Name: Sewer Main
Display Field: PROJECT_NAME
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description: This line feature class is a collection of sewer lines found within the City of Longview's sanitary sewer system. Sewer pipes are pipes that transport wastewater to a wastewater treatment plant.
Copyright Text: Creation of this dataset utilized source data from the City of Longview.
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -10558672.81182
YMin: 3813907.59425002
XMax: -10537968.4712097
YMax: 3842521.44199433
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[56,168,0,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- ASSETID (type: esriFieldTypeString, alias: ASSETID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [ACTIVE: ACTIVE], [ABANDONED: ABANDONED], [INACTIVE: INACTIVE])
- PROJECT_NAME (type: esriFieldTypeString, alias: PROJECT_NAME, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- ENG_JOB_NO (type: esriFieldTypeString, alias: ENG_JOB_NO, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- OWNER (type: esriFieldTypeInteger, alias: OWNER, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0], [1: CITY OF LONGVIEW], [5: CITY OF LONGVIEW PARKS], ... 3 more ...)
- DATE_INSTALLED (type: esriFieldTypeDate, alias: DATE_INSTALLED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- YEAR_INSTALLED (type: esriFieldTypeSmallInteger, alias: YEAR_INSTALLED, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ABANDONMENT_DATE (type: esriFieldTypeDate, alias: ABANDONMENT DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- DIAMETER (type: esriFieldTypeDouble, alias: DIAMETER, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: UNKNOWN], [1: 1"], [1.5: 1.5"], ... 30 more ...)
- LENGTH (type: esriFieldTypeDouble, alias: LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 21120])
- MATERIAL (type: esriFieldTypeString, alias: MATERIAL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AC: ASBESTOS CEMENT], [BR: BRICK], [CAS: CAST IRON], ... 21 more ...)
- ID_NO (type: esriFieldTypeString, alias: ID_NO, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
- TYPE (type: esriFieldTypeInteger, alias: TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: GRAVITY], [3: SIPHON], [4: UNKNOWN], ... 2 more ...)
- SERVICE_AREA (type: esriFieldTypeString, alias: SERVICE_AREA, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- SLOPE (type: esriFieldTypeDouble, alias: SLOPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MODEL (type: esriFieldTypeInteger, alias: MODEL, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0], [1: YES], [2: NO], ... 1 more ...)
- MANNING_N (type: esriFieldTypeDouble, alias: MANNING_N, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.009: .009], [0.01: .010], [0.012: .012], ... 3 more ...)
- CITY_NAME (type: esriFieldTypeString, alias: CITY_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [BS: BIG SANDY], [CL: CLARKSVILLE CITY], [EM: EAST MOUNTAIN], ... 18 more ...)
- PIPE_SHAPE (type: esriFieldTypeString, alias: PIPE_SHAPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [C: CIRCULAR])
- COMMENT (type: esriFieldTypeString, alias: COMMENT, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
- LOCATION_CODE (type: esriFieldTypeString, alias: LOCATION_CODE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [A: MAIN HIGHWAY - URBAN], [B: MAIN HIGHWAY - RURAL], [C: LIGHT HIGHWAY])
- UPSTREAM_MANHOLE (type: esriFieldTypeString, alias: UPSTREAM_MANHOLE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- DOWNSTREAM_MANHOLE (type: esriFieldTypeString, alias: DOWNSTREAM_MANHOLE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- UPSTREAM_CLEANOUT (type: esriFieldTypeString, alias: UPSTREAM_CLEANOUT, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- DOWNSTREAM_CLEANOUT (type: esriFieldTypeString, alias: DOWNSTREAM_CLEANOUT, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- UPSTREAM_LIFTSTATION (type: esriFieldTypeString, alias: UPSTREAM_LIFTSTATION, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- DOWNSTREAM_LIFTSTATION (type: esriFieldTypeString, alias: DOWNSTREAM_LIFTSTATION, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- BEGIN_DEVICE_EID (type: esriFieldTypeInteger, alias: BEGIN_DEVICE_EID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- END_DEVICE_EID (type: esriFieldTypeInteger, alias: END_DEVICE_EID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LF_ABANDONMENT_EID (type: esriFieldTypeString, alias: LF ABANDONMENT ENTRY ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- LF_ASBUILT_EID (type: esriFieldTypeString, alias: LF ASBUILT ENTRY ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- LF_SKETCH_EID (type: esriFieldTypeString, alias: LF SKETCH ENTRY ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- LINKED_IMAGES (type: esriFieldTypeString, alias: LINKED_IMAGES, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- ABANDONMENT_LINK (type: esriFieldTypeString, alias: ABANDONMENT_LINK, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- OLD_MATERIAL (type: esriFieldTypeInteger, alias: OLD_MATERIAL, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [6: CIP], [5: DIP], [4: HDPE], ... 4 more ...)
- OLD_DIAMETER (type: esriFieldTypeInteger, alias: OLD_DIAMETER, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0], [1: 1"], [105: 1.5"], ... 30 more ...)
- STATUS_old (type: esriFieldTypeInteger, alias: STATUS, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: ACTIVE], [2: ABANDONED], [0: 0], ... 1 more ...)
- oldDIAMETER (type: esriFieldTypeInteger, alias: oldDIAMETER, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [21: 2''], [1: 3"], [2: 4"], ... 18 more ...)
- CAP_ASSET_NO (type: esriFieldTypeString, alias: CAP ASSET NO, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Templates:
Name: Sewer Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- ENABLED: 1
- OWNER: 1
- TYPE: 1
- MANNING_N: 0
- STATUS_old: 1
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 2/10/2026 9:57:29 PM
Schema Last Edit Date: 2/10/2026 9:57:29 PM
Data Last Edit Date: 2/10/2026 9:57:29 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat