Icon for Socrata external plugin
Open repository in Console
Updated 11 months ago
Indexed 3 hours ago

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 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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"pa-gov/safe-drinking-water-facilities-information-system-afhy-him4\".\"safe_drinking_water_facilities_information_system\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • safe_drinking_water_facilities_information_system
Upstream Metadata