Name: Water Control Valve

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This layer contains all Water Control Valves. Control valves are a set of valves that operate in special ways. There are three fundamental types of control valves: backflow control, air control, and altitude. A backflow control valve is a control valve designed to prevent water from flowing in the reverse direction. Essentially, backflow control valves allow flow in only one direction—the normal flow dirrection. Backflow control valves are open in the direction of normal flow and closed with the reversal of flow. Backflow control valves are commonly found near pump stations and reservoirs. Air control valves are control valves that are used to either relieve the system of trapped air or vacuums that may develop. Finally, an altitude valve is a control valve that controls water flow into a tower when the water level drops below a threshold. Altitude valves automatically shut off water flow when the water level in an elevated tank (or tower) reaches a preset elevation. A pressure reducing valve is a system valve with a horizontal disk for automatically reducing water pressures to a preset value. A pressure relief valve is a system valve that opens automatically when water pressure reaches a preset limit to relieve stress on a pipeline. Pressure relief valves are used to protect against rapid increases in pressure (i.e., water hammer). A pressure sustaining valve is a system valve that automatically sustains water pressures at a preset value. A pressure sustaining valve is similar to a pressure reducing valve but governs the pressure on the upstream rather than the downstream flow.Types of control valves represented include AirGap, AirControl, AirRelease, Altitude, BackflowControl, Combination, AtmosphericVacuum, DoubleCheck, PressureVacuum, ReducedPressureBackflow, RPZ, SimpleCheck, Vacuum, VacuumBreaker, and VacuumRelease.

Copyright Text: City of Prince George

Min. Scale: 100000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 507826.6548
YMin: 5963808.3667
XMax: 526931.9759
YMax: 5985438.3641
Spatial Reference: 26910 (26910)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,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: true

HasM: true

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:

• assetid (type: esriFieldTypeString, alias: AssetID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• installdate (type: esriFieldTypeDate, alias: InstallDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• lifecyclestatus (type: esriFieldTypeSmallInteger, alias: LifeCycleStatus, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 14 more ...)
• installcontractor (type: esriFieldTypeSmallInteger, alias: InstallContractor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• condition (type: esriFieldTypeDouble, alias: Condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
• conditiondate (type: esriFieldTypeDate, alias: ConditionDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• elevation (type: esriFieldTypeDouble, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• manufacturer (type: esriFieldTypeSmallInteger, alias: Manufacturer, SQL Type: sqlTypeOther, nullable: true, editable: true)
• diameter (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• groundtype (type: esriFieldTypeSmallInteger, alias: GroundType, SQL Type: sqlTypeOther, nullable: true, editable: true)
• model (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• serialnumber (type: esriFieldTypeString, alias: SerialNumber, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• acquisitioncost (type: esriFieldTypeDouble, alias: AcquisitionCost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• expectedlife (type: esriFieldTypeDouble, alias: ExpectedLife, SQL Type: sqlTypeOther, nullable: true, editable: true)
• residualvalue (type: esriFieldTypeDouble, alias: ResidualValue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• cofscore (type: esriFieldTypeDouble, alias: CoFScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cofdate (type: esriFieldTypeDate, alias: CoFDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• riskscore (type: esriFieldTypeDouble, alias: RiskScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
• link (type: esriFieldTypeString, alias: Link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ASSETGROUP (type: esriFieldTypeInteger, alias: Asset group, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASSETTYPE (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASSOCIATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Association status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Container], [2: Structure], ... 33 more ...)
• ISSUBNETWORKCONTROLLER (type: esriFieldTypeSmallInteger, alias: Is subnetwork controller, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• ISCONNECTED (type: esriFieldTypeSmallInteger, alias: Is connected, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True], [2: Unknown])
• SUBNETWORKCONTROLLERNAME (type: esriFieldTypeString, alias: Subnetwork controller name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• TIERNAME (type: esriFieldTypeSmallInteger, alias: Tier name, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Water Cathodic Protection], [2: Water System], ... 3 more ...)
• TIERRANK (type: esriFieldTypeInteger, alias: Tier rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TERMINALCONFIGURATION (type: esriFieldTypeString, alias: Terminal path, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• cpsubnetworkname (type: esriFieldTypeString, alias: CP Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• SUPPORTEDSUBNETWORKNAME (type: esriFieldTypeString, alias: Supported subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• SUPPORTINGSUBNETWORKNAME (type: esriFieldTypeString, alias: Supporting subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• SystemSubnetworkName (type: esriFieldTypeString, alias: System Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• PressureSubnetworkName (type: esriFieldTypeString, alias: Pressure Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• IsolationSubnetworkName (type: esriFieldTypeString, alias: Isolation Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• DMASubnetworkName (type: esriFieldTypeString, alias: DMA Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• creationdate (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lastupdate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• updatedby (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• secondarydiameter (type: esriFieldTypeDouble, alias: secondarydiameter: Diameter 2, Nozzle Diameter, Outlet Diameter, Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pressure (type: esriFieldTypeDouble, alias: pressure: Amperage, Pressure, Rated Pressure, Volume, SQL Type: sqlTypeOther, nullable: true, editable: true)
• designtype (type: esriFieldTypeSmallInteger, alias: designtype: Anode Count, Design Type, Manufacturer, Pump Type, Test Wire Count, Valve Type, Wire Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• normalstatus (type: esriFieldTypeSmallInteger, alias: Normal Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Closed], [1: Open])
• presentstatus (type: esriFieldTypeSmallInteger, alias: Present Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Closed], [1: Open])
• additionaldetails (type: esriFieldTypeSmallInteger, alias: additionaldetails: Clockwise to Close, Cooling Method, Critical, Material, SQL Type: sqlTypeOther, nullable: true, editable: true)
• designinfo (type: esriFieldTypeDouble, alias: designinfo: Anode Depth, Rated Flow, Turns to Close, Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• operable (type: esriFieldTypeSmallInteger, alias: Operable, SQL Type: sqlTypeOther, nullable: true, editable: true)
• name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• accountid (type: esriFieldTypeString, alias: Account ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: CPG], [-1: RDFFG], [-2: Private], ... 3 more ...)
• maintby (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Asset], [2: Bylaw], [3: Civic Facility], ... 21 more ...)
• additionaldevice (type: esriFieldTypeSmallInteger, alias: additionaldevice: Additional Device, Has Bypass, Internal Meter, Metered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• 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)
• bondedinsulated (type: esriFieldTypeSmallInteger, alias: Bonded/Insulated, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Bonded], [2: Insulated])
• cptraceability (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Traceability, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• inservicedate (type: esriFieldTypeDate, alias: In-Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• retireddate (type: esriFieldTypeDate, alias: Retired Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• spatialsource (type: esriFieldTypeSmallInteger, alias: Spatial Source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: As-Built], [2: CAD], ... 3 more ...)
• spatialconfidence (type: esriFieldTypeSmallInteger, alias: Spatial Confidence, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: High], [2: Medium], ... 1 more ...)
• cpoverride (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Override, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Traceable], [2: Not Traceable])
• operator (type: esriFieldTypeSmallInteger, alias: Postindicator Valve, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pressurezone (type: esriFieldTypeString, alias: Pressure Zone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• source (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• overflowelev (type: esriFieldTypeDouble, alias: Overflow Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• nozzlediameter2 (type: esriFieldTypeDouble, alias: Nozzle Diameter 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• nozzlediameter3 (type: esriFieldTypeDouble, alias: Nozzle Diameter 3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• nozzlediameter4 (type: esriFieldTypeDouble, alias: Nozzle Diameter 4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• seatdiameter (type: esriFieldTypeDouble, alias: Seat Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• markertype (type: esriFieldTypeSmallInteger, alias: Marker Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• designflow (type: esriFieldTypeString, alias: Design Flow, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• bottomelev (type: esriFieldTypeDouble, alias: Elevation at Bottom, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pressurerange (type: esriFieldTypeString, alias: Pressure Range, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• pressuresettingus (type: esriFieldTypeDouble, alias: Pressure Setting Upstream, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pressuresettingds (type: esriFieldTypeDouble, alias: Pressure Setting Downstream, SQL Type: sqlTypeOther, nullable: true, editable: true)
• totaldynamichead (type: esriFieldTypeInteger, alias: Total Dynamic Head, SQL Type: sqlTypeOther, nullable: true, editable: true)
• depth (type: esriFieldTypeDouble, alias: Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• percentopen (type: esriFieldTypeInteger, alias: Percent Open, SQL Type: sqlTypeOther, nullable: true, editable: true)
• currentvalue (type: esriFieldTypeString, alias: Current Value, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• id (type: esriFieldTypeString, alias: ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• measurementtype (type: esriFieldTypeString, alias: Measurement Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: Parent Global ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• VALIDATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Validation status, SQL Type: sqlTypeOther, nullable: true, editable: true)
• subtypetext (type: esriFieldTypeString, alias: Subtype Text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: Water Control Valve
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• VALIDATIONSTATUS: 6
• lifecyclestatus: 0
• ASSETGROUP: 0
• ASSETTYPE: 0
• ASSOCIATIONSTATUS: 0
• ISSUBNETWORKCONTROLLER: 0
• ISCONNECTED: 2
• SUBNETWORKCONTROLLERNAME: Unknown
• TIERNAME: 0
• TIERRANK: 0
• TERMINALCONFIGURATION: Default
• cpsubnetworkname: Unknown
• SUPPORTEDSUBNETWORKNAME: Unknown
• SUPPORTINGSUBNETWORKNAME: Unknown
• SystemSubnetworkName: Unknown
• PressureSubnetworkName: Unknown
• IsolationSubnetworkName: Unknown
• DMASubnetworkName: Unknown
• ownedby: 1
• maintby: 1
• cptraceability: 0

Is Data Versioned: false

Has Contingent Values: true

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/26/2025 3:23:36 AM

Schema Last Edit Date: 7/26/2025 3:23:36 AM

Data Last Edit Date: 7/26/2025 3:23:36 AM

Child Resources:   Field Groups   Contingent Values

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