Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Strait IMW Tags
Short Name: Strait IMW Tags
Status: Planned
Abstract:

This table contains data on fish collected during PIT tagging operations including tagged and untagged fish. Most of the data are from summer electrofishing surveys the data from fall and spring trapping are included in later years.

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Schema Name: PARR
Description:

This table contains data on fish collected during PIT tagging operations including tagged and untagged fish. Most of the data are from summer electrofishing surveys the data from fall and spring trapping are included in later years.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
PIT Code TEXT The unique code of the tag that is inserted into the fish. This code is recorded by the MUX unit as the fish is detected at an antenna. Format is alphnumeric, three characters, a period then 10 characters, alpha limited to A-F. Blank if smolt was too small to tag or Mort=Y.
100
Date DATE Date stream/reach/habitat was sampled (electrofished). VALUES are 2003 to present.
100
Season TEXT Time of year sampling took place. Most samples were in Summer (August and September), though in 2005 a few fish were tagged in Fall and Spring. VALUES are Summer, Fall, Winter, or Spring.
100
Tag Year NUMBER Year fish were tagged. VALUES are 2003 to present.
100
River TEXT Stream where tagging/sampling took place. VALUES are East Twin, West Twin, Deep Creek.
100
Tributary TEXT Indicates whether the sampled East Twin reach was in the mainstem or in Sadie Creek (Major tributary of East Twin). VALUES are Mainstem, Sadie Creek, East Fork, West Fork, Unnamed and blank.
100
Reach Point NUMBER Reach Point - every 100 m in all three watersheds was marked by Lower Elwha Tribe from Highway 112 Bridge upstream. 100 m would be 1, 200 = 2 etc.. Most RPs are whole numbers (2, 71, etc.), though they can be more specific (e.g. 4.5, 6.5 etc.). We also identified some reaches and habitat units down to specific meter. For example, RP 8.28 was a reach that started at 828m.
100
Habitat Unit NUMBER NOAA surveys in 2003 to 2008 often were done by sampling each habitat unit separately and the habitat unit sampled within that reach was identified. This is 0 for all Weyco surveys and NOAA surveys from 2009 onward, as Weyco samples entire reach using 1 or 3 pass electrofishing, and starting in 2009 NOAA surveys used same protocol as Weyco. VALUES are integers 0 to 24.
100
Passes TEXT Number of electrofishing passes. Null means not electofished (smolt trap). VALUES are 0,1,2,3,4,5, blank. 0 or blank means they did not record number of passes.
100
Standardized Species TEXT Species are standardized on RBT(rainbow/steelhead), TF(trout fry), CO (coho), CT (cutthroat), STH (steelhead), SC=sculpin, CRAY=crayfish, LMP = lamprey, etc., ASTR - tailed frogs (Ascaphus truei). (Other values not yet corrected 1/24/2014).
100
Species TEXT Species, particularly for trout, was not consistently identified in earlier years (~2003 to 2007). This is the original field call, though likely was already cleaned up a little in data sheets before being standardized.
100
Fork Length NUMBER The fork length of the each fish measured to nearest millimeter. Non salmonids are often only counted, but not measured so fork lengths are usually missing for SC, LMP, etc. VALUES are >10mm and <650 mm.
100
Fork Length Source TEXT In a few instances (Particularly prior to ~2007) length of a fish was not measured or there was an error, the length was then either estimated from the weight using a length weight equation or based on average weight of same size fish in habitat. Typically sculpin (SC) and crayfish (CRAY) are not measured so there will be a blank for many of these species. VALUES are """"blank"""", measured, or estimated.
100
Weight NUMBER Weight is measured to the nearest tenth of gram. If it is not measured, we estimate using weight-length formula developed for each species (CO, RBT, TR).
100
Weight Source TEXT Indicates whether weight was measured or estimated from formula. VALUES are """"blank"""", measured, or estimated.
100
Time TEXT Time stamp from PIT tag """"brick"""" indicating when fish was tagged. VALUES are time to nearest second.
100
Recaptured TEXT Indicates whether this fish was a recapture from previous tagging. VALUES are Y, recapture, or N, not a recapture.
100
Mortality TEXT Y indicates fish died during sampling before it was released. N, it lived through release.
100
Notes TEXT Any notes about fish of site that might be relevant, may also be notes from when database was cleaned up.
100
Year River Reach Habitat Unit TEXT This was originally a concatenated field that denotes year, river and RP and habitat unit (reach point) to help match up with the habitat data table. It is not totally unique. VALUES are alphanumeric combination of Year, River, RP, Habitat Unit #. Retained for historical reasons.
100
Size Category TEXT Size category derived from fork length (fl). When fork length < 86, then Age 0, else Age 1+.
100
Fish ID NUMBER Unique fish id number, intended to correspond to order in original excel data sheet.
100
Not Tagged TEXT This button was added to our field computer so if we came across a fish that was too weak or injured to tag, I could just press the 'no tag' button and not take the time to write out the reason why.
100
Weyerhauser Site NUMBER Weyerhauser site number.
100
First Detection DATE Earliest detection of this tag.
100
Last Detection DATE Latest detection of this tag.
100
Total Detections NUMBER Total number of detections of this tag.

Attribute Details

PIT Code

CC ID: 859394
Seq. Order: 1
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

The unique code of the tag that is inserted into the fish. This code is recorded by the MUX unit as the fish is detected at an antenna. Format is alphnumeric, three characters, a period then 10 characters, alpha limited to A-F. Blank if smolt was too small to tag or Mort=Y.

General Data Type: TEXT

Date

CC ID: 859395
Seq. Order: 2
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date stream/reach/habitat was sampled (electrofished). VALUES are 2003 to present.

General Data Type: DATE

Season

CC ID: 859396
Seq. Order: 3
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Time of year sampling took place. Most samples were in Summer (August and September), though in 2005 a few fish were tagged in Fall and Spring. VALUES are Summer, Fall, Winter, or Spring.

General Data Type: TEXT

Tag Year

CC ID: 859397
Seq. Order: 4
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Year fish were tagged. VALUES are 2003 to present.

General Data Type: NUMBER

River

CC ID: 859398
Seq. Order: 5
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Stream where tagging/sampling took place. VALUES are East Twin, West Twin, Deep Creek.

General Data Type: TEXT

Tributary

CC ID: 859399
Seq. Order: 7
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Indicates whether the sampled East Twin reach was in the mainstem or in Sadie Creek (Major tributary of East Twin). VALUES are Mainstem, Sadie Creek, East Fork, West Fork, Unnamed and blank.

General Data Type: TEXT

Reach Point

CC ID: 859400
Seq. Order: 8
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Reach Point - every 100 m in all three watersheds was marked by Lower Elwha Tribe from Highway 112 Bridge upstream. 100 m would be 1, 200 = 2 etc.. Most RPs are whole numbers (2, 71, etc.), though they can be more specific (e.g. 4.5, 6.5 etc.). We also identified some reaches and habitat units down to specific meter. For example, RP 8.28 was a reach that started at 828m.

General Data Type: NUMBER

Habitat Unit

CC ID: 859401
Seq. Order: 9
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

NOAA surveys in 2003 to 2008 often were done by sampling each habitat unit separately and the habitat unit sampled within that reach was identified. This is 0 for all Weyco surveys and NOAA surveys from 2009 onward, as Weyco samples entire reach using 1 or 3 pass electrofishing, and starting in 2009 NOAA surveys used same protocol as Weyco. VALUES are integers 0 to 24.

General Data Type: NUMBER

Passes

CC ID: 859402
Seq. Order: 10
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Number of electrofishing passes. Null means not electofished (smolt trap). VALUES are 0,1,2,3,4,5, blank. 0 or blank means they did not record number of passes.

General Data Type: TEXT

Standardized Species

CC ID: 859403
Seq. Order: 11
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Species are standardized on RBT(rainbow/steelhead), TF(trout fry), CO (coho), CT (cutthroat), STH (steelhead), SC=sculpin, CRAY=crayfish, LMP = lamprey, etc., ASTR - tailed frogs (Ascaphus truei). (Other values not yet corrected 1/24/2014).

General Data Type: TEXT

Species

CC ID: 859404
Seq. Order: 12
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Species, particularly for trout, was not consistently identified in earlier years (~2003 to 2007). This is the original field call, though likely was already cleaned up a little in data sheets before being standardized.

General Data Type: TEXT

Fork Length

CC ID: 859405
Seq. Order: 13
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The fork length of the each fish measured to nearest millimeter. Non salmonids are often only counted, but not measured so fork lengths are usually missing for SC, LMP, etc. VALUES are >10mm and <650 mm.

General Data Type: NUMBER

Fork Length Source

CC ID: 859406
Seq. Order: 14
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

In a few instances (Particularly prior to ~2007) length of a fish was not measured or there was an error, the length was then either estimated from the weight using a length weight equation or based on average weight of same size fish in habitat. Typically sculpin (SC) and crayfish (CRAY) are not measured so there will be a blank for many of these species. VALUES are """"blank"""", measured, or estimated.

General Data Type: TEXT

Weight

CC ID: 859407
Seq. Order: 15
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Weight is measured to the nearest tenth of gram. If it is not measured, we estimate using weight-length formula developed for each species (CO, RBT, TR).

General Data Type: NUMBER

Weight Source

CC ID: 859408
Seq. Order: 16
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Indicates whether weight was measured or estimated from formula. VALUES are """"blank"""", measured, or estimated.

General Data Type: TEXT

Time

CC ID: 859409
Seq. Order: 17
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Time stamp from PIT tag """"brick"""" indicating when fish was tagged. VALUES are time to nearest second.

General Data Type: TEXT

Recaptured

CC ID: 859410
Seq. Order: 18
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Indicates whether this fish was a recapture from previous tagging. VALUES are Y, recapture, or N, not a recapture.

General Data Type: TEXT

Mortality

CC ID: 859411
Seq. Order: 19
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Y indicates fish died during sampling before it was released. N, it lived through release.

General Data Type: TEXT

Notes

CC ID: 859412
Seq. Order: 20
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Any notes about fish of site that might be relevant, may also be notes from when database was cleaned up.

General Data Type: TEXT

Year River Reach Habitat Unit

CC ID: 859413
Seq. Order: 21
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

This was originally a concatenated field that denotes year, river and RP and habitat unit (reach point) to help match up with the habitat data table. It is not totally unique. VALUES are alphanumeric combination of Year, River, RP, Habitat Unit #. Retained for historical reasons.

General Data Type: TEXT

Size Category

CC ID: 859414
Seq. Order: 22
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Size category derived from fork length (fl). When fork length < 86, then Age 0, else Age 1+.

General Data Type: TEXT

Fish ID

CC ID: 859415
Seq. Order: 23
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Unique fish id number, intended to correspond to order in original excel data sheet.

General Data Type: NUMBER

Not Tagged

CC ID: 859416
Seq. Order: 24
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

This button was added to our field computer so if we came across a fish that was too weak or injured to tag, I could just press the 'no tag' button and not take the time to write out the reason why.

General Data Type: TEXT

Weyerhauser Site

CC ID: 859417
Seq. Order: 25
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Weyerhauser site number.

General Data Type: NUMBER

First Detection

CC ID: 859418
Seq. Order: 26
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Earliest detection of this tag.

General Data Type: DATE

Last Detection

CC ID: 859419
Seq. Order: 27
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Latest detection of this tag.

General Data Type: DATE

Total Detections

CC ID: 859420
Seq. Order: 28
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Total number of detections of this tag.

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 56819
GUID: gov.noaa.nmfs.inport:56819
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2019-07-02 13:44+0000
Metadata Record Last Modified By: Jeffrey W Cowen
Metadata Record Last Modified: 2019-07-02 13:44+0000
Metadata Record Published: 2019-07-02
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-07-02