Name: Water Hydrant

Display Field: WATHYDRANTID

Type: Feature Layer

Geometry Type: esriGeometryPoint

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: 535356.2705
YMin: 4801446.247
XMax: 549724.7096
YMax: 4816449.4041
Spatial Reference: 26917 (26917)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"STATUS","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,130,130,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"defaultLabel":"","uniqueValueGroups":[{"heading":"STATUS","classes":[{"label":"IN SERVICE","description":"IN SERVICE","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,238,212,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["IN SERVICE"]]},{"label":"OUT OF SERVICE","description":"OUT OF SERVICE","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,204,209,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["OUT OF SERVICE"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,238,212,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"IN SERVICE","label":"IN SERVICE"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,204,209,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"OUT OF SERVICE","label":"OUT OF SERVICE"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,192,252,255],"toColor":[187,192,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,179,255],"toColor":[182,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,208,187,255],"toColor":[252,208,187,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,247,252,255],"toColor":[187,247,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,241,255],"toColor":[252,179,241,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[240,252,212,255],"toColor":[240,252,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,207,230,255],"toColor":[252,207,230,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,225,252,255],"toColor":[215,225,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,252,223,255],"toColor":[184,252,223,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[224,252,179,255],"toColor":[224,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,184,255],"toColor":[252,179,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[222,187,252,255],"toColor":[222,187,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,230,179,255],"toColor":[252,230,179,255]}]}}},"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:

Type ID Field: STATUS

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• WATHYDRANTID (type: esriFieldTypeInteger, alias: WATHYDRANTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [IN SERVICE: IN SERVICE], [OUT OF SERVICE: OUT OF SERVICE])
• STATUS_DATE (type: esriFieldTypeDate, alias: STATUS_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• REL_WATMAINID (type: esriFieldTypeInteger, alias: REL_WATMAINID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REL_WATSERVICEPIPEID (type: esriFieldTypeInteger, alias: REL_WATSERVICEPIPEID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROPERTY_UNIT_ID (type: esriFieldTypeInteger, alias: PROPERTY_UNIT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADDRESSID (type: esriFieldTypeInteger, alias: ADDRESSID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAKE (type: esriFieldTypeString, alias: MAKE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [AVK: AVK], [CANADA VALVE: CANADA VALVE], [DAIGLE: DAIGLE], ... 4 more ...)
• MODEL (type: esriFieldTypeString, alias: MODEL, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [BRIGADIER: BRIGADIER], [BRIGADIER IN-LINE: BRIGADIER IN-LINE], [CENTURY: CENTURY], ... 6 more ...)
• LOC_MARKER (type: esriFieldTypeString, alias: LOC_MARKER, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• CONNECTION_TYPE (type: esriFieldTypeString, alias: CONNECTION_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [2 PORTS ONLY: 2 PORTS ONLY], [STORTZ PLUS 2 PORTS: STORTZ PLUS 2 PORTS], [UNKNOWN: UNKNOWN])
• DEADEND_FLUSHING (type: esriFieldTypeString, alias: DEADEND_FLUSHING, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [B: B - BOTH FALL AND REGULAR], [F: F - FALL], [R: R - REGULAR], ... 2 more ...)
• INSTALLATION_DATE (type: esriFieldTypeDate, alias: INSTALLATION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WARRANTYDATE (type: esriFieldTypeDate, alias: WARRANTYDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ACQUISITION (type: esriFieldTypeString, alias: ACQUISITION, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [DONATED: DONATED], [PURCHASED: PURCHASED])
• KU_NOTES (type: esriFieldTypeString, alias: KU_NOTES, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• ENGINEERING_NOTES (type: esriFieldTypeString, alias: ENGINEERING_NOTES, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• CONSULTANT (type: esriFieldTypeString, alias: CONSULTANT, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• GENERAL_GRID (type: esriFieldTypeString, alias: GENERAL_GRID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [277: 277], [300: 300], [323: 323], ... 87 more ...)
• QUARTER_GRID (type: esriFieldTypeString, alias: QUARTER_GRID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [277-A: 277-A], [277-B: 277-B], [277-C: 277-C], ... 311 more ...)
• BFP_BOX_NUM (type: esriFieldTypeInteger, alias: BFP_BOX_NUM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REL_WATSERVICEVALVEID (type: esriFieldTypeInteger, alias: REL_WATSERVICEVALVEID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LRT_HAZARD_ZONE (type: esriFieldTypeString, alias: Lrt Hazard Zone, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ZONE A: ZONE A], [ZONE B: ZONE B], [BUFFER: BUFFER], ... 2 more ...)
• HYDRANT_FLAG_INSTALLED (type: esriFieldTypeString, alias: Hydrant flag installed, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• CLOSEST_ADDRESS (type: esriFieldTypeString, alias: CLOSEST_ADDRESS, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• STATIC_PRESSURE (type: esriFieldTypeInteger, alias: Latest static pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STATIC_PRESSURE_DATE (type: esriFieldTypeDate, alias: Latest static pressure date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INSPECTED_SPRING_1YR (type: esriFieldTypeString, alias: Inspected in spring in last year, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• INSPECTED_FALL_1YR (type: esriFieldTypeString, alias: Inspected in fall last year, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• WATER_IN_BARREL (type: esriFieldTypeString, alias: WATER_IN_BARREL, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO], [UNKNOWN: UNKNOWN])

Types:

ID: IN SERVICE
Name: IN SERVICE
Domains:

• Field Name: STATUS
  Inherited
  
• Field Name: MAKE
  Inherited
  
• Field Name: MODEL
  Inherited
  
• Field Name: LOC_MARKER
  Inherited
  
• Field Name: CONNECTION_TYPE
  Inherited
  
• Field Name: DEADEND_FLUSHING
  Inherited
  
• Field Name: ACQUISITION
  Inherited
  
• Field Name: GENERAL_GRID
  Inherited
  
• Field Name: QUARTER_GRID
  Inherited
  
• Field Name: LRT_HAZARD_ZONE
  Inherited
  
• Field Name: HYDRANT_FLAG_INSTALLED
  Inherited
  
• Field Name: INSPECTED_SPRING_1YR
  Inherited
  
• Field Name: INSPECTED_FALL_1YR
  Inherited
  
• Field Name: WATER_IN_BARREL
  Inherited
  
Templates:

Name: IN SERVICE
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• INSPECTED_FALL_1YR: N
• STATUS: IN SERVICE
• MAKE: UNKNOWN
• MODEL: UNKNOWN
• LOC_MARKER: N
• CONNECTION_TYPE: UNKNOWN
• DEADEND_FLUSHING: N
• ACQUISITION: DONATED
• LRT_HAZARD_ZONE: NONE
• HYDRANT_FLAG_INSTALLED: N
• INSPECTED_SPRING_1YR: N
• WATER_IN_BARREL: UNKNOWN

---

ID: OUT OF SERVICE
Name: OUT OF SERVICE
Domains:

• Field Name: STATUS
  Inherited
  
• Field Name: MAKE
  Inherited
  
• Field Name: MODEL
  Inherited
  
• Field Name: LOC_MARKER
  Inherited
  
• Field Name: CONNECTION_TYPE
  Inherited
  
• Field Name: DEADEND_FLUSHING
  Inherited
  
• Field Name: ACQUISITION
  Inherited
  
• Field Name: GENERAL_GRID
  Inherited
  
• Field Name: QUARTER_GRID
  Inherited
  
• Field Name: LRT_HAZARD_ZONE
  Inherited
  
• Field Name: HYDRANT_FLAG_INSTALLED
  Inherited
  
• Field Name: INSPECTED_SPRING_1YR
  Inherited
  
• Field Name: INSPECTED_FALL_1YR
  Inherited
  
• Field Name: WATER_IN_BARREL
  Inherited
  
Templates:

Name: OUT OF SERVICE
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• INSPECTED_FALL_1YR: N
• STATUS: OUT OF SERVICE
• MAKE: UNKNOWN
• MODEL: UNKNOWN
• LOC_MARKER: N
• CONNECTION_TYPE: UNKNOWN
• DEADEND_FLUSHING: N
• ACQUISITION: DONATED
• LRT_HAZARD_ZONE: NONE
• HYDRANT_FLAG_INSTALLED: N
• INSPECTED_SPRING_1YR: N
• WATER_IN_BARREL: UNKNOWN

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/25/2025 8:47:06 AM

Schema Last Edit Date: 7/25/2025 8:47:06 AM

Data Last Edit Date: 7/25/2025 8:47:06 AM

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