Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NWFSC Metadata Library > FE (Fish Ecology) Division > FE Legacy Data Sets > Estuary-wide genetic stock distribution and sal... >

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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Columbia River estuary-wide genetic stock distribution and salmon habitat use within the tidal-fluvial estuary.

Description

Columbia River estuary-wide genetic stock distribution and salmon habitat use within the tidal-fluvial estuary.

Entity Information

Entity Type
Spreadsheet

Data Attribute / Type Description
Sample_Unique_Code
Text 		Unique combination of date, station and sampling code.
Sample_Date
Date 		Date and time of sampling event.
Station Code
Text 		Sample site name.
Station Locality
Text 		Description of sample site.
Salmonid ID
Text 		Unique salmon identification number, ties it to any other related data such as genetics.
Species (common name)
Text 		Common name of fish sampled.
Life history
Text 		Identifies salmon life history stage (Unknown;Subyearling;Yearling;Juvenile;Adult).
Length (mm)
Number 		Actual fork or total length of fish in millimeters. Units for values are millimeters.
Count
Number 		Default = 1, otherwise mass count per species.
Measurement
Text 		How fish was measured, dependent on species.
WT (g) individual
Number 		Weight measured to 0.1 grams. Units for values are Grams.
Genetics
Text 		Were genetic sample taken yes or no.
Sample
Number 		Processing sample number assigned by genetics lab.
Sample No
Text 		Processing sample number assigned by genetics lab combined with Salmonid ID.
Best Estimate
Text 		Best estimate of source population origin. See GeneticSources lookup table for complete description and acceptable values.
Probability
Number 		Probability of best estimate.
2nd Best Estimate
Text 		Second best estimate of source population origin. See GeneticSources lookup table for complete description and acceptable values.
Probability 2nd Best Estimate
Number 		Probability of second best estimate.
Saved
Text 		Was the fish saved or released.
Mark
Text 		Type of mark a fish may have had, visible in field.
Scales
Text 		Were scales collected yes or no.
habitat
Text 		Type of habitat were the sampling occurred.
GPS
Text 		When available latitude and longitude of station.
Sampling_Comments
Text 		Description of sampling effort and gear type, and general.
Fish_Comments
Text 		Any further info deemed relavent for a fish.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NWFSC) for inquiries on this record.

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

Rubric Score Primary Key? 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