Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NWFSC Metadata Library > FE (Fish Ecology) Division > Data logger database - Physical and biological... >

Physical and Biological Effects of Fish-friendly Tide Gates Site Details Data Logger Sensor Data

Entity (ENT)  |  Northwest Fisheries Science Center (NWFSC)
GUID: gov.noaa.nmfs.inport:36220  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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.

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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
NUMBER 		Record ID.
Site
VARCHAR2 		Site name (see Site Details table for more information on each site).
Date
DATE 		Date of observation.
Time
DATE 		Time of observation.
DCE
NUMBER 		Id number of data collection event, with each site having been sampled three intervals during 2011.
Upstream Water Elevation (NAVD88 meters)
NUMBER 		Measured elevation of water immediately upstream of the structure in NAVD88.
Downstream Water Elevation (NAVD88 meters)
NUMBER 		Measured elevation of water immediately downstrem of the structure in NAVD88.
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.
Inside Depth (m)
NUMBER 		Water depth inside the structure.
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.
Gate
VARCHAR2 		Classification of the gate door position based on the tilt data.
Temperature Upstream (C)
NUMBER 		Water temperature upstream of the structure.
Salinity Upstream (ppt)
NUMBER 		Water salinity upstream of the structure.
Temperature Downstream (C)
NUMBER 		Water temperature downstream of the structure.
Salinity Downstream (ppt)
NUMBER 		Water salinity downstream of the structure.
TideGage
VARCHAR2 		Name of closest tide gage station.
Tide_m
NUMBER 		Tide height in meters - not corrected for local lags between tide gage and site.
Tide
VARCHAR2 		Classification of tidal stage as ebbing or flooding.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NWFSC) for inquiries on this record.

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: 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