Name: Fire_Hydrant

Display Field: AssetName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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: -9786444.1081
YMin: 5127524.47934951
XMax: -9783740.996
YMax: 5134134.6113
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[34,158,90,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)
• assettype (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [321: Dry Barrel], [322: Wet Barrel])
• creationdate (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• lastupdate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• updatedby (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• secondarydiameter (type: esriFieldTypeDouble, alias: Nozzle Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [2.5: 2 1/2"], [4.5: 4 1/2"], ... 4 more ...)
• designtype (type: esriFieldTypeSmallInteger, alias: Manufacturer, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [60: American Darling], [61: Clow Corporation], ... 15 more ...)
• presentstatus (type: esriFieldTypeSmallInteger, alias: Present Status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Closed], [1: Open], [2: Inactive], ... 1 more ...)
• installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Western Springs], [2: Private], [100: Other])
• maintby (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Western Springs], [2: Private], [100: Other])
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• symbolrotation (type: esriFieldTypeSmallInteger, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 359])
• lastmaint (type: esriFieldTypeDate, alias: Last Maintenance, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• lifecyclestatus (type: esriFieldTypeSmallInteger, alias: Lifecycle Status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 11 more ...)
• ESRIGNSS_RECEIVER (type: esriFieldTypeString, alias: Receiver Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ESRIGNSS_H_RMS (type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_V_RMS (type: esriFieldTypeDouble, alias: Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_ALTITUDE (type: esriFieldTypeDouble, alias: Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_PDOP (type: esriFieldTypeDouble, alias: PDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_HDOP (type: esriFieldTypeDouble, alias: HDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_VDOP (type: esriFieldTypeDouble, alias: VDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_FIXTYPE (type: esriFieldTypeSmallInteger, alias: Fix Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Fix not valid], [1: GPS], [2: Differential GPS], ... 2 more ...)
• ESRIGNSS_CORRECTIONAGE (type: esriFieldTypeDouble, alias: Correction Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_STATIONID (type: esriFieldTypeSmallInteger, alias: Station ID, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 1023])
• ESRIGNSS_NUMSATS (type: esriFieldTypeSmallInteger, alias: Number of Satellites, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 99])
• ESRIGNSS_FIXDATETIME (type: esriFieldTypeDate, alias: Fix Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ESRIGNSS_AVG_H_RMS (type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_AVG_V_RMS (type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_AVG_POSITIONS (type: esriFieldTypeSmallInteger, alias: Averaged Positions, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_H_STDDEV (type: esriFieldTypeDouble, alias: Standard Deviation (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Field (type: esriFieldTypeInteger, alias: Field, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AuxValveNum (type: esriFieldTypeSmallInteger, alias: AuxValve#, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BarrelDiameter (type: esriFieldTypeSmallInteger, alias: BarrelDiameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SeatDiameter (type: esriFieldTypeSmallInteger, alias: SeatDiameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Elevation (type: esriFieldTypeSmallInteger, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LocationDescription (type: esriFieldTypeString, alias: LocationDescription, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• Roation (type: esriFieldTypeSmallInteger, alias: Roation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HydrantID (type: esriFieldTypeSmallInteger, alias: HydrantID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Availablefireflow (type: esriFieldTypeSmallInteger, alias: Availablefireflow, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Flag (type: esriFieldTypeString, alias: Flag, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Cond_Rating (type: esriFieldTypeSmallInteger, alias: Rating, SQL Type: sqlTypeOther, nullable: true, editable: true)
• L_Hose_Nozzle (type: esriFieldTypeSingle, alias: L_Hose_Nozzle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• R_Hose_Nozzle (type: esriFieldTypeSingle, alias: R_Hose_Nozzle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pumper_Nozzle (type: esriFieldTypeSingle, alias: Pumper_Nozzle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Static_Pressure_PSI (type: esriFieldTypeSmallInteger, alias: Static_Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Flow_GPM (type: esriFieldTypeSmallInteger, alias: Flow_GPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Residual_Pressure_PSI (type: esriFieldTypeSmallInteger, alias: Residual_Pressure_PSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pitot_Test (type: esriFieldTypeSmallInteger, alias: Pitot_Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPM_20PSI (type: esriFieldTypeSmallInteger, alias: GPM_20PSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AssetName (type: esriFieldTypeString, alias: Asset Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HydrantID1 (type: esriFieldTypeSmallInteger, alias: HydrantID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pumper_Nozzle1 (type: esriFieldTypeSingle, alias: Pumper_Nozzle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pressure_PSI (type: esriFieldTypeSmallInteger, alias: Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Flow_GPM1 (type: esriFieldTypeSmallInteger, alias: Flow_GPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ID (type: esriFieldTypeInteger, alias: ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NWS_ADDRESS_ID (type: esriFieldTypeInteger, alias: NWS_ADDRESS_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NWS_HYDRANT_id (type: esriFieldTypeInteger, alias: NWS_HYDRANT_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NWS_HYDRANT_NUMBER (type: esriFieldTypeString, alias: NWS_HYDRANT_NUMBER, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• NWS_HYDRANT_LOCATIONDESCRIPT (type: esriFieldTypeString, alias: NWS_HYDRANT_LOCATIONDESCRIPTION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NWS_HYDRANT_SERIAL_NUMBER (type: esriFieldTypeString, alias: NWS_HYDRANT_SERIAL_NUMBER, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• NWS_HYDRANT_IN_SERVICE (type: esriFieldTypeString, alias: NWS_HYDRANT_IN_SERVICE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
• NWS_HYDRANT_COLOR (type: esriFieldTypeString, alias: NWS_HYDRANT_COLOR, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [RED: Red], [BLUE: Blue], [BLACK: Black], ... 2 more ...)
• GISOWNERSHIP (type: esriFieldTypeString, alias: GISOWNERSHIP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SizeofSteamerPort (type: esriFieldTypeDouble, alias: Size of Steamer Port (in.), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4.5: 4.5], [5.25: 5.25])
• MainSize (type: esriFieldTypeDouble, alias: Main Size (in.), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [4: 4], [6: 6], ... 4 more ...)
• ManufactureDate (type: esriFieldTypeDate, alias: Manufacture Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Templates:

Name: FireHydrant
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• assettype: 0
• secondarydiameter: 0
• designtype: 0
• presentstatus: 3
• ownedby: 1
• maintby: 1
• symbolrotation: 0
• lifecyclestatus: 0
• Roation: 0
• Cond_Rating: 3

Relationships:

• GeneralInspection (0) -- Related To: Inspection Records (6)
• (1) -- Related To: Flow Test Records (5)
• Residual (2) -- Related To: Residual (7)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/15/2026 3:48:01 PM

Schema Last Edit Date: 4/15/2026 3:48:01 PM

Data Last Edit Date: 5/13/2026 6:53:03 PM

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