WDFW-SGS by US Government | Demographics and Population Studies

About this Dataset

WDFW-SGS

A nightly summary of live fish counts, dead fish counts, and redd counts stored in the WDFW Spawning Ground Survey (SGS) database.

*Disclaimer: This is an evolving dataset and does not contain every survey conducted by WDFW at this time.
Organization: State of Washington
Last updated: 2022-02-07T23:34:53.903637
Tags: salmon, spawning-ground-survey, steelhead, wdfw

Tables

Table 1

@usgov.state_of_washington_wdfw_sgs.table_1

25.09 MB
1179077 rows
59 columns


CREATE TABLE table_1 (
  "surveyid" BIGINT,
  "surveydate" TIMESTAMP,
  "starttime" VARCHAR,
  "stoptime" VARCHAR,
  "wria" BIGINT,
  "streamcatalogcode" VARCHAR,
  "streamname" VARCHAR,
  "llid" DOUBLE,
  "tributary_to" VARCHAR,
  "upperrivermile" DOUBLE,
  "lowerrivermile" DOUBLE,
  "upperlatitude" DOUBLE,
  "upperlongitude" DOUBLE,
  "lowerlatitude" DOUBLE,
  "lowerlongitude" DOUBLE,
  "reachdescription" VARCHAR,
  "datasource" VARCHAR,
  "observers" VARCHAR,
  "surveymethod" VARCHAR,
  "weather" VARCHAR,
  "streamflow" VARCHAR,
  "flowcfs" DOUBLE,
  "streamvisibility" VARCHAR,
  "streamvisibilityfeet" DOUBLE,
  "watertempfarenheit" DOUBLE,
  "surveycomment" VARCHAR,
  "surveydetailid" DOUBLE,
  "surveytype" VARCHAR,
  "speciesabbr" VARCHAR,
  "species" VARCHAR,
  "run" VARCHAR,
  "runyear" DOUBLE,
  "origin" VARCHAR,
  "estimatedpctseen" DOUBLE,
  "cwtdetectionmethod" VARCHAR,
  "livetotal" DOUBLE,
  "liveadultmale" DOUBLE,
  "liveadultfemale" DOUBLE,
  "liveadultunknownsex" DOUBLE,
  "livejack" DOUBLE,
  "deadtotal" DOUBLE,
  "deadadultmale" DOUBLE,
  "deadadultfemale" DOUBLE,
  "deadadultunknownsex" DOUBLE,
  "deadjack" DOUBLE,
  "deadpreviouslysampled" DOUBLE,
  "newreddcount" DOUBLE,
  "previousreddcount" DOUBLE,
  "combinedreddcount" DOUBLE,
  "speciescomment" VARCHAR,
  "adiposeclip_cwtbeep" DOUBLE,
  "adiposeclip_nocwtbeep" DOUBLE,
  "adiposeclip_nohead" DOUBLE,
  "noadiposeclip_cwtbeep" DOUBLE,
  "noadiposeclip_nocwtbeep" DOUBLE,
  "noadiposeclip_nohead" DOUBLE,
  "adiposeclipunknown_cwtbeep" DOUBLE,
  "adiposeclipunknown_nocwtbeep" DOUBLE,
  "adiposeclipunknown_nohead" DOUBLE
);