Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Physical and Biological Effects of Fish-friendly Tide Gates Site Details Data Logger Sensor Data
Short Name: Physical and Biological Effects of Fish-friendly Tide Gates Site Details Data Logger Sensor Data
Status: Planned
Abstract:

Continuous sensor data from three two-week observation periods at each site, including water level, salinity, and temperature at one-minute intervals above and below each culvert and vault, and at each reference channel.

Entity Information

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

Continuous sensor data from three two-week observation periods at each site, including water level, salinity, and temperature at one-minute intervals above and below each culvert and vault, and at each reference channel.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ID NUMBER Record ID.
100
Site VARCHAR2 Site name (see Site Details table for more information on each site).
100
Date DATE Date of observation.
100
Time DATE Time of observation.
100
DCE NUMBER Id number of data collection event, with each site having been sampled three intervals during 2011.
100
Upstream Water Elevation (NAVD88 meters) NUMBER Measured elevation of water immediately upstream of the structure in NAVD88.
100
Downstream Water Elevation (NAVD88 meters) NUMBER Measured elevation of water immediately downstrem of the structure in NAVD88.
100
Downstream Water Elevation and Perch Elevation Difference (m) NUMBER Downstream water elevation relative to the elevation of the downstream interior floor of the structure (perch elevation), with negative values indicating that the structure is perched and a water fall has formed at the structure mouth.
100
Inside Depth (m) NUMBER Water depth inside the structure.
100
Tilt (degree) NUMBER Angle readings from tilt sensors used to determine when gate doors opened and closed. Values do not necessarily coorespond with actual angles of the door positions.
100
Gate VARCHAR2 Classification of the gate door position based on the tilt data.
100
Temperature Upstream (C) NUMBER Water temperature upstream of the structure.
100
Salinity Upstream (ppt) NUMBER Water salinity upstream of the structure.
100
Temperature Downstream (C) NUMBER Water temperature downstream of the structure.
100
Salinity Downstream (ppt) NUMBER Water salinity downstream of the structure.
100
TideGage VARCHAR2 Name of closest tide gage station.
100
Tide_m NUMBER Tide height in meters - not corrected for local lags between tide gage and site.
100
Tide VARCHAR2 Classification of tidal stage as ebbing or flooding.

Attribute Details

ID

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

Record ID.

General Data Type: NUMBER

Site

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

Site name (see Site Details table for more information on each site).

General Data Type: VARCHAR2
Format Mask: @

Date

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

Date of observation.

General Data Type: DATE
Format Mask: m/d/yyyy

Time

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

Time of observation.

General Data Type: DATE
Format Mask: Short Time

DCE

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

Id number of data collection event, with each site having been sampled three intervals during 2011.

General Data Type: NUMBER
Format Mask: 0

Upstream Water Elevation (NAVD88 meters)

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

Measured elevation of water immediately upstream of the structure in NAVD88.

General Data Type: NUMBER
Format Mask: Fixed

Downstream Water Elevation (NAVD88 meters)

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

Measured elevation of water immediately downstrem of the structure in NAVD88.

General Data Type: NUMBER
Format Mask: Fixed

Downstream Water Elevation and Perch Elevation Difference (m)

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

Downstream water elevation relative to the elevation of the downstream interior floor of the structure (perch elevation), with negative values indicating that the structure is perched and a water fall has formed at the structure mouth.

General Data Type: NUMBER
Format Mask: Fixed

Inside Depth (m)

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

Water depth inside the structure.

General Data Type: NUMBER

Tilt (degree)

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

Angle readings from tilt sensors used to determine when gate doors opened and closed. Values do not necessarily coorespond with actual angles of the door positions.

General Data Type: NUMBER
Format Mask: 0.0

Gate

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

Classification of the gate door position based on the tilt data.

General Data Type: VARCHAR2
Format Mask: 0

Temperature Upstream (C)

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

Water temperature upstream of the structure.

General Data Type: NUMBER
Format Mask: 0.0

Salinity Upstream (ppt)

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

Water salinity upstream of the structure.

General Data Type: NUMBER
Format Mask: 0.0

Temperature Downstream (C)

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

Water temperature downstream of the structure.

General Data Type: NUMBER
Format Mask: 0.0

Salinity Downstream (ppt)

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

Water salinity downstream of the structure.

General Data Type: NUMBER
Format Mask: 0.0

TideGage

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

Name of closest tide gage station.

General Data Type: VARCHAR2

Tide_m

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

Tide height in meters - not corrected for local lags between tide gage and site.

General Data Type: NUMBER

Tide

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

Classification of tidal stage as ebbing or flooding.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 36220
GUID: gov.noaa.nmfs.inport:36220
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-01-06 11:02+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