Item Identification

Title: Elwha Dam Removal Neashore Monitoring Catch Information
Short Name: Elwha Dam Removal Neashore Monitoring Catch Information
Status: Planned
Abstract:

Species and subgroup specific counts for individual beach seine catches.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: PARR
Description:

Species and subgroup specific counts for individual beach seine catches.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
set_id NUMBER Unique set identifier, links to set_info table.
100
site_name VARCHAR2 Name of sampling location.
100
site_setnum VARCHAR2 Subdivision within named sampling location; we sample 1-4 sites at one named location, generally 10s-100s of meters apart.
100
sample_date DATE Date on which sampling occured for this site/set combination.
100
species VARCHAR2 Identified fish species sampled.
100
life_stage VARCHAR2 Life stage designation used for some sampled species: forage fish (surf smelt, sand lance, and herring only) get divided into post-larval (<50mm), juvenile (50-120mm), and adult (>120mm). Chinook and coho salmon assigned 0+ and 1+ age based on size/month.
100
raw_count NUMBER Count of individuals of a given species in the assessed sample; for large hauls we subsample by volume.
100
total_count NUMBER Total count of individuals of a given species in the haul; calculated number for hauls that were subsampled by volume.
100
CWT VARCHAR2 Yes/no value for presence of a coded wire tag (CWT). Recorded for Chinook and coho salmon only.
100
ad_clip VARCHAR2 Yes/no value regarding adipose fin clipped status. Recorded for Chinook and coho salmon only. y=ad-clipped, no=intact adipose fin.
100
catch_ID NUMBER Unique identifier of this date/site/set sample.
100
hatchery VARCHAR2 Assigned hatchery designation for Chinook and coho salmon only determined based on combination of CWT and ad_clip status. CWT=y and/or ad_clip=y then H, otherwise called wild.

Attribute Details

set_id

CC ID: 731718
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

site_name

CC ID: 731719
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Name of sampling location.

General Data Type: VARCHAR2

site_setnum

CC ID: 731720
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Subdivision within named sampling location; we sample 1-4 sites at one named location, generally 10s-100s of meters apart.

General Data Type: VARCHAR2

sample_date

CC ID: 731721
Seq. Order: 4
Data Storage Type: DATE
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Date on which sampling occured for this site/set combination.

General Data Type: DATE

species

CC ID: 731722
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Identified fish species sampled.

General Data Type: VARCHAR2

life_stage

CC ID: 731723
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Life stage designation used for some sampled species: forage fish (surf smelt, sand lance, and herring only) get divided into post-larval (<50mm), juvenile (50-120mm), and adult (>120mm). Chinook and coho salmon assigned 0+ and 1+ age based on size/month.

General Data Type: VARCHAR2

raw_count

CC ID: 731724
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Count of individuals of a given species in the assessed sample; for large hauls we subsample by volume.

General Data Type: NUMBER

total_count

CC ID: 731725
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Total count of individuals of a given species in the haul; calculated number for hauls that were subsampled by volume.

General Data Type: NUMBER

CWT

CC ID: 731726
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Yes/no value for presence of a coded wire tag (CWT). Recorded for Chinook and coho salmon only.

General Data Type: VARCHAR2

ad_clip

CC ID: 731727
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Yes/no value regarding adipose fin clipped status. Recorded for Chinook and coho salmon only. y=ad-clipped, no=intact adipose fin.

General Data Type: VARCHAR2

catch_ID

CC ID: 731728
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier of this date/site/set sample.

General Data Type: NUMBER

hatchery

CC ID: 731729
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Assigned hatchery designation for Chinook and coho salmon only determined based on combination of CWT and ad_clip status. CWT=y and/or ad_clip=y then H, otherwise called wild.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 36341
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-01-19 16:18+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