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
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This table contains information about tagged fish and their release information for sockeye salmon in the Columbia and Snake River basins.
DescriptionThis 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
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
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
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
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
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
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
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
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
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
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
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 |