# Stream and air temperature data from stream network in the Andrews Experimental Forest, 1997-2001

## Dataset

- **Database Code:** HT002

- **Title:** Stream and air temperature data from stream network in the Andrews Experimental Forest, 1997-2001

- **Abstract:**

This study examines stream temperatures and associated air temperatures at multiple sites in stream networks within the Andrews Experimental Forest. Stream temperature sensors were placed at matched elevations in the main headwater streams of Lookout Creek, Mack Creek and McRae Creek as well as above and below major confluences in downstream reaches. Air temperatures were recorded 1.5 m above the stream at selected sites. Data were collected every half hour during late spring and summers. Some sites have data during fall and winter. Sensors were also placed in bottom of shallow piezometric wells in WS 3.


- **Keywords:** air temperature; water temperature; disturbance; aquatic ecosystems; disturbance

- **Temporal coverage:** 1997-05-21 to 2001-10-09

- **Principal Investigator:** Sherri L. Johnson


## Data Entities

1. HT00201

## Entity 1: HT00201

### Attribute list

- **DBCODE** — varchar, enum

Database Code

  - **HT002** — FSDB Database Code HT002


- **ENTITY** — numeric(1), range  1.0000  1.0000, number

Entity number


- **STREAM** — varchar, enum

Measurement stream

  - **LOOKOUT** — Lookout Creek
  - **MACKCR** — Mack Creek
  - **MCRAE** — McRae Creek
  - **WS01** — Andrews Watershed 1
  - **WS02** — Andrews Watershed 2
  - **WS03** — Andrews Watershed 3
  - **NOSTOC** — Nostoc Creek
  - **LONGER** — Longer Creek
  - **COLD** — Cold Creek


- **ELEVATION** — numeric(1.000000), range  425.0000  1250.0000, meters

Elevation of probe


- **MEDIA** — varchar, enum

Measurement media

  - **Air** — Air temperature
  - **Water** — Water temperature
  - **GW** — Ground water temperature
  - **Soil** — Soil temperature
  - **BW** — Back water temperature


- **SENSORID** — varchar, enum

Sensor Identification

  - **L1250** — Lookout Creek, elevation 1250m
  - **L1150** — Lookout Creek, above L704c, elevation 1150m
  - **L1075** — Lookout Creek, below L704a, elevation 1075m
  - **L975** — Upper Lookout creek, (TSLOOK) elevation 975m
  - **L950** — Lookout Creek, above Cold Creek, elevation 950m
  - **L940** — Lookout Creek, below Cold Creek, elevation 940m
  - **L800** — Lookout Creek, above Longer Creek, elevation 800m
  - **L775** — Lookout Creek, below Longer Creek, elevation 775m
  - **L680** — Lookout Creek, above old growth trail, elevation 680m
  - **L650** — Lookout creek at Lookout/Mack confluence (TSLOMA), 650m
  - **L640** — Lookout Creek, below Mack junction, elevation 640m
  - **L600** — Lookout Creek, down from road 330, elevation 600m
  - **L560** — Lookout Creek, above confluence with McCrae, elevation 560m
  - **L550** — Lookout Creek, below confluence with McCrae, elevation 550m
  - **L510** — Lookout Creek, elevation 510m
  - **L480** — Lookout Creek, gorge, elevation 480m
  - **L470** — Lookout Creek, gypsy camp, elevation 470m
  - **L460** — Lookout Creek, junction with WS3, elevation 460m
  - **L450** — Lookout Creek, junction with WS3, elevation 450m
  - **L425** — Lookout Creek gaging station, (GSLOOK), elevation 425m
  - **M1250** — Mack Creek, elevation 1250m
  - **M1125** — Mack Creek, elevation 1125m
  - **M1070** — Mack Creek, elevation 1070m
  - **M850** — Mack Creek, 1.3m above cabin, elevation 850m
  - **M780** — Mack Creek, above cabin, elevation 780m
  - **M750** — Mack Creek gaging station, (GSMACK), elevation 750m
  - **M720** — Mack Creek, below L110, elevation 720m
  - **M650** — Mack Creek at Lookout/Mack confluence (TSLOMA), 650m
  - **A825** — Watershed 1, elevation 825m
  - **A480** — Watershed 1, elevation 480m
  - **A470** — Watershed 1 Hydrolab site, elevation 470m
  - **A470S0** — Hydrolab site, right bank soil at 50cm depth, 470m
  - **A475** — Hydrolab site, left bank, elevation 475m
  - **A475S0** — Hydrolab site, left bank soil surface, elevation 475m
  - **A450** — Watershed 1 gage (GSWS01), elevation 450m
  - **B850** — Watershed 2, elevation 850m
  - **B750** — Watershed 2, elevation 750m
  - **B725** — Watershed 2, elevation 725m
  - **C900** — Watershed 3, spring, elevation 900m
  - **C780** — Watershed 3, above road 455, elevation 780m
  - **C600** — Watershed 3, upper bedrock, elevation 600m
  - **C570** — Watershed 3, deep pool within shade, elevation 570m
  - **C555** — Watershed 3, lower bedrock, elevation 555m
  - **C550** — Watershed 3, lower bedrock, elevation 550m
  - **C530** — Watershed 3, in wellfield, elevation 530m
  - **C500** — Watershed 3, below jam and above gage, elevation 500m
  - **C490** — Watershed 3 gage (GSWS03), elevation 490m
  - **LT990** — Cold Creek tributary meets Lookout Creek, elevation 990m
  - **LT830** — Longer Creek tributary meets Lookout Creek, 830m
  - **LT660** — Nostoc Creek tributary meets Lookout Ck. 660m, east of 350rd
  - **LT610** — Nostoc Creek tributary meets Lookout Ck. 610m, east of 350rd
  - **R1250** — McRae Creek, above 359 rd, elevation 1250m
  - **R1150** — McRae Creek, below L381, elevation 1150m
  - **R1075** — McRae Creek, oldgrowth, elevation 1075m
  - **R850** — McRae Creek, (TSMCRA) elevation 850m
  - **R725** — McRae Creek, above L602, elevation 725m
  - **R650** — McRae Creek, above debris flow, elevation 650m
  - **R625** — McRae Creek, below debris flow, elevation 625m
  - **R590** — McRae Creek, above bridge 1506, elevation 590m
  - **R560** — McRae Creek, wondzell site, elevation 590m
  - **R550** — McRae Creek, above junction with Lookout, elevation 550m
  - **LGB525** — Lookout gravel bar below cc bridge, elevation 525m
  - **LGB525a** — Below concrete (cc) bridge, sensor a
  - **LGB525b** — Below concrete (cc) bridge , sensor b
  - **LGB525c** — Pond below concrete (cc) bridge, sensor c
  - **LGB525d** — Upwelling willows, below concrete (cc) bridge, sensor d
  - **LGB525e** — Downstream end of 2ary channel, below cc bridge, sensor e
  - **LGB525f** — Before secondary channel enters, below cc bridge, sensor f
  - **C560** — Watershed 3, elevation 560m
  - **C560F4** — Watershed 3, well F4, elevation 560m
  - **C560F5** — Watershed 3, well F5, elevation 560m
  - **C560F6** — Watershed 3, well F6, elevation 560m
  - **C550E4** — Watershed 3, well E4, elevation 550m
  - **C550E5** — Watershed 3, well E5, elevation 550m
  - **C550E6** — Watershed 3, well E6, elevation 550m
  - **C540** — Watershed 3, elevation 540m
  - **C540D3** — Watershed 3, well D3, elevation 540m
  - **C540D4** — Watershed 3, well D4, elevation 540m
  - **C540D6** — Watershed 3, well D6, elevation 540m
  - **C530G5** — Watershed 3, well G5, elevation 530m
  - **C530SOD6** — Watershed 3, at 10cm depth near well D6, elevation 530m
  - **L544** — Lookout creek at Lookout-McRae junction, elevation 544m
  - **L545** — Lookout-McRae junction, elevation 545m
  - **L550-36** — Lookout creek in well 36, elevation 550m
  - **L550-37** — Lookout creek in well 37, elevation 550m
  - **L550-38** — Lookout creek in well 38, elevation 550m
  - **L550-6** — Lookout creek in well 6, elevation 550m
  - **L550-39** — Lookout creek in well 39, elevation 550m
  - **L550-27** — Lookout creek in well 27, elevation 550m
  - **L550-5** — Lookout creek in well 5, elevation 550m
  - **L550-13** — Lookout creek in well 13, elevation 550m
  - **L550-16** — Lookout creek in well 16, elevation 550m


- **DATE_TIME** — datetime, freetext

Date and time of probe reading


- **TEMP_C** — numeric(0.100000), range  -15.1000  38.3300, degrees Celsius

Temperature


- **SERIAL_NUMBER** — varchar, freetext

Probe serial number


## Attribute Definitions

**DATE_TIME**

Date and time of probe reading


**DBCODE**

Database Code


**ELEVATION**

Elevation of probe


**ENTITY**

Entity number


**MEDIA**

Measurement media


**SENSORID**

Sensor Identification


**SERIAL_NUMBER**

Probe serial number


**STREAM**

Measurement stream


**TEMP_C**

Temperature


## Enumerated Domains

### DBCODE

- **HT002** — FSDB Database Code HT002

### STREAM

- **LOOKOUT** — Lookout Creek

- **MACKCR** — Mack Creek

- **MCRAE** — McRae Creek

- **WS01** — Andrews Watershed 1

- **WS02** — Andrews Watershed 2

- **WS03** — Andrews Watershed 3

- **NOSTOC** — Nostoc Creek

- **LONGER** — Longer Creek

- **COLD** — Cold Creek

### MEDIA

- **Air** — Air temperature

- **Water** — Water temperature

- **GW** — Ground water temperature

- **Soil** — Soil temperature

- **BW** — Back water temperature

### SENSORID

- **L1250** — Lookout Creek, elevation 1250m

- **L1150** — Lookout Creek, above L704c, elevation 1150m

- **L1075** — Lookout Creek, below L704a, elevation 1075m

- **L975** — Upper Lookout creek, (TSLOOK) elevation 975m

- **L950** — Lookout Creek, above Cold Creek, elevation 950m

- **L940** — Lookout Creek, below Cold Creek, elevation 940m

- **L800** — Lookout Creek, above Longer Creek, elevation 800m

- **L775** — Lookout Creek, below Longer Creek, elevation 775m

- **L680** — Lookout Creek, above old growth trail, elevation 680m

- **L650** — Lookout creek at Lookout/Mack confluence (TSLOMA), 650m

- **L640** — Lookout Creek, below Mack junction, elevation 640m

- **L600** — Lookout Creek, down from road 330, elevation 600m

- **L560** — Lookout Creek, above confluence with McCrae, elevation 560m

- **L550** — Lookout Creek, below confluence with McCrae, elevation 550m

- **L510** — Lookout Creek, elevation 510m

- **L480** — Lookout Creek, gorge, elevation 480m

- **L470** — Lookout Creek, gypsy camp, elevation 470m

- **L460** — Lookout Creek, junction with WS3, elevation 460m

- **L450** — Lookout Creek, junction with WS3, elevation 450m

- **L425** — Lookout Creek gaging station, (GSLOOK), elevation 425m

- **M1250** — Mack Creek, elevation 1250m

- **M1125** — Mack Creek, elevation 1125m

- **M1070** — Mack Creek, elevation 1070m

- **M850** — Mack Creek, 1.3m above cabin, elevation 850m

- **M780** — Mack Creek, above cabin, elevation 780m

- **M750** — Mack Creek gaging station, (GSMACK), elevation 750m

- **M720** — Mack Creek, below L110, elevation 720m

- **M650** — Mack Creek at Lookout/Mack confluence (TSLOMA), 650m

- **A825** — Watershed 1, elevation 825m

- **A480** — Watershed 1, elevation 480m

- **A470** — Watershed 1 Hydrolab site, elevation 470m

- **A470S0** — Hydrolab site, right bank soil at 50cm depth, 470m

- **A475** — Hydrolab site, left bank, elevation 475m

- **A475S0** — Hydrolab site, left bank soil surface, elevation 475m

- **A450** — Watershed 1 gage (GSWS01), elevation 450m

- **B850** — Watershed 2, elevation 850m

- **B750** — Watershed 2, elevation 750m

- **B725** — Watershed 2, elevation 725m

- **C900** — Watershed 3, spring, elevation 900m

- **C780** — Watershed 3, above road 455, elevation 780m

- **C600** — Watershed 3, upper bedrock, elevation 600m

- **C570** — Watershed 3, deep pool within shade, elevation 570m

- **C555** — Watershed 3, lower bedrock, elevation 555m

- **C550** — Watershed 3, lower bedrock, elevation 550m

- **C530** — Watershed 3, in wellfield, elevation 530m

- **C500** — Watershed 3, below jam and above gage, elevation 500m

- **C490** — Watershed 3 gage (GSWS03), elevation 490m

- **LT990** — Cold Creek tributary meets Lookout Creek, elevation 990m

- **LT830** — Longer Creek tributary meets Lookout Creek, 830m

- **LT660** — Nostoc Creek tributary meets Lookout Ck. 660m, east of 350rd

- **LT610** — Nostoc Creek tributary meets Lookout Ck. 610m, east of 350rd

- **R1250** — McRae Creek, above 359 rd, elevation 1250m

- **R1150** — McRae Creek, below L381, elevation 1150m

- **R1075** — McRae Creek, oldgrowth, elevation 1075m

- **R850** — McRae Creek, (TSMCRA) elevation 850m

- **R725** — McRae Creek, above L602, elevation 725m

- **R650** — McRae Creek, above debris flow, elevation 650m

- **R625** — McRae Creek, below debris flow, elevation 625m

- **R590** — McRae Creek, above bridge 1506, elevation 590m

- **R560** — McRae Creek, wondzell site, elevation 590m

- **R550** — McRae Creek, above junction with Lookout, elevation 550m

- **LGB525** — Lookout gravel bar below cc bridge, elevation 525m

- **LGB525a** — Below concrete (cc) bridge, sensor a

- **LGB525b** — Below concrete (cc) bridge , sensor b

- **LGB525c** — Pond below concrete (cc) bridge, sensor c

- **LGB525d** — Upwelling willows, below concrete (cc) bridge, sensor d

- **LGB525e** — Downstream end of 2ary channel, below cc bridge, sensor e

- **LGB525f** — Before secondary channel enters, below cc bridge, sensor f

- **C560** — Watershed 3, elevation 560m

- **C560F4** — Watershed 3, well F4, elevation 560m

- **C560F5** — Watershed 3, well F5, elevation 560m

- **C560F6** — Watershed 3, well F6, elevation 560m

- **C550E4** — Watershed 3, well E4, elevation 550m

- **C550E5** — Watershed 3, well E5, elevation 550m

- **C550E6** — Watershed 3, well E6, elevation 550m

- **C540** — Watershed 3, elevation 540m

- **C540D3** — Watershed 3, well D3, elevation 540m

- **C540D4** — Watershed 3, well D4, elevation 540m

- **C540D6** — Watershed 3, well D6, elevation 540m

- **C530G5** — Watershed 3, well G5, elevation 530m

- **C530SOD6** — Watershed 3, at 10cm depth near well D6, elevation 530m

- **L544** — Lookout creek at Lookout-McRae junction, elevation 544m

- **L545** — Lookout-McRae junction, elevation 545m

- **L550-36** — Lookout creek in well 36, elevation 550m

- **L550-37** — Lookout creek in well 37, elevation 550m

- **L550-38** — Lookout creek in well 38, elevation 550m

- **L550-6** — Lookout creek in well 6, elevation 550m

- **L550-39** — Lookout creek in well 39, elevation 550m

- **L550-27** — Lookout creek in well 27, elevation 550m

- **L550-5** — Lookout creek in well 5, elevation 550m

- **L550-13** — Lookout creek in well 13, elevation 550m

- **L550-16** — Lookout creek in well 16, elevation 550m