Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Elwha Dam Removal Neashore Monitoring Lab Results
Short Name: Elwha Dam Removal Neashore Monitoring Lab Results
Status: Planned
Abstract:

Follow up fish-specific information gathered in the lab.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: PARR
Description:

Follow up fish-specific information gathered in the lab.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
set_id NUMBER Unique set identifier, links to set_info table.
100
fish_id VARCHAR2 Unique identifier assigned to individual sampled fish when it is retained for further analysis.
100
fklength_lab NUMBER Measured fork length in mm, measured in the lab (sometimes different from field measurement).
100
species VARCHAR2 Identified fish species sampled.
100
weight NUMBER Wet weight in grams (g).
100
otolith VARCHAR2 Number of otoliths extracted from the sample. field only filled when otoliths are retained.
100
stomach_content VARCHAR2 Yes/no entry regarding whether the individual fish stomach contained food. field only filled when stomach contents were extracted.
100
genetic_sample_num VARCHAR2 Unique identifier assigned to individual fish when it is sampled for genetic analysis (sometimes vials are pre-labeled so does not always match fish_id).
100
genetic_result VARCHAR2 Results of genetic analysiis. Level of detail dependent on species in question and lab where analyzed.
100
CWT_result VARCHAR2 Alphanumeric code read off of embedded coded wire tag in sampled individual fish.
100
CWT_release VARCHAR2 Location of release related to the coded wire tag that was read. Results obtained from state or regional CWT data repository.

Attribute Details

set_id

CC ID: 731745
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unique set identifier, links to set_info table.

General Data Type: NUMBER

fish_id

CC ID: 731746
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 255
Required: Yes
Primary Key: No
Status: Active
Description:

Unique identifier assigned to individual sampled fish when it is retained for further analysis.

General Data Type: VARCHAR2

fklength_lab

CC ID: 731747
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Measured fork length in mm, measured in the lab (sometimes different from field measurement).

General Data Type: NUMBER

species

CC ID: 731748
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Identified fish species sampled.

General Data Type: VARCHAR2

weight

CC ID: 731749
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Wet weight in grams (g).

General Data Type: NUMBER

otolith

CC ID: 731750
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Number of otoliths extracted from the sample. field only filled when otoliths are retained.

General Data Type: VARCHAR2

stomach_content

CC ID: 731751
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Yes/no entry regarding whether the individual fish stomach contained food. field only filled when stomach contents were extracted.

General Data Type: VARCHAR2

genetic_sample_num

CC ID: 731752
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier assigned to individual fish when it is sampled for genetic analysis (sometimes vials are pre-labeled so does not always match fish_id).

General Data Type: VARCHAR2

genetic_result

CC ID: 731753
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Results of genetic analysiis. Level of detail dependent on species in question and lab where analyzed.

General Data Type: VARCHAR2

CWT_result

CC ID: 731754
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Alphanumeric code read off of embedded coded wire tag in sampled individual fish.

General Data Type: VARCHAR2

CWT_release

CC ID: 731755
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Location of release related to the coded wire tag that was read. Results obtained from state or regional CWT data repository.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 36335
GUID: gov.noaa.nmfs.inport:36335
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-01-19 15:50+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