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

SA022: Headwater Stream Macroinvertebrates of the H.J. Andrews Experimental Forest, Oregon, 2003-2004

← Back to catalog index

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

Status: notPlanned
Period: 2003-01-06 to 2004-06-30
Version: 8
Published: 2019-06-10
EDI Package ID: knb-lter-and.4345.8
Source XML: SA022_8.xml

Notice

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

Citation

Johnson, S.; Frady, C. 2019. Headwater Stream Macroinvertebrates of the H.J. Andrews Experimental Forest, Oregon, 2003-2004 Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/SA022 Accessed 2026-05-10.

Abstract

Recent studies of headwater streams have demonstrated their importance to overall watershed biodiversity, nutrient cycling, and energy flux. However, little attention has been paid to long-term effects of forest harvest on macroinvertebrate communities in headwater streams. This study investigated headwater stream macroinvertebrate communities in the H.J. Andrews Experimental Forest, Oregon, U.S.A and used a paired-stream study design to examine if long term legacies of prior forest harvest existed for communities of stream macroinvertebrates. This study also examined correlations of macroinvertebrate life-history traits with site physical variables.

Coverage

Temporal coverage: 2003-01-06 to 2004-06-30

Geographic coverage: H.J. Andrews Experimental Forest

Spatial coverage:

Bounds: W -122.25683100, E -122.17079300, N 44.26974800, S 44.19901700

Purpose
  • This study was designed to evaluate if long term signals of prior forest harvest exist between paired basins for macroinvertebrate species and communities.
  • Results from this study suggest that neither richness nor densities differed between streams flowing through young growth versus old growth forests. Despite similarities among these metrics, multivariate ordination techniques helped elucidate slight differences in benthic community composition between paired streams when red alder was present in riparian zones of previously harvested basins. Indicator Species Analysis of community composition and abundance revealed that no taxa were exclusively indicative of either forest type.
  • Macroinvertebrate life-history traits among headwater streams were related to stream size, stream substrates, or stream discharge. Macroinvertebrates that ingest leaf litter (shredders) decreased at sites with increasing stream width, while macroinvertebrates that scrape off algae and biofilms from instream substrates (scrapers) increased with increasing stream width. Differences in macroinvertebrate habit-trait groups were related to differences in stream substrates or stream discharge between very small headwater streams (less than 20 ha basin area) and larger headwater streams (50-100 ha basin size). Seasonal variation in stream discharge also influenced macroinvertebrate communities.
  • Patterns in adult insect emergence in these streams displayed pulses of activity that varied among streams. During summer 2003, total emergence was greatest in one high elevation stream in this study. During spring 2004, total emergence began earlier in one low elevation and one mid elevation stream, but linkages with stream water temperature were tenuous; cumulative emergence remained higher in these streams than all others through early summer 2004. Although forest harvest can often have effects on macroinvertebrate communities, differences in community composition may persist long-term if regrowth of riparian vegetation includes shifts to other species, such as red alder (Alnus rubra).
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
  • Sherri L. Johnson
    Role: Principal Investigator
    US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: 541-758-7771
    Email: sherri.johnson2@usda.gov, sherri.johnson@oregonstate.edu
  • Sherri L. Johnson
    Role: Creator
    US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: 541-758-7771
    Email: sherri.johnson2@usda.gov, sherri.johnson@oregonstate.edu
  • Judith L. Li
    Role: Other Researcher
    Oregon State University;Dept. of Fisheries & Wildlife;104 Nash Hall, Corvallis, OR, 97331, USA
    Phone: (541) 737-1093
    Email: judyli@comcast.net, judith.li@oregonstate.edu
  • Charles H Frady
    Role: Method Contact
    Twisp, WA, USA
    Phone: 541-738-6905
    Email: fradychf@dfw.wa.gov
  • Charles H Frady
    Role: Creator
    Twisp, WA, USA
    Phone: 541-738-6905
    Email: fradychf@dfw.wa.gov
Contact
Publisher
  • Andrews Forest LTER Site
    Role: Publisher
    Forest Ecosystems and Society Department in Forestry, Oregon State University, 201K Richardson Hall, Corvallis, OR, 97331-5752
    Phone: (541) 737-8480
    Email: lterweb@fsl.orst.edu
Study Description

Recent studies of headwater streams have demonstrated their importance to overall watershed biodiversity, nutrient cycling, and energy flux. However, little attention has been paid to long-term effects of forest harvest on macroinvertebrate communities in headwater streams. This study investigated headwater stream macroinvertebrate communities in the H.J. Andrews Experimental Forest, Oregon, U.S.A and used a paired-stream study design to examine if long term legacies of prior forest harvest existed for communities of stream macroinvertebrates. This study also examined correlations of macroinvertebrate life-history traits with site physical variables. This study was designed to evaluate if long term signals of prior forest harvest exist between paired basins for macroinvertebrate species and communities. Field Methods - SA022

Purpose: This study was designed to evaluate if long term signals of prior forest harvest exist between paired basins for macroinvertebrate species and communities.

Methods

Method Steps

Field Methods - SA022
  • Instream and riparian attributes were measured at the time of benthic sampling. Six transects, perpendicular to stream flow, were established in study reaches and wetted stream widths were measured at each transect. At 11 points across each transect stream depths were measured and substrate types recorded. Substrate type was characterized by size as silt, sand, gravel, cobble, boulder, bedrock, or wood (modified from Wolman 1954). Percent canopy cover was measured using a canopy densiometer mid-channel at each transect with the observer facing upstream, downstream, right, and left (Platts et al. 1987). For each reach, average proportion of substrate type and average percent canopy cover were calculated. Composition of overstory and understory riparian vegetation was noted within 5 m of the stream. Allochthonous litterfall was collected continuously from July through October 2003. At each site, six litter traps, circular baskets (0.12 m) with 0.6 mm mesh nets, were placed along the edges of the stream. Leaf litter was collected monthly, dried at 60ºC for 24-36 hours, and weighed. Litter was categorized as red alder leaves, other deciduous leaves, conifer needles, or miscellaneous (catkins, cones, lichens, and twigs).
  • Benthic sampling was conducted four times and during periods of relatively stable stream flow; June 2003, November 2003, March 2004, and May 2004. Emerging macroinvertebrates were collected a total of 13 times; at the time of benthic sampling, at midpoints between benthic samples in 2004, and approximately 3-week intervals during the summer and early fall 2003. Locations of benthic sampling were randomized within study reaches at each sample date; emergence sample locations were only randomized once at the start of the study. On each sampling date, six benthic samples were collected per reach. All samples were taken with a 0.25 mm mesh Surber sampler (0.093 m) in riffle/cascade stream units on substrates ranging from silt to cobble. Four 0.25 m emergence traps, consisting of PVC frames draped with 0.6 mm mesh nets, were set over the stream bed and left in place for 6-8 days and then sampled. A small amount of unscented, biodegradable soap was added to the water in emergence trap collecting cups to decrease surface tension; in cold weather, rock salt was added to serve as both an antifreeze and a preservative agent. When invertebrates were collected, they were sieved through 0.25 mm mesh and stored in 95% ethanol. Emergence rates were calculated as densities of invertebrates collected in traps during each 6-8 day collection interval and expressed as number of individuals.m.day.
Laboratory Methods - SA022
  • All insects were identified to genus when possible (Brown 1972, McAlpine et al. 1981, Stewart and Stark 1993, Merritt and Cummins 1996, Wiggins 1996). Individuals of the family Chironomidae were identified to sub-family or tribe in benthic samples, and family level in emergence samples. Non-insects were typically identified to order (Thorp and Covich 1991). Young-instar insects and individuals damaged during sampling or storage were identified to the lowest taxonomic resolution possible, typically order or family. All individuals in each sample were identified, and benthic macroinvertebrates were assigned to functional feeding groups (Merritt and Cummins 1996, Wiggins 1996).
Statistical Methods - SA022
  • Benthic and emergent taxa richness were calculated as the sum of all taxa present at that site on a particular date. Benthic and shredder densities were natural log transformed before parametric analyses. This study used Indicator Species Analysis to identify taxa strongly correlated to forest type or season (Dufrene and Legendre 1997) (PC-ORD 4 software). This technique creates indicator values (from 0 to 100, 100 being a perfect indicator) for all taxa by combining values of relative abundance and relative frequency; significance of group membership was determined through 1000 Monte Carlo simulations. Species were included for consideration of strong indicators for a forest type if they met the following conditions: 1) they were represented in at least two of three streams of a forest type, 2) they were collected during at least two seasons, and 3) at least 25 total individuals of a given taxa were collected.
Taxonomic Procedures - SA022
  • Publications were consulted for species identification.
Algorithms - SA022
  • (number/m) is calculated by the number of benthic individuals in surber / surber size (0.093 m).
  • (number per m per day) is calculated by the number of individuals emerging from trap during sampling interval / trap size (0.25 m) / trap duration.

Sampling

Study Extent
  • Sampling frequency: through seasons of one year
Sampling Description
  • To assess benthic and emergent macroinvertebrate taxa richness, densities, and community composition, six perennial, headwater, fishless streams within the 6400 ha Andrews Forest, which occupies the entire Lookout Creek Watershed, were repeatedly sampled (Figure 1, Frady et al. 2007). Study reaches were 50 m long and located upstream of stream gages and access roads, except in Watershed (WS) 2. Stage height and stream temperature were measured in the gaged basins of WS-1, 2, 7, and 8 and discharge data are available on the Andrews web pages (http://andlter.forestry.oregonstate.edu/data/abstract.aspx?dbcode=HF004). Basins were paired by elevation, aspect, basin area, discharge and geology. Each pair contained one basin that had been harvested 30-40 years previously (YG) and an adjacent basin with old growth conifer forest cover (OG) (Table 1, Frady et al. 2007). WS-1 and WS-A were clearcut logged in the 1960s and burned following harvest. WS-7 was harvested by overstory thinning in 1974 and 1984. Basins were replanted with Douglas-fir after harvest (Martin and Harr 1989).
Spatial Sampling Units
  • Andrews Watershed 1
    W -122.25683100, E -122.23581300, N 44.20851700, S 44.19901700
    Altitude: 1027 to 1027 meter
  • Andrews Watershed 2
    W -122.24397600, E -122.22974100, N 44.21338500, S 44.20617800
    Altitude: 1079 to 1079 meter
  • Andrews Watershed 7
    W -122.17920900, E -122.17387500, N 44.26974800, S 44.26457900
    Altitude: 1102 to 1102 meter
  • Andrews Watershed 8
    W -122.17079300, E -122.17079300, N 44.26629400, S 44.26588100
    Altitude: 1182 to 1182 meter
  • Andrews Experimental Forest (HJA)
    W -122.26172200, E -122.10084700, N 44.28196400, S 44.19770400
    Altitude: 1631 to 1631 meter
  • New Belgium Creek Watershed
    W -122.17727000, E -122.17727000, N 44.22407000, S 44.22407000
  • Anderson Creek Watershed
    W -122.18315000, E -122.18315000, N 44.22776000, S 44.22776000
  • HJA Phenology Emergence Site 1 (WS01 stream)
    W -122.25750000, E -122.25750000, N 44.20700000, S 44.20700000
    Altitude: 457 to 457 meter
  • HJA Phenology Emergence Site 2 (WS02 stream)
    W -122.24930000, E -122.24930000, N 44.21450000, S 44.21450000
    Altitude: 487 to 487 meter
  • HJA Phenology Emergence Site 3 (WS08 stream)
    W -122.17070000, E -122.17070000, N 44.26640000, S 44.26640000
    Altitude: 959 to 959 meter
  • HJA Phenology Emergence Site 4 (WS07 stream)
    W -122.17560000, E -122.17560000, N 44.26510000, S 44.26510000
    Altitude: 940 to 940 meter
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: populations (theme), community dynamics (theme), species richness (theme), long term monitoring (theme), timber harvest (theme), aquatic ecosystems (theme), invertebrates (theme), aquatic invertebrates (theme), arthropods (theme), insects (theme), macroinvertebrates (theme), vegetation (theme)
  • Andrews Experimental Forest site thesaurus: riparian ecosystems (theme), long term studies (theme)
  • LTER core research areas: populations (theme)
Taxonomic Hierarchy
  • All Organisms: All Organisms
  • Highest common category (ca. kingdom): Plantae
  • Division or Phylum: Magnoliophyta
  • Class: Magnoliopsida
  • Subclass: Dilleniidae
  • Order: Ericales
  • Family: Ericaceae
  • Genus: Vaccinium
  • Species: Vaccinium parvifolium
  • Subclass: Hamamelididae
  • Order: Fagales
  • Family: Betulaceae
  • Genus: Alnus
  • Species: Alnus rubra
  • Subclass: Rosidae
  • Order: Sapindales
  • Family: Aceraceae
  • Genus: Acer
  • Species: Acer circinatum
  • Species: Acer macrophyllum
  • Division or Phylum: Coniferophyta
  • Class: Pinopsida
  • Order: Pinales
  • Family: Cupressaceae
  • Genus: Thuja
  • Species: Thuja plicata
  • Family: Pinaceae
  • Genus: Pseudotsuga
  • Species: Pseudotsuga menziesii
  • Genus: Tsuga
  • Species: Tsuga heterophylla
  • Highest common category (ca. kingdom): Animalia
  • Family: Pisidiidae
  • Division or Phylum: Tardigrada
  • Division or Phylum: Nematomorpha
  • Family: Hydroidolina
  • Order: Veneroida
  • Division or Phylum: Arthropoda
  • Subphylum: Crustacea
  • Class: Malacostraca
  • Order: Decapoda
  • Order: Amphipoda
  • Family: Astacidae
  • Genus: Pacifastacus
  • Order: Anomopoda
  • Family: Chydoridae
  • Order: Cyclopoida
  • Order: Harpacticoida
  • Order: Podocopida
  • Class: Insecta
  • Order: Odonata
  • Family: Gomphidae
  • Genus: Octogomphus
  • Family: Cordulegastridae
  • Genus: Cordulegaster
  • Order: Ephemeroptera
  • Family: Leptophlebiidae
  • Genus: Paraleptophlebia
  • Family: Baetidae
  • Genus: Acentrella
  • Genus: Baetis
  • Genus: Diphetor
  • Family: Ephemerellidae
  • Genus: Serratella
  • Genus: Ephemerella
  • Genus: Attenella
  • Genus: Caudatella
  • Genus: Drunella
  • Family: Ameletidae
  • Genus: Ameletus
  • Family: Heptageniidae
  • Genus: Rhithrogena
  • Genus: Cinygmula
  • Genus: Cinygma
  • Genus: Epeorus
  • Genus: Ironodes
  • Order: Coleoptera
  • Family: Dryopidae
  • Family: Psephenidae
  • Genus: Acneus
  • Family: Hydrophilidae
  • Family: Elmidae
  • Genus: Heterlimnius
  • Genus: Lara
  • Genus: Zaitzevia
  • Family: Amphizoidae
  • Genus: Amphizoa
  • Family: Dascillidae
  • Genus: Anchycteis
  • Family: Dytiscidae
  • Family: Staphylinidae
  • Family: Hydraenidae
  • Genus: Hydraena
  • Family: Ptilodactylidae
  • Genus: Helichus
  • Order: Trichoptera
  • Family: Rhyacophilidae
  • Genus: Rhyacophila
  • Family: Philopotamidae
  • Genus: Wormaldia
  • Genus: Dolophilodes
  • Family: Odontoceridae
  • Genus: Namamyia
  • Family: Limnephilidae
  • Genus: Neophylax
  • Genus: Limnephilus
  • Genus: Cryptochia
  • Genus: Allocosmoecus
  • Genus: Apatania
  • Genus: Oligophlebodes
  • Genus: Philocasca
  • Genus: Psychoglypha
  • Genus: Chyranda
  • Family: Hydroptilidae
  • Genus: Palaeagapetus
  • Family: Glossosomatidae
  • Genus: Glossosoma
  • Genus: Anagapetus
  • Family: Brachycentridae
  • Genus: Micrasema
  • Family: Calamoceratidae
  • Genus: Heteroplectron
  • Family: Goeridae
  • Genus: Lepania
  • Genus: Goeracea
  • Family: Hydropsychidae
  • Genus: Hydropsyche
  • Genus: Homoplectra
  • Family: Lepidostomatidae
  • Genus: Lepidostoma
  • Family: Uenoidae
  • Genus: Neothremma
  • Family: Arctopsychidae
  • Genus: Parapsyche
  • Family: Polycentropodidae
  • Genus: Polycentropus
  • Family: Apataniidae
  • Order: Diptera
  • Family: Chaoboridae
  • Genus: Eucorethra
  • Family: Pelecorhynchidae
  • Genus: Glutops
  • Family: Tipulidae
  • Genus: Limoniini
  • Genus: Eriopterini
  • Genus: Nasiternella
  • Genus: Ormosia
  • Genus: Ulomorpha
  • Genus: Tipula
  • Genus: Pilaria
  • Genus: Limonia
  • Genus: Elliptera
  • Genus: Dicranota
  • Genus: Dactylolabis
  • Genus: Austrolimnophila
  • Genus: Antocha
  • Genus: Erioptera
  • Genus: Gnophomyia
  • Genus: Gonomyia
  • Genus: Limnophila
  • Genus: Lipsothrix
  • Genus: Pedicia
  • Genus: Hexatoma
  • Genus: Limoniinae
  • Genus: Molophilus
  • Genus: Ornithodes
  • Genus: Prionocera
  • Genus: Rhabdomastix
  • Genus: Hexatomini
  • Genus: Pediciini
  • Family: Simuliidae
  • Genus: Simulium
  • Genus: Prosimulium
  • Genus: Parasimulium
  • Family: Dolichopodidae
  • Family: Culicidae
  • Genus: Culex
  • Genus: Culiseta
  • Family: Chironomidae
  • Genus: Tanytarsini
  • Genus: Podonominae
  • Subfamily: Orthocladiinae
  • Genus: Chironomini
  • Genus: Tanypodinae
  • Family: Dixidae
  • Genus: Dixella
  • Genus: Meringodixa
  • Genus: Dixa
  • Genus: Ceratopogon
  • Family: Ceratopogonidae
  • Genus: Probezzia
  • Genus: Sphaeromias
  • Genus: Forcipomyiinae
  • Genus: Forcipomyia
  • Genus: Atrichopogon
  • Genus: Culicoides
  • Genus: Palpomyia
  • Family: Blephariceridae
  • Genus: Agathon
  • Family: Axymyiidae
  • Genus: Axymyia
  • Family: Empididae
  • Genus: Neoplasta
  • Genus: Chelifera
  • Genus: Oreothalia
  • Genus: Hemerodromia
  • Genus: Clinocera
  • Genus: Oreogeton
  • Genus: Trichoclinocera
  • Genus: Dolichocephela
  • Family: Psychodidae
  • Genus: Maruina
  • Genus: Pericoma
  • Genus: Telmatoscopus
  • Family: Thaumaleidae
  • Genus: Thaumalea
  • Genus: Bezzia
  • Order: Plecoptera
  • Genus: Calliperla
  • Family: Taeniopterygidae
  • Genus: Taenionema
  • Family: Perlidae
  • Genus: Doroneuria
  • Genus: Calineuria
  • Family: Capniidae
  • Genus: Capnura
  • Genus: Paracapnia
  • Genus: Capnia
  • Family: Nemouridae
  • Genus: Zapada
  • Genus: Soyedina
  • Genus: Malenka
  • Genus: Visoka
  • Genus: Ostrocerca
  • Family: Perlodidae
  • Genus: Megarcys
  • Genus: Isoperla
  • Genus: Chernokrilus
  • Family: Chloroperlidae
  • Genus: Bisancora
  • Genus: Alloperla
  • Genus: Kathroperla
  • Genus: Sweltsa
  • Family: Leuctridae
  • Genus: Perlomyia
  • Genus: Paraleuctra
  • Genus: Moselia
  • Genus: Despaxia
  • Family: Peltoperlidae
  • Genus: Soliperla
  • Genus: Yoraperla
  • Family: Pteronarcyidae
  • Genus: Pteronarcella
  • Genus: Chloroperlinae
  • Order: Hemiptera
  • Family: Gerridae
  • Genus: Gerris
  • Genus: Aquarius
  • Order: Megaloptera
  • Family: Corydalidae
  • Genus: Orohermes
  • Family: Sialidae
  • Genus: Sialis
  • Class: Oligochaeta
  • Class: Turbellaria
  • Class: Arachnida
  • Subclass: Acari
  • Class: Gastropoda
  • Family: Hydrobiidae
  • Order: Prosobranchia
  • Family: Pleuroceridae
  • Genus: Juga
  • Class: Ostracoda
  • Division or Phylum: Nematoda
Data Entities
# Entity Metadata Data
1 SA02201
SA02201
Benthic data:
 METADATA DATA
2 SA02202
SA02202
Emergent data:
 METADATA DATA
3 SA02203
SA02203
Benthic taxa and traits:
 METADATA DATA
4 SA02204
SA02204
Emergence taxa:
 METADATA DATA
5 SA02205
SA02205
Widths and Covers:
 METADATA DATA
6 SA02206
SA02206
Substrates and Depths:
 METADATA DATA
7 SA02207
SA02207
Litter inputs:
 METADATA DATA
Metadata
SA02201 - SA02201

Object name: SA02201.csv

Records: 6655

Attributes: 8

Temporal coverage: 2003-06-19 to 2004-05-02

File size: 345919 byte

Checksum (MD5): c96e296a5972d545ee47e378a4fbdb35

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

Constraints (2)
  • primaryKey: PRIMARY
    SA02201.BASIN, SA02201.DATE, SA02201.SAMPLE
  • notNullConstraint: NOTNULL
    SA02201.BASIN, SA02201.B_COUNT, SA02201.DATE, SA02201.DBCODE, SA02201.DENSITY, SA02201.ENTITY, SA02201.SAMPLE
Attributes (8)
DBCODE - char(5) (nominal)

ID: SA02201.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: SA02201.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

DATE - datetime (dateTime)

ID: SA02201.DATE

Date of collection

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

BASIN - char(10) (ordinal)

ID: SA02201.BASIN

site

Type system: Microsoft SQL Server 2008

Code definitions (6)
  • WS_A
    New Belgium Creek Watershed
  • WS_B
    Anderson Creek Watershed
  • WS01
    HJA Phenology Emergence Site 1 (WS01 stream)
  • WS02
    HJA Phenology Emergence Site 2 (WS02 stream)
  • WS08
    HJA Phenology Emergence Site 3 (WS08 stream)
  • WS07
    HJA Phenology Emergence Site 4 (WS07 stream)
SAMPLE - numeric(1,0) (interval)

ID: SA02201.SAMPLE

surber sample number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

TAXA - varchar(35) (ordinal)

ID: SA02201.TAXA

Taxonomic Description

Type system: Microsoft SQL Server 2008

Code definitions (196)
  • Acari
    Acari
  • Turbellaria
    Turbellaria
  • Juga
    Juga
  • Oligochaeta
    Oligochaeta
  • Ostracoda
    Ostracoda
  • Acneus
    Acneus
  • Agathon
    Agathon
  • Allocosmoecus
    Allocosmoecus
  • Alloperla
    Alloperla
  • Ameletus
    Ameletus
  • Amphizoa
    Amphizoa
  • Anagapetus
    Anagapetus
  • Anchycteis
    Anchycteis
  • Antocha
    Antocha
  • Apatania
    Apatania
  • Atrichopogon
    Atrichopogon
  • Attenella
    Attenella
  • Austrolimnophila
    Austrolimnophila
  • Axymyia
    Axymyia
  • Baetis
    Baetis
  • Calineuria
    Calineuria
  • Capnia
    Capnia
  • Caudatella
    Caudatella
  • Chernokrilus
    Chernokrilus
  • Cinygma
    Cinygma
  • Cinygmula
    Cinygmula
  • Clinocera
    Clinocera
  • Cordulegaster
    Cordulegaster
  • Cryptochia
    Cryptochia
  • Culicoides
    Culicoides
  • Dactylolabis
    Dactylolabis
  • Despaxia
    Despaxia
  • Dicranota
    Dicranota
  • Diphetor
    Diphetor
  • Dixa
    Dixa
  • Dolophilodes
    Dolophilodes
  • Doroneuria
    Doroneuria
  • Drunella
    Drunella
  • Elliptera
    Elliptera
  • Epeorus
    Epeorus
  • Ephemerella
    Ephemerella
  • Erioptera
    Erioptera
  • Forcipomyia
    Forcipomyia
  • Gerris
    Gerris
  • Glossosoma
    Glossosoma
  • Gnophomyia
    Gnophomyia
  • Goeracea
    Goeracea
  • Gonomyia
    Gonomyia
  • Hemerodromia
    Hemerodromia
  • Heteroplectron
    Heteroplectron
  • Homoplectra
    Homoplectra
  • Hydropsyche
    Hydropsyche
  • Ironodes
    Ironodes
  • Isoperla
    Isoperla
  • Kathroperla
    Kathroperla
  • Lara
    Lara
  • Lepidostoma
    Lepidostoma
  • Limnephilus
    Limnephilus
  • Limnophila
    Limnophila
  • Limonia
    Limonia
  • Lipsothrix
    Lipsothrix
  • Malenka
    Malenka
  • Maruina
    Maruina
  • Megarcys
    Megarcys
  • Micrasema
    Micrasema
  • Moselia
    Moselia
  • Namamyia
    Namamyia
  • Neophylax
    Neophylax
  • Neothremma
    Neothremma
  • Octogomphus
    Octogomphus
  • Oligophlebodes
    Oligophlebodes
  • Oreothalia
    Oreothalia
  • Orohermes
    Orohermes
  • Palaeagapetus
    Palaeagapetus
  • Palpomyia
    Palpomyia
  • Paracapnia
    Paracapnia
  • Paraleptophlebia
    Paraleptophlebia
  • Paraleuctra
    Paraleuctra
  • Parapsyche
    Parapsyche
  • Parasimulium
    Parasimulium
  • Pedicia
    Pedicia
  • Perlomyia
    Perlomyia
  • Philocasca
    Philocasca
  • Pilaria
    Pilaria
  • Polycentropus
    Polycentropus
  • Prosimulium
    Prosimulium
  • Psychoglypha
    Psychoglypha
  • Rhithrogena
    Rhithrogena
  • Rhyacophila
    Rhyacophila
  • Serratella
    Serratella
  • Sialis
    Sialis
  • Simulium
    Simulium
  • Soliperla
    Soliperla
  • Soyedina
    Soyedina
  • Sweltsa
    Sweltsa
  • Taenionema
    Taenionema
  • Thaumalea
    Thaumalea
  • Tipula
    Tipula
  • Trichoptera
    Trichoptera
  • Ulomorpha
    Ulomorpha
  • Visoka
    Visoka
  • Wormaldia
    Wormaldia
  • Yoraperla
    Yoraperla
  • Zapada
    Zapada
  • Acentrella
    Acentrella
  • Ephemerellidae
    Ephemerellidae
  • Ephemeroptera
    Ephemeroptera
  • Plecoptera
    Plecoptera
  • Baetidae
    Baetidae
  • Brachycentridae
    Brachycentridae
  • Capniidae
    Capniidae
  • Ceratopogonidae
    Ceratopogonidae
  • Chironomidae
    Chironomidae
  • Dixidae
    Dixidae
  • Dolichopodidae
    Dolichopodidae
  • Dytiscidae
    Dytiscidae
  • Elmidae
    Elmidae
  • Empididae
    Empididae
  • Glossosomatidae
    Glossosomatidae
  • Gomphidae
    Gomphidae
  • Heptageniidae
    Heptageniidae
  • Hydrophilidae
    Hydrophilidae
  • Hydropsychidae
    Hydropsychidae
  • Hydroptilidae
    Hydroptilidae
  • Leuctridae
    Leuctridae
  • Limnephilidae
    Limnephilidae
  • Nemouridae
    Nemouridae
  • Peltoperlidae
    Peltoperlidae
  • Perlidae
    Perlidae
  • Perlodidae
    Perlodidae
  • Philopotamidae
    Philopotamidae
  • Psychodidae
    Psychodidae
  • Simuliidae
    Simuliidae
  • Staphylinidae
    Staphylinidae
  • Tipulidae
    Tipulidae
  • Uenoidae
    Uenoidae
  • Chelifera
    Chelifera
  • Oreogeton
    Oreogeton
  • Glutops
    Glutops
  • Hexatoma
    Hexatoma
  • Amphipoda
    Amphipoda
  • Cyclopoida
    Cyclopoida
  • Harpacticoida
    Harpacticoida
  • Hydroidolina
    Hydroidolina
  • Nemata
    Nematoda
  • Nematomorpha
    Nematomorpha
  • Tardigrada
    Tardigrada
  • Hydraenidae
    Hydraenidae
  • Hydrobiidae
    Hydrobiidae
  • Pisidiidae
    Pisidiidae
  • Bezzia
    Bezzia
  • Calliperla
    Calliperla
  • Ceratopogon
    Ceratopogon
  • Chironomini
    Chironomini
  • Chloroperlinae
    Chloroperlinae
  • Chydoridae
    Chydoridae
  • Chyranda
    Chyranda
  • Forcipomyiinae
    Forcipomyiinae
  • Helichus
    Helichus
  • Heterlimnius
    Heterlimnius
  • Hydraena
    Hydraena
  • Lepania
    Lepania
  • Limoniinae
    Limoniinae
  • Meringodixa
    Meringodixa
  • Molophilus
    Molophilus
  • Ormosia
    Ormosia
  • Ornithodes
    Ornithodes
  • Orthocladiinae
    Orthocladiinae
  • Ostrocerca
    Ostrocerca
  • Pacifastacus
    Pacifastacus
  • Pericoma
    Pericoma
  • Podonominae
    Podonominae
  • Prionocera
    Prionocera
  • Pteronarcella
    Pteronarcella
  • Rhabdomastix
    Rhabdomastix
  • Sphaeromias
    Sphaeromias
  • Tanypodinae
    Tanypodinae
  • Tanytarsini
    Tanytarsini
  • Zaitzevia
    Zaitzevia
  • Bisancora
    Bisancora
  • Trichoclinocera
    Trichoclinocera
  • Nasiternella
    Nasiternella
  • Telmatoscopus
    Telmatoscopus
  • Probezzia
    Probezzia
  • Eucorethra
    Eucorethra
  • Culex
    Culex
  • Culiseta
    Culiseta
  • Dixella
    Dixella
  • Dolichocephela
    Dolichocephela
  • Neoplasta
    Neoplasta
  • Aquarius
    Aquarius
  • Eriopterini
    Eriopterini
  • Hexatomini
    Hexatomini
  • Limoniini
    Limoniini
  • Pediciini
    Pediciini
  • Capnura
    Capnura
B_COUNT - numeric(4,0) (interval)

ID: SA02201.B_COUNT

Number of benthic individuals in surber sample

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

DENSITY - numeric(7,1) (ratio)

ID: SA02201.DENSITY

Benthic density

Type system: Microsoft SQL Server 2008

Unit: number per m2

Precision: 1

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

SA02202 - SA02202

Object name: SA02202.csv

Records: 2154

Attributes: 9

Temporal coverage: 2003-06-30 to 2004-06-30

File size: 115721 byte

Checksum (MD5): 642aa675e78105b8e82b97fb2a40169e

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

Constraints (2)
  • primaryKey: PRIMARY
    SA02202.BASIN, SA02202.DATE, SA02202.TAXA, SA02202.TRAP
  • notNullConstraint: NOTNULL
    SA02202.BASIN, SA02202.DATE, SA02202.DAYS, SA02202.DBCODE, SA02202.ENTITY, SA02202.RATE, SA02202.TAXA, SA02202.TRAP, SA02202.E_COUNT
Attributes (9)
DBCODE - char(5) (nominal)

ID: SA02202.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: SA02202.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

DATE - datetime (dateTime)

ID: SA02202.DATE

Date of collection

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

BASIN - char(10) (ordinal)

ID: SA02202.BASIN

site

Type system: Microsoft SQL Server 2008

Code definitions (6)
  • WS_A
    New Belgium Creek Watershed
  • WS_B
    Anderson Creek Watershed
  • WS01
    HJA Phenology Emergence Site 1 (WS01 stream)
  • WS02
    HJA Phenology Emergence Site 2 (WS02 stream)
  • WS08
    HJA Phenology Emergence Site 3 (WS08 stream)
  • WS07
    HJA Phenology Emergence Site 4 (WS07 stream)
TRAP - numeric(1,0) (interval)

ID: SA02202.TRAP

emergence trap number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

DAYS - numeric(1,0) (interval)

ID: SA02202.DAYS

trap duration

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

TAXA - varchar(35) (ordinal)

ID: SA02202.TAXA

Taxonomic Description

Type system: Microsoft SQL Server 2008

Code definitions (196)
  • Acari
    Acari
  • Turbellaria
    Turbellaria
  • Juga
    Juga
  • Oligochaeta
    Oligochaeta
  • Ostracoda
    Ostracoda
  • Acneus
    Acneus
  • Agathon
    Agathon
  • Allocosmoecus
    Allocosmoecus
  • Alloperla
    Alloperla
  • Ameletus
    Ameletus
  • Amphizoa
    Amphizoa
  • Anagapetus
    Anagapetus
  • Anchycteis
    Anchycteis
  • Antocha
    Antocha
  • Apatania
    Apatania
  • Atrichopogon
    Atrichopogon
  • Attenella
    Attenella
  • Austrolimnophila
    Austrolimnophila
  • Axymyia
    Axymyia
  • Baetis
    Baetis
  • Calineuria
    Calineuria
  • Capnia
    Capnia
  • Caudatella
    Caudatella
  • Chernokrilus
    Chernokrilus
  • Cinygma
    Cinygma
  • Cinygmula
    Cinygmula
  • Clinocera
    Clinocera
  • Cordulegaster
    Cordulegaster
  • Cryptochia
    Cryptochia
  • Culicoides
    Culicoides
  • Dactylolabis
    Dactylolabis
  • Despaxia
    Despaxia
  • Dicranota
    Dicranota
  • Diphetor
    Diphetor
  • Dixa
    Dixa
  • Dolophilodes
    Dolophilodes
  • Doroneuria
    Doroneuria
  • Drunella
    Drunella
  • Elliptera
    Elliptera
  • Epeorus
    Epeorus
  • Ephemerella
    Ephemerella
  • Erioptera
    Erioptera
  • Forcipomyia
    Forcipomyia
  • Gerris
    Gerris
  • Glossosoma
    Glossosoma
  • Gnophomyia
    Gnophomyia
  • Goeracea
    Goeracea
  • Gonomyia
    Gonomyia
  • Hemerodromia
    Hemerodromia
  • Heteroplectron
    Heteroplectron
  • Homoplectra
    Homoplectra
  • Hydropsyche
    Hydropsyche
  • Ironodes
    Ironodes
  • Isoperla
    Isoperla
  • Kathroperla
    Kathroperla
  • Lara
    Lara
  • Lepidostoma
    Lepidostoma
  • Limnephilus
    Limnephilus
  • Limnophila
    Limnophila
  • Limonia
    Limonia
  • Lipsothrix
    Lipsothrix
  • Malenka
    Malenka
  • Maruina
    Maruina
  • Megarcys
    Megarcys
  • Micrasema
    Micrasema
  • Moselia
    Moselia
  • Namamyia
    Namamyia
  • Neophylax
    Neophylax
  • Neothremma
    Neothremma
  • Octogomphus
    Octogomphus
  • Oligophlebodes
    Oligophlebodes
  • Oreothalia
    Oreothalia
  • Orohermes
    Orohermes
  • Palaeagapetus
    Palaeagapetus
  • Palpomyia
    Palpomyia
  • Paracapnia
    Paracapnia
  • Paraleptophlebia
    Paraleptophlebia
  • Paraleuctra
    Paraleuctra
  • Parapsyche
    Parapsyche
  • Parasimulium
    Parasimulium
  • Pedicia
    Pedicia
  • Perlomyia
    Perlomyia
  • Philocasca
    Philocasca
  • Pilaria
    Pilaria
  • Polycentropus
    Polycentropus
  • Prosimulium
    Prosimulium
  • Psychoglypha
    Psychoglypha
  • Rhithrogena
    Rhithrogena
  • Rhyacophila
    Rhyacophila
  • Serratella
    Serratella
  • Sialis
    Sialis
  • Simulium
    Simulium
  • Soliperla
    Soliperla
  • Soyedina
    Soyedina
  • Sweltsa
    Sweltsa
  • Taenionema
    Taenionema
  • Thaumalea
    Thaumalea
  • Tipula
    Tipula
  • Trichoptera
    Trichoptera
  • Ulomorpha
    Ulomorpha
  • Visoka
    Visoka
  • Wormaldia
    Wormaldia
  • Yoraperla
    Yoraperla
  • Zapada
    Zapada
  • Acentrella
    Acentrella
  • Ephemerellidae
    Ephemerellidae
  • Ephemeroptera
    Ephemeroptera
  • Plecoptera
    Plecoptera
  • Baetidae
    Baetidae
  • Brachycentridae
    Brachycentridae
  • Capniidae
    Capniidae
  • Ceratopogonidae
    Ceratopogonidae
  • Chironomidae
    Chironomidae
  • Dixidae
    Dixidae
  • Dolichopodidae
    Dolichopodidae
  • Dytiscidae
    Dytiscidae
  • Elmidae
    Elmidae
  • Empididae
    Empididae
  • Glossosomatidae
    Glossosomatidae
  • Gomphidae
    Gomphidae
  • Heptageniidae
    Heptageniidae
  • Hydrophilidae
    Hydrophilidae
  • Hydropsychidae
    Hydropsychidae
  • Hydroptilidae
    Hydroptilidae
  • Leuctridae
    Leuctridae
  • Limnephilidae
    Limnephilidae
  • Nemouridae
    Nemouridae
  • Peltoperlidae
    Peltoperlidae
  • Perlidae
    Perlidae
  • Perlodidae
    Perlodidae
  • Philopotamidae
    Philopotamidae
  • Psychodidae
    Psychodidae
  • Simuliidae
    Simuliidae
  • Staphylinidae
    Staphylinidae
  • Tipulidae
    Tipulidae
  • Uenoidae
    Uenoidae
  • Chelifera
    Chelifera
  • Oreogeton
    Oreogeton
  • Glutops
    Glutops
  • Hexatoma
    Hexatoma
  • Amphipoda
    Amphipoda
  • Cyclopoida
    Cyclopoida
  • Harpacticoida
    Harpacticoida
  • Hydroidolina
    Hydroidolina
  • Nemata
    Nematoda
  • Nematomorpha
    Nematomorpha
  • Tardigrada
    Tardigrada
  • Hydraenidae
    Hydraenidae
  • Hydrobiidae
    Hydrobiidae
  • Pisidiidae
    Pisidiidae
  • Bezzia
    Bezzia
  • Calliperla
    Calliperla
  • Ceratopogon
    Ceratopogon
  • Chironomini
    Chironomini
  • Chloroperlinae
    Chloroperlinae
  • Chydoridae
    Chydoridae
  • Chyranda
    Chyranda
  • Forcipomyiinae
    Forcipomyiinae
  • Helichus
    Helichus
  • Heterlimnius
    Heterlimnius
  • Hydraena
    Hydraena
  • Lepania
    Lepania
  • Limoniinae
    Limoniinae
  • Meringodixa
    Meringodixa
  • Molophilus
    Molophilus
  • Ormosia
    Ormosia
  • Ornithodes
    Ornithodes
  • Orthocladiinae
    Orthocladiinae
  • Ostrocerca
    Ostrocerca
  • Pacifastacus
    Pacifastacus
  • Pericoma
    Pericoma
  • Podonominae
    Podonominae
  • Prionocera
    Prionocera
  • Pteronarcella
    Pteronarcella
  • Rhabdomastix
    Rhabdomastix
  • Sphaeromias
    Sphaeromias
  • Tanypodinae
    Tanypodinae
  • Tanytarsini
    Tanytarsini
  • Zaitzevia
    Zaitzevia
  • Bisancora
    Bisancora
  • Trichoclinocera
    Trichoclinocera
  • Nasiternella
    Nasiternella
  • Telmatoscopus
    Telmatoscopus
  • Probezzia
    Probezzia
  • Eucorethra
    Eucorethra
  • Culex
    Culex
  • Culiseta
    Culiseta
  • Dixella
    Dixella
  • Dolichocephela
    Dolichocephela
  • Neoplasta
    Neoplasta
  • Aquarius
    Aquarius
  • Eriopterini
    Eriopterini
  • Hexatomini
    Hexatomini
  • Limoniini
    Limoniini
  • Pediciini
    Pediciini
  • Capnura
    Capnura
E_COUNT - numeric(4,0) (interval)

ID: SA02202.E_COUNT

Number of individuals emerging from that trap during the interval

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

RATE - numeric(5,1) (ratio)

ID: SA02202.RATE

Emergence rate

Type system: Microsoft SQL Server 2008

Unit: number per m2 per day

Precision: 1

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

SA02203 - SA02203

Object name: SA02203.csv

Records: 188

Attributes: 7

Temporal coverage: 2003-06-19 to 2004-05-02

File size: 13255 byte

Checksum (MD5): 2eaed6fcad299c12caacb74c13af596a

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

Constraints (2)
  • primaryKey: PRIMARY
    SA02203.TAXA
  • notNullConstraint: NOTNULL
    SA02203.DBCODE, SA02203.ENTITY, SA02203.FAMILY, SA02203.FFG, SA02203.HTG, SA02203.TAXA, SA02203.TAXA_ORDER
Attributes (7)
DBCODE - char(5) (nominal)

ID: SA02203.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: SA02203.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

TAXA_ORDER - varchar(35) (ordinal)

ID: SA02203.TAXA_ORDER

Taxonomic Order

Type system: Microsoft SQL Server 2008

Code definitions (23)
  • Acari
    Acari
  • Turbellaria
    Turbellaria
  • Prosobranchia
    Prosobranchia
  • Oligochaeta
    Oligochaeta
  • Coleoptera
    Coleoptera
  • Hemiptera
    Hemiptera
  • Trichoptera
    Trichoptera
  • Diptera
    Diptera
  • Ephemeroptera
    Ephemeroptera
  • Megaloptera
    Megaloptera
  • Odonata
    Odonata
  • Plecoptera
    Plecoptera
  • Amphipoda
    Amphipoda
  • Anomopoda
    Anomopoda
  • Veneroida
    Veneroida
  • Cyclopoida
    Cyclopoida
  • Decapoda
    Decapoda
  • Harpacticoida
    Harpacticoida
  • Hydroidolina
    Hydroidolina
  • Nemata
    Nematoda
  • Nematomorpha
    Nematomorpha
  • Podocopida
    Podocopida
  • Tardigrada
    Tardigrada
FAMILY - varchar(35) (ordinal)

ID: SA02203.FAMILY

Taxonomic Family

Type system: Microsoft SQL Server 2008

Code definitions (75)
  • Acari
    Acari
  • Turbellaria
    Turbellaria
  • Pleuroceridae
    Pleuroceridae
  • Oligochaeta
    Oligochaeta
  • Ostracoda
    Ostracoda
  • Trichoptera
    Trichoptera
  • Ameletidae
    Ameletidae
  • Ephemerellidae
    Ephemerellidae
  • Gerridae
    Gerridae
  • Ephemeroptera
    Ephemeroptera
  • Plecoptera
    Plecoptera
  • Amphizoidae
    Amphizoidae
  • Axymyiidae
    Axymyiidae
  • Baetidae
    Baetidae
  • Blephariceridae
    Blephariceridae
  • Brachycentridae
    Brachycentridae
  • Calamoceratidae
    Calamoceratidae
  • Capniidae
    Capniidae
  • Ceratopogonidae
    Ceratopogonidae
  • Chironomidae
    Chironomidae
  • Chloroperlidae
    Chloroperlidae
  • Cordulegastridae
    Cordulegastridae
  • Corydalidae
    Corydalidae
  • Culicidae
    Culicidae
  • Dixidae
    Dixidae
  • Dolichopodidae
    Dolichopodidae
  • Dytiscidae
    Dytiscidae
  • Elmidae
    Elmidae
  • Empididae
    Empididae
  • Glossosomatidae
    Glossosomatidae
  • Goeridae
    Goeridae
  • Gomphidae
    Gomphidae
  • Heptageniidae
    Heptageniidae
  • Hydrophilidae
    Hydrophilidae
  • Hydropsychidae
    Hydropsychidae
  • Hydroptilidae
    Hydroptilidae
  • Lepidostomatidae
    Lepidostomatidae
  • Leptophlebiidae
    Leptophlebiidae
  • Leuctridae
    Leuctridae
  • Limnephilidae
    Limnephilidae
  • Nemouridae
    Nemouridae
  • Odontoceridae
    Odontoceridae
  • Peltoperlidae
    Peltoperlidae
  • Perlidae
    Perlidae
  • Perlodidae
    Perlodidae
  • Philopotamidae
    Philopotamidae
  • Polycentropodidae
    Polycentropodidae
  • Psephenidae
    Psephenidae
  • Psychodidae
    Psychodidae
  • Rhyacophilidae
    Rhyacophilidae
  • Sialidae
    Sialidae
  • Simuliidae
    Simuliidae
  • Staphylinidae
    Staphylinidae
  • Taeniopterygidae
    Taeniopterygidae
  • Thaumaleidae
    Thaumaleidae
  • Tipulidae
    Tipulidae
  • Uenoidae
    Uenoidae
  • Pelecorhynchidae
    Pelecorhynchidae
  • Pteronarcyidae
    Pteronarcyidae
  • Amphipoda
    Amphipoda
  • Cyclopoida
    Cyclopoida
  • Harpacticoida
    Harpacticoida
  • Hydroidolina
    Hydroidolina
  • Nemata
    Nematoda
  • Nematomorpha
    Nematomorpha
  • Tardigrada
    Tardigrada
  • Astacidae
    Astacidae
  • Dryopidae
    Dryopidae
  • Hydraenidae
    Hydraenidae
  • Hydrobiidae
    Hydrobiidae
  • Ptilodactylidae
    Ptilodactylidae
  • Pisidiidae
    Pisidiidae
  • Apataniidae
    Apataniidae
  • Chaoboridae
    Chaoboridae
  • Chydoridae
    Chydoridae
TAXA - varchar(35) (ordinal)

ID: SA02203.TAXA

Taxonomic Description

Type system: Microsoft SQL Server 2008

Code definitions (196)
  • Acari
    Acari
  • Turbellaria
    Turbellaria
  • Juga
    Juga
  • Oligochaeta
    Oligochaeta
  • Ostracoda
    Ostracoda
  • Acneus
    Acneus
  • Agathon
    Agathon
  • Allocosmoecus
    Allocosmoecus
  • Alloperla
    Alloperla
  • Ameletus
    Ameletus
  • Amphizoa
    Amphizoa
  • Anagapetus
    Anagapetus
  • Anchycteis
    Anchycteis
  • Antocha
    Antocha
  • Apatania
    Apatania
  • Atrichopogon
    Atrichopogon
  • Attenella
    Attenella
  • Austrolimnophila
    Austrolimnophila
  • Axymyia
    Axymyia
  • Baetis
    Baetis
  • Calineuria
    Calineuria
  • Capnia
    Capnia
  • Caudatella
    Caudatella
  • Chernokrilus
    Chernokrilus
  • Cinygma
    Cinygma
  • Cinygmula
    Cinygmula
  • Clinocera
    Clinocera
  • Cordulegaster
    Cordulegaster
  • Cryptochia
    Cryptochia
  • Culicoides
    Culicoides
  • Dactylolabis
    Dactylolabis
  • Despaxia
    Despaxia
  • Dicranota
    Dicranota
  • Diphetor
    Diphetor
  • Dixa
    Dixa
  • Dolophilodes
    Dolophilodes
  • Doroneuria
    Doroneuria
  • Drunella
    Drunella
  • Elliptera
    Elliptera
  • Epeorus
    Epeorus
  • Ephemerella
    Ephemerella
  • Erioptera
    Erioptera
  • Forcipomyia
    Forcipomyia
  • Gerris
    Gerris
  • Glossosoma
    Glossosoma
  • Gnophomyia
    Gnophomyia
  • Goeracea
    Goeracea
  • Gonomyia
    Gonomyia
  • Hemerodromia
    Hemerodromia
  • Heteroplectron
    Heteroplectron
  • Homoplectra
    Homoplectra
  • Hydropsyche
    Hydropsyche
  • Ironodes
    Ironodes
  • Isoperla
    Isoperla
  • Kathroperla
    Kathroperla
  • Lara
    Lara
  • Lepidostoma
    Lepidostoma
  • Limnephilus
    Limnephilus
  • Limnophila
    Limnophila
  • Limonia
    Limonia
  • Lipsothrix
    Lipsothrix
  • Malenka
    Malenka
  • Maruina
    Maruina
  • Megarcys
    Megarcys
  • Micrasema
    Micrasema
  • Moselia
    Moselia
  • Namamyia
    Namamyia
  • Neophylax
    Neophylax
  • Neothremma
    Neothremma
  • Octogomphus
    Octogomphus
  • Oligophlebodes
    Oligophlebodes
  • Oreothalia
    Oreothalia
  • Orohermes
    Orohermes
  • Palaeagapetus
    Palaeagapetus
  • Palpomyia
    Palpomyia
  • Paracapnia
    Paracapnia
  • Paraleptophlebia
    Paraleptophlebia
  • Paraleuctra
    Paraleuctra
  • Parapsyche
    Parapsyche
  • Parasimulium
    Parasimulium
  • Pedicia
    Pedicia
  • Perlomyia
    Perlomyia
  • Philocasca
    Philocasca
  • Pilaria
    Pilaria
  • Polycentropus
    Polycentropus
  • Prosimulium
    Prosimulium
  • Psychoglypha
    Psychoglypha
  • Rhithrogena
    Rhithrogena
  • Rhyacophila
    Rhyacophila
  • Serratella
    Serratella
  • Sialis
    Sialis
  • Simulium
    Simulium
  • Soliperla
    Soliperla
  • Soyedina
    Soyedina
  • Sweltsa
    Sweltsa
  • Taenionema
    Taenionema
  • Thaumalea
    Thaumalea
  • Tipula
    Tipula
  • Trichoptera
    Trichoptera
  • Ulomorpha
    Ulomorpha
  • Visoka
    Visoka
  • Wormaldia
    Wormaldia
  • Yoraperla
    Yoraperla
  • Zapada
    Zapada
  • Acentrella
    Acentrella
  • Ephemerellidae
    Ephemerellidae
  • Ephemeroptera
    Ephemeroptera
  • Plecoptera
    Plecoptera
  • Baetidae
    Baetidae
  • Brachycentridae
    Brachycentridae
  • Capniidae
    Capniidae
  • Ceratopogonidae
    Ceratopogonidae
  • Chironomidae
    Chironomidae
  • Dixidae
    Dixidae
  • Dolichopodidae
    Dolichopodidae
  • Dytiscidae
    Dytiscidae
  • Elmidae
    Elmidae
  • Empididae
    Empididae
  • Glossosomatidae
    Glossosomatidae
  • Gomphidae
    Gomphidae
  • Heptageniidae
    Heptageniidae
  • Hydrophilidae
    Hydrophilidae
  • Hydropsychidae
    Hydropsychidae
  • Hydroptilidae
    Hydroptilidae
  • Leuctridae
    Leuctridae
  • Limnephilidae
    Limnephilidae
  • Nemouridae
    Nemouridae
  • Peltoperlidae
    Peltoperlidae
  • Perlidae
    Perlidae
  • Perlodidae
    Perlodidae
  • Philopotamidae
    Philopotamidae
  • Psychodidae
    Psychodidae
  • Simuliidae
    Simuliidae
  • Staphylinidae
    Staphylinidae
  • Tipulidae
    Tipulidae
  • Uenoidae
    Uenoidae
  • Chelifera
    Chelifera
  • Oreogeton
    Oreogeton
  • Glutops
    Glutops
  • Hexatoma
    Hexatoma
  • Amphipoda
    Amphipoda
  • Cyclopoida
    Cyclopoida
  • Harpacticoida
    Harpacticoida
  • Hydroidolina
    Hydroidolina
  • Nemata
    Nematoda
  • Nematomorpha
    Nematomorpha
  • Tardigrada
    Tardigrada
  • Hydraenidae
    Hydraenidae
  • Hydrobiidae
    Hydrobiidae
  • Pisidiidae
    Pisidiidae
  • Bezzia
    Bezzia
  • Calliperla
    Calliperla
  • Ceratopogon
    Ceratopogon
  • Chironomini
    Chironomini
  • Chloroperlinae
    Chloroperlinae
  • Chydoridae
    Chydoridae
  • Chyranda
    Chyranda
  • Forcipomyiinae
    Forcipomyiinae
  • Helichus
    Helichus
  • Heterlimnius
    Heterlimnius
  • Hydraena
    Hydraena
  • Lepania
    Lepania
  • Limoniinae
    Limoniinae
  • Meringodixa
    Meringodixa
  • Molophilus
    Molophilus
  • Ormosia
    Ormosia
  • Ornithodes
    Ornithodes
  • Orthocladiinae
    Orthocladiinae
  • Ostrocerca
    Ostrocerca
  • Pacifastacus
    Pacifastacus
  • Pericoma
    Pericoma
  • Podonominae
    Podonominae
  • Prionocera
    Prionocera
  • Pteronarcella
    Pteronarcella
  • Rhabdomastix
    Rhabdomastix
  • Sphaeromias
    Sphaeromias
  • Tanypodinae
    Tanypodinae
  • Tanytarsini
    Tanytarsini
  • Zaitzevia
    Zaitzevia
  • Bisancora
    Bisancora
  • Trichoclinocera
    Trichoclinocera
  • Nasiternella
    Nasiternella
  • Telmatoscopus
    Telmatoscopus
  • Probezzia
    Probezzia
  • Eucorethra
    Eucorethra
  • Culex
    Culex
  • Culiseta
    Culiseta
  • Dixella
    Dixella
  • Dolichocephela
    Dolichocephela
  • Neoplasta
    Neoplasta
  • Aquarius
    Aquarius
  • Eriopterini
    Eriopterini
  • Hexatomini
    Hexatomini
  • Limoniini
    Limoniini
  • Pediciini
    Pediciini
  • Capnura
    Capnura
FFG - char(10) (nominal)

ID: SA02203.FFG

Functional Feeding Group

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • col/filt
    collector/filterer
  • col/gath
    collector/gatherer
  • shred
    shredder
  • pred
    predator
  • scrape
    scraper
  • unknown
    unknown functional feeding group
  • non-feed
    not feeding at this stage of lifecycle
  • parasite
    parasite
HTG - char(10) (nominal)

ID: SA02203.HTG

Habit Trait Group

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • burrow
    burrowing
  • sprawl
    sprawling
  • cling
    clinging
  • swim
    swimming
  • skate
    skating
  • climb
    climbing
  • unknown
    unknown habitat trait group
  • dive
    diving
SA02204 - SA02204

Object name: SA02204.csv

Records: 108

Attributes: 5

Temporal coverage: 2003-06-30 to 2004-06-30

File size: 5389 byte

Checksum (MD5): af08a6d4a7f609321e77683c781dc76e

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

Constraints (2)
  • primaryKey: PRIMARY
    SA02204.TAXA
  • notNullConstraint: NOTNULL
    SA02204.DBCODE, SA02204.ENTITY, SA02204.FAMILY, SA02204.TAXA, SA02204.TAXA_ORDER
Attributes (5)
DBCODE - char(5) (nominal)

ID: SA02204.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: SA02204.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

TAXA_ORDER - varchar(35) (ordinal)

ID: SA02204.TAXA_ORDER

Taxonomic Order

Type system: Microsoft SQL Server 2008

Code definitions (23)
  • Acari
    Acari
  • Turbellaria
    Turbellaria
  • Prosobranchia
    Prosobranchia
  • Oligochaeta
    Oligochaeta
  • Coleoptera
    Coleoptera
  • Hemiptera
    Hemiptera
  • Trichoptera
    Trichoptera
  • Diptera
    Diptera
  • Ephemeroptera
    Ephemeroptera
  • Megaloptera
    Megaloptera
  • Odonata
    Odonata
  • Plecoptera
    Plecoptera
  • Amphipoda
    Amphipoda
  • Anomopoda
    Anomopoda
  • Veneroida
    Veneroida
  • Cyclopoida
    Cyclopoida
  • Decapoda
    Decapoda
  • Harpacticoida
    Harpacticoida
  • Hydroidolina
    Hydroidolina
  • Nemata
    Nematoda
  • Nematomorpha
    Nematomorpha
  • Podocopida
    Podocopida
  • Tardigrada
    Tardigrada
FAMILY - varchar(35) (ordinal)

ID: SA02204.FAMILY

Taxonomic Family

Type system: Microsoft SQL Server 2008

Code definitions (75)
  • Acari
    Acari
  • Turbellaria
    Turbellaria
  • Pleuroceridae
    Pleuroceridae
  • Oligochaeta
    Oligochaeta
  • Ostracoda
    Ostracoda
  • Trichoptera
    Trichoptera
  • Ameletidae
    Ameletidae
  • Ephemerellidae
    Ephemerellidae
  • Gerridae
    Gerridae
  • Ephemeroptera
    Ephemeroptera
  • Plecoptera
    Plecoptera
  • Amphizoidae
    Amphizoidae
  • Axymyiidae
    Axymyiidae
  • Baetidae
    Baetidae
  • Blephariceridae
    Blephariceridae
  • Brachycentridae
    Brachycentridae
  • Calamoceratidae
    Calamoceratidae
  • Capniidae
    Capniidae
  • Ceratopogonidae
    Ceratopogonidae
  • Chironomidae
    Chironomidae
  • Chloroperlidae
    Chloroperlidae
  • Cordulegastridae
    Cordulegastridae
  • Corydalidae
    Corydalidae
  • Culicidae
    Culicidae
  • Dixidae
    Dixidae
  • Dolichopodidae
    Dolichopodidae
  • Dytiscidae
    Dytiscidae
  • Elmidae
    Elmidae
  • Empididae
    Empididae
  • Glossosomatidae
    Glossosomatidae
  • Goeridae
    Goeridae
  • Gomphidae
    Gomphidae
  • Heptageniidae
    Heptageniidae
  • Hydrophilidae
    Hydrophilidae
  • Hydropsychidae
    Hydropsychidae
  • Hydroptilidae
    Hydroptilidae
  • Lepidostomatidae
    Lepidostomatidae
  • Leptophlebiidae
    Leptophlebiidae
  • Leuctridae
    Leuctridae
  • Limnephilidae
    Limnephilidae
  • Nemouridae
    Nemouridae
  • Odontoceridae
    Odontoceridae
  • Peltoperlidae
    Peltoperlidae
  • Perlidae
    Perlidae
  • Perlodidae
    Perlodidae
  • Philopotamidae
    Philopotamidae
  • Polycentropodidae
    Polycentropodidae
  • Psephenidae
    Psephenidae
  • Psychodidae
    Psychodidae
  • Rhyacophilidae
    Rhyacophilidae
  • Sialidae
    Sialidae
  • Simuliidae
    Simuliidae
  • Staphylinidae
    Staphylinidae
  • Taeniopterygidae
    Taeniopterygidae
  • Thaumaleidae
    Thaumaleidae
  • Tipulidae
    Tipulidae
  • Uenoidae
    Uenoidae
  • Pelecorhynchidae
    Pelecorhynchidae
  • Pteronarcyidae
    Pteronarcyidae
  • Amphipoda
    Amphipoda
  • Cyclopoida
    Cyclopoida
  • Harpacticoida
    Harpacticoida
  • Hydroidolina
    Hydroidolina
  • Nemata
    Nematoda
  • Nematomorpha
    Nematomorpha
  • Tardigrada
    Tardigrada
  • Astacidae
    Astacidae
  • Dryopidae
    Dryopidae
  • Hydraenidae
    Hydraenidae
  • Hydrobiidae
    Hydrobiidae
  • Ptilodactylidae
    Ptilodactylidae
  • Pisidiidae
    Pisidiidae
  • Apataniidae
    Apataniidae
  • Chaoboridae
    Chaoboridae
  • Chydoridae
    Chydoridae
TAXA - varchar(35) (ordinal)

ID: SA02204.TAXA

Taxonomic Description

Type system: Microsoft SQL Server 2008

Code definitions (196)
  • Acari
    Acari
  • Turbellaria
    Turbellaria
  • Juga
    Juga
  • Oligochaeta
    Oligochaeta
  • Ostracoda
    Ostracoda
  • Acneus
    Acneus
  • Agathon
    Agathon
  • Allocosmoecus
    Allocosmoecus
  • Alloperla
    Alloperla
  • Ameletus
    Ameletus
  • Amphizoa
    Amphizoa
  • Anagapetus
    Anagapetus
  • Anchycteis
    Anchycteis
  • Antocha
    Antocha
  • Apatania
    Apatania
  • Atrichopogon
    Atrichopogon
  • Attenella
    Attenella
  • Austrolimnophila
    Austrolimnophila
  • Axymyia
    Axymyia
  • Baetis
    Baetis
  • Calineuria
    Calineuria
  • Capnia
    Capnia
  • Caudatella
    Caudatella
  • Chernokrilus
    Chernokrilus
  • Cinygma
    Cinygma
  • Cinygmula
    Cinygmula
  • Clinocera
    Clinocera
  • Cordulegaster
    Cordulegaster
  • Cryptochia
    Cryptochia
  • Culicoides
    Culicoides
  • Dactylolabis
    Dactylolabis
  • Despaxia
    Despaxia
  • Dicranota
    Dicranota
  • Diphetor
    Diphetor
  • Dixa
    Dixa
  • Dolophilodes
    Dolophilodes
  • Doroneuria
    Doroneuria
  • Drunella
    Drunella
  • Elliptera
    Elliptera
  • Epeorus
    Epeorus
  • Ephemerella
    Ephemerella
  • Erioptera
    Erioptera
  • Forcipomyia
    Forcipomyia
  • Gerris
    Gerris
  • Glossosoma
    Glossosoma
  • Gnophomyia
    Gnophomyia
  • Goeracea
    Goeracea
  • Gonomyia
    Gonomyia
  • Hemerodromia
    Hemerodromia
  • Heteroplectron
    Heteroplectron
  • Homoplectra
    Homoplectra
  • Hydropsyche
    Hydropsyche
  • Ironodes
    Ironodes
  • Isoperla
    Isoperla
  • Kathroperla
    Kathroperla
  • Lara
    Lara
  • Lepidostoma
    Lepidostoma
  • Limnephilus
    Limnephilus
  • Limnophila
    Limnophila
  • Limonia
    Limonia
  • Lipsothrix
    Lipsothrix
  • Malenka
    Malenka
  • Maruina
    Maruina
  • Megarcys
    Megarcys
  • Micrasema
    Micrasema
  • Moselia
    Moselia
  • Namamyia
    Namamyia
  • Neophylax
    Neophylax
  • Neothremma
    Neothremma
  • Octogomphus
    Octogomphus
  • Oligophlebodes
    Oligophlebodes
  • Oreothalia
    Oreothalia
  • Orohermes
    Orohermes
  • Palaeagapetus
    Palaeagapetus
  • Palpomyia
    Palpomyia
  • Paracapnia
    Paracapnia
  • Paraleptophlebia
    Paraleptophlebia
  • Paraleuctra
    Paraleuctra
  • Parapsyche
    Parapsyche
  • Parasimulium
    Parasimulium
  • Pedicia
    Pedicia
  • Perlomyia
    Perlomyia
  • Philocasca
    Philocasca
  • Pilaria
    Pilaria
  • Polycentropus
    Polycentropus
  • Prosimulium
    Prosimulium
  • Psychoglypha
    Psychoglypha
  • Rhithrogena
    Rhithrogena
  • Rhyacophila
    Rhyacophila
  • Serratella
    Serratella
  • Sialis
    Sialis
  • Simulium
    Simulium
  • Soliperla
    Soliperla
  • Soyedina
    Soyedina
  • Sweltsa
    Sweltsa
  • Taenionema
    Taenionema
  • Thaumalea
    Thaumalea
  • Tipula
    Tipula
  • Trichoptera
    Trichoptera
  • Ulomorpha
    Ulomorpha
  • Visoka
    Visoka
  • Wormaldia
    Wormaldia
  • Yoraperla
    Yoraperla
  • Zapada
    Zapada
  • Acentrella
    Acentrella
  • Ephemerellidae
    Ephemerellidae
  • Ephemeroptera
    Ephemeroptera
  • Plecoptera
    Plecoptera
  • Baetidae
    Baetidae
  • Brachycentridae
    Brachycentridae
  • Capniidae
    Capniidae
  • Ceratopogonidae
    Ceratopogonidae
  • Chironomidae
    Chironomidae
  • Dixidae
    Dixidae
  • Dolichopodidae
    Dolichopodidae
  • Dytiscidae
    Dytiscidae
  • Elmidae
    Elmidae
  • Empididae
    Empididae
  • Glossosomatidae
    Glossosomatidae
  • Gomphidae
    Gomphidae
  • Heptageniidae
    Heptageniidae
  • Hydrophilidae
    Hydrophilidae
  • Hydropsychidae
    Hydropsychidae
  • Hydroptilidae
    Hydroptilidae
  • Leuctridae
    Leuctridae
  • Limnephilidae
    Limnephilidae
  • Nemouridae
    Nemouridae
  • Peltoperlidae
    Peltoperlidae
  • Perlidae
    Perlidae
  • Perlodidae
    Perlodidae
  • Philopotamidae
    Philopotamidae
  • Psychodidae
    Psychodidae
  • Simuliidae
    Simuliidae
  • Staphylinidae
    Staphylinidae
  • Tipulidae
    Tipulidae
  • Uenoidae
    Uenoidae
  • Chelifera
    Chelifera
  • Oreogeton
    Oreogeton
  • Glutops
    Glutops
  • Hexatoma
    Hexatoma
  • Amphipoda
    Amphipoda
  • Cyclopoida
    Cyclopoida
  • Harpacticoida
    Harpacticoida
  • Hydroidolina
    Hydroidolina
  • Nemata
    Nematoda
  • Nematomorpha
    Nematomorpha
  • Tardigrada
    Tardigrada
  • Hydraenidae
    Hydraenidae
  • Hydrobiidae
    Hydrobiidae
  • Pisidiidae
    Pisidiidae
  • Bezzia
    Bezzia
  • Calliperla
    Calliperla
  • Ceratopogon
    Ceratopogon
  • Chironomini
    Chironomini
  • Chloroperlinae
    Chloroperlinae
  • Chydoridae
    Chydoridae
  • Chyranda
    Chyranda
  • Forcipomyiinae
    Forcipomyiinae
  • Helichus
    Helichus
  • Heterlimnius
    Heterlimnius
  • Hydraena
    Hydraena
  • Lepania
    Lepania
  • Limoniinae
    Limoniinae
  • Meringodixa
    Meringodixa
  • Molophilus
    Molophilus
  • Ormosia
    Ormosia
  • Ornithodes
    Ornithodes
  • Orthocladiinae
    Orthocladiinae
  • Ostrocerca
    Ostrocerca
  • Pacifastacus
    Pacifastacus
  • Pericoma
    Pericoma
  • Podonominae
    Podonominae
  • Prionocera
    Prionocera
  • Pteronarcella
    Pteronarcella
  • Rhabdomastix
    Rhabdomastix
  • Sphaeromias
    Sphaeromias
  • Tanypodinae
    Tanypodinae
  • Tanytarsini
    Tanytarsini
  • Zaitzevia
    Zaitzevia
  • Bisancora
    Bisancora
  • Trichoclinocera
    Trichoclinocera
  • Nasiternella
    Nasiternella
  • Telmatoscopus
    Telmatoscopus
  • Probezzia
    Probezzia
  • Eucorethra
    Eucorethra
  • Culex
    Culex
  • Culiseta
    Culiseta
  • Dixella
    Dixella
  • Dolichocephela
    Dolichocephela
  • Neoplasta
    Neoplasta
  • Aquarius
    Aquarius
  • Eriopterini
    Eriopterini
  • Hexatomini
    Hexatomini
  • Limoniini
    Limoniini
  • Pediciini
    Pediciini
  • Capnura
    Capnura
SA02205 - SA02205

Object name: SA02205.csv

Records: 144

Attributes: 7

Temporal coverage: 2003-06-19 to 2004-05-02

File size: 5527 byte

Checksum (MD5): a96e8815d833c5ff628754a0d3827d61

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

Constraints (2)
  • primaryKey: PRIMARY
    SA02205.BASIN, SA02205.DATE, SA02205.TRANSECT
  • notNullConstraint: NOTNULL
    SA02205.BASIN, SA02205.COVER, SA02205.DATE, SA02205.DBCODE, SA02205.ENTITY, SA02205.TRANSECT, SA02205.WIDTH
Attributes (7)
DBCODE - char(5) (nominal)

ID: SA02205.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: SA02205.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

DATE - datetime (dateTime)

ID: SA02205.DATE

Date of collection

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

BASIN - char(10) (ordinal)

ID: SA02205.BASIN

site

Type system: Microsoft SQL Server 2008

Code definitions (6)
  • WS_A
    New Belgium Creek Watershed
  • WS_B
    Anderson Creek Watershed
  • WS01
    HJA Phenology Emergence Site 1 (WS01 stream)
  • WS02
    HJA Phenology Emergence Site 2 (WS02 stream)
  • WS08
    HJA Phenology Emergence Site 3 (WS08 stream)
  • WS07
    HJA Phenology Emergence Site 4 (WS07 stream)
TRANSECT - char(2) (ordinal)

ID: SA02205.TRANSECT

transects perpendicular to stream at 10 m intervals

Type system: Microsoft SQL Server 2008

Code definitions (6)
  • 1
    most upstream transect in study reach
  • 2
    Second transect, 10 meters downstream from transect 1
  • 3
    Third transect, 20 m downstream of transect 1
  • 4
    Fourth transect, 30 m downstream of transect 1
  • 5
    Fifth transect, 40 m downstream of transect 1
  • 6
    Sixth transect, 50 m downstream of transect 1
WIDTH - numeric(3,1) (ratio)

ID: SA02205.WIDTH

Measured wetted width of channel at transect

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

Numeric domain: type=real, min=0.4000 (exclusive=false), max=4.2000 (exclusive=false)

COVER - numeric(5,1) (ratio)

ID: SA02205.COVER

average overhead cover using densiometer

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1

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

SA02206 - SA02206

Object name: SA02206.csv

Records: 1584

Attributes: 8

Temporal coverage: 2003-06-19 to 2004-05-02

File size: 62146 byte

Checksum (MD5): fa2f2ceb3e8b56b098e216a2893aee10

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

Constraints (2)
  • primaryKey: PRIMARY
    SA02206.BASIN, SA02206.DATE, SA02206.POINT, SA02206.TRANSECT
  • notNullConstraint: NOTNULL
    SA02206.BASIN, SA02206.DATE, SA02206.DBCODE, SA02206.DEPTH, SA02206.ENTITY, SA02206.POINT, SA02206.SUBSTRATE, SA02206.TRANSECT
Attributes (8)
DBCODE - char(5) (nominal)

ID: SA02206.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: SA02206.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

DATE - datetime (dateTime)

ID: SA02206.DATE

Date of collection

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

BASIN - char(10) (ordinal)

ID: SA02206.BASIN

site

Type system: Microsoft SQL Server 2008

Code definitions (6)
  • WS_A
    New Belgium Creek Watershed
  • WS_B
    Anderson Creek Watershed
  • WS01
    HJA Phenology Emergence Site 1 (WS01 stream)
  • WS02
    HJA Phenology Emergence Site 2 (WS02 stream)
  • WS08
    HJA Phenology Emergence Site 3 (WS08 stream)
  • WS07
    HJA Phenology Emergence Site 4 (WS07 stream)
TRANSECT - char(2) (ordinal)

ID: SA02206.TRANSECT

transects perpendicular to stream at 10 m intervals

Type system: Microsoft SQL Server 2008

Code definitions (6)
  • 1
    most upstream transect in study reach
  • 2
    Second transect, 10 meters downstream from transect 1
  • 3
    Third transect, 20 m downstream of transect 1
  • 4
    Fourth transect, 30 m downstream of transect 1
  • 5
    Fifth transect, 40 m downstream of transect 1
  • 6
    Sixth transect, 50 m downstream of transect 1
POINT - char(3) (ordinal)

ID: SA02206.POINT

sampling point along transect

Type system: Microsoft SQL Server 2008

Code definitions (11)
  • A
    First sampling point on transect
  • B
    Second sampling point on transect
  • C
    Third sampling point on transect
  • D
    Fourth sampling point on transect
  • E
    Fifth sampling point on transect
  • F
    Sixth sampling point on transect
  • G
    Seventh sampling point on transect
  • H
    Eighth sampling point on transect
  • I
    Ninth sampling point on transect
  • J
    Tenth samplling point on transect
  • K
    Eleventh sampling point on transect
SUBSTRATE - char(2) (nominal)

ID: SA02206.SUBSTRATE

type of substrate at point

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • b
    boulder
  • c
    cobble
  • g
    gravel
  • lw
    large wood (>10cm dia)
  • r
    bedrock
  • sa
    sand
  • si
    silt
  • sw
    small wood (<10cm dia)
DEPTH - numeric(5,3) (ratio)

ID: SA02206.DEPTH

water depth at point

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.050000

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

SA02207 - SA02207

Object name: SA02207.csv

Records: 654

Attributes: 12

Temporal coverage: 2003-07-01 to 2003-10-31

File size: 42043 byte

Checksum (MD5): 1676ab5f5a1dfac56c4d0f09f69a8dc4

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

Constraints (2)
  • primaryKey: PRIMARY
    SA02207.BASIN, SA02207.LITTERTYPE, SA02207.MONTH, SA02207.NEAREST_VEGETATION, SA02207.SAMPLE_LOCATION, SA02207.STREAMBANK, SA02207.YEAR
  • notNullConstraint: NOTNULL
    SA02207.BASIN, SA02207.BIOMASS, SA02207.BIOMASS_PER_DAY, SA02207.DBCODE, SA02207.ENTITY, SA02207.LITTERTYPE, SA02207.MONTH, SA02207.NEAREST_VEGETATION, SA02207.SAMPLE_LOCATION, SA02207.STREAMBANK, SA02207.TIME_PERIOD, SA02207.YEAR
Attributes (12)
DBCODE - char(5) (nominal)

ID: SA02207.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: SA02207.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

YEAR - numeric(4,0) (dateTime)

ID: SA02207.YEAR

year of collection

Type system: Microsoft SQL Server 2008

Date format: YYYY

MONTH - numeric(2,0) (ratio)

ID: SA02207.MONTH

month of collection

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

TIME_PERIOD - numeric(2,0) (ratio)

ID: SA02207.TIME_PERIOD

number of days

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

BASIN - char(10) (ordinal)

ID: SA02207.BASIN

site

Type system: Microsoft SQL Server 2008

Code definitions (6)
  • WS_A
    New Belgium Creek Watershed
  • WS_B
    Anderson Creek Watershed
  • WS01
    HJA Phenology Emergence Site 1 (WS01 stream)
  • WS02
    HJA Phenology Emergence Site 2 (WS02 stream)
  • WS08
    HJA Phenology Emergence Site 3 (WS08 stream)
  • WS07
    HJA Phenology Emergence Site 4 (WS07 stream)
SAMPLE_LOCATION - numeric(3,0) (ratio)

ID: SA02207.SAMPLE_LOCATION

distance downstream from top of study reach

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

Numeric domain: type=integer, min=-8.0000 (exclusive=false), max=49.0000 (exclusive=false)

STREAMBANK - char(1) (ordinal)

ID: SA02207.STREAMBANK

right or left bank looking upstream

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • L
    left bank looking upstream
  • R
    right bank looking upstream
  • M
    mid-channel bar
NEAREST_VEGETATION - char(11) (ordinal)

ID: SA02207.NEAREST_VEGETATION

vegetation species nearest basket

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • GYMNO1
    Coniferophyta
  • ACCI
    Acer circinatum
  • ACMA
    Acer macrophyllum
  • ALRU
    Alnus rubra
  • PSME
    Pseudotsuga menziesii
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • VAPA
    Vaccinium parvifolium
LITTERTYPE - varchar(30) (nominal)

ID: SA02207.LITTERTYPE

catagories of sorted litter

Type system: Microsoft SQL Server 2008

BIOMASS - numeric(4,2) (ratio)

ID: SA02207.BIOMASS

dry weight for time period

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 1

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

BIOMASS_PER_DAY - numeric(5,1) (ratio)

ID: SA02207.BIOMASS_PER_DAY

dry weight per day

Type system: Microsoft SQL Server 2008

Unit: milligrams per day

Precision: 1

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

Units
number per m2 number/m2 arealDensity numberPerMeterSquared numberPerMeterSquared 1 number or count per square meter
number per m2 per day number/m2*day arealDensityRate numberPerMeterSquaredPerDay numberPerMeterSquaredPerDay N/A number or count per square meter per day
percent % dimensionless number dimensionless 100 percent; a number
grams g mass gram kilogram 0.001 grams; 0.001 kilogram
milligrams per day mg/day massFlux milligramPerDay kilogramPerSecond 0.086400 milligrams per day
meters m length meter meter 1 meter; SI unit of length
number number dimensionless number dimensionless 1 dimensionless number, i.e., ratio, count
Related Datasets

No related dataset codes found in the EML text fields.

Related Publications
  • Frady, Charles; Johnson, Sherri; Li, Judy. 2007. Stream macroinvertebrate community responses as legacies of forest harvest at the H.J. Andrews Experimental Forest, Oregon. Forest Science. 53(2): 281-293.
  • Frady, Charles H. 2005. Headwater stream macroinvertebrates of the H.J. Andrews Experimental Forest, Oregon. Corvallis, OR: Oregon State University. 97 p. M.S. thesis.
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 (2007-05-30)
    Moved metadata into SQL from Excel spreadsheets. Used move_xls programs. Database level metadata added using the administrative interface. Ran QC on data. Uploaded most entities to SQL, but will wait until after duplicates are resolved (ent. 1 & 2) to uploaded the rest.
  • Version2 (2007-07-27)
    All data QC checked and uploaded to SQL Server.
  • Version5 (2011-09-15)
    Changed the data in entity 7 for nearest_vegetation from 'confer sp.' to 'GYMNO1'. Updated entity_update_history and ran admin/createcsv.cfm to create new file.
  • Version8 (2019-06-10)
    Added coordinates for two sites (WS_A and WS_B) and changed taxonomic_classif_if for WS1,2,7,8 to match Phenology (PE) sites. Metadata change only.