Layer: UN_SewerLine (ID:315)

View In: Map Viewer

Name: UN_SewerLine

Display Field: assetgroup

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

The Line feature class represents linear features. These are the lines which deliver your utility resource. Lines can be connected to other lines, junctions, and devices. Lines can be contained within assemblies.

Copyright Text: Esri, Inc.

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"ASSETGROUP","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":1},"defaultLabel":"Other","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":1},"value":"0","label":"Unknown"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":2},"value":"1","label":"Sewer Gravity Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":2},"value":"2","label":"Sewer Force Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":1},"value":"3","label":"Lateral"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":2},"value":"4","label":"Outfall"},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[0,0,0,255],"width":2},"value":"50","label":"Bonding Line"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":1},"value":"51","label":"Test Lead Wire"},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[0,0,0,255],"width":1},"value":"52","label":"Rectifier Cable"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,252,228,255],"toColor":[207,252,228,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[242,182,252,255],"toColor":[242,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,197,184,255],"toColor":[252,197,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,217,252,255],"toColor":[189,217,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,245,179,255],"toColor":[252,245,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,252,182,255],"toColor":[189,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,246,255],"toColor":[252,215,246,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[183,182,252,255],"toColor":[183,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,225,194,255],"toColor":[252,225,194,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[202,243,252,255],"toColor":[202,243,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,216,255],"toColor":[252,184,216,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[246,252,215,255],"toColor":[246,252,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[222,197,252,255],"toColor":[222,197,252,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true

HasM: true

Has Attachments: true

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GLOBALID

Type ID Field: ASSETGROUP

Fields:

OBJECTID (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
ASSETGROUP (type: esriFieldTypeInteger, alias: Asset group, SQL Type: sqlTypeOther, nullable: false, editable: true)
ASSETTYPE (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: false, editable: true)
assetid (type: esriFieldTypeString, alias: assetid: Asset ID, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
feature_id (type: esriFieldTypeString, alias: Feature_ID (Deprecated), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
lifecyclestatus (type: esriFieldTypeSmallInteger, alias: lifecyclestatus: Lifecycle Status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 14 more ...)
measuredlength (type: esriFieldTypeDouble, alias: measuredlength: Measured Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
diameter (type: esriFieldTypeDouble, alias: diameter: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
material (type: esriFieldTypeSmallInteger, alias: material: Material, SQL Type: sqlTypeOther, nullable: true, editable: true)
linertype (type: esriFieldTypeSmallInteger, alias: linertype: Liner Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
designtype (type: esriFieldTypeSmallInteger, alias: designtype: Main Shape, SQL Type: sqlTypeOther, nullable: true, editable: true)
ownedby (type: esriFieldTypeSmallInteger, alias: ownedby: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
maintby (type: esriFieldTypeSmallInteger, alias: maintby: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
adminarea (type: esriFieldTypeString, alias: Administrative Area, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [Antioch: Village of Antioch], [Bannockburn: Village of Bannockburn], [Beach Park: Village of Beach Park], ... 29 more ...)
opsarea (type: esriFieldTypeString, alias: Operational Area, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [C: Central], [N: North], [NA: N/A], ... 1 more ...)
sewersystem (type: esriFieldTypeString, alias: Sewer System, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [Diamond-Sylvan Lake: Diamond-Sylvan Lake], [N/A: N/A], [Northeast: Northeast], ... 5 more ...)
systemsubnetworkname (type: esriFieldTypeString, alias: systemsubnetworkname: systemsubnetworkname, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
sewershedsubnetworkname (type: esriFieldTypeString, alias: sewershedsubnetworkname: sewershedsubnetworkname, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
planidinstall (type: esriFieldTypeInteger, alias: PlanID (installed), SQL Type: sqlTypeOther, nullable: true, editable: true)
planidretire (type: esriFieldTypeInteger, alias: PlanID (retired), SQL Type: sqlTypeOther, nullable: true, editable: true)
mapcorrectid (type: esriFieldTypeString, alias: Map CorrectionID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
downelev (type: esriFieldTypeDouble, alias: downelev: Downstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
upelev (type: esriFieldTypeDouble, alias: upelev: Upstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
slope (type: esriFieldTypeDouble, alias: slope: Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
installdate (type: esriFieldTypeDate, alias: installdate: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
notes (type: esriFieldTypeString, alias: notes: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
tracerwire (type: esriFieldTypeSmallInteger, alias: tracerwire: Tracer Wire, SQL Type: sqlTypeOther, nullable: true, editable: true)
nasscograde (type: esriFieldTypeSmallInteger, alias: NASSCO Inspection Grade, SQL Type: sqlTypeOther, nullable: true, editable: true)
nasscoyear (type: esriFieldTypeSmallInteger, alias: NASSCO Inspection Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
spatialsource (type: esriFieldTypeSmallInteger, alias: spatialsource: Spatial Source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: As-Built], [2: CAD], ... 3 more ...)
spatialconfidence (type: esriFieldTypeSmallInteger, alias: spatialconfidence: Spatial Confidence, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: High], [2: Medium], ... 1 more ...)
ASSOCIATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Association status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Container], [2: Structure], ... 33 more ...)
ISCONNECTED (type: esriFieldTypeSmallInteger, alias: Is connected, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: False], [1: True], [2: Unknown])
FROMDEVICETERMINAL (type: esriFieldTypeSmallInteger, alias: From device terminal, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Single Terminal], [2: High Pressure In], ... 15 more ...)
TODEVICETERMINAL (type: esriFieldTypeSmallInteger, alias: To device terminal, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Single Terminal], [2: High Pressure In], ... 15 more ...)
CREATIONDATE (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
CREATOR (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
LASTUPDATE (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
UPDATEDBY (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
GLOBALID (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
cpsubnetworkname (type: esriFieldTypeString, alias: cpsubnetworkname: cpsubnetworkname, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
cptraceability (type: esriFieldTypeSmallInteger, alias: cptraceability: Cathodic Protection Traceability, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
cpoverride (type: esriFieldTypeSmallInteger, alias: cpoverride: Cathodic Protection Override, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Traceable], [2: Not Traceable])
SUPPORTEDSUBNETWORKNAME (type: esriFieldTypeString, alias: Supported subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
SUPPORTINGSUBNETWORKNAME (type: esriFieldTypeString, alias: Supporting subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
installyear (type: esriFieldTypeSmallInteger, alias: Install Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: true)

Types:

Field Name: ASSETTYPE
Coded Values:[0: Unknown]
Field Name: lifecyclestatus
Coded Values:[0: Unknown], [1: Proposed], [2: Approved], More
Field Name: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: adminarea
Inherited
Field Name: opsarea
Inherited
Field Name: sewersystem
Inherited
Field Name: tracerwire
Coded Values:[0: Unknown], [1: Yes], [2: No]
Field Name: ASSOCIATIONSTATUS
Inherited
Field Name: ISCONNECTED
Inherited
Field Name: FROMDEVICETERMINAL
Inherited
Field Name: TODEVICETERMINAL
Inherited

ASSETGROUP: 0
TODEVICETERMINAL: 0
FROMDEVICETERMINAL: 0
ownedby: 1
tracerwire: 0
ASSETTYPE: 0
lifecyclestatus: 8
cptraceability: 0
maintby: 1

Field Name: ASSETTYPE
Coded Values:[0: Unknown], [1: Collector Gravity Main], [2: Interceptor Gravity Main], More
Field Name: lifecyclestatus
Coded Values:[0: Unknown], [1: Proposed], [2: Approved], More
Field Name: diameter
Coded Values:[0: Unknown], [0.5: 1/2"], [0.75: 3/4"], More
Field Name: material
Coded Values:[1: Acrylonitrile Butadiene Styrene - ABS], [2: Asbestos Cement - AC], [3: Asphalt - ASP], More
Field Name: linertype
Coded Values:[0: Unknown], [1: Cured-In-Place Pipe - CIP], [2: Fold and Form or Deform/Reform - FF], More
Field Name: designtype
Coded Values:[0: Unknown], [1: Circular], [2: Horseshoe], More
Field Name: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: adminarea
Inherited
Field Name: opsarea
Inherited
Field Name: sewersystem
Inherited
Field Name: tracerwire
Coded Values:[0: Unknown], [1: Yes], [2: No]
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: ASSOCIATIONSTATUS
Inherited
Field Name: ISCONNECTED
Inherited
Field Name: FROMDEVICETERMINAL
Inherited
Field Name: TODEVICETERMINAL
Inherited
Field Name: cptraceability
Inherited
Field Name: cpoverride
Inherited

ASSETGROUP: 1
spatialconfidence: 0
spatialsource: 0
TODEVICETERMINAL: 0
FROMDEVICETERMINAL: 0
designtype: 1
ownedby: 1
tracerwire: 0
ASSETTYPE: 0
lifecyclestatus: 8
cptraceability: 0
diameter: 0
material: 0
linertype: 6
maintby: 1

Field Name: ASSETTYPE
Coded Values:[0: Unknown], [41: Collector Force Main], [42: Interceptor Force Main]
Field Name: lifecyclestatus
Coded Values:[0: Unknown], [1: Proposed], [2: Approved], More
Field Name: diameter
Coded Values:[0: Unknown], [0.5: 1/2"], [0.75: 3/4"], More
Field Name: material
Coded Values:[1: Acrylonitrile Butadiene Styrene - ABS], [2: Asbestos Cement - AC], [3: Asphalt - ASP], More
Field Name: linertype
Coded Values:[0: Unknown], [1: Cured-In-Place Pipe - CIP], [2: Fold and Form or Deform/Reform - FF], More
Field Name: designtype
Coded Values:[0: Unknown], [1: Circular], [2: Horseshoe], More
Field Name: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: adminarea
Inherited
Field Name: opsarea
Inherited
Field Name: sewersystem
Inherited
Field Name: tracerwire
Coded Values:[0: Unknown], [1: Yes], [2: No]
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: ASSOCIATIONSTATUS
Inherited
Field Name: ISCONNECTED
Inherited
Field Name: FROMDEVICETERMINAL
Inherited
Field Name: TODEVICETERMINAL
Inherited
Field Name: cptraceability
Inherited
Field Name: cpoverride
Inherited

ASSETGROUP: 2
spatialconfidence: 0
spatialsource: 0
TODEVICETERMINAL: 0
FROMDEVICETERMINAL: 0
designtype: 1
ownedby: 1
tracerwire: 0
ASSETTYPE: 0
lifecyclestatus: 8
cptraceability: 0
diameter: 0
material: 0
linertype: 6
maintby: 1

Field Name: ASSETTYPE
Coded Values:[0: Unknown], [121: Commercial], [122: Industrial], More
Field Name: lifecyclestatus
Coded Values:[0: Unknown], [1: Proposed], [2: Approved], More
Field Name: diameter
Coded Values:[0: Unknown], [0.5: 1/2"], [0.75: 3/4"], More
Field Name: material
Coded Values:[7: ABS Plastic - ABS], [2: Asbestos Cement - AC], [8: Cast Iron - CI], More
Field Name: linertype
Coded Values:[0: Unknown], [1: Cured-In-Place Pipe - CIP], [2: Fold and Form or Deform/Reform - FF], More
Field Name: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: adminarea
Inherited
Field Name: opsarea
Inherited
Field Name: sewersystem
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: ASSOCIATIONSTATUS
Inherited
Field Name: ISCONNECTED
Inherited
Field Name: FROMDEVICETERMINAL
Inherited
Field Name: TODEVICETERMINAL
Inherited
Field Name: cptraceability
Inherited
Field Name: cpoverride
Inherited

ASSETGROUP: 3
spatialconfidence: 0
spatialsource: 0
TODEVICETERMINAL: 0
FROMDEVICETERMINAL: 0
ownedby: 1
ASSETTYPE: 0
lifecyclestatus: 8
cptraceability: 0
material: 0
linertype: 6
maintby: 1

Field Name: ASSETTYPE
Coded Values:[0: Unknown], [1: Outfall]
Field Name: lifecyclestatus
Coded Values:[0: Unknown], [1: Proposed], [2: Approved], More
Field Name: diameter
Coded Values:[0: Unknown], [0.5: 1/2"], [0.75: 3/4"], More
Field Name: material
Coded Values:[1: Acrylonitrile Butadiene Styrene - ABS], [2: Asbestos Cement - AC], [3: Asphalt - ASP], More
Field Name: linertype
Coded Values:[0: Unknown], [1: Cured-In-Place Pipe - CIP], [2: Fold and Form or Deform/Reform - FF], More
Field Name: designtype
Coded Values:[0: Unknown], [1: Circular], [2: Horseshoe], More
Field Name: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: adminarea
Inherited
Field Name: opsarea
Inherited
Field Name: sewersystem
Inherited
Field Name: tracerwire
Coded Values:[0: Unknown], [1: Yes], [2: No]
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: ASSOCIATIONSTATUS
Inherited
Field Name: ISCONNECTED
Inherited
Field Name: FROMDEVICETERMINAL
Inherited
Field Name: TODEVICETERMINAL
Inherited
Field Name: cptraceability
Inherited
Field Name: cpoverride
Inherited

ASSETGROUP: 4
spatialconfidence: 0
spatialsource: 0
TODEVICETERMINAL: 0
FROMDEVICETERMINAL: 0
designtype: 1
ownedby: 1
tracerwire: 0
ASSETTYPE: 0
lifecyclestatus: 8
cptraceability: 0
diameter: 0
material: 0
linertype: 6
maintby: 1

Field Name: ASSETTYPE
Coded Values:[0: Unknown], [941: Wire], [942: Strap]
Field Name: lifecyclestatus
Coded Values:[0: Unknown], [1: Proposed], [2: Approved], More
Field Name: diameter
Coded Values:[0: Unknown], [4: 4], [8: 8]
Field Name: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: adminarea
Inherited
Field Name: opsarea
Inherited
Field Name: sewersystem
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: ASSOCIATIONSTATUS
Inherited
Field Name: ISCONNECTED
Inherited
Field Name: FROMDEVICETERMINAL
Inherited
Field Name: TODEVICETERMINAL
Inherited
Field Name: cptraceability
Inherited
Field Name: cpoverride
Inherited

ASSETGROUP: 50
spatialconfidence: 0
spatialsource: 0
TODEVICETERMINAL: 0
FROMDEVICETERMINAL: 0
ownedby: 1
ASSETTYPE: 0
lifecyclestatus: 8
cptraceability: 0
maintby: 1

Field Name: ASSETTYPE
Coded Values:[0: Unknown], [901: Aqua], [902: Blue], More
Field Name: lifecyclestatus
Coded Values:[0: Unknown], [1: Proposed], [2: Approved], More
Field Name: diameter
Coded Values:[0: Unknown], [4: 4], [8: 8]
Field Name: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: adminarea
Inherited
Field Name: opsarea
Inherited
Field Name: sewersystem
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: ASSOCIATIONSTATUS
Inherited
Field Name: ISCONNECTED
Inherited
Field Name: FROMDEVICETERMINAL
Inherited
Field Name: TODEVICETERMINAL
Inherited
Field Name: cptraceability
Inherited
Field Name: cpoverride
Inherited

ASSETGROUP: 51
spatialconfidence: 0
spatialsource: 0
TODEVICETERMINAL: 0
FROMDEVICETERMINAL: 0
ownedby: 1
ASSETTYPE: 0
lifecyclestatus: 8
cptraceability: 0
maintby: 1

Field Name: ASSETTYPE
Coded Values:[0: Unknown], [961: Rectifier Cable]
Field Name: lifecyclestatus
Coded Values:[0: Unknown], [1: Proposed], [2: Approved], More
Field Name: diameter
Coded Values:[0: Unknown], [4: 4], [8: 8]
Field Name: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: adminarea
Inherited
Field Name: opsarea
Inherited
Field Name: sewersystem
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: ASSOCIATIONSTATUS
Inherited
Field Name: ISCONNECTED
Inherited
Field Name: FROMDEVICETERMINAL
Inherited
Field Name: TODEVICETERMINAL
Inherited
Field Name: cptraceability
Inherited
Field Name: cpoverride
Inherited

ASSETGROUP: 52
spatialconfidence: 0
spatialsource: 0
TODEVICETERMINAL: 0
FROMDEVICETERMINAL: 0
ownedby: 1
ASSETTYPE: 0
lifecyclestatus: 8
cptraceability: 0
maintby: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/25/2025 8:55:56 PM

Schema Last Edit Date: 2/25/2025 8:55:56 PM

Data Last Edit Date: 2/25/2025 8:55:17 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Query Attachments Generate Renderer Validate SQL Get Estimates ConvertFormat