Parent Layer: Sanitary

Name: Sewer Line

Display Field: cpsubnetworkname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 4ac20e8b90ee4fd1b3715d9ed4385170

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

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: 2481444.1740644313
YMin: 1490007.1558419466
XMax: 2495694.639329847
YMax: 1499419.835507363
Spatial Reference: 103038  (6457)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: assetgroup
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [130, 130, 130, 255]
Width: 1
Default Label: <all other values>
UniqueValueInfos:
• Value: 0
  Label: Unknown
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [130, 130, 130, 255]
  Width: 1
• Value: 1
  Label: Sewer Gravity Main
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 2
• Value: 2
  Label: Sewer Force Main
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: 3
  Label: Lateral
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 1
• Value: 50
  Label: Bonding Line
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [0, 0, 0, 255]
  Width: 2
• Value: 51
  Label: Test Lead Wire
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 1
• Value: 52
  Label: Rectifier Cable
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [0, 0, 0, 255]
  Width: 1
• Value: 53
  Label: Low Pressure Sewer Main
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [115, 223, 255, 255]
  Width: 2
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

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: true
Supports Query With Current User: true

HasZ: true

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: assetgroup

Fields:

• OBJECTID ( nullable: false, alias: Object ID, type: esriFieldTypeOID )
• assetid ( nullable: true, length: 64, alias: Pipe ID, type: esriFieldTypeString )
• assetgroup ( nullable: false, alias: Asset group, type: esriFieldTypeInteger )
• assettype ( nullable: false, alias: Asset type, type: esriFieldTypeSmallInteger )
• material ( nullable: true, alias: Material, type: esriFieldTypeSmallInteger )
• mainshape ( nullable: true, alias: Main Shape, type: esriFieldTypeSmallInteger )
• diameter ( nullable: true, alias: Size/Diameter, type: esriFieldTypeDouble )
• measuredlength ( nullable: true, alias: Measured Length, type: esriFieldTypeDouble )
• fromdeviceterminal ( nullable: false, alias: From device terminal, type: esriFieldTypeSmallInteger , Coded Values: [0: None] , [1: Single Terminal] , [2: High Pressure In] , ...19 more... )
• todeviceterminal ( nullable: false, alias: To device terminal, type: esriFieldTypeSmallInteger , Coded Values: [0: None] , [1: Single Terminal] , [2: High Pressure In] , ...19 more... )
• downelev ( nullable: true, alias: Downstream Elevation, type: esriFieldTypeDouble )
• upelev ( nullable: true, alias: Upstream Elevation, type: esriFieldTypeDouble )
• slope ( nullable: true, alias: Slope, type: esriFieldTypeDouble )
• lifecyclestatus ( nullable: false, alias: Lifecycle Status, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...14 more... )
• installdate ( nullable: true, length: 8, alias: Install Date, type: esriFieldTypeDate )
• linertype ( nullable: true, alias: Liner Type, type: esriFieldTypeSmallInteger )
• ownedby ( nullable: true, alias: Owned By, type: esriFieldTypeSmallInteger , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• maintby ( nullable: true, alias: Maintained By, type: esriFieldTypeSmallInteger , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• notes ( nullable: true, length: 2000, alias: Notes, type: esriFieldTypeString )
• tracerwire ( nullable: true, alias: Tracer Wire, type: esriFieldTypeSmallInteger )
• cptraceability ( nullable: true, alias: Cathodic Protection Traceability, type: esriFieldTypeSmallInteger , Coded Values: [1: Traceable] , [2: Not Traceable] )
• cpoverride ( nullable: true, alias: Cathodic Protection Override, type: esriFieldTypeSmallInteger , Coded Values: [1: Traceable] , [2: Not Traceable] )
• bondedinsulated ( nullable: true, alias: Bonded/Insulated, type: esriFieldTypeSmallInteger , Coded Values: [1: Bonded] , [2: Insulated] )
• spatialsource ( nullable: true, alias: Spatial Source, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more... )
• spatialconfidence ( nullable: true, alias: Spatial Confidence, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: High] , [2: Medium] , ...1 more... )
• Shape ( nullable: true, alias: Shape, type: esriFieldTypeGeometry )
• Shape.STLength() ( nullable: true, alias: shape.STLength(), type: esriFieldTypeDouble )
• created_user ( nullable: true, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, length: 8, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, length: 8, alias: last_edited_date, type: esriFieldTypeDate )
• CMT_Latitude ( nullable: true, alias: Latitude, type: esriFieldTypeDouble )
• CMT_Longitude ( nullable: true, alias: Longitude, type: esriFieldTypeDouble )
• CMT_Map_Label ( nullable: true, length: 255, alias: CMT Map Label, type: esriFieldTypeString )
• CMT_Map_Style1 ( nullable: true, length: 255, alias: CMT Map Style 1, type: esriFieldTypeString )
• CMT_Map_Style2 ( nullable: true, length: 255, alias: CMT Map Style 2, type: esriFieldTypeString )
• CMT_Map_Style3 ( nullable: true, length: 255, alias: CMT Map Style 3, type: esriFieldTypeString )
• CMT_Data_Key ( nullable: true, length: 255, alias: CMT Data Key, type: esriFieldTypeString )
• CMT_Job_Number ( nullable: true, alias: Job Number, type: esriFieldTypeInteger )
• isActive ( nullable: true, alias: CMT Is Active, type: esriFieldTypeSmallInteger )
• LinerDate ( nullable: true, length: 8, alias: LinerDate, type: esriFieldTypeDate )

Types:

ID: 0
Name: Unknown
Domains:
• todeviceterminal:
  Inherited
• tracerwire:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• associationstatus:
  Inherited
• isconnected:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown]
• fromdeviceterminal:
  Inherited
• bondedinsulated:
  Inherited
• lifecyclestatus:
  Inherited

---

ID: 50
Name: Bonding Line
Domains:
• spatialsource:
  Inherited
• fromdeviceterminal:
  Inherited
• lifecyclestatus:
  Inherited
• todeviceterminal:
  Inherited
• cptraceability:
  Inherited
• diameter:
  Coded Values: [0: Unknown] , [4: 4] , [8: 8]
• associationstatus:
  Inherited
• spatialconfidence:
  Inherited
• cpoverride:
  Inherited
• isconnected:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [941: Wire] , [942: Strap]
• bondedinsulated:
  Inherited

---

ID: 51
Name: Test Lead Wire
Domains:
• spatialsource:
  Inherited
• fromdeviceterminal:
  Inherited
• lifecyclestatus:
  Inherited
• todeviceterminal:
  Inherited
• cptraceability:
  Inherited
• diameter:
  Coded Values: [0: Unknown] , [4: 4] , [8: 8]
• associationstatus:
  Inherited
• spatialconfidence:
  Inherited
• cpoverride:
  Inherited
• isconnected:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [901: Aqua] , [902: Blue] , ...8 more...
• bondedinsulated:
  Inherited

---

ID: 52
Name: Rectifier Table
Domains:
• spatialsource:
  Inherited
• fromdeviceterminal:
  Inherited
• lifecyclestatus:
  Inherited
• todeviceterminal:
  Inherited
• cptraceability:
  Inherited
• diameter:
  Coded Values: [0: Unknown] , [4: 4] , [8: 8]
• associationstatus:
  Inherited
• spatialconfidence:
  Inherited
• cpoverride:
  Inherited
• isconnected:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [961: Rectifier Cable]
• bondedinsulated:
  Inherited

---

ID: 1
Name: Sewer Gravity Main
Domains:
• linertype:
  Coded Values: [0: Unknown] , [1: Cured-In-Place Pipe - CIP] , [2: Fold and Form or Deform/Reform - FF] , ...11 more...
• spatialsource:
  Inherited
• fromdeviceterminal:
  Inherited
• lifecyclestatus:
  Inherited
• todeviceterminal:
  Inherited
• cptraceability:
  Inherited
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...27 more...
• material:
  Coded Values: [0: Unknown] , [1: Acrylonitrile Butadiene Styrene - ABS] , [2: Asbestos Cement - AC] , ...24 more...
• mainshape:
  Coded Values: [0: Unknown] , [1: Circular] , [2: Horseshoe] , ...4 more...
• associationstatus:
  Inherited
• spatialconfidence:
  Inherited
• cpoverride:
  Inherited
• isconnected:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [1: Collector Gravity Main] , [2: Interceptor Gravity Main]
• bondedinsulated:
  Inherited

---

ID: 2
Name: Sewer Force Main
Domains:
• linertype:
  Coded Values: [0: Unknown] , [1: Cured-In-Place Pipe - CIP] , [2: Fold and Form or Deform/Reform - FF] , ...11 more...
• spatialsource:
  Inherited
• fromdeviceterminal:
  Inherited
• lifecyclestatus:
  Inherited
• todeviceterminal:
  Inherited
• cptraceability:
  Inherited
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...27 more...
• material:
  Coded Values: [0: Unknown] , [1: Acrylonitrile Butadiene Styrene - ABS] , [2: Asbestos Cement - AC] , ...24 more...
• mainshape:
  Coded Values: [0: Unknown] , [1: Circular] , [2: Horseshoe] , ...4 more...
• associationstatus:
  Inherited
• spatialconfidence:
  Inherited
• cpoverride:
  Inherited
• isconnected:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [41: Force Main]
• bondedinsulated:
  Inherited

---

ID: 3
Name: Lateral
Domains:
• spatialsource:
  Inherited
• fromdeviceterminal:
  Inherited
• lifecyclestatus:
  Inherited
• todeviceterminal:
  Inherited
• cptraceability:
  Inherited
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...27 more...
• material:
  Coded Values: [0: Unknown] , [1: Acrylonitrile Butadiene Styrene - ABS] , [2: Asbestos Cement - AC] , ...24 more...
• mainshape:
  Coded Values: [0: Unknown] , [1: Circular] , [2: Horseshoe] , ...4 more...
• associationstatus:
  Inherited
• spatialconfidence:
  Inherited
• cpoverride:
  Inherited
• isconnected:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [121: Commercial] , [122: Industrial] , ...1 more...
• bondedinsulated:
  Inherited

---

ID: 53
Name: Low Pressure Sewer Main
Domains:
• linertype:
  Coded Values: [0: Unknown] , [1: Cured-In-Place Pipe - CIP] , [2: Fold and Form or Deform/Reform - FF] , ...11 more...
• spatialsource:
  Inherited
• fromdeviceterminal:
  Inherited
• lifecyclestatus:
  Inherited
• todeviceterminal:
  Inherited
• cptraceability:
  Inherited
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...27 more...
• material:
  Coded Values: [0: Unknown] , [1: Acrylonitrile Butadiene Styrene - ABS] , [2: Asbestos Cement - AC] , ...24 more...
• mainshape:
  Coded Values: [0: Unknown] , [1: Circular] , [2: Horseshoe] , ...4 more...
• associationstatus:
  Inherited
• spatialconfidence:
  Inherited
• cpoverride:
  Inherited
• isconnected:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [1: Pressure Main]
• bondedinsulated:
  Inherited

---

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

  Iteminfo   Thumbnail   Metadata