Layers:

Layer: DATA_ADMIN.CDOT_LightStructures (0)

Name: DATA_ADMIN.CDOT_LightStructures

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1110635.08990068
YMin: 1813925.50144228
XMax: 1205146.79589001
YMax: 1951680.11963327
Spatial Reference: 102671  (3435)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CBI_ID ( type: esriFieldTypeInteger, alias: cbi_id )
• EFFECTIVE_DATE ( type: esriFieldTypeDate, alias: effective_date, length: 8 )
• END_DATE ( type: esriFieldTypeDate, alias: end_date, length: 8 )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: install_date, length: 8 )
• REMOVAL_DATE ( type: esriFieldTypeDate, alias: removal_date, length: 8 )
• ATLAS_PAGE ( type: esriFieldTypeString, alias: atlas_page, length: 10 )
• PHYSICAL_ATLAS_PAGE ( type: esriFieldTypeString, alias: physical_atlas_page, length: 10 )
• STRUCTURE_TYPE ( type: esriFieldTypeInteger, alias: structure_type , Coded Values: [0: Pole] , [1: Viaduct] , [2: Other] )
• LOCATION_TYPE ( type: esriFieldTypeInteger, alias: location_type , Coded Values: [0: Street] , [1: Alley] , [2: Underpass] , ...3 more... )
• CDOT_PROJECT_ID ( type: esriFieldTypeInteger, alias: cdot_project_id )
• POLE_CATEGORY_ID ( type: esriFieldTypeInteger, alias: pole_category_id , Coded Values: [0: City Steel] , [1: City Aluminum] , [2: Wood] , ...3 more... )
• FOUNDATION_TYPE ( type: esriFieldTypeInteger, alias: foundation_type , Coded Values: [0: Controller Pedestal] , [1: Traffic Controller] , [2: Traffic Controller] , ...5 more... )
• BALLAST_HOUSING_TYPE ( type: esriFieldTypeInteger, alias: ballast_housing_type , Coded Values: [0: Round Ballast Housing] , [1: Steel Ballast Housing] , [2: 3 GA Ballast] , ...1 more... )
• HEIGHT_FT ( type: esriFieldTypeDouble, alias: height_ft )
• COMMENTS ( type: esriFieldTypeString, alias: comments, length: 250 )
• HOUSE_NUMBER ( type: esriFieldTypeInteger, alias: house_number )
• STREET_DIR ( type: esriFieldTypeString, alias: street_dir, length: 1 )
• STREET_NAME ( type: esriFieldTypeString, alias: street_name, length: 80 , Coded Values: )
• STREET_TYPE ( type: esriFieldTypeString, alias: street_type, length: 5 , Coded Values: )
• CITY ( type: esriFieldTypeString, alias: city, length: 50 , Coded Values: [Chicago: Chicago] )
• STATE ( type: esriFieldTypeString, alias: state, length: 2 , Coded Values: [IL: Illinois] )
• ZIPCODE ( type: esriFieldTypeString, alias: zipcode, length: 10 )
• X_COORD ( type: esriFieldTypeDouble, alias: x_coord )
• Y_COORD ( type: esriFieldTypeDouble, alias: y_coord )
• LONGITUDE ( type: esriFieldTypeDouble, alias: longitude )
• LATITUDE ( type: esriFieldTypeDouble, alias: latitude )
• ALLEY_LOCATION ( type: esriFieldTypeString, alias: alley_location, length: 50 )
• TRAFFIC_RELATED ( type: esriFieldTypeSmallInteger, alias: traffic_related )
• RELATED_URL ( type: esriFieldTypeString, alias: related_url, length: 250 )
• REVIEWER_USERID ( type: esriFieldTypeString, alias: reviewer_userid, length: 10 )
• REVIEWER_COMMENTS ( type: esriFieldTypeString, alias: reviewer_comments, length: 250 )
• COMED_FILENAME ( type: esriFieldTypeString, alias: comed_filename, length: 30 )
• COMED_STATUSCD ( type: esriFieldTypeString, alias: comed_statuscd, length: 50 , Coded Values: [Ready for Review: Ready for Review] , [Reviewed: Reviewed] , [Submitted: Submitted] , ...4 more... )
• COMED_STATUSDATE ( type: esriFieldTypeDate, alias: comed_statusdate, length: 8 )
• COMED_REJECTREASON ( type: esriFieldTypeString, alias: comed_rejectreason, length: 400 )
• COMED_POLE_ID ( type: esriFieldTypeString, alias: comed_pole_id, length: 12 )
• COMED_LITE_TYPE ( type: esriFieldTypeString, alias: comed_lite_type, length: 3 , Coded Values: [DTD: DTD] , [GLI: GLI] )
• COMED_UPDATETYPE ( type: esriFieldTypeString, alias: comed_updatetype, length: 3 , Coded Values: [INS: INS] , [MNT: MNT] , [REM: REM] , ...1 more... )
• WARD ( type: esriFieldTypeString, alias: ward, length: 2 )
• SYMBOLOGY_CODE ( type: esriFieldTypeInteger, alias: symbology_code )
• CIRCUIT_ID ( type: esriFieldTypeInteger, alias: circuit_id )
• PROCESSED ( type: esriFieldTypeSmallInteger, alias: processed )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: DATA_ADMIN.CDOT_CircuitSegments (1)

Name: DATA_ADMIN.CDOT_CircuitSegments

Display Field: LINE_TYPE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1110635.08990068
YMin: 1813925.50144228
XMax: 1303001.49486526
YMax: 1951645.95795619
Spatial Reference: 102671  (3435)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [128, 0, 123, 255]
Width: 3
Label:
Description:
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CIRCUIT_SEGMENT_ID ( type: esriFieldTypeInteger, alias: circuit_segment_id )
• CIRCUIT_ID ( type: esriFieldTypeInteger, alias: circuit_id )
• LINE_TYPE ( type: esriFieldTypeString, alias: line_type, length: 10 , Coded Values: [2N: 2N] , [NR: NR] , [2NC: 2NC] , ...4 more... )
• LINE_LOCATION_TYPE ( type: esriFieldTypeString, alias: line_location_type, length: 10 , Coded Values: [0: Aerial] , [1: Underground] , [2: Unknown] )
• COMMENTS ( type: esriFieldTypeString, alias: comments, length: 250 )
• CDOT_PROJECT_ID ( type: esriFieldTypeInteger, alias: cdot_project_id )
• FROM_NODE_TYPE ( type: esriFieldTypeString, alias: from_node_type, length: 10 , Coded Values: [Pole: Pole] , [Hole: Hole] , [Junction: Junction] , ...2 more... )
• TO_NODE_TYPE ( type: esriFieldTypeString, alias: to_node_type, length: 10 , Coded Values: [Pole: Pole] , [Hole: Hole] , [Junction: Junction] , ...2 more... )
• FROM_NODE_ID ( type: esriFieldTypeInteger, alias: from_node_id )
• TO_NODE_ID ( type: esriFieldTypeInteger, alias: to_node_id )
• AERIAL_TYPE ( type: esriFieldTypeInteger, alias: aerial_type , Coded Values: )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SHAPE.LEN ( type: esriFieldTypeDouble, alias: SHAPE.LEN )

Layer: DATA_ADMIN.CDOT_Controllers (2)

Name: DATA_ADMIN.CDOT_Controllers

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1111292.90321759
YMin: 1814219.40374161
XMax: 1204970.23095443
YMax: 1951469.85200919
Spatial Reference: 102671  (3435)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CONTROLLER_ID ( type: esriFieldTypeInteger, alias: controller_id )
• SERVICE_ID ( type: esriFieldTypeInteger, alias: service_id )
• ATLAS_PAGE ( type: esriFieldTypeString, alias: atlas_page, length: 10 )
• ATLAS_PAGE_GROUP ( type: esriFieldTypeSmallInteger, alias: atlas_page_group )
• VOLTAGE ( type: esriFieldTypeSmallInteger, alias: voltage )
• CDOT_PROJECT_ID ( type: esriFieldTypeInteger, alias: cdot_project_id )
• METERED_FLAG ( type: esriFieldTypeString, alias: metered_flag, length: 50 )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: install_date, length: 8 )
• REMOVE_DATE ( type: esriFieldTypeDate, alias: remove_date, length: 8 )
• LOCATION_COMMENTS ( type: esriFieldTypeString, alias: location_comments, length: 250 )
• COMMENTS ( type: esriFieldTypeString, alias: comments, length: 250 )
• NEW_GROUP_FLAG ( type: esriFieldTypeSmallInteger, alias: new_group_flag )
• ADDR_NUM ( type: esriFieldTypeInteger, alias: addr_num )
• STREET_DIR ( type: esriFieldTypeString, alias: street_dir, length: 1 )
• STREET_NAME ( type: esriFieldTypeString, alias: street_name, length: 80 , Coded Values: )
• STREET_TYPE ( type: esriFieldTypeString, alias: street_type, length: 5 , Coded Values: )
• ZIPCODE ( type: esriFieldTypeString, alias: zipcode, length: 10 )
• WARD ( type: esriFieldTypeString, alias: ward, length: 2 )
• CONTROLLER_TYPE ( type: esriFieldTypeInteger, alias: controller_type , Coded Values: [0: Residential Controller] , [1: Street Controller Pole Mounted] , [2: Residential Clock Housing] , ...4 more... )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: DATA_ADMIN.CDOT_Holes (3)

Name: DATA_ADMIN.CDOT_Holes

Display Field: HOLE_OWNER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1115510.94989959
YMin: 1815542.22196211
XMax: 1204390.27345293
YMax: 1951017.66492144
Spatial Reference: 102671  (3435)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• HOLE_ID ( type: esriFieldTypeInteger, alias: hole_id )
• CIRCUIT_ID ( type: esriFieldTypeInteger, alias: circuit_id )
• HOLE_OWNER ( type: esriFieldTypeString, alias: hole_owner, length: 10 , Coded Values: [E: Commonwealth Edison] , [T: IL Bell Tele] , [G: People's Gas] , ...4 more... )
• CDOT_PROJECT_ID ( type: esriFieldTypeInteger, alias: cdot_project_id )
• COMMENTS ( type: esriFieldTypeString, alias: comments, length: 250 )
• HOLE_TYPE ( type: esriFieldTypeInteger, alias: hole_type , Coded Values: [0: Manhole] , [1: Handhole] )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: DATA_ADMIN.CDOT_Junctions (4)

Name: DATA_ADMIN.CDOT_Junctions

Display Field: COMMENTS

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1111877.97258551
YMin: 1815138.63090578
XMax: 1204821.04457301
YMax: 1951418.63656044
Spatial Reference: 102671  (3435)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [166, 47, 0, 255]
Size: 7.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• JUNCTION_ID ( type: esriFieldTypeInteger, alias: junction_id )
• CIRCUIT_ID ( type: esriFieldTypeInteger, alias: circuit_id )
• CDOT_PROJECT_ID ( type: esriFieldTypeInteger, alias: cdot_project_id )
• COMMENTS ( type: esriFieldTypeString, alias: comments, length: 250 )
• JUNCTION_TYPE ( type: esriFieldTypeInteger, alias: junction_type , Coded Values: [0: T-Tap] , [1: Hop] , [2: Hold] )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: DATA_ADMIN.CDOT_Services (5)

Name: DATA_ADMIN.CDOT_Services

Display Field: ATLAS_PAGE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1111292.90321759
YMin: 1814075.08939769
XMax: 1204969.70995809
YMax: 1951492.30570444
Spatial Reference: 102671  (3435)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SERVICE_ID ( type: esriFieldTypeInteger, alias: service_id )
• ATLAS_PAGE ( type: esriFieldTypeString, alias: atlas_page, length: 10 )
• SERVICE_TYPE ( type: esriFieldTypeInteger, alias: service_type , Coded Values: [0: Pole] , [1: Hole] , [2: Other] )
• COMMENTS ( type: esriFieldTypeString, alias: comments, length: 250 )
• LOCATION_COMMENTS ( type: esriFieldTypeString, alias: location_comments, length: 250 )
• CDOT_PROJECT_ID ( type: esriFieldTypeInteger, alias: cdot_project_id )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: DATA_ADMIN.CDOT_AtlasPages (6)

Name: DATA_ADMIN.CDOT_AtlasPages

Display Field: ATLAS_PAGE

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1091073.11754176
YMin: 1813832.53312428
XMax: 1205191.19770409
YMax: 1953182.87614219
Spatial Reference: 102671  (3435)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [231, 206, 245, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Label:
Description:
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ATLAS_PAGE ( type: esriFieldTypeString, alias: atlas_page, length: 10 )
• DEO_DISTRICT ( type: esriFieldTypeSmallInteger, alias: deo_district )
• COMED_ACCOUNT ( type: esriFieldTypeString, alias: comed_account, length: 20 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SHAPE.AREA ( type: esriFieldTypeDouble, alias: SHAPE.AREA )
• SHAPE.LEN ( type: esriFieldTypeDouble, alias: SHAPE.LEN )

Tables:

Table: DATA_ADMIN.CDOT_StreetlightsCircuits (7)

Name: DATA_ADMIN.CDOT_StreetlightsCircuits

Display Field: COMMENTS

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: false
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CIRCUIT_ID ( type: esriFieldTypeInteger, alias: circuit_id )
• CONTROLLER_ID ( type: esriFieldTypeInteger, alias: controller_id )
• BRANCH ( type: esriFieldTypeSmallInteger, alias: branch )
• DISPLAY_FLAG ( type: esriFieldTypeSmallInteger, alias: display_flag )
• NUMBER_OF_CONDUCTORS ( type: esriFieldTypeSmallInteger, alias: number_of_conductors )
• COMMENTS ( type: esriFieldTypeString, alias: comments, length: 250 )
• CDOT_PROJECT_ID ( type: esriFieldTypeInteger, alias: cdot_project_id )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )

Table: DATA_ADMIN.CDOT_StreetlightsProjects (8)

Name: DATA_ADMIN.CDOT_StreetlightsProjects

Display Field: PROJECT_SOURCE_IDENTIFIER

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: false
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CDOT_PROJECT_ID ( type: esriFieldTypeInteger, alias: cdot_project_id )
• PROJECT_SOURCE_SYSTEM ( type: esriFieldTypeInteger, alias: project_source_system )
• PROJECT_SOURCE_IDENTIFIER ( type: esriFieldTypeString, alias: project_source_identifier, length: 20 )
• PROJECT_START ( type: esriFieldTypeDate, alias: project_start, length: 8 )
• PROJECT_END ( type: esriFieldTypeDate, alias: project_end, length: 8 )
• PROJECT_STATUS ( type: esriFieldTypeString, alias: project_status, length: 10 )
• PROJECT_DESCRIPTION ( type: esriFieldTypeString, alias: project_description, length: 250 )
• PROJECT_RELATED_URL ( type: esriFieldTypeString, alias: project_related_url, length: 250 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )

Table: DATA_ADMIN.CDOT_Fixtures (9)

Name: DATA_ADMIN.CDOT_Fixtures

Display Field: COMED_FILENAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: false
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FIXTURE_ID ( type: esriFieldTypeInteger, alias: fixture_id )
• EFFECTIVE_DATE ( type: esriFieldTypeDate, alias: effective_date, length: 8 )
• CIRCUIT_ID ( type: esriFieldTypeInteger, alias: circuit_id )
• BALLAST_LOSS ( type: esriFieldTypeSmallInteger, alias: ballast_loss )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: install_date, length: 8 )
• END_DATE ( type: esriFieldTypeDate, alias: end_date, length: 8 )
• REMOVE_DATE ( type: esriFieldTypeDate, alias: remove_date, length: 8 )
• COMED_STATUSCD ( type: esriFieldTypeString, alias: comed_statuscd, length: 50 , Coded Values: [Ready for Review: Ready for Review] , [Reviewed: Reviewed] , [Submitted: Submitted] , ...4 more... )
• COMED_STATUSDATE ( type: esriFieldTypeDate, alias: comed_statusdate, length: 8 )
• COMED_REJECTREASON ( type: esriFieldTypeString, alias: comed_rejectreason, length: 400 )
• COMED_FILENAME ( type: esriFieldTypeString, alias: comed_filename, length: 30 )
• COMED_UPDATETYPE ( type: esriFieldTypeString, alias: comed_updatetype, length: 3 , Coded Values: [INS: INS] , [MNT: MNT] , [REM: REM] , ...1 more... )
• CDOT_PROJECT_ID ( type: esriFieldTypeInteger, alias: cdot_project_id )
• PHOTOCELL_FLAG ( type: esriFieldTypeSmallInteger, alias: photocell_flag )
• RELATED_URL ( type: esriFieldTypeString, alias: related_url, length: 250 )
• REVIEWER_USERID ( type: esriFieldTypeString, alias: reviewer_userid, length: 10 )
• REVIEWER_COMMENTS ( type: esriFieldTypeString, alias: reviewer_comments, length: 50 )
• COMMENTS ( type: esriFieldTypeString, alias: comments, length: 50 )
• FIXTURE_CODE ( type: esriFieldTypeInteger, alias: fixture_code , Coded Values: [0: aviation_13] , [1: coach_50] , [2: coach_60] , ...81 more... )
• CBI_ID ( type: esriFieldTypeInteger, alias: cbi_id )
• PROCESSED ( type: esriFieldTypeSmallInteger, alias: processed )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )