MO_2016_Section_303d_Listed_Impaired_Rivers_and_Streams_shp
This data set contains Missouri's 2016 Section 303(d) Listed Waters - Rivers and Streams and is a list of certain impaired waters in the State of Missouri. The list is a requirement of the Federal Clean Water Act and is developed biennially by the Missouri Department of Natural Resources. The list contains the names of impaired waters, their unique identification number and identification of specific pollutants and pollutant sources if they are known. This list has been modified by a state-wide public participation process and by review of the United States Environmental Protection Agency (EPA). Waters on the final EPA list must be the subject of a Total Maximum Daily Load (TMDL) study that stipulated the allowable amount of specific pollutants allowed in these waters. All waters are listed for their full size as given in 10 CSR 20-7.031 Water Quality Standards, Tables H.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"mo-gov/mo2016section303dlistedimpairedriversandstreamsshp-ivtb-g28c\".\"mo2016section303dlistedimpairedriversandstreamsshp\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.