Metadata Rubric

100%

6 / 6

NWFSC Metadata Library > FE (Fish Ecology) Division > Elwha Master Datafile - Elwha dam removal neash... >

Elwha Dam Removal Neashore Monitoring Catch Information

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

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

	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.

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
GUID:	gov.noaa.nmfs.inport: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:	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