MS005: Air and soil temperature data from the Reference Stand network at the Andrews Experimental Forest, 1971 to present

Citation

Daly, C.; McKee, W.; Schulze, M.; Remillard, S.; Cohn, G.; Kennedy, A.; Schmidt, S. 2025. Air and soil temperature data from the Reference Stand network at the Andrews Experimental Forest, 1971 to present Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/MS005 Accessed 2026-05-10.

Abstract

The current network of temperature measurement sites are designed to represent spatial variability of air and soil temperature in rugged mountain topography, and serve as second-level stations to capture specific microclimate temperatures in conjunction with a network of Benchmark Meteorological Stations (MS001). The air and soil thermograph network has been reduced from the historical network of 37 sites originally established. Currently there are 10 measurement sites with two of these sites measuring relative humidity in addition to air and soil temperature. An original network of 19 sites (RS01-RS19) were established during the International Biome Program in the early 1970's. Emphasis on phenology, plant moisture stress, and leaf nutrient content led to extending this network of air and soil temperature measurement. A plant community classification system (Dyrness et al., 1971) was used as a primary means of stratification, and a set of permanent vegetation plots (Reference Stands) was installed to represent forest communities with distinct vegetation and hypothesized different environments (Dyrness et al., 1974). A thermograph network was installed within the reference stands in the early 1970's (Zobel et al., 1974), and vegetation standing crop, tree growth and mortality, and plant succession were also measured. The majority of these sites were established to monitor micro-meteorological data under the canopy. The purpose of this network was to provide air and soil temperature data for modeling photosynthesis, respiration, phenology, and decomposition, and to measure environmental gradients.

Coverage

Temporal coverage: 1971-03-17 to 2024-10-01

Geographic coverage: Andrews Experimental Forest Reference Stands: Original stations were Reference Stands 1 to 20, 24, 26, 86, and 89 and temperature measurement sites 31 to 38 and 74 to 77. Currently, Reference Stands 2, 4, 5, 10, 12, 20, 26, 38, 86 and 89 are measured.

Spatial coverage:

Loading map…

Bounds: W -122.42357800, E -122.09452900, N 44.34393100, S 44.17114200

Purpose

Characterize the microclimates for the range of elevations, aspects, and habitat types found within the Andrews Experimental Forest for plant production, simulation modeling and studies of microclimate/plant community structure relationships. Provide baseline data for all the studies utilizing the Andrews in conjunction with six Benchmark Meteorological Stations, and to monitor the effects of forest management and physiography on microclimate.

Project

Title: Long-Term Ecological Research

Personnel

Posy Elizabeth Busby - Principal Investigator
Assistant Professor OSU Botany & Plant Pathology

Email: busbyp@science.oregonstate.edu, posybusby@gmail.com

URL: http://bpp.oregonstate.edu/content/posy-busby

ORCID: 0000-0002-2837-9820
Matthew G Betts - Principal Investigator
Department of Forest Ecosystems and Society; 201E Richardson Hall; College of Forestry; Oregon State University, Corvallis, OR, 97331

Phone: (541) 737-3841

Email: matt.betts@oregonstate.edu

URL: http://www.fsl.orst.edu/flel/index.htm

ORCID: 0000-0002-7100-2551
Brooke E. Penaluna - Principal Investigator
Email: brooke.penaluna@usda.gov, Brooke.Penaluna@oregonstate.edu

URL: https://www.fs.fed.us/pnw/lwm/aem/people/penaluna.html

ORCID: 0000-0001-7215-770X
Catalina Segura - Principal Investigator
Assistant Professor; Department of Forest Engineering, Resources, and Management; Oregon State University, Corvallis, OR, 97331

Phone: 541-737-6568

Email: catalina.segura@oregonstate.edu

URL: http://ferm.forestry.oregonstate.edu/facstaff/segura-catalina

ORCID: 0000-0002-0924-1172
David M. Bell - Principal Investigator
Email: david.bell@usda.gov, david.bell@oregonstate.edu

URL: https://lemma.forestry.oregonstate.edu/about/david-bell

ORCID: 0000-0002-2673-5836

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

LTER: Long-Term Ecological Research at the H.J. Andrews Experimental Forest (LTER8)
Award Number: DEB2025755

Funder: National Science Foundation

Funder Identifier: https://ror.org/021nxhr62

URL: https://www.nsf.gov/awardsearch/showAward?AWD_ID=2025755

Study Area Description

Long-Term Ecological Research
The Andrews Forest is situated in the western Cascade Range of Oregon, and covers the entire 15,800-acre (6400-ha) drainage basin of Lookout Creek. Elevation ranges from 1350 to 5340 feet (410 to 1630 m). Broadly representative of the rugged mountainous landscape of the Pacific Northwest, the Andrews Forest contains excellent examples of the region's conifer forests and associated wildlife and stream ecosystems. These forests are among the tallest and most productive in the world, with tree heights of often greater than 250 ft (75 m). Streams are steep, cold and clean, providing habitat for numerous aquatic organisms.

Associated Party

Contact

Information Manager
Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331

Email: hjaweb@lists.oregonstate.edu

URL: http://andrewsforest.oregonstate.edu/
Suzanne M. Remillard
Office: FSL 354;; Forest Science Department;; Oregon State University, Corvallis, OR, 97331, USA

Phone: (541) 758-8767

Email: suzanne.remillard@oregonstate.edu
Adam M Kennedy
1055 Clinton Drive, Eugene, OR, 97401, US

Phone: 541-822-6302

Email: adam.kennedy@oregonstate.edu, kennaster@gmail.com

URL: https://directory.forestry.oregonstate.edu/people/kennedy-adam
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

URL: http://andrewsforest.oregonstate.edu/

Study Description

The current network of temperature measurement sites are designed to represent spatial variability of air and soil temperature in rugged mountain topography, and serve as second-level stations to capture specific microclimate temperatures in conjunction with a network of Benchmark Meteorological Stations (MS001). The air and soil thermograph network has been reduced from the historical network of 37 sites originally established. Currently there are 10 measurement sites with two of these sites measuring relative humidity in addition to air and soil temperature. An original network of 19 sites (RS01-RS19) were established during the International Biome Program in the early 1970's. Emphasis on phenology, plant moisture stress, and leaf nutrient content led to extending this network of air and soil temperature measurement. A plant community classification system (Dyrness et al., 1971) was used as a primary means of stratification, and a set of permanent vegetation plots (Reference Stands) was installed to represent forest communities with distinct vegetation and hypothesized different environments (Dyrness et al., 1974). A thermograph network was installed within the reference stands in the early 1970's (Zobel et al., 1974), and vegetation standing crop, tree growth and mortality, and plant succession were also measured. The majority of these sites were established to monitor micro-meteorological data under the canopy. The purpose of this network was to provide air and soil temperature data for modeling photosynthesis, respiration, phenology, and decomposition, and to measure environmental gradients. Characterize the microclimates for the range of elevations, aspects, and habitat types found within the Andrews Experimental Forest for plant production, simulation modeling and studies of microclimate/plant community structure relationships. Provide baseline data for all the studies utilizing the Andrews in conjunction with six Benchmark Meteorological Stations, and to monitor the effects of forest management and physiography on microclimate. Field Methods - MS005: General

Purpose: Characterize the microclimates for the range of elevations, aspects, and habitat types found within the Andrews Experimental Forest for plant production, simulation modeling and studies of microclimate/plant community structure relationships. Provide baseline data for all the studies utilizing the Andrews in conjunction with six Benchmark Meteorological Stations, and to monitor the effects of forest management and physiography on microclimate.

Methods

Method Steps

Field Methods - MS005: General

Instrumentation:

The original thermograph instrument was the Dual Recording Thermometer Model RFHTT. This instrument records temperatures from two separate locations (air and soil) simultaneously on a single chart. Each of the two thermometer mechanisms operate with a mercury-filled sensing bulb which expands or contracts in response to temperature changes and in turn moves the recording pen along the calibrated chart. To prevent interference between the two pens, the right-hand pen records 1/12 revolution behind the left-hand pen. The recorder uses 10 inch 30- and 31-day Partlow circular charts that have ranges from -30°F - 170°F or 20°F - 120°F. These original thermograph charts were replaced with Campbell Scientific data loggers ( typically CR10, CR21X, CR500, or CR23X) beginning in 1987. The temperature probes used with the data loggers were type T thermocouple soldered from thermocouple wire. These thermocouple wires have gradually been replaced through the late 1990-s with Campbell Scientific model 107 temperature probes (CS107B or CS107B-L) which include the Fenwal Electronics UUT51J1 thermistor.

Method Step 2

No method step description paragraphs listed.

Instrumentation:

Thermocouple wire; Campbell Scientific model 107 temperature probe (CS107B, CS107B-L) includes the Fenwal Electronics UUT51J1 thermistor; Campbell Model HMP35C or the HMP45C probe containing a Vaisala capacitive relative humidity sensor and a Fenwal Electronics UUT51J1 thermistor; Campbell Scientific data loggers (CR10, CR21X, CR500, or CR23X); Interface Instrument models M-2, M-3, and M-4

Method Step 3

No method step description paragraphs listed.

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.

Laboratory Methods - MS005

Digitizing chart records was the primary method of capturing data until 1987 when data loggers begin to be installed. Digitizing continued for some sites until 1998. Charts were digitized and the record summarized by daytime, nighttime, and 24-hr period. The 24-hr mean values before 1987 are sunrise to sunrise; after January 1987 the 24-hr values are midnight to midnight. The exceptions to this are any pre-1987 periods that were redigitized. All sunrise-sunrise values are coded as such. Before January 1981, daily minimum air temperature is the nighttime minimum and daily maximum air temperature is the daytime maximum. This causes occasional violations of the min less than mean less than max rule. Regression estimates were used where possible to estimate missing data points (values flagged) in the early record. A temperature growth index is calculated based on daytime air and daily soil temperature. All daytime/nighttime calculation ended in 1998, and this data is only available by request.

Instrumentation:

Digitizer is the Summagraphics/Houston Instruments model MM 1812. (Comparable product is now http://www.calcomp.com/productsummagrid6.htm)

Quality Assurance - MS005

Quality assurance procedures included 1) missing flag check to ensure that all missing data really has the appropriate flag; 2) date/time check to verify that a record exists for each date (and hour if applicable) and that records fall in the correct order; 3) relative mean/max/min check for each record to make sure that min is less than mean is less than max; 4) similar sites were paired and the values compared to catch any gross outliers.

Field Methods - MS005: Relative Humidity

Please follow this link to view 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/
Relative humidity was sampled at two sites (RS86__ and RS89__) from July 2004 until October 2017 using an HMP45C sensor housed inside a Gill radiation shield. Output was hourly, in addition to mean daily, max and min. These measurements have been discontinued.

Instrumentation:

Temperature and relative humidity are sampled by Campbell Model HMP35C or HMP45C probes containing a Vaisala capacitive relative humidity sensor and a Fenwal Electronics UUT51J1 thermistor. The probes were originally housed in a locally-designed PVC radiation shield, which were later replaced with Gill radiation shields. Campbell Scientific data loggers are used.

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

Sites range from xeric to mesic communities; 380 to 1570 meters elevation; mature (old growth) forests, shelterwood cuttings and clearcuts, burned and unburned.
Sampling frequency: Continually

Sampling Description

Sites were originally selected from common and contrasting plant communities in established reference stands. The original 19 sites represent three vegetation zones and along environmental gradients of elevation and moisture. Other sites were added in the late 1970's with some original sites discontinued. The network was collapsed in the 1990's, and the current sites are primarily used for monitoring long-term changes in temperature. The following link summarizes general vegetation zones: http://andrewsforest.oregonstate.edu/data/studies/ms05/meta/veg_zones.pdf.
Citation:
Zobel, D. B.; McKee, W. A.; Hawk, G. M., and Dyrness, C. T. Correlation of forest communities with environment and phenology on the H.J. Andrews Experimental Forest, Oregon. In: Waring, R. H. and Edmonds, R. L., eds. Integrated research in the coniferous forest biome. Seattle, WA: Coniferous Forest Biome; 1974; Bulletin 5 pp. 48-56.

Spatial Sampling Units

Software

No software entries listed in this EML file.

Keywords

LTER controlled vocabulary: meteorology (theme), climatology (theme), dew point (theme), microclimate (theme), water content (theme), temperature (theme), air temperature (theme), soil temperature (theme), reference stands (theme), succession (theme), primary production (theme), growth (theme), disturbance (theme), monitoring (theme), ecosystems (theme)
Andrews Experimental Forest site thesaurus: environmental indexes (theme), moisture stress (theme)
LTER core research areas: primary production (theme), disturbance (theme)

Taxonomic Hierarchy

No taxonomic hierarchy listed in this EML file.

Data Entities

#	Entity	Metadata	Data
1	MS00501 Air temperature (Daily) Sensors at 10 sites of the original 38	METADATA	DATA
2	MS00502 Relative Humidity (Daily) Only recorded at 2 sites. Sensors discontinued Oct 24 2017	METADATA	DATA
3	MS00511 Air temperature (Finest resolution, e.g., hourly, 5 minute) Sensors at 10 sites of the original 15	METADATA	DATA
4	MS00512 Relative Humidity (Finest resolution, e.g., hourly, 5 minute) Only recorded at 2 sites. Sensors discontinued Oct 24 2017.	METADATA	DATA
5	MS00521 Soil temperature (Daily) Sensors at 10 sites of the original 38	METADATA	DATA
6	MS00531 Soil temperature (Finest resolution, e.g., 6-hourly, 5 minute) Sensors at 10 sites of the original 15	METADATA	DATA
7	MS00540 Legacy data: Temperature growth index, plant stress, and dew point temperature Plant stress and dew point temperature only collected 1973-1976.	METADATA	DATA

Metadata

MS00501 - Air temperature (Daily)

Object name: MS00501_v5.csv

Records: 303121

Attributes: 17

Temporal coverage: 1970-04-13 to 2019-09-30

File size: 26429603 byte

Checksum (MD5): b355e503558d6d3901a056098b9d06e8

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

Constraints (2)

primaryKey: PRIMARY
MS00501.DATE, MS00501.PROBE_CODE, MS00501.SITECODE
notNullConstraint: NOTNULL
MS00501.DATE, MS00501.AIRTEMP_MEAN_FLAG, MS00501.AIRTEMP_MAX_FLAG, MS00501.AIRTEMP_MIN_FLAG, MS00501.PROBE_CODE, MS00501.DBCODE, MS00501.SITECODE, MS00501.ENTITY, MS00501.AIRTEMP_METHOD, MS00501.QC_LEVEL, MS00501.EVENT_CODE, MS00501.HEIGHT

Attributes (17)

DBCODE - char(5) (nominal)

ID: MS00501.DBCODE

FSDB database code

Type system: Microsoft SQL Server 2019

Code definitions (1)

MS005
FSDB Database Code

ENTITY - numeric(2,0) (interval)

ID: MS00501.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SITECODE - char(6) (nominal)

ID: MS00501.SITECODE

Site code for the meteorological measurement station

Type system: Microsoft SQL Server 2019

Code definitions (37)

RS01__
Reference Stand RS01 air/soil temperature site
RS02__
Reference Stand RS02 air/soil temperature site
RS03__
Reference Stand RS03 air/soil temperature site
RS04__
Reference Stand RS04 air/soil temperature site
RS05__
Reference Stand RS05 air/soil temperature site
RS06__
Reference Stand RS06 air/soil temperature site
RS07__
Reference Stand RS07 air/soil temperature site
RS08__
Reference Stand RS08 air/soil temperature site
RS09__
Reference Stand RS09 air/soil temperature site
RS10__
Reference Stand RS10 air/soil temperature site
RS11__
Reference Stand RS11 air/soil temperature site
RS12__
Reference Stand RS12 air/soil temperature site
RS13__
Reference Stand RS13 air/soil temperature site
RS14__
Reference Stand RS14 air/soil temperature site
RS15__
Reference Stand RS15 air/soil temperature site
RS16__
Reference Stand RS16 air/soil temperature site
RS17__
Reference Stand RS17 air/soil temperature site
RS18__
Reference Stand RS18 air/soil temperature site
RS19__
Reference Stand RS19 air/soil temperature site
RS20__
Reference Stand RS20 air/soil temperature site
RS24__
Reference Stand RS24 air/soil temperature site
RS26__
Reference Stand RS26 air/soil temperature site
TS31__
Thermograph site 31
TS32__
Thermograph site 32
TS33__
Thermograph site 33
TS34__
Thermograph site 34
TS35__
Thermograph site 35
TS36__
Thermograph site 36
TS37__
Thermograph site 37
RS38__
Reference Stand RS38 air/soil temperature site (formerly TS38__)
TS74__
Thermograph site 74
TS75__
Thermograph site 75
TS76__
Thermograph site 76
TS77__
Thermograph site 77
RS86__
Reference Stand RS86 air/soil temperature and relative humidity site
RS89__
Reference Stand RS89 air/soil temperature and relative humidity site
RS13O_
Reference Stand RS13 Open canopy air/soil temperature site

AIRTEMP_METHOD - char(6) (nominal)

ID: MS00501.AIRTEMP_METHOD

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

Type system: Microsoft SQL Server 2019

Code definitions (103)

AIR504
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 60 cm height in small shelter on tree and corrected to standard rdg.
AIR505
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 65 cm height in small shelter on tree and corrected to standard rdg.
AIR506
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 80 cm height in small shelter on tree and corrected to standard rdg.
AIR507
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 85 cm height in small shelter on tree and corrected to standard rdg.
AIR508
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 100 cm height in small shelter on tree and corrected to standard rdg.
AIR509
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 160 cm height in small shelter on tree and corrected to standard rdg.
AIR510
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 180 cm height in small shelter on tree and corrected to standard rdg.
AIR511
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 190 cm height in small shelter on tree and corrected to standard rdg.
AIR512
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 200 cm height in small shelter on tree and corrected to standard rdg.
AIR513
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 235 cm height in small shelter on tree and corrected to standard rdg.
AIR514
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 300 cm height in small shelter on tree and corrected to standard rdg.
AIR515
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 500 cm height in small shelter on tree and corrected to standard rdg.
AIR501
Mean, max and min daily (sunrise to sunrise) air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 100 cm height in small shelter and corrected.
AIR502
Mean, max and min daily (sunrise to sunrise) air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 200 cm height in small shelter and corrected.
AIR503
Mean, max and min daily (sunrise to sunrise) air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 300 cm height in small shelter and corrected.
AIR448
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 190 cm height; mean temperature is output every 5 minutes
AIR449
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 200 cm height; mean temperature is output every 5 minutes
AIR450
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 220 cm height; mean temperature is output every 5 minutes
AIR451
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 225 cm height; mean temperature is output every 5 minutes
AIR452
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 325 cm height; mean temperature is output every 5 minutes
AIR444
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 100 cm height; mean temperature is output every 60 minutes
AIR445
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 200 cm height; mean temperature is output every 60 minutes
AIR440
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 85 cm height; mean temperature is output every 60 minutes
AIR441
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 100 cm height; mean temperature is output every 60 minutes
AIR442
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 200 cm height; mean temperature is output every 60 minutes
AIR443
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 235 cm height; mean temperature is output every 60 minutes
AIR446
Air temperature is sampled by a Campbell Scientific model HMP45C probe housed in a R.M. Young Gill radiation shield at 235 cm height; mean temperature is output every 60 minutes
AIR447
Air temperature is sampled by a Campbell Scientific model HMP45C probe housed in a R.M. Young Gill radiation shield at 285 cm height; mean temperature is output every 60 minutes
AIR435
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a R.M. Young Gill radiation shield at 190 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR436
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a R.M. Young Gill radiation shield at 200 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR437
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a R.M. Young Gill radiation shield at 220 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR438
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a R.M. Young Gill radiation shield at 225 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR439
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a R.M. Young Gill radiation shield at 325 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR516
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 100 cm height (Daily output only)
AIR517
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 190 cm height (Daily output only)
AIR518
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 200 cm height (Daily output only)
AIR519
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 220 cm height (Daily output only)
AIR520
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 225 cm height (Daily output only)
AIR521
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 275 cm height (Daily output only)
AIR522
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 285 cm height (Daily output only)
AIR523
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 300 cm height (Daily output only)
AIR524
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 325 cm height (Daily output only)
AIR525
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 400 cm height (Daily output only)
AIR526
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 435 cm height (Daily output only)
AIR427
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a locally designed PVC radiation shield at 190 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR428
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a locally designed PVC radiation shield at 200 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR429
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a locally designed PVC radiation shield at 220 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR430
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a locally designed PVC radiation shield at 225 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR431
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a locally designed PVC radiation shield at 275 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR432
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a locally designed PVC radiation shield at 285 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR433
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a locally designed PVC radiation shield at 325 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR434
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a locally designed PVC radiation shield at 435 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR527
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 190 cm height (See Method AIR427)
AIR528
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 200 cm height (See Method AIR428)
AIR529
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 220 cm height (See Method AIR429)
AIR530
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 225 cm height (See Method AIR430)
AIR531
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 275 cm height (See Method AIR431)
AIR532
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 285 cm height (See Method AIR432)
AIR533
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 325 cm height (See Method AIR433)
AIR534
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 435 cm height (See Method AIR434)
AIR535
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a R.M. Young Gill radiation shield at 190 cm height (See Method AIR435)
AIR536
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a R.M. Young Gill radiation shield at 200 cm height (See Method AIR436)
AIR537
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a R.M. Young Gill radiation shield at 220 cm height (See Method AIR437)
AIR538
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a R.M. Young Gill radiation shield at 225 cm height (See Method AIR438)
AIR539
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a R.M. Young Gill radiation shield at 325 cm height (See Method AIR439)
AIR540
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 85 cm height (See Method AIR440)
AIR541
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 100 cm height (See Method AIR441)
AIR542
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 200 cm height (See Method AIR442)
AIR543
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 235 cm height (See Method AIR443)
AIR544
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 100 cm height (See Method AIR444)
AIR545
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 200 cm height (See Method AIR445)
AIR546
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model HMP45C probe housed in a R.M. Young Gill radiation shield at 235 cm height (See Method AIR446)
AIR547
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model HMP45C probe housed in a R.M. Young Gill radiation shield at 285 cm height (See Method AIR447)
AIR548
Mean daily air 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 thermistor; RM Young Gill radiation shield; 190 cm height (See AIR448)
AIR549
Mean daily air 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 thermistor; RM Young Gill radiation shield; 200 cm height (See AIR449)
AIR550
Mean daily air 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 thermistor; RM Young Gill radiation shield; 220 cm height (See AIR450)
AIR551
Mean daily air 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 thermistor; RM Young Gill radiation shield; 225 cm height (See AIR451)
AIR552
Mean daily air 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 thermistor; RM Young Gill radiation shield; 325 cm height (See AIR452)
AIR635
Mean daily air temperature is post-calculated from hourly mean values for the day. Max-min values are based on hourly mean intervals and not instantaneous values. Type T thermocouple wire; R.M. Young Gill radiation shield; 190 cm (See Method AIR435)
AIR636
Mean daily air temperature is post-calculated from hourly mean values for the day. Max-min values are based on hourly mean intervals and not instantaneous values. Type T thermocouple wire; R.M. Young Gill radiation shield; 200cm (See Method AIR436)
AIR637
Mean daily air temperature is post-calculated from hourly mean values for the day. Max-min values are based on hourly mean intervals and not instantaneous values. Type T thermocouple wire; R.M. Young Gill radiation shield; 220cm (See Method AIR437)
AIR638
Mean daily air temperature is post-calculated from hourly mean values for the day. Max-min values are based on hourly mean intervals and not instantaneous values. Type T thermocouple wire; R.M. Young Gill radiation shield; 225cm (See Method AIR438)
AIR639
Mean daily air temperature is post-calculated from hourly mean values for the day. Max-min values are based on hourly mean intervals and not instantaneous values. Type T thermocouple wire; R.M. Young Gill radiation shield; 325cm (See Method AIR439)
AIR453
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 190 cm height; mean, min, max temperature is output every 5 minutes
AIR553
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 190 cm height (See method AIR453)
AIR454
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 200 cm height; mean, min, max temperature is output every 5 minutes
AIR455
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 220 cm height; mean, min, max temperature is output every 5 minutes
AIR456
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 225 cm height; mean, min, max temperature is output every 5 minutes
AIR457
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 325 cm height; mean, min, max temperature is output every 5 minutes
AIR554
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 200 cm height (See method AIR454)
AIR555
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 220 cm height (See method AIR455)
AIR556
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 225 cm height (See method AIR456)
AIR557
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 325 cm height (See method AIR457)
AIR458
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 200 cm height; mean, min, max temperature is output every 5 minutes
AIR459
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 200 cm height; mean, min, max temperature is output every 5 minutes
AIR460
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 100 cm height; mean, min, max temperature is output every 5 minutes
AIR461
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 235 cm height; mean, min, max temperature is output every 5 minutes
AIR462
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 285 cm height; mean, min, max temperature is output every 5 minutes
AIR558
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 200 cm height (See method AIR458)
AIR559
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 200 cm height (See method AIR459)
AIR560
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 100 cm height (See method AIR460)
AIR561
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 235 cm height (See method AIR461)
AIR562
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 285 cm height (See method AIR462)

HEIGHT - numeric(4,0) (ratio)

ID: MS00501.HEIGHT

Height of sensor from ground surface

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

Numeric domain: type=whole, min=60.0000 (exclusive=false), max=500.0000 (exclusive=false)

QC_LEVEL - char(2) (nominal)

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

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
1D
Data is published and unlikely to change - data is derived or aggregated from published data of level 1A
1P
Data is provisional and subject to revision - preliminary quality checks have been performed
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

PROBE_CODE - char(8) (nominal)

ID: MS00501.PROBE_CODE

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

Type system: Microsoft SQL Server 2019

Code definitions (120)

AIRO1301
Air temperature at RS13O_, probe no. 01 at height 435 cm, discontinued 2003
AIRR0101
Air temperature at RS01__, probe no. 01 at height 100 cm, discontinued 1995
AIRR0201
Air temperature at RS02__, probe no. 01 at height 225 cm, discontinued 2015
AIRR0301
Air temperature at RS03__, probe no. 01 at height 235 cm, discontinued 1995
AIRR0401
Air temperature at RS04__, probe no. 01 at height 325 cm, discontinued 2015
AIRR0501
Air temperature at RS05__, probe no. 01 at height 200 cm, discontinued 2017
AIRR0601
Air temperature at RS06__, probe no. 01 at height 100 cm, discontinued 1975
AIRR0701
Air temperature at RS07__, probe no. 01 at height 100 cm, discontinued 1995
AIRR0801
Air temperature at RS08__, probe no. 01 at height 100 cm, discontinued 1973
AIRR0901
Air temperature at RS09__, probe no. 01 at height 100 cm, discontinued 1975
AIRR1001
Air temperature at RS10__, probe no. 01 at height 200 cm, discontinued 2017
AIRR1101
Air temperature at RS11__, probe no. 01 at height 100 cm, discontinued 1977
AIRR1201
Air temperature at RS12__, probe no. 01 at height 190 cm, discontinued 2015
AIRR1301
Air temperature at RS13__, probe no. 01 at height 275 cm, discontinued 2003
AIRR1401
Air temperature at RS14__, probe no. 01 at height 285 cm, discontinued 2003
AIRR1501
Air temperature at RS15__, probe no. 01 at height 180 cm, discontinued 1994
AIRR1601
Air temperature at RS16__, probe no. 01 at height 180 cm, discontinued 1994
AIRR1701
Air temperature at RS17__, probe no. 01 at height 60 cm, discontinued 1995
AIRR1801
Air temperature at RS18__, probe no. 01 at height 100 cm, discontinued 1974
AIRR1901
Air temperature at RS19__, probe no. 01 at height 100 cm, discontinued 1973
AIRR2001
Air temperature at RS20__, probe no. 01 at height 220 cm, discontinued 2015
AIRR2401
Air temperature at RS24__, probe no. 01 at height 220 cm, discontinued 2004
AIRR2601
Air temperature at RS26__, probe no. 01 at height 200 cm, discontinued 2015
AIRR8601
Air temperature at RS86__, probe no. 01 at height 235 cm, discontinued 2017
AIRR8901
Air temperature at RS89__, probe no. 01 at height 285 cm, discontinued 2017
AIRT3101
Air temperature at TS31__, probe no. 01 at height 100 cm, discontinued 1976
AIRT3201
Air temperature at TS32__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3301
Air temperature at TS33__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3401
Air temperature at TS34__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3501
Air temperature at TS35__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3601
Air temperature at TS36__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3701
Air temperature at TS37__, probe no. 01 at height 100 cm, discontinued 1976
AIRR3801
Air temperature at RS38__, probe no. 01 at height 100 cm, discontinued 2017
AIRT7401
Air temperature at TS74__, probe no. 01 at height 100 cm, discontinued 1990
AIRT7501
Air temperature at TS75__, probe no. 01 at height 100 cm, discontinued 1990
AIRT7601
Air temperature at TS76__, probe no. 01 at height 100 cm, discontinued 1975
AIRT7701
Air temperature at TS77__, probe no. 01 at height 100 cm, discontinued 1975
SOIO1302
Soil temperature at RS13O_, probe no. 02 at depth 20 cm, discontinued 2003
SOIR0102
Soil temperature at RS01__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR0201
Soil temperature at RS02__, probe no. 01 at depth 10 cm
SOIR0202
Soil temperature at RS02__, probe no. 02 at depth 20 cm
SOIR0203
Soil temperature at RS02__, probe no. 03 at depth 30 cm
SOIR0302
Soil temperature at RS03__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR0401
Soil temperature at RS04__, probe no. 01 at depth 10 cm
SOIR0402
Soil temperature at RS04__, probe no. 02 at depth 20 cm
SOIR0403
Soil temperature at RS04__, probe no. 03 at depth 30 cm
SOIR0501
Soil temperature at RS05__, probe no. 01 at depth 10 cm
SOIR0502
Soil temperature at RS05__, probe no. 02 at depth 20 cm
SOIR0503
Soil temperature at RS05__, probe no. 03 at depth 30 cm
SOIR0602
Soil temperature at RS06__, probe no. 02 at depth 20 cm, discontinued 1975
SOIR0702
Soil temperature at RS07__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR0802
Soil temperature at RS08__, probe no. 02 at depth 20 cm, discontinued 1973
SOIR0902
Soil temperature at RS09__, probe no. 02 at depth 20 cm, discontinued 1975
SOIR1001
Soil temperature at RS10__, probe no. 01 at depth 10 cm
SOIR1002
Soil temperature at RS10__, probe no. 02 at depth 20 cm
SOIR1003
Soil temperature at RS10__, probe no. 03 at depth 30 cm
SOIR1102
Soil temperature at RS11__, probe no. 02 at depth 20 cm, discontinued 1977
SOIR1201
Soil temperature at RS12__, probe no. 01 at depth 10 cm
SOIR1202
Soil temperature at RS12__, probe no. 02 at depth 20 cm
SOIR1203
Soil temperature at RS12__, probe no. 03 at depth 30 cm
SOIR1302
Soil temperature at RS13__, probe no. 02 at depth 20 cm, discontinued 2003
SOIR1401
Soil temperature at RS14__, probe no. 01 at depth 10 cm, discontinued 2003
SOIR1402
Soil temperature at RS14__, probe no. 02 at depth 20 cm, discontinued 2003
SOIR1403
Soil temperature at RS14__, probe no. 03 at depth 30 cm, discontinued 2003
SOIR1502
Soil temperature at RS15__, probe no. 02 at depth 20 cm, discontinued 1994
SOIR1602
Soil temperature at RS16__, probe no. 02 at depth 20 cm, discontinued 1994
SOIR1702
Soil temperature at RS17__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR1802
Soil temperature at RS18__, probe no. 02 at depth 20 cm, discontinued 1974
SOIR1902
Soil temperature at RS19__, probe no. 02 at depth 20 cm, discontinued 1973
SOIR2001
Soil temperature at RS20__, probe no. 01 at depth 10 cm
SOIR2002
Soil temperature at RS20__, probe no. 02 at depth 20 cm
SOIR2003
Soil temperature at RS20__, probe no. 03 at depth 30 cm
SOIR2401
Soil temperature at RS24__, probe no. 01 at depth 10 cm, discontinued 2004
SOIR2402
Soil temperature at RS24__, probe no. 02 at depth 20 cm, discontinued 2004
SOIR2403
Soil temperature at RS24__, probe no. 03 at depth 30 cm, discontinued 2004
SOIR2601
Soil temperature at RS26__, probe no. 01 at depth 10 cm
SOIR2602
Soil temperature at RS26__, probe no. 02 at depth 20 cm
SOIR2603
Soil temperature at RS26__, probe no. 03 at depth 30 cm
SOIR8601
Soil temperature at RS86__, probe no. 01 at depth 10 cm
SOIR8602
Soil temperature at RS86__, probe no. 02 at depth 20 cm
SOIR8603
Soil temperature at RS86__, probe no. 03 at depth 30 cm
SOIR8901
Soil temperature at RS89__, probe no. 01 at depth 10 cm
SOIR8902
Soil temperature at RS89__, probe no. 02 at depth 20 cm
SOIR8903
Soil temperature at RS89__, probe no. 03 at depth 30 cm
SOIT3102
Soil temperature at TS31__, probe no. 02 at depth 20 cm, discontinued 1976
SOIT3202
Soil temperature at TS32__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3302
Soil temperature at TS33__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3402
Soil temperature at TS34__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3502
Soil temperature at TS35__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3602
Soil temperature at TS36__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3702
Soil temperature at TS37__, probe no. 02 at depth 20 cm, discontinued 1976
SOIR3801
Soil temperature at RS38__, probe no. 01 at depth 10 cm
SOIR3802
Soil temperature at RS38__, probe no. 02 at depth 20 cm
SOIR3803
Soil temperature at RS38__, probe no. 03 at depth 30 cm
SOIT7402
Soil temperature at TS74__, probe no. 02 at depth 20 cm, discontinued 1990
SOIT7502
Soil temperature at TS75__, probe no. 02 at depth 20 cm, discontinued 1990
SOIT7602
Soil temperature at TS76__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT7702
Soil temperature at TS77__, probe no. 02 at depth 20 cm, discontinued 1975
RELR8601
Relative humidity at RS86__, probe no. 01 at height 235 cm, discontinued 2017
RELR8901
Relative humidity at RS89__, probe no. 01 at height 285 cm, discontinued 2017
AIRR0202
Air temperature at RS02__, probe no. 02 at height 225 cm
AIRR0203
Air temperature at RS02__, probe no. 03 at height 225 cm
AIRR0402
Air temperature at RS04__, probe no. 02 at height 325 cm
AIRR0403
Air temperature at RS04__, probe no. 03 at height 325 cm
AIRR1202
Air temperature at RS12__, probe no. 02 at height 190 cm
AIRR1203
Air temperature at RS12__, probe no. 03 at height 190 cm
AIRR2002
Air temperature at RS20__, probe no. 02 at height 220 cm
AIRR2003
Air temperature at RS20__, probe no. 03 at height 220 cm
AIRR2602
Air temperature at RS26__, probe no. 02 at height 200 cm
AIRR2603
Air temperature at RS26__, probe no. 03 at height 200 cm
AIRR0502
Air temperature at RS05__, probe no. 02 at height 200 cm
AIRR0503
Air temperature at RS05__, probe no. 03 at height 200 cm
AIRR1002
Air temperature at RS10__, probe no. 02 at height 200 cm
AIRR1003
Air temperature at RS10__, probe no. 03 at height 200 cm
AIRR3802
Air temperature at RS38__, probe no. 02 at height 100 cm
AIRR3803
Air temperature at RS38__, probe no. 03 at height 100 cm
AIRR8602
Air temperature at RS86__, probe no. 02 at height 235 cm
AIRR8603
Air temperature at RS86__, probe no. 03 at height 235 cm
AIRR8902
Air temperature at RS89__, probe no. 02 at height 285 cm
AIRR8903
Air temperature at RS89__, probe no. 03 at height 285 cm

DATE - datetime (dateTime)

ID: MS00501.DATE

Date of measurement

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

AIRTEMP_MEAN_DAY - numeric(5,1) (interval)

ID: MS00501.AIRTEMP_MEAN_DAY

Mean air temperature for the day

Type system: Microsoft SQL Server 2019

Unit: degrees Celsius

Precision: 0.100000

Numeric domain: type=real, min=-23.5000 (exclusive=false), max=32.6000 (exclusive=false)

AIRTEMP_MEAN_FLAG - char(1) (nominal)

ID: MS00501.AIRTEMP_MEAN_FLAG

Mean air temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (7)

B
Sensor buried in snow; value represents snow temperature
E
Estimated value
M
Missing value
Q
Questionable value
S
Daily value based on sunrise to sunrise (not midnight to midnight)
A
Accepted value has passed all QC tests applied as represented by the quality level
P
Fire effects are visible in the data

AIRTEMP_MAX_DAY - numeric(5,1) (interval)

ID: MS00501.AIRTEMP_MAX_DAY

Maximum air temperature for the day

Type system: Microsoft SQL Server 2019

Unit: degrees Celsius

Precision: 0.100000

Numeric domain: type=real, min=-20.5000 (exclusive=false), max=42.9000 (exclusive=false)

AIRTEMP_MAX_FLAG - char(1) (nominal)

ID: MS00501.AIRTEMP_MAX_FLAG

Maximum air temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (7)

B
Sensor buried in snow; value represents snow temperature
E
Estimated value
M
Missing value
Q
Questionable value
S
Daily value based on sunrise to sunrise (not midnight to midnight)
A
Accepted value has passed all QC tests applied as represented by the quality level
H
Daily value based on the maximum hourly mean value (Check airtemp_method code)

AIRTEMP_MAXTIME - char(4) (ordinal)

ID: MS00501.AIRTEMP_MAXTIME

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

Type system: Microsoft SQL Server 2019

AIRTEMP_MIN_DAY - numeric(5,1) (interval)

ID: MS00501.AIRTEMP_MIN_DAY

Minimum air temperature for the day

Type system: Microsoft SQL Server 2019

Unit: degrees Celsius

Precision: 0.100000

Numeric domain: type=real, min=-25.1000 (exclusive=false), max=27.2000 (exclusive=false)

AIRTEMP_MIN_FLAG - char(1) (nominal)

ID: MS00501.AIRTEMP_MIN_FLAG

Minimum air temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (7)

B
Sensor buried in snow; value represents snow temperature
E
Estimated value
M
Missing value
Q
Questionable value
S
Daily value based on sunrise to sunrise (not midnight to midnight)
A
Accepted value has passed all QC tests applied as represented by the quality level
H
Daily value based on the minimum hourly mean value (Check airtemp_method code)

AIRTEMP_MINTIME - char(4) (ordinal)

ID: MS00501.AIRTEMP_MINTIME

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

Type system: Microsoft SQL Server 2019

EVENT_CODE - char(6) (nominal)

ID: MS00501.EVENT_CODE

Type of comment that exists independently for 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

Type system: Microsoft SQL Server 2019

Code definitions (8)

CALIBR
Associated with the inspection or replacement of sensors for calibration
INSREM
Sensor is installed or removed
LOGGER
Change in data logger, data logger program, or wiring
MAINTE
A maintenance event has occurred
METHOD
Change in data collection method
NA
No event is reported (not applicable)
QUALTY
Event may directly affect data quality
WEATHR
A weather event has occurred that may affect reading

MS00502 - Relative Humidity (Daily)

Object name: MS00502_v5.csv

Records: 9678

Attributes: 17

Temporal coverage: 2004-07-19 to 2017-10-24

File size: 896404 byte

Checksum (MD5): ffd0aaef9bc3fa9f59acf6e56021b04d

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

Constraints (2)

primaryKey: PRIMARY
MS00502.DATE, MS00502.PROBE_CODE, MS00502.SITECODE
notNullConstraint: NOTNULL
MS00502.DATE, MS00502.PROBE_CODE, MS00502.DBCODE, MS00502.SITECODE, MS00502.ENTITY, MS00502.RELHUM_MEAN_FLAG, MS00502.RELHUM_MAX_FLAG, MS00502.RELHUM_MIN_FLAG, MS00502.QC_LEVEL, MS00502.EVENT_CODE, MS00502.RELHUM_METHOD, MS00502.HEIGHT

Attributes (17)

DBCODE - char(5) (nominal)

ID: MS00502.DBCODE

FSDB database code

Type system: Microsoft SQL Server 2019

Code definitions (1)

MS005
FSDB Database Code

ENTITY - numeric(2,0) (interval)

ID: MS00502.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SITECODE - char(6) (nominal)

ID: MS00502.SITECODE

Site code for the meteorological measurement station

Type system: Microsoft SQL Server 2019

Code definitions (37)

RS01__
Reference Stand RS01 air/soil temperature site
RS02__
Reference Stand RS02 air/soil temperature site
RS03__
Reference Stand RS03 air/soil temperature site
RS04__
Reference Stand RS04 air/soil temperature site
RS05__
Reference Stand RS05 air/soil temperature site
RS06__
Reference Stand RS06 air/soil temperature site
RS07__
Reference Stand RS07 air/soil temperature site
RS08__
Reference Stand RS08 air/soil temperature site
RS09__
Reference Stand RS09 air/soil temperature site
RS10__
Reference Stand RS10 air/soil temperature site
RS11__
Reference Stand RS11 air/soil temperature site
RS12__
Reference Stand RS12 air/soil temperature site
RS13__
Reference Stand RS13 air/soil temperature site
RS14__
Reference Stand RS14 air/soil temperature site
RS15__
Reference Stand RS15 air/soil temperature site
RS16__
Reference Stand RS16 air/soil temperature site
RS17__
Reference Stand RS17 air/soil temperature site
RS18__
Reference Stand RS18 air/soil temperature site
RS19__
Reference Stand RS19 air/soil temperature site
RS20__
Reference Stand RS20 air/soil temperature site
RS24__
Reference Stand RS24 air/soil temperature site
RS26__
Reference Stand RS26 air/soil temperature site
TS31__
Thermograph site 31
TS32__
Thermograph site 32
TS33__
Thermograph site 33
TS34__
Thermograph site 34
TS35__
Thermograph site 35
TS36__
Thermograph site 36
TS37__
Thermograph site 37
RS38__
Reference Stand RS38 air/soil temperature site (formerly TS38__)
TS74__
Thermograph site 74
TS75__
Thermograph site 75
TS76__
Thermograph site 76
TS77__
Thermograph site 77
RS86__
Reference Stand RS86 air/soil temperature and relative humidity site
RS89__
Reference Stand RS89 air/soil temperature and relative humidity site
RS13O_
Reference Stand RS13 Open canopy air/soil temperature site

RELHUM_METHOD - char(6) (nominal)

ID: MS00502.RELHUM_METHOD

An indication of the the general methodology and instrumentation used to collect this relative humidity data

Type system: Microsoft SQL Server 2019

Code definitions (4)

REL018
Relative humidity is sampled by a Campbell Scientific model HMP45C probe housed in a R.M. Young Gill radiation shield at 235 cm height; mean relative humidity is output every 60 minutes
REL019
Relative humidity is sampled by a Campbell Scientific model HMP45C probe housed in a R.M. Young Gill radiation shield at 285 cm height; mean relative humidity is output every 60 minutes
REL118
Mean daily, max and min relative humidity is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model HMP45C probe housed in a R.M. Young Gill radiation shield at 235 cm height (See Method REL018)
REL119
Mean daily, max and min relative humidity is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model HMP45C probe housed in a R.M. Young Gill radiation shield at 285 cm height (See Method REL019)

HEIGHT - numeric(4,0) (ratio)

ID: MS00502.HEIGHT

Height of sensor from ground surface

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

Numeric domain: type=whole, min=85.0000 (exclusive=false), max=435.0000 (exclusive=false)

QC_LEVEL - char(2) (nominal)

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

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
1D
Data is published and unlikely to change - data is derived or aggregated from published data of level 1A
1P
Data is provisional and subject to revision - preliminary quality checks have been performed
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

PROBE_CODE - char(8) (nominal)

ID: MS00502.PROBE_CODE

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

Type system: Microsoft SQL Server 2019

Code definitions (120)

AIRO1301
Air temperature at RS13O_, probe no. 01 at height 435 cm, discontinued 2003
AIRR0101
Air temperature at RS01__, probe no. 01 at height 100 cm, discontinued 1995
AIRR0201
Air temperature at RS02__, probe no. 01 at height 225 cm, discontinued 2015
AIRR0301
Air temperature at RS03__, probe no. 01 at height 235 cm, discontinued 1995
AIRR0401
Air temperature at RS04__, probe no. 01 at height 325 cm, discontinued 2015
AIRR0501
Air temperature at RS05__, probe no. 01 at height 200 cm, discontinued 2017
AIRR0601
Air temperature at RS06__, probe no. 01 at height 100 cm, discontinued 1975
AIRR0701
Air temperature at RS07__, probe no. 01 at height 100 cm, discontinued 1995
AIRR0801
Air temperature at RS08__, probe no. 01 at height 100 cm, discontinued 1973
AIRR0901
Air temperature at RS09__, probe no. 01 at height 100 cm, discontinued 1975
AIRR1001
Air temperature at RS10__, probe no. 01 at height 200 cm, discontinued 2017
AIRR1101
Air temperature at RS11__, probe no. 01 at height 100 cm, discontinued 1977
AIRR1201
Air temperature at RS12__, probe no. 01 at height 190 cm, discontinued 2015
AIRR1301
Air temperature at RS13__, probe no. 01 at height 275 cm, discontinued 2003
AIRR1401
Air temperature at RS14__, probe no. 01 at height 285 cm, discontinued 2003
AIRR1501
Air temperature at RS15__, probe no. 01 at height 180 cm, discontinued 1994
AIRR1601
Air temperature at RS16__, probe no. 01 at height 180 cm, discontinued 1994
AIRR1701
Air temperature at RS17__, probe no. 01 at height 60 cm, discontinued 1995
AIRR1801
Air temperature at RS18__, probe no. 01 at height 100 cm, discontinued 1974
AIRR1901
Air temperature at RS19__, probe no. 01 at height 100 cm, discontinued 1973
AIRR2001
Air temperature at RS20__, probe no. 01 at height 220 cm, discontinued 2015
AIRR2401
Air temperature at RS24__, probe no. 01 at height 220 cm, discontinued 2004
AIRR2601
Air temperature at RS26__, probe no. 01 at height 200 cm, discontinued 2015
AIRR8601
Air temperature at RS86__, probe no. 01 at height 235 cm, discontinued 2017
AIRR8901
Air temperature at RS89__, probe no. 01 at height 285 cm, discontinued 2017
AIRT3101
Air temperature at TS31__, probe no. 01 at height 100 cm, discontinued 1976
AIRT3201
Air temperature at TS32__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3301
Air temperature at TS33__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3401
Air temperature at TS34__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3501
Air temperature at TS35__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3601
Air temperature at TS36__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3701
Air temperature at TS37__, probe no. 01 at height 100 cm, discontinued 1976
AIRR3801
Air temperature at RS38__, probe no. 01 at height 100 cm, discontinued 2017
AIRT7401
Air temperature at TS74__, probe no. 01 at height 100 cm, discontinued 1990
AIRT7501
Air temperature at TS75__, probe no. 01 at height 100 cm, discontinued 1990
AIRT7601
Air temperature at TS76__, probe no. 01 at height 100 cm, discontinued 1975
AIRT7701
Air temperature at TS77__, probe no. 01 at height 100 cm, discontinued 1975
SOIO1302
Soil temperature at RS13O_, probe no. 02 at depth 20 cm, discontinued 2003
SOIR0102
Soil temperature at RS01__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR0201
Soil temperature at RS02__, probe no. 01 at depth 10 cm
SOIR0202
Soil temperature at RS02__, probe no. 02 at depth 20 cm
SOIR0203
Soil temperature at RS02__, probe no. 03 at depth 30 cm
SOIR0302
Soil temperature at RS03__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR0401
Soil temperature at RS04__, probe no. 01 at depth 10 cm
SOIR0402
Soil temperature at RS04__, probe no. 02 at depth 20 cm
SOIR0403
Soil temperature at RS04__, probe no. 03 at depth 30 cm
SOIR0501
Soil temperature at RS05__, probe no. 01 at depth 10 cm
SOIR0502
Soil temperature at RS05__, probe no. 02 at depth 20 cm
SOIR0503
Soil temperature at RS05__, probe no. 03 at depth 30 cm
SOIR0602
Soil temperature at RS06__, probe no. 02 at depth 20 cm, discontinued 1975
SOIR0702
Soil temperature at RS07__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR0802
Soil temperature at RS08__, probe no. 02 at depth 20 cm, discontinued 1973
SOIR0902
Soil temperature at RS09__, probe no. 02 at depth 20 cm, discontinued 1975
SOIR1001
Soil temperature at RS10__, probe no. 01 at depth 10 cm
SOIR1002
Soil temperature at RS10__, probe no. 02 at depth 20 cm
SOIR1003
Soil temperature at RS10__, probe no. 03 at depth 30 cm
SOIR1102
Soil temperature at RS11__, probe no. 02 at depth 20 cm, discontinued 1977
SOIR1201
Soil temperature at RS12__, probe no. 01 at depth 10 cm
SOIR1202
Soil temperature at RS12__, probe no. 02 at depth 20 cm
SOIR1203
Soil temperature at RS12__, probe no. 03 at depth 30 cm
SOIR1302
Soil temperature at RS13__, probe no. 02 at depth 20 cm, discontinued 2003
SOIR1401
Soil temperature at RS14__, probe no. 01 at depth 10 cm, discontinued 2003
SOIR1402
Soil temperature at RS14__, probe no. 02 at depth 20 cm, discontinued 2003
SOIR1403
Soil temperature at RS14__, probe no. 03 at depth 30 cm, discontinued 2003
SOIR1502
Soil temperature at RS15__, probe no. 02 at depth 20 cm, discontinued 1994
SOIR1602
Soil temperature at RS16__, probe no. 02 at depth 20 cm, discontinued 1994
SOIR1702
Soil temperature at RS17__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR1802
Soil temperature at RS18__, probe no. 02 at depth 20 cm, discontinued 1974
SOIR1902
Soil temperature at RS19__, probe no. 02 at depth 20 cm, discontinued 1973
SOIR2001
Soil temperature at RS20__, probe no. 01 at depth 10 cm
SOIR2002
Soil temperature at RS20__, probe no. 02 at depth 20 cm
SOIR2003
Soil temperature at RS20__, probe no. 03 at depth 30 cm
SOIR2401
Soil temperature at RS24__, probe no. 01 at depth 10 cm, discontinued 2004
SOIR2402
Soil temperature at RS24__, probe no. 02 at depth 20 cm, discontinued 2004
SOIR2403
Soil temperature at RS24__, probe no. 03 at depth 30 cm, discontinued 2004
SOIR2601
Soil temperature at RS26__, probe no. 01 at depth 10 cm
SOIR2602
Soil temperature at RS26__, probe no. 02 at depth 20 cm
SOIR2603
Soil temperature at RS26__, probe no. 03 at depth 30 cm
SOIR8601
Soil temperature at RS86__, probe no. 01 at depth 10 cm
SOIR8602
Soil temperature at RS86__, probe no. 02 at depth 20 cm
SOIR8603
Soil temperature at RS86__, probe no. 03 at depth 30 cm
SOIR8901
Soil temperature at RS89__, probe no. 01 at depth 10 cm
SOIR8902
Soil temperature at RS89__, probe no. 02 at depth 20 cm
SOIR8903
Soil temperature at RS89__, probe no. 03 at depth 30 cm
SOIT3102
Soil temperature at TS31__, probe no. 02 at depth 20 cm, discontinued 1976
SOIT3202
Soil temperature at TS32__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3302
Soil temperature at TS33__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3402
Soil temperature at TS34__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3502
Soil temperature at TS35__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3602
Soil temperature at TS36__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3702
Soil temperature at TS37__, probe no. 02 at depth 20 cm, discontinued 1976
SOIR3801
Soil temperature at RS38__, probe no. 01 at depth 10 cm
SOIR3802
Soil temperature at RS38__, probe no. 02 at depth 20 cm
SOIR3803
Soil temperature at RS38__, probe no. 03 at depth 30 cm
SOIT7402
Soil temperature at TS74__, probe no. 02 at depth 20 cm, discontinued 1990
SOIT7502
Soil temperature at TS75__, probe no. 02 at depth 20 cm, discontinued 1990
SOIT7602
Soil temperature at TS76__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT7702
Soil temperature at TS77__, probe no. 02 at depth 20 cm, discontinued 1975
RELR8601
Relative humidity at RS86__, probe no. 01 at height 235 cm, discontinued 2017
RELR8901
Relative humidity at RS89__, probe no. 01 at height 285 cm, discontinued 2017
AIRR0202
Air temperature at RS02__, probe no. 02 at height 225 cm
AIRR0203
Air temperature at RS02__, probe no. 03 at height 225 cm
AIRR0402
Air temperature at RS04__, probe no. 02 at height 325 cm
AIRR0403
Air temperature at RS04__, probe no. 03 at height 325 cm
AIRR1202
Air temperature at RS12__, probe no. 02 at height 190 cm
AIRR1203
Air temperature at RS12__, probe no. 03 at height 190 cm
AIRR2002
Air temperature at RS20__, probe no. 02 at height 220 cm
AIRR2003
Air temperature at RS20__, probe no. 03 at height 220 cm
AIRR2602
Air temperature at RS26__, probe no. 02 at height 200 cm
AIRR2603
Air temperature at RS26__, probe no. 03 at height 200 cm
AIRR0502
Air temperature at RS05__, probe no. 02 at height 200 cm
AIRR0503
Air temperature at RS05__, probe no. 03 at height 200 cm
AIRR1002
Air temperature at RS10__, probe no. 02 at height 200 cm
AIRR1003
Air temperature at RS10__, probe no. 03 at height 200 cm
AIRR3802
Air temperature at RS38__, probe no. 02 at height 100 cm
AIRR3803
Air temperature at RS38__, probe no. 03 at height 100 cm
AIRR8602
Air temperature at RS86__, probe no. 02 at height 235 cm
AIRR8603
Air temperature at RS86__, probe no. 03 at height 235 cm
AIRR8902
Air temperature at RS89__, probe no. 02 at height 285 cm
AIRR8903
Air temperature at RS89__, probe no. 03 at height 285 cm

DATE - datetime (dateTime)

ID: MS00502.DATE

Date of measurement

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

RELHUM_MEAN_DAY - numeric(5,1) (ratio)

ID: MS00502.RELHUM_MEAN_DAY

Mean relative humidity for the day

Type system: Microsoft SQL Server 2019

Unit: percent

Precision: 2.000000

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

RELHUM_MEAN_FLAG - char(1) (nominal)

ID: MS00502.RELHUM_MEAN_FLAG

Mean relative humidity flag

Type system: Microsoft SQL Server 2019

Code definitions (5)

A
Accepted value has passed all QC tests applied as represented by the quality level
B
Sensor buried in snow
E
Estimated value
M
Missing value
Q
Questionable value

RELHUM_MAX_DAY - numeric(5,1) (ratio)

ID: MS00502.RELHUM_MAX_DAY

Maximum relative humidity for the day

Type system: Microsoft SQL Server 2019

Unit: percent

Precision: 2.000000

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

RELHUM_MAX_FLAG - char(1) (nominal)

ID: MS00502.RELHUM_MAX_FLAG

Maximum relative humidity flag

Type system: Microsoft SQL Server 2019

Code definitions (5)

A
Accepted value has passed all QC tests applied as represented by the quality level
B
Sensor buried in snow
E
Estimated value
M
Missing value
Q
Questionable value

RELHUM_MAXTIME - char(4) (ordinal)

ID: MS00502.RELHUM_MAXTIME

Time of day (HHMM) in Pacific Standard Time (PST) of maximum relative humidity

Type system: Microsoft SQL Server 2019

RELHUM_MIN_DAY - numeric(5,1) (ratio)

ID: MS00502.RELHUM_MIN_DAY

Minimum relative humidity for the day

Type system: Microsoft SQL Server 2019

Unit: percent

Precision: 2.000000

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

RELHUM_MIN_FLAG - char(1) (nominal)

ID: MS00502.RELHUM_MIN_FLAG

Minimum relative humidity flag

Type system: Microsoft SQL Server 2019

Code definitions (5)

A
Accepted value has passed all QC tests applied as represented by the quality level
B
Sensor buried in snow
E
Estimated value
M
Missing value
Q
Questionable value

RELHUM_MINTIME - char(4) (ordinal)

ID: MS00502.RELHUM_MINTIME

Time of day (HHMM) in Pacific Standard Time (PST) of minimum relative humidity

Type system: Microsoft SQL Server 2019

EVENT_CODE - char(6) (nominal)

ID: MS00502.EVENT_CODE

Type of comment that exists independently for 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

Type system: Microsoft SQL Server 2019

Code definitions (8)

CALIBR
Associated with the inspection or replacement of sensors for calibration
INSREM
Sensor is installed or removed
LOGGER
Change in data logger, data logger program, or wiring
MAINTE
A maintenance event has occurred
METHOD
Change in data collection method
NA
No event is reported (not applicable)
QUALTY
Event may directly affect data quality
WEATHR
A weather event has occurred that may affect reading

MS00511 - Air temperature (Finest resolution, e.g., hourly, 5 minute)

Object name: MS00511_v8.txt

Records: 21595724

Attributes: 11

Temporal coverage: 1998-03-13 to 2024-10-01

File size: 1673144469 byte

Checksum (MD5): b8c37fe8d784d7b2c62efb71a0cba510

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

Constraints (2)

primaryKey: PRIMARY
MS00511.DATE_TIME, MS00511.PROBE_CODE, MS00511.SITECODE
notNullConstraint: NOTNULL
MS00511.DATE_TIME, MS00511.AIRTEMP_MEAN_FLAG, MS00511.PROBE_CODE, MS00511.DBCODE, MS00511.SITECODE, MS00511.ENTITY, MS00511.AIRTEMP_METHOD, MS00511.QC_LEVEL, MS00511.EVENT_CODE, MS00511.HEIGHT

Attributes (11)

DBCODE - char(5) (nominal)

ID: MS00511.DBCODE

FSDB database code

Type system: Microsoft SQL Server 2019

Code definitions (1)

MS005
FSDB Database Code

ENTITY - numeric(2,0) (interval)

ID: MS00511.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SITECODE - char(6) (nominal)

ID: MS00511.SITECODE

Site code for the meteorological measurement station

Type system: Microsoft SQL Server 2019

Code definitions (37)

RS01__
Reference Stand RS01 air/soil temperature site
RS02__
Reference Stand RS02 air/soil temperature site
RS03__
Reference Stand RS03 air/soil temperature site
RS04__
Reference Stand RS04 air/soil temperature site
RS05__
Reference Stand RS05 air/soil temperature site
RS06__
Reference Stand RS06 air/soil temperature site
RS07__
Reference Stand RS07 air/soil temperature site
RS08__
Reference Stand RS08 air/soil temperature site
RS09__
Reference Stand RS09 air/soil temperature site
RS10__
Reference Stand RS10 air/soil temperature site
RS11__
Reference Stand RS11 air/soil temperature site
RS12__
Reference Stand RS12 air/soil temperature site
RS13__
Reference Stand RS13 air/soil temperature site
RS14__
Reference Stand RS14 air/soil temperature site
RS15__
Reference Stand RS15 air/soil temperature site
RS16__
Reference Stand RS16 air/soil temperature site
RS17__
Reference Stand RS17 air/soil temperature site
RS18__
Reference Stand RS18 air/soil temperature site
RS19__
Reference Stand RS19 air/soil temperature site
RS20__
Reference Stand RS20 air/soil temperature site
RS24__
Reference Stand RS24 air/soil temperature site
RS26__
Reference Stand RS26 air/soil temperature site
TS31__
Thermograph site 31
TS32__
Thermograph site 32
TS33__
Thermograph site 33
TS34__
Thermograph site 34
TS35__
Thermograph site 35
TS36__
Thermograph site 36
TS37__
Thermograph site 37
RS38__
Reference Stand RS38 air/soil temperature site (formerly TS38__)
TS74__
Thermograph site 74
TS75__
Thermograph site 75
TS76__
Thermograph site 76
TS77__
Thermograph site 77
RS86__
Reference Stand RS86 air/soil temperature and relative humidity site
RS89__
Reference Stand RS89 air/soil temperature and relative humidity site
RS13O_
Reference Stand RS13 Open canopy air/soil temperature site

AIRTEMP_METHOD - char(6) (nominal)

ID: MS00511.AIRTEMP_METHOD

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

Type system: Microsoft SQL Server 2019

Code definitions (103)

AIR504
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 60 cm height in small shelter on tree and corrected to standard rdg.
AIR505
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 65 cm height in small shelter on tree and corrected to standard rdg.
AIR506
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 80 cm height in small shelter on tree and corrected to standard rdg.
AIR507
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 85 cm height in small shelter on tree and corrected to standard rdg.
AIR508
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 100 cm height in small shelter on tree and corrected to standard rdg.
AIR509
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 160 cm height in small shelter on tree and corrected to standard rdg.
AIR510
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 180 cm height in small shelter on tree and corrected to standard rdg.
AIR511
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 190 cm height in small shelter on tree and corrected to standard rdg.
AIR512
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 200 cm height in small shelter on tree and corrected to standard rdg.
AIR513
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 235 cm height in small shelter on tree and corrected to standard rdg.
AIR514
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 300 cm height in small shelter on tree and corrected to standard rdg.
AIR515
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 500 cm height in small shelter on tree and corrected to standard rdg.
AIR501
Mean, max and min daily (sunrise to sunrise) air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 100 cm height in small shelter and corrected.
AIR502
Mean, max and min daily (sunrise to sunrise) air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 200 cm height in small shelter and corrected.
AIR503
Mean, max and min daily (sunrise to sunrise) air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 300 cm height in small shelter and corrected.
AIR448
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 190 cm height; mean temperature is output every 5 minutes
AIR449
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 200 cm height; mean temperature is output every 5 minutes
AIR450
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 220 cm height; mean temperature is output every 5 minutes
AIR451
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 225 cm height; mean temperature is output every 5 minutes
AIR452
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 325 cm height; mean temperature is output every 5 minutes
AIR444
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 100 cm height; mean temperature is output every 60 minutes
AIR445
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 200 cm height; mean temperature is output every 60 minutes
AIR440
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 85 cm height; mean temperature is output every 60 minutes
AIR441
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 100 cm height; mean temperature is output every 60 minutes
AIR442
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 200 cm height; mean temperature is output every 60 minutes
AIR443
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 235 cm height; mean temperature is output every 60 minutes
AIR446
Air temperature is sampled by a Campbell Scientific model HMP45C probe housed in a R.M. Young Gill radiation shield at 235 cm height; mean temperature is output every 60 minutes
AIR447
Air temperature is sampled by a Campbell Scientific model HMP45C probe housed in a R.M. Young Gill radiation shield at 285 cm height; mean temperature is output every 60 minutes
AIR435
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a R.M. Young Gill radiation shield at 190 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR436
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a R.M. Young Gill radiation shield at 200 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR437
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a R.M. Young Gill radiation shield at 220 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR438
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a R.M. Young Gill radiation shield at 225 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR439
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a R.M. Young Gill radiation shield at 325 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR516
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 100 cm height (Daily output only)
AIR517
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 190 cm height (Daily output only)
AIR518
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 200 cm height (Daily output only)
AIR519
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 220 cm height (Daily output only)
AIR520
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 225 cm height (Daily output only)
AIR521
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 275 cm height (Daily output only)
AIR522
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 285 cm height (Daily output only)
AIR523
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 300 cm height (Daily output only)
AIR524
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 325 cm height (Daily output only)
AIR525
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 400 cm height (Daily output only)
AIR526
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 435 cm height (Daily output only)
AIR427
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a locally designed PVC radiation shield at 190 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR428
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a locally designed PVC radiation shield at 200 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR429
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a locally designed PVC radiation shield at 220 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR430
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a locally designed PVC radiation shield at 225 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR431
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a locally designed PVC radiation shield at 275 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR432
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a locally designed PVC radiation shield at 285 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR433
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a locally designed PVC radiation shield at 325 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR434
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a locally designed PVC radiation shield at 435 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
AIR527
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 190 cm height (See Method AIR427)
AIR528
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 200 cm height (See Method AIR428)
AIR529
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 220 cm height (See Method AIR429)
AIR530
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 225 cm height (See Method AIR430)
AIR531
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 275 cm height (See Method AIR431)
AIR532
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 285 cm height (See Method AIR432)
AIR533
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 325 cm height (See Method AIR433)
AIR534
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 435 cm height (See Method AIR434)
AIR535
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a R.M. Young Gill radiation shield at 190 cm height (See Method AIR435)
AIR536
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a R.M. Young Gill radiation shield at 200 cm height (See Method AIR436)
AIR537
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a R.M. Young Gill radiation shield at 220 cm height (See Method AIR437)
AIR538
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a R.M. Young Gill radiation shield at 225 cm height (See Method AIR438)
AIR539
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple wire housed in a R.M. Young Gill radiation shield at 325 cm height (See Method AIR439)
AIR540
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 85 cm height (See Method AIR440)
AIR541
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 100 cm height (See Method AIR441)
AIR542
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 200 cm height (See Method AIR442)
AIR543
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 235 cm height (See Method AIR443)
AIR544
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 100 cm height (See Method AIR444)
AIR545
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 200 cm height (See Method AIR445)
AIR546
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model HMP45C probe housed in a R.M. Young Gill radiation shield at 235 cm height (See Method AIR446)
AIR547
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model HMP45C probe housed in a R.M. Young Gill radiation shield at 285 cm height (See Method AIR447)
AIR548
Mean daily air 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 thermistor; RM Young Gill radiation shield; 190 cm height (See AIR448)
AIR549
Mean daily air 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 thermistor; RM Young Gill radiation shield; 200 cm height (See AIR449)
AIR550
Mean daily air 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 thermistor; RM Young Gill radiation shield; 220 cm height (See AIR450)
AIR551
Mean daily air 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 thermistor; RM Young Gill radiation shield; 225 cm height (See AIR451)
AIR552
Mean daily air 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 thermistor; RM Young Gill radiation shield; 325 cm height (See AIR452)
AIR635
Mean daily air temperature is post-calculated from hourly mean values for the day. Max-min values are based on hourly mean intervals and not instantaneous values. Type T thermocouple wire; R.M. Young Gill radiation shield; 190 cm (See Method AIR435)
AIR636
Mean daily air temperature is post-calculated from hourly mean values for the day. Max-min values are based on hourly mean intervals and not instantaneous values. Type T thermocouple wire; R.M. Young Gill radiation shield; 200cm (See Method AIR436)
AIR637
Mean daily air temperature is post-calculated from hourly mean values for the day. Max-min values are based on hourly mean intervals and not instantaneous values. Type T thermocouple wire; R.M. Young Gill radiation shield; 220cm (See Method AIR437)
AIR638
Mean daily air temperature is post-calculated from hourly mean values for the day. Max-min values are based on hourly mean intervals and not instantaneous values. Type T thermocouple wire; R.M. Young Gill radiation shield; 225cm (See Method AIR438)
AIR639
Mean daily air temperature is post-calculated from hourly mean values for the day. Max-min values are based on hourly mean intervals and not instantaneous values. Type T thermocouple wire; R.M. Young Gill radiation shield; 325cm (See Method AIR439)
AIR453
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 190 cm height; mean, min, max temperature is output every 5 minutes
AIR553
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 190 cm height (See method AIR453)
AIR454
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 200 cm height; mean, min, max temperature is output every 5 minutes
AIR455
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 220 cm height; mean, min, max temperature is output every 5 minutes
AIR456
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 225 cm height; mean, min, max temperature is output every 5 minutes
AIR457
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 325 cm height; mean, min, max temperature is output every 5 minutes
AIR554
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 200 cm height (See method AIR454)
AIR555
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 220 cm height (See method AIR455)
AIR556
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 225 cm height (See method AIR456)
AIR557
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 325 cm height (See method AIR457)
AIR458
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 200 cm height; mean, min, max temperature is output every 5 minutes
AIR459
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 200 cm height; mean, min, max temperature is output every 5 minutes
AIR460
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 100 cm height; mean, min, max temperature is output every 5 minutes
AIR461
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 235 cm height; mean, min, max temperature is output every 5 minutes
AIR462
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 285 cm height; mean, min, max temperature is output every 5 minutes
AIR558
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 200 cm height (See method AIR458)
AIR559
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 200 cm height (See method AIR459)
AIR560
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 100 cm height (See method AIR460)
AIR561
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 235 cm height (See method AIR461)
AIR562
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 285 cm height (See method AIR462)

HEIGHT - numeric(4,0) (ratio)

ID: MS00511.HEIGHT

Height of sensor from ground surface

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

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

QC_LEVEL - char(2) (nominal)

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

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
1D
Data is published and unlikely to change - data is derived or aggregated from published data of level 1A
1P
Data is provisional and subject to revision - preliminary quality checks have been performed
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

PROBE_CODE - char(8) (nominal)

ID: MS00511.PROBE_CODE

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

Type system: Microsoft SQL Server 2019

Code definitions (120)

AIRO1301
Air temperature at RS13O_, probe no. 01 at height 435 cm, discontinued 2003
AIRR0101
Air temperature at RS01__, probe no. 01 at height 100 cm, discontinued 1995
AIRR0201
Air temperature at RS02__, probe no. 01 at height 225 cm, discontinued 2015
AIRR0301
Air temperature at RS03__, probe no. 01 at height 235 cm, discontinued 1995
AIRR0401
Air temperature at RS04__, probe no. 01 at height 325 cm, discontinued 2015
AIRR0501
Air temperature at RS05__, probe no. 01 at height 200 cm, discontinued 2017
AIRR0601
Air temperature at RS06__, probe no. 01 at height 100 cm, discontinued 1975
AIRR0701
Air temperature at RS07__, probe no. 01 at height 100 cm, discontinued 1995
AIRR0801
Air temperature at RS08__, probe no. 01 at height 100 cm, discontinued 1973
AIRR0901
Air temperature at RS09__, probe no. 01 at height 100 cm, discontinued 1975
AIRR1001
Air temperature at RS10__, probe no. 01 at height 200 cm, discontinued 2017
AIRR1101
Air temperature at RS11__, probe no. 01 at height 100 cm, discontinued 1977
AIRR1201
Air temperature at RS12__, probe no. 01 at height 190 cm, discontinued 2015
AIRR1301
Air temperature at RS13__, probe no. 01 at height 275 cm, discontinued 2003
AIRR1401
Air temperature at RS14__, probe no. 01 at height 285 cm, discontinued 2003
AIRR1501
Air temperature at RS15__, probe no. 01 at height 180 cm, discontinued 1994
AIRR1601
Air temperature at RS16__, probe no. 01 at height 180 cm, discontinued 1994
AIRR1701
Air temperature at RS17__, probe no. 01 at height 60 cm, discontinued 1995
AIRR1801
Air temperature at RS18__, probe no. 01 at height 100 cm, discontinued 1974
AIRR1901
Air temperature at RS19__, probe no. 01 at height 100 cm, discontinued 1973
AIRR2001
Air temperature at RS20__, probe no. 01 at height 220 cm, discontinued 2015
AIRR2401
Air temperature at RS24__, probe no. 01 at height 220 cm, discontinued 2004
AIRR2601
Air temperature at RS26__, probe no. 01 at height 200 cm, discontinued 2015
AIRR8601
Air temperature at RS86__, probe no. 01 at height 235 cm, discontinued 2017
AIRR8901
Air temperature at RS89__, probe no. 01 at height 285 cm, discontinued 2017
AIRT3101
Air temperature at TS31__, probe no. 01 at height 100 cm, discontinued 1976
AIRT3201
Air temperature at TS32__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3301
Air temperature at TS33__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3401
Air temperature at TS34__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3501
Air temperature at TS35__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3601
Air temperature at TS36__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3701
Air temperature at TS37__, probe no. 01 at height 100 cm, discontinued 1976
AIRR3801
Air temperature at RS38__, probe no. 01 at height 100 cm, discontinued 2017
AIRT7401
Air temperature at TS74__, probe no. 01 at height 100 cm, discontinued 1990
AIRT7501
Air temperature at TS75__, probe no. 01 at height 100 cm, discontinued 1990
AIRT7601
Air temperature at TS76__, probe no. 01 at height 100 cm, discontinued 1975
AIRT7701
Air temperature at TS77__, probe no. 01 at height 100 cm, discontinued 1975
SOIO1302
Soil temperature at RS13O_, probe no. 02 at depth 20 cm, discontinued 2003
SOIR0102
Soil temperature at RS01__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR0201
Soil temperature at RS02__, probe no. 01 at depth 10 cm
SOIR0202
Soil temperature at RS02__, probe no. 02 at depth 20 cm
SOIR0203
Soil temperature at RS02__, probe no. 03 at depth 30 cm
SOIR0302
Soil temperature at RS03__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR0401
Soil temperature at RS04__, probe no. 01 at depth 10 cm
SOIR0402
Soil temperature at RS04__, probe no. 02 at depth 20 cm
SOIR0403
Soil temperature at RS04__, probe no. 03 at depth 30 cm
SOIR0501
Soil temperature at RS05__, probe no. 01 at depth 10 cm
SOIR0502
Soil temperature at RS05__, probe no. 02 at depth 20 cm
SOIR0503
Soil temperature at RS05__, probe no. 03 at depth 30 cm
SOIR0602
Soil temperature at RS06__, probe no. 02 at depth 20 cm, discontinued 1975
SOIR0702
Soil temperature at RS07__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR0802
Soil temperature at RS08__, probe no. 02 at depth 20 cm, discontinued 1973
SOIR0902
Soil temperature at RS09__, probe no. 02 at depth 20 cm, discontinued 1975
SOIR1001
Soil temperature at RS10__, probe no. 01 at depth 10 cm
SOIR1002
Soil temperature at RS10__, probe no. 02 at depth 20 cm
SOIR1003
Soil temperature at RS10__, probe no. 03 at depth 30 cm
SOIR1102
Soil temperature at RS11__, probe no. 02 at depth 20 cm, discontinued 1977
SOIR1201
Soil temperature at RS12__, probe no. 01 at depth 10 cm
SOIR1202
Soil temperature at RS12__, probe no. 02 at depth 20 cm
SOIR1203
Soil temperature at RS12__, probe no. 03 at depth 30 cm
SOIR1302
Soil temperature at RS13__, probe no. 02 at depth 20 cm, discontinued 2003
SOIR1401
Soil temperature at RS14__, probe no. 01 at depth 10 cm, discontinued 2003
SOIR1402
Soil temperature at RS14__, probe no. 02 at depth 20 cm, discontinued 2003
SOIR1403
Soil temperature at RS14__, probe no. 03 at depth 30 cm, discontinued 2003
SOIR1502
Soil temperature at RS15__, probe no. 02 at depth 20 cm, discontinued 1994
SOIR1602
Soil temperature at RS16__, probe no. 02 at depth 20 cm, discontinued 1994
SOIR1702
Soil temperature at RS17__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR1802
Soil temperature at RS18__, probe no. 02 at depth 20 cm, discontinued 1974
SOIR1902
Soil temperature at RS19__, probe no. 02 at depth 20 cm, discontinued 1973
SOIR2001
Soil temperature at RS20__, probe no. 01 at depth 10 cm
SOIR2002
Soil temperature at RS20__, probe no. 02 at depth 20 cm
SOIR2003
Soil temperature at RS20__, probe no. 03 at depth 30 cm
SOIR2401
Soil temperature at RS24__, probe no. 01 at depth 10 cm, discontinued 2004
SOIR2402
Soil temperature at RS24__, probe no. 02 at depth 20 cm, discontinued 2004
SOIR2403
Soil temperature at RS24__, probe no. 03 at depth 30 cm, discontinued 2004
SOIR2601
Soil temperature at RS26__, probe no. 01 at depth 10 cm
SOIR2602
Soil temperature at RS26__, probe no. 02 at depth 20 cm
SOIR2603
Soil temperature at RS26__, probe no. 03 at depth 30 cm
SOIR8601
Soil temperature at RS86__, probe no. 01 at depth 10 cm
SOIR8602
Soil temperature at RS86__, probe no. 02 at depth 20 cm
SOIR8603
Soil temperature at RS86__, probe no. 03 at depth 30 cm
SOIR8901
Soil temperature at RS89__, probe no. 01 at depth 10 cm
SOIR8902
Soil temperature at RS89__, probe no. 02 at depth 20 cm
SOIR8903
Soil temperature at RS89__, probe no. 03 at depth 30 cm
SOIT3102
Soil temperature at TS31__, probe no. 02 at depth 20 cm, discontinued 1976
SOIT3202
Soil temperature at TS32__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3302
Soil temperature at TS33__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3402
Soil temperature at TS34__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3502
Soil temperature at TS35__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3602
Soil temperature at TS36__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3702
Soil temperature at TS37__, probe no. 02 at depth 20 cm, discontinued 1976
SOIR3801
Soil temperature at RS38__, probe no. 01 at depth 10 cm
SOIR3802
Soil temperature at RS38__, probe no. 02 at depth 20 cm
SOIR3803
Soil temperature at RS38__, probe no. 03 at depth 30 cm
SOIT7402
Soil temperature at TS74__, probe no. 02 at depth 20 cm, discontinued 1990
SOIT7502
Soil temperature at TS75__, probe no. 02 at depth 20 cm, discontinued 1990
SOIT7602
Soil temperature at TS76__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT7702
Soil temperature at TS77__, probe no. 02 at depth 20 cm, discontinued 1975
RELR8601
Relative humidity at RS86__, probe no. 01 at height 235 cm, discontinued 2017
RELR8901
Relative humidity at RS89__, probe no. 01 at height 285 cm, discontinued 2017
AIRR0202
Air temperature at RS02__, probe no. 02 at height 225 cm
AIRR0203
Air temperature at RS02__, probe no. 03 at height 225 cm
AIRR0402
Air temperature at RS04__, probe no. 02 at height 325 cm
AIRR0403
Air temperature at RS04__, probe no. 03 at height 325 cm
AIRR1202
Air temperature at RS12__, probe no. 02 at height 190 cm
AIRR1203
Air temperature at RS12__, probe no. 03 at height 190 cm
AIRR2002
Air temperature at RS20__, probe no. 02 at height 220 cm
AIRR2003
Air temperature at RS20__, probe no. 03 at height 220 cm
AIRR2602
Air temperature at RS26__, probe no. 02 at height 200 cm
AIRR2603
Air temperature at RS26__, probe no. 03 at height 200 cm
AIRR0502
Air temperature at RS05__, probe no. 02 at height 200 cm
AIRR0503
Air temperature at RS05__, probe no. 03 at height 200 cm
AIRR1002
Air temperature at RS10__, probe no. 02 at height 200 cm
AIRR1003
Air temperature at RS10__, probe no. 03 at height 200 cm
AIRR3802
Air temperature at RS38__, probe no. 02 at height 100 cm
AIRR3803
Air temperature at RS38__, probe no. 03 at height 100 cm
AIRR8602
Air temperature at RS86__, probe no. 02 at height 235 cm
AIRR8603
Air temperature at RS86__, probe no. 03 at height 235 cm
AIRR8902
Air temperature at RS89__, probe no. 02 at height 285 cm
AIRR8903
Air temperature at RS89__, probe no. 03 at height 285 cm

DATE_TIME - datetime (dateTime)

ID: MS00511.DATE_TIME

Date and time (PST) of probe reading

Type system: Microsoft SQL Server 2019

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

AIRTEMP_MEAN - numeric(5,1) (interval)

ID: MS00511.AIRTEMP_MEAN

Mean air temperature over the last interval (e.g., 5 minutes)

Type system: Microsoft SQL Server 2019

Unit: degrees Celsius

Precision: 0.100000

Numeric domain: type=real, min=-15.8000 (exclusive=false), max=44.1000 (exclusive=false)

AIRTEMP_MEAN_FLAG - char(1) (nominal)

ID: MS00511.AIRTEMP_MEAN_FLAG

Mean air temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (7)

B
Sensor buried in snow; value represents snow temperature
E
Estimated value
M
Missing value
Q
Questionable value
S
Daily value based on sunrise to sunrise (not midnight to midnight)
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: MS00511.EVENT_CODE

Type of comment that exists independently for 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

Type system: Microsoft SQL Server 2019

Code definitions (8)

CALIBR
Associated with the inspection or replacement of sensors for calibration
INSREM
Sensor is installed or removed
LOGGER
Change in data logger, data logger program, or wiring
MAINTE
A maintenance event has occurred
METHOD
Change in data collection method
NA
No event is reported (not applicable)
QUALTY
Event may directly affect data quality
WEATHR
A weather event has occurred that may affect reading

MS00512 - Relative Humidity (Finest resolution, e.g., hourly, 5 minute)

Object name: MS00512_v5.csv

Records: 232226

Attributes: 11

Temporal coverage: 2004-07-19 to 2017-10-24

File size: 18178539 byte

Checksum (MD5): 431138977152bc9465b8bf6a24838ec8

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

Constraints (2)

primaryKey: PRIMARY
MS00512.DATE_TIME, MS00512.PROBE_CODE, MS00512.SITECODE
notNullConstraint: NOTNULL
MS00512.DATE_TIME, MS00512.PROBE_CODE, MS00512.DBCODE, MS00512.SITECODE, MS00512.ENTITY, MS00512.RELHUM_MEAN_FLAG, MS00512.QC_LEVEL, MS00512.EVENT_CODE, MS00512.RELHUM_METHOD, MS00512.HEIGHT

Attributes (11)

DBCODE - char(5) (nominal)

ID: MS00512.DBCODE

FSDB database code

Type system: Microsoft SQL Server 2019

Code definitions (1)

MS005
FSDB Database Code

ENTITY - numeric(2,0) (interval)

ID: MS00512.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SITECODE - char(6) (nominal)

ID: MS00512.SITECODE

Site code for the meteorological measurement station

Type system: Microsoft SQL Server 2019

Code definitions (37)

RS01__
Reference Stand RS01 air/soil temperature site
RS02__
Reference Stand RS02 air/soil temperature site
RS03__
Reference Stand RS03 air/soil temperature site
RS04__
Reference Stand RS04 air/soil temperature site
RS05__
Reference Stand RS05 air/soil temperature site
RS06__
Reference Stand RS06 air/soil temperature site
RS07__
Reference Stand RS07 air/soil temperature site
RS08__
Reference Stand RS08 air/soil temperature site
RS09__
Reference Stand RS09 air/soil temperature site
RS10__
Reference Stand RS10 air/soil temperature site
RS11__
Reference Stand RS11 air/soil temperature site
RS12__
Reference Stand RS12 air/soil temperature site
RS13__
Reference Stand RS13 air/soil temperature site
RS14__
Reference Stand RS14 air/soil temperature site
RS15__
Reference Stand RS15 air/soil temperature site
RS16__
Reference Stand RS16 air/soil temperature site
RS17__
Reference Stand RS17 air/soil temperature site
RS18__
Reference Stand RS18 air/soil temperature site
RS19__
Reference Stand RS19 air/soil temperature site
RS20__
Reference Stand RS20 air/soil temperature site
RS24__
Reference Stand RS24 air/soil temperature site
RS26__
Reference Stand RS26 air/soil temperature site
TS31__
Thermograph site 31
TS32__
Thermograph site 32
TS33__
Thermograph site 33
TS34__
Thermograph site 34
TS35__
Thermograph site 35
TS36__
Thermograph site 36
TS37__
Thermograph site 37
RS38__
Reference Stand RS38 air/soil temperature site (formerly TS38__)
TS74__
Thermograph site 74
TS75__
Thermograph site 75
TS76__
Thermograph site 76
TS77__
Thermograph site 77
RS86__
Reference Stand RS86 air/soil temperature and relative humidity site
RS89__
Reference Stand RS89 air/soil temperature and relative humidity site
RS13O_
Reference Stand RS13 Open canopy air/soil temperature site

RELHUM_METHOD - char(6) (nominal)

ID: MS00512.RELHUM_METHOD

An indication of the the general methodology and instrumentation used to collect this relative humidity data

Type system: Microsoft SQL Server 2019

Code definitions (4)

REL018
Relative humidity is sampled by a Campbell Scientific model HMP45C probe housed in a R.M. Young Gill radiation shield at 235 cm height; mean relative humidity is output every 60 minutes
REL019
Relative humidity is sampled by a Campbell Scientific model HMP45C probe housed in a R.M. Young Gill radiation shield at 285 cm height; mean relative humidity is output every 60 minutes
REL118
Mean daily, max and min relative humidity is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model HMP45C probe housed in a R.M. Young Gill radiation shield at 235 cm height (See Method REL018)
REL119
Mean daily, max and min relative humidity is calculated by the Campbell Scientific datalogger based on 15 second samples from a Campbell Scientific model HMP45C probe housed in a R.M. Young Gill radiation shield at 285 cm height (See Method REL019)

HEIGHT - numeric(4,0) (ratio)

ID: MS00512.HEIGHT

Height of sensor from ground surface

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

Numeric domain: type=whole, min=235.0000 (exclusive=false), max=285.0000 (exclusive=false)

QC_LEVEL - char(2) (nominal)

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

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
1D
Data is published and unlikely to change - data is derived or aggregated from published data of level 1A
1P
Data is provisional and subject to revision - preliminary quality checks have been performed
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

PROBE_CODE - char(8) (nominal)

ID: MS00512.PROBE_CODE

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

Type system: Microsoft SQL Server 2019

Code definitions (120)

AIRO1301
Air temperature at RS13O_, probe no. 01 at height 435 cm, discontinued 2003
AIRR0101
Air temperature at RS01__, probe no. 01 at height 100 cm, discontinued 1995
AIRR0201
Air temperature at RS02__, probe no. 01 at height 225 cm, discontinued 2015
AIRR0301
Air temperature at RS03__, probe no. 01 at height 235 cm, discontinued 1995
AIRR0401
Air temperature at RS04__, probe no. 01 at height 325 cm, discontinued 2015
AIRR0501
Air temperature at RS05__, probe no. 01 at height 200 cm, discontinued 2017
AIRR0601
Air temperature at RS06__, probe no. 01 at height 100 cm, discontinued 1975
AIRR0701
Air temperature at RS07__, probe no. 01 at height 100 cm, discontinued 1995
AIRR0801
Air temperature at RS08__, probe no. 01 at height 100 cm, discontinued 1973
AIRR0901
Air temperature at RS09__, probe no. 01 at height 100 cm, discontinued 1975
AIRR1001
Air temperature at RS10__, probe no. 01 at height 200 cm, discontinued 2017
AIRR1101
Air temperature at RS11__, probe no. 01 at height 100 cm, discontinued 1977
AIRR1201
Air temperature at RS12__, probe no. 01 at height 190 cm, discontinued 2015
AIRR1301
Air temperature at RS13__, probe no. 01 at height 275 cm, discontinued 2003
AIRR1401
Air temperature at RS14__, probe no. 01 at height 285 cm, discontinued 2003
AIRR1501
Air temperature at RS15__, probe no. 01 at height 180 cm, discontinued 1994
AIRR1601
Air temperature at RS16__, probe no. 01 at height 180 cm, discontinued 1994
AIRR1701
Air temperature at RS17__, probe no. 01 at height 60 cm, discontinued 1995
AIRR1801
Air temperature at RS18__, probe no. 01 at height 100 cm, discontinued 1974
AIRR1901
Air temperature at RS19__, probe no. 01 at height 100 cm, discontinued 1973
AIRR2001
Air temperature at RS20__, probe no. 01 at height 220 cm, discontinued 2015
AIRR2401
Air temperature at RS24__, probe no. 01 at height 220 cm, discontinued 2004
AIRR2601
Air temperature at RS26__, probe no. 01 at height 200 cm, discontinued 2015
AIRR8601
Air temperature at RS86__, probe no. 01 at height 235 cm, discontinued 2017
AIRR8901
Air temperature at RS89__, probe no. 01 at height 285 cm, discontinued 2017
AIRT3101
Air temperature at TS31__, probe no. 01 at height 100 cm, discontinued 1976
AIRT3201
Air temperature at TS32__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3301
Air temperature at TS33__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3401
Air temperature at TS34__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3501
Air temperature at TS35__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3601
Air temperature at TS36__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3701
Air temperature at TS37__, probe no. 01 at height 100 cm, discontinued 1976
AIRR3801
Air temperature at RS38__, probe no. 01 at height 100 cm, discontinued 2017
AIRT7401
Air temperature at TS74__, probe no. 01 at height 100 cm, discontinued 1990
AIRT7501
Air temperature at TS75__, probe no. 01 at height 100 cm, discontinued 1990
AIRT7601
Air temperature at TS76__, probe no. 01 at height 100 cm, discontinued 1975
AIRT7701
Air temperature at TS77__, probe no. 01 at height 100 cm, discontinued 1975
SOIO1302
Soil temperature at RS13O_, probe no. 02 at depth 20 cm, discontinued 2003
SOIR0102
Soil temperature at RS01__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR0201
Soil temperature at RS02__, probe no. 01 at depth 10 cm
SOIR0202
Soil temperature at RS02__, probe no. 02 at depth 20 cm
SOIR0203
Soil temperature at RS02__, probe no. 03 at depth 30 cm
SOIR0302
Soil temperature at RS03__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR0401
Soil temperature at RS04__, probe no. 01 at depth 10 cm
SOIR0402
Soil temperature at RS04__, probe no. 02 at depth 20 cm
SOIR0403
Soil temperature at RS04__, probe no. 03 at depth 30 cm
SOIR0501
Soil temperature at RS05__, probe no. 01 at depth 10 cm
SOIR0502
Soil temperature at RS05__, probe no. 02 at depth 20 cm
SOIR0503
Soil temperature at RS05__, probe no. 03 at depth 30 cm
SOIR0602
Soil temperature at RS06__, probe no. 02 at depth 20 cm, discontinued 1975
SOIR0702
Soil temperature at RS07__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR0802
Soil temperature at RS08__, probe no. 02 at depth 20 cm, discontinued 1973
SOIR0902
Soil temperature at RS09__, probe no. 02 at depth 20 cm, discontinued 1975
SOIR1001
Soil temperature at RS10__, probe no. 01 at depth 10 cm
SOIR1002
Soil temperature at RS10__, probe no. 02 at depth 20 cm
SOIR1003
Soil temperature at RS10__, probe no. 03 at depth 30 cm
SOIR1102
Soil temperature at RS11__, probe no. 02 at depth 20 cm, discontinued 1977
SOIR1201
Soil temperature at RS12__, probe no. 01 at depth 10 cm
SOIR1202
Soil temperature at RS12__, probe no. 02 at depth 20 cm
SOIR1203
Soil temperature at RS12__, probe no. 03 at depth 30 cm
SOIR1302
Soil temperature at RS13__, probe no. 02 at depth 20 cm, discontinued 2003
SOIR1401
Soil temperature at RS14__, probe no. 01 at depth 10 cm, discontinued 2003
SOIR1402
Soil temperature at RS14__, probe no. 02 at depth 20 cm, discontinued 2003
SOIR1403
Soil temperature at RS14__, probe no. 03 at depth 30 cm, discontinued 2003
SOIR1502
Soil temperature at RS15__, probe no. 02 at depth 20 cm, discontinued 1994
SOIR1602
Soil temperature at RS16__, probe no. 02 at depth 20 cm, discontinued 1994
SOIR1702
Soil temperature at RS17__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR1802
Soil temperature at RS18__, probe no. 02 at depth 20 cm, discontinued 1974
SOIR1902
Soil temperature at RS19__, probe no. 02 at depth 20 cm, discontinued 1973
SOIR2001
Soil temperature at RS20__, probe no. 01 at depth 10 cm
SOIR2002
Soil temperature at RS20__, probe no. 02 at depth 20 cm
SOIR2003
Soil temperature at RS20__, probe no. 03 at depth 30 cm
SOIR2401
Soil temperature at RS24__, probe no. 01 at depth 10 cm, discontinued 2004
SOIR2402
Soil temperature at RS24__, probe no. 02 at depth 20 cm, discontinued 2004
SOIR2403
Soil temperature at RS24__, probe no. 03 at depth 30 cm, discontinued 2004
SOIR2601
Soil temperature at RS26__, probe no. 01 at depth 10 cm
SOIR2602
Soil temperature at RS26__, probe no. 02 at depth 20 cm
SOIR2603
Soil temperature at RS26__, probe no. 03 at depth 30 cm
SOIR8601
Soil temperature at RS86__, probe no. 01 at depth 10 cm
SOIR8602
Soil temperature at RS86__, probe no. 02 at depth 20 cm
SOIR8603
Soil temperature at RS86__, probe no. 03 at depth 30 cm
SOIR8901
Soil temperature at RS89__, probe no. 01 at depth 10 cm
SOIR8902
Soil temperature at RS89__, probe no. 02 at depth 20 cm
SOIR8903
Soil temperature at RS89__, probe no. 03 at depth 30 cm
SOIT3102
Soil temperature at TS31__, probe no. 02 at depth 20 cm, discontinued 1976
SOIT3202
Soil temperature at TS32__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3302
Soil temperature at TS33__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3402
Soil temperature at TS34__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3502
Soil temperature at TS35__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3602
Soil temperature at TS36__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3702
Soil temperature at TS37__, probe no. 02 at depth 20 cm, discontinued 1976
SOIR3801
Soil temperature at RS38__, probe no. 01 at depth 10 cm
SOIR3802
Soil temperature at RS38__, probe no. 02 at depth 20 cm
SOIR3803
Soil temperature at RS38__, probe no. 03 at depth 30 cm
SOIT7402
Soil temperature at TS74__, probe no. 02 at depth 20 cm, discontinued 1990
SOIT7502
Soil temperature at TS75__, probe no. 02 at depth 20 cm, discontinued 1990
SOIT7602
Soil temperature at TS76__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT7702
Soil temperature at TS77__, probe no. 02 at depth 20 cm, discontinued 1975
RELR8601
Relative humidity at RS86__, probe no. 01 at height 235 cm, discontinued 2017
RELR8901
Relative humidity at RS89__, probe no. 01 at height 285 cm, discontinued 2017
AIRR0202
Air temperature at RS02__, probe no. 02 at height 225 cm
AIRR0203
Air temperature at RS02__, probe no. 03 at height 225 cm
AIRR0402
Air temperature at RS04__, probe no. 02 at height 325 cm
AIRR0403
Air temperature at RS04__, probe no. 03 at height 325 cm
AIRR1202
Air temperature at RS12__, probe no. 02 at height 190 cm
AIRR1203
Air temperature at RS12__, probe no. 03 at height 190 cm
AIRR2002
Air temperature at RS20__, probe no. 02 at height 220 cm
AIRR2003
Air temperature at RS20__, probe no. 03 at height 220 cm
AIRR2602
Air temperature at RS26__, probe no. 02 at height 200 cm
AIRR2603
Air temperature at RS26__, probe no. 03 at height 200 cm
AIRR0502
Air temperature at RS05__, probe no. 02 at height 200 cm
AIRR0503
Air temperature at RS05__, probe no. 03 at height 200 cm
AIRR1002
Air temperature at RS10__, probe no. 02 at height 200 cm
AIRR1003
Air temperature at RS10__, probe no. 03 at height 200 cm
AIRR3802
Air temperature at RS38__, probe no. 02 at height 100 cm
AIRR3803
Air temperature at RS38__, probe no. 03 at height 100 cm
AIRR8602
Air temperature at RS86__, probe no. 02 at height 235 cm
AIRR8603
Air temperature at RS86__, probe no. 03 at height 235 cm
AIRR8902
Air temperature at RS89__, probe no. 02 at height 285 cm
AIRR8903
Air temperature at RS89__, probe no. 03 at height 285 cm

DATE_TIME - datetime (dateTime)

ID: MS00512.DATE_TIME

Date and time (PST) of probe reading

Type system: Microsoft SQL Server 2019

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

RELHUM_MEAN - numeric(5,1) (ratio)

ID: MS00512.RELHUM_MEAN

Mean relative humidity over the last interval (e.g., 5 minutes)

Type system: Microsoft SQL Server 2019

Unit: percent

Precision: 2.000000

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

RELHUM_MEAN_FLAG - char(1) (nominal)

ID: MS00512.RELHUM_MEAN_FLAG

Mean relative humidity flag

Type system: Microsoft SQL Server 2019

Code definitions (5)

A
Accepted value has passed all QC tests applied as represented by the quality level
B
Sensor buried in snow
E
Estimated value
M
Missing value
Q
Questionable value

EVENT_CODE - char(6) (nominal)

ID: MS00512.EVENT_CODE

Type of comment that exists independently for 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

Type system: Microsoft SQL Server 2019

Code definitions (8)

CALIBR
Associated with the inspection or replacement of sensors for calibration
INSREM
Sensor is installed or removed
LOGGER
Change in data logger, data logger program, or wiring
MAINTE
A maintenance event has occurred
METHOD
Change in data collection method
NA
No event is reported (not applicable)
QUALTY
Event may directly affect data quality
WEATHR
A weather event has occurred that may affect reading

MS00521 - Soil temperature (Daily)

Object name: MS00521_v5.csv

Records: 502639

Attributes: 17

Temporal coverage: 1970-04-13 to 2019-09-30

File size: 43581683 byte

Checksum (MD5): d4c303ce03fc86a05dbd2b541126c899

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

Constraints (2)

primaryKey: PRIMARY
MS00521.DATE, MS00521.PROBE_CODE, MS00521.SITECODE
notNullConstraint: NOTNULL
MS00521.DATE, MS00521.SOILTEMP_MEAN_FLAG, MS00521.SOILTEMP_MAX_FLAG, MS00521.SOILTEMP_MIN_FLAG, MS00521.PROBE_CODE, MS00521.DBCODE, MS00521.SITECODE, MS00521.ENTITY, MS00521.DEPTH, MS00521.QC_LEVEL, MS00521.EVENT_CODE, MS00521.SOILTEMP_METHOD

Attributes (17)

DBCODE - char(5) (nominal)

ID: MS00521.DBCODE

FSDB database code

Type system: Microsoft SQL Server 2019

Code definitions (1)

MS005
FSDB Database Code

ENTITY - numeric(2,0) (interval)

ID: MS00521.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: MS00521.SITECODE

Site code for the meteorological measurement station

Type system: Microsoft SQL Server 2019

Code definitions (37)

RS01__
Reference Stand RS01 air/soil temperature site
RS02__
Reference Stand RS02 air/soil temperature site
RS03__
Reference Stand RS03 air/soil temperature site
RS04__
Reference Stand RS04 air/soil temperature site
RS05__
Reference Stand RS05 air/soil temperature site
RS06__
Reference Stand RS06 air/soil temperature site
RS07__
Reference Stand RS07 air/soil temperature site
RS08__
Reference Stand RS08 air/soil temperature site
RS09__
Reference Stand RS09 air/soil temperature site
RS10__
Reference Stand RS10 air/soil temperature site
RS11__
Reference Stand RS11 air/soil temperature site
RS12__
Reference Stand RS12 air/soil temperature site
RS13__
Reference Stand RS13 air/soil temperature site
RS14__
Reference Stand RS14 air/soil temperature site
RS15__
Reference Stand RS15 air/soil temperature site
RS16__
Reference Stand RS16 air/soil temperature site
RS17__
Reference Stand RS17 air/soil temperature site
RS18__
Reference Stand RS18 air/soil temperature site
RS19__
Reference Stand RS19 air/soil temperature site
RS20__
Reference Stand RS20 air/soil temperature site
RS24__
Reference Stand RS24 air/soil temperature site
RS26__
Reference Stand RS26 air/soil temperature site
TS31__
Thermograph site 31
TS32__
Thermograph site 32
TS33__
Thermograph site 33
TS34__
Thermograph site 34
TS35__
Thermograph site 35
TS36__
Thermograph site 36
TS37__
Thermograph site 37
RS38__
Reference Stand RS38 air/soil temperature site (formerly TS38__)
TS74__
Thermograph site 74
TS75__
Thermograph site 75
TS76__
Thermograph site 76
TS77__
Thermograph site 77
RS86__
Reference Stand RS86 air/soil temperature and relative humidity site
RS89__
Reference Stand RS89 air/soil temperature and relative humidity site
RS13O_
Reference Stand RS13 Open canopy air/soil temperature site

SOILTEMP_METHOD - char(6) (nominal)

ID: MS00521.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 (29)

SOI115
Mean daily soil temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 20 cm depth
SOI116
Mean daily (sunrise to sunrise) soil temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 20 cm depth
SOI023
Soil temperature is sampled by a Campbell Scientific model 107 thermistor at 10 cm depth; mean temperature is output every 6 hours
SOI024
Soil temperature is sampled by a Campbell Scientific model 107 thermistor at 20 cm depth; mean temperature is output every 6 hours
SOI025
Soil temperature is sampled by a Campbell Scientific model 107 thermistor at 30 cm depth; mean temperature is output every 6 hours
SOI020
Soil temperature is sampled by type T thermocouple soldered from thermocouple wire at 10 cm depth with a Campbell Scientific data logger; mean temperature is output every 6 hours
SOI021
Soil temperature is sampled by type T thermocouple soldered from thermocouple wire at 20 cm depth with a Campbell Scientific data logger; mean temperature is output every 6 hours
SOI022
Soil temperature is sampled by type T thermocouple soldered from thermocouple wire at 30 cm depth with a Campbell Scientific data logger; mean temperature is output every 6 hours
SOI117
Mean daily, max and min soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple soldered from thermocouple wire at 10 cm depth (Daily output only)
SOI118
Mean daily, max and min soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple soldered from thermocouple wire at 20 cm depth (Daily output only)
SOI119
Mean daily, max and min soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple soldered from thermocouple wire at 30 cm depth (Daily output only)
SOI026
Soil temperature is sampled by type T thermocouple soldered from thermocouple wire at 10 cm depth with a Campbell Scientific data logger; mean temperature is output every 5 minutes
SOI027
Soil temperature is sampled by type T thermocouple soldered from thermocouple wire at 20 cm depth with a Campbell Scientific data logger; mean temperature is output every 5 minutes
SOI028
Soil temperature is sampled by type T thermocouple soldered from thermocouple wire at 30 cm depth with a Campbell Scientific data logger; mean temperature is output every 5 minutes
SOI029
Soil temperature is sampled by a Campbell Scientific model 107 thermistor at 10 cm depth; mean temperature is output every 5 minutes
SOI030
Soil temperature is sampled by a Campbell Scientific model 107 thermistor at 20 cm depth; mean temperature is output every 5 minutes
SOI031
Soil temperature is sampled by a Campbell Scientific model 107 thermistor at 30 cm depth; mean temperature is output every 5 minutes
SOI120
Mean daily, max and min soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple soldered from thermocouple wire at 10 cm depth (See Method SOI020)
SOI121
Mean daily, max and min soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple soldered from thermocouple wire at 20 cm depth (See Method SOI021)
SOI122
Mean daily, max and min soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple soldered from thermocouple wire at 30 cm depth (See Method SOI022)
SOI123
Mean daily, max and min soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is Campbell Scientific model 107 thermistor at 10 cm depth (See Method SOI023)
SOI124
Mean daily, max and min soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is Campbell Scientific model 107 thermistor at 20 cm depth (See Method SOI024)
SOI125
Mean daily, max and min soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is Campbell Scientific model 107 thermistor at 30 cm depth (See Method SOI025)
SOI126
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. Type T thermocouple wire at 10 cm depth (See Method SOI026)
SOI127
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. Type T thermocouple wire at 20 cm depth (See Method SOI027)
SOI128
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. Type T thermocouple wire at 30 cm depth (See Method SOI028)
SOI129
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. Campbell Scientific model 107 thermistor at 10 cm depth (See Method SOI029)
SOI130
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. Campbell Scientific model 107 thermistor at 20 cm depth (See Method SOI030)
SOI131
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. Campbell Scientific model 107 thermistor at 30 cm depth (See Method SOI031)

DEPTH - numeric(4,0) (ratio)

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

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
1D
Data is published and unlikely to change - data is derived or aggregated from published data of level 1A
1P
Data is provisional and subject to revision - preliminary quality checks have been performed
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

PROBE_CODE - char(8) (nominal)

ID: MS00521.PROBE_CODE

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

Type system: Microsoft SQL Server 2019

Code definitions (120)

AIRO1301
Air temperature at RS13O_, probe no. 01 at height 435 cm, discontinued 2003
AIRR0101
Air temperature at RS01__, probe no. 01 at height 100 cm, discontinued 1995
AIRR0201
Air temperature at RS02__, probe no. 01 at height 225 cm, discontinued 2015
AIRR0301
Air temperature at RS03__, probe no. 01 at height 235 cm, discontinued 1995
AIRR0401
Air temperature at RS04__, probe no. 01 at height 325 cm, discontinued 2015
AIRR0501
Air temperature at RS05__, probe no. 01 at height 200 cm, discontinued 2017
AIRR0601
Air temperature at RS06__, probe no. 01 at height 100 cm, discontinued 1975
AIRR0701
Air temperature at RS07__, probe no. 01 at height 100 cm, discontinued 1995
AIRR0801
Air temperature at RS08__, probe no. 01 at height 100 cm, discontinued 1973
AIRR0901
Air temperature at RS09__, probe no. 01 at height 100 cm, discontinued 1975
AIRR1001
Air temperature at RS10__, probe no. 01 at height 200 cm, discontinued 2017
AIRR1101
Air temperature at RS11__, probe no. 01 at height 100 cm, discontinued 1977
AIRR1201
Air temperature at RS12__, probe no. 01 at height 190 cm, discontinued 2015
AIRR1301
Air temperature at RS13__, probe no. 01 at height 275 cm, discontinued 2003
AIRR1401
Air temperature at RS14__, probe no. 01 at height 285 cm, discontinued 2003
AIRR1501
Air temperature at RS15__, probe no. 01 at height 180 cm, discontinued 1994
AIRR1601
Air temperature at RS16__, probe no. 01 at height 180 cm, discontinued 1994
AIRR1701
Air temperature at RS17__, probe no. 01 at height 60 cm, discontinued 1995
AIRR1801
Air temperature at RS18__, probe no. 01 at height 100 cm, discontinued 1974
AIRR1901
Air temperature at RS19__, probe no. 01 at height 100 cm, discontinued 1973
AIRR2001
Air temperature at RS20__, probe no. 01 at height 220 cm, discontinued 2015
AIRR2401
Air temperature at RS24__, probe no. 01 at height 220 cm, discontinued 2004
AIRR2601
Air temperature at RS26__, probe no. 01 at height 200 cm, discontinued 2015
AIRR8601
Air temperature at RS86__, probe no. 01 at height 235 cm, discontinued 2017
AIRR8901
Air temperature at RS89__, probe no. 01 at height 285 cm, discontinued 2017
AIRT3101
Air temperature at TS31__, probe no. 01 at height 100 cm, discontinued 1976
AIRT3201
Air temperature at TS32__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3301
Air temperature at TS33__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3401
Air temperature at TS34__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3501
Air temperature at TS35__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3601
Air temperature at TS36__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3701
Air temperature at TS37__, probe no. 01 at height 100 cm, discontinued 1976
AIRR3801
Air temperature at RS38__, probe no. 01 at height 100 cm, discontinued 2017
AIRT7401
Air temperature at TS74__, probe no. 01 at height 100 cm, discontinued 1990
AIRT7501
Air temperature at TS75__, probe no. 01 at height 100 cm, discontinued 1990
AIRT7601
Air temperature at TS76__, probe no. 01 at height 100 cm, discontinued 1975
AIRT7701
Air temperature at TS77__, probe no. 01 at height 100 cm, discontinued 1975
SOIO1302
Soil temperature at RS13O_, probe no. 02 at depth 20 cm, discontinued 2003
SOIR0102
Soil temperature at RS01__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR0201
Soil temperature at RS02__, probe no. 01 at depth 10 cm
SOIR0202
Soil temperature at RS02__, probe no. 02 at depth 20 cm
SOIR0203
Soil temperature at RS02__, probe no. 03 at depth 30 cm
SOIR0302
Soil temperature at RS03__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR0401
Soil temperature at RS04__, probe no. 01 at depth 10 cm
SOIR0402
Soil temperature at RS04__, probe no. 02 at depth 20 cm
SOIR0403
Soil temperature at RS04__, probe no. 03 at depth 30 cm
SOIR0501
Soil temperature at RS05__, probe no. 01 at depth 10 cm
SOIR0502
Soil temperature at RS05__, probe no. 02 at depth 20 cm
SOIR0503
Soil temperature at RS05__, probe no. 03 at depth 30 cm
SOIR0602
Soil temperature at RS06__, probe no. 02 at depth 20 cm, discontinued 1975
SOIR0702
Soil temperature at RS07__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR0802
Soil temperature at RS08__, probe no. 02 at depth 20 cm, discontinued 1973
SOIR0902
Soil temperature at RS09__, probe no. 02 at depth 20 cm, discontinued 1975
SOIR1001
Soil temperature at RS10__, probe no. 01 at depth 10 cm
SOIR1002
Soil temperature at RS10__, probe no. 02 at depth 20 cm
SOIR1003
Soil temperature at RS10__, probe no. 03 at depth 30 cm
SOIR1102
Soil temperature at RS11__, probe no. 02 at depth 20 cm, discontinued 1977
SOIR1201
Soil temperature at RS12__, probe no. 01 at depth 10 cm
SOIR1202
Soil temperature at RS12__, probe no. 02 at depth 20 cm
SOIR1203
Soil temperature at RS12__, probe no. 03 at depth 30 cm
SOIR1302
Soil temperature at RS13__, probe no. 02 at depth 20 cm, discontinued 2003
SOIR1401
Soil temperature at RS14__, probe no. 01 at depth 10 cm, discontinued 2003
SOIR1402
Soil temperature at RS14__, probe no. 02 at depth 20 cm, discontinued 2003
SOIR1403
Soil temperature at RS14__, probe no. 03 at depth 30 cm, discontinued 2003
SOIR1502
Soil temperature at RS15__, probe no. 02 at depth 20 cm, discontinued 1994
SOIR1602
Soil temperature at RS16__, probe no. 02 at depth 20 cm, discontinued 1994
SOIR1702
Soil temperature at RS17__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR1802
Soil temperature at RS18__, probe no. 02 at depth 20 cm, discontinued 1974
SOIR1902
Soil temperature at RS19__, probe no. 02 at depth 20 cm, discontinued 1973
SOIR2001
Soil temperature at RS20__, probe no. 01 at depth 10 cm
SOIR2002
Soil temperature at RS20__, probe no. 02 at depth 20 cm
SOIR2003
Soil temperature at RS20__, probe no. 03 at depth 30 cm
SOIR2401
Soil temperature at RS24__, probe no. 01 at depth 10 cm, discontinued 2004
SOIR2402
Soil temperature at RS24__, probe no. 02 at depth 20 cm, discontinued 2004
SOIR2403
Soil temperature at RS24__, probe no. 03 at depth 30 cm, discontinued 2004
SOIR2601
Soil temperature at RS26__, probe no. 01 at depth 10 cm
SOIR2602
Soil temperature at RS26__, probe no. 02 at depth 20 cm
SOIR2603
Soil temperature at RS26__, probe no. 03 at depth 30 cm
SOIR8601
Soil temperature at RS86__, probe no. 01 at depth 10 cm
SOIR8602
Soil temperature at RS86__, probe no. 02 at depth 20 cm
SOIR8603
Soil temperature at RS86__, probe no. 03 at depth 30 cm
SOIR8901
Soil temperature at RS89__, probe no. 01 at depth 10 cm
SOIR8902
Soil temperature at RS89__, probe no. 02 at depth 20 cm
SOIR8903
Soil temperature at RS89__, probe no. 03 at depth 30 cm
SOIT3102
Soil temperature at TS31__, probe no. 02 at depth 20 cm, discontinued 1976
SOIT3202
Soil temperature at TS32__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3302
Soil temperature at TS33__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3402
Soil temperature at TS34__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3502
Soil temperature at TS35__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3602
Soil temperature at TS36__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3702
Soil temperature at TS37__, probe no. 02 at depth 20 cm, discontinued 1976
SOIR3801
Soil temperature at RS38__, probe no. 01 at depth 10 cm
SOIR3802
Soil temperature at RS38__, probe no. 02 at depth 20 cm
SOIR3803
Soil temperature at RS38__, probe no. 03 at depth 30 cm
SOIT7402
Soil temperature at TS74__, probe no. 02 at depth 20 cm, discontinued 1990
SOIT7502
Soil temperature at TS75__, probe no. 02 at depth 20 cm, discontinued 1990
SOIT7602
Soil temperature at TS76__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT7702
Soil temperature at TS77__, probe no. 02 at depth 20 cm, discontinued 1975
RELR8601
Relative humidity at RS86__, probe no. 01 at height 235 cm, discontinued 2017
RELR8901
Relative humidity at RS89__, probe no. 01 at height 285 cm, discontinued 2017
AIRR0202
Air temperature at RS02__, probe no. 02 at height 225 cm
AIRR0203
Air temperature at RS02__, probe no. 03 at height 225 cm
AIRR0402
Air temperature at RS04__, probe no. 02 at height 325 cm
AIRR0403
Air temperature at RS04__, probe no. 03 at height 325 cm
AIRR1202
Air temperature at RS12__, probe no. 02 at height 190 cm
AIRR1203
Air temperature at RS12__, probe no. 03 at height 190 cm
AIRR2002
Air temperature at RS20__, probe no. 02 at height 220 cm
AIRR2003
Air temperature at RS20__, probe no. 03 at height 220 cm
AIRR2602
Air temperature at RS26__, probe no. 02 at height 200 cm
AIRR2603
Air temperature at RS26__, probe no. 03 at height 200 cm
AIRR0502
Air temperature at RS05__, probe no. 02 at height 200 cm
AIRR0503
Air temperature at RS05__, probe no. 03 at height 200 cm
AIRR1002
Air temperature at RS10__, probe no. 02 at height 200 cm
AIRR1003
Air temperature at RS10__, probe no. 03 at height 200 cm
AIRR3802
Air temperature at RS38__, probe no. 02 at height 100 cm
AIRR3803
Air temperature at RS38__, probe no. 03 at height 100 cm
AIRR8602
Air temperature at RS86__, probe no. 02 at height 235 cm
AIRR8603
Air temperature at RS86__, probe no. 03 at height 235 cm
AIRR8902
Air temperature at RS89__, probe no. 02 at height 285 cm
AIRR8903
Air temperature at RS89__, probe no. 03 at height 285 cm

DATE - datetime (dateTime)

ID: MS00521.DATE

Date of measurement

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

SOILTEMP_MEAN_DAY - numeric(5,1) (interval)

ID: MS00521.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=-2.5000 (exclusive=false), max=24.4000 (exclusive=false)

SOILTEMP_MEAN_FLAG - char(1) (nominal)

ID: MS00521.SOILTEMP_MEAN_FLAG

Mean soil temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (6)

E
Estimated value
M
Missing value
Q
Questionable value
S
Daily value based on sunrise to sunrise (not midnight to midnight)
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: MS00521.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=-2.5000 (exclusive=false), max=34.9000 (exclusive=false)

SOILTEMP_MAX_FLAG - char(1) (nominal)

ID: MS00521.SOILTEMP_MAX_FLAG

Maximum soil temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (4)

E
Estimated value
M
Missing value
Q
Questionable value
A
Accepted value has passed all QC tests applied as represented by the quality level

SOILTEMP_MAXTIME - char(4) (ordinal)

ID: MS00521.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: MS00521.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.7000 (exclusive=false), max=22.7000 (exclusive=false)

SOILTEMP_MIN_FLAG - char(1) (nominal)

ID: MS00521.SOILTEMP_MIN_FLAG

Minimum soil temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (4)

E
Estimated value
M
Missing value
Q
Questionable value
A
Accepted value has passed all QC tests applied as represented by the quality level

SOILTEMP_MINTIME - char(4) (ordinal)

ID: MS00521.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: MS00521.EVENT_CODE

Type of comment that exists independently for 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

Type system: Microsoft SQL Server 2019

Code definitions (8)

CALIBR
Associated with the inspection or replacement of sensors for calibration
INSREM
Sensor is installed or removed
LOGGER
Change in data logger, data logger program, or wiring
MAINTE
A maintenance event has occurred
METHOD
Change in data collection method
NA
No event is reported (not applicable)
QUALTY
Event may directly affect data quality
WEATHR
A weather event has occurred that may affect reading

MS00531 - Soil temperature (Finest resolution, e.g., 6-hourly, 5 minute)

Object name: MS00531_v8.txt

Records: 30511776

Attributes: 11

Temporal coverage: 1998-03-13 to 2024-10-01

File size: 2327473245 byte

Checksum (MD5): 67dece8984cedfaf378b80f49b5661c6

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

Constraints (2)

primaryKey: PRIMARY
MS00531.DATE_TIME, MS00531.PROBE_CODE, MS00531.SITECODE
notNullConstraint: NOTNULL
MS00531.DATE_TIME, MS00531.SOILTEMP_MEAN_FLAG, MS00531.PROBE_CODE, MS00531.DBCODE, MS00531.SITECODE, MS00531.ENTITY, MS00531.DEPTH, MS00531.QC_LEVEL, MS00531.EVENT_CODE, MS00531.SOILTEMP_METHOD

Attributes (11)

DBCODE - char(5) (nominal)

ID: MS00531.DBCODE

FSDB database code

Type system: Microsoft SQL Server 2019

Code definitions (1)

MS005
FSDB Database Code

ENTITY - numeric(2,0) (interval)

ID: MS00531.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: MS00531.SITECODE

Site code for the meteorological measurement station

Type system: Microsoft SQL Server 2019

Code definitions (37)

RS01__
Reference Stand RS01 air/soil temperature site
RS02__
Reference Stand RS02 air/soil temperature site
RS03__
Reference Stand RS03 air/soil temperature site
RS04__
Reference Stand RS04 air/soil temperature site
RS05__
Reference Stand RS05 air/soil temperature site
RS06__
Reference Stand RS06 air/soil temperature site
RS07__
Reference Stand RS07 air/soil temperature site
RS08__
Reference Stand RS08 air/soil temperature site
RS09__
Reference Stand RS09 air/soil temperature site
RS10__
Reference Stand RS10 air/soil temperature site
RS11__
Reference Stand RS11 air/soil temperature site
RS12__
Reference Stand RS12 air/soil temperature site
RS13__
Reference Stand RS13 air/soil temperature site
RS14__
Reference Stand RS14 air/soil temperature site
RS15__
Reference Stand RS15 air/soil temperature site
RS16__
Reference Stand RS16 air/soil temperature site
RS17__
Reference Stand RS17 air/soil temperature site
RS18__
Reference Stand RS18 air/soil temperature site
RS19__
Reference Stand RS19 air/soil temperature site
RS20__
Reference Stand RS20 air/soil temperature site
RS24__
Reference Stand RS24 air/soil temperature site
RS26__
Reference Stand RS26 air/soil temperature site
TS31__
Thermograph site 31
TS32__
Thermograph site 32
TS33__
Thermograph site 33
TS34__
Thermograph site 34
TS35__
Thermograph site 35
TS36__
Thermograph site 36
TS37__
Thermograph site 37
RS38__
Reference Stand RS38 air/soil temperature site (formerly TS38__)
TS74__
Thermograph site 74
TS75__
Thermograph site 75
TS76__
Thermograph site 76
TS77__
Thermograph site 77
RS86__
Reference Stand RS86 air/soil temperature and relative humidity site
RS89__
Reference Stand RS89 air/soil temperature and relative humidity site
RS13O_
Reference Stand RS13 Open canopy air/soil temperature site

SOILTEMP_METHOD - char(6) (nominal)

ID: MS00531.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 (29)

SOI115
Mean daily soil temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 20 cm depth
SOI116
Mean daily (sunrise to sunrise) soil temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 20 cm depth
SOI023
Soil temperature is sampled by a Campbell Scientific model 107 thermistor at 10 cm depth; mean temperature is output every 6 hours
SOI024
Soil temperature is sampled by a Campbell Scientific model 107 thermistor at 20 cm depth; mean temperature is output every 6 hours
SOI025
Soil temperature is sampled by a Campbell Scientific model 107 thermistor at 30 cm depth; mean temperature is output every 6 hours
SOI020
Soil temperature is sampled by type T thermocouple soldered from thermocouple wire at 10 cm depth with a Campbell Scientific data logger; mean temperature is output every 6 hours
SOI021
Soil temperature is sampled by type T thermocouple soldered from thermocouple wire at 20 cm depth with a Campbell Scientific data logger; mean temperature is output every 6 hours
SOI022
Soil temperature is sampled by type T thermocouple soldered from thermocouple wire at 30 cm depth with a Campbell Scientific data logger; mean temperature is output every 6 hours
SOI117
Mean daily, max and min soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple soldered from thermocouple wire at 10 cm depth (Daily output only)
SOI118
Mean daily, max and min soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple soldered from thermocouple wire at 20 cm depth (Daily output only)
SOI119
Mean daily, max and min soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple soldered from thermocouple wire at 30 cm depth (Daily output only)
SOI026
Soil temperature is sampled by type T thermocouple soldered from thermocouple wire at 10 cm depth with a Campbell Scientific data logger; mean temperature is output every 5 minutes
SOI027
Soil temperature is sampled by type T thermocouple soldered from thermocouple wire at 20 cm depth with a Campbell Scientific data logger; mean temperature is output every 5 minutes
SOI028
Soil temperature is sampled by type T thermocouple soldered from thermocouple wire at 30 cm depth with a Campbell Scientific data logger; mean temperature is output every 5 minutes
SOI029
Soil temperature is sampled by a Campbell Scientific model 107 thermistor at 10 cm depth; mean temperature is output every 5 minutes
SOI030
Soil temperature is sampled by a Campbell Scientific model 107 thermistor at 20 cm depth; mean temperature is output every 5 minutes
SOI031
Soil temperature is sampled by a Campbell Scientific model 107 thermistor at 30 cm depth; mean temperature is output every 5 minutes
SOI120
Mean daily, max and min soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple soldered from thermocouple wire at 10 cm depth (See Method SOI020)
SOI121
Mean daily, max and min soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple soldered from thermocouple wire at 20 cm depth (See Method SOI021)
SOI122
Mean daily, max and min soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is type T thermocouple soldered from thermocouple wire at 30 cm depth (See Method SOI022)
SOI123
Mean daily, max and min soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is Campbell Scientific model 107 thermistor at 10 cm depth (See Method SOI023)
SOI124
Mean daily, max and min soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is Campbell Scientific model 107 thermistor at 20 cm depth (See Method SOI024)
SOI125
Mean daily, max and min soil temperature is calculated by the Campbell Scientific datalogger based on 15 second samples. Instrument is Campbell Scientific model 107 thermistor at 30 cm depth (See Method SOI025)
SOI126
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. Type T thermocouple wire at 10 cm depth (See Method SOI026)
SOI127
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. Type T thermocouple wire at 20 cm depth (See Method SOI027)
SOI128
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. Type T thermocouple wire at 30 cm depth (See Method SOI028)
SOI129
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. Campbell Scientific model 107 thermistor at 10 cm depth (See Method SOI029)
SOI130
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. Campbell Scientific model 107 thermistor at 20 cm depth (See Method SOI030)
SOI131
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. Campbell Scientific model 107 thermistor at 30 cm depth (See Method SOI031)

DEPTH - numeric(4,0) (ratio)

ID: MS00531.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=30.0000 (exclusive=false)

QC_LEVEL - char(2) (nominal)

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

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
1D
Data is published and unlikely to change - data is derived or aggregated from published data of level 1A
1P
Data is provisional and subject to revision - preliminary quality checks have been performed
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

PROBE_CODE - char(8) (nominal)

ID: MS00531.PROBE_CODE

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

Type system: Microsoft SQL Server 2019

Code definitions (120)

AIRO1301
Air temperature at RS13O_, probe no. 01 at height 435 cm, discontinued 2003
AIRR0101
Air temperature at RS01__, probe no. 01 at height 100 cm, discontinued 1995
AIRR0201
Air temperature at RS02__, probe no. 01 at height 225 cm, discontinued 2015
AIRR0301
Air temperature at RS03__, probe no. 01 at height 235 cm, discontinued 1995
AIRR0401
Air temperature at RS04__, probe no. 01 at height 325 cm, discontinued 2015
AIRR0501
Air temperature at RS05__, probe no. 01 at height 200 cm, discontinued 2017
AIRR0601
Air temperature at RS06__, probe no. 01 at height 100 cm, discontinued 1975
AIRR0701
Air temperature at RS07__, probe no. 01 at height 100 cm, discontinued 1995
AIRR0801
Air temperature at RS08__, probe no. 01 at height 100 cm, discontinued 1973
AIRR0901
Air temperature at RS09__, probe no. 01 at height 100 cm, discontinued 1975
AIRR1001
Air temperature at RS10__, probe no. 01 at height 200 cm, discontinued 2017
AIRR1101
Air temperature at RS11__, probe no. 01 at height 100 cm, discontinued 1977
AIRR1201
Air temperature at RS12__, probe no. 01 at height 190 cm, discontinued 2015
AIRR1301
Air temperature at RS13__, probe no. 01 at height 275 cm, discontinued 2003
AIRR1401
Air temperature at RS14__, probe no. 01 at height 285 cm, discontinued 2003
AIRR1501
Air temperature at RS15__, probe no. 01 at height 180 cm, discontinued 1994
AIRR1601
Air temperature at RS16__, probe no. 01 at height 180 cm, discontinued 1994
AIRR1701
Air temperature at RS17__, probe no. 01 at height 60 cm, discontinued 1995
AIRR1801
Air temperature at RS18__, probe no. 01 at height 100 cm, discontinued 1974
AIRR1901
Air temperature at RS19__, probe no. 01 at height 100 cm, discontinued 1973
AIRR2001
Air temperature at RS20__, probe no. 01 at height 220 cm, discontinued 2015
AIRR2401
Air temperature at RS24__, probe no. 01 at height 220 cm, discontinued 2004
AIRR2601
Air temperature at RS26__, probe no. 01 at height 200 cm, discontinued 2015
AIRR8601
Air temperature at RS86__, probe no. 01 at height 235 cm, discontinued 2017
AIRR8901
Air temperature at RS89__, probe no. 01 at height 285 cm, discontinued 2017
AIRT3101
Air temperature at TS31__, probe no. 01 at height 100 cm, discontinued 1976
AIRT3201
Air temperature at TS32__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3301
Air temperature at TS33__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3401
Air temperature at TS34__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3501
Air temperature at TS35__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3601
Air temperature at TS36__, probe no. 01 at height 100 cm, discontinued 1975
AIRT3701
Air temperature at TS37__, probe no. 01 at height 100 cm, discontinued 1976
AIRR3801
Air temperature at RS38__, probe no. 01 at height 100 cm, discontinued 2017
AIRT7401
Air temperature at TS74__, probe no. 01 at height 100 cm, discontinued 1990
AIRT7501
Air temperature at TS75__, probe no. 01 at height 100 cm, discontinued 1990
AIRT7601
Air temperature at TS76__, probe no. 01 at height 100 cm, discontinued 1975
AIRT7701
Air temperature at TS77__, probe no. 01 at height 100 cm, discontinued 1975
SOIO1302
Soil temperature at RS13O_, probe no. 02 at depth 20 cm, discontinued 2003
SOIR0102
Soil temperature at RS01__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR0201
Soil temperature at RS02__, probe no. 01 at depth 10 cm
SOIR0202
Soil temperature at RS02__, probe no. 02 at depth 20 cm
SOIR0203
Soil temperature at RS02__, probe no. 03 at depth 30 cm
SOIR0302
Soil temperature at RS03__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR0401
Soil temperature at RS04__, probe no. 01 at depth 10 cm
SOIR0402
Soil temperature at RS04__, probe no. 02 at depth 20 cm
SOIR0403
Soil temperature at RS04__, probe no. 03 at depth 30 cm
SOIR0501
Soil temperature at RS05__, probe no. 01 at depth 10 cm
SOIR0502
Soil temperature at RS05__, probe no. 02 at depth 20 cm
SOIR0503
Soil temperature at RS05__, probe no. 03 at depth 30 cm
SOIR0602
Soil temperature at RS06__, probe no. 02 at depth 20 cm, discontinued 1975
SOIR0702
Soil temperature at RS07__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR0802
Soil temperature at RS08__, probe no. 02 at depth 20 cm, discontinued 1973
SOIR0902
Soil temperature at RS09__, probe no. 02 at depth 20 cm, discontinued 1975
SOIR1001
Soil temperature at RS10__, probe no. 01 at depth 10 cm
SOIR1002
Soil temperature at RS10__, probe no. 02 at depth 20 cm
SOIR1003
Soil temperature at RS10__, probe no. 03 at depth 30 cm
SOIR1102
Soil temperature at RS11__, probe no. 02 at depth 20 cm, discontinued 1977
SOIR1201
Soil temperature at RS12__, probe no. 01 at depth 10 cm
SOIR1202
Soil temperature at RS12__, probe no. 02 at depth 20 cm
SOIR1203
Soil temperature at RS12__, probe no. 03 at depth 30 cm
SOIR1302
Soil temperature at RS13__, probe no. 02 at depth 20 cm, discontinued 2003
SOIR1401
Soil temperature at RS14__, probe no. 01 at depth 10 cm, discontinued 2003
SOIR1402
Soil temperature at RS14__, probe no. 02 at depth 20 cm, discontinued 2003
SOIR1403
Soil temperature at RS14__, probe no. 03 at depth 30 cm, discontinued 2003
SOIR1502
Soil temperature at RS15__, probe no. 02 at depth 20 cm, discontinued 1994
SOIR1602
Soil temperature at RS16__, probe no. 02 at depth 20 cm, discontinued 1994
SOIR1702
Soil temperature at RS17__, probe no. 02 at depth 20 cm, discontinued 1995
SOIR1802
Soil temperature at RS18__, probe no. 02 at depth 20 cm, discontinued 1974
SOIR1902
Soil temperature at RS19__, probe no. 02 at depth 20 cm, discontinued 1973
SOIR2001
Soil temperature at RS20__, probe no. 01 at depth 10 cm
SOIR2002
Soil temperature at RS20__, probe no. 02 at depth 20 cm
SOIR2003
Soil temperature at RS20__, probe no. 03 at depth 30 cm
SOIR2401
Soil temperature at RS24__, probe no. 01 at depth 10 cm, discontinued 2004
SOIR2402
Soil temperature at RS24__, probe no. 02 at depth 20 cm, discontinued 2004
SOIR2403
Soil temperature at RS24__, probe no. 03 at depth 30 cm, discontinued 2004
SOIR2601
Soil temperature at RS26__, probe no. 01 at depth 10 cm
SOIR2602
Soil temperature at RS26__, probe no. 02 at depth 20 cm
SOIR2603
Soil temperature at RS26__, probe no. 03 at depth 30 cm
SOIR8601
Soil temperature at RS86__, probe no. 01 at depth 10 cm
SOIR8602
Soil temperature at RS86__, probe no. 02 at depth 20 cm
SOIR8603
Soil temperature at RS86__, probe no. 03 at depth 30 cm
SOIR8901
Soil temperature at RS89__, probe no. 01 at depth 10 cm
SOIR8902
Soil temperature at RS89__, probe no. 02 at depth 20 cm
SOIR8903
Soil temperature at RS89__, probe no. 03 at depth 30 cm
SOIT3102
Soil temperature at TS31__, probe no. 02 at depth 20 cm, discontinued 1976
SOIT3202
Soil temperature at TS32__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3302
Soil temperature at TS33__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3402
Soil temperature at TS34__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3502
Soil temperature at TS35__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3602
Soil temperature at TS36__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT3702
Soil temperature at TS37__, probe no. 02 at depth 20 cm, discontinued 1976
SOIR3801
Soil temperature at RS38__, probe no. 01 at depth 10 cm
SOIR3802
Soil temperature at RS38__, probe no. 02 at depth 20 cm
SOIR3803
Soil temperature at RS38__, probe no. 03 at depth 30 cm
SOIT7402
Soil temperature at TS74__, probe no. 02 at depth 20 cm, discontinued 1990
SOIT7502
Soil temperature at TS75__, probe no. 02 at depth 20 cm, discontinued 1990
SOIT7602
Soil temperature at TS76__, probe no. 02 at depth 20 cm, discontinued 1975
SOIT7702
Soil temperature at TS77__, probe no. 02 at depth 20 cm, discontinued 1975
RELR8601
Relative humidity at RS86__, probe no. 01 at height 235 cm, discontinued 2017
RELR8901
Relative humidity at RS89__, probe no. 01 at height 285 cm, discontinued 2017
AIRR0202
Air temperature at RS02__, probe no. 02 at height 225 cm
AIRR0203
Air temperature at RS02__, probe no. 03 at height 225 cm
AIRR0402
Air temperature at RS04__, probe no. 02 at height 325 cm
AIRR0403
Air temperature at RS04__, probe no. 03 at height 325 cm
AIRR1202
Air temperature at RS12__, probe no. 02 at height 190 cm
AIRR1203
Air temperature at RS12__, probe no. 03 at height 190 cm
AIRR2002
Air temperature at RS20__, probe no. 02 at height 220 cm
AIRR2003
Air temperature at RS20__, probe no. 03 at height 220 cm
AIRR2602
Air temperature at RS26__, probe no. 02 at height 200 cm
AIRR2603
Air temperature at RS26__, probe no. 03 at height 200 cm
AIRR0502
Air temperature at RS05__, probe no. 02 at height 200 cm
AIRR0503
Air temperature at RS05__, probe no. 03 at height 200 cm
AIRR1002
Air temperature at RS10__, probe no. 02 at height 200 cm
AIRR1003
Air temperature at RS10__, probe no. 03 at height 200 cm
AIRR3802
Air temperature at RS38__, probe no. 02 at height 100 cm
AIRR3803
Air temperature at RS38__, probe no. 03 at height 100 cm
AIRR8602
Air temperature at RS86__, probe no. 02 at height 235 cm
AIRR8603
Air temperature at RS86__, probe no. 03 at height 235 cm
AIRR8902
Air temperature at RS89__, probe no. 02 at height 285 cm
AIRR8903
Air temperature at RS89__, probe no. 03 at height 285 cm

DATE_TIME - datetime (dateTime)

ID: MS00531.DATE_TIME

Date and time (PST) of probe reading

Type system: Microsoft SQL Server 2019

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

SOILTEMP_MEAN - numeric(5,1) (interval)

ID: MS00531.SOILTEMP_MEAN

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

Type system: Microsoft SQL Server 2019

Unit: degrees Celsius

Precision: 0.100000

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

SOILTEMP_MEAN_FLAG - char(1) (nominal)

ID: MS00531.SOILTEMP_MEAN_FLAG

Mean soil temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (6)

E
Estimated value
M
Missing value
Q
Questionable value
S
Daily value based on sunrise to sunrise (not midnight to midnight)
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: MS00531.EVENT_CODE

Type of comment that exists independently for 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

Type system: Microsoft SQL Server 2019

Code definitions (8)

CALIBR
Associated with the inspection or replacement of sensors for calibration
INSREM
Sensor is installed or removed
LOGGER
Change in data logger, data logger program, or wiring
MAINTE
A maintenance event has occurred
METHOD
Change in data collection method
NA
No event is reported (not applicable)
QUALTY
Event may directly affect data quality
WEATHR
A weather event has occurred that may affect reading

MS00540 - Legacy data: Temperature growth index, plant stress, and dew point temperature

Object name: MS00540_v3.csv

Records: 157356

Attributes: 17

Temporal coverage: 1970-04-13 to 1992-10-06

File size: 8227493 byte

Checksum (MD5): de11d283adf2a675aa9da74eb7bd6bd5

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

Constraints (2)

primaryKey: PRIMARY
MS00540.DATE, MS00540.SITECODE
notNullConstraint: NOTNULL
MS00540.DATE, MS00540.EXPOSURE, MS00540.DBCODE, MS00540.SITECODE, MS00540.ENTITY

Attributes (17)

DBCODE - char(5) (nominal)

ID: MS00540.DBCODE

FSDB database code

Type system: Microsoft SQL Server 2019

Code definitions (1)

MS005
FSDB Database Code

ENTITY - numeric(2,0) (interval)

ID: MS00540.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SITECODE - char(6) (nominal)

ID: MS00540.SITECODE

Site code for the meteorological measurement station

Type system: Microsoft SQL Server 2019

Code definitions (37)

RS01__
Reference Stand RS01 air/soil temperature site
RS02__
Reference Stand RS02 air/soil temperature site
RS03__
Reference Stand RS03 air/soil temperature site
RS04__
Reference Stand RS04 air/soil temperature site
RS05__
Reference Stand RS05 air/soil temperature site
RS06__
Reference Stand RS06 air/soil temperature site
RS07__
Reference Stand RS07 air/soil temperature site
RS08__
Reference Stand RS08 air/soil temperature site
RS09__
Reference Stand RS09 air/soil temperature site
RS10__
Reference Stand RS10 air/soil temperature site
RS11__
Reference Stand RS11 air/soil temperature site
RS12__
Reference Stand RS12 air/soil temperature site
RS13__
Reference Stand RS13 air/soil temperature site
RS14__
Reference Stand RS14 air/soil temperature site
RS15__
Reference Stand RS15 air/soil temperature site
RS16__
Reference Stand RS16 air/soil temperature site
RS17__
Reference Stand RS17 air/soil temperature site
RS18__
Reference Stand RS18 air/soil temperature site
RS19__
Reference Stand RS19 air/soil temperature site
RS20__
Reference Stand RS20 air/soil temperature site
RS24__
Reference Stand RS24 air/soil temperature site
RS26__
Reference Stand RS26 air/soil temperature site
TS31__
Thermograph site 31
TS32__
Thermograph site 32
TS33__
Thermograph site 33
TS34__
Thermograph site 34
TS35__
Thermograph site 35
TS36__
Thermograph site 36
TS37__
Thermograph site 37
RS38__
Reference Stand RS38 air/soil temperature site (formerly TS38__)
TS74__
Thermograph site 74
TS75__
Thermograph site 75
TS76__
Thermograph site 76
TS77__
Thermograph site 77
RS86__
Reference Stand RS86 air/soil temperature and relative humidity site
RS89__
Reference Stand RS89 air/soil temperature and relative humidity site
RS13O_
Reference Stand RS13 Open canopy air/soil temperature site

EXPOSURE - char(1) (nominal)

ID: MS00540.EXPOSURE

Instrument exposure (open or closed canopy)

Type system: Microsoft SQL Server 2019

Code definitions (2)

C
Closed canopy
O
Open canopy

DATE - datetime (dateTime)

ID: MS00540.DATE

Date of measurement

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

TGI - numeric(2,0) (ratio)

ID: MS00540.TGI

Temperature-growth index (number from 0-10, from table, computed from daytim e mean air and soil (20cm) temperatures. ten indicates perfect conditions.)

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

TGI_FLAG - char(1) (nominal)

ID: MS00540.TGI_FLAG

Temperature-growth index flag

Type system: Microsoft SQL Server 2019

Code definitions (2)

G
Good value
M
Missing

PLANTSTRES - numeric(4,1) (ratio)

ID: MS00540.PLANTSTRES

Plant moisture stress (measured until 1976)

Type system: Microsoft SQL Server 2019

Unit: atmosphere

Precision: 0.100000

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

PS_FLAG - char(1) (nominal)

ID: MS00540.PS_FLAG

Plant moisture stress flag

Type system: Microsoft SQL Server 2019

Code definitions (3)

M
Missing
E
Estimate
G
Good value

MEANDEWDAY - numeric(5,1) (ratio)

ID: MS00540.MEANDEWDAY

Mean daytime dew point temperature

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 0.100000

Numeric domain: type=real, min=-9.0000 (exclusive=false), max=21.0000 (exclusive=false)

FD1 - char(1) (nominal)

ID: MS00540.FD1

Mean daytime dew point temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (2)

G
Good value
M
Missing

MEANDEWNIT - numeric(5,1) (ratio)

ID: MS00540.MEANDEWNIT

Mean nighttime dew point temperature

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 0.100000

Numeric domain: type=real, min=-9.0000 (exclusive=false), max=17.5000 (exclusive=false)

FD2 - char(1) (nominal)

ID: MS00540.FD2

Mean nighttime dew point temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (2)

G
Good value
M
Missing

MAXDEW - numeric(5,1) (ratio)

ID: MS00540.MAXDEW

Daily maximum dew point temperature

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 0.100000

Numeric domain: type=real, min=-8.0000 (exclusive=false), max=21.0000 (exclusive=false)

FD3 - char(1) (nominal)

ID: MS00540.FD3

Maximum dew point temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (2)

G
Good value
M
Missing

MINDEW - numeric(5,1) (ratio)

ID: MS00540.MINDEW

Daily minimum dew point temperature

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 0.100000

Numeric domain: type=real, min=-10.0000 (exclusive=false), max=16.0000 (exclusive=false)

FD4 - char(1) (nominal)

ID: MS00540.FD4

Minimum dew point temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (2)

G
Good value
M
Missing

Units


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
percent	%	dimensionless	number	dimensionless	100	percent; a number
centimeters	cm	length	centimeter	meter	0.01	centimeters; .01 meters
degrees Celsius	deg c	temperature	celsiusDegree	kelvin	1	Degrees Celsius; a common unit of temperature; constantToSI=273.18
atmosphere	atm	pressure	atmosphere	pascal	101325	pressure in bars
number	number	dimensionless	number	dimensionless	1	dimensionless number, i.e., ratio, count

Related Datasets

MS001

Related Publications

Zobel, D. B.; McKee, W. A.; Hawk, G. M.; Dyrness, C. T. 1974. Correlation of forest communities with environment and phenology on the H.J. Andrews Experimental Forest, Oregon. In: Waring, R. H.; Edmonds, R. L., eds. Integrated research in the coniferous forest biome. Bulletin 5. Seattle, WA: Coniferous Forest Biome: 48-56.
Rosentrater, Lynn D. 1997. The thermal climate of the H.J. Andrews Experimental Forest, Oregon . Eugene, OR: University of Oregon. 133 p. M.S. thesis.
Smith, Jonathan W. 2002. Mapping the thermal climate of the H.J. Andrews Experimental Forest, Oregon. Corvallis, OR: Oregon State University. 222 p. M.S. thesis.

Related Files

Vegetation Zones
Sites listed by vegetation zones

URL: https://andrewsforest.oregonstate.edu/data/studies/ms05/meta/veg_zones.pdf
Provisional Real-Time Data Graphs and Other Data Products
Access real-time climate and hydrology stations data graphs (for the past few weeks) and other data products on the Andrews Experimental Forest

URL: https://andrewsforest.oregonstate.edu/data/streaming
H.J. Andrews Climate Station Methods History
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.

URL: https://hjandrews.shinyapps.io/im_methods_history/

Intellectual Rights

Data Use Agreement:

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

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

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

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

Licensed

License: Creative Commons Attribution 4.0 International Public License

Identifier: CC-BY-4.0

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

Maintenance

Maintenance update frequency: annually

Description

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

Recent News & Events

Most Recent Research Highlight

See Real-Time Data

Search Andrews Publications

Education Resources

Did You Find What You Needed?

MS005: Air and soil temperature data from the Reference Stand network at the Andrews Experimental Forest, 1971 to present

Notice

Method Steps

Sampling

Description

Change History