View In:   ArcGIS Online Map Viewer

Name: Water Lateral Line

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: A lateral line is a small-diameter pipe that runs from the main to the customer premises. The Types of lateral lines are; DomesticFireCommercialIrrigationIndustrialHydrantLine

Service Item Id: ff9ff6fae01941ad8372cae60efc252d

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 4513.988705

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: 507609.3431510003
YMin: 5963598.066718999
XMax: 527588.2782760002
YMax: 5985498.311469
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: 3
  Label: Commercial
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 76, 115, 255]
  Width: 1
• Value: 1
  Label: Domestic
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [0, 77, 168, 255]
  Width: 1
• Value: 2
  Label: Fire
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [224, 170, 15, 255]
  Width: 1
• Value: 6
  Label: HydrantLine
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [102, 153, 205, 255]
  Width: 1
• Value: 5
  Label: Industrial
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 77, 168, 255]
  Width: 2
• Value: 4
  Label: Irrigation
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [68, 79, 137, 255]
  Width: 1
• Value: 7
  Label: Blowoff
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [178, 129, 227, 255]
  Width: 1
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: 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 )
• 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... )
• Diameter ( type: esriFieldTypeInteger, alias: Diameter, editable: true, nullable: true, defaultValue: 50, modelName: Diameter , Coded Values: [0: 0 mm] , [10: 10 mm] , [20: 20 mm] , ...68 more... )
• GroundType ( type: esriFieldTypeString, alias: GroundType, editable: true, nullable: true, length: 20, defaultValue: UNK, modelName: GroundType , Coded Values: [UNK: Unknown] , [OTH: Other] , [D: Dirt] , ...3 more... )
• ConnectionType ( type: esriFieldTypeString, alias: ConnectionType, editable: true, nullable: true, length: 20, defaultValue: UNK, modelName: ConnectionType , Coded Values: [UNK: Unknown] , [OTH: Other] , [TAP: Tap] , ...1 more... )
• DepthBuried ( type: esriFieldTypeDouble, alias: DepthBuried, editable: true, nullable: true, defaultValue: null, modelName: DepthBuried )
• PositionAtMain ( type: esriFieldTypeDouble, alias: PositionAtMain, editable: true, nullable: true, defaultValue: null, modelName: PositionAtMain )
• 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: 3
Name: watCommercial
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• Material:
  Inherited
• Diameter:
  Inherited
• GroundType:
  Inherited
• ConnectionType:
  Inherited
Templates:
• Name: Commercial
  Description:
  Prototype:
  Diameter: 50
  AssetID: null
  GroundType: UNK
  ConnectionType: UNK
  DepthBuried: null
  LifeCycleStatus: ACT
  Material: null
  PositionAtMain: null
  SubType: 3
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 1
Name: watDomestic
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• Material:
  Inherited
• Diameter:
  Inherited
• GroundType:
  Inherited
• ConnectionType:
  Inherited
Templates:
• Name: Domestic
  Description:
  Prototype:
  Diameter: 50
  AssetID: null
  GroundType: UNK
  ConnectionType: UNK
  DepthBuried: null
  LifeCycleStatus: ACT
  Material: null
  PositionAtMain: null
  SubType: 1
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: watFire
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• Material:
  Inherited
• Diameter:
  Inherited
• GroundType:
  Inherited
• ConnectionType:
  Inherited
Templates:
• Name: Fire
  Description:
  Prototype:
  Diameter: 50
  AssetID: null
  GroundType: UNK
  ConnectionType: UNK
  DepthBuried: null
  LifeCycleStatus: ACT
  Material: null
  PositionAtMain: null
  SubType: 2
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 6
Name: watHydrantLine
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• Material:
  Inherited
• Diameter:
  Inherited
• GroundType:
  Inherited
• ConnectionType:
  Inherited
Templates:
• Name: HydrantLine
  Description:
  Prototype:
  Diameter: 50
  AssetID: null
  GroundType: UNK
  ConnectionType: UNK
  DepthBuried: null
  LifeCycleStatus: ACT
  Material: null
  PositionAtMain: null
  SubType: 6
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 5
Name: watIndustrial
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• Material:
  Inherited
• Diameter:
  Inherited
• GroundType:
  Inherited
• ConnectionType:
  Inherited
Templates:
• Name: Industrial
  Description:
  Prototype:
  Diameter: 50
  AssetID: null
  GroundType: UNK
  ConnectionType: UNK
  DepthBuried: null
  LifeCycleStatus: ACT
  Material: null
  PositionAtMain: null
  SubType: 5
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 4
Name: watIrrigation
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• Material:
  Inherited
• Diameter:
  Inherited
• GroundType:
  Inherited
• ConnectionType:
  Inherited
Templates:
• Name: Irrigation
  Description:
  Prototype:
  Diameter: 50
  AssetID: null
  GroundType: UNK
  ConnectionType: UNK
  DepthBuried: null
  LifeCycleStatus: ACT
  Material: null
  PositionAtMain: null
  SubType: 4
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 7
Name: watBlowoff
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• Material:
  Inherited
• Diameter:
  Inherited
• GroundType:
  Inherited
• ConnectionType:
  Inherited
Templates:
• Name: watBlowoff
  Description:
  Prototype:
  DepthBuried: null
  PositionAtMain: null
  AssetID: null
  LifeCycleStatus: ACT
  SubType: 7
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  Material: null
  Diameter: 50
  GroundType: UNK
  ConnectionType: UNK
  
  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