Name: City Hydrants

Display Field: FACILITYID

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: 2189763.29398942
YMin: 368507.289345235
XMax: 2264396.95837007
YMax: 449639.253393307
Spatial Reference: 102724 (2267)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[117,147,60,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"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)
• FACILITYID (type: esriFieldTypeString, alias: UID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• INSTALLDATE (type: esriFieldTypeDate, alias: A_INSTALL_DATE , SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LOCDESC (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• ROTATION (type: esriFieldTypeDouble, alias: Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MANUFACTURER (type: esriFieldTypeString, alias: X_MANU, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [American Darling: American Darling], [Clow Corporation: Clow Corporation], [Corey: Corey], ... 13 more ...)
• OPERABLE (type: esriFieldTypeSmallInteger, alias: Operable, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• LASTSERVICE (type: esriFieldTypeDate, alias: Last Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• ACTIVEFLAG (type: esriFieldTypeSmallInteger, alias: Active Flag, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• OWNEDBY (type: esriFieldTypeString, alias: A_OWNER, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [OSU: OSU], [CITY: CITY], [PRIVATE: PRIVATE], ... 1 more ...)
• MAINTBY (type: esriFieldTypeString, alias: A_SYSTEM, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [RWD1: Rural System D1], [RWC3: Rural System C3], [CITY: MUNICIPAL], ... 2 more ...)
• LASTUPDATE (type: esriFieldTypeDate, alias: G_MOD_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTEDITOR (type: esriFieldTypeString, alias: G_MOD_BY, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FLOW (type: esriFieldTypeDouble, alias: Flow Rate (GPM), SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_STATUS (type: esriFieldTypeString, alias: A_STATUS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [IN USE: IN USE], [DEMOLISHED: DEMOLISHED], [NOT CONSTRUCTED: NOT CONSTRUCTED], ... 2 more ...)
• X_ELEV_SURVEY (type: esriFieldTypeDouble, alias: X_ELEV_SURVEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• X_TYPE (type: esriFieldTypeString, alias: X_TYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [FIRE HYDRANT: FIRE HYDRANT], [FLUSHING HYDRANT: FLUSHING HYDRANT])
• V_HAS_VALVE (type: esriFieldTypeString, alias: X_HAS_VALVE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO], [UNKNOWN: UNKNOWN])
• V_UID (type: esriFieldTypeString, alias: V_UID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• X_ZONE (type: esriFieldTypeString, alias: X_ZONE , SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [44TH: 44TH], [56TH: 56TH], [BOULDER: BOULDER], ... 12 more ...)
• X_CONDITION (type: esriFieldTypeString, alias: X_CONDITION, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [INOPERABLE: INOPERABLE], [EXCELLENT: EXCELLENT], [VERY GOOD: VERY GOOD], ... 5 more ...)
• G_SOURCE (type: esriFieldTypeString, alias: G_SOURCE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [AERIAL: AERIAL], [ASBUILT: ASBUILT], [ATLAS: ATLAS], ... 7 more ...)
• G_CRT_DATE (type: esriFieldTypeDate, alias: G_CRT_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• G_CRT_BY (type: esriFieldTypeString, alias: G_CRT_BY, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• G_MOD_SOURCE (type: esriFieldTypeString, alias: G_MOD_SOURCE, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• G_COMMENT (type: esriFieldTypeString, alias: G_COMMENT, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• G_ASBUILT1 (type: esriFieldTypeString, alias: G_ASBUILT1, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• G_ASBUILT2 (type: esriFieldTypeString, alias: G_ASBUILT2, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• G_ASBUILT3 (type: esriFieldTypeString, alias: G_ASBUILT3, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• V_INSTALLDATE (type: esriFieldTypeDate, alias: V_INSTALLDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• V_DIAM (type: esriFieldTypeDouble, alias: V_DIAM, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 3/4"], [1: 1"], [1.25: 1 1/4"], ... 30 more ...)
• V_TYPE (type: esriFieldTypeString, alias: V_TYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [AIR RELIEF: AIR RELIEF], [BUTTERFLY: BUTTERFLY], [GATE-RW: GATE-RW], ... 7 more ...)
• V_OWNEDBY (type: esriFieldTypeString, alias: V_OWNEDBY, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [OSU: OSU], [CITY: CITY], [PRIVATE: PRIVATE], ... 1 more ...)
• V_MAINTBY (type: esriFieldTypeString, alias: V_MAINTBY, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [RWD1: Rural System D1], [RWC3: Rural System C3], [CITY: MUNICIPAL], ... 2 more ...)
• V_STATUS (type: esriFieldTypeString, alias: V_STATUS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [IN USE: IN USE], [DEMOLISHED: DEMOLISHED], [NOT CONSTRUCTED: NOT CONSTRUCTED], ... 2 more ...)
• V_DEPTH (type: esriFieldTypeDouble, alias: V_DEPTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_POS_NORM (type: esriFieldTypeString, alias: V_POS_NORM, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [OPEN: OPEN], [CLOSED: CLOSED], [PARTIAL: PARTIAL], ... 1 more ...)
• V_POS_CUR (type: esriFieldTypeString, alias: V_POS_CUR, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [OPEN: OPEN], [CLOSED: CLOSED], [PARTIAL: PARTIAL], ... 1 more ...)
• V_PRES_RATING (type: esriFieldTypeDouble, alias: V_PRES_RATING, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_RESTRAINT (type: esriFieldTypeString, alias: V_RESTRAINT, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [GRIP: GRIP], [NONE: NONE], [THRUST ANCHOR: THRUST ANCHOR], ... 2 more ...)
• V_MANU (type: esriFieldTypeString, alias: V_MANU, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• V_CONDITION (type: esriFieldTypeString, alias: V_CONDITION, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [INOPERABLE: INOPERABLE], [EXCELLENT: EXCELLENT], [VERY GOOD: VERY GOOD], ... 5 more ...)
• V_ELEV_SURVEY (type: esriFieldTypeDouble, alias: Pitot PSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_EX_DATE (type: esriFieldTypeDate, alias: V_EX_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• V_CLOSE_DIR (type: esriFieldTypeString, alias: V_CLOSE_DIR, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [CW: CW], [CCW: CCW], [UNKNOWN: UNKNOWN])
• V_TORQUE (type: esriFieldTypeDouble, alias: V_TORQUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_TORQ_NOTE (type: esriFieldTypeString, alias: V_TORQ_NOTE, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• V_TURNSTOCLOSE (type: esriFieldTypeDouble, alias: V_TRN_CNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_EX_NOTE (type: esriFieldTypeString, alias: Inspection Note, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• V_SOURCE (type: esriFieldTypeString, alias: V_SOURCE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [AERIAL: AERIAL], [ASBUILT: ASBUILT], [ATLAS: ATLAS], ... 7 more ...)
• V_CRT_DATE (type: esriFieldTypeDate, alias: V_CRT_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• V_CRT_BY (type: esriFieldTypeString, alias: V_CRT_BY, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• V_MOD_SOURCE (type: esriFieldTypeString, alias: V_MOD_SOURCE, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• V_COMMENT (type: esriFieldTypeString, alias: V_COMMENT, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• V_LASTUPDATE (type: esriFieldTypeDate, alias: V_LASTUPDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• V_LASTEDITOR (type: esriFieldTypeString, alias: V_LASTEDITOR, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• V_DISTANCE (type: esriFieldTypeDouble, alias: V_DISTANCE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_EX_ELEV (type: esriFieldTypeDouble, alias: Static PSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Assignment (type: esriFieldTypeString, alias: Assignment, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Year_Made (type: esriFieldTypeSmallInteger, alias: Year_Made, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Steamer_Outlet_No (type: esriFieldTypeSmallInteger, alias: Steamer_Outlet_No, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Outlet_2_5_No (type: esriFieldTypeSmallInteger, alias: Outlet_2_5_No, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Barrel_Size (type: esriFieldTypeDouble, alias: Barrel_Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• H_Coefficient (type: esriFieldTypeString, alias: H_Coefficient, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Date_FlowTest (type: esriFieldTypeDate, alias: Date_FlowTest, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Templates:

Name: City Hydrants
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• INSTALLDATE: -2177452800000
• OPERABLE: 1
• ENABLED: 1
• ACTIVEFLAG: 1
• OWNEDBY: UNKNOWN
• MAINTBY: UNKNOWN
• LASTEDITOR: ""
• A_STATUS: IN USE
• X_ELEV_SURVEY: 0
• X_TYPE: FIRE HYDRANT
• V_HAS_VALVE: UNKNOWN
• V_UID: 0
• X_ZONE: UNKNOWN
• X_CONDITION: UNKNOWN
• G_SOURCE: UNKNOWN
• G_CRT_BY: ""
• G_MOD_SOURCE: ""
• G_COMMENT: ""
• G_ASBUILT1: ""
• G_ASBUILT2: ""
• G_ASBUILT3: ""
• V_DIAM: 6
• V_OWNEDBY: CITY
• V_MAINTBY: CITY
• V_STATUS: IN USE
• V_DEPTH: 0
• V_POS_NORM: OPEN
• V_POS_CUR: OPEN
• V_RESTRAINT: UNKNOWN
• V_MANU: ""
• V_ELEV_SURVEY: 0
• V_TURNSTOCLOSE: 0
• V_CRT_BY: ""
• V_COMMENT: ""
• V_LASTEDITOR: ""
• V_EX_ELEV: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/21/2026 10:33:23 PM

Schema Last Edit Date: 9/21/2026 10:33:23 PM

Data Last Edit Date: 9/21/2026 10:33:23 PM

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