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 Flow Data

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

Summary

Abstract

Water velocity measurements at each site. HACH Ultrasonic Submerged Area Velocity Meters (Sigma 950) were deployed approximately 24-hours at each site. Sensors were 7 cm above the ground in the middle of the culvert, vault, or channel floor.

Description

Water velocity measurements at each site. HACH Ultrasonic Submerged Area Velocity Meters (Sigma 950) were deployed approximately 24-hours at each site. Sensors were 7 cm above the ground in the middle of the culvert, vault, or channel floor.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID1
NUMBER 		Record ID.
Site
VARCHAR2 		Site name (see Site Details table for more information).
Date
DATE 		Date of measurement.
Time
DATE 		Time of measurement.
Gate
VARCHAR2 		Gate position as determined from tilt sensors and flow data.
Direction
VARCHAR2 		Direction of flow relative to the structure, with IN indicating water is flowing upstream, OUT indicating water is flowing downstream, and SLACK indicating that water is not moving in any detectable direction.
Depth
NUMBER 		Depth of water inside the structure in meters.
Velocity
NUMBER 		Velocity inside of structure in meters/second, with negative values indicating water flowing OUT of the structure.
Flow
NUMBER 		Estimated flow based on the water level inside the structure or channel, dimensions of the structure or channel, and measured velocity of water.
TideGage
VARCHAR2 		Nearest tide gage name.
RiverGage
VARCHAR2 		Nearest USGS river gage ID.
Tide_ft
NUMBER 		Tide height in ft at nearest tide gage - not corrected for time lag between gage and site.
River_ft
NUMBER 		River gage height in ft at nearest USGS gage - not corrected for time lag between gage and site.

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 Flow Data
Short Name: Physical and Biological Effects of Fish-friendly Tide Gates Site Details Data Logger Flow Data
Status: Planned
Abstract:

Water velocity measurements at each site. HACH Ultrasonic Submerged Area Velocity Meters (Sigma 950) were deployed approximately 24-hours at each site. Sensors were 7 cm above the ground in the middle of the culvert, vault, or channel floor.

Entity Information

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

Water velocity measurements at each site. HACH Ultrasonic Submerged Area Velocity Meters (Sigma 950) were deployed approximately 24-hours at each site. Sensors were 7 cm above the ground in the middle of the culvert, vault, or channel floor.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ID1 NUMBER Record ID.
100
 Site VARCHAR2 Site name (see Site Details table for more information).
100
 Date DATE Date of measurement.
100
 Time DATE Time of measurement.
100
 Gate VARCHAR2 Gate position as determined from tilt sensors and flow data.
100
 Direction VARCHAR2 Direction of flow relative to the structure, with IN indicating water is flowing upstream, OUT indicating water is flowing downstream, and SLACK indicating that water is not moving in any detectable direction.
100
 Depth NUMBER Depth of water inside the structure in meters.
100
 Velocity NUMBER Velocity inside of structure in meters/second, with negative values indicating water flowing OUT of the structure.
100
 Flow NUMBER Estimated flow based on the water level inside the structure or channel, dimensions of the structure or channel, and measured velocity of water.
100
 TideGage VARCHAR2 Nearest tide gage name.
100
 RiverGage VARCHAR2 Nearest USGS river gage ID.
100
 Tide_ft NUMBER Tide height in ft at nearest tide gage - not corrected for time lag between gage and site.
100
 River_ft NUMBER River gage height in ft at nearest USGS gage - not corrected for time lag between gage and site.

Attribute Details

ID1

CC ID: 733149
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: 733150
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).
General Data Type: VARCHAR2
Format Mask: @

Date

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

Date of measurement.
General Data Type: DATE
Format Mask: m/d/yyyy

Time

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

Time of measurement.
General Data Type: DATE
Format Mask: h:nn;@

Gate

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

Gate position as determined from tilt sensors and flow data.
General Data Type: VARCHAR2
Format Mask: @

Direction

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

Direction of flow relative to the structure, with IN indicating water is flowing upstream, OUT indicating water is flowing downstream, and SLACK indicating that water is not moving in any detectable direction.
General Data Type: VARCHAR2
Format Mask: @

Depth

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

Depth of water inside the structure in meters.
General Data Type: NUMBER
Format Mask: General Number

Velocity

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

Velocity inside of structure in meters/second, with negative values indicating water flowing OUT of the structure.
General Data Type: NUMBER
Format Mask: General Number

Flow

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

Estimated flow based on the water level inside the structure or channel, dimensions of the structure or channel, and measured velocity of water.
General Data Type: NUMBER
Format Mask: General Number

TideGage

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

Nearest tide gage name.
General Data Type: VARCHAR2
Format Mask: @

RiverGage

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

Nearest USGS river gage ID.
General Data Type: VARCHAR2
Format Mask: @

Tide_ft

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

Tide height in ft at nearest tide gage - not corrected for time lag between gage and site.
General Data Type: NUMBER
Format Mask: General Number

River_ft

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

River gage height in ft at nearest USGS gage - not corrected for time lag between gage and site.
General Data Type: NUMBER
Format Mask: General Number

Catalog Details

Catalog Item ID: 36219
GUID: gov.noaa.nmfs.inport:36219
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