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

MS045: Air temperature at core phenology sites and additional bird monitoring sites in the Andrews Experimental Forest, 2009 to present

← Back to catalog index

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

Status: annually
Period: 2008-10-01 to 2022-10-08
Version: 5
Published: 2023-04-24
EDI Package ID: knb-lter-and.5370.5
Source XML: MS045_5.xml

Notice

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

Citation

Schulze, M.; Betts, M.; Frey, S. 2023. Air temperature at core phenology sites and additional bird monitoring sites in the Andrews Experimental Forest, 2009 to present Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/MS045 Accessed 2026-05-10.

Abstract

The H.J Andrews phenology study air temperature network includes 16 core phenology sites, 40 core bird sites and 128 auxiliary bird sites. This study examines air temperatures at multiple sites within the Andrews Experimental Forest. Air temperatures were recorded 1.5 m above ground at 184 sites distributed on an 800-m incomplete grid throughout much of the Andrews Forest. Data were collected using automated sensors starting in June of 2009 at 56 sites and in June 2011 128 additional sensors were added. These data document the complex spatial and temporal patterns of air temperature variation within the Andrews Forest, which is governed by multiple processes including inversions, regional air mixing, cold air drainage and pooling, and the effects of vegetation on temperature extremes. The data entities provided indicate various methods of data quality checking over time.

Coverage

Temporal coverage: 2008-10-01 to 2022-10-08

Geographic coverage: HJ Andrews Experimental Forest

Spatial coverage:

Bounds: W -122.26077333, E -122.11159208, N 44.28199677, S 44.20198189

Purpose
  • These air temperature data were collected to support phenological research focused on increasing our understanding of plant, insect and bird responses to climates across the Andrews Experimental Forest. Species, taxa and communities within and across trophic levels are likely responding differently to climatic drivers.
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
  • 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
  • Mark D Schulze
    Role: Creator
    H.J. Andrews Experimental Forest; PO Box 300, Blue River, OR, 97413
    Phone: 541-822-6336
    Email: mark.schulze@oregonstate.edu
  • Matthew G Betts
    Role: Creator
    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
  • Sarah J. K. Frey
    Role: Creator
    Forest Ecosystems and Society;Oregon State University, Corvallis, OR, 97331
    Email: sjkfrey@gmail.com
  • Matthew G Betts
    Role: 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
  • Mark D Schulze
    Role: Principal Investigator
    H.J. Andrews Experimental Forest; PO Box 300, Blue River, OR, 97413
    Phone: 541-822-6336
    Email: mark.schulze@oregonstate.edu
  • Sherri L. Johnson
    Role: Other Researcher
    US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: 541-758-7771
    Email: sherri.johnson2@usda.gov, sherri.johnson@oregonstate.edu
  • Nina C. Ferrari
    Role: Other Researcher
    Email: ferrarin@oregonstate.edu, ninaferrari94@gmail.com
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

The H.J Andrews phenology study air temperature network includes 16 core phenology sites, 40 core bird sites and 128 auxiliary bird sites. This study examines air temperatures at multiple sites within the Andrews Experimental Forest. Air temperatures were recorded 1.5 m above ground at 184 sites distributed on an 800-m incomplete grid throughout much of the Andrews Forest. Data were collected using automated sensors starting in June of 2009 at 56 sites and in June 2011 128 additional sensors were added. These data document the complex spatial and temporal patterns of air temperature variation within the Andrews Forest, which is governed by multiple processes including inversions, regional air mixing, cold air drainage and pooling, and the effects of vegetation on temperature extremes. The data entities provided indicate various methods of data quality checking over time. These air temperature data were collected to support phenological research focused on increasing our understanding of plant, insect and bird responses to climates across the Andrews Experimental Forest. Species, taxa and communities within and across trophic levels are likely responding differently to climatic drivers. Field Methods - MS045

Purpose: These air temperature data were collected to support phenological research focused on increasing our understanding of plant, insect and bird responses to climates across the Andrews Experimental Forest. Species, taxa and communities within and across trophic levels are likely responding differently to climatic drivers.

Methods

Method Steps

Field Methods - MS045
  • At all the phenology air temperature sites, an Onset brand temperature sensor was placed at 1.5m above ground and shielded from direct sun. Shields were 8 inches long made from 3.5 inch diameter schedule 40 PVC pipe split in half lengthwise.

Instrumentation:

  • At the 16 Phenology Core sites, Onset Hobo U22-001 (accuracy 0.2 C) were programmed to record instantaneous air temperatures at 15 min intervals. At the 40 Core Bird sites and the 128 Auxillary Bird sites, Onset Hobo Pendant temperature and light sensors UA002-64 (accuracy 0.5 C) recorded instantaneous data at 20min intervals.
Quality Assurance - MS045
  • After sensors were downloaded, high resolution data were put through a series of programs for quality control and for filling missing values before generating the hourly averages (entities 2 and 4). A major concern of quality control was to detect when the sensors were buried by snow because temperatures would be representative of the snowpack and not the air temperature. When burial was detected, data were filled using the regression relationships with other sensors. Regressions were calculated using the best fit with other sensors during periods of time when the full data were available.
  • Note: Spikes in data associated with direct light impacting the sensors were not evaluated as part of the QC programs.
  • Note: For Phenology Core sites additional manual QA/QC was conducted to evaluate and correct snow flags and temperature spikes, resulting in data filling or reverting to original data, as needed.
  • For these entities (1-4), quality assurance and quality control was conducted on all temperature data collected. All data were averaged into hourly segments and run through a Python script to identify and flag impossible values, periods of missing data, and when sensors were buried by snow. Data were further checked via manual QAQC and values were compared to those from nearby temperature stations to identify any erroneous snow flags (i.e., data flagged as snow burial when there was no snow at that site), as well as temperature spikes, missing data, and other questionable values not identified by automated QAQC.
  • Raw data for entity 5 was flagged and not filled using the hja_hobo_clean Python programs. These data were checked for burial by snow, detection of extreme values and jumps, as well as the influence of high/extreme light intensity.
  • Raw data for entity 6 was flagged and not filled using the GCE Toolbox workflow and based on the flagging algorithms in the hja_hobo_clean workflow. Like entity 5, these data were checked for burial by snow, detection of extreme values and jumps, as well as the influence of high/extreme light intensity. Rather than having multiple data columns for each flag, as in entity 5, these data use an aggregated flagging system for each data variable (temperature and light).
Statistics - MS045
  • Evaluation of the high resolution temperatures (15 and 20 minute intervals) was conducted and questionable data flagged. Before calculation of hourly averages, flagged data were removed and missing values calculated using regression relationships with other temperature data from Andrews Forest for that period.
  • Script name: WaTeR.py (used to create entities 2 and 4)
  • This script was designed to flag, clean, average by hour, and fill data from air temperature sensors deployed at the HJ Andrews.
  • A revised Python program was used to flag the raw data in entity 5. This program also cleans and fills, but these data are not provided. A researcher can download the Python program from Bitbucket, the raw data from entity 5, and run the program. There is also a visualization program.
  • https://bitbucket.org/account/user/hjandrews/projects/PHEN
  • Datasets: The WaTeR.py script creates folders: flagged, cleaned, reference, and filled. These contain:
  • flagged original data with flags
  • cleaned data with the flags removed
  • reference cleaned data averaged into hourly timesteps
  • filled cleaned data which has been filled using other files in the reference folder based on their respective regressions
  • summary daily values with min, max and mean
  • Requires: Python, SciPy and NumPy
  • Note: This program was written for data loggers started during June (daylight savings time). Since ONSET uses the computer clock for time stamps, raw times are in PDT not PST. Hourly averaging changes times to PST and matches reference file format (where the hour represents the average of temperatures in the preceding hour). If original logger start dates are not in PDT, there is a line of code (currently 313) which can be turned on.
  • Settings: This may be run for a file or folder. The file or folder should be found in the same directory as the script. Input the file or folder name (e.g. INPUTFOLDER="Folder") and comment out the unused line (e.g. #INPUTFILE). Input files should contain the site name as this name is retained through processing. Date limits should be specified under the '#Date limits' heading. These form the bookends in which the program will attempt to fill gaps using the available reference files. Reference files are stored together in a folder (e.g. REFERENCE_DIR = "RS data for PC sites") and are labeled with *reformatted* to distinguish them from reference files which have not been modified to match the required input format. All sites are added as they are run, so this should be run twice if they are not already included in the reference folder and you want them as reference files for sites run in the same batch. Site files will not be used if they have *cleaned*, *filled* or *flagged* in their file name to avoid using processed data. Reference files must be in the correct format and include *reformatted* in their filename or they will not be used. These labels are consistent with the output files from this script as well as the script to convert reference data downloaded from the Andrews website (convert_reference_data.py).
  • Description: This script serves to flag, prune, average (by hour), and fill air temperature data as detailed below. This script was applied to the raw data that created entities 2 and 4
  • Step 1: Flagging (Original time steps); Output file – (input file name)_flagged_00-0000.csv, where 00-0000 is the month-year of the last data point
  • Flagging identifies for each line (date/time) entry:
  • Step 2: Pruning (Original time step); Output file – (input file name)_cleaned_00-000.csv
  • Pruning removes lines containing extreme, air_past, air, jump and nodata.
  • Step 3: Averaging (Hourly time step); Output file – (input file name)_00-0000_reformatted.csv
  • Averaging uses only values remaining after pruning. The number of values used to calculate the average is included as a new column. Notes: The command for saving this output file includes the path for the reference folder, if that folder is changed, it should also be changed in this section (or a new folder will be made with the files but they will not be used for filling). Averaging follows the convention used for Andrews weather stations where the hour represents the average of temperatures in the preceding hour. The output is in PST (while all previous outputs are in PDT, matching the raw input).
  • Step 4: Filling (Hourly time step); Output file – (input file name)_filled_00-000.csv
  • The script uses cleaned data and compares remaining entries to reference files (see Settings). This is done as a linear regression of the cleaned data with each reference file, the output includes the R2 which can be found in the text file corresponding to the input file name. Prior to filling, the script creates placeholder hours bounded by the date range specified under “Date limits” which is the range in which filling is attempted. These values are set at 1000 degrees. The script aims to fill missing (1000 degree) data by moving sequentially through the reference data in order of fit (R2). The linear regression equation is used to modify the reference value for that data point and it replaces the 1000 degree placeholder. The reference file used in the temperature value filling is listed in a neighboring column. If all reference files are examined and no data is found to replace the missing value placeholder, the placeholder is retained, thus 1000 degrees should be treated as "no data".
  • Step 5: Max, min, mean (Daily time step); Output file – (input file name)_daily_00-0000.csv
  • The script ignores 1000 degree data and calculates daily max, min and mean temperature values from the filled dataset. The number of records (hours) used in the calculation is listed in the column 'count.'
  • Figures: Data points over time with flagged (and cleaned) data shown in red. Located within the "flagged" folder as .pdfs.

Sampling

Study Extent
  • HJ Andrews Phenology sites
  • Sampling frequency: Continuous
Sampling Description
  • Sixteen core phenology sites were selected based on locations of long term air temperature and vegetation data at reference stands. Distribution of study sites was augmented by adding a few additional sites. At these Core sites, air temperature was measured year round and plant phenology, insect and bird abundances was measured during springtime from 2009-2014.
  • Additional sensors were placed at 40 Core Bird sites and 124 Auxillary Bird sites. These locations were stratified across elevation, forest type, and distance to roads to insure that the full environmental gradient was sampled, with a minimum distance between sampling points of 300m.
Spatial Sampling Units
  • HJA Phenology Auxiliary Site 002
    W -122.20169127, E -122.20169127, N 44.23091130, S 44.23091130
    Altitude: 604 to 604 meter
  • HJA Phenology Auxiliary Site 003
    W -122.20172777, E -122.20172777, N 44.22821061, S 44.22821061
    Altitude: 649 to 649 meter
  • HJA Phenology Auxiliary Site 004
    W -122.20176427, E -122.20176427, N 44.22550993, S 44.22550993
    Altitude: 767 to 767 meter
  • HJA Phenology Auxiliary Site 005
    W -122.20183726, E -122.20183726, N 44.22010856, S 44.22010856
    Altitude: 912 to 912 meter
  • HJA Phenology Auxiliary Site 006
    W -122.20187375, E -122.20187375, N 44.21740788, S 44.21740788
    Altitude: 993 to 993 meter
  • HJA Phenology Core Bird Site 008
    W -122.19667703, E -122.19667703, N 44.23132630, S 44.23132630
    Altitude: 621 to 621 meter
  • HJA Phenology Auxiliary Site 009
    W -122.19671377, E -122.19671377, N 44.22862562, S 44.22862562
    Altitude: 697 to 697 meter
  • HJA Phenology Auxiliary Site 010
    W -122.19675050, E -122.19675050, N 44.22592494, S 44.22592494
    Altitude: 764 to 764 meter
  • HJA Phenology Auxiliary Site 011
    W -122.19678722, E -122.19678722, N 44.22322426, S 44.22322426
    Altitude: 828 to 828 meter
  • HJA Phenology Auxiliary Site 012
    W -122.19682394, E -122.19682394, N 44.22052358, S 44.22052358
    Altitude: 929 to 929 meter
  • HJA Phenology Auxiliary Site 013
    W -122.19436329, E -122.19436329, N 44.21735515, S 44.21735515
    Altitude: 1091 to 1091 meter
  • HJA Phenology Core Bird Site 014
    W -122.19440011, E -122.19440011, N 44.21465447, S 44.21465447
    Altitude: 1184 to 1184 meter
  • HJA Phenology Auxiliary Site 016
    W -122.18666695, E -122.18666695, N 44.23080531, S 44.23080531
    Altitude: 639 to 639 meter
  • HJA Phenology Auxiliary Site 017
    W -122.18670414, E -122.18670414, N 44.22810464, S 44.22810464
    Altitude: 726 to 726 meter
  • HJA Phenology Auxiliary Site 018
    W -122.18674133, E -122.18674133, N 44.22540396, S 44.22540396
    Altitude: 783 to 783 meter
  • HJA Phenology Auxiliary Site 019
    W -122.18677851, E -122.18677851, N 44.22270329, S 44.22270329
    Altitude: 859 to 859 meter
  • HJA Phenology Auxiliary Site 020
    W -122.18681569, E -122.18681569, N 44.22000262, S 44.22000262
    Altitude: 1053 to 1053 meter
  • HJA Phenology Auxiliary Site 021
    W -122.18685286, E -122.18685286, N 44.21730194, S 44.21730194
    Altitude: 1181 to 1181 meter
  • HJA Phenology Core Bird Site 022
    W -122.18689002, E -122.18689002, N 44.21460126, S 44.21460126
    Altitude: 1285 to 1285 meter
  • HJA Phenology Auxiliary Site 023
    W -122.18692719, E -122.18692719, N 44.21190058, S 44.21190058
    Altitude: 1276 to 1276 meter
  • HJA Phenology Auxiliary Site 027
    W -122.17922988, E -122.17922988, N 44.22535024, S 44.22535024
    Altitude: 784 to 784 meter
  • HJA Phenology Auxiliary Site 028
    W -122.17926741, E -122.17926741, N 44.22264957, S 44.22264957
    Altitude: 867 to 867 meter
  • HJA Phenology Auxiliary Site 029
    W -122.17930493, E -122.17930493, N 44.21994890, S 44.21994890
    Altitude: 924 to 924 meter
  • HJA Phenology Core Bird Site 030
    W -122.17934244, E -122.17934244, N 44.21724823, S 44.21724823
    Altitude: 1077 to 1077 meter
  • HJA Phenology Auxiliary Site 031
    W -122.17937995, E -122.17937995, N 44.21454756, S 44.21454756
    Altitude: 1099 to 1099 meter
  • HJA Phenology Auxiliary Site 032
    W -122.17941746, E -122.17941746, N 44.21184688, S 44.21184688
    Altitude: 1203 to 1203 meter
  • HJA Phenology Auxiliary Site 036
    W -122.17171846, E -122.17171846, N 44.22529602, S 44.22529602
    Altitude: 804 to 804 meter
  • HJA Phenology Auxiliary Site 037
    W -122.17175633, E -122.17175633, N 44.22259536, S 44.22259536
    Altitude: 813 to 813 meter
  • HJA Phenology Auxiliary Site 038
    W -122.17179419, E -122.17179419, N 44.21989469, S 44.21989469
    Altitude: 858 to 858 meter
  • HJA Phenology Auxiliary Site 039
    W -122.17183205, E -122.17183205, N 44.21719403, S 44.21719403
    Altitude: 994 to 994 meter
  • HJA Phenology Auxiliary Site 040
    W -122.17186991, E -122.17186991, N 44.21449336, S 44.21449336
    Altitude: 1074 to 1074 meter
  • HJA Phenology Auxiliary Site 041
    W -122.17190775, E -122.17190775, N 44.21179269, S 44.21179269
    Altitude: 1171 to 1171 meter
  • HJA Phenology Auxiliary Site 042
    W -122.17194560, E -122.17194560, N 44.20909202, S 44.20909202
    Altitude: 1311 to 1311 meter
  • HJA Phenology Auxiliary Site 044
    W -122.16413062, E -122.16413062, N 44.23064262, S 44.23064262
    Altitude: 747 to 747 meter
  • HJA Phenology Auxiliary Site 045
    W -122.16416885, E -122.16416885, N 44.22794197, S 44.22794197
    Altitude: 740 to 740 meter
  • HJA Phenology Core Bird Site 046
    W -122.16420706, E -122.16420706, N 44.22524131, S 44.22524131
    Altitude: 758 to 758 meter
  • HJA Phenology Core Bird Site 047
    W -122.16424527, E -122.16424527, N 44.22254065, S 44.22254065
    Altitude: 797 to 797 meter
  • HJA Phenology Auxiliary Site 048
    W -122.16428348, E -122.16428348, N 44.21983999, S 44.21983999
    Altitude: 883 to 883 meter
  • HJA Phenology Auxiliary Site 051
    W -122.16443625, E -122.16443625, N 44.20903734, S 44.20903734
    Altitude: 1040 to 1040 meter
  • HJA Phenology Core Bird Site 052
    W -122.16447443, E -122.16447443, N 44.20633667, S 44.20633667
    Altitude: 1170 to 1170 meter
  • HJA Phenology Auxiliary Site 053
    W -122.15646424, E -122.15646424, N 44.24139000, S 44.24139000
    Altitude: 923 to 923 meter
  • HJA Phenology Auxiliary Site 054
    W -122.15650283, E -122.15650283, N 44.23868935, S 44.23868935
    Altitude: 871 to 871 meter
  • HJA Phenology Core Bird Site 055
    W -122.15654141, E -122.15654141, N 44.23598871, S 44.23598871
    Altitude: 805 to 805 meter
  • HJA Phenology Auxiliary Site 059
    W -122.15692693, E -122.15692693, N 44.20898216, S 44.20898216
    Altitude: 1040 to 1040 meter
  • HJA Phenology Core Bird Site 060
    W -122.15696546, E -122.15696546, N 44.20628150, S 44.20628150
    Altitude: 1167 to 1167 meter
  • HJA Phenology Auxiliary Site 062
    W -122.14883399, E -122.14883399, N 44.24943618, S 44.24943618
    Altitude: 1109 to 1109 meter
  • HJA Phenology Auxiliary Site 063
    W -122.14887294, E -122.14887294, N 44.24673554, S 44.24673554
    Altitude: 1039 to 1039 meter
  • HJA Phenology Auxiliary Site 064
    W -122.14891188, E -122.14891188, N 44.24403491, S 44.24403491
    Altitude: 986 to 986 meter
  • HJA Phenology Auxiliary Site 065
    W -122.14895082, E -122.14895082, N 44.24133427, S 44.24133427
    Altitude: 935 to 935 meter
  • HJA Phenology Auxiliary Site 066
    W -122.14898975, E -122.14898975, N 44.23863363, S 44.23863363
    Altitude: 930 to 930 meter
  • HJA Phenology Core Bird Site 067
    W -122.14902868, E -122.14902868, N 44.23593298, S 44.23593298
    Altitude: 876 to 876 meter
  • HJA Phenology Auxiliary Site 076
    W -122.13764128, E -122.13764128, N 44.24395038, S 44.24395038
    Altitude: 1131 to 1131 meter
  • HJA Phenology Auxiliary Site 077
    W -122.13768073, E -122.13768073, N 44.24124974, S 44.24124974
    Altitude: 1145 to 1145 meter
  • HJA Phenology Auxiliary Site 078
    W -122.13772018, E -122.13772018, N 44.23854911, S 44.23854911
    Altitude: 1048 to 1048 meter
  • HJA Phenology Auxiliary Site 079
    W -122.13775962, E -122.13775962, N 44.23584848, S 44.23584848
    Altitude: 950 to 950 meter
  • HJA Phenology Auxiliary Site 080
    W -122.13779906, E -122.13779906, N 44.23314784, S 44.23314784
    Altitude: 897 to 897 meter
  • HJA Phenology Auxiliary Site 081
    W -122.13717145, E -122.13717145, N 44.24653429, S 44.24653429
    Altitude: 1132 to 1132 meter
  • HJA Phenology Auxiliary Site 200
    W -122.24425407, E -122.24425407, N 44.20822481, S 44.20822481
    Altitude: 742 to 742 meter
  • HJA Phenology Core Bird Site 201
    W -122.23816611, E -122.23816611, N 44.21054320, S 44.21054320
    Altitude: 756 to 756 meter
  • HJA Phenology Core Bird Site 202
    W -122.24148785, E -122.24148785, N 44.21017816, S 44.21017816
    Altitude: 669 to 669 meter
  • HJA Phenology Auxiliary Site 203
    W -122.24317419, E -122.24317419, N 44.21240413, S 44.21240413
    Altitude: 639 to 639 meter
  • HJA Phenology Auxiliary Site 204
    W -122.24389212, E -122.24389212, N 44.21499278, S 44.21499278
    Altitude: 544 to 544 meter
  • HJA Phenology Core Bird Site 206
    W -122.25142374, E -122.25142374, N 44.21744332, S 44.21744332
    Altitude: 468 to 468 meter
  • HJA Phenology Auxiliary Site 207
    W -122.24741878, E -122.24741878, N 44.21808705, S 44.21808705
    Altitude: 493 to 493 meter
  • HJA Phenology Auxiliary Site 208
    W -122.24539522, E -122.24539522, N 44.22031546, S 44.22031546
    Altitude: 488 to 488 meter
  • HJA Phenology Auxiliary Site 209
    W -122.24259885, E -122.24259885, N 44.22336454, S 44.22336454
    Altitude: 486 to 486 meter
  • HJA Phenology Auxiliary Site 210
    W -122.23937693, E -122.23937693, N 44.22484429, S 44.22484429
    Altitude: 490 to 490 meter
  • HJA Phenology Auxiliary Site 211
    W -122.23567917, E -122.23567917, N 44.22567066, S 44.22567066
    Altitude: 489 to 489 meter
  • HJA Phenology Core Bird Site 216
    W -122.12617514, E -122.12617514, N 44.20376332, S 44.20376332
    Altitude: 1438 to 1438 meter
  • HJA Phenology Auxiliary Site 217
    W -122.12835098, E -122.12835098, N 44.20558957, S 44.20558957
    Altitude: 1502 to 1502 meter
  • HJA Phenology Auxiliary Site 224
    W -122.16745736, E -122.16745736, N 44.27353961, S 44.27353961
    Altitude: 1172 to 1172 meter
  • HJA Phenology Core Bird Site 225
    W -122.17079762, E -122.17079762, N 44.27214142, S 44.27214142
    Altitude: 1115 to 1115 meter
  • HJA Phenology Auxiliary Site 226
    W -122.17334660, E -122.17334660, N 44.26997215, S 44.26997215
    Altitude: 1074 to 1074 meter
  • HJA Phenology Auxiliary Site 233
    W -122.12895341, E -122.12895341, N 44.20802502, S 44.20802502
    Altitude: 1497 to 1497 meter
  • HJA Phenology Auxiliary Site 234
    W -122.12917656, E -122.12917656, N 44.21071866, S 44.21071866
    Altitude: 1510 to 1510 meter
  • HJA Phenology Auxiliary Site 235
    W -122.12987616, E -122.12987616, N 44.21336191, S 44.21336191
    Altitude: 1558 to 1558 meter
  • HJA Phenology Auxiliary Site 239
    W -122.12246903, E -122.12246903, N 44.20386095, S 44.20386095
    Altitude: 1391 to 1391 meter
  • HJA Phenology Auxiliary Site 240
    W -122.11768598, E -122.11768598, N 44.20405665, S 44.20405665
    Altitude: 1375 to 1375 meter
  • HJA Phenology Auxiliary Site 241
    W -122.11332177, E -122.11332177, N 44.20335165, S 44.20335165
    Altitude: 1339 to 1339 meter
  • HJA Phenology Core Bird Site 242
    W -122.15935615, E -122.15935615, N 44.23266930, S 44.23266930
    Altitude: 744 to 744 meter
  • HJA Phenology Auxiliary Site 243
    W -122.15523700, E -122.15523700, N 44.23175661, S 44.23175661
    Altitude: 781 to 781 meter
  • HJA Phenology Core Bird Site 244
    W -122.15159193, E -122.15159193, N 44.23097333, S 44.23097333
    Altitude: 874 to 874 meter
  • HJA Phenology Auxiliary Site 245
    W -122.14792950, E -122.14792950, N 44.23053193, S 44.23053193
    Altitude: 898 to 898 meter
  • HJA Phenology Auxiliary Site 246
    W -122.14410802, E -122.14410802, N 44.22983713, S 44.22983713
    Altitude: 898 to 898 meter
  • HJA Phenology Auxiliary Site 247
    W -122.14013417, E -122.14013417, N 44.22929410, S 44.22929410
    Altitude: 986 to 986 meter
  • HJA Phenology Auxiliary Site 248
    W -122.13662651, E -122.13662651, N 44.22855640, S 44.22855640
    Altitude: 1031 to 1031 meter
  • HJA Phenology Auxiliary Site 249
    W -122.13287791, E -122.13287791, N 44.22803283, S 44.22803283
    Altitude: 1024 to 1024 meter
  • HJA Phenology Auxiliary Site 250
    W -122.12934560, E -122.12934560, N 44.22643042, S 44.22643042
    Altitude: 1028 to 1028 meter
  • HJA Phenology Core Bird Site 251
    W -122.12525432, E -122.12525432, N 44.22647665, S 44.22647665
    Altitude: 991 to 991 meter
  • HJA Phenology Auxiliary Site 252
    W -122.12206971, E -122.12206971, N 44.22484420, S 44.22484420
    Altitude: 1006 to 1006 meter
  • HJA Phenology Auxiliary Site 253
    W -122.11909971, E -122.11909971, N 44.22250753, S 44.22250753
    Altitude: 1017 to 1017 meter
  • HJA Phenology Core Bird Site 254
    W -122.17952014, E -122.17952014, N 44.22969183, S 44.22969183
    Altitude: 636 to 636 meter
  • HJA Phenology Core Bird Site 255
    W -122.17576570, E -122.17576570, N 44.22865645, S 44.22865645
    Altitude: 662 to 662 meter
  • HJA Phenology Auxiliary Site 256
    W -122.17238459, E -122.17238459, N 44.22779472, S 44.22779472
    Altitude: 675 to 675 meter
  • HJA Phenology Auxiliary Site 257
    W -122.16925951, E -122.16925951, N 44.22742991, S 44.22742991
    Altitude: 692 to 692 meter
  • HJA Phenology Auxiliary Site 258
    W -122.25316885, E -122.25316885, N 44.20518168, S 44.20518168
    Altitude: 540 to 540 meter
  • HJA Phenology Auxiliary Site 259
    W -122.24995338, E -122.24995338, N 44.20416152, S 44.20416152
    Altitude: 603 to 603 meter
  • HJA Phenology Auxiliary Site 260
    W -122.24824684, E -122.24824684, N 44.20198189, S 44.20198189
    Altitude: 682 to 682 meter
  • HJA Phenology Core Bird Site 264
    W -122.16411823, E -122.16411823, N 44.27484767, S 44.27484767
    Altitude: 1216 to 1216 meter
  • HJA Phenology Auxiliary Site 265
    W -122.16061448, E -122.16061448, N 44.27362457, S 44.27362457
    Altitude: 1250 to 1250 meter
  • HJA Phenology Auxiliary Site 266
    W -122.15740420, E -122.15740420, N 44.27204341, S 44.27204341
    Altitude: 1250 to 1250 meter
  • HJA Phenology Core Bird Site 267
    W -122.15392595, E -122.15392595, N 44.27081129, S 44.27081129
    Altitude: 1244 to 1244 meter
  • HJA Phenology Core Bird Site 268
    W -122.14962071, E -122.14962071, N 44.27132851, S 44.27132851
    Altitude: 1260 to 1260 meter
  • HJA Phenology Core Bird Site 269
    W -122.14589003, E -122.14589003, N 44.27110260, S 44.27110260
    Altitude: 1231 to 1231 meter
  • HJA Phenology Auxiliary Site 270
    W -122.13785390, E -122.13785390, N 44.27776467, S 44.27776467
    Altitude: 1398 to 1398 meter
  • HJA Phenology Core Bird Site 271
    W -122.14144647, E -122.14144647, N 44.27815971, S 44.27815971
    Altitude: 1448 to 1448 meter
  • HJA Phenology Auxiliary Site 272
    W -122.14476990, E -122.14476990, N 44.27930040, S 44.27930040
    Altitude: 1502 to 1502 meter
  • HJA Phenology Auxiliary Site 273
    W -122.14615325, E -122.14615325, N 44.28199677, S 44.28199677
  • HJA Phenology Auxiliary Site 274
    W -122.14866715, E -122.14866715, N 44.27851879, S 44.27851879
    Altitude: 1471 to 1471 meter
  • HJA Phenology Auxiliary Site 275
    W -122.15129102, E -122.15129102, N 44.27656203, S 44.27656203
    Altitude: 1428 to 1428 meter
  • HJA Phenology Auxiliary Site 276
    W -122.15495315, E -122.15495315, N 44.27712371, S 44.27712371
    Altitude: 1398 to 1398 meter
  • HJA Phenology Auxiliary Site 277
    W -122.15853248, E -122.15853248, N 44.27650446, S 44.27650446
    Altitude: 1389 to 1389 meter
  • HJA Phenology Core Bird Site 278
    W -122.16209688, E -122.16209688, N 44.27607606, S 44.27607606
    Altitude: 1352 to 1352 meter
  • HJA Phenology Auxiliary Site 279
    W -122.16569196, E -122.16569196, N 44.27696664, S 44.27696664
    Altitude: 1307 to 1307 meter
  • HJA Phenology Core Bird Site 302
    W -122.20590310, E -122.20590310, N 44.23801710, S 44.23801710
    Altitude: 640 to 640 meter
  • HJA Phenology Auxiliary Site 303
    W -122.20256099, E -122.20256099, N 44.24068575, S 44.24068575
    Altitude: 630 to 630 meter
  • HJA Phenology Auxiliary Site 304
    W -122.20011912, E -122.20011912, N 44.24344163, S 44.24344163
    Altitude: 686 to 686 meter
  • HJA Phenology Auxiliary Site 305
    W -122.19360859, E -122.19360859, N 44.24696108, S 44.24696108
    Altitude: 670 to 670 meter
  • HJA Phenology Auxiliary Site 306
    W -122.18801502, E -122.18801502, N 44.25023459, S 44.25023459
    Altitude: 700 to 700 meter
  • HJA Phenology Auxiliary Site 307
    W -122.18451223, E -122.18451223, N 44.25173116, S 44.25173116
    Altitude: 787 to 787 meter
  • HJA Phenology Auxiliary Site 308
    W -122.18151758, E -122.18151758, N 44.25450970, S 44.25450970
    Altitude: 794 to 794 meter
  • HJA Phenology Auxiliary Site 309
    W -122.17869061, E -122.17869061, N 44.25782055, S 44.25782055
    Altitude: 814 to 814 meter
  • HJA Phenology Auxiliary Site 310
    W -122.17268546, E -122.17268546, N 44.25636373, S 44.25636373
    Altitude: 854 to 854 meter
  • HJA Phenology Auxiliary Site 311
    W -122.17510618, E -122.17510618, N 44.25793877, S 44.25793877
    Altitude: 876 to 876 meter
  • HJA Phenology Auxiliary Site 312
    W -122.17044980, E -122.17044980, N 44.26212749, S 44.26212749
    Altitude: 910 to 910 meter
  • HJA Phenology Auxiliary Site 314
    W -122.17727093, E -122.17727093, N 44.26170867, S 44.26170867
    Altitude: 860 to 860 meter
  • HJA Phenology Auxiliary Site 315
    W -122.18469591, E -122.18469591, N 44.26291430, S 44.26291430
    Altitude: 959 to 959 meter
  • HJA Phenology Core Bird Site 316
    W -122.17982994, E -122.17982994, N 44.26597652, S 44.26597652
    Altitude: 1011 to 1011 meter
  • HJA Phenology Auxiliary Site 317
    W -122.17408126, E -122.17408126, N 44.26582706, S 44.26582706
    Altitude: 950 to 950 meter
  • HJA Phenology Auxiliary Site 318
    W -122.19375573, E -122.19375573, N 44.23802204, S 44.23802204
    Altitude: 680 to 680 meter
  • HJA Phenology Auxiliary Site 322
    W -122.18106782, E -122.18106782, N 44.23185468, S 44.23185468
    Altitude: 669 to 669 meter
  • HJA Phenology Auxiliary Site 323
    W -122.19554595, E -122.19554595, N 44.23530672, S 44.23530672
    Altitude: 630 to 630 meter
  • HJA Phenology Auxiliary Site 324
    W -122.18725790, E -122.18725790, N 44.23426671, S 44.23426671
    Altitude: 659 to 659 meter
  • HJA Phenology Core Bird Site 325
    W -122.20212813, E -122.20212813, N 44.23286802, S 44.23286802
    Altitude: 567 to 567 meter
  • HJA Phenology Core Bird Site 326
    W -122.17388412, E -122.17388412, N 44.23158688, S 44.23158688
    Altitude: 687 to 687 meter
  • HJA Phenology Auxiliary Site 327
    W -122.14188260, E -122.14188260, N 44.23305255, S 44.23305255
    Altitude: 864 to 864 meter
  • HJA Phenology Auxiliary Site 328
    W -122.12868698, E -122.12868698, N 44.23203434, S 44.23203434
    Altitude: 999 to 999 meter
  • HJA Phenology Auxiliary Site 329
    W -122.11662204, E -122.11662204, N 44.22493725, S 44.22493725
    Altitude: 1049 to 1049 meter
  • HJA Phenology Auxiliary Site 330
    W -122.11587691, E -122.11587691, N 44.21951160, S 44.21951160
    Altitude: 1060 to 1060 meter
  • HJA Phenology Core Bird Site 331
    W -122.11333291, E -122.11333291, N 44.21439431, S 44.21439431
    Altitude: 1129 to 1129 meter
  • HJA Phenology Core Bird Site 332
    W -122.11159208, E -122.11159208, N 44.20891799, S 44.20891799
    Altitude: 1205 to 1205 meter
  • HJA Phenology Core Bird Site 333
    W -122.11738455, E -122.11738455, N 44.20863770, S 44.20863770
    Altitude: 1244 to 1244 meter
  • HJA Phenology Auxiliary Site 334
    W -122.23184447, E -122.23184447, N 44.22405959, S 44.22405959
    Altitude: 528 to 528 meter
  • HJA Phenology Core Bird Site 335
    W -122.22884575, E -122.22884575, N 44.22647023, S 44.22647023
    Altitude: 576 to 576 meter
  • HJA Phenology Auxiliary Site 336
    W -122.22658094, E -122.22658094, N 44.22253856, S 44.22253856
    Altitude: 637 to 637 meter
  • HJA Phenology Core Bird Site 337
    W -122.23116339, E -122.23116339, N 44.21963447, S 44.21963447
    Altitude: 729 to 729 meter
  • HJA Phenology Auxiliary Site 338
    W -122.23268869, E -122.23268869, N 44.21689877, S 44.21689877
    Altitude: 765 to 765 meter
  • HJA Phenology Auxiliary Site 339
    W -122.23220074, E -122.23220074, N 44.21398748, S 44.21398748
    Altitude: 744 to 744 meter
  • HJA Phenology Auxiliary Site 340
    W -122.22161662, E -122.22161662, N 44.22018203, S 44.22018203
    Altitude: 719 to 719 meter
  • HJA Phenology Auxiliary Site 341
    W -122.22043428, E -122.22043428, N 44.21680679, S 44.21680679
    Altitude: 788 to 788 meter
  • HJA Phenology Auxiliary Site 342
    W -122.21461923, E -122.21461923, N 44.21823447, S 44.21823447
    Altitude: 839 to 839 meter
  • HJA Phenology Core Bird Site 343
    W -122.21143304, E -122.21143304, N 44.21965303, S 44.21965303
    Altitude: 888 to 888 meter
  • HJA Phenology Auxiliary Site 344
    W -122.20517827, E -122.20517827, N 44.21836724, S 44.21836724
    Altitude: 936 to 936 meter
  • HJA Phenology Auxiliary Site 345
    W -122.20872600, E -122.20872600, N 44.21613209, S 44.21613209
    Altitude: 1044 to 1044 meter
  • HJA Phenology Core Bird Site 346
    W -122.20334566, E -122.20334566, N 44.21501431, S 44.21501431
    Altitude: 1094 to 1094 meter
  • HJA Phenology Auxiliary Site 347
    W -122.23514949, E -122.23514949, N 44.21247672, S 44.21247672
    Altitude: 748 to 748 meter
  • HJA Phenology Auxiliary Site 348
    W -122.22177685, E -122.22177685, N 44.22702550, S 44.22702550
    Altitude: 556 to 556 meter
  • HJA Phenology Auxiliary Site 349
    W -122.21430888, E -122.21430888, N 44.22933320, S 44.22933320
    Altitude: 569 to 569 meter
  • HJA Phenology Auxiliary Site 350
    W -122.22555511, E -122.22555511, N 44.21669987, S 44.21669987
    Altitude: 831 to 831 meter
  • HJA Phenology Auxiliary Site 351
    W -122.22303138, E -122.22303138, N 44.21351133, S 44.21351133
    Altitude: 889 to 889 meter
  • HJA Phenology Auxiliary Site 352
    W -122.20844874, E -122.20844874, N 44.23121941, S 44.23121941
    Altitude: 576 to 576 meter
  • HJA Phenology Auxiliary Site 353
    W -122.22913728, E -122.22913728, N 44.21180609, S 44.21180609
    Altitude: 852 to 852 meter
  • HJA Phenology Auxiliary Site 354
    W -122.22781328, E -122.22781328, N 44.21446208, S 44.21446208
    Altitude: 844 to 844 meter
  • HJA Phenology Core Bird Site 356
    W -122.21909018, E -122.21909018, N 44.21336742, S 44.21336742
    Altitude: 886 to 886 meter
  • HJA Phenology Core Bird Site 357
    W -122.21537967, E -122.21537967, N 44.21281981, S 44.21281981
    Altitude: 873 to 873 meter
  • HJA Phenology Core Bird Site 358
    W -122.11538376, E -122.11538376, N 44.20562494, S 44.20562494
    Altitude: 1310 to 1310 meter
  • HJA Phenology Auxiliary Site 400
    W -122.15315441, E -122.15315441, N 44.20882554, S 44.20882554
    Altitude: 1055 to 1055 meter
  • HJA Phenology Core Site 001 (WS01)
    W -122.25715110, E -122.25715110, N 44.20664191, S 44.20664191
    Altitude: 459 to 459 meter
  • HJA Phenology Core Site 002 (CS2MET/RS07)
    W -122.24967644, E -122.24967644, N 44.21401836, S 44.21401836
    Altitude: 488 to 488 meter
  • HJA Phenology Core Site 004 (RS89)
    W -122.26077333, E -122.26077333, N 44.21742613, S 44.21742613
    Altitude: 481 to 481 meter
  • HJA Phenology Core Site 005 (RS86)
    W -122.25780000, E -122.25780000, N 44.21950000, S 44.21950000
    Altitude: 643 to 643 meter
  • HJA Phenology Auxiliary Site 506
    W -122.25051899, E -122.25051899, N 44.22147141, S 44.22147141
    Altitude: 682 to 682 meter
  • HJA Phenology Core Site 007 (RS05)
    W -122.20252664, E -122.20252664, N 44.22218859, S 44.22218859
    Altitude: 903 to 903 meter
  • HJA Phenology Core Site 008 (RS32)
    W -122.19113780, E -122.19113780, N 44.23530330, S 44.23530330
    Altitude: 647 to 647 meter
  • HJA Phenology Core Site 009 (RS12)
    W -122.12174888, E -122.12174888, N 44.22717245, S 44.22717245
    Altitude: 979 to 979 meter
  • HJA Phenology Core Site 010 (Decomp site 5/CENMET)
    W -122.14276865, E -122.14276865, N 44.24209415, S 44.24209415
    Altitude: 994 to 994 meter
  • HJA Phenology Core Site 011 (L303/371 RD 350)
    W -122.15130105, E -122.15130105, N 44.25067222, S 44.25067222
    Altitude: 1116 to 1116 meter
  • HJA Phenology Core Site 012 (RS18)
    W -122.15895568, E -122.15895568, N 44.24627228, S 44.24627228
    Altitude: 1081 to 1081 meter
  • HJA Phenology Core Site 013 (RS21)
    W -122.13622203, E -122.13622203, N 44.24924626, S 44.24924626
    Altitude: 1178 to 1178 meter
  • HJA Phenology Core Site 014 (RS03)
    W -122.15925000, E -122.15925000, N 44.25911944, S 44.25911944
    Altitude: 965 to 965 meter
  • HJA Phenology Core Site 015 (WS08)
    W -122.17020059, E -122.17020059, N 44.26621172, S 44.26621172
    Altitude: 971 to 971 meter
  • HJA Phenology Core Site 016 (NADP/WS07)
    W -122.17786922, E -122.17786922, N 44.26749545, S 44.26749545
    Altitude: 1030 to 1030 meter
  • HJA Phenology Core Site 017 (RS04)
    W -122.13697290, E -122.13697290, N 44.27312824, S 44.27312824
    Altitude: 1302 to 1302 meter
  • HJA Phenology Core Site 018 (L306 RD 350)
    W -122.13525278, E -122.13525278, N 44.27447074, S 44.27447074
    Altitude: 1334 to 1334 meter
  • United States
    W -124.73634200, E -66.94539200, N 49.38280800, S 24.52120800
  • Andrews Experimental Forest (HJA)
    W -122.26172200, E -122.10084700, N 44.28196400, S 44.19770400
    Altitude: 1631 to 1631 meter
  • HJA Phenology Sites
    W -122.26083000, E -122.11159208, N 44.28199677, S 44.20198189
    Altitude: 1314 to 1314 meter
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: phenology (theme), microclimate (theme), air temperature (theme)
Taxonomic Hierarchy

No taxonomic hierarchy listed in this EML file.

Data Entities
# Entity Metadata Data
1 MS04501
Daily air temperature for phenology core sites
Derived from flagged output from WaTer.Py program with additional rigorous manual QA/QC
 METADATA DATA
2 MS04502
Hourly air temperature for phenology core sites
Derived from flagged output from WaTer.Py program with additional rigorous manual QA/QC
 METADATA DATA
3 MS04503
Daily air temperature for phenology core bird and auxiliary sites
Derived from filled output from WaTer.Py program
 METADATA DATA
4 MS04504
Hourly air temperature for phenology core bird and auxiliary sites
Derived from filled output from WaTer.Py program
 METADATA DATA
5 MS04505
Fine temporal resolution temperature and light intensity data for core, bird and auxiliary sites (Process A)
Raw data that has been flagged with the hja_hobo_clean Python program
 METADATA DATA
6 MS04506
Fine temporal resolution temperature and light intensity data for core, bird and auxiliary sites (Process B)
Raw data that has been flagged using defined QA_flag_definition criteria through GCE toolbox workflow
 METADATA DATA
Metadata
MS04501 - Daily air temperature for phenology core sites

Object name: MS04501_v1.csv

Records: 40557

Attributes: 13

Temporal coverage: 2008-10-01 to 2015-09-21

File size: 2381540 byte

Checksum (MD5): e1063e814d84371636e52eef7599ad18

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

Constraints (2)
  • primaryKey: PRIMARY
    MS04501.SITECODE, MS04501.DATE
  • notNullConstraint: NOTNULL
    MS04501.DBCODE, MS04501.ENTITY, MS04501.SITECODE, MS04501.SITETYPE, MS04501.DATE, MS04501.AIRTEMP_MEAN_FLAG, MS04501.AIRTEMP_MAX_FLAG, MS04501.AIRTEMP_MIN_FLAG, MS04501.REGRESSION_SITE, MS04501.QC_LEVEL
Attributes (13)
DBCODE - char(5) (nominal)

ID: MS04501.DBCODE

FSDB database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • MS045
    FSDB database code
ENTITY - numeric(2,0) (interval)

ID: MS04501.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1

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

SITECODE - char(5) (nominal)

ID: MS04501.SITECODE

Site code for the phenology measurement location

Type system: Microsoft SQL Server 2019

Code definitions (184)
  • PC001
    HJA Phenology Core Site 001 (WS01)
  • PC002
    HJA Phenology Core Site 002 (CS2MET/RS07)
  • PC004
    HJA Phenology Core Site 004 (RS89)
  • PC005
    HJA Phenology Core Site 005 (RS86)
  • PC007
    HJA Phenology Core Site 007 (RS05)
  • PC008
    HJA Phenology Core Site 008 (RS32)
  • PC009
    HJA Phenology Core Site 009 (RS12)
  • PC010
    HJA Phenology Core Site 010 (Decomp site 5/CENMET)
  • PC011
    HJA Phenology Core Site 011 (L303/371 RD 350)
  • PC012
    HJA Phenology Core Site 012 (RS18)
  • PC013
    HJA Phenology Core Site 013 (RS21)
  • PC014
    HJA Phenology Core Site 014 (RS03)
  • PC015
    HJA Phenology Core Site 015 (WS08)
  • PC016
    HJA Phenology Core Site 016 (NADP/WS07)
  • PC017
    HJA Phenology Core Site 017 (RS04)
  • PC018
    HJA Phenology Core Site 018 (L306 RD 350)
  • PA002
    HJA Phenology Auxiliary Site 002
  • PA003
    HJA Phenology Auxiliary Site 003
  • PA004
    HJA Phenology Auxiliary Site 004
  • PA005
    HJA Phenology Auxiliary Site 005
  • PA006
    HJA Phenology Auxiliary Site 006
  • PA009
    HJA Phenology Auxiliary Site 009
  • PA010
    HJA Phenology Auxiliary Site 010
  • PA011
    HJA Phenology Auxiliary Site 011
  • PA012
    HJA Phenology Auxiliary Site 012
  • PA013
    HJA Phenology Auxiliary Site 013
  • PA016
    HJA Phenology Auxiliary Site 016
  • PA017
    HJA Phenology Auxiliary Site 017
  • PA018
    HJA Phenology Auxiliary Site 018
  • PA019
    HJA Phenology Auxiliary Site 019
  • PA020
    HJA Phenology Auxiliary Site 020
  • PA021
    HJA Phenology Auxiliary Site 021
  • PA023
    HJA Phenology Auxiliary Site 023
  • PA027
    HJA Phenology Auxiliary Site 027
  • PA028
    HJA Phenology Auxiliary Site 028
  • PA029
    HJA Phenology Auxiliary Site 029
  • PA031
    HJA Phenology Auxiliary Site 031
  • PA032
    HJA Phenology Auxiliary Site 032
  • PA036
    HJA Phenology Auxiliary Site 036
  • PA037
    HJA Phenology Auxiliary Site 037
  • PA038
    HJA Phenology Auxiliary Site 038
  • PA039
    HJA Phenology Auxiliary Site 039
  • PA040
    HJA Phenology Auxiliary Site 040
  • PA041
    HJA Phenology Auxiliary Site 041
  • PA042
    HJA Phenology Auxiliary Site 042
  • PA044
    HJA Phenology Auxiliary Site 044
  • PA045
    HJA Phenology Auxiliary Site 045
  • PA048
    HJA Phenology Auxiliary Site 048
  • PA051
    HJA Phenology Auxiliary Site 051
  • PA053
    HJA Phenology Auxiliary Site 053
  • PA054
    HJA Phenology Auxiliary Site 054
  • PA059
    HJA Phenology Auxiliary Site 059
  • PA062
    HJA Phenology Auxiliary Site 062
  • PA063
    HJA Phenology Auxiliary Site 063
  • PA064
    HJA Phenology Auxiliary Site 064
  • PA065
    HJA Phenology Auxiliary Site 065
  • PA066
    HJA Phenology Auxiliary Site 066
  • PA076
    HJA Phenology Auxiliary Site 076
  • PA077
    HJA Phenology Auxiliary Site 077
  • PA078
    HJA Phenology Auxiliary Site 078
  • PA079
    HJA Phenology Auxiliary Site 079
  • PA080
    HJA Phenology Auxiliary Site 080
  • PA081
    HJA Phenology Auxiliary Site 081
  • PA200
    HJA Phenology Auxiliary Site 200
  • PA203
    HJA Phenology Auxiliary Site 203
  • PA204
    HJA Phenology Auxiliary Site 204
  • PA207
    HJA Phenology Auxiliary Site 207
  • PA208
    HJA Phenology Auxiliary Site 208
  • PA209
    HJA Phenology Auxiliary Site 209
  • PA210
    HJA Phenology Auxiliary Site 210
  • PA211
    HJA Phenology Auxiliary Site 211
  • PA217
    HJA Phenology Auxiliary Site 217
  • PA224
    HJA Phenology Auxiliary Site 224
  • PA226
    HJA Phenology Auxiliary Site 226
  • PA233
    HJA Phenology Auxiliary Site 233
  • PA234
    HJA Phenology Auxiliary Site 234
  • PA235
    HJA Phenology Auxiliary Site 235
  • PA239
    HJA Phenology Auxiliary Site 239
  • PA240
    HJA Phenology Auxiliary Site 240
  • PA241
    HJA Phenology Auxiliary Site 241
  • PA243
    HJA Phenology Auxiliary Site 243
  • PA245
    HJA Phenology Auxiliary Site 245
  • PA246
    HJA Phenology Auxiliary Site 246
  • PA247
    HJA Phenology Auxiliary Site 247
  • PA248
    HJA Phenology Auxiliary Site 248
  • PA249
    HJA Phenology Auxiliary Site 249
  • PA250
    HJA Phenology Auxiliary Site 250
  • PA252
    HJA Phenology Auxiliary Site 252
  • PA253
    HJA Phenology Auxiliary Site 253
  • PA256
    HJA Phenology Auxiliary Site 256
  • PA257
    HJA Phenology Auxiliary Site 257
  • PA258
    HJA Phenology Auxiliary Site 258
  • PA259
    HJA Phenology Auxiliary Site 259
  • PA260
    HJA Phenology Auxiliary Site 260
  • PA265
    HJA Phenology Auxiliary Site 265
  • PA266
    HJA Phenology Auxiliary Site 266
  • PA270
    HJA Phenology Auxiliary Site 270
  • PA272
    HJA Phenology Auxiliary Site 272
  • PA273
    HJA Phenology Auxiliary Site 273
  • PA274
    HJA Phenology Auxiliary Site 274
  • PA275
    HJA Phenology Auxiliary Site 275
  • PA276
    HJA Phenology Auxiliary Site 276
  • PA277
    HJA Phenology Auxiliary Site 277
  • PA279
    HJA Phenology Auxiliary Site 279
  • PA303
    HJA Phenology Auxiliary Site 303
  • PA304
    HJA Phenology Auxiliary Site 304
  • PA305
    HJA Phenology Auxiliary Site 305
  • PA306
    HJA Phenology Auxiliary Site 306
  • PA307
    HJA Phenology Auxiliary Site 307
  • PA308
    HJA Phenology Auxiliary Site 308
  • PA309
    HJA Phenology Auxiliary Site 309
  • PA310
    HJA Phenology Auxiliary Site 310
  • PA311
    HJA Phenology Auxiliary Site 311
  • PA312
    HJA Phenology Auxiliary Site 312
  • PA314
    HJA Phenology Auxiliary Site 314
  • PA315
    HJA Phenology Auxiliary Site 315
  • PA317
    HJA Phenology Auxiliary Site 317
  • PA318
    HJA Phenology Auxiliary Site 318
  • PA322
    HJA Phenology Auxiliary Site 322
  • PA323
    HJA Phenology Auxiliary Site 323
  • PA324
    HJA Phenology Auxiliary Site 324
  • PA327
    HJA Phenology Auxiliary Site 327
  • PA328
    HJA Phenology Auxiliary Site 328
  • PA329
    HJA Phenology Auxiliary Site 329
  • PA330
    HJA Phenology Auxiliary Site 330
  • PA334
    HJA Phenology Auxiliary Site 334
  • PA336
    HJA Phenology Auxiliary Site 336
  • PA338
    HJA Phenology Auxiliary Site 338
  • PA339
    HJA Phenology Auxiliary Site 339
  • PA340
    HJA Phenology Auxiliary Site 340
  • PA341
    HJA Phenology Auxiliary Site 341
  • PA342
    HJA Phenology Auxiliary Site 342
  • PA344
    HJA Phenology Auxiliary Site 344
  • PA345
    HJA Phenology Auxiliary Site 345
  • PA347
    HJA Phenology Auxiliary Site 347
  • PA348
    HJA Phenology Auxiliary Site 348
  • PA349
    HJA Phenology Auxiliary Site 349
  • PA350
    HJA Phenology Auxiliary Site 350
  • PA351
    HJA Phenology Auxiliary Site 351
  • PA352
    HJA Phenology Auxiliary Site 352
  • PA353
    HJA Phenology Auxiliary Site 353
  • PA354
    HJA Phenology Auxiliary Site 354
  • PA400
    HJA Phenology Auxiliary Site 400
  • PA506
    HJA Phenology Auxiliary Site 506
  • PB008
    HJA Phenology Core Bird Site 008
  • PB014
    HJA Phenology Core Bird Site 014
  • PB022
    HJA Phenology Core Bird Site 022
  • PB030
    HJA Phenology Core Bird Site 030
  • PB046
    HJA Phenology Core Bird Site 046
  • PB047
    HJA Phenology Core Bird Site 047
  • PB052
    HJA Phenology Core Bird Site 052
  • PB055
    HJA Phenology Core Bird Site 055
  • PB060
    HJA Phenology Core Bird Site 060
  • PB067
    HJA Phenology Core Bird Site 067
  • PB201
    HJA Phenology Core Bird Site 201
  • PB202
    HJA Phenology Core Bird Site 202
  • PB206
    HJA Phenology Core Bird Site 206
  • PB216
    HJA Phenology Core Bird Site 216
  • PB225
    HJA Phenology Core Bird Site 225
  • PB242
    HJA Phenology Core Bird Site 242
  • PB244
    HJA Phenology Core Bird Site 244
  • PB251
    HJA Phenology Core Bird Site 251
  • PB254
    HJA Phenology Core Bird Site 254
  • PB255
    HJA Phenology Core Bird Site 255
  • PB264
    HJA Phenology Core Bird Site 264
  • PB267
    HJA Phenology Core Bird Site 267
  • PB268
    HJA Phenology Core Bird Site 268
  • PB269
    HJA Phenology Core Bird Site 269
  • PB271
    HJA Phenology Core Bird Site 271
  • PB278
    HJA Phenology Core Bird Site 278
  • PB302
    HJA Phenology Core Bird Site 302
  • PB316
    HJA Phenology Core Bird Site 316
  • PB325
    HJA Phenology Core Bird Site 325
  • PB326
    HJA Phenology Core Bird Site 326
  • PB331
    HJA Phenology Core Bird Site 331
  • PB332
    HJA Phenology Core Bird Site 332
  • PB333
    HJA Phenology Core Bird Site 333
  • PB335
    HJA Phenology Core Bird Site 335
  • PB337
    HJA Phenology Core Bird Site 337
  • PB343
    HJA Phenology Core Bird Site 343
  • PB346
    HJA Phenology Core Bird Site 346
  • PB356
    HJA Phenology Core Bird Site 356
  • PB357
    HJA Phenology Core Bird Site 357
  • PB358
    HJA Phenology Core Bird Site 358
SITETYPE - char(2) (nominal)

ID: MS04501.SITETYPE

Type of measurement site: core phenology, core bird or auxiliary site

Type system: Microsoft SQL Server 2019

Code definitions (3)
  • PC
    Core phenology site
  • PB
    Core phenology bird site
  • PA
    Core phenology auxiliary site
QC_LEVEL - char(2) (nominal)

ID: MS04501.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 - date (dateTime)

ID: MS04501.DATE

Date of collection

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

AIRTEMP_MEAN_DAY - numeric(5,1) (interval)

ID: MS04501.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=-15.8000 (exclusive=false), max=28.3000 (exclusive=false)

AIRTEMP_MEAN_FLAG - char(1) (nominal)

ID: MS04501.AIRTEMP_MEAN_FLAG

Mean air temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (4)
  • A
    Accepted value
  • E
    Estimated value
  • M
    Missing value
  • Q
    Questionable value
AIRTEMP_MAX_DAY - numeric(5,1) (interval)

ID: MS04501.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=-14.5000 (exclusive=false), max=44.3000 (exclusive=false)

AIRTEMP_MAX_FLAG - char(1) (nominal)

ID: MS04501.AIRTEMP_MAX_FLAG

Maximum air temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (4)
  • A
    Accepted value
  • E
    Estimated value
  • M
    Missing value
  • Q
    Questionable value
AIRTEMP_MIN_DAY - numeric(5,1) (interval)

ID: MS04501.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=-17.2000 (exclusive=false), max=24.1000 (exclusive=false)

AIRTEMP_MIN_FLAG - char(1) (nominal)

ID: MS04501.AIRTEMP_MIN_FLAG

Minimum air temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (4)
  • A
    Accepted value
  • E
    Estimated value
  • M
    Missing value
  • Q
    Questionable value
REGRESSION_SITE - char(6) (nominal)

ID: MS04501.REGRESSION_SITE

Reference site used to estimate values using linear regression

Type system: Microsoft SQL Server 2019

Code definitions (183)
  • RS38__
    Reference Stand RS38, H.J. Andrews EF, Willamette NF
  • CENMET
    Central Meteorological Station
  • UPLMET
    Upper Lookout Meteorological Station
  • VANMET
    Vanilla Leaf Meteorological Station
  • CS2MET
    Climatic Station at Watershed 2
  • H15MET
    High 15 Meteorological Station
  • RS02__
    Reference Stand RS02 air/soil temperature site
  • RS04__
    Reference Stand RS04 air/soil temperature site
  • RS05__
    Reference Stand RS05 air/soil temperature site
  • RS10__
    Reference Stand RS10 air/soil temperature site
  • RS12__
    Reference Stand RS12 air/soil temperature site
  • RS20__
    Reference Stand RS20 air/soil temperature site
  • RS26__
    Reference Stand RS26 air/soil temperature site
  • RS86__
    Reference Stand RS86 air/soil temperature and relative humidity site
  • RS89__
    Reference Stand RS89 air/soil temperature and relative humidity site
  • PC001
    HJA Phenology Core Site 001 (WS01)
  • PC002
    HJA Phenology Core Site 002 (CS2MET/RS07)
  • PC004
    HJA Phenology Core Site 004 (RS89)
  • PC007
    HJA Phenology Core Site 007 (RS05)
  • PC008
    HJA Phenology Core Site 008 (RS32)
  • PC009
    HJA Phenology Core Site 009 (RS12)
  • PC010
    HJA Phenology Core Site 010 (Decomp site 5/CENMET)
  • PC011
    HJA Phenology Core Site 011 (L303/371 RD 350)
  • PC012
    HJA Phenology Core Site 012 (RS18)
  • PC013
    HJA Phenology Core Site 013 (RS21)
  • PC014
    HJA Phenology Core Site 014 (RS03)
  • PC015
    HJA Phenology Core Site 015 (WS08)
  • PC017
    HJA Phenology Core Site 017 (RS04)
  • PA002
    HJA Phenology Auxiliary Site 002
  • PA004
    HJA Phenology Auxiliary Site 004
  • PA005
    HJA Phenology Auxiliary Site 005
  • PA006
    HJA Phenology Auxiliary Site 006
  • PA009
    HJA Phenology Auxiliary Site 009
  • PA010
    HJA Phenology Auxiliary Site 010
  • PA011
    HJA Phenology Auxiliary Site 011
  • PA012
    HJA Phenology Auxiliary Site 012
  • PA013
    HJA Phenology Auxiliary Site 013
  • PA017
    HJA Phenology Auxiliary Site 017
  • PA019
    HJA Phenology Auxiliary Site 019
  • PA020
    HJA Phenology Auxiliary Site 020
  • PA021
    HJA Phenology Auxiliary Site 021
  • PA023
    HJA Phenology Auxiliary Site 023
  • PA027
    HJA Phenology Auxiliary Site 027
  • PA028
    HJA Phenology Auxiliary Site 028
  • PA031
    HJA Phenology Auxiliary Site 031
  • PA032
    HJA Phenology Auxiliary Site 032
  • PA036
    HJA Phenology Auxiliary Site 036
  • PA037
    HJA Phenology Auxiliary Site 037
  • PA038
    HJA Phenology Auxiliary Site 038
  • PA039
    HJA Phenology Auxiliary Site 039
  • PA040
    HJA Phenology Auxiliary Site 040
  • PA042
    HJA Phenology Auxiliary Site 042
  • PA045
    HJA Phenology Auxiliary Site 045
  • PA048
    HJA Phenology Auxiliary Site 048
  • PA051
    HJA Phenology Auxiliary Site 051
  • PA053
    HJA Phenology Auxiliary Site 053
  • PA054
    HJA Phenology Auxiliary Site 054
  • PA059
    HJA Phenology Auxiliary Site 059
  • PA062
    HJA Phenology Auxiliary Site 062
  • PA063
    HJA Phenology Auxiliary Site 063
  • PA064
    HJA Phenology Auxiliary Site 064
  • PA065
    HJA Phenology Auxiliary Site 065
  • PA066
    HJA Phenology Auxiliary Site 066
  • PA076
    HJA Phenology Auxiliary Site 076
  • PA077
    HJA Phenology Auxiliary Site 077
  • PA078
    HJA Phenology Auxiliary Site 078
  • PA079
    HJA Phenology Auxiliary Site 079
  • PA080
    HJA Phenology Auxiliary Site 080
  • PA200
    HJA Phenology Auxiliary Site 200
  • PA203
    HJA Phenology Auxiliary Site 203
  • PA207
    HJA Phenology Auxiliary Site 207
  • PA208
    HJA Phenology Auxiliary Site 208
  • PA209
    HJA Phenology Auxiliary Site 209
  • PA210
    HJA Phenology Auxiliary Site 210
  • PA211
    HJA Phenology Auxiliary Site 211
  • PA217
    HJA Phenology Auxiliary Site 217
  • PA224
    HJA Phenology Auxiliary Site 224
  • PA226
    HJA Phenology Auxiliary Site 226
  • PA233
    HJA Phenology Auxiliary Site 233
  • PA234
    HJA Phenology Auxiliary Site 234
  • PA235
    HJA Phenology Auxiliary Site 235
  • PA239
    HJA Phenology Auxiliary Site 239
  • PA240
    HJA Phenology Auxiliary Site 240
  • PA241
    HJA Phenology Auxiliary Site 241
  • PA243
    HJA Phenology Auxiliary Site 243
  • PA245
    HJA Phenology Auxiliary Site 245
  • PA246
    HJA Phenology Auxiliary Site 246
  • PA247
    HJA Phenology Auxiliary Site 247
  • PA248
    HJA Phenology Auxiliary Site 248
  • PA249
    HJA Phenology Auxiliary Site 249
  • PA250
    HJA Phenology Auxiliary Site 250
  • PA252
    HJA Phenology Auxiliary Site 252
  • PA253
    HJA Phenology Auxiliary Site 253
  • PA256
    HJA Phenology Auxiliary Site 256
  • PA257
    HJA Phenology Auxiliary Site 257
  • PA258
    HJA Phenology Auxiliary Site 258
  • PA259
    HJA Phenology Auxiliary Site 259
  • PA260
    HJA Phenology Auxiliary Site 260
  • PA265
    HJA Phenology Auxiliary Site 265
  • PA270
    HJA Phenology Auxiliary Site 270
  • PA273
    HJA Phenology Auxiliary Site 273
  • PA274
    HJA Phenology Auxiliary Site 274
  • PA275
    HJA Phenology Auxiliary Site 275
  • PA276
    HJA Phenology Auxiliary Site 276
  • PA277
    HJA Phenology Auxiliary Site 277
  • PA279
    HJA Phenology Auxiliary Site 279
  • PA303
    HJA Phenology Auxiliary Site 303
  • PA304
    HJA Phenology Auxiliary Site 304
  • PA305
    HJA Phenology Auxiliary Site 305
  • PA306
    HJA Phenology Auxiliary Site 306
  • PA307
    HJA Phenology Auxiliary Site 307
  • PA308
    HJA Phenology Auxiliary Site 308
  • PA309
    HJA Phenology Auxiliary Site 309
  • PA310
    HJA Phenology Auxiliary Site 310
  • PA311
    HJA Phenology Auxiliary Site 311
  • PA312
    HJA Phenology Auxiliary Site 312
  • PA314
    HJA Phenology Auxiliary Site 314
  • PA317
    HJA Phenology Auxiliary Site 317
  • PA318
    HJA Phenology Auxiliary Site 318
  • PA322
    HJA Phenology Auxiliary Site 322
  • PA323
    HJA Phenology Auxiliary Site 323
  • PA324
    HJA Phenology Auxiliary Site 324
  • PA327
    HJA Phenology Auxiliary Site 327
  • PA328
    HJA Phenology Auxiliary Site 328
  • PA329
    HJA Phenology Auxiliary Site 329
  • PA330
    HJA Phenology Auxiliary Site 330
  • PA334
    HJA Phenology Auxiliary Site 334
  • PA336
    HJA Phenology Auxiliary Site 336
  • PA338
    HJA Phenology Auxiliary Site 338
  • PA339
    HJA Phenology Auxiliary Site 339
  • PA340
    HJA Phenology Auxiliary Site 340
  • PA341
    HJA Phenology Auxiliary Site 341
  • PA342
    HJA Phenology Auxiliary Site 342
  • PA344
    HJA Phenology Auxiliary Site 344
  • PA345
    HJA Phenology Auxiliary Site 345
  • PA347
    HJA Phenology Auxiliary Site 347
  • PA348
    HJA Phenology Auxiliary Site 348
  • PA349
    HJA Phenology Auxiliary Site 349
  • PA350
    HJA Phenology Auxiliary Site 350
  • PA351
    HJA Phenology Auxiliary Site 351
  • PA352
    HJA Phenology Auxiliary Site 352
  • PA353
    HJA Phenology Auxiliary Site 353
  • PA354
    HJA Phenology Auxiliary Site 354
  • PA400
    HJA Phenology Auxiliary Site 400
  • PA506
    HJA Phenology Auxiliary Site 506
  • PB008
    HJA Phenology Core Bird Site 008
  • PB022
    HJA Phenology Core Bird Site 022
  • PB030
    HJA Phenology Core Bird Site 030
  • PB046
    HJA Phenology Core Bird Site 046
  • PB047
    HJA Phenology Core Bird Site 047
  • PB052
    HJA Phenology Core Bird Site 052
  • PB055
    HJA Phenology Core Bird Site 055
  • PB067
    HJA Phenology Core Bird Site 067
  • PB201
    HJA Phenology Core Bird Site 201
  • PB202
    HJA Phenology Core Bird Site 202
  • PB206
    HJA Phenology Core Bird Site 206
  • PB216
    HJA Phenology Core Bird Site 216
  • PB225
    HJA Phenology Core Bird Site 225
  • PB242
    HJA Phenology Core Bird Site 242
  • PB244
    HJA Phenology Core Bird Site 244
  • PB251
    HJA Phenology Core Bird Site 251
  • PB254
    HJA Phenology Core Bird Site 254
  • PB255
    HJA Phenology Core Bird Site 255
  • PB264
    HJA Phenology Core Bird Site 264
  • PB267
    HJA Phenology Core Bird Site 267
  • PB268
    HJA Phenology Core Bird Site 268
  • PB269
    HJA Phenology Core Bird Site 269
  • PB271
    HJA Phenology Core Bird Site 271
  • PB278
    HJA Phenology Core Bird Site 278
  • PB302
    HJA Phenology Core Bird Site 302
  • PB316
    HJA Phenology Core Bird Site 316
  • PB325
    HJA Phenology Core Bird Site 325
  • PB331
    HJA Phenology Core Bird Site 331
  • PB332
    HJA Phenology Core Bird Site 332
  • PB333
    HJA Phenology Core Bird Site 333
  • PB335
    HJA Phenology Core Bird Site 335
  • PB337
    HJA Phenology Core Bird Site 337
  • PB343
    HJA Phenology Core Bird Site 343
  • PB346
    HJA Phenology Core Bird Site 346
  • PB356
    HJA Phenology Core Bird Site 356
  • PB357
    HJA Phenology Core Bird Site 357
  • PB358
    HJA Phenology Core Bird Site 358
  • None
    No estimation (actual data is used)
MS04502 - Hourly air temperature for phenology core sites

Object name: MS04502_v1.csv

Records: 973579

Attributes: 9

Temporal coverage: 2008-10-01 to 2015-09-22

File size: 53300883 byte

Checksum (MD5): a83309c6a4cf589af8f0a1ce7406628e

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

Constraints (2)
  • primaryKey: PRIMARY
    MS04502.SITECODE, MS04502.DATE_TIME
  • notNullConstraint: NOTNULL
    MS04502.DBCODE, MS04502.ENTITY, MS04502.SITECODE, MS04502.SITETYPE, MS04502.AIRTEMP_MEAN_FLAG, MS04502.REGRESSION_SITE, MS04502.DATE_TIME, MS04502.QC_LEVEL
Attributes (9)
DBCODE - char(5) (nominal)

ID: MS04502.DBCODE

FSDB database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • MS045
    FSDB database code
ENTITY - numeric(2,0) (interval)

ID: MS04502.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1

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

SITECODE - char(5) (nominal)

ID: MS04502.SITECODE

Site code for the phenology measurement location

Type system: Microsoft SQL Server 2019

Code definitions (184)
  • PC001
    HJA Phenology Core Site 001 (WS01)
  • PC002
    HJA Phenology Core Site 002 (CS2MET/RS07)
  • PC004
    HJA Phenology Core Site 004 (RS89)
  • PC005
    HJA Phenology Core Site 005 (RS86)
  • PC007
    HJA Phenology Core Site 007 (RS05)
  • PC008
    HJA Phenology Core Site 008 (RS32)
  • PC009
    HJA Phenology Core Site 009 (RS12)
  • PC010
    HJA Phenology Core Site 010 (Decomp site 5/CENMET)
  • PC011
    HJA Phenology Core Site 011 (L303/371 RD 350)
  • PC012
    HJA Phenology Core Site 012 (RS18)
  • PC013
    HJA Phenology Core Site 013 (RS21)
  • PC014
    HJA Phenology Core Site 014 (RS03)
  • PC015
    HJA Phenology Core Site 015 (WS08)
  • PC016
    HJA Phenology Core Site 016 (NADP/WS07)
  • PC017
    HJA Phenology Core Site 017 (RS04)
  • PC018
    HJA Phenology Core Site 018 (L306 RD 350)
  • PA002
    HJA Phenology Auxiliary Site 002
  • PA003
    HJA Phenology Auxiliary Site 003
  • PA004
    HJA Phenology Auxiliary Site 004
  • PA005
    HJA Phenology Auxiliary Site 005
  • PA006
    HJA Phenology Auxiliary Site 006
  • PA009
    HJA Phenology Auxiliary Site 009
  • PA010
    HJA Phenology Auxiliary Site 010
  • PA011
    HJA Phenology Auxiliary Site 011
  • PA012
    HJA Phenology Auxiliary Site 012
  • PA013
    HJA Phenology Auxiliary Site 013
  • PA016
    HJA Phenology Auxiliary Site 016
  • PA017
    HJA Phenology Auxiliary Site 017
  • PA018
    HJA Phenology Auxiliary Site 018
  • PA019
    HJA Phenology Auxiliary Site 019
  • PA020
    HJA Phenology Auxiliary Site 020
  • PA021
    HJA Phenology Auxiliary Site 021
  • PA023
    HJA Phenology Auxiliary Site 023
  • PA027
    HJA Phenology Auxiliary Site 027
  • PA028
    HJA Phenology Auxiliary Site 028
  • PA029
    HJA Phenology Auxiliary Site 029
  • PA031
    HJA Phenology Auxiliary Site 031
  • PA032
    HJA Phenology Auxiliary Site 032
  • PA036
    HJA Phenology Auxiliary Site 036
  • PA037
    HJA Phenology Auxiliary Site 037
  • PA038
    HJA Phenology Auxiliary Site 038
  • PA039
    HJA Phenology Auxiliary Site 039
  • PA040
    HJA Phenology Auxiliary Site 040
  • PA041
    HJA Phenology Auxiliary Site 041
  • PA042
    HJA Phenology Auxiliary Site 042
  • PA044
    HJA Phenology Auxiliary Site 044
  • PA045
    HJA Phenology Auxiliary Site 045
  • PA048
    HJA Phenology Auxiliary Site 048
  • PA051
    HJA Phenology Auxiliary Site 051
  • PA053
    HJA Phenology Auxiliary Site 053
  • PA054
    HJA Phenology Auxiliary Site 054
  • PA059
    HJA Phenology Auxiliary Site 059
  • PA062
    HJA Phenology Auxiliary Site 062
  • PA063
    HJA Phenology Auxiliary Site 063
  • PA064
    HJA Phenology Auxiliary Site 064
  • PA065
    HJA Phenology Auxiliary Site 065
  • PA066
    HJA Phenology Auxiliary Site 066
  • PA076
    HJA Phenology Auxiliary Site 076
  • PA077
    HJA Phenology Auxiliary Site 077
  • PA078
    HJA Phenology Auxiliary Site 078
  • PA079
    HJA Phenology Auxiliary Site 079
  • PA080
    HJA Phenology Auxiliary Site 080
  • PA081
    HJA Phenology Auxiliary Site 081
  • PA200
    HJA Phenology Auxiliary Site 200
  • PA203
    HJA Phenology Auxiliary Site 203
  • PA204
    HJA Phenology Auxiliary Site 204
  • PA207
    HJA Phenology Auxiliary Site 207
  • PA208
    HJA Phenology Auxiliary Site 208
  • PA209
    HJA Phenology Auxiliary Site 209
  • PA210
    HJA Phenology Auxiliary Site 210
  • PA211
    HJA Phenology Auxiliary Site 211
  • PA217
    HJA Phenology Auxiliary Site 217
  • PA224
    HJA Phenology Auxiliary Site 224
  • PA226
    HJA Phenology Auxiliary Site 226
  • PA233
    HJA Phenology Auxiliary Site 233
  • PA234
    HJA Phenology Auxiliary Site 234
  • PA235
    HJA Phenology Auxiliary Site 235
  • PA239
    HJA Phenology Auxiliary Site 239
  • PA240
    HJA Phenology Auxiliary Site 240
  • PA241
    HJA Phenology Auxiliary Site 241
  • PA243
    HJA Phenology Auxiliary Site 243
  • PA245
    HJA Phenology Auxiliary Site 245
  • PA246
    HJA Phenology Auxiliary Site 246
  • PA247
    HJA Phenology Auxiliary Site 247
  • PA248
    HJA Phenology Auxiliary Site 248
  • PA249
    HJA Phenology Auxiliary Site 249
  • PA250
    HJA Phenology Auxiliary Site 250
  • PA252
    HJA Phenology Auxiliary Site 252
  • PA253
    HJA Phenology Auxiliary Site 253
  • PA256
    HJA Phenology Auxiliary Site 256
  • PA257
    HJA Phenology Auxiliary Site 257
  • PA258
    HJA Phenology Auxiliary Site 258
  • PA259
    HJA Phenology Auxiliary Site 259
  • PA260
    HJA Phenology Auxiliary Site 260
  • PA265
    HJA Phenology Auxiliary Site 265
  • PA266
    HJA Phenology Auxiliary Site 266
  • PA270
    HJA Phenology Auxiliary Site 270
  • PA272
    HJA Phenology Auxiliary Site 272
  • PA273
    HJA Phenology Auxiliary Site 273
  • PA274
    HJA Phenology Auxiliary Site 274
  • PA275
    HJA Phenology Auxiliary Site 275
  • PA276
    HJA Phenology Auxiliary Site 276
  • PA277
    HJA Phenology Auxiliary Site 277
  • PA279
    HJA Phenology Auxiliary Site 279
  • PA303
    HJA Phenology Auxiliary Site 303
  • PA304
    HJA Phenology Auxiliary Site 304
  • PA305
    HJA Phenology Auxiliary Site 305
  • PA306
    HJA Phenology Auxiliary Site 306
  • PA307
    HJA Phenology Auxiliary Site 307
  • PA308
    HJA Phenology Auxiliary Site 308
  • PA309
    HJA Phenology Auxiliary Site 309
  • PA310
    HJA Phenology Auxiliary Site 310
  • PA311
    HJA Phenology Auxiliary Site 311
  • PA312
    HJA Phenology Auxiliary Site 312
  • PA314
    HJA Phenology Auxiliary Site 314
  • PA315
    HJA Phenology Auxiliary Site 315
  • PA317
    HJA Phenology Auxiliary Site 317
  • PA318
    HJA Phenology Auxiliary Site 318
  • PA322
    HJA Phenology Auxiliary Site 322
  • PA323
    HJA Phenology Auxiliary Site 323
  • PA324
    HJA Phenology Auxiliary Site 324
  • PA327
    HJA Phenology Auxiliary Site 327
  • PA328
    HJA Phenology Auxiliary Site 328
  • PA329
    HJA Phenology Auxiliary Site 329
  • PA330
    HJA Phenology Auxiliary Site 330
  • PA334
    HJA Phenology Auxiliary Site 334
  • PA336
    HJA Phenology Auxiliary Site 336
  • PA338
    HJA Phenology Auxiliary Site 338
  • PA339
    HJA Phenology Auxiliary Site 339
  • PA340
    HJA Phenology Auxiliary Site 340
  • PA341
    HJA Phenology Auxiliary Site 341
  • PA342
    HJA Phenology Auxiliary Site 342
  • PA344
    HJA Phenology Auxiliary Site 344
  • PA345
    HJA Phenology Auxiliary Site 345
  • PA347
    HJA Phenology Auxiliary Site 347
  • PA348
    HJA Phenology Auxiliary Site 348
  • PA349
    HJA Phenology Auxiliary Site 349
  • PA350
    HJA Phenology Auxiliary Site 350
  • PA351
    HJA Phenology Auxiliary Site 351
  • PA352
    HJA Phenology Auxiliary Site 352
  • PA353
    HJA Phenology Auxiliary Site 353
  • PA354
    HJA Phenology Auxiliary Site 354
  • PA400
    HJA Phenology Auxiliary Site 400
  • PA506
    HJA Phenology Auxiliary Site 506
  • PB008
    HJA Phenology Core Bird Site 008
  • PB014
    HJA Phenology Core Bird Site 014
  • PB022
    HJA Phenology Core Bird Site 022
  • PB030
    HJA Phenology Core Bird Site 030
  • PB046
    HJA Phenology Core Bird Site 046
  • PB047
    HJA Phenology Core Bird Site 047
  • PB052
    HJA Phenology Core Bird Site 052
  • PB055
    HJA Phenology Core Bird Site 055
  • PB060
    HJA Phenology Core Bird Site 060
  • PB067
    HJA Phenology Core Bird Site 067
  • PB201
    HJA Phenology Core Bird Site 201
  • PB202
    HJA Phenology Core Bird Site 202
  • PB206
    HJA Phenology Core Bird Site 206
  • PB216
    HJA Phenology Core Bird Site 216
  • PB225
    HJA Phenology Core Bird Site 225
  • PB242
    HJA Phenology Core Bird Site 242
  • PB244
    HJA Phenology Core Bird Site 244
  • PB251
    HJA Phenology Core Bird Site 251
  • PB254
    HJA Phenology Core Bird Site 254
  • PB255
    HJA Phenology Core Bird Site 255
  • PB264
    HJA Phenology Core Bird Site 264
  • PB267
    HJA Phenology Core Bird Site 267
  • PB268
    HJA Phenology Core Bird Site 268
  • PB269
    HJA Phenology Core Bird Site 269
  • PB271
    HJA Phenology Core Bird Site 271
  • PB278
    HJA Phenology Core Bird Site 278
  • PB302
    HJA Phenology Core Bird Site 302
  • PB316
    HJA Phenology Core Bird Site 316
  • PB325
    HJA Phenology Core Bird Site 325
  • PB326
    HJA Phenology Core Bird Site 326
  • PB331
    HJA Phenology Core Bird Site 331
  • PB332
    HJA Phenology Core Bird Site 332
  • PB333
    HJA Phenology Core Bird Site 333
  • PB335
    HJA Phenology Core Bird Site 335
  • PB337
    HJA Phenology Core Bird Site 337
  • PB343
    HJA Phenology Core Bird Site 343
  • PB346
    HJA Phenology Core Bird Site 346
  • PB356
    HJA Phenology Core Bird Site 356
  • PB357
    HJA Phenology Core Bird Site 357
  • PB358
    HJA Phenology Core Bird Site 358
SITETYPE - char(2) (nominal)

ID: MS04502.SITETYPE

Type of measurement site: core phenology, core bird or auxiliary site

Type system: Microsoft SQL Server 2019

Code definitions (3)
  • PC
    Core phenology site
  • PB
    Core phenology bird site
  • PA
    Core phenology auxiliary site
QC_LEVEL - char(2) (nominal)

ID: MS04502.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: MS04502.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_MEAN - numeric(5,1) (interval)

ID: MS04502.AIRTEMP_MEAN

Mean air temperature over the last hour

Type system: Microsoft SQL Server 2019

Unit: degrees Celsius

Precision: 0.100000

Numeric domain: type=real, min=-17.2000 (exclusive=false), max=44.3000 (exclusive=false)

AIRTEMP_MEAN_FLAG - char(1) (nominal)

ID: MS04502.AIRTEMP_MEAN_FLAG

Mean air temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (4)
  • A
    Accepted value
  • E
    Estimated value
  • M
    Missing value
  • Q
    Questionable value
REGRESSION_SITE - char(6) (nominal)

ID: MS04502.REGRESSION_SITE

Reference site used to estimate values using linear regression

Type system: Microsoft SQL Server 2019

Code definitions (183)
  • RS38__
    Reference Stand RS38, H.J. Andrews EF, Willamette NF
  • CENMET
    Central Meteorological Station
  • UPLMET
    Upper Lookout Meteorological Station
  • VANMET
    Vanilla Leaf Meteorological Station
  • CS2MET
    Climatic Station at Watershed 2
  • H15MET
    High 15 Meteorological Station
  • RS02__
    Reference Stand RS02 air/soil temperature site
  • RS04__
    Reference Stand RS04 air/soil temperature site
  • RS05__
    Reference Stand RS05 air/soil temperature site
  • RS10__
    Reference Stand RS10 air/soil temperature site
  • RS12__
    Reference Stand RS12 air/soil temperature site
  • RS20__
    Reference Stand RS20 air/soil temperature site
  • RS26__
    Reference Stand RS26 air/soil temperature site
  • RS86__
    Reference Stand RS86 air/soil temperature and relative humidity site
  • RS89__
    Reference Stand RS89 air/soil temperature and relative humidity site
  • PC001
    HJA Phenology Core Site 001 (WS01)
  • PC002
    HJA Phenology Core Site 002 (CS2MET/RS07)
  • PC004
    HJA Phenology Core Site 004 (RS89)
  • PC007
    HJA Phenology Core Site 007 (RS05)
  • PC008
    HJA Phenology Core Site 008 (RS32)
  • PC009
    HJA Phenology Core Site 009 (RS12)
  • PC010
    HJA Phenology Core Site 010 (Decomp site 5/CENMET)
  • PC011
    HJA Phenology Core Site 011 (L303/371 RD 350)
  • PC012
    HJA Phenology Core Site 012 (RS18)
  • PC013
    HJA Phenology Core Site 013 (RS21)
  • PC014
    HJA Phenology Core Site 014 (RS03)
  • PC015
    HJA Phenology Core Site 015 (WS08)
  • PC017
    HJA Phenology Core Site 017 (RS04)
  • PA002
    HJA Phenology Auxiliary Site 002
  • PA004
    HJA Phenology Auxiliary Site 004
  • PA005
    HJA Phenology Auxiliary Site 005
  • PA006
    HJA Phenology Auxiliary Site 006
  • PA009
    HJA Phenology Auxiliary Site 009
  • PA010
    HJA Phenology Auxiliary Site 010
  • PA011
    HJA Phenology Auxiliary Site 011
  • PA012
    HJA Phenology Auxiliary Site 012
  • PA013
    HJA Phenology Auxiliary Site 013
  • PA017
    HJA Phenology Auxiliary Site 017
  • PA019
    HJA Phenology Auxiliary Site 019
  • PA020
    HJA Phenology Auxiliary Site 020
  • PA021
    HJA Phenology Auxiliary Site 021
  • PA023
    HJA Phenology Auxiliary Site 023
  • PA027
    HJA Phenology Auxiliary Site 027
  • PA028
    HJA Phenology Auxiliary Site 028
  • PA031
    HJA Phenology Auxiliary Site 031
  • PA032
    HJA Phenology Auxiliary Site 032
  • PA036
    HJA Phenology Auxiliary Site 036
  • PA037
    HJA Phenology Auxiliary Site 037
  • PA038
    HJA Phenology Auxiliary Site 038
  • PA039
    HJA Phenology Auxiliary Site 039
  • PA040
    HJA Phenology Auxiliary Site 040
  • PA042
    HJA Phenology Auxiliary Site 042
  • PA045
    HJA Phenology Auxiliary Site 045
  • PA048
    HJA Phenology Auxiliary Site 048
  • PA051
    HJA Phenology Auxiliary Site 051
  • PA053
    HJA Phenology Auxiliary Site 053
  • PA054
    HJA Phenology Auxiliary Site 054
  • PA059
    HJA Phenology Auxiliary Site 059
  • PA062
    HJA Phenology Auxiliary Site 062
  • PA063
    HJA Phenology Auxiliary Site 063
  • PA064
    HJA Phenology Auxiliary Site 064
  • PA065
    HJA Phenology Auxiliary Site 065
  • PA066
    HJA Phenology Auxiliary Site 066
  • PA076
    HJA Phenology Auxiliary Site 076
  • PA077
    HJA Phenology Auxiliary Site 077
  • PA078
    HJA Phenology Auxiliary Site 078
  • PA079
    HJA Phenology Auxiliary Site 079
  • PA080
    HJA Phenology Auxiliary Site 080
  • PA200
    HJA Phenology Auxiliary Site 200
  • PA203
    HJA Phenology Auxiliary Site 203
  • PA207
    HJA Phenology Auxiliary Site 207
  • PA208
    HJA Phenology Auxiliary Site 208
  • PA209
    HJA Phenology Auxiliary Site 209
  • PA210
    HJA Phenology Auxiliary Site 210
  • PA211
    HJA Phenology Auxiliary Site 211
  • PA217
    HJA Phenology Auxiliary Site 217
  • PA224
    HJA Phenology Auxiliary Site 224
  • PA226
    HJA Phenology Auxiliary Site 226
  • PA233
    HJA Phenology Auxiliary Site 233
  • PA234
    HJA Phenology Auxiliary Site 234
  • PA235
    HJA Phenology Auxiliary Site 235
  • PA239
    HJA Phenology Auxiliary Site 239
  • PA240
    HJA Phenology Auxiliary Site 240
  • PA241
    HJA Phenology Auxiliary Site 241
  • PA243
    HJA Phenology Auxiliary Site 243
  • PA245
    HJA Phenology Auxiliary Site 245
  • PA246
    HJA Phenology Auxiliary Site 246
  • PA247
    HJA Phenology Auxiliary Site 247
  • PA248
    HJA Phenology Auxiliary Site 248
  • PA249
    HJA Phenology Auxiliary Site 249
  • PA250
    HJA Phenology Auxiliary Site 250
  • PA252
    HJA Phenology Auxiliary Site 252
  • PA253
    HJA Phenology Auxiliary Site 253
  • PA256
    HJA Phenology Auxiliary Site 256
  • PA257
    HJA Phenology Auxiliary Site 257
  • PA258
    HJA Phenology Auxiliary Site 258
  • PA259
    HJA Phenology Auxiliary Site 259
  • PA260
    HJA Phenology Auxiliary Site 260
  • PA265
    HJA Phenology Auxiliary Site 265
  • PA270
    HJA Phenology Auxiliary Site 270
  • PA273
    HJA Phenology Auxiliary Site 273
  • PA274
    HJA Phenology Auxiliary Site 274
  • PA275
    HJA Phenology Auxiliary Site 275
  • PA276
    HJA Phenology Auxiliary Site 276
  • PA277
    HJA Phenology Auxiliary Site 277
  • PA279
    HJA Phenology Auxiliary Site 279
  • PA303
    HJA Phenology Auxiliary Site 303
  • PA304
    HJA Phenology Auxiliary Site 304
  • PA305
    HJA Phenology Auxiliary Site 305
  • PA306
    HJA Phenology Auxiliary Site 306
  • PA307
    HJA Phenology Auxiliary Site 307
  • PA308
    HJA Phenology Auxiliary Site 308
  • PA309
    HJA Phenology Auxiliary Site 309
  • PA310
    HJA Phenology Auxiliary Site 310
  • PA311
    HJA Phenology Auxiliary Site 311
  • PA312
    HJA Phenology Auxiliary Site 312
  • PA314
    HJA Phenology Auxiliary Site 314
  • PA317
    HJA Phenology Auxiliary Site 317
  • PA318
    HJA Phenology Auxiliary Site 318
  • PA322
    HJA Phenology Auxiliary Site 322
  • PA323
    HJA Phenology Auxiliary Site 323
  • PA324
    HJA Phenology Auxiliary Site 324
  • PA327
    HJA Phenology Auxiliary Site 327
  • PA328
    HJA Phenology Auxiliary Site 328
  • PA329
    HJA Phenology Auxiliary Site 329
  • PA330
    HJA Phenology Auxiliary Site 330
  • PA334
    HJA Phenology Auxiliary Site 334
  • PA336
    HJA Phenology Auxiliary Site 336
  • PA338
    HJA Phenology Auxiliary Site 338
  • PA339
    HJA Phenology Auxiliary Site 339
  • PA340
    HJA Phenology Auxiliary Site 340
  • PA341
    HJA Phenology Auxiliary Site 341
  • PA342
    HJA Phenology Auxiliary Site 342
  • PA344
    HJA Phenology Auxiliary Site 344
  • PA345
    HJA Phenology Auxiliary Site 345
  • PA347
    HJA Phenology Auxiliary Site 347
  • PA348
    HJA Phenology Auxiliary Site 348
  • PA349
    HJA Phenology Auxiliary Site 349
  • PA350
    HJA Phenology Auxiliary Site 350
  • PA351
    HJA Phenology Auxiliary Site 351
  • PA352
    HJA Phenology Auxiliary Site 352
  • PA353
    HJA Phenology Auxiliary Site 353
  • PA354
    HJA Phenology Auxiliary Site 354
  • PA400
    HJA Phenology Auxiliary Site 400
  • PA506
    HJA Phenology Auxiliary Site 506
  • PB008
    HJA Phenology Core Bird Site 008
  • PB022
    HJA Phenology Core Bird Site 022
  • PB030
    HJA Phenology Core Bird Site 030
  • PB046
    HJA Phenology Core Bird Site 046
  • PB047
    HJA Phenology Core Bird Site 047
  • PB052
    HJA Phenology Core Bird Site 052
  • PB055
    HJA Phenology Core Bird Site 055
  • PB067
    HJA Phenology Core Bird Site 067
  • PB201
    HJA Phenology Core Bird Site 201
  • PB202
    HJA Phenology Core Bird Site 202
  • PB206
    HJA Phenology Core Bird Site 206
  • PB216
    HJA Phenology Core Bird Site 216
  • PB225
    HJA Phenology Core Bird Site 225
  • PB242
    HJA Phenology Core Bird Site 242
  • PB244
    HJA Phenology Core Bird Site 244
  • PB251
    HJA Phenology Core Bird Site 251
  • PB254
    HJA Phenology Core Bird Site 254
  • PB255
    HJA Phenology Core Bird Site 255
  • PB264
    HJA Phenology Core Bird Site 264
  • PB267
    HJA Phenology Core Bird Site 267
  • PB268
    HJA Phenology Core Bird Site 268
  • PB269
    HJA Phenology Core Bird Site 269
  • PB271
    HJA Phenology Core Bird Site 271
  • PB278
    HJA Phenology Core Bird Site 278
  • PB302
    HJA Phenology Core Bird Site 302
  • PB316
    HJA Phenology Core Bird Site 316
  • PB325
    HJA Phenology Core Bird Site 325
  • PB331
    HJA Phenology Core Bird Site 331
  • PB332
    HJA Phenology Core Bird Site 332
  • PB333
    HJA Phenology Core Bird Site 333
  • PB335
    HJA Phenology Core Bird Site 335
  • PB337
    HJA Phenology Core Bird Site 337
  • PB343
    HJA Phenology Core Bird Site 343
  • PB346
    HJA Phenology Core Bird Site 346
  • PB356
    HJA Phenology Core Bird Site 356
  • PB357
    HJA Phenology Core Bird Site 357
  • PB358
    HJA Phenology Core Bird Site 358
  • None
    No estimation (actual data is used)
MS04503 - Daily air temperature for phenology core bird and auxiliary sites

Object name: MS04503_v1.csv

Records: 233416

Attributes: 13

Temporal coverage: 2009-01-01 to 2014-07-30

File size: 13672565 byte

Checksum (MD5): a4ef255a414a28d5fe69c9acd6c63206

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

Constraints (2)
  • primaryKey: PRIMARY
    MS04503.SITECODE, MS04503.DATE
  • notNullConstraint: NOTNULL
    MS04503.DBCODE, MS04503.ENTITY, MS04503.SITECODE, MS04503.SITETYPE, MS04503.DATE, MS04503.AIRTEMP_MEAN_FLAG, MS04503.AIRTEMP_MAX_FLAG, MS04503.AIRTEMP_MIN_FLAG, MS04503.REGRESSION_SITE, MS04503.QC_LEVEL
Attributes (13)
DBCODE - char(5) (nominal)

ID: MS04503.DBCODE

FSDB database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • MS045
    FSDB database code
ENTITY - numeric(2,0) (interval)

ID: MS04503.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1

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

SITECODE - char(5) (nominal)

ID: MS04503.SITECODE

Site code for the phenology measurement location

Type system: Microsoft SQL Server 2019

Code definitions (184)
  • PC001
    HJA Phenology Core Site 001 (WS01)
  • PC002
    HJA Phenology Core Site 002 (CS2MET/RS07)
  • PC004
    HJA Phenology Core Site 004 (RS89)
  • PC005
    HJA Phenology Core Site 005 (RS86)
  • PC007
    HJA Phenology Core Site 007 (RS05)
  • PC008
    HJA Phenology Core Site 008 (RS32)
  • PC009
    HJA Phenology Core Site 009 (RS12)
  • PC010
    HJA Phenology Core Site 010 (Decomp site 5/CENMET)
  • PC011
    HJA Phenology Core Site 011 (L303/371 RD 350)
  • PC012
    HJA Phenology Core Site 012 (RS18)
  • PC013
    HJA Phenology Core Site 013 (RS21)
  • PC014
    HJA Phenology Core Site 014 (RS03)
  • PC015
    HJA Phenology Core Site 015 (WS08)
  • PC016
    HJA Phenology Core Site 016 (NADP/WS07)
  • PC017
    HJA Phenology Core Site 017 (RS04)
  • PC018
    HJA Phenology Core Site 018 (L306 RD 350)
  • PA002
    HJA Phenology Auxiliary Site 002
  • PA003
    HJA Phenology Auxiliary Site 003
  • PA004
    HJA Phenology Auxiliary Site 004
  • PA005
    HJA Phenology Auxiliary Site 005
  • PA006
    HJA Phenology Auxiliary Site 006
  • PA009
    HJA Phenology Auxiliary Site 009
  • PA010
    HJA Phenology Auxiliary Site 010
  • PA011
    HJA Phenology Auxiliary Site 011
  • PA012
    HJA Phenology Auxiliary Site 012
  • PA013
    HJA Phenology Auxiliary Site 013
  • PA016
    HJA Phenology Auxiliary Site 016
  • PA017
    HJA Phenology Auxiliary Site 017
  • PA018
    HJA Phenology Auxiliary Site 018
  • PA019
    HJA Phenology Auxiliary Site 019
  • PA020
    HJA Phenology Auxiliary Site 020
  • PA021
    HJA Phenology Auxiliary Site 021
  • PA023
    HJA Phenology Auxiliary Site 023
  • PA027
    HJA Phenology Auxiliary Site 027
  • PA028
    HJA Phenology Auxiliary Site 028
  • PA029
    HJA Phenology Auxiliary Site 029
  • PA031
    HJA Phenology Auxiliary Site 031
  • PA032
    HJA Phenology Auxiliary Site 032
  • PA036
    HJA Phenology Auxiliary Site 036
  • PA037
    HJA Phenology Auxiliary Site 037
  • PA038
    HJA Phenology Auxiliary Site 038
  • PA039
    HJA Phenology Auxiliary Site 039
  • PA040
    HJA Phenology Auxiliary Site 040
  • PA041
    HJA Phenology Auxiliary Site 041
  • PA042
    HJA Phenology Auxiliary Site 042
  • PA044
    HJA Phenology Auxiliary Site 044
  • PA045
    HJA Phenology Auxiliary Site 045
  • PA048
    HJA Phenology Auxiliary Site 048
  • PA051
    HJA Phenology Auxiliary Site 051
  • PA053
    HJA Phenology Auxiliary Site 053
  • PA054
    HJA Phenology Auxiliary Site 054
  • PA059
    HJA Phenology Auxiliary Site 059
  • PA062
    HJA Phenology Auxiliary Site 062
  • PA063
    HJA Phenology Auxiliary Site 063
  • PA064
    HJA Phenology Auxiliary Site 064
  • PA065
    HJA Phenology Auxiliary Site 065
  • PA066
    HJA Phenology Auxiliary Site 066
  • PA076
    HJA Phenology Auxiliary Site 076
  • PA077
    HJA Phenology Auxiliary Site 077
  • PA078
    HJA Phenology Auxiliary Site 078
  • PA079
    HJA Phenology Auxiliary Site 079
  • PA080
    HJA Phenology Auxiliary Site 080
  • PA081
    HJA Phenology Auxiliary Site 081
  • PA200
    HJA Phenology Auxiliary Site 200
  • PA203
    HJA Phenology Auxiliary Site 203
  • PA204
    HJA Phenology Auxiliary Site 204
  • PA207
    HJA Phenology Auxiliary Site 207
  • PA208
    HJA Phenology Auxiliary Site 208
  • PA209
    HJA Phenology Auxiliary Site 209
  • PA210
    HJA Phenology Auxiliary Site 210
  • PA211
    HJA Phenology Auxiliary Site 211
  • PA217
    HJA Phenology Auxiliary Site 217
  • PA224
    HJA Phenology Auxiliary Site 224
  • PA226
    HJA Phenology Auxiliary Site 226
  • PA233
    HJA Phenology Auxiliary Site 233
  • PA234
    HJA Phenology Auxiliary Site 234
  • PA235
    HJA Phenology Auxiliary Site 235
  • PA239
    HJA Phenology Auxiliary Site 239
  • PA240
    HJA Phenology Auxiliary Site 240
  • PA241
    HJA Phenology Auxiliary Site 241
  • PA243
    HJA Phenology Auxiliary Site 243
  • PA245
    HJA Phenology Auxiliary Site 245
  • PA246
    HJA Phenology Auxiliary Site 246
  • PA247
    HJA Phenology Auxiliary Site 247
  • PA248
    HJA Phenology Auxiliary Site 248
  • PA249
    HJA Phenology Auxiliary Site 249
  • PA250
    HJA Phenology Auxiliary Site 250
  • PA252
    HJA Phenology Auxiliary Site 252
  • PA253
    HJA Phenology Auxiliary Site 253
  • PA256
    HJA Phenology Auxiliary Site 256
  • PA257
    HJA Phenology Auxiliary Site 257
  • PA258
    HJA Phenology Auxiliary Site 258
  • PA259
    HJA Phenology Auxiliary Site 259
  • PA260
    HJA Phenology Auxiliary Site 260
  • PA265
    HJA Phenology Auxiliary Site 265
  • PA266
    HJA Phenology Auxiliary Site 266
  • PA270
    HJA Phenology Auxiliary Site 270
  • PA272
    HJA Phenology Auxiliary Site 272
  • PA273
    HJA Phenology Auxiliary Site 273
  • PA274
    HJA Phenology Auxiliary Site 274
  • PA275
    HJA Phenology Auxiliary Site 275
  • PA276
    HJA Phenology Auxiliary Site 276
  • PA277
    HJA Phenology Auxiliary Site 277
  • PA279
    HJA Phenology Auxiliary Site 279
  • PA303
    HJA Phenology Auxiliary Site 303
  • PA304
    HJA Phenology Auxiliary Site 304
  • PA305
    HJA Phenology Auxiliary Site 305
  • PA306
    HJA Phenology Auxiliary Site 306
  • PA307
    HJA Phenology Auxiliary Site 307
  • PA308
    HJA Phenology Auxiliary Site 308
  • PA309
    HJA Phenology Auxiliary Site 309
  • PA310
    HJA Phenology Auxiliary Site 310
  • PA311
    HJA Phenology Auxiliary Site 311
  • PA312
    HJA Phenology Auxiliary Site 312
  • PA314
    HJA Phenology Auxiliary Site 314
  • PA315
    HJA Phenology Auxiliary Site 315
  • PA317
    HJA Phenology Auxiliary Site 317
  • PA318
    HJA Phenology Auxiliary Site 318
  • PA322
    HJA Phenology Auxiliary Site 322
  • PA323
    HJA Phenology Auxiliary Site 323
  • PA324
    HJA Phenology Auxiliary Site 324
  • PA327
    HJA Phenology Auxiliary Site 327
  • PA328
    HJA Phenology Auxiliary Site 328
  • PA329
    HJA Phenology Auxiliary Site 329
  • PA330
    HJA Phenology Auxiliary Site 330
  • PA334
    HJA Phenology Auxiliary Site 334
  • PA336
    HJA Phenology Auxiliary Site 336
  • PA338
    HJA Phenology Auxiliary Site 338
  • PA339
    HJA Phenology Auxiliary Site 339
  • PA340
    HJA Phenology Auxiliary Site 340
  • PA341
    HJA Phenology Auxiliary Site 341
  • PA342
    HJA Phenology Auxiliary Site 342
  • PA344
    HJA Phenology Auxiliary Site 344
  • PA345
    HJA Phenology Auxiliary Site 345
  • PA347
    HJA Phenology Auxiliary Site 347
  • PA348
    HJA Phenology Auxiliary Site 348
  • PA349
    HJA Phenology Auxiliary Site 349
  • PA350
    HJA Phenology Auxiliary Site 350
  • PA351
    HJA Phenology Auxiliary Site 351
  • PA352
    HJA Phenology Auxiliary Site 352
  • PA353
    HJA Phenology Auxiliary Site 353
  • PA354
    HJA Phenology Auxiliary Site 354
  • PA400
    HJA Phenology Auxiliary Site 400
  • PA506
    HJA Phenology Auxiliary Site 506
  • PB008
    HJA Phenology Core Bird Site 008
  • PB014
    HJA Phenology Core Bird Site 014
  • PB022
    HJA Phenology Core Bird Site 022
  • PB030
    HJA Phenology Core Bird Site 030
  • PB046
    HJA Phenology Core Bird Site 046
  • PB047
    HJA Phenology Core Bird Site 047
  • PB052
    HJA Phenology Core Bird Site 052
  • PB055
    HJA Phenology Core Bird Site 055
  • PB060
    HJA Phenology Core Bird Site 060
  • PB067
    HJA Phenology Core Bird Site 067
  • PB201
    HJA Phenology Core Bird Site 201
  • PB202
    HJA Phenology Core Bird Site 202
  • PB206
    HJA Phenology Core Bird Site 206
  • PB216
    HJA Phenology Core Bird Site 216
  • PB225
    HJA Phenology Core Bird Site 225
  • PB242
    HJA Phenology Core Bird Site 242
  • PB244
    HJA Phenology Core Bird Site 244
  • PB251
    HJA Phenology Core Bird Site 251
  • PB254
    HJA Phenology Core Bird Site 254
  • PB255
    HJA Phenology Core Bird Site 255
  • PB264
    HJA Phenology Core Bird Site 264
  • PB267
    HJA Phenology Core Bird Site 267
  • PB268
    HJA Phenology Core Bird Site 268
  • PB269
    HJA Phenology Core Bird Site 269
  • PB271
    HJA Phenology Core Bird Site 271
  • PB278
    HJA Phenology Core Bird Site 278
  • PB302
    HJA Phenology Core Bird Site 302
  • PB316
    HJA Phenology Core Bird Site 316
  • PB325
    HJA Phenology Core Bird Site 325
  • PB326
    HJA Phenology Core Bird Site 326
  • PB331
    HJA Phenology Core Bird Site 331
  • PB332
    HJA Phenology Core Bird Site 332
  • PB333
    HJA Phenology Core Bird Site 333
  • PB335
    HJA Phenology Core Bird Site 335
  • PB337
    HJA Phenology Core Bird Site 337
  • PB343
    HJA Phenology Core Bird Site 343
  • PB346
    HJA Phenology Core Bird Site 346
  • PB356
    HJA Phenology Core Bird Site 356
  • PB357
    HJA Phenology Core Bird Site 357
  • PB358
    HJA Phenology Core Bird Site 358
SITETYPE - char(2) (nominal)

ID: MS04503.SITETYPE

Type of measurement site: core phenology, core bird or auxiliary site

Type system: Microsoft SQL Server 2019

Code definitions (3)
  • PC
    Core phenology site
  • PB
    Core phenology bird site
  • PA
    Core phenology auxiliary site
QC_LEVEL - char(2) (nominal)

ID: MS04503.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 - date (dateTime)

ID: MS04503.DATE

Date of collection

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

AIRTEMP_MEAN_DAY - numeric(5,1) (interval)

ID: MS04503.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=-16.1000 (exclusive=false), max=29.7000 (exclusive=false)

AIRTEMP_MEAN_FLAG - char(1) (nominal)

ID: MS04503.AIRTEMP_MEAN_FLAG

Mean air temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (4)
  • A
    Accepted value
  • E
    Estimated value
  • M
    Missing value
  • Q
    Questionable value
AIRTEMP_MAX_DAY - numeric(5,1) (interval)

ID: MS04503.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=-14.5000 (exclusive=false), max=47.2000 (exclusive=false)

AIRTEMP_MAX_FLAG - char(1) (nominal)

ID: MS04503.AIRTEMP_MAX_FLAG

Maximum air temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (4)
  • A
    Accepted value
  • E
    Estimated value
  • M
    Missing value
  • Q
    Questionable value
AIRTEMP_MIN_DAY - numeric(5,1) (interval)

ID: MS04503.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=-18.9000 (exclusive=false), max=23.9000 (exclusive=false)

AIRTEMP_MIN_FLAG - char(1) (nominal)

ID: MS04503.AIRTEMP_MIN_FLAG

Minimum air temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (4)
  • A
    Accepted value
  • E
    Estimated value
  • M
    Missing value
  • Q
    Questionable value
REGRESSION_SITE - char(6) (nominal)

ID: MS04503.REGRESSION_SITE

Reference site used to estimate values using linear regression

Type system: Microsoft SQL Server 2019

Code definitions (183)
  • RS38__
    Reference Stand RS38, H.J. Andrews EF, Willamette NF
  • CENMET
    Central Meteorological Station
  • UPLMET
    Upper Lookout Meteorological Station
  • VANMET
    Vanilla Leaf Meteorological Station
  • CS2MET
    Climatic Station at Watershed 2
  • H15MET
    High 15 Meteorological Station
  • RS02__
    Reference Stand RS02 air/soil temperature site
  • RS04__
    Reference Stand RS04 air/soil temperature site
  • RS05__
    Reference Stand RS05 air/soil temperature site
  • RS10__
    Reference Stand RS10 air/soil temperature site
  • RS12__
    Reference Stand RS12 air/soil temperature site
  • RS20__
    Reference Stand RS20 air/soil temperature site
  • RS26__
    Reference Stand RS26 air/soil temperature site
  • RS86__
    Reference Stand RS86 air/soil temperature and relative humidity site
  • RS89__
    Reference Stand RS89 air/soil temperature and relative humidity site
  • PC001
    HJA Phenology Core Site 001 (WS01)
  • PC002
    HJA Phenology Core Site 002 (CS2MET/RS07)
  • PC004
    HJA Phenology Core Site 004 (RS89)
  • PC007
    HJA Phenology Core Site 007 (RS05)
  • PC008
    HJA Phenology Core Site 008 (RS32)
  • PC009
    HJA Phenology Core Site 009 (RS12)
  • PC010
    HJA Phenology Core Site 010 (Decomp site 5/CENMET)
  • PC011
    HJA Phenology Core Site 011 (L303/371 RD 350)
  • PC012
    HJA Phenology Core Site 012 (RS18)
  • PC013
    HJA Phenology Core Site 013 (RS21)
  • PC014
    HJA Phenology Core Site 014 (RS03)
  • PC015
    HJA Phenology Core Site 015 (WS08)
  • PC017
    HJA Phenology Core Site 017 (RS04)
  • PA002
    HJA Phenology Auxiliary Site 002
  • PA004
    HJA Phenology Auxiliary Site 004
  • PA005
    HJA Phenology Auxiliary Site 005
  • PA006
    HJA Phenology Auxiliary Site 006
  • PA009
    HJA Phenology Auxiliary Site 009
  • PA010
    HJA Phenology Auxiliary Site 010
  • PA011
    HJA Phenology Auxiliary Site 011
  • PA012
    HJA Phenology Auxiliary Site 012
  • PA013
    HJA Phenology Auxiliary Site 013
  • PA017
    HJA Phenology Auxiliary Site 017
  • PA019
    HJA Phenology Auxiliary Site 019
  • PA020
    HJA Phenology Auxiliary Site 020
  • PA021
    HJA Phenology Auxiliary Site 021
  • PA023
    HJA Phenology Auxiliary Site 023
  • PA027
    HJA Phenology Auxiliary Site 027
  • PA028
    HJA Phenology Auxiliary Site 028
  • PA031
    HJA Phenology Auxiliary Site 031
  • PA032
    HJA Phenology Auxiliary Site 032
  • PA036
    HJA Phenology Auxiliary Site 036
  • PA037
    HJA Phenology Auxiliary Site 037
  • PA038
    HJA Phenology Auxiliary Site 038
  • PA039
    HJA Phenology Auxiliary Site 039
  • PA040
    HJA Phenology Auxiliary Site 040
  • PA042
    HJA Phenology Auxiliary Site 042
  • PA045
    HJA Phenology Auxiliary Site 045
  • PA048
    HJA Phenology Auxiliary Site 048
  • PA051
    HJA Phenology Auxiliary Site 051
  • PA053
    HJA Phenology Auxiliary Site 053
  • PA054
    HJA Phenology Auxiliary Site 054
  • PA059
    HJA Phenology Auxiliary Site 059
  • PA062
    HJA Phenology Auxiliary Site 062
  • PA063
    HJA Phenology Auxiliary Site 063
  • PA064
    HJA Phenology Auxiliary Site 064
  • PA065
    HJA Phenology Auxiliary Site 065
  • PA066
    HJA Phenology Auxiliary Site 066
  • PA076
    HJA Phenology Auxiliary Site 076
  • PA077
    HJA Phenology Auxiliary Site 077
  • PA078
    HJA Phenology Auxiliary Site 078
  • PA079
    HJA Phenology Auxiliary Site 079
  • PA080
    HJA Phenology Auxiliary Site 080
  • PA200
    HJA Phenology Auxiliary Site 200
  • PA203
    HJA Phenology Auxiliary Site 203
  • PA207
    HJA Phenology Auxiliary Site 207
  • PA208
    HJA Phenology Auxiliary Site 208
  • PA209
    HJA Phenology Auxiliary Site 209
  • PA210
    HJA Phenology Auxiliary Site 210
  • PA211
    HJA Phenology Auxiliary Site 211
  • PA217
    HJA Phenology Auxiliary Site 217
  • PA224
    HJA Phenology Auxiliary Site 224
  • PA226
    HJA Phenology Auxiliary Site 226
  • PA233
    HJA Phenology Auxiliary Site 233
  • PA234
    HJA Phenology Auxiliary Site 234
  • PA235
    HJA Phenology Auxiliary Site 235
  • PA239
    HJA Phenology Auxiliary Site 239
  • PA240
    HJA Phenology Auxiliary Site 240
  • PA241
    HJA Phenology Auxiliary Site 241
  • PA243
    HJA Phenology Auxiliary Site 243
  • PA245
    HJA Phenology Auxiliary Site 245
  • PA246
    HJA Phenology Auxiliary Site 246
  • PA247
    HJA Phenology Auxiliary Site 247
  • PA248
    HJA Phenology Auxiliary Site 248
  • PA249
    HJA Phenology Auxiliary Site 249
  • PA250
    HJA Phenology Auxiliary Site 250
  • PA252
    HJA Phenology Auxiliary Site 252
  • PA253
    HJA Phenology Auxiliary Site 253
  • PA256
    HJA Phenology Auxiliary Site 256
  • PA257
    HJA Phenology Auxiliary Site 257
  • PA258
    HJA Phenology Auxiliary Site 258
  • PA259
    HJA Phenology Auxiliary Site 259
  • PA260
    HJA Phenology Auxiliary Site 260
  • PA265
    HJA Phenology Auxiliary Site 265
  • PA270
    HJA Phenology Auxiliary Site 270
  • PA273
    HJA Phenology Auxiliary Site 273
  • PA274
    HJA Phenology Auxiliary Site 274
  • PA275
    HJA Phenology Auxiliary Site 275
  • PA276
    HJA Phenology Auxiliary Site 276
  • PA277
    HJA Phenology Auxiliary Site 277
  • PA279
    HJA Phenology Auxiliary Site 279
  • PA303
    HJA Phenology Auxiliary Site 303
  • PA304
    HJA Phenology Auxiliary Site 304
  • PA305
    HJA Phenology Auxiliary Site 305
  • PA306
    HJA Phenology Auxiliary Site 306
  • PA307
    HJA Phenology Auxiliary Site 307
  • PA308
    HJA Phenology Auxiliary Site 308
  • PA309
    HJA Phenology Auxiliary Site 309
  • PA310
    HJA Phenology Auxiliary Site 310
  • PA311
    HJA Phenology Auxiliary Site 311
  • PA312
    HJA Phenology Auxiliary Site 312
  • PA314
    HJA Phenology Auxiliary Site 314
  • PA317
    HJA Phenology Auxiliary Site 317
  • PA318
    HJA Phenology Auxiliary Site 318
  • PA322
    HJA Phenology Auxiliary Site 322
  • PA323
    HJA Phenology Auxiliary Site 323
  • PA324
    HJA Phenology Auxiliary Site 324
  • PA327
    HJA Phenology Auxiliary Site 327
  • PA328
    HJA Phenology Auxiliary Site 328
  • PA329
    HJA Phenology Auxiliary Site 329
  • PA330
    HJA Phenology Auxiliary Site 330
  • PA334
    HJA Phenology Auxiliary Site 334
  • PA336
    HJA Phenology Auxiliary Site 336
  • PA338
    HJA Phenology Auxiliary Site 338
  • PA339
    HJA Phenology Auxiliary Site 339
  • PA340
    HJA Phenology Auxiliary Site 340
  • PA341
    HJA Phenology Auxiliary Site 341
  • PA342
    HJA Phenology Auxiliary Site 342
  • PA344
    HJA Phenology Auxiliary Site 344
  • PA345
    HJA Phenology Auxiliary Site 345
  • PA347
    HJA Phenology Auxiliary Site 347
  • PA348
    HJA Phenology Auxiliary Site 348
  • PA349
    HJA Phenology Auxiliary Site 349
  • PA350
    HJA Phenology Auxiliary Site 350
  • PA351
    HJA Phenology Auxiliary Site 351
  • PA352
    HJA Phenology Auxiliary Site 352
  • PA353
    HJA Phenology Auxiliary Site 353
  • PA354
    HJA Phenology Auxiliary Site 354
  • PA400
    HJA Phenology Auxiliary Site 400
  • PA506
    HJA Phenology Auxiliary Site 506
  • PB008
    HJA Phenology Core Bird Site 008
  • PB022
    HJA Phenology Core Bird Site 022
  • PB030
    HJA Phenology Core Bird Site 030
  • PB046
    HJA Phenology Core Bird Site 046
  • PB047
    HJA Phenology Core Bird Site 047
  • PB052
    HJA Phenology Core Bird Site 052
  • PB055
    HJA Phenology Core Bird Site 055
  • PB067
    HJA Phenology Core Bird Site 067
  • PB201
    HJA Phenology Core Bird Site 201
  • PB202
    HJA Phenology Core Bird Site 202
  • PB206
    HJA Phenology Core Bird Site 206
  • PB216
    HJA Phenology Core Bird Site 216
  • PB225
    HJA Phenology Core Bird Site 225
  • PB242
    HJA Phenology Core Bird Site 242
  • PB244
    HJA Phenology Core Bird Site 244
  • PB251
    HJA Phenology Core Bird Site 251
  • PB254
    HJA Phenology Core Bird Site 254
  • PB255
    HJA Phenology Core Bird Site 255
  • PB264
    HJA Phenology Core Bird Site 264
  • PB267
    HJA Phenology Core Bird Site 267
  • PB268
    HJA Phenology Core Bird Site 268
  • PB269
    HJA Phenology Core Bird Site 269
  • PB271
    HJA Phenology Core Bird Site 271
  • PB278
    HJA Phenology Core Bird Site 278
  • PB302
    HJA Phenology Core Bird Site 302
  • PB316
    HJA Phenology Core Bird Site 316
  • PB325
    HJA Phenology Core Bird Site 325
  • PB331
    HJA Phenology Core Bird Site 331
  • PB332
    HJA Phenology Core Bird Site 332
  • PB333
    HJA Phenology Core Bird Site 333
  • PB335
    HJA Phenology Core Bird Site 335
  • PB337
    HJA Phenology Core Bird Site 337
  • PB343
    HJA Phenology Core Bird Site 343
  • PB346
    HJA Phenology Core Bird Site 346
  • PB356
    HJA Phenology Core Bird Site 356
  • PB357
    HJA Phenology Core Bird Site 357
  • PB358
    HJA Phenology Core Bird Site 358
  • None
    No estimation (actual data is used)
MS04504 - Hourly air temperature for phenology core bird and auxiliary sites

Object name: MS04504_v2.txt

Records: 5601816

Attributes: 9

Temporal coverage: 2009-01-01 to 2014-07-30

File size: 305855133 byte

Checksum (MD5): 9bb010eec5abb83132bce23269a5b0f0

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

Constraints (2)
  • primaryKey: PRIMARY
    MS04504.SITECODE, MS04504.DATE_TIME
  • notNullConstraint: NOTNULL
    MS04504.DBCODE, MS04504.ENTITY, MS04504.SITECODE, MS04504.SITETYPE, MS04504.AIRTEMP_MEAN_FLAG, MS04504.REGRESSION_SITE, MS04504.DATE_TIME, MS04504.QC_LEVEL
Attributes (9)
DBCODE - char(5) (nominal)

ID: MS04504.DBCODE

FSDB database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • MS045
    FSDB database code
ENTITY - numeric(2,0) (interval)

ID: MS04504.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1

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

SITECODE - char(5) (nominal)

ID: MS04504.SITECODE

Site code for the phenology measurement location

Type system: Microsoft SQL Server 2019

Code definitions (184)
  • PC001
    HJA Phenology Core Site 001 (WS01)
  • PC002
    HJA Phenology Core Site 002 (CS2MET/RS07)
  • PC004
    HJA Phenology Core Site 004 (RS89)
  • PC005
    HJA Phenology Core Site 005 (RS86)
  • PC007
    HJA Phenology Core Site 007 (RS05)
  • PC008
    HJA Phenology Core Site 008 (RS32)
  • PC009
    HJA Phenology Core Site 009 (RS12)
  • PC010
    HJA Phenology Core Site 010 (Decomp site 5/CENMET)
  • PC011
    HJA Phenology Core Site 011 (L303/371 RD 350)
  • PC012
    HJA Phenology Core Site 012 (RS18)
  • PC013
    HJA Phenology Core Site 013 (RS21)
  • PC014
    HJA Phenology Core Site 014 (RS03)
  • PC015
    HJA Phenology Core Site 015 (WS08)
  • PC016
    HJA Phenology Core Site 016 (NADP/WS07)
  • PC017
    HJA Phenology Core Site 017 (RS04)
  • PC018
    HJA Phenology Core Site 018 (L306 RD 350)
  • PA002
    HJA Phenology Auxiliary Site 002
  • PA003
    HJA Phenology Auxiliary Site 003
  • PA004
    HJA Phenology Auxiliary Site 004
  • PA005
    HJA Phenology Auxiliary Site 005
  • PA006
    HJA Phenology Auxiliary Site 006
  • PA009
    HJA Phenology Auxiliary Site 009
  • PA010
    HJA Phenology Auxiliary Site 010
  • PA011
    HJA Phenology Auxiliary Site 011
  • PA012
    HJA Phenology Auxiliary Site 012
  • PA013
    HJA Phenology Auxiliary Site 013
  • PA016
    HJA Phenology Auxiliary Site 016
  • PA017
    HJA Phenology Auxiliary Site 017
  • PA018
    HJA Phenology Auxiliary Site 018
  • PA019
    HJA Phenology Auxiliary Site 019
  • PA020
    HJA Phenology Auxiliary Site 020
  • PA021
    HJA Phenology Auxiliary Site 021
  • PA023
    HJA Phenology Auxiliary Site 023
  • PA027
    HJA Phenology Auxiliary Site 027
  • PA028
    HJA Phenology Auxiliary Site 028
  • PA029
    HJA Phenology Auxiliary Site 029
  • PA031
    HJA Phenology Auxiliary Site 031
  • PA032
    HJA Phenology Auxiliary Site 032
  • PA036
    HJA Phenology Auxiliary Site 036
  • PA037
    HJA Phenology Auxiliary Site 037
  • PA038
    HJA Phenology Auxiliary Site 038
  • PA039
    HJA Phenology Auxiliary Site 039
  • PA040
    HJA Phenology Auxiliary Site 040
  • PA041
    HJA Phenology Auxiliary Site 041
  • PA042
    HJA Phenology Auxiliary Site 042
  • PA044
    HJA Phenology Auxiliary Site 044
  • PA045
    HJA Phenology Auxiliary Site 045
  • PA048
    HJA Phenology Auxiliary Site 048
  • PA051
    HJA Phenology Auxiliary Site 051
  • PA053
    HJA Phenology Auxiliary Site 053
  • PA054
    HJA Phenology Auxiliary Site 054
  • PA059
    HJA Phenology Auxiliary Site 059
  • PA062
    HJA Phenology Auxiliary Site 062
  • PA063
    HJA Phenology Auxiliary Site 063
  • PA064
    HJA Phenology Auxiliary Site 064
  • PA065
    HJA Phenology Auxiliary Site 065
  • PA066
    HJA Phenology Auxiliary Site 066
  • PA076
    HJA Phenology Auxiliary Site 076
  • PA077
    HJA Phenology Auxiliary Site 077
  • PA078
    HJA Phenology Auxiliary Site 078
  • PA079
    HJA Phenology Auxiliary Site 079
  • PA080
    HJA Phenology Auxiliary Site 080
  • PA081
    HJA Phenology Auxiliary Site 081
  • PA200
    HJA Phenology Auxiliary Site 200
  • PA203
    HJA Phenology Auxiliary Site 203
  • PA204
    HJA Phenology Auxiliary Site 204
  • PA207
    HJA Phenology Auxiliary Site 207
  • PA208
    HJA Phenology Auxiliary Site 208
  • PA209
    HJA Phenology Auxiliary Site 209
  • PA210
    HJA Phenology Auxiliary Site 210
  • PA211
    HJA Phenology Auxiliary Site 211
  • PA217
    HJA Phenology Auxiliary Site 217
  • PA224
    HJA Phenology Auxiliary Site 224
  • PA226
    HJA Phenology Auxiliary Site 226
  • PA233
    HJA Phenology Auxiliary Site 233
  • PA234
    HJA Phenology Auxiliary Site 234
  • PA235
    HJA Phenology Auxiliary Site 235
  • PA239
    HJA Phenology Auxiliary Site 239
  • PA240
    HJA Phenology Auxiliary Site 240
  • PA241
    HJA Phenology Auxiliary Site 241
  • PA243
    HJA Phenology Auxiliary Site 243
  • PA245
    HJA Phenology Auxiliary Site 245
  • PA246
    HJA Phenology Auxiliary Site 246
  • PA247
    HJA Phenology Auxiliary Site 247
  • PA248
    HJA Phenology Auxiliary Site 248
  • PA249
    HJA Phenology Auxiliary Site 249
  • PA250
    HJA Phenology Auxiliary Site 250
  • PA252
    HJA Phenology Auxiliary Site 252
  • PA253
    HJA Phenology Auxiliary Site 253
  • PA256
    HJA Phenology Auxiliary Site 256
  • PA257
    HJA Phenology Auxiliary Site 257
  • PA258
    HJA Phenology Auxiliary Site 258
  • PA259
    HJA Phenology Auxiliary Site 259
  • PA260
    HJA Phenology Auxiliary Site 260
  • PA265
    HJA Phenology Auxiliary Site 265
  • PA266
    HJA Phenology Auxiliary Site 266
  • PA270
    HJA Phenology Auxiliary Site 270
  • PA272
    HJA Phenology Auxiliary Site 272
  • PA273
    HJA Phenology Auxiliary Site 273
  • PA274
    HJA Phenology Auxiliary Site 274
  • PA275
    HJA Phenology Auxiliary Site 275
  • PA276
    HJA Phenology Auxiliary Site 276
  • PA277
    HJA Phenology Auxiliary Site 277
  • PA279
    HJA Phenology Auxiliary Site 279
  • PA303
    HJA Phenology Auxiliary Site 303
  • PA304
    HJA Phenology Auxiliary Site 304
  • PA305
    HJA Phenology Auxiliary Site 305
  • PA306
    HJA Phenology Auxiliary Site 306
  • PA307
    HJA Phenology Auxiliary Site 307
  • PA308
    HJA Phenology Auxiliary Site 308
  • PA309
    HJA Phenology Auxiliary Site 309
  • PA310
    HJA Phenology Auxiliary Site 310
  • PA311
    HJA Phenology Auxiliary Site 311
  • PA312
    HJA Phenology Auxiliary Site 312
  • PA314
    HJA Phenology Auxiliary Site 314
  • PA315
    HJA Phenology Auxiliary Site 315
  • PA317
    HJA Phenology Auxiliary Site 317
  • PA318
    HJA Phenology Auxiliary Site 318
  • PA322
    HJA Phenology Auxiliary Site 322
  • PA323
    HJA Phenology Auxiliary Site 323
  • PA324
    HJA Phenology Auxiliary Site 324
  • PA327
    HJA Phenology Auxiliary Site 327
  • PA328
    HJA Phenology Auxiliary Site 328
  • PA329
    HJA Phenology Auxiliary Site 329
  • PA330
    HJA Phenology Auxiliary Site 330
  • PA334
    HJA Phenology Auxiliary Site 334
  • PA336
    HJA Phenology Auxiliary Site 336
  • PA338
    HJA Phenology Auxiliary Site 338
  • PA339
    HJA Phenology Auxiliary Site 339
  • PA340
    HJA Phenology Auxiliary Site 340
  • PA341
    HJA Phenology Auxiliary Site 341
  • PA342
    HJA Phenology Auxiliary Site 342
  • PA344
    HJA Phenology Auxiliary Site 344
  • PA345
    HJA Phenology Auxiliary Site 345
  • PA347
    HJA Phenology Auxiliary Site 347
  • PA348
    HJA Phenology Auxiliary Site 348
  • PA349
    HJA Phenology Auxiliary Site 349
  • PA350
    HJA Phenology Auxiliary Site 350
  • PA351
    HJA Phenology Auxiliary Site 351
  • PA352
    HJA Phenology Auxiliary Site 352
  • PA353
    HJA Phenology Auxiliary Site 353
  • PA354
    HJA Phenology Auxiliary Site 354
  • PA400
    HJA Phenology Auxiliary Site 400
  • PA506
    HJA Phenology Auxiliary Site 506
  • PB008
    HJA Phenology Core Bird Site 008
  • PB014
    HJA Phenology Core Bird Site 014
  • PB022
    HJA Phenology Core Bird Site 022
  • PB030
    HJA Phenology Core Bird Site 030
  • PB046
    HJA Phenology Core Bird Site 046
  • PB047
    HJA Phenology Core Bird Site 047
  • PB052
    HJA Phenology Core Bird Site 052
  • PB055
    HJA Phenology Core Bird Site 055
  • PB060
    HJA Phenology Core Bird Site 060
  • PB067
    HJA Phenology Core Bird Site 067
  • PB201
    HJA Phenology Core Bird Site 201
  • PB202
    HJA Phenology Core Bird Site 202
  • PB206
    HJA Phenology Core Bird Site 206
  • PB216
    HJA Phenology Core Bird Site 216
  • PB225
    HJA Phenology Core Bird Site 225
  • PB242
    HJA Phenology Core Bird Site 242
  • PB244
    HJA Phenology Core Bird Site 244
  • PB251
    HJA Phenology Core Bird Site 251
  • PB254
    HJA Phenology Core Bird Site 254
  • PB255
    HJA Phenology Core Bird Site 255
  • PB264
    HJA Phenology Core Bird Site 264
  • PB267
    HJA Phenology Core Bird Site 267
  • PB268
    HJA Phenology Core Bird Site 268
  • PB269
    HJA Phenology Core Bird Site 269
  • PB271
    HJA Phenology Core Bird Site 271
  • PB278
    HJA Phenology Core Bird Site 278
  • PB302
    HJA Phenology Core Bird Site 302
  • PB316
    HJA Phenology Core Bird Site 316
  • PB325
    HJA Phenology Core Bird Site 325
  • PB326
    HJA Phenology Core Bird Site 326
  • PB331
    HJA Phenology Core Bird Site 331
  • PB332
    HJA Phenology Core Bird Site 332
  • PB333
    HJA Phenology Core Bird Site 333
  • PB335
    HJA Phenology Core Bird Site 335
  • PB337
    HJA Phenology Core Bird Site 337
  • PB343
    HJA Phenology Core Bird Site 343
  • PB346
    HJA Phenology Core Bird Site 346
  • PB356
    HJA Phenology Core Bird Site 356
  • PB357
    HJA Phenology Core Bird Site 357
  • PB358
    HJA Phenology Core Bird Site 358
SITETYPE - char(2) (nominal)

ID: MS04504.SITETYPE

Type of measurement site: core phenology, core bird or auxiliary site

Type system: Microsoft SQL Server 2019

Code definitions (3)
  • PC
    Core phenology site
  • PB
    Core phenology bird site
  • PA
    Core phenology auxiliary site
QC_LEVEL - char(2) (nominal)

ID: MS04504.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: MS04504.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_MEAN - numeric(5,1) (interval)

ID: MS04504.AIRTEMP_MEAN

Mean air temperature over the last hour

Type system: Microsoft SQL Server 2019

Unit: degrees Celsius

Precision: 0.100000

Numeric domain: type=real, min=-18.9000 (exclusive=false), max=47.2000 (exclusive=false)

AIRTEMP_MEAN_FLAG - char(1) (nominal)

ID: MS04504.AIRTEMP_MEAN_FLAG

Mean air temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (4)
  • A
    Accepted value
  • E
    Estimated value
  • M
    Missing value
  • Q
    Questionable value
REGRESSION_SITE - char(6) (nominal)

ID: MS04504.REGRESSION_SITE

Reference site used to estimate values using linear regression

Type system: Microsoft SQL Server 2019

Code definitions (183)
  • RS38__
    Reference Stand RS38, H.J. Andrews EF, Willamette NF
  • CENMET
    Central Meteorological Station
  • UPLMET
    Upper Lookout Meteorological Station
  • VANMET
    Vanilla Leaf Meteorological Station
  • CS2MET
    Climatic Station at Watershed 2
  • H15MET
    High 15 Meteorological Station
  • RS02__
    Reference Stand RS02 air/soil temperature site
  • RS04__
    Reference Stand RS04 air/soil temperature site
  • RS05__
    Reference Stand RS05 air/soil temperature site
  • RS10__
    Reference Stand RS10 air/soil temperature site
  • RS12__
    Reference Stand RS12 air/soil temperature site
  • RS20__
    Reference Stand RS20 air/soil temperature site
  • RS26__
    Reference Stand RS26 air/soil temperature site
  • RS86__
    Reference Stand RS86 air/soil temperature and relative humidity site
  • RS89__
    Reference Stand RS89 air/soil temperature and relative humidity site
  • PC001
    HJA Phenology Core Site 001 (WS01)
  • PC002
    HJA Phenology Core Site 002 (CS2MET/RS07)
  • PC004
    HJA Phenology Core Site 004 (RS89)
  • PC007
    HJA Phenology Core Site 007 (RS05)
  • PC008
    HJA Phenology Core Site 008 (RS32)
  • PC009
    HJA Phenology Core Site 009 (RS12)
  • PC010
    HJA Phenology Core Site 010 (Decomp site 5/CENMET)
  • PC011
    HJA Phenology Core Site 011 (L303/371 RD 350)
  • PC012
    HJA Phenology Core Site 012 (RS18)
  • PC013
    HJA Phenology Core Site 013 (RS21)
  • PC014
    HJA Phenology Core Site 014 (RS03)
  • PC015
    HJA Phenology Core Site 015 (WS08)
  • PC017
    HJA Phenology Core Site 017 (RS04)
  • PA002
    HJA Phenology Auxiliary Site 002
  • PA004
    HJA Phenology Auxiliary Site 004
  • PA005
    HJA Phenology Auxiliary Site 005
  • PA006
    HJA Phenology Auxiliary Site 006
  • PA009
    HJA Phenology Auxiliary Site 009
  • PA010
    HJA Phenology Auxiliary Site 010
  • PA011
    HJA Phenology Auxiliary Site 011
  • PA012
    HJA Phenology Auxiliary Site 012
  • PA013
    HJA Phenology Auxiliary Site 013
  • PA017
    HJA Phenology Auxiliary Site 017
  • PA019
    HJA Phenology Auxiliary Site 019
  • PA020
    HJA Phenology Auxiliary Site 020
  • PA021
    HJA Phenology Auxiliary Site 021
  • PA023
    HJA Phenology Auxiliary Site 023
  • PA027
    HJA Phenology Auxiliary Site 027
  • PA028
    HJA Phenology Auxiliary Site 028
  • PA031
    HJA Phenology Auxiliary Site 031
  • PA032
    HJA Phenology Auxiliary Site 032
  • PA036
    HJA Phenology Auxiliary Site 036
  • PA037
    HJA Phenology Auxiliary Site 037
  • PA038
    HJA Phenology Auxiliary Site 038
  • PA039
    HJA Phenology Auxiliary Site 039
  • PA040
    HJA Phenology Auxiliary Site 040
  • PA042
    HJA Phenology Auxiliary Site 042
  • PA045
    HJA Phenology Auxiliary Site 045
  • PA048
    HJA Phenology Auxiliary Site 048
  • PA051
    HJA Phenology Auxiliary Site 051
  • PA053
    HJA Phenology Auxiliary Site 053
  • PA054
    HJA Phenology Auxiliary Site 054
  • PA059
    HJA Phenology Auxiliary Site 059
  • PA062
    HJA Phenology Auxiliary Site 062
  • PA063
    HJA Phenology Auxiliary Site 063
  • PA064
    HJA Phenology Auxiliary Site 064
  • PA065
    HJA Phenology Auxiliary Site 065
  • PA066
    HJA Phenology Auxiliary Site 066
  • PA076
    HJA Phenology Auxiliary Site 076
  • PA077
    HJA Phenology Auxiliary Site 077
  • PA078
    HJA Phenology Auxiliary Site 078
  • PA079
    HJA Phenology Auxiliary Site 079
  • PA080
    HJA Phenology Auxiliary Site 080
  • PA200
    HJA Phenology Auxiliary Site 200
  • PA203
    HJA Phenology Auxiliary Site 203
  • PA207
    HJA Phenology Auxiliary Site 207
  • PA208
    HJA Phenology Auxiliary Site 208
  • PA209
    HJA Phenology Auxiliary Site 209
  • PA210
    HJA Phenology Auxiliary Site 210
  • PA211
    HJA Phenology Auxiliary Site 211
  • PA217
    HJA Phenology Auxiliary Site 217
  • PA224
    HJA Phenology Auxiliary Site 224
  • PA226
    HJA Phenology Auxiliary Site 226
  • PA233
    HJA Phenology Auxiliary Site 233
  • PA234
    HJA Phenology Auxiliary Site 234
  • PA235
    HJA Phenology Auxiliary Site 235
  • PA239
    HJA Phenology Auxiliary Site 239
  • PA240
    HJA Phenology Auxiliary Site 240
  • PA241
    HJA Phenology Auxiliary Site 241
  • PA243
    HJA Phenology Auxiliary Site 243
  • PA245
    HJA Phenology Auxiliary Site 245
  • PA246
    HJA Phenology Auxiliary Site 246
  • PA247
    HJA Phenology Auxiliary Site 247
  • PA248
    HJA Phenology Auxiliary Site 248
  • PA249
    HJA Phenology Auxiliary Site 249
  • PA250
    HJA Phenology Auxiliary Site 250
  • PA252
    HJA Phenology Auxiliary Site 252
  • PA253
    HJA Phenology Auxiliary Site 253
  • PA256
    HJA Phenology Auxiliary Site 256
  • PA257
    HJA Phenology Auxiliary Site 257
  • PA258
    HJA Phenology Auxiliary Site 258
  • PA259
    HJA Phenology Auxiliary Site 259
  • PA260
    HJA Phenology Auxiliary Site 260
  • PA265
    HJA Phenology Auxiliary Site 265
  • PA270
    HJA Phenology Auxiliary Site 270
  • PA273
    HJA Phenology Auxiliary Site 273
  • PA274
    HJA Phenology Auxiliary Site 274
  • PA275
    HJA Phenology Auxiliary Site 275
  • PA276
    HJA Phenology Auxiliary Site 276
  • PA277
    HJA Phenology Auxiliary Site 277
  • PA279
    HJA Phenology Auxiliary Site 279
  • PA303
    HJA Phenology Auxiliary Site 303
  • PA304
    HJA Phenology Auxiliary Site 304
  • PA305
    HJA Phenology Auxiliary Site 305
  • PA306
    HJA Phenology Auxiliary Site 306
  • PA307
    HJA Phenology Auxiliary Site 307
  • PA308
    HJA Phenology Auxiliary Site 308
  • PA309
    HJA Phenology Auxiliary Site 309
  • PA310
    HJA Phenology Auxiliary Site 310
  • PA311
    HJA Phenology Auxiliary Site 311
  • PA312
    HJA Phenology Auxiliary Site 312
  • PA314
    HJA Phenology Auxiliary Site 314
  • PA317
    HJA Phenology Auxiliary Site 317
  • PA318
    HJA Phenology Auxiliary Site 318
  • PA322
    HJA Phenology Auxiliary Site 322
  • PA323
    HJA Phenology Auxiliary Site 323
  • PA324
    HJA Phenology Auxiliary Site 324
  • PA327
    HJA Phenology Auxiliary Site 327
  • PA328
    HJA Phenology Auxiliary Site 328
  • PA329
    HJA Phenology Auxiliary Site 329
  • PA330
    HJA Phenology Auxiliary Site 330
  • PA334
    HJA Phenology Auxiliary Site 334
  • PA336
    HJA Phenology Auxiliary Site 336
  • PA338
    HJA Phenology Auxiliary Site 338
  • PA339
    HJA Phenology Auxiliary Site 339
  • PA340
    HJA Phenology Auxiliary Site 340
  • PA341
    HJA Phenology Auxiliary Site 341
  • PA342
    HJA Phenology Auxiliary Site 342
  • PA344
    HJA Phenology Auxiliary Site 344
  • PA345
    HJA Phenology Auxiliary Site 345
  • PA347
    HJA Phenology Auxiliary Site 347
  • PA348
    HJA Phenology Auxiliary Site 348
  • PA349
    HJA Phenology Auxiliary Site 349
  • PA350
    HJA Phenology Auxiliary Site 350
  • PA351
    HJA Phenology Auxiliary Site 351
  • PA352
    HJA Phenology Auxiliary Site 352
  • PA353
    HJA Phenology Auxiliary Site 353
  • PA354
    HJA Phenology Auxiliary Site 354
  • PA400
    HJA Phenology Auxiliary Site 400
  • PA506
    HJA Phenology Auxiliary Site 506
  • PB008
    HJA Phenology Core Bird Site 008
  • PB022
    HJA Phenology Core Bird Site 022
  • PB030
    HJA Phenology Core Bird Site 030
  • PB046
    HJA Phenology Core Bird Site 046
  • PB047
    HJA Phenology Core Bird Site 047
  • PB052
    HJA Phenology Core Bird Site 052
  • PB055
    HJA Phenology Core Bird Site 055
  • PB067
    HJA Phenology Core Bird Site 067
  • PB201
    HJA Phenology Core Bird Site 201
  • PB202
    HJA Phenology Core Bird Site 202
  • PB206
    HJA Phenology Core Bird Site 206
  • PB216
    HJA Phenology Core Bird Site 216
  • PB225
    HJA Phenology Core Bird Site 225
  • PB242
    HJA Phenology Core Bird Site 242
  • PB244
    HJA Phenology Core Bird Site 244
  • PB251
    HJA Phenology Core Bird Site 251
  • PB254
    HJA Phenology Core Bird Site 254
  • PB255
    HJA Phenology Core Bird Site 255
  • PB264
    HJA Phenology Core Bird Site 264
  • PB267
    HJA Phenology Core Bird Site 267
  • PB268
    HJA Phenology Core Bird Site 268
  • PB269
    HJA Phenology Core Bird Site 269
  • PB271
    HJA Phenology Core Bird Site 271
  • PB278
    HJA Phenology Core Bird Site 278
  • PB302
    HJA Phenology Core Bird Site 302
  • PB316
    HJA Phenology Core Bird Site 316
  • PB325
    HJA Phenology Core Bird Site 325
  • PB331
    HJA Phenology Core Bird Site 331
  • PB332
    HJA Phenology Core Bird Site 332
  • PB333
    HJA Phenology Core Bird Site 333
  • PB335
    HJA Phenology Core Bird Site 335
  • PB337
    HJA Phenology Core Bird Site 337
  • PB343
    HJA Phenology Core Bird Site 343
  • PB346
    HJA Phenology Core Bird Site 346
  • PB356
    HJA Phenology Core Bird Site 356
  • PB357
    HJA Phenology Core Bird Site 357
  • PB358
    HJA Phenology Core Bird Site 358
  • None
    No estimation (actual data is used)
MS04505 - Fine temporal resolution temperature and light intensity data for core, bird and auxiliary sites (Process A)

Object name: MS04505_v1.txt

Records: 35222601

Attributes: 19

Temporal coverage: 2009-06-02 to 2018-08-12

File size: 2607303008 byte

Checksum (MD5): cac125473085dde04b797198a4506f14

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

Constraints (2)
  • primaryKey: PRIMARY
    MS04505.SITECODE, MS04505.DATE_TIME
  • notNullConstraint: NOTNULL
    MS04505.DBCODE, MS04505.ENTITY, MS04505.SITECODE, MS04505.SITETYPE, MS04505.DATE_TIME, MS04505.QC_LEVEL, MS04505.DAYLIGHT, MS04505.TIME_GAP, MS04505.EXTREME_TEMP, MS04505.JUMP, MS04505.EXTREME_INTENSITY, MS04505.HIGH_INTENSITY, MS04505.RADIATION_BIAS_INTENSITY, MS04505.LOW_DAYLIGHT_INTENSITY, MS04505.NIGHTTIME_INTENSITY, MS04505.SNOW, MS04505.TEMP_SPIKE
Attributes (19)
DBCODE - char(5) (nominal)

ID: MS04505.DBCODE

FSDB database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • MS045
    FSDB database code
ENTITY - numeric(2,0) (interval)

ID: MS04505.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1

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

SITECODE - char(5) (nominal)

ID: MS04505.SITECODE

Site code for the phenology measurement location

Type system: Microsoft SQL Server 2019

Code definitions (184)
  • PC001
    HJA Phenology Core Site 001 (WS01)
  • PC002
    HJA Phenology Core Site 002 (CS2MET/RS07)
  • PC004
    HJA Phenology Core Site 004 (RS89)
  • PC005
    HJA Phenology Core Site 005 (RS86)
  • PC007
    HJA Phenology Core Site 007 (RS05)
  • PC008
    HJA Phenology Core Site 008 (RS32)
  • PC009
    HJA Phenology Core Site 009 (RS12)
  • PC010
    HJA Phenology Core Site 010 (Decomp site 5/CENMET)
  • PC011
    HJA Phenology Core Site 011 (L303/371 RD 350)
  • PC012
    HJA Phenology Core Site 012 (RS18)
  • PC013
    HJA Phenology Core Site 013 (RS21)
  • PC014
    HJA Phenology Core Site 014 (RS03)
  • PC015
    HJA Phenology Core Site 015 (WS08)
  • PC016
    HJA Phenology Core Site 016 (NADP/WS07)
  • PC017
    HJA Phenology Core Site 017 (RS04)
  • PC018
    HJA Phenology Core Site 018 (L306 RD 350)
  • PA002
    HJA Phenology Auxiliary Site 002
  • PA003
    HJA Phenology Auxiliary Site 003
  • PA004
    HJA Phenology Auxiliary Site 004
  • PA005
    HJA Phenology Auxiliary Site 005
  • PA006
    HJA Phenology Auxiliary Site 006
  • PA009
    HJA Phenology Auxiliary Site 009
  • PA010
    HJA Phenology Auxiliary Site 010
  • PA011
    HJA Phenology Auxiliary Site 011
  • PA012
    HJA Phenology Auxiliary Site 012
  • PA013
    HJA Phenology Auxiliary Site 013
  • PA016
    HJA Phenology Auxiliary Site 016
  • PA017
    HJA Phenology Auxiliary Site 017
  • PA018
    HJA Phenology Auxiliary Site 018
  • PA019
    HJA Phenology Auxiliary Site 019
  • PA020
    HJA Phenology Auxiliary Site 020
  • PA021
    HJA Phenology Auxiliary Site 021
  • PA023
    HJA Phenology Auxiliary Site 023
  • PA027
    HJA Phenology Auxiliary Site 027
  • PA028
    HJA Phenology Auxiliary Site 028
  • PA029
    HJA Phenology Auxiliary Site 029
  • PA031
    HJA Phenology Auxiliary Site 031
  • PA032
    HJA Phenology Auxiliary Site 032
  • PA036
    HJA Phenology Auxiliary Site 036
  • PA037
    HJA Phenology Auxiliary Site 037
  • PA038
    HJA Phenology Auxiliary Site 038
  • PA039
    HJA Phenology Auxiliary Site 039
  • PA040
    HJA Phenology Auxiliary Site 040
  • PA041
    HJA Phenology Auxiliary Site 041
  • PA042
    HJA Phenology Auxiliary Site 042
  • PA044
    HJA Phenology Auxiliary Site 044
  • PA045
    HJA Phenology Auxiliary Site 045
  • PA048
    HJA Phenology Auxiliary Site 048
  • PA051
    HJA Phenology Auxiliary Site 051
  • PA053
    HJA Phenology Auxiliary Site 053
  • PA054
    HJA Phenology Auxiliary Site 054
  • PA059
    HJA Phenology Auxiliary Site 059
  • PA062
    HJA Phenology Auxiliary Site 062
  • PA063
    HJA Phenology Auxiliary Site 063
  • PA064
    HJA Phenology Auxiliary Site 064
  • PA065
    HJA Phenology Auxiliary Site 065
  • PA066
    HJA Phenology Auxiliary Site 066
  • PA076
    HJA Phenology Auxiliary Site 076
  • PA077
    HJA Phenology Auxiliary Site 077
  • PA078
    HJA Phenology Auxiliary Site 078
  • PA079
    HJA Phenology Auxiliary Site 079
  • PA080
    HJA Phenology Auxiliary Site 080
  • PA081
    HJA Phenology Auxiliary Site 081
  • PA200
    HJA Phenology Auxiliary Site 200
  • PA203
    HJA Phenology Auxiliary Site 203
  • PA204
    HJA Phenology Auxiliary Site 204
  • PA207
    HJA Phenology Auxiliary Site 207
  • PA208
    HJA Phenology Auxiliary Site 208
  • PA209
    HJA Phenology Auxiliary Site 209
  • PA210
    HJA Phenology Auxiliary Site 210
  • PA211
    HJA Phenology Auxiliary Site 211
  • PA217
    HJA Phenology Auxiliary Site 217
  • PA224
    HJA Phenology Auxiliary Site 224
  • PA226
    HJA Phenology Auxiliary Site 226
  • PA233
    HJA Phenology Auxiliary Site 233
  • PA234
    HJA Phenology Auxiliary Site 234
  • PA235
    HJA Phenology Auxiliary Site 235
  • PA239
    HJA Phenology Auxiliary Site 239
  • PA240
    HJA Phenology Auxiliary Site 240
  • PA241
    HJA Phenology Auxiliary Site 241
  • PA243
    HJA Phenology Auxiliary Site 243
  • PA245
    HJA Phenology Auxiliary Site 245
  • PA246
    HJA Phenology Auxiliary Site 246
  • PA247
    HJA Phenology Auxiliary Site 247
  • PA248
    HJA Phenology Auxiliary Site 248
  • PA249
    HJA Phenology Auxiliary Site 249
  • PA250
    HJA Phenology Auxiliary Site 250
  • PA252
    HJA Phenology Auxiliary Site 252
  • PA253
    HJA Phenology Auxiliary Site 253
  • PA256
    HJA Phenology Auxiliary Site 256
  • PA257
    HJA Phenology Auxiliary Site 257
  • PA258
    HJA Phenology Auxiliary Site 258
  • PA259
    HJA Phenology Auxiliary Site 259
  • PA260
    HJA Phenology Auxiliary Site 260
  • PA265
    HJA Phenology Auxiliary Site 265
  • PA266
    HJA Phenology Auxiliary Site 266
  • PA270
    HJA Phenology Auxiliary Site 270
  • PA272
    HJA Phenology Auxiliary Site 272
  • PA273
    HJA Phenology Auxiliary Site 273
  • PA274
    HJA Phenology Auxiliary Site 274
  • PA275
    HJA Phenology Auxiliary Site 275
  • PA276
    HJA Phenology Auxiliary Site 276
  • PA277
    HJA Phenology Auxiliary Site 277
  • PA279
    HJA Phenology Auxiliary Site 279
  • PA303
    HJA Phenology Auxiliary Site 303
  • PA304
    HJA Phenology Auxiliary Site 304
  • PA305
    HJA Phenology Auxiliary Site 305
  • PA306
    HJA Phenology Auxiliary Site 306
  • PA307
    HJA Phenology Auxiliary Site 307
  • PA308
    HJA Phenology Auxiliary Site 308
  • PA309
    HJA Phenology Auxiliary Site 309
  • PA310
    HJA Phenology Auxiliary Site 310
  • PA311
    HJA Phenology Auxiliary Site 311
  • PA312
    HJA Phenology Auxiliary Site 312
  • PA314
    HJA Phenology Auxiliary Site 314
  • PA315
    HJA Phenology Auxiliary Site 315
  • PA317
    HJA Phenology Auxiliary Site 317
  • PA318
    HJA Phenology Auxiliary Site 318
  • PA322
    HJA Phenology Auxiliary Site 322
  • PA323
    HJA Phenology Auxiliary Site 323
  • PA324
    HJA Phenology Auxiliary Site 324
  • PA327
    HJA Phenology Auxiliary Site 327
  • PA328
    HJA Phenology Auxiliary Site 328
  • PA329
    HJA Phenology Auxiliary Site 329
  • PA330
    HJA Phenology Auxiliary Site 330
  • PA334
    HJA Phenology Auxiliary Site 334
  • PA336
    HJA Phenology Auxiliary Site 336
  • PA338
    HJA Phenology Auxiliary Site 338
  • PA339
    HJA Phenology Auxiliary Site 339
  • PA340
    HJA Phenology Auxiliary Site 340
  • PA341
    HJA Phenology Auxiliary Site 341
  • PA342
    HJA Phenology Auxiliary Site 342
  • PA344
    HJA Phenology Auxiliary Site 344
  • PA345
    HJA Phenology Auxiliary Site 345
  • PA347
    HJA Phenology Auxiliary Site 347
  • PA348
    HJA Phenology Auxiliary Site 348
  • PA349
    HJA Phenology Auxiliary Site 349
  • PA350
    HJA Phenology Auxiliary Site 350
  • PA351
    HJA Phenology Auxiliary Site 351
  • PA352
    HJA Phenology Auxiliary Site 352
  • PA353
    HJA Phenology Auxiliary Site 353
  • PA354
    HJA Phenology Auxiliary Site 354
  • PA400
    HJA Phenology Auxiliary Site 400
  • PA506
    HJA Phenology Auxiliary Site 506
  • PB008
    HJA Phenology Core Bird Site 008
  • PB014
    HJA Phenology Core Bird Site 014
  • PB022
    HJA Phenology Core Bird Site 022
  • PB030
    HJA Phenology Core Bird Site 030
  • PB046
    HJA Phenology Core Bird Site 046
  • PB047
    HJA Phenology Core Bird Site 047
  • PB052
    HJA Phenology Core Bird Site 052
  • PB055
    HJA Phenology Core Bird Site 055
  • PB060
    HJA Phenology Core Bird Site 060
  • PB067
    HJA Phenology Core Bird Site 067
  • PB201
    HJA Phenology Core Bird Site 201
  • PB202
    HJA Phenology Core Bird Site 202
  • PB206
    HJA Phenology Core Bird Site 206
  • PB216
    HJA Phenology Core Bird Site 216
  • PB225
    HJA Phenology Core Bird Site 225
  • PB242
    HJA Phenology Core Bird Site 242
  • PB244
    HJA Phenology Core Bird Site 244
  • PB251
    HJA Phenology Core Bird Site 251
  • PB254
    HJA Phenology Core Bird Site 254
  • PB255
    HJA Phenology Core Bird Site 255
  • PB264
    HJA Phenology Core Bird Site 264
  • PB267
    HJA Phenology Core Bird Site 267
  • PB268
    HJA Phenology Core Bird Site 268
  • PB269
    HJA Phenology Core Bird Site 269
  • PB271
    HJA Phenology Core Bird Site 271
  • PB278
    HJA Phenology Core Bird Site 278
  • PB302
    HJA Phenology Core Bird Site 302
  • PB316
    HJA Phenology Core Bird Site 316
  • PB325
    HJA Phenology Core Bird Site 325
  • PB326
    HJA Phenology Core Bird Site 326
  • PB331
    HJA Phenology Core Bird Site 331
  • PB332
    HJA Phenology Core Bird Site 332
  • PB333
    HJA Phenology Core Bird Site 333
  • PB335
    HJA Phenology Core Bird Site 335
  • PB337
    HJA Phenology Core Bird Site 337
  • PB343
    HJA Phenology Core Bird Site 343
  • PB346
    HJA Phenology Core Bird Site 346
  • PB356
    HJA Phenology Core Bird Site 356
  • PB357
    HJA Phenology Core Bird Site 357
  • PB358
    HJA Phenology Core Bird Site 358
SITETYPE - char(2) (nominal)

ID: MS04505.SITETYPE

Type of measurement site: core phenology, core bird or auxiliary site

Type system: Microsoft SQL Server 2019

Code definitions (3)
  • PC
    Core phenology site
  • PB
    Core phenology bird site
  • PA
    Core phenology auxiliary site
QC_LEVEL - char(2) (nominal)

ID: MS04505.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: MS04505.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: MS04505.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=-84.7710 (exclusive=false), max=398.6640 (exclusive=false)

INTENSITY - numeric(7,0) (ratio)

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

DAYLIGHT - char(1) (nominal)

ID: MS04505.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: MS04505.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: MS04505.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: MS04505.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: MS04505.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: MS04505.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: MS04505.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: MS04505.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: MS04505.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: MS04505.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: MS04505.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
MS04506 - Fine temporal resolution temperature and light intensity data for core, bird and auxiliary sites (Process B)

Object name: MS04506_v1.txt

Records: 17452962

Attributes: 11

Temporal coverage: 2018-07-19 to 2022-10-08

File size: 1131507874 byte

Checksum (MD5): b188378ab95dd5d1bc4178e32c93e5f7

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

Constraints (2)
  • primaryKey: PRIMARY
    MS04506.DATE_TIME, MS04506.PROBE_CODE
  • notNullConstraint: NOTNULL
    MS04506.DBCODE, MS04506.ENTITY, MS04506.SITECODE, MS04506.SITETYPE, MS04506.DATE_TIME, MS04506.QC_LEVEL, MS04506.AIRTEMP_INST_FLAG, MS04506.INTENSITY_FLAG, MS04506.PROBE_CODE
Attributes (11)
DBCODE - char(5) (nominal)

ID: MS04506.DBCODE

FSDB database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • MS045
    FSDB database code
ENTITY - numeric(2,0) (interval)

ID: MS04506.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1

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

SITECODE - char(5) (nominal)

ID: MS04506.SITECODE

Site code for the phenology measurement location

Type system: Microsoft SQL Server 2019

Code definitions (184)
  • PC001
    HJA Phenology Core Site 001 (WS01)
  • PC002
    HJA Phenology Core Site 002 (CS2MET/RS07)
  • PC004
    HJA Phenology Core Site 004 (RS89)
  • PC005
    HJA Phenology Core Site 005 (RS86)
  • PC007
    HJA Phenology Core Site 007 (RS05)
  • PC008
    HJA Phenology Core Site 008 (RS32)
  • PC009
    HJA Phenology Core Site 009 (RS12)
  • PC010
    HJA Phenology Core Site 010 (Decomp site 5/CENMET)
  • PC011
    HJA Phenology Core Site 011 (L303/371 RD 350)
  • PC012
    HJA Phenology Core Site 012 (RS18)
  • PC013
    HJA Phenology Core Site 013 (RS21)
  • PC014
    HJA Phenology Core Site 014 (RS03)
  • PC015
    HJA Phenology Core Site 015 (WS08)
  • PC016
    HJA Phenology Core Site 016 (NADP/WS07)
  • PC017
    HJA Phenology Core Site 017 (RS04)
  • PC018
    HJA Phenology Core Site 018 (L306 RD 350)
  • PA002
    HJA Phenology Auxiliary Site 002
  • PA003
    HJA Phenology Auxiliary Site 003
  • PA004
    HJA Phenology Auxiliary Site 004
  • PA005
    HJA Phenology Auxiliary Site 005
  • PA006
    HJA Phenology Auxiliary Site 006
  • PA009
    HJA Phenology Auxiliary Site 009
  • PA010
    HJA Phenology Auxiliary Site 010
  • PA011
    HJA Phenology Auxiliary Site 011
  • PA012
    HJA Phenology Auxiliary Site 012
  • PA013
    HJA Phenology Auxiliary Site 013
  • PA016
    HJA Phenology Auxiliary Site 016
  • PA017
    HJA Phenology Auxiliary Site 017
  • PA018
    HJA Phenology Auxiliary Site 018
  • PA019
    HJA Phenology Auxiliary Site 019
  • PA020
    HJA Phenology Auxiliary Site 020
  • PA021
    HJA Phenology Auxiliary Site 021
  • PA023
    HJA Phenology Auxiliary Site 023
  • PA027
    HJA Phenology Auxiliary Site 027
  • PA028
    HJA Phenology Auxiliary Site 028
  • PA029
    HJA Phenology Auxiliary Site 029
  • PA031
    HJA Phenology Auxiliary Site 031
  • PA032
    HJA Phenology Auxiliary Site 032
  • PA036
    HJA Phenology Auxiliary Site 036
  • PA037
    HJA Phenology Auxiliary Site 037
  • PA038
    HJA Phenology Auxiliary Site 038
  • PA039
    HJA Phenology Auxiliary Site 039
  • PA040
    HJA Phenology Auxiliary Site 040
  • PA041
    HJA Phenology Auxiliary Site 041
  • PA042
    HJA Phenology Auxiliary Site 042
  • PA044
    HJA Phenology Auxiliary Site 044
  • PA045
    HJA Phenology Auxiliary Site 045
  • PA048
    HJA Phenology Auxiliary Site 048
  • PA051
    HJA Phenology Auxiliary Site 051
  • PA053
    HJA Phenology Auxiliary Site 053
  • PA054
    HJA Phenology Auxiliary Site 054
  • PA059
    HJA Phenology Auxiliary Site 059
  • PA062
    HJA Phenology Auxiliary Site 062
  • PA063
    HJA Phenology Auxiliary Site 063
  • PA064
    HJA Phenology Auxiliary Site 064
  • PA065
    HJA Phenology Auxiliary Site 065
  • PA066
    HJA Phenology Auxiliary Site 066
  • PA076
    HJA Phenology Auxiliary Site 076
  • PA077
    HJA Phenology Auxiliary Site 077
  • PA078
    HJA Phenology Auxiliary Site 078
  • PA079
    HJA Phenology Auxiliary Site 079
  • PA080
    HJA Phenology Auxiliary Site 080
  • PA081
    HJA Phenology Auxiliary Site 081
  • PA200
    HJA Phenology Auxiliary Site 200
  • PA203
    HJA Phenology Auxiliary Site 203
  • PA204
    HJA Phenology Auxiliary Site 204
  • PA207
    HJA Phenology Auxiliary Site 207
  • PA208
    HJA Phenology Auxiliary Site 208
  • PA209
    HJA Phenology Auxiliary Site 209
  • PA210
    HJA Phenology Auxiliary Site 210
  • PA211
    HJA Phenology Auxiliary Site 211
  • PA217
    HJA Phenology Auxiliary Site 217
  • PA224
    HJA Phenology Auxiliary Site 224
  • PA226
    HJA Phenology Auxiliary Site 226
  • PA233
    HJA Phenology Auxiliary Site 233
  • PA234
    HJA Phenology Auxiliary Site 234
  • PA235
    HJA Phenology Auxiliary Site 235
  • PA239
    HJA Phenology Auxiliary Site 239
  • PA240
    HJA Phenology Auxiliary Site 240
  • PA241
    HJA Phenology Auxiliary Site 241
  • PA243
    HJA Phenology Auxiliary Site 243
  • PA245
    HJA Phenology Auxiliary Site 245
  • PA246
    HJA Phenology Auxiliary Site 246
  • PA247
    HJA Phenology Auxiliary Site 247
  • PA248
    HJA Phenology Auxiliary Site 248
  • PA249
    HJA Phenology Auxiliary Site 249
  • PA250
    HJA Phenology Auxiliary Site 250
  • PA252
    HJA Phenology Auxiliary Site 252
  • PA253
    HJA Phenology Auxiliary Site 253
  • PA256
    HJA Phenology Auxiliary Site 256
  • PA257
    HJA Phenology Auxiliary Site 257
  • PA258
    HJA Phenology Auxiliary Site 258
  • PA259
    HJA Phenology Auxiliary Site 259
  • PA260
    HJA Phenology Auxiliary Site 260
  • PA265
    HJA Phenology Auxiliary Site 265
  • PA266
    HJA Phenology Auxiliary Site 266
  • PA270
    HJA Phenology Auxiliary Site 270
  • PA272
    HJA Phenology Auxiliary Site 272
  • PA273
    HJA Phenology Auxiliary Site 273
  • PA274
    HJA Phenology Auxiliary Site 274
  • PA275
    HJA Phenology Auxiliary Site 275
  • PA276
    HJA Phenology Auxiliary Site 276
  • PA277
    HJA Phenology Auxiliary Site 277
  • PA279
    HJA Phenology Auxiliary Site 279
  • PA303
    HJA Phenology Auxiliary Site 303
  • PA304
    HJA Phenology Auxiliary Site 304
  • PA305
    HJA Phenology Auxiliary Site 305
  • PA306
    HJA Phenology Auxiliary Site 306
  • PA307
    HJA Phenology Auxiliary Site 307
  • PA308
    HJA Phenology Auxiliary Site 308
  • PA309
    HJA Phenology Auxiliary Site 309
  • PA310
    HJA Phenology Auxiliary Site 310
  • PA311
    HJA Phenology Auxiliary Site 311
  • PA312
    HJA Phenology Auxiliary Site 312
  • PA314
    HJA Phenology Auxiliary Site 314
  • PA315
    HJA Phenology Auxiliary Site 315
  • PA317
    HJA Phenology Auxiliary Site 317
  • PA318
    HJA Phenology Auxiliary Site 318
  • PA322
    HJA Phenology Auxiliary Site 322
  • PA323
    HJA Phenology Auxiliary Site 323
  • PA324
    HJA Phenology Auxiliary Site 324
  • PA327
    HJA Phenology Auxiliary Site 327
  • PA328
    HJA Phenology Auxiliary Site 328
  • PA329
    HJA Phenology Auxiliary Site 329
  • PA330
    HJA Phenology Auxiliary Site 330
  • PA334
    HJA Phenology Auxiliary Site 334
  • PA336
    HJA Phenology Auxiliary Site 336
  • PA338
    HJA Phenology Auxiliary Site 338
  • PA339
    HJA Phenology Auxiliary Site 339
  • PA340
    HJA Phenology Auxiliary Site 340
  • PA341
    HJA Phenology Auxiliary Site 341
  • PA342
    HJA Phenology Auxiliary Site 342
  • PA344
    HJA Phenology Auxiliary Site 344
  • PA345
    HJA Phenology Auxiliary Site 345
  • PA347
    HJA Phenology Auxiliary Site 347
  • PA348
    HJA Phenology Auxiliary Site 348
  • PA349
    HJA Phenology Auxiliary Site 349
  • PA350
    HJA Phenology Auxiliary Site 350
  • PA351
    HJA Phenology Auxiliary Site 351
  • PA352
    HJA Phenology Auxiliary Site 352
  • PA353
    HJA Phenology Auxiliary Site 353
  • PA354
    HJA Phenology Auxiliary Site 354
  • PA400
    HJA Phenology Auxiliary Site 400
  • PA506
    HJA Phenology Auxiliary Site 506
  • PB008
    HJA Phenology Core Bird Site 008
  • PB014
    HJA Phenology Core Bird Site 014
  • PB022
    HJA Phenology Core Bird Site 022
  • PB030
    HJA Phenology Core Bird Site 030
  • PB046
    HJA Phenology Core Bird Site 046
  • PB047
    HJA Phenology Core Bird Site 047
  • PB052
    HJA Phenology Core Bird Site 052
  • PB055
    HJA Phenology Core Bird Site 055
  • PB060
    HJA Phenology Core Bird Site 060
  • PB067
    HJA Phenology Core Bird Site 067
  • PB201
    HJA Phenology Core Bird Site 201
  • PB202
    HJA Phenology Core Bird Site 202
  • PB206
    HJA Phenology Core Bird Site 206
  • PB216
    HJA Phenology Core Bird Site 216
  • PB225
    HJA Phenology Core Bird Site 225
  • PB242
    HJA Phenology Core Bird Site 242
  • PB244
    HJA Phenology Core Bird Site 244
  • PB251
    HJA Phenology Core Bird Site 251
  • PB254
    HJA Phenology Core Bird Site 254
  • PB255
    HJA Phenology Core Bird Site 255
  • PB264
    HJA Phenology Core Bird Site 264
  • PB267
    HJA Phenology Core Bird Site 267
  • PB268
    HJA Phenology Core Bird Site 268
  • PB269
    HJA Phenology Core Bird Site 269
  • PB271
    HJA Phenology Core Bird Site 271
  • PB278
    HJA Phenology Core Bird Site 278
  • PB302
    HJA Phenology Core Bird Site 302
  • PB316
    HJA Phenology Core Bird Site 316
  • PB325
    HJA Phenology Core Bird Site 325
  • PB326
    HJA Phenology Core Bird Site 326
  • PB331
    HJA Phenology Core Bird Site 331
  • PB332
    HJA Phenology Core Bird Site 332
  • PB333
    HJA Phenology Core Bird Site 333
  • PB335
    HJA Phenology Core Bird Site 335
  • PB337
    HJA Phenology Core Bird Site 337
  • PB343
    HJA Phenology Core Bird Site 343
  • PB346
    HJA Phenology Core Bird Site 346
  • PB356
    HJA Phenology Core Bird Site 356
  • PB357
    HJA Phenology Core Bird Site 357
  • PB358
    HJA Phenology Core Bird Site 358
SITETYPE - char(2) (nominal)

ID: MS04506.SITETYPE

Type of measurement site: core phenology, core bird or auxiliary site

Type system: Microsoft SQL Server 2019

Code definitions (3)
  • PC
    Core phenology site
  • PB
    Core phenology bird site
  • PA
    Core phenology auxiliary site
QC_LEVEL - char(2) (nominal)

ID: MS04506.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: MS04506.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

PROBE_CODE - char(8) (nominal)

ID: MS04506.PROBE_CODE

Probe code indicates that site and sensor height

Type system: Microsoft SQL Server 2019

Code definitions (184)
  • PA348015
    Site PA348 at height 1.5 meters above ground
  • PB008015
    Site PB008 at height 1.5 meters above ground
  • PB014015
    Site PB014 at height 1.5 meters above ground
  • PB325015
    Site PB325 at height 1.5 meters above ground
  • PB326015
    Site PB326 at height 1.5 meters above ground
  • PC002015
    Site PC002 at height 1.5 meters above ground
  • PC009015
    Site PC009 at height 1.5 meters above ground
  • PC011015
    Site PC011 at height 1.5 meters above ground
  • PC012015
    Site PC012 at height 1.5 meters above ground
  • PC017015
    Site PC017 at height 1.5 meters above ground
  • PC018015
    Site PC018 at height 1.5 meters above ground
  • PA002015
    Site PA002 at height 1.5 meters above ground
  • PA003015
    Site PA003 at height 1.5 meters above ground
  • PA004015
    Site PA004 at height 1.5 meters above ground
  • PA005015
    Site PA005 at height 1.5 meters above ground
  • PA006015
    Site PA006 at height 1.5 meters above ground
  • PA009015
    Site PA009 at height 1.5 meters above ground
  • PA010015
    Site PA010 at height 1.5 meters above ground
  • PA011015
    Site PA011 at height 1.5 meters above ground
  • PA012015
    Site PA012 at height 1.5 meters above ground
  • PA013015
    Site PA013 at height 1.5 meters above ground
  • PA016015
    Site PA016 at height 1.5 meters above ground
  • PA017015
    Site PA017 at height 1.5 meters above ground
  • PA018015
    Site PA018 at height 1.5 meters above ground
  • PA019015
    Site PA019 at height 1.5 meters above ground
  • PA020015
    Site PA020 at height 1.5 meters above ground
  • PA021015
    Site PA021 at height 1.5 meters above ground
  • PB022015
    Site PB022 at height 1.5 meters above ground
  • PA023015
    Site PA023 at height 1.5 meters above ground
  • PA027015
    Site PA027 at height 1.5 meters above ground
  • PA028015
    Site PA028 at height 1.5 meters above ground
  • PA029015
    Site PA029 at height 1.5 meters above ground
  • PB030015
    Site PB030 at height 1.5 meters above ground
  • PA031015
    Site PA031 at height 1.5 meters above ground
  • PA032015
    Site PA032 at height 1.5 meters above ground
  • PA036015
    Site PA036 at height 1.5 meters above ground
  • PA037015
    Site PA037 at height 1.5 meters above ground
  • PA038015
    Site PA038 at height 1.5 meters above ground
  • PA039015
    Site PA039 at height 1.5 meters above ground
  • PA040015
    Site PA040 at height 1.5 meters above ground
  • PA041015
    Site PA041 at height 1.5 meters above ground
  • PA042015
    Site PA042 at height 1.5 meters above ground
  • PA044015
    Site PA044 at height 1.5 meters above ground
  • PA045015
    Site PA045 at height 1.5 meters above ground
  • PB046015
    Site PB046 at height 1.5 meters above ground
  • PB047015
    Site PB047 at height 1.5 meters above ground
  • PA048015
    Site PA048 at height 1.5 meters above ground
  • PA051015
    Site PA051 at height 1.5 meters above ground
  • PB052015
    Site PB052 at height 1.5 meters above ground
  • PA053015
    Site PA053 at height 1.5 meters above ground
  • PA054015
    Site PA054 at height 1.5 meters above ground
  • PB055015
    Site PB055 at height 1.5 meters above ground
  • PA059015
    Site PA059 at height 1.5 meters above ground
  • PB060015
    Site PB060 at height 1.5 meters above ground
  • PA062015
    Site PA062 at height 1.5 meters above ground
  • PA063015
    Site PA063 at height 1.5 meters above ground
  • PA064015
    Site PA064 at height 1.5 meters above ground
  • PA065015
    Site PA065 at height 1.5 meters above ground
  • PA066015
    Site PA066 at height 1.5 meters above ground
  • PB067015
    Site PB067 at height 1.5 meters above ground
  • PA076015
    Site PA076 at height 1.5 meters above ground
  • PA077015
    Site PA077 at height 1.5 meters above ground
  • PA078015
    Site PA078 at height 1.5 meters above ground
  • PA079015
    Site PA079 at height 1.5 meters above ground
  • PA080015
    Site PA080 at height 1.5 meters above ground
  • PA081015
    Site PA081 at height 1.5 meters above ground
  • PA200015
    Site PA200 at height 1.5 meters above ground
  • PB201015
    Site PB201 at height 1.5 meters above ground
  • PB202015
    Site PB202 at height 1.5 meters above ground
  • PA203015
    Site PA203 at height 1.5 meters above ground
  • PA204015
    Site PA204 at height 1.5 meters above ground
  • PB206015
    Site PB206 at height 1.5 meters above ground
  • PA207015
    Site PA207 at height 1.5 meters above ground
  • PA208015
    Site PA208 at height 1.5 meters above ground
  • PA209015
    Site PA209 at height 1.5 meters above ground
  • PA210015
    Site PA210 at height 1.5 meters above ground
  • PA211015
    Site PA211 at height 1.5 meters above ground
  • PB216015
    Site PB216 at height 1.5 meters above ground
  • PA217015
    Site PA217 at height 1.5 meters above ground
  • PA224015
    Site PA224 at height 1.5 meters above ground
  • PB225015
    Site PB225 at height 1.5 meters above ground
  • PA226015
    Site PA226 at height 1.5 meters above ground
  • PA233015
    Site PA233 at height 1.5 meters above ground
  • PA234015
    Site PA234 at height 1.5 meters above ground
  • PA235015
    Site PA235 at height 1.5 meters above ground
  • PA239015
    Site PA239 at height 1.5 meters above ground
  • PA240015
    Site PA240 at height 1.5 meters above ground
  • PA241015
    Site PA241 at height 1.5 meters above ground
  • PB242015
    Site PB242 at height 1.5 meters above ground
  • PA243015
    Site PA243 at height 1.5 meters above ground
  • PB244015
    Site PB244 at height 1.5 meters above ground
  • PA245015
    Site PA245 at height 1.5 meters above ground
  • PA246015
    Site PA246 at height 1.5 meters above ground
  • PA247015
    Site PA247 at height 1.5 meters above ground
  • PA248015
    Site PA248 at height 1.5 meters above ground
  • PA249015
    Site PA249 at height 1.5 meters above ground
  • PA250015
    Site PA250 at height 1.5 meters above ground
  • PB251015
    Site PB251 at height 1.5 meters above ground
  • PA252015
    Site PA252 at height 1.5 meters above ground
  • PA253015
    Site PA253 at height 1.5 meters above ground
  • PB254015
    Site PB254 at height 1.5 meters above ground
  • PB255015
    Site PB255 at height 1.5 meters above ground
  • PA256015
    Site PA256 at height 1.5 meters above ground
  • PA257015
    Site PA257 at height 1.5 meters above ground
  • PA258015
    Site PA258 at height 1.5 meters above ground
  • PA259015
    Site PA259 at height 1.5 meters above ground
  • PA260015
    Site PA260 at height 1.5 meters above ground
  • PB264015
    Site PB264 at height 1.5 meters above ground
  • PA265015
    Site PA265 at height 1.5 meters above ground
  • PA266015
    Site PA266 at height 1.5 meters above ground
  • PB267015
    Site PB267 at height 1.5 meters above ground
  • PB268015
    Site PB268 at height 1.5 meters above ground
  • PB269015
    Site PB269 at height 1.5 meters above ground
  • PA270015
    Site PA270 at height 1.5 meters above ground
  • PB271015
    Site PB271 at height 1.5 meters above ground
  • PA272015
    Site PA272 at height 1.5 meters above ground
  • PA273015
    Site PA273 at height 1.5 meters above ground
  • PA274015
    Site PA274 at height 1.5 meters above ground
  • PA275015
    Site PA275 at height 1.5 meters above ground
  • PA276015
    Site PA276 at height 1.5 meters above ground
  • PA277015
    Site PA277 at height 1.5 meters above ground
  • PB278015
    Site PB278 at height 1.5 meters above ground
  • PA279015
    Site PA279 at height 1.5 meters above ground
  • PB302015
    Site PB302 at height 1.5 meters above ground
  • PA303015
    Site PA303 at height 1.5 meters above ground
  • PA304015
    Site PA304 at height 1.5 meters above ground
  • PA305015
    Site PA305 at height 1.5 meters above ground
  • PA306015
    Site PA306 at height 1.5 meters above ground
  • PA307015
    Site PA307 at height 1.5 meters above ground
  • PA308015
    Site PA308 at height 1.5 meters above ground
  • PA309015
    Site PA309 at height 1.5 meters above ground
  • PA310015
    Site PA310 at height 1.5 meters above ground
  • PA311015
    Site PA311 at height 1.5 meters above ground
  • PA312015
    Site PA312 at height 1.5 meters above ground
  • PA314015
    Site PA314 at height 1.5 meters above ground
  • PA315015
    Site PA315 at height 1.5 meters above ground
  • PB316015
    Site PB316 at height 1.5 meters above ground
  • PA317015
    Site PA317 at height 1.5 meters above ground
  • PA318015
    Site PA318 at height 1.5 meters above ground
  • PA322015
    Site PA322 at height 1.5 meters above ground
  • PA323015
    Site PA323 at height 1.5 meters above ground
  • PA324015
    Site PA324 at height 1.5 meters above ground
  • PA327015
    Site PA327 at height 1.5 meters above ground
  • PA328015
    Site PA328 at height 1.5 meters above ground
  • PA329015
    Site PA329 at height 1.5 meters above ground
  • PA330015
    Site PA330 at height 1.5 meters above ground
  • PB331015
    Site PB331 at height 1.5 meters above ground
  • PB332015
    Site PB332 at height 1.5 meters above ground
  • PB333015
    Site PB333 at height 1.5 meters above ground
  • PA334015
    Site PA334 at height 1.5 meters above ground
  • PB335015
    Site PB335 at height 1.5 meters above ground
  • PA336015
    Site PA336 at height 1.5 meters above ground
  • PB337015
    Site PB337 at height 1.5 meters above ground
  • PA338015
    Site PA338 at height 1.5 meters above ground
  • PA339015
    Site PA339 at height 1.5 meters above ground
  • PA340015
    Site PA340 at height 1.5 meters above ground
  • PA341015
    Site PA341 at height 1.5 meters above ground
  • PA342015
    Site PA342 at height 1.5 meters above ground
  • PB343015
    Site PB343 at height 1.5 meters above ground
  • PA344015
    Site PA344 at height 1.5 meters above ground
  • PA345015
    Site PA345 at height 1.5 meters above ground
  • PB346015
    Site PB346 at height 1.5 meters above ground
  • PA347015
    Site PA347 at height 1.5 meters above ground
  • PA349015
    Site PA349 at height 1.5 meters above ground
  • PA350015
    Site PA350 at height 1.5 meters above ground
  • PA351015
    Site PA351 at height 1.5 meters above ground
  • PA352015
    Site PA352 at height 1.5 meters above ground
  • PA353015
    Site PA353 at height 1.5 meters above ground
  • PA354015
    Site PA354 at height 1.5 meters above ground
  • PB356015
    Site PB356 at height 1.5 meters above ground
  • PB357015
    Site PB357 at height 1.5 meters above ground
  • PB358015
    Site PB358 at height 1.5 meters above ground
  • PA400015
    Site PA400 at height 1.5 meters above ground
  • PA506015
    Site PA506 at height 1.5 meters above ground
  • PC001015
    Site PC001 at height 1.5 meters above ground
  • PC004015
    Site PC004 at height 1.5 meters above ground
  • PC005015
    Site PC005 at height 1.5 meters above ground
  • PC007015
    Site PC007 at height 1.5 meters above ground
  • PC008015
    Site PC008 at height 1.5 meters above ground
  • PC010015
    Site PC010 at height 1.5 meters above ground
  • PC013015
    Site PC013 at height 1.5 meters above ground
  • PC014015
    Site PC014 at height 1.5 meters above ground
  • PC015015
    Site PC015 at height 1.5 meters above ground
  • PC016015
    Site PC016 at height 1.5 meters above ground
AIRTEMP_INST - numeric(8,3) (ratio)

ID: MS04506.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=-19.5840 (exclusive=false), max=43.9660 (exclusive=false)

AIRTEMP_INST_FLAG - char(2) (nominal)

ID: MS04506.AIRTEMP_INST_FLAG

Instantaneous air temperature flag

Type system: Microsoft SQL Server 2019

Code definitions (44)
  • J
    data value jump
  • S
    temperature spike
  • B
    radiation bias
  • H
    high intensity
  • I
    extreme temperature or intensity
  • Q
    high temperature warning
  • C
    sensor covered (snow)
  • D
    low daylight intensity
  • N
    high nightime intensity
  • IJS
    major step violation outside of valid temperature range
  • QJ
    questionable range due to minor step violation
  • QJS
    questionable range due to major step violation
  • IJ
    implausible range due to minor step violation
  • IJS
    implausible range due to major step violation
  • EJ
    estimated value violates minor step
  • EJS
    estimated value violates major step
  • BJ
    bias and temperature jump within valid temperature range
  • BJS
    bias and temperature spike within valid temperature range
  • QBJ
    high temperature warning due to bias and temperature jump outside valid range
  • QBJS
    high temperature warning due to bias and temperature spike outside valid range
  • IBJ
    bias and jump outside implausible range
  • IBJS
    bias and spike outside implausible range
  • HJ
    High intensity jump inside valid temperature range
  • HJS
    high intensity spike inside implausible range
  • QHJ
    high temperature warning due to high intensity jump outside valid range
  • QHJS
    high temperature warning due to high intensity spike outside valid range
  • IHJ
    high intensity jump outside implausible range
  • IHJS
    high intensity spike outside implausible range
  • A
    Accepted value has passed all QC tests applied as represented by the quality level
  • M
    missing value
  • OB
    value is over the Long-term Mean Reference with radiation bias
  • OH
    value is over the Long-term Mean Reference with high intensity
  • OS
    Value is over the Long-term Mean Reference with a temperature spike
  • QB
    high temperature warning due to radiation bias
  • QH
    high temperature warning due to high intensity
  • QO
    high temperature warning due to value over the Long-term Mean Reference
  • SB
    temperature spike with radiation bias
  • SH
    temperature spike with high intensity
  • U
    value is under the Long-term Mean Reference
  • US
    value is under the Long-term Mean Reference with a temperature spike
  • O
    value is over the Long-term Mean Reference
  • CH
    sensor covered (snow) with high intensity
  • QS
    high temperature warning due to temperature spike
  • CD
    sensor covered (snow) with low daylight intensity'
INTENSITY - numeric(7,0) (ratio)

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

INTENSITY_FLAG - char(2) (nominal)

ID: MS04506.INTENSITY_FLAG

Light intensity flag

Type system: Microsoft SQL Server 2019

Code definitions (30)
  • J
    data value jump
  • S
    temperature spike
  • B
    radiation bias
  • H
    high intensity
  • I
    extreme temperature or intensity
  • Q
    high temperature warning
  • C
    sensor covered (snow)
  • D
    low daylight intensity
  • N
    high nightime intensity
  • IJS
    major step violation outside of valid temperature range
  • QJ
    questionable range due to minor step violation
  • QJS
    questionable range due to major step violation
  • IJ
    implausible range due to minor step violation
  • IJS
    implausible range due to major step violation
  • EJ
    estimated value violates minor step
  • EJS
    estimated value violates major step
  • BJ
    bias and temperature jump within valid temperature range
  • BJS
    bias and temperature spike within valid temperature range
  • QBJ
    high temperature warning due to bias and temperature jump outside valid range
  • QBJS
    high temperature warning due to bias and temperature spike outside valid range
  • IBJ
    bias and jump outside implausible range
  • IBJS
    bias and spike outside implausible range
  • HJ
    High intensity jump inside valid temperature range
  • HJS
    high intensity spike inside implausible range
  • QHJ
    high temperature warning due to high intensity jump outside valid range
  • QHJS
    high temperature warning due to high intensity spike outside valid range
  • IHJ
    high intensity jump outside implausible range
  • IHJS
    high intensity spike outside implausible range
  • A
    Accepted value has passed all QC tests applied as represented by the quality level
  • M
    missing value
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
Related Datasets
Related Publications
  • Frey, Sarah J. K.; Hadley, Adam S.; Johnson, Sherri L.; Schulze, Mark; Jones, Julia A.; Betts, Matthew G. 2016. Spatial models reveal the microclimatic buffering capacity of old-growth forests. Science Advances. 2(4): 9p. doi: 10.1126/sciadv.1501392
  • Ward, Sarah E. 2018. Microclimate and Phenology at the H.J. Andrews Experimental Forest. Eugene: University of Oregon. 73 p. M.S. thesis.
  • Ward, Sarah E.; Schulze, Mark; Roy, Bitty. 2018. A long-term perspective on microclimate and spring plant phenology in the Western Cascades. Ecosphere. 9(10): e02451. doi: 10.1002/ecs2.2451
  • Wolf, Christopher; Bell, David M.; Kim, Hankyu; Nelson, Michael Paul; Schulze, Mark; Betts, Matthew G. 2021. Temporal consistency of undercanopy thermal refugia in old-growth forest. Agricultural and Forest Meteorology. 307: 108520. doi: 10.1016/j.agrformet.2021.108520
  • Kim, Hankyu; McComb, Brenda C.; Frey, Sarah J. K.; Bell, David M.; Betts, Matthew G. 2022. Forest microclimate and composition mediate long-term trends of breeding bird populations. Global Change Biology. 28(21): 6180-6193. doi: 10.1111/gcb.16353
Related Files
Intellectual Rights

Data Use Agreement:

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

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

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

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

Licensed

License: 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 (2015-06-15)
    Study code and preliminary metadata established
  • Version2 (2016-06-02)
    MS045 data are prepared and established online 2009-2015 for core phenology sites and through 2014 for core bird and auxiliary phenology sites. High level metadata is not prepared but will be available June 2016.
  • Version3 (2017-07-14)
    Metadata for abstract, purpose, experimental design and methods including program algorithms are added. EML is updated to include check sums and corrected intellectual rights.
  • Version4 (2019-04-30)
    MS045 entity 5 is prepared and established online. Entity 5 includes high resolution (15 or 20 minute) data for 18 core phenology sites (starts 2009), 40 core bird sites (starts 2009) and 128 auxiliary (starts 2011) phenology sites through July 2018. These data have gone through a different Python processing program than data in entities 1-4. These are raw data that has been flagged with the hja_hobo_clean Python program. Hourly and daily data could be prepared from this entity to add to entities 1-4. But PC data in entity 2 has had a much more rigorous QC process to identify issues.
  • Version5 (2023-04-24)
    MS045 entity 6 is established online. Entity 6 includes high resolution (15 or 20 minute) data for 18 core phenology sites, 40 core bird sites and 128 auxiliary phenology sites from July 2018 through October 2022. These are raw data that has been flagged using a QA/QC processing algorithm using GCE Toolbox.