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

AN008: Stream Consumers and Lotic Ecosystem Rates (SCALER) in streams of the HJ Andrews Experimental Forest, 2014-2016

← Back to catalog index

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

Status: notPlanned
Period: 2014-08-14 to 2016-08-17
Version: 2
Published: 2020-04-28
EDI Package ID: knb-lter-and.5485.2
Source XML: AN008_2.xml

Notice

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

Citation

Argerich, A.; Penaluna, B. 2020. Stream Consumers and Lotic Ecosystem Rates (SCALER) in streams of the HJ Andrews Experimental Forest, 2014-2016 Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/AN008 Accessed 2026-05-10.

Abstract

SCALER attempts to address the question of whether small-scale ecological experiments can be applied to understand the behavior of entire ecological systems. Specifically, the role of comsumers to stream functional processes were examined by measurements of structure and function within stream reaches. These results feed into a broader continent wide examination within a variety of ecological systems. Rates of stream metabolism (photosynthesis and respiration) and nutrient uptake were measured, as well as the way these rates respond to animal exclusions (used to mimic loss of animal diversity in streams). Aquatic food web and biogeochemical responses in three consecutive 75m stream reaches were measured by manipulating densities of fish and amphibians (natural, depletion, and addition). Additionally, various stream characteristics were measured including streamflow, water chemistry, nutrients, metabolism, stream habitat measurements (wetted widths, depths and substrate), and canopy conditions (percent shade). The experiment was carried out every summer between 2014-2016 in streams of the HJ Andrews Experimental Forest to capture interannual variability.

Coverage

Temporal coverage: 2014-08-14 to 2016-08-17

Geographic coverage: Streams at H.J. Andrews Experimental Forest, Western Cascades, Oregon

Spatial coverage:

Bounds: W -122.20549300, E -122.16756900, N 44.25709700, S 44.22253500

Purpose
  • We set out to understand whether small scale ecological experiments can be applied to understand structure and function of stream reaches by understanding the role of consumers to stream functional processes. These local results will be linked to the scale of watersheds and regions by modeling.
Project

Title: Long-Term Ecological Research

Personnel
  • Sherri L. Johnson - Principal Investigator
    US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: 541-758-7771
    Email: sherri.johnson2@usda.gov, sherri.johnson@oregonstate.edu
  • Julia A. Jones - Principal Investigator
    Oregon State University;Department of Geosciences; Wilkinson Hall 104, Corvallis, OR, 97331-5506, USA
    Phone: (541) 737-1224
    Email: Julia.Jones@oregonstate.edu, geojulia@comcast.net
    ORCID: http://orcid.org/0000-0001-9429-8925
  • Matthew G Betts - Principal Investigator
    Department of Forest Ecosystems and Society; 201E Richardson Hall; College of Forestry; Oregon State University, Corvallis, OR, 97331
    Phone: (541) 737-3841
    Email: matt.betts@oregonstate.edu
  • Michael P. Nelson - Principal Investigator
    Department of Forest Ecosystems and Society; 201K Richarson Hall; College of Forestry; Oregon State University, Corvallis, OR, 97331
    Phone: 541-737-9221
    Email: mpnelson@oregonstate.edu
    ORCID: http://orcid.org/0000-0001-6917-4752
  • David Bell - Principal Investigator
    Email: david.bell@usda.gov, david.bell@oregonstate.edu
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: DEB1440409

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
Contact
  • Information Manager
    Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331
    Email: hjaweb@fsl.orst.edu
Publisher
  • Andrews Forest LTER Site
    Role: Publisher
    Forest Ecosystems and Society Department in Forestry, Oregon State University, 201K Richardson Hall, Corvallis, OR, 97331-5752
    Phone: (541) 737-8480
    Email: lterweb@fsl.orst.edu
Study Description

SCALER attempts to address the question of whether small-scale ecological experiments can be applied to understand the behavior of entire ecological systems. Specifically, the role of comsumers to stream functional processes were examined by measurements of structure and function within stream reaches. These results feed into a broader continent wide examination within a variety of ecological systems. Rates of stream metabolism (photosynthesis and respiration) and nutrient uptake were measured, as well as the way these rates respond to animal exclusions (used to mimic loss of animal diversity in streams). Aquatic food web and biogeochemical responses in three consecutive 75m stream reaches were measured by manipulating densities of fish and amphibians (natural, depletion, and addition). Additionally, various stream characteristics were measured including streamflow, water chemistry, nutrients, metabolism, stream habitat measurements (wetted widths, depths and substrate), and canopy conditions (percent shade). The experiment was carried out every summer between 2014-2016 in streams of the HJ Andrews Experimental Forest to capture interannual variability. We set out to understand whether small scale ecological experiments can be applied to understand structure and function of stream reaches by understanding the role of consumers to stream functional processes. These local results will be linked to the scale of watersheds and regions by modeling. Laboratory Methods - AN008

Purpose: We set out to understand whether small scale ecological experiments can be applied to understand structure and function of stream reaches by understanding the role of consumers to stream functional processes. These local results will be linked to the scale of watersheds and regions by modeling.

Methods

Method Steps

Method Step 1

No method step description paragraphs listed.

Instrumentation:

  • Dissolved oxygen and specific conductivity: YSI 600 OMS-V2 multiparameter sondes equipped with a 6150 ROX optical dissolved sensor (Yellow Springs Instruments, Yellow Springs, Ohio)
Laboratory Methods - AN008
  • After thawing, each sample was split into two aliquots; the aliquot for standing stock was sieved to remove large, non-algal particles, filtered onto pre-combusted and pre-weighed GF/F filters. These filters were then dried at 60 deg C, weighed, combusted at 500 deg C, and reweighed to provide estimates of both organic and inorganic fractions of standing stock. The second aliquot was analyzed for Chlorophyll a and phaeophytin concentration by filtering onto pre-combusted GF/F filters, and using the heated ethanol methodology (Sartory and Grobblear, 1984). All measurement of concentrations of pigments occurred using a Shimadzu UV-1700 UV-VIS spectrophotometer. Chlorophyll a pigment concentrations were corrected retroactively based on Parker et al. (2016).
  • The frozen water samples were sent to the Cooperative Chemical Analytical Laboratory (CCAL) at Oregon State University and analyzed for total phosphorus, total nitrogen, soluble reactive phosphorus, ammonium, nitrate, and dissolved organic carbon following standard methods (See http://www.ccal.oregonstate.edu/ for a list of analytical methods).
  • After thawing, the samples were sieved to remove large particles and filtered onto pre-combusted and pre-weighed GF/F filters. These filters were then dried at 60 deg C, weighed, combusted at 500 deg C, and reweighed to provide estimates of the benthic organic matter.
  • Propane samples were analyzed using an Agilent 7890A Gas Chromatograph
  • Macroinvertebrates that were preserved in 95% alcohol in the field were taken to the lab to be cleaned, picked, and classified to the lowest taxonomic unit possible. In 2014, macroinvertebrates were classified by Shannon Claeson, PNW Research Station, and in 2015 and 2016, they were classified by Matt Whiles lab, Southern Illinois University.

Sampling

Sampling Description
  • We measured aquatic food web and biogeochemical responses in three consecutive 75m stream reaches by manipulating densities of fish and amphibians (natural, depletion, and addition) for ~40 days. Prior to sampling, each reach was blocked with 3 mm mesh netting that was buried into the sediment to inhibit movement of animals in or out of the sample reaches. The natural reach was located furthest upstream, the depletion reach was the middle reach, and the addition reach was downstream. The reach with natural densities acted as a reference by maintaining animals that were initially found there. Captured fish and amphibians were removed from the depletion reach and added to the addition reach. General aspects of our experimental design was based on a larger macrosystems biology project (Scale, Consumers, And Lotic Ecosystem Rates). The experiment was carried out every summer between 2014-2017 at McCreek to capture interannual variability. In 2015, the experiment was carried out at 3 different size streams, to capture variability within the stream network. In 2015, we focused our field experiment in three streams of varying sizes, lower McRae Creek (4th order), upper McRae Creek (3rd order), and upper Lookout Creek (2nd order), at the H.J. Andrews Experimental Forest (HJA) in the central western Cascades Range, Oregon. In 2014 and 2016, we focused the field experiment only at the lower McRae Creek site.
Spatial Sampling Units
  • Andrews Experimental Forest (HJA)
    W -122.26172200, E -122.10084700, N 44.28196400, S 44.19770400
    Altitude: 1631 to 1631 meter
  • McRae Creek
    W -122.20859020, E -122.13943300, N 44.27311600, S 44.23328700
  • SCALER sample site 1 on McRae Creek
    W -122.20549300, E -122.20549300, N 44.23513200, S 44.23513200
    Altitude: 561 to 561 meter
  • SCALER sample site 2, on McRae Creek at the STREON site
    W -122.16756900, E -122.16756900, N 44.25709700, S 44.25709700
    Altitude: 846 to 846 meter
  • SCALER sample site 3 on Lookout Creek
    W -122.11797700, E -122.11797700, N 44.22253500, S 44.22253500
    Altitude: 1008 to 1008 meter
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: stream ecology (theme), biomass (theme), species abundance (theme), respiration (theme), metabolism (theme), primary production (theme), nutrients (theme), streams (theme), invertebrates (theme), amphibians (theme), fishes (theme)
  • LTER core research areas: primary production (theme)
Taxonomic Hierarchy
  • All Organisms: All Organisms
  • Highest common category (ca. kingdom): Animalia
  • Division or Phylum: Chordata
  • Class: Osteichthyes
  • Genus: Rhinichthys
  • Species: Rhinichthys cataractae
  • Class: Actinopterygii
  • Order: Salmoniformes
  • Family: Salmonidae
  • Genus: Oncorhyncus
  • Species: Oncorhyncus clarkii
  • Species: Oncorhyncus clarkii clarkii
  • Species: Oncorhyncus mykiss
  • Order: Scorpaeniformes
  • Family: Cottidae
  • Genus: Cottus
  • Species: Cottus beldingi
  • Class: Amphibia
  • Genus: Taricha
  • Species: Taricha granulosa
  • Genus: Rana
  • Species: Rana aurora
  • Species: Rana cascadae
  • Order: Urodela
  • Family: Dicamptodontidae
  • Genus: Dicamptodon
  • Species: Dicamptodon tenebrosus
  • Genus: Ascaphus
  • Species: Ascaphus truei
  • Genus: Plethodon
  • Species: Plethodon dunni
Data Entities
# Entity Metadata Data
1 AN00801
AN00801
Epilithic biomass and chlorophyll a within treatment reach:
 METADATA DATA
2 AN00802
AN00802
Measurements of macroconsumers within treatment reach:
 METADATA DATA
3 AN00803
AN00803
Water chemistry of treatment reach:
 METADATA DATA
4 AN00804
AN00804
Stream channel wetted width measurements within treatment reach:
 METADATA DATA
5 AN00805
AN00805
Stream habitat measurements (depth and substrate size):
 METADATA DATA
6 AN00806
AN00806
Canopy condition of treatment reach:
 METADATA DATA
7 AN00807
AN00807
Fine benthic organic matter within treatment reach:
 METADATA DATA
8 AN00808
AN00808
Dissolved oxygen and specific conductivity within treatment reach:
 METADATA DATA
Metadata
AN00801 - AN00801

Object name: AN00801.csv

Records: 189

Attributes: 12

Temporal coverage: 2014-09-02 to 2016-08-09

File size: 13424 byte

Checksum (MD5): 49ae3b75274de76bab5e74075bbbb3d2

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

Constraints (2)
  • primaryKey: PRIMARY
    AN00801.REACH_TREATMENT, AN00801.SAMPLE_REPLICATE, AN00801.SAMPLE_TIMING, AN00801.SAMPLE_TYPE, AN00801.SAMPLING_DATE, AN00801.SITE_NUMBER
  • notNullConstraint: NOTNULL
    AN00801.DBCODE, AN00801.ENTITY, AN00801.REACH_TREATMENT, AN00801.SAMPLE_REPLICATE, AN00801.SAMPLE_TIMING, AN00801.SAMPLE_TYPE, AN00801.SAMPLING_DATE, AN00801.SITE_NUMBER, AN00801.YEAR
Attributes (12)
DBCODE - char(5) (nominal)

ID: AN00801.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • AN008
    FSDB Database Study Code
ENTITY - numeric(2,0) (ratio)

ID: AN00801.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SAMPLE_TYPE - char(5) (nominal)

ID: AN00801.SAMPLE_TYPE

Spaitial scale of sampling

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • REACH
    Sampling conducted at reach scale, typically 50 to 65m stretch
  • PATCH
    Sampling conducted at patch scale in plots or chamber units within reach
YEAR - numeric(4,0) (interval)

ID: AN00801.YEAR

Year sample collected

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1

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

SITE_NUMBER - char(8) (ordinal)

ID: AN00801.SITE_NUMBER

ID number assigned to site

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • SCALER_1
    SCALER sample site 1 on McRae Creek
  • SCALER_2
    SCALER sample site 2, on McRae Creek at the STREON site
  • SCALER_3
    SCALER sample site 3 on Lookout Creek
REACH_TREATMENT - char(1) (nominal)

ID: AN00801.REACH_TREATMENT

Reach treatment

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • C
    Control reach (consumers ambient)
  • D
    Treatment/deletion reach (consumers removed)
  • A
    Addition reach (consumers added)
SAMPLE_REPLICATE - numeric(1,0) (ratio)

ID: AN00801.SAMPLE_REPLICATE

Sample replicate number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SAMPLE_TIMING - char(5) (nominal)

ID: AN00801.SAMPLE_TIMING

Type of sample timing collection during season

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • START
    Beginning of season first sampling
  • END
    End of season second and final sampling
SAMPLING_DATE - datetime (dateTime)

ID: AN00801.SAMPLING_DATE

Date of sample collection

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

EPILITHON_BIOMASS - numeric(6,2) (ratio)

ID: AN00801.EPILITHON_BIOMASS

Biomass (AFDM) concentration

Type system: Microsoft SQL Server 2008

Unit: grams per square meter

Precision: 1

Numeric domain: type=real, min=0.8800 (exclusive=false), max=52.0800 (exclusive=false)

CHL_A - numeric(6,2) (ratio)

ID: AN00801.CHL_A

Chlorophyll a concentration corrected following Parker et al. (2016)

Type system: Microsoft SQL Server 2008

Unit: milligrams per square meter

Precision: 1

Numeric domain: type=real, min=0.9500 (exclusive=false), max=35.4800 (exclusive=false)

NOTES - varchar(200) (nominal)

ID: AN00801.NOTES

Notes taken during sample collection and analysis

Type system: Microsoft SQL Server 2008

AN00802 - AN00802

Object name: AN00802.csv

Records: 9599

Attributes: 17

Temporal coverage: 2014-08-14 to 2016-08-17

File size: 669935 byte

Checksum (MD5): a418498e1555abde952e903e471db0dc

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

Constraints (2)
  • primaryKey: PRIMARY
    AN00802.DIRECTION, AN00802.PASS, AN00802.REACH_TREATMENT, AN00802.SAMPLING_DATE, AN00802.SITE_NUMBER, AN00802.SPECIES, AN00802.VERT_INDEX
  • notNullConstraint: NOTNULL
    AN00802.DAY_OF_EXPERIMENT, AN00802.DBCODE, AN00802.DIRECTION, AN00802.ENTITY, AN00802.FROG_DEV_STAGE, AN00802.PASS, AN00802.REACH_TREATMENT, AN00802.SAMPLING_DATE, AN00802.SITE_NUMBER, AN00802.SPECIES, AN00802.VERT_INDEX, AN00802.YEAR
Attributes (17)
DBCODE - char(5) (nominal)

ID: AN00802.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • AN008
    FSDB Database Study Code
ENTITY - numeric(2,0) (ratio)

ID: AN00802.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

YEAR - numeric(4,0) (interval)

ID: AN00802.YEAR

Year sample collected

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1

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

SITE_NUMBER - char(8) (ordinal)

ID: AN00802.SITE_NUMBER

ID number assigned to site

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • SCALER_1
    SCALER sample site 1 on McRae Creek
  • SCALER_2
    SCALER sample site 2, on McRae Creek at the STREON site
  • SCALER_3
    SCALER sample site 3 on Lookout Creek
REACH_TREATMENT - char(1) (nominal)

ID: AN00802.REACH_TREATMENT

Reach treatment

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • C
    Control reach (consumers ambient)
  • D
    Treatment/deletion reach (consumers removed)
  • A
    Addition reach (consumers added)
SAMPLING_DATE - datetime (dateTime)

ID: AN00802.SAMPLING_DATE

Date of sample collection

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

DAY_OF_EXPERIMENT - numeric(2,0) (ratio)

ID: AN00802.DAY_OF_EXPERIMENT

Day of experiment (Number since start)

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

PASS - numeric(2,0) (interval)

ID: AN00802.PASS

Pass through reach when collected (multiple passes made during collection)

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

DIRECTION - char(1) (nominal)

ID: AN00802.DIRECTION

Direction headed while sampling (upstream or downstream)

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • U
    Direction of pass through stream to collect consumers is upstream
  • D
    Direction of pass through stream to collect consumers is downstream
SPECIES - char(3) (nominal)

ID: AN00802.SPECIES

Consumer species code

Type system: Microsoft SQL Server 2008

Code definitions (10)
  • PS
    Cottus beldingi
  • CT
    Oncorhyncus clarkii clarkii
  • TR
    Oncorhyncus mykiss
  • LD
    Rhinichthys cataractae
  • TF
    Ascaphus truei
  • GS
    Dicamptodon tenebrosus
  • DU
    Plethodon dunni
  • RF
    Rana aurora
  • CF
    Rana cascadae
  • RSN
    Taricha granulosa
VERT_INDEX - numeric(3,0) (ratio)

ID: AN00802.VERT_INDEX

unique index of site, reach, date, pass, direction, species sampled

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

LENGTH2_AMPHIBS - numeric(4,0) (ratio)

ID: AN00802.LENGTH2_AMPHIBS

VL; vent length, amphibs only

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

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

LENGTH - numeric(4,0) (ratio)

ID: AN00802.LENGTH

Length of consumer

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

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

WEIGHT - numeric(7,1) (ratio)

ID: AN00802.WEIGHT

Weight of consumer

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 1

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

FROG_DEV_STAGE - char(3) (nominal)

ID: AN00802.FROG_DEV_STAGE

Stage of frog development

Type system: Microsoft SQL Server 2008

Code definitions (7)
  • NA
    Not applicable, data either misssing or does not apply to species
  • A
    Adult
  • FHL
    Full front and hind legs, tail remaining
  • HL
    Hind legs fully developed, front legs undeveloped
  • NL
    No legs, tadpole stage
  • SHL
    Stubby hind legs, front legs undeveloped
  • SFL
    Stubby front legs, hind legs developed
NOTES - varchar(200) (nominal)

ID: AN00802.NOTES

Notes taken during sample collection and analysis

Type system: Microsoft SQL Server 2008

QA_NOTES - varchar(200) (nominal)

ID: AN00802.QA_NOTES

Note recorded during QA/QC

Type system: Microsoft SQL Server 2008

AN00803 - AN00803

Object name: AN00803.csv

Records: 30

Attributes: 13

Temporal coverage: 2014-09-02 to 2016-08-09

File size: 2401 byte

Checksum (MD5): 262fe179df129443eef5a38a2c10ea1c

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

Constraints (2)
  • primaryKey: PRIMARY
    AN00803.REACH_TREATMENT, AN00803.SAMPLE_TIMING, AN00803.SAMPLING_DATE, AN00803.SITE_NUMBER
  • notNullConstraint: NOTNULL
    AN00803.DBCODE, AN00803.ENTITY, AN00803.REACH_TREATMENT, AN00803.SAMPLE_TIMING, AN00803.SAMPLING_DATE, AN00803.SITE_NUMBER, AN00803.YEAR
Attributes (13)
DBCODE - char(5) (nominal)

ID: AN00803.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • AN008
    FSDB Database Study Code
ENTITY - numeric(2,0) (ratio)

ID: AN00803.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

YEAR - numeric(4,0) (interval)

ID: AN00803.YEAR

Year sample collected

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1

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

SITE_NUMBER - char(8) (ordinal)

ID: AN00803.SITE_NUMBER

ID number assigned to site

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • SCALER_1
    SCALER sample site 1 on McRae Creek
  • SCALER_2
    SCALER sample site 2, on McRae Creek at the STREON site
  • SCALER_3
    SCALER sample site 3 on Lookout Creek
REACH_TREATMENT - char(1) (nominal)

ID: AN00803.REACH_TREATMENT

Reach treatment

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • C
    Control reach (consumers ambient)
  • D
    Treatment/deletion reach (consumers removed)
  • A
    Addition reach (consumers added)
SAMPLING_DATE - datetime (dateTime)

ID: AN00803.SAMPLING_DATE

Date of sample collection

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

SAMPLE_TIMING - char(5) (nominal)

ID: AN00803.SAMPLE_TIMING

Type of sample timing collection during season

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • START
    Beginning of season first sampling
  • END
    End of season second and final sampling
UTN - numeric(5,3) (ratio)

ID: AN00803.UTN

Total unfiltered nitrogen (N) concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

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

NH4_N - numeric(5,3) (ratio)

ID: AN00803.NH4_N

Ammonium (NH4-N) concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

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

NO3_N - numeric(5,3) (ratio)

ID: AN00803.NO3_N

Nitrate (NO3-N) concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

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

UTP - numeric(5,3) (ratio)

ID: AN00803.UTP

Total unfiltered phosphorous (P) concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

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

PO4_P - numeric(5,3) (ratio)

ID: AN00803.PO4_P

Orthophosphate (PO4-P) concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

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

DOC - numeric(5,3) (ratio)

ID: AN00803.DOC

Dissolved Organic Carbon (mg C/L) concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

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

AN00804 - AN00804

Object name: AN00804.csv

Records: 233

Attributes: 9

Temporal coverage: 2014-09-03 to 2016-08-09

File size: 12095 byte

Checksum (MD5): c33a4b703c013a6c43da71fa01efc279

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

Constraints (2)
  • primaryKey: PRIMARY
    AN00804.REACH_TREATMENT, AN00804.SAMPLE_TIMING, AN00804.SAMPLING_DATE, AN00804.SITE_NUMBER, AN00804.TRANSECT_M
  • notNullConstraint: NOTNULL
    AN00804.AVERAGE_WIDTH_M, AN00804.DBCODE, AN00804.ENTITY, AN00804.REACH_TREATMENT, AN00804.SAMPLE_TIMING, AN00804.SAMPLING_DATE, AN00804.SITE_NUMBER, AN00804.TRANSECT_M, AN00804.YEAR
Attributes (9)
DBCODE - char(5) (nominal)

ID: AN00804.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • AN008
    FSDB Database Study Code
ENTITY - numeric(2,0) (ratio)

ID: AN00804.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

YEAR - numeric(4,0) (interval)

ID: AN00804.YEAR

Year sample collected

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1

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

SITE_NUMBER - char(8) (ordinal)

ID: AN00804.SITE_NUMBER

ID number assigned to site

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • SCALER_1
    SCALER sample site 1 on McRae Creek
  • SCALER_2
    SCALER sample site 2, on McRae Creek at the STREON site
  • SCALER_3
    SCALER sample site 3 on Lookout Creek
REACH_TREATMENT - char(1) (nominal)

ID: AN00804.REACH_TREATMENT

Reach treatment

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • C
    Control reach (consumers ambient)
  • D
    Treatment/deletion reach (consumers removed)
  • A
    Addition reach (consumers added)
SAMPLING_DATE - datetime (dateTime)

ID: AN00804.SAMPLING_DATE

Date of sample collection

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

SAMPLE_TIMING - char(5) (nominal)

ID: AN00804.SAMPLE_TIMING

Type of sample timing collection during season

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • START
    Beginning of season first sampling
  • END
    End of season second and final sampling
TRANSECT_M - char(2) (ordinal)

ID: AN00804.TRANSECT_M

Number of meters from bottom of reach where measurements were taken

Type system: Microsoft SQL Server 2008

Code definitions (16)
  • code
    Most upstream transect in study reach
  • 5
    Second transect, 5 meters downstream from transect 0
  • 10
    Third transect, 10 m downstream of transect 0
  • 15
    Fourth transect, 15 m downstream of transect 0
  • 20
    Fifth transect, 20 m downstream of transect 0
  • 25
    Sixth transect, 25 m downstream of transect 0
  • 30
    Seventh transect, 30 m downstream of transect 0
  • 35
    Eighth transect, 35 m downstream of transect 0
  • 40
    Ninth transect, 40 m downstream of transect 0
  • 45
    Tenth transect, 45 m downstream of transect 0
  • 50
    Eleventh transect, 50 m downstream of transect 0
  • 55
    Twelfth transect, 55 m downstream of transect 0
  • 60
    Thirteenth transect, 60 m downstream of transect 0
  • 65
    Fourteenth transect, 65 m downstream of transect 0
  • 70
    Fifteenth transect, 70 m downstream of transect 0
  • 75
    Sixteenth transect, 75 m downstream of transect 0
AVERAGE_WIDTH_M - numeric(5,2) (interval)

ID: AN00804.AVERAGE_WIDTH_M

Wetted width measured at cross section of reach

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

Numeric domain: type=real, min=1.8000 (exclusive=false), max=11.0000 (exclusive=false)

AN00805 - AN00805

Object name: AN00805.csv

Records: 4995

Attributes: 11

Temporal coverage: 2014-09-03 to 2016-07-22

File size: 286086 byte

Checksum (MD5): c98bd99d2a46a60ad5e1386897421b92

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

Constraints (2)
  • primaryKey: PRIMARY
    AN00805.REACH_TREATMENT, AN00805.SAMPLING_DATE, AN00805.SITE_NUMBER, AN00805.TRANSECT_M, AN00805.SAMPLE_PT
  • notNullConstraint: NOTNULL
    AN00805.DBCODE, AN00805.ENTITY, AN00805.REACH_TREATMENT, AN00805.SAMPLING_DATE, AN00805.SITE_NUMBER, AN00805.TRANSECT_M, AN00805.YEAR, AN00805.SAMPLE_PT
Attributes (11)
DBCODE - char(5) (nominal)

ID: AN00805.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • AN008
    FSDB Database Study Code
ENTITY - numeric(2,0) (ratio)

ID: AN00805.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

YEAR - numeric(4,0) (interval)

ID: AN00805.YEAR

Year sample collected

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1

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

SITE_NUMBER - char(8) (ordinal)

ID: AN00805.SITE_NUMBER

ID number assigned to site

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • SCALER_1
    SCALER sample site 1 on McRae Creek
  • SCALER_2
    SCALER sample site 2, on McRae Creek at the STREON site
  • SCALER_3
    SCALER sample site 3 on Lookout Creek
REACH_TREATMENT - char(1) (nominal)

ID: AN00805.REACH_TREATMENT

Reach treatment

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • C
    Control reach (consumers ambient)
  • D
    Treatment/deletion reach (consumers removed)
  • A
    Addition reach (consumers added)
SAMPLING_DATE - datetime (dateTime)

ID: AN00805.SAMPLING_DATE

Date of sample collection

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TRANSECT_M - char(2) (ordinal)

ID: AN00805.TRANSECT_M

Number of meters from bottom of reach where measurements were taken

Type system: Microsoft SQL Server 2008

Code definitions (16)
  • code
    Most upstream transect in study reach
  • 5
    Second transect, 5 meters downstream from transect 0
  • 10
    Third transect, 10 m downstream of transect 0
  • 15
    Fourth transect, 15 m downstream of transect 0
  • 20
    Fifth transect, 20 m downstream of transect 0
  • 25
    Sixth transect, 25 m downstream of transect 0
  • 30
    Seventh transect, 30 m downstream of transect 0
  • 35
    Eighth transect, 35 m downstream of transect 0
  • 40
    Ninth transect, 40 m downstream of transect 0
  • 45
    Tenth transect, 45 m downstream of transect 0
  • 50
    Eleventh transect, 50 m downstream of transect 0
  • 55
    Twelfth transect, 55 m downstream of transect 0
  • 60
    Thirteenth transect, 60 m downstream of transect 0
  • 65
    Fourteenth transect, 65 m downstream of transect 0
  • 70
    Fifteenth transect, 70 m downstream of transect 0
  • 75
    Sixteenth transect, 75 m downstream of transect 0
SAMPLE_PT - numeric(2,0) (ratio)

ID: AN00805.SAMPLE_PT

Sampling point across the transect

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SUBSTRATE_MM - numeric(7,1) (ratio)

ID: AN00805.SUBSTRATE_MM

Width of substrate

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

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

DEPTH_CM - numeric(7,1) (ratio)

ID: AN00805.DEPTH_CM

Depth of stream at cross section

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

Numeric domain: type=real, min=0.0000 (exclusive=false), max=1000.0000 (exclusive=false)

NOTES - varchar(200) (nominal)

ID: AN00805.NOTES

Notes taken during sample collection and analysis

Type system: Microsoft SQL Server 2008

AN00806 - AN00806

Object name: AN00806.csv

Records: 189

Attributes: 11

Temporal coverage: 2014-09-03 to 2016-07-22

File size: 12179 byte

Checksum (MD5): 18799c4e9c9f159ebed9428cdeb5ca91

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

Constraints (2)
  • primaryKey: PRIMARY
    AN00806.REACH_TREATMENT, AN00806.SAMPLING_DATE, AN00806.SITE_NUMBER, AN00806.TRANSECT_M
  • notNullConstraint: NOTNULL
    AN00806.DBCODE, AN00806.DOWN_PERCENT_UNSHADED, AN00806.ENTITY, AN00806.LEFT_PERCENT_UNSHADED, AN00806.REACH_TREATMENT, AN00806.RIGHT_PERCENT_UNSHADED, AN00806.SAMPLING_DATE, AN00806.SITE_NUMBER, AN00806.TRANSECT_M, AN00806.UP_PERCENT_UNSHADED, AN00806.YEAR
Attributes (11)
DBCODE - char(5) (nominal)

ID: AN00806.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • AN008
    FSDB Database Study Code
ENTITY - numeric(2,0) (ratio)

ID: AN00806.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

YEAR - numeric(4,0) (interval)

ID: AN00806.YEAR

Year sample collected

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1

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

SITE_NUMBER - char(8) (ordinal)

ID: AN00806.SITE_NUMBER

ID number assigned to site

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • SCALER_1
    SCALER sample site 1 on McRae Creek
  • SCALER_2
    SCALER sample site 2, on McRae Creek at the STREON site
  • SCALER_3
    SCALER sample site 3 on Lookout Creek
REACH_TREATMENT - char(1) (nominal)

ID: AN00806.REACH_TREATMENT

Reach treatment

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • C
    Control reach (consumers ambient)
  • D
    Treatment/deletion reach (consumers removed)
  • A
    Addition reach (consumers added)
SAMPLING_DATE - datetime (dateTime)

ID: AN00806.SAMPLING_DATE

Date of sample collection

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TRANSECT_M - char(2) (ordinal)

ID: AN00806.TRANSECT_M

Number of meters from bottom of reach where measurements were taken

Type system: Microsoft SQL Server 2008

Code definitions (16)
  • code
    Most upstream transect in study reach
  • 5
    Second transect, 5 meters downstream from transect 0
  • 10
    Third transect, 10 m downstream of transect 0
  • 15
    Fourth transect, 15 m downstream of transect 0
  • 20
    Fifth transect, 20 m downstream of transect 0
  • 25
    Sixth transect, 25 m downstream of transect 0
  • 30
    Seventh transect, 30 m downstream of transect 0
  • 35
    Eighth transect, 35 m downstream of transect 0
  • 40
    Ninth transect, 40 m downstream of transect 0
  • 45
    Tenth transect, 45 m downstream of transect 0
  • 50
    Eleventh transect, 50 m downstream of transect 0
  • 55
    Twelfth transect, 55 m downstream of transect 0
  • 60
    Thirteenth transect, 60 m downstream of transect 0
  • 65
    Fourteenth transect, 65 m downstream of transect 0
  • 70
    Fifteenth transect, 70 m downstream of transect 0
  • 75
    Sixteenth transect, 75 m downstream of transect 0
UP_PERCENT_UNSHADED - numeric(6,2) (interval)

ID: AN00806.UP_PERCENT_UNSHADED

Percent of unshaded canopy looking upstream

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1

Numeric domain: type=real, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)

LEFT_PERCENT_UNSHADED - numeric(6,2) (ratio)

ID: AN00806.LEFT_PERCENT_UNSHADED

Percent of unshaded canopy looking to left bank

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1

Numeric domain: type=real, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)

DOWN_PERCENT_UNSHADED - numeric(6,2) (ratio)

ID: AN00806.DOWN_PERCENT_UNSHADED

Percent of unshaded canopy looking to right bank

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1

Numeric domain: type=real, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)

RIGHT_PERCENT_UNSHADED - numeric(6,2) (ratio)

ID: AN00806.RIGHT_PERCENT_UNSHADED

Percent of unshaded canopy looking downstream

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1

Numeric domain: type=real, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)

AN00807 - AN00807

Object name: AN00807.csv

Records: 156

Attributes: 10

Temporal coverage: 2014-10-03 to 2015-08-28

File size: 9323 byte

Checksum (MD5): ef4fbfa4df4e94732d9fb92da0570128

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

Constraints (2)
  • primaryKey: PRIMARY
    AN00807.REACH_TREATMENT, AN00807.SAMPLE_REPLICATE, AN00807.SAMPLE_TIMING, AN00807.SAMPLING_DATE, AN00807.SITE_NUMBER
  • notNullConstraint: NOTNULL
    AN00807.DBCODE, AN00807.ENTITY, AN00807.REACH_TREATMENT, AN00807.SAMPLE_REPLICATE, AN00807.SAMPLE_TIMING, AN00807.SAMPLING_DATE, AN00807.SITE_NUMBER, AN00807.YEAR
Attributes (10)
DBCODE - char(5) (nominal)

ID: AN00807.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • AN008
    FSDB Database Study Code
ENTITY - numeric(2,0) (ratio)

ID: AN00807.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

YEAR - numeric(4,0) (interval)

ID: AN00807.YEAR

Year sample collected

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1

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

SITE_NUMBER - char(8) (ordinal)

ID: AN00807.SITE_NUMBER

ID number assigned to site

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • SCALER_1
    SCALER sample site 1 on McRae Creek
  • SCALER_2
    SCALER sample site 2, on McRae Creek at the STREON site
  • SCALER_3
    SCALER sample site 3 on Lookout Creek
REACH_TREATMENT - char(1) (nominal)

ID: AN00807.REACH_TREATMENT

Reach treatment

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • C
    Control reach (consumers ambient)
  • D
    Treatment/deletion reach (consumers removed)
  • A
    Addition reach (consumers added)
SAMPLING_DATE - datetime (dateTime)

ID: AN00807.SAMPLING_DATE

Date of sample collection

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

SAMPLE_TIMING - char(5) (nominal)

ID: AN00807.SAMPLE_TIMING

Type of sample timing collection during season

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • START
    Beginning of season first sampling
  • END
    End of season second and final sampling
SAMPLE_REPLICATE - numeric(1,0) (ratio)

ID: AN00807.SAMPLE_REPLICATE

Sample replicate number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

FBOM_AFDM - numeric(8,2) (ratio)

ID: AN00807.FBOM_AFDM

Concentration of Fine Benthic Organic Matter (Ash Free Dry Mass)

Type system: Microsoft SQL Server 2008

Unit: grams per square meter

Precision: 1

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

NOTES - varchar(200) (nominal)

ID: AN00807.NOTES

Notes taken during sample collection and analysis

Type system: Microsoft SQL Server 2008

AN00808 - AN00808

Object name: AN00808.csv

Records: 41429

Attributes: 13

Temporal coverage: 2014-08-24 to 2016-08-12

File size: 3559503 byte

Checksum (MD5): b4ae9818aaefcfd460b88724fd04b68a

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

Constraints (2)
  • primaryKey: PRIMARY
    AN00808.SAMPLE_LOCATION, AN00808.REACH_TREATMENT, AN00808.SAMPLE_TIMING, AN00808.SITE_NUMBER, AN00808.TIMESTAMP
  • notNullConstraint: NOTNULL
    AN00808.SAMPLE_LOCATION, AN00808.DBCODE, AN00808.DO_MG_L, AN00808.EC_US_CM, AN00808.ENTITY, AN00808.PERCENT_DO, AN00808.REACH_TREATMENT, AN00808.SAMPLE_ID, AN00808.SAMPLE_TIMING, AN00808.SITE_NUMBER, AN00808.TEMPERATURE, AN00808.TIMESTAMP, AN00808.YEAR
Attributes (13)
DBCODE - char(5) (nominal)

ID: AN00808.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • AN008
    FSDB Database Study Code
ENTITY - numeric(2,0) (ratio)

ID: AN00808.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

YEAR - numeric(4,0) (interval)

ID: AN00808.YEAR

Year sample collected

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1

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

SITE_NUMBER - char(8) (ordinal)

ID: AN00808.SITE_NUMBER

ID number assigned to site

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • SCALER_1
    SCALER sample site 1 on McRae Creek
  • SCALER_2
    SCALER sample site 2, on McRae Creek at the STREON site
  • SCALER_3
    SCALER sample site 3 on Lookout Creek
REACH_TREATMENT - char(1) (nominal)

ID: AN00808.REACH_TREATMENT

Reach treatment

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • C
    Control reach (consumers ambient)
  • D
    Treatment/deletion reach (consumers removed)
  • A
    Addition reach (consumers added)
SAMPLE_LOCATION - char(6) (nominal)

ID: AN00808.SAMPLE_LOCATION

Location sampled in reach

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • BOTTOM
    Bottom or downstream ending point of sampling
  • TOP
    Top or upstream starting point of sampling
SAMPLE_TIMING - char(5) (nominal)

ID: AN00808.SAMPLE_TIMING

Type of sample timing collection during season

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • START
    Beginning of season first sampling
  • END
    End of season second and final sampling
TIMESTAMP - datetime (dateTime)

ID: AN00808.TIMESTAMP

Date and time of sample collection (5 min samples)

Type system: Microsoft SQL Server 2008

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

SAMPLE_ID - numeric(5,0) (ratio)

ID: AN00808.SAMPLE_ID

Unique ID number assigned to sample

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

TEMPERATURE - numeric(5,2) (ratio)

ID: AN00808.TEMPERATURE

Temperature

Type system: Microsoft SQL Server 2008

Unit: degrees Celsius

Precision: 1

Numeric domain: type=real, min=8.1800 (exclusive=false), max=17.6600 (exclusive=false)

PERCENT_DO - numeric(5,1) (ratio)

ID: AN00808.PERCENT_DO

Percentage of dissolved oxygen

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1

Numeric domain: type=real, min=80.0000 (exclusive=false), max=100.1000 (exclusive=false)

DO_MG_L - numeric(5,2) (ratio)

ID: AN00808.DO_MG_L

Concentration of dissolved oxygen

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=8.0000 (exclusive=false), max=10.5000 (exclusive=false)

EC_US_CM - numeric(4,0) (ratio)

ID: AN00808.EC_US_CM

Electrical conductivity

Type system: Microsoft SQL Server 2008

Unit: micro siemens per centimeter

Precision: 1

Numeric domain: type=real, min=34.0000 (exclusive=false), max=2038.0000 (exclusive=false)

Units
milligrams per square meter mg/m2 arealMassDensity milligramPerMeterSquared kilogramPerMeterSquared 0.000001 milligrams per square meter
grams g mass gram kilogram 0.001 grams; 0.001 kilogram
meters m length meter meter 1 meter; SI unit of length
centimeters cm length centimeter meter 0.01 centimeters; .01 meters
millimeters mm length millimeter meter 0.001 millimeters; .001 meters
grams per square meter g/m2 arealMassDensity gramPerMeterSquared kilogramPerMeterSquared 0.001 grams per square meter
milligrams per liter mg/l massDensity milligramPerLiter kilogramPerMeterCubed 0.001 milligrams per liter
micro siemens per centimeter uS/cm specific conductance microSiemenPerCentimeter siemenPerMeter .0001 micro Siemens per centimeter
percent % dimensionless number dimensionless 100 percent; a number
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
year (yyyy) YYYY datetime YYYY YYYY-MM-DDThh:mm:ss N/A year (4 character) portion of date
Related Datasets

No related dataset codes found in the EML text fields.

Related Publications

No publication citations found in this EML file.

Related Files

No related files listed in this EML file.

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: N/A

Maintenance

Maintenance update frequency: notPlanned

Description

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

Change History

  • Version1 (2017-05-19)
    Study code and preliminary metadata established
  • Version2 (2020-04-28)
    Initial creation of entities 1-8 using import_xls. Ran QC. Uploaded to SQL.