Parent Layer: Sanitary Sewer

Name: Sanitary Sewer Gravity Main

Display Field: systemsubnetworkname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 12000

Max Scale: 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: 1.1127525701120384E7
YMin: 3511273.516596522
XMax: 1.1440321754004724E7
YMax: 3847393.0873678513
Spatial Reference: 102747  (2284)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: lifecyclestatus
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 8
  Label: In Service
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [78, 78, 78, 255]
  Width: 11
• Value: 4
  Label: Under Construction
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [78, 78, 78, 255]
  Width: 11
• Value: 2
  Label: Approved
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [163, 255, 115, 255]
  Width: 2
• Value: 1
  Label: Proposed
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [163, 255, 115, 255]
  Width: 2
• Value: 32
  Label: Abandoned
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [255, 0, 0, 255]
  Width: 2
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

HasZ: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: ASSETGROUP

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• installdate ( type: esriFieldTypeDate, alias: InstallDate, length: 8 )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: LifecycleStatus , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...14 more... )
• material ( type: esriFieldTypeSmallInteger, alias: Material )
• slope ( type: esriFieldTypeDouble, alias: Slope )
• interceptor ( type: esriFieldTypeString, alias: Interceptor, length: 255 , Coded Values: [UNKNOWN: UNKNOWN] , [BLACKWATER CREEK: BLACKWATER CREEK] , [BLACKWATER CREEK TRIBUTARY: BLACKWATER CREEK TRIBUTARY] , ...40 more... )
• rehab ( type: esriFieldTypeSmallInteger, alias: Rehab , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• rehabdate ( type: esriFieldTypeDate, alias: RehabDate, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• crossings ( type: esriFieldTypeSmallInteger, alias: Crossings , Coded Values: [1: Aerial] , [2: Encasement] , [3: Underground] , ...1 more... )
• creator ( type: esriFieldTypeString, alias: Creator, length: 255 )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• lucitysyncdate ( type: esriFieldTypeDate, alias: LucitySyncDate, length: 8 )
• 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] , ...19 more... )
• TODEVICETERMINAL ( type: esriFieldTypeSmallInteger, alias: To device terminal , Coded Values: [0: None] , [1: Single Terminal] , [2: High Pressure In] , ...19 more... )
• systemsubnetworkname ( type: esriFieldTypeString, alias: systemsubnetworkname, length: 2000 )
• SUPPORTEDSUBNETWORKNAME ( type: esriFieldTypeString, alias: Supported subnetwork name, length: 2000 )
• SUPPORTINGSUBNETWORKNAME ( type: esriFieldTypeString, alias: Supporting subnetwork name, length: 2000 )
• sewershedsubnetworkname ( type: esriFieldTypeString, alias: sewershedsubnetworkname, length: 2000 )
• stormwatersubnetworkname ( type: esriFieldTypeString, alias: stormwatersubnetworkname, length: 2000 )
• creationdate ( type: esriFieldTypeDate, alias: Creation date, length: 8 )
• lastupdate ( type: esriFieldTypeDate, alias: Last update, length: 8 )
• updatedby ( type: esriFieldTypeString, alias: Updated by, length: 255 )
• diameter ( type: esriFieldTypeDouble, alias: Size/Diameter )
• linertype ( type: esriFieldTypeSmallInteger, alias: Liner Type )
• downelev ( type: esriFieldTypeDouble, alias: Downstream Elevation )
• upelev ( type: esriFieldTypeDouble, alias: Upstream Elevation )
• assetid ( type: esriFieldTypeString, alias: Asset ID, length: 64 )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [2: Private] , [1: Public] , [0: Unknown] , ...1 more... )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By )
• tracerwire ( type: esriFieldTypeSmallInteger, alias: Tracer Wire )
• measuredlength ( type: esriFieldTypeDouble, alias: Measured Length )
• notes ( type: esriFieldTypeString, alias: Notes, length: 2000 )
• spatialsource ( type: esriFieldTypeSmallInteger, alias: Spatial Source )
• spatialconfidence ( type: esriFieldTypeSmallInteger, alias: Spatial Confidence )
• cptraceability ( type: esriFieldTypeSmallInteger, alias: Cathodic Protection Traceability )
• cpoverride ( type: esriFieldTypeSmallInteger, alias: Cathodic Protection Override )
• bondedinsulated ( type: esriFieldTypeSmallInteger, alias: Bonded/Insulated )
• mainshape ( type: esriFieldTypeSmallInteger, alias: Main Shape )
• validationstatus ( type: esriFieldTypeSmallInteger, alias: Validation status )
• upstreammanhole ( type: esriFieldTypeString, alias: Upstream Manhole, length: 20 )
• downstreammanhole ( type: esriFieldTypeString, alias: Downstream Manhole, length: 20 )
• watertype ( type: esriFieldTypeSmallInteger, alias: Water Type , Coded Values: [1: Sewer] , [2: Stormwater] , [3: Combined] )
• cityapproved ( type: esriFieldTypeSmallInteger, alias: City Approved , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• streetname ( type: esriFieldTypeString, alias: Street Name, length: 35 , Coded Values: [10TH ST: 10TH ST] , [11TH ST: 11TH ST] , [12TH ST: 12TH ST] , ...1408 more... )
• houseno ( type: esriFieldTypeString, alias: House Number, length: 10 )
• projectno ( type: esriFieldTypeString, alias: Project Number, length: 20 )
• projectsheetno ( type: esriFieldTypeString, alias: Project Sheet Number, length: 15 )
• projectabdno ( type: esriFieldTypeString, alias: Project ABD Number, length: 10 )
• abddate ( type: esriFieldTypeDate, alias: ABD Date, length: 8 )
• incsq ( type: esriFieldTypeSmallInteger, alias: In CSQ? , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• csqlink ( type: esriFieldTypeInteger, alias: Link to CSQ )
• pipeshape ( type: esriFieldTypeSmallInteger, alias: Culvert Shape, Pipe Shape )
• type ( type: esriFieldTypeSmallInteger, alias: Type )
• lined ( type: esriFieldTypeSmallInteger, alias: Lined? )
• lineryear ( type: esriFieldTypeSmallInteger, alias: Liner Year )
• linermethod ( type: esriFieldTypeSmallInteger, alias: Liner Method )
• width ( type: esriFieldTypeDouble, alias: Width , Range: [0.5, 200] )
• height ( type: esriFieldTypeDouble, alias: Height , Range: [0.5, 200] )
• wall ( type: esriFieldTypeSmallInteger, alias: Wall )
• culvertsize ( type: esriFieldTypeString, alias: Culvert Size, length: 20 )
• barrels ( type: esriFieldTypeDouble, alias: Barrels )
• dpwinspectid ( type: esriFieldTypeString, alias: DPW Inspection ID, length: 10 )
• structuraldetail ( type: esriFieldTypeString, alias: Structural Detail, length: 255 )
• conditionid ( type: esriFieldTypeString, alias: Condition ID, length: 10 )
• recwaterbody ( type: esriFieldTypeString, alias: Receiving Water Body, length: 255 , Coded Values: [UNKNOWN: UNKNOWN] , [BLACKWATER CREEK: BLACKWATER CREEK] , [BLACKWATER CREEK TRIBUTARY: BLACKWATER CREEK TRIBUTARY] , ...40 more... )

Types:

ID: 0
Name: Unknown
Domains:
• ASSETTYPE:
  Coded Values: [0: Unknown]
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• ownedby:
  Inherited
• tracerwire:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• watertype:
  Inherited
• streetname:
  Inherited
• rehab:
  Inherited
• incsq:
  Inherited
• lined:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• lineryear:
  Range: [1800, 2060]
• linermethod:
  Coded Values: [0: Unknown] , [1: Cured In Place - CIP] , [2: Fold and Form or Deform/Reform - FF] , ...11 more...
• width:
  Inherited
• height:
  Inherited
• interceptor:
  Inherited

---

ID: 1
Name: Sewer Gravity Main
Domains:
• ASSETTYPE:
  Coded Values: [0: Unknown] , [1: Collector Gravity Main] , [2: Interceptor Gravity Main]
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• diameter:
  Coded Values: [0: Unknown] , [1: 1"] , [1.25: 1 1/4"] , ...43 more...
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• ownedby:
  Inherited
• tracerwire:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• material:
  Coded Values: [0: Unknown] , [5: Cast Iron - CAS] , [7: Concrete Pipe (Non-Reinforced) - CP] , ...19 more...
• watertype:
  Inherited
• crossings:
  Inherited
• streetname:
  Inherited
• rehab:
  Inherited
• incsq:
  Inherited
• lined:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]

---

ID: 2
Name: Sewer Force Main
Domains:
• ASSETTYPE:
  Coded Values: [0: Unknown] , [41: Force Main]
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• diameter:
  Coded Values: [0: Unknown] , [1: 1"] , [1.25: 1 1/4"] , ...43 more...
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• ownedby:
  Inherited
• tracerwire:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• material:
  Coded Values: [0: Unknown] , [5: Cast Iron - CAS] , [7: Concrete Pipe (Non-Reinforced) - CP] , ...19 more...
• watertype:
  Inherited
• crossings:
  Inherited
• streetname:
  Inherited
• rehab:
  Inherited
• incsq:
  Inherited
• lined:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]

---

ID: 3
Name: Lateral
Domains:
• ASSETTYPE:
  Coded Values: [0: Unknown] , [123: Lateral]
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• diameter:
  Coded Values: [0: Unknown] , [4: 4"] , [6: 6"] , ...1 more...
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• ownedby:
  Inherited
• material:
  Coded Values: [0: Unknown] , [8: Cast Iron - CAS] , [11: Ductile Iron - DIP] , ...4 more...
• watertype:
  Inherited
• crossings:
  Inherited
• cityapproved:
  Inherited
• streetname:
  Inherited
• rehab:
  Inherited
• incsq:
  Inherited

---

ID: 4
Name: Stormwater Pipe
Domains:
• ASSETTYPE:
  Coded Values: [0: Unknown] , [3: Gravity Pipe] , [5: Perforated Pipe]
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• diameter:
  Coded Values: [1.5: 1 1/2"] , [1.25: 1 1/4"] , [1: 1"] , ...62 more...
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• ownedby:
  Inherited
• material:
  Coded Values: [0: Unknown] , [2: Asbestos Cement - AC] , [5: Cast Iron - CAS] , ...13 more...
• watertype:
  Inherited
• crossings:
  Inherited
• cityapproved:
  Inherited
• streetname:
  Inherited
• rehab:
  Inherited
• incsq:
  Inherited
• pipeshape:
  Coded Values: [0: Unknown] , [1: Circular] , [2: Horseshoe] , ...6 more...
• lined:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• lineryear:
  Range: [1800, 2060]
• linermethod:
  Coded Values: [0: Unknown] , [1: Cured In Place - CIP] , [2: Fold and Form or Deform/Reform - FF] , ...11 more...
• width:
  Inherited
• height:
  Inherited

---

ID: 5
Name: Open Channel
Domains:
• ASSETTYPE:
  Coded Values: [0: Unknown] , [45: Natural Channel] , [46: Ditch Channel] , ...1 more...
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• ownedby:
  Inherited
• material:
  Coded Values: [1: Asphalt] , [2: Concrete] , [3: Dirt] , ...5 more...
• watertype:
  Inherited
• crossings:
  Inherited
• cityapproved:
  Inherited
• streetname:
  Inherited
• rehab:
  Inherited
• incsq:
  Inherited
• pipeshape:
  Coded Values: [0: Unknown] , [1: V-shaped] , [2: Trapezoidal] , ...2 more...

---

ID: 6
Name: Culvert
Domains:
• ASSETTYPE:
  Coded Values: [0: Unknown] , [81: Pipe Culvert] , [83: Box Culvert]
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• ownedby:
  Inherited
• material:
  Coded Values: [0: Unknown] , [2: Asbestos Cement - AC] , [5: Cast Iron - CAS] , ...13 more...
• watertype:
  Inherited
• crossings:
  Inherited
• cityapproved:
  Inherited
• streetname:
  Inherited
• rehab:
  Inherited
• incsq:
  Inherited
• pipeshape:
  Coded Values: [0: Unknown] , [1: Circular] , [2: Horseshoe] , ...6 more...
• width:
  Inherited
• height:
  Inherited

---

ID: 7
Name: Linear Drain
Domains:
• ASSETTYPE:
  Coded Values: [0: Unknown] , [121: Trench Drain] , [122: Slotted Drain]
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• diameter:
  Coded Values: [1.5: 1 1/2"] , [1.25: 1 1/4"] , [1: 1"] , ...62 more...
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• ownedby:
  Inherited
• material:
  Coded Values: [0: Unknown] , [2: Asbestos Cement - AC] , [5: Cast Iron - CAS] , ...13 more...
• watertype:
  Inherited
• crossings:
  Inherited
• cityapproved:
  Inherited
• streetname:
  Inherited
• rehab:
  Inherited
• incsq:
  Inherited

---

ID: 8
Name: Combined Gravity Main
Domains:
• ASSETTYPE:
  Coded Values: [11: Combined] , [0: Unknown]
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• diameter:
  Coded Values: [0: Unknown] , [1: 1"] , [1.25: 1 1/4"] , ...43 more...
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• ownedby:
  Inherited
• tracerwire:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• material:
  Coded Values: [0: Unknown] , [5: Cast Iron - CAS] , [7: Concrete Pipe (Non-Reinforced) - CP] , ...19 more...
• watertype:
  Inherited
• crossings:
  Inherited
• cityapproved:
  Inherited
• streetname:
  Inherited
• rehab:
  Inherited
• incsq:
  Inherited
• lined:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]

---

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

  Iteminfo   Thumbnail   Metadata