SPU DWW GSI Weirs by US Government | Demographics and Population Studies

About this Dataset

SPU DWW GSI Weirs

The DWW (Drainage and Waste Water) GSI (Green Stormwater Infrastructure) layer consists of line and polygon representations of the following features: Swales (biofiltration, bioretention, biofiltration/bioretention, and conveyance) are generally shallow depressions with a designed mix of soil and plants which break down pollutants through natural processes while reducing runoff. Permeable pavement is a paving system which allows rainfall to percolate into an underlying soil or aggregate storage reservoir. Underdrain piping systems are provided to prevent prolonged ponding of stormwater or to collect and convey water to another facility. Rain gardens are less engineered systems that are designed to mitigate water from the sidewalk only and have two inches or less of ponded depth. The drainage structures represented in the GSI points are not all unique to GSI, however, they are specifically part of SPU GSI projects.

The data is being refreshed weekly.
Organization: City of Seattle
Last updated: 2025-02-28T23:42:24.304516
Tags: biofiltration, bioretention, conveyance, dww, gis, green-roof, green-storm-infrastructure, gsi, modular-soil-cell, permeable-pavement, polygon, rain-garden, seattle-gis-open-data, silva-cell, spu, surface-drainage, surface-drainline, swale

Tables

Table 1

@usgov.city_of_seattle_spu_dww_gsi_weirs.table_1

39.88 KB
169 rows
39 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "feature_key" BIGINT,
  "assetnum" BIGINT,
  "dww_feature_key" BIGINT,
  "dww_assetnum" DOUBLE,
  "dww_d_mnlpt_id" VARCHAR,
  "dww_s_mnlpt_id" VARCHAR,
  "npdes_id" VARCHAR,
  "stream_name" VARCHAR,
  "tile_number" BIGINT,
  "gsi_project_key" BIGINT,
  "gsi_location_id" VARCHAR,
  "gsi_project_name" VARCHAR,
  "ap_featype_text" VARCHAR,
  "dww_feature_type" VARCHAR,
  "point_role_code" VARCHAR,
  "valve_feature_type" VARCHAR,
  "width_feet" DOUBLE,
  "height_feet" DOUBLE,
  "length_feet" DOUBLE,
  "material" VARCHAR,
  "owner" VARCHAR,
  "lifecycle" VARCHAR,
  "install_date" VARCHAR,
  "retire_date" VARCHAR,
  "low_orifice_flag" VARCHAR,
  "motorized" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "ap_ssdb_so_hght_ft_nbr" VARCHAR,
  "ap_ssdb_drct_s_endpt_id" VARCHAR,
  "ap_ssdb_vrt_fxd_opn_flag" VARCHAR,
  "ap_ssdb_elev_ft_nbr" VARCHAR,
  "ap_ssdb_xtype_text" VARCHAR,
  "ap_ssdb_hb_oelev_ft_nbr" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);