Layer: Water Pressurized Main (ID:21)

View In: Map Viewer

Name: Water Pressurized Main

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: A pressurized main is a type of main line that is pressurized. PressurizedMain is a concrete class. There are numerous types of PressurizedMains in the water distribution model; they include AirRelease, BlowOff, Bypass, ChemicalInjection, DistributionMain, Interconnect, ipeBridge, SamplingStation, and TransmissionMain. Transmission mains are large-diameter pipelines (24" or larger) that carry large quantities of raw water long distances from their source to a water treatment plant, then to the distribution grid system. Transmission mains generally run in a rather straight line from point to point. Lateral lines are not attached to transmission mains. Distribution mains are average-diameter pipes (4"–20") that transport potable water from transmission lines and redistribute it throughout an area. Lateral lines attach directly to distribution mains.

Copyright Text: City of Prince George

Min. Scale: 75000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[140,140,140,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpression":"[Diameter]","labelPlacement":"esriServerLinePlacementCenterAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","useClippedGeometry":true,"stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":2500,"name":"Default","priority":28,"symbol":{"type":"esriTS","color":[0,38,115,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1,"font":{"family":"Tahoma","size":8,"style":"normal","weight":"normal","decoration":"none"}}}]}
HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

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)
material (type: esriFieldTypeSmallInteger, alias: Material, SQL Type: sqlTypeOther, nullable: true, editable: true)
groundtype (type: esriFieldTypeSmallInteger, alias: GroundType, SQL Type: sqlTypeOther, nullable: true, editable: true)
exteriorcoating (type: esriFieldTypeString, alias: ExteriorCoating, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
liningtype (type: esriFieldTypeString, alias: LiningType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
roughness (type: esriFieldTypeDouble, alias: Roughness, SQL Type: sqlTypeOther, nullable: true, editable: true)
diameter (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0 mm], [10: 10 mm], [13: 13 mm], ... 71 more ...)
depth (type: esriFieldTypeDouble, alias: Depth, SQL Type: sqlTypeOther, 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 ...)
ISCONNECTED (type: esriFieldTypeSmallInteger, alias: Is connected, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True], [2: Unknown])
FROMDEVICETERMINAL (type: esriFieldTypeSmallInteger, alias: From device terminal, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Single Terminal], [2: High Pressure In], ... 15 more ...)
TODEVICETERMINAL (type: esriFieldTypeSmallInteger, alias: To device terminal, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Single Terminal], [2: High Pressure In], ... 15 more ...)
FLOWDIRECTION (type: esriFieldTypeSmallInteger, alias: Flow direction, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: With digitized], [2: Against digitized], [3: Indeterminate])
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)
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 ...)
notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
measuredlength (type: esriFieldTypeDouble, alias: Measured Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
adddetails (type: esriFieldTypeSmallInteger, alias: Additional Details, SQL Type: sqlTypeOther, 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)
cpoverride (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Override, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Traceable], [2: Not Traceable])
designtype (type: esriFieldTypeSmallInteger, alias: Water Type, SQL Type: sqlTypeOther, 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 ...)
parcelid (type: esriFieldTypeString, alias: Parcel ID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
pressurezone (type: esriFieldTypeString, alias: Pressure Zone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [PZ 01: PZ 01], [PZ 02: PZ 02], [PZ 03: PZ 03], ... 18 more ...)
criticalcustomer (type: esriFieldTypeSmallInteger, alias: Critical Customer, SQL Type: sqlTypeOther, nullable: true, editable: true)
liningdate (type: esriFieldTypeDate, alias: Lining Date, SQL Type: sqlTypeOther, length: 8, 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)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

enabled: 1
subtype: 8
lifecyclestatus: ACT
ASSETGROUP: 0
ASSETTYPE: 0
ASSOCIATIONSTATUS: 0
ISCONNECTED: 2
FROMDEVICETERMINAL: 0
TODEVICETERMINAL: 0
FLOWDIRECTION: 1
VALIDATIONSTATUS: 6
cpsubnetworkname: Unknown
SUPPORTEDSUBNETWORKNAME: Unknown
SUPPORTINGSUBNETWORKNAME: Unknown
SystemSubnetworkName: Unknown
PressureSubnetworkName: Unknown
IsolationSubnetworkName: Unknown
DMASubnetworkName: Unknown
cptraceability: 0

enabled: 1
subtype: 1
lifecyclestatus: ACT
ASSETGROUP: 0
ASSETTYPE: 0
ASSOCIATIONSTATUS: 0
ISCONNECTED: 2
FROMDEVICETERMINAL: 0
TODEVICETERMINAL: 0
FLOWDIRECTION: 1
VALIDATIONSTATUS: 6
cpsubnetworkname: Unknown
SUPPORTEDSUBNETWORKNAME: Unknown
SUPPORTINGSUBNETWORKNAME: Unknown
SystemSubnetworkName: Unknown
PressureSubnetworkName: Unknown
IsolationSubnetworkName: Unknown
DMASubnetworkName: Unknown
cptraceability: 0

enabled: 1
subtype: 2
lifecyclestatus: ACT
ASSETGROUP: 0
ASSETTYPE: 0
ASSOCIATIONSTATUS: 0
ISCONNECTED: 2
FROMDEVICETERMINAL: 0
TODEVICETERMINAL: 0
FLOWDIRECTION: 1
VALIDATIONSTATUS: 6
cpsubnetworkname: Unknown
SUPPORTEDSUBNETWORKNAME: Unknown
SUPPORTINGSUBNETWORKNAME: Unknown
SystemSubnetworkName: Unknown
PressureSubnetworkName: Unknown
IsolationSubnetworkName: Unknown
DMASubnetworkName: Unknown
cptraceability: 0

enabled: 1
subtype: 3
lifecyclestatus: ACT
ASSETGROUP: 0
ASSETTYPE: 0
ASSOCIATIONSTATUS: 0
ISCONNECTED: 2
FROMDEVICETERMINAL: 0
TODEVICETERMINAL: 0
FLOWDIRECTION: 1
VALIDATIONSTATUS: 6
cpsubnetworkname: Unknown
SUPPORTEDSUBNETWORKNAME: Unknown
SUPPORTINGSUBNETWORKNAME: Unknown
SystemSubnetworkName: Unknown
PressureSubnetworkName: Unknown
IsolationSubnetworkName: Unknown
DMASubnetworkName: Unknown
cptraceability: 0

enabled: 1
subtype: 5
lifecyclestatus: ACT
ASSETGROUP: 0
ASSETTYPE: 0
ASSOCIATIONSTATUS: 0
ISCONNECTED: 2
FROMDEVICETERMINAL: 0
TODEVICETERMINAL: 0
FLOWDIRECTION: 1
VALIDATIONSTATUS: 6
cpsubnetworkname: Unknown
SUPPORTEDSUBNETWORKNAME: Unknown
SUPPORTINGSUBNETWORKNAME: Unknown
SystemSubnetworkName: Unknown
PressureSubnetworkName: Unknown
IsolationSubnetworkName: Unknown
DMASubnetworkName: Unknown
cptraceability: 0

enabled: 1
subtype: 4
lifecyclestatus: ACT
ASSETGROUP: 0
ASSETTYPE: 0
ASSOCIATIONSTATUS: 0
ISCONNECTED: 2
FROMDEVICETERMINAL: 0
TODEVICETERMINAL: 0
FLOWDIRECTION: 1
VALIDATIONSTATUS: 6
cpsubnetworkname: Unknown
SUPPORTEDSUBNETWORKNAME: Unknown
SUPPORTINGSUBNETWORKNAME: Unknown
SystemSubnetworkName: Unknown
PressureSubnetworkName: Unknown
IsolationSubnetworkName: Unknown
DMASubnetworkName: Unknown
cptraceability: 0

enabled: 1
subtype: 6
lifecyclestatus: ACT
ASSETGROUP: 0
ASSETTYPE: 0
ASSOCIATIONSTATUS: 0
ISCONNECTED: 2
FROMDEVICETERMINAL: 0
TODEVICETERMINAL: 0
FLOWDIRECTION: 1
VALIDATIONSTATUS: 6
cpsubnetworkname: Unknown
SUPPORTEDSUBNETWORKNAME: Unknown
SUPPORTINGSUBNETWORKNAME: Unknown
SystemSubnetworkName: Unknown
PressureSubnetworkName: Unknown
IsolationSubnetworkName: Unknown
DMASubnetworkName: Unknown
cptraceability: 0

enabled: 1
subtype: 7
lifecyclestatus: ACT
ASSETGROUP: 0
ASSETTYPE: 0
ASSOCIATIONSTATUS: 0
ISCONNECTED: 2
FROMDEVICETERMINAL: 0
TODEVICETERMINAL: 0
FLOWDIRECTION: 1
VALIDATIONSTATUS: 6
cpsubnetworkname: Unknown
SUPPORTEDSUBNETWORKNAME: Unknown
SUPPORTINGSUBNETWORKNAME: Unknown
SystemSubnetworkName: Unknown
PressureSubnetworkName: Unknown
IsolationSubnetworkName: Unknown
DMASubnetworkName: Unknown
cptraceability: 0

enabled: 1
subtype: 9
lifecyclestatus: ACT
diameter: 50
ASSETGROUP: 0
ASSETTYPE: 0
ASSOCIATIONSTATUS: 0
ISCONNECTED: 2
FROMDEVICETERMINAL: 0
TODEVICETERMINAL: 0
FLOWDIRECTION: 1
VALIDATIONSTATUS: 6
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:24:23 AM

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

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