{ "layers": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 7, "name": "DBO.DepartureBoilerplates", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 145, 125, 34, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2739891.891899999, "ymin": -2324756.7567999996, "xmax": 2739891.891899999, "ymax": -2324756.7567999996, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Month", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Movements", "type": "esriFieldTypeInteger", "alias": "Movements", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 255, "domain": null }, { "name": "Route", "type": "esriFieldTypeString", "alias": "Route", "length": 255, "domain": null }, { "name": "Exit_Type", "type": "esriFieldTypeString", "alias": "Exit_Type", "length": 255, "domain": null }, { "name": "Difference", "type": "esriFieldTypeInteger", "alias": "Difference", "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "DepartureAdmin1", "type": "esriFieldTypeString", "alias": "DepartureAdmin1", "length": 255, "domain": null }, { "name": "ArrivalAdmin1", "type": "esriFieldTypeString", "alias": "ArrivalAdmin1", "length": 255, "domain": null }, { "name": "DepartureCountry", "type": "esriFieldTypeString", "alias": "DepartureCountry", "length": 255, "domain": null }, { "name": "ArrivalCountry", "type": "esriFieldTypeString", "alias": "ArrivalCountry", "length": 255, "domain": null }, { "name": "month_id", "type": "esriFieldTypeSmallInteger", "alias": "month_id", "domain": null }, { "name": "Percent_Total", "type": "esriFieldTypeDouble", "alias": "Percent_Total", "domain": null }, { "name": "Percent_Total1", "type": "esriFieldTypeDouble", "alias": "Percent_Total1", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R99_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S56_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "c35dd976736245e2a3575995dd9c488b" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 6, "name": "DBO.DriversBoilerplates", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 137, 35, 85, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2731512.1400999986, "ymin": -2698864.5846000016, "xmax": 2731512.1400999986, "ymax": -2698864.5846000016, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Month", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Movements", "type": "esriFieldTypeInteger", "alias": "Movements", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 255, "domain": null }, { "name": "Route", "type": "esriFieldTypeString", "alias": "Route", "length": 255, "domain": null }, { "name": "Exit_Type", "type": "esriFieldTypeString", "alias": "Exit_Type", "length": 255, "domain": null }, { "name": "Difference", "type": "esriFieldTypeInteger", "alias": "Difference", "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "flow_type", "type": "esriFieldTypeString", "alias": "flow_type", "length": 200, "domain": null }, { "name": "month_id", "type": "esriFieldTypeSmallInteger", "alias": "month_id", "domain": null }, { "name": "Percent_Total", "type": "esriFieldTypeDouble", "alias": "Percent_Total", "domain": null }, { "name": "Percent_Total1", "type": "esriFieldTypeDouble", "alias": "Percent_Total1", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R98_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S55_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "c35dd976736245e2a3575995dd9c488b" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 4, "name": "DBO.NationalityBoilerplates", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 77, 31, 145, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3003575.1022999994, "ymin": -2557391.844300002, "xmax": 3003575.1022999994, "ymax": -2557391.844300002, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Month", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Movements", "type": "esriFieldTypeInteger", "alias": "Movements", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 255, "domain": null }, { "name": "Route", "type": "esriFieldTypeString", "alias": "Route", "length": 255, "domain": null }, { "name": "Exit_Type", "type": "esriFieldTypeString", "alias": "Exit_Type", "length": 255, "domain": null }, { "name": "Difference", "type": "esriFieldTypeInteger", "alias": "Difference", "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "nationality_country", "type": "esriFieldTypeString", "alias": "nationality_country", "length": 200, "domain": null }, { "name": "month_id", "type": "esriFieldTypeSmallInteger", "alias": "month_id", "domain": null }, { "name": "Percent_Total", "type": "esriFieldTypeDouble", "alias": "Percent_Total", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R97_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S54_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "c35dd976736245e2a3575995dd9c488b" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 3, "name": "DBO.Outgoing_Migration_Trend", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSNull", "color": [ 44, 142, 73, 0 ], "width": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3742137.9004000016, "ymin": 162070.6136999987, "xmax": 5598006.896000002, "ymax": 1937847.4356000014, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Month", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Movements", "type": "esriFieldTypeInteger", "alias": "Movements", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 255, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Route", "type": "esriFieldTypeString", "alias": "Route", "length": 255, "domain": null }, { "name": "Subroute", "type": "esriFieldTypeString", "alias": "Subroute", "length": 255, "domain": null }, { "name": "Arrow", "type": "esriFieldTypeString", "alias": "Arrow", "length": 255, "domain": null }, { "name": "Difference", "type": "esriFieldTypeInteger", "alias": "Difference", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "Percent_Total", "type": "esriFieldTypeDouble", "alias": "Percent_Total", "domain": null }, { "name": "month_id", "type": "esriFieldTypeSmallInteger", "alias": "month_id", "domain": null }, { "name": "Exit_Type", "type": "esriFieldTypeString", "alias": "Exit_Type", "length": 255, "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R84_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S41_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "hasM": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape.STLength()", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "c35dd976736245e2a3575995dd9c488b" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 0, "name": "DBO.Admin_0", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 0, 0, 0, 255 ], "size": 8, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": null } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2428385.2474000007, "ymin": -1318510.3099000007, "xmax": 6196785.024500001, "ymax": 3783546.425999999, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "CNTRY_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID_1", "type": "esriFieldTypeOID", "alias": "FID", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "ISO3_CODE", "type": "esriFieldTypeString", "alias": "ISO3_CODE", "length": 3, "domain": null }, { "name": "ISO2_CODE", "type": "esriFieldTypeString", "alias": "ISO2_CODE", "length": 2, "domain": null }, { "name": "CNTRY_NAME", "type": "esriFieldTypeString", "alias": "CNTRY_NAME", "length": 250, "domain": null }, { "name": "REGION", "type": "esriFieldTypeString", "alias": "REGION", "length": 50, "domain": null }, { "name": "UN_STATUS", "type": "esriFieldTypeString", "alias": "UN_STATUS", "length": 50, "domain": null }, { "name": "DISP_AREA", "type": "esriFieldTypeString", "alias": "DISP_AREA", "length": 5, "domain": null }, { "name": "ADM0_CODE", "type": "esriFieldTypeInteger", "alias": "ADM0_CODE", "domain": null }, { "name": "FIPS", "type": "esriFieldTypeString", "alias": "FIPS", "length": 5, "domain": null }, { "name": "Regional_O", "type": "esriFieldTypeString", "alias": "Regional_O", "length": 50, "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "CNTRY_NA_1", "type": "esriFieldTypeString", "alias": "CNTRY_NA_1", "length": 250, "domain": null }, { "name": "Continent", "type": "esriFieldTypeString", "alias": "Continent", "length": 50, "domain": null }, { "name": "Shape_STAr", "type": "esriFieldTypeDouble", "alias": "Shape_STAr", "domain": null }, { "name": "Shape_STLe", "type": "esriFieldTypeDouble", "alias": "Shape_STLe", "domain": null }, { "name": "Shape_Leng", "type": "esriFieldTypeDouble", "alias": "Shape_Leng", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R31_pk", "fields": "OBJECTID_1", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S18_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "c35dd976736245e2a3575995dd9c488b" } ], "tables": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 18, "name": "DBO.DBO_Drivers_xlsx", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Month", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 255, "domain": null }, { "name": "Year", "type": "esriFieldTypeDouble", "alias": "Year", "domain": null }, { "name": "Route", "type": "esriFieldTypeString", "alias": "Route", "length": 255, "domain": null }, { "name": "sub_route", "type": "esriFieldTypeString", "alias": "sub_route", "length": 255, "domain": null }, { "name": "FMR_Flow_Types", "type": "esriFieldTypeString", "alias": "FMR_Flow_Types", "length": 255, "domain": null }, { "name": "Total_Flow_Types", "type": "esriFieldTypeDouble", "alias": "Total_Flow_Types", "domain": null }, { "name": "Arrow", "type": "esriFieldTypeString", "alias": "Arrow", "length": 1073741822, "domain": null }, { "name": "Exit_Type", "type": "esriFieldTypeString", "alias": "Exit_Type", "length": 1073741822, "domain": null }, { "name": "Difference", "type": "esriFieldTypeInteger", "alias": "Difference", "domain": null } ], "indexes": [ { "name": "R41_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "PK_DBO_DRIVERS_XLSX", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "c35dd976736245e2a3575995dd9c488b" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 19, "name": "DBO.DBO_FMP_Location_xlsx", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FMP_Location_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 255, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Route", "type": "esriFieldTypeString", "alias": "Route", "length": 255, "domain": null }, { "name": "sub_route", "type": "esriFieldTypeString", "alias": "sub_route", "length": 255, "domain": null }, { "name": "FMP_Location_Name", "type": "esriFieldTypeString", "alias": "FMP_Location_Name", "length": 255, "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "Total_Nationalities", "type": "esriFieldTypeInteger", "alias": "Total_Nationalities", "domain": null }, { "name": "Exit_Type", "type": "esriFieldTypeString", "alias": "Exit_Type", "length": 1073741822, "domain": null }, { "name": "Arrow", "type": "esriFieldTypeString", "alias": "Arrow", "length": 50, "domain": null }, { "name": "Difference", "type": "esriFieldTypeInteger", "alias": "Difference", "domain": null }, { "name": "Month_", "type": "esriFieldTypeInteger", "alias": "Month_", "domain": null } ], "indexes": [ { "name": "R40_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "PK_DBO_FMP_LOCATION_XLSX", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "c35dd976736245e2a3575995dd9c488b" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 20, "name": "DBO.DBO_Movement_Trends_xlsx", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Month_", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null }, { "name": "Year", "type": "esriFieldTypeDouble", "alias": "Year", "domain": null }, { "name": "Month_ID", "type": "esriFieldTypeDouble", "alias": "Month_ID", "domain": null }, { "name": "Month_", "type": "esriFieldTypeString", "alias": "Month_", "length": 255, "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 255, "domain": null }, { "name": "Route", "type": "esriFieldTypeString", "alias": "Route", "length": 255, "domain": null }, { "name": "Month_Year", "type": "esriFieldTypeDate", "alias": "Month_Year", "length": 8, "domain": null }, { "name": "sub_route", "type": "esriFieldTypeString", "alias": "sub_route", "length": 255, "domain": null }, { "name": "Total_Nationalities", "type": "esriFieldTypeDouble", "alias": "Total_Nationalities", "domain": null }, { "name": "Exit_Type", "type": "esriFieldTypeString", "alias": "Exit_Type", "length": 1073741822, "domain": null }, { "name": "Arrow", "type": "esriFieldTypeString", "alias": "Arrow", "length": 50, "domain": null }, { "name": "Difference", "type": "esriFieldTypeInteger", "alias": "Difference", "domain": null } ], "indexes": [ { "name": "R39_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "PK_DBO_MOVEMENT_TRENDS_XLSX", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "c35dd976736245e2a3575995dd9c488b" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 21, "name": "DBO.DBO_Nationality_xlsx", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Nationality_Country_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 255, "domain": null }, { "name": "Year", "type": "esriFieldTypeDouble", "alias": "Year", "domain": null }, { "name": "Route", "type": "esriFieldTypeString", "alias": "Route", "length": 255, "domain": null }, { "name": "sub_route", "type": "esriFieldTypeString", "alias": "sub_route", "length": 255, "domain": null }, { "name": "Nationality_Country_Name", "type": "esriFieldTypeString", "alias": "Nationality_Country_Name", "length": 255, "domain": null }, { "name": "Total_Nationalities", "type": "esriFieldTypeDouble", "alias": "Total_Nationalities", "domain": null }, { "name": "Exit_Type", "type": "esriFieldTypeString", "alias": "Exit_Type", "length": 1073741822, "domain": null }, { "name": "Arrow", "type": "esriFieldTypeString", "alias": "Arrow", "length": 50, "domain": null }, { "name": "Difference", "type": "esriFieldTypeInteger", "alias": "Difference", "domain": null } ], "indexes": [ { "name": "R38_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "PK_DBO_NATIONALITY_XLSX", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "c35dd976736245e2a3575995dd9c488b" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 22, "name": "DBO.DBO_Sex_Age_xlsx", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Route", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null }, { "name": "Year", "type": "esriFieldTypeDouble", "alias": "Year", "domain": null }, { "name": "Route", "type": "esriFieldTypeString", "alias": "Route", "length": 255, "domain": null }, { "name": "sub_route", "type": "esriFieldTypeString", "alias": "sub_route", "length": 255, "domain": null }, { "name": "Values_", "type": "esriFieldTypeString", "alias": "Values_", "length": 255, "domain": null }, { "name": "Gender", "type": "esriFieldTypeString", "alias": "Gender", "length": 255, "domain": null }, { "name": "Population", "type": "esriFieldTypeDouble", "alias": "Population", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 255, "domain": null }, { "name": "Exit_Type", "type": "esriFieldTypeString", "alias": "Exit_Type", "length": 1073741822, "domain": null }, { "name": "Arrow", "type": "esriFieldTypeString", "alias": "Arrow", "length": 50, "domain": null }, { "name": "Difference", "type": "esriFieldTypeInteger", "alias": "Difference", "domain": null } ], "indexes": [ { "name": "R37_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "PK_DBO_SEX_AGE_XLSX", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "c35dd976736245e2a3575995dd9c488b" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 23, "name": "DBO.DBO_Vulnerabilities_xlsx", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Vulnerability_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 255, "domain": null }, { "name": "Year", "type": "esriFieldTypeDouble", "alias": "Year", "domain": null }, { "name": "Route", "type": "esriFieldTypeString", "alias": "Route", "length": 255, "domain": null }, { "name": "sub_route", "type": "esriFieldTypeString", "alias": "sub_route", "length": 255, "domain": null }, { "name": "Vulnerability_Name", "type": "esriFieldTypeString", "alias": "Vulnerability_Name", "length": 255, "domain": null }, { "name": "Total_Vulnerabilities", "type": "esriFieldTypeDouble", "alias": "Total_Vulnerabilities", "domain": null }, { "name": "Exit_Type", "type": "esriFieldTypeString", "alias": "Exit_Type", "length": 1073741822, "domain": null }, { "name": "Arrow", "type": "esriFieldTypeString", "alias": "Arrow", "length": 50, "domain": null }, { "name": "Difference", "type": "esriFieldTypeInteger", "alias": "Difference", "domain": null } ], "indexes": [ { "name": "R34_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "PK_DBO_VULNERABILITIES_XLSX", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "c35dd976736245e2a3575995dd9c488b" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 24, "name": "DBO.DBO_Transport_xlsx", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Month", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null }, { "name": "Year", "type": "esriFieldTypeDouble", "alias": "Year", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 255, "domain": null }, { "name": "Route", "type": "esriFieldTypeString", "alias": "Route", "length": 255, "domain": null }, { "name": "sub_route", "type": "esriFieldTypeString", "alias": "sub_route", "length": 255, "domain": null }, { "name": "Transport_Means", "type": "esriFieldTypeString", "alias": "Transport_Means", "length": 255, "domain": null }, { "name": "Total_Nationalities", "type": "esriFieldTypeDouble", "alias": "Total_Nationalities", "domain": null }, { "name": "Exit_Type", "type": "esriFieldTypeString", "alias": "Exit_Type", "length": 1073741822, "domain": null }, { "name": "Arrow", "type": "esriFieldTypeString", "alias": "Arrow", "length": 50, "domain": null }, { "name": "Difference", "type": "esriFieldTypeInteger", "alias": "Difference", "domain": null } ], "indexes": [ { "name": "R35_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "PK_DBO_TRANSPORT_XLSX", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "c35dd976736245e2a3575995dd9c488b" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 25, "name": "DBO.DBO_Total_Movements_xlsx", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Month", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 255, "domain": null }, { "name": "Year", "type": "esriFieldTypeDouble", "alias": "Year", "domain": null }, { "name": "Route", "type": "esriFieldTypeString", "alias": "Route", "length": 255, "domain": null }, { "name": "sub_route", "type": "esriFieldTypeString", "alias": "sub_route", "length": 255, "domain": null }, { "name": "Total_Nationalities", "type": "esriFieldTypeDouble", "alias": "Total_Nationalities", "domain": null }, { "name": "Exit_Type", "type": "esriFieldTypeString", "alias": "Exit_Type", "length": 1073741822, "domain": null }, { "name": "Arrow", "type": "esriFieldTypeString", "alias": "Arrow", "length": 50, "domain": null }, { "name": "Difference", "type": "esriFieldTypeInteger", "alias": "Difference", "domain": null }, { "name": "month_", "type": "esriFieldTypeInteger", "alias": "month_", "domain": null } ], "indexes": [ { "name": "R36_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "PK_DBO_TOTAL_MOVEMENTS_XLSX", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "c35dd976736245e2a3575995dd9c488b" } ] }