Did You Find What You Needed?

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

Share Your Feedback

MS036: Cold air drainage transect studies at the Andrews Experimental Forest, 2002 to Present

← Back to catalog index

Status: annually
Period: 2001-01-12 to 2022-10-11
Version: 6
Published: 2023-04-08
EDI Package ID: knb-lter-and.4543.6
Source XML: MS036_6.xml

Notice

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

Citation

Daly, C. 2023. Cold air drainage transect studies at the Andrews Experimental Forest, 2002 to Present Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/MS036 Accessed 2026-05-10.

Abstract

Temperature data are being collected to investigate the effects of elevation and local topographic position on the patterns of cold air drainage and pooling in the HJ Andrews Forest, and how they vary with synoptic weather patterns. The main focus of the study is cold air drainage in the Lookout Creek area, but others sites have been added to sample temperature signatures at other locations of the forest with topographic positions that need to be better understood. Here, quality controlled 15-minute raw data and aggregated daily minimum and maximum temperatures are available from several stations along 4 separate transects or clusters with some additional single sensors also included. Several of the quality flags indicate that the data failed the test and should not be used in analysis.

Coverage

Temporal coverage: 2001-01-12 to 2022-10-11

Geographic coverage: HJ Andrews Experimental Forest

Spatial coverage:

Bounds: W -122.22055560, E -122.12083330, N 44.28138889, S 44.20344500

Purpose
  • These data are being used to inform methods for downscaling regional climate maps using PRISM (http://prism.oregonstate.edu/). Specifically, data from these transects reveal patterns of cold air drainage and pooling in mountain valleys, and their relationships with regional weather conditions, topographic position, and the spatial scale of the valleys.
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
    ORCID: http://orcid.org/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
    ORCID: http://orcid.org/0000-0002-7100-2551
  • Brooke E. Penaluna - Principal Investigator
    Email: brooke.penaluna@usda.gov, Brooke.Penaluna@oregonstate.edu
    ORCID: http://orcid.org/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
    ORCID: http://orcid.org/0000-0002-0924-1172
  • David Bell - Principal Investigator
    Email: david.bell@usda.gov, david.bell@oregonstate.edu
    ORCID: http://orcid.org/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
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
  • Christopher Daly
    Role: Principal Investigator
    PRISM Group;Northwest Alliance for Computational Science and Engineering, 2000 Kelley Engineering Center;Oregon State University, Corvallis, OR, 97331, USA
    Phone: (541) 737-2531
    Email: daly@nacse.org
  • Christopher Daly
    Role: Creator
    PRISM Group;Northwest Alliance for Computational Science and Engineering, 2000 Kelley Engineering Center;Oregon State University, Corvallis, OR, 97331, USA
    Phone: (541) 737-2531
    Email: daly@nacse.org
  • John Moreau
    Role: Former Investigator
    Blue River, OR, 97413, USA
    Email: john.moreau@oregonstate.edu
  • Adam M Kennedy
    Role: Other Researcher
    1055 Clinton Drive, Eugene, OR, 97401, US
    Phone: 541-822-6302
    Email: adam.kennedy@oregonstate.edu, kennaster@gmail.com
  • Joseph I. Smith
    Role: Other Researcher
  • Joseph I. Smith
    Role: Method Contact
  • Greg M Cohn
    Role: Other Researcher
    USFS Rd 15-130-132, Blue River, OR, 97413
    Phone: 541-822-6305
    Email: cohng@oregonstate.edu
  • David Rupp
    Role: Other Researcher
    Earth, Ocean & Atmo Sci
    Email: drupp@coas.oregonstate.edu
Contact
  • Information Manager
    Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331
    Email: hjaweb@lists.oregonstate.edu
Publisher
  • Andrews Forest LTER Site
    Role: Publisher
    Forest Ecosystems and Society Department in Forestry, Oregon State University, 201K Richardson Hall, Corvallis, OR, 97331-5752
    Phone: (541) 737-8480
    Email: lterweb@lists.oregonstate.edu
Study Description

Temperature data are being collected to investigate the effects of elevation and local topographic position on the patterns of cold air drainage and pooling in the HJ Andrews Forest, and how they vary with synoptic weather patterns. The main focus of the study is cold air drainage in the Lookout Creek area, but others sites have been added to sample temperature signatures at other locations of the forest with topographic positions that need to be better understood. Here, quality controlled 15-minute raw data and aggregated daily minimum and maximum temperatures are available from several stations along 4 separate transects or clusters with some additional single sensors also included. Several of the quality flags indicate that the data failed the test and should not be used in analysis. These data are being used to inform methods for downscaling regional climate maps using PRISM (http://prism.oregonstate.edu/). Specifically, data from these transects reveal patterns of cold air drainage and pooling in mountain valleys, and their relationships with regional weather conditions, topographic position, and the spatial scale of the valleys. Field Methods - MS036

Purpose: These data are being used to inform methods for downscaling regional climate maps using PRISM (http://prism.oregonstate.edu/). Specifically, data from these transects reveal patterns of cold air drainage and pooling in mountain valleys, and their relationships with regional weather conditions, topographic position, and the spatial scale of the valleys.

Methods

Method Steps

Field Methods - MS036
  • Data are sampled every 15 minutes with Hobo portable sensors mounted on rebar approximately 1.5 m above ground. Radiation shields are the “HJA short” type, which is made from PVC tubing, cut lengthwise and mounted above the sensor; sensors are open to the ground. Most sensors are located under dense forest canopy, with little solar radiation exposure. Many sensors also record illumination, which is useful in quantifying light exposure. Data are downloaded from the Hobo two times per year.
Processing Procedures - MS036
  • Daily maximum and minimum temperature values for entity 1 are generated from the raw 15-min HOBO data files. The data are subjected to a series of QC checks including range, rate of change, sufficient number of observations, standard deviation, and multi-day persistence checks. For range checks, the values are compared to the state monthly record. If a value falls outside of 2.8 degree C buffer, the value is removed from further consideration. For the rate of change check, if the current temperature is not missing and within one hour of the previous valid temperature, the difference between the temperatures is calculated. If the temperature difference exceeds 10 degrees C, the current temperature is removed from further consideration. At this point, the maximum and minimum of all non-missing temperatures for the day become the daily maximum and minimum temperatures. To check if there were a sufficient number of observations for the day, if there were valid observations in less than 18 of the 24 hours in the day, the daily maximum and minimum temperatures are flagged as an insufficient number of hourly observations to generate a valid daily observation. The standard deviation of all observations for the day is calculated and if the standard deviation is less than 0.1 degrees C, the daily observations are flagged as having too little variation over the day to be considered valid. Finally, the daily observations are checked for multi-day persistence. The difference between successive daily observations is calculated and if the difference is 0.4 degrees C or less for more than 10 successive observations, all observations in the sequence (not already flagged by previous checks) are flagged as being too many days with the same value. There can be no more than two missing days between successive observations before the sequence is reset. The 0.4 degree C threshold was chosen to identify occurrences of drift in automated sensors. Maximum and minimum temperatures are tested for multi-day persistence independently to account for issues that affect only one end of the temperature range, or where maximum and minimum temperatures are measured independently.
  • The 15-minute QC'd data in entity 2 was a one-time process to create this dataset for publication and is separate from the processing of data in entity 1. The raw 15-minute data are first run through an R program that concatenates the separate files from the HOBO datalogger into a single, uniformly formatted, time series with time gaps filled with blank records. The concatenated data are then run through a Python program (hja_hobo_clean) created for the purpose of data quality assurance and quality control of HOBO temperature sensor data collected at the Andrews Forest. The program flags data based on user-specified parameters. The program can also remove flagged data (clean) and fill in missing data with regressed data from other sites, but these procedures where not used for these data. Visual inspection was also done of the data from some sites - those on the Lower Lookout (LL) and Upper Lookout (UL) transects only. Visual inspection consisted of comparing all sensors within a transect to identify suspect data (e.g., a sensor whose reading were clearly inconsistent with others and with its own previous patterns). For all sites, field notes were also used to identify data when a sensor may have been on ground and/or its radiation shield was broken. Lastly, data are run through a second R program that flags data based on results from the visual inspection and field notes.
Quality Assurance - MS036
  • The flags set for daily minimum and maximum data are single-station QC (SSQC) flags. Spatial consistency QC (SPQC) tests have not been applied to these data. If a daily value fails an SSQC test, the value is retained, but it is not passed to PRISM for use in modeling, as it has been determined that the value does not meet minimum requirements for inclusion. Users of these data should be aware of these short-comings with the flagged data.

Sampling

Study Extent
  • Sites are selected along transects to represent elevational change moving in lateral directions away from a stream, or are clustered above or below a spring or depression. Two single points are selected at high elevations to represent one low and one high topographic position.
  • Sampling frequency: 15-minute
Sampling Description
  • Observed temperatures on “cold air” transects at 34 locations within the HJ Andrews Forest. The lower Lookout Creek transect (10 stations) is located just to the west of the concrete bridge, and intersects RS10. The upper Lookout Creek transect (11 stations) extends north from the north slope of Lookout Mountain, across Lookout Creek, and ends below the CENMET benchmark station. East of the upper transect, there is a short, 4-station transect across Cold Creek, a tributary of Lookout Creek. North of the upper transect, a 5-station cluster samples locations near a stream channel, above and below a spring. Single sensors are located downslope from the Roads End rain gauge near the southern border of the forest (high elevation, but locally low topographic position), and near the summit of Carpenter Mountain, on the northern border of the forest (high elevation, high topographic position, exposed to the free atmosphere). Two sensors will located temporarily in and above a sink northeast of the CENMET benchmark station. The upper and lower Lookout Creek transects were established in 2002, with others placed at later dates.
Spatial Sampling Units
  • HJA Cold Air Transects
    W -122.22055560, E -122.22055560, N 44.28138889, S 44.28138889
    Altitude: 1616 to 1616 meter
  • HJA Cold Air Station #501, Lower Lookout transect, elevation 669m, north
    W -122.21916670, E -122.21916670, N 44.23611111, S 44.23611111
    Altitude: 669 to 669 meter
  • HJA Cold Air Station #502, Lower Lookout transect, elevation 646m, north
    W -122.21888890, E -122.21888890, N 44.23500000, S 44.23500000
    Altitude: 646 to 646 meter
  • HJA Cold Air Station #503, Lower Lookout transect, elevation,557m, north
    W -122.21861110, E -122.21861110, N 44.23194444, S 44.23194444
    Altitude: 557 to 557 meter
  • HJA Cold Air Station #504, Lower Lookout transect, elevation, 527m, north
    W -122.21916670, E -122.21916670, N 44.23055556, S 44.23055556
    Altitude: 527 to 527 meter
  • HJA Cold Air Station #505, Lower Lookout transect, elevation, 528m, south
    W -122.21750000, E -122.21750000, N 44.23027778, S 44.23027778
    Altitude: 528 to 528 meter
  • HJA Cold Air Station #506, Lower Lookout transect, elevation, 577m, south
    W -122.21416670, E -122.21416670, N 44.22944444, S 44.22944444
    Altitude: 577 to 577 meter
  • HJA Cold Air Station #507, Lower Lookout transect, elevation, 596m, south
    W -122.21388890, E -122.21388890, N 44.22861111, S 44.22861111
    Altitude: 596 to 596 meter
  • HJA Cold Air Station #508, Lower Lookout transect, elevation, 624m, south
    W -122.21277780, E -122.21277780, N 44.22777778, S 44.22777778
    Altitude: 624 to 624 meter
  • HJA Cold Air Station #509, Daly Spring cluster, elevation 986, above spring
    W -122.14277780, E -122.14277780, N 44.24222222, S 44.24222222
    Altitude: 986 to 986 meter
  • HJA Cold Air Station #510, Upper Lookout transect, elevation, 903m, north
    W -122.14361110, E -122.14361110, N 44.23694444, S 44.23694444
    Altitude: 903 to 903 meter
  • HJA Cold Air Station #511, Upper Lookout transect, elevation, 912m, north
    W -122.14444440, E -122.14444440, N 44.23527778, S 44.23527778
    Altitude: 912 to 912 meter
  • HJA Cold Air Station #512, Upper Lookout transect, elevation, 841m, north
    W -122.14500000, E -122.14500000, N 44.23388889, S 44.23388889
    Altitude: 841 to 841 meter
  • HJA Cold Air Station #513, Upper Lookout transect, elevation, 806m, south
    W -122.14500000, E -122.14500000, N 44.23222222, S 44.23222222
    Altitude: 806 to 806 meter
  • HJA Cold Air Station #514, Upper Lookout transect, elevation, 813m, south
    W -122.14500000, E -122.14500000, N 44.23194444, S 44.23194444
    Altitude: 813 to 813 meter
  • HJA Cold Air Station #515, Upper Lookout transect, elevation, 813m, south
    W -122.14500000, E -122.14500000, N 44.23166667, S 44.23166667
    Altitude: 813 to 813 meter
  • HJA Cold Air Station #516, Upper Lookout transect, elevation, 845m, south
    W -122.14500000, E -122.14500000, N 44.23111111, S 44.23111111
    Altitude: 845 to 845 meter
  • HJA Cold Air Station #517, Upper Lookout transect, elevation, 876m, south
    W -122.14500000, E -122.14500000, N 44.23055556, S 44.23055556
    Altitude: 876 to 876 meter
  • HJA Cold Air Station #518, Upper Lookout transect, elevation, 900m, south
    W -122.14500000, E -122.14500000, N 44.23027778, S 44.23027778
    Altitude: 900 to 900 meter
  • HJA Cold Air Station #519A, Lower Lookout transect, elevation, 613m, north
    W -122.21861110, E -122.21861110, N 44.23361111, S 44.23361111
    Altitude: 613 to 613 meter
  • HJA Cold Air Station #519B, Upper Lookout transect, elevation, 925m, south
    W -122.14500000, E -122.14500000, N 44.22972222, S 44.22972222
    Altitude: 925 to 925 meter
  • HJA Cold Air Station #520, Upper Lookout transect, elevation, 957m, south
    W -122.14500000, E -122.14500000, N 44.22916667, S 44.22916667
    Altitude: 957 to 957 meter
  • HJA Cold Air Station #521, Daly Spring cluster, elevation 987, above spring
    W -122.14250000, E -122.14250000, N 44.24194444, S 44.24194444
    Altitude: 987 to 987 meter
  • HJA Cold Air Station #522, Daly Spring cluster, elevation 980, below spring
    W -122.14361110, E -122.14361110, N 44.24250000, S 44.24250000
    Altitude: 980 to 980 meter
  • HJA Cold Air Station #523, Daly Spring cluster, elevation 974, below spring
    W -122.14416670, E -122.14416670, N 44.24250000, S 44.24250000
    Altitude: 974 to 974 meter
  • HJA Cold Air Station #524, Daly Spring cluster, elevation 962, below spring
    W -122.14444440, E -122.14444440, N 44.24194444, S 44.24194444
    Altitude: 962 to 962 meter
  • HJA Cold Air Station #525, Cold Creek transect, elevation 1058, south
    W -122.12111110, E -122.12111110, N 44.23000000, S 44.23000000
    Altitude: 1058 to 1058 meter
  • HJA Cold Air Station #526, Cold Creek transect, elevation 1063, south
    W -122.12083330, E -122.12083330, N 44.22972222, S 44.22972222
    Altitude: 1063 to 1063 meter
  • HJA Cold Air Station #527, Cold Creek transect, elevation 1051, north
    W -122.12138890, E -122.12138890, N 44.23027778, S 44.23027778
    Altitude: 1051 to 1051 meter
  • HJA Cold Air Station #528, Cold Creek transect, elevation 1064, north
    W -122.12166670, E -122.12166670, N 44.23055556, S 44.23055556
    Altitude: 1064 to 1064 meter
  • HJA Cold Air Station #529, Lower Lookout transect, elevation, 756m, north
    W -122.22055560, E -122.22055560, N 44.23916667, S 44.23916667
    Altitude: 756 to 756 meter
  • HJA Cold Air Station on Carpenter Mountain, elevation 1616m, high topographic position
    W -122.14361110, E -122.14361110, N 44.28138889, S 44.28138889
    Altitude: 1616 to 1616 meter
  • HJA Cold Air Station Moreau Depression Pit, elevation 1134, in sink
    W -122.15598800, E -122.15598800, N 44.25027500, S 44.25027500
    Altitude: 1134 to 1134 meter
  • HJA Cold Air Station Moreau Depression Ridge, elevation 1138, above sink
    W -122.15585000, E -122.15585000, N 44.25128600, S 44.25128600
    Altitude: 1138 to 1138 meter
  • HJA Cold Air Station at Road's End, elevation 1320m, low topographic position
    W -122.13985200, E -122.13985200, N 44.20344500, S 44.20344500
    Altitude: 1320 to 1320 meter
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: meteorology (theme), climatology (theme), climate change (theme), air temperature (theme), topography (theme), forest ecosystems (theme)
  • Andrews Experimental Forest site thesaurus: Long-Term Ecological Research (LTER) (theme)
Taxonomic Hierarchy

No taxonomic hierarchy listed in this EML file.

Data Entities
# Entity Metadata Data
1 MS03601
Air Temperature (Daily minimum and maximum)
Computed from fine temporal resolutions sensors.
METADATA DATA
2 MS03602
Fine temporal resolution (15-minute) air temperature and light intensity data
Raw data that has been flagged with the hja_hobo_clean Python program and, for a subset of sites, by visual inspection
METADATA DATA
Metadata
MS03601 - Air Temperature (Daily minimum and maximum)

Object name: MS03601_v4.csv

Records: 195350

Attributes: 9

Temporal coverage: 2001-01-12 to 2022-10-11

File size: 8624537 byte

Checksum (MD5): 749e7b37880492ded197f331d73f6950

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

Constraints (2)
  • primaryKey: PRIMARY
    MS03601.SITECODE, MS03601.DATE
  • notNullConstraint: NOTNULL
    MS03601.DBCODE, MS03601.ENTITY, MS03601.SITECODE, MS03601.DATE, MS03601.AIRTEMP_MAX_QC, MS03601.AIRTEMP_MIN_QC, MS03601.TRANSECT
Attributes (9)
DBCODE - char(5) (nominal)

ID: MS03601.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2019

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

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

TRANSECT - char(2) (nominal)

ID: MS03601.TRANSECT

Transect or cluster for the given site

Type system: Microsoft SQL Server 2019

Code definitions (7)
  • CC
    Cold Creek
  • DS
    DS
  • LL
    Lower Lookout Creek
  • MD
    MD
  • RE
    Road's End, at the end of NF-1507
  • UL
    Upper Lookout Creek
  • CM
    Carpenter Mountain
SITECODE - char(6) (nominal)

ID: MS03601.SITECODE

Site code for the measurement station

Type system: Microsoft SQL Server 2019

Code definitions (34)
  • CA501
    HJA Cold Air Station #501, Lower Lookout transect, elevation 669m, north
  • CA502
    HJA Cold Air Station #502, Lower Lookout transect, elevation 646m, north
  • CA503
    HJA Cold Air Station #503, Lower Lookout transect, elevation,557m, north
  • CA504
    HJA Cold Air Station #504, Lower Lookout transect, elevation, 527m, north
  • CA505
    HJA Cold Air Station #505, Lower Lookout transect, elevation, 528m, south
  • CA506
    HJA Cold Air Station #506, Lower Lookout transect, elevation, 577m, south
  • CA507
    HJA Cold Air Station #507, Lower Lookout transect, elevation, 596m, south
  • CA508
    HJA Cold Air Station #508, Lower Lookout transect, elevation, 624m, south
  • CA509
    HJA Cold Air Station #509, Daly Spring cluster, elevation 986, above spring
  • CA510
    HJA Cold Air Station #510, Upper Lookout transect, elevation, 903m, north
  • CA511
    HJA Cold Air Station #511, Upper Lookout transect, elevation, 912m, north
  • CA512
    HJA Cold Air Station #512, Upper Lookout transect, elevation, 841m, north
  • CA513
    HJA Cold Air Station #513, Upper Lookout transect, elevation, 806m, south
  • CA514
    HJA Cold Air Station #514, Upper Lookout transect, elevation, 813m, south
  • CA515
    HJA Cold Air Station #515, Upper Lookout transect, elevation, 813m, south
  • CA516
    HJA Cold Air Station #516, Upper Lookout transect, elevation, 845m, south
  • CA517
    HJA Cold Air Station #517, Upper Lookout transect, elevation, 876m, south
  • CA518
    HJA Cold Air Station #518, Upper Lookout transect, elevation, 900m, south
  • CA519A
    HJA Cold Air Station #519A, Lower Lookout transect, elevation, 613m, north
  • CA519B
    HJA Cold Air Station #519B, Upper Lookout transect, elevation, 925m, south
  • CA520
    HJA Cold Air Station #520, Upper Lookout transect, elevation, 957m, south
  • CA521
    HJA Cold Air Station #521, Daly Spring cluster, elevation 987, above spring
  • CA522
    HJA Cold Air Station #522, Daly Spring cluster, elevation 980, below spring
  • CA523
    HJA Cold Air Station #523, Daly Spring cluster, elevation 974, below spring
  • CA524
    HJA Cold Air Station #524, Daly Spring cluster, elevation 962, below spring
  • CA525
    HJA Cold Air Station #525, Cold Creek transect, elevation 1058, south
  • CA526
    HJA Cold Air Station #526, Cold Creek transect, elevation 1063, south
  • CA527
    HJA Cold Air Station #527, Cold Creek transect, elevation 1051, north
  • CA528
    HJA Cold Air Station #528, Cold Creek transect, elevation 1064, north
  • CA529
    HJA Cold Air Station #529, Lower Lookout transect, elevation, 756m, north
  • CACARP
    HJA Cold Air Station on Carpenter Mountain, elevation 1616m, high topographic position
  • CAMDPI
    HJA Cold Air Station Moreau Depression Pit, elevation 1134, in sink
  • CAMDRI
    HJA Cold Air Station Moreau Depression Ridge, elevation 1138, above sink
  • CAROAD
    HJA Cold Air Station at Road's End, elevation 1320m, low topographic position
DATE - datetime (dateTime)

ID: MS03601.DATE

Date of Measurement

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

AIRTEMP_MAX_DAY - numeric(5,1) (interval)

ID: MS03601.AIRTEMP_MAX_DAY

Maximum air temperature for the day

Type system: Microsoft SQL Server 2019

Unit: degrees Celsius

Precision: 0.200000

Numeric domain: type=real, min=-15.6000 (exclusive=false), max=51.0000 (exclusive=false)

AIRTEMP_MAX_QC - char(1) (nominal)

ID: MS03601.AIRTEMP_MAX_QC

Maximum air temperature quality control codes

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • code
    Value passed QC test
  • 1
    No data collected - instrument failure
  • 3
    Insufficient number of hourly observations to generate a valid daily observation
  • 8
    Too little variation in hourly observations to generate a valid daily observation
  • 9
    Too many consecutive days with the same daily value
AIRTEMP_MIN_DAY - numeric(5,1) (interval)

ID: MS03601.AIRTEMP_MIN_DAY

Minimum air temperature for the day

Type system: Microsoft SQL Server 2019

Unit: degrees Celsius

Precision: 0.200000

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

AIRTEMP_MIN_QC - char(1) (nominal)

ID: MS03601.AIRTEMP_MIN_QC

Minimum air temperature quality control codes

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • code
    Value passed quality control test
  • 1
    No data collected - instrument failure
  • 3
    Insufficient number of hourly observations to generate a valid daily observation
  • 8
    Too little variation in hourly observations to generate a valid daily observation
  • 9
    Too many consecutive days with the same daily value
MS03602 - Fine temporal resolution (15-minute) air temperature and light intensity data

Object name: MS03602_v1.txt

Records: 17464555

Attributes: 21

Temporal coverage: 2002-07-26 to 2019-07-26

File size: 1388186281 byte

Checksum (MD5): b5b9b16b8603e4080522ed5038ee45a7

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

Constraints (2)
  • primaryKey: PRIMARY
    MS03602.SITECODE, MS03602.DATE_TIME
  • notNullConstraint: NOTNULL
    MS03602.SITECODE, MS03602.DATE_TIME, MS03602.QC_LEVEL, MS03602.TRANSECT, MS03602.DAYLIGHT, MS03602.TIME_GAP, MS03602.EXTREME_TEMP, MS03602.JUMP, MS03602.EXTREME_INTENSITY, MS03602.HIGH_INTENSITY, MS03602.RADIATION_BIAS_INTENSITY, MS03602.LOW_DAYLIGHT_INTENSITY, MS03602.NIGHTTIME_INTENSITY, MS03602.SNOW, MS03602.TEMP_SPIKE, MS03602.FIELD_NOTES, MS03602.VISUAL_1
Attributes (21)
DBCODE - char(5) (nominal)

ID: MS03602.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2019

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

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

TRANSECT - char(2) (nominal)

ID: MS03602.TRANSECT

Transect or cluster for the given site

Type system: Microsoft SQL Server 2019

Code definitions (7)
  • CC
    Cold Creek
  • DS
    DS
  • LL
    Lower Lookout Creek
  • MD
    MD
  • RE
    Road's End, at the end of NF-1507
  • UL
    Upper Lookout Creek
  • CM
    Carpenter Mountain
SITECODE - char(6) (nominal)

ID: MS03602.SITECODE

Site code for the measurement station

Type system: Microsoft SQL Server 2019

Code definitions (34)
  • CA501
    HJA Cold Air Station #501, Lower Lookout transect, elevation 669m, north
  • CA502
    HJA Cold Air Station #502, Lower Lookout transect, elevation 646m, north
  • CA503
    HJA Cold Air Station #503, Lower Lookout transect, elevation,557m, north
  • CA504
    HJA Cold Air Station #504, Lower Lookout transect, elevation, 527m, north
  • CA505
    HJA Cold Air Station #505, Lower Lookout transect, elevation, 528m, south
  • CA506
    HJA Cold Air Station #506, Lower Lookout transect, elevation, 577m, south
  • CA507
    HJA Cold Air Station #507, Lower Lookout transect, elevation, 596m, south
  • CA508
    HJA Cold Air Station #508, Lower Lookout transect, elevation, 624m, south
  • CA509
    HJA Cold Air Station #509, Daly Spring cluster, elevation 986, above spring
  • CA510
    HJA Cold Air Station #510, Upper Lookout transect, elevation, 903m, north
  • CA511
    HJA Cold Air Station #511, Upper Lookout transect, elevation, 912m, north
  • CA512
    HJA Cold Air Station #512, Upper Lookout transect, elevation, 841m, north
  • CA513
    HJA Cold Air Station #513, Upper Lookout transect, elevation, 806m, south
  • CA514
    HJA Cold Air Station #514, Upper Lookout transect, elevation, 813m, south
  • CA515
    HJA Cold Air Station #515, Upper Lookout transect, elevation, 813m, south
  • CA516
    HJA Cold Air Station #516, Upper Lookout transect, elevation, 845m, south
  • CA517
    HJA Cold Air Station #517, Upper Lookout transect, elevation, 876m, south
  • CA518
    HJA Cold Air Station #518, Upper Lookout transect, elevation, 900m, south
  • CA519A
    HJA Cold Air Station #519A, Lower Lookout transect, elevation, 613m, north
  • CA519B
    HJA Cold Air Station #519B, Upper Lookout transect, elevation, 925m, south
  • CA520
    HJA Cold Air Station #520, Upper Lookout transect, elevation, 957m, south
  • CA521
    HJA Cold Air Station #521, Daly Spring cluster, elevation 987, above spring
  • CA522
    HJA Cold Air Station #522, Daly Spring cluster, elevation 980, below spring
  • CA523
    HJA Cold Air Station #523, Daly Spring cluster, elevation 974, below spring
  • CA524
    HJA Cold Air Station #524, Daly Spring cluster, elevation 962, below spring
  • CA525
    HJA Cold Air Station #525, Cold Creek transect, elevation 1058, south
  • CA526
    HJA Cold Air Station #526, Cold Creek transect, elevation 1063, south
  • CA527
    HJA Cold Air Station #527, Cold Creek transect, elevation 1051, north
  • CA528
    HJA Cold Air Station #528, Cold Creek transect, elevation 1064, north
  • CA529
    HJA Cold Air Station #529, Lower Lookout transect, elevation, 756m, north
  • CACARP
    HJA Cold Air Station on Carpenter Mountain, elevation 1616m, high topographic position
  • CAMDPI
    HJA Cold Air Station Moreau Depression Pit, elevation 1134, in sink
  • CAMDRI
    HJA Cold Air Station Moreau Depression Ridge, elevation 1138, above sink
  • CAROAD
    HJA Cold Air Station at Road's End, elevation 1320m, low topographic position
QC_LEVEL - char(2) (nominal)

ID: MS03602.QC_LEVEL

Quality control flag indicates level of quality checking performed

Type system: Microsoft SQL Server 2019

Code definitions (4)
  • 1A
    Data is published and unlikely to change - automated range checking and manual review has been conducted.
  • 1D
    Data is published and unlikely to change - data is derived or aggregated from published data of level 1A
  • 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
DATE_TIME - datetime (dateTime)

ID: MS03602.DATE_TIME

Date and time in Pacific Standard Time (PST) of measurement

Type system: Microsoft SQL Server 2019

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

AIRTEMP_INST - numeric(8,3) (ratio)

ID: MS03602.AIRTEMP_INST

Instantaneous air temperature recorded on a specified interval (e.g., every 15 or 20 minutes)

Type system: Microsoft SQL Server 2019

Unit: degrees Celsius

Precision: 1

Numeric domain: type=real, min=-59.0400 (exclusive=false), max=398.6700 (exclusive=false)

INTENSITY - numeric(7,0) (ratio)

ID: MS03602.INTENSITY

Light intensity measured under the PVC shield on a specified interval (e.g., every 15 or 20 minutes)

Type system: Microsoft SQL Server 2019

Unit: lux

Precision: 1

Numeric domain: type=integer, min=0.0000 (exclusive=false), max=341690.0000 (exclusive=false)

DAYLIGHT - char(1) (nominal)

ID: MS03602.DAYLIGHT

An indication of day vs night, daylight hour based on sunrise/sunset table

Type system: Microsoft SQL Server 2019

Code definitions (2)
  • code
    Night
  • 1
    Day
TIME_GAP - char(1) (nominal)

ID: MS03602.TIME_GAP

Time gap flag

Type system: Microsoft SQL Server 2019

Code definitions (2)
  • code
    No time gap in data
  • 1
    Time interval between measurements is greater than the threshold (15 or 20 minutes)
EXTREME_TEMP - char(1) (nominal)

ID: MS03602.EXTREME_TEMP

Extreme temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (2)
  • code
    Temperature change relative to prior reading is within prescribed range
  • 1
    Temperature change relative to prior reading is outside the possible range (greater tha 42 or less than or equal to -20 degrees C)
JUMP - char(1) (nominal)

ID: MS03602.JUMP

Temperature jump flag

Type system: Microsoft SQL Server 2019

Code definitions (2)
  • code
    Temperature change relative to prior reading is within prescribed range
  • 1
    Temperature change greater than 5 degrees C relative to prior reading
EXTREME_INTENSITY - char(1) (nominal)

ID: MS03602.EXTREME_INTENSITY

Extreme intensity flag

Type system: Microsoft SQL Server 2019

Code definitions (3)
  • code
    Light intensity value is within the prescribed range
  • 1
    Light intensity reading is an impossible value (greater than 40,000 lux)
  • 9
    Light intensity is not measured (no sensor present)
HIGH_INTENSITY - char(1) (nominal)

ID: MS03602.HIGH_INTENSITY

High intensity flag

Type system: Microsoft SQL Server 2019

Code definitions (3)
  • code
    Light intensity value is within the prescribed range
  • 1
    Light intensity value likely associated with greater than or equal to 3 degree C bias relative to aspirated sensor (greater than 18,000 lux)
  • 9
    Light intensity is not measured (no sensor present)
RADIATION_BIAS_INTENSITY - char(1) (nominal)

ID: MS03602.RADIATION_BIAS_INTENSITY

Radiation bias flag

Type system: Microsoft SQL Server 2019

Code definitions (3)
  • code
    Light intensity value is within the prescribed range
  • 1
    Light intensity value likely associated with greater than or equal to 1.5 degree C bias relative to aspirated sensor (greater than 7000 lux)
  • 9
    Light intensity is not measured (no sensor present)
LOW_DAYLIGHT_INTENSITY - char(1) (nominal)

ID: MS03602.LOW_DAYLIGHT_INTENSITY

Low daylight flag

Type system: Microsoft SQL Server 2019

Code definitions (3)
  • code
    Light intensity value is within the prescribed range
  • 1
    Light intensity reading less than or equal to 0 during daylight hours
  • 9
    Light intensity is not measured (no sensor present)
NIGHTTIME_INTENSITY - char(1) (nominal)

ID: MS03602.NIGHTTIME_INTENSITY

Nightime intensity reading flag

Type system: Microsoft SQL Server 2019

Code definitions (3)
  • code
    Light intensity value is within the prescribed range
  • 1
    Light intensity reading greater than or equal to 0.1 lux during nighttime hours (defined as outside of daylight)
  • 9
    Light intensity is not measured (no sensor present)
SNOW - char(1) (ordinal)

ID: MS03602.SNOW

Snow flag

Type system: Microsoft SQL Server 2019

Code definitions (2)
  • code
    Snow is not affecting the temperature sensor reading
  • 1
    Temperature within plus or minus 0.7 degrees C for 2 days indicating that the sensor might be buried under snow
TEMP_SPIKE - char(1) (nominal)

ID: MS03602.TEMP_SPIKE

Temperature spike flag

Type system: Microsoft SQL Server 2019

Code definitions (2)
  • code
    Temperature change from a 7-record (centered) median is within prescribed range
  • 1
    Temperature deviates more than 7 degrees C from a 7-record (centered) median
FIELD_NOTES - char(1) (nominal)

ID: MS03602.FIELD_NOTES

Site inspection flag

Type system: Microsoft SQL Server 2019

Code definitions (2)
  • code
    No fallen or broken sensor or shield reported during site inspection
  • 1
    Sensor was on ground and/or radiation shield was broken at site inspection; all readings from day of inspection back to day of previous inspection are flagged with "1"
VISUAL_1 - char(1) (nominal)

ID: MS03602.VISUAL_1

Visual/manual QC flag

Type system: Microsoft SQL Server 2019

Code definitions (2)
  • code
    No highly suspect reading was detected when visually compared to other sensors in the same transect. Applies only to the Lower Lookout (LL) and Upper Lookout (UL) transects
  • 1
    A highly suspect reading was detected when visually compared to other sensors in the same transect. Applies only to the Lower Lookout (LL) and Upper Lookout (UL) transects
Units
number number dimensionless number dimensionless 1 dimensionless number, i.e., ratio, count
degrees Celsius deg c temperature celsiusDegree kelvin 1 Degrees Celsius; a common unit of temperature; constantToSI=273.18
lux lux illuminance lux lux 1 lux
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.

Change History

  • Version1 (2007-07-20)
    Created study code for Cold Air Temperature Transects in SQL.
  • Version2 (2011-03-10)
    Created entities and attributes in SQL.
  • Version3 (2017-06-29)
    Entity 1 is established online for the first time, 2002-2016. Entity 2 15-minute data will not be prepared for online distribution. Attributes were renamed to match MS001 convention.
  • Version4 (2017-07-18)
    Enhanced abstract, purpose and attribute "sitecode" descriptions in the metadata. Added a "transect" attribute to categorize the individual stations. Also corrects intellectual rights and adds checksum.
  • Version5 (2019-12-04)
    Added entity 2 data which is 15 minute data run through Python QC program that flags data. From David Rupp and used in a paper. Also added new version of entity 1 which are QC'd daily max and min temperature values. All data values are flagged and no data are removed.
  • Version6 (2023-04-08)
    Updated data in entity 1 through 9-10/2022. Data was reprocessed due to an error in the original QC code starting in 6/20/2007 for most sites, 10/26/2009 for CACARP, and 6/28/2009 for transects MD and RE. Entity 2 will not be updated as it was a one-off product.