18066
Fish and logger summaries - Physical and biological effects of fish-friendly tide gates
Fish and logger summaries (Physical and biological effects of fish-friendly tide gates)
Data Set
Published / External
17697
FE (Fish Ecology) Division
Project
Completed
2011-03-01
2017-01-23
The purpose of this one-time stand-alone study is to evaluate how effective "fish-friendly" or self-regulating tide gates (SRTs) are at increasing connectivity for fish rearing in estuaries. The work was carried out in North Puget Sound, Washington Coast, and Columbia River estuaries by Correigh Greene, Jason Hall, and Eric Beamer (Skagit River System Cooperative), and compared SRTs with traditional flap gates and reference sites that were not blocked by any tide gate. Thus far, the study has produced a report for ESRP (Estuary Salmon Restoration Program), the organization that funded it. Up to two peer-reviewed papers are planned. The audience for this work includes federal and state managers, local planners, Watershed Councils, and applied ecologists.
Excel datasheets of fish and logger summaries.
Addresses Legal Mandate
Monitoring or sensor data
Loaded by batch 4322, 02-01-2013 17:58
Subject to Public Access to Research Results (PARR): Yes
Report: Biological and Physical Effects of Fish-Friendly Tide Gates.
Theme
connectivity
Theme
habitat use
Theme
tide gates
Spatial
Chehalis Estuary
Spatial
Samish Bay
Spatial
Skagit Estuary
Spatial
Swinomish Channel
Spatial
Young's Bay
Instrument
Sonde and Probe - Sonde and Probe (not specified)
Platform
Animal and Plant Collection Device
Northwest Fisheries Science Center
Seattle
WA
USA
Data Set
Spreadsheet
Table (digital)
Sonde and Probe - Sonde and Probe (not specified)
Platform Not Applicable
Animal and Plant Collection Device
36584
Physical and Biological Effects of Fish-friendly Tide Gates Site Details
Physical and Biological Effects of Fish-friendly Tide Gates Site Details
Published / External
Planned
Details of sites sampled.
Spreadsheet
Yes
PARR
Details of sites sampled.
1
System
VARCHAR2
No
No
Active
The system is the river or placename in which the site is located.
VARCHAR2
2
Site
VARCHAR2
No
No
Active
Site name used to link data in the data table to the site details table.
VARCHAR2
3
Type
VARCHAR2
No
No
Active
The type designates the type of the site, which includes reference channels with no structures, flap gates, side-hinged self regulating tidegates (SRT), and pet doors.
VARCHAR2
4
Culvert Type
VARCHAR2
No
No
Active
The cuvlert type designates whether a structure was a round culvert, square vault, or rectangular vault, or an open channel where no structures were present.
VARCHAR2
5
Northing
NUMBER
No
No
Active
Northing coordinates for the location of the site. Units for values are NAD_1983_UTM_Zone_10N meters.
NUMBER
NAD_1983_UTM_Zone_10N meters
6
Easting
NUMBER
No
No
Active
Easting coordinates for the location of the site. Units for values are NAD_1983_UTM_Zone_10N meters.
NUMBER
NAD_1983_UTM_Zone_10N meters
7
Diamter (m)
NUMBER
No
No
Active
Diameter of culverts for circular culverts. Units for values are meters.
NUMBER
meters
8
Width (m)
NUMBER
No
No
Active
Width of rectancular and square vaults. Units for values are meters.
NUMBER
meters
9
Height (m)
NUMBER
No
No
Active
Height of rectancular and square vaults. Units for values are meters.
NUMBER
meters
10
Downstream Perch Elevation (m) NAVD88
NUMBER
No
No
Active
Elevation of the floor of the culvert or vault on the upstream side of the structure. Units for values are NAVD88 meters.
NUMBER
NAVD88 meters
11
Upstream Perch Elevation (m) NAVD88
NUMBER
No
No
Active
Elevation of the floor of the culvert or vault on the downstream side of the structure. Units for values are NAVD88 meters.
NUMBER
NAVD88 meters
36585
Physical and Biological Effects of Fish-friendly Tide Gates
Physical and Biological Effects of Fish-friendly Tide Gates
Published / External
Planned
Summary of physical parameters and fish counts.
Spreadsheet
Yes
PARR
Summary of physical parameters and fish counts.
1
Site
VARCHAR2
No
No
Active
Site name used to link data in the data table to the site details table.
VARCHAR2
2
Visit
NUMBER
No
No
Active
The sequential visit number to that site.
NUMBER
3
Date
DATE
No
No
Active
The date of the visit to that site.
DATE
4
Location
VARCHAR2
No
No
Active
Location of sample, with DS indicating downstream of structures and US indicating upstream of structures.
VARCHAR2
5
PropDis
NUMBER
No
No
Active
Proportion of time upstream and downstream habitat are disconnected to fish passage based on the position of tide gates (open = connected, closed = disconnected); whether or not the upstream inlet is perched above the upstream water elevation (not perched = connected, perched = disconnected); water velocity (< 0.4 m/s = connected, > 0.4 m/s = disconnected); tidal stage (flooding = connected, ebbing = disconnected), and water depth (>10 cm = connected, <10 cm = disconnected).
NUMBER
6
T.Ave
NUMBER
No
No
Active
Average water temperature as measured during a two week period that includes the sampling date. Units for values are Celsius.
NUMBER
Celsius
7
T.SD
NUMBER
No
No
Active
Standard deviation of water temperature as measured during a two week period that includes the sampling date. Units for values are Celsius.
NUMBER
Celsius
8
T.CV
NUMBER
No
No
Active
Coefficient of variance of water temperature as measured during a two week period that includes the sampling date.
NUMBER
9
S.Ave
NUMBER
No
No
Active
Average water salinity as measured during a two week period that includes the sampling date. Units for values are parts per thousand.
NUMBER
parts per thousand
10
S.SD
NUMBER
No
No
Active
Standard deviation of water salinity as measured during a two week period that includes the sampling date. Units for values are parts per thousand.
NUMBER
parts per thousand
11
S.CV
NUMBER
No
No
Active
Coefficient of variance of water salinity as measured during a two week period that includes the sampling date.
NUMBER
12
E.Ave
NUMBER
No
No
Active
Average surface water elevation as measured during a two week period that includes the sampling date. Units for values are NAVD88 meters.
NUMBER
NAVD88 meters
13
E.SD
NUMBER
No
No
Active
Standard deviation of surface water elevation as measured during a two week period that includes the sampling date. Units for values are NAVD88 meters.
NUMBER
NAVD88 meters
14
E.CV
NUMBER
No
No
Active
Coefficient of variance of surface water elevation as measured during a two week period that includes the sampling date.
NUMBER
15
V.Ave
NUMBER
No
No
Active
Average water velocity as measured during a two day period in June or July. Units for values are meters per second.
NUMBER
meters per second
16
V.SD
NUMBER
No
No
Active
Standard deviation of water velocity as measured during a two day period in June or July. Units for values are meters per second.
NUMBER
meters per second
17
V.DS.CV
NUMBER
No
No
Active
Coefficient of variance of water velocity as measured during a two day period in June or July.
NUMBER
18
Beach Seine Area m2
NUMBER
No
No
Active
Area of beach seine used to sample fish. This can be used to convert fish counts to density based on surface area. Units for values are square meters.
NUMBER
square meters
19
stickleback
NUMBER
No
No
Active
Three-spine stickleback (Gasterosteus aculeatus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
20
coho
NUMBER
No
No
Active
Coho salmon (Oncorhynchus kisutch) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
21
chinook
NUMBER
No
No
Active
Chinook salmon (O. tshawytscha) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
22
chum
NUMBER
No
No
Active
Chum salmon (O. keta) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
23
rainbow trout
NUMBER
No
No
Active
Rainbow trout/steelhead (O. mykiss) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
24
cutthrout
NUMBER
No
No
Active
Cutthrout trout (O. clarkia) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
25
peamouth
NUMBER
No
No
Active
Peamouth chub (Mylocheilus caurinus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
26
staghorn sculpin
NUMBER
No
No
Active
Staghorn sculpin (Leptocottus armatus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
27
prickly sculpin
NUMBER
No
No
Active
Prickly sculpin (Cottus asper) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
28
sucker
NUMBER
No
No
Active
Largescale sucker (Catostomus macrocheilus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
29
whitefish
NUMBER
No
No
Active
mountain whitefish(Prosopium williamsoni) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
30
smelt
NUMBER
No
No
Active
Surf smelt (Hypomesus pretiosus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
31
post-larval smelt
NUMBER
No
No
Active
Surf smelt (Hypomesus pretiosus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
32
starry flounder
NUMBER
No
No
Active
Starry flounder (Platichthys stellatus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
33
larval sandlance
NUMBER
No
No
Active
Pacific sand lance (Ammodytes hexapterus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
34
sandlance
NUMBER
No
No
Active
Pacific sand lance (Ammodytes hexapterus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
35
herring
NUMBER
No
No
Active
Pacific herring (Clupea pallasii) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
36
shiner
NUMBER
No
No
Active
Shiner perch (Cymatogaster aggregate) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
37
snake prickleback
NUMBER
No
No
Active
Snake prickleback (Lumpenus sagitta) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
38
crescent gunnel
NUMBER
No
No
Active
Crescent gunnel (Pholis laeta) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
39
unk gadid
NUMBER
No
No
Active
Unknown gadoid (Gadidae spp.) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
40
cancer crab
NUMBER
No
No
Active
Crab (Cancer spp.) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
41
shrimp
NUMBER
No
No
Active
Shrimp counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
42
speckled dace
NUMBER
No
No
Active
speckled dace(Rhinichthys osculus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
43
shad
NUMBER
No
No
Active
American shad (Alosa sapidissima) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
44
smallmouth
NUMBER
No
No
Active
Smallmouth bass (Micropterus dolmieui) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
45
bluegill
NUMBER
No
No
Active
Bluegill (Lepomis gulosis) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
46
largemouth
NUMBER
No
No
Active
largemouthbass(Micropterus salmoides) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
47
pumpkin
NUMBER
No
No
Active
Pumpkinseed (Lepomis gibbosus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
48
pickerel
NUMBER
No
No
Active
Grass pickerel (Esox americanus vermiculatus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
49
Y perch
NUMBER
No
No
Active
Yellow perch (Perca flavescens) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
50
crayfish
NUMBER
No
No
Active
Crayfish species counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
51
bullfrog tadpole
NUMBER
No
No
Active
Bullfrog tadpole (Rana catesbeiana) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
52
newt
NUMBER
No
No
Active
Rough-skin newt (Taricha granulosa) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.
NUMBER
count
Data Steward
2015-10-01
Person
Greene, Correigh
Correigh.Greene@noaa.gov
2725 Montlake Boulevard East
Seattle
WA
98112
206-860-5611
Distributor
2015-10-01
Organization
Northwest Fisheries Science Center
NWFSC
nmfs.nwfsc.metadata@noaa.gov
2725 Montlake Boulevard East
Seattle
WA
98112
USA
206-860-3200
http://www.nwfsc.noaa.gov
NWFSC Home
Online Resource
Metadata Contact
2015-10-01
Organization
Northwest Fisheries Science Center
NWFSC
nmfs.nwfsc.metadata@noaa.gov
2725 Montlake Boulevard East
Seattle
WA
98112
USA
206-860-3200
http://www.nwfsc.noaa.gov
NWFSC Home
Online Resource
Originator
2015-10-01
Person
Hall, Jason E
Jason.Hall@noaa.gov
2725 Montlake Boulevard East
Seattle
WA
98112
206-302-1748
Point of Contact
2015-10-01
Person
Greene, Correigh
Correigh.Greene@noaa.gov
2725 Montlake Boulevard East
Seattle
WA
98112
206-860-5611
-123.8897
-123.8897
46.1642
46.1642
Young's Bay: Young's Bay worksite contains 1 reference, 1 SRT, and 1 Flap Gate site.
Range
2009-09-01
2012-01-31
-122.4197
-122.4197
48.597
48.597
Samish Bay: Samish Bay worksite contains 1 reference, 2 SRT, and 1 Flap Gate site.
Range
2009-09-01
2012-01-31
-123.8045
-123.8045
46.9711
46.9711
Chehalis Estuary: Chehalis Estuary worksite contains 1 reference, 3 SRT, and 1 Flap Gate site.
Range
2009-09-01
2012-01-31
-122.5025
-122.5025
48.4351
48.4351
Swinomish Channel: Swinomish Channel worksite contains 1 reference, 2 SRT, and 1 Flap Gate site.
Range
2009-09-01
2012-01-31
-122.3438
-122.3438
48.3238
48.3238
Skagit Estuary: Skagit Estuary worksite contains 1 reference, 1 SRT, and 1 Flap Gate site.
Range
2009-09-01
2012-01-31
Unclassified
At this time, contact the Data Manager for information on obtaining access to this data set. In the near future, the NWFSC will strive to provide all data resources as a web service in order to meet the NOAA Data Access Policy Directive (https://nosc.noaa.gov/EDMC/PD.DA.php).
NA
2017-01-23
https://www.webapps.nwfsc.noaa.gov/apex/parr/physical_and_biological_effects_of_fishfriendly_tide_gates/data/page/
2015-10-01
Organization
Northwest Fisheries Science Center
Physical and Biological Effects of Fish-friendly T
Summary of physical parameters and fish counts.
2017-01-23
https://www.webapps.nwfsc.noaa.gov/apex/parr/physical_and_biological_effects_of_fishfriendly_tide_gates_site_details/data/page/
2015-10-01
Organization
Northwest Fisheries Science Center
Physical and Biological Effects of Fish-friendly T
Details of sites sampled.
2017-01-23
https://www.webapps.nwfsc.noaa.gov/apex/parrdata/inventory/tables/table/physical_and_biological_effects_of_fishfriendly_tide_gates
2015-10-01
Organization
Northwest Fisheries Science Center
Physical and Biological Effects of Fish-friendly T
Summary of physical parameters and fish counts.
2017-01-23
https://www.webapps.nwfsc.noaa.gov/apex/parrdata/inventory/tables/table/physical_and_biological_effects_of_fishfriendly_tide_gates_site_details
2015-10-01
Organization
Northwest Fisheries Science Center
Physical and Biological Effects of Fish-friendly T
Details of sites sampled.
https://www.webapps.nwfsc.noaa.gov/apex/parrdata/inventory/datasets/dataset/6879
Fish and logger summaries
Online Resource
Web site
NWFSC Dataset Information page. Excel datasheets of fish and logger summaries
Spreadsheet
High
Examination of ranges for outliers. These data were collected and processed in accordance with established protocols and best practices under the direction of the project’s Principal Investigator. Contact the dataset Data Manager for full QA/QC methodology.
Yes
15
Yes
No
No
0 days
No Delay
NCEI-MD
365
The Northwest Fisheries Science Center facilitates backup and recovery of all data and IT components which are managed by IT Operations through the capture of static (point-in-time) backup data to physical media. Once data is captured to physical media (every 1-3 days), a duplicate is made and routinely (weekly) transported to an offsite archive facility where it is maintained throughout the data's applicable life-cycle.
Summaries by time and location
36585
Entity
Physical and Biological Effects of Fish-friendly Tide Gates
36584
Entity
Physical and Biological Effects of Fish-friendly Tide Gates Site Details
gov.noaa.nmfs.inport:18066
SysAdmin InPortAdmin
2013-02-01T17:58:53
SysAdmin InPortAdmin
2022-08-09T17:11:07
2019-06-04
Northwest Fisheries Science Center
NWFSC
2725 Montlake Boulevard East
Seattle
WA
98112
USA
206-860-3200
http://www.nwfsc.noaa.gov
1001
Public
No
2019-06-04
1 Year
2020-06-04