About this Dataset

Best Management Practices

Best Management Practices (BMPs) are structural controls used to manage stormwater runoff. Examples include green roofs, rain gardens, and cisterns. BMPs reduce the effects of stormwater pollution and help restore the District’s waterbodies. The District’s stormwater regulations require that large construction or renovation projects install BMPs to manage stormwater runoff once construction is complete. The District also provides financial incentives for properties that install BMPs voluntarily. This dataset includes BMPs that were installed to comply with the District’s stormwater regulations, to participate in the Stormwater Retention Credit (SRC) trading program, to participate in the RiverSmart Homes program, to participate in the Green Roof Rebate program, or to participate in the RiverSmart Rewards stormwater fee discount program. These BMPs have been reviewed by the Department of Energy and Environment (DOEE) as part of these programs. This dataset is updated weekly with data from the District’s Stormwater Database.
Organization: District of Columbia
Last updated: 2024-04-30T18:08:08.214246
Tags: best-management-practices, bmp, dc, district-of-columbia, doee, environment, green-infrastructure, lid, pollution, retention, runoff, stormwater, swm, washington-dc, water-quality

Tables

Table 1

@usgov.district_of_columbia_best_management_practices.table_1

8.24 MB
98879 rows
59 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "bmp_id_number" VARCHAR,
  "bmp_type" VARCHAR,
  "bmp_sub_type" VARCHAR,
  "bmp_group" VARCHAR,
  "project_name" VARCHAR,
  "underdrain" BIGINT,
  "installation_date" TIMESTAMP,
  "date_removed" TIMESTAMP,
  "contributing_drainage_area_ft2" BIGINT,
  "post_project_natural_ft2" DOUBLE,
  "post_project_compacted_ft2" DOUBLE,
  "post_project_impervious_ft2" DOUBLE,
  "post_project_bmp_area_ft2" DOUBLE,
  "post_project_vehicular_ft2" DOUBLE,
  "pre_project_natural_ft2" DOUBLE,
  "pre_project_compacted_ft2" DOUBLE,
  "pre_project_impervious_ft2" DOUBLE,
  "pre_project_bmp_area_ft2" DOUBLE,
  "pre_project_vehicular_ft2" DOUBLE,
  "storage_volume_ft3" DOUBLE,
  "retention_volume_ft3" DOUBLE,
  "additional_volume_treated_ft3" DOUBLE,
  "major_drainage_basin" VARCHAR,
  "minor_drainage_basin" VARCHAR,
  "number_of_trees" DOUBLE,
  "proprietary_practice_name" VARCHAR,
  "describe_proprietary_practice" VARCHAR,
  "project_type" VARCHAR,
  "gis_last_mod_dttm" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "bmp_group_abbreviation" VARCHAR,
  "major_regulated_activity" VARCHAR,
  "src_generation" VARCHAR,
  "riversmart_rewards" VARCHAR,
  "gray_or_green_infrastructure" VARCHAR,
  "public_right_of_way" BOOLEAN,
  "plan_number" VARCHAR,
  "date_approved" TIMESTAMP,
  "sewershed" VARCHAR,
  "include_built" BOOLEAN,
  "include_all" BOOLEAN,
  "ward" DOUBLE,
  "green_roof_rebate" VARCHAR,
  "green_area_ratio" VARCHAR,
  "riversmart_homes" VARCHAR,
  "riversmart_communities" VARCHAR,
  "riversmart_schools" VARCHAR,
  "doee_maintains" VARCHAR,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "created" VARCHAR,
  "edited" VARCHAR,
  "objectid" BIGINT,
  "se_anno_cad_data" VARCHAR
);