Slide Menu
System Maintenance Notice, Sunday, May 22, 2022 @ 8am-2pm Eastern. The Operations Team will be performing system maintenance on all server environments. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

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

Rubric Score Primary Key? 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.

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: 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 Review Frequency: 1 Year