Slide Menu
Search Help Show/Hide Menu

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: 2019-06-04 13:14+0000
Metadata Record Published: 2018-02-27
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2019-02-28