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
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: 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