View In:   ArcGIS Online Map Viewer

Name: Water Fitting

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The Fitting class represents the facility found at the joint between two lines where a transition of some sort must occur. In order to cut down on the number of network feature classes and improve geometric network performance, we have chosen to rely on subtypes here to differentiate the different types of fitting-related classes. Fitting types include Bend, Cap, Cross, Coupling, ExpansionJoint, Offset, Reducer, Riser, Saddle, Sleeve, Tap, Tee, Wye, and Weld.

Service Item Id: ff9ff6fae01941ad8372cae60efc252d

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.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: 507581.7468743648
YMin: 5963081.866207358
XMax: 527591.9885778404
YMax: 5985543.780179872
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: 1
  Label: Bend
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Cap
  Description: N/A
  Symbol:
  
• Value: 4
  Label: Coupling
  Description: N/A
  Symbol:
  
• Value: 3
  Label: Cross
  Description: N/A
  Symbol:
  
• Value: 5
  Label: Expansion Joint
  Description: N/A
  Symbol:
  
• Value: 6
  Label: Offset
  Description: N/A
  Symbol:
  
• Value: 7
  Label: Reducer
  Description: N/A
  Symbol:
  
• Value: 8
  Label: Riser
  Description: N/A
  Symbol:
  
• Value: 9
  Label: Saddle
  Description: N/A
  Symbol:
  
• Value: 10
  Label: Sleeve
  Description: N/A
  Symbol:
  
• Value: 11
  Label: Tap
  Description: N/A
  Symbol:
  
• Value: 12
  Label: Tee
  Description: N/A
  Symbol:
  
• Value: 13
  Label: Weld
  Description: N/A
  Symbol:
  
• Value: 14
  Label: Wye
  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: 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: 4, 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 )
• PressureSystem ( type: esriFieldTypeString, alias: PressureSystem, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PressureSystem , Coded Values: [UNK: Unknown] , [OTH: Other] )
• Elevation ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: Elevation )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Manufacturer )
• 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... )
• 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... )
• 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... )
• Angle ( type: esriFieldTypeDouble, alias: Angle, editable: true, nullable: true, defaultValue: null, modelName: Angle , Coded Values: [90: 90 Degree] , [45: 45 Degree] , [22.5: 22 1/2 Degree] , ...1 more... )
• Diameter1 ( type: esriFieldTypeInteger, alias: Diameter1, editable: true, nullable: true, defaultValue: null, modelName: Diameter1 , Coded Values: [0: 0 mm] , [10: 10 mm] , [20: 20 mm] , ...69 more... )
• Diameter2 ( type: esriFieldTypeInteger, alias: Diameter2, editable: true, nullable: true, defaultValue: null, modelName: Diameter2 , Coded Values: [0: 0 mm] , [10: 10 mm] , [20: 20 mm] , ...69 more... )
• Diameter3 ( type: esriFieldTypeInteger, alias: Diameter3, editable: true, nullable: true, defaultValue: null, modelName: Diameter3 , Coded Values: [0: 0 mm] , [10: 10 mm] , [20: 20 mm] , ...69 more... )
• Diameter4 ( type: esriFieldTypeInteger, alias: Diameter4, editable: true, nullable: true, defaultValue: null, modelName: Diameter4 , Coded Values: [0: 0 mm] , [10: 10 mm] , [20: 20 mm] , ...69 more... )
• DepthBuried ( type: esriFieldTypeDouble, alias: DepthBuried, editable: true, nullable: true, defaultValue: null, modelName: DepthBuried )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: 1
Name: watBend
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• PressureSystem:
  Inherited
• GroundType:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• Material:
  Inherited
• Angle:
  Inherited
• Diameter1:
  Inherited
• Diameter2:
  Inherited
• Diameter3:
  Inherited
• Diameter4:
  Inherited
Templates:
• Name: Bend
  Description:
  Prototype:
  Diameter4: null
  LifeCycleStatus: ACT
  DepthBuried: null
  AssetID: null
  SubType: 1
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  PressureSystem: null
  Elevation: null
  Manufacturer: null
  GroundType: null
  JointType1: null
  JointType2: null
  Material: null
  Angle: null
  Diameter1: null
  Diameter2: null
  Diameter3: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: watCap
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• PressureSystem:
  Inherited
• GroundType:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• Material:
  Inherited
• Angle:
  Inherited
• Diameter1:
  Inherited
• Diameter2:
  Inherited
• Diameter3:
  Inherited
• Diameter4:
  Inherited
Templates:
• Name: Cap
  Description:
  Prototype:
  Diameter4: null
  LifeCycleStatus: ACT
  DepthBuried: null
  AssetID: null
  SubType: 2
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  PressureSystem: null
  Elevation: null
  Manufacturer: null
  GroundType: null
  JointType1: null
  JointType2: null
  Material: null
  Angle: null
  Diameter1: null
  Diameter2: null
  Diameter3: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: watCoupling
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• PressureSystem:
  Inherited
• GroundType:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• Material:
  Inherited
• Angle:
  Inherited
• Diameter1:
  Inherited
• Diameter2:
  Inherited
• Diameter3:
  Inherited
• Diameter4:
  Inherited
Templates:
• Name: Coupling
  Description:
  Prototype:
  Diameter4: null
  LifeCycleStatus: ACT
  DepthBuried: null
  AssetID: null
  SubType: 4
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  PressureSystem: null
  Elevation: null
  Manufacturer: null
  GroundType: null
  JointType1: null
  JointType2: null
  Material: null
  Angle: null
  Diameter1: null
  Diameter2: null
  Diameter3: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: watCross
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• PressureSystem:
  Inherited
• GroundType:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• Material:
  Inherited
• Angle:
  Inherited
• Diameter1:
  Inherited
• Diameter2:
  Inherited
• Diameter3:
  Inherited
• Diameter4:
  Inherited
Templates:
• Name: Cross
  Description:
  Prototype:
  Diameter4: null
  LifeCycleStatus: ACT
  DepthBuried: null
  AssetID: null
  SubType: 3
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  PressureSystem: null
  Elevation: null
  Manufacturer: null
  GroundType: null
  JointType1: null
  JointType2: null
  Material: null
  Angle: null
  Diameter1: null
  Diameter2: null
  Diameter3: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: watExpansionJoint
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• PressureSystem:
  Inherited
• GroundType:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• Material:
  Inherited
• Angle:
  Inherited
• Diameter1:
  Inherited
• Diameter2:
  Inherited
• Diameter3:
  Inherited
• Diameter4:
  Inherited
Templates:
• Name: Expansion Joint
  Description:
  Prototype:
  Diameter4: null
  LifeCycleStatus: ACT
  DepthBuried: null
  AssetID: null
  SubType: 5
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  PressureSystem: null
  Elevation: null
  Manufacturer: null
  GroundType: null
  JointType1: null
  JointType2: null
  Material: null
  Angle: null
  Diameter1: null
  Diameter2: null
  Diameter3: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 6
Name: watOffset
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• PressureSystem:
  Inherited
• GroundType:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• Material:
  Inherited
• Angle:
  Inherited
• Diameter1:
  Inherited
• Diameter2:
  Inherited
• Diameter3:
  Inherited
• Diameter4:
  Inherited
Templates:
• Name: Offset
  Description:
  Prototype:
  Diameter4: null
  LifeCycleStatus: ACT
  DepthBuried: null
  AssetID: null
  SubType: 6
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  PressureSystem: null
  Elevation: null
  Manufacturer: null
  GroundType: null
  JointType1: null
  JointType2: null
  Material: null
  Angle: null
  Diameter1: null
  Diameter2: null
  Diameter3: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 7
Name: watReducer
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• PressureSystem:
  Inherited
• GroundType:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• Material:
  Inherited
• Angle:
  Inherited
• Diameter1:
  Inherited
• Diameter2:
  Inherited
• Diameter3:
  Inherited
• Diameter4:
  Inherited
Templates:
• Name: Reducer
  Description:
  Prototype:
  Diameter4: null
  LifeCycleStatus: ACT
  DepthBuried: null
  AssetID: null
  SubType: 7
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  PressureSystem: null
  Elevation: null
  Manufacturer: null
  GroundType: null
  JointType1: null
  JointType2: null
  Material: null
  Angle: null
  Diameter1: null
  Diameter2: null
  Diameter3: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 8
Name: watRiser
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• PressureSystem:
  Inherited
• GroundType:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• Material:
  Inherited
• Angle:
  Inherited
• Diameter1:
  Inherited
• Diameter2:
  Inherited
• Diameter3:
  Inherited
• Diameter4:
  Inherited
Templates:
• Name: Riser
  Description:
  Prototype:
  Diameter4: null
  LifeCycleStatus: ACT
  DepthBuried: null
  AssetID: null
  SubType: 8
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  PressureSystem: null
  Elevation: null
  Manufacturer: null
  GroundType: null
  JointType1: null
  JointType2: null
  Material: null
  Angle: null
  Diameter1: null
  Diameter2: null
  Diameter3: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 9
Name: watSaddle
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• PressureSystem:
  Inherited
• GroundType:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• Material:
  Inherited
• Angle:
  Inherited
• Diameter1:
  Inherited
• Diameter2:
  Inherited
• Diameter3:
  Inherited
• Diameter4:
  Inherited
Templates:
• Name: Saddle
  Description:
  Prototype:
  Diameter4: null
  LifeCycleStatus: ACT
  DepthBuried: null
  AssetID: null
  SubType: 9
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  PressureSystem: null
  Elevation: null
  Manufacturer: null
  GroundType: null
  JointType1: null
  JointType2: null
  Material: null
  Angle: null
  Diameter1: null
  Diameter2: null
  Diameter3: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 10
Name: watSleeve
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• PressureSystem:
  Inherited
• GroundType:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• Material:
  Inherited
• Angle:
  Inherited
• Diameter1:
  Inherited
• Diameter2:
  Inherited
• Diameter3:
  Inherited
• Diameter4:
  Inherited
Templates:
• Name: Sleeve
  Description:
  Prototype:
  Diameter4: null
  LifeCycleStatus: ACT
  DepthBuried: null
  AssetID: null
  SubType: 10
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  PressureSystem: null
  Elevation: null
  Manufacturer: null
  GroundType: null
  JointType1: null
  JointType2: null
  Material: null
  Angle: null
  Diameter1: null
  Diameter2: null
  Diameter3: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 11
Name: watTap
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• PressureSystem:
  Inherited
• GroundType:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• Material:
  Inherited
• Angle:
  Inherited
• Diameter1:
  Inherited
• Diameter2:
  Inherited
• Diameter3:
  Inherited
• Diameter4:
  Inherited
Templates:
• Name: Tap
  Description:
  Prototype:
  Diameter4: null
  LifeCycleStatus: ACT
  DepthBuried: null
  AssetID: null
  SubType: 11
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  PressureSystem: null
  Elevation: null
  Manufacturer: null
  GroundType: null
  JointType1: null
  JointType2: null
  Material: null
  Angle: null
  Diameter1: null
  Diameter2: null
  Diameter3: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 12
Name: watTee
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• PressureSystem:
  Inherited
• GroundType:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• Material:
  Inherited
• Angle:
  Inherited
• Diameter1:
  Inherited
• Diameter2:
  Inherited
• Diameter3:
  Inherited
• Diameter4:
  Inherited
Templates:
• Name: Tee
  Description:
  Prototype:
  Diameter4: null
  LifeCycleStatus: ACT
  DepthBuried: null
  AssetID: null
  SubType: 12
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  PressureSystem: null
  Elevation: null
  Manufacturer: null
  GroundType: null
  JointType1: null
  JointType2: null
  Material: null
  Angle: null
  Diameter1: null
  Diameter2: null
  Diameter3: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 13
Name: watWeld
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• PressureSystem:
  Inherited
• GroundType:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• Material:
  Inherited
• Angle:
  Inherited
• Diameter1:
  Inherited
• Diameter2:
  Inherited
• Diameter3:
  Inherited
• Diameter4:
  Inherited
Templates:
• Name: Weld
  Description:
  Prototype:
  Diameter4: null
  LifeCycleStatus: ACT
  DepthBuried: null
  AssetID: null
  SubType: 13
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  PressureSystem: null
  Elevation: null
  Manufacturer: null
  GroundType: null
  JointType1: null
  JointType2: null
  Material: null
  Angle: null
  Diameter1: null
  Diameter2: null
  Diameter3: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 14
Name: watWye
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• PressureSystem:
  Inherited
• GroundType:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• Material:
  Inherited
• Angle:
  Inherited
• Diameter1:
  Inherited
• Diameter2:
  Inherited
• Diameter3:
  Inherited
• Diameter4:
  Inherited
Templates:
• Name: Wye
  Description:
  Prototype:
  Diameter4: null
  LifeCycleStatus: ACT
  DepthBuried: null
  AssetID: null
  SubType: 14
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  PressureSystem: null
  Elevation: null
  Manufacturer: null
  GroundType: null
  JointType1: null
  JointType2: null
  Material: null
  Angle: null
  Diameter1: null
  Diameter2: null
  Diameter3: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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