Did You Find What You Needed?

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

Share Your Feedback

HT004: Stream and air temperature data from stream gages and stream confluences in the Andrews Experimental Forest, 1950 to present

← Back to catalog index

Status: continually
Period: 1000-01-01 to 1000-01-01
Version: 25
Published: 1000-01-01
EDI Package ID: knb-lter-and.4020.25
Source XML: HT004_25.xml

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
Abstract
  • The H.J. Andrews Experimental Forest is a living laboratory that provides unparalleled opportunities for the study of forest and stream ecosystems in the central Cascade Range of Oregon. Since 1980, as a part of the National Science Foundation Long Term Ecological Research (NSF-LTER) program, the Andrews Experimental Forest has become a leader in the analysis of forest and stream ecosystem dynamics.
  • Long-term field experiments and measurement programs have focused on climate dynamics, streamflow, water quality, and vegetation succession. Currently researchers are working to develop concepts and tools needed to predict effects of natural disturbance, land use, and climate change on ecosystem structure, function, and species composition.
  • The Andrews Experimental Forest is administered cooperatively by the USDA Forest Service Pacific Northwest Research Station, Oregon State University and the Willamette National Forest. Funding for the research program comes from the National Science Foundation (NSF), US Forest Service Pacific Northwest Research Station, Oregon State University, and other sources.
Funding

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

Awards
Study Area Description
  • Long-Term Ecological Research
    The Andrews Forest is situated in the western Cascade Range of Oregon, and covers the entire 15,800-acre (6400-ha) drainage basin of Lookout Creek. Elevation ranges from 1350 to 5340 feet (410 to 1630 m). Broadly representative of the rugged mountainous landscape of the Pacific Northwest, the Andrews Forest contains excellent examples of the region's conifer forests and associated wildlife and stream ecosystems. These forests are among the tallest and most productive in the world, with tree heights of often greater than 250 ft (75 m). Streams are steep, cold and clean, providing habitat for numerous aquatic organisms.
Associated Party
  • Craig Creel
    Role: Former Investigator
    USDA Forest Service;Pacific NW Research Station;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: (541) 750-7326, (541) 822-6301
    Email: cdcreel@comcast.net
  • Christopher Daly
    Role: Other Researcher
    PRISM Group;Northwest Alliance for Computational Science and Engineering, 2000 Kelley Engineering Center;Oregon State University, Corvallis, OR, 97331, USA
    Phone: (541) 737-2531
    Email: daly@nacse.org
  • Greg Downing
    Role: Method Contact
    Forestry Sciences Lab;3200 SW Jefferson Way, Corvallis, OR, 97333, USA
    Phone: (541) 750-7283, (541) 822-6301
    Email: gregdowning242@gmail.com, greg.downing@oregonstate.edu
  • Stanley V. Gregory
    Role: Former Investigator
    Oregon State University;Dept. of Fisheries and Wildlife;Nash Hall 104, Corvallis, OR, 97331, USA
    Phone: (541) 737-1951
    Email: stanley.gregory@oregonstate.edu
  • Stanley V. Gregory
    Role: Creator
    Oregon State University;Dept. of Fisheries and Wildlife;Nash Hall 104, Corvallis, OR, 97331, USA
    Phone: (541) 737-1951
    Email: stanley.gregory@oregonstate.edu
  • Donald L. Henshaw
    Role: Abstractor
    Pacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, Oregon, 97331
    Email: hja_admin@lists.oregonstate.edu
  • Sherri L. Johnson
    Role: Principal Investigator
    US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: 541-758-7771
    Email: sherri.johnson@oregonstate.edu
  • Sherri L. Johnson
    Role: Abstractor
    US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: 541-758-7771
    Email: sherri.johnson@oregonstate.edu
  • Sherri L. Johnson
    Role: Creator
    US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: 541-758-7771
    Email: sherri.johnson@oregonstate.edu
  • John Moreau
    Role: Former Investigator
    Blue River, OR, 97413, USA
    Email: john.b.moreau@icloud.com
  • Randall C. Wildman
    Role: Former Investigator
    Oregon State University;Dept. of Fish and Wildlife, Corvallis, OR, 97331, USA
    Email: randallcwildman@gmail.com, wildmanr@retiree.oregonstate.edu
  • Adam M Kennedy
    Role: Other Researcher
    OR, US
    Phone: 541-822-6302
    Email: adam.kennedy@oregonstate.edu
  • Greg M Cohn
    Role: Other Researcher
    USFS Rd 15-130-132, Blue River, OR, 97413
    Phone: 541-822-6305
    Email: cohng@oregonstate.edu
  • Greg M Cohn
    Role: Method Contact
    USFS Rd 15-130-132, Blue River, OR, 97413
    Phone: 541-822-6305
    Email: cohng@oregonstate.edu
  • Stephanie A Schmidt
    Role: Other Researcher
    USDA Forest Service; 3200 SW Jefferson Way, Corvallis, Oregon, 97331
    Email: 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, 97331
    Email: hjaweb@lists.oregonstate.edu
  • Stephanie A Schmidt
    USDA Forest Service; 3200 SW Jefferson Way, Corvallis, Oregon, 97331
    Email: stephanie.schmidt@oregonstate.edu, stephanie.schmidt2@usda.gov
Publisher
  • Andrews Forest LTER Site
    Role: Publisher
    Forest Ecosystems and Society Department in Forestry, Oregon State University, 201K Richardson Hall, Corvallis, OR, 97331-5752
    Phone: (541) 737-8480
    Email: lterweb@lists.oregonstate.edu
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.20733900
    Altitude: 439 to 439 meter
  • Andrews Watershed 2 Gaging Station
    W -122.24487600, E -122.24487600, N 44.21201500, S 44.21201500
    Altitude: 545 to 545 meter
  • Andrews Watershed 3 Gaging Station
    W -122.24300000, E -122.24300000, N 44.21944000, S 44.21944000
    Altitude: 471 to 471 meter
  • Andrews Watershed 6 Gaging Station
    W -122.18070700, E -122.18070700, N 44.26150800, S 44.26150800
    Altitude: 878 to 878 meter
  • Andrews Watershed 7 Gaging Station
    W -122.17526500, E -122.17526500, N 44.26463700, S 44.26463700
    Altitude: 918 to 918 meter
  • Andrews Watershed 8 Gaging Station
    W -122.17079300, E -122.17079300, N 44.26629426, S 44.26629426
    Altitude: 962 to 962 meter
  • Andrews Watershed 10 Gaging Station
    W -122.26105600, E -122.26105600, N 44.21705700, S 44.21705700
    Altitude: 461 to 461 meter
  • Andrews Mack Creek Gaging Station
    W -122.16744700, E -122.16744700, N 44.21943621, S 44.21943621
    Altitude: 755 to 755 meter
  • Andrews Lookout Creek Gaging Station
    W -122.25714600, E -122.25714600, N 44.21012600, S 44.21012600
    Altitude: 422 to 422 meter
  • Lookout Creek upper thermograph site
    W -122.12162890, E -122.12162890, N 44.22478329, S 44.22478329
    Altitude: 998 to 998 meter
  • Mack Creek old-growth thermograph site
    W -122.16547369, E -122.16547369, N 44.21664907, S 44.21664907
    Altitude: 792 to 792 meter
  • McRae Creek upper thermograph site
    W -122.16757303, E -122.16757303, N 44.25638612, S 44.25638612
    Altitude: 840 to 840 meter
  • Quartz Creek (Blue River tributary) thermograph site
    W -122.30199700, E -122.30199700, N 44.19831900, S 44.19831900
    Altitude: 520 to 520 meter
  • Lookout and Mack Creek confluence thermograph site
    W -122.16802024, E -122.16802024, N 44.22756413, S 44.22756413
    Altitude: 674 to 674 meter
  • Lookout and McRae Creek confluence thermograph site
    W -122.20863436, E -122.20863436, N 44.23298992, S 44.23298992
    Altitude: 552 to 552 meter
  • Andrews Watershed 1
    W -122.25683100, E -122.23581300, N 44.20851700, S 44.19901700
    Altitude: 1027 to 1027 meter
  • Andrews Watershed 10
    W -122.25996600, E -122.25443900, N 44.22015200, S 44.21678600
    Altitude: 679 to 679 meter
  • Andrews Watershed 2
    W -122.24397600, E -122.22974100, N 44.21338500, S 44.20617800
    Altitude: 1079 to 1079 meter
  • Andrews Watershed 3
    W -122.24194900, E -122.22402200, N 44.21994300, S 44.20803100
    Altitude: 1080 to 1080 meter
  • Andrews Watershed 6
    W -122.18351000, E -122.17755000, N 44.26680800, S 44.26154400
    Altitude: 1029 to 1029 meter
  • Andrews Watershed 7
    W -122.17920900, E -122.17387500, N 44.26974800, S 44.26457900
    Altitude: 1102 to 1102 meter
  • Andrews Watershed 8
    W -122.17079300, E -122.17079300, N 44.26629400, S 44.26588100
    Altitude: 1182 to 1182 meter
  • Andrews Mack Creek Watershed
    W -122.17282200, E -122.12699600, N 44.22054300, S 44.20148000
    Altitude: 1626 to 1626 meter
  • Andrews Lookout Creek Watershed
    W -122.25879300, E -122.09952700, N 44.28226000, S 44.20127400
    Altitude: 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.19770400
    Altitude: 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

URL: https://creativecommons.org/licenses/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.