Physical and Biological Effects of Fish-friendly Tide Gates

Site name used to link data in the data table to the site details table.

The sequential visit number to that site.

The date of the visit to that site.

Location of sample, with DS indicating downstream of structures and US indicating upstream of structures.

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).

Average water temperature as measured during a two week period that includes the sampling date. Units for values are Celsius.

Standard deviation of water temperature as measured during a two week period that includes the sampling date. Units for values are Celsius.

Coefficient of variance of water temperature as measured during a two week period that includes the sampling date.

Average water salinity as measured during a two week period that includes the sampling date. Units for values are parts per thousand.

Standard deviation of water salinity as measured during a two week period that includes the sampling date. Units for values are parts per thousand.

Coefficient of variance of water salinity as measured during a two week period that includes the sampling date.

Average surface water elevation as measured during a two week period that includes the sampling date. Units for values are NAVD88 meters.

Standard deviation of surface water elevation as measured during a two week period that includes the sampling date. Units for values are NAVD88 meters.

Coefficient of variance of surface water elevation as measured during a two week period that includes the sampling date.

Average water velocity as measured during a two day period in June or July. Units for values are meters per second.

Standard deviation of water velocity as measured during a two day period in June or July. Units for values are meters per second.

Coefficient of variance of water velocity as measured during a two day period in June or July.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

Shrimp counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.