{
 "currentVersion": 10.81,
 "id": 9,
 "name": "DATA_ADMIN.CDOT_Fixtures",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": {
  "creationDateField": "created_date",
  "creatorField": "created_user",
  "editDateField": "last_edited_date",
  "editorField": "last_edited_user"
 },
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": false,
 "relationships": [],
 "isDataVersioned": true,
 "isDataArchived": false,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": false,
 "advancedQueryCapabilities": {
  "supportsPagination": false,
  "supportsTrueCurve": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsSqlExpression": true
 },
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "OBJECTID",
 "globalIdField": "",
 "displayField": "COMED_FILENAME",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "OBJECTID"
  },
  {
   "name": "FIXTURE_ID",
   "type": "esriFieldTypeInteger",
   "alias": "fixture_id",
   "domain": null,
   "editable": true,
   "nullable": false,
   "defaultValue": null,
   "modelName": "fixture_id"
  },
  {
   "name": "EFFECTIVE_DATE",
   "type": "esriFieldTypeDate",
   "alias": "effective_date",
   "domain": null,
   "editable": true,
   "nullable": false,
   "length": 8,
   "defaultValue": null,
   "modelName": "effective_date"
  },
  {
   "name": "CIRCUIT_ID",
   "type": "esriFieldTypeInteger",
   "alias": "circuit_id",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "circuit_id"
  },
  {
   "name": "BALLAST_LOSS",
   "type": "esriFieldTypeSmallInteger",
   "alias": "ballast_loss",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "ballast_loss"
  },
  {
   "name": "INSTALL_DATE",
   "type": "esriFieldTypeDate",
   "alias": "install_date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "install_date"
  },
  {
   "name": "END_DATE",
   "type": "esriFieldTypeDate",
   "alias": "end_date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "end_date"
  },
  {
   "name": "REMOVE_DATE",
   "type": "esriFieldTypeDate",
   "alias": "remove_date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "remove_date"
  },
  {
   "name": "COMED_STATUSCD",
   "type": "esriFieldTypeString",
   "alias": "comed_statuscd",
   "domain": {
    "type": "codedValue",
    "name": "ComedStatusCodes",
    "description": "ComedStatusCodes",
    "codedValues": [
     {
      "name": "Ready for Review",
      "code": "Ready for Review"
     },
     {
      "name": "Reviewed",
      "code": "Reviewed"
     },
     {
      "name": "Submitted",
      "code": "Submitted"
     },
     {
      "name": "Held",
      "code": "Held"
     },
     {
      "name": "Accepted",
      "code": "Accepted"
     },
     {
      "name": "Rejected",
      "code": "Rejected"
     },
     {
      "name": "AutoAccepted",
      "code": "AutoAccepted"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "comed_statuscd"
  },
  {
   "name": "COMED_STATUSDATE",
   "type": "esriFieldTypeDate",
   "alias": "comed_statusdate",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "comed_statusdate"
  },
  {
   "name": "COMED_REJECTREASON",
   "type": "esriFieldTypeString",
   "alias": "comed_rejectreason",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 400,
   "defaultValue": null,
   "modelName": "comed_rejectreason"
  },
  {
   "name": "COMED_FILENAME",
   "type": "esriFieldTypeString",
   "alias": "comed_filename",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 30,
   "defaultValue": null,
   "modelName": "comed_filename"
  },
  {
   "name": "COMED_UPDATETYPE",
   "type": "esriFieldTypeString",
   "alias": "comed_updatetype",
   "domain": {
    "type": "codedValue",
    "name": "ComedUpdateTypes",
    "description": "ComedUpdateTypes",
    "codedValues": [
     {
      "name": "INS",
      "code": "INS"
     },
     {
      "name": "MNT",
      "code": "MNT"
     },
     {
      "name": "REM",
      "code": "REM"
     },
     {
      "name": "REF",
      "code": "REF"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 3,
   "defaultValue": null,
   "modelName": "comed_updatetype"
  },
  {
   "name": "CDOT_PROJECT_ID",
   "type": "esriFieldTypeInteger",
   "alias": "cdot_project_id",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "cdot_project_id"
  },
  {
   "name": "PHOTOCELL_FLAG",
   "type": "esriFieldTypeSmallInteger",
   "alias": "photocell_flag",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "photocell_flag"
  },
  {
   "name": "RELATED_URL",
   "type": "esriFieldTypeString",
   "alias": "related_url",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 250,
   "defaultValue": null,
   "modelName": "related_url"
  },
  {
   "name": "REVIEWER_USERID",
   "type": "esriFieldTypeString",
   "alias": "reviewer_userid",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "reviewer_userid"
  },
  {
   "name": "REVIEWER_COMMENTS",
   "type": "esriFieldTypeString",
   "alias": "reviewer_comments",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "reviewer_comments"
  },
  {
   "name": "COMMENTS",
   "type": "esriFieldTypeString",
   "alias": "comments",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "comments"
  },
  {
   "name": "FIXTURE_CODE",
   "type": "esriFieldTypeInteger",
   "alias": "fixture_code",
   "domain": {
    "type": "codedValue",
    "name": "FixtureCodes",
    "description": "fixture_codes",
    "codedValues": [
     {
      "name": "aviation_13",
      "code": 0
     },
     {
      "name": "coach_50",
      "code": 1
     },
     {
      "name": "coach_60",
      "code": 2
     },
     {
      "name": "coach_90",
      "code": 3
     },
     {
      "name": "coach_100",
      "code": 4
     },
     {
      "name": "cobra_20",
      "code": 5
     },
     {
      "name": "cobra_90",
      "code": 6
     },
     {
      "name": "cobra_140",
      "code": 7
     },
     {
      "name": "cobra_150",
      "code": 8
     },
     {
      "name": "cobra_210",
      "code": 9
     },
     {
      "name": "cobra_250",
      "code": 10
     },
     {
      "name": "cobra_310",
      "code": 11
     },
     {
      "name": "cobra_315",
      "code": 12
     },
     {
      "name": "cobra_400",
      "code": 13
     },
     {
      "name": "cobra_1000",
      "code": 14
     },
     {
      "name": "flood_150",
      "code": 15
     },
     {
      "name": "flood_250",
      "code": 16
     },
     {
      "name": "flood_310",
      "code": 17
     },
     {
      "name": "flood_315",
      "code": 18
     },
     {
      "name": "flood_400",
      "code": 19
     },
     {
      "name": "ornamental_23",
      "code": 20
     },
     {
      "name": "ornamental_50",
      "code": 21
     },
     {
      "name": "ornamental_100",
      "code": 22
     },
     {
      "name": "ornamental_150",
      "code": 23
     },
     {
      "name": "ornamental_250",
      "code": 24
     },
     {
      "name": "ornamental_310",
      "code": 25
     },
     {
      "name": "ornamental_400",
      "code": 26
     },
     {
      "name": "viaduct_45",
      "code": 27
     },
     {
      "name": "viaduct_100",
      "code": 28
     },
     {
      "name": "ts_ryg_inc",
      "code": 29
     },
     {
      "name": "ts_red_led",
      "code": 30
     },
     {
      "name": "ts_yellow_led",
      "code": 31
     },
     {
      "name": "ts_green_led",
      "code": 32
     },
     {
      "name": "ts_inc_programmable",
      "code": 33
     },
     {
      "name": "ts_led_red_programmable",
      "code": 34
     },
     {
      "name": "ts_led_yellow_programmable",
      "code": 35
     },
     {
      "name": "ts_led_green_programmable",
      "code": 36
     },
     {
      "name": "ts_bike_red",
      "code": 37
     },
     {
      "name": "ts_bike_yellow",
      "code": 38
     },
     {
      "name": "ts_bike_green",
      "code": 39
     },
     {
      "name": "ts_ryg_inc_turn",
      "code": 40
     },
     {
      "name": "ts_ryg_led_turn",
      "code": 41
     },
     {
      "name": "ts_ryg_inc_programmable_turn",
      "code": 42
     },
     {
      "name": "ts_led_red_programmable_turn",
      "code": 43
     },
     {
      "name": "ts_led_yellow_programmable_turn",
      "code": 44
     },
     {
      "name": "ts_led_green_programmable_turn",
      "code": 45
     },
     {
      "name": "ts_pedestrian_inc",
      "code": 46
     },
     {
      "name": "ts_pedestrian_led",
      "code": 47
     },
     {
      "name": "ts_flashers_inc",
      "code": 48
     },
     {
      "name": "ts_flashers_led",
      "code": 49
     },
     {
      "name": "ts_flashers_inc_programmable",
      "code": 50
     },
     {
      "name": "ts_flashers_led_programmable",
      "code": 51
     },
     {
      "name": "ts_inc_sign",
      "code": 52
     },
     {
      "name": "ts_led_sign",
      "code": 53
     },
     {
      "name": "ts_fiber_sign",
      "code": 54
     },
     {
      "name": "ts_flourescent_sign",
      "code": 55
     },
     {
      "name": "ts_induction_sign",
      "code": 56
     },
     {
      "name": "ts_vdc",
      "code": 57
     },
     {
      "name": "ts_controllers",
      "code": 58
     },
     {
      "name": "cobra_145",
      "code": 59
     },
     {
      "name": "viaduct_led_70",
      "code": 60
     },
     {
      "name": "cobra_led_90",
      "code": 61
     },
     {
      "name": "coach_led_90",
      "code": 62
     },
     {
      "name": "cobra_led_100",
      "code": 63
     },
     {
      "name": "cobra_led_157",
      "code": 64
     },
     {
      "name": "cobra_led_189",
      "code": 65
     },
     {
      "name": "cobra_led_200",
      "code": 66
     },
     {
      "name": "cobra_led_400",
      "code": 67
     },
     {
      "name": "coach_led_100",
      "code": 68
     },
     {
      "name": "cobra_led_70",
      "code": 69
     },
     {
      "name": "cobra_led_310",
      "code": 70
     },
     {
      "name": "viaduct_140",
      "code": 71
     },
     {
      "name": "viaduct_150",
      "code": 72
     },
     {
      "name": "viaduct_led_77",
      "code": 73
     },
     {
      "name": "array_of_things_50",
      "code": 74
     },
     {
      "name": "cobra_led_125",
      "code": 75
     },
     {
      "name": "coach_led_28",
      "code": 76
     },
     {
      "name": "cobra_led_91",
      "code": 77
     },
     {
      "name": "viaduct_led_210_(400W_eqv)",
      "code": 78
     },
     {
      "name": "viaduct_led_60_(250W_eqv)",
      "code": 79
     },
     {
      "name": "flood_100",
      "code": 80
     },
     {
      "name": "cobra_led_67_(250W_eqv)",
      "code": 81
     },
     {
      "name": "coach_led_30_(50W_eqv)",
      "code": 82
     },
     {
      "name": "coach_led_60_(100W_eqv)",
      "code": 83
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": false,
   "defaultValue": null,
   "modelName": "fixture_code"
  },
  {
   "name": "CBI_ID",
   "type": "esriFieldTypeInteger",
   "alias": "cbi_id",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "cbi_id"
  },
  {
   "name": "PROCESSED",
   "type": "esriFieldTypeSmallInteger",
   "alias": "processed",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "processed"
  },
  {
   "name": "CREATED_USER",
   "type": "esriFieldTypeString",
   "alias": "CREATED_USER",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "created_user"
  },
  {
   "name": "CREATED_DATE",
   "type": "esriFieldTypeDate",
   "alias": "CREATED_DATE",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "created_date"
  },
  {
   "name": "LAST_EDITED_USER",
   "type": "esriFieldTypeString",
   "alias": "LAST_EDITED_USER",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "last_edited_user"
  },
  {
   "name": "LAST_EDITED_DATE",
   "type": "esriFieldTypeDate",
   "alias": "LAST_EDITED_DATE",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "last_edited_date"
  }
 ],
 "indexes": [
  {
   "name": "G7705CBI_ID",
   "fields": "CBI_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G7705CDOT_PROJEC",
   "fields": "CDOT_PROJECT_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G7705CIRCUIT_ID",
   "fields": "CIRCUIT_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "R202_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "dateFieldsTimeReference": {
  "timeZone": "UTC",
  "respectsDaylightSaving": false
 },
 "types": [],
 "templates": [
  {
   "name": "DATA_ADMIN.CDOT_Fixtures",
   "description": "",
   "prototype": {
    "attributes": {
     "PROCESSED": null,
     "CBI_ID": null,
     "FIXTURE_ID": 0,
     "EFFECTIVE_DATE": -2209161600000,
     "CIRCUIT_ID": null,
     "BALLAST_LOSS": null,
     "INSTALL_DATE": null,
     "END_DATE": null,
     "REMOVE_DATE": null,
     "COMED_STATUSCD": null,
     "COMED_STATUSDATE": null,
     "COMED_REJECTREASON": null,
     "COMED_FILENAME": null,
     "COMED_UPDATETYPE": null,
     "CDOT_PROJECT_ID": null,
     "PHOTOCELL_FLAG": null,
     "RELATED_URL": null,
     "REVIEWER_USERID": null,
     "REVIEWER_COMMENTS": null,
     "COMMENTS": null,
     "FIXTURE_CODE": 0
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 1000,
 "supportedQueryFormats": "JSON, geoJSON",
 "capabilities": "Query",
 "useStandardizedQueries": true,
 "standardMaxRecordCount": 32000,
 "tileMaxRecordCount": 1000,
 "maxRecordCountFactor": 1
}