{
 "layers": [
  {
   "currentVersion": 11.2,
   "cimVersion": "3.2.0",
   "id": 0,
   "name": "DC Boundary",
   "type": "Feature Layer",
   "description": "",
   "geometryType": "esriGeometryPolygon",
   "sourceSpatialReference": {
    "wkid": 26985,
    "latestWkid": 26985,
    "xyTolerance": 0.002,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -36747100,
    "falseY": -29091500,
    "xyUnits": 1000,
    "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": "esriSFS",
      "style": "esriSFSSolid",
      "color": [
       252,
       237,
       202,
       255
      ],
      "outline": {
       "type": "esriSLS",
       "style": "esriSLSSolid",
       "color": [
        110,
        110,
        110,
        255
       ],
       "width": 0.4
      }
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": false,
   "extent": {
    "xmin": 389612.306999996,
    "ymin": 124868.954999998,
    "xmax": 407880.11999999697,
    "ymax": 147558.136999998,
    "spatialReference": {
     "wkid": 26985,
     "latestWkid": 26985,
     "xyTolerance": 0.001,
     "zTolerance": 2,
     "mTolerance": 2,
     "falseX": -36747100,
     "falseY": -29091500,
     "xyUnits": 1.2123691021292362E8,
     "falseZ": 0,
     "zUnits": 1,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "CITY_NAME",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "CITY_FIPS",
     "type": "esriFieldTypeDouble",
     "alias": "CITY_FIPS",
     "domain": null
    },
    {
     "name": "CITY_NAME",
     "type": "esriFieldTypeString",
     "alias": "CITY_NAME",
     "length": 25,
     "domain": null
    },
    {
     "name": "STATE_FIPS",
     "type": "esriFieldTypeDouble",
     "alias": "STATE_FIPS",
     "domain": null
    },
    {
     "name": "STATE_NAME",
     "type": "esriFieldTypeString",
     "alias": "STATE_NAME",
     "length": 20,
     "domain": null
    },
    {
     "name": "STATE_CITY",
     "type": "esriFieldTypeDouble",
     "alias": "STATE_CITY",
     "domain": null
    },
    {
     "name": "CAPITAL",
     "type": "esriFieldTypeString",
     "alias": "CAPITAL",
     "length": 1,
     "domain": null
    },
    {
     "name": "WEB_URL",
     "type": "esriFieldTypeString",
     "alias": "WEB_URL",
     "length": 50,
     "domain": null
    },
    {
     "name": "AREAKM",
     "type": "esriFieldTypeDouble",
     "alias": "AREAKM",
     "domain": null
    },
    {
     "name": "AREAMILES",
     "type": "esriFieldTypeDouble",
     "alias": "AREAMILES",
     "domain": null
    },
    {
     "name": "SHAPE",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    },
    {
     "name": "SHAPE.AREA",
     "type": "esriFieldTypeDouble",
     "alias": "SHAPE.AREA",
     "domain": null
    },
    {
     "name": "SHAPE.LEN",
     "type": "esriFieldTypeDouble",
     "alias": "SHAPE.LEN",
     "domain": null
    },
    {
     "name": "SE_ANNO_CAD_DATA",
     "type": "esriFieldTypeBlob",
     "alias": "SE_ANNO_CAD_DATA",
     "domain": null
    },
    {
     "name": "GIS_ID",
     "type": "esriFieldTypeString",
     "alias": "GIS_ID",
     "length": 50,
     "domain": null
    },
    {
     "name": "GLOBALID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GLOBALID",
     "length": 38,
     "domain": null
    },
    {
     "name": "CREATOR",
     "type": "esriFieldTypeString",
     "alias": "CREATOR",
     "length": 255,
     "domain": null
    },
    {
     "name": "CREATED",
     "type": "esriFieldTypeDate",
     "alias": "CREATED",
     "length": 8,
     "domain": null
    },
    {
     "name": "EDITOR",
     "type": "esriFieldTypeString",
     "alias": "EDITOR",
     "length": 255,
     "domain": null
    },
    {
     "name": "EDITED",
     "type": "esriFieldTypeDate",
     "alias": "EDITED",
     "length": 8,
     "domain": null
    }
   ],
   "geometryField": {
    "name": "SHAPE",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape"
   },
   "indexes": [
    {
     "name": "R1026_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "UUID_1026",
     "fields": "GLOBALID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "A626_IX1",
     "fields": "SHAPE",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": false,
   "capabilities": "Data,Map,Query",
   "maxRecordCount": 1000,
   "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": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasGeometryProperties": true,
   "geometryProperties": {
    "shapeAreaFieldName": "SHAPE.AREA",
    "shapeLengthFieldName": "SHAPE.LEN",
    "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": "hauler_name",
   "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
    },
    {
     "name": "fiscal_week",
     "type": "esriFieldTypeInteger",
     "alias": "fiscal_week",
     "domain": null
    },
    {
     "name": "fiscal_quarter",
     "type": "esriFieldTypeInteger",
     "alias": "fiscal_quarter",
     "domain": null
    },
    {
     "name": "fiscal_year",
     "type": "esriFieldTypeInteger",
     "alias": "fiscal_year",
     "domain": null
    },
    {
     "name": "material_type",
     "type": "esriFieldTypeString",
     "alias": "material_type",
     "length": 60000,
     "domain": null
    },
    {
     "name": "payment_type",
     "type": "esriFieldTypeString",
     "alias": "payment_type",
     "length": 60000,
     "domain": null
    },
    {
     "name": "hauler_name",
     "type": "esriFieldTypeString",
     "alias": "hauler_name",
     "length": 60000,
     "domain": null
    },
    {
     "name": "hauler_account_number",
     "type": "esriFieldTypeString",
     "alias": "hauler_account_number",
     "length": 60000,
     "domain": null
    }
   ],
   "indexes": null,
   "subtypes": [],
   "relationships": [],
   "capabilities": "Data,Map,Query",
   "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": "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": 1073741822,
     "domain": null
    },
    {
     "name": "crew_subtype",
     "type": "esriFieldTypeString",
     "alias": "crew_subtype",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "source_app_id",
     "type": "esriFieldTypeSmallInteger",
     "alias": "source_app_id",
     "domain": null
    },
    {
     "name": "external_id",
     "type": "esriFieldTypeString",
     "alias": "external_id",
     "length": 1073741822,
     "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": 1073741822,
     "domain": null
    },
    {
     "name": "division",
     "type": "esriFieldTypeString",
     "alias": "division",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "section",
     "type": "esriFieldTypeString",
     "alias": "section",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "business_unit",
     "type": "esriFieldTypeString",
     "alias": "business_unit",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "activity",
     "type": "esriFieldTypeString",
     "alias": "activity",
     "length": 1073741822,
     "domain": null
    }
   ],
   "indexes": null,
   "subtypes": [],
   "relationships": [],
   "capabilities": "Data,Map,Query",
   "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": "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": 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": "employee_status",
     "type": "esriFieldTypeString",
     "alias": "employee_status",
     "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": "employee_id",
     "type": "esriFieldTypeString",
     "alias": "employee_id",
     "length": 60000,
     "domain": null
    }
   ],
   "indexes": null,
   "subtypes": [],
   "relationships": [],
   "capabilities": "Data,Map,Query",
   "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": "Crews View",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "title",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "activity",
     "type": "esriFieldTypeString",
     "alias": "activity",
     "length": 60000,
     "domain": null
    },
    {
     "name": "asset_id",
     "type": "esriFieldTypeInteger",
     "alias": "asset_id",
     "domain": null
    },
    {
     "name": "business_unit",
     "type": "esriFieldTypeString",
     "alias": "business_unit",
     "length": 60000,
     "domain": null
    },
    {
     "name": "computed_status",
     "type": "esriFieldTypeString",
     "alias": "computed_status",
     "length": 60000,
     "domain": null
    },
    {
     "name": "crew_id",
     "type": "esriFieldTypeInteger",
     "alias": "crew_id",
     "domain": null
    },
    {
     "name": "crew_people_id",
     "type": "esriFieldTypeOID",
     "alias": "crew_people_id",
     "domain": null
    },
    {
     "name": "crew_subtype",
     "type": "esriFieldTypeString",
     "alias": "crew_subtype",
     "length": 60000,
     "domain": null
    },
    {
     "name": "crew_type",
     "type": "esriFieldTypeString",
     "alias": "crew_type",
     "length": 60000,
     "domain": null
    },
    {
     "name": "department",
     "type": "esriFieldTypeString",
     "alias": "department",
     "length": 60000,
     "domain": null
    },
    {
     "name": "division",
     "type": "esriFieldTypeString",
     "alias": "division",
     "length": 60000,
     "domain": null
    },
    {
     "name": "employee_id",
     "type": "esriFieldTypeString",
     "alias": "employee_id",
     "length": 60000,
     "domain": null
    },
    {
     "name": "employee_status",
     "type": "esriFieldTypeString",
     "alias": "employee_status",
     "length": 60000,
     "domain": null
    },
    {
     "name": "end_datetime",
     "type": "esriFieldTypeDate",
     "alias": "end_datetime",
     "length": 8,
     "domain": null
    },
    {
     "name": "external_id",
     "type": "esriFieldTypeString",
     "alias": "external_id",
     "length": 60000,
     "domain": null
    },
    {
     "name": "first_name",
     "type": "esriFieldTypeString",
     "alias": "first_name",
     "length": 60000,
     "domain": null
    },
    {
     "name": "full_time_equivalent",
     "type": "esriFieldTypeSingle",
     "alias": "full_time_equivalent",
     "domain": null
    },
    {
     "name": "hours",
     "type": "esriFieldTypeInteger",
     "alias": "hours",
     "domain": null
    },
    {
     "name": "inserted_at",
     "type": "esriFieldTypeDate",
     "alias": "inserted_at",
     "length": 8,
     "domain": null
    },
    {
     "name": "last_name",
     "type": "esriFieldTypeString",
     "alias": "last_name",
     "length": 60000,
     "domain": null
    },
    {
     "name": "last_synced_from_trakster_at",
     "type": "esriFieldTypeDate",
     "alias": "last_synced_from_trakster_at",
     "length": 8,
     "domain": null
    },
    {
     "name": "organization_id",
     "type": "esriFieldTypeSmallInteger",
     "alias": "organization_id",
     "domain": null
    },
    {
     "name": "overtime_equivalent",
     "type": "esriFieldTypeSingle",
     "alias": "overtime_equivalent",
     "domain": null
    },
    {
     "name": "overtime_hours",
     "type": "esriFieldTypeInteger",
     "alias": "overtime_hours",
     "domain": null
    },
    {
     "name": "person_id",
     "type": "esriFieldTypeInteger",
     "alias": "person_id",
     "domain": null
    },
    {
     "name": "phone",
     "type": "esriFieldTypeString",
     "alias": "phone",
     "length": 60000,
     "domain": null
    },
    {
     "name": "section",
     "type": "esriFieldTypeString",
     "alias": "section",
     "length": 60000,
     "domain": null
    },
    {
     "name": "source_app_id",
     "type": "esriFieldTypeSmallInteger",
     "alias": "source_app_id",
     "domain": null
    },
    {
     "name": "start_datetime",
     "type": "esriFieldTypeDate",
     "alias": "start_datetime",
     "length": 8,
     "domain": null
    },
    {
     "name": "status",
     "type": "esriFieldTypeString",
     "alias": "status",
     "length": 60000,
     "domain": null
    },
    {
     "name": "status_category",
     "type": "esriFieldTypeString",
     "alias": "status_category",
     "length": 60000,
     "domain": null
    },
    {
     "name": "title",
     "type": "esriFieldTypeString",
     "alias": "title",
     "length": 60000,
     "domain": null
    },
    {
     "name": "total_hours",
     "type": "esriFieldTypeInteger",
     "alias": "total_hours",
     "domain": null
    },
    {
     "name": "updated_at",
     "type": "esriFieldTypeDate",
     "alias": "updated_at",
     "length": 8,
     "domain": null
    },
    {
     "name": "license_plate",
     "type": "esriFieldTypeString",
     "alias": "license_plate",
     "length": 60000,
     "domain": null
    },
    {
     "name": "faster_id",
     "type": "esriFieldTypeString",
     "alias": "faster_id",
     "length": 60000,
     "domain": null
    }
   ],
   "indexes": null,
   "subtypes": [],
   "relationships": [],
   "capabilities": "Data,Map,Query",
   "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": 5,
   "name": "Faster Work Orders",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "asset_number",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "id",
     "type": "esriFieldTypeOID",
     "alias": "id",
     "domain": null
    },
    {
     "name": "document_id",
     "type": "esriFieldTypeInteger",
     "alias": "document_id",
     "domain": null
    },
    {
     "name": "asset_number",
     "type": "esriFieldTypeString",
     "alias": "asset_number",
     "length": 60000,
     "domain": null
    },
    {
     "name": "work_order_status",
     "type": "esriFieldTypeString",
     "alias": "work_order_status",
     "length": 60000,
     "domain": null
    },
    {
     "name": "in_date",
     "type": "esriFieldTypeDate",
     "alias": "in_date",
     "length": 8,
     "domain": null
    },
    {
     "name": "out_date",
     "type": "esriFieldTypeDate",
     "alias": "out_date",
     "length": 8,
     "domain": null
    },
    {
     "name": "promised_date",
     "type": "esriFieldTypeDate",
     "alias": "promised_date",
     "length": 8,
     "domain": null
    },
    {
     "name": "work_order_modified_date",
     "type": "esriFieldTypeDate",
     "alias": "work_order_modified_date",
     "length": 8,
     "domain": null
    },
    {
     "name": "availability_start_time",
     "type": "esriFieldTypeDate",
     "alias": "availability_start_time",
     "length": 8,
     "domain": null
    },
    {
     "name": "availability_end_time",
     "type": "esriFieldTypeDate",
     "alias": "availability_end_time",
     "length": 8,
     "domain": null
    },
    {
     "name": "description",
     "type": "esriFieldTypeString",
     "alias": "description",
     "length": 60000,
     "domain": null
    },
    {
     "name": "faster_shop_id",
     "type": "esriFieldTypeString",
     "alias": "faster_shop_id",
     "length": 3,
     "domain": null
    },
    {
     "name": "total_labor_charge",
     "type": "esriFieldTypeDouble",
     "alias": "total_labor_charge",
     "domain": null
    },
    {
     "name": "total_parts_charge",
     "type": "esriFieldTypeDouble",
     "alias": "total_parts_charge",
     "domain": null
    },
    {
     "name": "total_sublet_charge",
     "type": "esriFieldTypeDouble",
     "alias": "total_sublet_charge",
     "domain": null
    },
    {
     "name": "total_other_charge",
     "type": "esriFieldTypeDouble",
     "alias": "total_other_charge",
     "domain": null
    },
    {
     "name": "total_work_order_charge",
     "type": "esriFieldTypeDouble",
     "alias": "total_work_order_charge",
     "domain": null
    },
    {
     "name": "asset_type",
     "type": "esriFieldTypeString",
     "alias": "asset_type",
     "length": 60000,
     "domain": null
    },
    {
     "name": "make",
     "type": "esriFieldTypeString",
     "alias": "make",
     "length": 60000,
     "domain": null
    },
    {
     "name": "model",
     "type": "esriFieldTypeString",
     "alias": "model",
     "length": 60000,
     "domain": null
    },
    {
     "name": "asset_class",
     "type": "esriFieldTypeString",
     "alias": "asset_class",
     "length": 60000,
     "domain": null
    }
   ],
   "indexes": null,
   "subtypes": [],
   "relationships": [],
   "capabilities": "Data,Map,Query",
   "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
   }
  }
 ]
}