36585 Physical and Biological Effects of Fish-friendly Tide Gates Entity Published / External 18066 Fish and logger summaries - Physical and biological effects of fish-friendly tide gates Data Set 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 gov.noaa.nmfs.inport:36585 Jeffrey Cowen 2017-01-31T18:06:00 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 https://www.nwfsc.noaa.gov 1001 Public No 2018-02-27 1 Year 2019-02-27