View In:   ArcGIS Online 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.

Service Item Id: ff9ff6fae01941ad8372cae60efc252d

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 507516.8796510007
YMin: 5963081.985468999
XMax: 527591.9780260008
YMax: 5985543.660468999
Spatial Reference: 26910  (26910)  VCSWkid(5713)  LatestVCSWkid(5713)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SubType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 8
  Label: Air Release
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 93, 150, 255]
  Width: 1
• Value: 1
  Label: Blowoff
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 255, 255]
  Width: 1
• Value: 2
  Label: Bypass
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 3, 173, 255]
  Width: 1
• Value: 3
  Label: Chemical Injection
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [79, 0, 143, 255]
  Width: 1
• Value: 5
  Label: Distribution Main
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 255, 255]
  Width: 1
• Value: 4
  Label: Interconnect
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [54, 0, 161, 255]
  Width: 1
• Value: 6
  Label: Pipe Bridge
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [102, 153, 205, 255]
  Width: 2
• Value: 7
  Label: Sampling Station
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [28, 0, 168, 255]
  Width: 1
• Value: 9
  Label: Transmission Main
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [115, 178, 255, 255]
  Width: 2
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementCenterAlong
Label Expression: [Diameter]
Use Coded Values: true
Symbol:
Color: [0, 38, 115, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Tahoma
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 2500.0
Max. Scale: 0.0

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SubType

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AssetID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: AssetID )
• LifeCycleStatus ( type: esriFieldTypeString, alias: LifeCycleStatus, editable: true, nullable: true, length: 20, defaultValue: ACT, modelName: LifeCycleStatus , Coded Values: [PRP: Proposed] , [ACT: Active] , [ABN: Abandoned] , ...2 more... )
• SubType ( type: esriFieldTypeInteger, alias: SubType, editable: true, nullable: true, defaultValue: 1, modelName: SubType )
• AssetOwner ( type: esriFieldTypeSmallInteger, alias: Owner of the Asset, editable: true, nullable: true, defaultValue: null, modelName: AssetOwner , Coded Values: [1: CPG] , [-1: RDFFG] , [-2: Private] , ...3 more... )
• AssetManager ( type: esriFieldTypeSmallInteger, alias: Manager of the Asset, editable: true, nullable: true, defaultValue: null, modelName: AssetManager , Coded Values: [1: Asset] , [2: Bylaw] , [3: Civic Facility] , ...21 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Location )
• InstallDate ( type: esriFieldTypeDate, alias: InstallDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• RecordedLength ( type: esriFieldTypeDouble, alias: RecordedLength, editable: true, nullable: true, defaultValue: null, modelName: RecordedLength )
• InstallContractor ( type: esriFieldTypeString, alias: InstallContractor, editable: true, nullable: true, length: 60, defaultValue: null, modelName: InstallContractor )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Material , Coded Values: [UNK: Unknown] , [OTH: Other] , [DI: Ductile Iron] , ...12 more... )
• GroundType ( type: esriFieldTypeString, alias: GroundType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: GroundType , Coded Values: [UNK: Unknown] , [OTH: Other] , [D: Dirt] , ...3 more... )
• ExteriorCoating ( type: esriFieldTypeString, alias: ExteriorCoating, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ExteriorCoating , Coded Values: [UNK: Unknown] , [OTH: Other] , [TAR: Tar] , ...3 more... )
• JointType1 ( type: esriFieldTypeString, alias: JointType1, editable: true, nullable: true, length: 20, defaultValue: null, modelName: JointType1 , Coded Values: [Flange: Flange] , [Weld: Weld] , [Bond: Bond] , ...5 more... )
• JointType2 ( type: esriFieldTypeString, alias: JointType2, editable: true, nullable: true, length: 20, defaultValue: null, modelName: JointType2 , Coded Values: [Flange: Flange] , [Weld: Weld] , [Bond: Bond] , ...5 more... )
• LiningType ( type: esriFieldTypeString, alias: LiningType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LiningType )
• PipeClass ( type: esriFieldTypeString, alias: PipeClass, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PipeClass , Coded Values: [UNK: Unknown] , [OTH: Other] )
• Roughness ( type: esriFieldTypeDouble, alias: Roughness, editable: true, nullable: true, defaultValue: null, modelName: Roughness )
• Name ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 60, defaultValue: null, modelName: Name )
• Diameter ( type: esriFieldTypeInteger, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: Diameter , Coded Values: [0: 0 mm] , [10: 10 mm] , [20: 20 mm] , ...69 more... )
• Depth ( type: esriFieldTypeDouble, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: Depth )
• PressureRating ( type: esriFieldTypeInteger, alias: PressureRating, editable: true, nullable: true, defaultValue: null, modelName: PressureRating )
• PressureSystem ( type: esriFieldTypeString, alias: PressureSystem, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PressureSystem , Coded Values: [UNK: Unknown] , [OTH: Other] )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: 8
Name: watAirRelease
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• Material:
  Inherited
• GroundType:
  Inherited
• ExteriorCoating:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• LiningType:
  Coded Values: [UNK: Unknown] , [OTH: Other] , [CM: Cement-Mortar] , ...5 more...
• PipeClass:
  Inherited
• Diameter:
  Inherited
• PressureSystem:
  Inherited
Templates:
• Name: Air Release
  Description:
  Prototype:
  AssetID: null
  PressureRating: null
  LifeCycleStatus: ACT
  PressureSystem: null
  SubType: 8
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  RecordedLength: null
  InstallContractor: null
  Material: null
  GroundType: null
  ExteriorCoating: null
  JointType1: null
  JointType2: null
  LiningType: null
  PipeClass: null
  Roughness: null
  Name: null
  Diameter: null
  Depth: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 1
Name: watBlowoff
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• Material:
  Inherited
• GroundType:
  Inherited
• ExteriorCoating:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• LiningType:
  Coded Values: [UNK: Unknown] , [OTH: Other] , [CM: Cement-Mortar] , ...5 more...
• PipeClass:
  Inherited
• Diameter:
  Inherited
• PressureSystem:
  Inherited
Templates:
• Name: Blowoff
  Description:
  Prototype:
  AssetID: null
  PressureRating: null
  LifeCycleStatus: ACT
  PressureSystem: null
  SubType: 1
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  RecordedLength: null
  InstallContractor: null
  Material: null
  GroundType: null
  ExteriorCoating: null
  JointType1: null
  JointType2: null
  LiningType: null
  PipeClass: null
  Roughness: null
  Name: null
  Diameter: null
  Depth: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: watBypass
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• Material:
  Inherited
• GroundType:
  Inherited
• ExteriorCoating:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• LiningType:
  Coded Values: [UNK: Unknown] , [OTH: Other] , [CM: Cement-Mortar] , ...5 more...
• PipeClass:
  Inherited
• Diameter:
  Inherited
• PressureSystem:
  Inherited
Templates:
• Name: Bypass
  Description:
  Prototype:
  AssetID: null
  PressureRating: null
  LifeCycleStatus: ACT
  PressureSystem: null
  SubType: 2
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  RecordedLength: null
  InstallContractor: null
  Material: null
  GroundType: null
  ExteriorCoating: null
  JointType1: null
  JointType2: null
  LiningType: null
  PipeClass: null
  Roughness: null
  Name: null
  Diameter: null
  Depth: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 3
Name: watChemicalInjection
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• Material:
  Inherited
• GroundType:
  Inherited
• ExteriorCoating:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• LiningType:
  Coded Values: [UNK: Unknown] , [OTH: Other] , [CM: Cement-Mortar] , ...5 more...
• PipeClass:
  Inherited
• Diameter:
  Inherited
• PressureSystem:
  Inherited
Templates:
• Name: Chemical Injection
  Description:
  Prototype:
  AssetID: null
  PressureRating: null
  LifeCycleStatus: ACT
  PressureSystem: null
  SubType: 3
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  RecordedLength: null
  InstallContractor: null
  Material: null
  GroundType: null
  ExteriorCoating: null
  JointType1: null
  JointType2: null
  LiningType: null
  PipeClass: null
  Roughness: null
  Name: null
  Diameter: null
  Depth: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 5
Name: watDistributionMain
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• Material:
  Inherited
• GroundType:
  Inherited
• ExteriorCoating:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• LiningType:
  Coded Values: [UNK: Unknown] , [OTH: Other] , [CM: Cement-Mortar] , ...5 more...
• PipeClass:
  Inherited
• Diameter:
  Inherited
• PressureSystem:
  Inherited
Templates:
• Name: Distribution Main
  Description:
  Prototype:
  AssetID: null
  PressureRating: null
  LifeCycleStatus: ACT
  PressureSystem: null
  SubType: 5
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  RecordedLength: null
  InstallContractor: null
  Material: null
  GroundType: null
  ExteriorCoating: null
  JointType1: null
  JointType2: null
  LiningType: null
  PipeClass: null
  Roughness: null
  Name: null
  Diameter: null
  Depth: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 4
Name: watInterconnect
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• Material:
  Inherited
• GroundType:
  Inherited
• ExteriorCoating:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• LiningType:
  Coded Values: [UNK: Unknown] , [OTH: Other] , [CM: Cement-Mortar] , ...5 more...
• PipeClass:
  Inherited
• Diameter:
  Inherited
• PressureSystem:
  Inherited
Templates:
• Name: Interconnect
  Description:
  Prototype:
  AssetID: null
  PressureRating: null
  LifeCycleStatus: ACT
  PressureSystem: null
  SubType: 4
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  RecordedLength: null
  InstallContractor: null
  Material: null
  GroundType: null
  ExteriorCoating: null
  JointType1: null
  JointType2: null
  LiningType: null
  PipeClass: null
  Roughness: null
  Name: null
  Diameter: null
  Depth: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 6
Name: watPipeBridge
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• Material:
  Inherited
• GroundType:
  Inherited
• ExteriorCoating:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• LiningType:
  Coded Values: [UNK: Unknown] , [OTH: Other] , [CM: Cement-Mortar] , ...5 more...
• PipeClass:
  Inherited
• Diameter:
  Inherited
• PressureSystem:
  Inherited
Templates:
• Name: Pipe Bridge
  Description:
  Prototype:
  AssetID: null
  PressureRating: null
  LifeCycleStatus: ACT
  PressureSystem: null
  SubType: 6
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  RecordedLength: null
  InstallContractor: null
  Material: null
  GroundType: null
  ExteriorCoating: null
  JointType1: null
  JointType2: null
  LiningType: null
  PipeClass: null
  Roughness: null
  Name: null
  Diameter: null
  Depth: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 7
Name: watSamplingStation
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• Material:
  Inherited
• GroundType:
  Inherited
• ExteriorCoating:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• LiningType:
  Coded Values: [UNK: Unknown] , [OTH: Other] , [CM: Cement-Mortar] , ...5 more...
• PipeClass:
  Inherited
• Diameter:
  Inherited
• PressureSystem:
  Inherited
Templates:
• Name: Sampling Station
  Description:
  Prototype:
  AssetID: null
  PressureRating: null
  LifeCycleStatus: ACT
  PressureSystem: null
  SubType: 7
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  RecordedLength: null
  InstallContractor: null
  Material: null
  GroundType: null
  ExteriorCoating: null
  JointType1: null
  JointType2: null
  LiningType: null
  PipeClass: null
  Roughness: null
  Name: null
  Diameter: null
  Depth: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 9
Name: watTransmissionMain
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• Material:
  Inherited
• GroundType:
  Inherited
• ExteriorCoating:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• LiningType:
  Coded Values: [UNK: Unknown] , [OTH: Other] , [CM: Cement-Mortar] , ...5 more...
• PipeClass:
  Inherited
• Diameter:
  Inherited
• PressureSystem:
  Inherited
Templates:
• Name: Transmission Main
  Description:
  Prototype:
  AssetID: null
  PressureRating: null
  LifeCycleStatus: ACT
  Name: null
  PressureSystem: null
  SubType: 9
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  RecordedLength: null
  InstallContractor: null
  Material: null
  GroundType: null
  ExteriorCoating: null
  JointType1: null
  JointType2: null
  LiningType: null
  PipeClass: null
  Roughness: null
  Diameter: 50
  Depth: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports OidReservation: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata