Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Sockeye Radiotelemetry Sites in the Columbia and Snake River Basins
Short Name: Sockeye Radiotelemetry Sites in the Columbia and Snake River Basins
Status: Planned
Abstract:

This table contains information about radiotelemetry site installations for tracking radiotagged 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 radiotelemetry site installations for tracking radiotagged sockeye salmon in the Columbia and Snake River basins.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
SITE_ID NUMBER Unique identifier for each site installation, generated for data connection purposes only.
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
TYPE VARCHAR2 Defines type of site as REC (=receiver site for detecting tagged fish) or REL (=release site giving information about where fish are released).
100
STUDY_YEAR NUMBER Calendar year in which fish were tagged and tracked for the study.
100
RKM NUMBER River kilometer location of receiver installation. Units for values are kilometer.
100
LAT NUMBER Geographic latitude indication of receiver installation. Units for values are decimal degrees.
100
LONG NUMBER Geographic longitude indication of receiver installation. Units for values are decimal degrees.
100
DESCR VARCHAR2 Vommon name or description of receiver or release location.
100
RIVER VARCHAR2 Name of river on which site is located.

Attribute Details

SITE_ID

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

Unique identifier for each site installation, generated for data connection purposes only.

General Data Type: NUMBER

SITE

CC ID: 731699
Seq. Order: 2
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: 731700
Seq. Order: 3
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

TYPE

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

Defines type of site as REC (=receiver site for detecting tagged fish) or REL (=release site giving information about where fish are released).

General Data Type: VARCHAR2

STUDY_YEAR

CC ID: 731702
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.

General Data Type: NUMBER
Allowed Values: >2010

RKM

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

River kilometer location of receiver installation. Units for values are kilometer.

General Data Type: NUMBER
Unit of Measure: kilometer
Allowed Values: >0

LAT

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

Geographic latitude indication of receiver installation. Units for values are decimal degrees.

General Data Type: NUMBER
Unit of Measure: decimal degrees

LONG

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

Geographic longitude indication of receiver installation. Units for values are decimal degrees.

General Data Type: NUMBER
Unit of Measure: decimal degrees

DESCR

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

Vommon name or description of receiver or release location.

General Data Type: VARCHAR2

RIVER

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

Name of river on which site is located.

General Data Type: VARCHAR2

Catalog Details

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