HT004: Stream and air temperature data from stream gages and stream confluences in the Andrews Experimental Forest, 1950 to present
Notice
"As Is" Basis: All content, including maps and forecasts, is provided without warranties. Users are advised to independently verify critical information.
Citation
Gregory, S.; Johnson, S. 1000. Stream and air temperature data from stream gages and stream confluences in the Andrews Experimental Forest, 1950 to present Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/HT004 Accessed 2026-05-10.
Abstract
Stream and air temperature are measured in tandem at stream gauging stations and other selected locations and stream confluences within the Andrews Forest. Air temperature is generally measured over the stream or alongside. Currently, mean, max and min water and air temperature data are collected every 5 minutes at the gauging stations and instantaneous temperatures every 15 minutes at all other sites. Most measurements were collected hourly commencing in the later 1990s, but a few sites have daily data beginning in the late 1970s. Historic data collected 1949 to 1981 at Lookout Creek stream gauge are included with the daily summary data. Other Andrews Forest related databases: Long term air temperature data from the reference and benchmark climate stations are also available in MS001. Previous high resolution stream temperature data at some of the small watershed stream gages are available in HT001 and stream temperature data throughout the Andrews Forest stream networks during several years are available in HT002.
Coverage
Temporal coverage: 1000-01-01 to 1000-01-01
Geographic coverage: Oregon: western Cascades - HJ Andrews Experimental Forest Gauging Stations at WS1, 2, 3, 6, 7, 8, 10, Mack Creek, and Lookout Creek. Stream thermograph sites on upper Lookout, upper McRae, Mack/Lookout confluence, and legacy sites Mack old-growth, McRae/Lookout confluence, Quartz Creek (Blue River tributary), and Grasshopper Creek (S. Fork McKenzie).
Spatial coverage:
Bounds: W -122.30199700, E -122.12162890, N 44.26629426, S 44.19831900
Purpose
- Stream temperature is a critical parameter in stream ecosystems and controls rates of multiple processes, such as metabolism, growth, decomposition, and solubility of gases, as well as biotic interactions. Measuring stream temperature at stream gages allows examination of long term responses to forest dynamics and forest harvest. These stream and air temperature data also are relevant to research on nutrient dynamics, stream flow, invertebrate and vertebrate responses to microclimate conditions.
Project
Title: Long-Term Ecological Research
Personnel
-
Posy Elizabeth Busby - Principal Investigator Assistant Professor OSU Botany & Plant PathologyEmail: busbyp@science.oregonstate.edu, posybusby@gmail.comORCID: 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, 97331Phone: (541) 737-3841Email: matt.betts@oregonstate.eduORCID: 0000-0002-7100-2551
-
Brooke E. Penaluna - Principal Investigator Email: brooke.penaluna@usda.gov, Brooke.Penaluna@oregonstate.eduORCID: 0000-0001-7215-770X
-
Catalina Segura - Principal Investigator Assistant Professor; Department of Forest Engineering, Resources, and Management; Oregon State University, Corvallis, OR, 97331Phone: 541-737-6568Email: catalina.segura@oregonstate.eduORCID: 0000-0002-0924-1172
-
David M. Bell - Principal Investigator Email: david.bell@usda.gov, david.bell@oregonstate.eduORCID: 0000-0002-2673-5836
Abstract
- The H.J. Andrews Experimental Forest is a living laboratory that provides unparalleled opportunities for the study of forest and stream ecosystems in the central Cascade Range of Oregon. Since 1980, as a part of the National Science Foundation Long Term Ecological Research (NSF-LTER) program, the Andrews Experimental Forest has become a leader in the analysis of forest and stream ecosystem dynamics.
- Long-term field experiments and measurement programs have focused on climate dynamics, streamflow, water quality, and vegetation succession. Currently researchers are working to develop concepts and tools needed to predict effects of natural disturbance, land use, and climate change on ecosystem structure, function, and species composition.
- The Andrews Experimental Forest is administered cooperatively by the USDA Forest Service Pacific Northwest Research Station, Oregon State University and the Willamette National Forest. Funding for the research program comes from the National Science Foundation (NSF), US Forest Service Pacific Northwest Research Station, Oregon State University, and other sources.
Funding
Data were provided by the HJ Andrews Experimental Forest research program, funded by the National Science Foundation's Long-Term Ecological Research Program (DEB 2025755), US Forest Service Pacific Northwest Research Station, and Oregon State University. National Science Foundation: DEB2025755
Awards
-
LTER: Long-Term Ecological Research at the H.J. Andrews Experimental Forest (LTER8) Award Number: DEB2025755Funder: National Science FoundationFunder Identifier: https://ror.org/021nxhr62
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
-
Craig Creel
Role: Former InvestigatorUSDA Forest Service;Pacific NW Research Station;3200 SW Jefferson Way, Corvallis, OR, 97331, USAPhone: (541) 750-7326, (541) 822-6301Email: cdcreel@comcast.net
-
Christopher Daly
Role: Other ResearcherPRISM Group;Northwest Alliance for Computational Science and Engineering, 2000 Kelley Engineering Center;Oregon State University, Corvallis, OR, 97331, USAPhone: (541) 737-2531Email: daly@nacse.org
-
Greg Downing
Role: Method ContactForestry Sciences Lab;3200 SW Jefferson Way, Corvallis, OR, 97333, USAPhone: (541) 750-7283, (541) 822-6301Email: gregdowning242@gmail.com, greg.downing@oregonstate.edu
-
Stanley V. Gregory
Role: Former InvestigatorOregon State University;Dept. of Fisheries and Wildlife;Nash Hall 104, Corvallis, OR, 97331, USAPhone: (541) 737-1951Email: stanley.gregory@oregonstate.edu
-
Stanley V. Gregory
Role: CreatorOregon State University;Dept. of Fisheries and Wildlife;Nash Hall 104, Corvallis, OR, 97331, USAPhone: (541) 737-1951Email: stanley.gregory@oregonstate.edu
-
Donald L. Henshaw
Role: AbstractorPacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, Oregon, 97331Email: hja_admin@lists.oregonstate.edu
-
Sherri L. Johnson
Role: Principal InvestigatorUS Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USAPhone: 541-758-7771Email: sherri.johnson@oregonstate.edu
-
Sherri L. Johnson
Role: AbstractorUS Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USAPhone: 541-758-7771Email: sherri.johnson@oregonstate.edu
-
Sherri L. Johnson
Role: CreatorUS Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USAPhone: 541-758-7771Email: sherri.johnson@oregonstate.edu
-
John Moreau
Role: Former InvestigatorBlue River, OR, 97413, USAEmail: john.b.moreau@icloud.com
-
Randall C. Wildman
Role: Former InvestigatorOregon State University;Dept. of Fish and Wildlife, Corvallis, OR, 97331, USAEmail: randallcwildman@gmail.com, wildmanr@retiree.oregonstate.edu
-
Adam M Kennedy
Role: Other ResearcherOR, USPhone: 541-822-6302Email: adam.kennedy@oregonstate.edu
-
Greg M Cohn
Role: Other ResearcherUSFS Rd 15-130-132, Blue River, OR, 97413Phone: 541-822-6305Email: cohng@oregonstate.edu
-
Greg M Cohn
Role: Method ContactUSFS Rd 15-130-132, Blue River, OR, 97413Phone: 541-822-6305Email: cohng@oregonstate.edu
-
Stephanie A Schmidt
Role: Other ResearcherUSDA Forest Service; 3200 SW Jefferson Way, Corvallis, Oregon, 97331Email: stephanie.schmidt@oregonstate.edu, stephanie.schmidt2@usda.gov
Contact
-
Information Manager
Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331Email: hjaweb@lists.oregonstate.edu
-
Stephanie A Schmidt
USDA Forest Service; 3200 SW Jefferson Way, Corvallis, Oregon, 97331Email: stephanie.schmidt@oregonstate.edu, stephanie.schmidt2@usda.gov
Publisher
-
Andrews Forest LTER Site
Role: PublisherForest Ecosystems and Society Department in Forestry, Oregon State University, 201K Richardson Hall, Corvallis, OR, 97331-5752Phone: (541) 737-8480Email: lterweb@lists.oregonstate.edu
Study Description
Stream and air temperature are measured in tandem at stream gauging stations and other selected locations and stream confluences within the Andrews Forest. Air temperature is generally measured over the stream or alongside. Currently, mean, max and min water and air temperature data are collected every 5 minutes at the gauging stations and instantaneous temperatures every 15 minutes at all other sites. Most measurements were collected hourly commencing in the later 1990s, but a few sites have daily data beginning in the late 1970s. Historic data collected 1949 to 1981 at Lookout Creek stream gauge are included with the daily summary data. Other Andrews Forest related databases: Long term air temperature data from the reference and benchmark climate stations are also available in MS001. Previous high resolution stream temperature data at some of the small watershed stream gages are available in HT001 and stream temperature data throughout the Andrews Forest stream networks during several years are available in HT002. Stream temperature is a critical parameter in stream ecosystems and controls rates of multiple processes, such as metabolism, growth, decomposition, and solubility of gases, as well as biotic interactions. Measuring stream temperature at stream gages allows examination of long term responses to forest dynamics and forest harvest. These stream and air temperature data also are relevant to research on nutrient dynamics, stream flow, invertebrate and vertebrate responses to microclimate conditions. Field Methods - HT004: General
Purpose: Stream temperature is a critical parameter in stream ecosystems and controls rates of multiple processes, such as metabolism, growth, decomposition, and solubility of gases, as well as biotic interactions. Measuring stream temperature at stream gages allows examination of long term responses to forest dynamics and forest harvest. These stream and air temperature data also are relevant to research on nutrient dynamics, stream flow, invertebrate and vertebrate responses to microclimate conditions.
Methods
Method Steps
Field Methods - HT004: General
- Originally, thermographs (later replaced with data loggers and thermistors) were installed at each stream site to continuously monitor stream temperature with an adjacent air temperature site near the stream. Stream temperature probes are generally anchored near the stream bottom. Air temperature was generally measured at 1 meter above the forest floor and insulated originally with an A-frame shield (later replaced with pvc-constructed shields). Many of the probes were repositioned in the early 1990's at 1 meter above average winter snow level. Generally, sites are visited and charts / CR10 records collected on a monthly basis. In 1987, Campbell Scientific CR-10 data loggers replaced 8 circular chart installations at the original sites. Early Lookout Creek stream temperature data 1950-1981 was collected by the USGS.
- The original thermograph instrument was the Dual Recording Thermometer Model RFHTT. This instrument records temperatures from two separate locations (air and soil) simultaneously on a single chart. Each of the two thermometer mechanisms operate with a mercury-filled sensing bulb which expands or contracts in response to temperature changes and in turn moves the recording pen along the calibrated chart. To prevent interference between the two pens, the right-hand pen records 1/12 revolution behind the left-hand pen. The recorder uses 10 inch 30- and 31-day Partlow circular charts that have ranges from -30°F - 170°F or 20°F - 120°F.
- These original thermograph charts were replaced with Campbell Scientific data loggers ( typically CR10, CR21X, CR500, or CR23X) beginning in 1987. The temperature probes used with the data loggers were type T thermocouple soldered from thermocouple wire. These thermocouple wires have gradually been replaced through the late 1990-s with Campbell Scientific model 107 temperature probes (CS107B or CS107B-L) which include the Fenwal Electronics UUT51J1 thermistor.
Instrumentation:
- The original thermograph instrument was the Dual Recording Thermometer Model RFHTT, which recorded on Partlow circular charts. Campbell Scientific data loggers with type T thermocouple soldered from thermocouple wire to measure temperature were used beginning 1987. Beginning in the late 990s Campbell Scientific model 107 temperature probes (CS107B or CS107B-L) which include the Fenwal Electronics UUT51J1 thermistor were gradually installed.
Field Methods - HT004: Stream and air temperature
- A description of sites and measurement history is here:
- http://andrewsforest.oregonstate.edu/data/studies/ht04/datalist.htm
Laboratory Methods - HT004
- Digitizing chart records was the primary method of capturing data until 1987 when data loggers begin to be installed. Digitizing continued for some sites until 1995. Charts were digitized and the record summarized by daytime, nighttime, and 24-hr period. The 24-hr mean values before 1987 are sunrise to sunrise; after January 1987 the 24-hr values are midnight to midnight. All daytime/nighttime calculation ended in 1998, and this data is only available by request.
Instrumentation:
- Digitizer is the Summagraphics/Houston Instruments model MM 1812. (Comparable product is now http://www.calcomp.com/productsummagrid6.htm)
Quality Assurance - HT004
- Quality assurance procedures included 1) missing flag check to ensure that all missing data really has the appropriate flag; 2) date/time check to verify that a record exists for each date (and hour if applicable) and that records fall in the correct order; 3) relative mean/max/min check for each record to make sure that min less than or equal to mean and mean less than or equal to max; 4) similar sites were paired and the values compared to catch any gross outliers.
Sampling
Study Extent
- Air and water temperatures are measured at gauged watersheds within the Andrews Forest and at other stream sites including Mack and McRae Creek confluences with Lookout Creek. Stream sites nearby the Andrews were collected briefly but were discontinued. Data collection began in 1976 but several sites were discontinued by the mid-1990s. Most of the gauged watershed collections were started between 1995 and 1998.
- Sampling frequency: Continually
Sampling Description
- Stream and air temperature sites were originally selected in the upper elevations of the three major stream segments, upper Lookout, upper Mack and upper McRae Creek, that combine to form Lookout Creek, as well as off-Andrews sites in Grasshopper and Quartz Creeks. These stream temperature sites were initiated in the late 1970's as an extension to the air and soil temperature network. The upper Mack Creek, Quartz and Grasshopper Creek sites have been discontinued. Additional sites were added in 1995 to the confluences of Lookout-Mack and Lookout-McRae Creeks to examine mixing of water temperature compared to relative flows. However, due to problems with maintaining sensors during winter and flood flows, the Lookout-McRae site was discontinued. In 1997, stream and air temperature sensors were placed at all Andrews gaging stations (WS#9 was not instrumented due to threat of potential vandalism). A legacy stream temperature data set, maintained by USGS, exists from 1950 to 1981 (missing 1955-1963) at Lookout Creek gaging station.
Spatial Sampling Units
-
Andrews Watershed 1 Gaging Station
W -122.25802700, E -122.25802700, N 44.20733900, S 44.20733900Altitude: 439 to 439 meter
-
Andrews Watershed 2 Gaging Station
W -122.24487600, E -122.24487600, N 44.21201500, S 44.21201500Altitude: 545 to 545 meter
-
Andrews Watershed 3 Gaging Station
W -122.24300000, E -122.24300000, N 44.21944000, S 44.21944000Altitude: 471 to 471 meter
-
Andrews Watershed 6 Gaging Station
W -122.18070700, E -122.18070700, N 44.26150800, S 44.26150800Altitude: 878 to 878 meter
-
Andrews Watershed 7 Gaging Station
W -122.17526500, E -122.17526500, N 44.26463700, S 44.26463700Altitude: 918 to 918 meter
-
Andrews Watershed 8 Gaging Station
W -122.17079300, E -122.17079300, N 44.26629426, S 44.26629426Altitude: 962 to 962 meter
-
Andrews Watershed 10 Gaging Station
W -122.26105600, E -122.26105600, N 44.21705700, S 44.21705700Altitude: 461 to 461 meter
-
Andrews Mack Creek Gaging Station
W -122.16744700, E -122.16744700, N 44.21943621, S 44.21943621Altitude: 755 to 755 meter
-
Andrews Lookout Creek Gaging Station
W -122.25714600, E -122.25714600, N 44.21012600, S 44.21012600Altitude: 422 to 422 meter
-
Lookout Creek upper thermograph site
W -122.12162890, E -122.12162890, N 44.22478329, S 44.22478329Altitude: 998 to 998 meter
-
Mack Creek old-growth thermograph site
W -122.16547369, E -122.16547369, N 44.21664907, S 44.21664907Altitude: 792 to 792 meter
-
McRae Creek upper thermograph site
W -122.16757303, E -122.16757303, N 44.25638612, S 44.25638612Altitude: 840 to 840 meter
-
Quartz Creek (Blue River tributary) thermograph site
W -122.30199700, E -122.30199700, N 44.19831900, S 44.19831900Altitude: 520 to 520 meter
-
Lookout and Mack Creek confluence thermograph site
W -122.16802024, E -122.16802024, N 44.22756413, S 44.22756413Altitude: 674 to 674 meter
-
Lookout and McRae Creek confluence thermograph site
W -122.20863436, E -122.20863436, N 44.23298992, S 44.23298992Altitude: 552 to 552 meter
-
Andrews Watershed 1
W -122.25683100, E -122.23581300, N 44.20851700, S 44.19901700Altitude: 1027 to 1027 meter
-
Andrews Watershed 10
W -122.25996600, E -122.25443900, N 44.22015200, S 44.21678600Altitude: 679 to 679 meter
-
Andrews Watershed 2
W -122.24397600, E -122.22974100, N 44.21338500, S 44.20617800Altitude: 1079 to 1079 meter
-
Andrews Watershed 3
W -122.24194900, E -122.22402200, N 44.21994300, S 44.20803100Altitude: 1080 to 1080 meter
-
Andrews Watershed 6
W -122.18351000, E -122.17755000, N 44.26680800, S 44.26154400Altitude: 1029 to 1029 meter
-
Andrews Watershed 7
W -122.17920900, E -122.17387500, N 44.26974800, S 44.26457900Altitude: 1102 to 1102 meter
-
Andrews Watershed 8
W -122.17079300, E -122.17079300, N 44.26629400, S 44.26588100Altitude: 1182 to 1182 meter
-
Andrews Mack Creek Watershed
W -122.17282200, E -122.12699600, N 44.22054300, S 44.20148000Altitude: 1626 to 1626 meter
-
Andrews Lookout Creek Watershed
W -122.25879300, E -122.09952700, N 44.28226000, S 44.20127400Altitude: 1627 to 1627 meter
-
McRae Creek
W -122.20859020, E -122.13943300, N 44.27311600, S 44.23328700
-
Andrews Experimental Forest (HJA)
W -122.26172200, E -122.10084700, N 44.28196400, S 44.19770400Altitude: 1631 to 1631 meter
Software
No software entries listed in this EML file.
Keywords
- LTER controlled vocabulary: climatology (theme), microclimate (theme), stream order (theme), air temperature (theme), water temperature (theme), disturbance (theme), monitoring (theme), ecosystems (theme)
- LTER core research areas: disturbance (theme)
Taxonomic Hierarchy
No taxonomic hierarchy listed in this EML file.
Data Entities
| # | Entity | Metadata | Data |
|---|---|---|---|
| 1 |
HT00401
Air temperature (daily) |
METADATA | DATA |
| 2 |
HT00411
Air temperature (fine temporal resolution) |
METADATA | DATA |
| 3 |
HT00441
Stream temperature (daily) Includes legacy Lookout Creek USGS data 1950-1981 (1955-1963 missing) |
METADATA | DATA |
| 4 |
HT00451
Stream temperature (fine temporal resolution) |
METADATA | DATA |
Metadata
HT00401 - Air temperature (daily)
Object name: HT00401_v8.csv
Records: 126083
Attributes: 17
Temporal coverage: 1000-01-01 to 1000-01-01
File size: 11216678 byte
Checksum (MD5): bfc7dc832903d9574b4afabca800abdf
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY HT00401.DATE, HT00401.PROBE_CODE
-
notNullConstraint: NOTNULL HT00401.DATE, HT00401.AIRTEMP_MEAN_FLAG, HT00401.AIRTEMP_MAX_FLAG, HT00401.AIRTEMP_MIN_FLAG, HT00401.PROBE_CODE, HT00401.DBCODE, HT00401.SITECODE, HT00401.ENTITY, HT00401.HEIGHT, HT00401.AIRTEMP_METHOD, HT00401.QC_LEVEL, HT00401.EVENT_CODE
Attributes (17)
DBCODE - char(5) (nominal)
ID: HT00401.DBCODE
FSDB database code
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
HT004
Study code HT004
ENTITY - numeric(2,0) (interval)
ID: HT00401.ENTITY
Entity number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=1.0000 (exclusive=false)
SITECODE - char(6) (nominal)
ID: HT00401.SITECODE
Site code for the meteorological measurement station
Type system: Microsoft SQL Server 2019
Code definitions (18)
-
GSWS01
Andrews Watershed 1 Gaging Station
-
GSWS02
Andrews Watershed 2 Gaging Station
-
GSWS03
Andrews Watershed 3 Gaging Station
-
GSWS06
Andrews Watershed 6 Gaging Station
-
GSWS07
Andrews Watershed 7 Gaging Station
-
GSWS08
Andrews Watershed 8 Gaging Station
-
GSWS10
Andrews Watershed 10 Gaging Station
-
GSMACK
Andrews Mack Creek Gaging Station
-
GSLOOK
Andrews Lookout Creek Gaging Station
-
TSGRAS
Grasshopper Creek (S. Fork McKenzie) thermograph site
-
TSLOOK
Lookout Creek upper thermograph site
-
TSMACK
Mack Creek old-growth thermograph site
-
TSMCRA
McRae Creek upper thermograph site
-
TSQRTZ
Quartz Creek (Blue River tributary) thermograph site
-
TSLOMA
Lookout and Mack Creek confluence thermograph site
-
TSLOMC
Lookout and McRae Creek confluence thermograph site
-
TSCOLD
Cold Creek thermograph site
-
TSMCBR
McRae Bridge thermograph site
AIRTEMP_METHOD - char(6) (nominal)
ID: HT00401.AIRTEMP_METHOD
An indication of the the general methodology and instrumentation used to collect this air temperature data
Type system: Microsoft SQL Server 2019
Code definitions (79)
-
AIR818
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 395 cm height (See method AIR718)
-
AIR807
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 395 cm height (Daily output only)
-
AIR814
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 305 cm height (See method AIR714)
-
AIR815
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 350 cm height (See method AIR715)
-
AIR838
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; PVC radiation shield; 450 cm height (See method AIR738)
-
AIR813
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 295 cm height (See method AIR713)
-
AIR810
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 240 cm height (See method AIR710)
-
AIR812
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 255 cm height (See method AIR712)
-
AIR817
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 370 cm height (See method AIR717)
-
AIR811
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 250 cm height (See method AIR711)
-
AIR801
Mean, max and min daily (sunrise to sunrise) air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 100 cm height in small shelter and corrected.
-
AIR816
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 365 cm height (See method AIR716)
-
AIR806
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 300 cm height in small shelter on tree and corrected to standard rdg.
-
AIR826
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 395 cm height (See method AIR726)
-
AIR824
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 305 cm height (See method AIR724)
-
AIR834
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; PVC radiation shield; 305 cm height (See method AIR734)
-
AIR820
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 450 cm height (See method AIR720)
-
AIR823
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 295 cm height (See method AIR723)
-
AIR821
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 240 cm height (See method AIR721)
-
AIR822
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 255 cm height (See method AIR722)
-
AIR825
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 370 cm height (See method AIR725)
-
AIR819
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 400 cm height (See method AIR719)
-
AIR827
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 400 cm height (See method AIR727)
-
AIR802
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 100 cm height in small shelter on tree and corrected to standard rdg.
-
AIR809
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 200 cm height (See method AIR709)
-
AIR808
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings.Thermocouple wire; PVC radiation shield; 395 cm height (See method AIR708)
-
AIR836
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; PVC radiation shield; 395 cm height (See method AIR736)
-
AIR828
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 450 cm height (See method AIR728)
-
AIR833
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; PVC radiation shield; 295 cm height (See method AIR733)
-
AIR831
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; PVC radiation shield; 240 cm height (See method AIR731)
-
AIR832
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; PVC radiation shield; 255 cm height (See method AIR732)
-
AIR835
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; PVC radiation shield; 370 cm height (See method AIR735)
-
AIR837
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; PVC radiation shield; 400 cm height (See method AIR737)
-
AIR805
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 240 cm height in small shelter on tree and corrected to standard rdg.
-
AIR804
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 200 cm height in small shelter on tree and corrected to standard rdg.
-
AIR803
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 160 cm height in small shelter on tree and corrected to standard rdg.
-
AIR708
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a locally designed PVC radiation shield at 395 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
-
AIR709
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 200 cm height; mean temperature is output every 60 minutes
-
AIR710
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 240 cm height; mean temperature is output every 60 minutes
-
AIR711
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 250 cm height; mean temperature is output every 60 minutes
-
AIR712
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 255 cm height; mean temperature is output every 60 minutes
-
AIR713
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 295 cm height; mean temperature is output every 60 minutes
-
AIR714
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 305 cm height; mean temperature is output every 60 minutes
-
AIR715
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 350 cm height; mean temperature is output every 60 minutes
-
AIR716
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 365 cm height; mean temperature is output every 60 minutes
-
AIR717
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 370 cm height; mean temperature is output every 60 minutes
-
AIR718
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 395 cm height; mean temperature is output every 60 minutes
-
AIR719
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 400 cm height; mean temperature is output every 60 minutes
-
AIR720
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 450 cm height; mean temperature is output every 60 minutes
-
AIR721
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 240 cm height; mean temperature is output every 15 minutes
-
AIR722
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 255 cm height; mean temperature is output every 15 minutes
-
AIR723
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 295 cm height; mean temperature is output every 15 minutes
-
AIR724
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 305 cm height; mean temperature is output every 15 minutes
-
AIR725
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 370 cm height; mean temperature is output every 15 minutes
-
AIR726
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 395 cm height; mean temperature is output every 15 minutes
-
AIR727
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 400 cm height; mean temperature is output every 15 minutes
-
AIR728
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 450 cm height; mean temperature is output every 15 minutes
-
AIR731
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 240 cm height; mean, min, max temperature is output every 5 minutes
-
AIR732
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 255 cm height; mean, min, max temperature is output every 5 minutes
-
AIR733
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 295 cm height; mean, min, max temperature is output every 5 minutes
-
AIR734
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 305 cm height; mean, min, max temperature is output every 5 minutes
-
AIR735
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 370 cm height; mean, min, max temperature is output every 5 minutes
-
AIR736
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 395 cm height; mean, min, max temperature is output every 5 minutes
-
AIR737
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 400 cm height; mean, min, max temperature is output every 5 minutes
-
AIR738
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 450 cm height; mean, min, max temperature is output every 5 minutes
-
AIR839
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; Gill radiation shield; 200 cm height (See method AIR739)
-
AIR840
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; Gill radiation shield; 240 cm height (See method AIR740)
-
AIR841
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; Gill radiation shield; 350 cm height (See method AIR741)
-
AIR842
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; Gill radiation shield; 395 cm height (See method AIR742)
-
AIR843
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 395 cm height (See method AIR743)
-
AIR844
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 350 cm height (See method AIR744)
-
AIR845
Mean daily air temperature is post-calculated from all instantaneous 15 minute values, and max-min values are determined based on all instantaneous 15 minute readings. Onset HOBO V2; RS1 7-Gill radiation shield; 200 cm height (See method AIR745)
-
AIR739
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 200 cm height; mean temperature is output every 60 minutes
-
AIR740
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 240 cm height; mean temperature is output every 60 minutes
-
AIR741
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 350 cm height; mean temperature is output every 60 minutes
-
AIR742
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 395 cm height; mean temperature is output every 60 minutes
-
AIR743
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 395 cm height; mean, min, max temperature is output every 5 minutes
-
AIR744
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 350 cm height; mean, min, max temperature is output every 5 minutes
-
AIR745
Air temperature is sampled by an Onset HOBO Water Temp V2 housed in an RS1 7-gill radiation shield at 200 cm height attached to a boom extending out from a tree directly over the stream sensor; instantaneous temperature is output every 15 minutes
HEIGHT - numeric(4,0) (ratio)
ID: HT00401.HEIGHT
Height of sensor from ground surface
Type system: Microsoft SQL Server 2019
Unit: centimeters
Precision: 1.000000
Numeric domain: type=natural, min=100.0000 (exclusive=false), max=450.0000 (exclusive=false)
QC_LEVEL - char(2) (nominal)
ID: HT00401.QC_LEVEL
Quality control flag indicates level of quality checking performed including an indication of "provisional" data.
Type system: Microsoft SQL Server 2019
Code definitions (5)
-
1A
Data is published and unlikely to change - automated range checking and manual review has been conducted. Quality is indicated in data value qualifier flags.
-
1D
Data is published and unlikely to change - data is derived or aggregated from published data of level 1A
-
1P
Data is provisional and subject to revision - preliminary quality checks have been performed
-
2A
Data is published and unlikely to change - Level 1A data has been modified such that data gaps may be filled or problem data may be removed
-
2D
Data is published and unlikely to change - data is derived or aggregated from published data of level 2A
PROBE_CODE - char(8) (nominal)
ID: HT00401.PROBE_CODE
Probe number code indicates the measurement type, site, and sensor number (e.g., AIRGS101)
Type system: Microsoft SQL Server 2019
Code definitions (43)
-
WATGSL01
Stream temperature at GSLOOK, probe no. 01
-
WATGSL02
Stream temperature at GSLOOK, probe no. 02, maintained by USGS, legacy data 1950-1981 (missing 1955-1963)
-
WATGSM01
Stream temperature at GSMACK, probe no. 01, downstream of flume in sampling pool
-
WATGS001
Stream temperature at GSWS10, probe no. 01, upstream of flume
-
WATGS101
Stream temperature at GSWS01, probe no. 01, downstream of flume
-
WATGS201
Stream temperature at GSWS02, probe no. 01, downstream of flume in sampling pool
-
WATGS301
Stream temperature at GSWS03, probe no. 01, downstream of flume
-
WATGS601
Stream temperature at GSWS06, probe no. 01, upstream of flume
-
WATGS701
Stream temperature at GSWS07, probe no. 01, downstream of flume
-
WATGS801
Stream temperature at GSWS08, probe no. 01, open canopy, discontinued 2001
-
WATGS802
Stream temperature at GSWS08, probe no. 02, upstream of flume
-
WATLMA01
Stream temperature at TSLOMA, probe no. 01 located in Lookout Cr. above the confluence with Mack Cr.
-
WATLMA02
Stream temperature at TSLOMA, probe no. 02 located in Mack Cr. above the confluence with Lookout Cr.
-
WATLMC01
Stream temperature at TSLOMC, probe no. 01 located in Lookout Cr. above the confluence with McRae cr., discontinued 1996
-
WATLMC02
Stream temperature at TSLOMC, probe no. 02 located in McRae Cr. above the confluence with Lookout Cr., discontinued 1996
-
WATTGR01
Stream temperature at TSGRAS, probe no. 01, discontinued 1987
-
WATTLO01
Stream temperature at TSLOOK, probe no. 01
-
WATTMA01
Stream temperature at TSMACK, probe no. 01, discontinued 1994
-
WATTMC01
Stream temperature at TSMCRA, probe no. 01, discontinued 2015
-
WATTQZ01
Stream temperature at TSQRTZ, probe no. 01, discontinued 1994
-
AIRGS001
Air temperature at GSWS10, probe no. 01 at height 400 cm
-
AIRGS101
Air temperature at GSWS01, probe no. 01 at height 305 cm
-
AIRGS201
Air temperature at GSWS02, probe no. 01 at height 450 cm
-
AIRGS301
Air temperature at GSWS03, probe no. 01 at height 295 cm
-
AIRGS601
Air temperature at GSWS06, probe no. 01 at height 240 cm
-
AIRGS701
Air temperature at GSWS07, probe no. 01 at height 255 cm
-
AIRGS801
Air temperature at GSWS08, probe no. 01 at height 370 cm
-
AIRGSL01
Air temperature at GSLOOK, probe no. 01 at height 395 cm
-
AIRGSM01
Air temperature at GSMACK, probe no. 01 at height 350 cm
-
AIRLMA01
Air temperature at TSLOMA, probe no. 01 at height 350 cm, discontinued 2017
-
AIRLMC01
Air temperature at TSLOMC, probe no. 01 at height 365 cm, discontinued 1996
-
AIRTGR01
Air temperature at TSGRAS, probe no. 01 at height 100 cm, discontinued 1987
-
AIRTLO01
Air temperature at TSLOOK, probe no. 01 at height 240 cm, discontinued 2017
-
AIRTMA01
Air temperature at TSMACK, probe no. 01 at height 200 cm, discontinued 1995
-
AIRTMC01
Air temperature at TSMCRA, probe no. 01 at height 200 cm, discontinued 2015
-
AIRTQZ01
Air temperature at TSQRTZ, probe no. 01 at height 100 cm, discontinued 1994
-
WATGSL03
Stream temperature at GSLOOK, probe no. 03, established 2016 at the Lookout Creek gauging station
-
WATTMA02
Stream temperature at TSMACK, probe no. 02, established 2016 upstream of the gauging station
-
WATMCB01
Stream temperature at TSMCBR, probe no. 01, established 2017 near McRae Bridge
-
WATCLD01
Stream temperature at TSCOLD, probe no. 01, established 2016 on Cold Creek
-
WATLMC03
Stream temperature at TSLOMC, probe no. 03, established 2017 on Lookout Creek above the Lookout-McRae confluence
-
AIRTLO02
Air temperature at TSLOOK, probe no. 02 at height 200 cm, established 2017 at upper Lookout site
-
AIRLMA02
Air temperature at TSLOMA, probe no. 02 at height 200 cm, established 2017 over Mack Creek at the Lookout-Mack confluence site
DATE - datetime (dateTime)
ID: HT00401.DATE
Date
Type system: Microsoft SQL Server 2019
Date format: YYYY-MM-DD
AIRTEMP_MEAN_DAY - numeric(5,1) (interval)
ID: HT00401.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.8000 (exclusive=false), max=26.3000 (exclusive=false)
AIRTEMP_MEAN_FLAG - char(1) (nominal)
ID: HT00401.AIRTEMP_MEAN_FLAG
Mean air temperature flag
Type system: Microsoft SQL Server 2019
Code definitions (7)
-
A
Accepted value has passed all QC tests applied as represented by the quality level
-
B
Sensor buried in snow; value is the snow temperature
-
E
Estimated value
-
M
Missing value
-
Q
Questionable value
-
S
Daily value based on 24 hour period defined from sunrise to sunrise
-
P
Fire effects are visible in the data
AIRTEMP_MAX_DAY - numeric(5,1) (interval)
ID: HT00401.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.2000 (exclusive=false), max=41.2000 (exclusive=false)
AIRTEMP_MAX_FLAG - char(1) (nominal)
ID: HT00401.AIRTEMP_MAX_FLAG
Maximum air temperature flag
Type system: Microsoft SQL Server 2019
Code definitions (7)
-
A
Accepted value has passed all QC tests applied as represented by the quality level
-
B
Sensor buried in snow; value is the snow temperature
-
E
Estimated value
-
M
Missing value
-
Q
Questionable value
-
S
Daily value based on 24 hour period defined from sunrise to sunrise
-
P
Fire effects are visible in the data
AIRTEMP_MAXTIME - char(4) (ordinal)
ID: HT00401.AIRTEMP_MAXTIME
Time of day (HHMM) in Pacific Standard Time (PST) of maximum air temperature
Type system: Microsoft SQL Server 2019
AIRTEMP_MIN_DAY - numeric(5,1) (interval)
ID: HT00401.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=-20.2000 (exclusive=false), max=21.7000 (exclusive=false)
AIRTEMP_MIN_FLAG - char(1) (nominal)
ID: HT00401.AIRTEMP_MIN_FLAG
Minimum air temperature flag
Type system: Microsoft SQL Server 2019
Code definitions (7)
-
A
Accepted value has passed all QC tests applied as represented by the quality level
-
B
Sensor buried in snow; value is the snow temperature
-
E
Estimated value
-
M
Missing value
-
Q
Questionable value
-
S
Daily value based on 24 hour period defined from sunrise to sunrise
-
P
Fire effects are visible in the data
AIRTEMP_MINTIME - char(4) (ordinal)
ID: HT00401.AIRTEMP_MINTIME
Time of day (HHMM) in Pacific Standard Time (PST) of minimum air temperature
Type system: Microsoft SQL Server 2019
EVENT_CODE - char(6) (nominal)
ID: HT00401.EVENT_CODE
Type of comment that exists independently for any event, disruption in protocol, or unusual conditions that occur at the given date or time and may have an effect on the data values
Type system: Microsoft SQL Server 2019
Code definitions (9)
-
CALIBR
Associated with the inspection or replacement of sensors for calibration
-
INSREM
Sensor is installed or removed
-
LOGGER
Change in data logger, data logger program, or wiring
-
MAINTE
A maintenance event has occurred
-
METHOD
Change in data collection method
-
NA
No event is reported (not applicable)
-
QUALTY
Event may directly affect data quality
-
WEATHR
A weather event has occurred that may affect reading
-
BURNED
Burning, including cleared trees and brush or wildfire, around the meteorological station or within the watershed (code begins at event initiation)
HT00411 - Air temperature (fine temporal resolution)
Object name: HT00411_v10.txt
Records: 11564850
Attributes: 11
Temporal coverage: 1000-01-01 to 1000-01-01
File size: 895922134 byte
Checksum (MD5): d74344b936fba4dc77125a22bc68dff9
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY HT00411.DATE_TIME, HT00411.PROBE_CODE
-
notNullConstraint: NOTNULL HT00411.DATE_TIME, HT00411.AIRTEMP_MEAN_FLAG, HT00411.PROBE_CODE, HT00411.DBCODE, HT00411.SITECODE, HT00411.ENTITY, HT00411.HEIGHT, HT00411.AIRTEMP_METHOD, HT00411.QC_LEVEL, HT00411.EVENT_CODE
Attributes (11)
DBCODE - char(5) (nominal)
ID: HT00411.DBCODE
FSDB database code
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
HT004
Study code HT004
ENTITY - numeric(2,0) (interval)
ID: HT00411.ENTITY
Entity number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=11.0000 (exclusive=false), max=11.0000 (exclusive=false)
SITECODE - char(6) (nominal)
ID: HT00411.SITECODE
Site code for the meteorological measurement station
Type system: Microsoft SQL Server 2019
Code definitions (18)
-
GSWS01
Andrews Watershed 1 Gaging Station
-
GSWS02
Andrews Watershed 2 Gaging Station
-
GSWS03
Andrews Watershed 3 Gaging Station
-
GSWS06
Andrews Watershed 6 Gaging Station
-
GSWS07
Andrews Watershed 7 Gaging Station
-
GSWS08
Andrews Watershed 8 Gaging Station
-
GSWS10
Andrews Watershed 10 Gaging Station
-
GSMACK
Andrews Mack Creek Gaging Station
-
GSLOOK
Andrews Lookout Creek Gaging Station
-
TSGRAS
Grasshopper Creek (S. Fork McKenzie) thermograph site
-
TSLOOK
Lookout Creek upper thermograph site
-
TSMACK
Mack Creek old-growth thermograph site
-
TSMCRA
McRae Creek upper thermograph site
-
TSQRTZ
Quartz Creek (Blue River tributary) thermograph site
-
TSLOMA
Lookout and Mack Creek confluence thermograph site
-
TSLOMC
Lookout and McRae Creek confluence thermograph site
-
TSCOLD
Cold Creek thermograph site
-
TSMCBR
McRae Bridge thermograph site
AIRTEMP_METHOD - char(6) (nominal)
ID: HT00411.AIRTEMP_METHOD
An indication of the the general methodology and instrumentation used to collect this air temperature data
Type system: Microsoft SQL Server 2019
Code definitions (79)
-
AIR818
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 395 cm height (See method AIR718)
-
AIR807
Mean daily, max and min air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Instrument is type T thermocouple wire housed in a locally designed PVC radiation shield at 395 cm height (Daily output only)
-
AIR814
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 305 cm height (See method AIR714)
-
AIR815
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 350 cm height (See method AIR715)
-
AIR838
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; PVC radiation shield; 450 cm height (See method AIR738)
-
AIR813
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 295 cm height (See method AIR713)
-
AIR810
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 240 cm height (See method AIR710)
-
AIR812
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 255 cm height (See method AIR712)
-
AIR817
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 370 cm height (See method AIR717)
-
AIR811
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 250 cm height (See method AIR711)
-
AIR801
Mean, max and min daily (sunrise to sunrise) air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 100 cm height in small shelter and corrected.
-
AIR816
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 365 cm height (See method AIR716)
-
AIR806
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 300 cm height in small shelter on tree and corrected to standard rdg.
-
AIR826
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 395 cm height (See method AIR726)
-
AIR824
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 305 cm height (See method AIR724)
-
AIR834
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; PVC radiation shield; 305 cm height (See method AIR734)
-
AIR820
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 450 cm height (See method AIR720)
-
AIR823
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 295 cm height (See method AIR723)
-
AIR821
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 240 cm height (See method AIR721)
-
AIR822
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 255 cm height (See method AIR722)
-
AIR825
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 370 cm height (See method AIR725)
-
AIR819
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 400 cm height (See method AIR719)
-
AIR827
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 400 cm height (See method AIR727)
-
AIR802
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 100 cm height in small shelter on tree and corrected to standard rdg.
-
AIR809
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 200 cm height (See method AIR709)
-
AIR808
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings.Thermocouple wire; PVC radiation shield; 395 cm height (See method AIR708)
-
AIR836
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; PVC radiation shield; 395 cm height (See method AIR736)
-
AIR828
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; PVC radiation shield; 450 cm height (See method AIR728)
-
AIR833
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; PVC radiation shield; 295 cm height (See method AIR733)
-
AIR831
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; PVC radiation shield; 240 cm height (See method AIR731)
-
AIR832
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; PVC radiation shield; 255 cm height (See method AIR732)
-
AIR835
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; PVC radiation shield; 370 cm height (See method AIR735)
-
AIR837
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; PVC radiation shield; 400 cm height (See method AIR737)
-
AIR805
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 240 cm height in small shelter on tree and corrected to standard rdg.
-
AIR804
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 200 cm height in small shelter on tree and corrected to standard rdg.
-
AIR803
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb at 160 cm height in small shelter on tree and corrected to standard rdg.
-
AIR708
Air temperature is sampled by type T thermocouple soldered from thermocouple wire housed in a locally designed PVC radiation shield at 395 cm height with a Campbell Scientific data logger; mean temperature is output every 60 minutes
-
AIR709
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 200 cm height; mean temperature is output every 60 minutes
-
AIR710
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 240 cm height; mean temperature is output every 60 minutes
-
AIR711
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 250 cm height; mean temperature is output every 60 minutes
-
AIR712
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 255 cm height; mean temperature is output every 60 minutes
-
AIR713
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 295 cm height; mean temperature is output every 60 minutes
-
AIR714
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 305 cm height; mean temperature is output every 60 minutes
-
AIR715
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 350 cm height; mean temperature is output every 60 minutes
-
AIR716
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 365 cm height; mean temperature is output every 60 minutes
-
AIR717
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 370 cm height; mean temperature is output every 60 minutes
-
AIR718
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 395 cm height; mean temperature is output every 60 minutes
-
AIR719
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 400 cm height; mean temperature is output every 60 minutes
-
AIR720
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 450 cm height; mean temperature is output every 60 minutes
-
AIR721
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 240 cm height; mean temperature is output every 15 minutes
-
AIR722
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 255 cm height; mean temperature is output every 15 minutes
-
AIR723
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 295 cm height; mean temperature is output every 15 minutes
-
AIR724
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 305 cm height; mean temperature is output every 15 minutes
-
AIR725
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 370 cm height; mean temperature is output every 15 minutes
-
AIR726
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 395 cm height; mean temperature is output every 15 minutes
-
AIR727
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 400 cm height; mean temperature is output every 15 minutes
-
AIR728
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 450 cm height; mean temperature is output every 15 minutes
-
AIR731
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 240 cm height; mean, min, max temperature is output every 5 minutes
-
AIR732
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 255 cm height; mean, min, max temperature is output every 5 minutes
-
AIR733
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 295 cm height; mean, min, max temperature is output every 5 minutes
-
AIR734
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 305 cm height; mean, min, max temperature is output every 5 minutes
-
AIR735
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 370 cm height; mean, min, max temperature is output every 5 minutes
-
AIR736
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 395 cm height; mean, min, max temperature is output every 5 minutes
-
AIR737
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 400 cm height; mean, min, max temperature is output every 5 minutes
-
AIR738
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a locally designed PVC radiation shield at 450 cm height; mean, min, max temperature is output every 5 minutes
-
AIR839
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; Gill radiation shield; 200 cm height (See method AIR739)
-
AIR840
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; Gill radiation shield; 240 cm height (See method AIR740)
-
AIR841
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; Gill radiation shield; 350 cm height (See method AIR741)
-
AIR842
Mean daily air temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings. CS Model 107; Gill radiation shield; 395 cm height (See method AIR742)
-
AIR843
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 395 cm height (See method AIR743)
-
AIR844
Mean daily air temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; Gill radiation shield; 350 cm height (See method AIR744)
-
AIR845
Mean daily air temperature is post-calculated from all instantaneous 15 minute values, and max-min values are determined based on all instantaneous 15 minute readings. Onset HOBO V2; RS1 7-Gill radiation shield; 200 cm height (See method AIR745)
-
AIR739
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 200 cm height; mean temperature is output every 60 minutes
-
AIR740
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 240 cm height; mean temperature is output every 60 minutes
-
AIR741
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 350 cm height; mean temperature is output every 60 minutes
-
AIR742
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 395 cm height; mean temperature is output every 60 minutes
-
AIR743
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 395 cm height; mean, min, max temperature is output every 5 minutes
-
AIR744
Air temperature is sampled by a Campbell Scientific model 107 thermistor housed in a R.M. Young Gill radiation shield at 350 cm height; mean, min, max temperature is output every 5 minutes
-
AIR745
Air temperature is sampled by an Onset HOBO Water Temp V2 housed in an RS1 7-gill radiation shield at 200 cm height attached to a boom extending out from a tree directly over the stream sensor; instantaneous temperature is output every 15 minutes
HEIGHT - numeric(4,0) (ratio)
ID: HT00411.HEIGHT
Height of sensor from ground surface
Type system: Microsoft SQL Server 2019
Unit: centimeters
Precision: 1.000000
Numeric domain: type=natural, min=150.0000 (exclusive=false), max=450.0000 (exclusive=false)
QC_LEVEL - char(2) (nominal)
ID: HT00411.QC_LEVEL
Quality control flag indicates level of quality checking performed including an indication of "provisional" data.
Type system: Microsoft SQL Server 2019
Code definitions (5)
-
1A
Data is published and unlikely to change - automated range checking and manual review has been conducted. Quality is indicated in data value qualifier flags.
-
1D
Data is published and unlikely to change - data is derived or aggregated from published data of level 1A
-
1P
Data is provisional and subject to revision - preliminary quality checks have been performed
-
2A
Data is published and unlikely to change - Level 1A data has been modified such that data gaps may be filled or problem data may be removed
-
2D
Data is published and unlikely to change - data is derived or aggregated from published data of level 2A
PROBE_CODE - char(8) (nominal)
ID: HT00411.PROBE_CODE
Probe number code indicates the measurement type, site, and sensor number (e.g., AIRGS101)
Type system: Microsoft SQL Server 2019
Code definitions (43)
-
WATGSL01
Stream temperature at GSLOOK, probe no. 01
-
WATGSL02
Stream temperature at GSLOOK, probe no. 02, maintained by USGS, legacy data 1950-1981 (missing 1955-1963)
-
WATGSM01
Stream temperature at GSMACK, probe no. 01, downstream of flume in sampling pool
-
WATGS001
Stream temperature at GSWS10, probe no. 01, upstream of flume
-
WATGS101
Stream temperature at GSWS01, probe no. 01, downstream of flume
-
WATGS201
Stream temperature at GSWS02, probe no. 01, downstream of flume in sampling pool
-
WATGS301
Stream temperature at GSWS03, probe no. 01, downstream of flume
-
WATGS601
Stream temperature at GSWS06, probe no. 01, upstream of flume
-
WATGS701
Stream temperature at GSWS07, probe no. 01, downstream of flume
-
WATGS801
Stream temperature at GSWS08, probe no. 01, open canopy, discontinued 2001
-
WATGS802
Stream temperature at GSWS08, probe no. 02, upstream of flume
-
WATLMA01
Stream temperature at TSLOMA, probe no. 01 located in Lookout Cr. above the confluence with Mack Cr.
-
WATLMA02
Stream temperature at TSLOMA, probe no. 02 located in Mack Cr. above the confluence with Lookout Cr.
-
WATLMC01
Stream temperature at TSLOMC, probe no. 01 located in Lookout Cr. above the confluence with McRae cr., discontinued 1996
-
WATLMC02
Stream temperature at TSLOMC, probe no. 02 located in McRae Cr. above the confluence with Lookout Cr., discontinued 1996
-
WATTGR01
Stream temperature at TSGRAS, probe no. 01, discontinued 1987
-
WATTLO01
Stream temperature at TSLOOK, probe no. 01
-
WATTMA01
Stream temperature at TSMACK, probe no. 01, discontinued 1994
-
WATTMC01
Stream temperature at TSMCRA, probe no. 01, discontinued 2015
-
WATTQZ01
Stream temperature at TSQRTZ, probe no. 01, discontinued 1994
-
AIRGS001
Air temperature at GSWS10, probe no. 01 at height 400 cm
-
AIRGS101
Air temperature at GSWS01, probe no. 01 at height 305 cm
-
AIRGS201
Air temperature at GSWS02, probe no. 01 at height 450 cm
-
AIRGS301
Air temperature at GSWS03, probe no. 01 at height 295 cm
-
AIRGS601
Air temperature at GSWS06, probe no. 01 at height 240 cm
-
AIRGS701
Air temperature at GSWS07, probe no. 01 at height 255 cm
-
AIRGS801
Air temperature at GSWS08, probe no. 01 at height 370 cm
-
AIRGSL01
Air temperature at GSLOOK, probe no. 01 at height 395 cm
-
AIRGSM01
Air temperature at GSMACK, probe no. 01 at height 350 cm
-
AIRLMA01
Air temperature at TSLOMA, probe no. 01 at height 350 cm, discontinued 2017
-
AIRLMC01
Air temperature at TSLOMC, probe no. 01 at height 365 cm, discontinued 1996
-
AIRTGR01
Air temperature at TSGRAS, probe no. 01 at height 100 cm, discontinued 1987
-
AIRTLO01
Air temperature at TSLOOK, probe no. 01 at height 240 cm, discontinued 2017
-
AIRTMA01
Air temperature at TSMACK, probe no. 01 at height 200 cm, discontinued 1995
-
AIRTMC01
Air temperature at TSMCRA, probe no. 01 at height 200 cm, discontinued 2015
-
AIRTQZ01
Air temperature at TSQRTZ, probe no. 01 at height 100 cm, discontinued 1994
-
WATGSL03
Stream temperature at GSLOOK, probe no. 03, established 2016 at the Lookout Creek gauging station
-
WATTMA02
Stream temperature at TSMACK, probe no. 02, established 2016 upstream of the gauging station
-
WATMCB01
Stream temperature at TSMCBR, probe no. 01, established 2017 near McRae Bridge
-
WATCLD01
Stream temperature at TSCOLD, probe no. 01, established 2016 on Cold Creek
-
WATLMC03
Stream temperature at TSLOMC, probe no. 03, established 2017 on Lookout Creek above the Lookout-McRae confluence
-
AIRTLO02
Air temperature at TSLOOK, probe no. 02 at height 200 cm, established 2017 at upper Lookout site
-
AIRLMA02
Air temperature at TSLOMA, probe no. 02 at height 200 cm, established 2017 over Mack Creek at the Lookout-Mack confluence site
DATE_TIME - datetime (dateTime)
ID: HT00411.DATE_TIME
Date and time (PST) of probe reading
Type system: Microsoft SQL Server 2019
Date format: YYYY-MM-DD hh:mm:ss
AIRTEMP_MEAN - numeric(5,1) (interval)
ID: HT00411.AIRTEMP_MEAN
Mean air temperature over the last interval (e.g., 5 minutes)
Type system: Microsoft SQL Server 2019
Unit: degrees Celsius
Precision: 0.100000
Numeric domain: type=real, min=-19.7000 (exclusive=false), max=41.4000 (exclusive=false)
AIRTEMP_MEAN_FLAG - char(1) (nominal)
ID: HT00411.AIRTEMP_MEAN_FLAG
Mean air temperature flag
Type system: Microsoft SQL Server 2019
Code definitions (7)
-
A
Accepted value has passed all QC tests applied as represented by the quality level
-
B
Sensor buried in snow; value is the snow temperature
-
E
Estimated value
-
M
Missing value
-
Q
Questionable value
-
S
Daily value based on 24 hour period defined from sunrise to sunrise
-
P
Fire effects are visible in the data
EVENT_CODE - char(6) (nominal)
ID: HT00411.EVENT_CODE
Type of comment that exists independently for any event, disruption in protocol, or unusual conditions that occur at the given date or time and may have an effect on the data values
Type system: Microsoft SQL Server 2019
Code definitions (9)
-
CALIBR
Associated with the inspection or replacement of sensors for calibration
-
INSREM
Sensor is installed or removed
-
LOGGER
Change in data logger, data logger program, or wiring
-
MAINTE
A maintenance event has occurred
-
METHOD
Change in data collection method
-
NA
No event is reported (not applicable)
-
QUALTY
Event may directly affect data quality
-
WEATHR
A weather event has occurred that may affect reading
-
BURNED
Burning, including cleared trees and brush or wildfire, around the meteorological station or within the watershed (code begins at event initiation)
HT00441 - Stream temperature (daily)
Object name: HT00441_v8.csv
Records: 147320
Attributes: 16
Temporal coverage: 1000-01-01 to 1000-01-01
File size: 12410983 byte
Checksum (MD5): 03328393a8adf4c372f134388d3940be
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY HT00441.DATE, HT00441.PROBE_CODE
-
notNullConstraint: NOTNULL HT00441.DATE, HT00441.WATERTEMP_MEAN_FLAG, HT00441.WATERTEMP_MAX_FLAG, HT00441.WATERTEMP_MIN_FLAG, HT00441.PROBE_CODE, HT00441.DBCODE, HT00441.SITECODE, HT00441.ENTITY, HT00441.QC_LEVEL, HT00441.EVENT_CODE, HT00441.WATERTEMP_METHOD
Attributes (16)
DBCODE - char(5) (nominal)
ID: HT00441.DBCODE
FSDB database code
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
HT004
Study code HT004
ENTITY - numeric(2,0) (interval)
ID: HT00441.ENTITY
Entity number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=41.0000 (exclusive=false), max=41.0000 (exclusive=false)
SITECODE - char(6) (nominal)
ID: HT00441.SITECODE
Site code for the meteorological measurement station
Type system: Microsoft SQL Server 2019
Code definitions (18)
-
GSWS01
Andrews Watershed 1 Gaging Station
-
GSWS02
Andrews Watershed 2 Gaging Station
-
GSWS03
Andrews Watershed 3 Gaging Station
-
GSWS06
Andrews Watershed 6 Gaging Station
-
GSWS07
Andrews Watershed 7 Gaging Station
-
GSWS08
Andrews Watershed 8 Gaging Station
-
GSWS10
Andrews Watershed 10 Gaging Station
-
GSMACK
Andrews Mack Creek Gaging Station
-
GSLOOK
Andrews Lookout Creek Gaging Station
-
TSGRAS
Grasshopper Creek (S. Fork McKenzie) thermograph site
-
TSLOOK
Lookout Creek upper thermograph site
-
TSMACK
Mack Creek old-growth thermograph site
-
TSMCRA
McRae Creek upper thermograph site
-
TSQRTZ
Quartz Creek (Blue River tributary) thermograph site
-
TSLOMA
Lookout and Mack Creek confluence thermograph site
-
TSLOMC
Lookout and McRae Creek confluence thermograph site
-
TSCOLD
Cold Creek thermograph site
-
TSMCBR
McRae Bridge thermograph site
WATERTEMP_METHOD - char(6) (nominal)
ID: HT00441.WATERTEMP_METHOD
An indication of the the general methodology and instrumentation used to collect this water temperature data
Type system: Microsoft SQL Server 2019
Code definitions (17)
-
WAT007
Stream temperature is sampled by a Campbell Scientific model 107 thermistor secured in the stream inside a colander-like metal pipe shade shelter; mean temperature is output every 60 minutes
-
WAT006
Stream temperature is sampled by a Campbell Scientific data logger using type T thermocouple soldered from thermocouple wire placed in the stream inside a colander-like metal pipe shade shelter; mean temperature is output every 60 minutes
-
WAT009
Stream temperature is sampled by a Campbell Scientific CS547A conductivity and temperature probe secured in the stream inside a colander-like metal pipe shade shelter; mean, min, max temperature is output every 5 minutes
-
WAT008
Stream temperature is sampled by a Campbell Scientific CS547A conductivity and temperature probe secured in the stream inside a colander-like metal pipe shade shelter; mean temperature is output every 15 minutes
-
WAT101
Max and min daily stream temperature is provided by the USGS National Water Information System
-
WAT102
Daily stream temperature is not collected during this period
-
WAT103
Mean, max and min daily (sunrise to sunrise) air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb placed in the stream with shade shelter
-
WAT104
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb placed in the stream with shade shelter
-
WAT105
Mean, max and min daily stream temperature is calculated by a Campbell Scientific datalogger based on 10 second samples. Instrument is type T thermocouple soldered from thermocouple wire and placed in stream with shade shelter (Daily output only)
-
WAT106
Mean daily stream temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings.Thermocouple wire; metal pipe shade shelter (See method WAT006)
-
WAT107
Mean daily stream temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings.CS Model 107 thermistor; metal pipe shade shelter (See method WAT007)
-
WAT108
Mean daily stream temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings.CS547A; metal pipe shade shelter (See method WAT008)
-
WAT109
Mean daily stream temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS547A; metal pipe shade shelter (See method WAT009)
-
WAT010
Stream temperature is sampled by a Campbell Scientific model 107 thermistor secured in the stream inside a colander-like metal pipe shade shelter; mean, min and max temperature is output every 5 minutes
-
WAT011
Stream temperature is sampled by an Onset HOBO Water Temp V2 anchored to the streambed and placed in an aluminum or pvc housing to shelter and weight the sensor near stream bottom; instantaneous temperature is output every 15 minutes
-
WAT110
Mean daily stream temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; metal pipe shade shelter (See method WAT010)
-
WAT111
Mean daily stream temperature is post-calculated from all 15 minute instantaneous values, and max-min values are determined based on all instantaneous 15 minute readings. HOBO V2; aluminum or PVC housing (See method WAT011)
QC_LEVEL - char(2) (nominal)
ID: HT00441.QC_LEVEL
Quality control flag indicates level of quality checking performed including an indication of "provisional" data.
Type system: Microsoft SQL Server 2019
Code definitions (5)
-
1A
Data is published and unlikely to change - automated range checking and manual review has been conducted. Quality is indicated in data value qualifier flags.
-
1D
Data is published and unlikely to change - data is derived or aggregated from published data of level 1A
-
1P
Data is provisional and subject to revision - preliminary quality checks have been performed
-
2A
Data is published and unlikely to change - Level 1A data has been modified such that data gaps may be filled or problem data may be removed
-
2D
Data is published and unlikely to change - data is derived or aggregated from published data of level 2A
PROBE_CODE - char(8) (nominal)
ID: HT00441.PROBE_CODE
Probe number code indicates the measurement type, site, and sensor number (e.g., AIRGS101)
Type system: Microsoft SQL Server 2019
Code definitions (43)
-
WATGSL01
Stream temperature at GSLOOK, probe no. 01
-
WATGSL02
Stream temperature at GSLOOK, probe no. 02, maintained by USGS, legacy data 1950-1981 (missing 1955-1963)
-
WATGSM01
Stream temperature at GSMACK, probe no. 01, downstream of flume in sampling pool
-
WATGS001
Stream temperature at GSWS10, probe no. 01, upstream of flume
-
WATGS101
Stream temperature at GSWS01, probe no. 01, downstream of flume
-
WATGS201
Stream temperature at GSWS02, probe no. 01, downstream of flume in sampling pool
-
WATGS301
Stream temperature at GSWS03, probe no. 01, downstream of flume
-
WATGS601
Stream temperature at GSWS06, probe no. 01, upstream of flume
-
WATGS701
Stream temperature at GSWS07, probe no. 01, downstream of flume
-
WATGS801
Stream temperature at GSWS08, probe no. 01, open canopy, discontinued 2001
-
WATGS802
Stream temperature at GSWS08, probe no. 02, upstream of flume
-
WATLMA01
Stream temperature at TSLOMA, probe no. 01 located in Lookout Cr. above the confluence with Mack Cr.
-
WATLMA02
Stream temperature at TSLOMA, probe no. 02 located in Mack Cr. above the confluence with Lookout Cr.
-
WATLMC01
Stream temperature at TSLOMC, probe no. 01 located in Lookout Cr. above the confluence with McRae cr., discontinued 1996
-
WATLMC02
Stream temperature at TSLOMC, probe no. 02 located in McRae Cr. above the confluence with Lookout Cr., discontinued 1996
-
WATTGR01
Stream temperature at TSGRAS, probe no. 01, discontinued 1987
-
WATTLO01
Stream temperature at TSLOOK, probe no. 01
-
WATTMA01
Stream temperature at TSMACK, probe no. 01, discontinued 1994
-
WATTMC01
Stream temperature at TSMCRA, probe no. 01, discontinued 2015
-
WATTQZ01
Stream temperature at TSQRTZ, probe no. 01, discontinued 1994
-
AIRGS001
Air temperature at GSWS10, probe no. 01 at height 400 cm
-
AIRGS101
Air temperature at GSWS01, probe no. 01 at height 305 cm
-
AIRGS201
Air temperature at GSWS02, probe no. 01 at height 450 cm
-
AIRGS301
Air temperature at GSWS03, probe no. 01 at height 295 cm
-
AIRGS601
Air temperature at GSWS06, probe no. 01 at height 240 cm
-
AIRGS701
Air temperature at GSWS07, probe no. 01 at height 255 cm
-
AIRGS801
Air temperature at GSWS08, probe no. 01 at height 370 cm
-
AIRGSL01
Air temperature at GSLOOK, probe no. 01 at height 395 cm
-
AIRGSM01
Air temperature at GSMACK, probe no. 01 at height 350 cm
-
AIRLMA01
Air temperature at TSLOMA, probe no. 01 at height 350 cm, discontinued 2017
-
AIRLMC01
Air temperature at TSLOMC, probe no. 01 at height 365 cm, discontinued 1996
-
AIRTGR01
Air temperature at TSGRAS, probe no. 01 at height 100 cm, discontinued 1987
-
AIRTLO01
Air temperature at TSLOOK, probe no. 01 at height 240 cm, discontinued 2017
-
AIRTMA01
Air temperature at TSMACK, probe no. 01 at height 200 cm, discontinued 1995
-
AIRTMC01
Air temperature at TSMCRA, probe no. 01 at height 200 cm, discontinued 2015
-
AIRTQZ01
Air temperature at TSQRTZ, probe no. 01 at height 100 cm, discontinued 1994
-
WATGSL03
Stream temperature at GSLOOK, probe no. 03, established 2016 at the Lookout Creek gauging station
-
WATTMA02
Stream temperature at TSMACK, probe no. 02, established 2016 upstream of the gauging station
-
WATMCB01
Stream temperature at TSMCBR, probe no. 01, established 2017 near McRae Bridge
-
WATCLD01
Stream temperature at TSCOLD, probe no. 01, established 2016 on Cold Creek
-
WATLMC03
Stream temperature at TSLOMC, probe no. 03, established 2017 on Lookout Creek above the Lookout-McRae confluence
-
AIRTLO02
Air temperature at TSLOOK, probe no. 02 at height 200 cm, established 2017 at upper Lookout site
-
AIRLMA02
Air temperature at TSLOMA, probe no. 02 at height 200 cm, established 2017 over Mack Creek at the Lookout-Mack confluence site
DATE - datetime (dateTime)
ID: HT00441.DATE
Date
Type system: Microsoft SQL Server 2019
Date format: YYYY-MM-DD
WATERTEMP_MEAN_DAY - numeric(5,1) (interval)
ID: HT00441.WATERTEMP_MEAN_DAY
Mean water temperature for the day
Type system: Microsoft SQL Server 2019
Unit: degrees Celsius
Precision: 0.100000
Numeric domain: type=real, min=-1.8000 (exclusive=false), max=19.4000 (exclusive=false)
WATERTEMP_MEAN_FLAG - char(1) (nominal)
ID: HT00441.WATERTEMP_MEAN_FLAG
Mean water temperature flag
Type system: Microsoft SQL Server 2019
Code definitions (7)
-
A
Accepted value has passed all QC tests applied as represented by the quality level
-
B
Sensor buried in sediment
-
E
Estimated value
-
M
Missing value
-
S
Daily value based on sunrise to sunrise (not midnight to midnight)
-
Q
Questionable value
-
P
Fire effects are visible in the data
WATERTEMP_MAX_DAY - numeric(5,1) (interval)
ID: HT00441.WATERTEMP_MAX_DAY
Maximum water temperature for the day
Type system: Microsoft SQL Server 2019
Unit: degrees Celsius
Precision: 0.100000
Numeric domain: type=real, min=-1.8000 (exclusive=false), max=25.0000 (exclusive=false)
WATERTEMP_MAX_FLAG - char(1) (nominal)
ID: HT00441.WATERTEMP_MAX_FLAG
Maximum water temperature flag
Type system: Microsoft SQL Server 2019
Code definitions (7)
-
A
Accepted value has passed all QC tests applied as represented by the quality level
-
B
Sensor buried in sediment
-
E
Estimated value
-
M
Missing value
-
S
Daily value based on sunrise to sunrise (not midnight to midnight)
-
Q
Questionable value
-
P
Fire effects are visible in the data
WATERTEMP_MAXTIME - char(4) (nominal)
ID: HT00441.WATERTEMP_MAXTIME
Time of day (HHMM) in Pacific Standard Time (PST) of maximum water temperature
Type system: Microsoft SQL Server 2019
WATERTEMP_MIN_DAY - numeric(5,1) (interval)
ID: HT00441.WATERTEMP_MIN_DAY
Minimum water temperature for the day
Type system: Microsoft SQL Server 2019
Unit: degrees Celsius
Precision: 0.100000
Numeric domain: type=real, min=-1.8000 (exclusive=false), max=19.0000 (exclusive=false)
WATERTEMP_MIN_FLAG - char(1) (nominal)
ID: HT00441.WATERTEMP_MIN_FLAG
Minimum water temperature flag
Type system: Microsoft SQL Server 2019
Code definitions (7)
-
A
Accepted value has passed all QC tests applied as represented by the quality level
-
B
Sensor buried in sediment
-
E
Estimated value
-
M
Missing value
-
S
Daily value based on sunrise to sunrise (not midnight to midnight)
-
Q
Questionable value
-
P
Fire effects are visible in the data
WATERTEMP_MINTIME - char(4) (nominal)
ID: HT00441.WATERTEMP_MINTIME
Time of day (HHMM) in Pacific Standard Time (PST) of minimum water temperature
Type system: Microsoft SQL Server 2019
EVENT_CODE - char(6) (nominal)
ID: HT00441.EVENT_CODE
Type of comment that exists independently for any event, disruption in protocol, or unusual conditions that occur at the given date or time and may have an effect on the data values
Type system: Microsoft SQL Server 2019
Code definitions (9)
-
CALIBR
Associated with the inspection or replacement of sensors for calibration
-
INSREM
Sensor is installed or removed
-
LOGGER
Change in data logger, data logger program, or wiring
-
MAINTE
A maintenance event has occurred
-
METHOD
Change in data collection method
-
NA
No event is reported (not applicable)
-
QUALTY
Event may directly affect data quality
-
WEATHR
A weather event has occurred that may affect reading
-
BURNED
Burning, including cleared trees and brush or wildfire, around the meteorological station or within the watershed (code begins at event initiation)
HT00451 - Stream temperature (fine temporal resolution)
Object name: HT00451_v10.txt
Records: 12776656
Attributes: 10
Temporal coverage: 1000-01-01 to 1000-01-01
File size: 936672945 byte
Checksum (MD5): ce24250c042c2388bb652a2dcf285d7e
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY HT00451.DATE_TIME, HT00451.PROBE_CODE
-
notNullConstraint: NOTNULL HT00451.DATE_TIME, HT00451.WATERTEMP_MEAN_FLAG, HT00451.PROBE_CODE, HT00451.DBCODE, HT00451.SITECODE, HT00451.ENTITY, HT00451.QC_LEVEL, HT00451.EVENT_CODE, HT00451.WATERTEMP_METHOD
Attributes (10)
DBCODE - char(5) (nominal)
ID: HT00451.DBCODE
FSDB database code
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
HT004
Study code HT004
ENTITY - numeric(2,0) (interval)
ID: HT00451.ENTITY
Entity number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=51.0000 (exclusive=false), max=51.0000 (exclusive=false)
SITECODE - char(6) (nominal)
ID: HT00451.SITECODE
Site code for the meteorological measurement station
Type system: Microsoft SQL Server 2019
Code definitions (18)
-
GSWS01
Andrews Watershed 1 Gaging Station
-
GSWS02
Andrews Watershed 2 Gaging Station
-
GSWS03
Andrews Watershed 3 Gaging Station
-
GSWS06
Andrews Watershed 6 Gaging Station
-
GSWS07
Andrews Watershed 7 Gaging Station
-
GSWS08
Andrews Watershed 8 Gaging Station
-
GSWS10
Andrews Watershed 10 Gaging Station
-
GSMACK
Andrews Mack Creek Gaging Station
-
GSLOOK
Andrews Lookout Creek Gaging Station
-
TSGRAS
Grasshopper Creek (S. Fork McKenzie) thermograph site
-
TSLOOK
Lookout Creek upper thermograph site
-
TSMACK
Mack Creek old-growth thermograph site
-
TSMCRA
McRae Creek upper thermograph site
-
TSQRTZ
Quartz Creek (Blue River tributary) thermograph site
-
TSLOMA
Lookout and Mack Creek confluence thermograph site
-
TSLOMC
Lookout and McRae Creek confluence thermograph site
-
TSCOLD
Cold Creek thermograph site
-
TSMCBR
McRae Bridge thermograph site
WATERTEMP_METHOD - char(6) (nominal)
ID: HT00451.WATERTEMP_METHOD
An indication of the the general methodology and instrumentation used to collect this water temperature data
Type system: Microsoft SQL Server 2019
Code definitions (17)
-
WAT007
Stream temperature is sampled by a Campbell Scientific model 107 thermistor secured in the stream inside a colander-like metal pipe shade shelter; mean temperature is output every 60 minutes
-
WAT006
Stream temperature is sampled by a Campbell Scientific data logger using type T thermocouple soldered from thermocouple wire placed in the stream inside a colander-like metal pipe shade shelter; mean temperature is output every 60 minutes
-
WAT009
Stream temperature is sampled by a Campbell Scientific CS547A conductivity and temperature probe secured in the stream inside a colander-like metal pipe shade shelter; mean, min, max temperature is output every 5 minutes
-
WAT008
Stream temperature is sampled by a Campbell Scientific CS547A conductivity and temperature probe secured in the stream inside a colander-like metal pipe shade shelter; mean temperature is output every 15 minutes
-
WAT101
Max and min daily stream temperature is provided by the USGS National Water Information System
-
WAT102
Daily stream temperature is not collected during this period
-
WAT103
Mean, max and min daily (sunrise to sunrise) air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb placed in the stream with shade shelter
-
WAT104
Mean, max and min daily air temperature is determined from digitizing circular Partlow charts. Temperature is recorded by a Dual Recording Thermometer Model RFHTT with mercury bulb placed in the stream with shade shelter
-
WAT105
Mean, max and min daily stream temperature is calculated by a Campbell Scientific datalogger based on 10 second samples. Instrument is type T thermocouple soldered from thermocouple wire and placed in stream with shade shelter (Daily output only)
-
WAT106
Mean daily stream temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings.Thermocouple wire; metal pipe shade shelter (See method WAT006)
-
WAT107
Mean daily stream temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings.CS Model 107 thermistor; metal pipe shade shelter (See method WAT007)
-
WAT108
Mean daily stream temperature is calculated by the Campbell Scientific datalogger based on 10 second samples. Max-min values are based on instantaneous 10 second readings.CS547A; metal pipe shade shelter (See method WAT008)
-
WAT109
Mean daily stream temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS547A; metal pipe shade shelter (See method WAT009)
-
WAT010
Stream temperature is sampled by a Campbell Scientific model 107 thermistor secured in the stream inside a colander-like metal pipe shade shelter; mean, min and max temperature is output every 5 minutes
-
WAT011
Stream temperature is sampled by an Onset HOBO Water Temp V2 anchored to the streambed and placed in an aluminum or pvc housing to shelter and weight the sensor near stream bottom; instantaneous temperature is output every 15 minutes
-
WAT110
Mean daily stream temperature is post-calculated from all 5 minute values, and max-min values are determined based on all instantaneous 10 second readings. CS Model 107; metal pipe shade shelter (See method WAT010)
-
WAT111
Mean daily stream temperature is post-calculated from all 15 minute instantaneous values, and max-min values are determined based on all instantaneous 15 minute readings. HOBO V2; aluminum or PVC housing (See method WAT011)
QC_LEVEL - char(2) (nominal)
ID: HT00451.QC_LEVEL
Quality control flag indicates level of quality checking performed including an indication of "provisional" data.
Type system: Microsoft SQL Server 2019
Code definitions (5)
-
1A
Data is published and unlikely to change - automated range checking and manual review has been conducted. Quality is indicated in data value qualifier flags.
-
1D
Data is published and unlikely to change - data is derived or aggregated from published data of level 1A
-
1P
Data is provisional and subject to revision - preliminary quality checks have been performed
-
2A
Data is published and unlikely to change - Level 1A data has been modified such that data gaps may be filled or problem data may be removed
-
2D
Data is published and unlikely to change - data is derived or aggregated from published data of level 2A
PROBE_CODE - char(8) (nominal)
ID: HT00451.PROBE_CODE
Probe number code indicates the measurement type, site, and sensor number (e.g., AIRGS101)
Type system: Microsoft SQL Server 2019
Code definitions (43)
-
WATGSL01
Stream temperature at GSLOOK, probe no. 01
-
WATGSL02
Stream temperature at GSLOOK, probe no. 02, maintained by USGS, legacy data 1950-1981 (missing 1955-1963)
-
WATGSM01
Stream temperature at GSMACK, probe no. 01, downstream of flume in sampling pool
-
WATGS001
Stream temperature at GSWS10, probe no. 01, upstream of flume
-
WATGS101
Stream temperature at GSWS01, probe no. 01, downstream of flume
-
WATGS201
Stream temperature at GSWS02, probe no. 01, downstream of flume in sampling pool
-
WATGS301
Stream temperature at GSWS03, probe no. 01, downstream of flume
-
WATGS601
Stream temperature at GSWS06, probe no. 01, upstream of flume
-
WATGS701
Stream temperature at GSWS07, probe no. 01, downstream of flume
-
WATGS801
Stream temperature at GSWS08, probe no. 01, open canopy, discontinued 2001
-
WATGS802
Stream temperature at GSWS08, probe no. 02, upstream of flume
-
WATLMA01
Stream temperature at TSLOMA, probe no. 01 located in Lookout Cr. above the confluence with Mack Cr.
-
WATLMA02
Stream temperature at TSLOMA, probe no. 02 located in Mack Cr. above the confluence with Lookout Cr.
-
WATLMC01
Stream temperature at TSLOMC, probe no. 01 located in Lookout Cr. above the confluence with McRae cr., discontinued 1996
-
WATLMC02
Stream temperature at TSLOMC, probe no. 02 located in McRae Cr. above the confluence with Lookout Cr., discontinued 1996
-
WATTGR01
Stream temperature at TSGRAS, probe no. 01, discontinued 1987
-
WATTLO01
Stream temperature at TSLOOK, probe no. 01
-
WATTMA01
Stream temperature at TSMACK, probe no. 01, discontinued 1994
-
WATTMC01
Stream temperature at TSMCRA, probe no. 01, discontinued 2015
-
WATTQZ01
Stream temperature at TSQRTZ, probe no. 01, discontinued 1994
-
AIRGS001
Air temperature at GSWS10, probe no. 01 at height 400 cm
-
AIRGS101
Air temperature at GSWS01, probe no. 01 at height 305 cm
-
AIRGS201
Air temperature at GSWS02, probe no. 01 at height 450 cm
-
AIRGS301
Air temperature at GSWS03, probe no. 01 at height 295 cm
-
AIRGS601
Air temperature at GSWS06, probe no. 01 at height 240 cm
-
AIRGS701
Air temperature at GSWS07, probe no. 01 at height 255 cm
-
AIRGS801
Air temperature at GSWS08, probe no. 01 at height 370 cm
-
AIRGSL01
Air temperature at GSLOOK, probe no. 01 at height 395 cm
-
AIRGSM01
Air temperature at GSMACK, probe no. 01 at height 350 cm
-
AIRLMA01
Air temperature at TSLOMA, probe no. 01 at height 350 cm, discontinued 2017
-
AIRLMC01
Air temperature at TSLOMC, probe no. 01 at height 365 cm, discontinued 1996
-
AIRTGR01
Air temperature at TSGRAS, probe no. 01 at height 100 cm, discontinued 1987
-
AIRTLO01
Air temperature at TSLOOK, probe no. 01 at height 240 cm, discontinued 2017
-
AIRTMA01
Air temperature at TSMACK, probe no. 01 at height 200 cm, discontinued 1995
-
AIRTMC01
Air temperature at TSMCRA, probe no. 01 at height 200 cm, discontinued 2015
-
AIRTQZ01
Air temperature at TSQRTZ, probe no. 01 at height 100 cm, discontinued 1994
-
WATGSL03
Stream temperature at GSLOOK, probe no. 03, established 2016 at the Lookout Creek gauging station
-
WATTMA02
Stream temperature at TSMACK, probe no. 02, established 2016 upstream of the gauging station
-
WATMCB01
Stream temperature at TSMCBR, probe no. 01, established 2017 near McRae Bridge
-
WATCLD01
Stream temperature at TSCOLD, probe no. 01, established 2016 on Cold Creek
-
WATLMC03
Stream temperature at TSLOMC, probe no. 03, established 2017 on Lookout Creek above the Lookout-McRae confluence
-
AIRTLO02
Air temperature at TSLOOK, probe no. 02 at height 200 cm, established 2017 at upper Lookout site
-
AIRLMA02
Air temperature at TSLOMA, probe no. 02 at height 200 cm, established 2017 over Mack Creek at the Lookout-Mack confluence site
DATE_TIME - datetime (dateTime)
ID: HT00451.DATE_TIME
Date and time (PST) of probe reading
Type system: Microsoft SQL Server 2019
Date format: YYYY-MM-DD hh:mm:ss
WATERTEMP_MEAN - numeric(5,1) (interval)
ID: HT00451.WATERTEMP_MEAN
Mean water temperature over the last interval (e.g., 5 minutes)
Type system: Microsoft SQL Server 2019
Unit: degrees Celsius
Precision: 0.100000
Numeric domain: type=real, min=-2.2000 (exclusive=false), max=29.5000 (exclusive=false)
WATERTEMP_MEAN_FLAG - char(1) (nominal)
ID: HT00451.WATERTEMP_MEAN_FLAG
Mean water temperature flag
Type system: Microsoft SQL Server 2019
Code definitions (7)
-
A
Accepted value has passed all QC tests applied as represented by the quality level
-
B
Sensor buried in sediment
-
E
Estimated value
-
M
Missing value
-
S
Daily value based on sunrise to sunrise (not midnight to midnight)
-
Q
Questionable value
-
P
Fire effects are visible in the data
EVENT_CODE - char(6) (nominal)
ID: HT00451.EVENT_CODE
Type of comment that exists independently for any event, disruption in protocol, or unusual conditions that occur at the given date or time and may have an effect on the data values
Type system: Microsoft SQL Server 2019
Code definitions (9)
-
CALIBR
Associated with the inspection or replacement of sensors for calibration
-
INSREM
Sensor is installed or removed
-
LOGGER
Change in data logger, data logger program, or wiring
-
MAINTE
A maintenance event has occurred
-
METHOD
Change in data collection method
-
NA
No event is reported (not applicable)
-
QUALTY
Event may directly affect data quality
-
WEATHR
A weather event has occurred that may affect reading
-
BURNED
Burning, including cleared trees and brush or wildfire, around the meteorological station or within the watershed (code begins at event initiation)
Units
| centimeters | cm | length | centimeter | meter | 0.01 | centimeters; .01 meters |
| 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 |
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
Maintenance
Maintenance update frequency: continually
Description
- An update history is logged and maintained with each new version of every dataset.
Change History
-
Version1 (1000-01-01) In October 1991, all thermograph data were run through a data checking program. Many pre-1987 24-hr mean values were recalculated using weighted daytime and nighttime means (values are flagged as 'S').
-
Version2 (1000-01-01) As of October 1994, all data were run through another set of checking routines. These included 1) missing flag check to ensure that all missing data really has the appropriate flag; 2) date/time check to verify that a record exists for each date (and hour if applicable) and that records fall in the correct order; 3) relative mean/max/min check for each record to make sure that min <= mean <= max; 4) similar sites were paired and the values compared to catch any gross outliers. As a result of #4, some thermograph charts had to be redigitized.
-
Version3 (1000-01-01) Original metadata creation.
-
Version4 (1000-01-01) The data is actively managed as an extension of MS001 (and not HT004). Daily formats are identical to MS001 entity 01. Hourly data for the Stream thermograph sites begin in the years 1995 to 1998 and are originally accommodated by MS001 entity 11.
-
Version5 (1000-01-01) Appended all data to master files. Separated stream temperature from air temperature and placed in separate entities. Reformatted all thermograph sites to use MS001 01,11 formats (daily air temp, hourly air temp) and created similar entities 24, 34 (daily stream temp, hourly stream temp). Also reformatted all data for discontinued sites. Uploaded to the web.
-
Version6 (1000-01-01) Data is prepared for move into SQLServer as study dataset HT004. A new data abstract is prepared. Stream temperature site data is updated for current sites. All day/night data has been removed and stored in P:\FSDB\HT04\day_night, and this data will only be available by request and not available on the web.
-
Version8 (1000-01-01) Updated data for all stream gauging sites for WY 2003 & 2004 (all entities).
-
Version9 (1000-01-01) Updated data for all stream gauging sites for WY 2005 through January 2007 and reference stream sites from January 2004 through March 2007 (all entities).
-
Version10 (1000-01-01) Updated data for Mack and Watersheds (1,2,3,6,7,8,10) for WY07 (Jan 06-Oct 07) 02/05/2009
-
Version11 (1000-01-01) Updated data for Mack and Watersheds (1,2,3,6,7,8,10) for WY08 and WY09 (Oct 07-Jan 10) 02/08/2010
-
Version12 (1000-01-01) Updated data for GSLOOK and confluence streams (TSLOMA, TSLOOK, TSMCRA) for 3/2007-3/2010 04/06/2010
-
Version13 (1000-01-01) Updated data for Mack and Watersheds (1,2,3,6,7,8,10) for WY10 (Jan 10-Mar 11)
-
Version16 (1000-01-01) Updated data for GSLOOK and confluence streams (TSLOMA, TSLOOk,TSMCRA) for 3/2/2010-12/31/2011. Also ran QA/QC on entire dataset and fixed a few problems (mainly some missing hours). Uploaded this new dataset (entirely) to SQL.
-
Version17 (1000-01-01) Updated watershed data (mack, 1,2,3,6,7,8,10) from 20110301 to 20120110.
-
Version18 (1000-01-01) Updated attribute description for attributes with a fine resolution datetime measurement scale to include 'PST' (pacific standard time).
-
Version19 (1000-01-01) Updated air and water temperature data for GSLOOK and confluence streams (TSLOMA, TSLOOk,TSMCRA) for 01/01/2012 to 07/31/2013 and watershed data (mack, 1,2,3,6,7,8,10) from 20120110 to 12/31/2012. Also ran QA/QC on entire dataset. Uploaded new dataset (entirely) to SQL and to master.
-
Version20 (1000-01-01) Updated watershed data for Mack and Watersheds 1, 2, 3, 6, 7, 8, and 10 with new data from 1 Jan 2013 to 15 Jan 2014.
-
Version21 (1000-01-01) Updated all daily and hourly stream and air temperature at current stream temperature station sites through calendar year 2014, which includes watersheds (Mack, 1,2,3,6,7,8,10) from 01/14/2014 to 01/06/2015 and streams (GSLOOK, TSLOOK, TSLOMA, TSMCRA) from 08/01/2013 to 12/31/2014.
-
Version22 (1000-01-01) Restructured HT004 to be consistent with entity structures and naming conventions used in MS001 and MS005 study databases. Method code and event codes are added to each entity and a QC level indicator. All data is updated for calendar year 2015.
-
Version23 (1000-01-01) Water and air temperature are updated at the gauging stations (WS1,2,3,6,7,8,10, Mack and Lookout) through water year 2019 (10/1/2019). The upper Lookout and Lookout-Mack confluence sites are updated into spring 2017 when the older sensors were removed. New Hobo V2 sensors are now employed at these sites and at new sites (Mack, McRae Bridge and Cold Creek), but no data from these are added yet. New locations for air temperature at sites TSLOOK and TSLOMA are initiated. McRae Creek (TSMCRA) site is discontinued but now has NEON measurements.
-
Version24 (1000-01-01) Water and air temperature are updated at the gauging stations (WS1,2,3,6,7,8,10, Mack) through water year 2024 (10/1/2024). Data from HOBO sites and LOOK are not added yet. Fasbbrige and im_sqe programs were used to process these data
-
Version25 (1000-01-01) This revision corrects a data entry error in the previous version where the site code for the GS Lookout site was incorrectly recorded as 'GSL' instead of the correct code 'GSLOOK' throughout the dataset.