About this Dataset

WDFW-Spawning Ground Surveys

A nightly summary of live fish counts, dead fish counts, and redd counts stored in the WDFW Fish Traps and Surveys (FTS) 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: 2025-07-12T19:08:35.337739
Tags: salmon, spawning-ground-survey, steelhead, survey, wdfw

Tables

Table 1

@usgov.state_of_washington_wdfw_spawning_ground_surveys.table_1

47.88 MB
1454784 rows
59 columns


CREATE TABLE table_1 (
  "survey_event_id" VARCHAR,
  "survey_date" VARCHAR,
  "start_time" VARCHAR,
  "end_time" VARCHAR,
  "wria" BIGINT,
  "stream_catalog_code" VARCHAR,
  "waterbody" VARCHAR,
  "llid" DOUBLE,
  "tributary_to" VARCHAR,
  "upper_river_mile" DOUBLE,
  "lower_river_mile" DOUBLE,
  "reach_upper_latitude" DOUBLE,
  "reach_upper_longitude" DOUBLE,
  "reach_lower_latitude" DOUBLE,
  "reach_lower_longitude" DOUBLE,
  "reach_description" VARCHAR,
  "start_point_latitude" DOUBLE,
  "start_point_longitude" DOUBLE,
  "stop_point_latitude" DOUBLE,
  "stop_point_longitude" DOUBLE,
  "data_source" VARCHAR,
  "survey_completion_status" VARCHAR,
  "observers" VARCHAR,
  "survey_event_type" VARCHAR,
  "survey_method" VARCHAR,
  "weather" VARCHAR,
  "water_visibility" VARCHAR,
  "water_clarity_m" VARCHAR,
  "water_clarity_type" VARCHAR,
  "water_temp_c" DOUBLE,
  "survey_type" VARCHAR,
  "survey_event_comment" VARCHAR,
  "run_year" DOUBLE,
  "estimated_percent_seen" DOUBLE,
  "species" VARCHAR,
  "run" VARCHAR,
  "live_total" DOUBLE,
  "live_adult_male" DOUBLE,
  "live_adult_female" DOUBLE,
  "live_adult_unknown_sex" DOUBLE,
  "live_jack" DOUBLE,
  "dead_total" DOUBLE,
  "dead_adult_male" DOUBLE,
  "dead_adult_female" DOUBLE,
  "dead_adult_unknown_sex" DOUBLE,
  "dead_jack" DOUBLE,
  "dead_previously_sampled" DOUBLE,
  "adipose_clip_cwt_beep" DOUBLE,
  "adipose_clip_no_cwt_beep" DOUBLE,
  "adipose_clip_not_wanded" DOUBLE,
  "no_adipose_clip_cwt_beep" DOUBLE,
  "no_adipose_clip_no_cwt_beep" DOUBLE,
  "no_adipose_clip_not_wanded" DOUBLE,
  "unknown_adipose_clip_cwt_beep" DOUBLE,
  "unknown_adipose_clip_no_cwt_beep" DOUBLE,
  "unknown_adipose_clip_not_wanded" DOUBLE,
  "new_redds" DOUBLE,
  "previous_redds" DOUBLE,
  "total_visible_redds" DOUBLE
);