Slide Menu
Search Help Show/Hide Menu

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