Name: Water Pump

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: A pump is a facility that moves, compresses, or alters the pressure of a fluid, such as water or air, being conveyed through a natural or artificial channel. Pumps are also much like hydrants and meters Pump types include AxialFlow, Centrifugal, Jet, Reciprocating, Rotary, Screw, and Turbine.

Copyright Text: City of Prince George

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: 507516.8797
YMin: 5963510.4765
XMax: 515180.6005
YMax: 5981589.7848
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)
• totaldynamichead (type: esriFieldTypeInteger, alias: TotalDynamicHead, 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)
• diameter (type: esriFieldTypeDouble, alias: diameter: Diameter, Diameter 1, Height, Inlet Diameter, Pipe Diameter, Weight, SQL Type: sqlTypeOther, 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)
• groundtype (type: esriFieldTypeSmallInteger, alias: Ground Type, SQL Type: sqlTypeOther, 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)
• 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: Axial Flow
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• enabled: 1
• subtype: 6
• VALIDATIONSTATUS: 6
• 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
• cptraceability: 0
Name: Centrifugal
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• enabled: 1
• subtype: 1
• VALIDATIONSTATUS: 6
• 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
• cptraceability: 0
Name: Jet
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• enabled: 1
• subtype: 2
• VALIDATIONSTATUS: 6
• 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
• cptraceability: 0
Name: Reciprocating
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• enabled: 1
• subtype: 3
• VALIDATIONSTATUS: 6
• 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
• cptraceability: 0
Name: Rotary
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• enabled: 1
• subtype: 4
• VALIDATIONSTATUS: 6
• 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
• cptraceability: 0
Name: Turbine
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• enabled: 1
• subtype: 5
• VALIDATIONSTATUS: 6
• 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
• cptraceability: 0

Is Data Versioned: false

Has Contingent Values: true

Supports Rollback On Failure Parameter: true

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

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

Data Last Edit Date: 7/26/2025 3:23:56 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