# Cold air drainage transect studies at the Andrews Experimental Forest, 2002 to Present ## Dataset - **Database Code:** MS036 - **Title:** Cold air drainage transect studies at the Andrews Experimental Forest, 2002 to Present - **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. - **Keywords:** meteorology; climatology; climate change; air temperature; topography; forest ecosystems; Long-Term Ecological Research (LTER) - **Temporal coverage:** 2001-01-12 to 2022-10-11 - **Principal Investigator:** Christopher Daly ## Data Entities 1. Air Temperature (Daily minimum and maximum) 2. Fine temporal resolution (15-minute) air temperature and light intensity data ## Entity 1: Air Temperature (Daily minimum and maximum) ### Attribute list - **DBCODE** — varchar, enum FSDB Database Code - **MS036** — FSDB Database Code MS036 - **ENTITY** — numeric(1.000000), range 1.0000 1.0000, number Entity Number - **TRANSECT** — varchar, enum Transect or cluster for the given site - **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** — varchar, enum Site code for the measurement station - **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, freetext Date of Measurement - **AIRTEMP_MAX_DAY** — numeric(0.200000), range -15.6000 51.0000, degrees Celsius Maximum air temperature for the day - **AIRTEMP_MAX_QC** — varchar, enum Maximum air temperature quality control codes - **** — 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(0.200000), range -25.1000 47.6000, degrees Celsius Minimum air temperature for the day - **AIRTEMP_MIN_QC** — varchar, enum Minimum air temperature quality control codes - **** — 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 ## Entity 2: Fine temporal resolution (15-minute) air temperature and light intensity data ### Attribute list - **DBCODE** — varchar, enum FSDB Database Code - **MS036** — FSDB Database Code MS036 - **ENTITY** — numeric(1.000000), range 2.0000 2.0000, number Entity Number - **TRANSECT** — varchar, enum Transect or cluster for the given site - **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** — varchar, enum Site code for the measurement station - **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** — varchar, enum Quality control flag indicates level of quality checking performed - **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, freetext Date and time in Pacific Standard Time (PST) of measurement - **AIRTEMP_INST** — numeric(1), range -59.0400 398.6700, degrees Celsius Instantaneous air temperature recorded on a specified interval (e.g., every 15 or 20 minutes) - **INTENSITY** — numeric(1), range 0.0000 341690.0000, lux Light intensity measured under the PVC shield on a specified interval (e.g., every 15 or 20 minutes) - **DAYLIGHT** — varchar, enum An indication of day vs night, daylight hour based on sunrise/sunset table - **** — Night - **1** — Day - **TIME_GAP** — varchar, enum Time gap flag - **** — No time gap in data - **1** — Time interval between measurements is greater than the threshold (15 or 20 minutes) - **EXTREME_TEMP** — varchar, enum Extreme temperature flag - **** — 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** — varchar, enum Temperature jump flag - **** — Temperature change relative to prior reading is within prescribed range - **1** — Temperature change greater than 5 degrees C relative to prior reading - **EXTREME_INTENSITY** — varchar, enum Extreme intensity flag - **** — 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** — varchar, enum High intensity flag - **** — 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** — varchar, enum Radiation bias flag - **** — 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** — varchar, enum Low daylight flag - **** — 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** — varchar, enum Nightime intensity reading flag - **** — 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** — varchar, enum Snow flag - **** — 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** — varchar, enum Temperature spike flag - **** — 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** — varchar, enum Site inspection flag - **** — 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** — varchar, enum Visual/manual QC flag - **** — 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 ## Attribute Definitions **AIRTEMP_INST** Instantaneous air temperature recorded on a specified interval (e.g., every 15 or 20 minutes) **AIRTEMP_MAX_DAY** Maximum air temperature for the day **AIRTEMP_MAX_QC** Maximum air temperature quality control codes **AIRTEMP_MIN_DAY** Minimum air temperature for the day **AIRTEMP_MIN_QC** Minimum air temperature quality control codes **DATE** Date of Measurement **DATE_TIME** Date and time in Pacific Standard Time (PST) of measurement **DAYLIGHT** An indication of day vs night, daylight hour based on sunrise/sunset table **DBCODE** FSDB Database Code **ENTITY** Entity Number **EXTREME_INTENSITY** Extreme intensity flag **EXTREME_TEMP** Extreme temperature flag **FIELD_NOTES** Site inspection flag **HIGH_INTENSITY** High intensity flag **INTENSITY** Light intensity measured under the PVC shield on a specified interval (e.g., every 15 or 20 minutes) **JUMP** Temperature jump flag **LOW_DAYLIGHT_INTENSITY** Low daylight flag **NIGHTTIME_INTENSITY** Nightime intensity reading flag **QC_LEVEL** Quality control flag indicates level of quality checking performed **RADIATION_BIAS_INTENSITY** Radiation bias flag **SITECODE** Site code for the measurement station **SNOW** Snow flag **TEMP_SPIKE** Temperature spike flag **TIME_GAP** Time gap flag **TRANSECT** Transect or cluster for the given site **VISUAL_1** Visual/manual QC flag ## Enumerated Domains ### DBCODE - **MS036** — FSDB Database Code MS036 ### TRANSECT - **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 - **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 ### AIRTEMP_MAX_QC - **** — 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_QC - **** — 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 ### QC_LEVEL - **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 ### DAYLIGHT - **** — Night - **1** — Day ### TIME_GAP - **** — No time gap in data - **1** — Time interval between measurements is greater than the threshold (15 or 20 minutes) ### EXTREME_TEMP - **** — 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 - **** — Temperature change relative to prior reading is within prescribed range - **1** — Temperature change greater than 5 degrees C relative to prior reading ### EXTREME_INTENSITY - **** — 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 - **** — 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 - **** — 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 - **** — 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 - **** — 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 - **** — 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 - **** — 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 - **** — 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 - **** — 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