About this Dataset

SPU DWW Storm Outfalls

This layer displays all outfalls within the City of Seattle (and the former service area north of the City limits) regardless of ownership. Selected Maximo data are included. Displays data from DWW.outfall_pt_pv with the following definition query, OUT_LIFECYCLE_CODE IN ( 'C' , 'UNK' ,'T','TBC','U', 'PC'). Layer is symbolized on the attribute OWNER. This layer does not display when zoomed out beyond 1:10,000. Labels are based on the attributes OUT_S_ENDPT_ID, OUT_D_ENDPT_ID, and OUT_OUTFALL_ID. Labels do not display when zoomed out beyond 1:3,000.

Refreshed weekly
Organization: City of Seattle
Last updated: 2025-02-28T23:29:04.378219
Tags: dww-outfalls, outfall, seattle-gis-open-data

Tables

Table 1

@usgov.city_of_seattle_spu_dww_storm_outfalls.table_1

286.09 KB
2401 rows
44 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "fea_key" BIGINT,
  "assetnum" DOUBLE,
  "s_endpt_id" VARCHAR,
  "d_endpt_id" VARCHAR,
  "npdes_id" DOUBLE,
  "outfall_id" DOUBLE,
  "map_area_id" VARCHAR,
  "cso_desc" VARCHAR,
  "owner" VARCHAR,
  "owner_desc" VARCHAR,
  "lifecycle" VARCHAR,
  "lifecycle_desc" VARCHAR,
  "cvr_elev_ref" VARCHAR,
  "cvr_elev_ref_desc" VARCHAR,
  "out_role" VARCHAR,
  "out_role_type" VARCHAR,
  "pipe_material" VARCHAR,
  "pipe_material_desc" VARCHAR,
  "prbl_flow" VARCHAR,
  "prbl_flow_desc" VARCHAR,
  "out_2005_study_flag" VARCHAR,
  "cvr_elev_ft" DOUBLE,
  "pipe_height_in" DOUBLE,
  "pipe_width_in" DOUBLE,
  "rotation" BIGINT,
  "symbol" DOUBLE,
  "x_coord" DOUBLE,
  "y_coord" DOUBLE,
  "draindischarge_id" VARCHAR,
  "sub_basin_id" VARCHAR,
  "surface_drainage_id" VARCHAR,
  "rec_waterbody" VARCHAR,
  "creekwatershed" VARCHAR,
  "dbasin" VARCHAR,
  "install_date" VARCHAR,
  "retire_date" VARCHAR,
  "npdes_adrs_text" VARCHAR,
  "npdes_actv_flag" VARCHAR,
  "long_coord" DOUBLE,
  "lat_coord" DOUBLE,
  "globalid" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);