Name: WDFW - Salmonid Population Indicators Database (SPI) Metrics And Indicators
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

WDFW - Salmonid Population Indicators Database (SPI) Metrics And Indicators

SPI natural origin spawner abundance metrics and indicators data
Organization: State of Washington
Last updated: 2023-12-22T14:55:32.695957
Tags: natural-origin-spawner-abundance, nosa, salmon, spi, steelhead, wdfw

Tables

Table 1

@usgov.state_of_washington_wdfw_salmonid_population_indicator_e748184e.table_1

656.54 kB
5,826 rows
102 columns

CREATE TABLE table_1 (
  "id" VARCHAR,
  "commonname" VARCHAR,
  "run" VARCHAR,
  "recoverydomain" VARCHAR,
  "esu_dps" VARCHAR,
  "majorpopgroup" VARCHAR,
  "popid" BIGINT,
  "commonpopname" VARCHAR,
  "popfit" VARCHAR,
  "popfitnotes" VARCHAR,
  "estimatetype" VARCHAR,
  "waterbody" VARCHAR,
  "escapementlong" DOUBLE,
  "escapementlat" DOUBLE,
  "spawningyear" BIGINT,
  "escapementtiming" VARCHAR,
  "contactagency" VARCHAR,
  "methodnumber" BIGINT,
  "bestvalue" VARCHAR,
  "nosaij" DOUBLE,
  "nosaijlowerlimit" DOUBLE,
  "nosaijupperlimit" DOUBLE,
  "nosaijalpha" DOUBLE,
  "nosaej" DOUBLE,
  "nosaejlowerlimit" DOUBLE,
  "nosaejupperlimit" DOUBLE,
  "nosaejalpha" DOUBLE,
  "nobroodstockremoved" DOUBLE,
  "phosij" DOUBLE,
  "phosijlowerlimit" DOUBLE,
  "phosijupperlimit" DOUBLE,
  "phosijalpha" DOUBLE,
  "phosej" DOUBLE,
  "phosejlowerlimit" DOUBLE,
  "phosejupperlimit" DOUBLE,
  "phosejalpha" DOUBLE,
  "nosjf" VARCHAR,
  "nosjflowerlimit" VARCHAR,
  "nosjfupperlimit" VARCHAR,
  "nosjfalpha" VARCHAR,
  "hosjf" VARCHAR,
  "tsaij" DOUBLE,
  "tsaijlowerlimit" DOUBLE,
  "tsaijupperlimit" DOUBLE,
  "tsaijalpha" DOUBLE,
  "tsaej" DOUBLE,
  "tsaejlowerlimit" DOUBLE,
  "tsaejupperlimit" DOUBLE,
  "tsaejalpha" DOUBLE,
  "age2prop" DOUBLE,
  "age2proplowerlimit" DOUBLE,
  "age2propupperlimit" DOUBLE,
  "age3prop" DOUBLE,
  "age3proplowerlimit" DOUBLE,
  "age3propupperlimit" DOUBLE,
  "age4prop" DOUBLE,
  "age4proplowerlimit" DOUBLE,
  "age4propupperlimit" DOUBLE,
  "age5prop" DOUBLE,
  "age5proplowerlimit" DOUBLE,
  "age5propupperlimit" DOUBLE,
  "age6prop" DOUBLE,
  "age6proplowerlimit" DOUBLE,
  "age6propupperlimit" DOUBLE,
  "age7prop" DOUBLE,
  "age7proplowerlimit" DOUBLE,
  "age7propupperlimit" DOUBLE,
  "age8prop" DOUBLE,
  "age8proplowerlimit" DOUBLE,
  "age8propupperlimit" DOUBLE,
  "age9prop" DOUBLE,
  "age9proplowerlimit" VARCHAR,
  "age9propupperlimit" VARCHAR,
  "age10prop" DOUBLE,
  "age10proplowerlimit" VARCHAR,
  "age10propupperlimit" VARCHAR,
  "age11plusprop" DOUBLE,
  "age11plusproplowerlimit" VARCHAR,
  "age11pluspropupperlimit" VARCHAR,
  "agepropalpha" DOUBLE,
  "protmethurl" VARCHAR,
  "protmethdocumentation" VARCHAR,
  "methodadjustments" VARCHAR,
  "otherdatasources" VARCHAR,
  "comments" VARCHAR,
  "nullrecord" VARCHAR,
  "datastatus" VARCHAR,
  "indicatorlocation" VARCHAR,
  "metriclocation" VARCHAR,
  "measurelocation" VARCHAR,
  "contactpersonfirst" VARCHAR,
  "contactpersonlast" VARCHAR,
  "contactphone" VARCHAR,
  "contactemail" VARCHAR,
  "metacomments" VARCHAR,
  "submitagency" VARCHAR,
  "refid" DOUBLE,
  "upddate" VARCHAR,
  "dataentry" VARCHAR,
  "dataentrynotes" VARCHAR
);