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

TD035: Coarse woody debris volume and mass from line transect inventory from reference stands and inventory plots of the Pacific Northwest, 1997 to 2005

← Back to catalog index

Status: notPlanned
Period: 1997-06-01 to 2005-09-30
Version: 9
Published: 2015-12-14
EDI Package ID: knb-lter-and.3124.9
Source XML: TD035_9.xml

Notice

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

Citation

Harmon, M. 2015. Coarse woody debris volume and mass from line transect inventory from reference stands and inventory plots of the Pacific Northwest, 1997 to 2005 Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/TD035 Accessed 2026-05-10.

Abstract

These data can be used to provide an inventory of the volume of coarse woody debris stored in forests.

Coverage

Temporal coverage: 1997-06-01 to 2005-09-30

Geographic coverage: Wind River Experimental Forest

Spatial coverage:

Bounds: W -122.25781500, E -122.17079300, N 44.26974800, S 44.20111000

Purpose

No purpose entries listed in this EML file.

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
  • Mark E. Harmon
    Role: Principal Investigator
    Oregon State University;Dept. of Forest Science;321 Richardson Hall, Corvallis, OR, 97331-5752, USA
    Phone: (541) 737-8455, (978) 724-0045 ext 223
    Email: mark.harmon@oregonstate.edu
  • Jay M. Sexton
    Role: Other Researcher
    Corvallis, OR, 97331-5752, USA
    Phone: (541) 737-8430
    Email: hexagon@exchangenet.net
  • Becky Fasth
    Role: Other Researcher
    Oregon State University;College of Forestry;Dept. of Forest Ecosystems and Society; 201L Richardson Hall, Corvallis, OR, 97331, USA
    Phone: (541) 737-8431, (541) 737-8460
    Email: becky.fasth@oregonstate.edu
  • Mark E. Harmon
    Role: Creator
    Oregon State University;Dept. of Forest Science;321 Richardson Hall, Corvallis, OR, 97331-5752, USA
    Phone: (541) 737-8455, (978) 724-0045 ext 223
    Email: mark.harmon@oregonstate.edu
Contact
Publisher
  • Andrews Forest LTER Site
    Role: Publisher
    Forest Ecosystems and Society Department in Forestry, Oregon State University, 201K Richardson Hall, Corvallis, OR, 97331-5752
    Phone: (541) 737-8480
    Email: lterweb@fsl.orst.edu
Study Description

These data can be used to provide an inventory of the volume of coarse woody debris stored in forests. Field Methods - TD035

Methods

Method Steps

Field Methods - TD035
  • All pieces of coarse woody debris greater than 10 cm diameter were measured on a 25 M transect. Species, decay class, and diameter were recorded. Volumes were calculated using standard line transect methods (Van Wagner, Brown).

Sampling

Study Extent
  • Sampling frequency: once only
Sampling Description
  • Transects were systematically placed throughout the Canopy Crane plot at Wind River Experimental Forest. Transects were 25 M long, set along boundaries of 25 x 25M subplots within the crane circle.
Spatial Sampling Units
  • Andrews Watershed 6
    W -122.18351000, E -122.17755000, N 44.26680800, S 44.26154400
    Altitude: 1029 to 1029 meter
  • Andrews Watershed 7
    W -122.17920900, E -122.17387500, N 44.26974800, S 44.26457900
    Altitude: 1102 to 1102 meter
  • Andrews Watershed 8
    W -122.17079300, E -122.17079300, N 44.26629400, S 44.26588100
    Altitude: 1182 to 1182 meter
  • Andrews Watershed 9
    W -122.25781500, E -122.25151500, N 44.20393300, S 44.20111000
    Altitude: 731 to 731 meter
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: inorganic nutrients (theme), coarse woody debris (theme), organic matter (theme)
  • Andrews Experimental Forest site thesaurus: Long-Term Ecological Research (LTER) (theme)
  • LTER core research areas: inorganic nutrients (theme), organic matter (theme)
Taxonomic Hierarchy
  • All Organisms: All Organisms
  • Highest common category (ca. kingdom): Plantae
  • Species: unknown plant
  • Division or Phylum: Coniferophyta
  • Class: Pinopsida
  • Order: Pinales
  • Family: Cupressaceae
  • Genus: Thuja
  • Species: Thuja plicata
  • Genus: Calocedrus
  • Species: Libocedrus decurrens
  • Family: Pinaceae
  • Genus: Pseudotsuga
  • Species: Pseudotsuga menziesii
  • Genus: Pinus
  • Species: Pinus lambertiana
  • Species: Pinus contorta
  • Species: Pinus jeffreyi
  • Species: Pinus monticola
  • Genus: Picea
  • Species: Picea engelmannii
  • Species: Picea sitchensis
  • Genus: Abies
  • Species: Abies procera
  • Species: Abies concolor
  • Species: Abies amabilis
  • Species: Abies grandis
  • Genus: Tsuga
  • Species: Tsuga heterophylla
  • Order: Taxales
  • Family: Taxaceae
  • Genus: Taxus
  • Species: Taxus brevifolia
  • Division or Phylum: Magnoliophyta
  • Class: Magnoliopsida
  • Subclass: Hamamelididae
  • Order: Fagales
  • Family: Fagaceae
  • Genus: Chrysolepis
  • Species: Castanopsis chrysophylla
  • Subclass: Rosidae
  • Order: Sapindales
  • Family: Aceraceae
  • Genus: Acer
  • Species: Acer circinatum
  • Species: Acer macrophyllum
  • Subclass: Caryophyllidae
  • Order: Caryophyllales
  • Family: Nyctaginaceae
  • Genus: Abronia
  • Species: Abronia latifolia
Data Entities
# Entity Metadata Data
1 TD03501
TD03501
Coarse Woody Debris Line Transect Inventory Data:
METADATA DATA
2 TD03502
TD03502
CWD volume calculations:
METADATA DATA
3 TD03503
TD03503
Wood densities:
METADATA DATA
4 TD03504
TD03504
CWD volume, mass and nutrient stores:
METADATA DATA
5 TD03505
TD03505
Nutrient concentrations in wood:
METADATA DATA
Metadata
TD03501 - TD03501

Object name: TD03501.csv

Records: 3447

Attributes: 19

Temporal coverage: 1997-04-25 to 2003-08-07

File size: 318153 byte

Checksum (MD5): ff2021abe969a4bfafa1cd51f28c6722

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

Constraints (1)
  • notNullConstraint: NOTNULL
    TD03501.DECAY, TD03501.PLOT, TD03501.STAND, TD03501.STUDYID, TD03501.DBCODE, TD03501.SEGMENT, TD03501.SPECIES, TD03501.COVER, TD03501.DIAMAX, TD03501.ENTITY, TD03501.LENGTH, TD03501.MASS, TD03501.YEAR, TD03501.VOLUME, TD03501.SAMPLEDATE
Attributes (19)
DBCODE - char(5) (nominal)

ID: TD03501.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

ENTITY - numeric(1,0) (ratio)

ID: TD03501.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

STUDYID - char(4) (nominal)

ID: TD03501.STUDYID

Individual studyid within overall project

Type system: Microsoft SQL Server 2008

Code definitions (4)
  • HSGY
    Hemlock-Spruce growth and yield
  • RMRS
    Rocky Mountain Reference Stands
  • SQNP
    Sequoia National Park
  • DFGY
    Douglas fir growth and yield
STAND - char(4) (nominal)

ID: TD03501.STAND

Stand name

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • WS06
    Andrews Watershed 6
  • WS07
    Andrews Watershed 7
  • WS08
    Andrews Watershed 8
  • WRE
    Wind River Experimental Forest
  • WS09
    Andrews Watershed 9
PLOT - char(8) (nominal)

ID: TD03501.PLOT

Plot name or number

Type system: Microsoft SQL Server 2008

Code definitions (84)
  • WRE_CC
    Wind River Canopy Crane Hectare
  • WS060104
    Permanent Watershed Plot in Watershed 6, transect 1, plot 04
  • WS060106
    Permanent Watershed Plot in Watershed 6, transect 1, plot 06
  • WS060214
    Permanent Watershed Plot in Watershed 6, transect 2, plot 14
  • WS060318
    Permanent Watershed Plot in Watershed 6, transect 3, plot 18
  • WS060319
    Permanent Watershed Plot in Watershed 6, transect 3, plot 19
  • WS060321
    Permanent Watershed Plot in Watershed 6, transect 3, plot 21
  • WS060323
    Permanent Watershed Plot in Watershed 6, transect 3, plot 23
  • WS060325
    Permanent Watershed Plot in Watershed 6, transect 3, plot 25
  • WS060538
    Permanent Watershed Plot in Watershed 6, transect 5, plot 38
  • WS060539
    Permanent Watershed Plot in Watershed 6, transect 5, plot 39
  • WS060541
    Permanent Watershed Plot in Watershed 6, transect 5, plot 41
  • WS060543
    Permanent Watershed Plot in Watershed 6, transect 5, plot 43
  • WS060545
    Permanent Watershed Plot in Watershed 6, transect 5, plot 45
  • WS060754
    Permanent Watershed Plot in Watershed 6, transect 7, plot 54
  • WS060756
    Permanent Watershed Plot in Watershed 6, transect 7, plot 56
  • WS060758
    Permanent Watershed Plot in Watershed 6, transect 7, plot 58
  • WS060760
    Permanent Watershed Plot in Watershed 6, transect 7, plot 60
  • WS060965
    Permanent Watershed Plot in Watershed 6, transect 9, plot 65
  • WS060966
    Permanent Watershed Plot in Watershed 6, transect 9, plot 66
  • WS060967
    Permanent Watershed Plot in Watershed 6, transect 9, plot 67
  • WS060968
    Permanent Watershed Plot in Watershed 6, transect 9, plot 68
  • WS060969
    Permanent Watershed Plot in Watershed 6, transect 9, plot 69
  • WS070101
    Permanent Watershed Plot in Watershed 7, transect 1, plot 01
  • WS070103
    Permanent Watershed Plot in Watershed 7, transect 1, plot 03
  • WS070214
    Permanent Watershed Plot in Watershed 7, transect 2, plot 14
  • WS070318
    Permanent Watershed Plot in Watershed 7, transect 3, plot 18
  • WS070320
    Permanent Watershed Plot in Watershed 7, transect 3, plot 20
  • WS070322
    Permanent Watershed Plot in Watershed 7, transect 3, plot 22
  • WS070326
    Permanent Watershed Plot in Watershed 7, transect 3, plot 26
  • WS070539
    Permanent Watershed Plot in Watershed 7, transect 5, plot 39
  • WS070541
    Permanent Watershed Plot in Watershed 7, transect 5, plot 41
  • WS070543
    Permanent Watershed Plot in Watershed 7, transect 5, plot 43
  • WS070545
    Permanent Watershed Plot in Watershed 7, transect 5, plot 45
  • WS070547
    Permanent Watershed Plot in Watershed 7, transect 5, plot 47
  • WS070549
    Permanent Watershed Plot in Watershed 7, transect 5, plot 49
  • WS070759
    Permanent Watershed Plot in Watershed 7, transect 7, plot 59
  • WS070761
    Permanent Watershed Plot in Watershed 7, transect 7, plot 61
  • WS070763
    Permanent Watershed Plot in Watershed 7, transect 7, plot 63
  • WS070765
    Permanent Watershed Plot in Watershed 7, transect 7, plot 65
  • WS070866
    Permanent Watershed Plot in Watershed 7, transect 8, plot 66
  • WS070867
    Permanent Watershed Plot in Watershed 7, transect 8, plot 67
  • WS070868
    Permanent Watershed Plot in Watershed 7, transect 8, plot 68
  • WS070869
    Permanent Watershed Plot in Watershed 7, transect 8, plot 69
  • WS070870
    Permanent Watershed Plot in Watershed 7, transect 8, plot 70
  • WS080101
    Permanent Watershed Plot in Watershed 8, transect 1, plot 01
  • WS080202
    Permanent Watershed Plot in Watershed 8, transect 2, plot 02
  • WS080203
    Permanent Watershed Plot in Watershed 8, transect 2, plot 03
  • WS080204
    Permanent Watershed Plot in Watershed 8, transect 2, plot 04
  • WS080205
    Permanent Watershed Plot in Watershed 8, transect 2, plot 05
  • WS080206
    Permanent Watershed Plot in Watershed 8, transect 2, plot 06
  • WS080307
    Permanent Watershed Plot in Watershed 8, transect 3, plot 07
  • WS080308
    Permanent Watershed Plot in Watershed 8, transect 3, plot 08
  • WS080310
    Permanent Watershed Plot in Watershed 8, transect 3, plot 10
  • WS080311
    Permanent Watershed Plot in Watershed 8, transect 3, plot 11
  • WS080312
    Permanent Watershed Plot in Watershed 8, transect 3, plot 12
  • WS080313
    Permanent Watershed Plot in Watershed 8, transect 3, plot 13
  • WS080314
    Permanent Watershed Plot in Watershed 8, transect 3, plot 14
  • WS080415
    Permanent Watershed Plot in Watershed 8, transect 4, plot 15
  • WS080416
    Permanent Watershed Plot in Watershed 8, transect 4, plot 16
  • WS080417
    Permanent Watershed Plot in Watershed 8, transect 4, plot 17
  • WS080418
    Permanent Watershed Plot in Watershed 8, transect 4, plot 18
  • WS080419
    Permanent Watershed Plot in Watershed 8, transect 4, plot 19
  • WS080420
    Permanent Watershed Plot in Watershed 8, transect 4, plot 20
  • WS080421
    Permanent Watershed Plot in Watershed 8, transect 4, plot 21
  • WS080422
    Permanent Watershed Plot in Watershed 8, transect 4, plot 22
  • WS090101
    Permanent Watershed Plot in Watershed 9, transect 1, plot 01
  • WS090102
    Permanent Watershed Plot in Watershed 9, transect 1, plot 02
  • WS090203
    Permanent Watershed Plot in Watershed 9, transect 2, plot 03
  • WS090204
    Permanent Watershed Plot in Watershed 9, transect 2, plot 04
  • WS090205
    Permanent Watershed Plot in Watershed 9, transect 2, plot 05
  • WS090306
    Permanent Watershed Plot in Watershed 9, transect 3, plot 06
  • WS090307
    Permanent Watershed Plot in Watershed 9, transect 3, plot 07
  • WS090308
    Permanent Watershed Plot in Watershed 9, transect 3, plot 08
  • WS090309
    Permanent Watershed Plot in Watershed 9, transect 3, plot 09
  • WS090410
    Permanent Watershed Plot in Watershed 9, transect 4, plot 10
  • WS090411
    Permanent Watershed Plot in Watershed 9, transect 4, plot 11
  • WS090412
    Permanent Watershed Plot in Watershed 9, transect 4, plot 12
  • WS090413
    Permanent Watershed Plot in Watershed 9, transect 4, plot 13
  • WS090514
    Permanent Watershed Plot in Watershed 9, transect 5, plot 14
  • WS090515
    Permanent Watershed Plot in Watershed 9, transect 5, plot 15
  • WS090516
    Permanent Watershed Plot in Watershed 9, transect 5, plot 16
  • WRE_CC2
    Wind River Canopy Crane plot 2 (CC2)
  • WRE_EW
    Wind River Canopy Crane plot EW
YEAR - numeric(4,0) (ratio)

ID: TD03501.YEAR

Year of data collection

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

Numeric domain: type=integer, min=1997.0000 (exclusive=false), max=2003.0000 (exclusive=false)

LENGTH - numeric(4,1) (ratio)

ID: TD03501.LENGTH

Transect length

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.100000

Numeric domain: type=real, min=10.0000 (exclusive=false), max=30.0000 (exclusive=false)

SEGMENT - char(4) (nominal)

ID: TD03501.SEGMENT

Line segment name

Type system: Microsoft SQL Server 2008

QUAD1 - numeric(3,0) (ratio)

ID: TD03501.QUAD1

Quadrant1 - quad number to the left of the transect direction

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

QUAD2 - numeric(3,0) (ratio)

ID: TD03501.QUAD2

Quadrant 2 - quad number to the right of the transect direction

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SPECIES - char(5) (nominal)

ID: TD03501.SPECIES

Species code according to Garrison et al., 1972

Type system: Microsoft SQL Server 2008

Code definitions (21)
  • ABIES
    Abies
  • ABAM
    Abies amabilis
  • ABCO
    Abies concolor
  • ABGR
    Abies grandis
  • ABPR
    Abies procera
  • ABLA
    Abronia latifolia
  • ACCI
    Acer circinatum
  • ACMA
    Acer macrophyllum
  • PIEN
    Picea engelmannii
  • PISI
    Picea sitchensis
  • PICO
    Pinus contorta
  • PIJE
    Pinus jeffreyi
  • PILA
    Pinus lambertiana
  • PIMO
    Pinus monticola
  • PSME
    Pseudotsuga menziesii
  • TABR
    Taxus brevifolia
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • CACH
    Castanopsis chrysophylla
  • LIDE2
    Libocedrus decurrens
  • UNKN
    unknown plant
DECAY - char(1) (nominal)

ID: TD03501.DECAY

Decay class of log or snag

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • 5
    Decay class 5
  • 1
    Decay class 1
  • 3
    Decay class 3
  • 4
    Decay class 4
  • 2
    Decay class 2
DIAMAX - numeric(3,0) (ratio)

ID: TD03501.DIAMAX

Maximum diameter of a CWD piece

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1.000000

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

DIAMIN - numeric(3,0) (ratio)

ID: TD03501.DIAMIN

Minimum diameter of a CWD piece

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1.000000

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

VOLUME - numeric(6,4) (ratio)

ID: TD03501.VOLUME

Individual cwd piece volume contribution: v=9.869*(diam^2/8l) (sum in TD03502) ref: Harmon and Sexton 1996. U.S. LTER publication #20 (pg. 24)

Type system: Microsoft SQL Server 2008

Unit: cubic meters per square meter

Precision: 0.000100

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

MASS - numeric(6,4) (ratio)

ID: TD03501.MASS

Individual CWD piece mass contribution (volume*density)

Type system: Microsoft SQL Server 2008

Unit: megagrams per hectare

Precision: 0.001000

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

COVER - numeric(6,2) (ratio)

ID: TD03501.COVER

Individual cwd piece percent cover contribution (diam/length*100)

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.001000

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

COMMENTS - char(8) (nominal)

ID: TD03501.COMMENTS

Comments

Type system: Microsoft SQL Server 2008

SAMPLEDATE - date (dateTime)

ID: TD03501.SAMPLEDATE

Date of data collection

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TD03502 - TD03502

Object name: TD03502.csv

Records: 700

Attributes: 18

Temporal coverage: 1997-04-25 to 2003-08-07

File size: 66754 byte

Checksum (MD5): 210c07462f4888a521786bb6590a752b

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

Constraints (2)
  • primaryKey: PRIMARY
    TD03502.PLOT, TD03502.STAND, TD03502.SEGMENT, TD03502.YEAR
  • notNullConstraint: NOTNULL
    TD03502.PLOT, TD03502.STAND, TD03502.DBCODE, TD03502.SEGMENT, TD03502.ENTITY, TD03502.LENGTH, TD03502.YEAR, TD03502.NSAMPLES, TD03502.SUMCOVER, TD03502.SUMMASS, TD03502.SUMVOL
Attributes (18)
DBCODE - char(5) (nominal)

ID: TD03502.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

ENTITY - numeric(1,0) (ratio)

ID: TD03502.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

STAND - char(4) (nominal)

ID: TD03502.STAND

Stand name

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • WS06
    Andrews Watershed 6
  • WS07
    Andrews Watershed 7
  • WS08
    Andrews Watershed 8
  • WRE
    Wind River Experimental Forest
  • WS09
    Andrews Watershed 9
PLOT - char(8) (nominal)

ID: TD03502.PLOT

Plot name or number

Type system: Microsoft SQL Server 2008

Code definitions (84)
  • WRE_CC
    Wind River Canopy Crane Hectare
  • WS060104
    Permanent Watershed Plot in Watershed 6, transect 1, plot 04
  • WS060106
    Permanent Watershed Plot in Watershed 6, transect 1, plot 06
  • WS060214
    Permanent Watershed Plot in Watershed 6, transect 2, plot 14
  • WS060318
    Permanent Watershed Plot in Watershed 6, transect 3, plot 18
  • WS060319
    Permanent Watershed Plot in Watershed 6, transect 3, plot 19
  • WS060321
    Permanent Watershed Plot in Watershed 6, transect 3, plot 21
  • WS060323
    Permanent Watershed Plot in Watershed 6, transect 3, plot 23
  • WS060325
    Permanent Watershed Plot in Watershed 6, transect 3, plot 25
  • WS060538
    Permanent Watershed Plot in Watershed 6, transect 5, plot 38
  • WS060539
    Permanent Watershed Plot in Watershed 6, transect 5, plot 39
  • WS060541
    Permanent Watershed Plot in Watershed 6, transect 5, plot 41
  • WS060543
    Permanent Watershed Plot in Watershed 6, transect 5, plot 43
  • WS060545
    Permanent Watershed Plot in Watershed 6, transect 5, plot 45
  • WS060754
    Permanent Watershed Plot in Watershed 6, transect 7, plot 54
  • WS060756
    Permanent Watershed Plot in Watershed 6, transect 7, plot 56
  • WS060758
    Permanent Watershed Plot in Watershed 6, transect 7, plot 58
  • WS060760
    Permanent Watershed Plot in Watershed 6, transect 7, plot 60
  • WS060965
    Permanent Watershed Plot in Watershed 6, transect 9, plot 65
  • WS060966
    Permanent Watershed Plot in Watershed 6, transect 9, plot 66
  • WS060967
    Permanent Watershed Plot in Watershed 6, transect 9, plot 67
  • WS060968
    Permanent Watershed Plot in Watershed 6, transect 9, plot 68
  • WS060969
    Permanent Watershed Plot in Watershed 6, transect 9, plot 69
  • WS070101
    Permanent Watershed Plot in Watershed 7, transect 1, plot 01
  • WS070103
    Permanent Watershed Plot in Watershed 7, transect 1, plot 03
  • WS070214
    Permanent Watershed Plot in Watershed 7, transect 2, plot 14
  • WS070318
    Permanent Watershed Plot in Watershed 7, transect 3, plot 18
  • WS070320
    Permanent Watershed Plot in Watershed 7, transect 3, plot 20
  • WS070322
    Permanent Watershed Plot in Watershed 7, transect 3, plot 22
  • WS070326
    Permanent Watershed Plot in Watershed 7, transect 3, plot 26
  • WS070539
    Permanent Watershed Plot in Watershed 7, transect 5, plot 39
  • WS070541
    Permanent Watershed Plot in Watershed 7, transect 5, plot 41
  • WS070543
    Permanent Watershed Plot in Watershed 7, transect 5, plot 43
  • WS070545
    Permanent Watershed Plot in Watershed 7, transect 5, plot 45
  • WS070547
    Permanent Watershed Plot in Watershed 7, transect 5, plot 47
  • WS070549
    Permanent Watershed Plot in Watershed 7, transect 5, plot 49
  • WS070759
    Permanent Watershed Plot in Watershed 7, transect 7, plot 59
  • WS070761
    Permanent Watershed Plot in Watershed 7, transect 7, plot 61
  • WS070763
    Permanent Watershed Plot in Watershed 7, transect 7, plot 63
  • WS070765
    Permanent Watershed Plot in Watershed 7, transect 7, plot 65
  • WS070866
    Permanent Watershed Plot in Watershed 7, transect 8, plot 66
  • WS070867
    Permanent Watershed Plot in Watershed 7, transect 8, plot 67
  • WS070868
    Permanent Watershed Plot in Watershed 7, transect 8, plot 68
  • WS070869
    Permanent Watershed Plot in Watershed 7, transect 8, plot 69
  • WS070870
    Permanent Watershed Plot in Watershed 7, transect 8, plot 70
  • WS080101
    Permanent Watershed Plot in Watershed 8, transect 1, plot 01
  • WS080202
    Permanent Watershed Plot in Watershed 8, transect 2, plot 02
  • WS080203
    Permanent Watershed Plot in Watershed 8, transect 2, plot 03
  • WS080204
    Permanent Watershed Plot in Watershed 8, transect 2, plot 04
  • WS080205
    Permanent Watershed Plot in Watershed 8, transect 2, plot 05
  • WS080206
    Permanent Watershed Plot in Watershed 8, transect 2, plot 06
  • WS080307
    Permanent Watershed Plot in Watershed 8, transect 3, plot 07
  • WS080308
    Permanent Watershed Plot in Watershed 8, transect 3, plot 08
  • WS080310
    Permanent Watershed Plot in Watershed 8, transect 3, plot 10
  • WS080311
    Permanent Watershed Plot in Watershed 8, transect 3, plot 11
  • WS080312
    Permanent Watershed Plot in Watershed 8, transect 3, plot 12
  • WS080313
    Permanent Watershed Plot in Watershed 8, transect 3, plot 13
  • WS080314
    Permanent Watershed Plot in Watershed 8, transect 3, plot 14
  • WS080415
    Permanent Watershed Plot in Watershed 8, transect 4, plot 15
  • WS080416
    Permanent Watershed Plot in Watershed 8, transect 4, plot 16
  • WS080417
    Permanent Watershed Plot in Watershed 8, transect 4, plot 17
  • WS080418
    Permanent Watershed Plot in Watershed 8, transect 4, plot 18
  • WS080419
    Permanent Watershed Plot in Watershed 8, transect 4, plot 19
  • WS080420
    Permanent Watershed Plot in Watershed 8, transect 4, plot 20
  • WS080421
    Permanent Watershed Plot in Watershed 8, transect 4, plot 21
  • WS080422
    Permanent Watershed Plot in Watershed 8, transect 4, plot 22
  • WS090101
    Permanent Watershed Plot in Watershed 9, transect 1, plot 01
  • WS090102
    Permanent Watershed Plot in Watershed 9, transect 1, plot 02
  • WS090203
    Permanent Watershed Plot in Watershed 9, transect 2, plot 03
  • WS090204
    Permanent Watershed Plot in Watershed 9, transect 2, plot 04
  • WS090205
    Permanent Watershed Plot in Watershed 9, transect 2, plot 05
  • WS090306
    Permanent Watershed Plot in Watershed 9, transect 3, plot 06
  • WS090307
    Permanent Watershed Plot in Watershed 9, transect 3, plot 07
  • WS090308
    Permanent Watershed Plot in Watershed 9, transect 3, plot 08
  • WS090309
    Permanent Watershed Plot in Watershed 9, transect 3, plot 09
  • WS090410
    Permanent Watershed Plot in Watershed 9, transect 4, plot 10
  • WS090411
    Permanent Watershed Plot in Watershed 9, transect 4, plot 11
  • WS090412
    Permanent Watershed Plot in Watershed 9, transect 4, plot 12
  • WS090413
    Permanent Watershed Plot in Watershed 9, transect 4, plot 13
  • WS090514
    Permanent Watershed Plot in Watershed 9, transect 5, plot 14
  • WS090515
    Permanent Watershed Plot in Watershed 9, transect 5, plot 15
  • WS090516
    Permanent Watershed Plot in Watershed 9, transect 5, plot 16
  • WRE_CC2
    Wind River Canopy Crane plot 2 (CC2)
  • WRE_EW
    Wind River Canopy Crane plot EW
YEAR - numeric(4,0) (ratio)

ID: TD03502.YEAR

Year of data collection

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

Numeric domain: type=integer, min=1997.0000 (exclusive=false), max=2003.0000 (exclusive=false)

LENGTH - numeric(4,1) (ratio)

ID: TD03502.LENGTH

Transect length

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.100000

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

SEGMENT - char(4) (nominal)

ID: TD03502.SEGMENT

Line segment name

Type system: Microsoft SQL Server 2008

QUAD1 - numeric(3,0) (ratio)

ID: TD03502.QUAD1

Quadrant1 - quad number to the left of the transect direction

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

QUAD2 - numeric(3,0) (ratio)

ID: TD03502.QUAD2

Quadrant 2 - quad number to the right of the transect direction

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SUMVOL - numeric(6,4) (ratio)

ID: TD03502.SUMVOL

Sum volume of measured cwd pieces from a single transect (m3/m2)

Type system: Microsoft SQL Server 2008

Unit: cubic meters per square meter

Precision: 0.001000

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

STDVOL - numeric(6,4) (ratio)

ID: TD03502.STDVOL

Standard deviation of volume summation

Type system: Microsoft SQL Server 2008

Unit: cubic meters per hectare

Precision: 0.001000

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

SUMMASS - numeric(6,4) (ratio)

ID: TD03502.SUMMASS

Sum mass of cwd pieces from a single transect (megagrams/m3)

Type system: Microsoft SQL Server 2008

Unit: megagrams per cubic meter

Precision: 0.001000

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

STDMASS - numeric(6,4) (ratio)

ID: TD03502.STDMASS

Standard deviation of mass summation

Type system: Microsoft SQL Server 2008

Unit: megagrams per cubic meter

Precision: 0.001000

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

SUMCOVER - numeric(6,2) (ratio)

ID: TD03502.SUMCOVER

Sum percent cover of cwd pieces from a single transect

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

STDCOVER - numeric(6,2) (ratio)

ID: TD03502.STDCOVER

Standard deviation of cover summation

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

NSAMPLES - numeric(3,0) (ratio)

ID: TD03502.NSAMPLES

Number of samples in summation

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

COMMENTS - char(8) (nominal)

ID: TD03502.COMMENTS

Comments

Type system: Microsoft SQL Server 2008

SAMPLEDATE - date (dateTime)

ID: TD03502.SAMPLEDATE

Date of data collection

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TD03503 - TD03503

Object name: TD03503.csv

Records: 65

Attributes: 6

File size: 1806 byte

Checksum (MD5): 54785cd1b81c56c13aa2a62b567e188e

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

Constraints (2)
  • primaryKey: PRIMARY
    TD03503.DECAY, TD03503.STUDYID, TD03503.SPECIES
  • notNullConstraint: NOTNULL
    TD03503.DECAY, TD03503.STUDYID, TD03503.DBCODE, TD03503.SPECIES, TD03503.ENTITY, TD03503.WDENSITY
Attributes (6)
DBCODE - char(5) (nominal)

ID: TD03503.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

ENTITY - numeric(1,0) (ratio)

ID: TD03503.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

STUDYID - char(4) (nominal)

ID: TD03503.STUDYID

Individual studyid within overall project

Type system: Microsoft SQL Server 2008

Code definitions (4)
  • HSGY
    Hemlock-Spruce growth and yield
  • RMRS
    Rocky Mountain Reference Stands
  • SQNP
    Sequoia National Park
  • DFGY
    Douglas fir growth and yield
SPECIES - char(5) (nominal)

ID: TD03503.SPECIES

Species code according to Garrison et al., 1972

Type system: Microsoft SQL Server 2008

Code definitions (21)
  • ABIES
    Abies
  • ABAM
    Abies amabilis
  • ABCO
    Abies concolor
  • ABGR
    Abies grandis
  • ABPR
    Abies procera
  • ABLA
    Abronia latifolia
  • ACCI
    Acer circinatum
  • ACMA
    Acer macrophyllum
  • PIEN
    Picea engelmannii
  • PISI
    Picea sitchensis
  • PICO
    Pinus contorta
  • PIJE
    Pinus jeffreyi
  • PILA
    Pinus lambertiana
  • PIMO
    Pinus monticola
  • PSME
    Pseudotsuga menziesii
  • TABR
    Taxus brevifolia
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • CACH
    Castanopsis chrysophylla
  • LIDE2
    Libocedrus decurrens
  • UNKN
    unknown plant
DECAY - char(1) (nominal)

ID: TD03503.DECAY

Decay class of log or snag

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • 5
    Decay class 5
  • 1
    Decay class 1
  • 3
    Decay class 3
  • 4
    Decay class 4
  • 2
    Decay class 2
WDENSITY - numeric(5,3) (ratio)

ID: TD03503.WDENSITY

Density of wood

Type system: Microsoft SQL Server 2008

Unit: grams per cubic centimeter

Precision: 1.000000

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

TD03504 - TD03504

Object name: TD03504.csv

Records: 469

Attributes: 22

File size: 54678 byte

Checksum (MD5): ffeaad57b60a3615dfb575804cfd0e77

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

Constraints (1)
  • notNullConstraint: NOTNULL
    TD03504.DECAY, TD03504.PLOT, TD03504.STAND, TD03504.DBCODE, TD03504.SPECIES, TD03504.CORRCOVER, TD03504.CORRMASS, TD03504.CORRVOL, TD03504.ENTITY, TD03504.NSAMPLES, TD03504.SLOPE, TD03504.SLPCORR, TD03504.TMASS, TD03504.TPCOVER, TD03504.TVOL
Attributes (22)
DBCODE - char(5) (nominal)

ID: TD03504.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

ENTITY - numeric(1,0) (ratio)

ID: TD03504.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

STAND - char(4) (nominal)

ID: TD03504.STAND

Stand name

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • WS06
    Andrews Watershed 6
  • WS07
    Andrews Watershed 7
  • WS08
    Andrews Watershed 8
  • WRE
    Wind River Experimental Forest
  • WS09
    Andrews Watershed 9
PLOT - char(8) (nominal)

ID: TD03504.PLOT

Plot name or number

Type system: Microsoft SQL Server 2008

Code definitions (84)
  • WRE_CC
    Wind River Canopy Crane Hectare
  • WS060104
    Permanent Watershed Plot in Watershed 6, transect 1, plot 04
  • WS060106
    Permanent Watershed Plot in Watershed 6, transect 1, plot 06
  • WS060214
    Permanent Watershed Plot in Watershed 6, transect 2, plot 14
  • WS060318
    Permanent Watershed Plot in Watershed 6, transect 3, plot 18
  • WS060319
    Permanent Watershed Plot in Watershed 6, transect 3, plot 19
  • WS060321
    Permanent Watershed Plot in Watershed 6, transect 3, plot 21
  • WS060323
    Permanent Watershed Plot in Watershed 6, transect 3, plot 23
  • WS060325
    Permanent Watershed Plot in Watershed 6, transect 3, plot 25
  • WS060538
    Permanent Watershed Plot in Watershed 6, transect 5, plot 38
  • WS060539
    Permanent Watershed Plot in Watershed 6, transect 5, plot 39
  • WS060541
    Permanent Watershed Plot in Watershed 6, transect 5, plot 41
  • WS060543
    Permanent Watershed Plot in Watershed 6, transect 5, plot 43
  • WS060545
    Permanent Watershed Plot in Watershed 6, transect 5, plot 45
  • WS060754
    Permanent Watershed Plot in Watershed 6, transect 7, plot 54
  • WS060756
    Permanent Watershed Plot in Watershed 6, transect 7, plot 56
  • WS060758
    Permanent Watershed Plot in Watershed 6, transect 7, plot 58
  • WS060760
    Permanent Watershed Plot in Watershed 6, transect 7, plot 60
  • WS060965
    Permanent Watershed Plot in Watershed 6, transect 9, plot 65
  • WS060966
    Permanent Watershed Plot in Watershed 6, transect 9, plot 66
  • WS060967
    Permanent Watershed Plot in Watershed 6, transect 9, plot 67
  • WS060968
    Permanent Watershed Plot in Watershed 6, transect 9, plot 68
  • WS060969
    Permanent Watershed Plot in Watershed 6, transect 9, plot 69
  • WS070101
    Permanent Watershed Plot in Watershed 7, transect 1, plot 01
  • WS070103
    Permanent Watershed Plot in Watershed 7, transect 1, plot 03
  • WS070214
    Permanent Watershed Plot in Watershed 7, transect 2, plot 14
  • WS070318
    Permanent Watershed Plot in Watershed 7, transect 3, plot 18
  • WS070320
    Permanent Watershed Plot in Watershed 7, transect 3, plot 20
  • WS070322
    Permanent Watershed Plot in Watershed 7, transect 3, plot 22
  • WS070326
    Permanent Watershed Plot in Watershed 7, transect 3, plot 26
  • WS070539
    Permanent Watershed Plot in Watershed 7, transect 5, plot 39
  • WS070541
    Permanent Watershed Plot in Watershed 7, transect 5, plot 41
  • WS070543
    Permanent Watershed Plot in Watershed 7, transect 5, plot 43
  • WS070545
    Permanent Watershed Plot in Watershed 7, transect 5, plot 45
  • WS070547
    Permanent Watershed Plot in Watershed 7, transect 5, plot 47
  • WS070549
    Permanent Watershed Plot in Watershed 7, transect 5, plot 49
  • WS070759
    Permanent Watershed Plot in Watershed 7, transect 7, plot 59
  • WS070761
    Permanent Watershed Plot in Watershed 7, transect 7, plot 61
  • WS070763
    Permanent Watershed Plot in Watershed 7, transect 7, plot 63
  • WS070765
    Permanent Watershed Plot in Watershed 7, transect 7, plot 65
  • WS070866
    Permanent Watershed Plot in Watershed 7, transect 8, plot 66
  • WS070867
    Permanent Watershed Plot in Watershed 7, transect 8, plot 67
  • WS070868
    Permanent Watershed Plot in Watershed 7, transect 8, plot 68
  • WS070869
    Permanent Watershed Plot in Watershed 7, transect 8, plot 69
  • WS070870
    Permanent Watershed Plot in Watershed 7, transect 8, plot 70
  • WS080101
    Permanent Watershed Plot in Watershed 8, transect 1, plot 01
  • WS080202
    Permanent Watershed Plot in Watershed 8, transect 2, plot 02
  • WS080203
    Permanent Watershed Plot in Watershed 8, transect 2, plot 03
  • WS080204
    Permanent Watershed Plot in Watershed 8, transect 2, plot 04
  • WS080205
    Permanent Watershed Plot in Watershed 8, transect 2, plot 05
  • WS080206
    Permanent Watershed Plot in Watershed 8, transect 2, plot 06
  • WS080307
    Permanent Watershed Plot in Watershed 8, transect 3, plot 07
  • WS080308
    Permanent Watershed Plot in Watershed 8, transect 3, plot 08
  • WS080310
    Permanent Watershed Plot in Watershed 8, transect 3, plot 10
  • WS080311
    Permanent Watershed Plot in Watershed 8, transect 3, plot 11
  • WS080312
    Permanent Watershed Plot in Watershed 8, transect 3, plot 12
  • WS080313
    Permanent Watershed Plot in Watershed 8, transect 3, plot 13
  • WS080314
    Permanent Watershed Plot in Watershed 8, transect 3, plot 14
  • WS080415
    Permanent Watershed Plot in Watershed 8, transect 4, plot 15
  • WS080416
    Permanent Watershed Plot in Watershed 8, transect 4, plot 16
  • WS080417
    Permanent Watershed Plot in Watershed 8, transect 4, plot 17
  • WS080418
    Permanent Watershed Plot in Watershed 8, transect 4, plot 18
  • WS080419
    Permanent Watershed Plot in Watershed 8, transect 4, plot 19
  • WS080420
    Permanent Watershed Plot in Watershed 8, transect 4, plot 20
  • WS080421
    Permanent Watershed Plot in Watershed 8, transect 4, plot 21
  • WS080422
    Permanent Watershed Plot in Watershed 8, transect 4, plot 22
  • WS090101
    Permanent Watershed Plot in Watershed 9, transect 1, plot 01
  • WS090102
    Permanent Watershed Plot in Watershed 9, transect 1, plot 02
  • WS090203
    Permanent Watershed Plot in Watershed 9, transect 2, plot 03
  • WS090204
    Permanent Watershed Plot in Watershed 9, transect 2, plot 04
  • WS090205
    Permanent Watershed Plot in Watershed 9, transect 2, plot 05
  • WS090306
    Permanent Watershed Plot in Watershed 9, transect 3, plot 06
  • WS090307
    Permanent Watershed Plot in Watershed 9, transect 3, plot 07
  • WS090308
    Permanent Watershed Plot in Watershed 9, transect 3, plot 08
  • WS090309
    Permanent Watershed Plot in Watershed 9, transect 3, plot 09
  • WS090410
    Permanent Watershed Plot in Watershed 9, transect 4, plot 10
  • WS090411
    Permanent Watershed Plot in Watershed 9, transect 4, plot 11
  • WS090412
    Permanent Watershed Plot in Watershed 9, transect 4, plot 12
  • WS090413
    Permanent Watershed Plot in Watershed 9, transect 4, plot 13
  • WS090514
    Permanent Watershed Plot in Watershed 9, transect 5, plot 14
  • WS090515
    Permanent Watershed Plot in Watershed 9, transect 5, plot 15
  • WS090516
    Permanent Watershed Plot in Watershed 9, transect 5, plot 16
  • WRE_CC2
    Wind River Canopy Crane plot 2 (CC2)
  • WRE_EW
    Wind River Canopy Crane plot EW
SPECIES - char(5) (nominal)

ID: TD03504.SPECIES

Species code according to Garrison et al., 1972

Type system: Microsoft SQL Server 2008

Code definitions (21)
  • ABIES
    Abies
  • ABAM
    Abies amabilis
  • ABCO
    Abies concolor
  • ABGR
    Abies grandis
  • ABPR
    Abies procera
  • ABLA
    Abronia latifolia
  • ACCI
    Acer circinatum
  • ACMA
    Acer macrophyllum
  • PIEN
    Picea engelmannii
  • PISI
    Picea sitchensis
  • PICO
    Pinus contorta
  • PIJE
    Pinus jeffreyi
  • PILA
    Pinus lambertiana
  • PIMO
    Pinus monticola
  • PSME
    Pseudotsuga menziesii
  • TABR
    Taxus brevifolia
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • CACH
    Castanopsis chrysophylla
  • LIDE2
    Libocedrus decurrens
  • UNKN
    unknown plant
DECAY - char(1) (nominal)

ID: TD03504.DECAY

Decay class of log or snag

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • 5
    Decay class 5
  • 1
    Decay class 1
  • 3
    Decay class 3
  • 4
    Decay class 4
  • 2
    Decay class 2
NSAMPLES - numeric(3,0) (ratio)

ID: TD03504.NSAMPLES

Number of samples in summation

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SLOPE - numeric(3,0) (ratio)

ID: TD03504.SLOPE

Slope of plot

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1.000000

Numeric domain: type=integer, min=0.0000 (exclusive=false), max=60.0000 (exclusive=false)

SLPCORR - numeric(6,4) (ratio)

ID: TD03504.SLPCORR

Applied slope correction

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

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

TVOL - numeric(8,3) (ratio)

ID: TD03504.TVOL

Total volume of logs

Type system: Microsoft SQL Server 2008

Unit: cubic meters per hectare

Precision: 0.001000

Numeric domain: type=real, min=1.2300 (exclusive=false), max=423.5000 (exclusive=false)

TMASS - numeric(8,3) (ratio)

ID: TD03504.TMASS

Total mass of logs

Type system: Microsoft SQL Server 2008

Unit: megagrams per hectare

Precision: 0.100000

Numeric domain: type=real, min=0.1700 (exclusive=false), max=132.1200 (exclusive=false)

TPCOVER - numeric(6,2) (ratio)

ID: TD03504.TPCOVER

Total percent cover of logs

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

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

CORRVOL - numeric(8,3) (ratio)

ID: TD03504.CORRVOL

Total volume of logs corrected for slope

Type system: Microsoft SQL Server 2008

Unit: cubic meters per hectare

Precision: 0.100000

Numeric domain: type=real, min=1.2360 (exclusive=false), max=437.2370 (exclusive=false)

CORRMASS - numeric(8,3) (ratio)

ID: TD03504.CORRMASS

Total mass of logs corrected for slope

Type system: Microsoft SQL Server 2008

Unit: megagrams per hectare

Precision: 0.100000

Numeric domain: type=real, min=0.1750 (exclusive=false), max=141.3380 (exclusive=false)

CORRCOVER - numeric(6,2) (ratio)

ID: TD03504.CORRCOVER

Total percent cover of logs corrected for slope

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

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

N - numeric(8,3) (ratio)

ID: TD03504.N

Nitrogen stored (kg/ha)

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.100000

Numeric domain: type=real, min=0.2170 (exclusive=false), max=143.7750 (exclusive=false)

P - numeric(8,3) (ratio)

ID: TD03504.P

Phosphorous stored (kg/ha)

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.100000

Numeric domain: type=real, min=0.0110 (exclusive=false), max=14.4190 (exclusive=false)

K - numeric(8,3) (ratio)

ID: TD03504.K

Potassium stored (kg/ha)

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.100000

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

CA - numeric(8,3) (ratio)

ID: TD03504.CA

Calcium stored (kg/ha)

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.100000

Numeric domain: type=real, min=0.2980 (exclusive=false), max=761.6800 (exclusive=false)

MG - numeric(8,3) (ratio)

ID: TD03504.MG

Magnesium stored (kg/ha)

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.100000

Numeric domain: type=real, min=0.0350 (exclusive=false), max=33.4650 (exclusive=false)

MN - numeric(8,3) (ratio)

ID: TD03504.MN

Manganese stored (kg/ha)

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.100000

Numeric domain: type=real, min=0.0090 (exclusive=false), max=15.6320 (exclusive=false)

NA - numeric(8,3) (ratio)

ID: TD03504.NA

Sodium stored (kg/ha)

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.100000

Numeric domain: type=real, min=0.0090 (exclusive=false), max=4.2400 (exclusive=false)

TD03505 - TD03505

Object name: TD03505.csv

Records: 71

Attributes: 13

File size: 3996 byte

Checksum (MD5): 8f2842b0b477750930433724b89d6cd4

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

Constraints (1)
  • notNullConstraint: NOTNULL
    TD03505.DECAY, TD03505.STUDYID, TD03505.DBCODE, TD03505.SPECIES, TD03505.ENTITY, TD03505.WOOD_MG, TD03505.WOOD_N, TD03505.WOOD_P
Attributes (13)
DBCODE - char(5) (nominal)

ID: TD03505.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

ENTITY - numeric(1,0) (ratio)

ID: TD03505.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

STUDYID - char(4) (nominal)

ID: TD03505.STUDYID

Individual studyid within overall project

Type system: Microsoft SQL Server 2008

Code definitions (4)
  • HSGY
    Hemlock-Spruce growth and yield
  • RMRS
    Rocky Mountain Reference Stands
  • SQNP
    Sequoia National Park
  • DFGY
    Douglas fir growth and yield
SPECIES - char(5) (nominal)

ID: TD03505.SPECIES

Species code according to Garrison et al., 1972

Type system: Microsoft SQL Server 2008

Code definitions (21)
  • ABIES
    Abies
  • ABAM
    Abies amabilis
  • ABCO
    Abies concolor
  • ABGR
    Abies grandis
  • ABPR
    Abies procera
  • ABLA
    Abronia latifolia
  • ACCI
    Acer circinatum
  • ACMA
    Acer macrophyllum
  • PIEN
    Picea engelmannii
  • PISI
    Picea sitchensis
  • PICO
    Pinus contorta
  • PIJE
    Pinus jeffreyi
  • PILA
    Pinus lambertiana
  • PIMO
    Pinus monticola
  • PSME
    Pseudotsuga menziesii
  • TABR
    Taxus brevifolia
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • CACH
    Castanopsis chrysophylla
  • LIDE2
    Libocedrus decurrens
  • UNKN
    unknown plant
DECAY - char(1) (nominal)

ID: TD03505.DECAY

Decay class of log or snag

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • 5
    Decay class 5
  • 1
    Decay class 1
  • 3
    Decay class 3
  • 4
    Decay class 4
  • 2
    Decay class 2
WOOD_N - numeric(7,0) (ratio)

ID: TD03505.WOOD_N

Nitrogen content in wood in parts per million (see TD012 Entity 2 sources)

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 1.000000

Numeric domain: type=integer, min=230.0000 (exclusive=false), max=6960.0000 (exclusive=false)

WOOD_P - numeric(7,0) (ratio)

ID: TD03505.WOOD_P

Phosphorus in wood in parts per million

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 1.000000

Numeric domain: type=integer, min=15.0000 (exclusive=false), max=460.0000 (exclusive=false)

WOOD_K - numeric(7,0) (ratio)

ID: TD03505.WOOD_K

Potassium in wood in parts per million

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 1.000000

Numeric domain: type=integer, min=90.0000 (exclusive=false), max=26180.0000 (exclusive=false)

WOOD_CA - numeric(7,0) (ratio)

ID: TD03505.WOOD_CA

Calcium in wood in parts per million

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 1.000000

Numeric domain: type=integer, min=625.0000 (exclusive=false), max=47580.0000 (exclusive=false)

WOOD_MG - numeric(7,2) (ratio)

ID: TD03505.WOOD_MG

Magnesium in wood in parts per million

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 0.010000

Numeric domain: type=real, min=70.0000 (exclusive=false), max=2040.0000 (exclusive=false)

WOOD_MN - numeric(7,2) (ratio)

ID: TD03505.WOOD_MN

Manganese in wood in parts per million

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 0.010000

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

WOOD_NA - numeric(7,2) (ratio)

ID: TD03505.WOOD_NA

Sodium in wood in parts per million

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 0.010000

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

WOOD_S - numeric(7,2) (ratio)

ID: TD03505.WOOD_S

Sulfur in wood in patrs per million

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 0.010000

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

Units
centimeters cm length centimeter meter 0.01 centimeters; .01 meters
meters m length meter meter 1 meter; SI unit of length
year (yyyy) YYYY datetime YYYY YYYY-MM-DDThh:mm:ss N/A year (4 character) portion of date
megagrams per cubic meter megag/m3 massDensity megagramPerMeterCubed kilogramPerMeterCubed 0.001 megagrams per cubic meter
cubic meters per square meter m3/m2 volumetricArea meterCubedPerMeterSquared meterCubedPerMeterSquared 1 cubic meters per square meter
grams per cubic centimeter g/cm3 massDensity gramPerCentimeterCubed kilogramPerMeterCubed 1000 grams per cubic centimeter
kilograms per hectare kg/ha arealMassDensity kilogramPerHectare kilogramPerMeterSquared 0.0001 kilograms per hectare
megagrams per hectare megag/ha arealMassDensity megagramPerHectare kilogramPerMeterSquared 0.1 megagrams per hectare
cubic meters per hectare m3/ha volumetricArea meterCubedPerHectare meterCubedPerMeterSquared 0.0001 cubic meters per hectare
parts per million ppm massDensity partsPerMillion kilogramPerMeterCubed 0.001 parts per million
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: 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 (2002-01-01)
    Original metadata creation.
  • Version2 (2002-02-06)
    Metadata restructured and moved into SQLServer metadata database LTERMETA. Data moved into SQLServer database FSDBDATA.
  • Version3 (2005-05-26)
    Updated database with with most recent data (2003)
  • Version8 (2011-09-19)
    Updated entity 4 (deleted attribute 'S'; all values null) for successful metacat harvest.
  • Version9 (2015-12-14)
    Reworked data for upload to PASTA. Created sampledate from year,month,day. Changed entities to dbcode and entity. Created plotid's for plot from place_keyword_id. Ran QC and reset limits. Recreated SQL structure and uploaded data.