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 Radiotelemetry Detections in the Columbia and Snake River Basins

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

Summary

Abstract

This table contains information about sockeye salmon radiotelemetry detections in the Columbia and Snake River basins.

Description

This table contains information about sockeye salmon radiotelemetry detections in the Columbia and Snake River basins.

Entity Information

Entity Type
Spreadsheet

Data Attribute / Type Description
STUDY_YEAR
NUMBER 		Valendar year in which fish were tagged and tracked for the study.
TAG_ID
NUMBER 		Unique identifier for each tagged fish, for data connection purposes.
SERIAL_NUM
VARCHAR2 		Unique identifier for each tagged fish per year, based on channel and code of the radiotag and a letter.
RELDATE
DATE 		Date and time when the fish was released into the river.
SITE
VARCHAR2 		Alpha-numeric site idenifier for internal reference to the site installations and for data differentiation purposes.
ANTEN
NUMBER 		Antenna number on which a radiotelemetry detection was made. Sites may have only one associated antenna or many.
FIRST_DET
DATE 		Date and time when the fish was first detected at this site/antenna combination when gap from previous detection at this site was greater than 10 minutes.
LAST_DET
DATE 		Date and time when fish was last detected at this site/antenna combination when gap from previous detection was less than 10 minutes.
NUM_DET
NUMBER 		Number of individual detections contained within the detection block represented by the time between first_detection and last_detection.
DET_PER_MIN
NUMBER 		Calculated detections per minute for this detection block. Units for values are detections per minute.

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 Radiotelemetry Detections in the Columbia and Snake River Basins
Short Name: Sockeye Radiotelemetry Detections in the Columbia and Snake River Basins
Status: Planned
Abstract:

This table contains information about sockeye salmon radiotelemetry detections in the Columbia and Snake River basins.

Entity Information

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

This table contains information about sockeye salmon radiotelemetry detections in the Columbia and Snake River basins.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 STUDY_YEAR NUMBER Valendar year in which fish were tagged and tracked for the study.
100
 TAG_ID NUMBER Unique identifier for each tagged fish, for data connection purposes.
100
 SERIAL_NUM VARCHAR2 Unique identifier for each tagged fish per year, based on channel and code of the radiotag and a letter.
100
 RELDATE DATE Date and time when the fish was released into the river.
100
 SITE VARCHAR2 Alpha-numeric site idenifier for internal reference to the site installations and for data differentiation purposes.
100
 ANTEN NUMBER Antenna number on which a radiotelemetry detection was made. Sites may have only one associated antenna or many.
100
 FIRST_DET DATE Date and time when the fish was first detected at this site/antenna combination when gap from previous detection at this site was greater than 10 minutes.
100
 LAST_DET DATE Date and time when fish was last detected at this site/antenna combination when gap from previous detection was less than 10 minutes.
100
 NUM_DET NUMBER Number of individual detections contained within the detection block represented by the time between first_detection and last_detection.
100
 DET_PER_MIN NUMBER Calculated detections per minute for this detection block. Units for values are detections per minute.

Attribute Details

STUDY_YEAR

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

Valendar year in which fish were tagged and tracked for the study.
General Data Type: NUMBER

TAG_ID

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

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

SERIAL_NUM

CC ID: 731710
Seq. Order: 3
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

RELDATE

CC ID: 731711
Seq. Order: 4
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: MON/DD/YYYY HH:MM

SITE

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

Alpha-numeric site idenifier for internal reference to the site installations and for data differentiation purposes.
General Data Type: VARCHAR2

ANTEN

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

Antenna number on which a radiotelemetry detection was made. Sites may have only one associated antenna or many.
General Data Type: NUMBER

FIRST_DET

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

Date and time when the fish was first detected at this site/antenna combination when gap from previous detection at this site was greater than 10 minutes.
General Data Type: DATE
Format Mask: MON/DD/YYYY HH:MM:SS

LAST_DET

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

Date and time when fish was last detected at this site/antenna combination when gap from previous detection was less than 10 minutes.
General Data Type: DATE
Format Mask: MON/DD/YYYY HH:MM:SS

NUM_DET

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

Number of individual detections contained within the detection block represented by the time between first_detection and last_detection.
General Data Type: NUMBER

DET_PER_MIN

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

Calculated detections per minute for this detection block. Units for values are detections per minute.
General Data Type: NUMBER
Unit of Measure: detections per minute

Catalog Details

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