Metadata Rubric

100%

6 / 6

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

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

	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.

Name

Type

Description

100

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