Metadata Rubric

100%

6 / 6

NWFSC Metadata Library > EFS (Environmental and Fisheries Sciences) Divi... > Migrated from Resource Enhancement and Utilizat... > Hood Canal Steelhead - Hood Canal Steelhead Sup... >

Hood Canal Steelhead Parr and Smolt Data

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Table contains data collected from 2006-2015 as part of the Hood Canal Steelhead Project. Data was collected on 8 rivers in the Hood Canal primarily from screw (smolt) traps and summer hook and line sampling for parr. Also included are some adult steelhead sampling data from tribal gill nets. It include length, weight, and age data primarily.

Description

Entity Type
Spreadsheet

Data Attribute / Type	Description
Fish_ID VARCHAR2	If DNA/scale sample were taken, than this code corresponds to those samples and identifies individual fish. Codes are in the form "River abbreviation-Number". Spring smolt traps and summer parr samples may have duplicate numbers for the same year and river.
Year NUMBER	Year of data/sample collection. Units for values are Year.
Method VARCHAR2	Describes method of data and sample collection. Either adult trap, screw trap, hook&line, gill net , electrofishing, or tribal fishery.
River VARCHAR2	Name of the river where data collection and sampling took place.
Reach VARCHAR2	Reach of the river where data and sample were collected.
Life_History VARCHAR2	This is based on method of collection and size of the fish sampled. If fish was caught using a screw trap, fork length = 130mm are labelled as parr and fish with fork length > 130 are labelled as smolt. All other methods fish are labelled based on appearance/size.
Fork_Length VARCHAR2	Fork length of the fish sampled. Units for values are millimeters.
Weight VARCHAR2	Weight of the fish sampled. Units for values are grams.
Final_Age VARCHAR2	Age of fish is determined by scale sample collection, and brought to WDFW fish scale aging laboratory in Olympia, WA. Units for values are Years.
Date_Sampled DATE	Date that the fish was sampled including MM/DD/YYYY. Units for values are Date.
Scale_Sample VARCHAR2	Was a scale sample taken for this fish? Either yes, no, or NA.
DNA_Sample VARCHAR2	Was DNA sample taken for this fish? Either yes, no or NA (blank).
Lethal_Nonlethal VARCHAR2	Was the sample taken lethal or nonlethal?.
Smolt_Index VARCHAR2	Designation for fish caught in the smolt trap only. Categorized as a 1,2, or 3 based on appearance and coloration of fish. We will categorize steelhead captured in the trap with the following index. Enter the number (1, 2, or 3) corresponding to the classes below in the column SMOLT INDEX. ONLY use smolt index values of 1, 2, or 3. DO NOT use intermediate values (i.e., 1 or 2). i. Class 1 (non-smolt): parr marks distinct, showing no signs of smolting characteristics as described in Class 3. ii. Class 2 (pre-smolt): parr marks becoming faint, smolting characteristics beginning to appear. iii. Class 3 (smolt): parr marks absent or clearly assuming smolting characteristics such as, silvery appearance with black banded tail, nose, or dorsal fin; loosening of scales.
Yellowslash VARCHAR2	Does the fish have a yellow slash present under their jaw. Used to determine hybrids.
LongJaw VARCHAR2	Does the fish have a long jaw that extends past their eye? Used to determine hybrids.
Hybrid VARCHAR2	Was this fish identified as a hybrid?.
Acoustic_Sample VARCHAR2	Was this fish tagged with acoustic tag?.
ERROR VARCHAR2	Is there error associated with this data?.
Origin VARCHAR2	Is this fish natural origin or hatchery origin?.
PIT_Code VARCHAR2	Is there a PIT tag code associated with this fish data?.
Girth NUMBER	What is the girth of the fish? Measured with tape measure around the whole fish just behind their dorsal fin. Units for values are millimeters.
Notes VARCHAR2	Any comments or notes associated with this fish/ sample?.

Data Attribute / Type

Description

Fish_ID
VARCHAR2

If DNA/scale sample were taken, than this code corresponds to those samples and identifies individual fish. Codes are in the form "River abbreviation-Number". Spring smolt traps and summer parr samples may have duplicate numbers for the same year and river.

Year
NUMBER

Year of data/sample collection. Units for values are Year.

Method
VARCHAR2

Describes method of data and sample collection. Either adult trap, screw trap, hook&line, gill net , electrofishing, or tribal fishery.

River
VARCHAR2

Name of the river where data collection and sampling took place.

Reach
VARCHAR2

Reach of the river where data and sample were collected.

Life_History
VARCHAR2

This is based on method of collection and size of the fish sampled. If fish was caught using a screw trap, fork length = 130mm are labelled as parr and fish with fork length > 130 are labelled as smolt. All other methods fish are labelled based on appearance/size.

Fork_Length
VARCHAR2

Fork length of the fish sampled. Units for values are millimeters.

Weight
VARCHAR2

Weight of the fish sampled. Units for values are grams.

Final_Age
VARCHAR2

Age of fish is determined by scale sample collection, and brought to WDFW fish scale aging laboratory in Olympia, WA. Units for values are Years.

Date_Sampled
DATE

Date that the fish was sampled including MM/DD/YYYY. Units for values are Date.

Scale_Sample
VARCHAR2

Was a scale sample taken for this fish? Either yes, no, or NA.

DNA_Sample
VARCHAR2

Was DNA sample taken for this fish? Either yes, no or NA (blank).

Lethal_Nonlethal
VARCHAR2

Was the sample taken lethal or nonlethal?.

Smolt_Index
VARCHAR2

Designation for fish caught in the smolt trap only. Categorized as a 1,2, or 3 based on appearance and coloration of fish. We will categorize steelhead captured in the trap with the following index. Enter the number (1, 2, or 3) corresponding to the classes below in the column SMOLT INDEX. ONLY use smolt index values of 1, 2, or 3. DO NOT use intermediate values (i.e., 1 or 2). i. Class 1 (non-smolt): parr marks distinct, showing no signs of smolting characteristics as described in Class 3. ii. Class 2 (pre-smolt): parr marks becoming faint, smolting characteristics beginning to appear. iii. Class 3 (smolt): parr marks absent or clearly assuming smolting characteristics such as, silvery appearance with black banded tail, nose, or dorsal fin; loosening of scales.

Yellowslash
VARCHAR2

Does the fish have a yellow slash present under their jaw. Used to determine hybrids.

LongJaw
VARCHAR2

Does the fish have a long jaw that extends past their eye? Used to determine hybrids.

Hybrid
VARCHAR2

Was this fish identified as a hybrid?.

Acoustic_Sample
VARCHAR2

Was this fish tagged with acoustic tag?.

ERROR
VARCHAR2

Is there error associated with this data?.

Origin
VARCHAR2

Is this fish natural origin or hatchery origin?.

PIT_Code
VARCHAR2

Is there a PIT tag code associated with this fish data?.

Girth
NUMBER

What is the girth of the fish? Measured with tape measure around the whole fish just behind their dorsal fin. Units for values are millimeters.

Notes
VARCHAR2

Any comments or notes associated with this fish/ sample?.

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:	Hood Canal Steelhead Parr and Smolt Data
Short Name:	Hood Canal Steelhead Parr and Smolt Data
Status:	Planned
Abstract:	Table contains data collected from 2006-2015 as part of the Hood Canal Steelhead Project. Data was collected on 8 rivers in the Hood Canal primarily from screw (smolt) traps and summer hook and line sampling for parr. Also included are some adult steelhead sampling data from tribal gill nets. It include length, weight, and age data primarily.

Entity Type:	Spreadsheet
Active Version?:	Yes
Schema Name:	PARR
Description:	Table contains data collected from 2006-2015 as part of the Hood Canal Steelhead Project. Data was collected on 8 rivers in the Hood Canal primarily from screw (smolt) traps and summer hook and line sampling for parr. Also included are some adult steelhead sampling data from tribal gill nets. It include length, weight, and age data primarily.

Attribute Summary

	Name	Type	Description
100	Fish_ID	VARCHAR2	If DNA/scale sample were taken, than this code corresponds to those samples and identifies individual fish. Codes are in the form "River abbreviation-Number". Spring smolt traps and summer parr samples may have duplicate numbers for the same year and river.
100	Year	NUMBER	Year of data/sample collection. Units for values are Year.
100	Method	VARCHAR2	Describes method of data and sample collection. Either adult trap, screw trap, hook&line, gill net , electrofishing, or tribal fishery.
100	River	VARCHAR2	Name of the river where data collection and sampling took place.
100	Reach	VARCHAR2	Reach of the river where data and sample were collected.
100	Life_History	VARCHAR2	This is based on method of collection and size of the fish sampled. If fish was caught using a screw trap, fork length = 130mm are labelled as parr and fish with fork length > 130 are labelled as smolt. All other methods fish are labelled based on appearance/size.
100	Fork_Length	VARCHAR2	Fork length of the fish sampled. Units for values are millimeters.
100	Weight	VARCHAR2	Weight of the fish sampled. Units for values are grams.
100	Final_Age	VARCHAR2	Age of fish is determined by scale sample collection, and brought to WDFW fish scale aging laboratory in Olympia, WA. Units for values are Years.
100	Date_Sampled	DATE	Date that the fish was sampled including MM/DD/YYYY. Units for values are Date.
100	Scale_Sample	VARCHAR2	Was a scale sample taken for this fish? Either yes, no, or NA.
100	DNA_Sample	VARCHAR2	Was DNA sample taken for this fish? Either yes, no or NA (blank).
100	Lethal_Nonlethal	VARCHAR2	Was the sample taken lethal or nonlethal?.
100	Smolt_Index	VARCHAR2	Designation for fish caught in the smolt trap only. Categorized as a 1,2, or 3 based on appearance and coloration of fish. We will categorize steelhead captured in the trap with the following index. Enter the number (1, 2, or 3) corresponding to the classes below in the column SMOLT INDEX. ONLY use smolt index values of 1, 2, or 3. DO NOT use intermediate values (i.e., 1 or 2). i. Class 1 (non-smolt): parr marks distinct, showing no signs of smolting characteristics as described in Class 3. ii. Class 2 (pre-smolt): parr marks becoming faint, smolting characteristics beginning to appear. iii. Class 3 (smolt): parr marks absent or clearly assuming smolting characteristics such as, silvery appearance with black banded tail, nose, or dorsal fin; loosening of scales.
100	Yellowslash	VARCHAR2	Does the fish have a yellow slash present under their jaw. Used to determine hybrids.
100	LongJaw	VARCHAR2	Does the fish have a long jaw that extends past their eye? Used to determine hybrids.
100	Hybrid	VARCHAR2	Was this fish identified as a hybrid?.
100	Acoustic_Sample	VARCHAR2	Was this fish tagged with acoustic tag?.
100	ERROR	VARCHAR2	Is there error associated with this data?.
100	Origin	VARCHAR2	Is this fish natural origin or hatchery origin?.
100	PIT_Code	VARCHAR2	Is there a PIT tag code associated with this fish data?.
100	Girth	NUMBER	What is the girth of the fish? Measured with tape measure around the whole fish just behind their dorsal fin. Units for values are millimeters.
100	Notes	VARCHAR2	Any comments or notes associated with this fish/ sample?.

Name

Type

Description

100

Fish_ID

VARCHAR2

100

Year

NUMBER

Year of data/sample collection. Units for values are Year.

100

Method

VARCHAR2

Describes method of data and sample collection. Either adult trap, screw trap, hook&line, gill net , electrofishing, or tribal fishery.

100

River

VARCHAR2

Name of the river where data collection and sampling took place.

100

Reach

VARCHAR2

Reach of the river where data and sample were collected.

100

Life_History

VARCHAR2

100

Fork_Length

VARCHAR2

Fork length of the fish sampled. Units for values are millimeters.

100

Weight

VARCHAR2

Weight of the fish sampled. Units for values are grams.

100

Final_Age

VARCHAR2

Age of fish is determined by scale sample collection, and brought to WDFW fish scale aging laboratory in Olympia, WA. Units for values are Years.

100

Date_Sampled

DATE

Date that the fish was sampled including MM/DD/YYYY. Units for values are Date.

100

Scale_Sample

VARCHAR2

Was a scale sample taken for this fish? Either yes, no, or NA.

100

DNA_Sample

VARCHAR2

Was DNA sample taken for this fish? Either yes, no or NA (blank).

100

Lethal_Nonlethal

VARCHAR2

Was the sample taken lethal or nonlethal?.

100

Smolt_Index

VARCHAR2

100

Yellowslash

VARCHAR2

Does the fish have a yellow slash present under their jaw. Used to determine hybrids.

100

LongJaw

VARCHAR2

Does the fish have a long jaw that extends past their eye? Used to determine hybrids.

100

Hybrid

VARCHAR2

Was this fish identified as a hybrid?.

100

Acoustic_Sample

VARCHAR2

Was this fish tagged with acoustic tag?.

100

ERROR

VARCHAR2

Is there error associated with this data?.

100

Origin

VARCHAR2

Is this fish natural origin or hatchery origin?.

100

PIT_Code

VARCHAR2

Is there a PIT tag code associated with this fish data?.

100

Girth

NUMBER

What is the girth of the fish? Measured with tape measure around the whole fish just behind their dorsal fin. Units for values are millimeters.

100

Notes

VARCHAR2

Any comments or notes associated with this fish/ sample?.

Attribute Details

Fish_ID

CC ID: 731107

Seq. Order:	1
Data Storage Type:	VARCHAR2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	If DNA/scale sample were taken, than this code corresponds to those samples and identifies individual fish. Codes are in the form "River abbreviation-Number". Spring smolt traps and summer parr samples may have duplicate numbers for the same year and river.
General Data Type:	VARCHAR2

Year

CC ID: 731108

Seq. Order:	2
Data Storage Type:	NUMBER
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Year of data/sample collection. Units for values are Year.
General Data Type:	NUMBER
Unit of Measure:	Year
Allowed Values:	2006-2015

Method

CC ID: 731109

Seq. Order:	3
Data Storage Type:	VARCHAR2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Describes method of data and sample collection. Either adult trap, screw trap, hook&line, gill net , electrofishing, or tribal fishery.
General Data Type:	VARCHAR2

River

CC ID: 731110

Seq. Order:	4
Data Storage Type:	VARCHAR2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Name of the river where data collection and sampling took place.
General Data Type:	VARCHAR2

Reach

CC ID: 731111

Seq. Order:	5
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Reach of the river where data and sample were collected.
General Data Type:	VARCHAR2

Life_History

CC ID: 731112

Seq. Order:	6
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	This is based on method of collection and size of the fish sampled. If fish was caught using a screw trap, fork length = 130mm are labelled as parr and fish with fork length > 130 are labelled as smolt. All other methods fish are labelled based on appearance/size.
General Data Type:	VARCHAR2
Null Value:	blank
Null Value Meaning:	unspecified

Fork_Length

CC ID: 731113

Seq. Order:	7
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Fork length of the fish sampled. Units for values are millimeters.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

Weight

CC ID: 731114

Seq. Order:	8
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Weight of the fish sampled. Units for values are grams.
General Data Type:	VARCHAR2
Unit of Measure:	grams
Null Value:	blank
Null Value Meaning:	unspecified, not able to take weight

Final_Age

CC ID: 731115

Seq. Order:	9
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Age of fish is determined by scale sample collection, and brought to WDFW fish scale aging laboratory in Olympia, WA. Units for values are Years.
General Data Type:	VARCHAR2
Unit of Measure:	Years
Null Value:	blank/NA
Null Value Meaning:	scale sample not collected or unable to read scale sample (regenerated scale etc.)

Date_Sampled

CC ID: 731116

Seq. Order:	10
Data Storage Type:	DATE
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Date that the fish was sampled including MM/DD/YYYY. Units for values are Date.
General Data Type:	DATE
Unit of Measure:	Date
Format Mask:	MM/DD/YYYY
Null Value:	blank
Null Value Meaning:	unspecififed/ unknown
Allowed Values:	Dates only

Scale_Sample

CC ID: 731117

Seq. Order:	11
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Was a scale sample taken for this fish? Either yes, no, or NA.
General Data Type:	VARCHAR2
Null Value:	blank
Null Value Meaning:	unspecififed/ unknown

DNA_Sample

CC ID: 731118

Seq. Order:	12
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Was DNA sample taken for this fish? Either yes, no or NA (blank).
General Data Type:	VARCHAR2
Null Value:	blank
Null Value Meaning:	unspecififed/ unknown

Lethal_Nonlethal

CC ID: 731119

Seq. Order:	13
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Was the sample taken lethal or nonlethal?.
General Data Type:	VARCHAR2
Null Value:	blank
Null Value Meaning:	non lethal if left blank
Allowed Values:	Non or Lethal

Smolt_Index

CC ID: 731120

Seq. Order:	14
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Designation for fish caught in the smolt trap only. Categorized as a 1,2, or 3 based on appearance and coloration of fish. We will categorize steelhead captured in the trap with the following index. Enter the number (1, 2, or 3) corresponding to the classes below in the column SMOLT INDEX. ONLY use smolt index values of 1, 2, or 3. DO NOT use intermediate values (i.e., 1 or 2). i. Class 1 (non-smolt): parr marks distinct, showing no signs of smolting characteristics as described in Class 3. ii. Class 2 (pre-smolt): parr marks becoming faint, smolting characteristics beginning to appear. iii. Class 3 (smolt): parr marks absent or clearly assuming smolting characteristics such as, silvery appearance with black banded tail, nose, or dorsal fin; loosening of scales.
General Data Type:	VARCHAR2
Null Value:	blank
Null Value Meaning:	unspecified/unknown
Allowed Values:	1,2,3

Yellowslash

CC ID: 731121

Seq. Order:	15
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Does the fish have a yellow slash present under their jaw. Used to determine hybrids.
General Data Type:	VARCHAR2
Null Value:	blank
Null Value Meaning:	no yellow slash
Allowed Values:	Y/N

LongJaw

CC ID: 731122

Seq. Order:	16
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Does the fish have a long jaw that extends past their eye? Used to determine hybrids.
General Data Type:	VARCHAR2
Null Value:	blank
Null Value Meaning:	no long jaw
Allowed Values:	Y/N

Hybrid

CC ID: 731123

Seq. Order:	17
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Was this fish identified as a hybrid?.
General Data Type:	VARCHAR2
Null Value:	blank, *
Null Value Meaning:	not a hybrid

Acoustic_Sample

CC ID: 731124

Seq. Order:	18
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Was this fish tagged with acoustic tag?.
General Data Type:	VARCHAR2
Null Value:	blank
Null Value Meaning:	not acoustic tagged
Allowed Values:	Y/N/blank

ERROR

CC ID: 731125

Seq. Order:	19
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Is there error associated with this data?.
General Data Type:	VARCHAR2
Null Value:	blank
Null Value Meaning:	no error associated with data
Allowed Values:	Y/ blank

Origin

CC ID: 731126

Seq. Order:	20
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Is this fish natural origin or hatchery origin?.
General Data Type:	VARCHAR2
Null Value:	blank
Null Value Meaning:	assume natural origin unless specified as hatchery

PIT_Code

CC ID: 731127

Seq. Order:	21
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Is there a PIT tag code associated with this fish data?.
General Data Type:	VARCHAR2
Null Value:	blank
Null Value Meaning:	no PIT tag associated with data

Girth

CC ID: 731128

Seq. Order:	22
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	What is the girth of the fish? Measured with tape measure around the whole fish just behind their dorsal fin. Units for values are millimeters.
General Data Type:	NUMBER
Unit of Measure:	millimeters
Null Value:	blank
Null Value Meaning:	no girth measured

Notes

CC ID: 731129

Seq. Order:	23
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Any comments or notes associated with this fish/ sample?.
General Data Type:	VARCHAR2
Null Value:	blank
Null Value Meaning:	no comments associated with this fish/sample

Catalog Item ID:	35543
GUID:	gov.noaa.nmfs.inport:35543
Metadata Record Created By:	Jeffrey W Cowen
Metadata Record Created:	2016-11-04 15:24+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

Hood Canal Steelhead Parr and Smolt Data

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

Fish_ID

Year

Method

River

Reach

Life_History

Fork_Length

Weight

Final_Age

Date_Sampled

Scale_Sample

DNA_Sample

Lethal_Nonlethal

Smolt_Index

Yellowslash

LongJaw

Hybrid

Acoustic_Sample

ERROR

Origin

PIT_Code

Girth

Notes

Catalog Details