Name: Hydrants
Display Field: FACILITYID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: false
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -8096417.8666774
YMin: 5172798.57209369
XMax: -8081003.37289692
YMax: 5185482.01589161
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":null}},"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:
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: Facility ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Abandoned: Abandoned], [Active: Active], [Does Not Exist: Does Not Exist], ... 5 more ...)
- MANUFACTURER (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AMERICAN: AMERICAN], [AVK: AVK], [CHAP: CHAPMAN], ... 8 more ...)
- OWNER (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- FABRICATIONDATE (type: esriFieldTypeInteger, alias: Fabrication Date (yyyy), SQL Type: sqlTypeOther, nullable: true, editable: true)
- OPERATIONDATE (type: esriFieldTypeDate, alias: Operation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- HYDRANTTURNS (type: esriFieldTypeSmallInteger, alias: Hydrant Turns, SQL Type: sqlTypeOther, nullable: true, editable: true)
- STATICPRESSURE (type: esriFieldTypeSmallInteger, alias: Static Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
- OBSERVEDFLOW (type: esriFieldTypeInteger, alias: Observed Flow, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AVERAGEFLOW (type: esriFieldTypeInteger, alias: Average Flow, SQL Type: sqlTypeOther, nullable: true, editable: true)
- VALVESIZE (type: esriFieldTypeSingle, alias: Valve Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
- BREAKAWAY (type: esriFieldTypeString, alias: Breakaway?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- SOURCEMAINDIAM (type: esriFieldTypeString, alias: Source Main Diameter, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- SURFACECOVER (type: esriFieldTypeString, alias: Surface Cover, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Brick: Brick], [Concrete: Concrete], ... 5 more ...)
- NOZZLE1SIZE (type: esriFieldTypeString, alias: Nozzle 1 Size, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [2.5: 2.5], [4.5: 4.5], [OTH: OTHER], ... 1 more ...)
- NOZZLE1COND (type: esriFieldTypeString, alias: Nozzle 1 Condition, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [DMG: DAMAGED], [GOOD: GOOD], [LEAKS: LEAKS], ... 1 more ...)
- NOZZLE2SIZE (type: esriFieldTypeString, alias: Nozzle 2 Size, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [2.5: 2.5], [4.5: 4.5], [OTH: OTHER], ... 1 more ...)
- NOZZLE2COND (type: esriFieldTypeString, alias: Nozzle 2 Condition, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [DMG: DAMAGED], [GOOD: GOOD], [LEAKS: LEAKS], ... 1 more ...)
- NOZZLE3SIZE (type: esriFieldTypeString, alias: Nozzle 3 Size, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [2.5: 2.5], [4.5: 4.5], [OTH: OTHER], ... 1 more ...)
- NOZZLE3COND (type: esriFieldTypeString, alias: Nozzle 3 Condition, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [DMG: DAMAGED], [GOOD: GOOD], [LEAKS: LEAKS], ... 1 more ...)
- S123CONDITION (type: esriFieldTypeString, alias: S123 Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- S123LASTINSPECTDATE (type: esriFieldTypeDate, alias: S123 Last Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- LASTEDITDATE (type: esriFieldTypeString, alias: Last Edit Date (yyyymmdd), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- LASTEDITORG (type: esriFieldTypeString, alias: Last Edit Name of Organization, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- LASTEDITSOURCE (type: esriFieldTypeString, alias: Last Edit Source, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [FIELD: Derived from field observations], [FIELD BOOK: Digitized from a field book page], [GPS: Global Positioning System], ... 14 more ...)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- LASTEDITUSER (type: esriFieldTypeString, alias: Last Edited User, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- S123SYMBOLOGY (type: esriFieldTypeInteger, alias: S123 Symbology, SQL Type: sqlTypeOther, nullable: true, editable: true)
- S123OID (type: esriFieldTypeInteger, alias: S123 Object ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- S123ATTID (type: esriFieldTypeInteger, alias: S123 Attachment ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- assetLocationROW (type: esriFieldTypeString, alias: Asset Location ROW, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- FIELDVERIFIED (type: esriFieldTypeString, alias: Field Verified?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Could Not Locate: Could Not Locate], ... 1 more ...)
- FIELDVERIFIEDDATE (type: esriFieldTypeDate, alias: Field Verified Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- GISADMINUPDATENOTES (type: esriFieldTypeString, alias: GIS Admin Update Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- hydrantBootSize (type: esriFieldTypeInteger, alias: Hydrant Boot Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: 2"], [4: 4"], [6: 6"], ... 3 more ...)
- ESRIGNSS_POSITIONSOURCETYPE (type: esriFieldTypeSmallInteger, alias: Position source type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: User defined], [2: Integrated (System) Location Provider], ... 3 more ...)
- ESRIGNSS_RECEIVER (type: esriFieldTypeString, alias: Receiver Name, SQL Type: sqlTypeOther, length: 50, 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_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_FIXDATETIME (type: esriFieldTypeDate, alias: Fix Time, SQL Type: sqlTypeOther, length: 8, 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_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_DIRECTION (type: esriFieldTypeDouble, alias: Direction of travel (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_SPEED (type: esriFieldTypeDouble, alias: Speed (km/h), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRISNSR_AZIMUTH (type: esriFieldTypeDouble, alias: Compass reading (°), SQL Type: sqlTypeOther, 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)
- TIEFILE (type: esriFieldTypeString, alias: Tie File with extension, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- REALID (type: esriFieldTypeString, alias: REALID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ZoneID (type: esriFieldTypeInteger, alias: ZoneID, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: Hydrants
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 1/5/2026 6:11:21 PM
Schema Last Edit Date: 1/5/2026 6:11:21 PM
Data Last Edit Date: 1/5/2026 6:11:21 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat