TTHM & HAA5 Quarterly Rolling Averages Data.

Total Trihalomethanes (TTHM) and Haloacetic Acids (HAA5) are disinfection byproducts that are monitored quarterly by the Texas Commission on Environmental Quality (TCEQ). The results in this data set are calculated quarterly averages by site using the results from each sample location. Sample data for each location is available on the TTHM and HAA5 pages.

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 \"dashboard-plano-gov/tthm-haa5-quarterly-rolling-averages-data-pbib-2w2z\".\"tthm_haa5_quarterly_rolling_averages_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.