Stream Gage Hydrology Data

This dataset contains hydrologic data from stream gages in the King County Stream Gage Network. See data.kingcounty.gov/Environment-Waste-Management/WLRD-Sites/wbhs-bbzf/about_data for sites.

While this dataset exists independently; more detailed information, and access to broader data please visit the King County Hydrologic Information Center green2.kingcounty.gov/hydrology/Default.aspx

"data" is raw data, "corrected_data" is raw data with applied corrections and editing. Discharge is reported only as "corrected_data" as it is calculated off water_level data.

The King County Stream Gage Network monitors for discharge, water level, and a suite of environmental parameters. Some sites are telemetered and should update hourly to daily, barring several conditions. Many sites require field visits for data acquisition and may be delayed in reporting. Please reach out with any questions about specific sites.

This is an evolving resource, please reach out with any questions, thoughts, or suggestions.

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/stream-gage-hydrology-data-hkim-5ysi\".\"stream_gage_hydrology_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.