Habitat Project Focus Metrics (12-04-2020)

Included here are restoration measures for three types of projects: riparian habitat treatments, estuary habitat treatments, and fish passage barrier corrections.

For more detailed information about these essential activities, visit the Recreation and Conservation Office’s Salmon Recovery Portal and PRISM Project Search public databases, the Lower Columbia Fish Recovery Board’s SalmonPORT, and data from the Washington Department of Natural Resources, State Parks, Washington Department of Fish and Wildlife, and Washington Department of Transportation.

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/habitat-project-focus-metrics-12042020-mibg-3zz6\".\"habitat_project_focus_metrics_12042020\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.