{
"layers": [
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 7,
"name": "Trash Route 2022",
"type": "Feature Layer",
"description": "Washington DC Trash Routes digitized by tracing street centerlines that form the boundaries of the various routes. The layer includes supercan routes (one collection per week) and the conventional area (two collections per week). The routes delineate the areas collected by a single crew on a single day either once or twice (in the conventional area) per week.",
"geometryType": "esriGeometryPolygon",
"sourceSpatialReference": {
"wkid": 26985,
"latestWkid": 26985,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -36747100,
"falseY": -29091500,
"xyUnits": 10000,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"copyrightText": "Department of Public Works, Solid Waste Management Administration",
"parentLayer": null,
"subLayers": [],
"minScale": 0,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [
252,
207,
210,
255
],
"outline": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
110,
110,
110,
255
],
"width": 0.7
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": false,
"extent": {
"xmin": 390090.3229999989,
"ymin": 127926.85000000149,
"xmax": 407848.3999999985,
"ymax": 147553.35300000012,
"spatialReference": {
"wkid": 26985,
"latestWkid": 26985,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -36747100,
"falseY": -29091500,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "OBJECTID",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "OBJECTID_1",
"type": "esriFieldTypeOID",
"alias": "OBJECTID_1",
"domain": null
},
{
"name": "OBJECTID",
"type": "esriFieldTypeInteger",
"alias": "OBJECTID",
"domain": null
},
{
"name": "ROUTE_NUMB",
"type": "esriFieldTypeInteger",
"alias": "ROUTE_NUMB",
"domain": null
},
{
"name": "DAY_",
"type": "esriFieldTypeString",
"alias": "DAY_",
"length": 20,
"domain": null
},
{
"name": "DAY_NUMBER",
"type": "esriFieldTypeInteger",
"alias": "DAY_NUMBER",
"domain": null
},
{
"name": "ROUTE_ID",
"type": "esriFieldTypeString",
"alias": "ROUTE_ID",
"length": 10,
"domain": null
},
{
"name": "CUST_CNT",
"type": "esriFieldTypeInteger",
"alias": "CUST_CNT",
"domain": null
},
{
"name": "TEST_ROUTE",
"type": "esriFieldTypeString",
"alias": "TEST_ROUTE",
"length": 8,
"domain": null
},
{
"name": "TEST_COUT_",
"type": "esriFieldTypeInteger",
"alias": "TEST_COUT_",
"domain": null
},
{
"name": "OLD_ROUTE_",
"type": "esriFieldTypeString",
"alias": "OLD_ROUTE_",
"length": 6,
"domain": null
},
{
"name": "NEW_TEST_C",
"type": "esriFieldTypeInteger",
"alias": "NEW_TEST_C",
"domain": null
},
{
"name": "PROP_COUNT",
"type": "esriFieldTypeInteger",
"alias": "PROP_COUNT",
"domain": null
},
{
"name": "AVE_TIME_O",
"type": "esriFieldTypeDouble",
"alias": "AVE_TIME_O",
"domain": null
},
{
"name": "AVE_TIME_1",
"type": "esriFieldTypeDouble",
"alias": "AVE_TIME_1",
"domain": null
},
{
"name": "CREWSB",
"type": "esriFieldTypeDouble",
"alias": "CREWSB",
"domain": null
},
{
"name": "CREWSA",
"type": "esriFieldTypeDouble",
"alias": "CREWSA",
"domain": null
},
{
"name": "AVE_LOADSB",
"type": "esriFieldTypeDouble",
"alias": "AVE_LOADSB",
"domain": null
},
{
"name": "AVE_LOADSA",
"type": "esriFieldTypeDouble",
"alias": "AVE_LOADSA",
"domain": null
},
{
"name": "ROUTE_DAYS",
"type": "esriFieldTypeInteger",
"alias": "ROUTE_DAYS",
"domain": null
},
{
"name": "ROUTE_DA_1",
"type": "esriFieldTypeInteger",
"alias": "ROUTE_DA_1",
"domain": null
},
{
"name": "INCR_DECR",
"type": "esriFieldTypeInteger",
"alias": "INCR_DECR",
"domain": null
},
{
"name": "INCR_DECR2",
"type": "esriFieldTypeString",
"alias": "INCR_DECR2",
"length": 50,
"domain": null
},
{
"name": "AVGTON_AUG",
"type": "esriFieldTypeDouble",
"alias": "AVGTON_AUG",
"domain": null
},
{
"name": "AVGTON_SEP",
"type": "esriFieldTypeDouble",
"alias": "AVGTON_SEP",
"domain": null
},
{
"name": "AVGTON_OCT",
"type": "esriFieldTypeDouble",
"alias": "AVGTON_OCT",
"domain": null
},
{
"name": "AVGTON_NOV",
"type": "esriFieldTypeDouble",
"alias": "AVGTON_NOV",
"domain": null
},
{
"name": "AVGTON_DEC",
"type": "esriFieldTypeDouble",
"alias": "AVGTON_DEC",
"domain": null
},
{
"name": "AVGTON_JAN",
"type": "esriFieldTypeDouble",
"alias": "AVGTON_JAN",
"domain": null
},
{
"name": "AVGTON_FEB",
"type": "esriFieldTypeDouble",
"alias": "AVGTON_FEB",
"domain": null
},
{
"name": "TRAKSTER_A",
"type": "esriFieldTypeString",
"alias": "TRAKSTER_A",
"length": 10,
"domain": null
},
{
"name": "SHAPE_Leng",
"type": "esriFieldTypeDouble",
"alias": "SHAPE_Leng",
"domain": null
},
{
"name": "Supervisor",
"type": "esriFieldTypeString",
"alias": "Supervisor",
"length": 50,
"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": "R455_pk",
"fields": "OBJECTID_1",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "S311_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,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsPagination": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsSqlFormat": false,
"supportsQueryAnalytic": true,
"supportsCurrentUserQueries": true
},
"supportsDatumTransformation": true,
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"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
},
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 6,
"name": "Recycling Route 2024",
"type": "Feature Layer",
"description": "Washington DC Recycling Routes digitized by tracing street centerlines that form the boundaries of the various routes. The layer includes recycling routes serviced by one collection per week. The routes delineate the areas collected by a single crew on a single day per week.",
"geometryType": "esriGeometryPolygon",
"sourceSpatialReference": {
"wkid": 26985,
"latestWkid": 26985,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -36747100,
"falseY": -29091500,
"xyUnits": 1.2123691021292362E8,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"copyrightText": "Digitized by Nkechi Whiteman ( )\nDepartment of Public Works, Solid Waste Management Administration",
"parentLayer": null,
"subLayers": [],
"minScale": 0,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [
252,
208,
186,
255
],
"outline": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
110,
110,
110,
255
],
"width": 0.7
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": false,
"extent": {
"xmin": 390090.2431000024,
"ymin": 127927.13599999994,
"xmax": 407848.3999999985,
"ymax": 147540.1367000006,
"spatialReference": {
"wkid": 26985,
"latestWkid": 26985,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -36747100,
"falseY": -29091500,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "SupervName",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "OBJECTID_1",
"type": "esriFieldTypeInteger",
"alias": "OBJECTID_1",
"domain": null
},
{
"name": "Ward",
"type": "esriFieldTypeString",
"alias": "Ward",
"length": 2,
"domain": null
},
{
"name": "Route",
"type": "esriFieldTypeString",
"alias": "Route",
"length": 8,
"domain": null
},
{
"name": "Route_Day",
"type": "esriFieldTypeString",
"alias": "Route_Day",
"length": 15,
"domain": null
},
{
"name": "Customer",
"type": "esriFieldTypeString",
"alias": "Customer",
"length": 20,
"domain": null
},
{
"name": "Old_Rte_Da",
"type": "esriFieldTypeString",
"alias": "Old_Rte_Da",
"length": 15,
"domain": null
},
{
"name": "Old_Rte_Ad",
"type": "esriFieldTypeString",
"alias": "Old_Rte_Ad",
"length": 8,
"domain": null
},
{
"name": "Test_Route",
"type": "esriFieldTypeString",
"alias": "Test_Route",
"length": 8,
"domain": null
},
{
"name": "Test_Cust_",
"type": "esriFieldTypeInteger",
"alias": "Test_Cust_",
"domain": null
},
{
"name": "OLD_ROUTE_",
"type": "esriFieldTypeString",
"alias": "OLD_ROUTE_",
"length": 8,
"domain": null
},
{
"name": "Shape_Le_1",
"type": "esriFieldTypeDouble",
"alias": "Shape_Le_1",
"domain": null
},
{
"name": "Ave_Time_O",
"type": "esriFieldTypeDouble",
"alias": "Ave_Time_O",
"domain": null
},
{
"name": "Ave_Time_1",
"type": "esriFieldTypeDouble",
"alias": "Ave_Time_1",
"domain": null
},
{
"name": "CrewB",
"type": "esriFieldTypeInteger",
"alias": "CrewB",
"domain": null
},
{
"name": "CrewA",
"type": "esriFieldTypeInteger",
"alias": "CrewA",
"domain": null
},
{
"name": "Ave_LoadsB",
"type": "esriFieldTypeDouble",
"alias": "Ave_LoadsB",
"domain": null
},
{
"name": "Ave_LoadsA",
"type": "esriFieldTypeDouble",
"alias": "Ave_LoadsA",
"domain": null
},
{
"name": "Route_Days",
"type": "esriFieldTypeInteger",
"alias": "Route_Days",
"domain": null
},
{
"name": "Route_Da_1",
"type": "esriFieldTypeInteger",
"alias": "Route_Da_1",
"domain": null
},
{
"name": "TonnesMost",
"type": "esriFieldTypeDouble",
"alias": "TonnesMost",
"domain": null
},
{
"name": "TonnesLeas",
"type": "esriFieldTypeDouble",
"alias": "TonnesLeas",
"domain": null
},
{
"name": "Ave_TimeO2",
"type": "esriFieldTypeDouble",
"alias": "Ave_TimeO2",
"domain": null
},
{
"name": "Ave_Load20",
"type": "esriFieldTypeDouble",
"alias": "Ave_Load20",
"domain": null
},
{
"name": "Ave_Tons20",
"type": "esriFieldTypeDouble",
"alias": "Ave_Tons20",
"domain": null
},
{
"name": "Crews_Rte",
"type": "esriFieldTypeDouble",
"alias": "Crews_Rte",
"domain": null
},
{
"name": "Incr_Decr",
"type": "esriFieldTypeInteger",
"alias": "Incr_Decr",
"domain": null
},
{
"name": "Count2017",
"type": "esriFieldTypeInteger",
"alias": "Count2017",
"domain": null
},
{
"name": "OBJECTID_7",
"type": "esriFieldTypeInteger",
"alias": "OBJECTID_7",
"domain": null
},
{
"name": "Symbology",
"type": "esriFieldTypeString",
"alias": "Symbology",
"length": 50,
"domain": null
},
{
"name": "OBJECTID_8",
"type": "esriFieldTypeInteger",
"alias": "OBJECTID_8",
"domain": null
},
{
"name": "OBJECTID_9",
"type": "esriFieldTypeInteger",
"alias": "OBJECTID_9",
"domain": null
},
{
"name": "OBJECTI_10",
"type": "esriFieldTypeInteger",
"alias": "OBJECTI_10",
"domain": null
},
{
"name": "Route_2018",
"type": "esriFieldTypeString",
"alias": "Route_2018",
"length": 30,
"domain": null
},
{
"name": "Shape_Le_2",
"type": "esriFieldTypeDouble",
"alias": "Shape_Le_2",
"domain": null
},
{
"name": "Shape_Le_3",
"type": "esriFieldTypeDouble",
"alias": "Shape_Le_3",
"domain": null
},
{
"name": "Shape_Le_4",
"type": "esriFieldTypeDouble",
"alias": "Shape_Le_4",
"domain": null
},
{
"name": "Shape_Le_5",
"type": "esriFieldTypeDouble",
"alias": "Shape_Le_5",
"domain": null
},
{
"name": "Shape_Le_6",
"type": "esriFieldTypeDouble",
"alias": "Shape_Le_6",
"domain": null
},
{
"name": "Altered",
"type": "esriFieldTypeInteger",
"alias": "Altered",
"domain": null
},
{
"name": "R2018_Coun",
"type": "esriFieldTypeInteger",
"alias": "R2018_Coun",
"domain": null
},
{
"name": "Shape_Le_7",
"type": "esriFieldTypeDouble",
"alias": "Shape_Le_7",
"domain": null
},
{
"name": "Shape_Le_8",
"type": "esriFieldTypeDouble",
"alias": "Shape_Le_8",
"domain": null
},
{
"name": "Shape_Le_9",
"type": "esriFieldTypeDouble",
"alias": "Shape_Le_9",
"domain": null
},
{
"name": "TraksterRt",
"type": "esriFieldTypeString",
"alias": "TraksterRt",
"length": 10,
"domain": null
},
{
"name": "dpwgdb.DPWLOADER.SWCD_RecyclingRoute2024.Area",
"type": "esriFieldTypeInteger",
"alias": "dpwgdb.DPWLOADER.SWCD_RecyclingRoute2024.Area",
"domain": null
},
{
"name": "Route_2019",
"type": "esriFieldTypeString",
"alias": "Route_2019",
"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": "SupervName",
"type": "esriFieldTypeString",
"alias": "SupervName",
"length": 50,
"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": "R492_pk",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "S338_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,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsPagination": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsSqlFormat": false,
"supportsQueryAnalytic": true,
"supportsCurrentUserQueries": true
},
"supportsDatumTransformation": true,
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"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
},
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 0,
"name": "Recycling Route Boundary",
"type": "Feature Layer",
"description": "Washington DC Recycling Routes digitized by tracing street centerlines that form the boundaries of the various routes. The layer includes recycling routes serviced by one collection per week. The routes delineate the areas collected by a single crew on a single day per week.",
"geometryType": "esriGeometryPolygon",
"sourceSpatialReference": {
"wkid": 26985,
"latestWkid": 26985,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -36747100,
"falseY": -29091500,
"xyUnits": 1.2123691021292362E8,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"copyrightText": "Digitized by Nkechi Whiteman ( )\nDepartment of Public Works, Solid Waste Management Administration",
"parentLayer": null,
"subLayers": [],
"minScale": 0,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [
245,
252,
201,
255
],
"outline": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
110,
110,
110,
255
],
"width": 0.7
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": false,
"extent": {
"xmin": 390090.2431000024,
"ymin": 127927.13599999994,
"xmax": 407848.3999999985,
"ymax": 147540.1367000006,
"spatialReference": {
"wkid": 26985,
"latestWkid": 26985,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -36747100,
"falseY": -29091500,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "SupervName",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "OBJECTID_1",
"type": "esriFieldTypeInteger",
"alias": "OBJECTID_1",
"domain": null
},
{
"name": "Ward",
"type": "esriFieldTypeString",
"alias": "Ward",
"length": 2,
"domain": null
},
{
"name": "Route",
"type": "esriFieldTypeString",
"alias": "Route",
"length": 8,
"domain": null
},
{
"name": "Route_Day",
"type": "esriFieldTypeString",
"alias": "Route_Day",
"length": 15,
"domain": null
},
{
"name": "Customer",
"type": "esriFieldTypeString",
"alias": "Customer",
"length": 20,
"domain": null
},
{
"name": "Old_Rte_Da",
"type": "esriFieldTypeString",
"alias": "Old_Rte_Da",
"length": 15,
"domain": null
},
{
"name": "Old_Rte_Ad",
"type": "esriFieldTypeString",
"alias": "Old_Rte_Ad",
"length": 8,
"domain": null
},
{
"name": "Test_Route",
"type": "esriFieldTypeString",
"alias": "Test_Route",
"length": 8,
"domain": null
},
{
"name": "Test_Cust_",
"type": "esriFieldTypeInteger",
"alias": "Test_Cust_",
"domain": null
},
{
"name": "OLD_ROUTE_",
"type": "esriFieldTypeString",
"alias": "OLD_ROUTE_",
"length": 8,
"domain": null
},
{
"name": "Shape_Le_1",
"type": "esriFieldTypeDouble",
"alias": "Shape_Le_1",
"domain": null
},
{
"name": "Ave_Time_O",
"type": "esriFieldTypeDouble",
"alias": "Ave_Time_O",
"domain": null
},
{
"name": "Ave_Time_1",
"type": "esriFieldTypeDouble",
"alias": "Ave_Time_1",
"domain": null
},
{
"name": "CrewB",
"type": "esriFieldTypeInteger",
"alias": "CrewB",
"domain": null
},
{
"name": "CrewA",
"type": "esriFieldTypeInteger",
"alias": "CrewA",
"domain": null
},
{
"name": "Ave_LoadsB",
"type": "esriFieldTypeDouble",
"alias": "Ave_LoadsB",
"domain": null
},
{
"name": "Ave_LoadsA",
"type": "esriFieldTypeDouble",
"alias": "Ave_LoadsA",
"domain": null
},
{
"name": "Route_Days",
"type": "esriFieldTypeInteger",
"alias": "Route_Days",
"domain": null
},
{
"name": "Route_Da_1",
"type": "esriFieldTypeInteger",
"alias": "Route_Da_1",
"domain": null
},
{
"name": "TonnesMost",
"type": "esriFieldTypeDouble",
"alias": "TonnesMost",
"domain": null
},
{
"name": "TonnesLeas",
"type": "esriFieldTypeDouble",
"alias": "TonnesLeas",
"domain": null
},
{
"name": "Ave_TimeO2",
"type": "esriFieldTypeDouble",
"alias": "Ave_TimeO2",
"domain": null
},
{
"name": "Ave_Load20",
"type": "esriFieldTypeDouble",
"alias": "Ave_Load20",
"domain": null
},
{
"name": "Ave_Tons20",
"type": "esriFieldTypeDouble",
"alias": "Ave_Tons20",
"domain": null
},
{
"name": "Crews_Rte",
"type": "esriFieldTypeDouble",
"alias": "Crews_Rte",
"domain": null
},
{
"name": "Incr_Decr",
"type": "esriFieldTypeInteger",
"alias": "Incr_Decr",
"domain": null
},
{
"name": "Count2017",
"type": "esriFieldTypeInteger",
"alias": "Count2017",
"domain": null
},
{
"name": "OBJECTID_7",
"type": "esriFieldTypeInteger",
"alias": "OBJECTID_7",
"domain": null
},
{
"name": "Symbology",
"type": "esriFieldTypeString",
"alias": "Symbology",
"length": 50,
"domain": null
},
{
"name": "OBJECTID_8",
"type": "esriFieldTypeInteger",
"alias": "OBJECTID_8",
"domain": null
},
{
"name": "OBJECTID_9",
"type": "esriFieldTypeInteger",
"alias": "OBJECTID_9",
"domain": null
},
{
"name": "OBJECTI_10",
"type": "esriFieldTypeInteger",
"alias": "OBJECTI_10",
"domain": null
},
{
"name": "Route_2018",
"type": "esriFieldTypeString",
"alias": "Route_2018",
"length": 30,
"domain": null
},
{
"name": "Shape_Le_2",
"type": "esriFieldTypeDouble",
"alias": "Shape_Le_2",
"domain": null
},
{
"name": "Shape_Le_3",
"type": "esriFieldTypeDouble",
"alias": "Shape_Le_3",
"domain": null
},
{
"name": "Shape_Le_4",
"type": "esriFieldTypeDouble",
"alias": "Shape_Le_4",
"domain": null
},
{
"name": "Shape_Le_5",
"type": "esriFieldTypeDouble",
"alias": "Shape_Le_5",
"domain": null
},
{
"name": "Shape_Le_6",
"type": "esriFieldTypeDouble",
"alias": "Shape_Le_6",
"domain": null
},
{
"name": "Altered",
"type": "esriFieldTypeInteger",
"alias": "Altered",
"domain": null
},
{
"name": "R2018_Coun",
"type": "esriFieldTypeInteger",
"alias": "R2018_Coun",
"domain": null
},
{
"name": "Shape_Le_7",
"type": "esriFieldTypeDouble",
"alias": "Shape_Le_7",
"domain": null
},
{
"name": "Shape_Le_8",
"type": "esriFieldTypeDouble",
"alias": "Shape_Le_8",
"domain": null
},
{
"name": "Shape_Le_9",
"type": "esriFieldTypeDouble",
"alias": "Shape_Le_9",
"domain": null
},
{
"name": "TraksterRt",
"type": "esriFieldTypeString",
"alias": "TraksterRt",
"length": 10,
"domain": null
},
{
"name": "dpwgdb.DPWLOADER.RecyclingRouteBndyPly.Area",
"type": "esriFieldTypeInteger",
"alias": "dpwgdb.DPWLOADER.RecyclingRouteBndyPly.Area",
"domain": null
},
{
"name": "Route_2019",
"type": "esriFieldTypeString",
"alias": "Route_2019",
"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": "SupervName",
"type": "esriFieldTypeString",
"alias": "SupervName",
"length": 50,
"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": "R456_pk",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "S312_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,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsPagination": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsSqlFormat": false,
"supportsQueryAnalytic": true,
"supportsCurrentUserQueries": true
},
"supportsDatumTransformation": true,
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"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
},
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 1,
"name": "Trash Route",
"type": "Feature Layer",
"description": "Washington DC Trash Routes digitized by tracing street centerlines that form the boundaries of the various routes. The layer includes supercan routes (one collection per week) and the conventional area (two collections per week). The routes delineate the areas collected by a single crew on a single day either once or twice (in the conventional area) per week.",
"geometryType": "esriGeometryPolygon",
"sourceSpatialReference": {
"wkid": 26985,
"latestWkid": 26985,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -36747100,
"falseY": -29091500,
"xyUnits": 10000,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"copyrightText": "Department of Public Works, Solid Waste Management Administration",
"parentLayer": null,
"subLayers": [],
"minScale": 0,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [
179,
252,
198,
255
],
"outline": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
110,
110,
110,
255
],
"width": 0.7
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": false,
"extent": {
"xmin": 390090.3229999989,
"ymin": 127926.85000000149,
"xmax": 407848.3999999985,
"ymax": 147553.35300000012,
"spatialReference": {
"wkid": 26985,
"latestWkid": 26985,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -36747100,
"falseY": -29091500,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "DAY_",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "OBJECTID_1",
"type": "esriFieldTypeOID",
"alias": "OBJECTID_1",
"domain": null
},
{
"name": "OBJECTID",
"type": "esriFieldTypeInteger",
"alias": "OBJECTID",
"domain": null
},
{
"name": "ROUTE_NUMB",
"type": "esriFieldTypeInteger",
"alias": "ROUTE_NUMB",
"domain": null
},
{
"name": "DAY_",
"type": "esriFieldTypeString",
"alias": "DAY_",
"length": 20,
"domain": null
},
{
"name": "DAY_NUMBER",
"type": "esriFieldTypeInteger",
"alias": "DAY_NUMBER",
"domain": null
},
{
"name": "ROUTE_ID",
"type": "esriFieldTypeString",
"alias": "ROUTE_ID",
"length": 10,
"domain": null
},
{
"name": "CUST_CNT",
"type": "esriFieldTypeInteger",
"alias": "CUST_CNT",
"domain": null
},
{
"name": "TEST_ROUTE",
"type": "esriFieldTypeString",
"alias": "TEST_ROUTE",
"length": 8,
"domain": null
},
{
"name": "TEST_COUT_",
"type": "esriFieldTypeInteger",
"alias": "TEST_COUT_",
"domain": null
},
{
"name": "OLD_ROUTE_",
"type": "esriFieldTypeString",
"alias": "OLD_ROUTE_",
"length": 6,
"domain": null
},
{
"name": "NEW_TEST_C",
"type": "esriFieldTypeInteger",
"alias": "NEW_TEST_C",
"domain": null
},
{
"name": "PROP_COUNT",
"type": "esriFieldTypeInteger",
"alias": "PROP_COUNT",
"domain": null
},
{
"name": "AVE_TIME_O",
"type": "esriFieldTypeDouble",
"alias": "AVE_TIME_O",
"domain": null
},
{
"name": "AVE_TIME_1",
"type": "esriFieldTypeDouble",
"alias": "AVE_TIME_1",
"domain": null
},
{
"name": "CREWSB",
"type": "esriFieldTypeDouble",
"alias": "CREWSB",
"domain": null
},
{
"name": "CREWSA",
"type": "esriFieldTypeDouble",
"alias": "CREWSA",
"domain": null
},
{
"name": "AVE_LOADSB",
"type": "esriFieldTypeDouble",
"alias": "AVE_LOADSB",
"domain": null
},
{
"name": "AVE_LOADSA",
"type": "esriFieldTypeDouble",
"alias": "AVE_LOADSA",
"domain": null
},
{
"name": "ROUTE_DAYS",
"type": "esriFieldTypeInteger",
"alias": "ROUTE_DAYS",
"domain": null
},
{
"name": "ROUTE_DA_1",
"type": "esriFieldTypeInteger",
"alias": "ROUTE_DA_1",
"domain": null
},
{
"name": "INCR_DECR",
"type": "esriFieldTypeInteger",
"alias": "INCR_DECR",
"domain": null
},
{
"name": "INCR_DECR2",
"type": "esriFieldTypeString",
"alias": "INCR_DECR2",
"length": 50,
"domain": null
},
{
"name": "AVGTON_AUG",
"type": "esriFieldTypeDouble",
"alias": "AVGTON_AUG",
"domain": null
},
{
"name": "AVGTON_SEP",
"type": "esriFieldTypeDouble",
"alias": "AVGTON_SEP",
"domain": null
},
{
"name": "AVGTON_OCT",
"type": "esriFieldTypeDouble",
"alias": "AVGTON_OCT",
"domain": null
},
{
"name": "AVGTON_NOV",
"type": "esriFieldTypeDouble",
"alias": "AVGTON_NOV",
"domain": null
},
{
"name": "AVGTON_DEC",
"type": "esriFieldTypeDouble",
"alias": "AVGTON_DEC",
"domain": null
},
{
"name": "AVGTON_JAN",
"type": "esriFieldTypeDouble",
"alias": "AVGTON_JAN",
"domain": null
},
{
"name": "AVGTON_FEB",
"type": "esriFieldTypeDouble",
"alias": "AVGTON_FEB",
"domain": null
},
{
"name": "TRAKSTER_A",
"type": "esriFieldTypeString",
"alias": "TRAKSTER_A",
"length": 10,
"domain": null
},
{
"name": "SHAPE_Leng",
"type": "esriFieldTypeDouble",
"alias": "SHAPE_Leng",
"domain": null
},
{
"name": "Supervisor",
"type": "esriFieldTypeString",
"alias": "Supervisor",
"length": 50,
"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": "R455_pk",
"fields": "OBJECTID_1",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "S311_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,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsPagination": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsSqlFormat": false,
"supportsQueryAnalytic": true,
"supportsCurrentUserQueries": true
},
"supportsDatumTransformation": true,
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"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
},
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 10,
"name": "OT_Detail_Layer",
"type": "Feature Layer",
"description": "OT_Detail_Layer",
"geometryType": "esriGeometryPoint",
"sourceSpatialReference": {
"wkid": 26985,
"latestWkid": 26985,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -36747100,
"falseY": -29091500,
"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": "esriSMS",
"style": "esriSMSCircle",
"color": [
112,
29,
140,
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": false,
"extent": {
"xmin": 398739.5041,
"ymin": 132346.5287,
"xmax": 401583.2687,
"ymax": 142158.696,
"spatialReference": {
"wkid": 26985,
"latestWkid": 26985,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -36747100,
"falseY": -29091500,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "DivName",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "DivName",
"type": "esriFieldTypeString",
"alias": "DivName",
"length": 25,
"domain": null
},
{
"name": "DailyCrewID",
"type": "esriFieldTypeOID",
"alias": "DailyCrewID",
"domain": null
},
{
"name": "Date",
"type": "esriFieldTypeDate",
"alias": "Date",
"length": 8,
"precision": 1,
"domain": null
},
{
"name": "RouteNo",
"type": "esriFieldTypeString",
"alias": "RouteNo",
"length": 20,
"domain": null
},
{
"name": "ActivityName",
"type": "esriFieldTypeString",
"alias": "ActivityName",
"length": 25,
"domain": null
},
{
"name": "OTHrsSum",
"type": "esriFieldTypeDouble",
"alias": "OTHrsSum",
"domain": null
},
{
"name": "OTReason_DisplayName",
"type": "esriFieldTypeString",
"alias": "OTReason_DisplayName",
"length": 25,
"domain": null
},
{
"name": "EstCost",
"type": "esriFieldTypeDouble",
"alias": "EstCost",
"domain": null
},
{
"name": "XCoord",
"type": "esriFieldTypeDouble",
"alias": "XCoord",
"domain": null
},
{
"name": "YCoord",
"type": "esriFieldTypeDouble",
"alias": "YCoord",
"domain": null
},
{
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape",
"domain": null
}
],
"geometryField": {
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
"indexes": [
{
"name": "Shape",
"fields": "Shape",
"isAscending": true,
"isUnique": false,
"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,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsPagination": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsSqlFormat": false,
"supportsQueryAnalytic": true,
"supportsCurrentUserQueries": true
},
"supportsDatumTransformation": true,
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": true,
"archivingInfo": {
"supportsQueryWithHistoricMoment": true,
"startArchivingMoment": -1
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
}
],
"tables": [
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 2,
"name": "Mid_Shift_Employee",
"type": "Table",
"description": null,
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "EmpName",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "Date",
"type": "esriFieldTypeDate",
"alias": "Date",
"length": 8,
"domain": null
},
{
"name": "EmpID",
"type": "esriFieldTypeOID",
"alias": "EmpID",
"domain": null
},
{
"name": "EmpName",
"type": "esriFieldTypeString",
"alias": "EmpName",
"length": 105,
"domain": null
},
{
"name": "RouteNo",
"type": "esriFieldTypeString",
"alias": "RouteNo",
"length": 20,
"domain": null
},
{
"name": "ActivityName",
"type": "esriFieldTypeString",
"alias": "ActivityName",
"length": 25,
"domain": null
},
{
"name": "EmpStatusName",
"type": "esriFieldTypeString",
"alias": "EmpStatusName",
"length": 25,
"domain": null
},
{
"name": "Hours",
"type": "esriFieldTypeDouble",
"alias": "Hours",
"domain": null
}
],
"indexes": null,
"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,
"supportsCurrentUserQueries": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
}
},
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 3,
"name": "Mid_Shift_Tonnage",
"type": "Table",
"description": null,
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "RteStatusName",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "Date",
"type": "esriFieldTypeDate",
"alias": "Date",
"length": 8,
"domain": null
},
{
"name": "RouteID",
"type": "esriFieldTypeOID",
"alias": "RouteID",
"domain": null
},
{
"name": "RouteNo",
"type": "esriFieldTypeString",
"alias": "RouteNo",
"length": 20,
"domain": null
},
{
"name": "ActivityDesc",
"type": "esriFieldTypeString",
"alias": "ActivityDesc",
"length": 25,
"domain": null
},
{
"name": "RteStatusName",
"type": "esriFieldTypeString",
"alias": "RteStatusName",
"length": 25,
"domain": null
},
{
"name": "Tons",
"type": "esriFieldTypeDouble",
"alias": "Tons",
"domain": null
}
],
"indexes": null,
"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,
"supportsCurrentUserQueries": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
}
},
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 4,
"name": "Mid_Shift_Assigned_Routes",
"type": "Table",
"description": null,
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "RouteName1",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "Date",
"type": "esriFieldTypeDate",
"alias": "Date",
"length": 8,
"domain": null
},
{
"name": "RouteID",
"type": "esriFieldTypeOID",
"alias": "RouteID",
"domain": null
},
{
"name": "RouteName1",
"type": "esriFieldTypeString",
"alias": "RouteName1",
"length": 20,
"domain": null
},
{
"name": "ActivityName",
"type": "esriFieldTypeString",
"alias": "ActivityName",
"length": 25,
"domain": null
},
{
"name": "NoEmp",
"type": "esriFieldTypeInteger",
"alias": "NoEmp",
"domain": null
}
],
"indexes": null,
"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,
"supportsCurrentUserQueries": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
}
},
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 5,
"name": "SWCD OT Comparison After Jan 23",
"type": "Table",
"description": null,
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "EmpName",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "ESRIID",
"type": "esriFieldTypeDouble",
"alias": "ESRIID",
"domain": null
},
{
"name": "EmpDate",
"type": "esriFieldTypeDate",
"alias": "EmpDate",
"length": 8,
"domain": null
},
{
"name": "EmpName",
"type": "esriFieldTypeString",
"alias": "EmpName",
"length": 105,
"domain": null
},
{
"name": "RouteNo",
"type": "esriFieldTypeString",
"alias": "RouteNo",
"length": 20,
"domain": null
},
{
"name": "ActivityName",
"type": "esriFieldTypeString",
"alias": "ActivityName",
"length": 25,
"domain": null
},
{
"name": "EmpStatusName",
"type": "esriFieldTypeString",
"alias": "EmpStatusName",
"length": 25,
"domain": null
},
{
"name": "EmpHours",
"type": "esriFieldTypeDouble",
"alias": "EmpHours",
"domain": null
},
{
"name": "OTHrsSum",
"type": "esriFieldTypeDouble",
"alias": "OTHrsSum",
"domain": null
},
{
"name": "EstCost",
"type": "esriFieldTypeDouble",
"alias": "EstCost",
"domain": null
},
{
"name": "OTReason_DisplayName",
"type": "esriFieldTypeString",
"alias": "OTReason_DisplayName",
"length": 25,
"domain": null
},
{
"name": "ESRI_OID",
"type": "esriFieldTypeOID",
"alias": "ESRI_OID",
"domain": null
}
],
"indexes": null,
"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,
"supportsCurrentUserQueries": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
}
},
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 8,
"name": "CY 2023 2024 SWMA OT",
"type": "Table",
"description": null,
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "EmpName",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "ESRIID",
"type": "esriFieldTypeDouble",
"alias": "ESRIID",
"domain": null
},
{
"name": "DailyCrewID",
"type": "esriFieldTypeOID",
"alias": "DailyCrewID",
"domain": null
},
{
"name": "Date",
"type": "esriFieldTypeDate",
"alias": "Date",
"length": 8,
"domain": null
},
{
"name": "EmpName",
"type": "esriFieldTypeString",
"alias": "EmpName",
"length": 105,
"domain": null
},
{
"name": "RouteNo",
"type": "esriFieldTypeString",
"alias": "RouteNo",
"length": 20,
"domain": null
},
{
"name": "ActivityName",
"type": "esriFieldTypeString",
"alias": "ActivityName",
"length": 25,
"domain": null
},
{
"name": "EmpStatusName",
"type": "esriFieldTypeString",
"alias": "EmpStatusName",
"length": 25,
"domain": null
},
{
"name": "Hours",
"type": "esriFieldTypeDouble",
"alias": "Hours",
"domain": null
},
{
"name": "OTHrsSum",
"type": "esriFieldTypeDouble",
"alias": "OTHrsSum",
"domain": null
},
{
"name": "EstCost",
"type": "esriFieldTypeDouble",
"alias": "EstCost",
"domain": null
},
{
"name": "DivName",
"type": "esriFieldTypeString",
"alias": "DivName",
"length": 25,
"domain": null
},
{
"name": "OTReason_DisplayName",
"type": "esriFieldTypeString",
"alias": "OTReason_DisplayName",
"length": 25,
"domain": null
}
],
"indexes": null,
"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,
"supportsCurrentUserQueries": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
}
},
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 9,
"name": "OT Detail ",
"type": "Table",
"description": null,
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "DivName",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "DivName",
"type": "esriFieldTypeString",
"alias": "DivName",
"length": 25,
"domain": null
},
{
"name": "DailyCrewID",
"type": "esriFieldTypeOID",
"alias": "DailyCrewID",
"domain": null
},
{
"name": "Date",
"type": "esriFieldTypeDate",
"alias": "Date",
"length": 8,
"domain": null
},
{
"name": "RouteNo",
"type": "esriFieldTypeString",
"alias": "RouteNo",
"length": 20,
"domain": null
},
{
"name": "ActivityName",
"type": "esriFieldTypeString",
"alias": "ActivityName",
"length": 25,
"domain": null
},
{
"name": "OTHrsSum",
"type": "esriFieldTypeDouble",
"alias": "OTHrsSum",
"domain": null
},
{
"name": "OTReason_DisplayName",
"type": "esriFieldTypeString",
"alias": "OTReason_DisplayName",
"length": 25,
"domain": null
},
{
"name": "EstCost",
"type": "esriFieldTypeDouble",
"alias": "EstCost",
"domain": null
},
{
"name": "XCoord",
"type": "esriFieldTypeDouble",
"alias": "XCoord",
"domain": null
},
{
"name": "YCoord",
"type": "esriFieldTypeDouble",
"alias": "YCoord",
"domain": null
}
],
"indexes": null,
"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,
"supportsCurrentUserQueries": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
}
}
]
}