Watershed Water Quality Data

Data collected to fulfill the requirements of the SWTR (Surface Water Treatment Rule) and FAD (Filtration Avoidance Determination). Data is collected via grab sampling, analysis, LIMS data capture and reporting. Each record represents either a four hour turbidity result, a 24 hour average turbidty result, or a daily fecal coliform result from DEL18DT (Delaware Shaft 18 downtake). Data is used to monitor compliance with the requirements above. There are no limitations for the data.

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 \"cityofnewyork-us/watershed-water-quality-data-y43c-5n92\".\"watershed_water_quality_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.