Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: PIT-Tag Antennas to Estimate Migration Timing and Survival
Short Name: PIT-Tag Antennas to Estimate Migration Timing and Survival
Status: Planned
Abstract:

PIT tag detections and associated data from several types of detector types (matrix antenna trawl system, fin-antenna barge system, flexible antenna system, and pile dike antenna system) used to estimate migration timing and survival of juvenile salmonids in the Columbia River Estuary. Operated from 3/26/2018 to 6/16/2018

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: PARR
Description:

PIT tag detections and associated data from several types of detector types (matrix antenna trawl system, fin-antenna barge system, flexible antenna system, and pile dike antenna system) used to estimate migration timing and survival of juvenile salmonids in the Columbia River Estuary. Operated from 3/26/2018 to 6/16/2018

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ID NUMBER Identification for each record in this specific table.
100
COLLECTION_SOURCE TEXT Type of detection source, valid values are: Barge=fin-antenna barge system, Flex=flexible antenna system, Matrix=matrix antenna trawl system, Pile Dike=pile dike antenna system.
100
Migr_Yr TEXT "Migration year"- Earliest year expected for a fish to migrate (juvenile salmonids). If non-migratory species or adult, it is year in which tagging occurred.
100
Tag_file TEXT Name of the tag data file in which the tagging event was submitted to PTAGIS website.
100
Tag_Date DATE Date of tagging event.
100
Org TEXT "Organization"- Entity responsible for fish tagging.
100
Coord TEXT "Coordinator"- Specific person responsible for fish tagging.
100
Tag_site TEXT Code for the site where the initial tagging event took place - Mark/Recapture/Recovery (MRR) sites registered in PTAGIS website.
100
Rel_Site TEXT "Release site"- Code for the MRR site where fish was released.
100
Rel_Date DATE "Release date"- Date fish was released.
100
Rkm TEXT "River kilometer"- kilometers from the mouth of the Columbia River to the release site, with each tributary delimited with a period.
100
Tag_ID TEXT PIT tag code.
100
Species TEXT Species code: 0=unknown, 1=chinook salmon, 2=coho salmon, 3=steelhead, 4=sockeye salmon, 5=chum salmon, 6=pink salmon, 7=bull trout, 8=cutthroat trout, 9=other, A=lamprey, B=white sturgeon, C=green sturgeon, D=northern pike minnow, E=brook trout.
100
Run TEXT Run code describing when fish migrate: 0=N/A, 1=spring, 2=summer, 3=fall, 4=winter, 5=unknown, R=resident.
100
Rear_Type TEXT "Rearing type"- Code for fish rearing status: W=wild fish or natural production, H=hatchery reared, U=unknown.
100
Length NUMBER Fork length in mm recorded at tagging event.
100
Weight NUMBER Weight in grams recorded at tagging event.
100
Obs_Site TEXT "Observation site"- name of interrogation site (site code in PTAGIS website).
100
First_Obs_Date DATE "First observation date"- date and time of first detection.
100
Last_Obs_Date DATE "Last observation date"- date and time of last detection.
100
First_Coil TEXT Name of detection system on which the first detection at the site was recorded.
100
Last_Coil TEXT Name of detection system on which the last detection at the site was recorded.
100
Trans_reads NUMBER "Transceiver reads"- Number of detections recorded for a specific tag at the interrogation site.

Attribute Details

ID

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

Identification for each record in this specific table.

General Data Type: NUMBER

COLLECTION_SOURCE

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

Type of detection source, valid values are: Barge=fin-antenna barge system, Flex=flexible antenna system, Matrix=matrix antenna trawl system, Pile Dike=pile dike antenna system.

General Data Type: TEXT

Migr_Yr

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

"Migration year"- Earliest year expected for a fish to migrate (juvenile salmonids). If non-migratory species or adult, it is year in which tagging occurred.

General Data Type: TEXT

Tag_file

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

Name of the tag data file in which the tagging event was submitted to PTAGIS website.

General Data Type: TEXT

Tag_Date

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

Date of tagging event.

General Data Type: DATE

Org

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

"Organization"- Entity responsible for fish tagging.

General Data Type: TEXT

Coord

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

"Coordinator"- Specific person responsible for fish tagging.

General Data Type: TEXT

Tag_site

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

Code for the site where the initial tagging event took place - Mark/Recapture/Recovery (MRR) sites registered in PTAGIS website.

General Data Type: TEXT

Rel_Site

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

"Release site"- Code for the MRR site where fish was released.

General Data Type: TEXT

Rel_Date

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

"Release date"- Date fish was released.

General Data Type: DATE

Rkm

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

"River kilometer"- kilometers from the mouth of the Columbia River to the release site, with each tributary delimited with a period.

General Data Type: TEXT

Tag_ID

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

PIT tag code.

General Data Type: TEXT

Species

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

Species code: 0=unknown, 1=chinook salmon, 2=coho salmon, 3=steelhead, 4=sockeye salmon, 5=chum salmon, 6=pink salmon, 7=bull trout, 8=cutthroat trout, 9=other, A=lamprey, B=white sturgeon, C=green sturgeon, D=northern pike minnow, E=brook trout.

General Data Type: TEXT

Run

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

Run code describing when fish migrate: 0=N/A, 1=spring, 2=summer, 3=fall, 4=winter, 5=unknown, R=resident.

General Data Type: TEXT

Rear_Type

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

"Rearing type"- Code for fish rearing status: W=wild fish or natural production, H=hatchery reared, U=unknown.

General Data Type: TEXT

Length

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

Fork length in mm recorded at tagging event.

General Data Type: NUMBER

Weight

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

Weight in grams recorded at tagging event.

General Data Type: NUMBER

Obs_Site

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

"Observation site"- name of interrogation site (site code in PTAGIS website).

General Data Type: TEXT

First_Obs_Date

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

"First observation date"- date and time of first detection.

General Data Type: DATE

Last_Obs_Date

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

"Last observation date"- date and time of last detection.

General Data Type: DATE

First_Coil

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

Name of detection system on which the first detection at the site was recorded.

General Data Type: TEXT

Last_Coil

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

Name of detection system on which the last detection at the site was recorded.

General Data Type: TEXT

Trans_reads

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

"Transceiver reads"- Number of detections recorded for a specific tag at the interrogation site.

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 56818
GUID: gov.noaa.nmfs.inport:56818
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