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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Fish-specific information collected in the field.

Description

Fish-specific information collected in the field.

Entity Type
Data Table

Data Attribute / Type	Description
ID NUMBER	Auto-generated unique identifier.
set_id NUMBER	Unique set identifier, links to set_info table.
site_name VARCHAR2	Name of sampling location.
site_setnum VARCHAR2	Subdivision within named sampling location; we sample 1-4 sites at one named location, generally 10s-100s of meters apart.
sample_date DATE	Date on which sampling occured for this site/set combination.
species VARCHAR2	Identified fish species sampled.
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.
CWT VARCHAR2	Yes/no value for presence of a coded wire tag (CWT). Recorded for Chinook and coho salmon only.
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.
fklength NUMBER	Measured fork length in mm, measured in the field.
sex VARCHAR2	Field-assigned gender of sampled individual fish; not always recorded.
comments VARCHAR2	Comments relevant to the sampled individual fish.
fish_id VARCHAR2	Unique identifier assigned to individual sampled fish when it is retained for further analysis.
catch_id NUMBER	Unique identifier of this date/site/set sample; links to catch_data table.
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.

Data Attribute / Type

Description

ID
NUMBER

Auto-generated unique identifier.

set_id
NUMBER

Unique set identifier, links to set_info table.

site_name
VARCHAR2

Name of sampling location.

site_setnum
VARCHAR2

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

sample_date
DATE

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

species
VARCHAR2

Identified fish species sampled.

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.

CWT
VARCHAR2

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

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.

fklength
NUMBER

Measured fork length in mm, measured in the field.

sex
VARCHAR2

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

comments
VARCHAR2

Comments relevant to the sampled individual fish.

fish_id
VARCHAR2

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

catch_id
NUMBER

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

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.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (NWFSC) for inquiries on this record.

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 Type:	Data Table
Active Version?:	Yes
Schema Name:	PARR
Description:	Fish-specific information collected in the field.

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

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 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

Elwha Dam Removal Neashore Monitoring Field Details

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ID

set_id

site_name

site_setnum

sample_date

species

life_stage

CWT

ad_clip

fklength

sex

comments

fish_id

catch_id

hatchery

Catalog Details