About this Dataset

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
Organization: State of Washington
Last updated: 2023-12-22T14:55:31.910918
Tags: hatchery, indicator, phos, pni, pnob, vsp, wdfw

Tables

Table 1

@usgov.state_of_washington_wdfw_lower_columbia_salmon_populat_623e105b.table_1

46.55 kB
935 rows
19 columns

CREATE TABLE table_1 (
  "esa_population_name" VARCHAR,
  "brood_year" BIGINT,
  "species" VARCHAR,
  "pnob" VARCHAR,
  "phob" VARCHAR,
  "total_releases" BIGINT,
  "popfit" VARCHAR,
  "best_value" VARCHAR,
  "nosaij" VARCHAR,
  "nosaej" VARCHAR,
  "phosij" VARCHAR,
  "phosej" VARCHAR,
  "tsaij" VARCHAR,
  "tsaej" VARCHAR,
  "phos" VARCHAR,
  "pnos" VARCHAR,
  "pni" VARCHAR,
  "nosa" VARCHAR,
  "tsa" VARCHAR
);