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

AS010: Riparian controls on light availability, primary producers, invertebrates, fish and salamanders in streams in and near the Andrews Experimental Forest, 2014-2018

← 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-07-01 to 2014-10-07
Version: 3
Published: 2019-06-18
EDI Package ID: knb-lter-and.5330.3
Source XML: AS010_3.xml

Notice

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

Citation

Warren, D.; Kaylor, M. 2019. Riparian controls on light availability, primary producers, invertebrates, fish and salamanders in streams in and near the Andrews Experimental Forest, 2014-2018 Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/AS010 Accessed 2026-05-10.

Abstract

The goal of this data collection effort was to determine how the age, stage, and structure of the riparian forest relates to stream primary producers and stream biota. Data were collected on stream habitat, benthic algal, biota (fish, salamanders and macroinvertebrates), and riparian forest cover across a total of 9 streams: 7 streams in the HJ Andrews basin/Lookout Creek stream network; one stream in the westward adjacent Blue River basin, and one stream in the eastward adjacent Deer Creek river basin. In each stream there were 2 study reaches – one bordered by old-growth riparian forest and the other bordered by regenerated second-growth riparian forest on at least one bank (with a stand ages that generally ranged between 30 and 60 years). In each study reach (80 – 150 m), we collected the following data: pool habitat, wetted and bankfull widths, large wood abundance and volume, riparian forest canopy cover, benthic algae accrual on tiles, stream macroinvertebrate abundances (from 6 replicate surber samplers, which were pooled and then sub-sampled, identified and measured), age 1+ cutthroat trout (Oncorhynchus clarkii clarkii) abundance and biomass, age 0+ (young-of-year) trout abundance and biomass, coastal giant salamander (Dicamptodon tenebrosus) abundance and biomass. Fish and salamander abundances were calculated by either mark-recapture or multiple pass depletion methods.

Coverage

Temporal coverage: 2014-07-01 to 2014-10-07

Geographic coverage: Data were collected from 9 streams in and around the HJ Andrews Forest. Seven sites were located within the HJA, and two sites were located within 10 km.

Spatial coverage:

Bounds: W -122.26081030, E -122.07050800, N 44.27938900, S 44.21876600

Purpose
  • The goal of this data collection effort was to determine how the age, stage, and structure of the riparian forest relates to stream habitat, stream primary producers and stream biota.
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
  • Dana Richard Warren
    Role: Principal Investigator
    Nash Hall, Oregon State University, Corvallis, OR, 97330, USA
    Phone: 541-737-5319
    Email: dana.warren@oregonstate.edu
  • Dana Richard Warren
    Role: Creator
    Nash Hall, Oregon State University, Corvallis, OR, 97330, USA
    Phone: 541-737-5319
    Email: dana.warren@oregonstate.edu
  • Matthew J. Kaylor
    Role: Creator
    104 Nash Hall; Oregon State University, Corvallis, Oregon, 97331
    Phone: (414) 405-9500
    Email: matthew.kaylor@oregonstate.edu
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
  • Matthew J. Kaylor
    104 Nash Hall; Oregon State University, Corvallis, Oregon, 97331
    Phone: (414) 405-9500
    Email: matthew.kaylor@oregonstate.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

The goal of this data collection effort was to determine how the age, stage, and structure of the riparian forest relates to stream primary producers and stream biota. Data were collected on stream habitat, benthic algal, biota (fish, salamanders and macroinvertebrates), and riparian forest cover across a total of 9 streams: 7 streams in the HJ Andrews basin/Lookout Creek stream network; one stream in the westward adjacent Blue River basin, and one stream in the eastward adjacent Deer Creek river basin. In each stream there were 2 study reaches – one bordered by old-growth riparian forest and the other bordered by regenerated second-growth riparian forest on at least one bank (with a stand ages that generally ranged between 30 and 60 years). In each study reach (80 – 150 m), we collected the following data: pool habitat, wetted and bankfull widths, large wood abundance and volume, riparian forest canopy cover, benthic algae accrual on tiles, stream macroinvertebrate abundances (from 6 replicate surber samplers, which were pooled and then sub-sampled, identified and measured), age 1+ cutthroat trout (Oncorhynchus clarkii clarkii) abundance and biomass, age 0+ (young-of-year) trout abundance and biomass, coastal giant salamander (Dicamptodon tenebrosus) abundance and biomass. Fish and salamander abundances were calculated by either mark-recapture or multiple pass depletion methods. The goal of this data collection effort was to determine how the age, stage, and structure of the riparian forest relates to stream habitat, stream primary producers and stream biota. Field Methods - AS010

Purpose: The goal of this data collection effort was to determine how the age, stage, and structure of the riparian forest relates to stream habitat, stream primary producers and stream biota.

Methods

Method Steps

Field Methods - AS010
  • : All data were collected in the summer of 2014 during low-flow conditions. Across all nine pairs of sites, we collected a suite of physical habitat variables in each reach including: canopy cover, bankfull width, wetted width, pool area, large wood abundance and volume, temperature, nutrient concentration, and stream gradient. Canopy cover was quantified using a convex spherical densiometer (Forestry Suppliers Model A). Measurements were taken in each cardinal direction at 11 regularly spaced locations in each reach. All densiometer measurements were taken by the same individual to avoid user bias. Bankfull width and wetted width were measured at transects across the same 11 reach locations. The mean wetted width for each reach was multiplied by reach length to obtain total reach wetted area, which was used to standardize fish, salamander, and invertebrate abundance and biomass estimates per square meter of stream. Pools were identified during summer-low flow conditions as slow velocity habitats connected to the main-channel. Pool area was calculated using the length and width of each pool, and percent pool area was calculated as the total pool area divided by total wetted reach area. We quantified all large wood pieces greater than 1 m in length and 10 cm in diameter (Richmond and Fausch 1995, Young et al. 2006, Warren et al. 2009) We only measured the portion of wood pieces located within the bankfull channel for wood volume estimates. Total channel area (mean bankfull width multiplied by reach length) was used to standardize large wood volume among reaches. Temperature loggers (HOBO Pro v2) were deployed for two weeks during mid-summer to evaluate relative temperature among streams and differences between paired reaches. Due to a limited number of sensors, not all sensors were deployed for the same time interval. Sensors were deployed from 7/20/14-8/3/14 in Cook Creek and Fritz Creek and from 8/4/14- 8/24/14 in all other streams. Water samples were collected in September 2014 at all reaches during a two-day period prior to the onset of autumn rain events in this region. Water samples were filtered (25 mm Whatman GF/F filters), frozen, and analyzed for nitrate-N (NO3-N) and phosphate-P (PO4-P) using a Dionex 1500 Ion Chromatograph. Nitrogen is the limiting nutrient for stream autotrophy in the streams evaluated in this study (Gregory 1980, Warren et al. 2017).
  • : Periphyton chlorophyll a (hereafter chl a) accrual was quantified on 10 ceramic tiles (15 x 15 cm) per reach. Tiles were placed in the stream in mid-July and were retrieved after six weeks. Tiles were spaced at regular intervals and positioned within riffle sections of the stream at a depth of 10-25 cm. After six weeks, tiles were scraped using a wire brush and the slurry was filtered through 47 mm glass fiber filters (Whatman GF/F). Filters were placed in 20 ml glass vials and frozen for 24-48 hours.
  • Benthic invertebrates were sampled in late July (7/15/14-7/29/14). Both reaches within a reach pair were always sampled on the same day. In each reach, six surber samples (363 µm, 0.0625 m2) were collected from riffle habitats at regular intervals. Substrate within the surber sample quadrate was disturbed to a depth of 10 cm for approximately 30 seconds. Samples were stored in 90% alcohol until laboratory processing.
  • Fish and salamanders were collected using a backpack electroshocker (Smith-Root model LR-20B). Block nets were set at the upper and lower ends of each reach to prevent movement and close the system for the duration of the surveys. Population estimates were conducted using single-pass mark-recapture methods for all reach pairs except Mack Creek. For mark-recapture surveys, fish and salamanders were anesthetized using AQUI-S 20E (AQUI-S, Lower Hutt, New Zealand), weighed (nearest 0.01 g), measured (total length for fish, and snout-vent length for salamanders), and marked. Fish were marked with a small caudal clip and salamanders were marked with a visual elastomer tag (Northwest Marine Technology, Shaw Island, Washington). Fish and salamanders were released and the reach was resurveyed after approximately 24 hours. The number of marked and unmarked individuals was recorded for each species. Abundance was estimated using the Lincoln-Peterson mark-recapture model, modified by Chapman (1951), and biomass was estimated by multiplying abundance estimates by mean weight. Juvenile (0+) and adult (1+) trout were analyzed separately. Trout were distinguished as juvenile or adult based on length frequency histograms and, in general, trout less than 65 mm were classified as juveniles.
  • Multiple pass depletion methods were used to survey fish and salamanders at Mack Creek. Mack Creek is a long-term ecological research (LTER) site where fish and salamanders are sampled annually using depletion estimates. The long-term research project provided the 2014 fish and salamander data used in this study (S.V. Gregory). Multiple pass depletion and mark-recapture methods can produce significantly different population estimates (Rosenberger and Dunham 2005). To standardize population estimates across all reaches, we applied a correction factor that was obtained from simultaneous mark-recapture and depletion estimates conducted in Mack Creek in 2015 (S.V. Gregory) per Thompson and Seber (1994).
  • In addition to the primary fish and salamander surveys conducted in mid-summer, a second single-pass survey was conducted in late September 2014 to capture juvenile (age 0+) cutthroat trout and assess summertime relative growth rates for this age class. We did not sample Mack Creek in the second juvenile assessment as we did not want to interfere with long-term research efforts occurring annually at this site. In LO701, MCTE, and Fritz Creek, juvenile trout were surveyed on two sampling dates but there were few surveyed fish in at least one of these surveys (n less than 5). Therefore, we were only able to evaluate juvenile relative growth rates in 5 of the 9 sites. Relative growth rates were determined by subtracting the mean weight at survey date 1 from the mean weight of survey date 2 and then dividing this number by the number of days between sampling events.
Laboratory Methods - AS010
  • Chlorophyll a; We extracted Chl a from filters with 15 mL of 95% acetone for 2 to 4 h and estimated Chl a based on fluorometric methods with phaeophytin corrections as outlined in US Environmental Protection Agency (EPA) method 445.0 (Arar and Collins 1997). Fluorescence of a subsample of the extraction solution was measured before and after the addition of 0.1 N HCL (0.15ml/5ml solution).
  • Invertebrates: In the laboratory, the contents of each of the six surber samples from each reach were combined into a single pooled sample. This pooled sample was then subsampled using a plankton splitter until a minimum of 500 individuals were picked from the subsample. We conducted a 60 second visual search of the remaining sample (less the subsample) to collect large bodied predators to more effectively quantify invertebrate predator biomass. Invertebrates were identified to Family or Genus (Merritt et al. 2008) and individually measured using an ocular micrometer mounted on the dissecting microscope. Invertebrate lengths were converted to biomass using established length- weight relationships (Sample et al. 1993, Sabo et al. 2002, Mark Wipfli; unpublished data). We summed the biomass of individuals within a subsample and divided this summed value by the proportion of the total sample that was subsampled. The addition of this value and the biomass of the 60-second sample to identify large bodied individuals (which was not subsampled) was then divided by the total area sampled (0.375 m2) to obtain biomass estimates per square meter (g/m2).

Sampling

Study Extent
  • The previously harvested cutblocks were cleared 40-60 years prior to this study. In all cases, timber was removed down to the stream bank with no riparian buffer. Trees were replanted within 5 years post-harvest in seven of the nine cuts in accordance with forest management practices at the time. Stands in MCTW and Mack Creek were regenerated without any post-harvest planting. In 2014, the second growth riparian forests were predominantly Douglas fir (Pseudotsuga menziesii) but red alder (Alnus rubra) was also a common canopy species in areas directly adjacent to streams and provided substantial stream shading. Old-growth forests were comprised of Douglas fir, western hemlock (Tsuga heterophylla) and western red cedar (Thuja plicata). Red alder was present adjacent to streams within old-growth forests as well, but it was not as common as in second growth sections.
  • Coastal cutthroat trout and coastal giant salamanders (Dicamptodon tenebrosus) were present in all 18 stream reaches and were the dominant vertebrates. Sculpin (Cottus spp.) were present in both reaches of MR404, but were not found in any other reaches. Tailed frogs (Ascaphis truei) were found in low abundance in some of the streams, but were not evaluated in this study.
  • Description of distinction between old-growth and second growth study reaches:
  • COOK - Cook Creek, a tributary of Blue River upstream of Blue River reservoir and north of the HJ Andrews
  • FRITZ - Fritz Creek, a tributary of Deer Creek, which flows directly into the McKenzie River, NE of the HJ Andrews
  • LO701 - Harvest block LO701 on Lookout Creek. Second growth section was in cutblock of LO701. The downstream end of this reach was 180 m upstream of the cutbreak. The old-growth section was downstream of cut LO701. The upstream end was 75 m downstream from the cutbreak.
  • LO703 - Harvest block LO703 on Lookout Creek. Second growth section was in cutblock of LO703. The downstream end of this reach was 85 m upstream of the western edge of cutbreak LO703. The old-growth section was upstream of cut LO703. The downstream end of the reach was 50 m upstream from the eastern edge of cutbreak LO703.
  • MACK - Mack Creek. This site is part of an LTER fish study.
  • MCT_E - McRae Creek east tributary . Second growth section was in cutblock of L504. The old-growth reach was upstream of the second growth reach here. The upstream end of the second growth reach was 200 m downstream of the cutbreak. The downstream end of the old-growth section was 35 m upstream of the cutbreak.
  • MCT_W - McRae Creek west tributary. Second growth section was in cutblock of L503. The downstream end of the second growth reach was 90 m upstream of the cutbreak. The upstream end of the old-growth section was 50 m downstream of the cutbreak.
  • MR404 - Harvest block L404 on McRae Creek. Second growth section was in cutblock of L404. The downstream end of the second growth reach was 110 m upstream of the cutbreak. The upstream end of the old-growth section was 80 m downstream of the cutbreak.
  • STR - Harvest block L504 on McRae Creek. Second growth section was in cutblock of L504. The old-growth reach was upstream of the second growth reach here. The upstream end of the second growth reach was 75 m downstream of the cutbreak. The downstream end of the old-growth section was 75 m upstream of the cutbreak.
  • Sampling frequency: Single year
Sampling Description
  • The study was conducted within nine reach-pair sites located within the McKenzie River Basin in the western Cascade Mountains of Oregon. Seven of the sites were located within the HJ Andrews Experimental Forest (HJA), a 6,400 ha research forest encompassing the entire Lookout Creek drainage basin. Cook Creek and Fritz Creek were located outside of the HJA. Cook Creek is a tributary of Blue River upstream of Blue River reservoir and Fritz Creek is a tributary of Deer Creek, which flows directly into the McKenzie River.
  • Each pair consisted of two reaches: one within a section of stream with old-growth riparian forest, and another in a nearby section of stream bordered by second-growth riparian forest on at least one stream bank. Harvesting in the previously managed reaches occurred on just one stream bank in three reach pairs (MR404, LO701, and LO703) and on both banks for all other pairs. Sites were selected based on the presence of old-growth and second growth riparian forests close in proximity on the same stream (within 500 m). Having distinctly different forest types along two nearby sections of the same stream reduces inherent stream-to-stream environmental variability (e.g. temperature, gradient, geology, substrate, etc.) that often arises in comparisons between whole-stream systems in basins with managed versus unmanaged, late succession forests. Reaches ranged from 90-200 m and reaches within a reach pair were separated by a 90-325 m buffer section.
  • Metrics of habitat and productivity relative to fish and salamander biomass in nine stream reach pairs were collected. Considering differences among streams and between reaches within each stream, relationships between both biotic and abiotic covariates and the biomass of coastal cutthroat trout (Onchorhynchus clarkii clarkii), coastal giant salamanders (Dicamptodon tenebrosus) and total vertebrates (fish and salamanders) were evaluated.
  • Five of the six fish-bearing stream reach pairs originally surveyed by Murphy and Hall (1981) were visited to determine how stream conditions, benthic biofilms, invertebrate predators, and ultimately resident coastal cutthroat trout have responded to nearly four decades of riparian forest regeneration. Using the upstream reference reaches identified by Murphy (1979), which were bordered by old-growth riparian forests, this design is similar to a before-after control-impact study with riparian regeneration as the treatment. The same study reaches were sampled and evaluated how 40 years of riparian regeneration influenced our response variables.
  • Citation:
  • Kaylor, Matthew J.; Warren, Dana R. 2017. Linking riparian shade and the legacies of forest management to fish and vertebrate biomass in forested streams. Ecosphere. 8(6): e01845. doi: 10.1002/ecs2.1845
  • Kaylor, Matthew J.; Warren, Dana R. 2017. Canopy closure after four decades of postlogging riparian forest regeneration reduces cutthroat trout biomass in headwater streams through bottom-up pathways. Canadian Journal of Fisheries and Aquatic Sciences. {Volume}: 1-12. doi: 10.1139/cjfas-2016-0519
  • Murphy, M. L.; Hall, J. D. 1981. Varied effects of clear-cut logging on predators and their habitat in small streams of the Cascade mountains, Oregon. Canadian Journal of Fisheries and Aquatic Sciences. 38: 137-145.
  • Murphy, Michael Louis. 1979. Predator assemblages in old-growth and logged sections of small Cascade streams. Corvallis, OR: Oregon State University. 72 p. M.S. thesis.
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
  • Mack Creek
    W -122.16826200, E -122.14698900, N 44.22714600, S 44.20991900
  • Cook Creek, a tributary of Blue River upstream of Blue River reservoir and north of HJ Andrews
    W -122.26081030, E -122.26081030, N 44.27938900, S 44.27938900
  • Fritz Creek, a tributary of Deer Creek, which flows directly into the McKenzie River, NE of HJA
    W -122.07050800, E -122.07050800, N 44.26990600, S 44.26990600
  • Harvest block L701 on Lookout Creek
    W -122.15456910, E -122.15456910, N 44.23363100, S 44.23363100
  • Harvest block L703 on Lookout Creek
    W -122.12997610, E -122.12997610, N 44.22975000, S 44.22975000
  • Mack Creek. This site is part of an LTER fish study
    W -122.16668980, E -122.16668980, N 44.21876600, S 44.21876600
  • McRae Creek east tributary
    W -122.17007954, E -122.17007954, N 44.25482400, S 44.25482400
  • McRae Creek west tributary
    W -122.18074240, E -122.18074240, N 44.25496300, S 44.25496300
  • Harvest block L404 on McRae Creek
    W -122.19167490, E -122.19167490, N 44.24535600, S 44.24535600
  • Harvest block L504 on McRae Creek
    W -122.16977810, E -122.16977810, N 44.25554300, S 44.25554300
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: land use history (theme), stream ecology (theme), trophic dynamics (theme), light (theme), streams (theme), algae (theme), aquatic invertebrates (theme), salamanders (theme), trout (theme)
  • Andrews Experimental Forest site thesaurus: riparian ecosystems (theme)
Taxonomic Hierarchy
  • All Organisms: All Organisms
  • Highest common category (ca. kingdom): Animalia
  • Division or Phylum: Platyhelminthes
  • Class: Amphibia
  • Order: Urodela
  • Family: Dicamptodontidae
  • Genus: Dicamptodon
  • Species: Dicamptodon tenebrosus
  • Division or Phylum: Chordata
  • Class: Osteichthyes
  • Class: Actinopterygii
  • Order: Scorpaeniformes
  • Family: Cottidae
  • Genus: Cottus
  • Order: Salmoniformes
  • Family: Salmonidae
  • Genus: Oncorhyncus
  • Species: Oncorhyncus clarkii
  • Species: Oncorhyncus clarkii clarkii
  • Division or Phylum: Arthropoda
  • Class: Insecta
  • Order: Ephemeroptera
  • Family: Heptageniidae
  • Genus: Epeorus
  • Genus: Cinygmula
  • Genus: Cinygma
  • Genus: Ironodes
  • Genus: Rhithrogena
  • Genus: CInygma
  • Family: Baetidae
  • Genus: Baetis
  • Family: Leptophlebiidae
  • Genus: Paraleptophlebia
  • Family: Ameletidae
  • Genus: Ameletus
  • Family: Ephemerellidae
  • Genus: Drunella
  • Order: Trichoptera
  • Family: Uenoidae
  • Family: Rhyacophilidae
  • Genus: Rhyacophila
  • Family: Philopotamidae
  • Genus: Wormaldia
  • Family: Lepidostomatidae
  • Genus: Lepidostoma
  • Family: Limnephilidae
  • Genus: Neophylax
  • Family: Glossosomatidae
  • Genus: Glossosoma
  • Family: Brachycentridae
  • Genus: Micrasema
  • Family: Arctopsychidae
  • Genus: Parapsyche
  • Family: Polycentropodidae
  • Genus: Polycentropus
  • Family: Limniphilidae
  • Family: Hydropsychidae
  • Order: Plecoptera
  • Family: Leuctridae/Capniidae
  • Family: Perlidae
  • Genus: Hesperoperla
  • Genus: Doroneuria
  • Genus: Calineuria
  • Family: Nemouridae
  • Family: Chloroperlidae
  • Genus: Kathroperla
  • Genus: Sweltsa
  • Family: Peltoperlidae
  • Genus: Yoraperla
  • Family: Pteronarcidae
  • Genus: Pteronarcys
  • Family: Perlodidae
  • Genus: Megarcys
  • Family: Pteronarcyidae
  • Genus: Pteronarcella
  • Order: Diptera
  • Family: Thaumaleidae
  • Family: Empididae
  • Family: Dixidae
  • Genus: Ceratopogon
  • Family: Ceratopogonidae
  • Family: Tabanidae
  • Family: Tipulidae
  • Genus: Pedicia
  • Genus: Antocha
  • Genus: Dicranota
  • Genus: Hexatoma
  • Genus: Hesperoconopa
  • Family: Chironomidae
  • Genus: Tanypodinae
  • Family: Simuliidae
  • Family: Pelecorhychidae
  • Order: Coleoptera
  • Family: Dyticidae
  • Subfamily: Hydroporinae
  • Family: Psephenidae
  • Genus: Acneus
  • Family: Elmidae
  • Genus: Heterlimnius
  • Genus: Optioservus
  • Order: Megaloptera
  • Family: Corydalidae
  • Genus: Orohermes
  • Subphylum: Crustacea
  • Order: Cyclopoida
  • Subclass: Copepoda
  • Class: Arachnida
  • Subclass: Acari
  • Class: Ostracoda
  • Division or Phylum: Nematoda
  • Division or Phylum: Mollusca
  • Class: Gastrapoda
Data Entities
# Entity Metadata Data
1 AS01001
AS01001
Fish and salamander surveys:
 METADATA DATA
2 AS01002
AS01002
Invertebrate raw data (ID and measurements) from surber sample surveys:
 METADATA DATA
3 AS01003
AS01003
Transect data for each site:
 METADATA DATA
4 AS01004
AS01004
Large wood measurements for each site:
 METADATA DATA
5 AS01005
AS01005
Measurements of pools for each site:
 METADATA DATA
Metadata
AS01001 - AS01001

Object name: AS01001.csv

Records: 3971

Attributes: 13

Temporal coverage: 2014-08-04 to 2014-09-05

File size: 214116 byte

Checksum (MD5): ab16e7eaba1967bc4e26a4cf861718a6

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

Constraints (2)
  • primaryKey: PRIMARY
    AS01001.DATE, AS01001.REACH_TYPE, AS01001.SURVEY_METHOD, AS01001.SITE, AS01001.SPECIES, AS01001.SPP_LIFESTAGE, AS01001.VERT_NO
  • notNullConstraint: NOTNULL
    AS01001.DATE, AS01001.DBCODE, AS01001.ENTITY, AS01001.MARKED_UNMARKED, AS01001.REACH_TYPE, AS01001.SURVEY_METHOD, AS01001.SITE, AS01001.SPECIES, AS01001.SPP_LIFESTAGE, AS01001.VERT_NO
Attributes (13)
DBCODE - char(5) (nominal)

ID: AS01001.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: AS01001.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)

SITE - char(6) (ordinal)

ID: AS01001.SITE

Site of survey

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • COOK
    Cook Creek, a tributary of Blue River upstream of Blue River reservoir and north of HJ Andrews
  • FRITZ
    Fritz Creek, a tributary of Deer Creek, which flows directly into the McKenzie River, NE of HJA
  • LO701
    Harvest block L701 on Lookout Creek
  • LO703
    Harvest block L703 on Lookout Creek
  • MACK
    Mack Creek. This site is part of an LTER fish study
  • MCT_E
    McRae Creek east tributary
  • MCT_W
    McRae Creek west tributary
  • MR404
    Harvest block L404 on McRae Creek
  • STR
    Harvest block L504 on McRae Creek
REACH_TYPE - char(2) (nominal)

ID: AS01001.REACH_TYPE

Riparian forest type (SG for second growth; OG for old-growth)

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • OG
    Old-growth. The riparian forest is bordered by old-growth on both sides of the stream
  • SG
    Second-growth. The riparian forest is bordered by second growth on at least one side of the stream.
DATE - datetime (dateTime)

ID: AS01001.DATE

Date of survey

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

SURVEY_METHOD - char(5) (nominal)

ID: AS01001.SURVEY_METHOD

Indicates the type of survey used and the round or pass within the survey

Type system: Microsoft SQL Server 2008

Code definitions (6)
  • M
    The "Mark" round of sampling indicating the first sampling out of two in which fish/salamanders are captured and marked with a small clip.
  • R
    The "Recapture" round of sampling indicationg the second out of two in which fish/salamanders are captured and checked for marks from the previous survey.
  • P1
    The first pass in multiple-pass depletion surveys. Typically out of 3 successive, equal effort passes (sometimes 4).
  • P2
    The second pass in multiple-pass depletion surveys. Typically out of 3 successive, equal effort passes (sometimes 4).
  • P3
    The third pass in multiple-pass depletion surveys. Typically out of 3 successive, equal effort passes (sometimes 4).
  • P4
    The fourth pass in multiple-pass depletion surveys. Typically out of 3 successive, equal effort passes (sometimes 4).
MARKED_UNMARKED - char(1) (nominal)

ID: AS01001.MARKED_UNMARKED

Indicates whether the fish was marked (M) or unmarked (U) during recapture surveys

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • M
    This indicates that during the recapture survey of a mark-recapture population estimate survey, this individual was marked (M).
  • U
    This indicates that during the recapture survey of a mark-recapture population estimate survey, this individual was not marked (U).
  • N
    This individual was part of a multiple pass depletion survey and not a recapture survey of a mark-recapture population estimate survey.
VERT_NO - numeric(3,0) (ratio)

ID: AS01001.VERT_NO

unique vertebrate number by site, reach and date

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SPECIES - char(4) (ordinal)

ID: AS01001.SPECIES

Species code

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • COTT
    Cottus
  • ONCL
    Oncorhyncus clarkii clarkii
  • DITE
    Dicamptodon tenebrosus
SPP_LIFESTAGE - char(1) (nominal)

ID: AS01001.SPP_LIFESTAGE

lifestage information about species

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • A
    Adult coastal cutthroat trout (Oncorhynchus clarkii clarkii)
  • J
    Juvenile (Young-of-year) coastal cutthroat trout (< 1 year old)
  • N
    Not noted for Coastal giant salamander (Dicamptodon tenebrosus) or Sculpin (Cottus spp.)
VENT_LENGTH - numeric(3,0) (ratio)

ID: AS01001.VENT_LENGTH

Vent length of salamanders

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

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

TAIL_LENGTH - numeric(3,0) (ratio)

ID: AS01001.TAIL_LENGTH

Tail length of fish

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

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

WEIGHT - numeric(6,2) (ratio)

ID: AS01001.WEIGHT

Weight

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 1

Numeric domain: type=real, min=0.0200 (exclusive=false), max=122.0900 (exclusive=false)

AS01002 - AS01002

Object name: AS01002.csv

Records: 8741

Attributes: 16

Temporal coverage: 2014-07-10 to 2014-07-29

File size: 798673 byte

Checksum (MD5): b2328ac0b2ea6a67d61c7d1d0fe34078

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

Constraints (2)
  • primaryKey: PRIMARY
    AS01002.DATE, AS01002.REACH_TYPE, AS01002.SITE, AS01002.INVERT_NO
  • notNullConstraint: NOTNULL
    AS01002.SUBSAMPLE_AREA, AS01002.CONVERTED_LENGTH, AS01002.DATE, AS01002.DBCODE, AS01002.ENTITY, AS01002.INV_LIFESTAGE, AS01002.INVERT_LENGTH, AS01002.LR_SUB, AS01002.MAG, AS01002.SUBSAMPLE_PROPORTION, AS01002.REACH_TYPE, AS01002.SITE, AS01002.TAXA, AS01002.TAXA_RANK, AS01002.TOT_CNT, AS01002.INVERT_NO
Attributes (16)
DBCODE - char(5) (nominal)

ID: AS01002.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: AS01002.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)

SITE - char(6) (ordinal)

ID: AS01002.SITE

Site of survey

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • COOK
    Cook Creek, a tributary of Blue River upstream of Blue River reservoir and north of HJ Andrews
  • FRITZ
    Fritz Creek, a tributary of Deer Creek, which flows directly into the McKenzie River, NE of HJA
  • LO701
    Harvest block L701 on Lookout Creek
  • LO703
    Harvest block L703 on Lookout Creek
  • MACK
    Mack Creek. This site is part of an LTER fish study
  • MCT_E
    McRae Creek east tributary
  • MCT_W
    McRae Creek west tributary
  • MR404
    Harvest block L404 on McRae Creek
  • STR
    Harvest block L504 on McRae Creek
REACH_TYPE - char(2) (nominal)

ID: AS01002.REACH_TYPE

Riparian forest type (SG for second growth; OG for old-growth)

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • OG
    Old-growth. The riparian forest is bordered by old-growth on both sides of the stream
  • SG
    Second-growth. The riparian forest is bordered by second growth on at least one side of the stream.
DATE - datetime (dateTime)

ID: AS01002.DATE

Date of survey

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

INVERT_NO - numeric(4,0) (ratio)

ID: AS01002.INVERT_NO

unique invertebrate number by site, reach and date

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

LR_SUB - char(3) (nominal)

ID: AS01002.LR_SUB

Large/rare or subsample

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • SUB
    Indicates that the invertebrate in this row was within the subsample
  • LR
    Indicates that the invertebrate was picked during the 60 second large-rare survey after the initial subsampling to 500 species limit.
SUBSAMPLE_AREA - numeric(6,4) (ratio)

ID: AS01002.SUBSAMPLE_AREA

Area of subsample

Type system: Microsoft SQL Server 2008

Unit: square meters

Precision: 1

Numeric domain: type=real, min=0.0469 (exclusive=false), max=0.3750 (exclusive=false)

SUBSAMPLE_PROPORTION - numeric(6,4) (ratio)

ID: AS01002.SUBSAMPLE_PROPORTION

Proportion of total area sampled

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

TAXA - varchar(30) (ordinal)

ID: AS01002.TAXA

taxonomic classification identified to the finest taxonomic rank

Type system: Microsoft SQL Server 2008

Code definitions (78)
  • Acari
    Acari
  • Copepoda
    Copepoda
  • Ostracoda
    Ostracoda
  • Acneus
    Acneus
  • Ameletus
    Ameletus
  • Antocha
    Antocha
  • Baetis
    Baetis
  • Calineuria
    Calineuria
  • Cinygma
    Cinygma
  • Cinygmula
    Cinygmula
  • Dicranota
    Dicranota
  • Doroneuria
    Doroneuria
  • Drunella
    Drunella
  • Epeorus
    Epeorus
  • Glossosoma
    Glossosoma
  • Hesperoperla
    Hesperoperla
  • Ironodes
    Ironodes
  • Kathroperla
    Kathroperla
  • Lepidostoma
    Lepidostoma
  • Megarcys
    Megarcys
  • Micrasema
    Micrasema
  • Neophylax
    Neophylax
  • Orohermes
    Orohermes
  • Paraleptophlebia
    Paraleptophlebia
  • Parapsyche
    Parapsyche
  • Pedicia
    Pedicia
  • Polycentropus
    Polycentropus
  • Pteronarcys
    Pteronarcys
  • Rhithrogena
    Rhithrogena
  • Rhyacophila
    Rhyacophila
  • Sweltsa
    Sweltsa
  • Trichoptera
    Trichoptera
  • Wormaldia
    Wormaldia
  • Yoraperla
    Yoraperla
  • Limniphilidae
    Limniphilidae
  • Tabanidae
    Tabanidae
  • Ephemerellidae
    Ephemerellidae
  • Ephemeroptera
    Ephemeroptera
  • Plecoptera
    Plecoptera
  • Baetidae
    Baetidae
  • Brachycentridae
    Brachycentridae
  • Ceratopogonidae
    Ceratopogonidae
  • Chironomidae
    Chironomidae
  • Chloroperlidae
    Chloroperlidae
  • Corydalidae
    Corydalidae
  • Dixidae
    Dixidae
  • Elmidae
    Elmidae
  • Empididae
    Empididae
  • Glossosomatidae
    Glossosomatidae
  • Heptageniidae
    Heptageniidae
  • Hydropsychidae
    Hydropsychidae
  • Lepidostomatidae
    Lepidostomatidae
  • Leptophlebiidae
    Leptophlebiidae
  • Nemouridae
    Nemouridae
  • Peltoperlidae
    Peltoperlidae
  • Perlidae
    Perlidae
  • Perlodidae
    Perlodidae
  • Philopotamidae
    Philopotamidae
  • Polycentropodidae
    Polycentropodidae
  • Rhyacophilidae
    Rhyacophilidae
  • Simuliidae
    Simuliidae
  • Thaumaleidae
    Thaumaleidae
  • Tipulidae
    Tipulidae
  • Uenoidae
    Uenoidae
  • CInygma
    CInygma
  • Optioservus
    Optioservus
  • Hexatoma
    Hexatoma
  • Cyclopoida
    Cyclopoida
  • Nematoda
    Nematoda
  • Heterlimnius
    Heterlimnius
  • Pteronarcella
    Pteronarcella
  • Tanypodinae
    Tanypodinae
  • Hesperoconopa
    Hesperoconopa
  • Leuctridae/Capniidae
    Leuctridae/Capniidae
  • Pelecorhychidae
    Pelecorhychidae
  • Hydroporinae
    Hydroporinae
  • Gastrapoda
    Gastrapoda
  • Platyhelminthes
    Platyhelminthes
TAXA_RANK - char(10) (ordinal)

ID: AS01002.TAXA_RANK

finest taxonomic resolution of identified invertebrate

Type system: Microsoft SQL Server 2008

Code definitions (7)
  • PHYLUM
    Invertebrate identified to Phylum
  • CLASS
    Invertebrate identified to Class
  • SUBCLASS
    Invertebrate identified to Sub-Class
  • ORDER
    Invertebrate identified to Order
  • FAMILY
    Invertebrate identified to Family
  • GENUS
    Invertebrate identified to Genus
  • SUBFAMILY
    Invertebrate identified to Sub-Family
INV_LIFESTAGE - char(1) (ordinal)

ID: AS01002.INV_LIFESTAGE

Life stage of invertebrate

Type system: Microsoft SQL Server 2008

Code definitions (4)
  • A
    Adult
  • L
    Larvae
  • P
    Pupae
  • N
    Not noted
MAG - numeric(4,2) (ratio)

ID: AS01002.MAG

Magnification of microscope

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

INVERT_LENGTH - numeric(4,1) (ratio)

ID: AS01002.INVERT_LENGTH

Length of inverebrate under magnification

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

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

CONVERTED_LENGTH - numeric(5,2) (ratio)

ID: AS01002.CONVERTED_LENGTH

Length of invertebrate after correcting for magnifcation

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

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

TOT_CNT - numeric(2,0) (ratio)

ID: AS01002.TOT_CNT

Number of invertebrates with this length

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

AS01003 - AS01003

Object name: AS01003.csv

Records: 198

Attributes: 12

Temporal coverage: 2014-07-01 to 2014-09-08

File size: 14768 byte

Checksum (MD5): b422920605b01ab0119d9491fb902187

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

Constraints (2)
  • primaryKey: PRIMARY
    AS01003.DATE, AS01003.METER, AS01003.REACH_TYPE, AS01003.SITE
  • notNullConstraint: NOTNULL
    AS01003.BANKFULL_WIDTH, AS01003.DATE, AS01003.DATE_DEPLOYED_TILES, AS01003.DATE_RETRIEVED_TILES, AS01003.DBCODE, AS01003.ENTITY, AS01003.METER, AS01003.REACH_TYPE, AS01003.SITE, AS01003.WETTED_WIDTH
Attributes (12)
DBCODE - char(5) (nominal)

ID: AS01003.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: AS01003.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)

SITE - char(6) (ordinal)

ID: AS01003.SITE

Site of survey

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • COOK
    Cook Creek, a tributary of Blue River upstream of Blue River reservoir and north of HJ Andrews
  • FRITZ
    Fritz Creek, a tributary of Deer Creek, which flows directly into the McKenzie River, NE of HJA
  • LO701
    Harvest block L701 on Lookout Creek
  • LO703
    Harvest block L703 on Lookout Creek
  • MACK
    Mack Creek. This site is part of an LTER fish study
  • MCT_E
    McRae Creek east tributary
  • MCT_W
    McRae Creek west tributary
  • MR404
    Harvest block L404 on McRae Creek
  • STR
    Harvest block L504 on McRae Creek
REACH_TYPE - char(2) (nominal)

ID: AS01003.REACH_TYPE

Riparian forest type (SG for second growth; OG for old-growth)

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • OG
    Old-growth. The riparian forest is bordered by old-growth on both sides of the stream
  • SG
    Second-growth. The riparian forest is bordered by second growth on at least one side of the stream.
DATE - datetime (dateTime)

ID: AS01003.DATE

Date of survey

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

METER - numeric(3,0) (ratio)

ID: AS01003.METER

Location of transect. Meter 0 is the upstream end of the reach.

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

Numeric domain: type=whole, min=0.0000 (exclusive=false), max=430.0000 (exclusive=false)

BANKFULL_WIDTH - numeric(4,1) (ratio)

ID: AS01003.BANKFULL_WIDTH

Bankfull width of transect

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

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

WETTED_WIDTH - numeric(3,1) (ratio)

ID: AS01003.WETTED_WIDTH

Wetted width of transect

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

Numeric domain: type=real, min=0.5000 (exclusive=false), max=9.6000 (exclusive=false)

CANOPY_COVER - numeric(6,2) (ratio)

ID: AS01003.CANOPY_COVER

Canopy cover

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1

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

DATE_DEPLOYED_TILES - datetime (dateTime)

ID: AS01003.DATE_DEPLOYED_TILES

Date ceramic tiles were put in streams

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

DATE_RETRIEVED_TILES - datetime (dateTime)

ID: AS01003.DATE_RETRIEVED_TILES

Date ceramic tiles were collected from streams

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

CHL_A_TILES - numeric(4,2) (ratio)

ID: AS01003.CHL_A_TILES

Chlorophyll a on ceramic tiles after 6 week deployment

Type system: Microsoft SQL Server 2008

Unit: micrograms per squared centimeter

Precision: 1

Numeric domain: type=real, min=0.0050 (exclusive=false), max=2.9500 (exclusive=false)

AS01004 - AS01004

Object name: AS01004.csv

Records: 550

Attributes: 9

Temporal coverage: 2014-07-01 to 2014-10-07

File size: 23925 byte

Checksum (MD5): e1b8bf8b03a1d2961a680593b45d34e0

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

Constraints (2)
  • primaryKey: PRIMARY
    AS01004.DATE, AS01004.REACH_TYPE, AS01004.SITE, AS01004.WOOD_PIECE
  • notNullConstraint: NOTNULL
    AS01004.DATE, AS01004.DBCODE, AS01004.DIAMETER_1, AS01004.DIAMETER_2, AS01004.ENTITY, AS01004.REACH_TYPE, AS01004.SITE, AS01004.WOOD_PIECE, AS01004.WOOD_LENGTH
Attributes (9)
DBCODE - char(5) (nominal)

ID: AS01004.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: AS01004.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)

SITE - char(6) (ordinal)

ID: AS01004.SITE

Site of survey

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • COOK
    Cook Creek, a tributary of Blue River upstream of Blue River reservoir and north of HJ Andrews
  • FRITZ
    Fritz Creek, a tributary of Deer Creek, which flows directly into the McKenzie River, NE of HJA
  • LO701
    Harvest block L701 on Lookout Creek
  • LO703
    Harvest block L703 on Lookout Creek
  • MACK
    Mack Creek. This site is part of an LTER fish study
  • MCT_E
    McRae Creek east tributary
  • MCT_W
    McRae Creek west tributary
  • MR404
    Harvest block L404 on McRae Creek
  • STR
    Harvest block L504 on McRae Creek
REACH_TYPE - char(2) (nominal)

ID: AS01004.REACH_TYPE

Riparian forest type (SG for second growth; OG for old-growth)

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • OG
    Old-growth. The riparian forest is bordered by old-growth on both sides of the stream
  • SG
    Second-growth. The riparian forest is bordered by second growth on at least one side of the stream.
DATE - datetime (dateTime)

ID: AS01004.DATE

Date of survey

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

WOOD_PIECE - numeric(3,0) (ratio)

ID: AS01004.WOOD_PIECE

unique number for piece of wood sampled

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

DIAMETER_1 - numeric(3,0) (ratio)

ID: AS01004.DIAMETER_1

Diameter at one end of the piece of wood

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

DIAMETER_2 - numeric(3,0) (ratio)

ID: AS01004.DIAMETER_2

Diameter at the other end

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

WOOD_LENGTH - numeric(4,0) (ratio)

ID: AS01004.WOOD_LENGTH

Length of the piece of wood

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

AS01005 - AS01005

Object name: AS01005.csv

Records: 172

Attributes: 11

Temporal coverage: 2014-07-01 to 2014-10-07

File size: 8616 byte

Checksum (MD5): 4729a2bb05f8e6fa0552acf516acd997

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

Constraints (2)
  • primaryKey: PRIMARY
    AS01005.DATE, AS01005.POOL_NO, AS01005.REACH_TYPE, AS01005.SITE
  • notNullConstraint: NOTNULL
    AS01005.DATE, AS01005.DBCODE, AS01005.ENTITY, AS01005.DEPTH_MAX, AS01005.DEPTH_OUTFLOW, AS01005.POOL_NO, AS01005.REACH_TYPE, AS01005.DEPTH_RESIDUAL, AS01005.SITE, AS01005.WIDTH, AS01005.POOL_LENGTH
Attributes (11)
DBCODE - char(5) (nominal)

ID: AS01005.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: AS01005.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)

SITE - char(6) (ordinal)

ID: AS01005.SITE

Site of survey

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • COOK
    Cook Creek, a tributary of Blue River upstream of Blue River reservoir and north of HJ Andrews
  • FRITZ
    Fritz Creek, a tributary of Deer Creek, which flows directly into the McKenzie River, NE of HJA
  • LO701
    Harvest block L701 on Lookout Creek
  • LO703
    Harvest block L703 on Lookout Creek
  • MACK
    Mack Creek. This site is part of an LTER fish study
  • MCT_E
    McRae Creek east tributary
  • MCT_W
    McRae Creek west tributary
  • MR404
    Harvest block L404 on McRae Creek
  • STR
    Harvest block L504 on McRae Creek
REACH_TYPE - char(2) (nominal)

ID: AS01005.REACH_TYPE

Riparian forest type (SG for second growth; OG for old-growth)

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • OG
    Old-growth. The riparian forest is bordered by old-growth on both sides of the stream
  • SG
    Second-growth. The riparian forest is bordered by second growth on at least one side of the stream.
DATE - datetime (dateTime)

ID: AS01005.DATE

Date of survey

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

POOL_NO - numeric(3,0) (ratio)

ID: AS01005.POOL_NO

unique number for pool sampled

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

DEPTH_MAX - numeric(3,0) (ratio)

ID: AS01005.DEPTH_MAX

The maximum depth of this pool

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

DEPTH_OUTFLOW - numeric(2,0) (ratio)

ID: AS01005.DEPTH_OUTFLOW

The depth at the outflow of this pool

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

DEPTH_RESIDUAL - numeric(2,0) (ratio)

ID: AS01005.DEPTH_RESIDUAL

The difference between maximum depth and residual depth

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

POOL_LENGTH - numeric(4,0) (ratio)

ID: AS01005.POOL_LENGTH

Length of the pool (parallel to stream flow)

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

WIDTH - numeric(4,0) (ratio)

ID: AS01005.WIDTH

Width of the pool (perpendicular to stream flow)

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

Units
grams g mass gram kilogram 0.001 grams; 0.001 kilogram
square meters m2 area meterSquared meterSquared 1 square meters
millimeters mm length millimeter meter 0.001 millimeters; .001 meters
percent % dimensionless number dimensionless 100 percent; a number
micrograms per squared centimeter ug/cm2 arealMassDensity microgramPerCentimeterSquared kilogramPerMeterSquared 0.00001 micrograms per squared centimeter
meters m length meter meter 1 meter; SI unit of length
number number dimensionless number dimensionless 1 dimensionless number, i.e., ratio, count
centimeters cm length centimeter meter 0.01 centimeters; .01 meters
Related Datasets

No related dataset codes found in the EML text fields.

Related Publications
  • Murphy, M. L.; Hall, J. D. 1981. Varied effects of clear-cut logging on predators and their habitat in small streams of the Cascade mountains, Oregon. Canadian Journal of Fisheries and Aquatic Sciences. 38: 137-145.
  • Murphy, Michael Louis. 1979. Predator assemblages in old-growth and logged sections of small Cascade streams. Corvallis, OR: Oregon State University. 72 p. M.S. thesis.
  • Kaylor, Matthew J.; Warren, Dana R. 2017. Linking riparian shade and the legacies of forest management to fish and vertebrate biomass in forested streams. Ecosphere. 8(6): e01845. doi: 10.1002/ecs2.1845
  • Kaylor, Matthew J.; Warren, Dana R. 2017. Canopy closure after four decades of postlogging riparian forest regeneration reduces cutthroat trout biomass in headwater streams through bottom-up pathways. Canadian Journal of Fisheries and Aquatic Sciences. {Volume}: 1-12. doi: 10.1139/cjfas-2016-0519
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 (2014-06-12)
    Study code and preliminary metadata established
  • Version2 (2019-06-12)
    Original creation of entity. Imported metadata using move_xls, created data structures, appended data, made necessary modifications. Ran QC and uploaded data.
  • Version3 (2019-06-18)
    Updated an invalid longitude value for MCT_E in place_keyword.