Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Elwha Dam Removal Neashore Monitoring Net Setting Information
Short Name: Elwha Dam Removal Neashore Monitoring Net Setting Information
Status: Planned
Abstract:

Data related to each set of the beach seine net: site, date, time, and environmental characteristics.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: PARR
Description:

Data related to each set of the beach seine net: site, date, time, and environmental characteristics.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
site_ID NUMBER Unique site identifier, links to sites 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
sample_time DATE Time of day at which sampling occured for this site/set combination.
100
depth NUMBER Depth to bottom (in meters) at which environmental sampling was conducted in association with a beach seine set.
100
water_temp NUMBER Water temperature in degrees C, recorded with YSI sampling device.
100
salinity NUMBER Salinity at sampling location in parts per hundred 0/00, recorded with YSI sampling device.
100
DO NUMBER Dissolved oxygen at sampling location in milligrams/liter, recorded with YSI sampling device.
100
conductivity NUMBER Conductivity at sampling location, recorded with YSI sampling device.
100
set_id NUMBER Unique set identifier, primary key.
100
subsample_multiplier NUMBER Multiplier used for sampled catch. value=1 when all captured fish were assessed; multiplier used for calculating total_catch in catch_data table.
100
comments VARCHAR2 Comments relevant to the site, set, or conditions.

Attribute Details

site_ID

CC ID: 731756
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unique site identifier, links to sites table.

General Data Type: NUMBER

site_name

CC ID: 731757
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: 731758
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: 731759
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
Format Mask: Short Date

sample_time

CC ID: 731760
Seq. Order: 5
Data Storage Type: DATE
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Time of day at which sampling occured for this site/set combination.

General Data Type: DATE
Format Mask: Short Time

depth

CC ID: 731761
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Depth to bottom (in meters) at which environmental sampling was conducted in association with a beach seine set.

General Data Type: NUMBER

water_temp

CC ID: 731762
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Water temperature in degrees C, recorded with YSI sampling device.

General Data Type: NUMBER
Format Mask: Standard

salinity

CC ID: 731763
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Salinity at sampling location in parts per hundred 0/00, recorded with YSI sampling device.

General Data Type: NUMBER
Format Mask: Standard

DO

CC ID: 731764
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Dissolved oxygen at sampling location in milligrams/liter, recorded with YSI sampling device.

General Data Type: NUMBER
Format Mask: Standard

conductivity

CC ID: 731765
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Conductivity at sampling location, recorded with YSI sampling device.

General Data Type: NUMBER

set_id

CC ID: 731766
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unique set identifier, primary key.

General Data Type: NUMBER

subsample_multiplier

CC ID: 731767
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Multiplier used for sampled catch. value=1 when all captured fish were assessed; multiplier used for calculating total_catch in catch_data table.

General Data Type: NUMBER

comments

CC ID: 731768
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Comments relevant to the site, set, or conditions.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 36336
GUID: gov.noaa.nmfs.inport:36336
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-01-19 15:50+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 Next Review Date: 2019-02-28