{
 "layers": [
  {
   "currentVersion": 11.2,
   "cimVersion": "3.2.0",
   "id": 0,
   "name": "Night Sweeping Routes",
   "type": "Feature Layer",
   "description": "",
   "geometryType": "esriGeometryPolyline",
   "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": -100000,
    "mUnits": 10000
   },
   "copyrightText": "",
   "parentLayer": null,
   "subLayers": [],
   "minScale": 0,
   "maxScale": 0,
   "drawingInfo": {
    "renderer": {
     "type": "simple",
     "symbol": {
      "type": "esriSLS",
      "style": "esriSLSSolid",
      "color": [
       163,
       117,
       0,
       255
      ],
      "width": 1
     }
    },
    "scaleSymbols": false,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": false,
   "extent": {
    "xmin": 389874.8447000012,
    "ymin": 126297.70949999988,
    "xmax": 407538.6372999996,
    "ymax": 147168.36549999937,
    "spatialReference": {
     "wkid": 26985,
     "latestWkid": 26985,
     "xyTolerance": 0.001,
     "zTolerance": 2,
     "mTolerance": 0.001,
     "falseX": -36747100,
     "falseY": -29091500,
     "xyUnits": 1.2123691021292362E8,
     "falseZ": 0,
     "zUnits": 1,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "Route_Id_1",
   "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_Id_1",
     "type": "esriFieldTypeString",
     "alias": "Route_Id_1",
     "length": 50,
     "domain": null
    },
    {
     "name": "Route_Id",
     "type": "esriFieldTypeString",
     "alias": "Route_Id",
     "length": 50,
     "domain": null
    },
    {
     "name": "Shape_Leng",
     "type": "esriFieldTypeDouble",
     "alias": "Shape_Leng",
     "domain": null
    },
    {
     "name": "Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    },
    {
     "name": "Shape.STLength()",
     "type": "esriFieldTypeDouble",
     "alias": "Shape.STLength()",
     "domain": null
    }
   ],
   "geometryField": {
    "name": "Shape",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape"
   },
   "indexes": [
    {
     "name": "R365_pk",
     "fields": "OBJECTID_1",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "S251_idx",
     "fields": "Shape",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": false,
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 1000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": 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,
    "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": 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
  }
 ],
 "tables": [
  {
   "currentVersion": 11.2,
   "cimVersion": "3.2.0",
   "id": 1,
   "name": "Weigh Scale Transactions",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "site_code",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "transaction_id",
     "type": "esriFieldTypeOID",
     "alias": "transaction_id",
     "domain": null
    },
    {
     "name": "material_type_id",
     "type": "esriFieldTypeSmallInteger",
     "alias": "material_type_id",
     "domain": null
    },
    {
     "name": "transaction_num",
     "type": "esriFieldTypeInteger",
     "alias": "transaction_num",
     "domain": null
    },
    {
     "name": "site_code",
     "type": "esriFieldTypeString",
     "alias": "site_code",
     "length": 4,
     "domain": null
    },
    {
     "name": "rate",
     "type": "esriFieldTypeDouble",
     "alias": "rate",
     "domain": null
    },
    {
     "name": "tip_fee",
     "type": "esriFieldTypeDouble",
     "alias": "tip_fee",
     "domain": null
    },
    {
     "name": "tare_weight_lbs",
     "type": "esriFieldTypeInteger",
     "alias": "tare_weight_lbs",
     "domain": null
    },
    {
     "name": "gross_weight_lbs",
     "type": "esriFieldTypeInteger",
     "alias": "gross_weight_lbs",
     "domain": null
    },
    {
     "name": "net_weight_lbs",
     "type": "esriFieldTypeInteger",
     "alias": "net_weight_lbs",
     "domain": null
    },
    {
     "name": "company_id",
     "type": "esriFieldTypeInteger",
     "alias": "company_id",
     "domain": null
    },
    {
     "name": "truck_number",
     "type": "esriFieldTypeString",
     "alias": "truck_number",
     "length": 60000,
     "domain": null
    },
    {
     "name": "time_in",
     "type": "esriFieldTypeDate",
     "alias": "time_in",
     "length": 8,
     "domain": null
    },
    {
     "name": "time_out",
     "type": "esriFieldTypeDate",
     "alias": "time_out",
     "length": 8,
     "domain": null
    },
    {
     "name": "direction",
     "type": "esriFieldTypeString",
     "alias": "direction",
     "length": 1,
     "domain": null
    },
    {
     "name": "payment_type_id",
     "type": "esriFieldTypeSmallInteger",
     "alias": "payment_type_id",
     "domain": null
    },
    {
     "name": "vehicle_type_id",
     "type": "esriFieldTypeSmallInteger",
     "alias": "vehicle_type_id",
     "domain": null
    },
    {
     "name": "total_fee",
     "type": "esriFieldTypeDouble",
     "alias": "total_fee",
     "domain": null
    },
    {
     "name": "tendered",
     "type": "esriFieldTypeDouble",
     "alias": "tendered",
     "domain": null
    },
    {
     "name": "inserted_at",
     "type": "esriFieldTypeDate",
     "alias": "inserted_at",
     "length": 8,
     "domain": null
    },
    {
     "name": "updated_at",
     "type": "esriFieldTypeDate",
     "alias": "updated_at",
     "length": 8,
     "domain": null
    }
   ],
   "indexes": null,
   "subtypes": [],
   "relationships": [],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 1000,
   "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": false
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   }
  },
  {
   "currentVersion": 11.2,
   "cimVersion": "3.2.0",
   "id": 2,
   "name": "Trakster Time and Attendance",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "employee_number",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "id",
     "type": "esriFieldTypeInteger",
     "alias": "id",
     "domain": null
    },
    {
     "name": "daily_crew_id",
     "type": "esriFieldTypeInteger",
     "alias": "daily_crew_id",
     "domain": null
    },
    {
     "name": "employee_number",
     "type": "esriFieldTypeString",
     "alias": "employee_number",
     "length": 60000,
     "domain": null
    },
    {
     "name": "date",
     "type": "esriFieldTypeDate",
     "alias": "date",
     "length": 8,
     "domain": null
    },
    {
     "name": "department",
     "type": "esriFieldTypeString",
     "alias": "department",
     "length": 60000,
     "domain": null
    },
    {
     "name": "division",
     "type": "esriFieldTypeString",
     "alias": "division",
     "length": 60000,
     "domain": null
    },
    {
     "name": "section",
     "type": "esriFieldTypeString",
     "alias": "section",
     "length": 60000,
     "domain": null
    },
    {
     "name": "status",
     "type": "esriFieldTypeString",
     "alias": "status",
     "length": 60000,
     "domain": null
    },
    {
     "name": "hours",
     "type": "esriFieldTypeInteger",
     "alias": "hours",
     "domain": null
    },
    {
     "name": "total_hours",
     "type": "esriFieldTypeInteger",
     "alias": "total_hours",
     "domain": null
    },
    {
     "name": "business_unit",
     "type": "esriFieldTypeString",
     "alias": "business_unit",
     "length": 60000,
     "domain": null
    },
    {
     "name": "employee_status",
     "type": "esriFieldTypeString",
     "alias": "employee_status",
     "length": 60000,
     "domain": null
    },
    {
     "name": "activity",
     "type": "esriFieldTypeString",
     "alias": "activity",
     "length": 60000,
     "domain": null
    },
    {
     "name": "status_category",
     "type": "esriFieldTypeString",
     "alias": "status_category",
     "length": 60000,
     "domain": null
    },
    {
     "name": "computed_status",
     "type": "esriFieldTypeString",
     "alias": "computed_status",
     "length": 60000,
     "domain": null
    },
    {
     "name": "full_time_equivalent",
     "type": "esriFieldTypeSingle",
     "alias": "full_time_equivalent",
     "domain": null
    },
    {
     "name": "overtime_equivalent",
     "type": "esriFieldTypeSingle",
     "alias": "overtime_equivalent",
     "domain": null
    },
    {
     "name": "overtime_hours",
     "type": "esriFieldTypeInteger",
     "alias": "overtime_hours",
     "domain": null
    },
    {
     "name": "last_synced_from_trakster_at",
     "type": "esriFieldTypeDate",
     "alias": "last_synced_from_trakster_at",
     "length": 8,
     "domain": null
    },
    {
     "name": "ESRI_OID",
     "type": "esriFieldTypeOID",
     "alias": "ESRI_OID",
     "domain": null
    }
   ],
   "indexes": null,
   "subtypes": [],
   "relationships": [],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 1000,
   "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": false
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   }
  },
  {
   "currentVersion": 11.2,
   "cimVersion": "3.2.0",
   "id": 3,
   "name": "Crews",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "crew_type",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "id",
     "type": "esriFieldTypeOID",
     "alias": "id",
     "domain": null
    },
    {
     "name": "start_datetime",
     "type": "esriFieldTypeDate",
     "alias": "start_datetime",
     "length": 8,
     "domain": null
    },
    {
     "name": "end_datetime",
     "type": "esriFieldTypeDate",
     "alias": "end_datetime",
     "length": 8,
     "domain": null
    },
    {
     "name": "organization_id",
     "type": "esriFieldTypeSmallInteger",
     "alias": "organization_id",
     "domain": null
    },
    {
     "name": "crew_type",
     "type": "esriFieldTypeString",
     "alias": "crew_type",
     "length": 60000,
     "domain": null
    },
    {
     "name": "crew_subtype",
     "type": "esriFieldTypeString",
     "alias": "crew_subtype",
     "length": 60000,
     "domain": null
    },
    {
     "name": "source_app_id",
     "type": "esriFieldTypeSmallInteger",
     "alias": "source_app_id",
     "domain": null
    },
    {
     "name": "external_id",
     "type": "esriFieldTypeString",
     "alias": "external_id",
     "length": 60000,
     "domain": null
    },
    {
     "name": "inserted_at",
     "type": "esriFieldTypeDate",
     "alias": "inserted_at",
     "length": 8,
     "domain": null
    },
    {
     "name": "updated_at",
     "type": "esriFieldTypeDate",
     "alias": "updated_at",
     "length": 8,
     "domain": null
    },
    {
     "name": "department",
     "type": "esriFieldTypeString",
     "alias": "department",
     "length": 60000,
     "domain": null
    },
    {
     "name": "division",
     "type": "esriFieldTypeString",
     "alias": "division",
     "length": 60000,
     "domain": null
    },
    {
     "name": "section",
     "type": "esriFieldTypeString",
     "alias": "section",
     "length": 60000,
     "domain": null
    },
    {
     "name": "business_unit",
     "type": "esriFieldTypeString",
     "alias": "business_unit",
     "length": 60000,
     "domain": null
    },
    {
     "name": "activity",
     "type": "esriFieldTypeString",
     "alias": "activity",
     "length": 60000,
     "domain": null
    }
   ],
   "indexes": null,
   "subtypes": [],
   "relationships": [],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 1000,
   "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": false
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   }
  },
  {
   "currentVersion": 11.2,
   "cimVersion": "3.2.0",
   "id": 4,
   "name": "Crew People",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "title",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "id",
     "type": "esriFieldTypeOID",
     "alias": "id",
     "domain": null
    },
    {
     "name": "crew_id",
     "type": "esriFieldTypeInteger",
     "alias": "crew_id",
     "domain": null
    },
    {
     "name": "person_id",
     "type": "esriFieldTypeInteger",
     "alias": "person_id",
     "domain": null
    },
    {
     "name": "title",
     "type": "esriFieldTypeString",
     "alias": "title",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "status",
     "type": "esriFieldTypeString",
     "alias": "status",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "hours",
     "type": "esriFieldTypeInteger",
     "alias": "hours",
     "domain": null
    },
    {
     "name": "total_hours",
     "type": "esriFieldTypeInteger",
     "alias": "total_hours",
     "domain": null
    },
    {
     "name": "employee_status",
     "type": "esriFieldTypeString",
     "alias": "employee_status",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "status_category",
     "type": "esriFieldTypeString",
     "alias": "status_category",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "computed_status",
     "type": "esriFieldTypeString",
     "alias": "computed_status",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "full_time_equivalent",
     "type": "esriFieldTypeSingle",
     "alias": "full_time_equivalent",
     "domain": null
    },
    {
     "name": "overtime_equivalent",
     "type": "esriFieldTypeSingle",
     "alias": "overtime_equivalent",
     "domain": null
    },
    {
     "name": "overtime_hours",
     "type": "esriFieldTypeInteger",
     "alias": "overtime_hours",
     "domain": null
    },
    {
     "name": "last_synced_from_trakster_at",
     "type": "esriFieldTypeDate",
     "alias": "last_synced_from_trakster_at",
     "length": 8,
     "precision": 1,
     "domain": null
    },
    {
     "name": "employee_id",
     "type": "esriFieldTypeString",
     "alias": "employee_id",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "external_id",
     "type": "esriFieldTypeString",
     "alias": "external_id",
     "length": 1073741822,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "crew_people_pkey",
     "fields": "id",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 1000,
   "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": false
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   }
  }
 ]
}