Name: Water Transmission 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: 997955.266048163
YMin: 1740765.92794541
XMax: 1077468.0847125
YMax: 1786753.283149
Spatial Reference: 102671 (3435)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[56,168,0,255],"width":3}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

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)
• 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], ... 6 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 ...)
• 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)
• 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)
• MODEL_DECADE (type: esriFieldTypeString, alias: Model Decade, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MODEL_NOTES (type: esriFieldTypeString, alias: Model Notes, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• MODEL_ID (type: esriFieldTypeString, alias: Model ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Water Transmission Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/28/2025 6:18:40 PM

Schema Last Edit Date: 5/28/2025 6:18:40 PM

Data Last Edit Date: 5/28/2025 6:18:40 PM

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