Icon for Socrata external plugin
Open repository in Console
Updated 1 year ago
Indexed 18 minutes ago


Benthic Index of Biological Integrity (B-IBI) data (mean site score per survey) from Watershed Health Monitoring Surveys conducted by the Department of Ecology during 2009 through 2019. Data from Recovery Regions is intended for the 2020 State of the Salmon Report. B-IBI scores are accessible from Puget Sound Stream Benthos. See https://pugetsoundstreambenthos.org but this file uses a different rating method for "Good/Fair/Poor" that is based on percentiles of BIBI-scores from Department of Ecology reference sites during 2009-2018.

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" \
{"sql": "
    SELECT *
    FROM \"wa-gov/watershedhealthbibisos2020-aezt-3f9c\".\"watershedhealthbibisos2020\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • watershedhealthbibisos2020