Name: Sewer Main
Display Field: MAIN_ID
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description: The Mains layer contains GIS information about force mains for sanitary sewers within the service area of the City of Puyallup.
Copyright Text: CoP Public Works, CoP GIS
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: 1184083.62950864
YMin: 665964.577308983
XMax: 1208087.52342989
YMax: 692267.598849803
Spatial Reference: 2927 (2927)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[56,168,0,255],"width":2}},"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)
- MAIN_ID (type: esriFieldTypeString, alias: Puyallup_ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- MAIN_DIAMETER (type: esriFieldTypeSmallInteger, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MAIN_ADD_NUM (type: esriFieldTypeInteger, alias: Address, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MAIN_ADD_STR (type: esriFieldTypeString, alias: Route, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- MAIN_UPNODE (type: esriFieldTypeString, alias: UpNode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- MAIN_DOWNNODE (type: esriFieldTypeString, alias: DownNode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- MAIN_SUBDIV (type: esriFieldTypeString, alias: Subdivision, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- MAIN_NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- MAIN_UP_MH (type: esriFieldTypeString, alias: UP_MH, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- MAIN_DOWN_MH (type: esriFieldTypeString, alias: DOWN_MH, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- MAIN_BASIN (type: esriFieldTypeInteger, alias: Sewer_Basin, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MAIN_TYPE (type: esriFieldTypeSmallInteger, alias: MAIN_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Collector], [9: Interceptor], [18: Main], ... 1 more ...)
- MAIN_JURISDICTION (type: esriFieldTypeSmallInteger, alias: MAIN_JURISDICTION, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Commercial], [10: CoP Parks], [15: CoP PW], ... 2 more ...)
- MAIN_SURF_COV (type: esriFieldTypeSmallInteger, alias: MAIN_SURF_COV, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Asphalt], [10: Concrete], [15: Dense Vegetation], ... 8 more ...)
- MAIN_FLOWDIR (type: esriFieldTypeSmallInteger, alias: MAIN_FLOWDIR, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: North], [45: Northeast], [90: East], ... 5 more ...)
- MAIN_DIS_DEST (type: esriFieldTypeSmallInteger, alias: MAIN_DIS_DEST, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [10: Clean Out], [20: Lateral], [30: Main], ... 3 more ...)
- MAIN_YEAR (type: esriFieldTypeSmallInteger, alias: Year Installed, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MAIN_MATERIAL (type: esriFieldTypeSmallInteger, alias: Material, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [12: Asbestos Concrete], [13: Cast Iron], [14: Clay Tile], ... 10 more ...)
- MAN_GPSDATE (type: esriFieldTypeDate, alias: GPS Date (manual), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Main_LENGTH_D (type: esriFieldTypeDouble, alias: Length (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
- 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)
- 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)
- MAIN_NASSCO (type: esriFieldTypeString, alias: NASSCO_Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [AC: AC], [CAS: CAS], [CMP: CMP], ... 9 more ...)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Templates:
Name: Sewer Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 5/22/2025 4:41:43 PM
Schema Last Edit Date: 5/22/2025 4:41:43 PM
Data Last Edit Date: 5/22/2025 4:41:43 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat