Name: Water Main

Display Field: HIST_ID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 994893.137986083
YMin: 1735593.60101975
XMax: 1077574.41488041
YMax: 1794729.55033291
Spatial Reference: 102671 (3435)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"MAIN_MATERIAL","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":3},"defaultLabel":"","uniqueValueGroups":[{"heading":"Water Main Material","classes":[{"label":"Unknown","description":"Unknown","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":3},"values":[["0"]]},{"label":"Cast Iron","description":"Cast Iron","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":3},"values":[["1"]]},{"label":"Concrete","description":"Concrete","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":3},"values":[["2"]]},{"label":"Ductile Iron","description":"Ductile Iron","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":3},"values":[["3"]]},{"label":"Lead","description":"Lead","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":3},"values":[["4"]]},{"label":"PVC","description":"PVC","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,76,115,255],"width":3},"values":[["5"]]},{"label":"HDPE","description":"HDPE","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,76,115,255],"width":3},"values":[["6"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":3},"value":"0","label":"Unknown"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":3},"value":"1","label":"Cast Iron"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":3},"value":"2","label":"Concrete"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":3},"value":"3","label":"Ductile Iron"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":3},"value":"4","label":"Lead"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,76,115,255],"width":3},"value":"5","label":"PVC"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,76,115,255],"width":3},"value":"6","label":"HDPE"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[56,161,207,255],"toColor":[242,250,125,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[242,250,125,255],"toColor":[237,40,33,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"DomainName($feature, 'MAIN_SIZE') + \" \" + DomainName($feature, 'MAIN_MATERIAL')","title":"Custom"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"none","multiPart":"labelPerFeature","useClippedGeometry":true,"allowOverlapOfFeatureInterior":"avoid","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"MAIN_TYPE IN (2 , 0 , 4 , 3 , 1 )","useCodedValues":true,"maxScale":0,"minScale":0,"name":"Treated","priority":74,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[190,232,255,255],"haloSize":1,"font":{"family":"Arial","size":10,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpression":"[MAIN_SIZE] CONCAT \" \" CONCAT [MAIN_MATERIAL] CONCAT \" Raw\"","labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"none","multiPart":"labelPerFeature","useClippedGeometry":true,"allowOverlapOfFeatureInterior":"avoid","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"MAIN_TYPE IN (5 , 6 )","useCodedValues":true,"maxScale":0,"minScale":0,"name":"Raw","priority":75,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[158,187,215,255],"haloSize":1,"font":{"family":"Arial","size":10,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpression":"[MAIN_SIZE] CONCAT \" \" CONCAT [MAIN_MATERIAL]","labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"none","multiPart":"labelPerFeature","useClippedGeometry":true,"allowOverlapOfFeatureInterior":"avoid","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"NOT ((MAIN_TYPE = 2 ) OR (MAIN_TYPE = 0 ) OR (MAIN_TYPE = 4 ) OR (MAIN_TYPE = 3 ) OR (MAIN_TYPE = 1 ) OR (MAIN_TYPE = 5 ) OR (MAIN_TYPE = 6 ))","useCodedValues":true,"maxScale":0,"minScale":0,"name":"Unknown","priority":77,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[190,232,255,255],"haloSize":1,"font":{"family":"Arial","size":10,"style":"normal","weight":"bold","decoration":"none"}}}]}

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: MAIN_MATERIAL

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])
• MAIN_OID (type: esriFieldTypeInteger, alias: Unique ID, SQL Type: sqlTypeOther, nullable: false, editable: true)
• HIST_ID (type: esriFieldTypeString, alias: Historic ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• MAIN_TYPE (type: esriFieldTypeSmallInteger, alias: Water Main Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Bypass], [2: Distribution], ... 4 more ...)
• MAIN_MATERIAL (type: esriFieldTypeSmallInteger, alias: Water Main Material, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Cast Iron], [2: Concrete], ... 4 more ...)
• MAIN_SIZE (type: esriFieldTypeSmallInteger, alias: Water Main Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [4: 4"], [6: 6"], ... 11 more ...)
• MAIN_STATUS (type: esriFieldTypeSmallInteger, alias: Water Main Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Active], [2: Inactive], ... 2 more ...)
• PRESSURE_GRADIENT (type: esriFieldTypeString, alias: Pressure Gradient, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [UNK: Unknown], [Q2: Q2 (Regulated Low)], [Q3: Q3 (Regulated Intermediate)], ... 6 more ...)
• MAIN_OWNER (type: esriFieldTypeString, alias: Water Main Owner, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MAIN_OWNER_TYPE (type: esriFieldTypeSmallInteger, alias: Water Main Owner Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: City of Joliet], [2: Other Government Agency], ... 1 more ...)
• MAIN_CONDITION (type: esriFieldTypeSmallInteger, alias: Main Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Good], [2: Fair], ... 2 more ...)
• MAIN_CONDITION_DATE (type: esriFieldTypeDate, alias: Main Condition Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INSTALL_DATE (type: esriFieldTypeDate, alias: Installation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EFF_DATE (type: esriFieldTypeDate, alias: Effective Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INACT_DATE (type: esriFieldTypeDate, alias: Inactive Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LAST_UPDATE (type: esriFieldTypeDate, alias: Last Update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EDITED_BY (type: esriFieldTypeString, alias: Edited By, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• NOTE (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SOURCE (type: esriFieldTypeSmallInteger, alias: Source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: CAD], [2: CAD - Map], ... 9 more ...)
• EDIT_TYPE (type: esriFieldTypeSmallInteger, alias: Edit Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Import], [2: Modify - CAD], ... 4 more ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CIPP_LINER (type: esriFieldTypeString, alias: CIPP Liner, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [U: Unknown])
• CIPP_LINING_DATE (type: esriFieldTypeDate, alias: CIPP Lining Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CIPP_LINING_TYPE (type: esriFieldTypeSmallInteger, alias: CIPP Lining Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown])
• CIPP_LINING_NOTES (type: esriFieldTypeString, alias: CIPP_LINING_NOTES, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• CIPP_LINER_INSIDE_DIAMETER (type: esriFieldTypeString, alias: CIPP Liner Inside Diameter, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• POLYWRAP_INST (type: esriFieldTypeSmallInteger, alias: Polywrap Installed, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: Unknown])
• DESIGN_DATE (type: esriFieldTypeDate, alias: Design Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LOCATE_DATE (type: esriFieldTypeDate, alias: Locate Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MODEL_NOTES (type: esriFieldTypeString, alias: Model Notes, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• NOTES2 (type: esriFieldTypeString, alias: Notes 2, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• INSTALL_DECADE (type: esriFieldTypeString, alias: Install Decade, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MODEL_ID (type: esriFieldTypeString, alias: Model ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ELEVATION (type: esriFieldTypeDouble, alias: ELEVATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: 0
Name: Unknown
Domains:

• Field Name: Enabled
  Inherited
  
• Field Name: MAIN_TYPE
  Inherited
  
• Field Name: MAIN_MATERIAL
  Inherited
  
• Field Name: MAIN_SIZE
  Inherited
  
• Field Name: MAIN_STATUS
  Inherited
  
• Field Name: PRESSURE_GRADIENT
  Inherited
  
• Field Name: MAIN_OWNER_TYPE
  Inherited
  
• Field Name: MAIN_CONDITION
  Inherited
  
• Field Name: SOURCE
  Inherited
  
• Field Name: EDIT_TYPE
  Inherited
  
• Field Name: CIPP_LINER
  Inherited
  
• Field Name: CIPP_LINING_TYPE
  Inherited
  
• Field Name: POLYWRAP_INST
  Inherited
  
Templates:

Name: 0
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Enabled: 1
• MAIN_OID: 0
• MAIN_MATERIAL: 0
• CIPP_LINING_TYPE: 0

---

ID: 1
Name: Cast Iron
Domains:

• Field Name: Enabled
  Inherited
  
• Field Name: MAIN_TYPE
  Inherited
  
• Field Name: MAIN_MATERIAL
  Inherited
  
• Field Name: MAIN_SIZE
  Inherited
  
• Field Name: MAIN_STATUS
  Inherited
  
• Field Name: PRESSURE_GRADIENT
  Inherited
  
• Field Name: MAIN_OWNER_TYPE
  Inherited
  
• Field Name: MAIN_CONDITION
  Inherited
  
• Field Name: SOURCE
  Inherited
  
• Field Name: EDIT_TYPE
  Inherited
  
• Field Name: CIPP_LINER
  Inherited
  
• Field Name: CIPP_LINING_TYPE
  Inherited
  
• Field Name: POLYWRAP_INST
  Inherited
  
Templates:

Name: 1
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Enabled: 1
• MAIN_OID: 0
• MAIN_MATERIAL: 1
• CIPP_LINING_TYPE: 0

---

ID: 2
Name: Concrete
Domains:

• Field Name: Enabled
  Inherited
  
• Field Name: MAIN_TYPE
  Inherited
  
• Field Name: MAIN_MATERIAL
  Inherited
  
• Field Name: MAIN_SIZE
  Inherited
  
• Field Name: MAIN_STATUS
  Inherited
  
• Field Name: PRESSURE_GRADIENT
  Inherited
  
• Field Name: MAIN_OWNER_TYPE
  Inherited
  
• Field Name: MAIN_CONDITION
  Inherited
  
• Field Name: SOURCE
  Inherited
  
• Field Name: EDIT_TYPE
  Inherited
  
• Field Name: CIPP_LINER
  Inherited
  
• Field Name: CIPP_LINING_TYPE
  Inherited
  
• Field Name: POLYWRAP_INST
  Inherited
  
Templates:

Name: 2
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Enabled: 1
• MAIN_OID: 0
• MAIN_MATERIAL: 2
• CIPP_LINING_TYPE: 0

---

ID: 3
Name: Ductile Iron
Domains:

• Field Name: Enabled
  Inherited
  
• Field Name: MAIN_TYPE
  Inherited
  
• Field Name: MAIN_MATERIAL
  Inherited
  
• Field Name: MAIN_SIZE
  Inherited
  
• Field Name: MAIN_STATUS
  Inherited
  
• Field Name: PRESSURE_GRADIENT
  Inherited
  
• Field Name: MAIN_OWNER_TYPE
  Inherited
  
• Field Name: MAIN_CONDITION
  Inherited
  
• Field Name: SOURCE
  Inherited
  
• Field Name: EDIT_TYPE
  Inherited
  
• Field Name: CIPP_LINER
  Inherited
  
• Field Name: CIPP_LINING_TYPE
  Inherited
  
• Field Name: POLYWRAP_INST
  Inherited
  
Templates:

Name: 3
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Enabled: 1
• MAIN_OID: 0
• MAIN_MATERIAL: 3
• CIPP_LINING_TYPE: 0

---

ID: 4
Name: Lead
Domains:

• Field Name: Enabled
  Inherited
  
• Field Name: MAIN_TYPE
  Inherited
  
• Field Name: MAIN_MATERIAL
  Inherited
  
• Field Name: MAIN_SIZE
  Inherited
  
• Field Name: MAIN_STATUS
  Inherited
  
• Field Name: PRESSURE_GRADIENT
  Inherited
  
• Field Name: MAIN_OWNER_TYPE
  Inherited
  
• Field Name: MAIN_CONDITION
  Inherited
  
• Field Name: SOURCE
  Inherited
  
• Field Name: EDIT_TYPE
  Inherited
  
• Field Name: CIPP_LINER
  Inherited
  
• Field Name: CIPP_LINING_TYPE
  Inherited
  
• Field Name: POLYWRAP_INST
  Inherited
  
Templates:

Name: 4
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Enabled: 1
• MAIN_OID: 0
• MAIN_MATERIAL: 4
• CIPP_LINING_TYPE: 0

---

ID: 5
Name: PVC
Domains:

• Field Name: Enabled
  Inherited
  
• Field Name: MAIN_TYPE
  Inherited
  
• Field Name: MAIN_MATERIAL
  Inherited
  
• Field Name: MAIN_SIZE
  Inherited
  
• Field Name: MAIN_STATUS
  Inherited
  
• Field Name: PRESSURE_GRADIENT
  Inherited
  
• Field Name: MAIN_OWNER_TYPE
  Inherited
  
• Field Name: MAIN_CONDITION
  Inherited
  
• Field Name: SOURCE
  Inherited
  
• Field Name: EDIT_TYPE
  Inherited
  
• Field Name: CIPP_LINER
  Inherited
  
• Field Name: CIPP_LINING_TYPE
  Inherited
  
• Field Name: POLYWRAP_INST
  Inherited
  
Templates:

Name: 5
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Enabled: 1
• MAIN_OID: 0
• MAIN_MATERIAL: 5
• CIPP_LINING_TYPE: 0

---

ID: 6
Name: HDPE
Domains:

• Field Name: Enabled
  Inherited
  
• Field Name: MAIN_TYPE
  Inherited
  
• Field Name: MAIN_MATERIAL
  Inherited
  
• Field Name: MAIN_SIZE
  Inherited
  
• Field Name: MAIN_STATUS
  Inherited
  
• Field Name: PRESSURE_GRADIENT
  Inherited
  
• Field Name: MAIN_OWNER_TYPE
  Inherited
  
• Field Name: MAIN_CONDITION
  Inherited
  
• Field Name: SOURCE
  Inherited
  
• Field Name: EDIT_TYPE
  Inherited
  
• Field Name: CIPP_LINER
  Inherited
  
• Field Name: CIPP_LINING_TYPE
  Inherited
  
• Field Name: POLYWRAP_INST
  Inherited
  
Templates:

Name: 6
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Enabled: 1
• MAIN_OID: 0
• MAIN_MATERIAL: 6
• CIPP_LINING_TYPE: 0

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/23/2026 2:45:05 PM

Schema Last Edit Date: 7/23/2026 2:45:05 PM

Data Last Edit Date: 7/23/2026 2:45:05 PM

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