36219
Physical and Biological Effects of Fish-friendly Tide Gates Site Details Data Logger Flow Data
Physical and Biological Effects of Fish-friendly Tide Gates Site Details Data Logger Flow Data
Entity
Published / External
18067
Data logger database - Physical and biological effects of fish-friendly tide gates
Data Set
Planned
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 Table
Yes
PARR
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.
1
ID1
NUMBER
22
No
No
Active
Record ID.
NUMBER
2
Site
VARCHAR2
255
No
No
Active
Site name (see Site Details table for more information).
VARCHAR2
@
3
Date
DATE
22
No
No
Active
Date of measurement.
DATE
m/d/yyyy
4
Time
DATE
22
No
No
Active
Time of measurement.
DATE
h:nn;@
5
Gate
VARCHAR2
255
No
No
Active
Gate position as determined from tilt sensors and flow data.
VARCHAR2
@
6
Direction
VARCHAR2
255
No
No
Active
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.
VARCHAR2
@
7
Depth
NUMBER
22
No
No
Active
Depth of water inside the structure in meters.
NUMBER
General Number
8
Velocity
NUMBER
22
No
No
Active
Velocity inside of structure in meters/second, with negative values indicating water flowing OUT of the structure.
NUMBER
General Number
9
Flow
NUMBER
22
No
No
Active
Estimated flow based on the water level inside the structure or channel, dimensions of the structure or channel, and measured velocity of water.
NUMBER
General Number
10
TideGage
VARCHAR2
255
No
No
Active
Nearest tide gage name.
VARCHAR2
@
11
RiverGage
VARCHAR2
255
No
No
Active
Nearest USGS river gage ID.
VARCHAR2
@
12
Tide_ft
NUMBER
22
No
No
Active
Tide height in ft at nearest tide gage - not corrected for time lag between gage and site.
NUMBER
General Number
13
River_ft
NUMBER
22
No
No
Active
River gage height in ft at nearest USGS gage - not corrected for time lag between gage and site.
NUMBER
General Number
gov.noaa.nmfs.inport:36219
Jeffrey Cowen
2017-01-06T11:02:01
SysAdmin InPortAdmin
2022-08-09T17:11:17
2018-02-27
Northwest Fisheries Science Center
NWFSC
2725 Montlake Boulevard East
Seattle
WA
98112
USA
206-860-3200
http://www.nwfsc.noaa.gov
1001
Public
No
2018-02-27
1 Year
2019-02-27