Sampled Fish Snake River Chinook
Northwest Fisheries Science Center
Entity
(ENT)
| ID: 35557
| Published / External
Created: 2016-11-04
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 18138
ID: 35557
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Sampled Fish Snake River Chinook |
---|---|
Short Name | Sampled Fish Snake River Chinook |
* Status | Planned |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
This table describes data associated with each Snake River fall chinook salmon collected from Lyons Ferry Hatchery in 2011. |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Spreadsheet |
---|---|
Active Version? | Y |
Alias | |
Schema Name | PARR |
» Description |
This table describes data associated with each Snake River fall chinook salmon collected from Lyons Ferry Hatchery in 2011. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | Species | VARCHAR2 | Fish species. |
100 | No | No | Collection date | DATE | Date when fish was collected. |
100 | No | No | Collection location | VARCHAR2 | Location where fish was collected. |
100 | No | No | Fish ID | VARCHAR2 | Unique identifier for each fish that includes collection year. |
100 | No | No | Sex | VARCHAR2 | Male or female. |
100 | No | No | Fork Length | NUMBER | Length of the fish from tip of snout to fork of tail. Units for values are millimeters. |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | Age | NUMBER | Age based on scale analysis and provided by Lyons Ferry Hatchery. Units for values are year. |
100 | No | No | Hatch Yr | NUMBER | Hatch year determined by the subtraction of Age from Collection year. |
100 | No | No | 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 | No | No | 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 | No | No | 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
Attribute Name | Species |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Fish species. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Collection date |
---|---|
Seq. Order | 2 |
Data Storage Type | DATE |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date when fish was collected. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Collection location |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Location where fish was collected. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Fish ID |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique identifier for each fish that includes collection year. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Sex |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Male or female. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Fork Length |
---|---|
Seq. Order | 6 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Otolith radius at Snake River exit |
---|---|
Seq. Order | 7 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning |
NA |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Otolith radius at ocean entry |
---|---|
Seq. Order | 8 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning |
NA |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Otolith radius at 1st annulus |
---|---|
Seq. Order | 9 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning |
NA |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Life history strategy |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Fork length at Snake River exit |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning |
NA |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Fork length at ocean entry |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning |
NA |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Growth between Snake River exit and ocean entry |
---|---|
Seq. Order | 13 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning |
NA |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Age |
---|---|
Seq. Order | 14 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Hatch Yr |
---|---|
Seq. Order | 15 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Hatch year determined by the subtraction of Age from Collection year. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Natal Sr87/86 |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Rearing Sr87/86 |
---|---|
Seq. Order | 17 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Over-wintering Sr87/86 |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning |
NA |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 | 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 Workflow State | Published / External |
Metadata Last Review Date | 2018-02-27 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2019-02-27 |
Tags |
---|