pa-gov/safe-drinking-water-facilities-information-system-afhy-him4
Icon for Socrata external plugin
Open repository in Console
 
Readme
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 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.

 
Preview
  • safe_drinking_water_facilities_information_system
     
     
     
     
     
Upstream Metadata