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
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
|
|
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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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 |