About this Dataset

DWW Pump Stations

Contains business data for drainage and waste water (DWW) pump stations. A pump station is a facility that includes pumps and other equipment that is used to move fluids from one location to another. The graphic is not a footprint of the physical structure. Data source is DWW.pump_station_plgn_pv with the following query, PS_LIFECYCLE_CODE IN ('C', 'PC', 'UNK', 'T', 'TBC', 'U'). Data is symbolized on the attribute OWNER_CODE and does not display when zoomed out beyond 1:50,000. Label is based on EQNUM.

Refreshed weekly. Maintained by SPU GIS DWW Data Maintenance staff.
Organization: City of Seattle
Last updated: 2025-02-28T23:36:43.071952
Tags: dww, pump-station, seattle-gis-open-data

Tables

Table 1

@usgov.city_of_seattle_dww_pump_stations.table_1

35.05 KB
141 rows
36 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "ply_fea_key" DOUBLE,
  "dww_feature_key" BIGINT,
  "eqnum" DOUBLE,
  "npdes_id" DOUBLE,
  "cso_facility_id" DOUBLE,
  "primary_rain_gage" VARCHAR,
  "secondary_rain_gage" VARCHAR,
  "discharge1_feature_key" DOUBLE,
  "discharge1_mnl_pt_id" VARCHAR,
  "discharge2_feature_key" DOUBLE,
  "discharge2_mnl_pt_id" VARCHAR,
  "overflow1_feature_key" DOUBLE,
  "overflow1_mnl_pt_id" VARCHAR,
  "overflow2_feature_key" DOUBLE,
  "overflow2_mnl_pt_id" VARCHAR,
  "feature_type_code" VARCHAR,
  "feature_type" VARCHAR,
  "owner_code" VARCHAR,
  "owner" VARCHAR,
  "lifecycle" VARCHAR,
  "lifecycle_desc" VARCHAR,
  "forced_main1_head_ft" DOUBLE,
  "forced_main1_length_ft" DOUBLE,
  "forced_main1_diameter_inch" DOUBLE,
  "forced_main2_head_ft" DOUBLE,
  "forced_main2_length_ft" DOUBLE,
  "forced_main2_diameter_inch" DOUBLE,
  "emergency_power_volt_phase" VARCHAR,
  "sewer_classification_type" VARCHAR,
  "sewer_classification" VARCHAR,
  "wet_well_approx_storage_time_hrs" VARCHAR,
  "comments" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);