# Solute dynamics in the hyporheic mesocosm in Watershed 1 at the H.J. Andrews Experimental Forest, 2019-2020 ## Dataset - **Database Code:** CF020 - **Title:** Solute dynamics in the hyporheic mesocosm in Watershed 1 at the H.J. Andrews Experimental Forest, 2019-2020 - **Abstract:** We investigated biogeochemistry along a 12-m hyporheic mesocosm that allowed for controlled testing of seasonal and spatial water quality changes along a flowpath with fixed geometry and constant flow rate. Water quality profiles of oxygen, carbon, and nitrogen were measured at 1-m intervals along the mesocosm over multiple seasons. dissolved oxygen (DO) and temperature profiles were monitored on 18 dates between May 2019 through August 2020. Grab samples to monitor profiles of carbon, nitrogen, and various other solutes along the mesocosm were collected in December 2019 and August 2020 to provide more comprehensive biogeochemical analyses at time points when the dissolved oxygen (DO) and temperature profiles were at or near the maximum seasonal differences. Mesocosm monitoring ceased abruptly due to the Holiday Farm Fire, which burned from September through October 2020, cutting off personnel access and electrical power to the mesocosm facility. - **Keywords:** hydrology; biogeochemistry; hyporheic - **Temporal coverage:** 2019-05-31 to 2020-08-18 - **Principal Investigator:** Steven M. Wondzell Adam S. Ward ## Data Entities 1. Dissolved oxygen profile along the mesocosm 2. Full Analyte Profile ## Entity 1: Dissolved oxygen profile along the mesocosm ### Attribute list - **DBCODE** — varchar, enum FSDB Database Code - **CF020** — FSDB Database Study Code - **ENTITY** — numeric(1), range 1.0000 1.0000, number Entity number - **SITECODE** — varchar, enum Code for where the experiment was conducted - **WS1HMF** — WS1 hyporheic mesocosm facility located at WS1 gage house - **SAMPLE_DATE** — datetime, freetext date of sample collection - **SAMPLE_TIME** — varchar, freetext time of sample collection - **SAMPLE_ID** — varchar, freetext Unique identifier for every sample (a concatenation of sample run and position) - **SAMPLE_RUN** — numeric(1), range 1.0000 18.0000, number Unique run number for the mesocosm experiment (based on sample date) - **SAMPLE_POSITION** — varchar, enum Unique sample position measured during run at specifc date, time, and distance - **STB** — Stream sample before mesocosm run starts - **S00** — Mesocosm sample at meter 0 - **S01** — Mesocosm sample at meter 1 - **S02** — Mesocosm sample at meter 2 - **S03** — Mesocosm sample at meter 3 - **S04** — Mesocosm sample at meter 4 - **S05** — Mesocosm sample at meter 5 - **S06** — Mesocosm sample at meter 6 - **S07** — Mesocosm sample at meter 7 - **S08** — Mesocosm sample at meter 8 - **S09** — Mesocosm sample at meter 9 - **S10** — Mesocosm sample at meter 10 - **S11** — Mesocosm sample at meter 11 - **S12** — Mesocosm sample at meter 12 - **STA** — Stream sample after mesocosm run conclusion - **DISTANCE** — numeric(1), range 0.0000 12.0000, meters distance along the mescocosm - **DO** — numeric(1), range 0.1200 13.1600, milligrams per liter Dissolved oxygen concentration in water at time of collection - **TEMPERATURE** — numeric(1), range 2.7000 21.1000, degrees Celsius Temperature of water at time of collection - **TRAVELTIME** — numeric(1), range 4.5500 54.5500, number of hours Median residence travel time in hyporheic mesocosm ## Entity 2: Full Analyte Profile ### Attribute list - **DBCODE** — varchar, enum FSDB Database Code - **CF020** — FSDB Database Study Code - **ENTITY** — numeric(1), range 2.0000 2.0000, number Entity number - **SITECODE** — varchar, enum Code for where the experiment was conducted - **WS1HMF** — WS1 hyporheic mesocosm facility located at WS1 gage house - **SAMPLE_DATE** — datetime, freetext date of sample collection - **SAMPLE_ID** — varchar, freetext Unique identifier for every sample (a concatenation of sample run and position) - **SAMPLE_RUN** — numeric(1), range 1.0000 18.0000, number Unique run number for the mesocosm experiment (based on sample date) - **SAMPLE_POSITION** — varchar, enum Unique sample position measured during run at specifc date, time, and distance - **STB** — Stream sample before mesocosm run starts - **S00** — Mesocosm sample at meter 0 - **S01** — Mesocosm sample at meter 1 - **S02** — Mesocosm sample at meter 2 - **S03** — Mesocosm sample at meter 3 - **S04** — Mesocosm sample at meter 4 - **S05** — Mesocosm sample at meter 5 - **S06** — Mesocosm sample at meter 6 - **S07** — Mesocosm sample at meter 7 - **S08** — Mesocosm sample at meter 8 - **S09** — Mesocosm sample at meter 9 - **S10** — Mesocosm sample at meter 10 - **S11** — Mesocosm sample at meter 11 - **S12** — Mesocosm sample at meter 12 - **STA** — Stream sample after mesocosm run conclusion - **DUPLICATE** — numeric(1), range 1.0000 4.0000, number Indication of whether a second sample was taken for this run and position - **DISTANCE** — numeric(1), range 0.0000 12.0000, meters distance along the mescocosm - **DO** — numeric(1), range 0.2200 13.1600, milligrams per liter Dissolved oxygen concentration in water at time of collection - **TEMPERATURE** — numeric(1), range 2.7000 21.1000, degrees Celsius Temperature of water at time of collection - **TRAVELTIME** — numeric(1), range 4.5500 54.5500, number of hours Median residence travel time in hyporheic mesocosm - **ALKALINITY** — numeric(1), range 20.5900 34.6500, milligrams per liter Alkalinity as calcium carbonate (CaCO3) - **DOC** — numeric(1), range 0.5400 1.6900, milligrams per liter Dissolved organic carbon - **DIC** — numeric(1), range 4.6800 9.8600, milligrams per liter Dissolved inorganic carbon - **NH3N** — numeric(1), range 0.0050 0.0180, milligrams per liter Ammonia-nitrogen (NH3-N) concentration, ammonia as nitrogen - **NH3N_CODE** — varchar, enum NH3-N value qualifier code - ***** — Value is below detection limit for analysis - **A** — Accepted value - **N** — No analytical measurement - **NO3N** — numeric(1), range 0.0010 0.1000, milligrams per liter Nitrate-nitrogen (NO3-N), nitrate + nitrite as nitrogen concentration - **NO3N_CODE** — varchar, enum NO3-N value qualifier code - ***** — Value is below detection limit for analysis - **A** — Accepted value - **N** — No analytical measurement - **PO4P** — numeric(1), range 0.0230 0.1490, milligrams per liter Ortho phosphorus concentration, soluble reactive phosphorus, phosphate (PO4-P) - **TDN** — numeric(1), range 0.0300 0.1400, milligrams per liter Total dissolved nitrogen concentration - **TDP** — numeric(1), range 0.0210 0.1460, milligrams per liter Total dissolved phosphorus concentration - **CL** — numeric(1), range 0.4800 0.9700, milligrams per liter Chloride (dissolved) concentration - **SO4S** — numeric(1), range 0.1600 0.2900, milligrams per liter Dissolved SO4-S concentration, sulfate as sulfur - **NA** — numeric(1), range 2.6200 3.8700, milligrams per liter Dissolved sodium (filtrable) concentration - **K** — numeric(1), range 0.1800 0.3600, milligrams per liter Dissolved potassium (filtrable) concentration - **CA** — numeric(1), range 4.4300 7.3400, milligrams per liter Dissolved calcium (filtrable) concentration - **MG** — numeric(1), range 1.0100 1.6500, milligrams per liter Dissolved magnesium (filtrable) concentration - **FE** — numeric(1), range 0.0500 0.1200, milligrams per liter Dissolved iron concentration - **FE_CODE** — varchar, enum Fe value qualifier code - ***** — Value is below detection limit for analysis - **A** — Accepted value - **N** — No analytical measurement ## Attribute Definitions **ALKALINITY** Alkalinity as calcium carbonate (CaCO3) **CA** Dissolved calcium (filtrable) concentration **CL** Chloride (dissolved) concentration **DBCODE** FSDB Database Code **DIC** Dissolved inorganic carbon **DISTANCE** distance along the mescocosm **DO** Dissolved oxygen concentration in water at time of collection **DOC** Dissolved organic carbon **DUPLICATE** Indication of whether a second sample was taken for this run and position **ENTITY** Entity number **FE** Dissolved iron concentration **FE_CODE** Fe value qualifier code **K** Dissolved potassium (filtrable) concentration **MG** Dissolved magnesium (filtrable) concentration **NA** Dissolved sodium (filtrable) concentration **NH3N** Ammonia-nitrogen (NH3-N) concentration, ammonia as nitrogen **NH3N_CODE** NH3-N value qualifier code **NO3N** Nitrate-nitrogen (NO3-N), nitrate + nitrite as nitrogen concentration **NO3N_CODE** NO3-N value qualifier code **PO4P** Ortho phosphorus concentration, soluble reactive phosphorus, phosphate (PO4-P) **SAMPLE_DATE** date of sample collection **SAMPLE_ID** Unique identifier for every sample (a concatenation of sample run and position) **SAMPLE_POSITION** Unique sample position measured during run at specifc date, time, and distance **SAMPLE_RUN** Unique run number for the mesocosm experiment (based on sample date) **SAMPLE_TIME** time of sample collection **SITECODE** Code for where the experiment was conducted **SO4S** Dissolved SO4-S concentration, sulfate as sulfur **TDN** Total dissolved nitrogen concentration **TDP** Total dissolved phosphorus concentration **TEMPERATURE** Temperature of water at time of collection **TRAVELTIME** Median residence travel time in hyporheic mesocosm ## Enumerated Domains ### DBCODE - **CF020** — FSDB Database Study Code ### SITECODE - **WS1HMF** — WS1 hyporheic mesocosm facility located at WS1 gage house ### SAMPLE_POSITION - **STB** — Stream sample before mesocosm run starts - **S00** — Mesocosm sample at meter 0 - **S01** — Mesocosm sample at meter 1 - **S02** — Mesocosm sample at meter 2 - **S03** — Mesocosm sample at meter 3 - **S04** — Mesocosm sample at meter 4 - **S05** — Mesocosm sample at meter 5 - **S06** — Mesocosm sample at meter 6 - **S07** — Mesocosm sample at meter 7 - **S08** — Mesocosm sample at meter 8 - **S09** — Mesocosm sample at meter 9 - **S10** — Mesocosm sample at meter 10 - **S11** — Mesocosm sample at meter 11 - **S12** — Mesocosm sample at meter 12 - **STA** — Stream sample after mesocosm run conclusion ### NH3N_CODE - ***** — Value is below detection limit for analysis - **A** — Accepted value - **N** — No analytical measurement ### NO3N_CODE - ***** — Value is below detection limit for analysis - **A** — Accepted value - **N** — No analytical measurement ### FE_CODE - ***** — Value is below detection limit for analysis - **A** — Accepted value - **N** — No analytical measurement