{
 "currentVersion": 10.81,
 "cimVersion": "2.6.0",
 "id": 23,
 "name": "Traffic Count Deployments",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "DeviceID",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "DeviceID",
   "type": "esriFieldTypeString",
   "alias": "DeviceID",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "TrafficCount_DEVICE",
    "description": "Traffic Counts Collector",
    "codedValues": [
     {
      "name": "PC-501",
      "code": "PC-501"
     },
     {
      "name": "PC-502",
      "code": "PC-502"
     },
     {
      "name": "PC-503",
      "code": "PC-503"
     },
     {
      "name": "PC-504",
      "code": "PC-504"
     },
     {
      "name": "PC-505",
      "code": "PC-505"
     },
     {
      "name": "PC-506",
      "code": "PC-506"
     },
     {
      "name": "PC-507",
      "code": "PC-507"
     },
     {
      "name": "PC-508",
      "code": "PC-508"
     },
     {
      "name": "PC-509",
      "code": "PC-509"
     },
     {
      "name": "PC-510",
      "code": "PC-510"
     },
     {
      "name": "PC-511",
      "code": "PC-511"
     },
     {
      "name": "PC-512",
      "code": "PC-512"
     },
     {
      "name": "PC-513",
      "code": "PC-513"
     },
     {
      "name": "PC-514",
      "code": "PC-514"
     },
     {
      "name": "PC-515",
      "code": "PC-515"
     },
     {
      "name": "PC-516",
      "code": "PC-516"
     },
     {
      "name": "PC-517",
      "code": "PC-517"
     },
     {
      "name": "PC-518",
      "code": "PC-518"
     },
     {
      "name": "PC-519",
      "code": "PC-519"
     },
     {
      "name": "PC-520",
      "code": "PC-520"
     },
     {
      "name": "PC-521",
      "code": "PC-521"
     },
     {
      "name": "PC-522",
      "code": "PC-522"
     },
     {
      "name": "PC-523",
      "code": "PC-523"
     },
     {
      "name": "PC-524",
      "code": "PC-524"
     },
     {
      "name": "PC-525",
      "code": "PC-525"
     },
     {
      "name": "PC-526",
      "code": "PC-526"
     },
     {
      "name": "PC-527",
      "code": "PC-527"
     },
     {
      "name": "PC-528",
      "code": "PC-528"
     },
     {
      "name": "PC-529",
      "code": "PC-529"
     },
     {
      "name": "PC-530",
      "code": "PC-530"
     },
     {
      "name": "PC-531",
      "code": "PC-531"
     },
     {
      "name": "PC-532",
      "code": "PC-532"
     },
     {
      "name": "PC-533",
      "code": "PC-533"
     },
     {
      "name": "PC-534",
      "code": "PC-534"
     },
     {
      "name": "PC-535",
      "code": "PC-535"
     },
     {
      "name": "PC-536",
      "code": "PC-536"
     },
     {
      "name": "PC-537",
      "code": "PC-537"
     },
     {
      "name": "PC-538",
      "code": "PC-538"
     },
     {
      "name": "PC-539",
      "code": "PC-539"
     },
     {
      "name": "PC-540",
      "code": "PC-540"
     },
     {
      "name": "PC-541",
      "code": "PC-541"
     },
     {
      "name": "PC-542",
      "code": "PC-542"
     },
     {
      "name": "PC-543",
      "code": "PC-543"
     },
     {
      "name": "PC-544",
      "code": "PC-544"
     },
     {
      "name": "PC-545",
      "code": "PC-545"
     },
     {
      "name": "PC-546",
      "code": "PC-546"
     },
     {
      "name": "PC-547",
      "code": "PC-547"
     },
     {
      "name": "PC-548",
      "code": "PC-548"
     },
     {
      "name": "PC-549",
      "code": "PC-549"
     },
     {
      "name": "PC-550",
      "code": "PC-550"
     },
     {
      "name": "PC-551",
      "code": "PC-551"
     },
     {
      "name": "PC-552",
      "code": "PC-552"
     },
     {
      "name": "PC-553",
      "code": "PC-553"
     },
     {
      "name": "PC-554",
      "code": "PC-554"
     },
     {
      "name": "PC-555",
      "code": "PC-555"
     },
     {
      "name": "PC-556",
      "code": "PC-556"
     },
     {
      "name": "PC-557",
      "code": "PC-557"
     },
     {
      "name": "PC-558",
      "code": "PC-558"
     },
     {
      "name": "PC-559",
      "code": "PC-559"
     },
     {
      "name": "PC-560",
      "code": "PC-560"
     },
     {
      "name": "PC-561",
      "code": "PC-561"
     },
     {
      "name": "PC-562",
      "code": "PC-562"
     },
     {
      "name": "PC-563",
      "code": "PC-563"
     },
     {
      "name": "PC-564",
      "code": "PC-564"
     },
     {
      "name": "PC-565",
      "code": "PC-565"
     },
     {
      "name": "PC-566",
      "code": "PC-566"
     },
     {
      "name": "PC-567",
      "code": "PC-567"
     },
     {
      "name": "PC-568",
      "code": "PC-568"
     },
     {
      "name": "PC-569",
      "code": "PC-569"
     },
     {
      "name": "PC-570",
      "code": "PC-570"
     },
     {
      "name": "PC-571",
      "code": "PC-571"
     },
     {
      "name": "PC-572",
      "code": "PC-572"
     },
     {
      "name": "PC-573",
      "code": "PC-573"
     },
     {
      "name": "PC-574",
      "code": "PC-574"
     },
     {
      "name": "PC-575",
      "code": "PC-575"
     },
     {
      "name": "PC-576",
      "code": "PC-576"
     },
     {
      "name": "PC-577",
      "code": "PC-577"
     },
     {
      "name": "PC-578",
      "code": "PC-578"
     },
     {
      "name": "PC-579",
      "code": "PC-579"
     },
     {
      "name": "PC-580",
      "code": "PC-580"
     },
     {
      "name": "PC-581",
      "code": "PC-581"
     },
     {
      "name": "PC-582",
      "code": "PC-582"
     },
     {
      "name": "PC-583",
      "code": "PC-583"
     },
     {
      "name": "PC-584",
      "code": "PC-584"
     },
     {
      "name": "PC-585",
      "code": "PC-585"
     },
     {
      "name": "PC-586",
      "code": "PC-586"
     },
     {
      "name": "PC-587",
      "code": "PC-587"
     },
     {
      "name": "PC-588",
      "code": "PC-588"
     },
     {
      "name": "PC-589",
      "code": "PC-589"
     },
     {
      "name": "PC-590",
      "code": "PC-590"
     },
     {
      "name": "PC-591",
      "code": "PC-591"
     },
     {
      "name": "PC-592",
      "code": "PC-592"
     },
     {
      "name": "PC-593",
      "code": "PC-593"
     },
     {
      "name": "PC-594",
      "code": "PC-594"
     },
     {
      "name": "PC-595",
      "code": "PC-595"
     },
     {
      "name": "PC-596",
      "code": "PC-596"
     },
     {
      "name": "PC-597",
      "code": "PC-597"
     },
     {
      "name": "PC-598",
      "code": "PC-598"
     },
     {
      "name": "PC-599",
      "code": "PC-599"
     },
     {
      "name": "PC-600",
      "code": "PC-600"
     },
     {
      "name": "R-1001",
      "code": "R-1001"
     },
     {
      "name": "R-1002",
      "code": "R-1002"
     },
     {
      "name": "R-1003",
      "code": "R-1003"
     },
     {
      "name": "R-1004",
      "code": "R-1004"
     },
     {
      "name": "R-1005",
      "code": "R-1005"
     },
     {
      "name": "R-1006",
      "code": "R-1006"
     },
     {
      "name": "R-1007",
      "code": "R-1007"
     },
     {
      "name": "R-1008",
      "code": "R-1008"
     },
     {
      "name": "R-1009",
      "code": "R-1009"
     },
     {
      "name": "R-1010",
      "code": "R-1010"
     },
     {
      "name": "R-1011",
      "code": "R-1011"
     },
     {
      "name": "R-1012",
      "code": "R-1012"
     },
     {
      "name": "R-1013",
      "code": "R-1013"
     },
     {
      "name": "R-1014",
      "code": "R-1014"
     },
     {
      "name": "R-1015",
      "code": "R-1015"
     },
     {
      "name": "R-1016",
      "code": "R-1016"
     },
     {
      "name": "R-1017",
      "code": "R-1017"
     },
     {
      "name": "R-1018",
      "code": "R-1018"
     },
     {
      "name": "R-1019",
      "code": "R-1019"
     },
     {
      "name": "R-1020",
      "code": "R-1020"
     },
     {
      "name": "R-1021",
      "code": "R-1021"
     },
     {
      "name": "R-1022",
      "code": "R-1022"
     },
     {
      "name": "R-1023",
      "code": "R-1023"
     },
     {
      "name": "R-1024",
      "code": "R-1024"
     },
     {
      "name": "R-1025",
      "code": "R-1025"
     },
     {
      "name": "R-1026",
      "code": "R-1026"
     },
     {
      "name": "R-1027",
      "code": "R-1027"
     },
     {
      "name": "R-1028",
      "code": "R-1028"
     },
     {
      "name": "R-1029",
      "code": "R-1029"
     },
     {
      "name": "R-1030",
      "code": "R-1030"
     },
     {
      "name": "R-1031",
      "code": "R-1031"
     },
     {
      "name": "R-1032",
      "code": "R-1032"
     },
     {
      "name": "R-1033",
      "code": "R-1033"
     },
     {
      "name": "R-1034",
      "code": "R-1034"
     },
     {
      "name": "R-1035",
      "code": "R-1035"
     },
     {
      "name": "R-1036",
      "code": "R-1036"
     },
     {
      "name": "R-1037",
      "code": "R-1037"
     },
     {
      "name": "R-1038",
      "code": "R-1038"
     },
     {
      "name": "R-1039",
      "code": "R-1039"
     },
     {
      "name": "R-1040",
      "code": "R-1040"
     },
     {
      "name": "R-1041",
      "code": "R-1041"
     },
     {
      "name": "R-1042",
      "code": "R-1042"
     },
     {
      "name": "R-1043",
      "code": "R-1043"
     },
     {
      "name": "R-1044",
      "code": "R-1044"
     },
     {
      "name": "R-1045",
      "code": "R-1045"
     },
     {
      "name": "R-1046",
      "code": "R-1046"
     },
     {
      "name": "R-1047",
      "code": "R-1047"
     },
     {
      "name": "R-1048",
      "code": "R-1048"
     },
     {
      "name": "R-1049",
      "code": "R-1049"
     },
     {
      "name": "R-1050",
      "code": "R-1050"
     },
     {
      "name": "R-1051",
      "code": "R-1051"
     },
     {
      "name": "R-1052",
      "code": "R-1052"
     },
     {
      "name": "R-1053",
      "code": "R-1053"
     },
     {
      "name": "R-1054",
      "code": "R-1054"
     },
     {
      "name": "R-1055",
      "code": "R-1055"
     },
     {
      "name": "R-1056",
      "code": "R-1056"
     },
     {
      "name": "R-1057",
      "code": "R-1057"
     },
     {
      "name": "R-1058",
      "code": "R-1058"
     },
     {
      "name": "R-1059",
      "code": "R-1059"
     },
     {
      "name": "R-1060",
      "code": "R-1060"
     },
     {
      "name": "R-1061",
      "code": "R-1061"
     },
     {
      "name": "R-1062",
      "code": "R-1062"
     },
     {
      "name": "R-1063",
      "code": "R-1063"
     },
     {
      "name": "R-1064",
      "code": "R-1064"
     },
     {
      "name": "R-1065",
      "code": "R-1065"
     },
     {
      "name": "R-1066",
      "code": "R-1066"
     },
     {
      "name": "R-1067",
      "code": "R-1067"
     },
     {
      "name": "R-1068",
      "code": "R-1068"
     },
     {
      "name": "R-1069",
      "code": "R-1069"
     },
     {
      "name": "R-1070",
      "code": "R-1070"
     },
     {
      "name": "R-1071",
      "code": "R-1071"
     },
     {
      "name": "R-1072",
      "code": "R-1072"
     },
     {
      "name": "R-1073",
      "code": "R-1073"
     },
     {
      "name": "R-1074",
      "code": "R-1074"
     },
     {
      "name": "R-1075",
      "code": "R-1075"
     },
     {
      "name": "R-1076",
      "code": "R-1076"
     },
     {
      "name": "R-1077",
      "code": "R-1077"
     },
     {
      "name": "R-1078",
      "code": "R-1078"
     },
     {
      "name": "R-1079",
      "code": "R-1079"
     },
     {
      "name": "R-1080",
      "code": "R-1080"
     },
     {
      "name": "R-1081",
      "code": "R-1081"
     },
     {
      "name": "R-1082",
      "code": "R-1082"
     },
     {
      "name": "R-1083",
      "code": "R-1083"
     },
     {
      "name": "R-1084",
      "code": "R-1084"
     },
     {
      "name": "R-1085",
      "code": "R-1085"
     },
     {
      "name": "R-1086",
      "code": "R-1086"
     },
     {
      "name": "R-1087",
      "code": "R-1087"
     },
     {
      "name": "R-1088",
      "code": "R-1088"
     },
     {
      "name": "R-1089",
      "code": "R-1089"
     },
     {
      "name": "R-1090",
      "code": "R-1090"
     },
     {
      "name": "R-1091",
      "code": "R-1091"
     },
     {
      "name": "R-1092",
      "code": "R-1092"
     },
     {
      "name": "R-1093",
      "code": "R-1093"
     },
     {
      "name": "R-1094",
      "code": "R-1094"
     },
     {
      "name": "R-1095",
      "code": "R-1095"
     },
     {
      "name": "R-1096",
      "code": "R-1096"
     },
     {
      "name": "R-1097",
      "code": "R-1097"
     },
     {
      "name": "R-1098",
      "code": "R-1098"
     },
     {
      "name": "R-1099",
      "code": "R-1099"
     },
     {
      "name": "R-1100",
      "code": "R-1100"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Direction",
   "type": "esriFieldTypeString",
   "alias": "Direction",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "TrafficCount_Direction_T",
    "description": "Traffic Counts Collector",
    "codedValues": [
     {
      "name": "FNB - NBT",
      "code": "FNB - NBT"
     },
     {
      "name": "FNB - SBT",
      "code": "FNB - SBT"
     },
     {
      "name": "FSB - NBT",
      "code": "FSB - NBT"
     },
     {
      "name": "FSB - SBT",
      "code": "FSB - SBT"
     },
     {
      "name": "FEB - EBT",
      "code": "FEB - EBT"
     },
     {
      "name": "FEB - WBT",
      "code": "FEB - WBT"
     },
     {
      "name": "FWB - EBT",
      "code": "FWB - EBT"
     },
     {
      "name": "FWB - WBT",
      "code": "FWB - WBT"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Notes",
   "type": "esriFieldTypeString",
   "alias": "Notes",
   "length": 3000,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "AssignmentId",
   "type": "esriFieldTypeGUID",
   "alias": "AssignmentId",
   "length": 38,
   "domain": null
  },
  {
   "name": "DeployDate",
   "type": "esriFieldTypeDate",
   "alias": "Deployed Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "PickupDate",
   "type": "esriFieldTypeDate",
   "alias": "Picked Up Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "LocationID",
   "type": "esriFieldTypeGUID",
   "alias": "LocationID",
   "length": 38,
   "domain": null
  },
  {
   "name": "Speed",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Posted Speed",
   "domain": {
    "type": "codedValue",
    "name": "TrafficCount_speed",
    "description": "Traffic Counts Collector",
    "codedValues": [
     {
      "name": "20",
      "code": 20
     },
     {
      "name": "25",
      "code": 25
     },
     {
      "name": "30",
      "code": 30
     },
     {
      "name": "35",
      "code": 35
     },
     {
      "name": "40",
      "code": 40
     },
     {
      "name": "45",
      "code": 45
     },
     {
      "name": "50",
      "code": 50
     },
     {
      "name": "55",
      "code": 55
     },
     {
      "name": "60",
      "code": 60
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "NumberDirectionsRecorded",
   "type": "esriFieldTypeSmallInteger",
   "alias": "NumberDirectionsRecorded",
   "domain": {
    "type": "codedValue",
    "name": "TrafficCount_NumberRecordedDirections",
    "description": "description",
    "codedValues": [
     {
      "name": "One side",
      "code": 1
     },
     {
      "name": "Both sides",
      "code": 2
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  }
 ],
 "indexes": [
  {
   "name": "R4903_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_4903",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G11387LocationID",
   "fields": "LocationID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G11387Assignment",
   "fields": "AssignmentId",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 1,
   "name": "HPWGDB_Staging.TDO.DropLocations",
   "relatedTableId": 4,
   "role": "esriRelRoleDestination",
   "keyField": "LocationID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 3,
   "name": "HPWGDB_Staging.TDO.DropLocations",
   "relatedTableId": 5,
   "role": "esriRelRoleDestination",
   "keyField": "LocationID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 5,
   "name": "HPWGDB_Staging.TDO.DropLocations",
   "relatedTableId": 6,
   "role": "esriRelRoleDestination",
   "keyField": "LocationID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 7,
   "name": "HPWGDB_Staging.TDO.DropLocations",
   "relatedTableId": 7,
   "role": "esriRelRoleDestination",
   "keyField": "LocationID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 9,
   "name": "HPWGDB_Staging.TDO.DropLocations",
   "relatedTableId": 8,
   "role": "esriRelRoleDestination",
   "keyField": "LocationID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 11,
   "name": "HPWGDB_Staging.TDO.DropLocations",
   "relatedTableId": 9,
   "role": "esriRelRoleDestination",
   "keyField": "LocationID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 13,
   "name": "HPWGDB_Staging.TDO.DropLocations",
   "relatedTableId": 10,
   "role": "esriRelRoleDestination",
   "keyField": "LocationID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 15,
   "name": "HPWGDB_Staging.TDO.DropLocations",
   "relatedTableId": 16,
   "role": "esriRelRoleDestination",
   "keyField": "LocationID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 17,
   "name": "HPWGDB_Staging.TDO.DropLocations",
   "relatedTableId": 17,
   "role": "esriRelRoleDestination",
   "keyField": "LocationID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 18,
   "name": "HPWGDB_Staging.TDO.TrafficCount_Assignments",
   "relatedTableId": 22,
   "role": "esriRelRoleDestination",
   "keyField": "AssignmentId",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Query,Map,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
 },
 "dateFieldsTimeReference": {
  "timeZone": "Central Standard Time",
  "respectsDaylightSaving": false
 },
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}