Genetic stock distribution and salmon habitat use
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:51553 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Genetic stock distribution and salmon habitat use |
---|---|
Short Name: | Genetic stock distribution and salmon habitat use |
Status: | Planned |
Abstract: |
Columbia River estuary-wide genetic stock distribution and salmon habitat use within the tidal-fluvial estuary. |
Entity Information
Entity Type: | Spreadsheet |
---|---|
Active Version?: | Yes |
Schema Name: | PARR |
Description: |
Columbia River estuary-wide genetic stock distribution and salmon habitat use within the tidal-fluvial estuary. |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
Sample_Unique_Code | Text | Unique combination of date, station and sampling code. | |
100
|
Sample_Date | Date | Date and time of sampling event. | |
100
|
Station Code | Text | Sample site name. | |
100
|
Station Locality | Text | Description of sample site. | |
100
|
Salmonid ID | Text | Unique salmon identification number, ties it to any other related data such as genetics. | |
100
|
Species (common name) | Text | Common name of fish sampled. | |
100
|
Life history | Text | Identifies salmon life history stage (Unknown;Subyearling;Yearling;Juvenile;Adult). | |
100
|
Length (mm) | Number | Actual fork or total length of fish in millimeters. Units for values are millimeters. | |
100
|
Count | Number | Default = 1, otherwise mass count per species. | |
100
|
Measurement | Text | How fish was measured, dependent on species. | |
100
|
WT (g) individual | Number | Weight measured to 0.1 grams. Units for values are Grams. | |
100
|
Genetics | Text | Were genetic sample taken yes or no. | |
100
|
Sample | Number | Processing sample number assigned by genetics lab. | |
100
|
Sample No | Text | Processing sample number assigned by genetics lab combined with Salmonid ID. | |
100
|
Best Estimate | Text | Best estimate of source population origin. See GeneticSources lookup table for complete description and acceptable values. | |
100
|
Probability | Number | Probability of best estimate. | |
100
|
2nd Best Estimate | Text | Second best estimate of source population origin. See GeneticSources lookup table for complete description and acceptable values. | |
100
|
Probability 2nd Best Estimate | Number | Probability of second best estimate. | |
100
|
Saved | Text | Was the fish saved or released. | |
100
|
Mark | Text | Type of mark a fish may have had, visible in field. | |
100
|
Scales | Text | Were scales collected yes or no. | |
100
|
habitat | Text | Type of habitat were the sampling occurred. | |
100
|
GPS | Text | When available latitude and longitude of station. | |
100
|
Sampling_Comments | Text | Description of sampling effort and gear type, and general. | |
100
|
Fish_Comments | Text | Any further info deemed relavent for a fish. |
Attribute Details
Sample_Unique_Code
Seq. Order: | 1 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique combination of date, station and sampling code. |
General Data Type: | Text |
Sample_Date
Seq. Order: | 2 |
---|---|
Data Storage Type: | Date |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date and time of sampling event. |
General Data Type: | Date |
Station Code
Seq. Order: | 3 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sample site name. |
General Data Type: | Text |
Station Locality
Seq. Order: | 4 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Description of sample site. |
General Data Type: | Text |
Salmonid ID
Seq. Order: | 5 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique salmon identification number, ties it to any other related data such as genetics. |
General Data Type: | Text |
Species (common name)
Seq. Order: | 6 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Common name of fish sampled. |
General Data Type: | Text |
Life history
Seq. Order: | 7 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Identifies salmon life history stage (Unknown;Subyearling;Yearling;Juvenile;Adult). |
General Data Type: | Text |
Allowed Values: | Unknown;Subyearling;Yearling;Juvenile;Adult |
Length (mm)
Seq. Order: | 8 |
---|---|
Data Storage Type: | Number |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Actual fork or total length of fish in millimeters. Units for values are millimeters. |
General Data Type: | Number |
Unit of Measure: | millimeters |
Count
Seq. Order: | 9 |
---|---|
Data Storage Type: | Number |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Default = 1, otherwise mass count per species. |
General Data Type: | Number |
Measurement
Seq. Order: | 10 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
How fish was measured, dependent on species. |
General Data Type: | Text |
Allowed Values: | FL (mm);TL (mm);Count;Carapace (mm);SL (mm) |
WT (g) individual
Seq. Order: | 11 |
---|---|
Data Storage Type: | Number |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Weight measured to 0.1 grams. Units for values are Grams. |
General Data Type: | Number |
Unit of Measure: | Grams |
Genetics
Seq. Order: | 12 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Were genetic sample taken yes or no. |
General Data Type: | Text |
Allowed Values: | Yes;No |
Sample
Seq. Order: | 13 |
---|---|
Data Storage Type: | Number |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Processing sample number assigned by genetics lab. |
General Data Type: | Number |
Sample No
Seq. Order: | 14 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Processing sample number assigned by genetics lab combined with Salmonid ID. |
General Data Type: | Text |
Best Estimate
Seq. Order: | 15 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Best estimate of source population origin. See GeneticSources lookup table for complete description and acceptable values. |
General Data Type: | Text |
Probability
Seq. Order: | 16 |
---|---|
Data Storage Type: | Number |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Probability of best estimate. |
General Data Type: | Number |
2nd Best Estimate
Seq. Order: | 17 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Second best estimate of source population origin. See GeneticSources lookup table for complete description and acceptable values. |
General Data Type: | Text |
Probability 2nd Best Estimate
Seq. Order: | 18 |
---|---|
Data Storage Type: | Number |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Probability of second best estimate. |
General Data Type: | Number |
Saved
Seq. Order: | 19 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Was the fish saved or released. |
General Data Type: | Text |
Allowed Values: | R;S |
Mark
Seq. Order: | 20 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Type of mark a fish may have had, visible in field. |
General Data Type: | Text |
Scales
Seq. Order: | 21 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Were scales collected yes or no. |
General Data Type: | Text |
Allowed Values: | Yes;No |
habitat
Seq. Order: | 22 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Type of habitat were the sampling occurred. |
General Data Type: | Text |
GPS
Seq. Order: | 23 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
When available latitude and longitude of station. |
General Data Type: | Text |
Sampling_Comments
Seq. Order: | 24 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Description of sampling effort and gear type, and general. |
General Data Type: | Text |
Fish_Comments
Seq. Order: | 25 |
---|---|
Data Storage Type: | Text |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Any further info deemed relavent for a fish. |
General Data Type: | Text |
Catalog Details
Catalog Item ID: | 51553 |
---|---|
GUID: | gov.noaa.nmfs.inport:51553 |
Metadata Record Created By: | Jeffrey W Cowen |
Metadata Record Created: | 2018-02-20 14:53+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 |