Name: Water Main

Display Field: FacilityID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Water mains in the O'Fallon, Illinois water system.

Copyright Text: O'Fallon, Illinois Public Works

Min. Scale: 2097152

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2330992.52662658
YMin: 681617.92851074
XMax: 2389804.53367424
YMax: 723882.29903432
Spatial Reference: 102672 (3436)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[2,112,255,255],"width":1},"label":"","description":""},"transparency":0,"labelingInfo":[{"labelPlacement":"esriServerLinePlacementCenterAlong","where":null,"labelExpression":"[DIAMETER]","useCodedValues":true,"symbol":{"type":"esriTS","color":[0,0,255,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":2,"font":{"family":"Arial","size":12,"style":"normal","weight":"bold","decoration":"none"}},"minScale":4096,"maxScale":0}]}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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)
• ADMINISTRATIVEAREA (type: esriFieldTypeString, alias: AdministrativeArea, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [OFAL: City of O'Fallon], [MADI: Madison County], [SHIL: Village of Shiloh], ... 5 more ...)
• FacilityID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 20, 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)
• OPERATIONALAREA (type: esriFieldTypeString, alias: OperationalArea, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [UNK: Unknown], [O'Fallon: O'Fallon, IL], [Fairview Heights: Fairview Heights, IL], ... 6 more ...)
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: LifeCycleStatus, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [PRP: Proposed], [ACT: Active], [ABN: Abandoned], ... 5 more ...)
• SUBTYPE (type: esriFieldTypeInteger, alias: SubType, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECORDEDLENGTH (type: esriFieldTypeDouble, alias: RECORDEDLENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [DI: Ductile Iron], [CI: Cast Iron], [AC: Asbestos Concrete], ... 6 more ...)
• LININGTYPE (type: esriFieldTypeString, alias: LiningType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CM: Cement-Mortar], [SL: Sliplining], [UNK: Unknown], ... 1 more ...)
• NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• DIAMETER (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: 3/4 Inch], [1: 1 Inch], [99: 1 1/2 Inch], ... 21 more ...)
• 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)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Flag_Followup (type: esriFieldTypeDate, alias: Flag for Followup, 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: Water Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• DIAMETER: 12
• LIFECYCLESTATUS: ACT
• SUBTYPE: 2
Name: Water Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• DIAMETER: 12
• LIFECYCLESTATUS: ACT
• SUBTYPE: 2

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/17/2026 12:36:10 AM

Schema Last Edit Date: 7/17/2026 12:36:10 AM

Data Last Edit Date: 7/17/2026 12:36:10 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat