Name: wHydrant

Display Field: CreatedBy

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: -13077860.6046361
YMin: 4031360.22126159
XMax: -13063391.5212206
YMax: 4056124.56618053
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[122,58,153,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)
• 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])
• CreatedBy (type: esriFieldTypeString, alias: CreatedBy, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreatedDate (type: esriFieldTypeDate, alias: CreatedDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LastEditor (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LastUpdate (type: esriFieldTypeDate, alias: Last Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FacilityID (type: esriFieldTypeString, alias: FacilityID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LegacyID (type: esriFieldTypeString, alias: LegacyID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WaterType (type: esriFieldTypeString, alias: WaterType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Potable: Potable Water], [Raw: Raw Water], [Reclaimed: Reclaimed Water])
• DataSource (type: esriFieldTypeString, alias: DataSource, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AM: Atlas Map], [AB: As-Built], [AP: Aerial Photo], ... 6 more ...)
• ProjectNumber (type: esriFieldTypeString, alias: ProjectNumber, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• InstallYear (type: esriFieldTypeInteger, alias: InstallYear, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LifecycleStatus (type: esriFieldTypeString, alias: LifecycleStatus, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [ACT: Active], [INA: Inactive], [PRO: Proposed], ... 3 more ...)
• OwnedBy (type: esriFieldTypeString, alias: OwnedBy, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [WVWD: WVWD], [OTHA: Other Agency], [PRIV: Private], ... 1 more ...)
• MaintainedBy (type: esriFieldTypeString, alias: MaintainedBy, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [WVWD: WVWD], [OTHA: Other Agency], [PRIV: Private], ... 1 more ...)
• SymbolRotation (type: esriFieldTypeDouble, alias: SymbolRotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPS_X (type: esriFieldTypeDouble, alias: GPS_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPS_Y (type: esriFieldTypeDouble, alias: GPS_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPS_Z (type: esriFieldTypeDouble, alias: GPS_Z, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PressureZone (type: esriFieldTypeString, alias: PressureZone, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true, Coded Values: [2: Zone 2], [OTH: Other], [UNK: Unknown], ... 7 more ...)
• HydrantType (type: esriFieldTypeString, alias: HydrantType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Wharf: Wharf], [Standard: Standard], [Super: Super])
• Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CLW: Clow], [JJC: James Jones Company], [MC: Mueller Company], ... 1 more ...)
• Diameter (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OutletConfiguration (type: esriFieldTypeString, alias: OutletConfiguration, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• StaticPressure_psi (type: esriFieldTypeInteger, alias: StaticPressure_psi, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ResidualPressure_psi (type: esriFieldTypeInteger, alias: ResidualPressure_psi, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LastFlushedDate (type: esriFieldTypeDate, alias: LastFlushedDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Barrel_Type (type: esriFieldTypeString, alias: Barrel_Type, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Dry: Dry], [Wet: Wet], [Unknown: Unknown])
• AtlasMapNumber (type: esriFieldTypeString, alias: AtlasMapNumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WorkOrder (type: esriFieldTypeString, alias: WorkOrder, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MapGrid (type: esriFieldTypeString, alias: MapGrid, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ValveNumber (type: esriFieldTypeString, alias: ValveNumber, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• GPMValue (type: esriFieldTypeString, alias: GPMValue, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• DeadEnd (type: esriFieldTypeSmallInteger, alias: DeadEnd, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])

Templates:

Name: wHydrant
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• DeadEnd: 0
• Enabled: 1
• WaterType: Potable
• DataSource: AM
• LifecycleStatus: ACT
• OwnedBy: WVWD
• MaintainedBy: WVWD
• HydrantType: Standard
• Manufacturer: CLW
• Diameter: 6
• OutletConfiguration: 4"x2.5"
• Barrel_Type: Wet

Relationships:

• wHydrantActivity (11) -- Related To: wHydrantActivity (62)
• wHydrantActivity (12) -- Related To: wHydrantActivity (63)
• wHydrantActivity (13) -- Related To: wHydrantActivity (64)
• wHydrantActivity (14) -- Related To: wHydrantActivity (65)
• wHydrantActivity (15) -- Related To: wHydrantActivity (71)
• wHydrantFlowTesting (16) -- Related To: wHydrantFlowTest (61)
• wHydrantFlowTesting (17) -- Related To: wHydrantFlowTest (73)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/24/2025 3:47:29 AM

Schema Last Edit Date: 11/24/2025 3:47:29 AM

Data Last Edit Date: 11/24/2025 3:47:29 AM

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