Metadata Rubric

100%

6 / 6

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

Elwha Dam Removal Neashore Monitoring Field Details

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

Item Identification

Title:	Elwha Dam Removal Neashore Monitoring Field Details
Short Name:	Elwha Dam Removal Neashore Monitoring Field Details
Status:	Planned
Abstract:	Fish-specific information collected in the field.

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	PARR
Description:	Fish-specific information collected in the field.

Data Attributes

Attribute Summary

	Name	Type	Description
100	ID	NUMBER	Auto-generated unique identifier.
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	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	fklength	NUMBER	Measured fork length in mm, measured in the field.
100	sex	VARCHAR2	Field-assigned gender of sampled individual fish; not always recorded.
100	comments	VARCHAR2	Comments relevant to the sampled individual fish.
100	fish_id	VARCHAR2	Unique identifier assigned to individual sampled fish when it is retained for further analysis.
100	catch_id	NUMBER	Unique identifier of this date/site/set sample; links to catch_data table.
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

NUMBER

Auto-generated unique identifier.

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

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

fklength

NUMBER

Measured fork length in mm, measured in the field.

100

sex

VARCHAR2

Field-assigned gender of sampled individual fish; not always recorded.

100

comments

VARCHAR2

Comments relevant to the sampled individual fish.

100

fish_id

VARCHAR2

Unique identifier assigned to individual sampled fish when it is retained for further analysis.

100

catch_id

NUMBER

Unique identifier of this date/site/set sample; links to catch_data table.

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

ID

CC ID: 731730

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Auto-generated unique identifier.
General Data Type:	NUMBER

set_id

CC ID: 731731

Seq. Order:	2
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: 731732

Seq. Order:	3
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: 731733

Seq. Order:	4
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: 731734

Seq. Order:	5
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: 731735

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	Identified fish species sampled.
General Data Type:	VARCHAR2

life_stage

CC ID: 731736

Seq. Order:	7
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

CWT

CC ID: 731737

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	5
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: 731738

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	22
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

fklength

CC ID: 731739

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Measured fork length in mm, measured in the field.
General Data Type:	NUMBER

sex

CC ID: 731740

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Field-assigned gender of sampled individual fish; not always recorded.
General Data Type:	VARCHAR2

comments

CC ID: 731741

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Comments relevant to the sampled individual fish.
General Data Type:	VARCHAR2

fish_id

CC ID: 731742

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique identifier assigned to individual sampled fish when it is retained for further analysis.
General Data Type:	VARCHAR2

catch_id

CC ID: 731743

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique identifier of this date/site/set sample; links to catch_data table.
General Data Type:	NUMBER

hatchery

CC ID: 731744

Seq. Order:	15
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:	36342
GUID:	gov.noaa.nmfs.inport:36342
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