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

SP002: Soil Moisture and vegetation cover patterns after logging and burning an old-growth Douglas-fir forest in the Andrews Experimental Forest, 1960-1983

← Back to catalog index

Status: notPlanned
Period: 1960-04-18 to 1983-11-21
Version: 7
Published: 2013-12-16
EDI Package ID: knb-lter-and.3190.7
Source XML: SP002_7.xml

Notice

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

Citation

Levno, A.; Rothacher, J. 2013. Soil Moisture and vegetation cover patterns after logging and burning an old-growth Douglas-fir forest in the Andrews Experimental Forest, 1960-1983 Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/SP002 Accessed 2026-05-10.

Abstract

This soil moisture study was initiated in 1960 to investigate the effects of patch clearcut logging and slash burning (1962-63) in an old-growth Douglas-fir forest in the Oregon Cascade Range. Since soil moisture and vegetation sampling continued regularly until 1980, this is a unique data set that represents nearly two decades of post-treatment information. Plant cover exerts a profound influence on soil moisture levels through its effects on interception, infiltration, evaporation, and transpiration. In the Douglas-fir forests of the Pacific Northwest, clearcut logging and slash burning are common practices that can dramatically alter plant cover and soil moisture. Logging can increase soil moisture by temporarily reducing cover and associated water use, and burning may further augment soil moisture levels by suppressing the survival and regrowth of vegetation. Indeed, part of the rationale for slash burning in the region is to control shrubs and other vegetation that would otherwise compete with conifer seedlings for available moisture, light, and nutrients. Within a few years after burning, however, invading vegetation may deplete soil moisture to levels comparable to forested areas. Such observations point to the value of long-term information to better understand dynamic soil moisture and plant cover responses to forest practices.

Coverage

Temporal coverage: 1960-04-18 to 1983-11-21

Geographic coverage: Willamette National Forest; Andrews Experimental Forest, WS 3, unit 9C (L141)

Spatial coverage:

Bounds: W -122.24090134, E -122.23625296, N 44.21890888, S 44.21588476

Purpose
  • To study the relationship between vegetation cover and soil moisture during the re-establishment of vegetation after logging and burning of a Douglas-fir forest; to study the relationship between vegetation cover and soil water deficit and use, the change in soil moisture storage by depth over time, and the precipitation interception changes over various successional changes during re-establishment; also, to examine soil temperature by depth over time.
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
  • Paul W. Adams
    Role: Other Researcher
  • Alan L. Flint
    Role: Other Researcher
  • Richard L. Fredriksen
    Role: Former Investigator
  • Donald L. Henshaw
    Role: Abstractor
    Pacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, Oregon, 97331
    Email: hja_admin@fsl.orst.edu
  • Alfred B. Levno
    Role: Principal Investigator
    Corvallis, OR, 97331, USA
    Email: ablevno@comcast.net, allevno@hotmail.com
  • Alfred B. Levno
    Role: Creator
    Corvallis, OR, 97331, USA
    Email: ablevno@comcast.net, allevno@hotmail.com
  • Jack S. Rothacher
    Role: Creator
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
  • Donald L. Henshaw
    Pacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, Oregon, 97331
    Email: hja_admin@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 soil moisture study was initiated in 1960 to investigate the effects of patch clearcut logging and slash burning (1962-63) in an old-growth Douglas-fir forest in the Oregon Cascade Range. Since soil moisture and vegetation sampling continued regularly until 1980, this is a unique data set that represents nearly two decades of post-treatment information. Plant cover exerts a profound influence on soil moisture levels through its effects on interception, infiltration, evaporation, and transpiration. In the Douglas-fir forests of the Pacific Northwest, clearcut logging and slash burning are common practices that can dramatically alter plant cover and soil moisture. Logging can increase soil moisture by temporarily reducing cover and associated water use, and burning may further augment soil moisture levels by suppressing the survival and regrowth of vegetation. Indeed, part of the rationale for slash burning in the region is to control shrubs and other vegetation that would otherwise compete with conifer seedlings for available moisture, light, and nutrients. Within a few years after burning, however, invading vegetation may deplete soil moisture to levels comparable to forested areas. Such observations point to the value of long-term information to better understand dynamic soil moisture and plant cover responses to forest practices. To study the relationship between vegetation cover and soil moisture during the re-establishment of vegetation after logging and burning of a Douglas-fir forest; to study the relationship between vegetation cover and soil water deficit and use, the change in soil moisture storage by depth over time, and the precipitation interception changes over various successional changes during re-establishment; also, to examine soil temperature by depth over time. Field Methods - SP002

Purpose: To study the relationship between vegetation cover and soil moisture during the re-establishment of vegetation after logging and burning of a Douglas-fir forest; to study the relationship between vegetation cover and soil water deficit and use, the change in soil moisture storage by depth over time, and the precipitation interception changes over various successional changes during re-establishment; also, to examine soil temperature by depth over time.

Methods

Method Steps

Field Methods - SP002
  • In 1960, soil pits were dug andnd a soil moisture stack was installed at a random location near each sample point. Each stack consisted of laboratory-calibrated fiberglas resistance blocks and thermisters at three depths of 6, 18, and 36 in. (30, 60, 120 cm) to monitor soil moisture (in resistance units) and soil temperature. Resistance measurements were taken about every three weeks from mid-spring to mid-autumn in 1960-63, along with bulk soil samples for gravimetric analysis and field calibration of the resistance units. [Three gravimetric samples were taken using the King tube at random locations in the plot. Samples were collected at 0-6, 6-18, and 18-36 in. depths and placed in cans. The gravimetric samples were used to calibrate the Coleman fiberglas soil moisture units.] Due to a constantly shifting calibration, however, the resistance units were abandoned in 1963 in favor of gravimetric samples (1964-65). Conjecture is that fine clays infiltrate the fiberglas units yielding higher soil moisture readings. The gravimetric samples were oven-dried to determine soil moisture content. Bulk density of soil at the measurement depths was determined on installation of fiberglas units. Soil bulk density and soil moisture are used to determine inches of soil water. A neutron probe (Troxler probe and scale) was acquired for more accurate and direct soil moisture measurement and neutron probe measurements (1966, 1967, 1969, 1971, 1974, 1977, 1980, 1983) were taken over a similar seasonal schedule (from April until November). Neutron measurements were taken with a calibrated probe at three randomly located access tubes around each sample point, with gravimetric samples also taken periodically to verify probe results. A new neutron probe was acquired for 1983 measurements. April measurements have been used to measure soil field capacity.
  • All soil moisture data were converted to percent by volume and cm of moisture values using local soil bulk densities and coarse-fragment contents. Field capacity moisture contents were measured using soil cores collected 3-10 days following rain in winter. Plant-available moisture content was calculated as the field capacity moisture content minus the moisture content at -15 atm, using the pressure membrane method (Richards 1965). Available moisture capacity has since been more carefully defined to consider plant uptake of moisture at potentials lower than -15 atm (Flint and Childs 1984). Moisture at these lower potentials may only represent 2-4 percent water by volume (Flint 1983), however, so the data are still considered representative of nearly all of the available moisture in these soils.
  • Vegetation type and cover was measured on four, 4.0 square meter plots (6.7 ft squares (milacre)) orthogonally located within the circular plot around each sample point on the transect in the treatment area. Herbs, bare ground, and litter are assessed on macro plots occupying one quadrant (1/4 milacre). This macro plot is divided into nine systematically located 0.1 sq. m micro plots and used to measure herb and low shrub (less than 60 cm tall) cover, whereas the entire 4.0 m(square) plot was used for measurements of trees and vegetation >60 cm tall. Vegetation surveys were conducted in late July or early August starting in 1964, and subsequently in the same years as the soil moisture measurements. Data for individual species were stratified into herb and low shrub or tree and tall shrub cover consistent with Dyrness (1973). Data from different transects used by Dyrness (1965) provide estimates of plant cover in 1963.
  • One interception gage is located in each plot. Each gage is rotated around plot circumference at the four cardinal direction points. Gages are rotated at each collection time. A precipitation gage (no vegetation obstructions) is located on Plot 11 and serves as the standard for all soil moisture plots.
Permanent Plots - SP002
  • 6 .016 acre plots in the leave strip area of old-growth, and 5 (originally 6) .016 acre plots in the adjacent clearcut

Sampling

Study Extent
  • The study area is located within a 101 ha watershed (WS3) in the H.J. Andrews Experimental Forest, 60 km east of Eugene, Oregon (Lat. 44 degrees 13 minutes N, Long. 122 degrees 15 minutes W). The watershed extends from 500 to 1070 m in elevation, with slopes averaging about 53 percent (Fredriksen 1970). Soils in the watershed have developed from the local andesitic breccia bedrock found at 1-4 meters, and are predominantly classified as loamy, skeletal Typic Dystrochrepts. Some baseline physical properties of the soil are given in Table 1. Weather data collected since 1952 on an adjacent watershed show a mild, humid, temperate climate with an average annual temperature of 9.4 degrees Centigrade, and an average annual precipitation level of about 225 cm. Precipitation normally occurs as rain, which is concentrated between October and May. Summers are typically cool (ave. July temp. = 20.6 degrees C) and dry (Rothacher 1965).
  • Old-growth (300-500 yr) Douglas-fir (Pseudotsuga menziesii (Mirb.) Franco) dominates the undisturbed forest on the watershed, accompanied by numerous western hemlock (Tsuga heterophylla (Raf.) Sarg.) of various ages. Local site productivity for Douglas-fir is moderate (43 m height at 100 yr), and when the study began (1960), the basal area of the Douglas-fir-Hemlock stand was about 90 m(square)/ha. Major prelogging understory communities on the watershed were rhododendron-salal (Rhododendron macrophyllum-Gaultheria shallon), vine maple-salal (Acer circinatum-Gaultheria shallon), vine maple-Oregon grape (Acer circinatum-Berberis nervosa), cutleaf goldthread (Coptis laciniata), and swordfern (Polystichum munitum) (Dyrness 1973).
  • In the winter of 1962-63, 25 percent of the watershed was clearcut logged with a high-lead cable system in three patches of 5, 9, and 11 ha. The logged patches were broadcast burned in September of 1963, followed soon by planting of Douglas-fir seedlings. Log yarding resulted in largely minor and shallow soil disturbance in the cutover areas (Dyrness 1965), and moist conditions during burning produced only light, discontinuous charring of the surface litter (Fredriksen 1970).
  • Sampling frequency: 1-3 weeks
Sampling Description
  • In 1960, two random, parallel transects, each about 125 m long, were laid out up and down a 30 percent, SW-facing slope on the watershed. One of the transects was located well within one of the patches (9 ha) that was clearcut in 1962-63, while the other was in undisturbed forest for the entire study. Six equal segments (approx. 25 m each) are established in two strips parallel to the cutting boundary, one strip on either side. Soil moisture stacks were placed at random within each segment, and the stack becomes the center of a 0.16-ac circular plot (6 plots in old-growth, 6 in cutting area, but one plot (plot 7) was lost to road construction in the cutting area). Soil moisture, vegetation cover, and throughfall are measured on each plot. The plots were installed in HJA WS 3 in October 1959. The cutting area was clearcut in winter 1962-1963, completed in February 1963, and broadcast burned in September 1963.
  • NOTE: Plots 1-6 are in the forest; plots 8-12 are in the clearcut; plot 7 in clearcut was lost to road construction.
  • Citation:
  • Adams, Paul W.; Flint, Alan L. 1986. Soil moisture patterns following clearcut harvest of a Douglas-fir forest. Corvallis, OR: Oregon State University; project completion report to supplement number PNW-85-382. 18 p.
Spatial Sampling Units
  • Andrews Watershed 3
    W -122.24194900, E -122.22402200, N 44.21994300, S 44.20803100
    Altitude: 1080 to 1080 meter
  • UNIT L141
    W -122.24090134, E -122.23625296, N 44.21890888, S 44.21588476
    Altitude: 610 to 610 meter
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: interception (theme), water content (theme), trophic structure (theme), soil moisture (theme), water balance (theme), analytical tools (theme), neutron probe (theme), disturbance (theme), evapotranspiration (theme), clearcutting (theme), inorganic nutrients (theme), vegetation (theme)
  • Andrews Experimental Forest site thesaurus: Long-Term Ecological Research (LTER) (theme), gavimetric sampling (theme), moisture stress (theme)
  • LTER core research areas: disturbance (theme), inorganic nutrients (theme)
Taxonomic Hierarchy
  • All Organisms: All Organisms
  • Highest common category (ca. kingdom): Plantae
  • Division or Phylum: Polypodiophyta
  • Class: Filicopsida
  • Order: Polypodiales
  • Family: Dryopteridaceae
  • Genus: Polystichum
  • Species: Polystichum munitum
  • Division or Phylum: Magnoliophyta
  • Class: Magnoliopsida
  • Subclass: Hamamelididae
  • Order: Fagales
  • Family: Fagaceae
  • Genus: Chrysolepis
  • Species: Castanopsis chrysophylla
  • Subclass: Dilleniidae
  • Order: Ericales
  • Family: Ericaceae
  • Genus: Vaccinium
  • Species: Vaccinium parvifolium
  • Genus: Gaultheria
  • Species: Gaultheria shallon
  • Genus: Rhododendron
  • Species: Rhododendron macrophyllum
  • Order: Theales
  • Family: Clusiaceae
  • Genus: Hypericum
  • Species: Hypericum perforatum
  • Subclass: Magnoliidae
  • Order: Papaverales
  • Family: Fumariaceae
  • Genus: Dicentra
  • Species: Dicentra formosa
  • Order: Ranunculales
  • Family: Ranunculaceae
  • Genus: Coptis
  • Species: Coptis laciniata
  • Genus: Anemone
  • Species: Anemone deltoidea
  • Family: Berberidaceae
  • Genus: Berberis
  • Species: Berberis nervosa
  • Subclass: Rosidae
  • Order: Rosales
  • Family: Grossulariaceae
  • Genus: Ribes
  • Species: Ribes sanguineum
  • Family: Rosaceae
  • Genus: Holodiscus
  • Species: Holodiscus discolor
  • Genus: Rubus
  • Species: Rubus parviflorus
  • Species: Rubus leucodermis
  • Species: Rubus ursinus
  • Family: Hydrangeaceae
  • Genus: Whipplea
  • Species: Whipplea modesta
  • Order: Rhamnales
  • Family: Rhamnaceae
  • Genus: Rhamnus
  • Species: Rhamnus purshiana
  • Genus: Ceanothus
  • Species: Ceanothus sanguineus
  • Species: Ceanothus velutinus
  • Order: Sapindales
  • Family: Aceraceae
  • Genus: Acer
  • Species: Acer circinatum
  • Order: Cornales
  • Family: Cornaceae
  • Genus: Cornus
  • Species: Cornus nuttallii
  • Species: Cornus canadensis
  • Order: Myrtales
  • Family: Onagraceae
  • Genus: Epilobium
  • Species: Epilobium watsonii
  • Species: Epilobium minutum
  • Species: Epilobium paniculatum
  • Species: Epilobium angustifolium
  • Order: Fabales
  • Family: Fabaceae
  • Genus: Lotus
  • Species: Lotus micranthus
  • Genus: Trifolium
  • Species: Trifolium latifolium
  • Class: Liliopsida
  • Subclass: Liliidae
  • Order: Liliales
  • Family: Liliaceae
  • Genus: Trillium
  • Species: Trillium ovatum
  • Order: Orchidales
  • Family: Orchidaceae
  • Genus: Listera
  • Species: Listera borealis
  • Subclass: Asteridae
  • Order: Dipsacales
  • Family: Caprifoliaceae
  • Genus: Sambucus
  • Order: Gentianales
  • Family: Gentianaceae
  • Genus: Frasera
  • Species: Frasera speciosa
  • Order: Asterales
  • Family: Asteraceae
  • Genus: Gnaphalium
  • Species: Gnaphalium microcephalum
  • Genus: Cirsium
  • Species: Cirsium brevifolium
  • Species: Cirsium arvense
  • Species: Cirsium vulgare
  • Genus: Anaphalis
  • Species: Anaphalis margaritacea
  • Genus: Cotula
  • Species: Cotula coronopifolia
  • Genus: Hieracium
  • Species: Hieracium albiflorum
  • Genus: Madia
  • Species: Madia madioides
  • Genus: Senecio
  • Species: Senecio sylvaticus
  • Order: Rubiales
  • Family: Rubiaceae
  • Genus: Galium
  • Species: Galium triflorum
  • Subclass: Commelinidae
  • Order: Juncales
  • Family: Juncaceae
  • Genus: Luzula
  • Species: Luzula comosa
  • Order: Cyperales
  • Family: Poaceae
  • Genus: Festuca
  • Species: Festuca occidentalis
  • Division or Phylum: Coniferophyta
  • Class: Pinopsida
  • Order: Taxales
  • Family: Taxaceae
  • Genus: Taxus
  • Species: Taxus brevifolia
  • Order: Pinales
  • Family: Pinaceae
  • Genus: Pseudotsuga
  • Species: Pseudotsuga menziesii
  • Genus: Tsuga
  • Species: Tsuga heterophylla
Data Entities
# Entity Metadata Data
1 SP00201
SP00201
Soil moisture content, 1960 - 1983:
METADATA DATA
2 SP00202
SP00202
Soil temperature:
METADATA DATA
3 SP00203
SP00203
Throughfall: A series of raingages under the forest canopy and in the clearcut, as well as other nearby raingages, can be used to estimate throughfall.
METADATA DATA
4 SP00204
SP00204
Vegetation cover by species:
METADATA DATA
5 SP00205
SP00205
Vegetation cover (on microplots) by cover type:
METADATA DATA
6 SP00206
SP00206
Vegetation cover by cover type:
METADATA DATA
Metadata
SP00201 - SP00201

Object name: SP00201.csv

Records: 515

Attributes: 16

File size: 42779 byte

Checksum (MD5): 8e1baa8c0732d00a4d5d535adbef53c8

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

Constraints (2)
  • primaryKey: PRIMARY
    SP00201.DATE, SP00201.DEPTH
  • notNullConstraint: NOTNULL
    SP00201.DATE, SP00201.DEPTH, SP00201.FORMAT, SP00201.PLOT2, SP00201.PLOT3, SP00201.PLOT4, SP00201.PLOT5, SP00201.PLOT6, SP00201.SITECODE, SP00201.STCODE
Attributes (16)
STCODE - char(5) (nominal)

ID: SP00201.STCODE

Study code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • SP002
    FSDB Database Study Code
FORMAT - numeric(1,0) (interval)

ID: SP00201.FORMAT

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SITECODE - char(4) (nominal)

ID: SP00201.SITECODE

Site code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • WS03
    Andrews watershed 3: clearcut L141, forest NW of L141
DATE - datetime (dateTime)

ID: SP00201.DATE

Date of measurement

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

DEPTH - numeric(3,1) (ratio)

ID: SP00201.DEPTH

Soil depth

Type system: Microsoft SQL Server 2008

Unit: feet

Precision: 0.100000

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

PLOT1 - numeric(4,1) (ratio)

ID: SP00201.PLOT1

Moisture content of soil at plot 1

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

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

PLOT2 - numeric(4,1) (ratio)

ID: SP00201.PLOT2

Moisture content of soil at plot 2

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

Numeric domain: type=real, min=9.4000 (exclusive=false), max=66.7000 (exclusive=false)

PLOT3 - numeric(4,1) (ratio)

ID: SP00201.PLOT3

Moisture content of soil at plot 3

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

Numeric domain: type=real, min=7.7000 (exclusive=false), max=61.7000 (exclusive=false)

PLOT4 - numeric(4,1) (ratio)

ID: SP00201.PLOT4

Moisture content of soil at plot 4

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

Numeric domain: type=real, min=8.6000 (exclusive=false), max=62.4000 (exclusive=false)

PLOT5 - numeric(4,1) (ratio)

ID: SP00201.PLOT5

Moisture content of soil at plot 5

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

Numeric domain: type=real, min=9.9000 (exclusive=false), max=50.8000 (exclusive=false)

PLOT6 - numeric(4,1) (ratio)

ID: SP00201.PLOT6

Moisture content of soil at plot 6

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

Numeric domain: type=real, min=6.9000 (exclusive=false), max=48.6000 (exclusive=false)

PLOT8 - numeric(4,1) (ratio)

ID: SP00201.PLOT8

Moisture content of soil at plot 8

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

Numeric domain: type=real, min=6.9000 (exclusive=false), max=57.4000 (exclusive=false)

PLOT9 - numeric(4,1) (ratio)

ID: SP00201.PLOT9

Moisture content of soil at plot 9

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

Numeric domain: type=real, min=7.8000 (exclusive=false), max=66.7000 (exclusive=false)

PLOT10 - numeric(4,1) (ratio)

ID: SP00201.PLOT10

Moisture content of soil at plot 10

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

Numeric domain: type=real, min=8.6000 (exclusive=false), max=61.7000 (exclusive=false)

PLOT11 - numeric(4,1) (ratio)

ID: SP00201.PLOT11

Moisture content of soil at plot 11

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

Numeric domain: type=real, min=6.6000 (exclusive=false), max=52.8000 (exclusive=false)

PLOT12 - numeric(4,1) (ratio)

ID: SP00201.PLOT12

Moisture content of soil at plot 12

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

Numeric domain: type=real, min=5.7000 (exclusive=false), max=48.8000 (exclusive=false)

SP00202 - SP00202

Object name: SP00202.csv

Records: 389

Attributes: 19

File size: 25793 byte

Checksum (MD5): d3b6816b492529c5f757f90288622e14

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

Constraints (2)
  • primaryKey: PRIMARY
    SP00202.DATE, SP00202.PLOTCODE
  • notNullConstraint: NOTNULL
    SP00202.DATE, SP00202.FORMAT, SP00202.PLOTCODE, SP00202.STCODE
Attributes (19)
STCODE - char(5) (nominal)

ID: SP00202.STCODE

Study code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • SP002
    FSDB Database Study Code
FORMAT - numeric(1,0) (interval)

ID: SP00202.FORMAT

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

PLOTCODE - char(1) (nominal)

ID: SP00202.PLOTCODE

Specifies if sample from plots 2-6 (forest) or plots 8-12 (clearcut)

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • 1
    Plots 2-6, in forest
  • 2
    Plots 8-12, in clearcut
DATE - datetime (dateTime)

ID: SP00202.DATE

Date of measurement

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

STEMP061 - numeric(3,0) (ratio)

ID: SP00202.STEMP061

Soil temperature at plot 2 or 8, depth=.5 ft

Type system: Microsoft SQL Server 2008

Unit: degrees Fahrenheit

Precision: 1.000000

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

STEMP062 - numeric(3,0) (ratio)

ID: SP00202.STEMP062

Soil temperature at plot 3 or 9, depth=.5 ft

Type system: Microsoft SQL Server 2008

Unit: degrees Fahrenheit

Precision: 1.000000

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

STEMP063 - numeric(3,0) (ratio)

ID: SP00202.STEMP063

Soil temperature at plot 4 or 10, depth=.5 ft

Type system: Microsoft SQL Server 2008

Unit: degrees Fahrenheit

Precision: 1.000000

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

STEMP064 - numeric(3,0) (ratio)

ID: SP00202.STEMP064

Soil temperature at plot 5 or 11, depth=.5 ft

Type system: Microsoft SQL Server 2008

Unit: degrees Fahrenheit

Precision: 1.000000

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

STEMP065 - numeric(3,0) (ratio)

ID: SP00202.STEMP065

Soil temperature at plot 6 or 12, depth=.5 ft

Type system: Microsoft SQL Server 2008

Unit: degrees Fahrenheit

Precision: 1.000000

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

STEMP181 - numeric(3,0) (ratio)

ID: SP00202.STEMP181

Soil temperature at plot 2 or 8, depth=1.5 ft

Type system: Microsoft SQL Server 2008

Unit: degrees Fahrenheit

Precision: 1.000000

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

STEMP182 - numeric(3,0) (ratio)

ID: SP00202.STEMP182

Soil temperature at plot 3 or 9, depth=1.5 ft

Type system: Microsoft SQL Server 2008

Unit: degrees Fahrenheit

Precision: 1.000000

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

STEMP183 - numeric(3,0) (ratio)

ID: SP00202.STEMP183

Soil temperature at plot 4 or 10, deplth=1.5 ft

Type system: Microsoft SQL Server 2008

Unit: degrees Fahrenheit

Precision: 1.000000

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

STEMP184 - numeric(3,0) (ratio)

ID: SP00202.STEMP184

Soil temperature at plot 5 or 11, depth=1.5 ft

Type system: Microsoft SQL Server 2008

Unit: degrees Fahrenheit

Precision: 1.000000

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

STEMP185 - numeric(3,0) (ratio)

ID: SP00202.STEMP185

Soil temperature at plot 6 or 12, depth=1.5 ft

Type system: Microsoft SQL Server 2008

Unit: degrees Fahrenheit

Precision: 1.000000

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

STEMP361 - numeric(3,0) (ratio)

ID: SP00202.STEMP361

Soil temperature at plot 2 or 8, depth=3.0 ft

Type system: Microsoft SQL Server 2008

Unit: degrees Fahrenheit

Precision: 1.000000

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

STEMP362 - numeric(3,0) (ratio)

ID: SP00202.STEMP362

Soil temperature at plot 3 or 9, depth=3.0 ft

Type system: Microsoft SQL Server 2008

Unit: degrees Fahrenheit

Precision: 1.000000

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

STEMP363 - numeric(3,0) (ratio)

ID: SP00202.STEMP363

Soil temperature at plot 4 or 10, depth=3.0 ft

Type system: Microsoft SQL Server 2008

Unit: degrees Fahrenheit

Precision: 1.000000

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

STEMP364 - numeric(3,0) (ratio)

ID: SP00202.STEMP364

Soil temperature at plot 5 or 11, depth=3.0 ft

Type system: Microsoft SQL Server 2008

Unit: degrees Fahrenheit

Precision: 1.000000

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

STEMP365 - numeric(3,0) (ratio)

ID: SP00202.STEMP365

Soil temperature at plot 6 or 12, depth=3.0 ft

Type system: Microsoft SQL Server 2008

Unit: degrees Fahrenheit

Precision: 1.000000

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

SP00203 - SP00203

Object name: SP00203.csv

Records: 269

Attributes: 17

File size: 18624 byte

Checksum (MD5): 6e1342d6e8970c00afe467b194cc7945

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

Constraints (2)
  • primaryKey: PRIMARY
    SP00203.DATE
  • notNullConstraint: NOTNULL
    SP00203.DATE, SP00203.FORMAT, SP00203.STCODE
Attributes (17)
STCODE - char(5) (nominal)

ID: SP00203.STCODE

Study code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • SP002
    FSDB Database Study Code
FORMAT - numeric(1,0) (interval)

ID: SP00203.FORMAT

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

DATE - datetime (dateTime)

ID: SP00203.DATE

Date of measurement

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TRANS1A - numeric(5,2) (interval)

ID: SP00203.TRANS1A

Forest raingage A

Type system: Microsoft SQL Server 2008

Unit: inches

Precision: 0.010000

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

TRANS1B - numeric(5,2) (interval)

ID: SP00203.TRANS1B

Forest raingage B

Type system: Microsoft SQL Server 2008

Unit: inches

Precision: 0.010000

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

TRANS1C - numeric(5,2) (interval)

ID: SP00203.TRANS1C

Forest raingage C

Type system: Microsoft SQL Server 2008

Unit: inches

Precision: 0.010000

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

TRANS1D - numeric(5,2) (interval)

ID: SP00203.TRANS1D

Forest raingage D

Type system: Microsoft SQL Server 2008

Unit: inches

Precision: 0.010000

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

TRANS1E - numeric(5,2) (interval)

ID: SP00203.TRANS1E

Forest raingage E

Type system: Microsoft SQL Server 2008

Unit: inches

Precision: 0.010000

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

TRANS2A - numeric(5,2) (interval)

ID: SP00203.TRANS2A

Clearcut raingage A

Type system: Microsoft SQL Server 2008

Unit: inches

Precision: 0.010000

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

TRANS2B - numeric(5,2) (interval)

ID: SP00203.TRANS2B

Clearcut raingage B

Type system: Microsoft SQL Server 2008

Unit: inches

Precision: 0.010000

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

TRANS2C - numeric(5,2) (interval)

ID: SP00203.TRANS2C

Clearcut raingage C

Type system: Microsoft SQL Server 2008

Unit: inches

Precision: 0.010000

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

TRANS2D - numeric(5,2) (interval)

ID: SP00203.TRANS2D

Clearcut raingage D

Type system: Microsoft SQL Server 2008

Unit: inches

Precision: 0.010000

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

TRANS2E - numeric(5,2) (interval)

ID: SP00203.TRANS2E

Clearcut raingage E

Type system: Microsoft SQL Server 2008

Unit: inches

Precision: 0.010000

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

CLIMATE2 - numeric(5,2) (ratio)

ID: SP00203.CLIMATE2

Climatic Station #2 raingage

Type system: Microsoft SQL Server 2008

Unit: inches

Precision: 0.010000

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

FORKS - numeric(5,2) (ratio)

ID: SP00203.FORKS

Forks raingage

Type system: Microsoft SQL Server 2008

Unit: inches

Precision: 0.010000

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

MGAGE - numeric(5,2) (ratio)

ID: SP00203.MGAGE

M3 raingage (on M-road as part of early ws 1, 2, 3 rain network)

Type system: Microsoft SQL Server 2008

Unit: inches

Precision: 0.010000

Numeric domain: type=real, min=0.0300 (exclusive=false), max=16.4000 (exclusive=false)

SITESRG - numeric(5,2) (ratio)

ID: SP00203.SITESRG

On site standard raingage (in plot 11) serves as standard for all soil moist ure plots

Type system: Microsoft SQL Server 2008

Unit: inches

Precision: 0.010000

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

SP00204 - SP00204

Object name: SP00204.csv

Records: 316

Attributes: 10

File size: 15420 byte

Checksum (MD5): abc76d296fe5b24ea1c161fcdb3ac91e

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

Constraints (2)
  • primaryKey: PRIMARY
    SP00204.SPECIES, SP00204.YEAR
  • notNullConstraint: NOTNULL
    SP00204.COVER_10, SP00204.COVER_11, SP00204.COVER_12, SP00204.COVER_8, SP00204.COVER_9, SP00204.FORMAT, SP00204.SPECIES, SP00204.STCODE, SP00204.VEGTYPE, SP00204.YEAR
Attributes (10)
STCODE - char(5) (nominal)

ID: SP00204.STCODE

Study code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • SP002
    FSDB Database Study Code
FORMAT - numeric(1,0) (interval)

ID: SP00204.FORMAT

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

YEAR - numeric(4,0) (dateTime)

ID: SP00204.YEAR

Year of survey

Type system: Microsoft SQL Server 2008

Date format: YYYY

VEGTYPE - char(1) (nominal)

ID: SP00204.VEGTYPE

Vegetation type

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • 1
    Herbaceous
  • 2
    Woody
SPECIES - char(6) (nominal)

ID: SP00204.SPECIES

Vegetation genus, species acronym according to Garrison et all., 1972

Type system: Microsoft SQL Server 2008

Code definitions (50)
  • ACCI
    Acer circinatum
  • ANMA
    Anaphalis margaritacea
  • ANDE
    Anemone deltoidea
  • BENE
    Berberis nervosa
  • CESA
    Ceanothus sanguineus
  • CEVE
    Ceanothus velutinus
  • CIRSI
    Cirsium
  • CIAR
    Cirsium arvense
  • CIBR
    Cirsium brevifolium
  • CIVU
    Cirsium vulgare
  • COLA
    Coptis laciniata
  • COCA
    Cornus canadensis
  • CONU
    Cornus nuttallii
  • COCO
    Cotula coronopifolia
  • DIFO
    Dicentra formosa
  • EPILO
    Epilobium
  • EPMI
    Epilobium minutum
  • EPPA
    Epilobium paniculatum
  • EPWA
    Epilobium watsonii
  • FEOC
    Festuca occidentalis
  • FRSP
    Frasera speciosa
  • GATR
    Galium triflorum
  • GASH
    Gaultheria shallon
  • HIAL
    Hieracium albiflorum
  • HODI
    Holodiscus discolor
  • HYPE
    Hypericum perforatum
  • LIBO
    Listera borealis
  • LOMI
    Lotus micranthus
  • LUCO
    Luzula comosa
  • MAMA
    Madia madioides
  • POMU
    Polystichum munitum
  • PSME
    Pseudotsuga menziesii
  • RHPU
    Rhamnus purshiana
  • RHMA
    Rhododendron macrophyllum
  • RISA
    Ribes sanguineum
  • RULE
    Rubus leucodermis
  • RUPA
    Rubus parviflorus
  • RUUR
    Rubus ursinus
  • SAMBU
    Sambucus
  • SESY
    Senecio sylvaticus
  • TABR
    Taxus brevifolia
  • TRLA
    Trifolium latifolium
  • TROV
    Trillium ovatum
  • TSHE
    Tsuga heterophylla
  • VAPA
    Vaccinium parvifolium
  • WHMO
    Whipplea modesta
  • CACH
    Castanopsis chrysophylla
  • EPAN
    Epilobium angustifolium
  • GNMI
    Gnaphalium microcephalum
  • GRAMIN
    Gramin
COVER_8 - numeric(6,2) (ratio)

ID: SP00204.COVER_8

Percent vegetation cover by species on plot 8

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

COVER_9 - numeric(6,2) (ratio)

ID: SP00204.COVER_9

Percent vegetation cover by species on plot 9

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

COVER_10 - numeric(6,2) (ratio)

ID: SP00204.COVER_10

Percent vegetation cover by species on plot 10

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

COVER_11 - numeric(6,2) (ratio)

ID: SP00204.COVER_11

Percent vegetation cover by species on plot 11

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

COVER_12 - numeric(6,2) (ratio)

ID: SP00204.COVER_12

Percent vegetation cover by species on plot 12

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

SP00205 - SP00205

Object name: SP00205.csv

Records: 545

Attributes: 15

File size: 26074 byte

Checksum (MD5): bf61ab08a7b3e21454681bcea98bfbcd

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

Constraints (2)
  • primaryKey: PRIMARY
    SP00205.COVERTYPE, SP00205.PLOT, SP00205.PLOTQUAD, SP00205.YEAR
  • notNullConstraint: NOTNULL
    SP00205.COVER1, SP00205.COVER2, SP00205.COVER3, SP00205.COVER4, SP00205.COVER5, SP00205.COVER6, SP00205.COVER7, SP00205.COVER8, SP00205.COVER9, SP00205.COVERTYPE, SP00205.FORMAT, SP00205.PLOT, SP00205.PLOTQUAD, SP00205.STCODE, SP00205.YEAR
Attributes (15)
STCODE - char(5) (nominal)

ID: SP00205.STCODE

Study code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • SP002
    FSDB Database Study Code
FORMAT - numeric(1,0) (interval)

ID: SP00205.FORMAT

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

YEAR - numeric(4,0) (dateTime)

ID: SP00205.YEAR

Year of survey

Type system: Microsoft SQL Server 2008

Date format: YYYY

PLOT - numeric(2,0) (interval)

ID: SP00205.PLOT

Macro plot number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

PLOTQUAD - char(2) (nominal)

ID: SP00205.PLOTQUAD

Plot quadrant (ne, nw, se, sw)

Type system: Microsoft SQL Server 2008

Code definitions (4)
  • NE
    Northeast quadrant of plot
  • NW
    Northwest quadrant of plot
  • SE
    Southeast quadrant of plot
  • SW
    Southwest quadrant of plot
COVERTYPE - char(2) (nominal)

ID: SP00205.COVERTYPE

Cover type

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • BG
    Bare ground
  • LI
    Litter
  • LO
    Logs
  • MO
    Moss
  • SL
    Slash
  • SO
    Stones
  • SU
    Stumps
  • UN
    Unknown = % cover of herbaceous and some woody species on microplot (1964 - 1967 only) - probably best to recategorize as 'litter'.
COVER1 - numeric(4,0) (ratio)

ID: SP00205.COVER1

Percent cover in microplot 1

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1.000000

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

COVER2 - numeric(4,0) (ratio)

ID: SP00205.COVER2

Percent cover in microplot 2

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1.000000

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

COVER3 - numeric(4,0) (ratio)

ID: SP00205.COVER3

Percent cover in microplot 3

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1.000000

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

COVER4 - numeric(4,0) (ratio)

ID: SP00205.COVER4

Percent cover in microplot 4

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1.000000

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

COVER5 - numeric(4,0) (ratio)

ID: SP00205.COVER5

Percent cover in microplot 5

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1.000000

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

COVER6 - numeric(4,0) (ratio)

ID: SP00205.COVER6

Percent cover in microplot 6

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1.000000

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

COVER7 - numeric(4,0) (ratio)

ID: SP00205.COVER7

Percent cover in microplot 7

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1.000000

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

COVER8 - numeric(4,0) (ratio)

ID: SP00205.COVER8

Percent cover in microplot 8

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1.000000

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

COVER9 - numeric(4,0) (ratio)

ID: SP00205.COVER9

Percent cover in microplot 9

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1.000000

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

SP00206 - SP00206

Object name: SP00206.csv

Records: 63

Attributes: 9

File size: 2524 byte

Checksum (MD5): f184be87d0167aaba23bf45312d44d6d

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

Constraints (2)
  • primaryKey: PRIMARY
    SP00206.COVERTYPE, SP00206.YEAR
  • notNullConstraint: NOTNULL
    SP00206.COVERTYPE, SP00206.COVTYPE_10, SP00206.COVTYPE_11, SP00206.COVTYPE_12, SP00206.COVTYPE_8, SP00206.COVTYPE_9, SP00206.FORMAT, SP00206.STCODE, SP00206.YEAR
Attributes (9)
STCODE - char(5) (nominal)

ID: SP00206.STCODE

Study code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • SP002
    FSDB Database Study Code
FORMAT - numeric(1,0) (interval)

ID: SP00206.FORMAT

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

YEAR - numeric(4,0) (dateTime)

ID: SP00206.YEAR

Year of survey

Type system: Microsoft SQL Server 2008

Date format: YYYY

COVERTYPE - char(2) (nominal)

ID: SP00206.COVERTYPE

Cover type

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • BG
    Bare ground
  • LI
    Litter
  • LO
    Logs
  • MO
    Moss
  • SL
    Slash
  • SO
    Stones
  • SU
    Stumps
  • UN
    Unknown = % cover of herbaceous and some woody species on microplot (1964 - 1967 only) - probably best to recategorize as 'litter'.
COVTYPE_8 - numeric(6,1) (ratio)

ID: SP00206.COVTYPE_8

Percent cover type in plot 8

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

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

COVTYPE_9 - numeric(6,1) (ratio)

ID: SP00206.COVTYPE_9

Percent cover type in plot 9

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

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

COVTYPE_10 - numeric(6,1) (ratio)

ID: SP00206.COVTYPE_10

Percent cover type in plot 10

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

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

COVTYPE_11 - numeric(6,1) (ratio)

ID: SP00206.COVTYPE_11

Percent cover type in plot 11

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

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

COVTYPE_12 - numeric(6,1) (ratio)

ID: SP00206.COVTYPE_12

Percent cover type in plot 12

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

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

Units
feet ft length foot meter 0.3048 feet; 12 inches
degrees Fahrenheit deg f temperature fahrenheitDegree kelvin 0.556 Degrees Fahrenheit; an obsolescent unit of temperature still used in popular meteorology; constantToSI= -255.402
inches in length inch meter 0.0254 inches; an imperial measure of length
percent % dimensionless number dimensionless 100 percent; a number
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: notPlanned

Description

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

Change History

  • Version1 (1984-11-14)
    Original metadata creation.
  • Version2 (1986-10-23)
    Alan Flint and Paul Adams thoroughly reviewed the raw soil moisture data in Summer 1986 and compiled the summary available in Entity 1. Alan worked with Don Henshaw to build the first complete and quality assured version of all entities.
  • Version3 (2002-05-29)
    Metadata restructured and moved into SQLServer metadata database LTERMETA. Data moved into SQLServer database FSDBDATA.
  • Version7 (2013-12-16)
    Updated dates for formats 1-3 to truetype; created enum for STCODE; Added species code to attribute_taxonomic_classif for format 4; reran createcsv to create new delimiter for uploading into PASTA.