Item Identification

Title: Elwha Dam Removal Neashore Monitoring Sites
Short Name: Elwha Dam Removal Neashore Monitoring Sites
Status: Planned
Abstract:

Information on sampling sites for Strait of Juan de Fuca beach seining.

Entity Information

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

Information on sampling sites for Strait of Juan de Fuca beach seining.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
site_id NUMBER Auto assigned unique identifier for the named site location.
100
site_name VARCHAR2 Name of sampling location.
100
latitude NUMBER Latitude for geographical location reference (absolute value, all locations in Strait of Juan de Fuca, Washington).
100
longitude NUMBER Longitude for geographical location reference (absolute value, all locations in Strait of Juan de Fuca, Washington).
100
region VARCHAR2 Project assigned groupings of sites based on geography.
100
site_code VARCHAR2 Field data sheet site code assignment (project usage only, replaced by full site names in database usage).
100
description VARCHAR2 Description of site location with point references for field use.
100
exposure VARCHAR2 Categorical assignment based on beach aspect relative to waves and wind.
100
feature_type VARCHAR2 Categorical assignment based on geologic morphology.
100
substrate_type VARCHAR2 Categorical assignment based on grain size of beach substrate.
100
vegetation_type VARCHAR2 Categorical assignment based on qualitative assessment of dominant vegetative type in the intertidal and shallow subtidal.
100
geomorphic_type VARCHAR2 Categorical assignment based on a combination of geologic morphology and substrate type.
100
site_grouping VARCHAR2 Categorical assignment based on geographic location relative to the Elwha River mouth for analysis.
100
regional_group VARCHAR2 Categorical assignment based on geographic location for analysis, only for sites with consistent sampling.

Attribute Details

site_id

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

Auto assigned unique identifier for the named site location.

General Data Type: NUMBER

site_name

CC ID: 731770
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

latitude

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

Latitude for geographical location reference (absolute value, all locations in Strait of Juan de Fuca, Washington).

General Data Type: NUMBER
Format Mask: Standard

longitude

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

Longitude for geographical location reference (absolute value, all locations in Strait of Juan de Fuca, Washington).

General Data Type: NUMBER
Format Mask: Standard

region

CC ID: 731773
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Project assigned groupings of sites based on geography.

General Data Type: VARCHAR2

site_code

CC ID: 731774
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Field data sheet site code assignment (project usage only, replaced by full site names in database usage).

General Data Type: VARCHAR2

description

CC ID: 731775
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Description of site location with point references for field use.

General Data Type: VARCHAR2

exposure

CC ID: 731776
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Categorical assignment based on beach aspect relative to waves and wind.

General Data Type: VARCHAR2

feature_type

CC ID: 731777
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Categorical assignment based on geologic morphology.

General Data Type: VARCHAR2

substrate_type

CC ID: 731778
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Categorical assignment based on grain size of beach substrate.

General Data Type: VARCHAR2

vegetation_type

CC ID: 731779
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Categorical assignment based on qualitative assessment of dominant vegetative type in the intertidal and shallow subtidal.

General Data Type: VARCHAR2

geomorphic_type

CC ID: 731780
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Categorical assignment based on a combination of geologic morphology and substrate type.

General Data Type: VARCHAR2

site_grouping

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

Categorical assignment based on geographic location relative to the Elwha River mouth for analysis.

General Data Type: VARCHAR2

regional_group

CC ID: 731782
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Categorical assignment based on geographic location for analysis, only for sites with consistent sampling.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 36337
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