noaa-fisheries-nwfsc-data-socrata/physical-and-biological-effects-of-fishfriendly-crke-3cvy

  • connectivity
  • habitat use
  • tide gates

Physical and Biological Effects of Fishfriendly Tide Gates

Physical and Biological Effects of Fishfriendly Tide Gates

InPort Dataset ID: 18066

InPort Entity ID: 36585

Summary of physical parameters and fish counts.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Cohocoho_countcoho_countNumberCoho salmon (Oncorhynchus kisutch) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Datedate_of_visitdate_of_visitCalendar dateThe date of the visit to that site.
T.SDstandard_deviation_water_tempstandard_deviation_water_tempNumberStandard deviation of water temperature as measured during a two week period that includes the sampling date.
Shadshad_countshad_countNumberAmerican shad (Alosa sapidissima) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Shrimpshrimp_countshrimp_countNumberShrimp counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Pumpkinpumpkin_countpumpkin_countNumberPumpkinseed (Lepomis gibbosus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Bullfrog Tadpolebullfrog_tadpole_countbullfrog_tadpole_countNumberBullfrog tadpole (Rana catesbeiana) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Staghorn Sculpinstaghorn_sculpin_countstaghorn_sculpin_countNumberStaghorn sculpin (Leptocottus armatus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Cutthroutcutthrout_countcutthrout_countNumberCutthrout trout (O. clarkia) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Post-Larval Smeltpost_larval_smelt_countpost_larval_smelt_countNumberSurf smelt (Hypomesus pretiosus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Herringherring_countherring_countNumberPacific herring (Clupea pallasii) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Sandlancesandlance_countsandlance_countNumberPacific sand lance (Ammodytes hexapterus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Larval Sandlancelarval_sandlance_countlarval_sandlance_countNumberPacific sand lance (Ammodytes hexapterus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Snake Pricklebacksnake_prickleback_countsnake_prickleback_countNumberSnake prickleback (Lumpenus sagitta) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Speckled Dacespeckled_dace_countspeckled_dace_countNumberspeckled dace (Rhinichthys osculus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Newtnewt_countnewt_countNumberRough-skin newt (Taricha granulosa) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
S.SDstandard_deviation_salinitystandard_deviation_salinityNumberStandard deviation of water salinity as measured during a two week period that includes the sampling date.
E.CVcoeff_of_variance_water_elevcoeff_of_variance_water_elevNumberCoefficient of variance of surface water elevation as measured during a two week period that includes the sampling date.
Visitvisit_numbervisit_numberNumberThe sequential visit number to that site.
Bluegillbluegill_countbluegill_countNumberBluegill (Lepomis gulosis) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Sticklebackstickleback_countstickleback_countNumberThree-spine stickleback (Gasterosteus aculeatus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
V.SDstandard_deviation_water_velstandard_deviation_water_velNumberStandard deviation of water velocity as measured during a two day period in June or July.
Locationlocation_of_samplelocation_of_sampleTextLocation of sample, with DS indicating downstream of structures and US indicating upstream of structures.
Sitesite_namesite_nameTextSite name used to link data in the data table to the site details table.
Largemouthlargemouth_countlargemouth_countNumberlargemouth bass (Micropterus salmoides) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
T.Aveaverage_water_temperatureaverage_water_temperatureNumberAverage water temperature as measured during a two week period that includes the sampling date.
PropDisproportion_time_disconnectedproportion_time_disconnectedNumberProportion 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).
Cancer Crabcancer_crab_countcancer_crab_countNumberCrab (Cancer spp.) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Smallmouthsmallmouth_countsmallmouth_countNumberSmallmouth bass (Micropterus dolmieui) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Prickly Sculpinprickly_sculpin_countprickly_sculpin_countNumberPrickly sculpin (Cottus asper) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Crayfishcrayfish_countcrayfish_countNumberCrayfish species counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Y Perchy_perch_county_perch_countNumberYellow perch (Perca flavescens) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Smeltsmelt_countsmelt_countNumberSurf smelt (Hypomesus pretiosus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Pickerelpickerel_countpickerel_countNumberGrass pickerel (Esox americanus vermiculatus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Peamouthpeamouth_countpeamouth_countNumberPeamouth chub (Mylocheilus caurinus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Crescent Gunnelcrescent_gunnel_countcrescent_gunnel_countNumberCrescent gunnel (Pholis laeta) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Whitefishwhitefish_countwhitefish_countNumbermountain whitefish (Prosopium williamsoni) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Suckersucker_countsucker_countNumberLargescale sucker (Catostomus macrocheilus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Starry Flounderstarry_flounder_countstarry_flounder_countNumberStarry flounder (Platichthys stellatus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Shinershiner_countshiner_countNumberShiner perch (Cymatogaster aggregate) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Unk Gadidunk_gadid_countunk_gadid_countNumberUnknown gadoid (Gadidae spp.) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
S.CVcoeff_of_variance_salinitycoeff_of_variance_salinityNumberCoefficient of variance of water salinity as measured during a two week period that includes the sampling date.
S.Aveaverage_water_salinityaverage_water_salinityNumberAverage water salinity as measured during a two week period that includes the sampling date.
T.CVcoefficient_of_variance_tempcoefficient_of_variance_tempNumberCoefficient of variance of water temperature as measured during a two week period that includes the sampling date.
V.Aveaverage_water_velocityaverage_water_velocityNumberAverage water velocity as measured during a two day period in June or July.
E.SDstandard_deviation_water_elevstandard_deviation_water_elevNumberStandard deviation of surface water elevation as measured during a two week period that includes the sampling date.
E.Aveaverage_water_elevationaverage_water_elevationNumberAverage surface water elevation as measured during a two week period that includes the sampling date.
Beach Seine Area M2area_of_beach_seine_setarea_of_beach_seine_setNumberArea of beach seine used to sample fish. This can be used to convert fish counts to density based on surface area.
V.DS.CVcoeff_of_variance_water_velcoeff_of_variance_water_velNumberCoefficient of variance of water velocity as measured during a two day period in June or July.
Rainbow Troutrainbow_trout_countrainbow_trout_countNumberRainbow trout/steelhead (O. mykiss) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Chumchum_countchum_countNumberChum salmon (O. keta) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.
Chinookchinook_countchinook_countNumberChinook salmon (O. tshawytscha) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present.

Upstream Metadata