Name: Water Service

Display Field: HIST_ID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 3600

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 995015.870680247
YMin: 1737466.07102808
XMax: 1077613.43940866
YMax: 1794663.99829866
Spatial Reference: 102671 (3435)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":1.5}},"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])
• SERVICE_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)
• SERVICE_TYPE (type: esriFieldTypeSmallInteger, alias: Water Service Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [2: Domestic], [3: Fire Suppression])
• SERVICE_MATERIAL (type: esriFieldTypeSmallInteger, alias: Water Service Material, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Cast Iron], [2: Copper], ... 5 more ...)
• SERVICE_SIZE (type: esriFieldTypeSmallInteger, alias: Water Service Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [4: 4"], [6: 6"], ... 15 more ...)
• SERVICE_STATUS (type: esriFieldTypeSmallInteger, alias: Water Service Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Active], [2: Inactive], ... 2 more ...)
• SERVICE_OWNER (type: esriFieldTypeString, alias: Water Service Owner, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SERVICE_OWNER_TYPE (type: esriFieldTypeSmallInteger, alias: Water Service Owner Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: City of Joliet], [2: Other Government Agency], ... 1 more ...)
• LOCATION (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 254, 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 ...)
• 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)
• 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)
• REPLACED_MATERIAL (type: esriFieldTypeSmallInteger, alias: Replaced Material, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Cast Iron], [2: Copper], ... 5 more ...)
• REPLACED_DATE (type: esriFieldTypeDate, alias: Replaced Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ELEVATION (type: esriFieldTypeDouble, alias: ELEVATION, SQL Type: sqlTypeOther, 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 Service
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• EDITED_BY: RTA - MJD
• Enabled: 1
• LAST_UPDATE: 1422316800000
• SOURCE: 5
• SERVICE_OID: 0
• EDIT_TYPE: 3

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/23/2026 2:46:28 PM

Schema Last Edit Date: 7/23/2026 2:46:28 PM

Data Last Edit Date: 7/23/2026 2:46:28 PM

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