Slide Menu
Search Help Show/Hide Menu

Item Identification

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 Information

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.

Data Attributes

Attribute Summary

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

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 Details

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