Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Sampled Fish Snake River Chinook
Short Name: Sampled Fish Snake River Chinook
Status: Planned
Abstract:

This table describes data associated with each Snake River fall chinook salmon collected from Lyons Ferry Hatchery in 2011.

Entity Information

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

This table describes data associated with each Snake River fall chinook salmon collected from Lyons Ferry Hatchery in 2011.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Species VARCHAR2 Fish species.
100
Collection date DATE Date when fish was collected.
100
Collection location VARCHAR2 Location where fish was collected.
100
Fish ID VARCHAR2 Unique identifier for each fish that includes collection year.
100
Sex VARCHAR2 Male or female.
100
Fork Length NUMBER Length of the fish from tip of snout to fork of tail. Units for values are millimeters.
100
Otolith radius at Snake River exit NUMBER Otolith radius was measured on the dorsal side of the otolith in the region perpendicular to the longest axis. Otolith radius at Snake River egress was measured at the point on the edge-to-core scan where 87Sr/86Sr ratio was between 0.70960 (upper and lower Snake River have a 87Sr/86Sr ratio of 0.709651 and 0.709746, respectively) and 0.70922 (the upper bound used to identify ocean entry). Units for values are microns.
100
Otolith radius at ocean entry NUMBER Otolith radius was measured on the dorsal side of the otolith in the region perpendicular to the longest axis. Otolith radius at ocean entry was measured at the point on the edge-to-core scan where the 87Sr/86Sr ratio converged with the range of 0.70914-0.70922, which is centered on the global marine signature of 0.70918. Units for values are microns.
100
Otolith radius at 1st annulus NUMBER Otolith radius was measured on the dorsal side of the otolith in the region perpendicular to the longest axis. Otolith radius was measured to the 1st annulus, which denotes the completion of an individuals first winter of growth. Units for values are microns.
100
Life history strategy VARCHAR2 An individual was classified as exhibiting the sub-yearling strategy if the otolith radius to the first annual mark was greater than the otolith radius at ocean entry. In other words, a fish was categorized as exhibiting a sub-yearling strategy if it was in the ocean before its first annulus formed. Alternatively, if the otolith radius to the first annual mark was less than or equal to the otolith radius at ocean entry then the fish was designated as exhibiting a yearling strategy. A sub-yearling migration strategy is when individuals migrate to the ocean a few months after their spring emergence (i.e., first feeding), while a yearling migration strategy is one in which juveniles remain in freshwater for an extended period (referred to as overwintering) prior to ocean entry the following spring.
100
Fork length at Snake River exit NUMBER Fork length (mm) estimated from a relationship between fork length and otolith radius (FL=(0.1914 * otolith radius at Snake River exit) - 7.8467). Units for values are millimeters.
100
Fork length at ocean entry NUMBER Fork length (mm) estimated from a relationship between fork length and otolith radius (FL=(0.1914 * otolith radius at ocean entry) - 7.8467). Units for values are millimeters.
100
Growth between Snake River exit and ocean entry NUMBER The differences between fork length at Snake River exit and fork length at ocean entry. Units for values are millimeters.
100
Age NUMBER Age based on scale analysis and provided by Lyons Ferry Hatchery. Units for values are year.
100
Hatch Yr NUMBER Hatch year determined by the subtraction of Age from Collection year.
100
Natal Sr87/86 NUMBER The natal 87Sr/86Sr ratio was quantified as the first stable signature located between an otolith radius of 110m and 250m from the otolith core.
100
Rearing Sr87/86 NUMBER The rearing 87Sr/86Sr ratio was determined as the first stable signature located between an otolith radius of 250m and 500m from the otolith core.
100
Over-wintering Sr87/86 NUMBER Over-wintering Sr87/Sr86 ratio was quantified as the first stable signature between an otolith radius between 500m and the radius from the core corresponding to when a fish exited the Snake River.

Attribute Details

Species

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

Fish species.

General Data Type: VARCHAR2

Collection date

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

Date when fish was collected.

General Data Type: DATE

Collection location

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

Location where fish was collected.

General Data Type: VARCHAR2

Fish ID

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

Unique identifier for each fish that includes collection year.

General Data Type: VARCHAR2

Sex

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

Male or female.

General Data Type: VARCHAR2

Fork Length

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

Length of the fish from tip of snout to fork of tail. Units for values are millimeters.

General Data Type: NUMBER
Unit of Measure: millimeters

Otolith radius at Snake River exit

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

Otolith radius was measured on the dorsal side of the otolith in the region perpendicular to the longest axis. Otolith radius at Snake River egress was measured at the point on the edge-to-core scan where 87Sr/86Sr ratio was between 0.70960 (upper and lower Snake River have a 87Sr/86Sr ratio of 0.709651 and 0.709746, respectively) and 0.70922 (the upper bound used to identify ocean entry). Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns
Null Value Meaning:

NA

Otolith radius at ocean entry

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

Otolith radius was measured on the dorsal side of the otolith in the region perpendicular to the longest axis. Otolith radius at ocean entry was measured at the point on the edge-to-core scan where the 87Sr/86Sr ratio converged with the range of 0.70914-0.70922, which is centered on the global marine signature of 0.70918. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns
Null Value Meaning:

NA

Otolith radius at 1st annulus

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

Otolith radius was measured on the dorsal side of the otolith in the region perpendicular to the longest axis. Otolith radius was measured to the 1st annulus, which denotes the completion of an individuals first winter of growth. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns
Null Value Meaning:

NA

Life history strategy

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

An individual was classified as exhibiting the sub-yearling strategy if the otolith radius to the first annual mark was greater than the otolith radius at ocean entry. In other words, a fish was categorized as exhibiting a sub-yearling strategy if it was in the ocean before its first annulus formed. Alternatively, if the otolith radius to the first annual mark was less than or equal to the otolith radius at ocean entry then the fish was designated as exhibiting a yearling strategy. A sub-yearling migration strategy is when individuals migrate to the ocean a few months after their spring emergence (i.e., first feeding), while a yearling migration strategy is one in which juveniles remain in freshwater for an extended period (referred to as overwintering) prior to ocean entry the following spring.

General Data Type: VARCHAR2

Fork length at Snake River exit

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

Fork length (mm) estimated from a relationship between fork length and otolith radius (FL=(0.1914 * otolith radius at Snake River exit) - 7.8467). Units for values are millimeters.

General Data Type: NUMBER
Unit of Measure: millimeters
Null Value Meaning:

NA

Fork length at ocean entry

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

Fork length (mm) estimated from a relationship between fork length and otolith radius (FL=(0.1914 * otolith radius at ocean entry) - 7.8467). Units for values are millimeters.

General Data Type: NUMBER
Unit of Measure: millimeters
Null Value Meaning:

NA

Growth between Snake River exit and ocean entry

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

The differences between fork length at Snake River exit and fork length at ocean entry. Units for values are millimeters.

General Data Type: NUMBER
Unit of Measure: millimeters
Null Value Meaning:

NA

Age

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

Age based on scale analysis and provided by Lyons Ferry Hatchery. Units for values are year.

General Data Type: NUMBER
Unit of Measure: year

Hatch Yr

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

Hatch year determined by the subtraction of Age from Collection year.

General Data Type: NUMBER

Natal Sr87/86

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

The natal 87Sr/86Sr ratio was quantified as the first stable signature located between an otolith radius of 110m and 250m from the otolith core.

General Data Type: NUMBER

Rearing Sr87/86

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

The rearing 87Sr/86Sr ratio was determined as the first stable signature located between an otolith radius of 250m and 500m from the otolith core.

General Data Type: NUMBER

Over-wintering Sr87/86

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

Over-wintering Sr87/Sr86 ratio was quantified as the first stable signature between an otolith radius between 500m and the radius from the core corresponding to when a fish exited the Snake River.

General Data Type: NUMBER
Null Value Meaning:

NA

Catalog Details

Catalog Item ID: 35557
GUID: gov.noaa.nmfs.inport:35557
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2016-11-04 19:22+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