# Stream Consumers and Lotic Ecosystem Rates (SCALER) in streams of the HJ Andrews Experimental Forest, 2014-2016 ## Dataset - **Database Code:** AN008 - **Title:** Stream Consumers and Lotic Ecosystem Rates (SCALER) in streams of the HJ Andrews Experimental Forest, 2014-2016 - **Abstract:** SCALER attempts to address the question of whether small-scale ecological experiments can be applied to understand the behavior of entire ecological systems. Specifically, the role of comsumers to stream functional processes were examined by measurements of structure and function within stream reaches. These results feed into a broader continent wide examination within a variety of ecological systems. Rates of stream metabolism (photosynthesis and respiration) and nutrient uptake were measured, as well as the way these rates respond to animal exclusions (used to mimic loss of animal diversity in streams). Aquatic food web and biogeochemical responses in three consecutive 75m stream reaches were measured by manipulating densities of fish and amphibians (natural, depletion, and addition). Additionally, various stream characteristics were measured including streamflow, water chemistry, nutrients, metabolism, stream habitat measurements (wetted widths, depths and substrate), and canopy conditions (percent shade). The experiment was carried out every summer between 2014-2016 in streams of the HJ Andrews Experimental Forest to capture interannual variability. - **Keywords:** stream ecology; biomass; species abundance; respiration; metabolism; primary production; nutrients; streams; invertebrates; amphibians; fishes; primary production - **Temporal coverage:** 2014-08-14 to 2016-08-17 - **Principal Investigator:** Brooke E. Penaluna ## Data Entities 1. AN00801 2. AN00802 3. AN00803 4. AN00804 5. AN00805 6. AN00806 7. AN00807 8. AN00808 ## Entity 1: AN00801 ### Attribute list - **DBCODE** — varchar, enum FSDB Database Code - **AN008** — FSDB Database Study Code - **ENTITY** — numeric(1), range 1.0000 1.0000, number Entity number - **SAMPLE_TYPE** — varchar, enum Spaitial scale of sampling - **REACH** — Sampling conducted at reach scale, typically 50 to 65m stretch - **PATCH** — Sampling conducted at patch scale in plots or chamber units within reach - **YEAR** — numeric(1), range 2014.0000 2016.0000, year (yyyy) Year sample collected - **SITE_NUMBER** — varchar, enum ID number assigned to site - **SCALER_1** — SCALER sample site 1 on McRae Creek - **SCALER_2** — SCALER sample site 2, on McRae Creek at the STREON site - **SCALER_3** — SCALER sample site 3 on Lookout Creek - **REACH_TREATMENT** — varchar, enum Reach treatment - **C** — Control reach (consumers ambient) - **D** — Treatment/deletion reach (consumers removed) - **A** — Addition reach (consumers added) - **SAMPLE_REPLICATE** — numeric(1), range 1.0000 7.0000, number Sample replicate number - **SAMPLE_TIMING** — varchar, enum Type of sample timing collection during season - **START** — Beginning of season first sampling - **END** — End of season second and final sampling - **SAMPLING_DATE** — datetime, freetext Date of sample collection - **EPILITHON_BIOMASS** — numeric(1), range 0.8800 52.0800, grams per square meter Biomass (AFDM) concentration - **CHL_A** — numeric(1), range 0.9500 35.4800, milligrams per square meter Chlorophyll a concentration corrected following Parker et al. (2016) - **NOTES** — varchar, freetext Notes taken during sample collection and analysis ## Entity 2: AN00802 ### Attribute list - **DBCODE** — varchar, enum FSDB Database Code - **AN008** — FSDB Database Study Code - **ENTITY** — numeric(1), range 2.0000 2.0000, number Entity number - **YEAR** — numeric(1), range 2014.0000 2016.0000, year (yyyy) Year sample collected - **SITE_NUMBER** — varchar, enum ID number assigned to site - **SCALER_1** — SCALER sample site 1 on McRae Creek - **SCALER_2** — SCALER sample site 2, on McRae Creek at the STREON site - **SCALER_3** — SCALER sample site 3 on Lookout Creek - **REACH_TREATMENT** — varchar, enum Reach treatment - **C** — Control reach (consumers ambient) - **D** — Treatment/deletion reach (consumers removed) - **A** — Addition reach (consumers added) - **SAMPLING_DATE** — datetime, freetext Date of sample collection - **DAY_OF_EXPERIMENT** — numeric(1), range 1.0000 50.0000, number Day of experiment (Number since start) - **PASS** — numeric(1), range 1.0000 11.0000, number Pass through reach when collected (multiple passes made during collection) - **DIRECTION** — varchar, enum Direction headed while sampling (upstream or downstream) - **U** — Direction of pass through stream to collect consumers is upstream - **D** — Direction of pass through stream to collect consumers is downstream - **SPECIES** — varchar, enum Consumer species code - **PS** — Cottus beldingi - **CT** — Oncorhyncus clarkii clarkii - **TR** — Oncorhyncus mykiss - **LD** — Rhinichthys cataractae - **TF** — Ascaphus truei - **GS** — Dicamptodon tenebrosus - **DU** — Plethodon dunni - **RF** — Rana aurora - **CF** — Rana cascadae - **RSN** — Taricha granulosa - **VERT_INDEX** — numeric(1), range 1.0000 172.0000, number unique index of site, reach, date, pass, direction, species sampled - **LENGTH2_AMPHIBS** — numeric(1), range 1.0000 200.0000, millimeters VL; vent length, amphibs only - **LENGTH** — numeric(1), range 1.0000 300.0000, millimeters Length of consumer - **WEIGHT** — numeric(1), range 0.1000 200.0000, grams Weight of consumer - **FROG_DEV_STAGE** — varchar, enum Stage of frog development - **NA** — Not applicable, data either misssing or does not apply to species - **A** — Adult - **FHL** — Full front and hind legs, tail remaining - **HL** — Hind legs fully developed, front legs undeveloped - **NL** — No legs, tadpole stage - **SHL** — Stubby hind legs, front legs undeveloped - **SFL** — Stubby front legs, hind legs developed - **NOTES** — varchar, freetext Notes taken during sample collection and analysis - **QA_NOTES** — varchar, freetext Note recorded during QA/QC ## Entity 3: AN00803 ### Attribute list - **DBCODE** — varchar, enum FSDB Database Code - **AN008** — FSDB Database Study Code - **ENTITY** — numeric(1), range 3.0000 3.0000, number Entity number - **YEAR** — numeric(1), range 2014.0000 2016.0000, year (yyyy) Year sample collected - **SITE_NUMBER** — varchar, enum ID number assigned to site - **SCALER_1** — SCALER sample site 1 on McRae Creek - **SCALER_2** — SCALER sample site 2, on McRae Creek at the STREON site - **SCALER_3** — SCALER sample site 3 on Lookout Creek - **REACH_TREATMENT** — varchar, enum Reach treatment - **C** — Control reach (consumers ambient) - **D** — Treatment/deletion reach (consumers removed) - **A** — Addition reach (consumers added) - **SAMPLING_DATE** — datetime, freetext Date of sample collection - **SAMPLE_TIMING** — varchar, enum Type of sample timing collection during season - **START** — Beginning of season first sampling - **END** — End of season second and final sampling - **UTN** — numeric(1), range 0.0010 1.0000, milligrams per liter Total unfiltered nitrogen (N) concentration - **NH4_N** — numeric(1), range 0.0010 1.0000, milligrams per liter Ammonium (NH4-N) concentration - **NO3_N** — numeric(1), range 0.0010 1.0000, milligrams per liter Nitrate (NO3-N) concentration - **UTP** — numeric(1), range 0.0010 1.0000, milligrams per liter Total unfiltered phosphorous (P) concentration - **PO4_P** — numeric(1), range 0.0010 1.0000, milligrams per liter Orthophosphate (PO4-P) concentration - **DOC** — numeric(1), range 0.0010 1.0000, milligrams per liter Dissolved Organic Carbon (mg C/L) concentration ## Entity 4: AN00804 ### Attribute list - **DBCODE** — varchar, enum FSDB Database Code - **AN008** — FSDB Database Study Code - **ENTITY** — numeric(1), range 4.0000 4.0000, number Entity number - **YEAR** — numeric(1), range 2014.0000 2016.0000, year (yyyy) Year sample collected - **SITE_NUMBER** — varchar, enum ID number assigned to site - **SCALER_1** — SCALER sample site 1 on McRae Creek - **SCALER_2** — SCALER sample site 2, on McRae Creek at the STREON site - **SCALER_3** — SCALER sample site 3 on Lookout Creek - **REACH_TREATMENT** — varchar, enum Reach treatment - **C** — Control reach (consumers ambient) - **D** — Treatment/deletion reach (consumers removed) - **A** — Addition reach (consumers added) - **SAMPLING_DATE** — datetime, freetext Date of sample collection - **SAMPLE_TIMING** — varchar, enum Type of sample timing collection during season - **START** — Beginning of season first sampling - **END** — End of season second and final sampling - **TRANSECT_M** — varchar, enum Number of meters from bottom of reach where measurements were taken - **** — Most upstream transect in study reach - **5** — Second transect, 5 meters downstream from transect 0 - **10** — Third transect, 10 m downstream of transect 0 - **15** — Fourth transect, 15 m downstream of transect 0 - **20** — Fifth transect, 20 m downstream of transect 0 - **25** — Sixth transect, 25 m downstream of transect 0 - **30** — Seventh transect, 30 m downstream of transect 0 - **35** — Eighth transect, 35 m downstream of transect 0 - **40** — Ninth transect, 40 m downstream of transect 0 - **45** — Tenth transect, 45 m downstream of transect 0 - **50** — Eleventh transect, 50 m downstream of transect 0 - **55** — Twelfth transect, 55 m downstream of transect 0 - **60** — Thirteenth transect, 60 m downstream of transect 0 - **65** — Fourteenth transect, 65 m downstream of transect 0 - **70** — Fifteenth transect, 70 m downstream of transect 0 - **75** — Sixteenth transect, 75 m downstream of transect 0 - **AVERAGE_WIDTH_M** — numeric(1), range 1.8000 11.0000, meters Wetted width measured at cross section of reach ## Entity 5: AN00805 ### Attribute list - **DBCODE** — varchar, enum FSDB Database Code - **AN008** — FSDB Database Study Code - **ENTITY** — numeric(1), range 5.0000 5.0000, number Entity number - **YEAR** — numeric(1), range 2014.0000 2016.0000, year (yyyy) Year sample collected - **SITE_NUMBER** — varchar, enum ID number assigned to site - **SCALER_1** — SCALER sample site 1 on McRae Creek - **SCALER_2** — SCALER sample site 2, on McRae Creek at the STREON site - **SCALER_3** — SCALER sample site 3 on Lookout Creek - **REACH_TREATMENT** — varchar, enum Reach treatment - **C** — Control reach (consumers ambient) - **D** — Treatment/deletion reach (consumers removed) - **A** — Addition reach (consumers added) - **SAMPLING_DATE** — datetime, freetext Date of sample collection - **TRANSECT_M** — varchar, enum Number of meters from bottom of reach where measurements were taken - **** — Most upstream transect in study reach - **5** — Second transect, 5 meters downstream from transect 0 - **10** — Third transect, 10 m downstream of transect 0 - **15** — Fourth transect, 15 m downstream of transect 0 - **20** — Fifth transect, 20 m downstream of transect 0 - **25** — Sixth transect, 25 m downstream of transect 0 - **30** — Seventh transect, 30 m downstream of transect 0 - **35** — Eighth transect, 35 m downstream of transect 0 - **40** — Ninth transect, 40 m downstream of transect 0 - **45** — Tenth transect, 45 m downstream of transect 0 - **50** — Eleventh transect, 50 m downstream of transect 0 - **55** — Twelfth transect, 55 m downstream of transect 0 - **60** — Thirteenth transect, 60 m downstream of transect 0 - **65** — Fourteenth transect, 65 m downstream of transect 0 - **70** — Fifteenth transect, 70 m downstream of transect 0 - **75** — Sixteenth transect, 75 m downstream of transect 0 - **SAMPLE_PT** — numeric(1), range 1.0000 56.0000, number Sampling point across the transect - **SUBSTRATE_MM** — numeric(1), range 0.1000 2000.0000, millimeters Width of substrate - **DEPTH_CM** — numeric(1), range 0.0000 1000.0000, centimeters Depth of stream at cross section - **NOTES** — varchar, freetext Notes taken during sample collection and analysis ## Entity 6: AN00806 ### Attribute list - **DBCODE** — varchar, enum FSDB Database Code - **AN008** — FSDB Database Study Code - **ENTITY** — numeric(1), range 6.0000 6.0000, number Entity number - **YEAR** — numeric(1), range 2014.0000 2016.0000, year (yyyy) Year sample collected - **SITE_NUMBER** — varchar, enum ID number assigned to site - **SCALER_1** — SCALER sample site 1 on McRae Creek - **SCALER_2** — SCALER sample site 2, on McRae Creek at the STREON site - **SCALER_3** — SCALER sample site 3 on Lookout Creek - **REACH_TREATMENT** — varchar, enum Reach treatment - **C** — Control reach (consumers ambient) - **D** — Treatment/deletion reach (consumers removed) - **A** — Addition reach (consumers added) - **SAMPLING_DATE** — datetime, freetext Date of sample collection - **TRANSECT_M** — varchar, enum Number of meters from bottom of reach where measurements were taken - **** — Most upstream transect in study reach - **5** — Second transect, 5 meters downstream from transect 0 - **10** — Third transect, 10 m downstream of transect 0 - **15** — Fourth transect, 15 m downstream of transect 0 - **20** — Fifth transect, 20 m downstream of transect 0 - **25** — Sixth transect, 25 m downstream of transect 0 - **30** — Seventh transect, 30 m downstream of transect 0 - **35** — Eighth transect, 35 m downstream of transect 0 - **40** — Ninth transect, 40 m downstream of transect 0 - **45** — Tenth transect, 45 m downstream of transect 0 - **50** — Eleventh transect, 50 m downstream of transect 0 - **55** — Twelfth transect, 55 m downstream of transect 0 - **60** — Thirteenth transect, 60 m downstream of transect 0 - **65** — Fourteenth transect, 65 m downstream of transect 0 - **70** — Fifteenth transect, 70 m downstream of transect 0 - **75** — Sixteenth transect, 75 m downstream of transect 0 - **UP_PERCENT_UNSHADED** — numeric(1), range 0.0000 100.0000, percent Percent of unshaded canopy looking upstream - **LEFT_PERCENT_UNSHADED** — numeric(1), range 0.0000 100.0000, percent Percent of unshaded canopy looking to left bank - **DOWN_PERCENT_UNSHADED** — numeric(1), range 0.0000 100.0000, percent Percent of unshaded canopy looking to right bank - **RIGHT_PERCENT_UNSHADED** — numeric(1), range 0.0000 100.0000, percent Percent of unshaded canopy looking downstream ## Entity 7: AN00807 ### Attribute list - **DBCODE** — varchar, enum FSDB Database Code - **AN008** — FSDB Database Study Code - **ENTITY** — numeric(1), range 7.0000 7.0000, number Entity number - **YEAR** — numeric(1), range 2014.0000 2016.0000, year (yyyy) Year sample collected - **SITE_NUMBER** — varchar, enum ID number assigned to site - **SCALER_1** — SCALER sample site 1 on McRae Creek - **SCALER_2** — SCALER sample site 2, on McRae Creek at the STREON site - **SCALER_3** — SCALER sample site 3 on Lookout Creek - **REACH_TREATMENT** — varchar, enum Reach treatment - **C** — Control reach (consumers ambient) - **D** — Treatment/deletion reach (consumers removed) - **A** — Addition reach (consumers added) - **SAMPLING_DATE** — datetime, freetext Date of sample collection - **SAMPLE_TIMING** — varchar, enum Type of sample timing collection during season - **START** — Beginning of season first sampling - **END** — End of season second and final sampling - **SAMPLE_REPLICATE** — numeric(1), range 1.0000 7.0000, number Sample replicate number - **FBOM_AFDM** — numeric(1), range 1.0000 400.0000, grams per square meter Concentration of Fine Benthic Organic Matter (Ash Free Dry Mass) - **NOTES** — varchar, freetext Notes taken during sample collection and analysis ## Entity 8: AN00808 ### Attribute list - **DBCODE** — varchar, enum FSDB Database Code - **AN008** — FSDB Database Study Code - **ENTITY** — numeric(1), range 8.0000 8.0000, number Entity number - **YEAR** — numeric(1), range 2014.0000 2016.0000, year (yyyy) Year sample collected - **SITE_NUMBER** — varchar, enum ID number assigned to site - **SCALER_1** — SCALER sample site 1 on McRae Creek - **SCALER_2** — SCALER sample site 2, on McRae Creek at the STREON site - **SCALER_3** — SCALER sample site 3 on Lookout Creek - **REACH_TREATMENT** — varchar, enum Reach treatment - **C** — Control reach (consumers ambient) - **D** — Treatment/deletion reach (consumers removed) - **A** — Addition reach (consumers added) - **SAMPLE_LOCATION** — varchar, enum Location sampled in reach - **BOTTOM** — Bottom or downstream ending point of sampling - **TOP** — Top or upstream starting point of sampling - **SAMPLE_TIMING** — varchar, enum Type of sample timing collection during season - **START** — Beginning of season first sampling - **END** — End of season second and final sampling - **TIMESTAMP** — datetime, freetext Date and time of sample collection (5 min samples) - **SAMPLE_ID** — numeric(1), range 1.0000 52476.0000, number Unique ID number assigned to sample - **TEMPERATURE** — numeric(1), range 8.1800 17.6600, degrees Celsius Temperature - **PERCENT_DO** — numeric(1), range 80.0000 100.1000, percent Percentage of dissolved oxygen - **DO_MG_L** — numeric(1), range 8.0000 10.5000, milligrams per liter Concentration of dissolved oxygen - **EC_US_CM** — numeric(1), range 34.0000 2038.0000, micro siemens per centimeter Electrical conductivity ## Attribute Definitions **AVERAGE_WIDTH_M** Wetted width measured at cross section of reach **CHL_A** Chlorophyll a concentration corrected following Parker et al. (2016) **DAY_OF_EXPERIMENT** Day of experiment (Number since start) **DBCODE** FSDB Database Code **DEPTH_CM** Depth of stream at cross section **DIRECTION** Direction headed while sampling (upstream or downstream) **DOC** Dissolved Organic Carbon (mg C/L) concentration **DOWN_PERCENT_UNSHADED** Percent of unshaded canopy looking to right bank **DO_MG_L** Concentration of dissolved oxygen **EC_US_CM** Electrical conductivity **ENTITY** Entity number **EPILITHON_BIOMASS** Biomass (AFDM) concentration **FBOM_AFDM** Concentration of Fine Benthic Organic Matter (Ash Free Dry Mass) **FROG_DEV_STAGE** Stage of frog development **LEFT_PERCENT_UNSHADED** Percent of unshaded canopy looking to left bank **LENGTH** Length of consumer **LENGTH2_AMPHIBS** VL; vent length, amphibs only **NH4_N** Ammonium (NH4-N) concentration **NO3_N** Nitrate (NO3-N) concentration **NOTES** Notes taken during sample collection and analysis **PASS** Pass through reach when collected (multiple passes made during collection) **PERCENT_DO** Percentage of dissolved oxygen **PO4_P** Orthophosphate (PO4-P) concentration **QA_NOTES** Note recorded during QA/QC **REACH_TREATMENT** Reach treatment **RIGHT_PERCENT_UNSHADED** Percent of unshaded canopy looking downstream **SAMPLE_ID** Unique ID number assigned to sample **SAMPLE_LOCATION** Location sampled in reach **SAMPLE_PT** Sampling point across the transect **SAMPLE_REPLICATE** Sample replicate number **SAMPLE_TIMING** Type of sample timing collection during season **SAMPLE_TYPE** Spaitial scale of sampling **SAMPLING_DATE** Date of sample collection **SITE_NUMBER** ID number assigned to site **SPECIES** Consumer species code **SUBSTRATE_MM** Width of substrate **TEMPERATURE** Temperature **TIMESTAMP** Date and time of sample collection (5 min samples) **TRANSECT_M** Number of meters from bottom of reach where measurements were taken **UP_PERCENT_UNSHADED** Percent of unshaded canopy looking upstream **UTN** Total unfiltered nitrogen (N) concentration **UTP** Total unfiltered phosphorous (P) concentration **VERT_INDEX** unique index of site, reach, date, pass, direction, species sampled **WEIGHT** Weight of consumer **YEAR** Year sample collected ## Enumerated Domains ### DBCODE - **AN008** — FSDB Database Study Code ### SAMPLE_TYPE - **REACH** — Sampling conducted at reach scale, typically 50 to 65m stretch - **PATCH** — Sampling conducted at patch scale in plots or chamber units within reach ### SITE_NUMBER - **SCALER_1** — SCALER sample site 1 on McRae Creek - **SCALER_2** — SCALER sample site 2, on McRae Creek at the STREON site - **SCALER_3** — SCALER sample site 3 on Lookout Creek ### REACH_TREATMENT - **C** — Control reach (consumers ambient) - **D** — Treatment/deletion reach (consumers removed) - **A** — Addition reach (consumers added) ### SAMPLE_TIMING - **START** — Beginning of season first sampling - **END** — End of season second and final sampling ### DIRECTION - **U** — Direction of pass through stream to collect consumers is upstream - **D** — Direction of pass through stream to collect consumers is downstream ### SPECIES - **PS** — Cottus beldingi - **CT** — Oncorhyncus clarkii clarkii - **TR** — Oncorhyncus mykiss - **LD** — Rhinichthys cataractae - **TF** — Ascaphus truei - **GS** — Dicamptodon tenebrosus - **DU** — Plethodon dunni - **RF** — Rana aurora - **CF** — Rana cascadae - **RSN** — Taricha granulosa ### FROG_DEV_STAGE - **NA** — Not applicable, data either misssing or does not apply to species - **A** — Adult - **FHL** — Full front and hind legs, tail remaining - **HL** — Hind legs fully developed, front legs undeveloped - **NL** — No legs, tadpole stage - **SHL** — Stubby hind legs, front legs undeveloped - **SFL** — Stubby front legs, hind legs developed ### TRANSECT_M - **** — Most upstream transect in study reach - **5** — Second transect, 5 meters downstream from transect 0 - **10** — Third transect, 10 m downstream of transect 0 - **15** — Fourth transect, 15 m downstream of transect 0 - **20** — Fifth transect, 20 m downstream of transect 0 - **25** — Sixth transect, 25 m downstream of transect 0 - **30** — Seventh transect, 30 m downstream of transect 0 - **35** — Eighth transect, 35 m downstream of transect 0 - **40** — Ninth transect, 40 m downstream of transect 0 - **45** — Tenth transect, 45 m downstream of transect 0 - **50** — Eleventh transect, 50 m downstream of transect 0 - **55** — Twelfth transect, 55 m downstream of transect 0 - **60** — Thirteenth transect, 60 m downstream of transect 0 - **65** — Fourteenth transect, 65 m downstream of transect 0 - **70** — Fifteenth transect, 70 m downstream of transect 0 - **75** — Sixteenth transect, 75 m downstream of transect 0 ### SAMPLE_LOCATION - **BOTTOM** — Bottom or downstream ending point of sampling - **TOP** — Top or upstream starting point of sampling