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
CC ID: 733369
| 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
CC ID: 733370
| 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
CC ID: 733371
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | Text |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sample site name. |
| General Data Type: | Text |
Station Locality
CC ID: 733372
| 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
CC ID: 733373
| 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)
CC ID: 733374
| 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
CC ID: 733375
| 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)
CC ID: 733376
| 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
CC ID: 733377
| 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
CC ID: 733378
| 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
CC ID: 733379
| 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
CC ID: 733380
| 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
CC ID: 733381
| 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
CC ID: 733382
| 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
CC ID: 733383
| 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
CC ID: 733384
| 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
CC ID: 733385
| 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
CC ID: 733386
| 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
CC ID: 733387
| 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
CC ID: 733388
| 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
CC ID: 733389
| 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
CC ID: 733390
| 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
CC ID: 733391
| 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
CC ID: 733392
| 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
CC ID: 733393
| 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 |