View In:   ArcGIS Online Map Viewer

Name: Water System Hydrant

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 474075fb90a545ae80ce641350fa6551

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 9027.977411

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -8638363.782959446
YMin: 4502191.987617946
XMax: -8614649.125043834
YMax: 4523542.046032752
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: HydrantOwnership
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label:
UniqueValueInfos:
• Value: Chesterfield
  Label: Chesterfield Owned
  Description: N/A
  Symbol:
  
• Value: City
  Label: City Owned
  Description: N/A
  Symbol:
  
• Value: Henrico
  Label: Henrico Owned
  Description: N/A
  Symbol:
  
• Value: Private
  Label: Independently Owned
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: HydrantOwnership

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AssetID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AssetID )
• EditBy ( type: esriFieldTypeString, alias: Edit By, editable: false, nullable: true, length: 30, defaultValue: null, modelName: EditBy )
• EditDate ( type: esriFieldTypeDate, alias: Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• HydrantStatus ( type: esriFieldTypeString, alias: Hydrant Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: HydrantStatus , Coded Values: [In Service: In Service] , [Out of Service: Out of Service] , [Unknown: Unknown] )
• LifeCycleStatus ( type: esriFieldTypeString, alias: Life Cycle Status, editable: true, nullable: true, length: 35, defaultValue: null, modelName: LifeCycleStatus , Coded Values: [Active: Active] , [Inactive: Inactive] , [Proposed: Proposed] , ...5 more... )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• InstallContractor ( type: esriFieldTypeString, alias: Install Contractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InstallContractor , Coded Values: [AMERICAN INFRUSTRUCTURE: AMERICAN INFRUSTRUCTURE] , [CITY OF RICHMOND: CITY OF RICHMOND] , [CITY OF RICHMOND/HENKELS & MCCOY: CITY OF RICHMOND/HENKELS & MCCOY] , ...74 more... )
• ConstructionInspector ( type: esriFieldTypeString, alias: Construction Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ConstructionInspector , Coded Values: [ANTONIO TONY PYZOWSKI: ANTONIO TONY PYZOWSKI] , [BILLY OVERMAN: BILLY OVERMAN] , [BRADLEY JOHNSON: BRADLEY JOHNSON] , ...103 more... )
• WorkOrderNumber ( type: esriFieldTypeString, alias: Work Order Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WorkOrderNumber )
• ConstructionDrawing ( type: esriFieldTypeString, alias: Construction Drawing, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ConstructionDrawing )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• FieldComments ( type: esriFieldTypeString, alias: FieldComments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FieldComments )
• SymbolRotation ( type: esriFieldTypeDouble, alias: Symbol Rotation, editable: true, nullable: true, defaultValue: null, modelName: SymbolRotation )
• UIDTagOnHydrant ( type: esriFieldTypeString, alias: UID Tag On Hydrant, editable: true, nullable: true, length: 10, defaultValue: No, modelName: UIDTagOnHydrant , Coded Values: [No: No] , [Unknown: Unknown] , [Yes: Yes] )
• HydrantBarrelSize ( type: esriFieldTypeDouble, alias: Hydrant Barrel Size, editable: true, nullable: true, defaultValue: null, modelName: HydrantBarrelSize , Coded Values: [4.5: 4 1/2"] , [5: 5"] , [5.5: 5 1/2"] , ...1 more... )
• ValveDistance ( type: esriFieldTypeDouble, alias: Valve Distance, editable: true, nullable: true, defaultValue: null, modelName: ValveDistance )
• PressureZone ( type: esriFieldTypeString, alias: Pressure Zone Area Name, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PressureZone , Coded Values: [1 NORTH: 1 NORTH] , [1 SOUTH: 1 SOUTH] , [2 NORTH: 2 NORTH] , ...10 more... )
• MainSize ( type: esriFieldTypeDouble, alias: Main Size, editable: true, nullable: true, defaultValue: null, modelName: MainSize , Coded Values: [0: Unknown] , [2: 2"] , [3: 3"] , ...15 more... )
• CapColor ( type: esriFieldTypeString, alias: Cap Color, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CapColor , Coded Values: [Gold: Gold] , [Green: Green] , [Red: Red] , ...3 more... )
• TestStaticPressure ( type: esriFieldTypeDouble, alias: Test Static Pressure, editable: true, nullable: true, defaultValue: null, modelName: TestStaticPressure )
• TestResidualPressure ( type: esriFieldTypeDouble, alias: Test Residual Pressure, editable: true, nullable: true, defaultValue: null, modelName: TestResidualPressure )
• TestHydrant1 ( type: esriFieldTypeString, alias: Test Hydrant 1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TestHydrant1 )
• TestHydrant1AssetID ( type: esriFieldTypeString, alias: Test Hydrant 1 Asset ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TestHydrant1AssetID )
• Flow1 ( type: esriFieldTypeDouble, alias: Flow 1, editable: true, nullable: true, defaultValue: null, modelName: Flow1 )
• TestHydrant2 ( type: esriFieldTypeString, alias: Test Hydrant 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TestHydrant2 )
• TestHydrant2AssetID ( type: esriFieldTypeString, alias: Test Hydrant 2 Asset ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TestHydrant2AssetID )
• Flow2 ( type: esriFieldTypeDouble, alias: Flow 2, editable: true, nullable: true, defaultValue: null, modelName: Flow2 )
• TestHydrant3 ( type: esriFieldTypeString, alias: Test Hydrant 3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TestHydrant3 )
• TestHydrant3AssetID ( type: esriFieldTypeString, alias: Test Hydrant 3 Asset ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TestHydrant3AssetID )
• Flow3 ( type: esriFieldTypeDouble, alias: Flow 3, editable: true, nullable: true, defaultValue: null, modelName: Flow3 )
• TestFlow ( type: esriFieldTypeDouble, alias: Test Flow, editable: true, nullable: true, defaultValue: null, modelName: TestFlow )
• TestPersonnel ( type: esriFieldTypeString, alias: Test Personnel, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TestPersonnel , Coded Values: [Billy Overman: Billy Overman] , [Billy Purdy Jr: Billy Purdy Jr] , [Bobby Masopust: Bobby Masopust] , ...68 more... )
• TestDate ( type: esriFieldTypeDate, alias: Test Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TestDate )
• TestTime ( type: esriFieldTypeSmallInteger, alias: Test Time, editable: true, nullable: true, defaultValue: null, modelName: TestTime )
• AvailableFireFlow ( type: esriFieldTypeDouble, alias: Available Fire Flow, editable: true, nullable: true, defaultValue: null, modelName: AvailableFireFlow )
• NozzelElevation ( type: esriFieldTypeDouble, alias: Nozzel Elevation, editable: true, nullable: true, defaultValue: null, modelName: NozzelElevation )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Manufacturer , Coded Values: [American: American] , [AP Smith: AP Smith] , [Clow: Clow] , ...12 more... )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Model , Coded Values: [107: 107] , [Centurion: Centurion] , [Clow: Clow] , ...9 more... )
• VandalGuard ( type: esriFieldTypeString, alias: Vandal Guard, editable: true, nullable: true, length: 10, defaultValue: null, modelName: VandalGuard , Coded Values: [No: No] , [Yes: Yes] )
• BlueReflectorInstalled ( type: esriFieldTypeString, alias: Blue Reflector Installed, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BlueReflectorInstalled , Coded Values: [No: No] , [Unknown: Unknown] , [Yes: Yes] )
• LastServiceDate ( type: esriFieldTypeDate, alias: Last Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastServiceDate )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• AncillaryRole ( type: esriFieldTypeSmallInteger, alias: AncillaryRole, editable: true, nullable: true, defaultValue: 0, modelName: AncillaryRole , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• WaterTraceWeight ( type: esriFieldTypeInteger, alias: WaterTraceWeight, editable: true, nullable: true, defaultValue: null, modelName: WaterTraceWeight )
• WaterPressureSystemStatus ( type: esriFieldTypeString, alias: WaterPressureSystemStatus, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WaterPressureSystemStatus , Coded Values: [N: Not a Boundary] , [Y: Boundary] )
• WaterSystemStatus ( type: esriFieldTypeString, alias: WaterSystemStatus, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WaterSystemStatus , Coded Values: [N: Not a Boundary] , [Y: Boundary] )
• HANDLE ( type: esriFieldTypeString, alias: HANDLE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HANDLE )
• HydrantOwnership ( type: esriFieldTypeString, alias: HydrantOwnership, editable: true, nullable: true, length: 20, defaultValue: City, modelName: HydrantOwnership , Coded Values: [Chesterfield: Chesterfield Owned] , [City: City Owned] , [Henrico: Henrico Owned] , ...1 more... )
• Hydrant_Address ( type: esriFieldTypeString, alias: Hydrant_Address, editable: true, nullable: true, length: 80, defaultValue: null, modelName: Hydrant_Address )
• Turn_Direction ( type: esriFieldTypeString, alias: Turn_Direction, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Turn_Direction )
• Comments_H ( type: esriFieldTypeString, alias: Comments_H, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Comments_H )
• GPSX ( type: esriFieldTypeDouble, alias: GPS X, editable: true, nullable: true, defaultValue: null, modelName: GPSX )
• GPSY ( type: esriFieldTypeDouble, alias: GPS Y, editable: true, nullable: true, defaultValue: null, modelName: GPSY )
• GPSZ ( type: esriFieldTypeDouble, alias: GPS Z, editable: true, nullable: true, defaultValue: null, modelName: GPSZ )
• GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GlobalID )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• Criticality ( type: esriFieldTypeSmallInteger, alias: Criticality, editable: true, nullable: true, defaultValue: null, modelName: Criticality , Coded Values: [1: Low Criticality] , [3: Medium Criticality] , [5: High Criticality] )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Location )
• GridNum ( type: esriFieldTypeString, alias: GridNum, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GridNum )
• CreatedBy ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 30, defaultValue: null, modelName: CreatedBy )
• CreatedDate ( type: esriFieldTypeDate, alias: Created Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreatedDate )
• InServiceDate ( type: esriFieldTypeDate, alias: In Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InServiceDate )
• AbandonedDate ( type: esriFieldTypeDate, alias: Abandoned Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AbandonedDate )
• ManufactureDate ( type: esriFieldTypeDate, alias: Manufacture Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ManufactureDate )

Types:

ID: Chesterfield
Name: Chesterfield Owned
Domains:
• HydrantStatus:
  Inherited
• LifeCycleStatus:
  Inherited
• InstallContractor:
  Inherited
• ConstructionInspector:
  Inherited
• UIDTagOnHydrant:
  Inherited
• HydrantBarrelSize:
  Inherited
• PressureZone:
  Inherited
• MainSize:
  Inherited
• CapColor:
  Inherited
• TestPersonnel:
  Inherited
• Manufacturer:
  Inherited
• Model:
  Inherited
• VandalGuard:
  Inherited
• BlueReflectorInstalled:
  Inherited
• Enabled:
  Inherited
• AncillaryRole:
  Inherited
• WaterPressureSystemStatus:
  Inherited
• WaterSystemStatus:
  Inherited
• HydrantOwnership:
  Inherited
• Criticality:
  Inherited
Templates:
• Name: Chesterfield Owned
  Description:
  Prototype:
  AncillaryRole: 0
  Enabled: 1
  UIDTagOnHydrant: No
  HydrantOwnership: Chesterfield
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: City
Name: City Owned
Domains:
• HydrantStatus:
  Inherited
• LifeCycleStatus:
  Inherited
• InstallContractor:
  Inherited
• ConstructionInspector:
  Inherited
• UIDTagOnHydrant:
  Inherited
• HydrantBarrelSize:
  Inherited
• PressureZone:
  Inherited
• MainSize:
  Inherited
• CapColor:
  Inherited
• TestPersonnel:
  Inherited
• Manufacturer:
  Inherited
• Model:
  Inherited
• VandalGuard:
  Inherited
• BlueReflectorInstalled:
  Inherited
• Enabled:
  Inherited
• AncillaryRole:
  Inherited
• WaterPressureSystemStatus:
  Inherited
• WaterSystemStatus:
  Inherited
• HydrantOwnership:
  Inherited
• Criticality:
  Inherited
Templates:
• Name: City Owned
  Description:
  Prototype:
  AncillaryRole: 0
  Enabled: 1
  UIDTagOnHydrant: No
  HydrantOwnership: City
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Henrico
Name: Henrico Owned
Domains:
• HydrantStatus:
  Inherited
• LifeCycleStatus:
  Inherited
• InstallContractor:
  Inherited
• ConstructionInspector:
  Inherited
• UIDTagOnHydrant:
  Inherited
• HydrantBarrelSize:
  Inherited
• PressureZone:
  Inherited
• MainSize:
  Inherited
• CapColor:
  Inherited
• TestPersonnel:
  Inherited
• Manufacturer:
  Inherited
• Model:
  Inherited
• VandalGuard:
  Inherited
• BlueReflectorInstalled:
  Inherited
• Enabled:
  Inherited
• AncillaryRole:
  Inherited
• WaterPressureSystemStatus:
  Inherited
• WaterSystemStatus:
  Inherited
• HydrantOwnership:
  Inherited
• Criticality:
  Inherited
Templates:
• Name: Henrico Owned
  Description:
  Prototype:
  AncillaryRole: 0
  Enabled: 1
  UIDTagOnHydrant: No
  HydrantOwnership: Henrico
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Private
Name: Independently Owned
Domains:
• HydrantStatus:
  Inherited
• LifeCycleStatus:
  Inherited
• InstallContractor:
  Inherited
• ConstructionInspector:
  Inherited
• UIDTagOnHydrant:
  Inherited
• HydrantBarrelSize:
  Inherited
• PressureZone:
  Inherited
• MainSize:
  Inherited
• CapColor:
  Inherited
• TestPersonnel:
  Inherited
• Manufacturer:
  Inherited
• Model:
  Inherited
• VandalGuard:
  Inherited
• BlueReflectorInstalled:
  Inherited
• Enabled:
  Inherited
• AncillaryRole:
  Inherited
• WaterPressureSystemStatus:
  Inherited
• WaterSystemStatus:
  Inherited
• HydrantOwnership:
  Inherited
• Criticality:
  Inherited
Templates:
• Name: Independently Owned
  Description:
  Prototype:
  AncillaryRole: 0
  Enabled: 1
  UIDTagOnHydrant: No
  HydrantOwnership: Private
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CreatedDate
• Creator Field: CreatedBy
• Edit Date Field: EditDate
• Editor Field: EditBy

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata