Adult Anadromous Fish Radiotelemetry Project (1996-2004)

NOAA College of Natural Resources, University of Idaho US Army Corps of Engineers
AAFRP Project Description Data Description Glossary Maps & Publications Contact

Adult Radiotelemetry (1996-2004)
Data Queries

Event Summaries Query

The Event Summaries Query produces a graph and table of the selected Species, Dam and Event Efficiency, defined as the number of unique fish performing an action divided by the number having the chance to perform that action, for all Study Years. Efficiencies are defined separately for each event/action.

A 'coding' system was originally developed to condense the many data recorded from the emission of radio signals (from transmitters in fish) into cogent summaries of fish movements past dams, through reservoirs and into tributaries. The movements/behaviors of tagged fish were summarized into five action events at dams.

Approach: Detection of a fish near the base of a dam; records are 'coded' for the first and any subsequent approaches to a dam. Efficiencies are not calculated for approaches as they are not associated with a specific route at the dam.

Entrance: a location in a dam structure where there is access to the fish ladder system for migrating adult salmonids. Fish entrances are noted and tallied at entrances with receivers.

Exit: the action of a fish leaving a fishway through a downstream path after it has entered a dam fishway.

Fallback: an event in which a fish is detected at a location downstream of a dam after having been above that dam. These are determined either by records showing the fish's actual passage route back over a dam, or assumed when a fish is recorded downstream of a dam after it has originally passed. Fallbacks are one source of delay in a fish's migration, or can occur if a fish overshot its natal stream.

Passage: the act of traversing a dam as part of the upstream spawning migration. Passage times are calculated based on the time of a fish's first approach to a dam and the last detection of that fish at the top of a fish ladder.

sample image
sample graph from Event Summaries Query

Detection Details Query

The Detection Details Query produces a html table and csv file of release details and first/last detection details at dams and tributaries for the selected Species and Study Year based on the 'coding' system. Query options include specifying Release Date range, requiring PIT Tag ID, and including PIT Tag detections for fish tagged with both tags.

Radiotelemetry detections included in the Detection Details Query are based on the follow codes:

F = First record at the 1 Site after an approach at the dam, or First record at a fixed receiver site.
L = Last record at the 1 Site after an approach at the dam, or Last record at a fixed receiver site.
A1** = First Approach at Site + Antenna.
LT = Last record at the top-of-the-ladder site.
FB = record indicating a Fallback event at a dam. The time associated with a FB record does not indicate the time of a Fallback, just that it happened sometime between the preceding and subsequent records.

The results table includes Study Year, Species, Tag ID, Radiotelemetry Release Date, Radiotelemetry Release KM, Radiotelemetry Release Site, PIT Tag ID, PIT Tag as Juv/Adult, PIT Tag SpRRT, PIT Tag Release Date, PIT Tag Release Site, Radiotelemetry Record Date, Radiotelemetry CORR, Radiotelemetry Detection River, Radiotelemetry Detection Dam, Radiotelemetry Detection Site, Radiotelemetry Detection Antenna, Radiotelemetry Detection River KM, and Radiotelemetry Detection Site Description. Refer to Data Description for further information and defintions.

View sample query results (opens in new browser window/tab).

Release Details Query

The Release Details Query produces a html table and csv file of release details for the selected Species and Study Year. Query options include requiring PIT Tag ID for fish tagged with both tags.

The results table includes Study Year, Species, Tag ID, Radiotelemetry Release Date, Radiotelemetry Release KM, Radiotelemetry Release Site, Radiotelemetry Weight, Radiotelemetry Fork Length, Radiotelemetry Sex, Radiotelemetry Flin Clip, Radiotelemetry Descale, PIT Tag Release Year, PIT Tag Species Run Rear Type, PIT Tag as Juv/Adult, PIT Tag ID, PIT Tag Release Date, PIT Tag Release KM, PIT Tag Release Site.

View sample query results (opens in new browser window/tab).

One Tag Details

The One Tag Details Query produces a html table and csv file of Radiotelemetry release and detection details for the selected Tag ID. The report includes all radiotelemetry detections where as the Detection Details Query includes first and last. PIT Tag release and detection details are included if the selected fish is also PIT-tagged.

The results table includes Study Year, Species, Tag ID, Radiotelemetry Release Date, Radiotelemetry Release KM, Radiotelemetry Release Site, PIT Tag ID, PIT Tag as Juv/Adult, PIT Tag SpRRT, PIT Tag Release Date, PIT Tag Release Site, Radiotelemetry Record Date, Radiotelemetry CORR, Radiotelemetry Detection River, Radiotelemetry Detection Dam, Radiotelemetry Detection Site, Radiotelemetry Detection Antenna, Radiotelemetry Detection River KM, and Radiotelemetry Detection Site Description. Refer to Data Description for further information and defintions.

View sample query results (opens in new browser window/tab).

Diel Activity

The Diel Activity Query produces a graph and table of the selected Species, Dam, Event, and Pooled Hours.

A 'coding' system was originally developed to condense the many data recorded from the emission of radio signals (from transmitters in fish) into cogent summaries of fish movements past dams, through reservoirs and into tributaries. The movements/behaviors of tagged fish were summarized into five action events at dams. The Diel Activity Query includes: approach, entrance, and exit activities.

Approach: Detection of a fish near the base of a dam; records are 'coded' for the first and any subsequent approaches to a dam. Efficiencies are not calculated for approaches as they are not associated with a specific route at the dam.

Entrance: a location in a dam structure where there is access to the fish ladder system for migrating adult salmonids. Fish entrances are noted and tallied at entrances with receivers.

Exit: the action of a fish leaving a fishway through a downstream path after it has entered a dam fishway.

sample image
sample graph from Diel Activity Query

Travel Time Estimates

The Travel Time Estimates are based on the release date for each radio-tagged fish as recorded in the AAFRP database and the first approach (A1**) and last record at top-of-the-ladder (LT) times at each upstream detection site. Travel Time estimates for release to upstream site are calculated using the release time and the time of the first approach (A1**) record at the upstream site. Reach travel time is based on the last record at the top-of-ladder site (LT) at the first project and the first approach record (A1**) at the second project.

Arithmetic Mean Travel Time
( reach travel time ) / number of unique fish detected at the detection sites

Harmonic Mean Travel Time
number of unique fish detected at the detection sites / ( (1/reach travel time) )

When dealing with travel times, we are primarily interested in the speed with which fish travel from point A to point B. A good statistic for describing a particular group's speed is the harmonic mean. A harmonic mean is used when working with rates of speed, usually the number of days to travel a set distance. A benefit to using the harmonic mean is that it is more robust in the presence of outliers (i.e., a very fast or slow fish).

View sample query results (opens in new browser window/tab).

Travel Times All Years with Daily TT

The Travel Times All Years with Daily TT presents a species-specific reach travel time table for all study years and plots of the reach-specific daily mean travel time as it varies throughout the season. Reach travel time is based on the last record at the top-of-ladder site (LT) at the first project and the first approach record (A1**) at the second project. The date of the daily mean travel time is determined by and plotted on the reach entry date, i.e., the date of the last record at the top-of-ladder site (LT) for each Radio Telemetry tagged fish at the first project in the reach. The plots include a 95% confidence interval for each reach entry date on which more than one fish started traversing the reach.

sample image

sample daily travel time graph from Travel Times All Years with Daily TT

AAFRP Project Description Data Description Glossary Maps & Publications Contact

The Adult Anadromous Fish Radiotelemetry Project was originally hosted by the NWFSC, NOAA (1996-2007). It is currently hosted by Columbia River DART (Data Access in Real Time), Columbia Basin Research, School of Aquatic & Fishery Sciences, University of Washington. All Data Queries presented on this web site are designed and implemented by DART.

Monday, 10-Nov-2014 11:06:47 PST