TP103: Species interactions during succession in the western Cascade Range of Oregon, 1990 to present
Notice
"As Is" Basis: All content, including maps and forecasts, is provided without warranties. Users are advised to independently verify critical information.
Citation
Halpern, C. 2024. Species interactions during succession in the western Cascade Range of Oregon, 1990 to present Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/TP103 Accessed 2026-05-10.
Abstract
The factors that contribute to plant species establishment and decline following disturbance determine the rates and patterns of successional change of a system. In this long-term field experiment, we test the commonly held assumption that competition for space or resources by dominant species determines the outcome of succession. Specifically, we examine the population- and community-level consequences of removing one or more potentially dominant species from the post-disturbance community after clearcut logging and burning of a mature/old-growth Douglas-fir forest. Experimental treatments include: (1) removal of early-seral annual, Senecio sylvaticus, or perennial, Epilobium angustifolium—or both—to test the influences of these early-seral dominants on subsequent community development; (2) removal of all species except Senecio or Epilobium, to test whether the decline of these early-seral dominants is driven by competitive displacement; or (3) removal of shade-tolerant forest species that dominate subsequent stages of succession—Rubus ursinus or Berberis nervosa plus Gaultheria shallon—to test the influences of these long-lived perennials on understory development. The experiment is a randomized block design comprising eight removal treatments plus a control replicated in each of 25 blocks. Removal (reduction in competition) is achieved by removing seedlings or vegetative stems annually from a treatment area of 2.5 x 2.5 m. Sample plots (1 x 1 m) centered within these are used to estimate cover of all vascular plant species and, for the first 8 yr of the experiment, stem density and height, facilitating estimates of above-ground biomass. Pre-harvest data were collected in 1990, logging/burning occurred in 1991, and removal treatments and post-treatment sampling were initiated in 1992. Six of the nine experimental treatments were terminated between 1996 and 1998, with loss of early-seral Senecio and Epilobium from the system. The remaining three treatments (removal of Rubus, removal of Berberis plus Gaultheria, and the control) have been sampled annually since 1992. All regeneration of trees within the experimental area has occurred naturally. In September 2018, the study site was subjected to a controlled burn to limit spread of the Terwilliger Fire from the north. In 2019, plots were assessed for burn severity. Species' removals were terminated, but cover measurements continue in the plots.
Coverage
Temporal coverage: 1990-07-01 to 2024-07-03
Geographic coverage: West of the south fork of the McKenzie River, north of Augusta Creek, western Cascades, Oregon.
Spatial coverage:
Bounds: W -122.18500900, E -122.18500900, N 44.00302200, S 44.00302200
Purpose
- To test the role of competitive interactions in shaping the early successional dynamics of understory species in Douglas-fir forests of the western Cascades.
Project
Title: Long-Term Ecological Research
Personnel
-
Posy Elizabeth Busby - Principal Investigator Assistant Professor OSU Botany & Plant PathologyEmail: busbyp@science.oregonstate.edu, posybusby@gmail.comORCID: 0000-0002-2837-9820
-
Matthew G Betts - Principal Investigator Department of Forest Ecosystems and Society; 201E Richardson Hall; College of Forestry; Oregon State University, Corvallis, OR, 97331Phone: (541) 737-3841Email: matt.betts@oregonstate.eduORCID: 0000-0002-7100-2551
-
Brooke E. Penaluna - Principal Investigator Email: brooke.penaluna@usda.gov, Brooke.Penaluna@oregonstate.eduORCID: 0000-0001-7215-770X
-
Catalina Segura - Principal Investigator Assistant Professor; Department of Forest Engineering, Resources, and Management; Oregon State University, Corvallis, OR, 97331Phone: 541-737-6568Email: catalina.segura@oregonstate.eduORCID: 0000-0002-0924-1172
-
David Bell - Principal Investigator Email: david.bell@usda.gov, david.bell@oregonstate.eduORCID: 0000-0002-2673-5836
Abstract
- The H.J. Andrews Experimental Forest is a living laboratory that provides unparalleled opportunities for the study of forest and stream ecosystems in the central Cascade Range of Oregon. Since 1980, as a part of the National Science Foundation Long Term Ecological Research (NSF-LTER) program, the Andrews Experimental Forest has become a leader in the analysis of forest and stream ecosystem dynamics.
- Long-term field experiments and measurement programs have focused on climate dynamics, streamflow, water quality, and vegetation succession. Currently researchers are working to develop concepts and tools needed to predict effects of natural disturbance, land use, and climate change on ecosystem structure, function, and species composition.
- The Andrews Experimental Forest is administered cooperatively by the USDA Forest Service Pacific Northwest Research Station, Oregon State University and the Willamette National Forest. Funding for the research program comes from the National Science Foundation (NSF), US Forest Service Pacific Northwest Research Station, Oregon State University, and other sources.
Funding
Data were provided by the HJ Andrews Experimental Forest research program, funded by the National Science Foundation's Long-Term Ecological Research Program (DEB 2025755), US Forest Service Pacific Northwest Research Station, and Oregon State University. National Science Foundation: DEB2025755
Awards
-
LTER: Long-Term Ecological Research at the H.J. Andrews Experimental Forest (LTER8) Award Number: DEB2025755Funder: National Science FoundationFunder Identifier: https://ror.org/021nxhr62
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
-
Joseph A. Antos
Role: Other ResearcherDepartment of Biology;University of Victoria, Victoria, BC, V8W 2Y2, CanadaPhone: (250) 721-7144Email: jantos@uvic.ca
-
Kermit Cromack Jr.
Role: Other ResearcherOregon State University;Dept. of Forest Science;321 Richardson Hall, Corvallis, OR, 97331-5752, USAPhone: (541) 737-6590Email: Kermit.Cromack@oregonstate.edu
-
Charles B. Halpern
Role: Principal InvestigatorSchool of Environmental and Forest Sciences, University of Washington, Box 352100, Seattle, WA, 98195-2100, USAPhone: (206) 543-2789Email: chalpern@u.washington.edu
-
Charles B. Halpern
Role: AbstractorSchool of Environmental and Forest Sciences, University of Washington, Box 352100, Seattle, WA, 98195-2100, USAPhone: (206) 543-2789Email: chalpern@u.washington.edu
-
Charles B. Halpern
Role: CreatorSchool of Environmental and Forest Sciences, University of Washington, Box 352100, Seattle, WA, 98195-2100, USAPhone: (206) 543-2789Email: chalpern@u.washington.edu
-
Annette M. Olson
Role: Other ResearcherEmail: lottia@comcast.net
Contact
-
Information Manager
Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331Email: hjaweb@lists.oregonstate.edu
-
Charles B. Halpern
School of Environmental and Forest Sciences, University of Washington, Box 352100, Seattle, WA, 98195-2100, USAPhone: (206) 543-2789Email: chalpern@u.washington.edu
Publisher
-
Andrews Forest LTER Site
Role: PublisherForest Ecosystems and Society Department in Forestry, Oregon State University, 201K Richardson Hall, Corvallis, OR, 97331-5752Phone: (541) 737-8480Email: lterweb@lists.oregonstate.edu
Study Description
The factors that contribute to plant species establishment and decline following disturbance determine the rates and patterns of successional change of a system. In this long-term field experiment, we test the commonly held assumption that competition for space or resources by dominant species determines the outcome of succession. Specifically, we examine the population- and community-level consequences of removing one or more potentially dominant species from the post-disturbance community after clearcut logging and burning of a mature/old-growth Douglas-fir forest. Experimental treatments include: (1) removal of early-seral annual, Senecio sylvaticus, or perennial, Epilobium angustifolium—or both—to test the influences of these early-seral dominants on subsequent community development; (2) removal of all species except Senecio or Epilobium, to test whether the decline of these early-seral dominants is driven by competitive displacement; or (3) removal of shade-tolerant forest species that dominate subsequent stages of succession—Rubus ursinus or Berberis nervosa plus Gaultheria shallon—to test the influences of these long-lived perennials on understory development. The experiment is a randomized block design comprising eight removal treatments plus a control replicated in each of 25 blocks. Removal (reduction in competition) is achieved by removing seedlings or vegetative stems annually from a treatment area of 2.5 x 2.5 m. Sample plots (1 x 1 m) centered within these are used to estimate cover of all vascular plant species and, for the first 8 yr of the experiment, stem density and height, facilitating estimates of above-ground biomass. Pre-harvest data were collected in 1990, logging/burning occurred in 1991, and removal treatments and post-treatment sampling were initiated in 1992. Six of the nine experimental treatments were terminated between 1996 and 1998, with loss of early-seral Senecio and Epilobium from the system. The remaining three treatments (removal of Rubus, removal of Berberis plus Gaultheria, and the control) have been sampled annually since 1992. All regeneration of trees within the experimental area has occurred naturally. In September 2018, the study site was subjected to a controlled burn to limit spread of the Terwilliger Fire from the north. In 2019, plots were assessed for burn severity. Species' removals were terminated, but cover measurements continue in the plots. To test the role of competitive interactions in shaping the early successional dynamics of understory species in Douglas-fir forests of the western Cascades. Field Methods - TP103
Purpose: To test the role of competitive interactions in shaping the early successional dynamics of understory species in Douglas-fir forests of the western Cascades.
Methods
Method Steps
Field Methods - TP103
- Vegetation measurements are made in a central 1 x 1 m plot within each treatment area (see Related Materials: Plot Layout). Pre-logging measurements were made in 1990; post-harvest measurements were initiated in 1992. Between 1992 and 1996, measurements were repeated two to three times during the summer (June-Aug). Since 1997, measurements have been made annually (typically in late-June/early July). Measurements include estimates of cover (%) of ground-surface conditions (bare ground, fine litter, and logs) and of each vascular plant species (including herbs, shrubs, and trees) (see Entity 1). In addition, between 1992 and 1999, stems of each species were counted and measured for basal diameter and/or height (see Entity 1). These parameters are used in species-specific allometric equations (see Entity 5) to predict the aboveground biomass of each stem (Halpern et al. 1996). For other species, equations predict biomass in the 1-m2 plot from cover. Plot-scale estimates of biomass (summing stem estimates as needed) were generated for all species between 1990 and 1999 (see Entity 6). After 1999, these estimates are limited to a subset of species whose biomass is computed from cover (or from cover and height for Berberis nervosa and Gaultheria shallon).
Models/Algorithms - TP103
- Estimates of species’ biomass are from regression equations developed from dimensional measurements and destructive sampling at the study site (Halpern et al. 1996)
Permanent Plots - TP103
- 1 x 1 m plots are permanently marked with rebar and uniquely numbered aluminum tags (block/plot number)
Quality Assurance - TP103
- Standard QA/QC procedures, including range limits, legitimate codes, relational checks
Data Entry - TP103
- Entered and checked by PI
Sampling
Study Extent
- The 4-ha study site, Starrbright (named after nearby Starr Creek and the timber sale) lies on a gentle (less than 5%) east-facing slope at ~736 m elevation. Soils are mostly deep (greater than 1.5 m), loamy Andisols (frigid typic Hapludand) formed from weathering of andesite, breccia, and volcanic ash. Prior to harvest, the site supported a mix of mature and old-growth forest dominated by Pseudotsuga menziesii with a subcanopy of Tsuga heterophylla, Thuja plicata and Taxus brevifolia. The understory was dominated by woody species, including Rhododendron macrophyllum, Gaultheria shallon and Berberis nervosa.
- Sampling frequency: annual
Sampling Description
- The site was clearcut logged in late May/early June 1991. Slash was broadcast burned on 11 September 1991 with a moderate- to high-intensity fire. The full experiment consists of a randomized complete-block design with a control and eight treatments (A through I; see below) in which one or more species is removed from the post-disturbance community (see details in Halpern et al. 1997). Treatments were assigned randomly to nine 2.5 x 2.5 m experimental units (treatment areas) in each of 25 blocks (~11 m on a side). Within a block, treatment areas are arranged in a 3 x 3 array with ~1-m spacing (see Related Materials: Plot Layout). Species’ removal treatments were initiated in June 1992, synchronous with the first post-disturbance measurement of vegetation. For the first 7 years, removals were conducted monthly (April to June). Seedlings were pulled by hand and vegetative shoots were clipped at the ground surface (see Entity 2 for counts of seedlings and shoots removed). Subsequently, removals have been conducted at the time of vegetation measurement, but the stems removed are no longer counted. Sampling of six treatments was discontinued between 1996 and 1998 when removal or target species became uncommon. The remaining three treatments (A = control; H = Rubus ursinus removed; and I = Berberis nervosa and Gaultheria shallon removed) were maintained through 2018. Following a controlled burn of the site in September 2018 -- to limit spread of the larger Terwilliger Fire -- species' removals were terminated in treatments H and I. However, cover measurements have continued in treatments A, H, and I (see details in Halpern and Antos 2022).
- Treatment codes (A-I), removal species, and response variables for the nine treatments include:
- A. Control (no removal); Response = Community (all species)
- B. Senecio sylvaticus removed; Response = Community (all other species)
- C. Epilobium angustifolium removed; Response = Community (all other species)
- D. Senecio sylvaticus and E. angustifolium removed; Response = Community (all other species)
- E. Senecio sylvaticus and Community removed; Response = Epilobium angustifolium
- F. Epilobium angustifolium and Community removed; Response = Senecio sylvaticus
- G. Community removed; Response = Senecio sylvaticus and Epilobium angustifolium
- H. Rubus ursinus removed; Response = Community (all other species)
- I. Berberis nervosa/Gaultheria shallon removed; Response = Community (all other species)
- Citation:
- Halpern, Charles B., Antos, Joseph A. 2022, Burn severity and pre-fire seral state interact to shape vegetation responses to fire in a young, western Cascade Range forest (Pub. No: 5214)
Spatial Sampling Units
-
Starrbright Timber Sale
W -122.18500900, E -122.18500900, N 44.00302200, S 44.00302200Altitude: 730 to 730 meter
Software
No software entries listed in this EML file.
Keywords
- LTER controlled vocabulary: community dynamics (theme), trophic structure (theme), succession (theme), primary production (theme), species interactions (theme), competition (theme), disturbance (theme), burning (theme), timber harvest (theme), clearcutting (theme)
- Andrews Experimental Forest site thesaurus: Long-Term Ecological Research (LTER) (theme)
- LTER core research areas: primary production (theme), disturbance (theme)
Taxonomic Hierarchy
- All Organisms: All Organisms
- Highest common category (ca. kingdom): Plantae
- Species: unknown plant
- Division or Phylum: Equisetophyta
- Class: Equisetopsida
- Order: Equisetales
- Family: Equisetaceae
- Genus: Equisetum
- Species: Equisetum telmateia
- Division or Phylum: Magnoliophyta
- Class: Magnoliopsida
- Subclass: Hamamelididae
- Order: Fagales
- Family: Fagaceae
- Genus: Chrysolepis
- Species: Castanopsis chrysophylla
- Subclass: Dilleniidae
- Order: Violales
- Family: Violaceae
- Genus: Viola
- Species: Viola sempervirens
- Order: Primulales
- Family: Primulaceae
- Genus: Trientalis
- Species: Trientalis latifolia
- Order: Capparales
- Family: Brassicaceae
- Genus: Cardamine
- Species: Cardamine oligosperma
- Order: Ericales
- Family: Ericaceae
- Genus: Gaultheria
- Species: Gaultheria shallon
- Genus: Arbutus
- Species: Arbutus menziesii
- Genus: Arctostaphylos
- Species: Arctostaphylos columbiana
- Genus: Rhododendron
- Species: Rhododendron macrophyllum
- Genus: Vaccinium
- Species: Vaccinium parvifolium
- Species: Vaccinium membranaceum
- Family: Pyrolaceae
- Genus: Pyrola
- Species: Pyrola asarifolia
- Species: Pyrola picta
- Genus: Chimaphila
- Species: Chimaphila umbellata
- Species: Chimaphila menziesii
- Order: Theales
- Family: Clusiaceae
- Genus: Hypericum
- Species: Hypericum perforatum
- Order: Poales
- Family: Poaceae
- Genus: Trisetum
- Species: Trisetum canescens
- Species: Trisetum cernuum
- Genus: Deschampsia
- Species: Deschampsia elongata
- Genus: Arrhenatherum
- Species: Arrhenatherum elatius
- Genus: Agrostis
- Species: Agrostis tenuis
- Species: Agrostis exarata
- Genus: Aira
- Species: Aira caryophyllea
- Genus: Bromus
- Species: Bromus vulgaris
- Genus: Elymus
- Species: Elymus glaucus
- Genus: Festuca
- Species: Festuca myuros
- Species: Festuca occidentalis
- Genus: Holcus
- Species: Holcus lanatus
- Subclass: Magnoliidae
- Order: Ranunculales
- Family: Ranunculaceae
- Genus: Ranunculus
- Species: Ranunculus uncinatus
- Genus: Anemone
- Species: Anemone deltoidea
- Species: Anemone lyallii
- Family: Berberidaceae
- Genus: Berberis
- Species: Berberis nervosa
- Genus: Achlys
- Species: Achlys triphylla
- Genus: Vancouveria
- Species: Vancouveria hexandra
- Order: Aristolochiales
- Family: Aristolochiaceae
- Genus: Asarum
- Species: Asarum caudatum
- Subclass: Rosidae
- Order: Apiales
- Family: Apiaceae
- Genus: Osmorhiza
- Species: Osmorhiza chilensis
- Order: Myrtales
- Family: Onagraceae
- Genus: Epilobium
- Species: Epilobium angustifolium
- Species: Epilobium paniculatum
- Species: Epilobium minutum
- Species: Epilobium watsonii
- Order: Cornales
- Family: Cornaceae
- Genus: Cornus
- Species: Cornus nuttallii
- Family: Garryaceae
- Genus: Garrya
- Species: Garrya fremontii
- Order: Rosales
- Family: Grossulariaceae
- Genus: Ribes
- Species: Ribes lobbii
- Family: Rosaceae
- Genus: Rosa
- Species: Rosa gymnocarpa
- Genus: Holodiscus
- Species: Holodiscus discolor
- Genus: Fragaria
- Species: Fragaria vesca
- Genus: Amelanchier
- Species: Amelanchier alnifolia
- Genus: Prunus
- Species: Prunus emarginata
- Genus: Rubus
- Species: Rubus parviflorus
- Species: Rubus leucodermis
- Species: Rubus nivalis
- Species: Rubus ursinus
- Family: Saxifragaceae
- Genus: Tiarella
- Species: Tiarella trifoliata
- Family: Hydrangeaceae
- Genus: Whipplea
- Species: Whipplea modesta
- Order: Sapindales
- Family: Aceraceae
- Genus: Acer
- Species: Acer circinatum
- Species: Acer macrophyllum
- Order: Rhamnales
- Family: Rhamnaceae
- Genus: Ceanothus
- Species: Ceanothus velutinus
- Species: Ceanothus integerrimus
- Species: Ceanothus sanguineus
- Order: Fabales
- Family: Fabaceae
- Genus: Lupinus
- Species: Lupinus latifolius
- Genus: Lotus
- Species: Lotus micranthus
- Species: Lotus crassifolius
- Species: Lotus purshianus
- Subclass: Caryophyllidae
- Order: Caryophyllales
- Family: Portulacaceae
- Genus: Montia
- Species: Montia perfoliata
- Species: Montia sibirica
- Family: Caryophyllaceae
- Genus: Cerastium
- Species: Cerastium vulgatum
- Genus: Silene
- Species: Silene antirrhina
- Genus: Stellaria
- Species: Stellaria calycantha
- Order: Polygonales
- Family: Polygonaceae
- Genus: Polygonum
- Species: Polygonum douglasii
- Class: Liliopsida
- Subclass: Commelinidae
- Order: Cyperales
- Family: Cyperaceae
- Genus: Carex
- Species: Carex amplifolia
- Order: Juncales
- Family: Juncaceae
- Genus: Luzula
- Species: Luzula campestris
- Subclass: Liliidae
- Order: Liliales
- Family: Liliaceae
- Genus: Clintonia
- Species: Clintonia uniflora
- Genus: Trillium
- Species: Trillium ovatum
- Genus: Maianthemum
- Species: Smilacina stellata
- Order: Orchidales
- Family: Orchidaceae
- Genus: Listera
- Species: Listera cordata
- Genus: Goodyera
- Species: Goodyera oblongifolia
- Genus: Cephalanthera
- Species: Eburophyton austiniae
- Subclass: Asteridae
- Order: Scrophulariales
- Family: Scrophulariaceae
- Genus: Veronica
- Species: Veronica arvensis
- Species: Veronica serpyllifolia
- Order: Solanales
- Family: Polemoniaceae
- Genus: Collomia
- Species: Collomia heterophylla
- Family: Hydrophyllaceae
- Genus: Nemophila
- Species: Nemophila parviflora
- Order: Lamiales
- Family: Lamiaceae
- Genus: Clinopodium
- Species: Satureja douglasii
- Genus: Prunella
- Species: Prunella vulgaris
- Family: Boraginaceae
- Genus: Myosotis
- Species: Myosotis discolor
- Order: Asterales
- Family: Asteraceae
- Genus: Sonchus
- Species: Sonchus arvensis
- Genus: Hypochaeris
- Species: Hypochaeris radicata
- Genus: Hieracium
- Species: Hieracium albiflorum
- Genus: Cirsium
- Species: Cirsium vulgare
- Species: Cirsium arvense
- Genus: Agoseris
- Species: Agoseris grandiflora
- Species: Agoseris heterophylla
- Genus: Adenocaulon
- Species: Adenocaulon bicolor
- Genus: Anaphalis
- Species: Anaphalis margaritacea
- Genus: Chrysanthemum
- Species: Chrysanthemum leucanthemum
- Genus: Conyza
- Species: Conyza canadensis
- Genus: Crepis
- Species: Crepis capillaris
- Genus: Gnaphalium
- Species: Gnaphalium microcephalum
- Species: Gnaphalium uliginosum
- Species: Gnaphalium purpureum
- Genus: Lactuca
- Species: Lactuca serriola
- Species: Lactuca muralis
- Genus: Madia
- Species: Madia gracilis
- Genus: Petasites
- Species: Petasites frigidus
- Genus: Senecio
- Species: Senecio sylvaticus
- Species: Senecio jacobaea
- Order: Campanulales
- Family: Campanulaceae
- Genus: Campanula
- Species: Campanula scouleri
- Order: Rubiales
- Family: Rubiaceae
- Genus: Galium
- Species: Galium triflorum
- Order: Dipsacales
- Family: Caprifoliaceae
- Genus: Sambucus
- Species: Sambucus cerulea
- Genus: Lonicera
- Species: Lonicera ciliosa
- Genus: Linnaea
- Species: Linnaea borealis
- Genus: Symphoricarpos
- Species: Symphoricarpos mollis
- Division or Phylum: Coniferophyta
- Class: Pinopsida
- Order: Pinales
- Family: Cupressaceae
- Genus: Thuja
- Species: Thuja plicata
- Family: Pinaceae
- Genus: Tsuga
- Species: Tsuga heterophylla
- Genus: Pseudotsuga
- Species: Pseudotsuga menziesii
- Genus: Pinus
- Species: Pinus lambertiana
- Genus: Abies
- Species: Abies grandis
- Order: Taxales
- Family: Taxaceae
- Genus: Taxus
- Species: Taxus brevifolia
- Division or Phylum: Polypodiophyta
- Class: Filicopsida
- Order: Polypodiales
- Family: Dryopteridaceae
- Genus: Polystichum
- Species: Polystichum munitum
- Family: Dennstaedtiaceae
- Genus: Pteridium
- Species: Pteridium aquilinum
- Family: Non-taxonomic objects (vegetative, organic, or inorganic)
- Species: Root
- Species: Snag
- Species: Tree butt
- Species: Log
- Species: Coarse woody debris
- Species: Gramin
- Species: Grass
- Species: unknown plant 2
- Species: Moss
- Species: Tree
- Species: Herb
- Species: Shrub
- Species: Lichen
- Species: Litter
- Species: Bare ground
- Species: Stone
- Species: Tree stump
Data Entities
| # | Entity | Metadata | Data |
|---|---|---|---|
| 1 |
TP10301
Species Cover, Density, and Biomass Measurement Data Species cover, stem density, and biomass-related measurements, as well as cover of moss and ground-surface conditions; includes all sampling years |
METADATA | DATA |
| 2 |
TP10302
Species Removals (counts) Numbers of seedlings removed or stems clipped from species-removal plots and from the adjacent 75-cm-wide buffer |
METADATA | DATA |
| 3 |
TP10303
Species Cover, Density, and Biomass Measurements Original Fieldsheet Format Original version (1990-1996) of species cover, stem density, and biomass-related measurements (heights, basal diameters), as well as cover of moss and ground-surface conditions; data structured the same as the "original" field sheet; also contained in Entity 1 |
METADATA | DATA |
| 4 |
TP10304
Species Cover, Density, and Biomass Measurements Modified Fieldsheet Format Original version (1997-1999) of species cover, stem density, and biomass-related measurements (heights, basal diameters), as well as cover of moss and ground-surface conditions; data structured the same as the "modified" field sheet; also contained in Entity 1 |
METADATA | DATA |
| 5 |
TP10305
Equations used for calculating biomass Species-specific equations developed at the Starrbright study site to estimate above-ground biomass (grams/m^2) from plant dimensional measurements (cover, basal diameter and/or stem height) |
METADATA | DATA |
| 6 |
TP10306
Estimated biomass using measurement data and equations Estimated above-ground biomass within the plot (grams/m^2) based on species-specific equations in Entity 5 |
METADATA | DATA |
| 7 |
TP10307
Assessment of 2018 burn severity Metrics of burn severity following the fall 2018 Terwilliger Fire, including counts of live and dead trees within 2.5 m of the plot, percentage of ground surface burned in and adjacent to the plot, burn class (burned, partially burned, unburned), and additional comments on plot conditions |
METADATA | DATA |
Metadata
TP10301 - Species Cover, Density, and Biomass Measurement Data
Object name: TP10301_v12.csv
Records: 313443
Attributes: 19
Temporal coverage: 1990-06-01 to 2024-07-03
File size: 22228475 byte
Checksum (MD5): abe7414d1d4ccfa7d0587b3cbb45b152
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TP10301.BLOCK, TP10301.PLOT, TP10301.SEASON, TP10301.SPECIES, TP10301.STRATUM, TP10301.TMT, TP10301.YEAR, TP10301.REC_NO, TP10301.STUDY
-
notNullConstraint: NOTNULL TP10301.BLOCK, TP10301.ENTITY, TP10301.PLOT, TP10301.SEASON, TP10301.SPECIES, TP10301.DBCODE, TP10301.STRATUM, TP10301.TMT, TP10301.YEAR, TP10301.REC_NO, TP10301.STUDY
Attributes (19)
DBCODE - char(5) (nominal)
ID: TP10301.DBCODE
Database code
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
TP103
FSDB database code TP103
ENTITY - numeric(1,0) (interval)
ID: TP10301.ENTITY
Entity number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=1.0000 (exclusive=false)
STUDY - char(11) (nominal)
ID: TP10301.STUDY
Study site location
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
Starrbright
Starrbright Timber Sale
YEAR - numeric(4,0) (interval)
ID: TP10301.YEAR
Sampling year
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1990.0000 (exclusive=false), max=2024.0000 (exclusive=false)
SDATE - datetime (dateTime)
ID: TP10301.SDATE
Vegetation sampling date
Type system: Microsoft SQL Server 2019
Date format: YYYY-MM-DD
SEASON - char(1) (nominal)
ID: TP10301.SEASON
Sampling season (1 - 3)
Type system: Microsoft SQL Server 2019
Code definitions (4)
-
U
Unknown season of sampling
-
1
First season of sampling per year (usually june)
-
2
Second season of sampling per year (usually july)
-
3
Third season of sampling per year (usually august)
BLOCK - numeric(2,0) (interval)
ID: TP10301.BLOCK
Sample block (1-25)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=25.0000 (exclusive=false)
PLOT - numeric(1,0) (interval)
ID: TP10301.PLOT
Sample plot w/in block (1-9)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=9.0000 (exclusive=false)
TMT - char(1) (nominal)
ID: TP10301.TMT
Treatment code (A-I)
Type system: Microsoft SQL Server 2019
Code definitions (9)
-
A
Control
-
B
Senecio sylvaticus removed
-
C
Epilobium angustifolium removed
-
D
Senecio sylvaticus and Epilobium angustifolium removed
-
E
Senecio sylvaticus and community removed
-
F
Epilobium angustifolium and community removed
-
G
Community removed
-
H
Rubus ursinus removed
-
I
Berberis nervosa and Gaultheria shallon removed
SPECIES - char(6) (nominal)
ID: TP10301.SPECIES
Species acronym according to Garrison et al. 1974
Type system: Microsoft SQL Server 2019
Code definitions (152)
-
BORAGI
Boraginaceae
-
LILIAC
Liliaceae
-
ABGR
Abies grandis
-
ACCI
Acer circinatum
-
ACMA
Acer macrophyllum
-
ACTR
Achlys triphylla
-
ADBI
Adenocaulon bicolor
-
AGGR
Agoseris grandiflora
-
AGHE
Agoseris heterophylla
-
AGROS
Agrostis
-
AGEX
Agrostis exarata
-
AGTE
Agrostis tenuis
-
AICA
Aira caryophyllea
-
AMAL
Amelanchier alnifolia
-
ANMA
Anaphalis margaritacea
-
ANDE
Anemone deltoidea
-
ANLY2
Anemone lyallii
-
ARME
Arbutus menziesii
-
ARCO3
Arctostaphylos columbiana
-
AREL
Arrhenatherum elatius
-
ASCA3
Asarum caudatum
-
BENE
Berberis nervosa
-
BROMU
Bromus
-
BRVU
Bromus vulgaris
-
CASC2
Campanula scouleri
-
CARDA
Cardamine
-
CAOL
Cardamine oligosperma
-
CAAM
Carex amplifolia
-
CEANO
Ceanothus
-
CEIN
Ceanothus integerrimus
-
CESA
Ceanothus sanguineus
-
CEVE
Ceanothus velutinus
-
CERAS
Cerastium
-
CEVU
Cerastium vulgatum
-
CHME
Chimaphila menziesii
-
CHUM
Chimaphila umbellata
-
CHLE2
Chrysanthemum leucanthemum
-
CIRSI
Cirsium
-
CIAR
Cirsium arvense
-
CIVU
Cirsium vulgare
-
CLUN
Clintonia uniflora
-
COHE
Collomia heterophylla
-
COCA2
Conyza canadensis
-
CONU
Cornus nuttallii
-
CRCA
Crepis capillaris
-
DEEL
Deschampsia elongata
-
ELGL
Elymus glaucus
-
EPILO
Epilobium
-
EPMI
Epilobium minutum
-
EPPA
Epilobium paniculatum
-
EPWA
Epilobium watsonii
-
EQTE
Equisetum telmateia
-
FESTU
Festuca
-
FEMY
Festuca myuros
-
FEOC
Festuca occidentalis
-
FRVE
Fragaria vesca
-
GALIU
Galium
-
GATR
Galium triflorum
-
GAFR
Garrya fremontii
-
GASH
Gaultheria shallon
-
GNPU
Gnaphalium purpureum
-
GNUL
Gnaphalium uliginosum
-
GOOB
Goodyera oblongifolia
-
HIAL
Hieracium albiflorum
-
HOLA
Holcus lanatus
-
HODI
Holodiscus discolor
-
HYPE
Hypericum perforatum
-
HYRA
Hypochaeris radicata
-
LAMU
Lactuca muralis
-
LASE
Lactuca serriola
-
LIBO2
Linnaea borealis
-
LISTE
Listera
-
LICO3
Listera cordata
-
LOCI
Lonicera ciliosa
-
LOCR
Lotus crassifolius
-
LOMI
Lotus micranthus
-
LOPU
Lotus purshianus
-
LULA
Lupinus latifolius
-
MAGR
Madia gracilis
-
MOPE
Montia perfoliata
-
MOSI
Montia sibirica
-
MYDI
Myosotis discolor
-
NEPA
Nemophila parviflora
-
OSCH
Osmorhiza chilensis
-
PEFR2
Petasites frigidus
-
PILA
Pinus lambertiana
-
POLYG
Polygonum
-
PODO
Polygonum douglasii
-
POMU
Polystichum munitum
-
PRVU
Prunella vulgaris
-
PREM
Prunus emarginata
-
PSME
Pseudotsuga menziesii
-
PTAQ
Pteridium aquilinum
-
PYAS
Pyrola asarifolia
-
PYPI
Pyrola picta
-
RAUN2
Ranunculus uncinatus
-
RHMA
Rhododendron macrophyllum
-
RIBES
Ribes
-
RILO
Ribes lobbii
-
ROGY
Rosa gymnocarpa
-
RUBUS
Rubus
-
RULE
Rubus leucodermis
-
RUNI
Rubus nivalis
-
RUPA
Rubus parviflorus
-
RUUR
Rubus ursinus
-
SACE
Sambucus cerulea
-
SEJA
Senecio jacobaea
-
SESY
Senecio sylvaticus
-
SIAN2
Silene antirrhina
-
SOAR
Sonchus arvensis
-
STELL
Stellaria
-
STCA2
Stellaria calycantha
-
TABR
Taxus brevifolia
-
THPL
Thuja plicata
-
TITR
Tiarella trifoliata
-
TRLA2
Trientalis latifolia
-
TROV
Trillium ovatum
-
TRCA
Trisetum canescens
-
TRCE
Trisetum cernuum
-
TSHE
Tsuga heterophylla
-
VAME
Vaccinium membranaceum
-
VAPA
Vaccinium parvifolium
-
VAHE
Vancouveria hexandra
-
VEAR
Veronica arvensis
-
VESE
Veronica serpyllifolia
-
VISE
Viola sempervirens
-
WHMO
Whipplea modesta
-
CACH
Castanopsis chrysophylla
-
EBAU
Eburophyton austiniae
-
SADO
Satureja douglasii
-
SMST
Smilacina stellata
-
EPAN
Epilobium angustifolium
-
SYMO
Symphoricarpos mollis
-
GNMI
Gnaphalium microcephalum
-
LUCA2
Luzula campestris
-
UNKN
unknown plant
-
HERB
Herb
-
TREE
Tree
-
SHRUB
Shrub
-
MOSS
Moss
-
LICHEN
Lichen
-
GRASS
Grass
-
LITTER
Litter
-
CWD
Coarse woody debris
-
BARE
Bare ground
-
LOG
Log
-
STONE
Stone
-
BUTT
Tree butt
-
STUMP
Tree stump
-
SNAG
Snag
-
UNKN2
unknown plant 2
-
ROOT
Root
STRATUM - char(1) (nominal)
ID: TP10301.STRATUM
Pre-harvest tree stratum: (O)verstory, (S)ubcanopy, (U)nderstory
Type system: Microsoft SQL Server 2019
Code definitions (4)
-
O
Overstory layer
-
S
Subcanopy layer
-
U
Understory layer
-
N
Not applicable; STRATUM applies only to tree species in the pre-harvest sample (1990)
COV1_4TH - numeric(5,1) (ratio)
ID: TP10301.COV1_4TH
Cover in the "quarter" plot (0.25 x 0.25 m), used to subsample when species density was high
Type system: Microsoft SQL Server 2019
Unit: percent
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)
COVER - numeric(5,1) (ratio)
ID: TP10301.COVER
Cover in the 1 m2 plot
Type system: Microsoft SQL Server 2019
Unit: percent
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)
DENSITYS - numeric(6,0) (ratio)
ID: TP10301.DENSITYS
Density of seedlings (1 m2 plot)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=3300.0000 (exclusive=false)
DENSITYM - numeric(6,0) (ratio)
ID: TP10301.DENSITYM
Density of mature stems/sprouts (1 m2 plot)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=105.0000 (exclusive=false)
DBA - numeric(5,1) (ratio)
ID: TP10301.DBA
Basal diameter
Type system: Microsoft SQL Server 2019
Unit: centimeters
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)
HT - numeric(5,1) (ratio)
ID: TP10301.HT
Total height (including inflorescence if present)
Type system: Microsoft SQL Server 2019
Unit: centimeters
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=145.0000 (exclusive=false)
HTV - numeric(5,1) (ratio)
ID: TP10301.HTV
Height of vegetative portion
Type system: Microsoft SQL Server 2019
Unit: centimeters
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=330.0000 (exclusive=false)
REC_NO - numeric(4,0) (interval)
ID: TP10301.REC_NO
Unique record number for a given year, season, block, plot, tmt, species and stratum
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=1135.0000 (exclusive=false)
TP10302 - Species Removals (counts)
Object name: TP10302_v4.csv
Records: 5500
Attributes: 13
Temporal coverage: 1992-06-22 to 1998-05-17
File size: 332160 byte
Checksum (MD5): ed2bddd956b002ad402bdd77bc422fa6
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TP10302.BLOCK, TP10302.PLOT, TP10302.TMT
-
notNullConstraint: NOTNULL TP10302.BLOCK, TP10302.ENTITY, TP10302.PLOT, TP10302.DBCODE, TP10302.TMT
Attributes (13)
DBCODE - char(5) (nominal)
ID: TP10302.DBCODE
Database code
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
TP103
FSDB database code TP103
ENTITY - numeric(1,0) (interval)
ID: TP10302.ENTITY
Entity number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=2.0000 (exclusive=false), max=2.0000 (exclusive=false)
STUDY - char(11) (nominal)
ID: TP10302.STUDY
Study site location
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
Starrbright
Starrbright Timber Sale
SDATE - datetime (dateTime)
ID: TP10302.SDATE
Vegetation sampling date
Type system: Microsoft SQL Server 2019
Date format: YYYY-MM-DD
RDATE - datetime (dateTime)
ID: TP10302.RDATE
Date of species removal (yyyymmdd)
Type system: Microsoft SQL Server 2019
Date format: YYYY-MM-DD
SEASON - char(1) (nominal)
ID: TP10302.SEASON
Sampling season (1 - 3)
Type system: Microsoft SQL Server 2019
Code definitions (4)
-
U
Unknown season of sampling
-
1
First season of sampling per year (usually june)
-
2
Second season of sampling per year (usually july)
-
3
Third season of sampling per year (usually august)
BLOCK - numeric(2,0) (interval)
ID: TP10302.BLOCK
Sample block (1-25)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=25.0000 (exclusive=false)
PLOT - numeric(1,0) (interval)
ID: TP10302.PLOT
Sample plot w/in block (1-9)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=9.0000 (exclusive=false)
TMT - char(1) (nominal)
ID: TP10302.TMT
Treatment code (A-I)
Type system: Microsoft SQL Server 2019
Code definitions (9)
-
A
Control
-
B
Senecio sylvaticus removed
-
C
Epilobium angustifolium removed
-
D
Senecio sylvaticus and Epilobium angustifolium removed
-
E
Senecio sylvaticus and community removed
-
F
Epilobium angustifolium and community removed
-
G
Community removed
-
H
Rubus ursinus removed
-
I
Berberis nervosa and Gaultheria shallon removed
SPECIES - char(6) (nominal)
ID: TP10302.SPECIES
Species acronym according to Garrison et al. 1974
Type system: Microsoft SQL Server 2019
Code definitions (152)
-
BORAGI
Boraginaceae
-
LILIAC
Liliaceae
-
ABGR
Abies grandis
-
ACCI
Acer circinatum
-
ACMA
Acer macrophyllum
-
ACTR
Achlys triphylla
-
ADBI
Adenocaulon bicolor
-
AGGR
Agoseris grandiflora
-
AGHE
Agoseris heterophylla
-
AGROS
Agrostis
-
AGEX
Agrostis exarata
-
AGTE
Agrostis tenuis
-
AICA
Aira caryophyllea
-
AMAL
Amelanchier alnifolia
-
ANMA
Anaphalis margaritacea
-
ANDE
Anemone deltoidea
-
ANLY2
Anemone lyallii
-
ARME
Arbutus menziesii
-
ARCO3
Arctostaphylos columbiana
-
AREL
Arrhenatherum elatius
-
ASCA3
Asarum caudatum
-
BENE
Berberis nervosa
-
BROMU
Bromus
-
BRVU
Bromus vulgaris
-
CASC2
Campanula scouleri
-
CARDA
Cardamine
-
CAOL
Cardamine oligosperma
-
CAAM
Carex amplifolia
-
CEANO
Ceanothus
-
CEIN
Ceanothus integerrimus
-
CESA
Ceanothus sanguineus
-
CEVE
Ceanothus velutinus
-
CERAS
Cerastium
-
CEVU
Cerastium vulgatum
-
CHME
Chimaphila menziesii
-
CHUM
Chimaphila umbellata
-
CHLE2
Chrysanthemum leucanthemum
-
CIRSI
Cirsium
-
CIAR
Cirsium arvense
-
CIVU
Cirsium vulgare
-
CLUN
Clintonia uniflora
-
COHE
Collomia heterophylla
-
COCA2
Conyza canadensis
-
CONU
Cornus nuttallii
-
CRCA
Crepis capillaris
-
DEEL
Deschampsia elongata
-
ELGL
Elymus glaucus
-
EPILO
Epilobium
-
EPMI
Epilobium minutum
-
EPPA
Epilobium paniculatum
-
EPWA
Epilobium watsonii
-
EQTE
Equisetum telmateia
-
FESTU
Festuca
-
FEMY
Festuca myuros
-
FEOC
Festuca occidentalis
-
FRVE
Fragaria vesca
-
GALIU
Galium
-
GATR
Galium triflorum
-
GAFR
Garrya fremontii
-
GASH
Gaultheria shallon
-
GNPU
Gnaphalium purpureum
-
GNUL
Gnaphalium uliginosum
-
GOOB
Goodyera oblongifolia
-
HIAL
Hieracium albiflorum
-
HOLA
Holcus lanatus
-
HODI
Holodiscus discolor
-
HYPE
Hypericum perforatum
-
HYRA
Hypochaeris radicata
-
LAMU
Lactuca muralis
-
LASE
Lactuca serriola
-
LIBO2
Linnaea borealis
-
LISTE
Listera
-
LICO3
Listera cordata
-
LOCI
Lonicera ciliosa
-
LOCR
Lotus crassifolius
-
LOMI
Lotus micranthus
-
LOPU
Lotus purshianus
-
LULA
Lupinus latifolius
-
MAGR
Madia gracilis
-
MOPE
Montia perfoliata
-
MOSI
Montia sibirica
-
MYDI
Myosotis discolor
-
NEPA
Nemophila parviflora
-
OSCH
Osmorhiza chilensis
-
PEFR2
Petasites frigidus
-
PILA
Pinus lambertiana
-
POLYG
Polygonum
-
PODO
Polygonum douglasii
-
POMU
Polystichum munitum
-
PRVU
Prunella vulgaris
-
PREM
Prunus emarginata
-
PSME
Pseudotsuga menziesii
-
PTAQ
Pteridium aquilinum
-
PYAS
Pyrola asarifolia
-
PYPI
Pyrola picta
-
RAUN2
Ranunculus uncinatus
-
RHMA
Rhododendron macrophyllum
-
RIBES
Ribes
-
RILO
Ribes lobbii
-
ROGY
Rosa gymnocarpa
-
RUBUS
Rubus
-
RULE
Rubus leucodermis
-
RUNI
Rubus nivalis
-
RUPA
Rubus parviflorus
-
RUUR
Rubus ursinus
-
SACE
Sambucus cerulea
-
SEJA
Senecio jacobaea
-
SESY
Senecio sylvaticus
-
SIAN2
Silene antirrhina
-
SOAR
Sonchus arvensis
-
STELL
Stellaria
-
STCA2
Stellaria calycantha
-
TABR
Taxus brevifolia
-
THPL
Thuja plicata
-
TITR
Tiarella trifoliata
-
TRLA2
Trientalis latifolia
-
TROV
Trillium ovatum
-
TRCA
Trisetum canescens
-
TRCE
Trisetum cernuum
-
TSHE
Tsuga heterophylla
-
VAME
Vaccinium membranaceum
-
VAPA
Vaccinium parvifolium
-
VAHE
Vancouveria hexandra
-
VEAR
Veronica arvensis
-
VESE
Veronica serpyllifolia
-
VISE
Viola sempervirens
-
WHMO
Whipplea modesta
-
CACH
Castanopsis chrysophylla
-
EBAU
Eburophyton austiniae
-
SADO
Satureja douglasii
-
SMST
Smilacina stellata
-
EPAN
Epilobium angustifolium
-
SYMO
Symphoricarpos mollis
-
GNMI
Gnaphalium microcephalum
-
LUCA2
Luzula campestris
-
UNKN
unknown plant
-
HERB
Herb
-
TREE
Tree
-
SHRUB
Shrub
-
MOSS
Moss
-
LICHEN
Lichen
-
GRASS
Grass
-
LITTER
Litter
-
CWD
Coarse woody debris
-
BARE
Bare ground
-
LOG
Log
-
STONE
Stone
-
BUTT
Tree butt
-
STUMP
Tree stump
-
SNAG
Snag
-
UNKN2
unknown plant 2
-
ROOT
Root
NREMBUF - numeric(6,0) (ratio)
ID: TP10302.NREMBUF
Number of stems removed from 75 cm buffer
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=1354.0000 (exclusive=false)
NREMPLT - numeric(6,0) (ratio)
ID: TP10302.NREMPLT
Number of stems removed from 1 m2 plot
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=486.0000 (exclusive=false)
NOTES - varchar(45) (nominal)
ID: TP10302.NOTES
Comments
Type system: Microsoft SQL Server 2019
TP10303 - Species Cover, Density, and Biomass Measurements Original Fieldsheet Format
Object name: TP10303_v2.csv
Records: 65013
Attributes: 26
Temporal coverage: 1990-06-01 to 1996-08-15
File size: 5569236 byte
Checksum (MD5): 7d00c31568bd5e263b478512c31859f1
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TP10303.BLOCK, TP10303.LC, TP10303.PLOT, TP10303.SEASON, TP10303.SPECIES, TP10303.TMT, TP10303.YEAR
-
notNullConstraint: NOTNULL TP10303.BLOCK, TP10303.ENTITY, TP10303.LC, TP10303.PLOT, TP10303.SEASON, TP10303.SPECIES, TP10303.DBCODE, TP10303.TMT, TP10303.YEAR
Attributes (26)
DBCODE - char(5) (nominal)
ID: TP10303.DBCODE
Database code
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
TP103
FSDB database code TP103
ENTITY - numeric(1,0) (interval)
ID: TP10303.ENTITY
Entity number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=3.0000 (exclusive=false), max=3.0000 (exclusive=false)
STUDY - char(11) (nominal)
ID: TP10303.STUDY
Study site location
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
Starrbright
Starrbright Timber Sale
YEAR - numeric(4,0) (interval)
ID: TP10303.YEAR
Sampling year
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1990.0000 (exclusive=false), max=1996.0000 (exclusive=false)
SDATE - datetime (dateTime)
ID: TP10303.SDATE
Vegetation sampling date
Type system: Microsoft SQL Server 2019
Date format: YYYY-MM-DD
SEASON - char(1) (nominal)
ID: TP10303.SEASON
Sampling season (1 - 3)
Type system: Microsoft SQL Server 2019
Code definitions (4)
-
U
Unknown season of sampling
-
1
First season of sampling per year (usually june)
-
2
Second season of sampling per year (usually july)
-
3
Third season of sampling per year (usually august)
BLOCK - numeric(2,0) (interval)
ID: TP10303.BLOCK
Sample block (1-25)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=25.0000 (exclusive=false)
PLOT - numeric(1,0) (interval)
ID: TP10303.PLOT
Sample plot w/in block (1-9)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=9.0000 (exclusive=false)
TMT - char(1) (nominal)
ID: TP10303.TMT
Treatment code (A-I)
Type system: Microsoft SQL Server 2019
Code definitions (9)
-
A
Control
-
B
Senecio sylvaticus removed
-
C
Epilobium angustifolium removed
-
D
Senecio sylvaticus and Epilobium angustifolium removed
-
E
Senecio sylvaticus and community removed
-
F
Epilobium angustifolium and community removed
-
G
Community removed
-
H
Rubus ursinus removed
-
I
Berberis nervosa and Gaultheria shallon removed
SPECIES - char(6) (nominal)
ID: TP10303.SPECIES
Species acronym according to Garrison et al. 1974
Type system: Microsoft SQL Server 2019
Code definitions (152)
-
BORAGI
Boraginaceae
-
LILIAC
Liliaceae
-
ABGR
Abies grandis
-
ACCI
Acer circinatum
-
ACMA
Acer macrophyllum
-
ACTR
Achlys triphylla
-
ADBI
Adenocaulon bicolor
-
AGGR
Agoseris grandiflora
-
AGHE
Agoseris heterophylla
-
AGROS
Agrostis
-
AGEX
Agrostis exarata
-
AGTE
Agrostis tenuis
-
AICA
Aira caryophyllea
-
AMAL
Amelanchier alnifolia
-
ANMA
Anaphalis margaritacea
-
ANDE
Anemone deltoidea
-
ANLY2
Anemone lyallii
-
ARME
Arbutus menziesii
-
ARCO3
Arctostaphylos columbiana
-
AREL
Arrhenatherum elatius
-
ASCA3
Asarum caudatum
-
BENE
Berberis nervosa
-
BROMU
Bromus
-
BRVU
Bromus vulgaris
-
CASC2
Campanula scouleri
-
CARDA
Cardamine
-
CAOL
Cardamine oligosperma
-
CAAM
Carex amplifolia
-
CEANO
Ceanothus
-
CEIN
Ceanothus integerrimus
-
CESA
Ceanothus sanguineus
-
CEVE
Ceanothus velutinus
-
CERAS
Cerastium
-
CEVU
Cerastium vulgatum
-
CHME
Chimaphila menziesii
-
CHUM
Chimaphila umbellata
-
CHLE2
Chrysanthemum leucanthemum
-
CIRSI
Cirsium
-
CIAR
Cirsium arvense
-
CIVU
Cirsium vulgare
-
CLUN
Clintonia uniflora
-
COHE
Collomia heterophylla
-
COCA2
Conyza canadensis
-
CONU
Cornus nuttallii
-
CRCA
Crepis capillaris
-
DEEL
Deschampsia elongata
-
ELGL
Elymus glaucus
-
EPILO
Epilobium
-
EPMI
Epilobium minutum
-
EPPA
Epilobium paniculatum
-
EPWA
Epilobium watsonii
-
EQTE
Equisetum telmateia
-
FESTU
Festuca
-
FEMY
Festuca myuros
-
FEOC
Festuca occidentalis
-
FRVE
Fragaria vesca
-
GALIU
Galium
-
GATR
Galium triflorum
-
GAFR
Garrya fremontii
-
GASH
Gaultheria shallon
-
GNPU
Gnaphalium purpureum
-
GNUL
Gnaphalium uliginosum
-
GOOB
Goodyera oblongifolia
-
HIAL
Hieracium albiflorum
-
HOLA
Holcus lanatus
-
HODI
Holodiscus discolor
-
HYPE
Hypericum perforatum
-
HYRA
Hypochaeris radicata
-
LAMU
Lactuca muralis
-
LASE
Lactuca serriola
-
LIBO2
Linnaea borealis
-
LISTE
Listera
-
LICO3
Listera cordata
-
LOCI
Lonicera ciliosa
-
LOCR
Lotus crassifolius
-
LOMI
Lotus micranthus
-
LOPU
Lotus purshianus
-
LULA
Lupinus latifolius
-
MAGR
Madia gracilis
-
MOPE
Montia perfoliata
-
MOSI
Montia sibirica
-
MYDI
Myosotis discolor
-
NEPA
Nemophila parviflora
-
OSCH
Osmorhiza chilensis
-
PEFR2
Petasites frigidus
-
PILA
Pinus lambertiana
-
POLYG
Polygonum
-
PODO
Polygonum douglasii
-
POMU
Polystichum munitum
-
PRVU
Prunella vulgaris
-
PREM
Prunus emarginata
-
PSME
Pseudotsuga menziesii
-
PTAQ
Pteridium aquilinum
-
PYAS
Pyrola asarifolia
-
PYPI
Pyrola picta
-
RAUN2
Ranunculus uncinatus
-
RHMA
Rhododendron macrophyllum
-
RIBES
Ribes
-
RILO
Ribes lobbii
-
ROGY
Rosa gymnocarpa
-
RUBUS
Rubus
-
RULE
Rubus leucodermis
-
RUNI
Rubus nivalis
-
RUPA
Rubus parviflorus
-
RUUR
Rubus ursinus
-
SACE
Sambucus cerulea
-
SEJA
Senecio jacobaea
-
SESY
Senecio sylvaticus
-
SIAN2
Silene antirrhina
-
SOAR
Sonchus arvensis
-
STELL
Stellaria
-
STCA2
Stellaria calycantha
-
TABR
Taxus brevifolia
-
THPL
Thuja plicata
-
TITR
Tiarella trifoliata
-
TRLA2
Trientalis latifolia
-
TROV
Trillium ovatum
-
TRCA
Trisetum canescens
-
TRCE
Trisetum cernuum
-
TSHE
Tsuga heterophylla
-
VAME
Vaccinium membranaceum
-
VAPA
Vaccinium parvifolium
-
VAHE
Vancouveria hexandra
-
VEAR
Veronica arvensis
-
VESE
Veronica serpyllifolia
-
VISE
Viola sempervirens
-
WHMO
Whipplea modesta
-
CACH
Castanopsis chrysophylla
-
EBAU
Eburophyton austiniae
-
SADO
Satureja douglasii
-
SMST
Smilacina stellata
-
EPAN
Epilobium angustifolium
-
SYMO
Symphoricarpos mollis
-
GNMI
Gnaphalium microcephalum
-
LUCA2
Luzula campestris
-
UNKN
unknown plant
-
HERB
Herb
-
TREE
Tree
-
SHRUB
Shrub
-
MOSS
Moss
-
LICHEN
Lichen
-
GRASS
Grass
-
LITTER
Litter
-
CWD
Coarse woody debris
-
BARE
Bare ground
-
LOG
Log
-
STONE
Stone
-
BUTT
Tree butt
-
STUMP
Tree stump
-
SNAG
Snag
-
UNKN2
unknown plant 2
-
ROOT
Root
STRATUM - char(1) (nominal)
ID: TP10303.STRATUM
Pre-harvest tree stratum: (O)verstory, (S)ubcanopy, (U)nderstory
Type system: Microsoft SQL Server 2019
Code definitions (4)
-
O
Overstory layer
-
S
Subcanopy layer
-
U
Understory layer
-
N
Not applicable; STRATUM applies only to tree species in the pre-harvest sample (1990)
LC - numeric(3,0) (interval)
ID: TP10303.LC
Line count
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=165.0000 (exclusive=false)
COV1_4TH - numeric(5,1) (ratio)
ID: TP10303.COV1_4TH
Cover in the "quarter" plot (0.25 x 0.25 m), used to subsample when species density was high
Type system: Microsoft SQL Server 2019
Unit: percent
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)
COVER - numeric(5,1) (ratio)
ID: TP10303.COVER
Cover in the 1 m2 plot
Type system: Microsoft SQL Server 2019
Unit: percent
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)
DENSITYS - numeric(6,0) (ratio)
ID: TP10303.DENSITYS
Density of seedlings (1 m2 plot)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=3300.0000 (exclusive=false)
DENSITYM - numeric(6,0) (ratio)
ID: TP10303.DENSITYM
Density of mature stems/sprouts (1 m2 plot)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=120.0000 (exclusive=false)
STEM1BV1 - numeric(5,1) (ratio)
ID: TP10303.STEM1BV1
Biomass parameter 1 of stem1
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=130.0000 (exclusive=false)
STEM1BV2 - numeric(5,1) (ratio)
ID: TP10303.STEM1BV2
Biomass parameter 2 of stem1
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=130.0000 (exclusive=false)
STEM2BV1 - numeric(5,1) (ratio)
ID: TP10303.STEM2BV1
Biomass parameter 1 of stem2
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=330.0000 (exclusive=false)
STEM2BV2 - numeric(5,1) (ratio)
ID: TP10303.STEM2BV2
Biomass parameter 2 of stem2
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=150.0000 (exclusive=false)
STEM3BV1 - numeric(5,1) (ratio)
ID: TP10303.STEM3BV1
Biomass parameter 1 of stem3
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=130.0000 (exclusive=false)
STEM3BV2 - numeric(5,1) (ratio)
ID: TP10303.STEM3BV2
Biomass parameter 2 of stem3
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=130.0000 (exclusive=false)
STEM4BV1 - numeric(5,1) (ratio)
ID: TP10303.STEM4BV1
Biomass parameter 1 of stem4
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=130.0000 (exclusive=false)
STEM4BV2 - numeric(5,1) (ratio)
ID: TP10303.STEM4BV2
Biomass parameter 2 of stem4
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=130.0000 (exclusive=false)
STEM5BV1 - numeric(5,1) (ratio)
ID: TP10303.STEM5BV1
Biomass parameter 1 of stem5
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=130.0000 (exclusive=false)
STEM5BV2 - numeric(5,1) (ratio)
ID: TP10303.STEM5BV2
Biomass parameter 2 of stem5
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=130.0000 (exclusive=false)
TP10304 - Species Cover, Density, and Biomass Measurements Modified Fieldsheet Format
Object name: TP10304_v2.csv
Records: 10185
Attributes: 24
Temporal coverage: 1997-06-01 to 1999-07-14
File size: 784473 byte
Checksum (MD5): a460674564971448c3bed945086bbe71
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TP10304.BLOCK, TP10304.LC, TP10304.PLOT, TP10304.SEASON, TP10304.SPECIES, TP10304.TMT, TP10304.YEAR
-
notNullConstraint: NOTNULL TP10304.BLOCK, TP10304.ENTITY, TP10304.LC, TP10304.PLOT, TP10304.SEASON, TP10304.SPECIES, TP10304.DBCODE, TP10304.TMT, TP10304.YEAR
Attributes (24)
DBCODE - char(5) (nominal)
ID: TP10304.DBCODE
Database code
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
TP103
FSDB database code TP103
ENTITY - numeric(1,0) (interval)
ID: TP10304.ENTITY
Entity number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=4.0000 (exclusive=false), max=4.0000 (exclusive=false)
STUDY - char(11) (nominal)
ID: TP10304.STUDY
Study site location
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
Starrbright
Starrbright Timber Sale
YEAR - numeric(4,0) (interval)
ID: TP10304.YEAR
Sampling year
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1997.0000 (exclusive=false), max=2002.0000 (exclusive=false)
SDATE - datetime (dateTime)
ID: TP10304.SDATE
Vegetation sampling date
Type system: Microsoft SQL Server 2019
Date format: YYYY-MM-DD
SEASON - char(1) (nominal)
ID: TP10304.SEASON
Sampling season (1 - 3)
Type system: Microsoft SQL Server 2019
Code definitions (4)
-
U
Unknown season of sampling
-
1
First season of sampling per year (usually june)
-
2
Second season of sampling per year (usually july)
-
3
Third season of sampling per year (usually august)
BLOCK - numeric(2,0) (interval)
ID: TP10304.BLOCK
Sample block (1-25)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=25.0000 (exclusive=false)
PLOT - numeric(1,0) (interval)
ID: TP10304.PLOT
Sample plot w/in block (1-9)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=9.0000 (exclusive=false)
TMT - char(1) (nominal)
ID: TP10304.TMT
Treatment code (A-I)
Type system: Microsoft SQL Server 2019
Code definitions (9)
-
A
Control
-
B
Senecio sylvaticus removed
-
C
Epilobium angustifolium removed
-
D
Senecio sylvaticus and Epilobium angustifolium removed
-
E
Senecio sylvaticus and community removed
-
F
Epilobium angustifolium and community removed
-
G
Community removed
-
H
Rubus ursinus removed
-
I
Berberis nervosa and Gaultheria shallon removed
SPECIES - char(6) (nominal)
ID: TP10304.SPECIES
Species acronym according to Garrison et al. 1974
Type system: Microsoft SQL Server 2019
Code definitions (152)
-
BORAGI
Boraginaceae
-
LILIAC
Liliaceae
-
ABGR
Abies grandis
-
ACCI
Acer circinatum
-
ACMA
Acer macrophyllum
-
ACTR
Achlys triphylla
-
ADBI
Adenocaulon bicolor
-
AGGR
Agoseris grandiflora
-
AGHE
Agoseris heterophylla
-
AGROS
Agrostis
-
AGEX
Agrostis exarata
-
AGTE
Agrostis tenuis
-
AICA
Aira caryophyllea
-
AMAL
Amelanchier alnifolia
-
ANMA
Anaphalis margaritacea
-
ANDE
Anemone deltoidea
-
ANLY2
Anemone lyallii
-
ARME
Arbutus menziesii
-
ARCO3
Arctostaphylos columbiana
-
AREL
Arrhenatherum elatius
-
ASCA3
Asarum caudatum
-
BENE
Berberis nervosa
-
BROMU
Bromus
-
BRVU
Bromus vulgaris
-
CASC2
Campanula scouleri
-
CARDA
Cardamine
-
CAOL
Cardamine oligosperma
-
CAAM
Carex amplifolia
-
CEANO
Ceanothus
-
CEIN
Ceanothus integerrimus
-
CESA
Ceanothus sanguineus
-
CEVE
Ceanothus velutinus
-
CERAS
Cerastium
-
CEVU
Cerastium vulgatum
-
CHME
Chimaphila menziesii
-
CHUM
Chimaphila umbellata
-
CHLE2
Chrysanthemum leucanthemum
-
CIRSI
Cirsium
-
CIAR
Cirsium arvense
-
CIVU
Cirsium vulgare
-
CLUN
Clintonia uniflora
-
COHE
Collomia heterophylla
-
COCA2
Conyza canadensis
-
CONU
Cornus nuttallii
-
CRCA
Crepis capillaris
-
DEEL
Deschampsia elongata
-
ELGL
Elymus glaucus
-
EPILO
Epilobium
-
EPMI
Epilobium minutum
-
EPPA
Epilobium paniculatum
-
EPWA
Epilobium watsonii
-
EQTE
Equisetum telmateia
-
FESTU
Festuca
-
FEMY
Festuca myuros
-
FEOC
Festuca occidentalis
-
FRVE
Fragaria vesca
-
GALIU
Galium
-
GATR
Galium triflorum
-
GAFR
Garrya fremontii
-
GASH
Gaultheria shallon
-
GNPU
Gnaphalium purpureum
-
GNUL
Gnaphalium uliginosum
-
GOOB
Goodyera oblongifolia
-
HIAL
Hieracium albiflorum
-
HOLA
Holcus lanatus
-
HODI
Holodiscus discolor
-
HYPE
Hypericum perforatum
-
HYRA
Hypochaeris radicata
-
LAMU
Lactuca muralis
-
LASE
Lactuca serriola
-
LIBO2
Linnaea borealis
-
LISTE
Listera
-
LICO3
Listera cordata
-
LOCI
Lonicera ciliosa
-
LOCR
Lotus crassifolius
-
LOMI
Lotus micranthus
-
LOPU
Lotus purshianus
-
LULA
Lupinus latifolius
-
MAGR
Madia gracilis
-
MOPE
Montia perfoliata
-
MOSI
Montia sibirica
-
MYDI
Myosotis discolor
-
NEPA
Nemophila parviflora
-
OSCH
Osmorhiza chilensis
-
PEFR2
Petasites frigidus
-
PILA
Pinus lambertiana
-
POLYG
Polygonum
-
PODO
Polygonum douglasii
-
POMU
Polystichum munitum
-
PRVU
Prunella vulgaris
-
PREM
Prunus emarginata
-
PSME
Pseudotsuga menziesii
-
PTAQ
Pteridium aquilinum
-
PYAS
Pyrola asarifolia
-
PYPI
Pyrola picta
-
RAUN2
Ranunculus uncinatus
-
RHMA
Rhododendron macrophyllum
-
RIBES
Ribes
-
RILO
Ribes lobbii
-
ROGY
Rosa gymnocarpa
-
RUBUS
Rubus
-
RULE
Rubus leucodermis
-
RUNI
Rubus nivalis
-
RUPA
Rubus parviflorus
-
RUUR
Rubus ursinus
-
SACE
Sambucus cerulea
-
SEJA
Senecio jacobaea
-
SESY
Senecio sylvaticus
-
SIAN2
Silene antirrhina
-
SOAR
Sonchus arvensis
-
STELL
Stellaria
-
STCA2
Stellaria calycantha
-
TABR
Taxus brevifolia
-
THPL
Thuja plicata
-
TITR
Tiarella trifoliata
-
TRLA2
Trientalis latifolia
-
TROV
Trillium ovatum
-
TRCA
Trisetum canescens
-
TRCE
Trisetum cernuum
-
TSHE
Tsuga heterophylla
-
VAME
Vaccinium membranaceum
-
VAPA
Vaccinium parvifolium
-
VAHE
Vancouveria hexandra
-
VEAR
Veronica arvensis
-
VESE
Veronica serpyllifolia
-
VISE
Viola sempervirens
-
WHMO
Whipplea modesta
-
CACH
Castanopsis chrysophylla
-
EBAU
Eburophyton austiniae
-
SADO
Satureja douglasii
-
SMST
Smilacina stellata
-
EPAN
Epilobium angustifolium
-
SYMO
Symphoricarpos mollis
-
GNMI
Gnaphalium microcephalum
-
LUCA2
Luzula campestris
-
UNKN
unknown plant
-
HERB
Herb
-
TREE
Tree
-
SHRUB
Shrub
-
MOSS
Moss
-
LICHEN
Lichen
-
GRASS
Grass
-
LITTER
Litter
-
CWD
Coarse woody debris
-
BARE
Bare ground
-
LOG
Log
-
STONE
Stone
-
BUTT
Tree butt
-
STUMP
Tree stump
-
SNAG
Snag
-
UNKN2
unknown plant 2
-
ROOT
Root
LC - numeric(3,0) (interval)
ID: TP10304.LC
Line count
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=10.0000 (exclusive=false)
COV1_4TH - numeric(5,1) (ratio)
ID: TP10304.COV1_4TH
Cover in the "quarter" plot (0.25 x 0.25 m), used to subsample when species density was high
Type system: Microsoft SQL Server 2019
Unit: percent
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)
COVER - numeric(5,1) (ratio)
ID: TP10304.COVER
Cover in the 1 m2 plot
Type system: Microsoft SQL Server 2019
Unit: percent
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)
DENSITYS - numeric(6,0) (ratio)
ID: TP10304.DENSITYS
Density of seedlings (1 m2 plot)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=2000.0000 (exclusive=false)
DENSITYM - numeric(6,0) (ratio)
ID: TP10304.DENSITYM
Density of mature stems/sprouts (1 m2 plot)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=70.0000 (exclusive=false)
STEM1BV1 - numeric(5,1) (ratio)
ID: TP10304.STEM1BV1
Biomass parameter 1 of stem1
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 0.100000
Numeric domain: type=real, min=0.1000 (exclusive=false), max=150.0000 (exclusive=false)
STEM1BV2 - numeric(5,1) (ratio)
ID: TP10304.STEM1BV2
Biomass parameter 2 of stem1
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 0.100000
Numeric domain: type=real, min=0.1000 (exclusive=false), max=150.0000 (exclusive=false)
STEM1NO - numeric(5,0) (ratio)
ID: TP10304.STEM1NO
Number of stems containing the corresponding bv1 and bv2 values
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=1000.0000 (exclusive=false)
STEM2BV1 - numeric(5,1) (ratio)
ID: TP10304.STEM2BV1
Biomass parameter 1 of stem2
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 0.100000
Numeric domain: type=real, min=0.1000 (exclusive=false), max=150.0000 (exclusive=false)
STEM2BV2 - numeric(5,1) (ratio)
ID: TP10304.STEM2BV2
Biomass parameter 2 of stem2
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 0.100000
Numeric domain: type=real, min=0.1000 (exclusive=false), max=150.0000 (exclusive=false)
STEM2NO - numeric(5,0) (ratio)
ID: TP10304.STEM2NO
Number of stems containing the corresponding bv1 and bv2 values
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=1000.0000 (exclusive=false)
STEM3BV1 - numeric(5,1) (ratio)
ID: TP10304.STEM3BV1
Biomass parameter 1 of stem3
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 0.100000
Numeric domain: type=real, min=0.1000 (exclusive=false), max=150.0000 (exclusive=false)
STEM3BV2 - numeric(5,1) (ratio)
ID: TP10304.STEM3BV2
Biomass parameter 2 of stem3
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 0.100000
Numeric domain: type=real, min=0.1000 (exclusive=false), max=150.0000 (exclusive=false)
STEM3NO - numeric(5,0) (ratio)
ID: TP10304.STEM3NO
Number of stems containing the corresponding bv1 and bv2 values
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=1000.0000 (exclusive=false)
TP10305 - Equations used for calculating biomass
Object name: TP10305_v7.csv
Records: 1131
Attributes: 7
Temporal coverage: 1992-06-21 to 2024-07-03
File size: 78882 byte
Checksum (MD5): 37824364916a4f1a85345aec90706347
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TP10305.ALTEQU, TP10305.SPECIES, TP10305.YEAR
-
notNullConstraint: NOTNULL TP10305.ALTEQU, TP10305.EQUATION, TP10305.ENTITY, TP10305.SPECIES, TP10305.DBCODE, TP10305.YEAR
Attributes (7)
DBCODE - char(5) (nominal)
ID: TP10305.DBCODE
Database code
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
TP103
FSDB database code TP103
ENTITY - numeric(1,0) (interval)
ID: TP10305.ENTITY
Entity number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=5.0000 (exclusive=false), max=5.0000 (exclusive=false)
STUDY - char(11) (nominal)
ID: TP10305.STUDY
Study site location
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
Starrbright
Starrbright Timber Sale
YEAR - numeric(4,0) (interval)
ID: TP10305.YEAR
Sampling year
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1992.0000 (exclusive=false), max=2024.0000 (exclusive=false)
SPECIES - char(6) (nominal)
ID: TP10305.SPECIES
Species acronym according to Garrison et al. 1974
Type system: Microsoft SQL Server 2019
Code definitions (152)
-
BORAGI
Boraginaceae
-
LILIAC
Liliaceae
-
ABGR
Abies grandis
-
ACCI
Acer circinatum
-
ACMA
Acer macrophyllum
-
ACTR
Achlys triphylla
-
ADBI
Adenocaulon bicolor
-
AGGR
Agoseris grandiflora
-
AGHE
Agoseris heterophylla
-
AGROS
Agrostis
-
AGEX
Agrostis exarata
-
AGTE
Agrostis tenuis
-
AICA
Aira caryophyllea
-
AMAL
Amelanchier alnifolia
-
ANMA
Anaphalis margaritacea
-
ANDE
Anemone deltoidea
-
ANLY2
Anemone lyallii
-
ARME
Arbutus menziesii
-
ARCO3
Arctostaphylos columbiana
-
AREL
Arrhenatherum elatius
-
ASCA3
Asarum caudatum
-
BENE
Berberis nervosa
-
BROMU
Bromus
-
BRVU
Bromus vulgaris
-
CASC2
Campanula scouleri
-
CARDA
Cardamine
-
CAOL
Cardamine oligosperma
-
CAAM
Carex amplifolia
-
CEANO
Ceanothus
-
CEIN
Ceanothus integerrimus
-
CESA
Ceanothus sanguineus
-
CEVE
Ceanothus velutinus
-
CERAS
Cerastium
-
CEVU
Cerastium vulgatum
-
CHME
Chimaphila menziesii
-
CHUM
Chimaphila umbellata
-
CHLE2
Chrysanthemum leucanthemum
-
CIRSI
Cirsium
-
CIAR
Cirsium arvense
-
CIVU
Cirsium vulgare
-
CLUN
Clintonia uniflora
-
COHE
Collomia heterophylla
-
COCA2
Conyza canadensis
-
CONU
Cornus nuttallii
-
CRCA
Crepis capillaris
-
DEEL
Deschampsia elongata
-
ELGL
Elymus glaucus
-
EPILO
Epilobium
-
EPMI
Epilobium minutum
-
EPPA
Epilobium paniculatum
-
EPWA
Epilobium watsonii
-
EQTE
Equisetum telmateia
-
FESTU
Festuca
-
FEMY
Festuca myuros
-
FEOC
Festuca occidentalis
-
FRVE
Fragaria vesca
-
GALIU
Galium
-
GATR
Galium triflorum
-
GAFR
Garrya fremontii
-
GASH
Gaultheria shallon
-
GNPU
Gnaphalium purpureum
-
GNUL
Gnaphalium uliginosum
-
GOOB
Goodyera oblongifolia
-
HIAL
Hieracium albiflorum
-
HOLA
Holcus lanatus
-
HODI
Holodiscus discolor
-
HYPE
Hypericum perforatum
-
HYRA
Hypochaeris radicata
-
LAMU
Lactuca muralis
-
LASE
Lactuca serriola
-
LIBO2
Linnaea borealis
-
LISTE
Listera
-
LICO3
Listera cordata
-
LOCI
Lonicera ciliosa
-
LOCR
Lotus crassifolius
-
LOMI
Lotus micranthus
-
LOPU
Lotus purshianus
-
LULA
Lupinus latifolius
-
MAGR
Madia gracilis
-
MOPE
Montia perfoliata
-
MOSI
Montia sibirica
-
MYDI
Myosotis discolor
-
NEPA
Nemophila parviflora
-
OSCH
Osmorhiza chilensis
-
PEFR2
Petasites frigidus
-
PILA
Pinus lambertiana
-
POLYG
Polygonum
-
PODO
Polygonum douglasii
-
POMU
Polystichum munitum
-
PRVU
Prunella vulgaris
-
PREM
Prunus emarginata
-
PSME
Pseudotsuga menziesii
-
PTAQ
Pteridium aquilinum
-
PYAS
Pyrola asarifolia
-
PYPI
Pyrola picta
-
RAUN2
Ranunculus uncinatus
-
RHMA
Rhododendron macrophyllum
-
RIBES
Ribes
-
RILO
Ribes lobbii
-
ROGY
Rosa gymnocarpa
-
RUBUS
Rubus
-
RULE
Rubus leucodermis
-
RUNI
Rubus nivalis
-
RUPA
Rubus parviflorus
-
RUUR
Rubus ursinus
-
SACE
Sambucus cerulea
-
SEJA
Senecio jacobaea
-
SESY
Senecio sylvaticus
-
SIAN2
Silene antirrhina
-
SOAR
Sonchus arvensis
-
STELL
Stellaria
-
STCA2
Stellaria calycantha
-
TABR
Taxus brevifolia
-
THPL
Thuja plicata
-
TITR
Tiarella trifoliata
-
TRLA2
Trientalis latifolia
-
TROV
Trillium ovatum
-
TRCA
Trisetum canescens
-
TRCE
Trisetum cernuum
-
TSHE
Tsuga heterophylla
-
VAME
Vaccinium membranaceum
-
VAPA
Vaccinium parvifolium
-
VAHE
Vancouveria hexandra
-
VEAR
Veronica arvensis
-
VESE
Veronica serpyllifolia
-
VISE
Viola sempervirens
-
WHMO
Whipplea modesta
-
CACH
Castanopsis chrysophylla
-
EBAU
Eburophyton austiniae
-
SADO
Satureja douglasii
-
SMST
Smilacina stellata
-
EPAN
Epilobium angustifolium
-
SYMO
Symphoricarpos mollis
-
GNMI
Gnaphalium microcephalum
-
LUCA2
Luzula campestris
-
UNKN
unknown plant
-
HERB
Herb
-
TREE
Tree
-
SHRUB
Shrub
-
MOSS
Moss
-
LICHEN
Lichen
-
GRASS
Grass
-
LITTER
Litter
-
CWD
Coarse woody debris
-
BARE
Bare ground
-
LOG
Log
-
STONE
Stone
-
BUTT
Tree butt
-
STUMP
Tree stump
-
SNAG
Snag
-
UNKN2
unknown plant 2
-
ROOT
Root
EQUATION - varchar(55) (nominal)
ID: TP10305.EQUATION
Explicit equation used for calculating biomass. mht = height, mcov= cover, mdba = bottom diameter
Type system: Microsoft SQL Server 2019
ALTEQU - char(1) (ordinal)
ID: TP10305.ALTEQU
Alternative equation within a species for calculating biomass
Type system: Microsoft SQL Server 2019
Code definitions (4)
-
1
primary equation
-
2
second alternative equation
-
3
third alternative equation
-
4
fourth alternative equation
TP10306 - Estimated biomass using measurement data and equations
Object name: TP10306_v12.csv
Records: 37192
Attributes: 11
Temporal coverage: 1992-06-21 to 2024-07-03
File size: 2007481 byte
Checksum (MD5): bbb0ff76627f51708785944538a111ad
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TP10306.BLOCK, TP10306.PLOT, TP10306.SEASON, TP10306.SPECIES, TP10306.TMT, TP10306.YEAR
-
notNullConstraint: NOTNULL TP10306.BLOCK, TP10306.ENTITY, TP10306.PLOT, TP10306.SEASON, TP10306.SPECIES, TP10306.DBCODE, TP10306.TMT, TP10306.YEAR
Attributes (11)
DBCODE - char(5) (nominal)
ID: TP10306.DBCODE
Database code
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
TP103
FSDB database code TP103
ENTITY - numeric(1,0) (interval)
ID: TP10306.ENTITY
Entity number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=6.0000 (exclusive=false), max=6.0000 (exclusive=false)
STUDY - char(11) (nominal)
ID: TP10306.STUDY
Study site location
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
Starrbright
Starrbright Timber Sale
YEAR - numeric(4,0) (interval)
ID: TP10306.YEAR
Sampling year
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1992.0000 (exclusive=false), max=2024.0000 (exclusive=false)
SEASON - char(1) (nominal)
ID: TP10306.SEASON
Sampling season (1 - 3)
Type system: Microsoft SQL Server 2019
Code definitions (4)
-
U
Unknown season of sampling
-
1
First season of sampling per year (usually june)
-
2
Second season of sampling per year (usually july)
-
3
Third season of sampling per year (usually august)
BLOCK - numeric(2,0) (interval)
ID: TP10306.BLOCK
Sample block (1-25)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=25.0000 (exclusive=false)
PLOT - numeric(1,0) (interval)
ID: TP10306.PLOT
Sample plot w/in block (1-9)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=9.0000 (exclusive=false)
TMT - char(1) (nominal)
ID: TP10306.TMT
Treatment code (A-I)
Type system: Microsoft SQL Server 2019
Code definitions (9)
-
A
Control
-
B
Senecio sylvaticus removed
-
C
Epilobium angustifolium removed
-
D
Senecio sylvaticus and Epilobium angustifolium removed
-
E
Senecio sylvaticus and community removed
-
F
Epilobium angustifolium and community removed
-
G
Community removed
-
H
Rubus ursinus removed
-
I
Berberis nervosa and Gaultheria shallon removed
SPECIES - char(6) (nominal)
ID: TP10306.SPECIES
Species acronym according to Garrison et al. 1974
Type system: Microsoft SQL Server 2019
Code definitions (152)
-
BORAGI
Boraginaceae
-
LILIAC
Liliaceae
-
ABGR
Abies grandis
-
ACCI
Acer circinatum
-
ACMA
Acer macrophyllum
-
ACTR
Achlys triphylla
-
ADBI
Adenocaulon bicolor
-
AGGR
Agoseris grandiflora
-
AGHE
Agoseris heterophylla
-
AGROS
Agrostis
-
AGEX
Agrostis exarata
-
AGTE
Agrostis tenuis
-
AICA
Aira caryophyllea
-
AMAL
Amelanchier alnifolia
-
ANMA
Anaphalis margaritacea
-
ANDE
Anemone deltoidea
-
ANLY2
Anemone lyallii
-
ARME
Arbutus menziesii
-
ARCO3
Arctostaphylos columbiana
-
AREL
Arrhenatherum elatius
-
ASCA3
Asarum caudatum
-
BENE
Berberis nervosa
-
BROMU
Bromus
-
BRVU
Bromus vulgaris
-
CASC2
Campanula scouleri
-
CARDA
Cardamine
-
CAOL
Cardamine oligosperma
-
CAAM
Carex amplifolia
-
CEANO
Ceanothus
-
CEIN
Ceanothus integerrimus
-
CESA
Ceanothus sanguineus
-
CEVE
Ceanothus velutinus
-
CERAS
Cerastium
-
CEVU
Cerastium vulgatum
-
CHME
Chimaphila menziesii
-
CHUM
Chimaphila umbellata
-
CHLE2
Chrysanthemum leucanthemum
-
CIRSI
Cirsium
-
CIAR
Cirsium arvense
-
CIVU
Cirsium vulgare
-
CLUN
Clintonia uniflora
-
COHE
Collomia heterophylla
-
COCA2
Conyza canadensis
-
CONU
Cornus nuttallii
-
CRCA
Crepis capillaris
-
DEEL
Deschampsia elongata
-
ELGL
Elymus glaucus
-
EPILO
Epilobium
-
EPMI
Epilobium minutum
-
EPPA
Epilobium paniculatum
-
EPWA
Epilobium watsonii
-
EQTE
Equisetum telmateia
-
FESTU
Festuca
-
FEMY
Festuca myuros
-
FEOC
Festuca occidentalis
-
FRVE
Fragaria vesca
-
GALIU
Galium
-
GATR
Galium triflorum
-
GAFR
Garrya fremontii
-
GASH
Gaultheria shallon
-
GNPU
Gnaphalium purpureum
-
GNUL
Gnaphalium uliginosum
-
GOOB
Goodyera oblongifolia
-
HIAL
Hieracium albiflorum
-
HOLA
Holcus lanatus
-
HODI
Holodiscus discolor
-
HYPE
Hypericum perforatum
-
HYRA
Hypochaeris radicata
-
LAMU
Lactuca muralis
-
LASE
Lactuca serriola
-
LIBO2
Linnaea borealis
-
LISTE
Listera
-
LICO3
Listera cordata
-
LOCI
Lonicera ciliosa
-
LOCR
Lotus crassifolius
-
LOMI
Lotus micranthus
-
LOPU
Lotus purshianus
-
LULA
Lupinus latifolius
-
MAGR
Madia gracilis
-
MOPE
Montia perfoliata
-
MOSI
Montia sibirica
-
MYDI
Myosotis discolor
-
NEPA
Nemophila parviflora
-
OSCH
Osmorhiza chilensis
-
PEFR2
Petasites frigidus
-
PILA
Pinus lambertiana
-
POLYG
Polygonum
-
PODO
Polygonum douglasii
-
POMU
Polystichum munitum
-
PRVU
Prunella vulgaris
-
PREM
Prunus emarginata
-
PSME
Pseudotsuga menziesii
-
PTAQ
Pteridium aquilinum
-
PYAS
Pyrola asarifolia
-
PYPI
Pyrola picta
-
RAUN2
Ranunculus uncinatus
-
RHMA
Rhododendron macrophyllum
-
RIBES
Ribes
-
RILO
Ribes lobbii
-
ROGY
Rosa gymnocarpa
-
RUBUS
Rubus
-
RULE
Rubus leucodermis
-
RUNI
Rubus nivalis
-
RUPA
Rubus parviflorus
-
RUUR
Rubus ursinus
-
SACE
Sambucus cerulea
-
SEJA
Senecio jacobaea
-
SESY
Senecio sylvaticus
-
SIAN2
Silene antirrhina
-
SOAR
Sonchus arvensis
-
STELL
Stellaria
-
STCA2
Stellaria calycantha
-
TABR
Taxus brevifolia
-
THPL
Thuja plicata
-
TITR
Tiarella trifoliata
-
TRLA2
Trientalis latifolia
-
TROV
Trillium ovatum
-
TRCA
Trisetum canescens
-
TRCE
Trisetum cernuum
-
TSHE
Tsuga heterophylla
-
VAME
Vaccinium membranaceum
-
VAPA
Vaccinium parvifolium
-
VAHE
Vancouveria hexandra
-
VEAR
Veronica arvensis
-
VESE
Veronica serpyllifolia
-
VISE
Viola sempervirens
-
WHMO
Whipplea modesta
-
CACH
Castanopsis chrysophylla
-
EBAU
Eburophyton austiniae
-
SADO
Satureja douglasii
-
SMST
Smilacina stellata
-
EPAN
Epilobium angustifolium
-
SYMO
Symphoricarpos mollis
-
GNMI
Gnaphalium microcephalum
-
LUCA2
Luzula campestris
-
UNKN
unknown plant
-
HERB
Herb
-
TREE
Tree
-
SHRUB
Shrub
-
MOSS
Moss
-
LICHEN
Lichen
-
GRASS
Grass
-
LITTER
Litter
-
CWD
Coarse woody debris
-
BARE
Bare ground
-
LOG
Log
-
STONE
Stone
-
BUTT
Tree butt
-
STUMP
Tree stump
-
SNAG
Snag
-
UNKN2
unknown plant 2
-
ROOT
Root
B_VAL - numeric(3,0) (interval)
ID: TP10306.B_VAL
Unique biomass value for a given year, season, block, plot, tmt, species.
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1
Numeric domain: type=whole, min=1.0000 (exclusive=false), max=8.0000 (exclusive=false)
BIOMASS - numeric(12,5) (ratio)
ID: TP10306.BIOMASS
Estimated biomass
Type system: Microsoft SQL Server 2019
Unit: grams per square meter
Precision: 0.010000
Numeric domain: type=natural, min=0.0000 (exclusive=false), max=2279755.7500 (exclusive=false)
TP10307 - Assessment of 2018 burn severity
Object name: TP10307_v1.csv
Records: 75
Attributes: 15
Temporal coverage: 2019-07-03 to 2019-07-04
File size: 14836 byte
Checksum (MD5): 501de57ca677cebe70f4e4a583cef315
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TP10307.BLOCK, TP10307.PLOT, TP10307.TMT, TP10307.YEAR
-
notNullConstraint: NOTNULL TP10307.BLOCK, TP10307.ENTITY, TP10307.PLOT, TP10307.SDATE, TP10307.DBCODE, TP10307.TMT, TP10307.YEAR, TP10307.STUDY, TP10307.TREES_LIVE, TP10307.TREES_DEAD, TP10307.PCT_BURN, TP10307.PCT_BURN_ADJ, TP10307.BURN_CLASS
Attributes (15)
DBCODE - char(5) (nominal)
ID: TP10307.DBCODE
Database code
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
TP103
FSDB database code TP103
ENTITY - numeric(1,0) (interval)
ID: TP10307.ENTITY
Entity number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=7.0000 (exclusive=false), max=7.0000 (exclusive=false)
STUDY - char(11) (nominal)
ID: TP10307.STUDY
Study site location
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
Starrbright
Starrbright Timber Sale
YEAR - numeric(4,0) (interval)
ID: TP10307.YEAR
Sampling year
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=2019.0000 (exclusive=false), max=2019.0000 (exclusive=false)
SDATE - datetime (dateTime)
ID: TP10307.SDATE
Vegetation sampling date
Type system: Microsoft SQL Server 2019
Date format: YYYY-MM-DD
BLOCK - numeric(2,0) (interval)
ID: TP10307.BLOCK
Sample block (1-25)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=25.0000 (exclusive=false)
PLOT - numeric(1,0) (interval)
ID: TP10307.PLOT
Sample plot w/in block (1-9)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=9.0000 (exclusive=false)
TMT - char(1) (nominal)
ID: TP10307.TMT
Treatment code (A-I)
Type system: Microsoft SQL Server 2019
Code definitions (9)
-
A
Control
-
B
Senecio sylvaticus removed
-
C
Epilobium angustifolium removed
-
D
Senecio sylvaticus and Epilobium angustifolium removed
-
E
Senecio sylvaticus and community removed
-
F
Epilobium angustifolium and community removed
-
G
Community removed
-
H
Rubus ursinus removed
-
I
Berberis nervosa and Gaultheria shallon removed
TREES_LIVE - numeric(2,0) (ratio)
ID: TP10307.TREES_LIVE
Number of live trees within 2.5 m of the plot
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=12.0000 (exclusive=false)
TREES_DEAD - numeric(2,0) (ratio)
ID: TP10307.TREES_DEAD
Number of dead trees within 2.5 m of the plot
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=11.0000 (exclusive=false)
PROP_DEAD - numeric(2,1) (ratio)
ID: TP10307.PROP_DEAD
Proportion of trees within 2.5 m of the plot that are dead (undefined if there are no trees)
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1
Numeric domain: type=real, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)
PCT_BURN - numeric(3,0) (ratio)
ID: TP10307.PCT_BURN
Percentage of ground surface burned or charred within the plot
Type system: Microsoft SQL Server 2019
Unit: percent
Precision: 1
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)
PCT_BURN_ADJ - numeric(3,0) (ratio)
ID: TP10307.PCT_BURN_ADJ
Percentage of ground surface burned or charred within 0.5 m of the plot edge
Type system: Microsoft SQL Server 2019
Unit: percent
Precision: 1
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)
BURN_CLASS - char(2) (nominal)
ID: TP10307.BURN_CLASS
Burn class
Type system: Microsoft SQL Server 2019
Code definitions (3)
-
B
Burned
-
PB
Partially burned
-
UB
Unburned
BURN_COMMENT - char(254) (nominal)
ID: TP10307.BURN_COMMENT
Description of burn conditions
Type system: Microsoft SQL Server 2019
Units
| centimeters | cm | length | centimeter | meter | 0.01 | centimeters; .01 meters |
| grams per square meter | g/m2 | arealMassDensity | gramPerMeterSquared | kilogramPerMeterSquared | 0.001 | grams per square meter |
| number | number | dimensionless | number | dimensionless | 1 | dimensionless number, i.e., ratio, count |
| percent | % | dimensionless | number | dimensionless | 100 | percent; a number |
Intellectual Rights
Data Use Agreement:
The re-use of scientific data has the potential to greatly increase communication, collaboration and synthesis within and among disciplines, and thus is fostered, supported and encouraged. This Data Set is released under the Creative Commons license CC BY "Attribution" (see: https://creativecommons.org/licenses/by/4.0/). Creative Commons license CC BY - Attribution is a license that allows others to distribute, remix, tweak, and build upon your work (even commercially), as long as you are credited for the original creation. This license accommodates maximum dissemination and use of licensed materials.
It is considered professional conduct and an ethical obligation to acknowledge the work of other scientists. The Data User is asked to provide attribution of the original work if this data package is shared in whole or by individual parts or used in the derivation of other products. A recommended citation is provided for each Data Set in the Andrews LTER data catalog (see: http://andlter.forestry.oregonstate.edu/data/catalog/datacatalog.aspx). A generic citation is also provided for this Data Set on the website https://portal.edirepository.org in the summary metadata page. Data Users are thus strongly encouraged to consider consultation, collaboration and/or co-authorship with the Data Set Creator.
While substantial efforts are made to ensure the accuracy of data and associated documentation, complete accuracy of data sets cannot be guaranteed and all data are made available "as is." The Data User should be aware, however, that data are updated periodically and it is the responsibility of the Data User to check for new versions of the data. The data authors and the repository where these data were obtained shall not be liable for damages resulting from any use or misinterpretation of the data.
General acknowledgement: Data were provided by the HJ Andrews Experimental Forest research program, funded by the National Science Foundation's Long-Term Ecological Research Program (DEB 2025755), US Forest Service Pacific Northwest Research Station, and Oregon State University.
Licensed
License: Creative Commons Attribution 4.0 International Public License
Identifier: CC-BY-4.0
Maintenance
Maintenance update frequency: annually
Description
- An update history is logged and maintained with each new version of every dataset.
Change History
-
Version1 (1990-10-07) Original metadata creation.
-
Version2 (2002-03-01) Metadata restructured and moved into SQLServer metadata database LTERMETA. Data moved into SQLServer database FSDBDATA.
-
Version5 (2007-08-21) Annual data update.
-
Version6 (2008-09-29) Updated entity 1 with 2008 data. Ran QA/QC (from editdb) on all data. Data restriction rule only allows access to data prior to 1995. Charlie said this can change to 2000. Entity 6 (biomass) will also be updated soon, but data is not online.
-
Version7 (2008-11-06) updated entity 6 with 2008 data. Ran QA/QC (from editdb).
-
Version8 (2010-11-05) Unrestricted data per conversation with PI. (entities 2, 4, 6 were released from restriction).
-
Version11 (2011-10-19) Cleaned up specific entities to be consistent. See entity_update_history for details.
-
Version12 (2012-01-30) Replaced data for 2007-2010 and added 2011 data for entity 1 and 6.
-
Version13 (2012-08-02) Added 2012 data to entity 1 and 6. Made some modification to 2011 data and a global species change (entity 1). See entity_update_history for details.
-
Version14 (2014-09-11) Charlie had sent new files to replace 2011 and 2012 data, in addtion to new 2013 and 2014 data. Copied 1990-2012 data from SQL; deleted 2011 and 2012 data; added new data for 2011-2014. Ran QC; uploaded all data to SQL
-
Version15 (2015-07-23) Updated entities 1 and 6 with 2015 data
-
Version16 (2019-05-31) Imported 2017 and 2018 data from CSV for entities 1 and 6, ran QC (no problems), uploaded to SQL. Added study attribute as place domain (Starrbright); changed stcode to dbcode and format to entity. Made a copy of the data, ran QC, modified the SQL structure in entity_attribute, recreated the SQL table and appended data.
-
Version17 (2019-07-24) Updated entities 1 and 6 with 2019 data and a few corrections to previous data. Also modified the data restriction on these entities so that the most recent 3 years of data are restricted. Entity 5 was updated from 2005-2019. New entity 7 was added. Study level metadata has been updated.
-
Version18 (2022-01-26) Updated entities 1, 5 and 6 with data through 2020 and a few corrections to previous data. Study level metadata has been updated. Data restriction for entities 1 and 6 was removed.
-
Version19 (2022-08-01) Updated entities 1, 5 and 6 with 2022 data and a few corrections to previous data.
-
Version20 (2023-08-08) Updated entities 1, 5, 6 with replacement and new data through 2023.
-
Version21 (2024-08-07) Updated entities 1, 5, 6 with replacement and new data through 2024. Corrected a blank code in entity 2.