Safe Drinking Water Facilities Information System for Pennsylvania 2018 - Current Environmental Protection

Safe Drinking Water Information System (SDWIS) is EPA’s national database that manages and collects public water system information from states, including reports of drinking water standard violations, reporting and monitoring violations, and other basic information. The data derived in the State of Pennsylvania is published and searchable online on the www.pa.gov website. This set contains the Water System Facility data, which will be updated annually for the prior calendar year in the first Quarter of the following year.

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-facilities-information-system-afhy-him4\".\"safe_drinking_water_facilities_information_system\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.