Did You Find What You Needed?

We'd love to know how your experience with the Andrews Forest data catalog went - whether you found exactly what you were looking for or hit a dead end. Your feedback helps us improve data discovery and access.

Share Your Feedback

CF020: Solute dynamics in the hyporheic mesocosm in Watershed 1 at the H.J. Andrews Experimental Forest, 2019-2020

← Back to catalog index

Status: notPlanned
Period: 2019-05-31 to 2020-08-18
Version: 2
Published: 2025-05-05
EDI Package ID: knb-lter-and.12113.2
Source XML: CF020_2.xml

Notice

"As Is" Basis: All content, including maps and forecasts, is provided without warranties. Users are advised to independently verify critical information.

Citation

Herzog, S.; Wondzell, S.; Ward, A. 2025. Solute dynamics in the hyporheic mesocosm in Watershed 1 at the H.J. Andrews Experimental Forest, 2019-2020 Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/CF020 Accessed 2026-05-10.

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.

Coverage

Temporal coverage: 2019-05-31 to 2020-08-18

Geographic coverage: Geographic Extent: Watershed 1 (WS01) of the H.J. Andrews Experimental Forest

Spatial coverage:

Bounds: W -122.25802700, E -122.25802700, N 44.20733900, S 44.20733900

Purpose
  • Hyporheic exchange is critical to river corridor biogeochemistry, but decameter-scale flowpaths (~10-m long) are understudied due to logistical challenges (e.g., sampling at depth, multi-day transit times). Some studies suggest that decameter-scale flowpaths should have initial hot spots followed by transport-limited conditions, whereas others suggest steady reaction rates and secondary reactions that could make decameter-scale flowpaths important and unique. 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. Our objective in this study was to quantify the controls on transport- vs. reaction limitation for multiple key constituents in a decameter-scale hyporheic flowpath. Specifically, we asked: (1) How variable is DO, N, and C biogeochemistry between summer and winter, given natural variation in both influent reactant loads and temperature? We expect seasonal water temperature and organic carbon availability to control aerobic respiration rates and the timing and location of oxic-anoxic transitions. (2) How variable is DO, N, and C biogeochemistry along a fixed-geometry, 12-m flowpath? We expect to identify the most rapid transformations (i.e., hot spots) of all three reactants at the upstream (or proximal end) of the flowpath, where influent concentrations are highest, compared to the downstream (or distal end) of the flowpath.
Project

Title: Long-Term Ecological Research

Personnel
Abstract
  • The H.J. Andrews Experimental Forest is a living laboratory that provides unparalleled opportunities for the study of forest and stream ecosystems in the central Cascade Range of Oregon. Since 1980, as a part of the National Science Foundation Long Term Ecological Research (NSF-LTER) program, the Andrews Experimental Forest has become a leader in the analysis of forest and stream ecosystem dynamics.
  • Long-term field experiments and measurement programs have focused on climate dynamics, streamflow, water quality, and vegetation succession. Currently researchers are working to develop concepts and tools needed to predict effects of natural disturbance, land use, and climate change on ecosystem structure, function, and species composition.
  • The Andrews Experimental Forest is administered cooperatively by the USDA Forest Service Pacific Northwest Research Station, Oregon State University and the Willamette National Forest. Funding for the research program comes from the National Science Foundation (NSF), US Forest Service Pacific Northwest Research Station, Oregon State University, and other sources.
Funding

Data were provided by the HJ Andrews Experimental Forest research program, funded by the National Science Foundation's Long-Term Ecological Research Program (DEB 2025755), US Forest Service Pacific Northwest Research Station, and Oregon State University. National Science Foundation: DEB2025755

Awards
Study Area Description
  • Long-Term Ecological Research
    The Andrews Forest is situated in the western Cascade Range of Oregon, and covers the entire 15,800-acre (6400-ha) drainage basin of Lookout Creek. Elevation ranges from 1350 to 5340 feet (410 to 1630 m). Broadly representative of the rugged mountainous landscape of the Pacific Northwest, the Andrews Forest contains excellent examples of the region's conifer forests and associated wildlife and stream ecosystems. These forests are among the tallest and most productive in the world, with tree heights of often greater than 250 ft (75 m). Streams are steep, cold and clean, providing habitat for numerous aquatic organisms.
Associated Party
  • Steven M. Wondzell
    Role: Principal Investigator
    Pacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: 541-758-8753
    Email: steve.wondzell@usda.gov
  • Adam S. Ward
    Role: Principal Investigator
    Dept. Head & Professor; Biological & Ecological Engineering; Oregon State University
    Email: adam.ward@oregonstate.edu
  • Skuyler Herzog
    Role: Creator
    Assistant Professor; Natural Resources Program; Oregon State University-Cascades
    Email: skuyler.herzog@osucascades.edu
  • Steven M. Wondzell
    Role: Creator
    Pacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: 541-758-8753
    Email: steve.wondzell@usda.gov
  • Adam S. Ward
    Role: Creator
    Dept. Head & Professor; Biological & Ecological Engineering; Oregon State University
    Email: adam.ward@oregonstate.edu
  • Roy Haggerty
    Role: Other Researcher
    Dept. of Geosciences;Wilkinson 104;Oregon State University, Corvallis, OR, 97331, USA
    Phone: 541-737-1210
    Email: haggertr@geo.oregonstate.edu
Contact
  • Information Manager
    Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331
    Email: hjaweb@lists.oregonstate.edu
  • Skuyler Herzog
    Assistant Professor; Natural Resources Program; Oregon State University-Cascades
    Email: skuyler.herzog@osucascades.edu
Publisher
  • Andrews Forest LTER Site
    Role: Publisher
    Forest Ecosystems and Society Department in Forestry, Oregon State University, 201K Richardson Hall, Corvallis, OR, 97331-5752
    Phone: (541) 737-8480
    Email: lterweb@lists.oregonstate.edu
Study Description

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. Hyporheic exchange is critical to river corridor biogeochemistry, but decameter-scale flowpaths (~10-m long) are understudied due to logistical challenges (e.g., sampling at depth, multi-day transit times). Some studies suggest that decameter-scale flowpaths should have initial hot spots followed by transport-limited conditions, whereas others suggest steady reaction rates and secondary reactions that could make decameter-scale flowpaths important and unique. 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. Our objective in this study was to quantify the controls on transport- vs. reaction limitation for multiple key constituents in a decameter-scale hyporheic flowpath. Specifically, we asked: (1) How variable is DO, N, and C biogeochemistry between summer and winter, given natural variation in both influent reactant loads and temperature? We expect seasonal water temperature and organic carbon availability to control aerobic respiration rates and the timing and location of oxic-anoxic transitions. (2) How variable is DO, N, and C biogeochemistry along a fixed-geometry, 12-m flowpath? We expect to identify the most rapid transformations (i.e., hot spots) of all three reactants at the upstream (or proximal end) of the flowpath, where influent concentrations are highest, compared to the downstream (or distal end) of the flowpath. Field Methods - CF020

Purpose: Hyporheic exchange is critical to river corridor biogeochemistry, but decameter-scale flowpaths (~10-m long) are understudied due to logistical challenges (e.g., sampling at depth, multi-day transit times). Some studies suggest that decameter-scale flowpaths should have initial hot spots followed by transport-limited conditions, whereas others suggest steady reaction rates and secondary reactions that could make decameter-scale flowpaths important and unique. 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. Our objective in this study was to quantify the controls on transport- vs. reaction limitation for multiple key constituents in a decameter-scale hyporheic flowpath. Specifically, we asked: (1) How variable is DO, N, and C biogeochemistry between summer and winter, given natural variation in both influent reactant loads and temperature? We expect seasonal water temperature and organic carbon availability to control aerobic respiration rates and the timing and location of oxic-anoxic transitions. (2) How variable is DO, N, and C biogeochemistry along a fixed-geometry, 12-m flowpath? We expect to identify the most rapid transformations (i.e., hot spots) of all three reactants at the upstream (or proximal end) of the flowpath, where influent concentrations are highest, compared to the downstream (or distal end) of the flowpath.

Methods

Method Steps

Field Methods - CF020
  • DO and temperature were measured with a handheld YSI ProODO probe. A flow-through sampling chamber was affixed to the sampling port between each mesocosm column, and the DO probe was submerged in the chamber and allowed to equilibrate.
  • All mesocosm sampling (i.e., DO, grab samples) started at the downstream end of the mesocosm (x = 12 m) and worked upstream toward the mesocosm inlet (x = 0 m) to minimize the interference of sampling on water quality. We sampled at the ambient flow rate from tubing that connects each pipe segment rather than pumping from the porewater because pumping may disturb the ambient flow conditions. Sampling at the ambient flow rate took several hours, but this was less than the mean travel time of a single pipe segment.
  • Water samples for DOC, NH3, NO3+NO2, and total dissolved nitrogen (TDN) were collected in acid-washed 250 mL HDPE Nalgene® bottles. Dissolved inorganic carbon (DIC) samples were collected unfiltered in acid-washed 60 mL BD® syringes. Samples were stored on ice upon collection and then delivered to the Cooperative Chemical Analytical Laboratory in Corvallis, Oregon, within 24 hours of collection.
Laboratory Methods - CF020
  • At the Cooperative Chemical Analytical Laboratory (CCAL) in Corvallis, Oregon, unfiltered DIC was analyzed within 24 hours. Filtered DOC aliquots were separated, refrigerated, and analyzed within 48 hours for the winter sample but within 60 days for the summer sample. The remaining filtered samples were frozen for less than 60 days before being thawed and analyzed. Carbon samples were then analyzed using a Shimadzu TOC-VSCH Combustion Carbon Analyzer. NH3, NO3+NO2 were analyzed via Lachat QuikChem 8500 Flow Injection Analyzer, while TDN was analyzed by Technicon Auto-Analyzer II.
  • All laboratory analyses followed CCAL’s standard operating procedures and thus are consistent with other water chemistry data collected at the H. J. Andrews Experimental Forest (for example, dataset CF002 Stream chemistry concentrations; https://andlter.forestry.oregonstate.edu/data/abstractdetail.aspx?dbcode=CF002).
  • The CCAL standard operating procedure for DOC and DIC analyses were developed from American Public Health Association (APHA) methods. Citations for the methods used in DOC and DIC analyses will be in the following format: (CCAL standard operating procedure, APHA method, comparable EPA method, method detection limit).

Sampling

Study Extent
  • Site Description: The mesocosm facility is located adjacent to the stream gauge of Watershed 1 (WS01), in a 2nd-order mountain stream in the H.J. Andrews Experimental Forest (44.20741 N, 122.25831 W). The 96-ha watershed is drained by a steep (~12% gradient) cobble and gravel-bedded stream that flows over a series of step-pool sequences formed by logs and boulders. Stream water was pumped directly from WS01 and into the mesocosm.
  • Sampling frequency: monthly to seasonally
Sampling Description
  • DO and temperature profiles were monitored on 18 dates between May 2019 through August 2020. Our goal was to monitor DO and temperature profiles approximately once per month to capture a wide range of seasonal conditions, but the actual frequency of monitoring varied based on personnel availability and access conditions for this remote site. Grab samples to monitor profiles of carbon and nitrogen along the mesocosm were collected in December 2019 (hereafter referred to as winter samples) and August 2020 (hereafter referred to as summer samples) to provide more comprehensive biogeochemical analyses at time points when the 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.
Spatial Sampling Units
  • Andrews Experimental Forest (HJA)
    W -122.26172200, E -122.10084700, N 44.28196400, S 44.19770400
    Altitude: 1631 to 1631 meter
  • Andrews Watershed 1
    W -122.25683100, E -122.23581300, N 44.20851700, S 44.19901700
    Altitude: 1027 to 1027 meter
  • WS1 hyporheic mesocosm facility located at WS1 gage house
    W -122.25802700, E -122.25802700, N 44.20733900, S 44.20733900
    Altitude: 439 to 439 meter
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: hydrology (theme), biogeochemistry (theme), hyporheic (theme)
Taxonomic Hierarchy

No taxonomic hierarchy listed in this EML file.

Data Entities
# Entity Metadata Data
1 CF02001
Dissolved oxygen profile along the mesocosm
Dissolved oxygen (do) and temperature at 1m distance across a 12 meter mesocosm
METADATA DATA
2 CF02002
Full Analyte Profile
Full analyte profile of a winter and summer sample from watershed 1
METADATA DATA
Metadata
CF02001 - Dissolved oxygen profile along the mesocosm

Object name: CF02001_v1.csv

Records: 270

Attributes: 12

Temporal coverage: 2019-05-31 to 2020-08-18

File size: 17800 byte

Checksum (MD5): 93fe770ad9924af70d36d84eb15ccbd7

Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column

Constraints (2)
  • primaryKey: PRIMARY
    CF02001.SAMPLE_DATE, CF02001.SAMPLE_POSITION, CF02001.SAMPLE_RUN, CF02001.SITECODE
  • notNullConstraint: NOTNULL
    CF02001.DBCODE, CF02001.ENTITY, CF02001.SAMPLE_DATE, CF02001.SAMPLE_ID, CF02001.SAMPLE_POSITION, CF02001.SAMPLE_RUN, CF02001.SITECODE
Attributes (12)
DBCODE - char(5) (nominal)

ID: CF02001.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • CF020
    FSDB Database Study Code
ENTITY - numeric(2,0) (ratio)

ID: CF02001.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1

Numeric domain: type=natural, min=1.0000 (exclusive=false), max=1.0000 (exclusive=false)

SITECODE - char(6) (ordinal)

ID: CF02001.SITECODE

Code for where the experiment was conducted

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • WS1HMF
    WS1 hyporheic mesocosm facility located at WS1 gage house
SAMPLE_DATE - datetime (dateTime)

ID: CF02001.SAMPLE_DATE

date of sample collection

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

SAMPLE_TIME - char(5) (nominal)

ID: CF02001.SAMPLE_TIME

time of sample collection

Type system: Microsoft SQL Server 2019

SAMPLE_ID - char(7) (nominal)

ID: CF02001.SAMPLE_ID

Unique identifier for every sample (a concatenation of sample run and position)

Type system: Microsoft SQL Server 2019

SAMPLE_RUN - numeric(2,0) (ratio)

ID: CF02001.SAMPLE_RUN

Unique run number for the mesocosm experiment (based on sample date)

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1

Numeric domain: type=natural, min=1.0000 (exclusive=false), max=18.0000 (exclusive=false)

SAMPLE_POSITION - char(3) (nominal)

ID: CF02001.SAMPLE_POSITION

Unique sample position measured during run at specifc date, time, and distance

Type system: Microsoft SQL Server 2019

Code definitions (15)
  • 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(2,0) (ratio)

ID: CF02001.DISTANCE

distance along the mescocosm

Type system: Microsoft SQL Server 2019

Unit: meters

Precision: 1

Numeric domain: type=whole, min=0.0000 (exclusive=false), max=12.0000 (exclusive=false)

DO - numeric(5,2) (ratio)

ID: CF02001.DO

Dissolved oxygen concentration in water at time of collection

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=0.1200 (exclusive=false), max=13.1600 (exclusive=false)

TEMPERATURE - numeric(4,1) (ratio)

ID: CF02001.TEMPERATURE

Temperature of water at time of collection

Type system: Microsoft SQL Server 2019

Unit: degrees Celsius

Precision: 1

Numeric domain: type=real, min=2.7000 (exclusive=false), max=21.1000 (exclusive=false)

TRAVELTIME - numeric(5,2) (ratio)

ID: CF02001.TRAVELTIME

Median residence travel time in hyporheic mesocosm

Type system: Microsoft SQL Server 2019

Unit: number of hours

Precision: 1

Numeric domain: type=real, min=4.5500 (exclusive=false), max=54.5500 (exclusive=false)

CF02002 - Full Analyte Profile

Object name: CF02002_v1.csv

Records: 51

Attributes: 30

Temporal coverage: 2019-12-16 to 2020-08-18

File size: 6670 byte

Checksum (MD5): 9572b98650d5179c3e9c0bf91b18ee10

Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column

Constraints (2)
  • primaryKey: PRIMARY
    CF02002.DUPLICATE, CF02002.SAMPLE_DATE, CF02002.SAMPLE_POSITION, CF02002.SAMPLE_RUN, CF02002.SITECODE
  • notNullConstraint: NOTNULL
    CF02002.DBCODE, CF02002.DUPLICATE, CF02002.ENTITY, CF02002.FE_CODE, CF02002.NH3N_CODE, CF02002.NO3N_CODE, CF02002.SAMPLE_DATE, CF02002.SAMPLE_ID, CF02002.SAMPLE_POSITION, CF02002.SAMPLE_RUN, CF02002.SITECODE
Attributes (30)
DBCODE - char(5) (nominal)

ID: CF02002.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • CF020
    FSDB Database Study Code
ENTITY - numeric(2,0) (ratio)

ID: CF02002.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1

Numeric domain: type=natural, min=2.0000 (exclusive=false), max=2.0000 (exclusive=false)

SITECODE - char(6) (ordinal)

ID: CF02002.SITECODE

Code for where the experiment was conducted

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • WS1HMF
    WS1 hyporheic mesocosm facility located at WS1 gage house
SAMPLE_DATE - datetime (dateTime)

ID: CF02002.SAMPLE_DATE

date of sample collection

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

SAMPLE_ID - char(7) (nominal)

ID: CF02002.SAMPLE_ID

Unique identifier for every sample (a concatenation of sample run and position)

Type system: Microsoft SQL Server 2019

SAMPLE_RUN - numeric(2,0) (ratio)

ID: CF02002.SAMPLE_RUN

Unique run number for the mesocosm experiment (based on sample date)

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1

Numeric domain: type=natural, min=1.0000 (exclusive=false), max=18.0000 (exclusive=false)

SAMPLE_POSITION - char(3) (nominal)

ID: CF02002.SAMPLE_POSITION

Unique sample position measured during run at specifc date, time, and distance

Type system: Microsoft SQL Server 2019

Code definitions (15)
  • 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,0) (ratio)

ID: CF02002.DUPLICATE

Indication of whether a second sample was taken for this run and position

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1

Numeric domain: type=natural, min=1.0000 (exclusive=false), max=4.0000 (exclusive=false)

DISTANCE - numeric(2,0) (ratio)

ID: CF02002.DISTANCE

distance along the mescocosm

Type system: Microsoft SQL Server 2019

Unit: meters

Precision: 1

Numeric domain: type=whole, min=0.0000 (exclusive=false), max=12.0000 (exclusive=false)

DO - numeric(5,2) (ratio)

ID: CF02002.DO

Dissolved oxygen concentration in water at time of collection

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=0.2200 (exclusive=false), max=13.1600 (exclusive=false)

TEMPERATURE - numeric(4,1) (ratio)

ID: CF02002.TEMPERATURE

Temperature of water at time of collection

Type system: Microsoft SQL Server 2019

Unit: degrees Celsius

Precision: 1

Numeric domain: type=real, min=2.7000 (exclusive=false), max=21.1000 (exclusive=false)

TRAVELTIME - numeric(5,2) (ratio)

ID: CF02002.TRAVELTIME

Median residence travel time in hyporheic mesocosm

Type system: Microsoft SQL Server 2019

Unit: number of hours

Precision: 1

Numeric domain: type=real, min=4.5500 (exclusive=false), max=54.5500 (exclusive=false)

ALKALINITY - numeric(5,2) (ratio)

ID: CF02002.ALKALINITY

Alkalinity as calcium carbonate (CaCO3)

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=20.5900 (exclusive=false), max=34.6500 (exclusive=false)

DOC - numeric(4,2) (ratio)

ID: CF02002.DOC

Dissolved organic carbon

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=0.5400 (exclusive=false), max=1.6900 (exclusive=false)

DIC - numeric(4,2) (ratio)

ID: CF02002.DIC

Dissolved inorganic carbon

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=4.6800 (exclusive=false), max=9.8600 (exclusive=false)

NH3N - numeric(5,3) (ratio)

ID: CF02002.NH3N

Ammonia-nitrogen (NH3-N) concentration, ammonia as nitrogen

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=0.0050 (exclusive=false), max=0.0180 (exclusive=false)

NH3N_CODE - char(1) (nominal)

ID: CF02002.NH3N_CODE

NH3-N value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (3)
  • *
    Value is below detection limit for analysis
  • A
    Accepted value
  • N
    No analytical measurement
NO3N - numeric(5,3) (ratio)

ID: CF02002.NO3N

Nitrate-nitrogen (NO3-N), nitrate + nitrite as nitrogen concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=0.0010 (exclusive=false), max=0.1000 (exclusive=false)

NO3N_CODE - char(1) (nominal)

ID: CF02002.NO3N_CODE

NO3-N value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (3)
  • *
    Value is below detection limit for analysis
  • A
    Accepted value
  • N
    No analytical measurement
PO4P - numeric(5,3) (ratio)

ID: CF02002.PO4P

Ortho phosphorus concentration, soluble reactive phosphorus, phosphate (PO4-P)

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=0.0230 (exclusive=false), max=0.1490 (exclusive=false)

TDN - numeric(4,2) (ratio)

ID: CF02002.TDN

Total dissolved nitrogen concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=0.0300 (exclusive=false), max=0.1400 (exclusive=false)

TDP - numeric(5,3) (ratio)

ID: CF02002.TDP

Total dissolved phosphorus concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=0.0210 (exclusive=false), max=0.1460 (exclusive=false)

CL - numeric(4,2) (ratio)

ID: CF02002.CL

Chloride (dissolved) concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=0.4800 (exclusive=false), max=0.9700 (exclusive=false)

SO4S - numeric(4,2) (ratio)

ID: CF02002.SO4S

Dissolved SO4-S concentration, sulfate as sulfur

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=0.1600 (exclusive=false), max=0.2900 (exclusive=false)

NA - numeric(4,2) (ratio)

ID: CF02002.NA

Dissolved sodium (filtrable) concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=2.6200 (exclusive=false), max=3.8700 (exclusive=false)

K - numeric(4,2) (ratio)

ID: CF02002.K

Dissolved potassium (filtrable) concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=0.1800 (exclusive=false), max=0.3600 (exclusive=false)

CA - numeric(4,2) (ratio)

ID: CF02002.CA

Dissolved calcium (filtrable) concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=4.4300 (exclusive=false), max=7.3400 (exclusive=false)

MG - numeric(4,2) (ratio)

ID: CF02002.MG

Dissolved magnesium (filtrable) concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=1.0100 (exclusive=false), max=1.6500 (exclusive=false)

FE - numeric(4,2) (ratio)

ID: CF02002.FE

Dissolved iron concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=0.0500 (exclusive=false), max=0.1200 (exclusive=false)

FE_CODE - char(1) (nominal)

ID: CF02002.FE_CODE

Fe value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (3)
  • *
    Value is below detection limit for analysis
  • A
    Accepted value
  • N
    No analytical measurement
Units
meters m length meter meter 1 meter; SI unit of length
number number dimensionless number dimensionless 1 dimensionless number, i.e., ratio, count
milligrams per liter mg/l massDensity milligramPerLiter kilogramPerMeterCubed 0.001 milligrams per liter
degrees Celsius deg c temperature celsiusDegree kelvin 1 Degrees Celsius; a common unit of temperature; constantToSI=273.18
number of hours hours time nominalHour second 3600 one hour excluding leap seconds, 3600 seconds
Intellectual Rights

Data Use Agreement:

The re-use of scientific data has the potential to greatly increase communication, collaboration and synthesis within and among disciplines, and thus is fostered, supported and encouraged. This Data Set is released under the Creative Commons license CC BY "Attribution" (see: https://creativecommons.org/licenses/by/4.0/). Creative Commons license CC BY - Attribution is a license that allows others to distribute, remix, tweak, and build upon your work (even commercially), as long as you are credited for the original creation. This license accommodates maximum dissemination and use of licensed materials.

It is considered professional conduct and an ethical obligation to acknowledge the work of other scientists. The Data User is asked to provide attribution of the original work if this data package is shared in whole or by individual parts or used in the derivation of other products. A recommended citation is provided for each Data Set in the Andrews LTER data catalog (see: http://andlter.forestry.oregonstate.edu/data/catalog/datacatalog.aspx). A generic citation is also provided for this Data Set on the website https://portal.edirepository.org in the summary metadata page. Data Users are thus strongly encouraged to consider consultation, collaboration and/or co-authorship with the Data Set Creator.

While substantial efforts are made to ensure the accuracy of data and associated documentation, complete accuracy of data sets cannot be guaranteed and all data are made available "as is." The Data User should be aware, however, that data are updated periodically and it is the responsibility of the Data User to check for new versions of the data. The data authors and the repository where these data were obtained shall not be liable for damages resulting from any use or misinterpretation of the data.

General acknowledgement: Data were provided by the HJ Andrews Experimental Forest research program, funded by the National Science Foundation's Long-Term Ecological Research Program (DEB 2025755), US Forest Service Pacific Northwest Research Station, and Oregon State University.

Licensed

License: Creative Commons Attribution 4.0 International Public License

Identifier: CC-BY-4.0

URL: https://creativecommons.org/licenses/by/4.0/

Maintenance

Maintenance update frequency: notPlanned

Description

  • An update history is logged and maintained with each new version of every dataset.

Change History

  • Version1 (2024-07-30)
    Study code and preliminary metadata established
  • Version2 (2025-05-05)
    Original upload of entity 1 and 2 metadata from entity_attribute spreadsheet using move_xls programs. Ran generic QC on data and uploaded to SQL.