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

SA025: Aquatic and terrestrial insect activity phenology with trap collections at the Andrews Experimental Forest, 2009-2014

← Back to catalog index

Status: annually
Period: 2009-04-09 to 2014-07-02
Version: 5
Published: 2019-09-26
EDI Package ID: knb-lter-and.4782.5
Source XML: SA025_5.xml

Notice

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

Citation

Johnson, S.; Li, J. 2019. Aquatic and terrestrial insect activity phenology with trap collections at the Andrews Experimental Forest, 2009-2014 Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/SA025 Accessed 2026-05-10.

Abstract

This study was designed to evaluate the influence of microclimatic heterogeneity, associated with complex terrain, on phenology and to evaluate potential trophic responses to scenarios of climate change, disturbance and land use. We focus on a simplified model trophic system involving vascular plants, terrestrial and aquatic insects, and migratory neotropical and resident birds. The model trophic system is interesting because the phenologies of different components in the model system are independent (cued by various abiotic drivers) and dependent (due to trophic interactions), potentially leading to complex system behaviors. Plant and poiklothermic animal (ex. invertebrates) phenologies are highly temperature dependent. Phenologies of terrestrial plants and invertebrates would therefore likely exhibit wide spatial and temporal variation across the landscape in response to temperature variation associated with elevational differences, cold air drainages patterns, and temperature inversions. Aquatic invertebrate phenologies are also tied to temperature, but stream temperatures are influenced by different factors than those driving air temperatures and they may be less sensitive to complex terrain. For the invertebrate part of this study, we are examining spring-time (April through June) flying (terrestrial and adult aquatic) insect activity and adult aquatic insect emergence across a range of sites in the HJ Andrews Experimental Forest. Flying insect activity will be assessed using malaise traps deployed at 16 sites ranging from 450m to over 1300m in elevation, and with a variety of forest stand ages and slope aspects. Emerging aquatic insects will be collected with emergence traps in six 1st to 2nd order streams ranging from 450m to 1000m in elevation, and differing in water source (spring vs run-off) and surrounding forest age. Insects from malaise traps will be identified to varying levels from order to genus, depending on the group and available keys. Adult aquatic insects will be identified to varying levels from subfamily to species. We will be monitoring overall activity levels and emergence rates over time as well as the activity/emergence of selected key taxa. Data collection began in 2009 and is ongoing.

Coverage

Temporal coverage: 2009-04-09 to 2014-07-02

Geographic coverage: H. J. Andrews Experimental Forest, Oregon, USA

Spatial coverage:

Bounds: W -122.26077333, E -122.12050000, N 44.27447074, S 44.20664191

Purpose
  • We will assess the activity level of flying insects and emergence rates of adults of aquatic insects across the range of microclimates provided by the complex terrain at the HJ Andrews experimental forest. Our goal is to look at spatial and temporal variation within the Spring season, and to assess the variability among years. Invertebrate data will be combined with plant and bird phenology data to look for interactions among trophic levels. Data collected will provide a baseline which will be used to assess possible effects of climate and/or land-use change.
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
  • William J. Gerth
    Role: Other Researcher
    Oregon State University; Department of Fisheries and Wildlife; Nash Hall 104, Corvallis, OR, 97331, USA
    Phone: 541-737-1949
    Email: william.gerth@oregonstate.edu
  • 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: Creator
    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
Contact
  • Information Manager
    Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331
    Email: hjaweb@fsl.orst.edu
Publisher
  • Andrews Forest LTER Site
    Role: Publisher
    Forest Ecosystems and Society Department in Forestry, Oregon State University, 201K Richardson Hall, Corvallis, OR, 97331-5752
    Phone: (541) 737-8480
    Email: lterweb@fsl.orst.edu
Study Description

This study was designed to evaluate the influence of microclimatic heterogeneity, associated with complex terrain, on phenology and to evaluate potential trophic responses to scenarios of climate change, disturbance and land use. We focus on a simplified model trophic system involving vascular plants, terrestrial and aquatic insects, and migratory neotropical and resident birds. The model trophic system is interesting because the phenologies of different components in the model system are independent (cued by various abiotic drivers) and dependent (due to trophic interactions), potentially leading to complex system behaviors. Plant and poiklothermic animal (ex. invertebrates) phenologies are highly temperature dependent. Phenologies of terrestrial plants and invertebrates would therefore likely exhibit wide spatial and temporal variation across the landscape in response to temperature variation associated with elevational differences, cold air drainages patterns, and temperature inversions. Aquatic invertebrate phenologies are also tied to temperature, but stream temperatures are influenced by different factors than those driving air temperatures and they may be less sensitive to complex terrain. For the invertebrate part of this study, we are examining spring-time (April through June) flying (terrestrial and adult aquatic) insect activity and adult aquatic insect emergence across a range of sites in the HJ Andrews Experimental Forest. Flying insect activity will be assessed using malaise traps deployed at 16 sites ranging from 450m to over 1300m in elevation, and with a variety of forest stand ages and slope aspects. Emerging aquatic insects will be collected with emergence traps in six 1st to 2nd order streams ranging from 450m to 1000m in elevation, and differing in water source (spring vs run-off) and surrounding forest age. Insects from malaise traps will be identified to varying levels from order to genus, depending on the group and available keys. Adult aquatic insects will be identified to varying levels from subfamily to species. We will be monitoring overall activity levels and emergence rates over time as well as the activity/emergence of selected key taxa. Data collection began in 2009 and is ongoing. We will assess the activity level of flying insects and emergence rates of adults of aquatic insects across the range of microclimates provided by the complex terrain at the HJ Andrews experimental forest. Our goal is to look at spatial and temporal variation within the Spring season, and to assess the variability among years. Invertebrate data will be combined with plant and bird phenology data to look for interactions among trophic levels. Data collected will provide a baseline which will be used to assess possible effects of climate and/or land-use change. Field Methods - SA025

Purpose: We will assess the activity level of flying insects and emergence rates of adults of aquatic insects across the range of microclimates provided by the complex terrain at the HJ Andrews experimental forest. Our goal is to look at spatial and temporal variation within the Spring season, and to assess the variability among years. Invertebrate data will be combined with plant and bird phenology data to look for interactions among trophic levels. Data collected will provide a baseline which will be used to assess possible effects of climate and/or land-use change.

Methods

Method Steps

Field Methods - SA025
  • Malaise and emergence traps: Trap samples are collected continuously at intervals from April (or when sites become accessible after snow has melted) through June each year. Malaise traps samples are collected approximately weekly; emergence samples are collected approximately twice a week. Malaise samples are collected from single traps hung from trees at each of the 16 core phenology sites. Emerging insects are collected with 4 emergence traps (sampling area 0.3 square meters of stream bottom for each trap) at each of the 6 study streams; samples from individual traps are combined by site in the field. Samples collected are preserved with 95% ethanol.
Laboratory Methods - SA025
  • All insect samples are examined using a binocular dissecting microscope in the lab. To get detailed information on a subset of samples and general information on most all of the samples, samples are fully or partially processed. For malaise trap samples, flying adult insects in fully processed samples are enumerated and identified to varying taxonomic levels from order to genus depending on the availability of keys and the ease of their use (McAlpine et al. 1981, Covell 1984, Arnett 2000, Arnett and Thomas 2001, Arnett et al. 2002, Triplehorn and Johnson 2005, Merritt and Cummins 2008). For partially processed samples, total counts of flying insects and counts of 3 widespread insect genera (Diptera:Dolichopodidae:Scellus, Diptera:Rhagionidae:Bolbomyia, and Coleoptera:Scraptiidae:Anaspis) are made. For emergence samples, adults of aquatic insects in fully processed samples are enumerated and identified to varying taxonomic levels from family to species depending on the availability of keys and the ease of their use (Usinger 1956, Jewett 1959, Lehmkuhl and Anderson 1971, McAlpine et al. 1981, Harper and Harper 1986, Armitage 1996, Stewart and Oswood 2006, Merritt and Cummins 2008). Individuals of the family Chironomidae are identified to sub-family or tribe. For partially processed emergence samples individuals in 4 widespread species (Plecoptera:Chloroplerlidae:Alloperla fraterna, Plecoptera:Leuctridae:Moselia infuscata, Ephemeroptera:Leptophlebiidae:Paraleptophlebia temporalis, and Trichoptera:Philopotamidae:Dolophilodes dorcus) were enumerated.
Statistics - SA025
  • For specific time periods, sites with fully processed samples are compared in terms of total and genus-specific flying insect activity (malaise trap samples) and total and species-specific adult aquatic insect emergence rates (emergence trap samples). Correlations with site elevations and short- and longer-term thermal patterns are examined. Using fully and partially processed samples, sites are compared in terms of cumulative springtime captures of 3 widespread flying insect genera (malaise traps) and cumulative captures per square meter of 4 widespread emerging adults of aquatic insects. Again correlations with site elevations and short- and longer-term thermal patterns are examined.
Taxonomic Procedures - SA025
  • The following publications were consulted for identifications. Taxonomic name changes were followed in the literature and on ITIS (http://www.itis.gov/). Additional assistance with caddisfly identification was provided by R.W. Wisseman.
Models/Algorithms - SA025
  • Flying insect activity level (number/day) is calculated by the number of winged individuals in a malaise trap sample / number of days trap was set. Emergence rate (number per square meter per day) is calculated by the number of individuals emerging from the collected traps during sampling interval / area of streambottom sampled / number of days traps were set.

Sampling

Study Extent
  • Sampling frequency: continuous April through June each year
Sampling Description
  • To examine spatial and temporal variation in insect phenology in complex terrain we collect continuous samples of flying insects and emerging adults of aquatic insects each spring (April through June) from 2009 until the study ends. Flying insects are collected with single malaise traps at each of the 16 core phenology sites. Emerging insects are collected with 4 emergence traps at each of the 6 study streams. We are looking for patterns for all insects combined, and for selected species that are widespread throughout the HJ Andrews. Year round temperature data are also collected at each sampling location so that insect phenologies can be related to short-term and annual thermal patterns. Concurrent plant and bird phenology data collected at core phenology sites will be compared with insect data to look for interactions among trophic levels.
Spatial Sampling Units
  • Andrews Experimental Forest (HJA)
    W -122.26172200, E -122.10084700, N 44.28196400, S 44.19770400
    Altitude: 1631 to 1631 meter
  • HJA Phenology Core Site 001 (WS01)
    W -122.25715110, E -122.25715110, N 44.20664191, S 44.20664191
    Altitude: 459 to 459 meter
  • HJA Phenology Core Site 002 (CS2MET/RS07)
    W -122.24967644, E -122.24967644, N 44.21401836, S 44.21401836
    Altitude: 488 to 488 meter
  • HJA Phenology Core Site 004 (RS89)
    W -122.26077333, E -122.26077333, N 44.21742613, S 44.21742613
    Altitude: 481 to 481 meter
  • HJA Phenology Core Site 005 (RS86)
    W -122.25780000, E -122.25780000, N 44.21950000, S 44.21950000
    Altitude: 643 to 643 meter
  • HJA Phenology Core Site 007 (RS05)
    W -122.20252664, E -122.20252664, N 44.22218859, S 44.22218859
    Altitude: 903 to 903 meter
  • HJA Phenology Core Site 008 (RS32)
    W -122.19113780, E -122.19113780, N 44.23530330, S 44.23530330
    Altitude: 647 to 647 meter
  • HJA Phenology Core Site 009 (RS12)
    W -122.12174888, E -122.12174888, N 44.22717245, S 44.22717245
    Altitude: 979 to 979 meter
  • HJA Phenology Core Site 010 (Decomp site 5/CENMET)
    W -122.14276865, E -122.14276865, N 44.24209415, S 44.24209415
    Altitude: 994 to 994 meter
  • HJA Phenology Core Site 011 (L303/371 RD 350)
    W -122.15130105, E -122.15130105, N 44.25067222, S 44.25067222
    Altitude: 1116 to 1116 meter
  • HJA Phenology Core Site 012 (RS18)
    W -122.15895568, E -122.15895568, N 44.24627228, S 44.24627228
    Altitude: 1081 to 1081 meter
  • HJA Phenology Core Site 013 (RS21)
    W -122.13622203, E -122.13622203, N 44.24924626, S 44.24924626
    Altitude: 1178 to 1178 meter
  • HJA Phenology Core Site 014 (RS03)
    W -122.15925000, E -122.15925000, N 44.25911944, S 44.25911944
    Altitude: 965 to 965 meter
  • HJA Phenology Core Site 015 (WS08)
    W -122.17020059, E -122.17020059, N 44.26621172, S 44.26621172
    Altitude: 971 to 971 meter
  • HJA Phenology Core Site 016 (NADP/WS07)
    W -122.17786922, E -122.17786922, N 44.26749545, S 44.26749545
    Altitude: 1030 to 1030 meter
  • HJA Phenology Core Site 017 (RS04)
    W -122.13697290, E -122.13697290, N 44.27312824, S 44.27312824
    Altitude: 1302 to 1302 meter
  • HJA Phenology Core Site 018 (L306 RD 350)
    W -122.13525278, E -122.13525278, N 44.27447074, S 44.27447074
    Altitude: 1334 to 1334 meter
  • HJA Phenology Sites
    W -122.26083000, E -122.11159208, N 44.28199677, S 44.20198189
    Altitude: 1314 to 1314 meter
  • 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
  • HJA Phenology Emergence Site 5 (Cold Creek)
    W -122.12400000, E -122.12400000, N 44.22950000, S 44.22950000
    Altitude: 1000 to 1000 meter
  • HJA Phenology Emergence Site 6 (South Creek)
    W -122.12050000, E -122.12050000, N 44.22720000, S 44.22720000
    Altitude: 1000 to 1000 meter
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: habitats (theme), communities (theme), populations (theme), biodiversity (theme), spatial variability (theme), aquatic ecosystems (theme), streams (theme), invertebrates (theme), aquatic invertebrates (theme), arthropods (theme), insects (theme), birds (theme)
  • Andrews Experimental Forest site thesaurus: Long-Term Ecological Research (LTER) (theme), entomology (theme), temporal variability (theme)
  • LTER core research areas: populations (theme)
Taxonomic Hierarchy
  • All Organisms: All Organisms
  • Highest common category (ca. kingdom): Animalia
  • Division or Phylum: Arthropoda
  • Class: Insecta
  • Order: Coleoptera
  • Family: Hydraenidae
  • Genus: Hydraena
  • Order: Hemiptera
  • Family: Gerridae
  • Genus: Aquarius
  • Order: Ephemeroptera
  • Family: Leptophlebiidae
  • Genus: Paraleptophlebia
  • Family: Ameletidae
  • Genus: Ameletus
  • Family: Baetidae
  • Genus: Baetis
  • Genus: Diphetor
  • Family: Heptageniidae
  • Genus: Cinygmula
  • Genus: Cinygma
  • Genus: Epeorus
  • Family: Ephemerellidae
  • Genus: Ephemerella
  • Genus: Drunella
  • Order: Diptera
  • Family: Trichoceridae
  • Genus: Paracladura
  • Family: Simuliidae
  • Genus: Prosimulium
  • Family: Dixidae
  • Family: Psychodidae
  • Genus: Maruina
  • Subfamily: Psychodinae
  • Family: Tipulidae
  • Genus: Molophilus
  • Genus: Limonia
  • Genus: Dicranota
  • Genus: Limnophila
  • Genus: Pedicia
  • Family: Blephariceridae
  • Genus: Agathon
  • Family: Culicidae
  • Genus: Aedes
  • Family: Empididae
  • Genus: Thanategia
  • Genus: Dolichocephala
  • Genus: Neoplasta
  • Genus: Chelifera
  • Genus: Oreothalia
  • Genus: Clinocera
  • Genus: Trichoclinocera
  • Genus: Ceratopogon
  • Family: Ceratopogonidae
  • Family: Chironomidae
  • Subfamily: Diamesinae
  • Genus: Tanypodinae
  • Subfamily: Orthocladiinae
  • Genus: Podonominae
  • Subfamily: Chironominae
  • Order: Plecoptera
  • Family: Peltoperlidae
  • Genus: Yoraperla
  • Family: Leuctridae
  • Genus: Moselia
  • Genus: Paraleuctra
  • Genus: Pomoleuctra
  • Family: Perlodidae
  • Genus: Chernokrilus
  • Family: Perlidae
  • Genus: Calineuria
  • Family: Chloroperlidae
  • Genus: Alloperla
  • Genus: Kathroperla
  • Genus: Sweltsa
  • Family: Capniidae
  • Genus: Capnia
  • Genus: Eucapnopsis
  • Genus: Paracapnia
  • Family: Nemouridae
  • Genus: Ostrocerca
  • Genus: Visoka
  • Genus: Soyedina
  • Genus: Malenka
  • Genus: Zapada
  • Genus: Calliperla
  • Order: Trichoptera
  • Family: Polycentropodidae
  • Genus: Polycentropus
  • Family: Arctopsychidae
  • Genus: Parapsyche
  • Family: Lepidostomatidae
  • Genus: Lepidostoma
  • Family: Goeridae
  • Genus: Goeracea
  • Genus: Lepania
  • Family: Philopotamidae
  • Genus: Dolophilodes
  • Genus: Wormaldia
  • Family: Limnephilidae
  • Genus: Pseudostenophylax
  • Genus: Ecclisomyia
  • Genus: Apatania
  • Family: Glossosomatidae
  • Genus: Glossosoma
  • Genus: Anagapetus
  • Family: Brachycentridae
  • Genus: Micrasema
  • Family: Odontoceridae
  • Genus: Namamyia
  • Family: Rhyacophilidae
  • Genus: Rhyacophila
  • Family: Uenoidae
  • Genus: Farula
Data Entities
# Entity Metadata Data
1 SA02501
SA02501
Malaise Trap data:
METADATA DATA
2 SA02502
SA02502
Aquatic Insect Emergence data:
METADATA DATA
3 SA02503
SA02503
Beetle Trap data:
METADATA DATA
4 SA02504
SA02504
Aquatic Insect Emergence Genus data:
METADATA DATA
Metadata
SA02501 - SA02501

Object name: SA02501.csv

Records: 1045

Attributes: 15

Temporal coverage: 2009-05-05 to 2014-07-02

File size: 77627 byte

Checksum (MD5): e154b8f8e8b0723a0a6825dacf3e38fc

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

Constraints (2)
  • primaryKey: PRIMARY
    SA02501.SITE_ID, SA02501.YEAR, SA02501.TRAP_TYPE, SA02501.TRAP_NO
  • notNullConstraint: NOTNULL
    SA02501.ANASPIS, SA02501.BOLBOMYIA, SA02501.DAYS_SET, SA02501.DBCODE, SA02501.SAMPLE_ID, SA02501.ENTITY, SA02501.PICKUP_DATE, SA02501.SCELLUS, SA02501.SET_DATE, SA02501.SITE_ID, SA02501.YEAR, SA02501.TRAP_TYPE, SA02501.TRAP_NO
Attributes (15)
DBCODE - char(5) (nominal)

ID: SA02501.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

ID: SA02501.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SAMPLE_ID - char(10) (nominal)

ID: SA02501.SAMPLE_ID

unique sample code; identifies the type of trap, site, year and sample number

Type system: Microsoft SQL Server 2008

TRAP_TYPE - char(1) (ordinal)

ID: SA02501.TRAP_TYPE

Type of trap used in the field for sampling

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • M
    Malaise Trap
  • E
    Emergent Trap for aquatic insects
  • B
    Beetle Trap
SITE_ID - char(5) (nominal)

ID: SA02501.SITE_ID

Site code

Type system: Microsoft SQL Server 2008

Code definitions (22)
  • PC001
    HJA Phenology Core Site 001 (WS01)
  • PC002
    HJA Phenology Core Site 002 (CS2MET/RS07)
  • PC004
    HJA Phenology Core Site 004 (RS89)
  • PC005
    HJA Phenology Core Site 005 (RS86)
  • PC007
    HJA Phenology Core Site 007 (RS05)
  • PC008
    HJA Phenology Core Site 008 (RS32)
  • PC009
    HJA Phenology Core Site 009 (RS12)
  • PC010
    HJA Phenology Core Site 010 (Decomp site 5/CENMET)
  • PC011
    HJA Phenology Core Site 011 (L303/371 RD 350)
  • PC012
    HJA Phenology Core Site 012 (RS18)
  • PC013
    HJA Phenology Core Site 013 (RS21)
  • PC014
    HJA Phenology Core Site 014 (RS03)
  • PC015
    HJA Phenology Core Site 015 (WS08)
  • PC016
    HJA Phenology Core Site 016 (NADP/WS07)
  • PC017
    HJA Phenology Core Site 017 (RS04)
  • PC018
    HJA Phenology Core Site 018 (L306 RD 350)
  • PE001
    HJA Phenology Emergence Site 1 (WS01 stream)
  • PE002
    HJA Phenology Emergence Site 2 (WS02 stream)
  • PE003
    HJA Phenology Emergence Site 3 (WS08 stream)
  • PE004
    HJA Phenology Emergence Site 4 (WS07 stream)
  • PE005
    HJA Phenology Emergence Site 5 (Cold Creek)
  • PE006
    HJA Phenology Emergence Site 6 (South Creek)
YEAR - numeric(4,0) (interval)

ID: SA02501.YEAR

year of sample collection

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1

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

TRAP_NO - numeric(2,0) (ratio)

ID: SA02501.TRAP_NO

Trap number for a given site, trap type and year

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SET_DATE - datetime (dateTime)

ID: SA02501.SET_DATE

trap set date

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

PICKUP_DATE - datetime (dateTime)

ID: SA02501.PICKUP_DATE

trap sample collection date

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

DAYS_SET - numeric(2,0) (ratio)

ID: SA02501.DAYS_SET

days trap set

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

TOTAL_WINGED - numeric(4,0) (ratio)

ID: SA02501.TOTAL_WINGED

total number of winged insects in sample

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SCELLUS - numeric(2,0) (ratio)

ID: SA02501.SCELLUS

number of Scellus in sample

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

BOLBOMYIA - numeric(2,0) (ratio)

ID: SA02501.BOLBOMYIA

number of Bolbomyia in sample

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

ANASPIS - numeric(2,0) (ratio)

ID: SA02501.ANASPIS

number of Anaspis in sample

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

COMMENTS - varchar(100) (nominal)

ID: SA02501.COMMENTS

comments

Type system: Microsoft SQL Server 2008

SA02502 - SA02502

Object name: SA02502.csv

Records: 708

Attributes: 18

Temporal coverage: 2009-04-09 to 2014-06-30

File size: 62909 byte

Checksum (MD5): 036374d7b3fde85911b92b5e212f1736

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

Constraints (2)
  • primaryKey: PRIMARY
    SA02502.SITE_ID, SA02502.YEAR, SA02502.TRAP_TYPE, SA02502.TRAP_NO
  • notNullConstraint: NOTNULL
    SA02502.ALLOPERLA_FRATERNA, SA02502.DAYS_SET, SA02502.DBCODE, SA02502.DOLOPHILODES_DORCUS, SA02502.SAMPLE_ID, SA02502.ENTITY, SA02502.MOSELIA_INFUSCATA, SA02502.PARALEPTOPHLEBIA_TEMPORALIS, SA02502.PICKUP_DATE, SA02502.SET_DATE, SA02502.SITE_ID, SA02502.YEAR, SA02502.TRAP_TYPE, SA02502.TRAP_NO
Attributes (18)
DBCODE - char(5) (nominal)

ID: SA02502.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

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

SAMPLE_ID - char(10) (nominal)

ID: SA02502.SAMPLE_ID

unique sample code; identifies the type of trap, site, year and sample number

Type system: Microsoft SQL Server 2008

TRAP_TYPE - char(1) (ordinal)

ID: SA02502.TRAP_TYPE

Type of trap used in the field for sampling

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • M
    Malaise Trap
  • E
    Emergent Trap for aquatic insects
  • B
    Beetle Trap
SITE_ID - char(5) (nominal)

ID: SA02502.SITE_ID

Site code

Type system: Microsoft SQL Server 2008

Code definitions (22)
  • PC001
    HJA Phenology Core Site 001 (WS01)
  • PC002
    HJA Phenology Core Site 002 (CS2MET/RS07)
  • PC004
    HJA Phenology Core Site 004 (RS89)
  • PC005
    HJA Phenology Core Site 005 (RS86)
  • PC007
    HJA Phenology Core Site 007 (RS05)
  • PC008
    HJA Phenology Core Site 008 (RS32)
  • PC009
    HJA Phenology Core Site 009 (RS12)
  • PC010
    HJA Phenology Core Site 010 (Decomp site 5/CENMET)
  • PC011
    HJA Phenology Core Site 011 (L303/371 RD 350)
  • PC012
    HJA Phenology Core Site 012 (RS18)
  • PC013
    HJA Phenology Core Site 013 (RS21)
  • PC014
    HJA Phenology Core Site 014 (RS03)
  • PC015
    HJA Phenology Core Site 015 (WS08)
  • PC016
    HJA Phenology Core Site 016 (NADP/WS07)
  • PC017
    HJA Phenology Core Site 017 (RS04)
  • PC018
    HJA Phenology Core Site 018 (L306 RD 350)
  • PE001
    HJA Phenology Emergence Site 1 (WS01 stream)
  • PE002
    HJA Phenology Emergence Site 2 (WS02 stream)
  • PE003
    HJA Phenology Emergence Site 3 (WS08 stream)
  • PE004
    HJA Phenology Emergence Site 4 (WS07 stream)
  • PE005
    HJA Phenology Emergence Site 5 (Cold Creek)
  • PE006
    HJA Phenology Emergence Site 6 (South Creek)
YEAR - numeric(4,0) (interval)

ID: SA02502.YEAR

year of sample collection

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1

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

TRAP_NO - numeric(2,0) (ratio)

ID: SA02502.TRAP_NO

Trap number for a given site, trap type and year

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SET_DATE - datetime (dateTime)

ID: SA02502.SET_DATE

trap set date

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

PICKUP_DATE - datetime (dateTime)

ID: SA02502.PICKUP_DATE

trap sample collection date

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

DAYS_SET - numeric(2,0) (ratio)

ID: SA02502.DAYS_SET

days trap set

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

TRAPS_PICKED_UP - numeric(3,1) (ratio)

ID: SA02502.TRAPS_PICKED_UP

number of traps

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

AREA_SAMPLED - numeric(4,2) (ratio)

ID: SA02502.AREA_SAMPLED

stream-bottom area sampled in square meters

Type system: Microsoft SQL Server 2008

Unit: square meters

Precision: 1

Numeric domain: type=real, min=0.3000 (exclusive=false), max=1.2000 (exclusive=false)

TOTAL_AQUATIC_ADULTS - numeric(3,0) (ratio)

ID: SA02502.TOTAL_AQUATIC_ADULTS

total number of winged insects in sample

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

ALLOPERLA_FRATERNA - numeric(2,0) (ratio)

ID: SA02502.ALLOPERLA_FRATERNA

number of Alloperla fraterna in sample

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

DOLOPHILODES_DORCUS - numeric(2,0) (ratio)

ID: SA02502.DOLOPHILODES_DORCUS

number of Dolophilodes dorcus in sample

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

PARALEPTOPHLEBIA_TEMPORALIS - numeric(2,0) (ratio)

ID: SA02502.PARALEPTOPHLEBIA_TEMPORALIS

number of Paraleptophlebia temporalis in sample

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

MOSELIA_INFUSCATA - numeric(2,0) (ratio)

ID: SA02502.MOSELIA_INFUSCATA

number of Moselia infuscata in sample

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

COMMENTS - varchar(100) (nominal)

ID: SA02502.COMMENTS

comments

Type system: Microsoft SQL Server 2008

SA02503 - SA02503

Object name: SA02503.csv

Records: 1110

Attributes: 14

Temporal coverage: 2012-05-03 to 2014-07-02

File size: 81311 byte

Checksum (MD5): 32a5c1a69ca62ccab1708f1e4678ce36

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

Constraints (2)
  • primaryKey: PRIMARY
    SA02503.SITE_ID, SA02503.YEAR, SA02503.TRAP_TYPE, SA02503.TRAP_NO, SA02503.REP
  • notNullConstraint: NOTNULL
    SA02503.DAYS_SET, SA02503.DBCODE, SA02503.SAMPLE_ID, SA02503.ENTITY, SA02503.PICKUP_DATE, SA02503.SET_DATE, SA02503.SITE_ID, SA02503.YEAR, SA02503.TRAP_TYPE, SA02503.TRAP_NO, SA02503.REP
Attributes (14)
DBCODE - char(5) (nominal)

ID: SA02503.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

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

SAMPLE_ID - char(10) (nominal)

ID: SA02503.SAMPLE_ID

unique sample code; identifies the type of trap, site, year and sample number

Type system: Microsoft SQL Server 2008

TRAP_TYPE - char(1) (ordinal)

ID: SA02503.TRAP_TYPE

Type of trap used in the field for sampling

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • M
    Malaise Trap
  • E
    Emergent Trap for aquatic insects
  • B
    Beetle Trap
SITE_ID - char(5) (nominal)

ID: SA02503.SITE_ID

Site code

Type system: Microsoft SQL Server 2008

Code definitions (22)
  • PC001
    HJA Phenology Core Site 001 (WS01)
  • PC002
    HJA Phenology Core Site 002 (CS2MET/RS07)
  • PC004
    HJA Phenology Core Site 004 (RS89)
  • PC005
    HJA Phenology Core Site 005 (RS86)
  • PC007
    HJA Phenology Core Site 007 (RS05)
  • PC008
    HJA Phenology Core Site 008 (RS32)
  • PC009
    HJA Phenology Core Site 009 (RS12)
  • PC010
    HJA Phenology Core Site 010 (Decomp site 5/CENMET)
  • PC011
    HJA Phenology Core Site 011 (L303/371 RD 350)
  • PC012
    HJA Phenology Core Site 012 (RS18)
  • PC013
    HJA Phenology Core Site 013 (RS21)
  • PC014
    HJA Phenology Core Site 014 (RS03)
  • PC015
    HJA Phenology Core Site 015 (WS08)
  • PC016
    HJA Phenology Core Site 016 (NADP/WS07)
  • PC017
    HJA Phenology Core Site 017 (RS04)
  • PC018
    HJA Phenology Core Site 018 (L306 RD 350)
  • PE001
    HJA Phenology Emergence Site 1 (WS01 stream)
  • PE002
    HJA Phenology Emergence Site 2 (WS02 stream)
  • PE003
    HJA Phenology Emergence Site 3 (WS08 stream)
  • PE004
    HJA Phenology Emergence Site 4 (WS07 stream)
  • PE005
    HJA Phenology Emergence Site 5 (Cold Creek)
  • PE006
    HJA Phenology Emergence Site 6 (South Creek)
YEAR - numeric(4,0) (interval)

ID: SA02503.YEAR

year of sample collection

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1

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

TRAP_NO - numeric(2,0) (ratio)

ID: SA02503.TRAP_NO

Trap number for a given site, trap type and year

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

REP - char(1) (nominal)

ID: SA02503.REP

Replicate for a given site, trap type, trap number and year

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • A
    Sample A
  • B
    Sample B
  • C
    Sample C
SET_DATE - datetime (dateTime)

ID: SA02503.SET_DATE

trap set date

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

PICKUP_DATE - datetime (dateTime)

ID: SA02503.PICKUP_DATE

trap sample collection date

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

DAYS_SET - numeric(2,0) (ratio)

ID: SA02503.DAYS_SET

days trap set

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

TOTAL_BEETLE - numeric(3,0) (ratio)

ID: SA02503.TOTAL_BEETLE

total number of beetles in sample

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

TOTAL_FUNGUS_GNAT - numeric(3,0) (ratio)

ID: SA02503.TOTAL_FUNGUS_GNAT

total number offungus gnats in sample

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

COMMENTS - varchar(100) (nominal)

ID: SA02503.COMMENTS

comments

Type system: Microsoft SQL Server 2008

SA02504 - SA02504

Object name: SA02504.csv

Records: 1033

Attributes: 15

Temporal coverage: 2011-04-05 to 2011-07-08

File size: 91133 byte

Checksum (MD5): b0b9da6a8df20da244952c50763e423b

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

Constraints (2)
  • primaryKey: PRIMARY
    SA02504.DAYS_SET, SA02504.SET_DATE, SA02504.SITE_ID, SA02504.TAXON, SA02504.YEAR, SA02504.TRAP_TYPE, SA02504.TRAP_NO
  • notNullConstraint: NOTNULL
    SA02504.AREA_SAMPLED, SA02504.DAYS_SET, SA02504.DBCODE, SA02504.SAMPLE_ID, SA02504.ENTITY, SA02504.PICKUP_DATE, SA02504.SET_DATE, SA02504.SITE_ID, SA02504.TAXON, SA02504.TAXON_COUNT, SA02504.TRAPS_PICKED_UP, SA02504.YEAR, SA02504.TRAP_TYPE, SA02504.TRAP_NO
Attributes (15)
DBCODE - char(5) (nominal)

ID: SA02504.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

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

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

SAMPLE_ID - char(10) (nominal)

ID: SA02504.SAMPLE_ID

unique sample code; identifies the type of trap, site, year and sample number

Type system: Microsoft SQL Server 2008

TRAP_TYPE - char(1) (ordinal)

ID: SA02504.TRAP_TYPE

Type of trap used in the field for sampling

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • M
    Malaise Trap
  • E
    Emergent Trap for aquatic insects
  • B
    Beetle Trap
SITE_ID - char(5) (nominal)

ID: SA02504.SITE_ID

Site code

Type system: Microsoft SQL Server 2008

Code definitions (22)
  • PC001
    HJA Phenology Core Site 001 (WS01)
  • PC002
    HJA Phenology Core Site 002 (CS2MET/RS07)
  • PC004
    HJA Phenology Core Site 004 (RS89)
  • PC005
    HJA Phenology Core Site 005 (RS86)
  • PC007
    HJA Phenology Core Site 007 (RS05)
  • PC008
    HJA Phenology Core Site 008 (RS32)
  • PC009
    HJA Phenology Core Site 009 (RS12)
  • PC010
    HJA Phenology Core Site 010 (Decomp site 5/CENMET)
  • PC011
    HJA Phenology Core Site 011 (L303/371 RD 350)
  • PC012
    HJA Phenology Core Site 012 (RS18)
  • PC013
    HJA Phenology Core Site 013 (RS21)
  • PC014
    HJA Phenology Core Site 014 (RS03)
  • PC015
    HJA Phenology Core Site 015 (WS08)
  • PC016
    HJA Phenology Core Site 016 (NADP/WS07)
  • PC017
    HJA Phenology Core Site 017 (RS04)
  • PC018
    HJA Phenology Core Site 018 (L306 RD 350)
  • PE001
    HJA Phenology Emergence Site 1 (WS01 stream)
  • PE002
    HJA Phenology Emergence Site 2 (WS02 stream)
  • PE003
    HJA Phenology Emergence Site 3 (WS08 stream)
  • PE004
    HJA Phenology Emergence Site 4 (WS07 stream)
  • PE005
    HJA Phenology Emergence Site 5 (Cold Creek)
  • PE006
    HJA Phenology Emergence Site 6 (South Creek)
YEAR - numeric(4,0) (interval)

ID: SA02504.YEAR

year of sample collection

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1

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

TRAP_NO - numeric(2,0) (ratio)

ID: SA02504.TRAP_NO

Trap number for a given site, trap type and year

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SET_DATE - datetime (dateTime)

ID: SA02504.SET_DATE

trap set date

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

PICKUP_DATE - datetime (dateTime)

ID: SA02504.PICKUP_DATE

trap sample collection date

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

DAYS_SET - numeric(2,0) (ratio)

ID: SA02504.DAYS_SET

days trap set

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

TRAPS_PICKED_UP - numeric(3,1) (ratio)

ID: SA02504.TRAPS_PICKED_UP

number of traps

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

AREA_SAMPLED - numeric(4,2) (ratio)

ID: SA02504.AREA_SAMPLED

stream-bottom area sampled in square meters

Type system: Microsoft SQL Server 2008

Unit: square meters

Precision: 1

Numeric domain: type=real, min=0.9000 (exclusive=false), max=1.2000 (exclusive=false)

TAXON - char(25) (nominal)

ID: SA02504.TAXON

taxon identified, mainly genus

Type system: Microsoft SQL Server 2008

Code definitions (74)
  • Aedes
    Aedes
  • Agathon
    Agathon
  • Alloperla
    Alloperla
  • Ameletus
    Ameletus
  • Anagapetus
    Anagapetus
  • Apatania
    Apatania
  • Baetis
    Baetis
  • Calineuria
    Calineuria
  • Capnia
    Capnia
  • Chernokrilus
    Chernokrilus
  • Cinygma
    Cinygma
  • Cinygmula
    Cinygmula
  • Clinocera
    Clinocera
  • Dicranota
    Dicranota
  • Diphetor
    Diphetor
  • Dolophilodes
    Dolophilodes
  • Drunella
    Drunella
  • Ecclisomyia
    Ecclisomyia
  • Epeorus
    Epeorus
  • Ephemerella
    Ephemerella
  • Eucapnopsis
    Eucapnopsis
  • Goeracea
    Goeracea
  • Kathroperla
    Kathroperla
  • Lepidostoma
    Lepidostoma
  • Limnophila
    Limnophila
  • Limonia
    Limonia
  • Malenka
    Malenka
  • Maruina
    Maruina
  • Micrasema
    Micrasema
  • Moselia
    Moselia
  • Namamyia
    Namamyia
  • Oreothalia
    Oreothalia
  • Paracapnia
    Paracapnia
  • Paraleptophlebia
    Paraleptophlebia
  • Paraleuctra
    Paraleuctra
  • Parapsyche
    Parapsyche
  • Pedicia
    Pedicia
  • Polycentropus
    Polycentropus
  • Prosimulium
    Prosimulium
  • Pseudostenophylax
    Pseudostenophylax
  • Rhyacophila
    Rhyacophila
  • Soyedina
    Soyedina
  • Sweltsa
    Sweltsa
  • Visoka
    Visoka
  • Wormaldia
    Wormaldia
  • Yoraperla
    Yoraperla
  • Zapada
    Zapada
  • Gerridae
    Gerridae
  • Ceratopogonidae
    Ceratopogonidae
  • Dixidae
    Dixidae
  • Heptageniidae
    Heptageniidae
  • Simuliidae
    Simuliidae
  • Tipulidae
    Tipulidae
  • Chelifera
    Chelifera
  • Calliperla
    Calliperla
  • Hydraena
    Hydraena
  • Lepania
    Lepania
  • Molophilus
    Molophilus
  • Orthocladiinae
    Orthocladiinae
  • Ostrocerca
    Ostrocerca
  • Podonominae
    Podonominae
  • Tanypodinae
    Tanypodinae
  • Trichoclinocera
    Trichoclinocera
  • Neoplasta
    Neoplasta
  • Aquarius
    Aquarius
  • Glossosoma
    Glossosoma
  • Chironominae
    Chironominae
  • Diamesinae
    Diamesinae
  • Psychodinae
    Psychodinae
  • Dolichocephala
    Dolichocephala
  • Farula
    Farula
  • Paracladura
    Paracladura
  • Pomoleuctra
    Pomoleuctra
  • Thanategia
    Thanategia
TAXON_COUNT - numeric(3,0) (ratio)

ID: SA02504.TAXON_COUNT

number of the taxon in sample

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

COMMENTS - varchar(100) (nominal)

ID: SA02504.COMMENTS

comments

Type system: Microsoft SQL Server 2008

Units
square meters m2 area meterSquared meterSquared 1 square meters
year (yyyy) YYYY datetime YYYY YYYY-MM-DDThh:mm:ss N/A year (4 character) portion of date
number number dimensionless number dimensionless 1 dimensionless number, i.e., ratio, count
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: annually

Description

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

Change History

  • Version1 (2009-04-09)
    Original creation of metadata into SQL
  • Version2 (2015-06-08)
    Imported metadata from Excel file and data from CSV file. Ran QC. Created SQL structures and appended data for all 4 entities. Data through 2013.
  • Version4 (2016-10-21)
    Uploaded new data and corrected problems with attribute domains. Data tables for entities 1-3 are completely new and restructured.