Water Quality

Prior to downloading data, please download the <b> <a href="https://data.kingcounty.gov/api/views/vwmt-pvjw/files/74efd236-ffa8-4dee-aac1-0188e110dd1c?download=true&filename=DataReadMeFile_WQ.docx">README</a></b> file.

This dataset contains water quality samples collected from Puget Sound, lakes, and streams in the region which can be filtered by "Site Type" and "Area".

To see where water quality samples are collected, see the <b><a href="https://data.kingcounty.gov/dataset/WLRD-Sites/wbhs-bbzf">WLRD Water Quality Collection Sites</a></b> dataset.

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 \"kingcounty-gov/water-quality-vwmt-pvjw\".\"water_quality\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.