Name: Raw Water Hydrant

Display Field: ST_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 10000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 998113.319865916
YMin: 1745290.35295166
XMax: 1074928.31190491
YMax: 1784696.11731583
Spatial Reference: 102671 (3435)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"18677cde5ae285487fb80e56b8162e5e","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABeklEQVQ4jb2Uy0pCURSGP/UoXtKudCEL6QIWFD1B0KSamZPIB2jUNGhQg4ZGvUA0iSY5KmsSNDGIaBg1KYQuQmSkhyhLU1Dj5OWo4e0Q/bAXi3+v/bHY7L0E/ljCfwNVgKbESwJppUAHsF/iuQCPUmDdEiptqrVYDT2g74B0CqIB+HrGogjYOMa81cGyeajYf/GxGPJxHfFzWgtwTgq6Zka7Z1gw23930z7BoFrDdsTPGvCetT3lgLtSsAyDxS6bqQSoNJklqW2cvuARm5/3+ZKywB81DMh5PARXS6BrgtF1GWrqhwIgFYFqrZwnY5CMQiIN6aQMLKypCoyH5dzYCyNuEIyg1sl+Ilwb0CmFaIDZhIhL15oxTbbios8H4rEgq8BNNaBXCq8XeA3HtHROMpWD5vRxR0o8ZyP2iLuWDvN6OmA6HmavwYZT35W5P+lhR27ZertkBSU/RTxjRzzLXEOBTiqdESptSk8wO11KPcXAw3oHyL8P2Lr1DZV0YsXDb06nAAAAAElFTkSuQmCC","contentType":"image/png","width":15,"height":15,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

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)
• AncillaryRole (type: esriFieldTypeSmallInteger, alias: AncillaryRole, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• HYDRANT_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)
• LEAD_OID (type: esriFieldTypeInteger, alias: Hydrant Lead OID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HYDRANT_STATUS (type: esriFieldTypeSmallInteger, alias: Hydrant Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Active], [2: Inactive], ... 2 more ...)
• HYDRANT_TYPE (type: esriFieldTypeSmallInteger, alias: Hydrant Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Booster Discharge], [2: Booster Suction], ... 4 more ...)
• HYDRANT_MFG (type: esriFieldTypeSmallInteger, alias: Hydrant Manufacturer, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Clow], [2: Darling], ... 10 more ...)
• HYDRANT_SERVICE (type: esriFieldTypeSmallInteger, alias: Hydrant Service Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: City of Joliet], [2: Other Government Agency], ... 1 more ...)
• HYDRANT_MAIN_SIZE (type: esriFieldTypeSmallInteger, alias: Hydrant Main Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [4: 4"], [6: 6"], ... 9 more ...)
• BARREL_DIAMETER (type: esriFieldTypeDouble, alias: Barrel Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STEAMER_DIAMETER (type: esriFieldTypeSingle, alias: Steamer Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [2.5: 2 1/2"], [4: 4"], ... 3 more ...)
• SEAT_DIAMETER (type: esriFieldTypeDouble, alias: Seat Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• 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)
• CAST_YEAR (type: esriFieldTypeSmallInteger, alias: Cast Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NEED_REPAIR (type: esriFieldTypeSmallInteger, alias: Needs Repair, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: Unknown])
• OUT_OF_SERVICE (type: esriFieldTypeSmallInteger, alias: Out of Service, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: Unknown])
• ST_NUM (type: esriFieldTypeString, alias: Street Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ST_DIR (type: esriFieldTypeString, alias: Street Direction, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ST_NAME (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• BOX_NUM (type: esriFieldTypeString, alias: Box Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• FLOW_GPM (type: esriFieldTypeInteger, alias: Flow GPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMMENT (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 50, 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 ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• 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)
• MODEL_ID (type: esriFieldTypeString, alias: Model ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)

Templates:

Name: Raw Water Hydrant
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Enabled: 1
• HYDRANT_OID: 0
• NEED_REPAIR: 0
• OUT_OF_SERVICE: 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