Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Recolonization of the Cedar River by Pacific Salmon 2000-2015
Short Name: Recolonization of the Cedar River by Pacific Salmon 2000-2015
Status: Planned
Abstract:

Habitat and snorkel counts of fish.

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Schema Name: PARR
Description:

Habitat and snorkel counts of fish.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Stream VARCHAR2 Stream name. In this case represents Cedar River from above Landsburg Dam to Cedar Falls.
100
Season VARCHAR2 Season when survey was conducted. In this case all surveys were in late July to early August.
100
Year NUMBER Calendar year when survey was conducted.
100
Reach NUMBER Reach number (1-10). Defined by changes in channel gradient, valley confinement, and dominant substrate. Reach 1 starts ~200 m upstream of Landsburg Dam; Reach 10 ends at Cedar Falls a natural migration barrier.
100
Main.unit.# VARCHAR2 Not applicable for 2000-2004. In 2005, classified habitat types into primary channel unit or main unit.
100
Subunit.num VARCHAR2 Not applicable for 2000-2004. In 2005, classified habitat types into primary channel unit or main unit with sub-unit habitat types within main unit.
100
Habitat.type VARCHAR2 Habitat types or pools, riffles, runs, step pools, cascades, depositional and side channel units.
100
unit.area.m2 NUMBER Unit area (width x length) of each habitat type. Units for values are Square meter.
100
max.depth.m NUMBER Not always measured but represents the maximum depth in meters for each habitat unit. Measured using a stadia rod. Units for values are Meter.
100
tail.depth.m NUMBER Not always measured but represents the tail depth in meters for each pool unit. Measured using a stadia rod. Units for values are Meter.
100
Avg.depth.m NUMBER Not always measured but represents the average depth in meters for each unit. Measured using a stadia rod at the top, middle and end of each unit. Units for values are Meter.
100
residual.depth.m NUMBER Only measured in pool units. Difference between maximum depth and tail depth in meters. Units for values are Meter.
100
avg.vel.m.s NUMBER Not always measured but represents the average velocity of each unit. Measured using a Swoffer flow meter at the top, middle and bottom of each unit. Units for values are Meter.
100
trt.size1 NUMBER Unidentifed trout < 90 millimeters total length. Units for values are Millimeter.
100
trt.size2 NUMBER Unidentifed trout > 91 < 190 millimeters total length. Units for values are Millimeter.
100
trt.size3 NUMBER Unidentifed trout > 191 < 250 millimeters total length. Units for values are Millimeter.
100
trt.size4 NUMBER Unidentifed trout >251 < 330 mm total length. Units for values are Millimeter.
100
trt.size5 NUMBER Unidentifed trout > 331 mm total length. Units for values are Millimeter.
100
rb.size1 NUMBER Rainbow trout < 90 mm total length. Units for values are Millimeter.
100
rb.size2 NUMBER Rainbow trout > 91 < 190 mm total length. Units for values are Millimeter.
100
rb.size3 NUMBER Rainbow trout > 191 < 250 mm total length. Units for values are Millimeter.
100
rb.size4 NUMBER Rainbow trout >251 < 330 mm total length. Units for values are Millimeter.
100
rb.size5 NUMBER Rainbow trout > 331 mm total length. Units for values are Millimeter.
100
steelhead.adult NUMBER Steelhead adult. Units for values are Millimeter.
100
cutt.size1 NUMBER Cutthroat trout < 90 mm total length. Units for values are Millimeter.
100
cutt.size2 NUMBER Cutthroat trout > 91 < 190 mm total length. Units for values are Millimeter.
100
cutt.size3 NUMBER Cutthroat trout > 191 < 250 mm total length. Units for values are Millimeter.
100
cutt.size4 NUMBER Cutthroat trout >251 < 330 mm total length. Units for values are Millimeter.
100
cutt.size5 NUMBER Cutthroat trout > 331 mm total length. Units for values are Millimeter.
100
juvcoho NUMBER Juvenile coho. Units for values are Millimeter.
100
juvchinook NUMBER Juvenile Chinook. Units for values are Millimeter.
100
sockeye.adult NUMBER Sockeye adult. Units for values are Millimeter.
100
mwf.size1 NUMBER Mountain whitefish < 90 mm total length. Units for values are Millimeter.
100
mwf.size2 NUMBER Mountain whitefish trout > 91 < 190 mm total length. Units for values are Millimeter.
100
mwf.size3 NUMBER Mountain whitefish trout > 191 < 250 mm total length. Units for values are Millimeter.
100
mwf.siz4 NUMBER Mountain whitefish trout >251 < 330 mm total length. Units for values are Millimeter.
100
mwf.szie5 NUMBER Mountain whitefish trout > 331 mm total length. Units for values are Millimeter.
100
sculpin.size1 NUMBER Sculpin < 90 mm in total length. Units for values are Millimeter.
100
sculpin.size2 NUMBER Sculpin > 90 mm in total length. Units for values are Millimeter.
100
lamprey.size1 NUMBER Lamprey < 90 mm in total length. Units for values are Millimeter.
100
lamprey.size2 NUMBER Lamprey > 90 mm in total length. Units for values are Millimeter.
100
charr.size3 NUMBER Bull trout >191 < 250 mm total length. Units for values are Millimeter.
100
charr.size4 NUMBER Bull trout > 251 and < 330 mm in total length. Units for values are Millimeter.
100
charr.size5 NUMBER Bull trout > 331 mm in total length. Units for values are Millimeter.

Attribute Details

Stream

CC ID: 732208
Seq. Order: 1
Data Storage Type: VARCHAR2
Required: Yes
Primary Key: No
Status: Active
Description:

Stream name. In this case represents Cedar River from above Landsburg Dam to Cedar Falls.

General Data Type: VARCHAR2

Season

CC ID: 732209
Seq. Order: 2
Data Storage Type: VARCHAR2
Required: Yes
Primary Key: No
Status: Active
Description:

Season when survey was conducted. In this case all surveys were in late July to early August.

General Data Type: VARCHAR2

Year

CC ID: 732210
Seq. Order: 3
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Calendar year when survey was conducted.

General Data Type: NUMBER

Reach

CC ID: 732211
Seq. Order: 4
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Reach number (1-10). Defined by changes in channel gradient, valley confinement, and dominant substrate. Reach 1 starts ~200 m upstream of Landsburg Dam; Reach 10 ends at Cedar Falls a natural migration barrier.

General Data Type: NUMBER

Main.unit.#

CC ID: 732212
Seq. Order: 5
Data Storage Type: VARCHAR2
Required: Yes
Primary Key: No
Status: Active
Description:

Not applicable for 2000-2004. In 2005, classified habitat types into primary channel unit or main unit.

General Data Type: VARCHAR2

Subunit.num

CC ID: 732213
Seq. Order: 6
Data Storage Type: VARCHAR2
Required: Yes
Primary Key: No
Status: Active
Description:

Not applicable for 2000-2004. In 2005, classified habitat types into primary channel unit or main unit with sub-unit habitat types within main unit.

General Data Type: VARCHAR2
Null Value Meaning:

Subunit habitats not classified.

Habitat.type

CC ID: 732214
Seq. Order: 7
Data Storage Type: VARCHAR2
Required: Yes
Primary Key: No
Status: Active
Description:

Habitat types or pools, riffles, runs, step pools, cascades, depositional and side channel units.

General Data Type: VARCHAR2

unit.area.m2

CC ID: 732215
Seq. Order: 8
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Unit area (width x length) of each habitat type. Units for values are Square meter.

General Data Type: NUMBER
Unit of Measure: Square meter
Allowed Values: > 1 m2

max.depth.m

CC ID: 732216
Seq. Order: 9
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Not always measured but represents the maximum depth in meters for each habitat unit. Measured using a stadia rod. Units for values are Meter.

General Data Type: NUMBER
Unit of Measure: Meter
Null Value Meaning:

NA

Allowed Values: > 0 <10 m

tail.depth.m

CC ID: 732217
Seq. Order: 10
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Not always measured but represents the tail depth in meters for each pool unit. Measured using a stadia rod. Units for values are Meter.

General Data Type: NUMBER
Unit of Measure: Meter
Allowed Values: > 0 <10 m

Avg.depth.m

CC ID: 732218
Seq. Order: 11
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Not always measured but represents the average depth in meters for each unit. Measured using a stadia rod at the top, middle and end of each unit. Units for values are Meter.

General Data Type: NUMBER
Unit of Measure: Meter
Allowed Values: > 0 < 7.5 m

residual.depth.m

CC ID: 732219
Seq. Order: 12
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Only measured in pool units. Difference between maximum depth and tail depth in meters. Units for values are Meter.

General Data Type: NUMBER
Unit of Measure: Meter
Allowed Values: > 0 < 7.5 m

avg.vel.m.s

CC ID: 732220
Seq. Order: 13
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Not always measured but represents the average velocity of each unit. Measured using a Swoffer flow meter at the top, middle and bottom of each unit. Units for values are Meter.

General Data Type: NUMBER
Unit of Measure: Meter
Allowed Values: > 0 <5 m/s

trt.size1

CC ID: 732221
Seq. Order: 14
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Unidentifed trout < 90 millimeters total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

trt.size2

CC ID: 732222
Seq. Order: 15
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Unidentifed trout > 91 < 190 millimeters total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

trt.size3

CC ID: 732223
Seq. Order: 16
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Unidentifed trout > 191 < 250 millimeters total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

trt.size4

CC ID: 732224
Seq. Order: 17
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Unidentifed trout >251 < 330 mm total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

trt.size5

CC ID: 732225
Seq. Order: 18
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Unidentifed trout > 331 mm total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

rb.size1

CC ID: 732226
Seq. Order: 19
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Rainbow trout < 90 mm total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

rb.size2

CC ID: 732227
Seq. Order: 20
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Rainbow trout > 91 < 190 mm total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

rb.size3

CC ID: 732228
Seq. Order: 21
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Rainbow trout > 191 < 250 mm total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

rb.size4

CC ID: 732229
Seq. Order: 22
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Rainbow trout >251 < 330 mm total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

rb.size5

CC ID: 732230
Seq. Order: 23
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Rainbow trout > 331 mm total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

steelhead.adult

CC ID: 732231
Seq. Order: 24
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Steelhead adult. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

cutt.size1

CC ID: 732232
Seq. Order: 25
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Cutthroat trout < 90 mm total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

cutt.size2

CC ID: 732233
Seq. Order: 26
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Cutthroat trout > 91 < 190 mm total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

cutt.size3

CC ID: 732234
Seq. Order: 27
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Cutthroat trout > 191 < 250 mm total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

cutt.size4

CC ID: 732235
Seq. Order: 28
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Cutthroat trout >251 < 330 mm total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

cutt.size5

CC ID: 732236
Seq. Order: 29
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Cutthroat trout > 331 mm total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

juvcoho

CC ID: 732237
Seq. Order: 30
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Juvenile coho. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

juvchinook

CC ID: 732238
Seq. Order: 31
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Juvenile Chinook. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

sockeye.adult

CC ID: 732239
Seq. Order: 32
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Sockeye adult. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

mwf.size1

CC ID: 732240
Seq. Order: 33
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Mountain whitefish < 90 mm total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

mwf.size2

CC ID: 732241
Seq. Order: 34
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Mountain whitefish trout > 91 < 190 mm total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

mwf.size3

CC ID: 732242
Seq. Order: 35
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Mountain whitefish trout > 191 < 250 mm total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

mwf.siz4

CC ID: 732243
Seq. Order: 36
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Mountain whitefish trout >251 < 330 mm total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

mwf.szie5

CC ID: 732244
Seq. Order: 37
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Mountain whitefish trout > 331 mm total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

sculpin.size1

CC ID: 732245
Seq. Order: 38
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Sculpin < 90 mm in total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

sculpin.size2

CC ID: 732246
Seq. Order: 39
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Sculpin > 90 mm in total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

lamprey.size1

CC ID: 732247
Seq. Order: 40
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Lamprey < 90 mm in total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

lamprey.size2

CC ID: 732248
Seq. Order: 41
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Lamprey > 90 mm in total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

charr.size3

CC ID: 732249
Seq. Order: 42
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Bull trout >191 < 250 mm total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

charr.size4

CC ID: 732250
Seq. Order: 43
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Bull trout > 251 and < 330 mm in total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

charr.size5

CC ID: 732251
Seq. Order: 44
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Bull trout > 331 mm in total length. Units for values are Millimeter.

General Data Type: NUMBER
Unit of Measure: Millimeter
Allowed Values: >0

Catalog Details

Catalog Item ID: 35546
GUID: gov.noaa.nmfs.inport:35546
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: 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