Icon for Socrata external plugin
Open repository in Console
Updated 6 months ago
Indexed 3 hours ago

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" \
{"sql": "
    SELECT *
    FROM \"wa-gov/wdfw-lower-columbia-salmon-population-and-hatchery-uud8-pyb3\".\"wdfw_lower_columbia_salmon_population_and_hatchery\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • wdfw_lower_columbia_salmon_population_and_hatchery
Upstream Metadata