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
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionTable 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
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?. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NWFSC) for inquiries on this record.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |