How to acquire sum information on historical PIT-

tagging efforts in the Columbia Basin

Josh Murauskas Natural Resources Department

Chelan County PUD

2

Introduction

1989

1991

1993

1995

1997

1999

2001

2003

2005

2007

2009

0

20,000

40,000

60,000

80,000

100,000

120,000

140,000

160,000

4 3

2 1

3

Tagging in HUC 1702*

BIOMRK CCT

CPUD

CRITFC

FPC

GPUDNMFS

PNL

PSMFC

RTR

USFWS

USGS

WDF

WDFWWDW WFC

YINN

4

Annual tagging summaries

5

tag_sum_* (1987-2021)

6

Combining data

Import into your program*

Multiple .csv files

• 1989 to 2010, and beyond

* Anything besides a spreadsheet

7

Fields to filter or tabulateBIOLOGICAL OTHER

Species

Run

Rear type

Organization

EPA reach (HUC)

Hatchery

Release site

Dates

Notes

8

Examples

Finding out what’s been tagged

Particular issues

• Adult steelhead stray rates

• Sub-yearling migration behavior

• Sockeye survival

9

10

11

Adult steelhead stray rates

Turtle Rock Island

In-basin acclimation?

• Methow Basin (‘03-’04) > 230,000 PITs

• Wenatchee Basin (’06-’07) wild-origin PITs

12

Conversion between Rock Island and Wells or Tumwater

RIS:WEL• Methow 91.9%• Wenatchee 48.1%• Wenat (W) 12.3%

RIS:TUM• Methow 00.0%• Wenatchee 22.9%• Wenat (W) 80.7%

Map from NOAA

13

Sub-yearling behavior

Sub-yearling travel time

28-Mar 17-Apr 7-May 27-May 16-Jun 6-Jul 26-Jul 15-Aug0

10

20

30

40

50

60

70

80MCN-BONSub-yearling

Yearling

Date

Sub-yearling travel time

28-Mar 17-Apr 7-May 27-May 16-Jun 6-Jul 26-Jul 15-Aug0

10

20

30

40

50

60

70

80LGR-MCNSub-yearling

Yearling

Date

Sub-yearling travel time

28-Mar 17-Apr 7-May 27-May 16-Jun 6-Jul 26-Jul 15-Aug0

10

20

30

40

50

60

70

80RIS-MCNSub-yearling

Yearling

Date

17

Sockeye to McNary

0

50

100

150

200

250

300

0.000

0.100

0.200

0.300

0.400

0.500

0.600

0.700

0.800

0.900

1.000

2006 2007 2008 2009 2010

Mea

n tr

avel

tim

e to

MCN

(d)

Surv

ival

Year

Lake WenatcheeSurvival (RLS-MCN)Travel time (RLS-MCN)

0

10

20

30

40

50

60

70

80

0.000

0.100

0.200

0.300

0.400

0.500

0.600

0.700

0.800

0.900

1.000

2006 2007 2008 2009 2010M

ean

trav

el ti

me

to M

CN (d

)

Surv

ival

Year

Wenatchee RiverSurvival (RLS-MCN)Travel time (RLS-MCN)

Lake Wenatchee• Travel ~150 d

• Survival ~35 %

Wenatchee River• Travel ~ 11 d

• Survival ~ 65 %

18

Potential issues

Purpose not captured in database

Changing environment and methods

Data quality

• Over 25,000,000 tags

• Numeric/character format

19

Conclusion

1. Plenty of data available

2. Metadata = better than memory

3. You may not need another study

• Maybe someone did it already

• Maybe you’re not that bad after all

4. Your neighbors have dirty secrets

20

Questions or comments?