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

CF010: Stream and hyporheic carbon dioxide (CO2) measurements in a headwater catchment, Watershed 1, and throughout Lookout Creek watershed at the HJ Andrews Experimental Forest, July 2013 to July 2014

← Back to catalog index

Status: notPlanned
Period: 2013-07-22 to 2014-07-10
Version: 3
Published: 2017-06-29
EDI Package ID: knb-lter-and.5275.3
Source XML: CF010_3.xml

Notice

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

Citation

Haggerty, R.; Dosch, N. 2017. Stream and hyporheic carbon dioxide (CO2) measurements in a headwater catchment, Watershed 1, and throughout Lookout Creek watershed at the HJ Andrews Experimental Forest, July 2013 to July 2014 Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/CF010 Accessed 2026-05-10.

Abstract

We examined the spatial and temporal variability of stream carbon dioxide (CO2) in a headwater catchment. We measured stream and hyporheic pCO2 at at 30-minute intervals over 11 months in 95.9-ha Watershed 1, HJ Andrews Experimental Forest. We also measured stream temperature, pH and alkalinity which we used to calculate CO2 at monthly intervals from July 2013 through July 2014 at 38 locations across the 6400-ha HJ Andrews Experimental Forest.

Coverage

Temporal coverage: 2013-07-22 to 2014-07-10

Geographic coverage: 30-minute pCO<subscript>2</sub > data was collected within the Watershed 1 well network at the base of watershed 1. Stream pH, temperature, and alkalinity measurements were made across the Lookout Creek drainage network in HJ Andrews Experimental Forest.

Spatial coverage:

Bounds: W -122.26109000, E -122.11718000, N 44.29470000, S 44.20147000

Purpose
  • To examine the spatial and temporal variability of stream carbon dioxide (CO) and the drivers of these variations in a headwater catchment for improved spatial and temporal scaling of stream pCO for watershed dissolved inorganic carbon flux estimates.
Project

Title: Long-Term Ecological Research

Personnel
  • Sherri L. Johnson - Principal Investigator
    US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: 541-758-7771
    Email: sherri.johnson2@usda.gov, sherri.johnson@oregonstate.edu
  • Julia A. Jones - Principal Investigator
    Oregon State University;Department of Geosciences; Wilkinson Hall 104, Corvallis, OR, 97331-5506, USA
    Phone: (541) 737-1224
    Email: Julia.Jones@oregonstate.edu, geojulia@comcast.net
    ORCID: http://orcid.org/0000-0001-9429-8925
  • Matthew G Betts - Principal Investigator
    Department of Forest Ecosystems and Society; 201E Richardson Hall; College of Forestry; Oregon State University, Corvallis, OR, 97331
    Phone: (541) 737-3841
    Email: matt.betts@oregonstate.edu
  • Michael P. Nelson - Principal Investigator
    Department of Forest Ecosystems and Society; 201K Richarson Hall; College of Forestry; Oregon State University, Corvallis, OR, 97331
    Phone: 541-737-9221
    Email: mpnelson@oregonstate.edu
    ORCID: http://orcid.org/0000-0001-6917-4752
  • David Bell - Principal Investigator
    Email: david.bell@usda.gov, david.bell@oregonstate.edu
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: DEB1440409

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
  • Roy Haggerty
    Role: Principal Investigator
    Dept. of Geosciences;Wilkinson 104;Oregon State University, Corvallis, OR, 97331, USA
    Phone: 541-737-1210
    Email: haggertr@geo.oregonstate.edu
  • Steven M. Wondzell
    Role: Other Researcher
    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
  • Roy Haggerty
    Role: Creator
    Dept. of Geosciences;Wilkinson 104;Oregon State University, Corvallis, OR, 97331, USA
    Phone: 541-737-1210
    Email: haggertr@geo.oregonstate.edu
  • Nicholas T. Dosch
    Role: Creator
    Water Resources Engineering
    Email: ntdosch@gmail.com, doschn@onid.orst.edu
Contact
  • Information Manager
    Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331
    Email: hjaweb@fsl.orst.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@fsl.orst.edu
Study Description

We examined the spatial and temporal variability of stream carbon dioxide (CO2) in a headwater catchment. We measured stream and hyporheic pCO2 at at 30-minute intervals over 11 months in 95.9-ha Watershed 1, HJ Andrews Experimental Forest. We also measured stream temperature, pH and alkalinity which we used to calculate CO2 at monthly intervals from July 2013 through July 2014 at 38 locations across the 6400-ha HJ Andrews Experimental Forest. To examine the spatial and temporal variability of stream carbon dioxide (CO) and the drivers of these variations in a headwater catchment for improved spatial and temporal scaling of stream pCO for watershed dissolved inorganic carbon flux estimates. Field Methods - CF010

Purpose: To examine the spatial and temporal variability of stream carbon dioxide (CO) and the drivers of these variations in a headwater catchment for improved spatial and temporal scaling of stream pCO for watershed dissolved inorganic carbon flux estimates.

Methods

Method Steps

Field Methods - CF010
  • 30-minute pCO data were collected GMM220 series CO probes following the method in Johnson et al. [2010]. Probes were sealed in gas permeable PTFE sleeves and connected to external data loggers where mole fraction pCO (ppmv) was measured at 5-min intervals, averaged and recoded at 30-min intervals. One probe was placed in the WS01 stream attached to a stryofoam float at a depth of 6 cm and another in a riparian well located 0.4 m from the stream edge at a depth of 65 cm below the water table.
  • Water samples for the analysis of stream alkalinity were collected in 250 mL HDPE (high-density polyethylene) bottles (Nalgene, Inc., United States). Bottles were acid washed according to the Oregon State University and U.S. Forest Service Cooperative Chemical Analytical Laboratory (CCAL) quality assurance plan (CCAL, 2013). Prior to collection, bottles were rinsed three times with stream water by filling the sample container 1/4 full, then shaking vigorously with the lid loosely tightened to the bottle, making sure to rinse the inside walls, threads, and cap of the bottle. Samples were collected from the thalweg in locations deep enough to fully submerge the bottle while the sample collector stood downstream of the sampling location. In larger streams, samples were taken as close to the thalweg as possible and always collected from locations with strong downstream transport, thereby avoiding stagnant pools or lateral cavities. Sample bottle caps were secured underwater to minimize air collected with the sample and to minimize the amount of sediment or other particulates collected with the water sample. Nitrile gloves were worn during sampling to minimize sample contamination. After collection, samples were placed on ice in a dark container until laboratory processing.
  • Stream pH and temperature were measured at sample sites using a YSI Model 63 handheld pH, conductivity, salinity and temperature system (YSI, Inc., United States). The meter was calibrated for pH at the beginning of each field day with a two point calibration at pH 7.0 and 10.0, bracketing the range of expected field pH values. When making field measurements, the probe was placed in the thalweg of the stream, slightly downstream from the location of water sampling. The meter was given a minimum of 10 minutes to stabilize prior to reading. The probe was positioned so that the pH electrode was suspended in the water column and not resting in mud or sediment.

Instrumentation:

  • Vaisala GMM 220 NDIR CO<subscript>2</subscript> module, International polymer engineering PTFE sleeve, YSI 63 pH/Temperature/Conductivity probe
Laboratory Methods - CF010
  • Analytical lab work was conducted at the Institute for Water and Watersheds Collaboratory at Oregon State University. Carbonate alkalinity was determined using a Radiometer TIM840 AutoTitrator (Radiometer Analytical, SAS, France) according to CCAL procedure 10C.0 by titrating 100 mL of unfiltered sample to a pH of 4.5 with 0.02 N HSO (CCAL, 2013). Detection limits associated with this method are 0.2 mg CaCO L. Samples were processed within 7 days of field collection.

Instrumentation:

  • Radiometer TIM840 AutoTitrator
Processing Procedures - CF010
  • 30-minute stream and hyporheic CO-probe readings were corrected for deviations in temperature, depth and barrometric pressure from calibration conditions following Johnson et al. (2010).
  • Stream pCO was calculated with the CO2SYS program (van Heuven et al., 2011) using field measurements of temperature and pH, and lab measurements of alkalinity. This calculation is based on equilibrium concentrations of the carbonate species in water at a given pressure, temperature, and pH. The dissociation constants of the carbonate species used for this calculation were those from Millero (1979) for freshwater systems.

Instrumentation:

  • CO2SYS for MATLAB, can be downloaded at: http://cdiac.ornl.gov/oceans/co2rprt.html

Sampling

Sampling Description
  • We examined the spatial and temporal variability of stream and hyporheic partial pressure of carbon dioxide (pCO) and the drivers of these variations in a headwater catchment. To examine the temporal dynamics of stream and hyporheic pCO, we measured pCO at high temporal resolution (30-minute interval) at seasonal and event scales in the in the stream and in a hyporheic well in the Watershed 1 well network in the HJ Andrews Experimental Forest. Stream and hyporheic pCO were observed for 11 months, from 27 August 2013 to 10 July 2014.
  • To examine spatial variation and drivers, we measured stream pCO at monthly intervals from July 2013 through July 2014 at 38 locations across the 6400-ha HJ Andrews Experimental Forest. Synoptic field measurements and water samples were collected 12 times over a 13-month study period from July 2013 to July 2014. Sample sites were established across the Lookout Creek drainage network at sites that captured the diverse natural and managed landscape of the HJA. Sample sites were chosen to ensure they included streams from a range of basin sizes, elevations, discharge regimes, subclimates and forest management histories.Sampling occurred at approximately monthly intervals; no samples were collected during April 2014. Low elevation sites were sampled during all 12 sample periods. High elevation sites were sometimes inaccessible due to snowfall and were therefore not sampled during some winter months. Streams that were designed as longitudinal transects were sampled from high elevation to low. Sites were sampled at approximately the same time of day over the study period.
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
  • Watershed 1 well network
    W -122.25833300, E -122.25833300, N 44.20777800, S 44.20777800
  • Dosch stream sampling sites at the HJ Andrews Experimental Forest
    W -122.26109000, E -122.11718000, N 44.29470000, S 44.20147000
  • Watershed 1 Dosch stream sample site 1
    W -122.24989000, E -122.24989000, N 44.20451000, S 44.20451000
  • Watershed 1 Dosch stream sample site 2
    W -122.25018000, E -122.25018000, N 44.20504000, S 44.20504000
  • Watershed 1 Dosch stream sample site 3
    W -122.25105000, E -122.25105000, N 44.20520000, S 44.20520000
  • Watershed 1 Dosch stream sample site 4
    W -122.25131000, E -122.25131000, N 44.20507000, S 44.20507000
  • Watershed 1 Dosch stream sample site 5
    W -122.25191000, E -122.25191000, N 44.20530000, S 44.20530000
  • Watershed 1 Dosch stream sample site 6
    W -122.25253000, E -122.25253000, N 44.20534000, S 44.20534000
  • Watershed 1 Dosch stream sample site 7
    W -122.25302000, E -122.25302000, N 44.20565000, S 44.20565000
  • Watershed 1 Dosch stream sample site 8
    W -122.25368000, E -122.25368000, N 44.20575000, S 44.20575000
  • Watershed 1 Dosch stream sample site 9
    W -122.25423000, E -122.25423000, N 44.20574000, S 44.20574000
  • Watershed 1 Dosch stream sample site 10
    W -122.25482000, E -122.25482000, N 44.20581000, S 44.20581000
  • Watershed 1 Dosch stream sample site 11
    W -122.25514000, E -122.25514000, N 44.20609000, S 44.20609000
  • Watershed 1 Dosch stream sample site 12
    W -122.25539000, E -122.25539000, N 44.20612000, S 44.20612000
  • Watershed 1 Dosch stream sample site 13
    W -122.25632000, E -122.25632000, N 44.20636000, S 44.20636000
  • Watershed 1 Dosch stream sample site 14
    W -122.25713000, E -122.25713000, N 44.20704000, S 44.20704000
  • Watershed 1 Dosch stream sample site 15
    W -122.25768000, E -122.25768000, N 44.20704000, S 44.20704000
  • Watershed 2 Dosch stream sample site 1
    W -122.24097000, E -122.24097000, N 44.20164000, S 44.20164000
  • Watershed 2 Dosch stream sample site 2
    W -122.24522000, E -122.24522000, N 44.21201000, S 44.21201000
  • Watershed 2 Dosch stream sample site 3
    W -122.24930000, E -122.24930000, N 44.21427000, S 44.21427000
  • Watershed 3 Dosch stream sample site 1
    W -122.24294000, E -122.24294000, N 44.21953000, S 44.21953000
  • Watershed 6 Dosch stream sample site 1
    W -122.18079000, E -122.18079000, N 44.26149000, S 44.26149000
  • Watershed 7 Dosch stream sample site 1
    W -122.17537000, E -122.17537000, N 44.26469000, S 44.26469000
  • Watershed 8 Dosch stream sample site 1
    W -122.17097000, E -122.17097000, N 44.26632000, S 44.26632000
  • Watershed 9 Dosch stream sample site 1
    W -122.25894000, E -122.25894000, N 44.20147000, S 44.20147000
  • Watershed 10 Dosch stream sample site 1
    W -122.26109000, E -122.26109000, N 44.21702000, S 44.21702000
  • Lookout Creek Dosch stream sample site 1
    W -122.11718000, E -122.11718000, N 44.20756000, S 44.20756000
  • Lookout Creek Dosch stream sample site 2
    W -122.11781000, E -122.11781000, N 44.22220000, S 44.22220000
  • Lookout Creek Dosch stream sample site 3
    W -122.15955000, E -122.15955000, N 44.23187000, S 44.23187000
  • Lookout Creek Dosch stream sample site 4
    W -122.18631000, E -122.18631000, N 44.23258000, S 44.23258000
  • Lookout Creek Dosch stream sample site 5
    W -122.21742000, E -122.21742000, N 44.23089000, S 44.23089000
  • Lookout Creek Dosch stream sample site 6
    W -122.25725000, E -122.25725000, N 44.21002000, S 44.21002000
  • Lookout Creek Dosch stream sample site 7
    W -122.25995000, E -122.25995000, N 44.20785000, S 44.20785000
  • Mack Creek Dosch stream sample site 1
    W -122.16468000, E -122.16468000, N 44.21619000, S 44.21619000
  • Mack Creek Dosch stream sample site 2
    W -122.16771000, E -122.16771000, N 44.21768000, S 44.21768000
  • Mack Creek Dosch stream sample site 3
    W -122.16817000, E -122.16817000, N 44.22713000, S 44.22713000
  • McRae Creek Dosch stream sample site 1
    W -122.16440000, E -122.16440000, N 44.26073000, S 44.26073000
  • McRae Creek Dosch stream sample site 2
    W -122.20743000, E -122.20743000, N 44.23409000, S 44.23409000
  • Cold Creek Dosch stream sample site 1
    W -122.12386000, E -122.12386000, N 44.29470000, S 44.29470000
  • No Name Creek Dosch stream sample site 1 off FS Rd 320 north of unit L503
    W -122.18061000, E -122.18061000, N 44.25823000, S 44.25823000
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: carbon cycling (theme), hydrologic processes (theme), carbon (theme), water (theme), hyporheic zone (theme), aquatic ecosystems (theme)
Taxonomic Hierarchy

No taxonomic hierarchy listed in this EML file.

Data Entities
# Entity Metadata Data
1 CF01001
CF01001
Stream and Hyporheic carbon dioxide partial pressure (pCO2) in lower Watershed 1, HJA:
METADATA DATA
2 CF01002
CF01002
Stream pH, temperature, alkalinity and computed pCO2 at 38 sites in HJA:
METADATA DATA
Metadata
CF01001 - CF01001

Object name: CF01001.csv

Records: 15182

Attributes: 8

Temporal coverage: 2013-06-18 to 2014-07-09

File size: 734590 byte

Checksum (MD5): f196e4eaf5eebd9fbcbc781e2c702c96

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

Constraints (2)
  • primaryKey: PRIMARY
    CF01001.SAMPLE_DATETIME, CF01001.SITECODE
  • notNullConstraint: NOTNULL
    CF01001.SAMPLE_DATETIME, CF01001.DBCODE, CF01001.ENTITY, CF01001.H_PCO2CODE, CF01001.SITECODE, CF01001.S_PCO2CODE
Attributes (8)
DBCODE - char(5) (nominal)

ID: CF01001.DBCODE

Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • CF010
    FSDB Database code CF010
ENTITY - numeric(2,0) (ratio)

ID: CF01001.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITECODE - char(5) (nominal)

ID: CF01001.SITECODE

Site code

Type system: Microsoft SQL Server 2008

Code definitions (39)
  • WS1WN
    Watershed 1 well network
  • W101
    Watershed 1 Dosch stream sample site 1
  • W102
    Watershed 1 Dosch stream sample site 2
  • W103
    Watershed 1 Dosch stream sample site 3
  • W104
    Watershed 1 Dosch stream sample site 4
  • W105
    Watershed 1 Dosch stream sample site 5
  • W106
    Watershed 1 Dosch stream sample site 6
  • W107
    Watershed 1 Dosch stream sample site 7
  • W108
    Watershed 1 Dosch stream sample site 8
  • W109
    Watershed 1 Dosch stream sample site 9
  • W110
    Watershed 1 Dosch stream sample site 10
  • W111
    Watershed 1 Dosch stream sample site 11
  • W112
    Watershed 1 Dosch stream sample site 12
  • W113
    Watershed 1 Dosch stream sample site 13
  • W114
    Watershed 1 Dosch stream sample site 14
  • W115
    Watershed 1 Dosch stream sample site 15
  • W201
    Watershed 2 Dosch stream sample site 1
  • W202
    Watershed 2 Dosch stream sample site 2
  • W203
    Watershed 2 Dosch stream sample site 3
  • W301
    Watershed 3 Dosch stream sample site 1
  • W601
    Watershed 6 Dosch stream sample site 1
  • W701
    Watershed 7 Dosch stream sample site 1
  • W801
    Watershed 8 Dosch stream sample site 1
  • W901
    Watershed 9 Dosch stream sample site 1
  • W1001
    Watershed 10 Dosch stream sample site 1
  • LO01
    Lookout Creek Dosch stream sample site 1
  • LO02
    Lookout Creek Dosch stream sample site 2
  • LO03
    Lookout Creek Dosch stream sample site 3
  • LO04
    Lookout Creek Dosch stream sample site 4
  • LO05
    Lookout Creek Dosch stream sample site 5
  • LO06
    Lookout Creek Dosch stream sample site 6
  • LO07
    Lookout Creek Dosch stream sample site 7
  • MK01
    Mack Creek Dosch stream sample site 1
  • MK02
    Mack Creek Dosch stream sample site 2
  • MK03
    Mack Creek Dosch stream sample site 3
  • MR01
    McRae Creek Dosch stream sample site 1
  • MR02
    McRae Creek Dosch stream sample site 2
  • CC01
    Cold Creek Dosch stream sample site 1
  • NN01
    No Name Creek Dosch stream sample site 1 off FS Rd 320 north of unit L503
SAMPLE_DATETIME - datetime (dateTime)

ID: CF01001.SAMPLE_DATETIME

Date and time (PST) of pCO2 reading

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD hh:mm:ss

S_PCO2 - numeric(4,0) (ratio)

ID: CF01001.S_PCO2

Stream pCO2 measured in approximate center of Watershed 1 well network between the E and F transects

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 1

Numeric domain: type=whole, min=425.0000 (exclusive=false), max=3565.0000 (exclusive=false)

S_PCO2CODE - char(1) (nominal)

ID: CF01001.S_PCO2CODE

Stream reading estimate code

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • G
    Data good
  • Q
    Questionable data - Probe may have been unsubmerged from stream
H_PCO2 - numeric(5,0) (ratio)

ID: CF01001.H_PCO2

Hyporheic pCO2 measured in well G3

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 1

Numeric domain: type=whole, min=3857.0000 (exclusive=false), max=16439.0000 (exclusive=false)

H_PCO2CODE - char(1) (nominal)

ID: CF01001.H_PCO2CODE

Hyporheic reading estimate code

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • G
    Data good
  • M
    Missing data - Probe removed from well
  • E
    Estimated data - Based on moving average
CF01002 - CF01002

Object name: CF01002.csv

Records: 456

Attributes: 12

Temporal coverage: 2013-07-22 to 2014-07-10

File size: 32317 byte

Checksum (MD5): b162e8580ae7c6e21f464a73c43aa431

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

Constraints (2)
  • primaryKey: PRIMARY
    CF01002.RUN, CF01002.SITECODE
  • notNullConstraint: NOTNULL
    CF01002.DBCODE, CF01002.ENTITY, CF01002.ESTCODE, CF01002.RUN, CF01002.SITECODE
Attributes (12)
DBCODE - char(5) (nominal)

ID: CF01002.DBCODE

Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • CF010
    FSDB Database code CF010
ENTITY - numeric(2,0) (ratio)

ID: CF01002.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITECODE - char(5) (nominal)

ID: CF01002.SITECODE

Site code

Type system: Microsoft SQL Server 2008

Code definitions (39)
  • WS1WN
    Watershed 1 well network
  • W101
    Watershed 1 Dosch stream sample site 1
  • W102
    Watershed 1 Dosch stream sample site 2
  • W103
    Watershed 1 Dosch stream sample site 3
  • W104
    Watershed 1 Dosch stream sample site 4
  • W105
    Watershed 1 Dosch stream sample site 5
  • W106
    Watershed 1 Dosch stream sample site 6
  • W107
    Watershed 1 Dosch stream sample site 7
  • W108
    Watershed 1 Dosch stream sample site 8
  • W109
    Watershed 1 Dosch stream sample site 9
  • W110
    Watershed 1 Dosch stream sample site 10
  • W111
    Watershed 1 Dosch stream sample site 11
  • W112
    Watershed 1 Dosch stream sample site 12
  • W113
    Watershed 1 Dosch stream sample site 13
  • W114
    Watershed 1 Dosch stream sample site 14
  • W115
    Watershed 1 Dosch stream sample site 15
  • W201
    Watershed 2 Dosch stream sample site 1
  • W202
    Watershed 2 Dosch stream sample site 2
  • W203
    Watershed 2 Dosch stream sample site 3
  • W301
    Watershed 3 Dosch stream sample site 1
  • W601
    Watershed 6 Dosch stream sample site 1
  • W701
    Watershed 7 Dosch stream sample site 1
  • W801
    Watershed 8 Dosch stream sample site 1
  • W901
    Watershed 9 Dosch stream sample site 1
  • W1001
    Watershed 10 Dosch stream sample site 1
  • LO01
    Lookout Creek Dosch stream sample site 1
  • LO02
    Lookout Creek Dosch stream sample site 2
  • LO03
    Lookout Creek Dosch stream sample site 3
  • LO04
    Lookout Creek Dosch stream sample site 4
  • LO05
    Lookout Creek Dosch stream sample site 5
  • LO06
    Lookout Creek Dosch stream sample site 6
  • LO07
    Lookout Creek Dosch stream sample site 7
  • MK01
    Mack Creek Dosch stream sample site 1
  • MK02
    Mack Creek Dosch stream sample site 2
  • MK03
    Mack Creek Dosch stream sample site 3
  • MR01
    McRae Creek Dosch stream sample site 1
  • MR02
    McRae Creek Dosch stream sample site 2
  • CC01
    Cold Creek Dosch stream sample site 1
  • NN01
    No Name Creek Dosch stream sample site 1 off FS Rd 320 north of unit L503
RUN - numeric(3,0) (interval)

ID: CF01002.RUN

Sample collection run number (1-12)

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

FIELD_DATETIME - datetime (dateTime)

ID: CF01002.FIELD_DATETIME

field measurement date and time

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD hh:mm:ss

PH - numeric(3,1) (interval)

ID: CF01002.PH

stream pH

Type system: Microsoft SQL Server 2008

Unit: pH units

Precision: 1

Numeric domain: type=real, min=6.6000 (exclusive=false), max=8.1000 (exclusive=false)

TEMP - numeric(4,1) (interval)

ID: CF01002.TEMP

stream temperature

Type system: Microsoft SQL Server 2008

Unit: degrees Celsius

Precision: 1

Numeric domain: type=real, min=0.7000 (exclusive=false), max=19.5000 (exclusive=false)

LAB_DATE - datetime (dateTime)

ID: CF01002.LAB_DATE

Date of laborotory measurement

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

ALK_CACO3 - numeric(4,1) (ratio)

ID: CF01002.ALK_CACO3

laboratory determined alkalinity

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=6.5000 (exclusive=false), max=36.4000 (exclusive=false)

CALC_PCO2 - numeric(4,0) (ratio)

ID: CF01002.CALC_PCO2

calculated stream pCO2

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 1

Numeric domain: type=whole, min=147.0000 (exclusive=false), max=8154.0000 (exclusive=false)

ESTCODE - char(1) (nominal)

ID: CF01002.ESTCODE

Qualifier of chemistry measurement

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • G
    Data good
  • Q
    Questionable data - See Notes
  • M
    Missing data - See Notes
NOTE - varchar(150) (nominal)

ID: CF01002.NOTE

Note about chemistry measurement

Type system: Microsoft SQL Server 2008

Units
milligrams per liter mg/l massDensity milligramPerLiter kilogramPerMeterCubed 0.001 milligrams per liter
parts per million ppm massDensity partsPerMillion kilogramPerMeterCubed 0.001 parts per million
pH units ph undefined pH unknown N/A Scale used for pH measurements
number number dimensionless number dimensionless 1 dimensionless number, i.e., ratio, count
degrees Celsius deg c temperature celsiusDegree kelvin 1 Degrees Celsius; a common unit of temperature; constantToSI=273.18
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: N/A

Maintenance

Maintenance update frequency: notPlanned

Description

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

Change History

  • Version1 (2013-08-06)
    Study code and preliminary metadata established
  • Version2 (2014-09-26)
    Data imported using XLS programs. QC run, data structures created on SQL and data appended to these structures. No CSV file created as data is restricted due to publication issues.
  • Version3 (2017-06-29)
    Data are being released per request to PI on 11/2/2016 and PI responded yes on 11/5/2016.