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

HF024: Oxygen-18 isotope ratios, chemistry, and tracers in storm water from WS10 hillslope experiment in the HJ Andrews Experimental Forest, 2001-2003

← Back to catalog index

Go to Data Downloads Download Metadata Text (.txt) View Metadata in Browser (HTML) Download Metadata CSV (ZIP)

Status: notPlanned
Period: 2000-10-17 to 2003-08-11
Version: 3
Published: 2020-05-04
EDI Package ID: knb-lter-and.4542.3
Source XML: HF024_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

McGuire, K. 2020. Oxygen-18 isotope ratios, chemistry, and tracers in storm water from WS10 hillslope experiment in the HJ Andrews Experimental Forest, 2001-2003 Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/HF024 Accessed 2026-05-10.

Abstract

Oxygen-18 ratios, expressed as Delta-18O or D18O (parts per hundred), measured in WS10 discharge and WS10 precipitation. The time series spans from January 2001 to February 2003, period during which precipitation and streamflow were sampled mostly manually and weekly. The time series also includes some periods of higher frequency automatic sampling in streamflow and precipitation in winter 2001 and winter 2002. The precipitation Delta-18O time series corresponds to the Delta-18O measured at PRIMET station located about 1 km from WS10 outlet at a similar altitude, except from 01-Sep-2002 to 04-Feb-2003, when the Delta-18O of precipitation sampled sequentially on an experimental hillslope of WS10, was used (the collector was located on the south aspect, 91 m upstream from the outlet).

Coverage

Temporal coverage: 2000-10-17 to 2003-08-11

Geographic coverage: H. J. Andrews Experimental Forest, Western Cascades, Oregon

Spatial coverage:

Bounds: W -122.26042570, E -122.10268900, N 44.27664500, S 44.19948400

Purpose
  • To examine the temporal dynamics of hillslope and catchment runoff responses using combined hydrometric, isotopic, and applied tracer approaches.
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
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

Oxygen-18 ratios, expressed as Delta-18O or D18O (parts per hundred), measured in WS10 discharge and WS10 precipitation. The time series spans from January 2001 to February 2003, period during which precipitation and streamflow were sampled mostly manually and weekly. The time series also includes some periods of higher frequency automatic sampling in streamflow and precipitation in winter 2001 and winter 2002. The precipitation Delta-18O time series corresponds to the Delta-18O measured at PRIMET station located about 1 km from WS10 outlet at a similar altitude, except from 01-Sep-2002 to 04-Feb-2003, when the Delta-18O of precipitation sampled sequentially on an experimental hillslope of WS10, was used (the collector was located on the south aspect, 91 m upstream from the outlet). To examine the temporal dynamics of hillslope and catchment runoff responses using combined hydrometric, isotopic, and applied tracer approaches. Field Methods - HF024

Purpose: To examine the temporal dynamics of hillslope and catchment runoff responses using combined hydrometric, isotopic, and applied tracer approaches.

Methods

Method Steps

Field Methods - HF024
  • Discharge was measured from the trench from 1 September 2002 to 21 January 2003 and thereafter predicted using regression with WS10 discharge due to gauge failure. Precipitation was measured with a tipping bucket (15.39 cm diameter orifice, 0.2 mm resolution) and storage gauge (8.9 cm diameter orifice) observed on an event basis in a small canopy opening on the hillslope. The drainage area of the hillslope was delineated from a total station topographic survey of the entire hillslope (0.2 ha) and verified by a water balance calculation (i.e., compared similarly to the WS10 balance).
  • Precipitation samples were collected weekly from January 2000 to February 2003 (~1130 day period) in bulk collectors at two locations that coincided with a low (PRIMET, 430 m) and high (Hi-15, 922 m) elevation meteorological station. Precipitation samplers consisted of plastic funnels with drainage tubing attached to plastic bottles. To minimize evaporation, water traps were created by looping drainage tubes and protecting collection bottles in either a climate controlled shelter (Hi-15) or by burying the bottle beneath the soil surface below a small insulated shelter (PRIMET). Precipitation rates were determined using heated tipping bucket rain gauges at each station as part of HJA long-term data collection. Snowmelt sampling occurred weekly at Hi-15 during the 2001–2002 winter using a 0.25 m2 snow lysimeter that drained into a heated shelter to prevent the samples from freezing. Snowmelt rates were measured using tipping buckets (0.025 mm per tip) and a 5.52 m2 lysimeter. A network of small bulk rainfall collectors (N = 38) were used to assess input variations across the large basin scale for 3 rain storms in fall 2002. Seven stream sites (WS02, WS03, WS08, WS09, WS10, MACK, and LOOK) were sampled weekly (generally on the same day as precipitation sample collection).
  • Two line source tracers were applied to the hillslope immediately before a large winter rainstorm (66 mm, 49 h duration) that began on 9 December 2002 at 21:30 [see McGuire et al., 2007]. 20.9 g of amino G acid monopotassium salt (AGA), a fluorescent dye [Smart and Laidlaw, 1977], and 4.0 kg of bromide (as LiBr solution) were applied 19 and 33 m from the trench, respectively. Both tracers were monitored continuously at the trench for the first 9 days of the experiment. AGA was monitored using a field fluorometer (10-AU, Turner Designs, Inc., Sunnyvale, CA) equipped with along wavelength optical kit, temperature compensation, flow-through cell, and data logger. Bromide was also measured in situ with an ion-selective electrode for Br- (TempHion®, Instrumentation Northwest, Inc.) until 31 March 2003. Grab sampling extended the AGA breakthrough for 100 days and it provided additional samples for calibrating the Br- selective electrode (N = 107, R2 = 0.99). Both tracers were monitored until concentrations during storm events were at background levels (~100 days).
  • Oxygen-18 (18O) samples were collected weekly at the hillslope trench (1 November 2001 to 11 February 2003), WS10 (13 February 2001 to 4 February 2003), and as bulk precipitation (1 January 2000 to 11 February 2003). Soil water samples from the lysimeters were collected at time intervals between daily and weekly from 2 October 2002 until 11 February 2003. Storm samples were collected between 2 and 4 h intervals from the hillslope and WS10 for several storms during the fall 2002 to winter 2003 period. Rainfall was sampled sequentially (4.4 mm increments) over this period for 18O using samplers as described by Kennedy et al. [1979].
Laboratory Methods - HF024
  • Precipitation samples collected prior to October 2000 were analyzed at the Colorado State University facility for Mass Spectrometry and after October 2000, at the USGS Stable Isotope Laboratory in Menlo Park, California for oxygen-18 composition (d18O) using an automated version of the CO2–H2O equilibration technique of Epstein and Mayeda [1953]. The d18O values are reported in per mil (0/00) relative to a standard as d18O = (Rx/Rs-1)x1000, where Rx and Rs are the 18O/16O ratios for the sample and standard (VSMOW), respectively. The analytical precision was 0.11% based on submitted blind duplicate samples.

Instrumentation:

  • Mass Spectrometry or an automated version of the CO2–H2O equilibration technique of Epstein and Mayeda [1953]

Sampling

Study Extent
  • WS10 outlet, WS10 experimental hillslope, PRIMET station
  • Sampling frequency: Irregular. From hourly to weekly.
Sampling Description
  • The hillslope study area was located on the south aspect of WS10, 91 m upstream from the stream gauging station. This site was reestablished from early 1970s era benchmark studies [Harr and Ranken, 1972; Harr, 1977; Sollins and McCorison, 1981; Sollins et al., 1981]. The slope is representative of the two main planar hillslopes that compose the overall v-shaped catchment (WS10). The 125 m long stream-to-ridge slope is slightly convex and its gradient averages 37°, ranging from 27° near the ridge to 48° adjacent to the stream. Elevation ranges from 480 to 565 m.
  • A 10 m long trench was constructed to measure subsurface throughflow at the location of a seep that had been previously gauged in the early to mid-1970s [Harr, 1977; Triska et al., 1984]. The trench was constructed by intercepting subsurface water from a natural seepage face, which was routed to a calibrated 15 degree V notch weir that recorded stage at 10 min time intervals using a 1 mm resolution capacitance water level recorder (TruTrack, Inc., model WT-HR).
  • Precipitation samples were collected weekly from January 2000 to February 2003 (about 1130 day period) in bulk collectors at two locations that coincided with a low (PRIMET, 430 m) and high (H15MET, 922 m) elevation meteorological station.
  • Citation:
  • Harr, R. D., and D. W. Ranken (1972), Movement of water through forested soils in steep topography, Coniferous For. Biome Internal Rep. 117, 19 pp., Univ. of Wash., Seattle.
  • Harr, R. D. (1977), Water flux in soil and subsoil on a steep forested slope, J. Hydrol., 33(1–2), 37–58, doi:10.1016/0022-1694(77)90097-X.
  • Sollins, P., and F. M. McCorison (1981), Nitrogen and carbon solution chemistry of an old growth coniferous forest watershed before and after cutting, Water Resour. Res., 17(5), 1409–1418, doi:10.1029/ WR017i005p01409.
  • Sollins, P., K. J. Cromack, F. M. McCorison, R. H. Waring, and R. D. Harr (1981), Changes in nitrogen cycling at an old-growth Douglas-fir site after disturbance, J. Environ. Qual., 10, 37–42, doi:10.2134/ jeq1981.00472425001000010007x.
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 10
    W -122.25996600, E -122.25443900, N 44.22015200, S 44.21678600
    Altitude: 679 to 679 meter
  • Andrews Lookout Creek Gaging Station
    W -122.25714600, E -122.25714600, N 44.21012600, S 44.21012600
    Altitude: 422 to 422 meter
  • Andrews Mack Creek Gaging Station
    W -122.16744700, E -122.16744700, N 44.21943621, S 44.21943621
    Altitude: 755 to 755 meter
  • Andrews Watershed 1 Gaging Station
    W -122.25802700, E -122.25802700, N 44.20733900, S 44.20733900
    Altitude: 439 to 439 meter
  • Andrews Watershed 2 Gaging Station
    W -122.24487600, E -122.24487600, N 44.21201500, S 44.21201500
    Altitude: 545 to 545 meter
  • Andrews Watershed 3 Gaging Station
    W -122.24300000, E -122.24300000, N 44.21944000, S 44.21944000
    Altitude: 471 to 471 meter
  • Andrews Watershed 6 Gaging Station
    W -122.18070700, E -122.18070700, N 44.26150800, S 44.26150800
    Altitude: 878 to 878 meter
  • Andrews Watershed 7 Gaging Station
    W -122.17526500, E -122.17526500, N 44.26463700, S 44.26463700
    Altitude: 918 to 918 meter
  • Andrews Watershed 8 Gaging Station
    W -122.17079300, E -122.17079300, N 44.26629426, S 44.26629426
    Altitude: 962 to 962 meter
  • Andrews Watershed 9 Gaging Station
    W -122.25880100, E -122.25880100, N 44.20119000, S 44.20119000
    Altitude: 426 to 426 meter
  • Andrews Watershed 10 Gaging Station
    W -122.26105600, E -122.26105600, N 44.21705700, S 44.21705700
    Altitude: 461 to 461 meter
  • High 15 Meteorological Station
    W -122.17378247, E -122.17378247, N 44.26425069, S 44.26425069
    Altitude: 909 to 909 meter
  • Primary Meteorological Station
    W -122.25594100, E -122.25594100, N 44.21189300, S 44.21189300
    Altitude: 436 to 436 meter
  • Watershed 10 (WS10) hillslope throughflow weir
    W -122.26024700, E -122.26024700, N 44.21773400, S 44.21773400
    Altitude: 498 to 498 meter
  • Watershed 10 (WS10) landslide hollow (trib from SE)
    W -122.25805600, E -122.25805600, N 44.21805556, S 44.21805556
    Altitude: 570 to 570 meter
  • Watershed 10 (WS10) main channel above confluence
    W -122.25722200, E -122.25722200, N 44.21788889, S 44.21788889
    Altitude: 520 to 520 meter
  • Watershed 10 (WS10) McGuire's tipping bucket rain gauge
    W -122.26042570, E -122.26042570, N 44.21751927, S 44.21751927
    Altitude: 481 to 481 meter
  • McGuire rainfall network site 01
    W -122.25465700, E -122.25465700, N 44.21010300, S 44.21010300
    Altitude: 468 to 468 meter
  • McGuire rainfall network site 02
    W -122.25504100, E -122.25504100, N 44.21795600, S 44.21795600
    Altitude: 590 to 590 meter
  • McGuire rainfall network site 03
    W -122.22381600, E -122.22381600, N 44.23593400, S 44.23593400
    Altitude: 717 to 717 meter
  • McGuire rainfall network site 04
    W -122.23843800, E -122.23843800, N 44.22775000, S 44.22775000
    Altitude: 631 to 631 meter
  • McGuire rainfall network site 05
    W -122.25925100, E -122.25925100, N 44.21565200, S 44.21565200
    Altitude: 555 to 555 meter
  • McGuire rainfall network site 06
    W -122.24740700, E -122.24740700, N 44.21291800, S 44.21291800
    Altitude: 532 to 532 meter
  • McGuire rainfall network site 07
    W -122.22978800, E -122.22978800, N 44.21239600, S 44.21239600
    Altitude: 857 to 857 meter
  • McGuire rainfall network site 08
    W -122.21739300, E -122.21739300, N 44.21542700, S 44.21542700
    Altitude: 932 to 932 meter
  • McGuire rainfall network site 09
    W -122.16484400, E -122.16484400, N 44.20378200, S 44.20378200
    Altitude: 1262 to 1262 meter
  • McGuire rainfall network site 10
    W -122.13751100, E -122.13751100, N 44.20238200, S 44.20238200
    Altitude: 1215 to 1215 meter
  • McGuire rainfall network site 11
    W -122.18977600, E -122.18977600, N 44.21555800, S 44.21555800
    Altitude: 1249 to 1249 meter
  • McGuire rainfall network site 12
    W -122.22654000, E -122.22654000, N 44.22458200, S 44.22458200
    Altitude: 610 to 610 meter
  • McGuire rainfall network site 13
    W -122.21670800, E -122.21670800, N 44.22935900, S 44.22935900
    Altitude: 535 to 535 meter
  • McGuire rainfall network site 14
    W -122.23916700, E -122.23916700, N 44.20029500, S 44.20029500
    Altitude: 847 to 847 meter
  • McGuire rainfall network site 15
    W -122.25820100, E -122.25820100, N 44.19948400, S 44.19948400
    Altitude: 434 to 434 meter
  • McGuire rainfall network site 16
    W -122.19752400, E -122.19752400, N 44.22970300, S 44.22970300
    Altitude: 676 to 676 meter
  • McGuire rainfall network site 17
    W -122.11834500, E -122.11834500, N 44.20532400, S 44.20532400
    Altitude: 1338 to 1338 meter
  • McGuire rainfall network site 18
    W -122.10268900, E -122.10268900, N 44.21617700, S 44.21617700
    Altitude: 1552 to 1552 meter
  • McGuire rainfall network site 19
    W -122.10838400, E -122.10838400, N 44.23281400, S 44.23281400
    Altitude: 1423 to 1423 meter
  • McGuire rainfall network site 20
    W -122.13087100, E -122.13087100, N 44.25184000, S 44.25184000
    Altitude: 1416 to 1416 meter
  • McGuire rainfall network site 21
    W -122.12676100, E -122.12676100, N 44.22923800, S 44.22923800
    Altitude: 948 to 948 meter
  • McGuire rainfall network site 22
    W -122.15295600, E -122.15295600, N 44.23889700, S 44.23889700
    Altitude: 908 to 908 meter
  • McGuire rainfall network site 23
    W -122.14056300, E -122.14056300, N 44.24101900, S 44.24101900
    Altitude: 1041 to 1041 meter
  • McGuire rainfall network site 24
    W -122.15171500, E -122.15171500, N 44.24586500, S 44.24586500
    Altitude: 1023 to 1023 meter
  • McGuire rainfall network site 25
    W -122.14771700, E -122.14771700, N 44.26881100, S 44.26881100
    Altitude: 1142 to 1142 meter
  • McGuire rainfall network site 26
    W -122.13847000, E -122.13847000, N 44.27074100, S 44.27074100
    Altitude: 1268 to 1268 meter
  • McGuire rainfall network site 27
    W -122.14419800, E -122.14419800, N 44.27664500, S 44.27664500
    Altitude: 1380 to 1380 meter
  • McGuire rainfall network site 28
    W -122.18124100, E -122.18124100, N 44.23009100, S 44.23009100
    Altitude: 640 to 640 meter
  • McGuire rainfall network site 29
    W -122.24087100, E -122.24087100, N 44.21701600, S 44.21701600
    Altitude: 582 to 582 meter
  • McGuire rainfall network site 30
    W -122.18342200, E -122.18342200, N 44.26191500, S 44.26191500
    Altitude: 927 to 927 meter
  • McGuire rainfall network site 31
    W -122.17262700, E -122.17262700, N 44.26234100, S 44.26234100
    Altitude: 908 to 908 meter
  • McGuire rainfall network site 32
    W -122.17118200, E -122.17118200, N 44.25689300, S 44.25689300
    Altitude: 857 to 857 meter
  • McGuire rainfall network site 33
    W -122.15914300, E -122.15914300, N 44.25799300, S 44.25799300
    Altitude: 968 to 968 meter
  • McGuire rainfall network site 34
    W -122.18315400, E -122.18315400, N 44.25228900, S 44.25228900
    Altitude: 789 to 789 meter
  • McGuire rainfall network site 35
    W -122.20010700, E -122.20010700, N 44.24057900, S 44.24057900
    Altitude: 613 to 613 meter
  • McGuire rainfall network site 36
    W -122.17282100, E -122.17282100, N 44.22452100, S 44.22452100
    Altitude: 836 to 836 meter
  • McGuire rainfall network site 37
    W -122.16569500, E -122.16569500, N 44.21786100, S 44.21786100
    Altitude: 790 to 790 meter
  • McGuire rainfall network site 38
    W -122.16265900, E -122.16265900, N 44.22183600, S 44.22183600
    Altitude: 890 to 890 meter
  • McGuire WS10 Soil Pit 1
    W -122.26036920, E -122.26036920, N 44.21756194, S 44.21756194
  • McGuire WS10 Soil Pit 2
    W -122.26032990, E -122.26032990, N 44.21762390, S 44.21762390
  • McGuire WS10 Soil Pit 3
    W -122.26026190, E -122.26026190, N 44.21766469, S 44.21766469
  • McGuire WS10 tension lysimeter nest A2
    W -122.26016670, E -122.26016670, N 44.21758333, S 44.21758333
  • McGuire WS10 tension lysimeter nest A1
    W -122.26022220, E -122.26022220, N 44.21758333, S 44.21758333
  • McGuire WS10 tension lysimeter nest B
    W -122.26027780, E -122.26027780, N 44.21763889, S 44.21763889
  • McGuire WS10 tension lysimeter nest C
    W -122.26000000, E -122.26000000, N 44.21750000, S 44.21750000
  • McGuire WS10 tension lysimeter nest D
    W -122.26000000, E -122.26000000, N 44.21777778, S 44.21777778
  • McGuire WS10 tension lysimeter nest UP1 and UP2
    W -122.25888890, E -122.25888890, N 44.21805556, S 44.21805556
    Altitude: 526 to 526 meter
  • McGuire WS10 tension lysimeter nest UP3 and UP4
    W -122.25916670, E -122.25916670, N 44.21777778, S 44.21777778
    Altitude: 517 to 517 meter
  • Andrews Lookout Creek Watershed
    W -122.25879300, E -122.09952700, N 44.28226000, S 44.20127400
    Altitude: 1627 to 1627 meter
  • Andrews Mack Creek Watershed
    W -122.17282200, E -122.12699600, N 44.22054300, S 44.20148000
    Altitude: 1626 to 1626 meter
  • McRae Creek
    W -122.20859020, E -122.13943300, N 44.27311600, S 44.23328700
  • Upper Lookout Creek
    W -122.16810500, E -122.12601600, N 44.23402900, S 44.22757500
    Altitude: 998 to 998 meter
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: tracers (theme), disturbance (theme), streamflow (theme), inorganic nutrients (theme), dissolved oxygen (theme), isotopes (theme), streams (theme)
  • LTER core research areas: disturbance (theme), inorganic nutrients (theme)
Taxonomic Hierarchy

No taxonomic hierarchy listed in this EML file.

Data Entities
# Entity Metadata Data
1 HF02401
HF02401
Water isotope data (Oxygen-18) for streams, seeps, bulk rainfall, bulk snowmelt across the HJA:
 METADATA DATA
2 HF02402
HF02402
Daily Water isotope (Oxygen-18) composition based on sequentially sampled rainfall (~5mm increments) at PRIMET:
 METADATA DATA
3 HF02403
HF02403
Amino G acid tracer breakthrough collected from WS10 hillslope trench and main gauge:
 METADATA DATA
4 HF02404
HF02404
Major ion chemistry from stream gauges WS02, WS09, WS10, and soil water in WS10:
 METADATA DATA
5 HF02405
HF02405
Water isotope data (Oxygen-18) and rainfall from rain gauge network across the HJA:
 METADATA DATA
6 HF02406
HF02406
Dissolved silica from stream gauges WS09, WS10, and soil water in WS10:
 METADATA DATA
7 HF02407
HF02407
Rainfall, specific conductance, and water temperature from WS10 hillslope weir and WS10 main weir: Rainfall depth is calculated from the nearby tipping bucket (entity 12) binned to 10 minute intervals
 METADATA DATA
8 HF02408
HF02408
Soil moisture from Campbell CS 615s on hillslope in 3 soil pits:
 METADATA DATA
9 HF02409
HF02409
WS10 hillslope discharge data:
 METADATA DATA
10 HF02410
HF02410
Water isotope data (Oxygen-18) of synoptic sampling in major tributaries and streams in HJA, Blue River and McKenzie basins: See synoptic sampling map in related materials for sample locations
 METADATA DATA
11 HF02411
HF02411
Bromide tracer breakthrough with water temperature, specific conductance, discharge and rainfall collected from WS10 hillslope trench: Rainfall depth is calculated from the nearby tipping bucket (entity 12) binned to 10 minute intervals
 METADATA DATA
12 HF02412
HF02412
Raw tipping bucket data from WS10 hillslope: Each record represents the datetime of one tip
 METADATA DATA
Metadata
HF02401 - HF02401

Object name: HF02401.csv

Records: 1967

Attributes: 11

Temporal coverage: 2000-10-17 to 2003-02-05

File size: 154113 byte

Checksum (MD5): b0785b946a2f5587401f2c8a0ab97c5e

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

Constraints (2)
  • primaryKey: PRIMARY
    HF02401.COLLECTION_METHOD, HF02401.DATETIME, HF02401.SAMPLE_TYPE, HF02401.SITE, HF02401.SAMPLE_REP
  • notNullConstraint: NOTNULL
    HF02401.COLLECTION_METHOD, HF02401.D18O, HF02401.DATETIME, HF02401.DBCODE, HF02401.ENTITY, HF02401.LABID, HF02401.SAMPLE_ID, HF02401.SAMPLE_TYPE, HF02401.SITE, HF02401.TIME_FLAG, HF02401.SAMPLE_REP
Attributes (11)
DBCODE - char(5) (nominal)

ID: HF02401.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: HF02401.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)

SITE - char(10) (nominal)

ID: HF02401.SITE

Site location

Type system: Microsoft SQL Server 2008

Code definitions (26)
  • GSWS01
    Andrews Watershed 1 Gaging Station
  • GSWS02
    Andrews Watershed 2 Gaging Station
  • GSWS03
    Andrews Watershed 3 Gaging Station
  • GSWS06
    Andrews Watershed 6 Gaging Station
  • GSWS07
    Andrews Watershed 7 Gaging Station
  • GSWS08
    Andrews Watershed 8 Gaging Station
  • GSWS09
    Andrews Watershed 9 Gaging Station
  • GSWS10
    Andrews Watershed 10 Gaging Station
  • GSMACK
    Andrews Mack Creek Gaging Station
  • GSLOOK
    Andrews Lookout Creek Gaging Station
  • PRIMET
    Primary Meteorological Station
  • H15MET
    High 15 Meteorological Station
  • WS10S1
    Watershed 10 (WS10) hillslope throughflow weir
  • WS10S2
    Watershed 10 (WS10) landslide hollow (trib from SE)
  • WS10S3
    Watershed 10 (WS10) main channel above confluence
  • WS10TB
    Watershed 10 (WS10) McGuire's tipping bucket rain gauge
  • WS10P1
    McGuire WS10 Soil Pit 1
  • WS10P2
    McGuire WS10 Soil Pit 2
  • WS10P3
    McGuire WS10 Soil Pit 3
  • WS10A2
    McGuire WS10 tension lysimeter nest A2
  • WS10A1
    McGuire WS10 tension lysimeter nest A1
  • WS10B1
    McGuire WS10 tension lysimeter nest B
  • WS10C1
    McGuire WS10 tension lysimeter nest C
  • WS10D1
    McGuire WS10 tension lysimeter nest D
  • WS10UP12
    McGuire WS10 tension lysimeter nest UP1 and UP2
  • WS10UP34
    McGuire WS10 tension lysimeter nest UP3 and UP4
SAMPLE_TYPE - varchar(20) (nominal)

ID: HF02401.SAMPLE_TYPE

Type of water sample

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • surface
    stream surface water
  • precip
    precipitation captured in sampling gauge
  • snow
    snowmelt from lysimeter
  • through
    seep/throughflow from hillslope
  • ground
    ground water from well or piezometer
COLLECTION_METHOD - char(4) (nominal)

ID: HF02401.COLLECTION_METHOD

Method of sample collection

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • grab
    grab sample from stream
  • bulk
    bulk sample
  • auto
    collected using an auto sampler or instrument
DATETIME - datetime (dateTime)

ID: HF02401.DATETIME

Date and time of sample collection

Type system: Microsoft SQL Server 2008

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

D18O - numeric(6,2) (ratio)

ID: HF02401.D18O

Oxygen-18 composition of water sample

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-16.8900 (exclusive=false), max=-4.0000 (exclusive=false)

SAMPLE_ID - numeric(4,0) (ratio)

ID: HF02401.SAMPLE_ID

Sample ID for McGuire database

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

LABID - char(7) (ordinal)

ID: HF02401.LABID

Lab ID for USGS, Menlo Park

Type system: Microsoft SQL Server 2008

TIME_FLAG - char(1) (nominal)

ID: HF02401.TIME_FLAG

Qualifying flag for time of measurement

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • A
    Actual time recorded in data
  • E
    No time recorded in data, so time guessed or estimated based on data for the site and year of collection
SAMPLE_REP - char(1) (nominal)

ID: HF02401.SAMPLE_REP

Replicated sample taken at same datetime as another

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • 1
    First sample for a given sample datetime
  • 2
    Second (replicate) sample for a given sample datetime
HF02402 - HF02402

Object name: HF02402.csv

Records: 157

Attributes: 6

Temporal coverage: 2002-09-01 to 2003-02-04

File size: 6409 byte

Checksum (MD5): 4591bf5fe2baff551215d0fc2cdcd480

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

Constraints (2)
  • primaryKey: PRIMARY
    HF02402.SAMPLEDATE, HF02402.SITE
  • notNullConstraint: NOTNULL
    HF02402.D18O, HF02402.DBCODE, HF02402.ENTITY, HF02402.RAINFALL, HF02402.SAMPLEDATE, HF02402.SITE
Attributes (6)
DBCODE - char(5) (nominal)

ID: HF02402.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: HF02402.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)

SITE - char(10) (nominal)

ID: HF02402.SITE

Site location

Type system: Microsoft SQL Server 2008

Code definitions (26)
  • GSWS01
    Andrews Watershed 1 Gaging Station
  • GSWS02
    Andrews Watershed 2 Gaging Station
  • GSWS03
    Andrews Watershed 3 Gaging Station
  • GSWS06
    Andrews Watershed 6 Gaging Station
  • GSWS07
    Andrews Watershed 7 Gaging Station
  • GSWS08
    Andrews Watershed 8 Gaging Station
  • GSWS09
    Andrews Watershed 9 Gaging Station
  • GSWS10
    Andrews Watershed 10 Gaging Station
  • GSMACK
    Andrews Mack Creek Gaging Station
  • GSLOOK
    Andrews Lookout Creek Gaging Station
  • PRIMET
    Primary Meteorological Station
  • H15MET
    High 15 Meteorological Station
  • WS10S1
    Watershed 10 (WS10) hillslope throughflow weir
  • WS10S2
    Watershed 10 (WS10) landslide hollow (trib from SE)
  • WS10S3
    Watershed 10 (WS10) main channel above confluence
  • WS10TB
    Watershed 10 (WS10) McGuire's tipping bucket rain gauge
  • WS10P1
    McGuire WS10 Soil Pit 1
  • WS10P2
    McGuire WS10 Soil Pit 2
  • WS10P3
    McGuire WS10 Soil Pit 3
  • WS10A2
    McGuire WS10 tension lysimeter nest A2
  • WS10A1
    McGuire WS10 tension lysimeter nest A1
  • WS10B1
    McGuire WS10 tension lysimeter nest B
  • WS10C1
    McGuire WS10 tension lysimeter nest C
  • WS10D1
    McGuire WS10 tension lysimeter nest D
  • WS10UP12
    McGuire WS10 tension lysimeter nest UP1 and UP2
  • WS10UP34
    McGuire WS10 tension lysimeter nest UP3 and UP4
SAMPLEDATE - datetime (dateTime)

ID: HF02402.SAMPLEDATE

Date of sample collection

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

RAINFALL - numeric(5,2) (ratio)

ID: HF02402.RAINFALL

Rainfall depth derived based on the number of 5mm rainfall samples collected

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

Numeric domain: type=real, min=0.0000 (exclusive=false), max=76.4500 (exclusive=false)

D18O - numeric(6,2) (ratio)

ID: HF02402.D18O

Oxygen-18 composition of water sample

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-18.7400 (exclusive=false), max=-5.0600 (exclusive=false)

HF02403 - HF02403

Object name: HF02403.csv

Records: 6973

Attributes: 8

Temporal coverage: 2002-12-09 to 2003-02-04

File size: 442922 byte

Checksum (MD5): efae74b955f03c752faadedf873464c1

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

Constraints (2)
  • primaryKey: PRIMARY
    HF02403.DATETIME, HF02403.SITE, HF02403.TIME
  • notNullConstraint: NOTNULL
    HF02403.DATETIME, HF02403.DBCODE, HF02403.DISCHARGE, HF02403.ENTITY, HF02403.SITE, HF02403.TIME
Attributes (8)
DBCODE - char(5) (nominal)

ID: HF02403.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: HF02403.ENTITY

Entity Number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITE - char(10) (nominal)

ID: HF02403.SITE

Site location

Type system: Microsoft SQL Server 2008

Code definitions (26)
  • GSWS01
    Andrews Watershed 1 Gaging Station
  • GSWS02
    Andrews Watershed 2 Gaging Station
  • GSWS03
    Andrews Watershed 3 Gaging Station
  • GSWS06
    Andrews Watershed 6 Gaging Station
  • GSWS07
    Andrews Watershed 7 Gaging Station
  • GSWS08
    Andrews Watershed 8 Gaging Station
  • GSWS09
    Andrews Watershed 9 Gaging Station
  • GSWS10
    Andrews Watershed 10 Gaging Station
  • GSMACK
    Andrews Mack Creek Gaging Station
  • GSLOOK
    Andrews Lookout Creek Gaging Station
  • PRIMET
    Primary Meteorological Station
  • H15MET
    High 15 Meteorological Station
  • WS10S1
    Watershed 10 (WS10) hillslope throughflow weir
  • WS10S2
    Watershed 10 (WS10) landslide hollow (trib from SE)
  • WS10S3
    Watershed 10 (WS10) main channel above confluence
  • WS10TB
    Watershed 10 (WS10) McGuire's tipping bucket rain gauge
  • WS10P1
    McGuire WS10 Soil Pit 1
  • WS10P2
    McGuire WS10 Soil Pit 2
  • WS10P3
    McGuire WS10 Soil Pit 3
  • WS10A2
    McGuire WS10 tension lysimeter nest A2
  • WS10A1
    McGuire WS10 tension lysimeter nest A1
  • WS10B1
    McGuire WS10 tension lysimeter nest B
  • WS10C1
    McGuire WS10 tension lysimeter nest C
  • WS10D1
    McGuire WS10 tension lysimeter nest D
  • WS10UP12
    McGuire WS10 tension lysimeter nest UP1 and UP2
  • WS10UP34
    McGuire WS10 tension lysimeter nest UP3 and UP4
COLLECTION_METHOD - char(4) (nominal)

ID: HF02403.COLLECTION_METHOD

Method of sample collection

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • grab
    grab sample from stream
  • bulk
    bulk sample
  • auto
    collected using an auto sampler or instrument
DATETIME - datetime (dateTime)

ID: HF02403.DATETIME

Date and time of sample collection

Type system: Microsoft SQL Server 2008

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

TIME - numeric(6,1) (ratio)

ID: HF02403.TIME

Time from start of experiment (12/9/2002 10:30)

Type system: Microsoft SQL Server 2008

Unit: number of hours

Precision: 1

Numeric domain: type=real, min=4.5000 (exclusive=false), max=1362.5000 (exclusive=false)

AGA - numeric(5,2) (ratio)

ID: HF02403.AGA

Amino G acid monopotassium salt (AGA) measured at hillslope weir

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

Numeric domain: type=real, min=1.0600 (exclusive=false), max=44.5200 (exclusive=false)

DISCHARGE - numeric(8,6) (ratio)

ID: HF02403.DISCHARGE

Hillslope water discharge from entity 9

Type system: Microsoft SQL Server 2008

Unit: liters per second

Precision: 1

Numeric domain: type=real, min=0.0200 (exclusive=false), max=85.5740 (exclusive=false)

HF02404 - HF02404

Object name: HF02404.csv

Records: 208

Attributes: 16

Temporal coverage: 2002-09-16 to 2002-12-12

File size: 19803 byte

Checksum (MD5): 24d34283a17b91a155e99f22695b6faf

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

Constraints (2)
  • primaryKey: PRIMARY
    HF02404.DATETIME, HF02404.SITE, HF02404.COLLECTION_TYPE
  • notNullConstraint: NOTNULL
    HF02404.DATETIME, HF02404.DBCODE, HF02404.ENTITY, HF02404.SAMPLE_ID, HF02404.SITE, HF02404.NH4CODE, HF02404.NO3CODE, HF02404.COLLECTION_TYPE
Attributes (16)
DBCODE - char(5) (nominal)

ID: HF02404.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: HF02404.ENTITY

Entity Number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITE - char(10) (nominal)

ID: HF02404.SITE

Site location

Type system: Microsoft SQL Server 2008

Code definitions (26)
  • GSWS01
    Andrews Watershed 1 Gaging Station
  • GSWS02
    Andrews Watershed 2 Gaging Station
  • GSWS03
    Andrews Watershed 3 Gaging Station
  • GSWS06
    Andrews Watershed 6 Gaging Station
  • GSWS07
    Andrews Watershed 7 Gaging Station
  • GSWS08
    Andrews Watershed 8 Gaging Station
  • GSWS09
    Andrews Watershed 9 Gaging Station
  • GSWS10
    Andrews Watershed 10 Gaging Station
  • GSMACK
    Andrews Mack Creek Gaging Station
  • GSLOOK
    Andrews Lookout Creek Gaging Station
  • PRIMET
    Primary Meteorological Station
  • H15MET
    High 15 Meteorological Station
  • WS10S1
    Watershed 10 (WS10) hillslope throughflow weir
  • WS10S2
    Watershed 10 (WS10) landslide hollow (trib from SE)
  • WS10S3
    Watershed 10 (WS10) main channel above confluence
  • WS10TB
    Watershed 10 (WS10) McGuire's tipping bucket rain gauge
  • WS10P1
    McGuire WS10 Soil Pit 1
  • WS10P2
    McGuire WS10 Soil Pit 2
  • WS10P3
    McGuire WS10 Soil Pit 3
  • WS10A2
    McGuire WS10 tension lysimeter nest A2
  • WS10A1
    McGuire WS10 tension lysimeter nest A1
  • WS10B1
    McGuire WS10 tension lysimeter nest B
  • WS10C1
    McGuire WS10 tension lysimeter nest C
  • WS10D1
    McGuire WS10 tension lysimeter nest D
  • WS10UP12
    McGuire WS10 tension lysimeter nest UP1 and UP2
  • WS10UP34
    McGuire WS10 tension lysimeter nest UP3 and UP4
COLLECTION_TYPE - char(7) (nominal)

ID: HF02404.COLLECTION_TYPE

Type of sample collection

Type system: Microsoft SQL Server 2008

Code definitions (13)
  • surface
    surface grab sample
  • through
    seep/throughflow
  • ATL30-1
    tension lysimeter in nest A1 at 30 cm depth; lowest of transect (1)
  • ATL32
    tension lysimeter in nest A2 at 32 cm depth
  • ATL70
    tension lysimeter in nest A1 at 70 cm depth; lowest of transect
  • BTL30
    tension lysimeter in nest B at 30 cm depth; middle of transect, 1 m above lower datalogger housing
  • BTL70
    tension lysimeter in nest B at 70 cm depth; middle of transect, 1 m above lower datalogger housing
  • BTL95
    tension lysimeter in nest B at 95 cm depth; middle of transect, 1 m above lower datalogger housing
  • DTL70
    tension lysimeter in nest D at 70 cm depth; middle of transect, highest of transect
  • DTL92
    tension lysimeter in nest D at 90 cm depth; middle of transect, highest of transect
  • TLUP2
    tension lysimeter in UP2 nest at 45 cm depth (214 meters above flume, right bank)
  • TLUP3
    tension lysimeter in UP3 nest at 53 cm depth
  • TLUP4
    tension lysimeter in UP4 nest at 37 cm depth
DATETIME - datetime (dateTime)

ID: HF02404.DATETIME

Date and time of sample collection

Type system: Microsoft SQL Server 2008

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

NA - numeric(5,1) (ratio)

ID: HF02404.NA

Na, dissolved sodium (filtrable) concentration

Type system: Microsoft SQL Server 2008

Unit: microequivalent per liter

Precision: 1

Numeric domain: type=real, min=37.1000 (exclusive=false), max=631.0000 (exclusive=false)

NH4 - numeric(5,2) (ratio)

ID: HF02404.NH4

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

Type system: Microsoft SQL Server 2008

Unit: microequivalent per liter

Precision: 1

Numeric domain: type=real, min=0.9300 (exclusive=false), max=11.3000 (exclusive=false)

NH4CODE - char(1) (nominal)

ID: HF02404.NH4CODE

NH4-N value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • A
    Value within an acceptable range
  • L
    Value below detection limit of less than 0.9 microeq/L
  • H
    Value above quantitation limit of 8.0 microeq/L
K - numeric(5,2) (ratio)

ID: HF02404.K

K, dissolved potassium (filtrable) concentration

Type system: Microsoft SQL Server 2008

Unit: microequivalent per liter

Precision: 1

Numeric domain: type=real, min=0.3500 (exclusive=false), max=115.0000 (exclusive=false)

MG - numeric(6,2) (ratio)

ID: HF02404.MG

Mg, dissolved magnesium (filtrable) concentration

Type system: Microsoft SQL Server 2008

Unit: microequivalent per liter

Precision: 1

Numeric domain: type=real, min=30.1000 (exclusive=false), max=378.0000 (exclusive=false)

CA - numeric(6,1) (ratio)

ID: HF02404.CA

Ca, dissolved calcium (filtrable) concentration

Type system: Microsoft SQL Server 2008

Unit: microequivalent per liter

Precision: 1

Numeric domain: type=real, min=68.4000 (exclusive=false), max=1372.0000 (exclusive=false)

CL - numeric(6,1) (ratio)

ID: HF02404.CL

Chloride (dissolved) concentration

Type system: Microsoft SQL Server 2008

Unit: microequivalent per liter

Precision: 1

Numeric domain: type=real, min=10.9000 (exclusive=false), max=1794.0000 (exclusive=false)

NO3 - numeric(4,2) (ratio)

ID: HF02404.NO3

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

Type system: Microsoft SQL Server 2008

Unit: microequivalent per liter

Precision: 1

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

NO3CODE - char(1) (ordinal)

ID: HF02404.NO3CODE

NO3-N value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • A
    Value within an acceptable range
  • L
    Value below detection limit of less than 0.2 microeq/L
  • H
    Value above quantitation limit of 1.6 microeq/L
SO4 - numeric(5,2) (ratio)

ID: HF02404.SO4

SO4 (dissolved) concentration, sulfate as sulfur

Type system: Microsoft SQL Server 2008

Unit: microequivalent per liter

Precision: 1

Numeric domain: type=real, min=4.4100 (exclusive=false), max=109.0000 (exclusive=false)

SAMPLE_ID - numeric(4,0) (ratio)

ID: HF02404.SAMPLE_ID

Sample ID for McGuire database

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

HF02405 - HF02405

Object name: HF02405.csv

Records: 149

Attributes: 8

Temporal coverage: 2002-09-21 to 2003-08-11

File size: 7699 byte

Checksum (MD5): 8dd317466ef028b432dff0989e178b0b

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

Constraints (2)
  • primaryKey: PRIMARY
    HF02405.DATETIME, HF02405.EVENT, HF02405.RAINGAGE
  • notNullConstraint: NOTNULL
    HF02405.DATETIME, HF02405.DBCODE, HF02405.ENTITY, HF02405.EVENT, HF02405.RAINGAGE
Attributes (8)
DBCODE - char(5) (nominal)

ID: HF02405.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: HF02405.ENTITY

Entity Number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

RAINGAGE - char(4) (nominal)

ID: HF02405.RAINGAGE

Raingage Location

Type system: Microsoft SQL Server 2008

Code definitions (38)
  • RN01
    McGuire rainfall network site 01
  • RN02
    McGuire rainfall network site 02
  • RN03
    McGuire rainfall network site 03
  • RN04
    McGuire rainfall network site 04
  • RN05
    McGuire rainfall network site 05
  • RN06
    McGuire rainfall network site 06
  • RN07
    McGuire rainfall network site 07
  • RN08
    McGuire rainfall network site 08
  • RN09
    McGuire rainfall network site 09
  • RN10
    McGuire rainfall network site 10
  • RN11
    McGuire rainfall network site 11
  • RN12
    McGuire rainfall network site 12
  • RN13
    McGuire rainfall network site 13
  • RN14
    McGuire rainfall network site 14
  • RN15
    McGuire rainfall network site 15
  • RN16
    McGuire rainfall network site 16
  • RN17
    McGuire rainfall network site 17
  • RN18
    McGuire rainfall network site 18
  • RN19
    McGuire rainfall network site 19
  • RN20
    McGuire rainfall network site 20
  • RN21
    McGuire rainfall network site 21
  • RN22
    McGuire rainfall network site 22
  • RN23
    McGuire rainfall network site 23
  • RN24
    McGuire rainfall network site 24
  • RN25
    McGuire rainfall network site 25
  • RN26
    McGuire rainfall network site 26
  • RN27
    McGuire rainfall network site 27
  • RN28
    McGuire rainfall network site 28
  • RN29
    McGuire rainfall network site 29
  • RN30
    McGuire rainfall network site 30
  • RN31
    McGuire rainfall network site 31
  • RN32
    McGuire rainfall network site 32
  • RN33
    McGuire rainfall network site 33
  • RN34
    McGuire rainfall network site 34
  • RN35
    McGuire rainfall network site 35
  • RN36
    McGuire rainfall network site 36
  • RN37
    McGuire rainfall network site 37
  • RN38
    McGuire rainfall network site 38
EVENT - char(1) (nominal)

ID: HF02405.EVENT

Storm Event; time was not noted and 12:00 PM was assumed

Type system: Microsoft SQL Server 2008

Code definitions (4)
  • 1
    storm event 1
  • 2
    storm event 2
  • 3
    storm event 3
  • 4
    storm event 4
DATETIME - datetime (dateTime)

ID: HF02405.DATETIME

Date and time of sample collection

Type system: Microsoft SQL Server 2008

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

RAINFALL_VOL - numeric(3,0) (ratio)

ID: HF02405.RAINFALL_VOL

Total rainfall volume collected in gauge since pervious period

Type system: Microsoft SQL Server 2008

Unit: milliliters

Precision: 1

Numeric domain: type=real, min=26.0000 (exclusive=false), max=540.0000 (exclusive=false)

RAINFALL_DEP - numeric(5,3) (ratio)

ID: HF02405.RAINFALL_DEP

Total rainfall depth collected in gauge since pervious period

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

Numeric domain: type=real, min=3.6000 (exclusive=false), max=75.8000 (exclusive=false)

D18O - numeric(6,2) (ratio)

ID: HF02405.D18O

Oxygen-18 composition of water sample

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-14.1400 (exclusive=false), max=-5.5900 (exclusive=false)

HF02406 - HF02406

Object name: HF02406.csv

Records: 209

Attributes: 7

Temporal coverage: 2002-10-02 to 2002-12-20

File size: 11939 byte

Checksum (MD5): fe033877f2a47975a456deb205532852

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

Constraints (2)
  • primaryKey: PRIMARY
    HF02406.DATETIME, HF02406.SITE
  • notNullConstraint: NOTNULL
    HF02406.DATETIME, HF02406.DBCODE, HF02406.ENTITY, HF02406.SAMPLE_ID, HF02406.SI, HF02406.SITE
Attributes (7)
DBCODE - char(5) (nominal)

ID: HF02406.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: HF02406.ENTITY

Entity Number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITE - char(10) (nominal)

ID: HF02406.SITE

Site location

Type system: Microsoft SQL Server 2008

Code definitions (26)
  • GSWS01
    Andrews Watershed 1 Gaging Station
  • GSWS02
    Andrews Watershed 2 Gaging Station
  • GSWS03
    Andrews Watershed 3 Gaging Station
  • GSWS06
    Andrews Watershed 6 Gaging Station
  • GSWS07
    Andrews Watershed 7 Gaging Station
  • GSWS08
    Andrews Watershed 8 Gaging Station
  • GSWS09
    Andrews Watershed 9 Gaging Station
  • GSWS10
    Andrews Watershed 10 Gaging Station
  • GSMACK
    Andrews Mack Creek Gaging Station
  • GSLOOK
    Andrews Lookout Creek Gaging Station
  • PRIMET
    Primary Meteorological Station
  • H15MET
    High 15 Meteorological Station
  • WS10S1
    Watershed 10 (WS10) hillslope throughflow weir
  • WS10S2
    Watershed 10 (WS10) landslide hollow (trib from SE)
  • WS10S3
    Watershed 10 (WS10) main channel above confluence
  • WS10TB
    Watershed 10 (WS10) McGuire's tipping bucket rain gauge
  • WS10P1
    McGuire WS10 Soil Pit 1
  • WS10P2
    McGuire WS10 Soil Pit 2
  • WS10P3
    McGuire WS10 Soil Pit 3
  • WS10A2
    McGuire WS10 tension lysimeter nest A2
  • WS10A1
    McGuire WS10 tension lysimeter nest A1
  • WS10B1
    McGuire WS10 tension lysimeter nest B
  • WS10C1
    McGuire WS10 tension lysimeter nest C
  • WS10D1
    McGuire WS10 tension lysimeter nest D
  • WS10UP12
    McGuire WS10 tension lysimeter nest UP1 and UP2
  • WS10UP34
    McGuire WS10 tension lysimeter nest UP3 and UP4
COLLECTION_TYPE - char(7) (nominal)

ID: HF02406.COLLECTION_TYPE

Type of sample collection

Type system: Microsoft SQL Server 2008

Code definitions (13)
  • surface
    surface grab sample
  • through
    seep/throughflow
  • ATL30-1
    tension lysimeter in nest A1 at 30 cm depth; lowest of transect (1)
  • ATL32
    tension lysimeter in nest A2 at 32 cm depth
  • ATL70
    tension lysimeter in nest A1 at 70 cm depth; lowest of transect
  • BTL30
    tension lysimeter in nest B at 30 cm depth; middle of transect, 1 m above lower datalogger housing
  • BTL70
    tension lysimeter in nest B at 70 cm depth; middle of transect, 1 m above lower datalogger housing
  • BTL95
    tension lysimeter in nest B at 95 cm depth; middle of transect, 1 m above lower datalogger housing
  • DTL70
    tension lysimeter in nest D at 70 cm depth; middle of transect, highest of transect
  • DTL92
    tension lysimeter in nest D at 90 cm depth; middle of transect, highest of transect
  • TLUP2
    tension lysimeter in UP2 nest at 45 cm depth (214 meters above flume, right bank)
  • TLUP3
    tension lysimeter in UP3 nest at 53 cm depth
  • TLUP4
    tension lysimeter in UP4 nest at 37 cm depth
DATETIME - datetime (dateTime)

ID: HF02406.DATETIME

Date and time of sample collection

Type system: Microsoft SQL Server 2008

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

SI - numeric(3,0) (ratio)

ID: HF02406.SI

Dissolved Silica

Type system: Microsoft SQL Server 2008

Unit: micromoles per liter

Precision: 1

Numeric domain: type=real, min=13.0000 (exclusive=false), max=482.0000 (exclusive=false)

SAMPLE_ID - numeric(4,0) (ratio)

ID: HF02406.SAMPLE_ID

Sample ID for McGuire database

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

HF02407 - HF02407

Object name: HF02407.csv

Records: 86050

Attributes: 7

Temporal coverage: 2002-04-25 to 2003-03-25

File size: 4764917 byte

Checksum (MD5): 70883a8574502356421f7840a1d81580

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

Constraints (2)
  • primaryKey: PRIMARY
    HF02407.DATETIME, HF02407.SITE
  • notNullConstraint: NOTNULL
    HF02407.DATETIME, HF02407.DBCODE, HF02407.ENTITY, HF02407.RAINFALL_DEPTH, HF02407.SITE, HF02407.WATERTEMP
Attributes (7)
DBCODE - char(5) (nominal)

ID: HF02407.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: HF02407.ENTITY

Entity Number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITE - char(10) (nominal)

ID: HF02407.SITE

Site location

Type system: Microsoft SQL Server 2008

Code definitions (26)
  • GSWS01
    Andrews Watershed 1 Gaging Station
  • GSWS02
    Andrews Watershed 2 Gaging Station
  • GSWS03
    Andrews Watershed 3 Gaging Station
  • GSWS06
    Andrews Watershed 6 Gaging Station
  • GSWS07
    Andrews Watershed 7 Gaging Station
  • GSWS08
    Andrews Watershed 8 Gaging Station
  • GSWS09
    Andrews Watershed 9 Gaging Station
  • GSWS10
    Andrews Watershed 10 Gaging Station
  • GSMACK
    Andrews Mack Creek Gaging Station
  • GSLOOK
    Andrews Lookout Creek Gaging Station
  • PRIMET
    Primary Meteorological Station
  • H15MET
    High 15 Meteorological Station
  • WS10S1
    Watershed 10 (WS10) hillslope throughflow weir
  • WS10S2
    Watershed 10 (WS10) landslide hollow (trib from SE)
  • WS10S3
    Watershed 10 (WS10) main channel above confluence
  • WS10TB
    Watershed 10 (WS10) McGuire's tipping bucket rain gauge
  • WS10P1
    McGuire WS10 Soil Pit 1
  • WS10P2
    McGuire WS10 Soil Pit 2
  • WS10P3
    McGuire WS10 Soil Pit 3
  • WS10A2
    McGuire WS10 tension lysimeter nest A2
  • WS10A1
    McGuire WS10 tension lysimeter nest A1
  • WS10B1
    McGuire WS10 tension lysimeter nest B
  • WS10C1
    McGuire WS10 tension lysimeter nest C
  • WS10D1
    McGuire WS10 tension lysimeter nest D
  • WS10UP12
    McGuire WS10 tension lysimeter nest UP1 and UP2
  • WS10UP34
    McGuire WS10 tension lysimeter nest UP3 and UP4
DATETIME - datetime (dateTime)

ID: HF02407.DATETIME

Date and time of sample collection

Type system: Microsoft SQL Server 2008

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

RAINFALL_DEPTH - numeric(5,3) (ratio)

ID: HF02407.RAINFALL_DEPTH

Rainfall depth measured by tipping bucket on hillslope (entity 12) binned to 10 minute intervals

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

Numeric domain: type=real, min=0.2540 (exclusive=false), max=2.2860 (exclusive=false)

EC - numeric(6,4) (ratio)

ID: HF02407.EC

Hillslope water specific conductance

Type system: Microsoft SQL Server 2008

Unit: milli Siemens per centimeter

Precision: 1

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

WATERTEMP - numeric(4,1) (ratio)

ID: HF02407.WATERTEMP

Hillslope water temperature

Type system: Microsoft SQL Server 2008

Unit: degrees Celsius

Precision: 1

Numeric domain: type=real, min=0.2000 (exclusive=false), max=24.9000 (exclusive=false)

HF02408 - HF02408

Object name: HF02408.csv

Records: 416025

Attributes: 6

Temporal coverage: 2002-04-24 to 2003-03-11

File size: 19691888 byte

Checksum (MD5): 3f176659d363bad053a5f507b5653a5e

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

Constraints (2)
  • primaryKey: PRIMARY
    HF02408.DATETIME, HF02408.DEPTH, HF02408.SITE
  • notNullConstraint: NOTNULL
    HF02408.DATETIME, HF02408.DBCODE, HF02408.DEPTH, HF02408.ENTITY, HF02408.SITE, HF02408.SM
Attributes (6)
DBCODE - char(5) (nominal)

ID: HF02408.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: HF02408.ENTITY

Entity Number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITE - char(10) (nominal)

ID: HF02408.SITE

Site location

Type system: Microsoft SQL Server 2008

Code definitions (26)
  • GSWS01
    Andrews Watershed 1 Gaging Station
  • GSWS02
    Andrews Watershed 2 Gaging Station
  • GSWS03
    Andrews Watershed 3 Gaging Station
  • GSWS06
    Andrews Watershed 6 Gaging Station
  • GSWS07
    Andrews Watershed 7 Gaging Station
  • GSWS08
    Andrews Watershed 8 Gaging Station
  • GSWS09
    Andrews Watershed 9 Gaging Station
  • GSWS10
    Andrews Watershed 10 Gaging Station
  • GSMACK
    Andrews Mack Creek Gaging Station
  • GSLOOK
    Andrews Lookout Creek Gaging Station
  • PRIMET
    Primary Meteorological Station
  • H15MET
    High 15 Meteorological Station
  • WS10S1
    Watershed 10 (WS10) hillslope throughflow weir
  • WS10S2
    Watershed 10 (WS10) landslide hollow (trib from SE)
  • WS10S3
    Watershed 10 (WS10) main channel above confluence
  • WS10TB
    Watershed 10 (WS10) McGuire's tipping bucket rain gauge
  • WS10P1
    McGuire WS10 Soil Pit 1
  • WS10P2
    McGuire WS10 Soil Pit 2
  • WS10P3
    McGuire WS10 Soil Pit 3
  • WS10A2
    McGuire WS10 tension lysimeter nest A2
  • WS10A1
    McGuire WS10 tension lysimeter nest A1
  • WS10B1
    McGuire WS10 tension lysimeter nest B
  • WS10C1
    McGuire WS10 tension lysimeter nest C
  • WS10D1
    McGuire WS10 tension lysimeter nest D
  • WS10UP12
    McGuire WS10 tension lysimeter nest UP1 and UP2
  • WS10UP34
    McGuire WS10 tension lysimeter nest UP3 and UP4
DATETIME - datetime (dateTime)

ID: HF02408.DATETIME

Date and time of sample collection

Type system: Microsoft SQL Server 2008

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

DEPTH - numeric(3,0) (ratio)

ID: HF02408.DEPTH

Soil Depth

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

Numeric domain: type=integer, min=30.0000 (exclusive=false), max=100.0000 (exclusive=false)

SM - numeric(5,3) (ratio)

ID: HF02408.SM

Soil Moisture measured as volumetric water content

Type system: Microsoft SQL Server 2008

Unit: cubic meters per cubic meter

Precision: 1

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

HF02409 - HF02409

Object name: HF02409.csv

Records: 50892

Attributes: 7

Temporal coverage: 2002-04-24 to 2003-03-31

File size: 2819930 byte

Checksum (MD5): 1c60ad8002576c658cc9efa9f8d37800

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

Constraints (2)
  • primaryKey: PRIMARY
    HF02409.DATETIME, HF02409.SITE
  • notNullConstraint: NOTNULL
    HF02409.DATETIME, HF02409.DBCODE, HF02409.DISCHARGE, HF02409.ENTITY, HF02409.QCODE, HF02409.SITE
Attributes (7)
DBCODE - char(5) (nominal)

ID: HF02409.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: HF02409.ENTITY

Entity Number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITE - char(10) (nominal)

ID: HF02409.SITE

Site location

Type system: Microsoft SQL Server 2008

Code definitions (26)
  • GSWS01
    Andrews Watershed 1 Gaging Station
  • GSWS02
    Andrews Watershed 2 Gaging Station
  • GSWS03
    Andrews Watershed 3 Gaging Station
  • GSWS06
    Andrews Watershed 6 Gaging Station
  • GSWS07
    Andrews Watershed 7 Gaging Station
  • GSWS08
    Andrews Watershed 8 Gaging Station
  • GSWS09
    Andrews Watershed 9 Gaging Station
  • GSWS10
    Andrews Watershed 10 Gaging Station
  • GSMACK
    Andrews Mack Creek Gaging Station
  • GSLOOK
    Andrews Lookout Creek Gaging Station
  • PRIMET
    Primary Meteorological Station
  • H15MET
    High 15 Meteorological Station
  • WS10S1
    Watershed 10 (WS10) hillslope throughflow weir
  • WS10S2
    Watershed 10 (WS10) landslide hollow (trib from SE)
  • WS10S3
    Watershed 10 (WS10) main channel above confluence
  • WS10TB
    Watershed 10 (WS10) McGuire's tipping bucket rain gauge
  • WS10P1
    McGuire WS10 Soil Pit 1
  • WS10P2
    McGuire WS10 Soil Pit 2
  • WS10P3
    McGuire WS10 Soil Pit 3
  • WS10A2
    McGuire WS10 tension lysimeter nest A2
  • WS10A1
    McGuire WS10 tension lysimeter nest A1
  • WS10B1
    McGuire WS10 tension lysimeter nest B
  • WS10C1
    McGuire WS10 tension lysimeter nest C
  • WS10D1
    McGuire WS10 tension lysimeter nest D
  • WS10UP12
    McGuire WS10 tension lysimeter nest UP1 and UP2
  • WS10UP34
    McGuire WS10 tension lysimeter nest UP3 and UP4
DATETIME - datetime (dateTime)

ID: HF02409.DATETIME

Date and time of sample collection

Type system: Microsoft SQL Server 2008

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

CAPROD_TEMP - numeric(4,1) (ratio)

ID: HF02409.CAPROD_TEMP

Hillslope water temperature from capacitance rod, does not equal actual water temperature

Type system: Microsoft SQL Server 2008

Unit: degrees Celsius

Precision: 1

Numeric domain: type=real, min=-4.4000 (exclusive=false), max=31.9000 (exclusive=false)

DISCHARGE - numeric(8,6) (ratio)

ID: HF02409.DISCHARGE

Hillslope water discharge from entity 9

Type system: Microsoft SQL Server 2008

Unit: liters per second

Precision: 1

Numeric domain: type=real, min=0.0059 (exclusive=false), max=1.1936 (exclusive=false)

QCODE - char(10) (nominal)

ID: HF02409.QCODE

Data quality codes

Type system: Microsoft SQL Server 2008

Code definitions (4)
  • G
    good
  • E
    estimated
  • A
    adjusted offset
  • M
    missing and predicted from WS10 Q (R-Sq = 0.947, MSE=0.0013)
HF02410 - HF02410

Object name: HF02410.csv

Records: 70

Attributes: 12

Temporal coverage: 2001-09-18 to 2002-09-26

File size: 9713 byte

Checksum (MD5): caeab264fbb10180e0201eaf249ccc55

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

Constraints (2)
  • primaryKey: PRIMARY
    HF02410.COLLECTION_METHOD, HF02410.DATETIME, HF02410.SAMPLE_TYPE, HF02410.SYN_SITE, HF02410.SUBBASIN
  • notNullConstraint: NOTNULL
    HF02410.COLLECTION_METHOD, HF02410.D18O, HF02410.DATETIME, HF02410.DBCODE, HF02410.ENTITY, HF02410.LABID, HF02410.SAMPLE_ID, HF02410.SAMPLE_TYPE, HF02410.SYN_SITE, HF02410.TIMECODE, HF02410.SUBBASIN
Attributes (12)
DBCODE - char(5) (nominal)

ID: HF02410.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: HF02410.ENTITY

Entity Number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SUBBASIN - char(15) (nominal)

ID: HF02410.SUBBASIN

Subbasin in which stream is located

Type system: Microsoft SQL Server 2008

Code definitions (6)
  • McKenzie
    McKenzie River Watershed
  • Blue River
    Blue River Watershed
  • McRae
    McRae Creek
  • Mack
    Andrews Mack Creek Watershed
  • Lookout
    Andrews Lookout Creek Watershed
  • Upper Lookout
    Upper Lookout Creek
SYN_SITE - char(10) (nominal)

ID: HF02410.SYN_SITE

Site location code for synoptic sampling

Type system: Microsoft SQL Server 2008

Code definitions (57)
  • ZZ
    Unknown basin; stream sample site ZZ
  • ZZ SEEP
    Unknown basin; stream sample site ZZ SEEP
  • BR_DAM
    Blue River basin; Blue River below dam stream sample site BR_DAM
  • BR_LOOK
    Blue River basin; Blue River Below LOOK stream sample site BR_LOOK
  • BR_QUE
    Blue River basin; Blue River at Quentin stream sample site BR_QUE
  • COOK
    Blue River basin; Cook Creek stream sample site COOK
  • HJA_BD
    Blue River basin; stream sample site HJA_BD
  • ORE
    Blue River basin; Ore Creek stream sample site ORE
  • QUENTIN
    Blue River basin; Quentin Creek stream sample site QUENTIN
  • TB_ORE
    Blue River basin; Tidbits Creek above Ore Creek stream sample site TB_ORE
  • TIDBITS
    Blue River basin; stream sample site TIDBITS
  • HJA_AS
    Lookout basin; stream sample site HJA_AS
  • HJA_BB
    Lookout basin; stream sample site HJA_BB
  • HJA_BL
    Lookout basin; stream sample site HJA_BL
  • HJA_BM
    Lookout basin; stream sample site HJA_BM
  • HJA_C
    Lookout basin; stream sample site HJA_C
  • HJA_D
    Lookout basin; stream sample site HJA_D
  • HJA_F
    Lookout basin; stream sample site HJA_F
  • HJA_K
    Lookout basin; stream sample site HJA_K
  • HJA_K2
    Lookout basin; stream sample site HJA_K2, near K
  • HJA_O
    Lookout basin; stream sample site HJA_O
  • LOOK
    Lookout basin; stream sample site LOOK, 3H
  • WS01
    Lookout basin; stream sample site WS01
  • WS02
    Lookout basin; stream sample site WS02
  • WS03
    Lookout basin; stream sample site WS03
  • HJA_CC
    Mack basin; stream sample site HJA_CC
  • HJA_T
    Mack basin; stream sample site HJA_T, (SADDLE), 3H
  • HJA_U
    Mack basin; stream sample site HJA_U, (MACK), 3H
  • HJA_V
    Mack basin; stream sample site HJA_V
  • HJA_W
    Mack basin; stream sample site HJA_W
  • DEER
    McKenzie basin; Deer Creek stream sample site DEER
  • MCK_ARM
    McKenzie basin; McKenzie at Armitage stream sample site MCK_ARM
  • MCK_SIL
    McKenzie basin; McKenzie @ Silver Creek boat launch stream sample site MCK_SIL
  • OLLALIE
    McKenzie basin; Ollaloo Creek stream sample site OLLALIE
  • HJA_AQ
    McRae basin; stream sample site HJA_AQ
  • HJA_AR
    McRae basin; stream sample site AR (MCRAE)
  • HJA_AU
    McRae basin; stream sample site HJA_AU
  • HJA_AW
    McRae basin; stream sample site HJA_AW
  • HJA_AY
    McRae basin; stream sample site HJA_AY
  • HJA_AZ
    McRae basin; stream sample site HJA_AZ
  • HJA_BA
    McRae basin; stream sample site HJA_BA
  • WS06
    McRae basin; stream sample site WS06
  • WS07
    McRae basin; stream sample site WS07
  • WS08
    McRae basin; stream sample site WS08, 3H
  • HJA_AA
    Upper Lookout basin; stream sample site HJA_AA
  • HJA_AB
    Upper Lookout basin; stream sample site HJA_AB
  • HJA_AD
    Upper Lookout basin; stream sample site AD (LONGER)
  • HJA_AE
    Upper Lookout basin; stream sample site HJA_AE
  • HJA_AF
    Upper Lookout basin; stream sample site HJA_AF
  • HJA_AG
    Upper Lookout basin; stream sample site AG (COLD CREEK), 3H
  • HJA_AH
    Upper Lookout basin; stream sample site HJA_AH
  • HJA_AI
    Upper Lookout basin; stream sample site HJA_AI
  • HJA_AJ
    Upper Lookout basin; stream sample site HJA_AJ
  • HJA_AK
    Upper Lookout basin; stream sample site HJA_AK
  • HJA_AM
    Upper Lookout basin; stream sample site HJA_AM
  • HJA_AP
    Upper Lookout basin; stream sample site HJA_AP
  • HJA_Y
    Upper Lookout basin; stream sample site HJA_Y
DATETIME - datetime (dateTime)

ID: HF02410.DATETIME

Date and time of sample collection

Type system: Microsoft SQL Server 2008

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

D18O - numeric(6,2) (ratio)

ID: HF02410.D18O

Oxygen-18 composition of water sample

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-12.3500 (exclusive=false), max=-10.3000 (exclusive=false)

TIMECODE - char(1) (nominal)

ID: HF02410.TIMECODE

Code describing the sample time

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • G
    time is accurate as recorded when sampled
  • M
    time was not recorded and estimated
COLLECTION_METHOD - char(4) (nominal)

ID: HF02410.COLLECTION_METHOD

Method of sample collection

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • grab
    grab sample from stream
  • bulk
    bulk sample
  • auto
    collected using an auto sampler or instrument
SAMPLE_TYPE - varchar(20) (nominal)

ID: HF02410.SAMPLE_TYPE

Type of water sample

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • surface
    stream surface water
  • precip
    precipitation captured in sampling gauge
  • snow
    snowmelt from lysimeter
  • through
    seep/throughflow from hillslope
  • ground
    ground water from well or piezometer
SAMPLE_ID - numeric(4,0) (ratio)

ID: HF02410.SAMPLE_ID

Sample ID for McGuire database

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

LABID - char(7) (ordinal)

ID: HF02410.LABID

Lab ID for USGS, Menlo Park

Type system: Microsoft SQL Server 2008

SITE_DESCRIPTION - char(85) (nominal)

ID: HF02410.SITE_DESCRIPTION

description of the synoptic sampling site

Type system: Microsoft SQL Server 2008

HF02411 - HF02411

Object name: HF02411.csv

Records: 14482

Attributes: 10

Temporal coverage: 2002-12-09 to 2003-03-20

File size: 1108544 byte

Checksum (MD5): f66a303cbc3a1535c76106e7b83bfa1a

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

Constraints (2)
  • primaryKey: PRIMARY
    HF02411.DATETIME
  • notNullConstraint: NOTNULL
    HF02411.DATETIME, HF02411.DBCODE, HF02411.ENTITY
Attributes (10)
DBCODE - char(5) (nominal)

ID: HF02411.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: HF02411.ENTITY

Entity Number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITE - char(10) (nominal)

ID: HF02411.SITE

Site location

Type system: Microsoft SQL Server 2008

Code definitions (26)
  • GSWS01
    Andrews Watershed 1 Gaging Station
  • GSWS02
    Andrews Watershed 2 Gaging Station
  • GSWS03
    Andrews Watershed 3 Gaging Station
  • GSWS06
    Andrews Watershed 6 Gaging Station
  • GSWS07
    Andrews Watershed 7 Gaging Station
  • GSWS08
    Andrews Watershed 8 Gaging Station
  • GSWS09
    Andrews Watershed 9 Gaging Station
  • GSWS10
    Andrews Watershed 10 Gaging Station
  • GSMACK
    Andrews Mack Creek Gaging Station
  • GSLOOK
    Andrews Lookout Creek Gaging Station
  • PRIMET
    Primary Meteorological Station
  • H15MET
    High 15 Meteorological Station
  • WS10S1
    Watershed 10 (WS10) hillslope throughflow weir
  • WS10S2
    Watershed 10 (WS10) landslide hollow (trib from SE)
  • WS10S3
    Watershed 10 (WS10) main channel above confluence
  • WS10TB
    Watershed 10 (WS10) McGuire's tipping bucket rain gauge
  • WS10P1
    McGuire WS10 Soil Pit 1
  • WS10P2
    McGuire WS10 Soil Pit 2
  • WS10P3
    McGuire WS10 Soil Pit 3
  • WS10A2
    McGuire WS10 tension lysimeter nest A2
  • WS10A1
    McGuire WS10 tension lysimeter nest A1
  • WS10B1
    McGuire WS10 tension lysimeter nest B
  • WS10C1
    McGuire WS10 tension lysimeter nest C
  • WS10D1
    McGuire WS10 tension lysimeter nest D
  • WS10UP12
    McGuire WS10 tension lysimeter nest UP1 and UP2
  • WS10UP34
    McGuire WS10 tension lysimeter nest UP3 and UP4
COLLECTION_METHOD - char(4) (nominal)

ID: HF02411.COLLECTION_METHOD

Method of sample collection

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • grab
    grab sample from stream
  • bulk
    bulk sample
  • auto
    collected using an auto sampler or instrument
DATETIME - datetime (dateTime)

ID: HF02411.DATETIME

Date and time of sample collection

Type system: Microsoft SQL Server 2008

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

TIME - numeric(6,1) (ratio)

ID: HF02411.TIME

Time from start of experiment (12/9/2002 10:30)

Type system: Microsoft SQL Server 2008

Unit: number of hours

Precision: 1

Numeric domain: type=real, min=0.1700 (exclusive=false), max=2413.5000 (exclusive=false)

WATERTEMP - numeric(4,1) (ratio)

ID: HF02411.WATERTEMP

Hillslope water temperature

Type system: Microsoft SQL Server 2008

Unit: degrees Celsius

Precision: 1

Numeric domain: type=real, min=4.7000 (exclusive=false), max=9.5000 (exclusive=false)

EC - numeric(6,4) (ratio)

ID: HF02411.EC

Hillslope water specific conductance

Type system: Microsoft SQL Server 2008

Unit: milli Siemens per centimeter

Precision: 1

Numeric domain: type=real, min=0.0187 (exclusive=false), max=0.1929 (exclusive=false)

DISCHARGE - numeric(8,6) (ratio)

ID: HF02411.DISCHARGE

Hillslope water discharge from entity 9

Type system: Microsoft SQL Server 2008

Unit: liters per second

Precision: 1

Numeric domain: type=real, min=0.0129 (exclusive=false), max=1.1935 (exclusive=false)

RAINFALL_DEPTH - numeric(5,3) (ratio)

ID: HF02411.RAINFALL_DEPTH

Rainfall depth measured by tipping bucket on hillslope (entity 12) binned to 10 minute intervals

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

Numeric domain: type=real, min=0.2540 (exclusive=false), max=2.2860 (exclusive=false)

HF02412 - HF02412

Object name: HF02412.csv

Records: 14995

Attributes: 5

Temporal coverage: 2001-11-05 to 2003-08-05

File size: 674817 byte

Checksum (MD5): a2fbcf1ea47721443a9deb24b2b67dd6

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

Constraints (2)
  • primaryKey: PRIMARY
    HF02412.DATETIME, HF02412.SITE
  • notNullConstraint: NOTNULL
    HF02412.DATETIME, HF02412.DBCODE, HF02412.ENTITY, HF02412.RAINFALL_AMT, HF02412.SITE
Attributes (5)
DBCODE - char(5) (nominal)

ID: HF02412.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: HF02412.ENTITY

Entity Number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITE - char(10) (nominal)

ID: HF02412.SITE

Site location

Type system: Microsoft SQL Server 2008

Code definitions (26)
  • GSWS01
    Andrews Watershed 1 Gaging Station
  • GSWS02
    Andrews Watershed 2 Gaging Station
  • GSWS03
    Andrews Watershed 3 Gaging Station
  • GSWS06
    Andrews Watershed 6 Gaging Station
  • GSWS07
    Andrews Watershed 7 Gaging Station
  • GSWS08
    Andrews Watershed 8 Gaging Station
  • GSWS09
    Andrews Watershed 9 Gaging Station
  • GSWS10
    Andrews Watershed 10 Gaging Station
  • GSMACK
    Andrews Mack Creek Gaging Station
  • GSLOOK
    Andrews Lookout Creek Gaging Station
  • PRIMET
    Primary Meteorological Station
  • H15MET
    High 15 Meteorological Station
  • WS10S1
    Watershed 10 (WS10) hillslope throughflow weir
  • WS10S2
    Watershed 10 (WS10) landslide hollow (trib from SE)
  • WS10S3
    Watershed 10 (WS10) main channel above confluence
  • WS10TB
    Watershed 10 (WS10) McGuire's tipping bucket rain gauge
  • WS10P1
    McGuire WS10 Soil Pit 1
  • WS10P2
    McGuire WS10 Soil Pit 2
  • WS10P3
    McGuire WS10 Soil Pit 3
  • WS10A2
    McGuire WS10 tension lysimeter nest A2
  • WS10A1
    McGuire WS10 tension lysimeter nest A1
  • WS10B1
    McGuire WS10 tension lysimeter nest B
  • WS10C1
    McGuire WS10 tension lysimeter nest C
  • WS10D1
    McGuire WS10 tension lysimeter nest D
  • WS10UP12
    McGuire WS10 tension lysimeter nest UP1 and UP2
  • WS10UP34
    McGuire WS10 tension lysimeter nest UP3 and UP4
DATETIME - datetime (dateTime)

ID: HF02412.DATETIME

Date and time of sample collection

Type system: Microsoft SQL Server 2008

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

RAINFALL_AMT - numeric(5,3) (ratio)

ID: HF02412.RAINFALL_AMT

Amount of rain per tip of the bucket (always 0.254 mm); record represents 1 tip

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

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

Units
micrograms per liter ug/l massDensity microgramPerLiter kilogramPerMeterCubed 0.000001 micrograms per liter
microequivalent per liter ueq/l amountOfSubstanceWeight microequivalentPerLiter molePerKilogram N/A microequivalent per liter
milliliters ml volume milliliter meterCubed 0.000001 milliliters; 1/1000 of a liter
micromoles per liter umol/l amountOfSubstanceConcentration micromolePerLiter molePerMeterCubed 0.001 micromoles per liter
centimeters cm length centimeter meter 0.01 centimeters; .01 meters
cubic meters per cubic meter m3/m3 volumePerVolume meterCubedPerMeterCubed centimeterCubed PerCentimeterCubed 1000000 cubic meters per cubic meter
permil o/oo massPerMass permil gramPerGram 0.001 parts per thousand, relative to a standard. for isotopes. Isotope data uses LC-delta=(Rx/Rs-1)*1000
liters per second l/sec volumetricRate literPerSecond literPerSecond 1 liters per second
milli Siemens per centimeter mS/cm specific conductance milliSiemenPerCentimeter siemenPerMeter 0.001 milli Siemens per centimeter
number of hours hours time nominalHour second 3600 one hour excluding leap seconds, 3600 seconds
degrees Celsius deg c temperature celsiusDegree kelvin 1 Degrees Celsius; a common unit of temperature; constantToSI=273.18
number number dimensionless number dimensionless 1 dimensionless number, i.e., ratio, count
millimeters mm length millimeter meter 0.001 millimeters; .001 meters
Related Datasets

No related dataset codes found in the EML text fields.

Related Publications
  • McGuire, Kevin J. 2004. Water residence time and runoff generation in the western Cascades of Oregon. Corvallis, OR: Oregon State University. 224 p. Ph.D. dissertation.
  • McGuire, K. J.; McDonnell, J. J.; Weiler, M.; Kendall, C.; McGlynn, B. L.; Welker, J. M.; Seibert, J. 2005. The role of topography on catchment-scale water residence time. Water Resources Research. 41(W05002): doi:10.1029/2004WR003657.
  • McGuire, K. J.; Weiler, M.; McDonnell, J. J. 2007. Integrating tracer experiments with modeling to assess runoff processes and water transit times. Advances in Water Resources. 30: 824-837.
  • McGuire, Kevin J.; McDonnell, Jeffrey J. 2010. Hydrological connectivity of hillslopes and streams: characteristic time scales and nonlinearities. Water Resources Research. 46(W10543): doi:10.1029/2010WR009341.
Related Files
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 (2007-07-20)
    Original metadata creation.
  • Version1 (2017-09-08)
    Nicolas Rodriguez submitted a portion of data with documentation from Kevin McGuire's study. This was originally assigned a new database code (HF027), but when realized it was the same data from Kevin's study, the data and documentation got merged with HF024.
  • Version2 (2020-05-04)
    Original creation of entity. Imported metatdata using move_xls. Ran QC. Created data structures and uploaded data to SQL.
  • Version3 (2020-05-04)
    Need to recreate entity 10 CSV file and some updated metadata.