About this Dataset

Rainwise

The RainWise program helps eligible property owners manage stormwater by installing rain gardens and/or cisterns on private property. The program is jointly funded by King County and SPU as part of the effort to manage 700 million gallons of storm runoff using green infrastructure by 2025. Property owners must live in selected Combined Sewer Overflow basins to be eligible.
Organization: City of Seattle
Last updated: 2025-02-28T23:52:42.081504
Tags: best-management-practice, biofiltration, bioretention, bmp, cistern, citywide, conveyance, deciduous, evergreen, gallons-managed, green-roof, green-stormwater-infrastructure, gsi, king-county, modular-soil-cell, rain-garden, rainwise, sdci, sdot, seattle-gis-open-data, spr, spu, swale, tree, underdrain

Tables

Table 1

@usgov.city_of_seattle_rainwise.table_1

16.06 kB
2 rows
23 columns

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