Formatting and Instructions:

Fish Trapping Surveys

This template contains data elements that are typically collected when fish trapping is conducted. If you collect data using a rotary screw trap you will need to add a few fields, including start and end times, revolutions/min, and an odometer reading.

All the Excel worksheets containing drop-down list choices (inbold) are currently hidden. To unhide them, go to Format>SheetUnhide, and select whichever Table you wish to view. You must unhide sheets one at a time. You may also wish to add choices to the drop-down options that better fit your particular project. To add a choice, go to the relevant Table; create a new code and definition.

Adding Data Elements

If you collect data elements other than those listed within the template, please feel free to add them and label them as you wish, or delete data elements you do not collect, provided that you retain the minimum core data elements. We ask that you do not change the field names, as this will keep data collected by all entities comparable. Changing field names may also render the Pivot Table reports unusable. If the field name is unclear, you can always change the caption so it makes more sense.

Population Estimates

Excel spreadsheets for calculating population estimates have been created by staff in the Life Cycle Monitoring Program at the Oregon Dept. of Fish and Wildlife. You can access and download spreadsheets and instructions for calculating population estimates from their website:

DATA DICTIONARY

Required Data Elements

Required data elements are listed in bold below. Data elements that are required depending on circumstances are in bold and italics. Notes below each data Dictionary table describe when the conditional data elements are required.

KLB111/13/2018

Field Name / Field Description / Data Type / Codes/Conventions
ProjDocNum / Individual number identifying the project documentation / Long Integer
Basin / A unique 6 digit code for the third level of classification (accounting unit) or 3rd field HUC (Hydrologic Unit Code). / Text 6 / SeeBasin table and map. 170900 is the BasinID for the Willamette
Subbasin / A unique 8 digit code for the fourth level of classification (cataloging unit) or 4th field HUC (Hydrologic Unit Code). Generally represents part or all of a surface drainage basin, combination of drainage basins, or a distinct hydrologic feature. Sometimes also called a “watershed”. / Text 8 / SeeSubbasin table and map. 17090003 is the SubbasinID for the Upper Willamette
LLID / A standard, unique 13 digit code that identifies an individual stream or body of water. LLID as used in this document refers to a stream code assigned at the 1:100,000 scale hydrography. LLIDs are created by GIS personnel in state Fish and Wildlife Agencies (such as ODFW in Oregon). / Text 13 / 1227618456580 is the LLID for the WillametteRiver
Stream Name / Name of stream / Text 50
Trap Site / Description of trap site / Text 50
Latitude / Latitude at trap site, in decimal degrees / Single / 12.34567
Longitude / Longitude at trap site, in decimal degrees / Single / 123.45678
Date / Date of trapping event / Date / MM/DD/YYYY
Time / Time of arrival at trap / Time / 24 hr clock
Trap ID / Identification number associated with a trap (like a serial number) / Long Integer
Trap Type / Type of trap / Byte / FNT = Frame-net Trap
HP = Hoop Trap
IPT = Inclined Plane Trap
MT = Minnow Trap
O = Other / PT = Pipe Trap
ST = Screw Trap
U = Unknown
W = Weir
HY = Hybrid of multiple types
Crew / Names of crew members checking the trap / Text 50 / If crews are often the same, a lookup table could be created
Weather / Average weather during trapping / Text 2 / SU = Sunny
O = Overcast
P = Partly-Cloudy
R = Raining
S = Snow
ST = Sleet / HL = Hail
F = Fog
C = Clear
OT = Other
U = Unknown
NR = Not Recorded
Staff gauge reading / Water height (m) at guage / Single / Record if gauge exists at or near trapping site
Stream Flow / Visual estimate of stream flow / Text 3 / DR = Dry
L = Low Flow
M = Moderate Flow
H = High Flow
BF = Bankful Flow / F = Flooding
O = Other
U = Unknown
NR = Not Recorded
Species / Species of fish capturing during electro-fishing pass / Text 3 / See Species table
Life Stage / Life stage of fish / Text 2 / NA = N/A
EG = Egg
FR = Fry or larvae
FG = Fingerling
Z = Sub-yearling (Age 0)
SM = Smolt
JK = Jack or SubAdult / AD = Adult
AJ = Adults and jacks
JUV = Juvenile
P = Parr
O = Other
U = Unknown
Count / Total number of fish / Integer
Length (mm) / Length of fish (mm) / Single
Length Method / Method used to measure length of fish / Text 2 / FL = Fork Length
ML = MEPS Length
NA = N/A / O = Other
TL = Total Length
U = Unknown
Size Class / Size class of fish / Byte / 1 = <60 mm
2 = 60-89 mm
3 = 90-119 mm / 4 = 120-159mm
5 = >160 mm
Sex Class / Sex of fish / Text 15 / Male, Female, Unknown
Recapture / Is the fish a recapture? i.e. tagged during another trapping event / Yes/No
Mortality / Is the fish mortality? / Yes/No
Mark Status / Status of the mark / Text 50 / New = Mark applied during this trapping event
Existing = Mark applied during a previous trapping event
None Visible = No applied mark visible
Type of Mark / Type of mark / Text 3 / CWT = Coded Wire Tag
D = Dye
EL = Elastomer
FC = Fin Clip
FT = Floy Tag / O = Other
P = Punch
PIT = PIT tag
RT = Radio Tag
U = Unknown
Left/Right / Is the mark on the left or right side? / Text 5 / Left; Right
Mark Location / General location of mark – often used to describe location of operculum punches / Text 3 / A = Above Center
B = Below Center
C = Center
D = Double / NA = Not Applicable
O = Other
U = Unknown
Mark Anatomy / Anatomical part of the fish that has been marked / Text 3 / AD = Adipose
AN = Anal
B = Belly
C = Caudal
D = Dorsal
J = Jaw
MX = Maxillary / O = Other
OP = Operculum
PT = Pectoral
PV = Pelvic
SN = Snout
U = Unknown
V = Ventral
Mark Color / Color of mark / Text 2 / B = Blue
BL = Black
BR = Brown
GN = Green
GR = Grey
NA = Not Applicable / OR = Orange
OT = Other
P = Purple
R = Red
U = Unknown
W = White
Y = Yellow
Comments / Any additional information about the fish / Memo

**The marking/tagging fields only required if tagging takes place. Size class or Life stage are required, both can be entered if desired.

Project Documentation Table – this table includes the information about the project and documents methods and purpose.

Field Name / Field Description / Data Type / Codes/Conventions
ProjDocID / Individual number identifying the project documentation / AutoNumber
ProjName / Descriptive name of project / Text
OrgName / Name of the organization undertaking data collection / Text
Methods / Name of or brief description of methods used, may also include citation for methods / Memo
Purpose / Brief description of purpose, or citation for purpose / Memo

Basin Table:

BasinID / Basin_Name
160402 / BlackRockDesert
170501 / Middle Snake-Boise
170502 / Middle Snake-Powder
170601 / Lower Snake
170701 / Middle Columbia
170702 / John Day
170703 / Deschutes
170800 / Lower Columbia
170900 / Willamette
171002 / Northern Oregon Coastal
171003 / Southern Oregon Coastal
171200 / Oregon Closed Basins
180101 / Northern California Coastal
180102 / Klamath
180200 / Upper Sacramento

Subbasin Table:

SubbasinID / Subbasin_Name / SubbasinID / Subbasin_Name / SubbasinID / Subbasin_Name
16040201 / Upper Quinn / 17070304 / Upper Crooked / 17100308 / Middle Rogue
16040205 / Thousand-Virgin / 17070305 / Lower Crooked / 17100309 / Applegate
17050103 / Middle Snake-Succor / 17070306 / Lower Deschutes / 17100310 / Lower Rogue
17050105 / South Fork Owyhee / 17070307 / Trout / 17100311 / Illinois
17050106 / East Little Owyhee / 17080001 / Lower Columbia-Sandy / 17100312 / Chetco
17050107 / Middle Owyhee / 17080003 / Lower Columbia-Clatskanie / 17120001 / Harney-MalheurLakes
17050108 / Jordan / 17080006 / Lower Columbia / 17120002 / Silvies
17050109 / Crooked-Rattlesnake / 17090001 / Middle Fork Willamette / 17120003 / Donner und Blitzen
17050110 / Lower Owyhee / 17090002 / Coast Fork Willamette / 17120004 / Silver
17050115 / Middle Snake-Payette / 17090003 / Upper Willamette / 17120005 / SummerLake
17050116 / Upper Malheur / 17090004 / McKenzie / 17120006 / LakeAbert
17050117 / Lower Malheur / 17090005 / North Santiam / 17120007 / WarnerLakes
17050118 / Bully / 17090006 / South Santiam / 17120008 / Guano
17050119 / Willow / 17090007 / Middle Willamette / 17120009 / AlvordLake
17050201 / Brownlee Reservoir / 17090008 / Yamhill / 18010101 / SmithRiver
17050202 / Burnt River / 17090009 / Molalla-Pudding / 18010201 / Williamson
17050203 / Powder River / 17090010 / Tualatin / 18010202 / Sprague
17060101 / Hells Canyon / 17090011 / Clackamas / 18010203 / Upper Klamath Lake
17060102 / ImnahaRiver / 17090012 / Lower Willamette / 18010204 / Lost River
17060103 / Lower Snake-Asotin / 17100201 / Necanicum / 18010205 / Butte
17060104 / UpperGrandeRondeRiver / 17100202 / Nehalem / 18010206 / Upper Klamath River
17060105 / WallowaRiver / 17100203 / Wilson-Trask-Nestucca / 18010209 / Lower Klamath River
17060106 / Lower Grande Ronde / 17100204 / Siletz-Yaquina / 18020001 / GooseLake
17070101 / Middle Columbia-Lake Wallula / 17100205 / Alsea
17070102 / Walla Walla / 17100206 / Siuslaw
17070103 / Umatilla / 17100207 / Siltcoos
17070104 / Willow / 17100301 / North Umpqua
17070105 / Middle Columbia-Hood / 17100302 / South Umpqua
17070106 / Klickitat / 17100303 / Umpqua
17070201 / Upper John Day / 17100304 / Coos
17070202 / North Fork John Day / 17100305 / Coquille
17070203 / Middle Fork John Day / 17100306 / Sixes
17070204 / Lower John Day / 17100307 / Upper Rogue

Species Table:

SpeciesID / Species Name / Scientific Name / SpeciesID / Species Name / Scientific Name
AM / ammocoetes / Petromyzontidae / OC / Oregon chub / Oregonichthys crameri
AS / Atlantic salmon / Salmo salar / PGS / pacific giant salamander / Dicamptodon tenebrosus
ATF / adult tailed frog / Ascaphus truei / PK / pumpkinseed / Lepomis gibbosus
BG / bluegill / Lepomis macrochirus / PL / Pacific lamprey
BLB / black bullhead / Ameiurus melas / PM / peamouth / Mylocheilus caurinus
BR / brown trout / Salmo trutta / PS / pink salmon / Oncorhynchus gorbuscha
BRB / brown bullhead / Ameiurus nebulosus / RB / rainbow trout / Oncorhynchus mykiss
BSU / bridgelip sucker / Catostomus columbianus / RO / roach
BT / brook trout / Salvelinus confluentus / RSN / rough skin newt
BTH / brook/bull hybrid / Salvelinus fontinalis x confluentus / RSS / redside shiner / Richardsonius balteatus
BUT / bull trout / Salvelinus confluentus / RT / redband trout / Oncorhynchus mykiss subsp.
C / crappie / Pomoxis sp / RTS / reticulate sculpin / Cottus perplexus
CC / channel catfish / Ictalurus punctatus / SAL / salamander
CF / crayfish / SB / smallmouth bass / Micropterus dolomieu
CH / chinook salmon / Oncorhynchus tshawytscha / SF / salmonid fry (age 0+)
CLM / chiselmouth / Acrocheilus alutaceus / SH / shiner spp.
CO / coho salmon / Oncorhynchus kisutch / SKB / threespine stickleback / Gasterosteus aculeatus aculeatus
COT / sculpin / Cottus sp / SNF / sunfish
CP / carp / Cyprinus sp / SPD / speckled dace / Rhinichthys osculus
CS / chum salmon / Oncorhynchus keta / SQ / northern pikeminnow / Ptychocheilus oregonensis
CSU / largescale sucker / Catostomus rimiculus / SR / sandroller / Percopsis transmontana
CT / cutthroat trout / Oncorhynchus clarki clarki / SS / sockeye salmon / Oncorhynchus nerka
CTH / cutthroat/rainbow hybrid / Oncorhynchus clarki x mykiss / ST / steelhead / Oncorhynchus mykiss
D / dace / Cyprinidae / SU / sucker
FRG / frog (species unknown) / TC / tui chub / Gila bicolor
JSU / Jenny lake sucker / Catostomus rimiculus / TF / trout fry (age 0+)
LAM / lamprey / Petromyzontidae / TFT / tailed frog tadpole / Ascaphus truei
LB / largemouth bass / Micropterus salmoides / U / Unknown
LND / longnose dace / Rhinichthys cataractae / US / unknown salmonid
MF / mosquitofish / Gambusia sp / UT / unknown trout
MMS / Malheur mottled sculpin / Cottus bairdi bendirei / WF / mountain whitefish / Prosopium williamsoni
MS / mottled sculpin / Cottus bairdii / X / no fish found
MSU / mountain sucker / Catostomus platyrhynchus / YP / yellow perch / Perca flavescens
O / Other

Minimum Core Data Elements:

Many different data elements could be collected during fish trapping. Since we realize that different groups will have different needs we propose the following list as core minimum data elements. As long as fish are marked each week, and recaptures counted, these data elements will allow for population estimates to made using ODFW’s spreadsheet (see above).

LLID

Trap Site

Latitude/Longitude at Trap Site

Date

Time

Trap Type (if a screw trap is used, additional fields will be needed)

Species

Life stage or Size Class

Number of fish captured

Number of mortalities

If marking is conducted then:

Description of mark for each week (type, location, anatomy, side, etc)

Number of tagged fish

Number of recaptured fish

KLB111/13/2018