MO 2016 Section 305b Water Quality Report Complete Listing Of Impaired Rivers And Streams by US Government | Environmental and Climate Sciences

About this Dataset

MO 2016 Section 305b Water Quality Report Complete Listing Of Impaired Rivers And Streams

This data set contains those Missouri waters which have been assessed as impaired in 2016, including waters on Missouri's EPA Approved 2016 Section 303(d) List, but also including waters not on that list, such as waters which have a Total Maximum Daily Load (TMDL) or other appropriate management plan in place, or waters which are not impaired by a discrete pollutant. Missouri's EPA Approved 2016 303(d) List has received approval from the Environmental Protection Agency (EPA). The data set contains the names of impaired waters, their unique identification numbers and locations, and identifies specific pollutants and pollutant sources if they are known. This data set is created in conjunction with the Missouri Water Quality Report, which is produced biennially as required by Section 305(b) of the Federal Clean Water Act, and correlates to Tables 14-15 of that report.

These data were formally named: MO_2014_Section_305b_Water_Quality_Report_Complete_Listing_of_Impaired_Lakes_shp.zip and MO_2014_Section_305b_Water_Quality_Report_Complete_Listing_of_Impaired_Rivers_and_Streams_shp.zip which have been removed from MSDIS at MO Office of Administration request.
Organization: State of Missouri
Last updated: 2024-04-12T17:15:00.933294
Tags: dnr, epa, federal-clean-water-act, impaired-rivers, missouri-water-quality-report, natural-resources, streams, water

Tables

Table 1

@usgov.state_of_missouri_mo_2016_section_305b_water_quality_r_8afdbcfc.table_1

6.54 MB
7436 rows
32 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "businessid" BIGINT,
  "the_geom" VARCHAR,
  "year_cd" BIGINT,
  "wbid" DOUBLE,
  "wb_name" VARCHAR,
  "wb_cls" VARCHAR,
  "imp_size" DOUBLE,
  "wb_size" DOUBLE,
  "units" VARCHAR,
  "pollutant" VARCHAR,
  "src_desc" VARCHAR,
  "iu" VARCHAR,
  "ou" VARCHAR,
  "county_u_d" VARCHAR,
  "category" VARCHAR,
  "tmdl_sched" BIGINT,
  "tmdl_prior" VARCHAR,
  "tmdl_epaid" DOUBLE,
  "atain_date" VARCHAR,
  "media_ind" VARCHAR,
  "entire_wb" VARCHAR,
  "impr_303d" VARCHAR,
  "qa_flag" VARCHAR,
  "reachcode" BIGINT,
  "up_measure" DOUBLE,
  "dn_measure" DOUBLE,
  "createdby" VARCHAR,
  "datecreate" VARCHAR,
  "updatedby" VARCHAR,
  "dateupdate" VARCHAR,
  "db2gse_sde" DOUBLE
);