Name: Hydrants

Display Field: ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: A point feature class of the firehydrants on UNC's campus. The layer is reviewed and maintained by OWASA.

Service Item Id: d9ded6996515456ca9144bfd954cdb19

Copyright Text: OWASA

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 7200.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1928167.0450000018
YMin: 768131.0450000018
XMax: 2001261.5006249994
YMax: 811179.9912499934
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Ownership
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: OWASA
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Private
  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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: ASSETGROUP

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• ASSETGROUP ( type: esriFieldTypeInteger, alias: Asset group )
• ASSETTYPE ( type: esriFieldTypeSmallInteger, alias: Asset type )
• assetid ( type: esriFieldTypeString, alias: Asset ID, length: 64 )
• diameter ( type: esriFieldTypeDouble, alias: Diameter )
• ValveSize ( type: esriFieldTypeDouble, alias: Valve Size , Coded Values: [0: UNK] , [4: 4"] , [6: 6"] , ...17 more... )
• secondarydiameter ( type: esriFieldTypeDouble, alias: Nozzle Diameter )
• Install_Date ( type: esriFieldTypeDate, alias: Install_Date, length: 8 )
• additionaldetails ( type: esriFieldTypeSmallInteger, alias: Turn Open Direction )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [2: Private] , [100: Other] , [1: OWASA] , ...1 more... )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By , Coded Values: [2: Private] , [100: Other] , [1: OWASA] , ...1 more... )
• ManufacturerYear ( type: esriFieldTypeString, alias: Manufacturer Year, length: 8 )
• operable ( type: esriFieldTypeSmallInteger, alias: Operable , Coded Values: [0: False] , [1: True] )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status , Coded Values: [0: UNK] , [1: Proposed] , [2: Approved] , ...14 more... )
• Municipality ( type: esriFieldTypeSmallInteger, alias: Municipality )
• notes ( type: esriFieldTypeString, alias: Notes, length: 2000 )
• Latitude ( type: esriFieldTypeDouble, alias: Lat )
• Longitude ( type: esriFieldTypeDouble, alias: Long )
• ASSOCIATIONSTATUS ( type: esriFieldTypeSmallInteger, alias: Association status , Coded Values: [0: None] , [1: Container] , [2: Structure] , ...33 more... )
• ISSUBNETWORKCONTROLLER ( type: esriFieldTypeSmallInteger, alias: Is subnetwork controller , Coded Values: [0: False] , [1: True] )
• ISCONNECTED ( type: esriFieldTypeSmallInteger, alias: Is connected , Coded Values: [0: False] , [1: True] , [2: Unknown] )
• SUBNETWORKCONTROLLERNAME ( type: esriFieldTypeString, alias: Subnetwork controller name, length: 2000 )
• TIERNAME ( type: esriFieldTypeSmallInteger, alias: Tier name , Coded Values: [0: Unknown] , [1: Water System] , [2: Water Pressure] , ...2 more... )
• TIERRANK ( type: esriFieldTypeInteger, alias: Tier rank )
• TERMINALCONFIGURATION ( type: esriFieldTypeString, alias: Terminal path, length: 128 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: Global ID, length: 38 )
• SystemSubnetworkName ( type: esriFieldTypeString, alias: System Subnetwork Name, length: 2000 )
• SUPPORTEDSUBNETWORKNAME ( type: esriFieldTypeString, alias: Supported subnetwork name, length: 2000 )
• SUPPORTINGSUBNETWORKNAME ( type: esriFieldTypeString, alias: Supporting subnetwork name, length: 2000 )
• PressureSubnetworkName ( type: esriFieldTypeString, alias: Pressure Subnetwork Name, length: 2000 )
• IsolationSubnetworkName ( type: esriFieldTypeString, alias: Isolation Subnetwork Name, length: 2000 )
• DMASubnetworkName ( type: esriFieldTypeString, alias: DMA Subnetwork Name, length: 2000 )
• Service_Address ( type: esriFieldTypeString, alias: Service_Address, length: 125 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• VALIDATIONSTATUS ( type: esriFieldTypeSmallInteger, alias: Validation status , Coded Values: [0: No calculation required, no validation required, no error] , [1: No calculation required, no validation required, has error(s)] , [2: No calculation required, validation required, no error] , ...5 more... )

Types:

ID: 0
Name: Unknown
Domains:
• ASSETTYPE:
  Coded Values: [0: Unknown]
• ownedby:
  Inherited
• maintby:
  Inherited
• operable:
  Inherited
• ASSOCIATIONSTATUS:
  Inherited
• ISSUBNETWORKCONTROLLER:
  Inherited
• ISCONNECTED:
  Inherited
• TIERNAME:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

ID: 1
Name: Flow Valve
Domains:
• ASSETTYPE:
  Coded Values: [0: UNK] , [2: Altitude] , [3: Check]
• diameter:
  Coded Values: [0: UNK] , [0.5: 1/2"] , [0.75: 3/4"] , ...22 more...
• additionaldetails:
  Coded Values: [0: Counter Clockwise] , [1: Clockwise]
• ownedby:
  Inherited
• maintby:
  Inherited
• operable:
  Inherited
• lifecyclestatus:
  Coded Values: [0: UNK] , [1: Proposed] , [2: Approved] , ...7 more...
• ASSOCIATIONSTATUS:
  Inherited
• ISSUBNETWORKCONTROLLER:
  Inherited
• ISCONNECTED:
  Inherited
• TIERNAME:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

ID: 2
Name: System Valve
Domains:
• ASSETTYPE:
  Coded Values: [0: UNK] , [167: Isolation Zone] , [169: Supply] , ...4 more...
• diameter:
  Coded Values: [0: UNK] , [0.5: 1/2"] , [0.75: 3/4"] , ...22 more...
• additionaldetails:
  Coded Values: [0: Counter Clockwise] , [1: Clockwise]
• ownedby:
  Inherited
• maintby:
  Inherited
• operable:
  Inherited
• lifecyclestatus:
  Coded Values: [0: UNK] , [1: Proposed] , [2: Approved] , ...7 more...
• ASSOCIATIONSTATUS:
  Inherited
• ISSUBNETWORKCONTROLLER:
  Inherited
• ISCONNECTED:
  Inherited
• TIERNAME:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

ID: 3
Name: Pressure Valve
Domains:
• ASSETTYPE:
  Coded Values: [0: UNK] , [201: Combo Air\Vacuum] , [202: Air Release Valve] , ...1 more...
• diameter:
  Coded Values: [0: UNK] , [0.5: 1/2"] , [0.75: 3/4"] , ...22 more...
• additionaldetails:
  Coded Values: [0: Counter Clockwise] , [1: Clockwise]
• ownedby:
  Inherited
• maintby:
  Inherited
• operable:
  Inherited
• lifecyclestatus:
  Coded Values: [0: UNK] , [1: Proposed] , [2: Approved] , ...7 more...
• ASSOCIATIONSTATUS:
  Inherited
• ISSUBNETWORKCONTROLLER:
  Inherited
• ISCONNECTED:
  Inherited
• TIERNAME:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

ID: 4
Name: Station
Domains:
• ASSETTYPE:
  Coded Values: [0: UNK] , [241: Sample Station] , [242: Pump Station]
• ownedby:
  Inherited
• maintby:
  Inherited
• lifecyclestatus:
  Coded Values: [0: UNK] , [1: Proposed] , [2: Approved] , ...7 more...
• ASSOCIATIONSTATUS:
  Inherited
• ISSUBNETWORKCONTROLLER:
  Inherited
• ISCONNECTED:
  Inherited
• TIERNAME:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

ID: 5
Name: Pump
Domains:
• ASSETTYPE:
  Coded Values: [0: UNK] , [281: Booster] , [283: Primary]
• ownedby:
  Inherited
• maintby:
  Inherited
• lifecyclestatus:
  Coded Values: [0: UNK] , [1: Proposed] , [2: Approved] , ...7 more...
• ASSOCIATIONSTATUS:
  Inherited
• ISSUBNETWORKCONTROLLER:
  Inherited
• ISCONNECTED:
  Inherited
• TIERNAME:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

ID: 6
Name: Service Valve
Domains:
• ASSETTYPE:
  Coded Values: [0: UNK] , [164: Hydrant Gate] , [176: PIV] , ...1 more...
• diameter:
  Coded Values: [0: UNK] , [0.5: 1/2"] , [0.75: 3/4"] , ...22 more...
• additionaldetails:
  Coded Values: [0: Counter Clockwise] , [1: Clockwise]
• ownedby:
  Inherited
• maintby:
  Inherited
• operable:
  Inherited
• lifecyclestatus:
  Coded Values: [0: UNK] , [1: Proposed] , [2: Approved] , ...7 more...
• ASSOCIATIONSTATUS:
  Inherited
• ISSUBNETWORKCONTROLLER:
  Inherited
• ISCONNECTED:
  Inherited
• TIERNAME:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

ID: 7
Name: Fire Hydrant
Domains:
• ASSETTYPE:
  Coded Values: [0: UNK] , [321: Fire Hydrant]
• diameter:
  Coded Values: [0: UNK] , [0.5: 1/2"] , [0.75: 3/4"] , ...22 more...
• ValveSize:
  Coded Values: [4.5: 4 1/2"] , [5.25: 5 1/4"]
• secondarydiameter:
  Coded Values: [0: UNK] , [2.5: 2 1/2"] , [4.5: 4 1/2"] , ...1 more...
• additionaldetails:
  Coded Values: [0: Counter Clockwise] , [1: Clockwise]
• ownedby:
  Inherited
• maintby:
  Inherited
• Manufacturer:
  Coded Values: [CL: CLOW] , [AD: American Darling] , [MU: Mueller] , ...4 more...
• operable:
  Inherited
• lifecyclestatus:
  Coded Values: [0: UNK] , [1: Proposed] , [2: Approved] , ...7 more...
• Municipality:
  Coded Values: [1: Carborro] , [2: Chapel Hill] , [3: County]
• ASSOCIATIONSTATUS:
  Inherited
• ISSUBNETWORKCONTROLLER:
  Inherited
• ISCONNECTED:
  Inherited
• TIERNAME:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

ID: 8
Name: Outlet
Domains:
• ASSETTYPE:
  Coded Values: [0: UNK] , [642: Yard Hydrant]
• ownedby:
  Inherited
• maintby:
  Inherited
• operable:
  Inherited
• lifecyclestatus:
  Coded Values: [0: UNK] , [1: Proposed] , [2: Approved] , ...7 more...
• ASSOCIATIONSTATUS:
  Inherited
• ISSUBNETWORKCONTROLLER:
  Inherited
• ISCONNECTED:
  Inherited
• TIERNAME:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

ID: 9
Name: Flushing and Blow Off
Domains:
• ASSETTYPE:
  Coded Values: [0: UNK] , [361: Flushing Device] , [365: Blow Off Device]
• diameter:
  Coded Values: [0: UNK] , [0.5: 1/2"] , [0.75: 3/4"] , ...22 more...
• ownedby:
  Inherited
• maintby:
  Inherited
• operable:
  Inherited
• lifecyclestatus:
  Coded Values: [0: UNK] , [1: Proposed] , [2: Approved] , ...7 more...
• ASSOCIATIONSTATUS:
  Inherited
• ISSUBNETWORKCONTROLLER:
  Inherited
• ISCONNECTED:
  Inherited
• TIERNAME:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

ID: 10
Name: Service Meter
Domains:
• ASSETTYPE:
  Coded Values: [0: UNK] , [48: Domestic Meter] , [49: Irrigation Meter] , ...4 more...
• diameter:
  Coded Values: [0: UNK] , [0.75: 3/4"] , [1: 1"] , ...21 more...
• ownedby:
  Inherited
• maintby:
  Inherited
• operable:
  Inherited
• lifecyclestatus:
  Coded Values: [0: UNK] , [1: Proposed] , [2: Approved] , ...7 more...
• Municipality:
  Coded Values: [1: Carborro] , [2: Chapel Hill] , [3: County]
• ASSOCIATIONSTATUS:
  Inherited
• ISSUBNETWORKCONTROLLER:
  Inherited
• ISCONNECTED:
  Inherited
• TIERNAME:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

ID: 11
Name: Monitoring
Domains:
• ASSETTYPE:
  Coded Values: [0: UNK] , [22: Pressure Sensor]
• ownedby:
  Inherited
• maintby:
  Inherited
• operable:
  Inherited
• lifecyclestatus:
  Coded Values: [0: UNK] , [1: Proposed] , [2: Approved] , ...7 more...
• ASSOCIATIONSTATUS:
  Inherited
• ISSUBNETWORKCONTROLLER:
  Inherited
• ISCONNECTED:
  Inherited
• TIERNAME:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

ID: 13
Name: System Meter
Domains:
• ASSETTYPE:
  Coded Values: [0: UNK] , [41: Bulk] , [43: Interconnect Meter] , ...2 more...
• diameter:
  Coded Values: [0: UNK] , [0.75: 3/4"] , [1: 1"] , ...21 more...
• ownedby:
  Inherited
• maintby:
  Inherited
• operable:
  Inherited
• lifecyclestatus:
  Coded Values: [0: UNK] , [1: Proposed] , [2: Approved] , ...7 more...
• Municipality:
  Coded Values: [1: Carborro] , [2: Chapel Hill] , [3: County]
• ASSOCIATIONSTATUS:
  Inherited
• ISSUBNETWORKCONTROLLER:
  Inherited
• ISCONNECTED:
  Inherited
• TIERNAME:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

ID: 15
Name: Supply
Domains:
• ASSETTYPE:
  Coded Values: [0: UNK] , [601: Treatment Plant] , [602: Well]
• diameter:
  Coded Values: [0: UNK] , [10: 10"] , [14: 14"] , ...4 more...
• ownedby:
  Inherited
• maintby:
  Inherited
• operable:
  Inherited
• lifecyclestatus:
  Coded Values: [0: UNK] , [1: Proposed] , [2: Approved] , ...7 more...
• ASSOCIATIONSTATUS:
  Inherited
• ISSUBNETWORKCONTROLLER:
  Inherited
• ISCONNECTED:
  Inherited
• TIERNAME:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

ID: 18
Name: Controller
Domains:
• ASSETTYPE:
  Coded Values: [122: Operator Nut]
• ownedby:
  Inherited
• maintby:
  Inherited
• operable:
  Inherited
• lifecyclestatus:
  Coded Values: [0: UNK] , [1: Proposed] , [2: Approved] , ...7 more...
• ASSOCIATIONSTATUS:
  Inherited
• ISSUBNETWORKCONTROLLER:
  Inherited
• ISCONNECTED:
  Inherited
• TIERNAME:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

ID: 20
Name: Storage
Domains:
• ASSETTYPE:
  Coded Values: [0: UNK] , [563: Storage Tank]
• ownedby:
  Inherited
• maintby:
  Inherited
• operable:
  Inherited
• lifecyclestatus:
  Coded Values: [0: UNK] , [1: Proposed] , [2: Approved] , ...7 more...
• ASSOCIATIONSTATUS:
  Inherited
• ISSUBNETWORKCONTROLLER:
  Inherited
• ISCONNECTED:
  Inherited
• TIERNAME:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

ID: 14
Name: Backflow
Domains:
• ASSETTYPE:
  Coded Values: [0: Unknown] , [1: BackFlow]
• diameter:
  Coded Values: [0: UNK] , [0.5: 1/2"] , [0.75: 3/4"] , ...13 more...
• ownedby:
  Inherited
• maintby:
  Inherited
• operable:
  Inherited
• lifecyclestatus:
  Inherited
• ASSOCIATIONSTATUS:
  Inherited
• ISSUBNETWORKCONTROLLER:
  Inherited
• ISCONNECTED:
  Inherited
• TIERNAME:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata