Safe Drinking Water Sample Results Information Systems Pennsylvania 2010 - Current Environmental Protection
Pennsylvania collects and manages public drinking water system information in the Pennsylvania Drinking Water Information System (PADWIS). <br>
The data includes water system inventory information, drinking water sample results for testing required by the regulations and violations of PA Safe Drinking Water Regulations, pertaining to monitoring/reporting requirements, MCL exceedances, and treatment techniques.
Much of this data is searchable via the www.drinkingwater.state.pa.us website. This set contains drinking water sample results reported on behalf of Pennsylvania’s regulated public water supplies.
The data is updated quarterly.
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 \"pa-gov/safe-drinking-water-sample-results-information-f6wi-njzk\".\"safe_drinking_water_sample_results_information\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.