Name: Water Lateral Line

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 7e40f59d04004c398f12f69471ca77ae

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 311813.61763499986
YMin: 5770735.9559349995
XMax: 720045.2868650004
YMax: 6178967.625165001
Spatial Reference: 26910  (26910)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ASSETTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 12
  Label: Commercial
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 76, 115, 255]
  Width: 1
• Value: 11
  Label: Domestic
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 77, 168, 255]
  Width: 1
• Value: 14
  Label: Fire
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [224, 170, 15, 255]
  Width: 1
• Value: 15
  Label: HydrantLine
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [102, 153, 205, 255]
  Width: 1
• Value: 13
  Label: Industrial
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 77, 168, 255]
  Width: 2
• Value: 16
  Label: Irrigation
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [68, 79, 137, 255]
  Width: 1
• Value: 18
  Label: Blow Off
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [180, 130, 228, 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: false
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: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ASSETGROUP

Fields:

• ASSETGROUP ( type: esriFieldTypeInteger, alias: Asset group )
• ASSETTYPE ( type: esriFieldTypeSmallInteger, alias: Asset type )
• ASSOCIATIONSTATUS ( type: esriFieldTypeSmallInteger, alias: Association status , Coded Values: [0: None] , [1: Container] , [2: Structure] , ...33 more... )
• ISCONNECTED ( type: esriFieldTypeSmallInteger, alias: Is connected , Coded Values: [0: False] , [1: True] , [2: Unknown] )
• FROMDEVICETERMINAL ( type: esriFieldTypeSmallInteger, alias: From device terminal , Coded Values: [0: None] , [1: Single Terminal] , [2: High Pressure In] , ...15 more... )
• TODEVICETERMINAL ( type: esriFieldTypeSmallInteger, alias: To device terminal , Coded Values: [0: None] , [1: Single Terminal] , [2: High Pressure In] , ...15 more... )
• FLOWDIRECTION ( type: esriFieldTypeSmallInteger, alias: Flow direction , Coded Values: [1: With digitized] , [2: Against digitized] , [3: Indeterminate] )
• cpsubnetworkname ( type: esriFieldTypeString, alias: CP Subnetwork Name, length: 2000 )
• SUPPORTEDSUBNETWORKNAME ( type: esriFieldTypeString, alias: Supported subnetwork name, length: 2000 )
• SUPPORTINGSUBNETWORKNAME ( type: esriFieldTypeString, alias: Supporting subnetwork name, length: 2000 )
• SystemSubnetworkName ( type: esriFieldTypeString, alias: System Subnetwork Name, length: 2000 )
• PressureSubnetworkName ( type: esriFieldTypeString, alias: Pressure Subnetwork Name, length: 2000 )
• creationdate ( type: esriFieldTypeDate, alias: Creation date, length: 8 )
• creator ( type: esriFieldTypeString, alias: Creator, length: 255 )
• lastupdate ( type: esriFieldTypeDate, alias: Last update, length: 8 )
• updatedby ( type: esriFieldTypeString, alias: Updated by, length: 255 )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [1: CPG] , [-1: RDFFG] , [-2: Private] , ...3 more... )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By , Coded Values: [1: Asset] , [2: Bylaw] , [3: Civic Facility] , ...21 more... )
• notes ( type: esriFieldTypeString, alias: Notes, length: 2000 )
• measuredlength ( type: esriFieldTypeDouble, alias: Measured Length )
• adddetails ( type: esriFieldTypeSmallInteger, alias: adddetails: Color Code, Tracer Wire )
• bondedinsulated ( type: esriFieldTypeSmallInteger, alias: Bonded/Insulated , Coded Values: [1: Bonded] , [2: Insulated] )
• cptraceability ( type: esriFieldTypeSmallInteger, alias: Cathodic Protection Traceability , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• inservicedate ( type: esriFieldTypeDate, alias: In-Service Date, length: 8 )
• retireddate ( type: esriFieldTypeDate, alias: Retired Date, length: 8 )
• cpoverride ( type: esriFieldTypeSmallInteger, alias: Cathodic Protection Override , Coded Values: [1: Traceable] , [2: Not Traceable] )
• designtype ( type: esriFieldTypeSmallInteger, alias: Water Type )
• spatialsource ( type: esriFieldTypeSmallInteger, alias: Spatial Source , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more... )
• spatialconfidence ( type: esriFieldTypeSmallInteger, alias: Spatial Confidence , Coded Values: [0: Unknown] , [1: High] , [2: Medium] , ...1 more... )
• pressurezone ( type: esriFieldTypeString, alias: Pressure Zone, length: 20 , Coded Values: [PZ 01: PZ 01] , [PZ 02: PZ 02] , [PZ 03: PZ 03] , ...18 more... )
• depth ( type: esriFieldTypeDouble, alias: Depth )
• exteriorcoating ( type: esriFieldTypeString, alias: Exterior Coating, length: 20 )
• liningtype ( type: esriFieldTypeString, alias: Lining Type, length: 20 )
• liningdate ( type: esriFieldTypeDate, alias: Lining Date, length: 8 )
• roughness ( type: esriFieldTypeDouble, alias: Roughness )
• VALIDATIONSTATUS ( type: esriFieldTypeSmallInteger, alias: Validation status )
• OBJECTID ( type: esriFieldTypeOID, alias: Object ID, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: Global ID, length: 38 )
• IsolationSubnetworkName ( type: esriFieldTypeString, alias: Isolation Subnetwork Name, length: 2000 )
• DMASubnetworkName ( type: esriFieldTypeString, alias: DMA Subnetwork Name, length: 2000 )
• installdate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• assetid ( type: esriFieldTypeString, alias: Asset ID, length: 50 )
• diameter ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [0: 0 mm] , [10: 10 mm] , [13: 13 mm] , ...71 more... )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...14 more... )
• material ( type: esriFieldTypeSmallInteger, alias: Material )
• location ( type: esriFieldTypeString, alias: Location, length: 100 )
• parcelid ( type: esriFieldTypeString, alias: Parcel ID, length: 100 )
• installcontractor ( type: esriFieldTypeSmallInteger, alias: Install Contractor )
• groundtype ( type: esriFieldTypeSmallInteger, alias: Ground Type )
• criticalcustomer ( type: esriFieldTypeSmallInteger, alias: Critical Customer )
• conditiondate ( type: esriFieldTypeDate, alias: Condition Date, length: 8 )
• acquisitioncost ( type: esriFieldTypeDouble, alias: Acquisition Cost )
• expectedlife ( type: esriFieldTypeDouble, alias: Expected Life )
• residualvalue ( type: esriFieldTypeDouble, alias: Residual Value )
• condition ( type: esriFieldTypeDouble, alias: Condition )
• cofscore ( type: esriFieldTypeDouble, alias: CoF Score )
• cofdate ( type: esriFieldTypeDate, alias: CoF Date, length: 8 )
• riskscore ( type: esriFieldTypeDouble, alias: Risk Score )
• link ( type: esriFieldTypeString, alias: Link, length: 255 )
• subtypetext ( type: esriFieldTypeString, alias: Subtype Text, length: 255 )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE_Length )

Types:

ID: 0
Name: Unknown
Domains:
• ASSETTYPE:
  Coded Values: [0: Unknown]
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• FLOWDIRECTION:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• bondedinsulated:
  Inherited
• cptraceability:
  Inherited

---

ID: 1
Name: Water Main
Domains:
• ASSETTYPE:
  Coded Values: [0: Unknown] , [1: Transmission Main] , [2: Distribution Main] , ...3 more...
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• FLOWDIRECTION:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• diameter:
  Inherited
• adddetails:
  Coded Values: [11: Bypass] , [12: Interconnect]
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• bondedinsulated:
  Inherited
• cptraceability:
  Inherited
• material:
  Coded Values: [0: Unknown] , [89: Galvanized Pipe - GP] , [91: Plastic/Steel Composite - PSC] , ...18 more...
• cpoverride:
  Inherited
• designtype:
  Coded Values: [0: Unknown] , [1: Treated Water] , [2: Combined Waste Water] , ...5 more...
• spatialsource:
  Inherited
• spatialconfidence:
  Inherited
• pressurezone:
  Inherited
• installcontractor:
  Coded Values: [1: Access Engineering Consultants Ltd] , [2: AESL] , [3: DB Mechanical] , ...11 more...
• groundtype:
  Coded Values: [1: Asphalt] , [2: Dirt] , [3: Grass] , ...2 more...
• exteriorcoating:
  Coded Values: [UNK: Unknown] , [OTH: Other] , [TAR: Tar] , ...3 more...
• liningtype:
  Coded Values: [UNK: Unknown] , [OTH: Other] , [CM: Cement-Mortar] , ...3 more...

---

ID: 2
Name: Service
Domains:
• ASSETTYPE:
  Coded Values: [0: Unknown] , [11: Residential Service] , [12: Commercial Service] , ...7 more...
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• FLOWDIRECTION:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• diameter:
  Coded Values: [0: 0 mm] , [10: 10 mm] , [20: 20 mm] , ...68 more...
• adddetails:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• bondedinsulated:
  Inherited
• cptraceability:
  Inherited
• material:
  Coded Values: [0: Unknown] , [94: Polyvinyl Chloride - PVC] , [81: Asbestos Concrete - AC] , ...8 more...
• cpoverride:
  Inherited
• designtype:
  Coded Values: [0: Unknown] , [1: Treated Water] , [2: Combined Waste Water] , ...5 more...
• spatialsource:
  Inherited
• spatialconfidence:
  Inherited
• pressurezone:
  Inherited
• installcontractor:
  Coded Values: [1: Access Engineering Consultants Ltd] , [2: AESL] , [3: DB Mechanical] , ...11 more...
• groundtype:
  Coded Values: [1: Asphalt] , [2: Dirt] , [3: Grass] , ...2 more...
• criticalcustomer:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]

---

ID: 51
Name: Test Lead Wire
Domains:
• ASSETTYPE:
  Coded Values: [0: Unknown] , [901: Aqua] , [902: Blue] , ...8 more...
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• FLOWDIRECTION:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• diameter:
  Coded Values: [0: Unknown] , [1: 4] , [2: 8]
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• bondedinsulated:
  Inherited
• cptraceability:
  Inherited
• cpoverride:
  Inherited
• spatialsource:
  Inherited
• spatialconfidence:
  Inherited

---

ID: 52
Name: Rectifier Cable
Domains:
• ASSETTYPE:
  Coded Values: [0: Unknown] , [961: Rectifier Cable]
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• FLOWDIRECTION:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• diameter:
  Coded Values: [0: Unknown] , [1: 4] , [2: 8]
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• bondedinsulated:
  Inherited
• cptraceability:
  Inherited
• cpoverride:
  Inherited
• spatialsource:
  Inherited
• spatialconfidence:
  Inherited

---

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata