Willamette River decadal assessment fish dataset

Metadata:

Entity_and_Attribute_Information:

Overview_Description:

Entity_and_Attribute_Overview:

Below you will find a list and description of the files included in this data publication.


VARIABLE DESCRIPTION FILE (1)

1. \Data\_variable_descriptions.csv: Comma-separated values (CSV) file containing a list and description of variables found in all data files. (A description of these variables is also provided in the metadata below.)

Columns include:

Filename = Name of data file
Variable = Name of variable
Units = Units (if applicable)
Precision = Precision (if applicable)
Description = Description of variable


DATA FILE (1)

1. \Data\Willamette_Fish_Archive_2011-2023.csv: CSV file containing data regarding fish captured or observed in the Willamette River, Oregon, USA from 2011 to 2023 as part of the Willamette River decadal assessment project.

Variables include:

HUC8 = Name of Hydrologic Unit Code (HUC) 8 that fish was sampled in:
Lower Willamette
Middle Willamette
Upper Willamette

WRDS_RB = Name of Willamette River Decadal Survey section:
Lower Willamette
Middle Willamette
Upper Willamette

Slice_Number = Willamette River slice number, using the SLICES framework to divide the river into approximately 1 kilometer lengths (for more details, go to: https://hub.oregonexplorer.info and search for “Willamette Basin SLICES”)

Slice_ID = Combination of Willamette River slice number and slice type (mainstem or off-channel) separated by underscore. Also includes distinction between the two separate off-channels present in slice 42 (42_East_off-channel and 42_Rock_off-channel).

Repeat_Survey = Denotes whether the survey was a repeat (previously sampled) during the year:
No = not a repeat survey/not previously sampled
Yes = repeat survey

Latitude = Latitude of sampling site (decimal degrees)

Longitude = Longitude of sampling site (decimal degrees)

Slice_Type = Describes slice category:
mainstem = mainstem river
off-channel = off-channel slough area

eFishing_Type = Method used to capture fish during sampling:
boat (reach) = boat electroshocking throughout the reach
backpack (microhabitat) = backpack electroshocker
beach seine (50 ft) = 50 foot beach seine

Native_Status = Describes whether the species is native or nonnative to the Willamette River basin:
native
nonnative
unknown = fish not identified

Year = Year that sampling occurred (2011, 2012, 2013, 2021, 2022, 2023)

Date = Date of the sampling event (MM/DD/YYYY)

Reach = Stream reach or sampling pass number within the slice (1-5)

Order = Order to which the fish belongs

Family = Family to which the fish belongs

Species_Code = Species code for the identified fish

Common_Name = Common name of the identified fish

Scientific_Name = Scientific name of the identified fish

Mortality = Denotes whether the fish was a mortality (1) or not (0)

Length_mm = Length of the fish (Unit: millimeters [mm]) (blank cell indicates fish not measured)

Length_Type = Method of measuring fish length:
Fork Length = fork length (most individuals)
Total Length = total length (sculpin)
Not Measured = length not measured

Final_Weight_g = Fish weight (grams) (blank cell indicates fish weight not measured or estimated)

Weight_Method = Method of determining fish weight:
Measured = measured in field with scale
Estimated = estimated based on fish length and length-weight relationship
Not Measured or Estimated = weight not measured or estimated

Seen_Not_Captured = Code describing whether fish was captured or only observed:
0 = fish captured (length usually measured)
1 = fish observed only (seen not captured)
2 = fish length approximate (in the case of sturgeon, because they were not netted)

Notes = Field and data notes about the identified fish (blank cells indicate no notes recorded)

Number_Observed = Number of fish observed (usually 1 in the case of captured and measured individuals).

GPS_Flag = Denotes whether there are suspected errors or corrections in the GPS coordinates (i.e., Latitude and Longitude):
0 = no flags or errors noted
1 = flag or error in GPS coordinates

GPS_Notes = Notes related to GPS coordinates (i.e., Latitude and Longitude) or GPS flag code (blank cells indicate no notes recorded)

Equal_Effort_Subset = Denotes whether identified fish were included in the equal-effort subset for analysis.
(A total of 156 1-km slices were surveyed in 2011–2013 and 108 were sampled in 2021–2023. To account for differences in effort, we created an “equal-effort” subset by randomly removing sites from 2011-2013 while ensuring that all fish species encountered were still included in the reduced data. Each decade contains 108 sampling sites upstream from Willamette Falls. Repeat surveys were not included in the equal-effort subset.)
Yes = included in equal-effort subset
No = not included in equal-effort subset

Sentinel = Denotes whether the sampling location was a sentinel site (Yes) or not (No)

Entity_and_Attribute_Detail_Citation:

Penaluna, Brooke E.; Gregory, Stanley V.; Wildman, Randall; Giannico, Guillermo R.; Pollock, Amanda M. [In review]. A large river in transition: Declining native fish abundance amidst rise of nonnative fishes in the Willamette River.

Metadata_Reference_Information:

Metadata_Date: 20250724

Metadata_Contact:

Contact_Information:

Contact_Organization_Primary:

Contact_Organization: Oregon State University

Contact_Person: Stanley V. Gregory

Contact_Position: Emeritus Appointment

Contact_Address:

Address_Type: mailing and physical

Address: 104 Nash Hall

Address: 2820 SW Campus Way

City: Corvallis

State_or_Province: OR

Postal_Code: 97331

Country: USA

Contact_Voice_Telephone: 541-737-1950

Contact_Electronic_Mail_Address: stanley.gregory@oregonstate.edu

Contact Instructions: This contact information was current as of original publication date. For current information see Contact Us page on: https://doi.org/10.2737/RDS.

Metadata_Standard_Name: FGDC Biological Data Profile of the Content Standard for Digital Geospatial Metadata

Metadata_Standard_Version: FGDC-STD-001.1-1999