TTHM & HAA5 Monitoring

TCEQ uses contract samplers to collect all TTHM and HAA5 samples used for compliance with the Stage 2 Disinfection Byproduct Rule. The results in this data set are from all TTHM & HAA samples collected to date.

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-monitoring-4zd6-872p\".\"tthm_haa5_monitoring\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.