About this Dataset

MO 2016 Section 305b Water Quality Report Complete Listing Of Impaired Lakes

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.
Organization: State of Missouri
Last updated: 2024-04-12T17:15:31.540403
Tags: dnr, epa, federal-clean-water-act, impaired-lakes, lake, missouri-water-quality, natural-resources, water

Tables

Table 1

@usgov.state_of_missouri_mo_2016_section_305b_water_quality_r_f6350aa3.table_1

4.82 MB
87 rows
31 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "businessid" BIGINT,
  "year_cd" BIGINT,
  "objectid" BIGINT,
  "wbid" BIGINT,
  "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" DOUBLE,
  "createdby" VARCHAR,
  "datecreate" VARCHAR,
  "updatedby" VARCHAR,
  "dateupdate" VARCHAR,
  "db2gse_st" DOUBLE,
  "db2gse_sde" DOUBLE
);