Metadata Rubric

100%

6 / 6

NWFSC Metadata Library > FE (Fish Ecology) Division > Elwha Master Datafile - Elwha dam removal neash... >

Elwha Dam Removal Neashore Monitoring Lab Results

Entity (ENT) | Northwest Fisheries Science Center (NWFSC)
GUID: gov.noaa.nmfs.inport:36335 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Follow up fish-specific information gathered in the lab.

Description

Follow up fish-specific information gathered in the lab.

Entity Type
Data Table

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

Data Attribute / Type

Description

set_id
NUMBER

Unique set identifier, links to set_info table.

fish_id
VARCHAR2

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

fklength_lab
NUMBER

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

species
VARCHAR2

Identified fish species sampled.

weight
NUMBER

Wet weight in grams (g).

otolith
VARCHAR2

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

stomach_content
VARCHAR2

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

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).

genetic_result
VARCHAR2

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

CWT_result
VARCHAR2

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

CWT_release
VARCHAR2

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

No Child Items for this record.

No contact information is available for this record.

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

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 Type:	Data Table
Active Version?:	Yes
Schema Name:	PARR
Description:	Follow up fish-specific information gathered in the lab.

Attribute Summary

	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.

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

Elwha Dam Removal Neashore Monitoring Lab Results

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

set_id

fish_id

fklength_lab

species

weight

otolith

stomach_content

genetic_sample_num

genetic_result

CWT_result

CWT_release

Catalog Details