Name: Roads - Cityworks

Display Field: ST_Name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 131072

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10025762.2022878
YMin: 4652954.22851029
XMax: -9995653.07211887
YMax: 4672847.33088065
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSDash","color":[225,225,225,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• FacilityID (type: esriFieldTypeString, alias: FacilityID, SQL Type: sqlTypeOther, length: 41, nullable: true, editable: true)
• SubType (type: esriFieldTypeInteger, alias: SubType, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• InstallDate (type: esriFieldTypeDate, alias: InstallDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LifeCycleStatus (type: esriFieldTypeString, alias: LifeCycleStatus, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [OPEN: Open], [CL: Closed], [UC: Under Construction], ... 4 more ...)
• RecordedLength (type: esriFieldTypeDouble, alias: RecordedLength, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Owner (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [OFAL: City of O'Fallon], [OFTW: O'Fallon Township], [CASE: Caseyville Township], ... 9 more ...)
• Contractor (type: esriFieldTypeString, alias: Contractor, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• NumberofLanes (type: esriFieldTypeSmallInteger, alias: NumberofLanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Median (type: esriFieldTypeSmallInteger, alias: Median, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• FromLeft (type: esriFieldTypeDouble, alias: From Left Address, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ToLeft (type: esriFieldTypeDouble, alias: To Left Address, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FromRight (type: esriFieldTypeDouble, alias: From Right Address, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ToRight (type: esriFieldTypeDouble, alias: To Right Address, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESN_Left (type: esriFieldTypeString, alias: Left Emergency Services Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ESN_Right (type: esriFieldTypeString, alias: Right Emergency Services Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Comm_Left (type: esriFieldTypeString, alias: Left Community, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• Comm_Right (type: esriFieldTypeString, alias: Right Community, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• Zip_Left (type: esriFieldTypeInteger, alias: Left Zipcode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Zip_Right (type: esriFieldTypeInteger, alias: Right Zipcode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Refcode (type: esriFieldTypeString, alias: Reference Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ColorCode (type: esriFieldTypeString, alias: Color Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• RDCode (type: esriFieldTypeString, alias: Road Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Pre_Dir (type: esriFieldTypeString, alias: Prefix Direction, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ST_Name (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• ST_Type (type: esriFieldTypeString, alias: Street Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• EDIT_BY (type: esriFieldTypeString, alias: Edited By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• EDIT_DATE (type: esriFieldTypeDate, alias: Last Updated Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• CREATE_BY (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• CREATE_DATE (type: esriFieldTypeDate, alias: Creation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• RETIRE_DATE (type: esriFieldTypeDate, alias: Retired from Service, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FLAG_FOLLOWUP (type: esriFieldTypeDate, alias: Flag for Followup, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• YearOverlaid (type: esriFieldTypeDate, alias: Year Overlaid, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Roads - Zoomed Out
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Enabled: 1
• SubType: 7

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/15/2026 7:33:45 PM

Schema Last Edit Date: 4/15/2026 7:33:45 PM

Data Last Edit Date: 4/15/2026 7:33:45 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat