Name: SPU DWW Mainlines (Probable Flow)
Display Field: MNL_OWNER_NAME
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description: This layer displays all connected or to be connected drainage, sanitary, and combined mainline pipes within the City of Seattle (and the former service area north of the City limits) regardless of ownership and not including detention systems. Probable flow is the derived use classification based on what is the best estimation of usage broken out by combined sewer, drainage, and sanitary. A combined sewer is a type of sewer system that collects sanitary sewage and stormwater runoff into a single pipe system. A sanitary sewer is a type of underground system for transporting sewage . A drainage system transports waste water from buildings and water run-off from streets.
Copyright Text:
Min. Scale: 20000
Max. Scale: 0
Default Visibility: false
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 1242453.58466107
YMin: 180107.223404482
XMax: 1297959.59361391
YMax: 284755.155671641
Spatial Reference: 2926 (2926)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"MNL_PRBL_FLOW_SYM_NUM","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,255,255,255],"width":1.5},"value":"5","label":"SPU Drainage Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,255,255],"width":1.5},"value":"6","label":"SPU Sanitary Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,153,0,255],"width":1.5},"value":"8","label":"SPU Combined Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[112,168,0,255],"width":1.9},"value":"4","label":"King County Drainage Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[2,219,0,255],"width":1.9},"value":"3","label":"King County Sewer Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,255,255,255],"width":0.75},"value":"15","label":"Private Drainage Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,255,255],"width":0.75},"value":"16","label":"Private Sanitary Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,153,0,255],"width":0.75},"value":"18","label":"Private Combined Main"},{"symbol":{"type":"esriSLS","style":"esriSLSDashDot","color":[156,156,156,255],"width":1.5},"value":"97","label":"Phantom Connector"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriHSVAlgorithm","fromColor":[56,168,0,255],"toColor":[255,255,0,255]},{"type":"algorithmic","algorithm":"esriHSVAlgorithm","fromColor":[255,255,0,255],"toColor":[255,0,0,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.MNL_WIDTH_IN_NBR + \" \" + $feature.MNL_MATERIAL_CODE","title":"Custom"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"none","multiPart":"labelPerFeature","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"MNL_LIFECYCLE_CODE <> 'PC'","useCodedValues":true,"maxScale":0,"minScale":1799,"name":"Default","priority":42,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"center","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[250,250,250,255],"haloSize":1,"font":{"family":"Arial","size":8,"style":"normal","weight":"normal","decoration":"none"}}},{"labelExpressionInfo":{"expression":"$feature.MNL_WIDTH_IN_NBR + \" \" + $feature.MNL_MATERIAL_CODE + \" \" + $feature.MNL_LIFECYCLE_CODE","title":"Custom"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"none","multiPart":"labelPerFeature","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"MNL_LIFECYCLE_CODE = 'PC'","useCodedValues":true,"maxScale":0,"minScale":1799,"name":"pc","priority":66,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"center","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[250,250,250,255],"haloSize":1,"font":{"family":"Arial","size":8,"style":"normal","weight":"normal","decoration":"none"}}}]}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field: MNL_PRBL_FLOW_SYM_NUM
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- MNL_FEA_KEY (type: esriFieldTypeInteger, alias: FEA_KEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MNL_CMPNT_KEY (type: esriFieldTypeInteger, alias: COMPONENT_KEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MNL_UPS_FEATURE_KEY (type: esriFieldTypeInteger, alias: UPS_FEATURE_KEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MNL_DNS_FEATURE_KEY (type: esriFieldTypeInteger, alias: DNS_FEATURE_KEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MNL_EQNUM_ID (type: esriFieldTypeString, alias: ASSETNUM, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- MNL_UPS_ENDPT_ID (type: esriFieldTypeString, alias: UPS_ENDPT_ID, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
- MNL_DNS_ENDPT_ID (type: esriFieldTypeString, alias: DNS_ENDPT_ID, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
- MNL_MNLPT_ID (type: esriFieldTypeString, alias: MAINLINE_PT_ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- MNL_MAP_AREA_ID (type: esriFieldTypeString, alias: MAP_AREA_ID, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- MNL_SSC2001_ID (type: esriFieldTypeString, alias: SSC2001_ID, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
- MNL_NPDES_ID (type: esriFieldTypeString, alias: NPDES_ID, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- MNL_FEATYPE_CODE (type: esriFieldTypeString, alias: FEATYPE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- MNL_FEATYPE_TEXT (type: esriFieldTypeString, alias: FEATYPE_DESC, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- MNL_OWNER_CODE (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- MNL_OWNER_NAME (type: esriFieldTypeString, alias: OWNER_DESC, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- MNL_PARALLEL_CODE (type: esriFieldTypeString, alias: PARALLEL, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- MNL_PARALLEL_TEXT (type: esriFieldTypeString, alias: PARALLEL_DESC, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- MNL_PRBL_FLOW_CODE (type: esriFieldTypeString, alias: PRBL_FLOW, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- MNL_PRBL_FLOW_TEXT (type: esriFieldTypeString, alias: PRBL_FLOW_DESC, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- MNL_USE_PERMIT_CODE (type: esriFieldTypeString, alias: USE_PERMIT, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- MNL_USE_PERMIT_TEXT (type: esriFieldTypeString, alias: USE_PERMIT_DESC, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- MNL_MATERIAL_CODE (type: esriFieldTypeString, alias: MATERIAL_CODE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- MNL_MATERIAL_TYPE (type: esriFieldTypeString, alias: MATERIAL_DESC, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- MNL_PIPE_SHP_CODE (type: esriFieldTypeString, alias: PIPE_SHP, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- MNL_PIPE_SHP_TEXT (type: esriFieldTypeString, alias: PIPE_SHP_DESC, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- MNL_LIFECYCLE_CODE (type: esriFieldTypeString, alias: LIFECYCLE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- MNL_LIFECYCLE_STAT (type: esriFieldTypeString, alias: LIFECYCLE_DESC, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- MNL_CNVYNC_TYPE (type: esriFieldTypeString, alias: CONVEYANCE_TYPE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- MNL_DSTNTN_TYPE (type: esriFieldTypeString, alias: DESTINATION_TYPE, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- MNL_OVRFLW_FLAG (type: esriFieldTypeString, alias: OVERFLOW_FLAG, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- MNL_PUMP_FLAG (type: esriFieldTypeString, alias: PUMP_FLAG, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- MNL_CUNETTE_FLAG (type: esriFieldTypeString, alias: CUNETTE_FLAG, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- MNL_CASING_FLAG (type: esriFieldTypeString, alias: CASING_FLAG, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- MNL_LINING_FLAG (type: esriFieldTypeString, alias: LINING_FLAG, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- MNL_PERF_PIPE_FLAG (type: esriFieldTypeString, alias: PERF_PIPE_FLAG, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- MNL_LENGTH_FT_NBR (type: esriFieldTypeDouble, alias: LENGTH_FT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MNL_FCNLENGTH_FT_NBR (type: esriFieldTypeDouble, alias: FCNLENGTH_FT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MNL_WIDTH_IN_NBR (type: esriFieldTypeSingle, alias: WIDTH_IN, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MNL_HEIGHT_IN_NBR (type: esriFieldTypeSingle, alias: HEIGHT_IN, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MNL_SLOPE_PCT_NBR (type: esriFieldTypeSingle, alias: SLOPE_PCT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MNL_UPS_DEPTH_FT_NBR (type: esriFieldTypeDouble, alias: UPS_DEPTH_FT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MNL_DNS_DEPTH_FT_NBR (type: esriFieldTypeDouble, alias: DNS_DEPTH_FT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MNL_UPS_ELEV_FT_NBR (type: esriFieldTypeDouble, alias: UPS_ELEV_FT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MNL_DNS_ELEV_FT_NBR (type: esriFieldTypeDouble, alias: DNS_ELEV_FT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MNL_PRBL_FLOW_SYM_NUM (type: esriFieldTypeSmallInteger, alias: PRBL_FlOW_SYMBOL, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MNL_USE_PERMIT_SYM_NUM (type: esriFieldTypeSmallInteger, alias: USE_PERMIT_SYMBOL, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MNL_INC_MNL_NBR (type: esriFieldTypeSmallInteger, alias: INC_MAINLINE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MNL_INSTALL_DATE (type: esriFieldTypeDate, alias: INSTALL_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- MNL_RETIRE_DATE (type: esriFieldTypeDate, alias: RETIRE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- MNL_LST_UPDT_DATE (type: esriFieldTypeDate, alias: LAST_UPDATE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- MNL_STREAM_NAME (type: esriFieldTypeString, alias: STREAM_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- MNL_CCTV_DATE (type: esriFieldTypeDate, alias: CCTV_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- MNL_CCTV_COLLAPSE_FLAG (type: esriFieldTypeString, alias: CCTV_COLLAPSE_FLAG, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- MNL_MXM_ADRS_TEXT (type: esriFieldTypeString, alias: MXM_ADDRESS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: true)
Types:
ID: 5
Name: SPU Drainage Main
Domains:
Templates:
Name: SPU Drainage Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
ID: 6
Name: SPU Sanitary Main
Domains:
Templates:
Name: SPU Sanitary Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
ID: 8
Name: SPU Combined Main
Domains:
Templates:
Name: SPU Combined Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
ID: 4
Name: King County Drainage Main
Domains:
Templates:
Name: King County Drainage Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
ID: 3
Name: King County Sewer Main
Domains:
Templates:
Name: King County Sewer Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
ID: 15
Name: Private Drainage Main
Domains:
Templates:
Name: Private Drainage Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- MNL_PRBL_FLOW_SYM_NUM: 15
ID: 16
Name: Private Sanitary Main
Domains:
Templates:
Name: Private Sanitary Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- MNL_PRBL_FLOW_SYM_NUM: 16
ID: 18
Name: Private Combined Main
Domains:
Templates:
Name: Private Combined Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- MNL_PRBL_FLOW_SYM_NUM: 18
ID: 97
Name: Phantom Connector
Domains:
Templates:
Name: Phantom Connector
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- MNL_PRBL_FLOW_SYM_NUM: 97
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 12/23/2025 12:52:05 AM
Schema Last Edit Date: 12/23/2025 12:52:05 AM
Data Last Edit Date: 12/23/2025 12:52:05 AM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat