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. |
Attribute Details
set_id
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
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
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
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
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
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
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
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
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
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
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
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 |