Water Quality Index

Monthly water quality index at active sampling sites. The Water Quality Index, or WQI,

is a number ranging from 1 to 100; a higher number indicates better water quality. In general,

stations scoring 80 and above met expectations for water quality and are of lowest concern,

scores 40 to 80 indicate moderate concern, and water quality at stations with scores below 40

did not meet expectations and are of highest concern.

Data is available from https://ecology.wa.gov/Research-Data/Monitoring-assessment/River-stream-monitoring/Water-quality-monitoring/Using-river-stream-water-quality-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 \"everettwa-gov/water-quality-index-h4q7-nr7v\".\"water_quality_index\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.