WDFW - Lower Columbia Salmon Population and Hatchery Indicators

This dataset contains salmon population "indicator" data from WDFW's Salmon Population Indicators (SPi) database as well as newly calculated hatchery indicators (e.g., proportion of natural origin brood, proportionate natural influence) for Lower Columbia populations. It was developed as part of a pilot project to automate reporting on hatchery indicators funded by the Washington State Salmon Recovery Funding Board and sponsored by the Lower Columbia Fish Recovery Board

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 \"wa-gov/wdfw-lower-columbia-salmon-population-and-hatchery-uud8-pyb3\".\"wdfw_lower_columbia_salmon_population_and_hatchery\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.