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

CF012: Stream specific conductance and temperature from small watersheds in the Andrews Forest

← Back to catalog index

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

Status: annually
Period: 1000-01-01 to 1000-01-01
Version: 5
Published: 1000-01-01
EDI Package ID: knb-lter-and.5357.5
Source XML: CF012_5.xml

Notice

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

Citation

Johnson, S.; Henshaw, D.; Kennedy, A.; Remillard, S. 1000. Stream specific conductance and temperature from small watersheds in the Andrews Forest Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/CF012 Accessed 2026-05-10.

Abstract

Stream specific conductance and water temperature are measured instantaneously every 5 minutes at most of the gauged watersheds within the H.J. Andrews Experimental Forest (Watersheds 1, 2, 3, 6, 7, 8, 10 and Mack Creek). Data is complementary to stream chemistry measurements from a proportional sampler (CF002) and long-term streamflow measurements (HF004) made at each of these watersheds.

Coverage

Temporal coverage: 1000-01-01 to 1000-01-01

Geographic coverage: H.J. Andrews Experimental Forest

Spatial coverage:

Bounds: W -122.26105600, E -122.16744700, N 44.26629426, S 44.20733900

Purpose

No purpose entries listed in this EML file.

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
  • 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
  • Catalina Segura
    Role: Other Researcher
    Assistant Professor; Department of Forest Engineering, Resources, and Management; Oregon State University, Corvallis, OR, 97331
    Phone: 541-737-6568
    Email: catalina.segura@oregonstate.edu
  • Benjamin E. Nash
    Role: Other Researcher
    Email: benjamin.nash@usda.gov
  • Don Henshaw
    Role: Former Investigator
    Email: donny.henshaw@gmail.com
  • Greg Downing
    Role: Former Investigator
    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
  • 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
  • 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
  • Donald L. Henshaw
    Role: Creator
    Pacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, Oregon, 97331
    Email: hja_admin@lists.oregonstate.edu
  • Adam M Kennedy
    Role: Creator
    OR, US
    Phone: 541-822-6302
    Email: adam.kennedy@oregonstate.edu
  • Suzanne M. Remillard
    Role: Creator
    Office: FSL 354;; Forest Science Department;; Oregon State University, Corvallis, OR, 97331, USA
    Phone: (541) 758-8767
    Email: suzanne.remillard@oregonstate.edu
Contact
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 specific conductance and water temperature are measured instantaneously every 5 minutes at most of the gauged watersheds within the H.J. Andrews Experimental Forest (Watersheds 1, 2, 3, 6, 7, 8, 10 and Mack Creek). Data is complementary to stream chemistry measurements from a proportional sampler (CF002) and long-term streamflow measurements (HF004) made at each of these watersheds. Field Methods - CF012

Methods

Method Steps

Field Methods - CF012
  • Specific conductance is measured with a Campbell Scientific CS547A electrical conductivity and temperature probe connected to a Campbell Scientific data logger. The sensor is installed in a small pool just upstream, downstream or directly across from the flume / gage house depending on the site. Instantaneous measurements of specific conductance and water temperature are made every 5 minutes. During periodic (approximately every 6 to 9 weeks) field visits, independent check measurements are made using a portable YSI Pro30 as of August 2015 and previously a YSI 30 conductivity meter. Should the CS547A measurement differ from the YSI measurement, the temperature coefficient used in calculating conductance is modified in the data logger program in the field to better match the CS547A output with the YSI check measurement. In the early years of operation the cell constant was modified to better match these values, but that is no longer done. Additionally, the probes are regularly brushed during field visits to improve operation.

Instrumentation:

  • A Campbell Scientific CS547A electrical conductivity and temperature probe connected to a Campbell Scientific data logger is used in conjunction with a portable YSI Pro30 conductivity meter.

Sampling

Study Extent
  • Continuous streamflow data have been collected over varying periods of record in eight first to second-order watersheds, one third-order watershed, and the fifth-order watershed in the H. J. Andrews. Watersheds 1, 2, and 3 comprise a low-elevation (442 m to 1082 m) set of experimental basins with Watershed 2 serving as the control. Watersheds 6, 7, and 8 comprise a high-elevation (863 m to 1190 m) set of experimental basins with Watershed 8 as the control. Watersheds 9 and 10 are a low-elevation pair of small watersheds with Watershed 9 as the control. Mack Creek is a control basin and has not been harvested. The gauged portion of 5th-order Lookout Creek comprises nearly all of the Andrews Forest.
  • Sampling frequency: 5 minutes
Sampling Description
  • Specific conductance is measured in conjunction with the small watershed studies which also collect proportional streamflow samples, measure streamflow, and measure air and water temperature at the gauging stations.
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 Experimental Forest (HJA)
    W -122.26172200, E -122.10084700, N 44.28196400, S 44.19770400
    Altitude: 1631 to 1631 meter
  • Andrews Watershed 1
    W -122.25683100, E -122.23581300, N 44.20851700, S 44.19901700
    Altitude: 1027 to 1027 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 Watershed 10
    W -122.25996600, E -122.25443900, N 44.22015200, S 44.21678600
    Altitude: 679 to 679 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 Gaging Station
    W -122.25714600, E -122.25714600, N 44.21012600, S 44.21012600
    Altitude: 422 to 422 meter
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: hydrology (theme), water chemistry (theme), electrical conductivity (theme), specific conductivity (theme), water temperature (theme), watersheds (theme), aquatic ecosystems (theme)
  • Andrews Experimental Forest site thesaurus: long term studies (theme)
Taxonomic Hierarchy

No taxonomic hierarchy listed in this EML file.

Data Entities
# Entity Metadata Data
1 CF01201
Specific conductance (electrical conductivity) (5 minute resolution)
 METADATA DATA
2 CF01202
Specific conductance (electrical conductivity) (manual checks)
 METADATA DATA
3 CF01251
Stream water temperature (5 minute resolution)
 METADATA DATA
Metadata
CF01201 - Specific conductance (electrical conductivity) (5 minute resolution)

Object name: CF01201_v4.txt

Records: 11399875

Attributes: 10

Temporal coverage: 1000-01-01 to 1000-01-01

File size: 832142859 byte

Checksum (MD5): 5381bcc36acb7190f2786452b6a8d1f4

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

Constraints (2)
  • primaryKey: PRIMARY
    CF01201.PROBE_CODE, CF01201.DATE_TIME
  • notNullConstraint: NOTNULL
    CF01201.DBCODE, CF01201.ENTITY, CF01201.SITECODE, CF01201.EC_METHOD, CF01201.QC_LEVEL, CF01201.PROBE_CODE, CF01201.DATE_TIME, CF01201.EC_INST_FLAG, CF01201.EVENT_CODE
Attributes (10)
DBCODE - char(5) (nominal)

ID: CF01201.DBCODE

FSDB database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • CF012
    FSDB Database Code
ENTITY - numeric(2,0) (interval)

ID: CF01201.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1

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

SITECODE - char(6) (nominal)

ID: CF01201.SITECODE

Sitecode for the gauging station

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • 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
EC_METHOD - char(6) (nominal)

ID: CF01201.EC_METHOD

General method and instrumentation used to collect specific conductivity and water temperature

Type system: Microsoft SQL Server 2019

Code definitions (3)
  • ECD001
    Specific conductance is measured with Campbell Scientific CS547A electrical conductivity and temperature probe installed in pool upstream of flume every 5 minutes; a temperature coefficient is modified to correct reading based on manual check
  • ECD002
    Specific conductance is verified with independent checks during periodic (approximately every 6 to 9 weeks) field visits using a YSI 30 conductivity meter
  • ECD003
    Specific conductance is verified with independent checks during periodic (approximately every 6 to 9 weeks) field visits using a YSI pro30 conductivity meter
QC_LEVEL - char(2) (nominal)

ID: CF01201.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: CF01201.PROBE_CODE

Probe number code indicates the measurement type, site, and sensor number, e.g., ECDGS101

Type system: Microsoft SQL Server 2019

Code definitions (27)
  • 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
  • WATGS802
    Stream temperature at GSWS08, probe no. 02, upstream of flume
  • ECDGS001
    Specific conductance (electrical conductivity) at GSWS10, probe number 01
  • ECDGS101
    Specific conductance (electrical conductivity) at GSWS01, probe number 01
  • ECDGS201
    Specific conductance (electrical conductivity) at GSWS02, probe number 01
  • ECDGS301
    Specific conductance (electrical conductivity) at GSWS03, probe number 01
  • ECDGS601
    Specific conductance (electrical conductivity) at GSWS06, probe number 01
  • ECDGS701
    Specific conductance (electrical conductivity) at GSWS07, probe number 01
  • ECDGS802
    Specific conductance (electrical conductivity) at GSWS08, probe number 02
  • ECDGSM01
    Specific conductance (electrical conductivity) at GSMACK, probe number 01
  • WATGSL03
    Stream temperature at GSLOOK, probe no. 03, established 2016 at the Lookout Creek gauging station
  • ECDGSL03
    Specific conductance (electrical conductivity) at GSLOOK, probe number 03
  • ECDGS002
    Specific conductance (electrical conductivity) at GSWS10, probe number 02
  • ECDGS102
    Specific conductance (electrical conductivity) at GSWS01, probe number 02
  • ECDGS202
    Specific conductance (electrical conductivity) at GSWS02, probe number 02
  • ECDGS302
    Specific conductance (electrical conductivity) at GSWS03, probe number 02
  • ECDGS602
    Specific conductance (electrical conductivity) at GSWS06, probe number 02
  • ECDGS702
    Specific conductance (electrical conductivity) at GSWS07, probe number 02
  • ECDGS803
    Specific conductance (electrical conductivity) at GSWS08, probe number 03
  • ECDGSM02
    Specific conductance (electrical conductivity) at GSMACK, probe number 02
  • ECDGSL04
    Specific conductance (electrical conductivity) at GSLOOK, probe number 04
DATE_TIME - datetime (dateTime)

ID: CF01201.DATE_TIME

Date and time in Pacific Standard Time (PST) of sensor reading

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD hh:mm:ss

EC_INST - numeric(5,1) (ratio)

ID: CF01201.EC_INST

Instantaneous specific conductance (electrical conductivity) measurement

Type system: Microsoft SQL Server 2019

Unit: micro siemens per centimeter

Precision: 2.000000

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

EC_INST_FLAG - char(1) (nominal)

ID: CF01201.EC_INST_FLAG

Instantaneous specific conductance measurement 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
  • E
    Estimated value
  • M
    Missing value
  • Q
    Questionable value
  • T
    Tracer experiment is underway and electrical conductivity measurements are affected
  • P
    Fire effects are visible in the data
  • I
    Implausible value
EVENT_CODE - char(6) (nominal)

ID: CF01201.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 (10)
  • 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 maintenence event has occurred
  • METHOD
    Change in data collection method
  • NA
    No event is reported (not applicable)
  • QUALTY
    Event may directly affect data qualty
  • WEATHR
    A weather event has occurred that may affect reading
  • BRUSHD
    Sensor is brushed for cleaning to improve measurement accuracy
  • BURNED
    Burning, including cleared trees and brush or wildfire, around the meteorological station or within the watershed (code begins at event initiation)
CF01202 - Specific conductance (electrical conductivity) (manual checks)

Object name: CF01202_v1.csv

Records: 692

Attributes: 10

Temporal coverage: 1000-01-01 to 1000-01-01

File size: 50604 byte

Checksum (MD5): 8ace2fa58868fe1274103fdd3efcb43a

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

Constraints (2)
  • primaryKey: PRIMARY
    CF01202.PROBE_CODE, CF01202.DATE_TIME
  • notNullConstraint: NOTNULL
    CF01202.DBCODE, CF01202.ENTITY, CF01202.SITECODE, CF01202.EC_METHOD, CF01202.QC_LEVEL, CF01202.PROBE_CODE, CF01202.DATE_TIME, CF01202.EC_INST_FLAG, CF01202.EVENT_CODE
Attributes (10)
DBCODE - char(5) (nominal)

ID: CF01202.DBCODE

FSDB database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • CF012
    FSDB Database Code
ENTITY - numeric(2,0) (interval)

ID: CF01202.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1

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

SITECODE - char(6) (nominal)

ID: CF01202.SITECODE

Sitecode for the gauging station

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • 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
EC_METHOD - char(6) (nominal)

ID: CF01202.EC_METHOD

General method and instrumentation used to collect specific conductivity and water temperature

Type system: Microsoft SQL Server 2019

Code definitions (3)
  • ECD001
    Specific conductance is measured with Campbell Scientific CS547A electrical conductivity and temperature probe installed in pool upstream of flume every 5 minutes; a temperature coefficient is modified to correct reading based on manual check
  • ECD002
    Specific conductance is verified with independent checks during periodic (approximately every 6 to 9 weeks) field visits using a YSI 30 conductivity meter
  • ECD003
    Specific conductance is verified with independent checks during periodic (approximately every 6 to 9 weeks) field visits using a YSI pro30 conductivity meter
QC_LEVEL - char(2) (nominal)

ID: CF01202.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: CF01202.PROBE_CODE

Probe number code indicates the measurement type, site, and sensor number, e.g., ECDGS101

Type system: Microsoft SQL Server 2019

Code definitions (27)
  • 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
  • WATGS802
    Stream temperature at GSWS08, probe no. 02, upstream of flume
  • ECDGS001
    Specific conductance (electrical conductivity) at GSWS10, probe number 01
  • ECDGS101
    Specific conductance (electrical conductivity) at GSWS01, probe number 01
  • ECDGS201
    Specific conductance (electrical conductivity) at GSWS02, probe number 01
  • ECDGS301
    Specific conductance (electrical conductivity) at GSWS03, probe number 01
  • ECDGS601
    Specific conductance (electrical conductivity) at GSWS06, probe number 01
  • ECDGS701
    Specific conductance (electrical conductivity) at GSWS07, probe number 01
  • ECDGS802
    Specific conductance (electrical conductivity) at GSWS08, probe number 02
  • ECDGSM01
    Specific conductance (electrical conductivity) at GSMACK, probe number 01
  • WATGSL03
    Stream temperature at GSLOOK, probe no. 03, established 2016 at the Lookout Creek gauging station
  • ECDGSL03
    Specific conductance (electrical conductivity) at GSLOOK, probe number 03
  • ECDGS002
    Specific conductance (electrical conductivity) at GSWS10, probe number 02
  • ECDGS102
    Specific conductance (electrical conductivity) at GSWS01, probe number 02
  • ECDGS202
    Specific conductance (electrical conductivity) at GSWS02, probe number 02
  • ECDGS302
    Specific conductance (electrical conductivity) at GSWS03, probe number 02
  • ECDGS602
    Specific conductance (electrical conductivity) at GSWS06, probe number 02
  • ECDGS702
    Specific conductance (electrical conductivity) at GSWS07, probe number 02
  • ECDGS803
    Specific conductance (electrical conductivity) at GSWS08, probe number 03
  • ECDGSM02
    Specific conductance (electrical conductivity) at GSMACK, probe number 02
  • ECDGSL04
    Specific conductance (electrical conductivity) at GSLOOK, probe number 04
DATE_TIME - datetime (dateTime)

ID: CF01202.DATE_TIME

Date and time in Pacific Standard Time (PST) of sensor reading

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD hh:mm:ss

EC_INST - numeric(5,1) (ratio)

ID: CF01202.EC_INST

Instantaneous specific conductance (electrical conductivity) measurement

Type system: Microsoft SQL Server 2019

Unit: micro siemens per centimeter

Precision: 2.000000

Numeric domain: type=real, min=21.2000 (exclusive=false), max=93.1000 (exclusive=false)

EC_INST_FLAG - char(1) (nominal)

ID: CF01202.EC_INST_FLAG

Instantaneous specific conductance measurement 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
  • E
    Estimated value
  • M
    Missing value
  • Q
    Questionable value
  • T
    Tracer experiment is underway and electrical conductivity measurements are affected
  • P
    Fire effects are visible in the data
  • I
    Implausible value
EVENT_CODE - char(6) (nominal)

ID: CF01202.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 (10)
  • 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 maintenence event has occurred
  • METHOD
    Change in data collection method
  • NA
    No event is reported (not applicable)
  • QUALTY
    Event may directly affect data qualty
  • WEATHR
    A weather event has occurred that may affect reading
  • BRUSHD
    Sensor is brushed for cleaning to improve measurement accuracy
  • BURNED
    Burning, including cleared trees and brush or wildfire, around the meteorological station or within the watershed (code begins at event initiation)
CF01251 - Stream water temperature (5 minute resolution)

Object name: CF01251_v1.txt

Records: 11399875

Attributes: 10

Temporal coverage: 1000-01-01 to 1000-01-01

File size: 829309333 byte

Checksum (MD5): be907e4606b0d66e887a7eeb5315e2d7

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

Constraints (2)
  • primaryKey: PRIMARY
    CF01251.PROBE_CODE
  • notNullConstraint: NOTNULL
    CF01251.ENTITY, CF01251.SITECODE, CF01251.QC_LEVEL, CF01251.PROBE_CODE, CF01251.WATERTEMP_INST_FLAG, CF01251.EVENT_CODE, CF01251.WATERTEMP_METHOD
Attributes (10)
DBCODE - char(5) (nominal)

ID: CF01251.DBCODE

FSDB database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • CF012
    FSDB Database Code
ENTITY - numeric(2,0) (interval)

ID: CF01251.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1

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

SITECODE - char(6) (nominal)

ID: CF01251.SITECODE

Sitecode for the gauging station

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • 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
WATERTEMP_METHOD - char(6) (nominal)

ID: CF01251.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 (2)
  • 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, inst 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 and instantaneous temperature is output every 15 minutes
QC_LEVEL - char(2) (nominal)

ID: CF01251.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: CF01251.PROBE_CODE

Probe number code indicates the measurement type, site, and sensor number, e.g., ECDGS101

Type system: Microsoft SQL Server 2019

Code definitions (27)
  • 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
  • WATGS802
    Stream temperature at GSWS08, probe no. 02, upstream of flume
  • ECDGS001
    Specific conductance (electrical conductivity) at GSWS10, probe number 01
  • ECDGS101
    Specific conductance (electrical conductivity) at GSWS01, probe number 01
  • ECDGS201
    Specific conductance (electrical conductivity) at GSWS02, probe number 01
  • ECDGS301
    Specific conductance (electrical conductivity) at GSWS03, probe number 01
  • ECDGS601
    Specific conductance (electrical conductivity) at GSWS06, probe number 01
  • ECDGS701
    Specific conductance (electrical conductivity) at GSWS07, probe number 01
  • ECDGS802
    Specific conductance (electrical conductivity) at GSWS08, probe number 02
  • ECDGSM01
    Specific conductance (electrical conductivity) at GSMACK, probe number 01
  • WATGSL03
    Stream temperature at GSLOOK, probe no. 03, established 2016 at the Lookout Creek gauging station
  • ECDGSL03
    Specific conductance (electrical conductivity) at GSLOOK, probe number 03
  • ECDGS002
    Specific conductance (electrical conductivity) at GSWS10, probe number 02
  • ECDGS102
    Specific conductance (electrical conductivity) at GSWS01, probe number 02
  • ECDGS202
    Specific conductance (electrical conductivity) at GSWS02, probe number 02
  • ECDGS302
    Specific conductance (electrical conductivity) at GSWS03, probe number 02
  • ECDGS602
    Specific conductance (electrical conductivity) at GSWS06, probe number 02
  • ECDGS702
    Specific conductance (electrical conductivity) at GSWS07, probe number 02
  • ECDGS803
    Specific conductance (electrical conductivity) at GSWS08, probe number 03
  • ECDGSM02
    Specific conductance (electrical conductivity) at GSMACK, probe number 02
  • ECDGSL04
    Specific conductance (electrical conductivity) at GSLOOK, probe number 04
DATE_TIME - datetime (dateTime)

ID: CF01251.DATE_TIME

Date and time in Pacific Standard Time (PST) of sensor reading

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD hh:mm:ss

WATERTEMP_INST - numeric(5,1) (ratio)

ID: CF01251.WATERTEMP_INST

Instantaneous water temperature measurement

Type system: Microsoft SQL Server 2019

Unit: degrees Celsius

Precision: 0.400000

Numeric domain: type=real, min=-0.1000 (exclusive=false), max=25.9000 (exclusive=false)

WATERTEMP_INST_FLAG - char(1) (nominal)

ID: CF01251.WATERTEMP_INST_FLAG

Instantaneous water temperature measurement flag

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • A
    Accepted value has passed all QC tests applied as represented by the quality level
  • E
    Estimated value
  • Q
    Questionable value
  • M
    Missing value
  • P
    Fire effects are visible in the data
EVENT_CODE - char(6) (nominal)

ID: CF01251.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 (10)
  • 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 maintenence event has occurred
  • METHOD
    Change in data collection method
  • NA
    No event is reported (not applicable)
  • QUALTY
    Event may directly affect data qualty
  • WEATHR
    A weather event has occurred that may affect reading
  • BRUSHD
    Sensor is brushed for cleaning to improve measurement accuracy
  • BURNED
    Burning, including cleared trees and brush or wildfire, around the meteorological station or within the watershed (code begins at event initiation)
Units
micro siemens per centimeter uS/cm specific conductance microSiemenPerCentimeter siemenPerMeter .0001 micro Siemens per centimeter
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
Related Datasets
Related Publications
  • Mosquera, Giovanny M.; Segura, Catalina; Crespo, Patricio. 2018. Flow Partitioning Modelling Using High-Resolution Isotopic and Electrical Conductivity Data. Water. 10(7),904: 1-23. doi: 10.3390/w10070904
Related Files
Intellectual Rights

Data Use Agreement:

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

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

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

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

Licensed

License: Creative Commons Attribution 4.0 International Public License

Identifier: CC-BY-4.0

URL: https://creativecommons.org/licenses/by/4.0/

Maintenance

Maintenance update frequency: annually

Description

  • An update history is logged and maintained with each new version of every dataset.

Change History

  • Version1 (1000-01-01)
    Study code and preliminary metadata established
  • Version2 (1000-01-01)
    Data is prepared for first -time online access. Data originates in 2011 for WS 1 and in 2012 for WS 2,3,6,7,8,10 and Mack Creek. Data is quality controlled and put online through at least April 2015 for all watersheds.
  • Version3 (1000-01-01)
    Entity 1 is updated from September 2015 through March 2016.
  • Version4 (1000-01-01)
    Entity 1 is updated for April 2016 through Sep 2019. The GSLOOK sensor data is added. Event codes are edited for the entire record starting in 2011 by merging event codes from the Notes data table and adding a specific brushing code. Additionally, the "sys" files were used to capture site visits (event_code='MAINTE') and brushing events (event_code='BRUSHD') for all sites starting in WY 2019 except for Lookout Creek.
  • Version5 (1000-01-01)
    Update: September 2019 through September 2024. Data processed using FastBridge and GenQ for the first time. Entity 01 contains SpC 5-minute readings with no corrections made; Q flags were used extensively to expedite publishing. Entity 02 contains a partial record of SpC manual periodic checks; the complete historical record can be back-filled as time permits. Entity 51 contains instantaneous water temperature readings for back-calculating SpC to conductivity, using the same method and probe code as WATERTEMP_MEAN in HT00451.