About this Dataset

SPU DWW Mainline Detention Lines

SPU DWW Mainlines is a Group Layer containing all Lifecycles, Ownerships, and other variations of Drainage and Wastewater Mainlines. The Connected Mainlines are symbolized differently in two different layers, one displaying the Permitted Use of the pipe and another displaying the Probable Flow.

Permitted Use describes the intended use of the pipe, including Sanitary, Combined, or Drainage flows. Probable Flow takes into account upstream pipes and makes an assumption on the type of flow within the pipes.

Proposed Mainlines are planned but not yet installed or as-built.

SPU DWW Aba Rem Mainlines refers to Abandoned and Removed Mainlines.

Force Mainlines are Mainlines under pressure. Detention Lines and Polygons refer to Mainline Detention Infrastructure.

The data is refreshed weekly and is maintained by the SPU GIS Data Maintenance Team.
Organization: City of Seattle
Last updated: 2025-02-28T23:40:55.532986
Tags: combined, drainage, dww, mainline, seattle-gis-open-data, sewer, spu

Tables

Table 1

@usgov.city_of_seattle_spu_dww_mainline_detention_lines_0d238.table_1

84.78 kB
368 rows
56 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "fea_key" BIGINT,
  "component_key" BIGINT,
  "ups_feature_key" BIGINT,
  "dns_feature_key" BIGINT,
  "assetnum" DOUBLE,
  "ups_endpt_id" VARCHAR,
  "dns_endpt_id" VARCHAR,
  "mainline_pt_id" VARCHAR,
  "map_area_id" VARCHAR,
  "ssc2001_id" VARCHAR,
  "npdes_id" VARCHAR,
  "featype" VARCHAR,
  "featype_desc" VARCHAR,
  "owner" VARCHAR,
  "mnl_owner_name" VARCHAR,
  "parallel" VARCHAR,
  "parallel_desc" VARCHAR,
  "prbl_flow" VARCHAR,
  "prbl_flow_desc" VARCHAR,
  "use_permit" VARCHAR,
  "use_permit_desc" VARCHAR,
  "material_code" VARCHAR,
  "mnl_material_type" VARCHAR,
  "pipe_shp" VARCHAR,
  "pipe_shp_desc" VARCHAR,
  "lifecycle" VARCHAR,
  "mnl_lifecycle_stat" VARCHAR,
  "cnvync_type" VARCHAR,
  "dstntn_type" VARCHAR,
  "overflow_flag" VARCHAR,
  "pump_flag" VARCHAR,
  "cunette_flag" VARCHAR,
  "casing_flag" VARCHAR,
  "lining_flag" VARCHAR,
  "perf_pipe_flag" VARCHAR,
  "length_ft" DOUBLE,
  "fcnlength_ft" DOUBLE,
  "width_in" DOUBLE,
  "height_in" DOUBLE,
  "slope_pct" DOUBLE,
  "ups_depth_ft" DOUBLE,
  "dns_depth_ft" DOUBLE,
  "ups_elev_ft" DOUBLE,
  "dns_elev_ft" DOUBLE,
  "prbl_flow_symbol" BIGINT,
  "use_permit_symbol" BIGINT,
  "inc_mnl" DOUBLE,
  "install_date" VARCHAR,
  "retire_date" VARCHAR,
  "lst_updt_date" VARCHAR,
  "stream_name" VARCHAR,
  "cctv_date" VARCHAR,
  "cctv_collapse_flag" VARCHAR,
  "mxm_adrs" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);