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

SP038: Soil moisture and soil temperature from Benchmark Stations at the HJ Andrews Experimental Forest, 1987 to present

← Back to catalog index

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

Status: annually
Period: 1987-06-16 to 2024-10-01
Version: 6
Published: 2025-07-31
EDI Package ID: knb-lter-and.12109.6
Source XML: SP038_6.xml

Notice

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

Citation

Schulze, M.; Daly, C.; McKee, W. 2025. Soil moisture and soil temperature from Benchmark Stations at the HJ Andrews Experimental Forest, 1987 to present Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/SP038 Accessed 2026-05-10.

Abstract

A three-level hydro-climatological network for data monitoring was established in 1994. The networks at each level are nested to form a coordinated program of data acquisition and measurement. A future vision of linking the benchmark meteorological stations with regional weather stations to expand the future scope of studies was also considered in designing this network. The first-level in this top-down approach consists of Benchmark Meteorological Stations (BMS) and Benchmark Stream Stations. The BMS are designed to represent the environment across the Andrews. These stations are intended to provide complete, long-term, high temporal resolution, meso-scale hydroclimatological data. The location of the BMS network is based on factors such as elevation, aspect, vegetation gradients, and accessibility. Collected meteorological parameters are generally standardized across the BMS as well as methods and instrumentation. Secondary Meteorological Stations also follow standardized methods and serve similar purposes but are somewhat limited in meteorological parameters collected. The Primary Meteorological Station (PRIMET), Central Meteorological Station (CENMET), Upper Lookout Meteorological Station (UPLMET), and Vanilla Leaf Meteorological Station (VANMET) are the four Benchmark Stations, Climatic Station at Watershed 2 (CS2MET) and the Hi-15 Meteorological Station (H15MET) are Secondary Stations. These soil parameters were previously part of database code MS001, but were separated out into their own database in 2024.

Coverage

Temporal coverage: 1987-06-16 to 2024-10-01

Geographic coverage: H. J. Andrews Experimental Forest

Spatial coverage:

Bounds: W -122.25594100, E -122.11976300, N 44.27332900, S 44.20709700

Purpose
  • Hydrology, climatology, and biology interact over a wide range of spatial and temporal scales. Continuous interaction among climate, soils, landuse, and vegetation shape the hydrology and ecology of a landscape. Long-term measurements of such variables at various time and space scales provide an essential foundation for understanding ecosystem processes, and document changes in the local, regional, and global environments.
Project

Title: Long-Term Ecological Research

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

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

Awards
Study Area Description
  • Long-Term Ecological Research
    The Andrews Forest is situated in the western Cascade Range of Oregon, and covers the entire 15,800-acre (6400-ha) drainage basin of Lookout Creek. Elevation ranges from 1350 to 5340 feet (410 to 1630 m). Broadly representative of the rugged mountainous landscape of the Pacific Northwest, the Andrews Forest contains excellent examples of the region's conifer forests and associated wildlife and stream ecosystems. These forests are among the tallest and most productive in the world, with tree heights of often greater than 250 ft (75 m). Streams are steep, cold and clean, providing habitat for numerous aquatic organisms.
Associated Party
  • Suzanne M. Remillard
    Role: Abstractor
    Office: FSL 354;; Forest Science Department;; Oregon State University, Corvallis, OR, 97331, USA
    Phone: (541) 758-8767
    Email: suzanne.remillard@oregonstate.edu
  • Mark D Schulze
    Role: Principal Investigator
    H.J. Andrews Experimental Forest; PO Box 300, Blue River, OR, 97413
    Phone: 541-822-6336
    Email: mark.schulze@oregonstate.edu
  • Christopher Daly
    Role: Principal Investigator
    PRISM Group;Northwest Alliance for Computational Science and Engineering, 2000 Kelley Engineering Center;Oregon State University, Corvallis, OR, 97331, USA
    Phone: (541) 737-2531
    Email: daly@nacse.org
  • Sherri L. Johnson
    Role: Other Researcher
    US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: 541-758-7771
    Email: sherri.johnson@oregonstate.edu
  • Julia A. Jones
    Role: Other Researcher
    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
  • Greg M Cohn
    Role: Other Researcher
    USFS Rd 15-130-132, Blue River, OR, 97413
    Phone: 541-822-6305
    Email: cohng@oregonstate.edu
  • Adam M Kennedy
    Role: Other Researcher
    1055 Clinton Drive, Eugene, OR, 97401, US
    Phone: 541-822-6302
    Email: adam.kennedy@oregonstate.edu, kennaster@gmail.com
  • Stephanie A Schmidt
    Role: Other Researcher
    USDA Forest Service; 3200 SW Jefferson Way, Corvallis, Oregon, 97331
    Email: stephanie.schmidt@oregonstate.edu, stephanie.schmidt2@usda.gov
  • Richard H. Waring
    Role: Former Investigator
    Oregon State University;Dept. of Forest Science;321 Richardson Hall, Corvallis, OR, 97331-5752, USA
    Email: Richard.Waring@oregonstate.edu
  • David Greenland
    Role: Former Investigator
    Atlanta, GA, USA
    Email: degreenland@gmail.com
  • Mark E. Harmon
    Role: Former Investigator
    Oregon State University;Dept. of Forest Science;321 Richardson Hall, Corvallis, OR, 97331-5752, USA
    Phone: (541) 737-8455, (978) 724-0045 ext 223
    Email: mark.harmon@oregonstate.edu
  • Don Henshaw
    Role: Former Investigator
    Email: donny.henshaw@gmail.com
  • Craig Creel
    Role: Former Investigator
    USDA Forest Service;Pacific NW Research Station;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: (541) 750-7326, (541) 822-6301
    Email: cdcreel@comcast.net
  • Frederick A. Bierlmaier
    Role: Former Investigator
    OR, USA
  • John Moreau
    Role: Former Investigator
    Blue River, OR, 97413, USA
    Email: john.b.moreau@icloud.com
  • Christoph K Thomas
    Role: Former Investigator
    Professor, Micrometeorology; Associate Editor Water Resources Research; University of Bayreuth; Micrometeorology Group, Bayreuth, 95540, Germany
    Phone: +49 (0) 921 55 2293
    Email: christoph.thomas@uni-bayreuth.de
  • Michael H. Unsworth
    Role: Former Investigator
    Oregon State University;Oregon Climatology, Corvallis, OR, 97331, USA
    Email: unswortm@coas.oregonstate.edu
  • Anne W. Nolin
    Role: Former Investigator
    Director, Graduate Program of Hydrologic Sciences and; Professor, Department of Geography; University of Nevada-Reno, Reno, NV, USA
    Phone: 775-682-8148
    Email: anne.nolin@gmail.com
  • Adam B. Mazurkiewicz
    Role: Former Investigator
    CA
    Email: amazurkiewicz@sfwater.org
  • Alfred B. Levno
    Role: Former Investigator
    Corvallis, OR, 97331, USA
    Email: ablevno@comcast.net, allevno@hotmail.com
  • Roswell C. Mersereau
    Role: Former Investigator
  • Fox Sparky Peterson
    Role: Former Investigator
    Phone: 404-580-5016
    Email: fox@tinybike.net
  • Greg Downing
    Role: Method Contact
    Forestry Sciences Lab;3200 SW Jefferson Way, Corvallis, OR, 97333, USA
    Phone: (541) 750-7283, (541) 822-6301
    Email: gregdowning242@gmail.com, greg.downing@oregonstate.edu
  • Greg M Cohn
    Role: Method Contact
    USFS Rd 15-130-132, Blue River, OR, 97413
    Phone: 541-822-6305
    Email: cohng@oregonstate.edu
  • Donald L. Henshaw
    Role: Abstractor
    Pacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, Oregon, 97331
    Email: hja_admin@lists.oregonstate.edu
  • Mark D Schulze
    Role: Creator
    H.J. Andrews Experimental Forest; PO Box 300, Blue River, OR, 97413
    Phone: 541-822-6336
    Email: mark.schulze@oregonstate.edu
  • Christopher Daly
    Role: Creator
    PRISM Group;Northwest Alliance for Computational Science and Engineering, 2000 Kelley Engineering Center;Oregon State University, Corvallis, OR, 97331, USA
    Phone: (541) 737-2531
    Email: daly@nacse.org
  • W. Arthur McKee
    Role: Creator
    Flathead Lake Biological Station ;The University of Montana ;300 Bio Station Lane, Polson, MT, 59860-9659, USA
    Phone: 406-982-3301
    Email: art.mckee@flbs.umt.edu
Contact
  • Information Manager
    Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331
    Email: hjaweb@lists.oregonstate.edu
  • Adam M Kennedy
    1055 Clinton Drive, Eugene, OR, 97401, US
    Phone: 541-822-6302
    Email: adam.kennedy@oregonstate.edu, kennaster@gmail.com
  • Stephanie A Schmidt
    USDA Forest Service; 3200 SW Jefferson Way, Corvallis, Oregon, 97331
    Email: stephanie.schmidt@oregonstate.edu, stephanie.schmidt2@usda.gov
Publisher
  • Andrews Forest LTER Site
    Role: Publisher
    Forest Ecosystems and Society Department in Forestry, Oregon State University, 201K Richardson Hall, Corvallis, OR, 97331-5752
    Phone: (541) 737-8480
    Email: lterweb@lists.oregonstate.edu
Study Description

A three-level hydro-climatological network for data monitoring was established in 1994. The networks at each level are nested to form a coordinated program of data acquisition and measurement. A future vision of linking the benchmark meteorological stations with regional weather stations to expand the future scope of studies was also considered in designing this network. The first-level in this top-down approach consists of Benchmark Meteorological Stations (BMS) and Benchmark Stream Stations. The BMS are designed to represent the environment across the Andrews. These stations are intended to provide complete, long-term, high temporal resolution, meso-scale hydroclimatological data. The location of the BMS network is based on factors such as elevation, aspect, vegetation gradients, and accessibility. Collected meteorological parameters are generally standardized across the BMS as well as methods and instrumentation. Secondary Meteorological Stations also follow standardized methods and serve similar purposes but are somewhat limited in meteorological parameters collected. The Primary Meteorological Station (PRIMET), Central Meteorological Station (CENMET), Upper Lookout Meteorological Station (UPLMET), and Vanilla Leaf Meteorological Station (VANMET) are the four Benchmark Stations, Climatic Station at Watershed 2 (CS2MET) and the Hi-15 Meteorological Station (H15MET) are Secondary Stations. These soil parameters were previously part of database code MS001, but were separated out into their own database in 2024. Hydrology, climatology, and biology interact over a wide range of spatial and temporal scales. Continuous interaction among climate, soils, landuse, and vegetation shape the hydrology and ecology of a landscape. Long-term measurements of such variables at various time and space scales provide an essential foundation for understanding ecosystem processes, and document changes in the local, regional, and global environments. Field Methods - SP038: Soil moisture

Purpose: Hydrology, climatology, and biology interact over a wide range of spatial and temporal scales. Continuous interaction among climate, soils, landuse, and vegetation shape the hydrology and ecology of a landscape. Long-term measurements of such variables at various time and space scales provide an essential foundation for understanding ecosystem processes, and document changes in the local, regional, and global environments.

Methods

Method Steps

Field Methods - SP038: Soil moisture
  • The follow link describes data collection methods (by date range and resolution) that have been used by each unique probe. Results are filtered by database code, sitecode, parameter, and probe.
  • https://andlter.forestry.oregonstate.edu/MethodCode/View_History.aspx
  • Please follow this link to view climate data collection methods that have been used over time at select stations. Results can be filtered by parameter, climate station, and date range. A general text search is also available.
  • https://hjandrews.shinyapps.io/im_methods_history/
  • Soil moisture is measured with a water content reflectometer (WCR) beginning in 1998 (PRIMET) replacing older gypsum block technology. Mean 5-minute soil temperatures are measured at the four benchmark stations (PRIMET, CENMET, UPLMET, VANMET) at four depths (10, 20, 50, 100 cm) starting in either 2014 or 2015. Since 2015, daily data is post-calculated from all 5 minute mean values for the day. Max-min values are based on 5 minute mean intervals and not instantaneous values. Prior to that, mean hourly soil temperatures were measured starting in May 2012 and mean daily soil volumetric water content was calculated on 15 second samples starting in 2001 or 2002 for the other three sites. Daily max-min values were based on instantaneous 15 second readings.

Instrumentation:

  • Campbell Scientific CS615 Water Content Reflectometers
Field Methods - SP038: Soil moisture potential
  • The follow link describes data collection methods (by date range and resolution) that have been used by each unique probe. Results are filtered by database code, sitecode, parameter, and probe.
  • https://andlter.forestry.oregonstate.edu/MethodCode/View_History.aspx
  • Please follow this link to view climate data collection methods that have been used over time at select stations. Results can be filtered by parameter, climate station, and date range. A general text search is also available.
  • https://hjandrews.shinyapps.io/im_methods_history/
  • Gypsum blocks were used to record mean daily soil moisture potential at the four benchmark stations (PRIMET, CENMET, UPLMET, VANMET) beginning in 1994. Water content reflectometers were added beginning in 1998 at all sites and all gypsum block measurements were terminated by May 2000. Hourly measurements were made between 1988 and 1990 at PRIMET but were discontinued and restarted in Oct 1994 on a daily basis only. At VANMET, soil moisture potential measurements were summarized by daytime and nighttime hours only from 1987 to 1994 at depths of 10, 20, 30 cm. From 1987 to 1993, mean daily soil moisture potentials were recorded in the rooting zone of 3 individual trees at VANMET.

Instrumentation:

  • Campbell Scientific model 223 gypsum soil moisture blocks were used historically. A polynomial equation relates changes in soil moisture with changes in block resistance. The manufacturer supplied equation is calibrated from -.1 to -15 bars. Values less than -15 bars are listed as out of range. Data logger is Campbell Scientific.
Field Methods - SP038: Soil temperature
  • The follow link describes data collection methods (by date range and resolution) that have been used by each unique probe. Results are filtered by database code, sitecode, parameter, and probe.
  • https://andlter.forestry.oregonstate.edu/MethodCode/View_History.aspx
  • Please follow this link to view climate data collection methods that have been used over time at select stations. Results can be filtered by parameter, climate station, and date range. A general text search is also available.
  • https://hjandrews.shinyapps.io/im_methods_history/
  • Mean 5-minute soil temperatures are measured at the four benchmark stations (PRIMET, CENMET, UPLMET, VANMET) at four depths (10, 20, 50, 100 cm) starting in either 2014 or 2015. Prior to that, and from the beginning of data collection, mean hourly soil temperatures were measured. Collection at the secondary benchmark site, WS7MET, began with 10-minute means at the end of 2006 and was switched to 5-minutes means with the other sites. Thermocouple wire was used in the earliest measurements and were protected inside of a PVC structure. Most measurements begin in 1994 but measurements were made at PRIMET beginning in 1988 at 20 cm depth only. At VANMET, measurements were summarized by daytime and nighttime hours only from 1987 to 1993 at depths of 10, 20, 30 cm, and soil temperature was recorded in the rooting zone of 3 individual trees.

Instrumentation:

  • Thermocouple wire: Probe is type T thermocouple soldered from thermocouple wire or, Campbell Scientific thermistor probe: Campbell Scientific model 107 temperature probe (CS107B, CS107B-L) includes the Fenwal Electronics UUT51J1 thermistor. Data logger is a Campbell Scientific, typically CR10, CR21X, CR500, or CR23X.
Processing Procedures - MS001
  • Sensor data streams via wifi into files at the headquarters. The files are run through GCE Data Toolbox, which is a comprehensive software framework for metadata-based analysis, quality control, transformation and management of ecological data sets. https://gce-lter.marsci.uga.edu/public/im/tools/data_toolbox.htm. The files are provided on the provisional data page. For processing into final formats, these files are processed through a Python script called Fastbridge where data visualization is possible and QC/QA validation and report logs occur. Data ranges are checked, specific statistical analysis are performed, data are transformed into final FSDB format.
Quality Assurance - Fire effects on data
  • The HJ Andrews Experimental Forest was affected by wildfires in 2020, 2023, and, to a lesser degree, 2024. Documentation is being developed that will describe the potential impacts on long-term records, provide the date ranges of direct impact, and describe specific site or data impacts. The use of the BURNED event_code was expanded to include wildfire, and a code was added to each relevant attribute flag to indicate when fire effects are visible in the data (P=Pyro).

Sampling

Study Extent
  • Temperature and rainfall in the Andrews Experimental Forest are are typical of a maritime climate with wet, relatively mild winters and dry, cool summers. Humidity is generally high through winter months, and maximum daily relative humidity approaches 100 percent at night throughout the year. Minimum summer humidities generally hover around 30-50 percent. Temperature extremes range from near 0 degrees F in unusually cold winters to over 100 degrees for brief periods almost every summer. The range in mean annual temperature (1972-2002) is 7.1-10.5 degrees C at a low elevation site (PRIMET). Precipitation varies with elevation - long-term annual average at low elevation (450 m) is 2200 mm, and at high elevation (1200m) is 2600 mm.
  • Sampling frequency: continuous
Sampling Description
  • Much of the early climatological measurements on the Andrews Forest were associated with the investigation of the initial small watersheds experiment (Watersheds 1, 2, 3). The Climatic Station on WS 2 was installed in 1956 to measure precipitation and a hygrothermograph was added in 1958. The High-15 station was established to measure precipitation in 1964 in conjunction with small watersheds 6, 7, 8, and has evolved into a secondary meteorological station. A more general set of modeling needs led to the installation of the Primary Meteorological Station in 1972 to characterize the meso-scale environment. Originally, solar radiation, air temperature, dew point temperature, and windspeed were collected. Along with precipitation from the climatic station on WS 2, these were the primary climatic variables needed for the models predicting the rates at which materials accumulate or move through ecosystems (Waring et al., 1978). Significant improvements to the station were made in 1975, 1979, and 1988, as the station evolved from chart recorders to state-of-the-art digital data loggers (Bierlmaier and McKee, 1989). The Vanilla Leaf Met Station was installed in 1987. The primary intent was to provide micro- meteorological data for a study of seedling survival following clearcut and shelterwood logging at high elevation. Ultimately, the shelterwood site was discontinued and the clearcut site has evolved as a primary high elevation meteorological station.
  • Four Benchmark Meteorological Stations (BMS) and two second-level stations are included in the MS001 database. The Primary Meteorological and Vanilla Leaf Meteorological BMS are retained. Two new BMS are installed. In 1994, the Upper Lookout Meteorological Station was established at high elevation (4200 ft, ENE aspect) on clearcut L708 in the SE Andrews. In 1995 the Central Meteorological BMS was established at a centrally located site on clearcut L351 (3300 ft, WSW aspect) in the east-central Andrews. A GIS analysis of elevation and aspect indicated the average elevation (3170 ft., 966 m) and average aspect (267 degrees) of the Andrews Forest, and the Central Met Station was located to represent these general averages. Modifications are made to the Primary and Vanilla Leaf Stations to standardize measured variables, temporal resolution, methods, and instrumention across all BMS. Sites will be cleared and required openings maintained following standards of the National Weather Service, the LTER network, and where appropriate, the NADP network. Telemetering of all BMS was completed in 1996. Second-level stations (SLS) at the Hi-15 and WS 2 Climatic Station will continue to be maintained for measurement of precipitation, temperature, and other data to maintain continuity of historical records. These sites also follow established procedural standards.
  • The BMS include meteorological measurement of air and soil temperature, relative humidity, calculated dew point temperature and vapor pressure deficit, wind speed and direction measurement, incoming solar radiation, photosynthetically active radiation (PAR), soil moisture, snow melt, and snow moisture and depth.
  • Citation:
  • The Program for Hydroclimatological Measurement at the H.J. Andrews Experimental Forest by Don Henshaw, Arthur McKee, Alok Sikka 18 Aug 1995 http://andrewsforest.oregonstate.edu/research/component/climate/clim95.pdf
Spatial Sampling Units
  • Central Meteorological Station
    W -122.14109300, E -122.14109300, N 44.24348200, S 44.24348200
    Altitude: 1028 to 1028 meter
  • Primary Meteorological Station
    W -122.25594100, E -122.25594100, N 44.21189300, S 44.21189300
    Altitude: 436 to 436 meter
  • Upper Lookout Meteorological Station
    W -122.11976300, E -122.11976300, N 44.20709700, S 44.20709700
    Altitude: 1284 to 1284 meter
  • Vanilla Leaf Meteorological Station
    W -122.14936800, E -122.14936800, N 44.27161800, S 44.27161800
    Altitude: 1268 to 1268 meter
  • Watershed 7 Meteorological Station
    W -122.17657400, E -122.17657400, N 44.26657600, S 44.26657600
    Altitude: 998 to 998 meter
  • Andrews Experimental Forest (HJA)
    W -122.26172200, E -122.10084700, N 44.28196400, S 44.19770400
    Altitude: 1631 to 1631 meter
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: meteorology (theme), climatology (theme), climate change (theme), soil temperature (theme), soil moisture (theme), disturbance (theme), monitoring (theme)
  • LTER core research areas: disturbance (theme)
Taxonomic Hierarchy

No taxonomic hierarchy listed in this EML file.

Data Entities
# Entity Metadata Data
1 SP03806
Soil moisture potential (daily)
Daily soil moisture potential is discontinued in November 2002. Please see "Soil water content (daily)" (Entity 23) or "Soil water content (fine temporal resolution)" (Entity 33) for volumetric soil water content.
 METADATA DATA
2 SP03816
Soil moisture potential (fine temporal resolution)
Hourly soil moisture potential is discontinued in 1994. Please see "Soil moisture potential (daily)" (Entity 6) or see "Soil water content (daily)" (Entity 23) or "Soil water content (fine temporal resolution)" (Entity 33) for volumetric soil water content.
 METADATA DATA
3 SP03821
Soil temperature (daily)
Soil temperature at multiple depths per site, daily
 METADATA DATA
4 SP03823
Soil water content (daily)
Soil volumetric water content at multiple depths per site, daily
 METADATA DATA
5 SP03831
Soil temperature (fine temporal resolution)
Soil temperature at multiple depths per site, fine temporal resolution
 METADATA DATA
6 SP03833
Soil water content (fine temporal resolution)
Soil volumetric water content at multiple depths per site, fine temporal resolution
 METADATA DATA
Metadata
SP03806 - Soil moisture potential (daily)

Object name: SP03806_v3.csv

Records: 49486

Attributes: 17

Temporal coverage: 1987-06-16 to 2002-11-13

File size: 4325058 byte

Checksum (MD5): 41b16cbcd605178f36a19858bf0ee958

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

Constraints (2)
  • primaryKey: PRIMARY
    SP03806.DATE, SP03806.PROBE_CODE, SP03806.SITECODE
  • notNullConstraint: NOTNULL
    SP03806.DATE, SP03806.ENTITY, SP03806.SOILMP_MEAN_FLAG, SP03806.SOILMP_MAX_FLAG, SP03806.SOILMP_MIN_FLAG, SP03806.EVENT_CODE, SP03806.QC_LEVEL, SP03806.SOILMP_METHOD, SP03806.DEPTH, SP03806.DBCODE, SP03806.PROBE_CODE, SP03806.SITECODE
Attributes (17)
DBCODE - char(5) (nominal)

ID: SP03806.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • SP038
    FSDB Database Code SP038
ENTITY - numeric(2,0) (interval)

ID: SP03806.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SITECODE - char(6) (nominal)

ID: SP03806.SITECODE

Site code for the meteorological measurement station

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • CENMET
    Central Meteorological Station
  • PRIMET
    Primary Meteorological Station
  • UPLMET
    Upper Lookout Meteorological Station
  • VANMET
    Vanilla Leaf Meteorological Station
  • WS7MET
    Watershed 7 Meteorological Station
SOILMP_METHOD - char(6) (nominal)

ID: SP03806.SOILMP_METHOD

An indication of the the general methodology and instrumentation used to collect this soil moisture potential data

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • SMP001
    Soil moisture potential is sampled by a Campbell Scientific model 223 gypsum soil moisture block at 10 cm depth; mean soil moisture potential in bars is output every 60 minutes
  • SMP002
    Soil moisture potential is sampled by a Campbell Scientific model 223 gypsum soil moisture block at 20 cm depth; mean soil moisture potential in bars is output every 60 minutes
  • SMP005
    Soil moisture potential is sampled by a Campbell Scientific model 223 gypsum soil moisture block at 30 cm depth; mean soil moisture potential in bars is output every 60 minutes
  • SMP101
    Mean daily soil moisture potential is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings; CS model 223 gypsum soil moisture block; 10cm depth (See Method SMP001)
  • SMP102
    Mean daily soil moisture potential is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings; CS model 223 gypsum soil moisture block; 20cm depth (See Method SMP002)
  • SMP103
    Mean daily soil moisture potential is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings; CS model 223 gypsum soil moisture block; 50cm depth
  • SMP104
    Mean daily soil moisture potential is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings; CS model 223 gypsum soil moisture block; 100 cm depth
  • SMP105
    Mean daily soil moisture potential is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings; CS model 223 gypsum soil moisture block; 30 cm depth (See Method SMP005)
  • SMP106
    No daily soil moisture potential is recorded or calculated during this period
DEPTH - numeric(4,0) (ratio)

ID: SP03806.DEPTH

Depth of sensor from ground surface

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

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

QC_LEVEL - char(2) (nominal)

ID: SP03806.QC_LEVEL

Quality control flag indicates level of quality checking performed including an indication of "provisional" data.

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • 1P
    Data is provisional and subject to revision - preliminary quality checks have been performed
  • 1A
    Data is published and unlikely to change - automated range checking and manual review has been conducted. Quality is indicated in data value qualifier flags.
  • 2A
    Data is published and unlikely to change - Level 1A data has been modified such that data gaps may be filled or problem data may be removed
  • 2D
    Data is published and unlikely to change - data is derived or aggregated from published data of level 2A
  • 1D
    Data is published and unlikely to change - data is derived or aggregated from published data of level 1A
PROBE_CODE - char(8) (nominal)

ID: SP03806.PROBE_CODE

Probe number code indicates the measurement type, site, and sensor number (e.g., SOIPRI01)

Type system: Microsoft SQL Server 2019

Code definitions (58)
  • SWCPRI01
    Soil water content at PRIMET, probe no. 01 at depth 10 cm
  • SWCPRI02
    Soil water content at PRIMET, probe no. 02 at depth 20 cm
  • SWCPRI03
    Soil water content at PRIMET, probe no. 03 at depth 50 cm
  • SWCPRI04
    Soil water content at PRIMET, probe no. 04 at depth 100 cm
  • SWCCEN01
    Soil water content at CENMET, probe no. 01 at depth 10 cm
  • SWCCEN02
    Soil water content at CENMET, probe no. 02 at depth 20 cm
  • SWCCEN03
    Soil water content at CENMET, probe no. 03 at depth 50 cm
  • SWCCEN04
    Soil water content at CENMET, probe no. 04 at depth 100 cm
  • SWCUPL01
    Soil water content at UPLMET, probe no. 01 at depth 10 cm
  • SWCUPL02
    Soil water content at UPLMET, probe no. 02 at depth 20 cm
  • SWCUPL03
    Soil water content at UPLMET, probe no. 03 at depth 50 cm
  • SWCUPL04
    Soil water content at UPLMET, probe no. 04 at depth 100 cm
  • SWCVAN01
    Soil water content at VANMET, probe no. 01 at depth 10 cm
  • SWCVAN02
    Soil water content at VANMET, probe no. 02 at depth 20 cm
  • SWCVAN03
    Soil water content at VANMET, probe no. 03 at depth 50 cm
  • SWCVAN04
    Soil water content at VANMET, probe no. 04 at depth 100 cm
  • SMPCEN01
    Soil moisture potential at CENMET, probe no. 01 at depth 10 cm; discontinued 13 Nov 2002
  • SMPCEN02
    Soil moisture potential at CENMET, probe no. 02 at depth 20 cm; discontinued 13 Nov 2002
  • SMPCEN03
    Soil moisture potential at CENMET, probe no. 03 at depth 50 cm; discontinued 13 Nov 2002
  • SMPCEN04
    Soil moisture potential at CENMET, probe no. 04 at depth 100 cm; discontinued 13 Nov 2002
  • SMPPRI01
    Soil moisture potential at PRIMET, probe no. 01 at depth 10 cm; discontinued 23 May 2000
  • SMPPRI02
    Soil moisture potential at PRIMET, probe no. 02 at depth 20 cm; discontinued 23 May 2000
  • SMPPRI03
    Soil moisture potential at PRIMET, probe no. 03 at depth 50 cm; discontinued 23 May 2000
  • SMPPRI04
    Soil moisture potential at PRIMET, probe no. 04 at depth 100 cm; discontinued 23 May 2000
  • SMPUPL01
    Soil moisture potential at UPLMET, probe no. 01 at depth 10 cm; discontinued 18 Oct 2001
  • SMPUPL02
    Soil moisture potential at UPLMET, probe no. 02 at depth 20 cm; discontinued 18 Oct 2001
  • SMPUPL03
    Soil moisture potential at UPLMET, probe no. 03 at depth 50 cm; discontinued 18 Oct 2001
  • SMPUPL04
    Soil moisture potential at UPLMET, probe no. 04 at depth 100 cm; discontinued 18 Oct 2001
  • SMPVAN01
    Soil moisture potential at VANMET, probe no. 01 at depth 10 cm; discontinued 9 Sep 2001
  • SMPVAN02
    Soil moisture potential at VANMET, probe no. 02 at depth 20 cm; discontinued 9 Sep 2001
  • SMPVAN03
    Soil moisture potential at VANMET, probe no. 03 at depth 50 cm; discontinued 9 Sep 2001
  • SMPVAN04
    Soil moisture potential at VANMET, probe no. 04 at depth 100 cm; discontinued 9 Sep 2001
  • SMPVAN05
    Soil moisture potential at VANMET, probe no. 05 at depth 30 cm; discontinued 9 Sep 2001
  • SOICEN01
    Soil temperature at CENMET, probe no. 01 at depth10 cm
  • SOICEN02
    Soil temperature at CENMET, probe no. 02 at depth 20 cm
  • SOICEN03
    Soil temperature at CENMET, probe no. 03 at depth 50 cm
  • SOICEN04
    Soil temperature at CENMET, probe no. 04 at depth 100 cm
  • SOIPRI01
    Soil temperature at PRIMET, probe no. 01 at depth 10 cm
  • SOIPRI02
    Soil temperature at PRIMET, probe no. 02 at depth 20 cm
  • SOIPRI03
    Soil temperature at PRIMET, probe no. 03 at depth 50 cm
  • SOIPRI04
    Soil temperature at PRIMET, probe no. 04 at depth 100 cm
  • SOIUPL01
    Soil temperature at UPLMET, probe no. 01 at depth 10 cm
  • SOIUPL02
    Soil temperature at UPLMET, probe no. 02 at depth 20 cm
  • SOIUPL03
    Soil temperature at UPLMET, probe no. 03 at depth 50 cm
  • SOIUPL04
    Soil temperature at UPLMET, probe no. 04 at depth 100 cm
  • SOIVAN01
    Soil temperature at VANMET, probe no. 01 at depth 10 cm; discontinued 29 July 2007
  • SOIVAN02
    Soil temperature at VANMET, probe no. 02 at depth 20 cm; discontinued 29 July 2007
  • SOIVAN03
    Soil temperature at VANMET, probe no. 03 at depth 50 cm; discontinued 29 July 2007
  • SOIVAN04
    Soil temperature at VANMET, probe no. 04 at depth 100 cm; discontinued 29 July 2007
  • SOIVAN05
    Soil temperature at VANMET, probe no. 05 at depth 30 cm; discontinued 13 July 1994
  • SOIVAN06
    Soil temperature at VANMET, probe no. 06 at depth 10 cm; established 15 Sep 2004
  • SOIVAN07
    Soil temperature at VANMET, probe no. 07 at depth 20 cm; established 15 Sep 2004
  • SOIVAN08
    Soil temperature at VANMET, probe no. 08 at depth 50 cm; established 15 Sep 2004
  • SOIVAN09
    Soil temperature at VANMET, probe no. 09 at depth 100 cm; established 15 Sep 2004
  • SOIWS701
    Soil temperature at WS7MET, probe no. 01 at depth 10 cm; established 6 Dec 2006
  • SOIWS702
    Soil temperature at WS7MET, probe no. 02 at depth 20 cm; established 6 Dec 2006
  • SOIWS703
    Soil temperature at WS7MET, probe no. 03 at depth 50 cm; established 6 Dec 2006
  • SOIWS704
    Soil temperature at WS7MET, probe no. 04 at depth 100 cm; established 6 Dec 2006
DATE - datetime (dateTime)

ID: SP03806.DATE

Date of measurement

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

SOILMP_MEAN_DAY - numeric(5,2) (ratio)

ID: SP03806.SOILMP_MEAN_DAY

Mean soil moisture potential - the negative pressure exerted by a column of water - for the day

Type system: Microsoft SQL Server 2019

Unit: pressure in bars

Precision: 0.010000

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

SOILMP_MEAN_FLAG - char(1) (nominal)

ID: SP03806.SOILMP_MEAN_FLAG

Mean soil moisture potential flag

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • +
    Exceeds sensor calibration range at 15 negative bars
  • A
    Accepted value has passed all QC tests applied as represented by the quality level
  • M
    Missing value
  • Q
    Questionable value
  • S
    Daily value based on sunrise to sunrise
  • P
    Fire effects are visible in the data
SOILMP_MAX_DAY - numeric(5,2) (ratio)

ID: SP03806.SOILMP_MAX_DAY

Maximum soil moisture potential for the day

Type system: Microsoft SQL Server 2019

Unit: pressure in bars

Precision: 0.100000

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

SOILMP_MAX_FLAG - char(1) (nominal)

ID: SP03806.SOILMP_MAX_FLAG

Maximum soil moisture potential flag

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • +
    Exceeds sensor calibration range at 15 negative bars
  • A
    Accepted value has passed all QC tests applied as represented by the quality level
  • M
    Missing value
  • Q
    Questionable value
  • S
    Daily value based on sunrise to sunrise
  • P
    Fire effects are visible in the data
SOILMP_MAXTIME - char(4) (ordinal)

ID: SP03806.SOILMP_MAXTIME

Time of day (HHMM) in Pacific Standard Time (PST) of maximum soil moisture potential

Type system: Microsoft SQL Server 2019

SOILMP_MIN_DAY - numeric(5,2) (ratio)

ID: SP03806.SOILMP_MIN_DAY

Minimum soil moisture potential for the day

Type system: Microsoft SQL Server 2019

Unit: pressure in bars

Precision: 0.010000

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

SOILMP_MIN_FLAG - char(1) (nominal)

ID: SP03806.SOILMP_MIN_FLAG

Minimum soil moisture potential flag

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • +
    Exceeds sensor calibration range at 15 negative bars
  • A
    Accepted value has passed all QC tests applied as represented by the quality level
  • M
    Missing value
  • Q
    Questionable value
  • S
    Daily value based on sunrise to sunrise
  • P
    Fire effects are visible in the data
SOILMP_MINTIME - char(4) (ordinal)

ID: SP03806.SOILMP_MINTIME

Time of day (HHMM) in Pacific Standard Time (PST) of minimum soil moisture potential

Type system: Microsoft SQL Server 2019

EVENT_CODE - char(6) (nominal)

ID: SP03806.EVENT_CODE

Any event, disruption in protocol, or unusual conditions that occur at the given date or time and may have an effect on the data values; contact information manager for access to specific details from the field 'Notes' database

Type system: Microsoft SQL Server 2019

Code definitions (11)
  • INSREM
    Sensor is installed or removed
  • LOGGER
    Change in data logger, data logger program, or wiring
  • METHOD
    Change in data collection method
  • NA
    No event is reported (not applicable)
  • QUALTY
    Event may directly affect data quality (individual activities tracked in field notes database)
  • MAINTE
    A maintenance event has occurred
  • INTPRO
    Internal processing may produce an anomalous reading
  • WEATHR
    A weather event has occurred that may affect reading
  • CALIBR
    Associated with the inspection or replacement of sensors for calibration
  • CLEARD
    Site clearing of trees and brush around the meteorological station is being conducted
  • BURNED
    Burning, including cleared trees and brush or wildfire, around the meteorological station or within the watershed (code begins at event initiation)
SP03816 - Soil moisture potential (fine temporal resolution)

Object name: SP03816_v3.csv

Records: 112896

Attributes: 11

Temporal coverage: 1988-07-06 to 1994-07-14

File size: 8694293 byte

Checksum (MD5): df18ec9901ab8133db35953c1ab20541

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

Constraints (2)
  • primaryKey: PRIMARY
    SP03816.DATE_TIME, SP03816.PROBE_CODE, SP03816.SITECODE
  • notNullConstraint: NOTNULL
    SP03816.DATE_TIME, SP03816.ENTITY, SP03816.SOILMP_MEAN_FLAG, SP03816.EVENT_CODE, SP03816.QC_LEVEL, SP03816.SOILMP_METHOD, SP03816.DEPTH, SP03816.DBCODE, SP03816.PROBE_CODE, SP03816.SITECODE
Attributes (11)
DBCODE - char(5) (nominal)

ID: SP03816.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • SP038
    FSDB Database Code SP038
ENTITY - numeric(2,0) (interval)

ID: SP03816.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SITECODE - char(6) (nominal)

ID: SP03816.SITECODE

Site code for the meteorological measurement station

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • CENMET
    Central Meteorological Station
  • PRIMET
    Primary Meteorological Station
  • UPLMET
    Upper Lookout Meteorological Station
  • VANMET
    Vanilla Leaf Meteorological Station
  • WS7MET
    Watershed 7 Meteorological Station
SOILMP_METHOD - char(6) (nominal)

ID: SP03816.SOILMP_METHOD

An indication of the the general methodology and instrumentation used to collect this soil moisture potential data

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • SMP001
    Soil moisture potential is sampled by a Campbell Scientific model 223 gypsum soil moisture block at 10 cm depth; mean soil moisture potential in bars is output every 60 minutes
  • SMP002
    Soil moisture potential is sampled by a Campbell Scientific model 223 gypsum soil moisture block at 20 cm depth; mean soil moisture potential in bars is output every 60 minutes
  • SMP005
    Soil moisture potential is sampled by a Campbell Scientific model 223 gypsum soil moisture block at 30 cm depth; mean soil moisture potential in bars is output every 60 minutes
  • SMP101
    Mean daily soil moisture potential is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings; CS model 223 gypsum soil moisture block; 10cm depth (See Method SMP001)
  • SMP102
    Mean daily soil moisture potential is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings; CS model 223 gypsum soil moisture block; 20cm depth (See Method SMP002)
  • SMP103
    Mean daily soil moisture potential is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings; CS model 223 gypsum soil moisture block; 50cm depth
  • SMP104
    Mean daily soil moisture potential is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings; CS model 223 gypsum soil moisture block; 100 cm depth
  • SMP105
    Mean daily soil moisture potential is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings; CS model 223 gypsum soil moisture block; 30 cm depth (See Method SMP005)
  • SMP106
    No daily soil moisture potential is recorded or calculated during this period
DEPTH - numeric(4,0) (ratio)

ID: SP03816.DEPTH

Depth of sensor from ground surface

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

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

QC_LEVEL - char(2) (nominal)

ID: SP03816.QC_LEVEL

Quality control flag indicates level of quality checking performed including an indication of "provisional" data.

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • 1P
    Data is provisional and subject to revision - preliminary quality checks have been performed
  • 1A
    Data is published and unlikely to change - automated range checking and manual review has been conducted. Quality is indicated in data value qualifier flags.
  • 2A
    Data is published and unlikely to change - Level 1A data has been modified such that data gaps may be filled or problem data may be removed
  • 2D
    Data is published and unlikely to change - data is derived or aggregated from published data of level 2A
  • 1D
    Data is published and unlikely to change - data is derived or aggregated from published data of level 1A
PROBE_CODE - char(8) (nominal)

ID: SP03816.PROBE_CODE

Probe number code indicates the measurement type, site, and sensor number (e.g., SOIPRI01)

Type system: Microsoft SQL Server 2019

Code definitions (58)
  • SWCPRI01
    Soil water content at PRIMET, probe no. 01 at depth 10 cm
  • SWCPRI02
    Soil water content at PRIMET, probe no. 02 at depth 20 cm
  • SWCPRI03
    Soil water content at PRIMET, probe no. 03 at depth 50 cm
  • SWCPRI04
    Soil water content at PRIMET, probe no. 04 at depth 100 cm
  • SWCCEN01
    Soil water content at CENMET, probe no. 01 at depth 10 cm
  • SWCCEN02
    Soil water content at CENMET, probe no. 02 at depth 20 cm
  • SWCCEN03
    Soil water content at CENMET, probe no. 03 at depth 50 cm
  • SWCCEN04
    Soil water content at CENMET, probe no. 04 at depth 100 cm
  • SWCUPL01
    Soil water content at UPLMET, probe no. 01 at depth 10 cm
  • SWCUPL02
    Soil water content at UPLMET, probe no. 02 at depth 20 cm
  • SWCUPL03
    Soil water content at UPLMET, probe no. 03 at depth 50 cm
  • SWCUPL04
    Soil water content at UPLMET, probe no. 04 at depth 100 cm
  • SWCVAN01
    Soil water content at VANMET, probe no. 01 at depth 10 cm
  • SWCVAN02
    Soil water content at VANMET, probe no. 02 at depth 20 cm
  • SWCVAN03
    Soil water content at VANMET, probe no. 03 at depth 50 cm
  • SWCVAN04
    Soil water content at VANMET, probe no. 04 at depth 100 cm
  • SMPCEN01
    Soil moisture potential at CENMET, probe no. 01 at depth 10 cm; discontinued 13 Nov 2002
  • SMPCEN02
    Soil moisture potential at CENMET, probe no. 02 at depth 20 cm; discontinued 13 Nov 2002
  • SMPCEN03
    Soil moisture potential at CENMET, probe no. 03 at depth 50 cm; discontinued 13 Nov 2002
  • SMPCEN04
    Soil moisture potential at CENMET, probe no. 04 at depth 100 cm; discontinued 13 Nov 2002
  • SMPPRI01
    Soil moisture potential at PRIMET, probe no. 01 at depth 10 cm; discontinued 23 May 2000
  • SMPPRI02
    Soil moisture potential at PRIMET, probe no. 02 at depth 20 cm; discontinued 23 May 2000
  • SMPPRI03
    Soil moisture potential at PRIMET, probe no. 03 at depth 50 cm; discontinued 23 May 2000
  • SMPPRI04
    Soil moisture potential at PRIMET, probe no. 04 at depth 100 cm; discontinued 23 May 2000
  • SMPUPL01
    Soil moisture potential at UPLMET, probe no. 01 at depth 10 cm; discontinued 18 Oct 2001
  • SMPUPL02
    Soil moisture potential at UPLMET, probe no. 02 at depth 20 cm; discontinued 18 Oct 2001
  • SMPUPL03
    Soil moisture potential at UPLMET, probe no. 03 at depth 50 cm; discontinued 18 Oct 2001
  • SMPUPL04
    Soil moisture potential at UPLMET, probe no. 04 at depth 100 cm; discontinued 18 Oct 2001
  • SMPVAN01
    Soil moisture potential at VANMET, probe no. 01 at depth 10 cm; discontinued 9 Sep 2001
  • SMPVAN02
    Soil moisture potential at VANMET, probe no. 02 at depth 20 cm; discontinued 9 Sep 2001
  • SMPVAN03
    Soil moisture potential at VANMET, probe no. 03 at depth 50 cm; discontinued 9 Sep 2001
  • SMPVAN04
    Soil moisture potential at VANMET, probe no. 04 at depth 100 cm; discontinued 9 Sep 2001
  • SMPVAN05
    Soil moisture potential at VANMET, probe no. 05 at depth 30 cm; discontinued 9 Sep 2001
  • SOICEN01
    Soil temperature at CENMET, probe no. 01 at depth10 cm
  • SOICEN02
    Soil temperature at CENMET, probe no. 02 at depth 20 cm
  • SOICEN03
    Soil temperature at CENMET, probe no. 03 at depth 50 cm
  • SOICEN04
    Soil temperature at CENMET, probe no. 04 at depth 100 cm
  • SOIPRI01
    Soil temperature at PRIMET, probe no. 01 at depth 10 cm
  • SOIPRI02
    Soil temperature at PRIMET, probe no. 02 at depth 20 cm
  • SOIPRI03
    Soil temperature at PRIMET, probe no. 03 at depth 50 cm
  • SOIPRI04
    Soil temperature at PRIMET, probe no. 04 at depth 100 cm
  • SOIUPL01
    Soil temperature at UPLMET, probe no. 01 at depth 10 cm
  • SOIUPL02
    Soil temperature at UPLMET, probe no. 02 at depth 20 cm
  • SOIUPL03
    Soil temperature at UPLMET, probe no. 03 at depth 50 cm
  • SOIUPL04
    Soil temperature at UPLMET, probe no. 04 at depth 100 cm
  • SOIVAN01
    Soil temperature at VANMET, probe no. 01 at depth 10 cm; discontinued 29 July 2007
  • SOIVAN02
    Soil temperature at VANMET, probe no. 02 at depth 20 cm; discontinued 29 July 2007
  • SOIVAN03
    Soil temperature at VANMET, probe no. 03 at depth 50 cm; discontinued 29 July 2007
  • SOIVAN04
    Soil temperature at VANMET, probe no. 04 at depth 100 cm; discontinued 29 July 2007
  • SOIVAN05
    Soil temperature at VANMET, probe no. 05 at depth 30 cm; discontinued 13 July 1994
  • SOIVAN06
    Soil temperature at VANMET, probe no. 06 at depth 10 cm; established 15 Sep 2004
  • SOIVAN07
    Soil temperature at VANMET, probe no. 07 at depth 20 cm; established 15 Sep 2004
  • SOIVAN08
    Soil temperature at VANMET, probe no. 08 at depth 50 cm; established 15 Sep 2004
  • SOIVAN09
    Soil temperature at VANMET, probe no. 09 at depth 100 cm; established 15 Sep 2004
  • SOIWS701
    Soil temperature at WS7MET, probe no. 01 at depth 10 cm; established 6 Dec 2006
  • SOIWS702
    Soil temperature at WS7MET, probe no. 02 at depth 20 cm; established 6 Dec 2006
  • SOIWS703
    Soil temperature at WS7MET, probe no. 03 at depth 50 cm; established 6 Dec 2006
  • SOIWS704
    Soil temperature at WS7MET, probe no. 04 at depth 100 cm; established 6 Dec 2006
DATE_TIME - datetime (dateTime)

ID: SP03816.DATE_TIME

Date and time in Pacific Standard Time (PST) of sensor reading

Type system: Microsoft SQL Server 2019

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

SOILMP_MEAN - numeric(5,2) (ratio)

ID: SP03816.SOILMP_MEAN

Mean soil moisture potential - the negative pressure exerted by a column of water - over the last interval (e.g., 60 minutes)

Type system: Microsoft SQL Server 2019

Unit: pressure in bars

Precision: 0.010000

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

SOILMP_MEAN_FLAG - char(1) (nominal)

ID: SP03816.SOILMP_MEAN_FLAG

Mean soil moisture potential flag

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • +
    Exceeds sensor calibration range at 15 negative bars
  • A
    Accepted value has passed all QC tests applied as represented by the quality level
  • M
    Missing value
  • Q
    Questionable value
  • S
    Daily value based on sunrise to sunrise
  • P
    Fire effects are visible in the data
EVENT_CODE - char(6) (nominal)

ID: SP03816.EVENT_CODE

Any event, disruption in protocol, or unusual conditions that occur at the given date or time and may have an effect on the data values; contact information manager for access to specific details from the field 'Notes' database

Type system: Microsoft SQL Server 2019

Code definitions (11)
  • INSREM
    Sensor is installed or removed
  • LOGGER
    Change in data logger, data logger program, or wiring
  • METHOD
    Change in data collection method
  • NA
    No event is reported (not applicable)
  • QUALTY
    Event may directly affect data quality (individual activities tracked in field notes database)
  • MAINTE
    A maintenance event has occurred
  • INTPRO
    Internal processing may produce an anomalous reading
  • WEATHR
    A weather event has occurred that may affect reading
  • CALIBR
    Associated with the inspection or replacement of sensors for calibration
  • CLEARD
    Site clearing of trees and brush around the meteorological station is being conducted
  • BURNED
    Burning, including cleared trees and brush or wildfire, around the meteorological station or within the watershed (code begins at event initiation)
SP03821 - Soil temperature (daily)

Object name: SP03821_v7.csv

Records: 170764

Attributes: 17

Temporal coverage: 1987-06-16 to 2018-09-30

File size: 15309991 byte

Checksum (MD5): 2ec682495bac76e146a96d66ea21b1d3

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

Constraints (2)
  • primaryKey: PRIMARY
    SP03821.DATE, SP03821.PROBE_CODE, SP03821.SITECODE
  • notNullConstraint: NOTNULL
    SP03821.DATE, SP03821.ENTITY, SP03821.SOILTEMP_MEAN_FLAG, SP03821.SOILTEMP_MAX_FLAG, SP03821.SOILTEMP_MIN_FLAG, SP03821.EVENT_CODE, SP03821.QC_LEVEL, SP03821.SOILTEMP_METHOD, SP03821.DEPTH, SP03821.DBCODE, SP03821.PROBE_CODE, SP03821.SITECODE
Attributes (17)
DBCODE - char(5) (nominal)

ID: SP03821.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • SP038
    FSDB Database Code SP038
ENTITY - numeric(2,0) (interval)

ID: SP03821.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SITECODE - char(6) (nominal)

ID: SP03821.SITECODE

Site code for the meteorological measurement station

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • CENMET
    Central Meteorological Station
  • PRIMET
    Primary Meteorological Station
  • UPLMET
    Upper Lookout Meteorological Station
  • VANMET
    Vanilla Leaf Meteorological Station
  • WS7MET
    Watershed 7 Meteorological Station
SOILTEMP_METHOD - char(6) (nominal)

ID: SP03821.SOILTEMP_METHOD

An indication of the the general methodology and instrumentation used to collect this soil temperature data

Type system: Microsoft SQL Server 2019

Code definitions (37)
  • SOI001
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 10 cm depth; mean temperature is output every 60 minutes
  • SOI002
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 20 cm depth; mean temperature is output every 60 minutes
  • SOI003
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 50 cm depth; mean temperature is output every 60 minutes
  • SOI004
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 100 cm depth; mean temperature is output every 60 minutes
  • SOI005
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 30 cm depth; mean temperature is output every 60 minutes
  • SOI006
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor housed in PVC pipe at 10 cm depth; mean temperature is output every 60 minutes
  • SOI007
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor housed in PVC pipe at 20 cm depth; mean temperature is output every 60 minutes
  • SOI008
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor housed in PVC pipe at 50 cm depth; mean temperature is output every 60 minutes
  • SOI009
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor housed in PVC pipe at 100 cm depth; mean temperature is output every 60 minutes
  • SOI011
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 10 cm depth; mean temperature is output every 5 minutes
  • SOI012
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 20 cm depth; mean temperature is output every 5 minutes
  • SOI013
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 50 cm depth; mean temperature is output every 5 minutes
  • SOI014
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 100 cm depth; mean temperature is output every 5 minutes
  • SOI101
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings. CS Model 107; 10 cm depth (See method SOI001)
  • SOI102
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings. CS Model 107; 20 cm depth (See method SOI002)
  • SOI103
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings. CS Model 107; 50 cm depth (See method SOI003)
  • SOI104
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings. CS Model 107; 100 cm depth (See method SOI004)
  • SOI105
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings. CS Model 107; 30 cm depth (See method SOI005)
  • SOI106
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings. CS Model 107; 10 cm depth; housed in PVC pipe (See method SOI006)
  • SOI107
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings. CS Model 107; 20 cm depth; housed in PVC pipe (See method SOI007)
  • SOI108
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings. CS Model 107; 50 cm depth; housed in PVC pipe (See method SOI008)
  • SOI109
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings. CS Model 107; 100 cm depth; housed in PVC pipe (See method SOI009)
  • SOI111
    Mean daily soil temperature is post-calculated from all 5 minute mean values for the day. Max-min values are based on 5 minute mean intervals and not instantaneous values. CS Model 107; 10 cm depth (See method SOI011)
  • SOI112
    Mean daily soil temperature is post-calculated from all 5 minute mean values for the day. Max-min values are based on 5 minute mean intervals and not instantaneous values. CS Model 107; 20 cm depth (See method SOI012)
  • SOI113
    Mean daily soil temperature is post-calculated from all 5 minute mean values for the day. Max-min values are based on 5 minute mean intervals and not instantaneous values. CS Model 107; 50 cm depth (See method SOI013)
  • SOI114
    Mean daily soil temperature is post-calculated from all 5 minute mean values for the day. Max-min values are based on 5 minute mean intervals and not instantaneous values. CS Model 107; 100 cm depth (See method SOI014)
  • SOI201
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger and output on a sunrise to sunrise basis. Max-min values are based on instantaneous 15 second readings. CS Model 107; 10 cm depth
  • SOI202
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger and output on a sunrise to sunrise basis. Max-min values are based on instantaneous 15 second readings. CS Model 107; 20 cm depth
  • SOI203
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger and output on a sunrise to sunrise basis. Max-min values are based on instantaneous 15 second readings. CS Model 107; 30 cm depth
  • SOI016
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 10 cm depth; mean temperature is output every 10 minutes
  • SOI017
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 20 cm depth; mean temperature is output every 10 minutes
  • SOI018
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 50 cm depth; mean temperature is output every 10 minutes
  • SOI019
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 100 cm depth; mean temperature is output every 10 minutes
  • SOI216
    Mean daily soil temperature is post-calculated from all 10 minute mean values for the day. Max-min values are based on 10 minute mean intervals and not instantaneous values. CS Model 107; 10 cm depth (See method SOI016)
  • SOI217
    Mean daily soil temperature is post-calculated from all 10 minute mean values for the day. Max-min values are based on 10 minute mean intervals and not instantaneous values. CS Model 107; 20 cm depth (See method SOI017)
  • SOI218
    Mean daily soil temperature is post-calculated from all 10 minute mean values for the day. Max-min values are based on 10 minute mean intervals and not instantaneous values. CS Model 107; 50 cm depth (See method SOI018)
  • SOI219
    Mean daily soil temperature is post-calculated from all 10 minute mean values for the day. Max-min values are based on 10 minute mean intervals and not instantaneous values. CS Model 107; 100 cm depth (See method SOI019)
DEPTH - numeric(4,0) (ratio)

ID: SP03821.DEPTH

Depth of sensor from ground surface

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

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

QC_LEVEL - char(2) (nominal)

ID: SP03821.QC_LEVEL

Quality control flag indicates level of quality checking performed including an indication of "provisional" data.

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • 1P
    Data is provisional and subject to revision - preliminary quality checks have been performed
  • 1A
    Data is published and unlikely to change - automated range checking and manual review has been conducted. Quality is indicated in data value qualifier flags.
  • 2A
    Data is published and unlikely to change - Level 1A data has been modified such that data gaps may be filled or problem data may be removed
  • 2D
    Data is published and unlikely to change - data is derived or aggregated from published data of level 2A
  • 1D
    Data is published and unlikely to change - data is derived or aggregated from published data of level 1A
PROBE_CODE - char(8) (nominal)

ID: SP03821.PROBE_CODE

Probe number code indicates the measurement type, site, and sensor number (e.g., SOIPRI01)

Type system: Microsoft SQL Server 2019

Code definitions (58)
  • SWCPRI01
    Soil water content at PRIMET, probe no. 01 at depth 10 cm
  • SWCPRI02
    Soil water content at PRIMET, probe no. 02 at depth 20 cm
  • SWCPRI03
    Soil water content at PRIMET, probe no. 03 at depth 50 cm
  • SWCPRI04
    Soil water content at PRIMET, probe no. 04 at depth 100 cm
  • SWCCEN01
    Soil water content at CENMET, probe no. 01 at depth 10 cm
  • SWCCEN02
    Soil water content at CENMET, probe no. 02 at depth 20 cm
  • SWCCEN03
    Soil water content at CENMET, probe no. 03 at depth 50 cm
  • SWCCEN04
    Soil water content at CENMET, probe no. 04 at depth 100 cm
  • SWCUPL01
    Soil water content at UPLMET, probe no. 01 at depth 10 cm
  • SWCUPL02
    Soil water content at UPLMET, probe no. 02 at depth 20 cm
  • SWCUPL03
    Soil water content at UPLMET, probe no. 03 at depth 50 cm
  • SWCUPL04
    Soil water content at UPLMET, probe no. 04 at depth 100 cm
  • SWCVAN01
    Soil water content at VANMET, probe no. 01 at depth 10 cm
  • SWCVAN02
    Soil water content at VANMET, probe no. 02 at depth 20 cm
  • SWCVAN03
    Soil water content at VANMET, probe no. 03 at depth 50 cm
  • SWCVAN04
    Soil water content at VANMET, probe no. 04 at depth 100 cm
  • SMPCEN01
    Soil moisture potential at CENMET, probe no. 01 at depth 10 cm; discontinued 13 Nov 2002
  • SMPCEN02
    Soil moisture potential at CENMET, probe no. 02 at depth 20 cm; discontinued 13 Nov 2002
  • SMPCEN03
    Soil moisture potential at CENMET, probe no. 03 at depth 50 cm; discontinued 13 Nov 2002
  • SMPCEN04
    Soil moisture potential at CENMET, probe no. 04 at depth 100 cm; discontinued 13 Nov 2002
  • SMPPRI01
    Soil moisture potential at PRIMET, probe no. 01 at depth 10 cm; discontinued 23 May 2000
  • SMPPRI02
    Soil moisture potential at PRIMET, probe no. 02 at depth 20 cm; discontinued 23 May 2000
  • SMPPRI03
    Soil moisture potential at PRIMET, probe no. 03 at depth 50 cm; discontinued 23 May 2000
  • SMPPRI04
    Soil moisture potential at PRIMET, probe no. 04 at depth 100 cm; discontinued 23 May 2000
  • SMPUPL01
    Soil moisture potential at UPLMET, probe no. 01 at depth 10 cm; discontinued 18 Oct 2001
  • SMPUPL02
    Soil moisture potential at UPLMET, probe no. 02 at depth 20 cm; discontinued 18 Oct 2001
  • SMPUPL03
    Soil moisture potential at UPLMET, probe no. 03 at depth 50 cm; discontinued 18 Oct 2001
  • SMPUPL04
    Soil moisture potential at UPLMET, probe no. 04 at depth 100 cm; discontinued 18 Oct 2001
  • SMPVAN01
    Soil moisture potential at VANMET, probe no. 01 at depth 10 cm; discontinued 9 Sep 2001
  • SMPVAN02
    Soil moisture potential at VANMET, probe no. 02 at depth 20 cm; discontinued 9 Sep 2001
  • SMPVAN03
    Soil moisture potential at VANMET, probe no. 03 at depth 50 cm; discontinued 9 Sep 2001
  • SMPVAN04
    Soil moisture potential at VANMET, probe no. 04 at depth 100 cm; discontinued 9 Sep 2001
  • SMPVAN05
    Soil moisture potential at VANMET, probe no. 05 at depth 30 cm; discontinued 9 Sep 2001
  • SOICEN01
    Soil temperature at CENMET, probe no. 01 at depth10 cm
  • SOICEN02
    Soil temperature at CENMET, probe no. 02 at depth 20 cm
  • SOICEN03
    Soil temperature at CENMET, probe no. 03 at depth 50 cm
  • SOICEN04
    Soil temperature at CENMET, probe no. 04 at depth 100 cm
  • SOIPRI01
    Soil temperature at PRIMET, probe no. 01 at depth 10 cm
  • SOIPRI02
    Soil temperature at PRIMET, probe no. 02 at depth 20 cm
  • SOIPRI03
    Soil temperature at PRIMET, probe no. 03 at depth 50 cm
  • SOIPRI04
    Soil temperature at PRIMET, probe no. 04 at depth 100 cm
  • SOIUPL01
    Soil temperature at UPLMET, probe no. 01 at depth 10 cm
  • SOIUPL02
    Soil temperature at UPLMET, probe no. 02 at depth 20 cm
  • SOIUPL03
    Soil temperature at UPLMET, probe no. 03 at depth 50 cm
  • SOIUPL04
    Soil temperature at UPLMET, probe no. 04 at depth 100 cm
  • SOIVAN01
    Soil temperature at VANMET, probe no. 01 at depth 10 cm; discontinued 29 July 2007
  • SOIVAN02
    Soil temperature at VANMET, probe no. 02 at depth 20 cm; discontinued 29 July 2007
  • SOIVAN03
    Soil temperature at VANMET, probe no. 03 at depth 50 cm; discontinued 29 July 2007
  • SOIVAN04
    Soil temperature at VANMET, probe no. 04 at depth 100 cm; discontinued 29 July 2007
  • SOIVAN05
    Soil temperature at VANMET, probe no. 05 at depth 30 cm; discontinued 13 July 1994
  • SOIVAN06
    Soil temperature at VANMET, probe no. 06 at depth 10 cm; established 15 Sep 2004
  • SOIVAN07
    Soil temperature at VANMET, probe no. 07 at depth 20 cm; established 15 Sep 2004
  • SOIVAN08
    Soil temperature at VANMET, probe no. 08 at depth 50 cm; established 15 Sep 2004
  • SOIVAN09
    Soil temperature at VANMET, probe no. 09 at depth 100 cm; established 15 Sep 2004
  • SOIWS701
    Soil temperature at WS7MET, probe no. 01 at depth 10 cm; established 6 Dec 2006
  • SOIWS702
    Soil temperature at WS7MET, probe no. 02 at depth 20 cm; established 6 Dec 2006
  • SOIWS703
    Soil temperature at WS7MET, probe no. 03 at depth 50 cm; established 6 Dec 2006
  • SOIWS704
    Soil temperature at WS7MET, probe no. 04 at depth 100 cm; established 6 Dec 2006
DATE - datetime (dateTime)

ID: SP03821.DATE

Date of measurement

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

SOILTEMP_MEAN_DAY - numeric(5,1) (interval)

ID: SP03821.SOILTEMP_MEAN_DAY

Mean soil temperature for the day

Type system: Microsoft SQL Server 2019

Unit: degrees Celsius

Precision: 0.100000

Numeric domain: type=real, min=-1.8000 (exclusive=false), max=27.5000 (exclusive=false)

SOILTEMP_MEAN_FLAG - char(1) (nominal)

ID: SP03821.SOILTEMP_MEAN_FLAG

Mean soil temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • E
    Estimated value
  • M
    Missing
  • Q
    Questionable
  • S
    Daily value based on sunrise to sunrise
  • A
    Accepted value has passed all QC tests applied as represented by the quality level
  • P
    Fire effects are visible in the data
SOILTEMP_MAX_DAY - numeric(5,1) (interval)

ID: SP03821.SOILTEMP_MAX_DAY

Maximum soil temperature for the day

Type system: Microsoft SQL Server 2019

Unit: degrees Celsius

Precision: 0.100000

Numeric domain: type=real, min=-1.0000 (exclusive=false), max=36.7000 (exclusive=false)

SOILTEMP_MAX_FLAG - char(1) (nominal)

ID: SP03821.SOILTEMP_MAX_FLAG

Maximum soil temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • E
    Estimated value
  • M
    Missing
  • Q
    Questionable
  • S
    Daily value based on sunrise to sunrise
  • A
    Accepted value has passed all QC tests applied as represented by the quality level
  • P
    Fire effects are visible in the data
SOILTEMP_MAXTIME - char(4) (nominal)

ID: SP03821.SOILTEMP_MAXTIME

Time of day (HHMM) in Pacific Standard Time (PST) of maximum soil temperature

Type system: Microsoft SQL Server 2019

SOILTEMP_MIN_DAY - numeric(5,1) (interval)

ID: SP03821.SOILTEMP_MIN_DAY

Minimum soil temperature for the day

Type system: Microsoft SQL Server 2019

Unit: degrees Celsius

Precision: 0.100000

Numeric domain: type=real, min=-2.9000 (exclusive=false), max=26.8000 (exclusive=false)

SOILTEMP_MIN_FLAG - char(1) (nominal)

ID: SP03821.SOILTEMP_MIN_FLAG

Minimum soil temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • E
    Estimated value
  • M
    Missing
  • Q
    Questionable
  • S
    Daily value based on sunrise to sunrise
  • A
    Accepted value has passed all QC tests applied as represented by the quality level
  • P
    Fire effects are visible in the data
SOILTEMP_MINTIME - char(4) (nominal)

ID: SP03821.SOILTEMP_MINTIME

Time of day (HHMM) in Pacific Standard Time (PST) of minimum soil temperature

Type system: Microsoft SQL Server 2019

EVENT_CODE - char(6) (nominal)

ID: SP03821.EVENT_CODE

Any event, disruption in protocol, or unusual conditions that occur at the given date or time and may have an effect on the data values; contact information manager for access to specific details from the field 'Notes' database

Type system: Microsoft SQL Server 2019

Code definitions (11)
  • INSREM
    Sensor is installed or removed
  • LOGGER
    Change in data logger, data logger program, or wiring
  • METHOD
    Change in data collection method
  • NA
    No event is reported (not applicable)
  • QUALTY
    Event may directly affect data quality (individual activities tracked in field notes database)
  • MAINTE
    A maintenance event has occurred
  • INTPRO
    Internal processing may produce an anomalous reading
  • WEATHR
    A weather event has occurred that may affect reading
  • CALIBR
    Associated with the inspection or replacement of sensors for calibration
  • CLEARD
    Site clearing of trees and brush around the meteorological station is being conducted
  • BURNED
    Burning, including cleared trees and brush or wildfire, around the meteorological station or within the watershed (code begins at event initiation)
SP03823 - Soil water content (daily)

Object name: SP03823_v7.csv

Records: 102408

Attributes: 17

Temporal coverage: 1998-06-04 to 2018-09-30

File size: 9361611 byte

Checksum (MD5): e846d5d7dfc4d4970142a07e7eefaf65

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

Constraints (2)
  • primaryKey: PRIMARY
    SP03823.DATE, SP03823.PROBE_CODE, SP03823.SITECODE
  • notNullConstraint: NOTNULL
    SP03823.DATE, SP03823.ENTITY, SP03823.SOILWC_MEAN_FLAG, SP03823.SOILWC_MAX_FLAG, SP03823.SOILWC_MIN_FLAG, SP03823.EVENT_CODE, SP03823.QC_LEVEL, SP03823.DEPTH, SP03823.SOILWC_METHOD, SP03823.DBCODE, SP03823.PROBE_CODE, SP03823.SITECODE
Attributes (17)
DBCODE - char(5) (nominal)

ID: SP03823.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • SP038
    FSDB Database Code SP038
ENTITY - numeric(2,0) (interval)

ID: SP03823.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SITECODE - char(6) (nominal)

ID: SP03823.SITECODE

Site code for the meteorological measurement station

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • CENMET
    Central Meteorological Station
  • PRIMET
    Primary Meteorological Station
  • UPLMET
    Upper Lookout Meteorological Station
  • VANMET
    Vanilla Leaf Meteorological Station
  • WS7MET
    Watershed 7 Meteorological Station
SOILWC_METHOD - char(6) (nominal)

ID: SP03823.SOILWC_METHOD

An indication of the the general methodology and instrumentation used to collect this soil water content data

Type system: Microsoft SQL Server 2019

Code definitions (16)
  • SWC101
    Mean daily soil volumetric water content at 10 cm depth is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values based on instantaneous 15 second readings. Model CS615 water content reflectometer (See Method SWC001)
  • SWC102
    Mean daily soil volumetric water content at 20 cm depth is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values based on instantaneous 15 second readings. Model CS615 water content reflectometer (See Method SWC002)
  • SWC103
    Mean daily soil volumetric water content at 50 cm depth is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values based on instantaneous 15 second readings. Model CS615 water content reflectometer (See Method SWC003)
  • SWC104
    Mean daily soil volumetric water content at 100 cm depth is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values based on instantaneous 15 second readings. Model CS615 water content reflectometer (See Method SWC004)
  • SWC001
    Soil volumetric water content is sampled by a Campbell Scientific model 615 water content reflectometer placed horizontally in soil at 10 cm depth; mean soil volumetric water content on a fractional basis is output every 60 minutes
  • SWC002
    Soil volumetric water content is sampled by a Campbell Scientific model 615 water content reflectometer placed horizontally in soil at 20 cm depth; mean soil volumetric water content on a fractional basis is output every 60 minutes
  • SWC003
    Soil volumetric water content is sampled by a Campbell Scientific model 615 water content reflectometer placed horizontally in soil at 50 cm depth; mean soil volumetric water content on a fractional basis is output every 60 minutes
  • SWC004
    Soil volumetric water content is sampled by a Campbell Scientific model 615 water content reflectometer placed horizontally in soil at 100 cm depth; mean soil volumetric water content on a fractional basis is output every 60 minutes
  • SWC005
    Soil volumetric water content is sampled by a Campbell Scientific model 615 water content reflectometer placed horizontally in soil at 10 cm depth; mean soil volumetric water content on a fractional basis is output every 5 minutes
  • SWC006
    Soil volumetric water content is sampled by a Campbell Scientific model 615 water content reflectometer placed horizontally in soil at 20 cm depth; mean soil volumetric water content on a fractional basis is output every 5 minutes
  • SWC007
    Soil volumetric water content is sampled by a Campbell Scientific model 615 water content reflectometer placed horizontally in soil at 50 cm depth; mean soil volumetric water content on a fractional basis is output every 5 minutes
  • SWC008
    Soil volumetric water content is sampled by a Campbell Scientific model 615 water content reflectometer placed horizontally in soil at 100 cm depth; mean soil volumetric water content on a fractional basis is output every 5 minutes
  • SWC105
    Mean daily soil volumetric water content is post-calculated from all 5 minute mean values for the day. Max-min values are based on 5 minute mean intervals and not instantaneous values. Model CS615 water content reflectometer; 10cm dep (See method SWC005)
  • SWC106
    Mean daily soil volumetric water content is post-calculated from all 5 minute mean values for the day. Max-min values are based on 5 minute mean intervals and not instantaneous values. Model CS615 water content reflectometer; 20cm dep (See method SWC006)
  • SWC107
    Mean daily soil volumetric water content is post-calculated from all 5 minute mean values for the day. Max-min values are based on 5 minute mean intervals and not instantaneous values. Model CS615 water content reflectometer; 50cm dep (See method SWC007)
  • SWC108
    Mean daily soil volumetric water content is post-calculated from all 5 minute mean values for the day. Max-min values are based on 5 minute mean intervals and not instantaneous values. Model CS615 water content reflectometer;100cm dep (See method SWC008)
DEPTH - numeric(4,0) (ratio)

ID: SP03823.DEPTH

Depth of sensor from ground surface

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

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

QC_LEVEL - char(2) (nominal)

ID: SP03823.QC_LEVEL

Quality control flag indicates level of quality checking performed including an indication of "provisional" data.

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • 1P
    Data is provisional and subject to revision - preliminary quality checks have been performed
  • 1A
    Data is published and unlikely to change - automated range checking and manual review has been conducted. Quality is indicated in data value qualifier flags.
  • 2A
    Data is published and unlikely to change - Level 1A data has been modified such that data gaps may be filled or problem data may be removed
  • 2D
    Data is published and unlikely to change - data is derived or aggregated from published data of level 2A
  • 1D
    Data is published and unlikely to change - data is derived or aggregated from published data of level 1A
PROBE_CODE - char(8) (nominal)

ID: SP03823.PROBE_CODE

Probe number code indicates the measurement type, site, and sensor number (e.g., SOIPRI01)

Type system: Microsoft SQL Server 2019

Code definitions (58)
  • SWCPRI01
    Soil water content at PRIMET, probe no. 01 at depth 10 cm
  • SWCPRI02
    Soil water content at PRIMET, probe no. 02 at depth 20 cm
  • SWCPRI03
    Soil water content at PRIMET, probe no. 03 at depth 50 cm
  • SWCPRI04
    Soil water content at PRIMET, probe no. 04 at depth 100 cm
  • SWCCEN01
    Soil water content at CENMET, probe no. 01 at depth 10 cm
  • SWCCEN02
    Soil water content at CENMET, probe no. 02 at depth 20 cm
  • SWCCEN03
    Soil water content at CENMET, probe no. 03 at depth 50 cm
  • SWCCEN04
    Soil water content at CENMET, probe no. 04 at depth 100 cm
  • SWCUPL01
    Soil water content at UPLMET, probe no. 01 at depth 10 cm
  • SWCUPL02
    Soil water content at UPLMET, probe no. 02 at depth 20 cm
  • SWCUPL03
    Soil water content at UPLMET, probe no. 03 at depth 50 cm
  • SWCUPL04
    Soil water content at UPLMET, probe no. 04 at depth 100 cm
  • SWCVAN01
    Soil water content at VANMET, probe no. 01 at depth 10 cm
  • SWCVAN02
    Soil water content at VANMET, probe no. 02 at depth 20 cm
  • SWCVAN03
    Soil water content at VANMET, probe no. 03 at depth 50 cm
  • SWCVAN04
    Soil water content at VANMET, probe no. 04 at depth 100 cm
  • SMPCEN01
    Soil moisture potential at CENMET, probe no. 01 at depth 10 cm; discontinued 13 Nov 2002
  • SMPCEN02
    Soil moisture potential at CENMET, probe no. 02 at depth 20 cm; discontinued 13 Nov 2002
  • SMPCEN03
    Soil moisture potential at CENMET, probe no. 03 at depth 50 cm; discontinued 13 Nov 2002
  • SMPCEN04
    Soil moisture potential at CENMET, probe no. 04 at depth 100 cm; discontinued 13 Nov 2002
  • SMPPRI01
    Soil moisture potential at PRIMET, probe no. 01 at depth 10 cm; discontinued 23 May 2000
  • SMPPRI02
    Soil moisture potential at PRIMET, probe no. 02 at depth 20 cm; discontinued 23 May 2000
  • SMPPRI03
    Soil moisture potential at PRIMET, probe no. 03 at depth 50 cm; discontinued 23 May 2000
  • SMPPRI04
    Soil moisture potential at PRIMET, probe no. 04 at depth 100 cm; discontinued 23 May 2000
  • SMPUPL01
    Soil moisture potential at UPLMET, probe no. 01 at depth 10 cm; discontinued 18 Oct 2001
  • SMPUPL02
    Soil moisture potential at UPLMET, probe no. 02 at depth 20 cm; discontinued 18 Oct 2001
  • SMPUPL03
    Soil moisture potential at UPLMET, probe no. 03 at depth 50 cm; discontinued 18 Oct 2001
  • SMPUPL04
    Soil moisture potential at UPLMET, probe no. 04 at depth 100 cm; discontinued 18 Oct 2001
  • SMPVAN01
    Soil moisture potential at VANMET, probe no. 01 at depth 10 cm; discontinued 9 Sep 2001
  • SMPVAN02
    Soil moisture potential at VANMET, probe no. 02 at depth 20 cm; discontinued 9 Sep 2001
  • SMPVAN03
    Soil moisture potential at VANMET, probe no. 03 at depth 50 cm; discontinued 9 Sep 2001
  • SMPVAN04
    Soil moisture potential at VANMET, probe no. 04 at depth 100 cm; discontinued 9 Sep 2001
  • SMPVAN05
    Soil moisture potential at VANMET, probe no. 05 at depth 30 cm; discontinued 9 Sep 2001
  • SOICEN01
    Soil temperature at CENMET, probe no. 01 at depth10 cm
  • SOICEN02
    Soil temperature at CENMET, probe no. 02 at depth 20 cm
  • SOICEN03
    Soil temperature at CENMET, probe no. 03 at depth 50 cm
  • SOICEN04
    Soil temperature at CENMET, probe no. 04 at depth 100 cm
  • SOIPRI01
    Soil temperature at PRIMET, probe no. 01 at depth 10 cm
  • SOIPRI02
    Soil temperature at PRIMET, probe no. 02 at depth 20 cm
  • SOIPRI03
    Soil temperature at PRIMET, probe no. 03 at depth 50 cm
  • SOIPRI04
    Soil temperature at PRIMET, probe no. 04 at depth 100 cm
  • SOIUPL01
    Soil temperature at UPLMET, probe no. 01 at depth 10 cm
  • SOIUPL02
    Soil temperature at UPLMET, probe no. 02 at depth 20 cm
  • SOIUPL03
    Soil temperature at UPLMET, probe no. 03 at depth 50 cm
  • SOIUPL04
    Soil temperature at UPLMET, probe no. 04 at depth 100 cm
  • SOIVAN01
    Soil temperature at VANMET, probe no. 01 at depth 10 cm; discontinued 29 July 2007
  • SOIVAN02
    Soil temperature at VANMET, probe no. 02 at depth 20 cm; discontinued 29 July 2007
  • SOIVAN03
    Soil temperature at VANMET, probe no. 03 at depth 50 cm; discontinued 29 July 2007
  • SOIVAN04
    Soil temperature at VANMET, probe no. 04 at depth 100 cm; discontinued 29 July 2007
  • SOIVAN05
    Soil temperature at VANMET, probe no. 05 at depth 30 cm; discontinued 13 July 1994
  • SOIVAN06
    Soil temperature at VANMET, probe no. 06 at depth 10 cm; established 15 Sep 2004
  • SOIVAN07
    Soil temperature at VANMET, probe no. 07 at depth 20 cm; established 15 Sep 2004
  • SOIVAN08
    Soil temperature at VANMET, probe no. 08 at depth 50 cm; established 15 Sep 2004
  • SOIVAN09
    Soil temperature at VANMET, probe no. 09 at depth 100 cm; established 15 Sep 2004
  • SOIWS701
    Soil temperature at WS7MET, probe no. 01 at depth 10 cm; established 6 Dec 2006
  • SOIWS702
    Soil temperature at WS7MET, probe no. 02 at depth 20 cm; established 6 Dec 2006
  • SOIWS703
    Soil temperature at WS7MET, probe no. 03 at depth 50 cm; established 6 Dec 2006
  • SOIWS704
    Soil temperature at WS7MET, probe no. 04 at depth 100 cm; established 6 Dec 2006
DATE - datetime (dateTime)

ID: SP03823.DATE

Date of measurement

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

SOILWC_MEAN_DAY - numeric(5,2) (ratio)

ID: SP03823.SOILWC_MEAN_DAY

Mean soil volumetric water content on a fractional basis (values are 0 to 1) for the day

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 0.020000

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

SOILWC_MEAN_FLAG - char(1) (nominal)

ID: SP03823.SOILWC_MEAN_FLAG

Mean soil water content flag

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • E
    Estimated value
  • M
    Missing
  • Q
    Questionable
  • A
    Accepted value has passed all QC tests applied as represented by the quality level
  • F
    Observed value is above field (or water holding) capacity but the data point is still potentially valid and reliable for analysis
  • P
    Fire effects are visible in the data
SOILWC_MAX_DAY - numeric(5,2) (ratio)

ID: SP03823.SOILWC_MAX_DAY

Maximum soil volumetric water content on a fractional basis (values are 0 to 1) for the day

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 0.020000

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

SOILWC_MAX_FLAG - char(1) (nominal)

ID: SP03823.SOILWC_MAX_FLAG

Maximum soil water content flag

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • E
    Estimated value
  • M
    Missing
  • Q
    Questionable
  • A
    Accepted value has passed all QC tests applied as represented by the quality level
  • P
    Fire effects are visible in the data
SOILWC_MAXTIME - char(4) (ordinal)

ID: SP03823.SOILWC_MAXTIME

Time of day (HHMM) in Pacific Standard Time (PST) of maximum soil water content

Type system: Microsoft SQL Server 2019

SOILWC_MIN_DAY - numeric(5,2) (ratio)

ID: SP03823.SOILWC_MIN_DAY

Minimum soil volumetric water content on a fractional basis (values are 0 to 1)

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 0.020000

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

SOILWC_MIN_FLAG - char(1) (nominal)

ID: SP03823.SOILWC_MIN_FLAG

Minimum soil water content flag

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • E
    Estimated value
  • M
    Missing
  • Q
    Questionable
  • A
    Accepted value has passed all QC tests applied as represented by the quality level
  • P
    Fire effects are visible in the data
SOILWC_MINTIME - char(4) (ordinal)

ID: SP03823.SOILWC_MINTIME

Time of day (HHMM) in Pacific Standard Time (PST) of minimum soil water content

Type system: Microsoft SQL Server 2019

EVENT_CODE - char(6) (nominal)

ID: SP03823.EVENT_CODE

Any event, disruption in protocol, or unusual conditions that occur at the given date or time and may have an effect on the data values; contact information manager for access to specific details from the field 'Notes' database

Type system: Microsoft SQL Server 2019

Code definitions (11)
  • INSREM
    Sensor is installed or removed
  • LOGGER
    Change in data logger, data logger program, or wiring
  • METHOD
    Change in data collection method
  • NA
    No event is reported (not applicable)
  • QUALTY
    Event may directly affect data quality (individual activities tracked in field notes database)
  • MAINTE
    A maintenance event has occurred
  • INTPRO
    Internal processing may produce an anomalous reading
  • WEATHR
    A weather event has occurred that may affect reading
  • CALIBR
    Associated with the inspection or replacement of sensors for calibration
  • CLEARD
    Site clearing of trees and brush around the meteorological station is being conducted
  • BURNED
    Burning, including cleared trees and brush or wildfire, around the meteorological station or within the watershed (code begins at event initiation)
SP03831 - Soil temperature (fine temporal resolution)

Object name: SP03831_v7.txt

Records: 25582701

Attributes: 11

Temporal coverage: 1988-07-06 to 2024-10-01

File size: 1957580829 byte

Checksum (MD5): 3a7d047da2b6534ca1b6b833d29b45f7

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

Constraints (2)
  • primaryKey: PRIMARY
    SP03831.DATE_TIME, SP03831.PROBE_CODE, SP03831.SITECODE
  • notNullConstraint: NOTNULL
    SP03831.DATE_TIME, SP03831.ENTITY, SP03831.SOILTEMP_MEAN_FLAG, SP03831.EVENT_CODE, SP03831.QC_LEVEL, SP03831.SOILTEMP_METHOD, SP03831.DEPTH, SP03831.DBCODE, SP03831.PROBE_CODE, SP03831.SITECODE
Attributes (11)
DBCODE - char(5) (nominal)

ID: SP03831.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • SP038
    FSDB Database Code SP038
ENTITY - numeric(2,0) (interval)

ID: SP03831.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SITECODE - char(6) (nominal)

ID: SP03831.SITECODE

Site code for the meteorological measurement station

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • CENMET
    Central Meteorological Station
  • PRIMET
    Primary Meteorological Station
  • UPLMET
    Upper Lookout Meteorological Station
  • VANMET
    Vanilla Leaf Meteorological Station
  • WS7MET
    Watershed 7 Meteorological Station
SOILTEMP_METHOD - char(6) (nominal)

ID: SP03831.SOILTEMP_METHOD

An indication of the the general methodology and instrumentation used to collect this soil temperature data

Type system: Microsoft SQL Server 2019

Code definitions (37)
  • SOI001
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 10 cm depth; mean temperature is output every 60 minutes
  • SOI002
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 20 cm depth; mean temperature is output every 60 minutes
  • SOI003
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 50 cm depth; mean temperature is output every 60 minutes
  • SOI004
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 100 cm depth; mean temperature is output every 60 minutes
  • SOI005
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 30 cm depth; mean temperature is output every 60 minutes
  • SOI006
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor housed in PVC pipe at 10 cm depth; mean temperature is output every 60 minutes
  • SOI007
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor housed in PVC pipe at 20 cm depth; mean temperature is output every 60 minutes
  • SOI008
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor housed in PVC pipe at 50 cm depth; mean temperature is output every 60 minutes
  • SOI009
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor housed in PVC pipe at 100 cm depth; mean temperature is output every 60 minutes
  • SOI011
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 10 cm depth; mean temperature is output every 5 minutes
  • SOI012
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 20 cm depth; mean temperature is output every 5 minutes
  • SOI013
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 50 cm depth; mean temperature is output every 5 minutes
  • SOI014
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 100 cm depth; mean temperature is output every 5 minutes
  • SOI101
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings. CS Model 107; 10 cm depth (See method SOI001)
  • SOI102
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings. CS Model 107; 20 cm depth (See method SOI002)
  • SOI103
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings. CS Model 107; 50 cm depth (See method SOI003)
  • SOI104
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings. CS Model 107; 100 cm depth (See method SOI004)
  • SOI105
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings. CS Model 107; 30 cm depth (See method SOI005)
  • SOI106
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings. CS Model 107; 10 cm depth; housed in PVC pipe (See method SOI006)
  • SOI107
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings. CS Model 107; 20 cm depth; housed in PVC pipe (See method SOI007)
  • SOI108
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings. CS Model 107; 50 cm depth; housed in PVC pipe (See method SOI008)
  • SOI109
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values are based on instantaneous 15 second readings. CS Model 107; 100 cm depth; housed in PVC pipe (See method SOI009)
  • SOI111
    Mean daily soil temperature is post-calculated from all 5 minute mean values for the day. Max-min values are based on 5 minute mean intervals and not instantaneous values. CS Model 107; 10 cm depth (See method SOI011)
  • SOI112
    Mean daily soil temperature is post-calculated from all 5 minute mean values for the day. Max-min values are based on 5 minute mean intervals and not instantaneous values. CS Model 107; 20 cm depth (See method SOI012)
  • SOI113
    Mean daily soil temperature is post-calculated from all 5 minute mean values for the day. Max-min values are based on 5 minute mean intervals and not instantaneous values. CS Model 107; 50 cm depth (See method SOI013)
  • SOI114
    Mean daily soil temperature is post-calculated from all 5 minute mean values for the day. Max-min values are based on 5 minute mean intervals and not instantaneous values. CS Model 107; 100 cm depth (See method SOI014)
  • SOI201
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger and output on a sunrise to sunrise basis. Max-min values are based on instantaneous 15 second readings. CS Model 107; 10 cm depth
  • SOI202
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger and output on a sunrise to sunrise basis. Max-min values are based on instantaneous 15 second readings. CS Model 107; 20 cm depth
  • SOI203
    Mean daily soil temperature is calculated by the Campbell Scientific datalogger and output on a sunrise to sunrise basis. Max-min values are based on instantaneous 15 second readings. CS Model 107; 30 cm depth
  • SOI016
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 10 cm depth; mean temperature is output every 10 minutes
  • SOI017
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 20 cm depth; mean temperature is output every 10 minutes
  • SOI018
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 50 cm depth; mean temperature is output every 10 minutes
  • SOI019
    Soil temperature is sampled by a Campbell Scientific model 107 thermistor placed directly in soil at 100 cm depth; mean temperature is output every 10 minutes
  • SOI216
    Mean daily soil temperature is post-calculated from all 10 minute mean values for the day. Max-min values are based on 10 minute mean intervals and not instantaneous values. CS Model 107; 10 cm depth (See method SOI016)
  • SOI217
    Mean daily soil temperature is post-calculated from all 10 minute mean values for the day. Max-min values are based on 10 minute mean intervals and not instantaneous values. CS Model 107; 20 cm depth (See method SOI017)
  • SOI218
    Mean daily soil temperature is post-calculated from all 10 minute mean values for the day. Max-min values are based on 10 minute mean intervals and not instantaneous values. CS Model 107; 50 cm depth (See method SOI018)
  • SOI219
    Mean daily soil temperature is post-calculated from all 10 minute mean values for the day. Max-min values are based on 10 minute mean intervals and not instantaneous values. CS Model 107; 100 cm depth (See method SOI019)
DEPTH - numeric(4,0) (ratio)

ID: SP03831.DEPTH

Depth of sensor from ground surface

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

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

QC_LEVEL - char(2) (nominal)

ID: SP03831.QC_LEVEL

Quality control flag indicates level of quality checking performed including an indication of "provisional" data.

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • 1P
    Data is provisional and subject to revision - preliminary quality checks have been performed
  • 1A
    Data is published and unlikely to change - automated range checking and manual review has been conducted. Quality is indicated in data value qualifier flags.
  • 2A
    Data is published and unlikely to change - Level 1A data has been modified such that data gaps may be filled or problem data may be removed
  • 2D
    Data is published and unlikely to change - data is derived or aggregated from published data of level 2A
  • 1D
    Data is published and unlikely to change - data is derived or aggregated from published data of level 1A
PROBE_CODE - char(8) (nominal)

ID: SP03831.PROBE_CODE

Probe number code indicates the measurement type, site, and sensor number (e.g., SOIPRI01)

Type system: Microsoft SQL Server 2019

Code definitions (58)
  • SWCPRI01
    Soil water content at PRIMET, probe no. 01 at depth 10 cm
  • SWCPRI02
    Soil water content at PRIMET, probe no. 02 at depth 20 cm
  • SWCPRI03
    Soil water content at PRIMET, probe no. 03 at depth 50 cm
  • SWCPRI04
    Soil water content at PRIMET, probe no. 04 at depth 100 cm
  • SWCCEN01
    Soil water content at CENMET, probe no. 01 at depth 10 cm
  • SWCCEN02
    Soil water content at CENMET, probe no. 02 at depth 20 cm
  • SWCCEN03
    Soil water content at CENMET, probe no. 03 at depth 50 cm
  • SWCCEN04
    Soil water content at CENMET, probe no. 04 at depth 100 cm
  • SWCUPL01
    Soil water content at UPLMET, probe no. 01 at depth 10 cm
  • SWCUPL02
    Soil water content at UPLMET, probe no. 02 at depth 20 cm
  • SWCUPL03
    Soil water content at UPLMET, probe no. 03 at depth 50 cm
  • SWCUPL04
    Soil water content at UPLMET, probe no. 04 at depth 100 cm
  • SWCVAN01
    Soil water content at VANMET, probe no. 01 at depth 10 cm
  • SWCVAN02
    Soil water content at VANMET, probe no. 02 at depth 20 cm
  • SWCVAN03
    Soil water content at VANMET, probe no. 03 at depth 50 cm
  • SWCVAN04
    Soil water content at VANMET, probe no. 04 at depth 100 cm
  • SMPCEN01
    Soil moisture potential at CENMET, probe no. 01 at depth 10 cm; discontinued 13 Nov 2002
  • SMPCEN02
    Soil moisture potential at CENMET, probe no. 02 at depth 20 cm; discontinued 13 Nov 2002
  • SMPCEN03
    Soil moisture potential at CENMET, probe no. 03 at depth 50 cm; discontinued 13 Nov 2002
  • SMPCEN04
    Soil moisture potential at CENMET, probe no. 04 at depth 100 cm; discontinued 13 Nov 2002
  • SMPPRI01
    Soil moisture potential at PRIMET, probe no. 01 at depth 10 cm; discontinued 23 May 2000
  • SMPPRI02
    Soil moisture potential at PRIMET, probe no. 02 at depth 20 cm; discontinued 23 May 2000
  • SMPPRI03
    Soil moisture potential at PRIMET, probe no. 03 at depth 50 cm; discontinued 23 May 2000
  • SMPPRI04
    Soil moisture potential at PRIMET, probe no. 04 at depth 100 cm; discontinued 23 May 2000
  • SMPUPL01
    Soil moisture potential at UPLMET, probe no. 01 at depth 10 cm; discontinued 18 Oct 2001
  • SMPUPL02
    Soil moisture potential at UPLMET, probe no. 02 at depth 20 cm; discontinued 18 Oct 2001
  • SMPUPL03
    Soil moisture potential at UPLMET, probe no. 03 at depth 50 cm; discontinued 18 Oct 2001
  • SMPUPL04
    Soil moisture potential at UPLMET, probe no. 04 at depth 100 cm; discontinued 18 Oct 2001
  • SMPVAN01
    Soil moisture potential at VANMET, probe no. 01 at depth 10 cm; discontinued 9 Sep 2001
  • SMPVAN02
    Soil moisture potential at VANMET, probe no. 02 at depth 20 cm; discontinued 9 Sep 2001
  • SMPVAN03
    Soil moisture potential at VANMET, probe no. 03 at depth 50 cm; discontinued 9 Sep 2001
  • SMPVAN04
    Soil moisture potential at VANMET, probe no. 04 at depth 100 cm; discontinued 9 Sep 2001
  • SMPVAN05
    Soil moisture potential at VANMET, probe no. 05 at depth 30 cm; discontinued 9 Sep 2001
  • SOICEN01
    Soil temperature at CENMET, probe no. 01 at depth10 cm
  • SOICEN02
    Soil temperature at CENMET, probe no. 02 at depth 20 cm
  • SOICEN03
    Soil temperature at CENMET, probe no. 03 at depth 50 cm
  • SOICEN04
    Soil temperature at CENMET, probe no. 04 at depth 100 cm
  • SOIPRI01
    Soil temperature at PRIMET, probe no. 01 at depth 10 cm
  • SOIPRI02
    Soil temperature at PRIMET, probe no. 02 at depth 20 cm
  • SOIPRI03
    Soil temperature at PRIMET, probe no. 03 at depth 50 cm
  • SOIPRI04
    Soil temperature at PRIMET, probe no. 04 at depth 100 cm
  • SOIUPL01
    Soil temperature at UPLMET, probe no. 01 at depth 10 cm
  • SOIUPL02
    Soil temperature at UPLMET, probe no. 02 at depth 20 cm
  • SOIUPL03
    Soil temperature at UPLMET, probe no. 03 at depth 50 cm
  • SOIUPL04
    Soil temperature at UPLMET, probe no. 04 at depth 100 cm
  • SOIVAN01
    Soil temperature at VANMET, probe no. 01 at depth 10 cm; discontinued 29 July 2007
  • SOIVAN02
    Soil temperature at VANMET, probe no. 02 at depth 20 cm; discontinued 29 July 2007
  • SOIVAN03
    Soil temperature at VANMET, probe no. 03 at depth 50 cm; discontinued 29 July 2007
  • SOIVAN04
    Soil temperature at VANMET, probe no. 04 at depth 100 cm; discontinued 29 July 2007
  • SOIVAN05
    Soil temperature at VANMET, probe no. 05 at depth 30 cm; discontinued 13 July 1994
  • SOIVAN06
    Soil temperature at VANMET, probe no. 06 at depth 10 cm; established 15 Sep 2004
  • SOIVAN07
    Soil temperature at VANMET, probe no. 07 at depth 20 cm; established 15 Sep 2004
  • SOIVAN08
    Soil temperature at VANMET, probe no. 08 at depth 50 cm; established 15 Sep 2004
  • SOIVAN09
    Soil temperature at VANMET, probe no. 09 at depth 100 cm; established 15 Sep 2004
  • SOIWS701
    Soil temperature at WS7MET, probe no. 01 at depth 10 cm; established 6 Dec 2006
  • SOIWS702
    Soil temperature at WS7MET, probe no. 02 at depth 20 cm; established 6 Dec 2006
  • SOIWS703
    Soil temperature at WS7MET, probe no. 03 at depth 50 cm; established 6 Dec 2006
  • SOIWS704
    Soil temperature at WS7MET, probe no. 04 at depth 100 cm; established 6 Dec 2006
DATE_TIME - datetime (dateTime)

ID: SP03831.DATE_TIME

Date and time in Pacific Standard Time (PST) of sensor reading

Type system: Microsoft SQL Server 2019

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

SOILTEMP_MEAN - numeric(5,1) (interval)

ID: SP03831.SOILTEMP_MEAN

Mean soil temperature over the past interval (e.g., 60 minutes)

Type system: Microsoft SQL Server 2019

Unit: degrees Celsius

Precision: 0.100000

Numeric domain: type=real, min=-3.0000 (exclusive=false), max=88.6000 (exclusive=false)

SOILTEMP_MEAN_FLAG - char(1) (nominal)

ID: SP03831.SOILTEMP_MEAN_FLAG

Mean soil temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • E
    Estimated value
  • M
    Missing
  • Q
    Questionable
  • S
    Daily value based on sunrise to sunrise
  • A
    Accepted value has passed all QC tests applied as represented by the quality level
  • P
    Fire effects are visible in the data
EVENT_CODE - char(6) (nominal)

ID: SP03831.EVENT_CODE

Any event, disruption in protocol, or unusual conditions that occur at the given date or time and may have an effect on the data values; contact information manager for access to specific details from the field 'Notes' database

Type system: Microsoft SQL Server 2019

Code definitions (11)
  • INSREM
    Sensor is installed or removed
  • LOGGER
    Change in data logger, data logger program, or wiring
  • METHOD
    Change in data collection method
  • NA
    No event is reported (not applicable)
  • QUALTY
    Event may directly affect data quality (individual activities tracked in field notes database)
  • MAINTE
    A maintenance event has occurred
  • INTPRO
    Internal processing may produce an anomalous reading
  • WEATHR
    A weather event has occurred that may affect reading
  • CALIBR
    Associated with the inspection or replacement of sensors for calibration
  • CLEARD
    Site clearing of trees and brush around the meteorological station is being conducted
  • BURNED
    Burning, including cleared trees and brush or wildfire, around the meteorological station or within the watershed (code begins at event initiation)
SP03833 - Soil water content (fine temporal resolution)

Object name: SP03833_v5.txt

Records: 17141244

Attributes: 11

Temporal coverage: 2012-05-09 to 2024-10-01

File size: 1316852301 byte

Checksum (MD5): baf1b78c6e95bf02a892b7148e2792b8

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

Constraints (2)
  • primaryKey: PRIMARY
    SP03833.DATE_TIME, SP03833.PROBE_CODE, SP03833.SITECODE
  • notNullConstraint: NOTNULL
    SP03833.DATE_TIME, SP03833.ENTITY, SP03833.SOILWC_MEAN_FLAG, SP03833.EVENT_CODE, SP03833.QC_LEVEL, SP03833.DEPTH, SP03833.SOILWC_METHOD, SP03833.DBCODE, SP03833.PROBE_CODE, SP03833.SITECODE
Attributes (11)
DBCODE - char(5) (nominal)

ID: SP03833.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • SP038
    FSDB Database Code SP038
ENTITY - numeric(2,0) (interval)

ID: SP03833.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SITECODE - char(6) (nominal)

ID: SP03833.SITECODE

Site code for the meteorological measurement station

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • CENMET
    Central Meteorological Station
  • PRIMET
    Primary Meteorological Station
  • UPLMET
    Upper Lookout Meteorological Station
  • VANMET
    Vanilla Leaf Meteorological Station
  • WS7MET
    Watershed 7 Meteorological Station
SOILWC_METHOD - char(6) (nominal)

ID: SP03833.SOILWC_METHOD

An indication of the the general methodology and instrumentation used to collect this soil water content data

Type system: Microsoft SQL Server 2019

Code definitions (16)
  • SWC101
    Mean daily soil volumetric water content at 10 cm depth is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values based on instantaneous 15 second readings. Model CS615 water content reflectometer (See Method SWC001)
  • SWC102
    Mean daily soil volumetric water content at 20 cm depth is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values based on instantaneous 15 second readings. Model CS615 water content reflectometer (See Method SWC002)
  • SWC103
    Mean daily soil volumetric water content at 50 cm depth is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values based on instantaneous 15 second readings. Model CS615 water content reflectometer (See Method SWC003)
  • SWC104
    Mean daily soil volumetric water content at 100 cm depth is calculated by the Campbell Scientific datalogger based on 15 second samples. Max-min values based on instantaneous 15 second readings. Model CS615 water content reflectometer (See Method SWC004)
  • SWC001
    Soil volumetric water content is sampled by a Campbell Scientific model 615 water content reflectometer placed horizontally in soil at 10 cm depth; mean soil volumetric water content on a fractional basis is output every 60 minutes
  • SWC002
    Soil volumetric water content is sampled by a Campbell Scientific model 615 water content reflectometer placed horizontally in soil at 20 cm depth; mean soil volumetric water content on a fractional basis is output every 60 minutes
  • SWC003
    Soil volumetric water content is sampled by a Campbell Scientific model 615 water content reflectometer placed horizontally in soil at 50 cm depth; mean soil volumetric water content on a fractional basis is output every 60 minutes
  • SWC004
    Soil volumetric water content is sampled by a Campbell Scientific model 615 water content reflectometer placed horizontally in soil at 100 cm depth; mean soil volumetric water content on a fractional basis is output every 60 minutes
  • SWC005
    Soil volumetric water content is sampled by a Campbell Scientific model 615 water content reflectometer placed horizontally in soil at 10 cm depth; mean soil volumetric water content on a fractional basis is output every 5 minutes
  • SWC006
    Soil volumetric water content is sampled by a Campbell Scientific model 615 water content reflectometer placed horizontally in soil at 20 cm depth; mean soil volumetric water content on a fractional basis is output every 5 minutes
  • SWC007
    Soil volumetric water content is sampled by a Campbell Scientific model 615 water content reflectometer placed horizontally in soil at 50 cm depth; mean soil volumetric water content on a fractional basis is output every 5 minutes
  • SWC008
    Soil volumetric water content is sampled by a Campbell Scientific model 615 water content reflectometer placed horizontally in soil at 100 cm depth; mean soil volumetric water content on a fractional basis is output every 5 minutes
  • SWC105
    Mean daily soil volumetric water content is post-calculated from all 5 minute mean values for the day. Max-min values are based on 5 minute mean intervals and not instantaneous values. Model CS615 water content reflectometer; 10cm dep (See method SWC005)
  • SWC106
    Mean daily soil volumetric water content is post-calculated from all 5 minute mean values for the day. Max-min values are based on 5 minute mean intervals and not instantaneous values. Model CS615 water content reflectometer; 20cm dep (See method SWC006)
  • SWC107
    Mean daily soil volumetric water content is post-calculated from all 5 minute mean values for the day. Max-min values are based on 5 minute mean intervals and not instantaneous values. Model CS615 water content reflectometer; 50cm dep (See method SWC007)
  • SWC108
    Mean daily soil volumetric water content is post-calculated from all 5 minute mean values for the day. Max-min values are based on 5 minute mean intervals and not instantaneous values. Model CS615 water content reflectometer;100cm dep (See method SWC008)
DEPTH - numeric(4,0) (ratio)

ID: SP03833.DEPTH

Depth of sensor from ground surface

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

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

QC_LEVEL - char(2) (nominal)

ID: SP03833.QC_LEVEL

Quality control flag indicates level of quality checking performed including an indication of "provisional" data.

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • 1P
    Data is provisional and subject to revision - preliminary quality checks have been performed
  • 1A
    Data is published and unlikely to change - automated range checking and manual review has been conducted. Quality is indicated in data value qualifier flags.
  • 2A
    Data is published and unlikely to change - Level 1A data has been modified such that data gaps may be filled or problem data may be removed
  • 2D
    Data is published and unlikely to change - data is derived or aggregated from published data of level 2A
  • 1D
    Data is published and unlikely to change - data is derived or aggregated from published data of level 1A
PROBE_CODE - char(8) (nominal)

ID: SP03833.PROBE_CODE

Probe number code indicates the measurement type, site, and sensor number (e.g., SOIPRI01)

Type system: Microsoft SQL Server 2019

Code definitions (58)
  • SWCPRI01
    Soil water content at PRIMET, probe no. 01 at depth 10 cm
  • SWCPRI02
    Soil water content at PRIMET, probe no. 02 at depth 20 cm
  • SWCPRI03
    Soil water content at PRIMET, probe no. 03 at depth 50 cm
  • SWCPRI04
    Soil water content at PRIMET, probe no. 04 at depth 100 cm
  • SWCCEN01
    Soil water content at CENMET, probe no. 01 at depth 10 cm
  • SWCCEN02
    Soil water content at CENMET, probe no. 02 at depth 20 cm
  • SWCCEN03
    Soil water content at CENMET, probe no. 03 at depth 50 cm
  • SWCCEN04
    Soil water content at CENMET, probe no. 04 at depth 100 cm
  • SWCUPL01
    Soil water content at UPLMET, probe no. 01 at depth 10 cm
  • SWCUPL02
    Soil water content at UPLMET, probe no. 02 at depth 20 cm
  • SWCUPL03
    Soil water content at UPLMET, probe no. 03 at depth 50 cm
  • SWCUPL04
    Soil water content at UPLMET, probe no. 04 at depth 100 cm
  • SWCVAN01
    Soil water content at VANMET, probe no. 01 at depth 10 cm
  • SWCVAN02
    Soil water content at VANMET, probe no. 02 at depth 20 cm
  • SWCVAN03
    Soil water content at VANMET, probe no. 03 at depth 50 cm
  • SWCVAN04
    Soil water content at VANMET, probe no. 04 at depth 100 cm
  • SMPCEN01
    Soil moisture potential at CENMET, probe no. 01 at depth 10 cm; discontinued 13 Nov 2002
  • SMPCEN02
    Soil moisture potential at CENMET, probe no. 02 at depth 20 cm; discontinued 13 Nov 2002
  • SMPCEN03
    Soil moisture potential at CENMET, probe no. 03 at depth 50 cm; discontinued 13 Nov 2002
  • SMPCEN04
    Soil moisture potential at CENMET, probe no. 04 at depth 100 cm; discontinued 13 Nov 2002
  • SMPPRI01
    Soil moisture potential at PRIMET, probe no. 01 at depth 10 cm; discontinued 23 May 2000
  • SMPPRI02
    Soil moisture potential at PRIMET, probe no. 02 at depth 20 cm; discontinued 23 May 2000
  • SMPPRI03
    Soil moisture potential at PRIMET, probe no. 03 at depth 50 cm; discontinued 23 May 2000
  • SMPPRI04
    Soil moisture potential at PRIMET, probe no. 04 at depth 100 cm; discontinued 23 May 2000
  • SMPUPL01
    Soil moisture potential at UPLMET, probe no. 01 at depth 10 cm; discontinued 18 Oct 2001
  • SMPUPL02
    Soil moisture potential at UPLMET, probe no. 02 at depth 20 cm; discontinued 18 Oct 2001
  • SMPUPL03
    Soil moisture potential at UPLMET, probe no. 03 at depth 50 cm; discontinued 18 Oct 2001
  • SMPUPL04
    Soil moisture potential at UPLMET, probe no. 04 at depth 100 cm; discontinued 18 Oct 2001
  • SMPVAN01
    Soil moisture potential at VANMET, probe no. 01 at depth 10 cm; discontinued 9 Sep 2001
  • SMPVAN02
    Soil moisture potential at VANMET, probe no. 02 at depth 20 cm; discontinued 9 Sep 2001
  • SMPVAN03
    Soil moisture potential at VANMET, probe no. 03 at depth 50 cm; discontinued 9 Sep 2001
  • SMPVAN04
    Soil moisture potential at VANMET, probe no. 04 at depth 100 cm; discontinued 9 Sep 2001
  • SMPVAN05
    Soil moisture potential at VANMET, probe no. 05 at depth 30 cm; discontinued 9 Sep 2001
  • SOICEN01
    Soil temperature at CENMET, probe no. 01 at depth10 cm
  • SOICEN02
    Soil temperature at CENMET, probe no. 02 at depth 20 cm
  • SOICEN03
    Soil temperature at CENMET, probe no. 03 at depth 50 cm
  • SOICEN04
    Soil temperature at CENMET, probe no. 04 at depth 100 cm
  • SOIPRI01
    Soil temperature at PRIMET, probe no. 01 at depth 10 cm
  • SOIPRI02
    Soil temperature at PRIMET, probe no. 02 at depth 20 cm
  • SOIPRI03
    Soil temperature at PRIMET, probe no. 03 at depth 50 cm
  • SOIPRI04
    Soil temperature at PRIMET, probe no. 04 at depth 100 cm
  • SOIUPL01
    Soil temperature at UPLMET, probe no. 01 at depth 10 cm
  • SOIUPL02
    Soil temperature at UPLMET, probe no. 02 at depth 20 cm
  • SOIUPL03
    Soil temperature at UPLMET, probe no. 03 at depth 50 cm
  • SOIUPL04
    Soil temperature at UPLMET, probe no. 04 at depth 100 cm
  • SOIVAN01
    Soil temperature at VANMET, probe no. 01 at depth 10 cm; discontinued 29 July 2007
  • SOIVAN02
    Soil temperature at VANMET, probe no. 02 at depth 20 cm; discontinued 29 July 2007
  • SOIVAN03
    Soil temperature at VANMET, probe no. 03 at depth 50 cm; discontinued 29 July 2007
  • SOIVAN04
    Soil temperature at VANMET, probe no. 04 at depth 100 cm; discontinued 29 July 2007
  • SOIVAN05
    Soil temperature at VANMET, probe no. 05 at depth 30 cm; discontinued 13 July 1994
  • SOIVAN06
    Soil temperature at VANMET, probe no. 06 at depth 10 cm; established 15 Sep 2004
  • SOIVAN07
    Soil temperature at VANMET, probe no. 07 at depth 20 cm; established 15 Sep 2004
  • SOIVAN08
    Soil temperature at VANMET, probe no. 08 at depth 50 cm; established 15 Sep 2004
  • SOIVAN09
    Soil temperature at VANMET, probe no. 09 at depth 100 cm; established 15 Sep 2004
  • SOIWS701
    Soil temperature at WS7MET, probe no. 01 at depth 10 cm; established 6 Dec 2006
  • SOIWS702
    Soil temperature at WS7MET, probe no. 02 at depth 20 cm; established 6 Dec 2006
  • SOIWS703
    Soil temperature at WS7MET, probe no. 03 at depth 50 cm; established 6 Dec 2006
  • SOIWS704
    Soil temperature at WS7MET, probe no. 04 at depth 100 cm; established 6 Dec 2006
DATE_TIME - datetime (dateTime)

ID: SP03833.DATE_TIME

Date and time in Pacific Standard Time (PST) of sensor reading

Type system: Microsoft SQL Server 2019

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

SOILWC_MEAN - numeric(5,2) (ratio)

ID: SP03833.SOILWC_MEAN

Mean soil volumetric water content on a fractional basis (values are 0 to 1) over the last interval

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1

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

SOILWC_MEAN_FLAG - char(1) (nominal)

ID: SP03833.SOILWC_MEAN_FLAG

Mean soil water content flag

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • E
    Estimated value
  • M
    Missing
  • Q
    Questionable
  • A
    Accepted value has passed all QC tests applied as represented by the quality level
  • F
    Observed value is above field (or water holding) capacity but the data point is still potentially valid and reliable for analysis
  • P
    Fire effects are visible in the data
EVENT_CODE - char(6) (nominal)

ID: SP03833.EVENT_CODE

Any event, disruption in protocol, or unusual conditions that occur at the given date or time and may have an effect on the data values; contact information manager for access to specific details from the field 'Notes' database

Type system: Microsoft SQL Server 2019

Code definitions (11)
  • INSREM
    Sensor is installed or removed
  • LOGGER
    Change in data logger, data logger program, or wiring
  • METHOD
    Change in data collection method
  • NA
    No event is reported (not applicable)
  • QUALTY
    Event may directly affect data quality (individual activities tracked in field notes database)
  • MAINTE
    A maintenance event has occurred
  • INTPRO
    Internal processing may produce an anomalous reading
  • WEATHR
    A weather event has occurred that may affect reading
  • CALIBR
    Associated with the inspection or replacement of sensors for calibration
  • CLEARD
    Site clearing of trees and brush around the meteorological station is being conducted
  • BURNED
    Burning, including cleared trees and brush or wildfire, around the meteorological station or within the watershed (code begins at event initiation)
Units
pressure in bars bar pressure bar pascal 100000 1 bar = 100000 pascals; =0.9869 atmospheres; =0.1 megapascal (MPa); =100 kilopascals (kPa)
time in military hours and minutes HHMM datetime hhmm YYYY-MM-DDThh:mm:ss N/A Hours and minutes with hh as military hours and mm as minutes
degrees Celsius deg c temperature celsiusDegree kelvin 1 Degrees Celsius; a common unit of temperature; constantToSI=273.18
centimeters cm length centimeter meter 0.01 centimeters; .01 meters
number number dimensionless number dimensionless 1 dimensionless number, i.e., ratio, count
Related Datasets
Related Publications

No publication citations found in this EML file.

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. SP038 is now the source for all quality checked benchmark soil moisture and temperature data. Current, provisional data will be posted on the provisional data portal.

Licensed

License: Creative Commons Attribution 4.0 International Public License

Identifier: CC-BY-4.0

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

Maintenance

Maintenance update frequency: annually

Description

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

Change History

  • Version1 (2024-06-10)
    Study code and preliminary metadata established
  • Version2 (2024-12-16)
    Soil data entities were migrated out of MS001. This is a version of the data as it was in MS001, except with new dbcode assigned. New CSV files created.
  • Version3 (2025-01-16)
    Entities 31 and 33 data were updated through 10/01/2023.
  • Version4 (2025-06-16)
    Updated high temporal resolution entities 31, 33.
  • Version5 (2025-06-26)
    Entities 31 and 33 data were updated through 10/01/2024.
  • Version6 (2025-07-31)
    Dates in v5 were output incorrectly, this version corrects those dates. No other changes.