HAA5 LRAA Data
Two disinfectant byproducts (DBPs), Total Trihalomethanes (TTHMs) and Haloacedic Acids (HAA5s) are regulated by the Safe Drinking Water Act through the Stage 2 Disinfectant Byproduct Rule. The City of Bloomington Utilities collects samples for DBPs monthly at 8 testing locations throughout the distribution system and follows a quarterly compliance schedule. Compliance is calculated on a Locational Running Annual Average (LRAA). The Maximum Contaminant Levels are 80 µg/l for TTHMs and 60 µg/l for HAA5s. Micrograms per liter (µg/l) is equal to parts per billion (ppb). One part per billion is roughly equal to a teaspoon of water in an Olympic-size swimming pool.
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 \"bloomington-in-gov/haa5-lraa-data-sf3n-epsc\".\"haa5_lraa_data\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
