Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NWFSC Metadata Library > FE (Fish Ecology) Division > Radio telemetry data - Characterizing migration... >

Sockeye Fish Tags in the Columbia and Snake River Basins

Entity (ENT)  |  Northwest Fisheries Science Center (NWFSC)
GUID: gov.noaa.nmfs.inport:36789  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This table contains information about tagged fish and their release information for sockeye salmon in the Columbia and Snake River basins.

Description

This table contains information about tagged fish and their release information for sockeye salmon in the Columbia and Snake River basins.

Entity Information

Entity Type
Spreadsheet

Data Attribute / Type Description
TAG_ID
NUMBER 		Unique identifier for each tagged fish, generated for data connection purposes only.
SERIAL_NUM
VARCHAR2 		unique identifier for each tagged fish per year, based on channel and code of the radiotag and a letter.
PIT_TAG
VARCHAR2 		Code of PIT (passive integrated transponder) tag inserted into the fish upon tagging.
SPECIES
VARCHAR2 		Fish species tagged in this instance.
STUDY_YEAR
NUMBER 		calendar year in which fish were tagged and tracked for the study. Units for values are year (YYYY).
TAGDATE
DATE 		Date and time when the fish was tagged.
RELDATE
DATE 		Date and time when the fish was released into the river.
RELEASE_SITE_ID
NUMBER 		Unique identifier indicating the site at which the fish was released, for data connection purposes.
LENGTH
NUMBER 		Fork length of the tagged fish. Units for values are millimeters (mm).
WEIGHT
NUMBER 		Weight of the tagged fish. Units for values are grams (g).

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NWFSC) for inquiries on this record.

Item Identification

Title: Sockeye Fish Tags in the Columbia and Snake River Basins
Short Name: Sockeye Fish Tags in the Columbia and Snake River Basins
Status: Planned
Abstract:

This table contains information about tagged fish and their release information for sockeye salmon in the Columbia and Snake River basins.

Entity Information

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

This table contains information about tagged fish and their release information for sockeye salmon in the Columbia and Snake River basins.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TAG_ID NUMBER Unique identifier for each tagged fish, generated for data connection purposes only.
100
 SERIAL_NUM VARCHAR2 unique identifier for each tagged fish per year, based on channel and code of the radiotag and a letter.
100
 PIT_TAG VARCHAR2 Code of PIT (passive integrated transponder) tag inserted into the fish upon tagging.
100
 SPECIES VARCHAR2 Fish species tagged in this instance.
100
 STUDY_YEAR NUMBER calendar year in which fish were tagged and tracked for the study. Units for values are year (YYYY).
100
 TAGDATE DATE Date and time when the fish was tagged.
100
 RELDATE DATE Date and time when the fish was released into the river.
100
 RELEASE_SITE_ID NUMBER Unique identifier indicating the site at which the fish was released, for data connection purposes.
100
 LENGTH NUMBER Fork length of the tagged fish. Units for values are millimeters (mm).
100
 WEIGHT NUMBER Weight of the tagged fish. Units for values are grams (g).

Attribute Details

TAG_ID

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

Unique identifier for each tagged fish, generated for data connection purposes only.
General Data Type: NUMBER

SERIAL_NUM

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

unique identifier for each tagged fish per year, based on channel and code of the radiotag and a letter.
General Data Type: VARCHAR2

PIT_TAG

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

Code of PIT (passive integrated transponder) tag inserted into the fish upon tagging.
General Data Type: VARCHAR2

SPECIES

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

Fish species tagged in this instance.
General Data Type: VARCHAR2

STUDY_YEAR

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

calendar year in which fish were tagged and tracked for the study. Units for values are year (YYYY).
General Data Type: NUMBER
Unit of Measure: year (YYYY)
Format Mask: YYYY

TAGDATE

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

Date and time when the fish was tagged.
General Data Type: DATE
Format Mask: YYYY-MM-DDTHH:mi:ss

RELDATE

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

Date and time when the fish was released into the river.
General Data Type: DATE
Format Mask: YYYY-MM-DDTHH:mi:ss

RELEASE_SITE_ID

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

Unique identifier indicating the site at which the fish was released, for data connection purposes.
General Data Type: NUMBER

LENGTH

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

Fork length of the tagged fish. Units for values are millimeters (mm).
General Data Type: NUMBER
Unit of Measure: millimeters (mm)

WEIGHT

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

Weight of the tagged fish. Units for values are grams (g).
General Data Type: NUMBER
Unit of Measure: grams (g)

Catalog Details

Catalog Item ID: 36789
GUID: gov.noaa.nmfs.inport:36789
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-02-13 16:57+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-02-27
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-02-27
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-02-27