Taste and Odor
Taste and odor issues with drinking water stem from the presence of the organic compounds known as methylisoborneol (MIB) and geosmin. These two compounds are not harmful to human health. Rather, the presence of MIB and geosmin negatively affect the drinking water's aesthetics (geosmin causes an earthy smell, while MIB causes a musty taste). Taste and odor thresholds vary from person to person, but normally geosmin can be detected as low as 7-15 parts per trillion, while MIB can be detected as low as 20-30 parts per trillion.
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/taste-and-odor-uxrf-d4qy\".\"taste_and_odor\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.