{ "layers": [ { "currentVersion": 10.81, "id": 0, "name": "DATA_ADMIN.CDOT_LightStructures", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "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": true, "supportsCalculate": false, "supportsDatumTransformation": true, "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, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": 1110635.08990068, "ymin": 1813925.50144228, "xmax": 1205146.79589001, "ymax": 1951680.11963327, "spatialReference": { "wkid": 102671, "latestWkid": 3435 } }, "sourceSpatialReference": { "wkid": 102671, "latestWkid": 3435 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "197167e2ec9c308866dac76bf4dffb67", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAW9JREFUKJFjYSATsKDxmRINDMLdFBXtRHh4xP//+/fvxZcvT9ZfuLBr/cOH23BpFJnn6zspTEfHi5uNjR9Zka+mZrj92bMbC3bvLmZgYPiKrJF5SWDg9Cg9vRBGLM4SYGeXyLW0TGVhYGDJ2b07Ba6xxdY2LURb2x+bJrgfGBmZog0NQ65/+rRl6smTG1gYGBgYzOXkvNiZmVkJBYgAJye/q4xMEFwjPxubCiFNMCDMy6sEdyojMzM7sRqZGBnZ4Rp//PnzkoGBQZEYjV9//nwN1/j08+cTf/79s2BhYsKr6dvv3wxPPn8+ANe4Ye3aKileXh9beXmcfv3PwMBw8MGDc0mbN/fANa5gYPju+/Jl5BEGhrUWsrJy6Db//PuX4fD9+9efvHgRyMDA8A+ukYGBgSF6+/YzWxMT9XbdvDlJlI/PloOZWYrh//9/337/fvjyy5dd31evLkljYPgNU4+SVr3nz//IwMAQjz94IAAAEBF4m6v6GwIAAAAASUVORK5CYII=", "contentType": "image/png", "width": 10, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "STREET_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CBI_ID", "type": "esriFieldTypeInteger", "alias": "cbi_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "cbi_id" }, { "name": "EFFECTIVE_DATE", "type": "esriFieldTypeDate", "alias": "effective_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "effective_date" }, { "name": "END_DATE", "type": "esriFieldTypeDate", "alias": "end_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "end_date" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "install_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "install_date" }, { "name": "REMOVAL_DATE", "type": "esriFieldTypeDate", "alias": "removal_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "removal_date" }, { "name": "ATLAS_PAGE", "type": "esriFieldTypeString", "alias": "atlas_page", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "atlas_page" }, { "name": "PHYSICAL_ATLAS_PAGE", "type": "esriFieldTypeString", "alias": "physical_atlas_page", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "physical_atlas_page" }, { "name": "STRUCTURE_TYPE", "type": "esriFieldTypeInteger", "alias": "structure_type", "domain": { "type": "codedValue", "name": "StructureTypes", "description": "StructureTypes", "codedValues": [ { "name": "Pole", "code": 0 }, { "name": "Viaduct", "code": 1 }, { "name": "Other", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "defaultValue": null, "modelName": "structure_type" }, { "name": "LOCATION_TYPE", "type": "esriFieldTypeInteger", "alias": "location_type", "domain": { "type": "codedValue", "name": "LocationTypes", "description": "LocationTypes", "codedValues": [ { "name": "Street", "code": 0 }, { "name": "Alley", "code": 1 }, { "name": "Underpass", "code": 2 }, { "name": "CTA", "code": 3 }, { "name": "Aviation", "code": 4 }, { "name": "Other", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "defaultValue": null, "modelName": "location_type" }, { "name": "CDOT_PROJECT_ID", "type": "esriFieldTypeInteger", "alias": "cdot_project_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "cdot_project_id" }, { "name": "POLE_CATEGORY_ID", "type": "esriFieldTypeInteger", "alias": "pole_category_id", "domain": { "type": "codedValue", "name": "PoleCategories", "description": "PoleCategories", "codedValues": [ { "name": "City Steel", "code": 0 }, { "name": "City Aluminum", "code": 1 }, { "name": "Wood", "code": 2 }, { "name": "Foundation With Elbows", "code": 3 }, { "name": "Ornamental", "code": 4 }, { "name": "Other", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "pole_category_id" }, { "name": "FOUNDATION_TYPE", "type": "esriFieldTypeInteger", "alias": "foundation_type", "domain": { "type": "codedValue", "name": "FoundationTypes", "description": "FoundationTypes", "codedValues": [ { "name": "Controller Pedestal", "code": 0 }, { "name": "Traffic Controller", "code": 1 }, { "name": "Traffic Controller", "code": 2 }, { "name": "Traffic Type \"P\"", "code": 3 }, { "name": "Controller Street Light", "code": 4 }, { "name": "Transclosure", "code": 5 }, { "name": "Other", "code": 6 }, { "name": "Helix", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "foundation_type" }, { "name": "BALLAST_HOUSING_TYPE", "type": "esriFieldTypeInteger", "alias": "ballast_housing_type", "domain": { "type": "codedValue", "name": "BallastHousingTypes", "description": "BallastHousingTypes", "codedValues": [ { "name": "Round Ballast Housing", "code": 0 }, { "name": "Steel Ballast Housing", "code": 1 }, { "name": "3 GA Ballast", "code": 2 }, { "name": "Other", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ballast_housing_type" }, { "name": "HEIGHT_FT", "type": "esriFieldTypeDouble", "alias": "height_ft", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "height_ft" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "comments" }, { "name": "HOUSE_NUMBER", "type": "esriFieldTypeInteger", "alias": "house_number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "house_number" }, { "name": "STREET_DIR", "type": "esriFieldTypeString", "alias": "street_dir", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "street_dir" }, { "name": "STREET_NAME", "type": "esriFieldTypeString", "alias": "street_name", "domain": { "type": "codedValue", "name": "StreetNames", "description": "StreetNames", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "street_name" }, { "name": "STREET_TYPE", "type": "esriFieldTypeString", "alias": "street_type", "domain": { "type": "codedValue", "name": "StreetTypes", "description": "StreetTypes", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "street_type" }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "city", "domain": { "type": "codedValue", "name": "City", "description": "city", "codedValues": [ { "name": "Chicago", "code": "Chicago" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "city" }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "state", "domain": { "type": "codedValue", "name": "States", "description": "States", "codedValues": [ { "name": "Illinois", "code": "IL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "state" }, { "name": "ZIPCODE", "type": "esriFieldTypeString", "alias": "zipcode", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "zipcode" }, { "name": "X_COORD", "type": "esriFieldTypeDouble", "alias": "x_coord", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "x_coord" }, { "name": "Y_COORD", "type": "esriFieldTypeDouble", "alias": "y_coord", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "y_coord" }, { "name": "LONGITUDE", "type": "esriFieldTypeDouble", "alias": "longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "longitude" }, { "name": "LATITUDE", "type": "esriFieldTypeDouble", "alias": "latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "latitude" }, { "name": "ALLEY_LOCATION", "type": "esriFieldTypeString", "alias": "alley_location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "alley_location" }, { "name": "TRAFFIC_RELATED", "type": "esriFieldTypeSmallInteger", "alias": "traffic_related", "domain": null, "editable": true, "nullable": false, "defaultValue": 0, "modelName": "traffic_related" }, { "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": 250, "defaultValue": null, "modelName": "reviewer_comments" }, { "name": "COMED_FILENAME", "type": "esriFieldTypeString", "alias": "comed_filename", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "comed_filename" }, { "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_POLE_ID", "type": "esriFieldTypeString", "alias": "comed_pole_id", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "comed_pole_id" }, { "name": "COMED_LITE_TYPE", "type": "esriFieldTypeString", "alias": "comed_lite_type", "domain": { "type": "codedValue", "name": "ComedLiteTypes", "description": "ComedLiteTypes", "codedValues": [ { "name": "DTD", "code": "DTD" }, { "name": "GLI", "code": "GLI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "comed_lite_type" }, { "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": "WARD", "type": "esriFieldTypeString", "alias": "ward", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "ward" }, { "name": "SYMBOLOGY_CODE", "type": "esriFieldTypeInteger", "alias": "symbology_code", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "symbology_code" }, { "name": "CIRCUIT_ID", "type": "esriFieldTypeInteger", "alias": "circuit_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "circuit_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" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "G7731CBI_ID", "fields": "CBI_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G7731CDOT_PROJEC", "fields": "CDOT_PROJECT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R211_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A127_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "DATA_ADMIN.CDOT_LightStructures", "description": "", "prototype": { "attributes": { "PROCESSED": null, "CIRCUIT_ID": null, "CBI_ID": null, "EFFECTIVE_DATE": null, "END_DATE": null, "INSTALL_DATE": null, "REMOVAL_DATE": null, "ATLAS_PAGE": null, "PHYSICAL_ATLAS_PAGE": null, "STRUCTURE_TYPE": 0, "LOCATION_TYPE": 0, "CDOT_PROJECT_ID": null, "POLE_CATEGORY_ID": null, "FOUNDATION_TYPE": null, "BALLAST_HOUSING_TYPE": null, "HEIGHT_FT": null, "COMMENTS": null, "HOUSE_NUMBER": null, "STREET_DIR": null, "STREET_NAME": null, "STREET_TYPE": null, "CITY": null, "STATE": null, "ZIPCODE": null, "X_COORD": null, "Y_COORD": null, "LONGITUDE": null, "LATITUDE": null, "ALLEY_LOCATION": null, "TRAFFIC_RELATED": 0, "RELATED_URL": null, "REVIEWER_USERID": null, "REVIEWER_COMMENTS": null, "COMED_FILENAME": null, "COMED_STATUSCD": null, "COMED_STATUSDATE": null, "COMED_REJECTREASON": null, "COMED_POLE_ID": null, "COMED_LITE_TYPE": null, "COMED_UPDATETYPE": null, "WARD": null, "SYMBOLOGY_CODE": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 1, "name": "DATA_ADMIN.CDOT_CircuitSegments", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsDatumTransformation": true, "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, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": 1110635.08990068, "ymin": 1813925.50144228, "xmax": 1303001.49486526, "ymax": 1951645.95795619, "spatialReference": { "wkid": 102671, "latestWkid": 3435 } }, "sourceSpatialReference": { "wkid": 102671, "latestWkid": 3435 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 128, 0, 123, 255 ], "width": 3 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "LINE_TYPE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CIRCUIT_SEGMENT_ID", "type": "esriFieldTypeInteger", "alias": "circuit_segment_id", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "circuit_segment_id" }, { "name": "CIRCUIT_ID", "type": "esriFieldTypeInteger", "alias": "circuit_id", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "circuit_id" }, { "name": "LINE_TYPE", "type": "esriFieldTypeString", "alias": "line_type", "domain": { "type": "codedValue", "name": "LineTypes", "description": "LineTypes", "codedValues": [ { "name": "2N", "code": "2N" }, { "name": "NR", "code": "NR" }, { "name": "2NC", "code": "2NC" }, { "name": "3TC", "code": "3TC" }, { "name": "2W", "code": "2W" }, { "name": "3W", "code": "3W" }, { "name": "III", "code": "III" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "line_type" }, { "name": "LINE_LOCATION_TYPE", "type": "esriFieldTypeString", "alias": "line_location_type", "domain": { "type": "codedValue", "name": "LineLocationTypes", "description": "LineLocationTypes", "codedValues": [ { "name": "Aerial", "code": "0" }, { "name": "Underground", "code": "1" }, { "name": "Unknown", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "line_location_type" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "comments" }, { "name": "CDOT_PROJECT_ID", "type": "esriFieldTypeInteger", "alias": "cdot_project_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "cdot_project_id" }, { "name": "FROM_NODE_TYPE", "type": "esriFieldTypeString", "alias": "from_node_type", "domain": { "type": "codedValue", "name": "NodeTypes", "description": "NodeTypes", "codedValues": [ { "name": "Pole", "code": "Pole" }, { "name": "Hole", "code": "Hole" }, { "name": "Junction", "code": "Junction" }, { "name": "Service", "code": "Service" }, { "name": "Controller", "code": "Controller" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "from_node_type" }, { "name": "TO_NODE_TYPE", "type": "esriFieldTypeString", "alias": "to_node_type", "domain": { "type": "codedValue", "name": "NodeTypes", "description": "NodeTypes", "codedValues": [ { "name": "Pole", "code": "Pole" }, { "name": "Hole", "code": "Hole" }, { "name": "Junction", "code": "Junction" }, { "name": "Service", "code": "Service" }, { "name": "Controller", "code": "Controller" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "to_node_type" }, { "name": "FROM_NODE_ID", "type": "esriFieldTypeInteger", "alias": "from_node_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "from_node_id" }, { "name": "TO_NODE_ID", "type": "esriFieldTypeInteger", "alias": "to_node_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "to_node_id" }, { "name": "AERIAL_TYPE", "type": "esriFieldTypeInteger", "alias": "aerial_type", "domain": { "type": "codedValue", "name": "AerialTypes", "description": "AerialTypes", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "aerial_type" }, { "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" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "G7709CDOT_PROJEC", "fields": "CDOT_PROJECT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G7709CIRCUIT_ID", "fields": "CIRCUIT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R205_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A121_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "DATA_ADMIN.CDOT_CircuitSegments", "description": "", "prototype": { "attributes": { "AERIAL_TYPE": null, "TO_NODE_ID": null, "CIRCUIT_SEGMENT_ID": 0, "CIRCUIT_ID": 0, "LINE_TYPE": null, "LINE_LOCATION_TYPE": null, "COMMENTS": null, "CDOT_PROJECT_ID": null, "FROM_NODE_TYPE": null, "TO_NODE_TYPE": null, "FROM_NODE_ID": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 2, "name": "DATA_ADMIN.CDOT_Controllers", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsDatumTransformation": true, "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, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": 1111292.90321759, "ymin": 1814219.40374161, "xmax": 1204970.23095443, "ymax": 1951469.85200919, "spatialReference": { "wkid": 102671, "latestWkid": 3435 } }, "sourceSpatialReference": { "wkid": 102671, "latestWkid": 3435 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "0f4348b5d87e2d58c89dcef93fee4f91", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAOCAYAAAAmL5yKAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAVhJREFUKJFjYaAQsBCQlxQSEpJ89+7dObIMqKgwaBEV5ZUsLj7sRbIB6upCFuHh2nbi4nyCJ07ciVq9+vkyUgxgTEzUqDYwkFRhYGBg8PTUTFm9+vlaBgaGn0QZ4OoqlBAfr2sK44eEaJnt3Xu9YOnS553EGMATHm4QKyHBKw4T4OXl4A4NNfFdunTzPAYGhtd4DQgLU6mMjNQxRxf38lIxT0tTr54162YBPgOU4+K0nbi42LjQDWBlZWaJjTW02bz5k/bz58+vYjUgPV271tNT2QyLtxgYGBgYrK1ljGNixMu6u5/HYxjAzs7umpVlYsTExMSEywBGRgaG1FRDo+7uC54MDAzbkQ1gKSkxyNHTE9XFpRkGVFWFdVpbzZOrq0/uZmBg+MPCwMDAoK4ulKurK2R3+vQzQvoZIOpFnOTlhTIfPnw3mYWBgYHh5s13/RER2/uJ0o0GAI2YV8jWpKCrAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 12, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "STREET_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CONTROLLER_ID", "type": "esriFieldTypeInteger", "alias": "controller_id", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "controller_id" }, { "name": "SERVICE_ID", "type": "esriFieldTypeInteger", "alias": "service_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "service_id" }, { "name": "ATLAS_PAGE", "type": "esriFieldTypeString", "alias": "atlas_page", "domain": null, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "atlas_page" }, { "name": "ATLAS_PAGE_GROUP", "type": "esriFieldTypeSmallInteger", "alias": "atlas_page_group", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "atlas_page_group" }, { "name": "VOLTAGE", "type": "esriFieldTypeSmallInteger", "alias": "voltage", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "voltage" }, { "name": "CDOT_PROJECT_ID", "type": "esriFieldTypeInteger", "alias": "cdot_project_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "cdot_project_id" }, { "name": "METERED_FLAG", "type": "esriFieldTypeString", "alias": "metered_flag", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "metered_flag" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "install_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "install_date" }, { "name": "REMOVE_DATE", "type": "esriFieldTypeDate", "alias": "remove_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "remove_date" }, { "name": "LOCATION_COMMENTS", "type": "esriFieldTypeString", "alias": "location_comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "location_comments" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "comments" }, { "name": "NEW_GROUP_FLAG", "type": "esriFieldTypeSmallInteger", "alias": "new_group_flag", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "new_group_flag" }, { "name": "ADDR_NUM", "type": "esriFieldTypeInteger", "alias": "addr_num", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "addr_num" }, { "name": "STREET_DIR", "type": "esriFieldTypeString", "alias": "street_dir", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "street_dir" }, { "name": "STREET_NAME", "type": "esriFieldTypeString", "alias": "street_name", "domain": { "type": "codedValue", "name": "StreetNames", "description": "StreetNames", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "street_name" }, { "name": "STREET_TYPE", "type": "esriFieldTypeString", "alias": "street_type", "domain": { "type": "codedValue", "name": "StreetTypes", "description": "StreetTypes", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "street_type" }, { "name": "ZIPCODE", "type": "esriFieldTypeString", "alias": "zipcode", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "zipcode" }, { "name": "WARD", "type": "esriFieldTypeString", "alias": "ward", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "ward" }, { "name": "CONTROLLER_TYPE", "type": "esriFieldTypeInteger", "alias": "controller_type", "domain": { "type": "codedValue", "name": "ControllerTypes", "description": "ControllerTypes", "codedValues": [ { "name": "Residential Controller", "code": 0 }, { "name": "Street Controller Pole Mounted", "code": 1 }, { "name": "Residential Clock Housing", "code": 2 }, { "name": "Street Controller Pedestal Base Mounted", "code": 3 }, { "name": "Traffic Signal Controller", "code": 4 }, { "name": "Transclosure", "code": 5 }, { "name": "Other", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "defaultValue": null, "modelName": "controller_type" }, { "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" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "G7710ATLAS_PAGE", "fields": "ATLAS_PAGE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G7710CDOT_PROJEC", "fields": "CDOT_PROJECT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G7710CONTROLLER_", "fields": "CONTROLLER_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G7710SERVICE_ID", "fields": "SERVICE_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R206_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A122_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "DATA_ADMIN.CDOT_Controllers", "description": "", "prototype": { "attributes": { "CONTROLLER_TYPE": 0, "WARD": null, "CONTROLLER_ID": 0, "SERVICE_ID": null, "ATLAS_PAGE": " ", "ATLAS_PAGE_GROUP": 0, "VOLTAGE": 0, "CDOT_PROJECT_ID": null, "METERED_FLAG": null, "INSTALL_DATE": null, "REMOVE_DATE": null, "LOCATION_COMMENTS": null, "COMMENTS": null, "NEW_GROUP_FLAG": null, "ADDR_NUM": null, "STREET_DIR": null, "STREET_NAME": null, "STREET_TYPE": null, "ZIPCODE": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 3, "name": "DATA_ADMIN.CDOT_Holes", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsDatumTransformation": true, "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, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": 1115510.94989959, "ymin": 1815542.22196211, "xmax": 1204390.27345293, "ymax": 1951017.66492144, "spatialReference": { "wkid": 102671, "latestWkid": 3435 } }, "sourceSpatialReference": { "wkid": 102671, "latestWkid": 3435 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "b776bb3336aab2bb32b5eb67c6d9a7a2", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAE1JREFUKJFjYWBgYGBvZS/nFuf+xUAAfH3w9SILAwMDw8+An7k/tX5KE9LAvoW9m4WQInQwqoGGGu4zcDCwElb888tPLogGHwYRYm0AAHpvEGxowSfSAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 9, "height": 9, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "HOLE_OWNER", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "HOLE_ID", "type": "esriFieldTypeInteger", "alias": "hole_id", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "hole_id" }, { "name": "CIRCUIT_ID", "type": "esriFieldTypeInteger", "alias": "circuit_id", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "circuit_id" }, { "name": "HOLE_OWNER", "type": "esriFieldTypeString", "alias": "hole_owner", "domain": { "type": "codedValue", "name": "HoleOwners", "description": "HoleOwners", "codedValues": [ { "name": "Commonwealth Edison", "code": "E" }, { "name": "IL Bell Tele", "code": "T" }, { "name": "People's Gas", "code": "G" }, { "name": "Chicago Water", "code": "W" }, { "name": "Chicago Park District", "code": "P" }, { "name": "Sewer", "code": "S" }, { "name": "Chicago Transit Auth", "code": "CTA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "hole_owner" }, { "name": "CDOT_PROJECT_ID", "type": "esriFieldTypeInteger", "alias": "cdot_project_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "cdot_project_id" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "comments" }, { "name": "HOLE_TYPE", "type": "esriFieldTypeInteger", "alias": "hole_type", "domain": { "type": "codedValue", "name": "HoleTypes", "description": "HoleTypes", "codedValues": [ { "name": "Manhole", "code": 0 }, { "name": "Handhole", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "hole_type" }, { "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" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "G7711CDOT_PROJEC", "fields": "CDOT_PROJECT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G7711CIRCUIT_ID", "fields": "CIRCUIT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R207_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A123_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "DATA_ADMIN.CDOT_Holes", "description": "", "prototype": { "attributes": { "HOLE_TYPE": null, "COMMENTS": null, "HOLE_ID": 0, "CIRCUIT_ID": 0, "HOLE_OWNER": null, "CDOT_PROJECT_ID": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 4, "name": "DATA_ADMIN.CDOT_Junctions", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsDatumTransformation": true, "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, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": 1111877.97258551, "ymin": 1815138.63090578, "xmax": 1204821.04457301, "ymax": 1951418.63656044, "spatialReference": { "wkid": 102671, "latestWkid": 3435 } }, "sourceSpatialReference": { "wkid": 102671, "latestWkid": 3435 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 166, 47, 0, 255 ], "size": 7, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "COMMENTS", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "JUNCTION_ID", "type": "esriFieldTypeInteger", "alias": "junction_id", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "junction_id" }, { "name": "CIRCUIT_ID", "type": "esriFieldTypeInteger", "alias": "circuit_id", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "circuit_id" }, { "name": "CDOT_PROJECT_ID", "type": "esriFieldTypeInteger", "alias": "cdot_project_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "cdot_project_id" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "comments" }, { "name": "JUNCTION_TYPE", "type": "esriFieldTypeInteger", "alias": "junction_type", "domain": { "type": "codedValue", "name": "JunctionTypes", "description": "junction_description", "codedValues": [ { "name": "T-Tap", "code": 0 }, { "name": "Hop", "code": 1 }, { "name": "Hold", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "defaultValue": null, "modelName": "junction_type" }, { "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" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "G7712CDOT_PROJEC", "fields": "CDOT_PROJECT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G7712CIRCUIT_ID", "fields": "CIRCUIT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R208_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A124_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "DATA_ADMIN.CDOT_Junctions", "description": "", "prototype": { "attributes": { "JUNCTION_TYPE": 0, "COMMENTS": null, "JUNCTION_ID": 0, "CIRCUIT_ID": 0, "CDOT_PROJECT_ID": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 5, "name": "DATA_ADMIN.CDOT_Services", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsDatumTransformation": true, "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, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": 1111292.90321759, "ymin": 1814075.08939769, "xmax": 1204969.70995809, "ymax": 1951492.30570444, "spatialReference": { "wkid": 102671, "latestWkid": 3435 } }, "sourceSpatialReference": { "wkid": 102671, "latestWkid": 3435 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "b3923aba2e8e4238556a7c77e526b36a", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAS9JREFUKJGl0T9LQlEYx/Gvl9M9NwWHyMlXEDUmBLlUuAQNFyEhsrGIqIgoas0oxCIoR6lBEC4R0ewUQVRDtPQ2JATFo11vi1f8G/35befhfDjPjyP4Y0TnYHUoOm6UpNc911BOWt08AbW+8FLuH80WJrcNdN2dOdSZYPR2kYNYKxYt6Diqprb8+HQ6Ms+M6VC34hw2sQDIyL1kVE1v+vHKXn0GEMSImA5YSw0sAEJqZKEfasVzhM24jISyKv8oADQ0z3fIjQcNMNo7/jb/g2VU9SeXK1RVxfdRQTXgM2+JIMPJIIFAP1SkpO7k/fl14eG1+eIG6SsPxqdJ+LQXLlKuWjJ/saJSu22rAqxzktWw7RBjiUH05tfY1HmR79aySu10dXSzxlkOyHXtqbpX/wKmpFmRUzOcLAAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 10, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ATLAS_PAGE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SERVICE_ID", "type": "esriFieldTypeInteger", "alias": "service_id", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "service_id" }, { "name": "ATLAS_PAGE", "type": "esriFieldTypeString", "alias": "atlas_page", "domain": null, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "atlas_page" }, { "name": "SERVICE_TYPE", "type": "esriFieldTypeInteger", "alias": "service_type", "domain": { "type": "codedValue", "name": "ServiceTypes", "description": "ServiceTypes", "codedValues": [ { "name": "Pole", "code": 0 }, { "name": "Hole", "code": 1 }, { "name": "Other", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "defaultValue": null, "modelName": "service_type" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "comments" }, { "name": "LOCATION_COMMENTS", "type": "esriFieldTypeString", "alias": "location_comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "location_comments" }, { "name": "CDOT_PROJECT_ID", "type": "esriFieldTypeInteger", "alias": "cdot_project_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "cdot_project_id" }, { "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" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "G7713ATLAS_PAGE", "fields": "ATLAS_PAGE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G7713CDOT_PROJEC", "fields": "CDOT_PROJECT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G7713SERVICE_ID", "fields": "SERVICE_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R209_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A125_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "DATA_ADMIN.CDOT_Services", "description": "", "prototype": { "attributes": { "CDOT_PROJECT_ID": null, "LOCATION_COMMENTS": null, "SERVICE_ID": 0, "ATLAS_PAGE": " ", "SERVICE_TYPE": 0, "COMMENTS": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 6, "name": "DATA_ADMIN.CDOT_AtlasPages", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": false, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": 1091073.11754176, "ymin": 1813832.53312428, "xmax": 1205191.19770409, "ymax": 1953182.87614219, "spatialReference": { "wkid": 102671, "latestWkid": 3435 } }, "sourceSpatialReference": { "wkid": 102671, "latestWkid": 3435 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 231, 206, 245, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ATLAS_PAGE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ATLAS_PAGE", "type": "esriFieldTypeString", "alias": "atlas_page", "domain": null, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "atlas_page" }, { "name": "DEO_DISTRICT", "type": "esriFieldTypeSmallInteger", "alias": "deo_district", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "deo_district" }, { "name": "COMED_ACCOUNT", "type": "esriFieldTypeString", "alias": "comed_account", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "comed_account" }, { "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" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "G7714ATLAS_PAGE", "fields": "ATLAS_PAGE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R210_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A126_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "DATA_ADMIN.CDOT_AtlasPages", "description": "", "prototype": { "attributes": { "COMED_ACCOUNT": null, "DEO_DISTRICT": null, "ATLAS_PAGE": " " } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 10.81, "id": 7, "name": "DATA_ADMIN.CDOT_StreetlightsCircuits", "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": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "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": "COMMENTS", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CIRCUIT_ID", "type": "esriFieldTypeInteger", "alias": "circuit_id", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "circuit_id" }, { "name": "CONTROLLER_ID", "type": "esriFieldTypeInteger", "alias": "controller_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "controller_id" }, { "name": "BRANCH", "type": "esriFieldTypeSmallInteger", "alias": "branch", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "branch" }, { "name": "DISPLAY_FLAG", "type": "esriFieldTypeSmallInteger", "alias": "display_flag", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "display_flag" }, { "name": "NUMBER_OF_CONDUCTORS", "type": "esriFieldTypeSmallInteger", "alias": "number_of_conductors", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "number_of_conductors" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "comments" }, { "name": "CDOT_PROJECT_ID", "type": "esriFieldTypeInteger", "alias": "cdot_project_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "cdot_project_id" }, { "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": "G7707CDOT_PROJEC", "fields": "CDOT_PROJECT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G7707CIRCUIT_ID", "fields": "CIRCUIT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G7707CONTROLLER_", "fields": "CONTROLLER_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R204_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "DATA_ADMIN.CDOT_StreetlightsCircuits", "description": "", "prototype": { "attributes": { "CDOT_PROJECT_ID": null, "COMMENTS": null, "CIRCUIT_ID": 0, "CONTROLLER_ID": null, "BRANCH": 0, "DISPLAY_FLAG": 0, "NUMBER_OF_CONDUCTORS": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 8, "name": "DATA_ADMIN.CDOT_StreetlightsProjects", "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": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "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": "PROJECT_SOURCE_IDENTIFIER", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CDOT_PROJECT_ID", "type": "esriFieldTypeInteger", "alias": "cdot_project_id", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "cdot_project_id" }, { "name": "PROJECT_SOURCE_SYSTEM", "type": "esriFieldTypeInteger", "alias": "project_source_system", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "project_source_system" }, { "name": "PROJECT_SOURCE_IDENTIFIER", "type": "esriFieldTypeString", "alias": "project_source_identifier", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "project_source_identifier" }, { "name": "PROJECT_START", "type": "esriFieldTypeDate", "alias": "project_start", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "project_start" }, { "name": "PROJECT_END", "type": "esriFieldTypeDate", "alias": "project_end", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "project_end" }, { "name": "PROJECT_STATUS", "type": "esriFieldTypeString", "alias": "project_status", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "project_status" }, { "name": "PROJECT_DESCRIPTION", "type": "esriFieldTypeString", "alias": "project_description", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "project_description" }, { "name": "PROJECT_RELATED_URL", "type": "esriFieldTypeString", "alias": "project_related_url", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "project_related_url" }, { "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": "G7706CDOT_PROJEC", "fields": "CDOT_PROJECT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R203_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "DATA_ADMIN.CDOT_StreetlightsProjects", "description": "", "prototype": { "attributes": { "PROJECT_RELATED_URL": null, "PROJECT_DESCRIPTION": null, "CDOT_PROJECT_ID": 0, "PROJECT_SOURCE_SYSTEM": null, "PROJECT_SOURCE_IDENTIFIER": null, "PROJECT_START": null, "PROJECT_END": null, "PROJECT_STATUS": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "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 } ] }