Name: Citywide GSI BMP
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Citywide GSI BMP

This layer displays Citywide Green Stormwater Infrastructure Best Management Practices (City-wide GSI BMP) and Citywide Green Stormwater Infrastructure projects (City-wide GSI Project).

Citywide GSI BMP is sourced from CARTO.GSI_BMP_PT_PV. Labels are based on the attribute BMP. BMP codes listed in the BEST MANAGED PRACTICE (GB_BMP_TEXT) field are defined as follows:

Code Value	Text Value
BIO	Bioretention, infiltrating, installed by others
BIN	Bioretention, infiltrating, installed by SPU
BND	Bioretention, non-infiltrating, with detention
BSU	Biofiltration swale with underdrain
BSW	Biofiltration swale without underdrain
BUC	Bioretention swale, non-infiltrating, with underdrain in CSO basin
BUN	Bioretention Swale, non-infiltrating, with underdrain in non-CSO basin
CRG	Cistern to rain garden

Tables

Table 1

@usgov.city_of_seattle_citywide_gsi_bmp.table_1

3.33 MB
107933 rows
23 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "gb_key" BIGINT,
  "gsi_key" DOUBLE,
  "project_name" VARCHAR,
  "department" VARCHAR,
  "purpose" VARCHAR,
  "funder" VARCHAR,
  "install_year" DOUBLE,
  "sewer_classification_code" VARCHAR,
  "cso_basin_key" DOUBLE,
  "cso_basin_name" VARCHAR,
  "creek_watershed_key" DOUBLE,
  "creek_watershed_name" VARCHAR,
  "source_type" VARCHAR,
  "source_id" VARCHAR,
  "best_managed_practice" VARCHAR,
  "number_of_bmps" DOUBLE,
  "infiltration_sq_ft" DOUBLE,
  "impervious_managed_sq_ft" DOUBLE,
  "avg_annual_runoff_vol_managed_cb_ft" DOUBLE,
  "avg_annual_runoff_vol_managed_gln" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);