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

TD022: Coarse woody debris density and nutrient data across western USA, including HJ Andrews Experimental Forest, North Carolina, USA, Mexico and Russia 1982-2001

← Back to catalog index

Status: irregular
Period: 1982-09-01 to 2001-06-11
Version: 7
Published: 2018-09-20
EDI Package ID: knb-lter-and.4546.7
Source XML: TD022_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

Harmon, M. 2018. Coarse woody debris density and nutrient data across western USA, including HJ Andrews Experimental Forest, North Carolina, USA, Mexico and Russia 1982-2001 Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/TD022 Accessed 2026-05-10.

Abstract

This data set is used to document the changes in external characteristics, density, nutrient content, and form of carbon associated with various decay classes and ages of logs and snags. The pieces that have been dated form the basis for a chronosequence. All the pieces sampled are used to define the characteristics of decay classes. These classes are used in turn to convert the external dimension data in TD012 to estimates of mass and nutrient stores.

Coverage

Temporal coverage: 1982-09-01 to 2001-06-11

Geographic coverage: HJ Andrews Experimental Forest, Sequoia National Park , Fraser Experimental Forest, Puerto Morelos, Quintana Roo, Mexico, Cascade Head Experimental Forest, Pringle Falls Experimental Forest, Los Tuxtlas Experimental forest, North Carolina.

Spatial coverage:

Bounds: W -123.99172780, E 35.77831690, N 59.41969500, S 19.13141400

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
  • 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
  • Becky Fasth
    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
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 data set is used to document the changes in external characteristics, density, nutrient content, and form of carbon associated with various decay classes and ages of logs and snags. The pieces that have been dated form the basis for a chronosequence. All the pieces sampled are used to define the characteristics of decay classes. These classes are used in turn to convert the external dimension data in TD012 to estimates of mass and nutrient stores. Field Methods - TD022

Methods

Method Steps

Field Methods - TD022
  • Once logs had been selected for sampling, they were marked with an aluminum tag and their location was plotted on a rough sketch map. This allowed us to resample many of these logs and apply the decomposition vector method to narrow uncertainties about decomposition rates.
  • Dates of tree death or cutting were taken from fall scars and or living stumps (Harmon et al. 1986). In the case of logs added by harvest or thinning, we corroborated these dates by aging living stumps within the unit sampled. Fall scars and the upper portions of living stumps were removed with a chainsaw and air-dried. These cut surfaces were then sanded with fine grit sandpaper and examined under a binocular microscope at 10-X magnification. Rings formed after the scars were counted twice and if the counts differed were counted a third time.
  • For each log sampled we noted key characteristics that could be used to define a decay class system. Physical characteristics recorded included: the presence of leaves, twigs, branches, bark cover on branches and boles, sloughing of wood, collapsing and spreading of the log (indicating the transition from round to elliptic form), degree of soil contact, friability or crushability of wood, color of wood, and if the branch stubs could be moved (Harmon et al 1987). Biological indicators such as moss cover, fungal fruiting bodies, or presence of insect galleries were also noted although past experience shows they are too variable at a local scale to be useful in separating decay classes (Harmon et al 1989).
  • To determine rates of decomposition we determined the remaining mass of each log. Current mass remaining was determined from the current density and volume of the log. The current volume was determined by measuring the length and diameter systematically along the bole from the base to the top as well as the locations where cross-sections were removed. For each log segment defined by the end diameters or the cross-sections, we calculated the volume as a frustum of a cone (Harmon et al 1989).
  • The current density of the wood and bark was determined by removing cross-sections along the length of each log. For sound trees we removed 3 to 4 cross-sections. In the case of extremely decomposed or very short logs, only 2 cross-sections were removed. For each cross-section the diameter, mean longitudinal thickness, circumference covered by bark, radial thickness of bark and mean radial depth of decay were recorded. Diameters were usually measured using a diameter tape, however, in the case of extremely old logs the cross-sections were too decomposed to be measured with this method. We therefore excavated very decayed cross-sections and used a ruler to measure the long and short axes of the cross-section from the remaining portions of the log. The total mass of the bark and wood for each cross-section was weighed on a portable electronic scale with a range of 1 to 6000 g (Ohaus Model CT6000), and then 50-200 g subsamples were removed to determine the moisture content. When cross-sections had a range of decay or moisture conditions, we took samples from the different areas in rough proportion to the area in each condition. These samples were weighed and then dried in an oven at 55 C until their mass was stable (usually 7 to 14 days). Total dry weight was calculated as the fraction of dry material in the subsamples multiplied by the total wet weight. The volume of the bark or wood was determined from the dimensional data recorded. Current density of bark or wood was calculated as the dry weight divided by the volume of the cross-section. The overall cross-sectional density was calculated similarly, but using the total dry weight and volume. The weighted mean density for each log was calculated. The densities from each cross-section in a log were weighted by their cross-sectional area, so that the smaller, upper cross-sections contributed less to the log average than the larger, lower cross-sections.
Method Step 2

No method step description paragraphs listed.

Sampling

Study Extent
  • Sites in Rocky Mountains, Pacific Northwest, Mexico; specifically Sequoia National Park, Fraser Experimental National Park, Puerto Morelos, Quintana Roo, Mexico. http://andrewsforest.oregonstate.edu/pubs/webdocs/reports/decomp/study_areas.htm
  • Sampling frequency: annually
Sampling Description
  • The chronosequence approach was used to determine decomposition rates from logs in which the sampling occurred only once. In a chronosequence one ages many pieces in various states of decay and examines how a parameter such as density changes through time. This is a substitution of space for time, and while not as precise as a time series experiment (where individual pieces are followed through time) it provides a good first approximation of decomposition rates (Harmon et al. 1998).
  • For logs sampled using the chronosequence and/or decomposition vector methods individual logs were selected to represent as many ages or decay stages as possible. For decay classes we sought to have at least 3 replicates of each decay class. For chronosequences we also sought to have at least 3 replicates of each decay class, although to represent as even a distribution in ages as possible, some decay classes had more replicates. Logs were created from a range of processes, although for chronosequences we avoided the use of logs generated from snag fall. In the case of logs left as a result of harvest or thinning, we examined the state of decay to make sure it roughly corresponded to the time left on the ground. Pieces that were either too decayed or too sound were not used as they might have been added at a time other than the activity date noted in the records. Trees adjacent to logs that resulted from natural mortality were examined for the presence of scars that may have been created when the log fell. In the case of logs in very advanced stages of decomposition it was often impossible to find a tree fall scar or any other means to date the time of death. Priority was given to very decayed logs with the possibility of dating the time of death, however, some logs were selected without dates. To estimate the initial density of dead trees, we sampled a limited number of freshly killed, standing dead trees. For the most part these trees still had needles attached and it was likely that they died in the past year.
  • Citation:
  • Please see methods in: http://andrewsforest.oregonstate.edu/pubs/webdocs/reports/decomp/cwd_decomp_web.htm
  • Harmon, Mark E.; Krankina, Olga N.; Sexton, Jay. 2000. Decomposition vectors: a new approach to estimating woody detritus decomposition dynamics. Canadian Journal of Forest Research. 30: 76-84.
Spatial Sampling Units
  • Andrews Experimental Forest (HJA)
    W -122.26172200, E -122.10084700, N 44.28196400, S 44.19770400
    Altitude: 1631 to 1631 meter
  • Cascade Head Experimental Forest
    W -123.99172777, E -123.89730000, N 45.06476948, S 45.03130000
  • Pringle Falls Experimental Forest
    W -121.61548044, E -121.60590486, N 43.70822744, S 43.70581376
  • Sequoia National Park Reference Stands
    W -118.80000000, E -118.73000000, N 36.60000000, S 36.57000000
    Altitude: 2440 to 2440 meter
  • Cascade Head Experimental Forest OR (TD027)
    W -123.99172777, E -123.89730000, N 45.06476948, S 45.03130000
  • North Carolina Botanical Garden, Chapel Hill, NC
    W -79.04317500, E -79.03100800, N 35.90545500, S 35.89715000
  • Pringle Falls Experimental Forest Oregon
    W -121.61548044, E -121.60590486, N 43.70822744, S 43.70581376
  • Los Tuxtlas Experimental Forest, UNAM, Veracruz, Mexico
    W -96.23330800, E -96.12344500, N 19.22642400, S 19.13141400
  • Andrews Forest and vicinity Reference Stands
    W -122.25882600, E -122.11525700, N 44.27566300, S 44.20057900
    Altitude: 1305 to 1305 meter
  • Ponderosa Pine Growth and Yield Study
    W -122.70500000, E -121.60300000, N 44.48800000, S 42.15200000
    Altitude: 1400 to 1400 meter
  • Novgorod, Russia
    W 30.67385280, E 35.77831690, N 59.41969500, S 56.92374000
  • H.J. Andrews Log decomp site 2
    W -122.18823490, E -122.18823490, N 44.25593256, S 44.25593256
    Altitude: 858 to 858 meter
  • H.J. Andrews Log decomp site 4
    W -122.16847050, E -122.16847050, N 44.23341661, S 44.23341661
    Altitude: 748 to 748 meter
  • Reference Stand PF27, Pringle Falls RNA, Deschutes NF
    W -121.61135773, E -121.61135773, N 43.70697926, S 43.70697926
  • Reference Stand PF28, Pringle Falls RNA, Deschutes NF
    W -121.60590486, E -121.60590486, N 43.70822744, S 43.70822744
  • Reference Stand FRC3, Fraser EF, CO, lodgepole pine
    W -105.85903000, E -105.85903000, N 39.90398200, S 39.90398200
  • Reference Stand FRD1, Fraser EF, CO, spruce-fir
    W -105.86349500, E -105.86349500, N 39.89871600, S 39.89871600
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: decay rates (theme), decomposition (theme), inorganic nutrients (theme), nutrients (theme), coarse woody debris (theme), organic matter (theme), logs (theme)
  • LTER core research areas: inorganic nutrients (theme), organic matter (theme)
Taxonomic Hierarchy
  • All Organisms: All Organisms
  • Family: Non-taxonomic objects (vegetative, organic, or inorganic)
  • Species: unknown plant
  • Species: unknown plant 1
  • Species: unknown
  • Highest common category (ca. kingdom): Plantae
  • Division or Phylum: Magnoliophyta
  • Class: Liliopsida
  • Subclass: Asteridae
  • Order: Lamiales
  • Family: Bignoniaceae
  • Genus: Tabebuia
  • Species: Tabebuia rosea
  • Subclass: Liliidae
  • Order: Liliales
  • Species: Beaucarnea pliabilis
  • Class: Magnoliopsida
  • Subclass: Magnoliidae
  • Order: Nymphaeales
  • Family: Bombacaceae
  • Species: Ceiba aesculifolia
  • Subclass: Rosidae
  • Order: Rhamnales
  • Family: Rhamnaceae
  • Genus: Krugiodendron
  • Species: Krugiodendron ferreum
  • Order: Sapindales
  • Species: Talisia olivaeformis
  • Species: Bursera simaruba
  • Family: Sapindaceae
  • Genus: Sapindus
  • Species: Sapindus saponaria
  • Order: Myrtales
  • Species: Myrcianthes fragrans
  • Subclass: Hamamelididae
  • Order: Urticales
  • Family: Moraceae
  • Species: Brosimum alicastrum
  • Species: Manilkara zapota
  • Division or Phylum: Coniferophyta
  • Class: Pinopsida
  • Order: Pinales
  • Family: Pinaceae
  • Genus: Pseudotsuga
  • Species: Pseudotsuga menziesii
  • Genus: Pinus
  • Species: Pinus lambertiana
  • Species: Pinus contorta
  • Species: Pinus jeffreyi
  • Species: Pinus ponderosa
  • Genus: Abies
  • Species: Abies magnifica
  • Species: Abies concolor
  • Species: Abies lasiocarpa
  • Genus: Picea
  • Species: Picea engelmannii
  • Family: Cupressaceae
  • Genus: Calocedrus
  • Species: Calocedrus decurrens
Data Entities
# Entity Metadata Data
1 TD02201
TD02201
Log and Snag Descriptions:
METADATA DATA
2 TD02202
TD02202
Current Tissue Radial Thickness and Volume:
METADATA DATA
3 TD02203
TD02203
Tissue Density:
METADATA DATA
4 TD02204
TD02204
Tissue Nutrient Content:
METADATA DATA
5 TD02206
TD02206
Depth Of Decay:
METADATA DATA
6 TD02207
TD02207
Initial Tissue Radial Thickness and Volume:
METADATA DATA
7 TD02208
TD02208
Log Characteristics:
METADATA DATA
Metadata
TD02201 - TD02201

Object name: TD02201.csv

Records: 342

Attributes: 32

Temporal coverage: 1982-09-01 to 1994-06-24

File size: 36928 byte

Checksum (MD5): d987f7a336ef2b48d16d1a293c355484

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

Constraints (2)
  • primaryKey: PRIMARY
    TD02201.STUDYID, TD02201.NUMBER, TD02201.PLOT, TD02201.YEAR, TD02201.STAND
  • notNullConstraint: NOTNULL
    TD02201.CAUSE, TD02201.POSITION, TD02201.STUDYID, TD02201.DBCODE, TD02201.NUMBER, TD02201.PLOT, TD02201.ENTITY, TD02201.YEAR, TD02201.STAND, TD02201.SPECIES, TD02201.SAMPLEDATE
Attributes (32)
DBCODE - char(5) (nominal)

ID: TD02201.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • TD022
    FSDB Database Code TD022 (terrestrial decomposition)
ENTITY - numeric(2,0) (interval)

ID: TD02201.ENTITY

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)

STUDYID - char(4) (nominal)

ID: TD02201.STUDYID

Study Id, matches those in TD12 and TV010 whenever possible

Type system: Microsoft SQL Server 2008

Code definitions (16)
  • EUS
    Eastern United States
  • INTM
    Intermountain United States
  • IRIR
    Russia; 1-st pair of letters describes the forest inventory enterprise, Ir=Irkutsk; 2-nd Pair Of Letters Describes The Region-"oblast'", Ir=Irkutsk
  • KHKH
    KH=Kabarovsk inventory enterprise; kH=Khabarovs region-"oblast"; russia
  • KRKR
    KR=Krasnoyarsk inventory enterprise; KR=Krasnoyarsk region-"oblast"; russia
  • MEX
    Mexico
  • MOSK
    Moscow region, Russia
  • NNOV
    Nizhnii novgorod; Russia
  • NSNS
    NS=NNvosibirsk inventory enterprise; NS=Novosibirsk region-"oblast"; Russia
  • NSTM
    NS=Novosibirsk inventory enterprise; TM=Tiumenskaya "oblast"-region; Russia
  • PNW
    Pacific Northwest, United States
  • PSW
    Pacific Southwest, United States
  • STAR
    EPA star project headed by Dr. Beverly Law
  • STPB
    St.-Petersburg; Russia
  • WINE
    Winema National Forest
  • WRE
    Wind River Xxperimental Forest
STAND - char(4) (nominal)

ID: TD02201.STAND

Code for stand

Type system: Microsoft SQL Server 2008

Code definitions (47)
  • ME
    Metolius RNA
  • RSF
    Rancho San Felipe, Puerto Morelos, Quintana Roo
  • THUN
    WIND RIVER R.D. CUT UNIT, THUN
  • BONE
    WIND RIVER R.D. CUT UNIT, BONE
  • TCH1
    WIND RIVER R.D. CUT UNIT, TCH1
  • VIM2
    WIND RIVER R.D. CUT UNIT, VIM2
  • SEC4
    WIND RIVER R.D. CUT UNIT, SEC4
  • COUG
    WIND RIVER R.D. CUT UNIT, COUG
  • PCR2
    WIND RIVER R.D. CUT UNIT, PLCR
  • TCH2
    WIND RIVER R.D. CUT UNIT, TCH2
  • SOSF
    WIND RIVER R.D. CUT UNIT, SOSF
  • CHEF
    Cascade Head Experimental Forest OR (TD027)
  • NCB
    North Carolina Botanical Garden, Chapel Hill, NC
  • PFEF
    Pringle Falls Experimental Forest Oregon
  • TUX
    Los Tuxtlas Experimental Forest, UNAM, Veracruz, Mexico
  • YUC
    Noh Bec, Quintana Roo, Mexico
  • OHJA
    Andrews Forest and vicinity Reference Stands
  • PPGY
    Ponderosa Pine Growth and Yield Study
  • RMRS
    Rocky Mountain Reference Stands
  • SQNP
    Sequoia National Park Reference Stands
  • BABA
    BA=Bayandaiskii lekhoz (forest management enterprise); BA=Bayandaevskoe Lesnichestvo (ranger station
  • NZUD
    Nizhneudinsk, Russia
  • OLKO
    OL=Ol'khonskii leskhoz; KO=Kosostepskoe lesnichestvo
  • STIL
    ST=Shestakovskii leskhoz (forest management entermprise); IL=Ilimskoe Lesnichestvo (ranger station)
  • BTKL
    BT=Bystrinskii leskhoz (fme); KL=Kliuchevskoe lesnichestvo (ranger station)
  • KHKF
    KH=Khorskii leskhoz; KF=Kafenskoe lesnichestvo
  • KHKT
    KH=Khorskii leskhoz; KT=Katenskoe lesnichestvo
  • KHLA
    Kh=khorskii leskhoz; LA=Lazovskoe lesnichestvo
  • KHLZ
    Khabarovskii leskhoz (forest management enterprise), Russia
  • ULBR
    UL=Ul'chskii leskhoz; BR=Bogorodskoe lesnichestvo
  • BGKB
    BG=Boguchanskii leskhoz (fme); karabul'skoe lesnichestvo (ranger station)
  • CHCH
    CH=Chunskii leskhoz (forest management enterprise); CH=Chunoyarskoe Lesnichestvo (ranger station)
  • CHKH
    CH=Chunskii leskhoz (fme); khozhenskoe lesnichestvo (ranger station)
  • CHTA
    CH=Chunskii leskhoz (fme); takuchetskoe lesnichestvo (ranger station)
  • EMKE
    EM=Emel'yanovskii leskhoz (fme); ke=kemchugskoe lesnichestvo
  • POPO
    PO=Podol'skii leskhoz; podol'skoe lesnichestvo
  • PZMA
    Pizhma village, Russia
  • BERD
    Berdskii leskhoz (forest management enterprise)
  • MIMI
    MI=Mirnovskii leskhoz; MI=Mirnovskoe lesnichestvo
  • NSIB
    Novosibirsk, Russia
  • BEKZ
    BE=Beloyarskii leskhoz (forest management enterprise); KZ= Kazymskoe Lesnichestvo (ranger station)
  • KART
    Kartashevka, Russia
  • KOBN
    Korbona, Russia
  • LYSI
    Lysino, Russia
  • NOVG
    Novgorod, Russia
  • VRZA
    Viritza, Russia
  • KRD
    Kalamath r.d., Winema National Forest
PLOT - char(10) (nominal)

ID: TD02201.PLOT

Arbitrary site number associated with cwd piece.

Type system: Microsoft SQL Server 2008

YEAR - numeric(4,0) (ratio)

ID: TD02201.YEAR

Year the sample collection took place

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

NUMBER - char(5) (nominal)

ID: TD02201.NUMBER

Identifying code/number of CWD piece

Type system: Microsoft SQL Server 2008

SPECIES - char(4) (nominal)

ID: TD02201.SPECIES

Code for speciesof the log, snag or stump

Type system: Microsoft SQL Server 2008

Code definitions (21)
  • ABCO
    Abies concolor
  • ABLA
    Abies lasiocarpa
  • ABMA
    Abies magnifica
  • CADE
    Calocedrus decurrens
  • KRFE
    Krugiodendron ferreum
  • PIEN
    Picea engelmannii
  • PICO
    Pinus contorta
  • PIJE
    Pinus jeffreyi
  • PILA
    Pinus lambertiana
  • PIPO
    Pinus ponderosa
  • PSME
    Pseudotsuga menziesii
  • SASA
    Sapindus saponaria
  • TARO
    Tabebuia rosea
  • BRAL
    Brosimum alicastrum
  • BUSI
    Bursera simaruba
  • MYFR
    Myrcianthes fragrans
  • CEAE
    Ceiba aesculifolia
  • MAZA
    Manilkara zapota
  • TAOL
    Talisia olivaeformis
  • BEPL
    Beaucarnea pliabilis
  • UNKN
    unknown
POSITION - char(1) (nominal)

ID: TD02201.POSITION

Position of the log, snag, or stump.

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • L
    Log; indicates piece was horizonatal
  • S
    Snag; indicates piece was standing dead
  • P
    Stump; indicates a lower portion of a tree left after tree was harvested
DECAY - char(1) (nominal)

ID: TD02201.DECAY

Decay class of sample

Type system: Microsoft SQL Server 2008

Code definitions (6)
  • code
    Green tree with no decay
  • 1
    Freshly killed; sound log with fine twigs present
  • 2
    Beginning to decompose; twigs falling off; bark cover intact
  • 3
    Partially decayed;bark and sapwood sloughing off; many brnaches have fallen Off
  • 4
    Very decayed; unable to support itself; branch stubs can be moved by hand id Icating Wood Decayed To Center.
  • 5
    Extremely decayed; cross-section elliptical; embedded in forest floor; wood Structure Largely Gone
AGE - numeric(3,0) (ratio)

ID: TD02201.AGE

Residence time of the cwd piece; the time it has been dead

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

METHOD - char(1) (nominal)

ID: TD02201.METHOD

Method of determining the residence time

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • F
    Decomposition time estimate is based on visual foliage appearance: Freshly Killed Needles Still Green Or Red-brown
  • K
    Decomposition time is known
  • L
    Dated from a living stump
  • N
    Dated from a seedling on a nurse log.
  • P
    Palm, by counting annual rings since hit by a log
  • R
    Dated from a record in a permanent plot.
  • S
    Dated from a fall scar on a living or recently killed tree.
  • U
    Decomposition time is undetermined.
CAUSE - char(2) (nominal)

ID: TD02201.CAUSE

Cause of death; this is very general

Type system: Microsoft SQL Server 2008

Code definitions (10)
  • BK
    Beetle kill
  • C
    Tree was cut down as in a thinning operation
  • F
    Fire; could be based on record or fire scar (latter is less reliable)
  • O
    Other form of mortality including unknown causes
  • RB
    Road building
  • RT
    Root throw
  • S
    Standing
  • WB
    Wind break, wind broke stem
  • WS
    Windsnap; bole is broken off
  • WT
    Wind throw with the root system tore out of ground
DBH - numeric(3,0) (ratio)

ID: TD02201.DBH

Diameter at breast height of the cwd piece. in cases of very decayed piece this is estimated. used to calculate the original volume and mass

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1.000000

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

BD - numeric(3,0) (ratio)

ID: TD02201.BD

Diameter at base of the cwd piece. this is the current measurement and does not correct for fragmentation. used to claculate the current volume& mass

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1.000000

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

TD - numeric(3,0) (ratio)

ID: TD02201.TD

Diameter at top of the cwd piece. this is the current measurement and does not correct for fragmentation. used to claculate the current volume& mass

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1.000000

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

LENGTH - numeric(4,1) (ratio)

ID: TD02201.LENGTH

Length of the cwd piece. this includes zones that have decayed away but not spaces caused when the piece fell to the forest floor.

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.100000

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

BCOVER - numeric(3,0) (ratio)

ID: TD02201.BCOVER

Bark cover on the bole of the cwd piece.

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1.000000

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

VOLMISS - numeric(9,6) (ratio)

ID: TD02201.VOLMISS

Volume missing. accounts for parts that have decayed away and do not co ntribute to the current volume (except parts missing to non-decay process).

Type system: Microsoft SQL Server 2008

Unit: cubic centimeters

Precision: 0.005000

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

DS1 - numeric(3,0) (ratio)

ID: TD02201.DS1

Diamter at first sample point.

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1.000000

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

HS1 - numeric(4,1) (ratio)

ID: TD02201.HS1

Height at first sample point.

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.100000

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

DS2 - numeric(3,0) (ratio)

ID: TD02201.DS2

Diameter at second sample point.

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1.000000

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

HS2 - numeric(4,1) (ratio)

ID: TD02201.HS2

Height at second sample point.

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.100000

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

DS3 - numeric(3,0) (ratio)

ID: TD02201.DS3

Diameter at third sample point.

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1.000000

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

HS3 - numeric(4,1) (ratio)

ID: TD02201.HS3

Height at third sample point.

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.100000

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

DS4 - numeric(3,0) (ratio)

ID: TD02201.DS4

Diameter at fourth sample point.

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1.000000

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

HS4 - numeric(4,1) (ratio)

ID: TD02201.HS4

Height at fourth sample point.

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.100000

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

DS5 - numeric(3,0) (ratio)

ID: TD02201.DS5

Diameter at fifth sample point.

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1.000000

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

HS5 - numeric(4,1) (ratio)

ID: TD02201.HS5

Height at fifth sample point.

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.100000

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

CURVOL - numeric(9,6) (ratio)

ID: TD02201.CURVOL

Current volume of the CWD piece

Type system: Microsoft SQL Server 2008

Unit: cubic centimeters

Precision: 0.000000

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

ORIGVOL - numeric(9,6) (ratio)

ID: TD02201.ORIGVOL

Initial volume of the cwd piece

Type system: Microsoft SQL Server 2008

Unit: cubic centimeters

Precision: 0.000000

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

SAMPLEDATE - date (dateTime)

ID: TD02201.SAMPLEDATE

Date the sample collection took place

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TD02202 - TD02202

Object name: TD02202.csv

Records: 6662

Attributes: 18

Temporal coverage: 1982-09-01 to 2001-06-11

File size: 599760 byte

Checksum (MD5): b821417f12467915a4841174e01aa7e5

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

Constraints (2)
  • primaryKey: PRIMARY
    TD02202.STUDYID, TD02202.NUMBER, TD02202.PLOT, TD02202.SECTION, TD02202.YEAR, TD02202.STAND
  • notNullConstraint: NOTNULL
    TD02202.STUDYID, TD02202.DBCODE, TD02202.NUMBER, TD02202.PLOT, TD02202.SECTION, TD02202.ENTITY, TD02202.YEAR, TD02202.STAND, TD02202.SAMPLEDATE
Attributes (18)
DBCODE - char(5) (nominal)

ID: TD02202.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • TD022
    FSDB Database Code TD022 (terrestrial decomposition)
ENTITY - numeric(2,0) (interval)

ID: TD02202.ENTITY

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)

STUDYID - char(4) (nominal)

ID: TD02202.STUDYID

Study Id, matches those in TD12 and TV010 whenever possible

Type system: Microsoft SQL Server 2008

Code definitions (16)
  • EUS
    Eastern United States
  • INTM
    Intermountain United States
  • IRIR
    Russia; 1-st pair of letters describes the forest inventory enterprise, Ir=Irkutsk; 2-nd Pair Of Letters Describes The Region-"oblast'", Ir=Irkutsk
  • KHKH
    KH=Kabarovsk inventory enterprise; kH=Khabarovs region-"oblast"; russia
  • KRKR
    KR=Krasnoyarsk inventory enterprise; KR=Krasnoyarsk region-"oblast"; russia
  • MEX
    Mexico
  • MOSK
    Moscow region, Russia
  • NNOV
    Nizhnii novgorod; Russia
  • NSNS
    NS=NNvosibirsk inventory enterprise; NS=Novosibirsk region-"oblast"; Russia
  • NSTM
    NS=Novosibirsk inventory enterprise; TM=Tiumenskaya "oblast"-region; Russia
  • PNW
    Pacific Northwest, United States
  • PSW
    Pacific Southwest, United States
  • STAR
    EPA star project headed by Dr. Beverly Law
  • STPB
    St.-Petersburg; Russia
  • WINE
    Winema National Forest
  • WRE
    Wind River Xxperimental Forest
STAND - char(4) (nominal)

ID: TD02202.STAND

Code for stand

Type system: Microsoft SQL Server 2008

Code definitions (47)
  • ME
    Metolius RNA
  • RSF
    Rancho San Felipe, Puerto Morelos, Quintana Roo
  • THUN
    WIND RIVER R.D. CUT UNIT, THUN
  • BONE
    WIND RIVER R.D. CUT UNIT, BONE
  • TCH1
    WIND RIVER R.D. CUT UNIT, TCH1
  • VIM2
    WIND RIVER R.D. CUT UNIT, VIM2
  • SEC4
    WIND RIVER R.D. CUT UNIT, SEC4
  • COUG
    WIND RIVER R.D. CUT UNIT, COUG
  • PCR2
    WIND RIVER R.D. CUT UNIT, PLCR
  • TCH2
    WIND RIVER R.D. CUT UNIT, TCH2
  • SOSF
    WIND RIVER R.D. CUT UNIT, SOSF
  • CHEF
    Cascade Head Experimental Forest OR (TD027)
  • NCB
    North Carolina Botanical Garden, Chapel Hill, NC
  • PFEF
    Pringle Falls Experimental Forest Oregon
  • TUX
    Los Tuxtlas Experimental Forest, UNAM, Veracruz, Mexico
  • YUC
    Noh Bec, Quintana Roo, Mexico
  • OHJA
    Andrews Forest and vicinity Reference Stands
  • PPGY
    Ponderosa Pine Growth and Yield Study
  • RMRS
    Rocky Mountain Reference Stands
  • SQNP
    Sequoia National Park Reference Stands
  • BABA
    BA=Bayandaiskii lekhoz (forest management enterprise); BA=Bayandaevskoe Lesnichestvo (ranger station
  • NZUD
    Nizhneudinsk, Russia
  • OLKO
    OL=Ol'khonskii leskhoz; KO=Kosostepskoe lesnichestvo
  • STIL
    ST=Shestakovskii leskhoz (forest management entermprise); IL=Ilimskoe Lesnichestvo (ranger station)
  • BTKL
    BT=Bystrinskii leskhoz (fme); KL=Kliuchevskoe lesnichestvo (ranger station)
  • KHKF
    KH=Khorskii leskhoz; KF=Kafenskoe lesnichestvo
  • KHKT
    KH=Khorskii leskhoz; KT=Katenskoe lesnichestvo
  • KHLA
    Kh=khorskii leskhoz; LA=Lazovskoe lesnichestvo
  • KHLZ
    Khabarovskii leskhoz (forest management enterprise), Russia
  • ULBR
    UL=Ul'chskii leskhoz; BR=Bogorodskoe lesnichestvo
  • BGKB
    BG=Boguchanskii leskhoz (fme); karabul'skoe lesnichestvo (ranger station)
  • CHCH
    CH=Chunskii leskhoz (forest management enterprise); CH=Chunoyarskoe Lesnichestvo (ranger station)
  • CHKH
    CH=Chunskii leskhoz (fme); khozhenskoe lesnichestvo (ranger station)
  • CHTA
    CH=Chunskii leskhoz (fme); takuchetskoe lesnichestvo (ranger station)
  • EMKE
    EM=Emel'yanovskii leskhoz (fme); ke=kemchugskoe lesnichestvo
  • POPO
    PO=Podol'skii leskhoz; podol'skoe lesnichestvo
  • PZMA
    Pizhma village, Russia
  • BERD
    Berdskii leskhoz (forest management enterprise)
  • MIMI
    MI=Mirnovskii leskhoz; MI=Mirnovskoe lesnichestvo
  • NSIB
    Novosibirsk, Russia
  • BEKZ
    BE=Beloyarskii leskhoz (forest management enterprise); KZ= Kazymskoe Lesnichestvo (ranger station)
  • KART
    Kartashevka, Russia
  • KOBN
    Korbona, Russia
  • LYSI
    Lysino, Russia
  • NOVG
    Novgorod, Russia
  • VRZA
    Viritza, Russia
  • KRD
    Kalamath r.d., Winema National Forest
PLOT - char(10) (nominal)

ID: TD02202.PLOT

Arbitrary site number associated with cwd piece.

Type system: Microsoft SQL Server 2008

YEAR - numeric(4,0) (ratio)

ID: TD02202.YEAR

Year the sample collection took place

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

NUMBER - char(5) (nominal)

ID: TD02202.NUMBER

Identifying code/number of CWD piece

Type system: Microsoft SQL Server 2008

SECTION - char(1) (ordinal)

ID: TD02202.SECTION

Cross-section number or letter of sample; often more than one is taken to give replication

Type system: Microsoft SQL Server 2008

OBT - numeric(5,1) (ratio)

ID: TD02202.OBT

Current radial thickness of outerbark

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1.000000

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

IBT - numeric(5,1) (ratio)

ID: TD02202.IBT

Current radial thickness of inner bark

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1.000000

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

SWT - numeric(5,1) (ratio)

ID: TD02202.SWT

Current radial thickness of sapwood

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1.000000

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

HWT - numeric(5,1) (ratio)

ID: TD02202.HWT

Current radial thickness of heartwood

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1.000000

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

FOB - numeric(5,1) (ratio)

ID: TD02202.FOB

Current fraction of crosssection in outer bark

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)

FIB - numeric(5,1) (ratio)

ID: TD02202.FIB

Current fraction of cross-section in inner bark

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

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

FSW - numeric(5,1) (ratio)

ID: TD02202.FSW

Current fraction of cross-section in sapwood

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)

FHW - numeric(5,1) (ratio)

ID: TD02202.FHW

Current fraction of cross-section in heartwood

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)

DKRAD - numeric(5,1) (ratio)

ID: TD02202.DKRAD

Radial depth of rot; depth to which the rot progrssed from outside inward

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1.000000

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

SAMPLEDATE - date (dateTime)

ID: TD02202.SAMPLEDATE

Date the sample collection took place

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TD02203 - TD02203

Object name: TD02203.csv

Records: 13674

Attributes: 19

Temporal coverage: 1982-09-01 to 2001-06-11

File size: 1344883 byte

Checksum (MD5): 0fe614e43f35e86e89f4a80602dac4eb

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

Constraints (2)
  • primaryKey: PRIMARY
    TD02203.STUDYID, TD02203.TISSUE, TD02203.NUMBER, TD02203.SECTION, TD02203.YEAR, TD02203.STAND, TD02203.SAMPLEDATE
  • notNullConstraint: NOTNULL
    TD02203.STUDYID, TD02203.TISSUE, TD02203.DBCODE, TD02203.NUMBER, TD02203.SECTION, TD02203.ENTITY, TD02203.YEAR, TD02203.STAND, TD02203.SAMPLEDATE
Attributes (19)
DBCODE - char(5) (nominal)

ID: TD02203.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • TD022
    FSDB Database Code TD022 (terrestrial decomposition)
ENTITY - numeric(2,0) (interval)

ID: TD02203.ENTITY

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)

STUDYID - char(4) (nominal)

ID: TD02203.STUDYID

Study Id, matches those in TD12 and TV010 whenever possible

Type system: Microsoft SQL Server 2008

Code definitions (16)
  • EUS
    Eastern United States
  • INTM
    Intermountain United States
  • IRIR
    Russia; 1-st pair of letters describes the forest inventory enterprise, Ir=Irkutsk; 2-nd Pair Of Letters Describes The Region-"oblast'", Ir=Irkutsk
  • KHKH
    KH=Kabarovsk inventory enterprise; kH=Khabarovs region-"oblast"; russia
  • KRKR
    KR=Krasnoyarsk inventory enterprise; KR=Krasnoyarsk region-"oblast"; russia
  • MEX
    Mexico
  • MOSK
    Moscow region, Russia
  • NNOV
    Nizhnii novgorod; Russia
  • NSNS
    NS=NNvosibirsk inventory enterprise; NS=Novosibirsk region-"oblast"; Russia
  • NSTM
    NS=Novosibirsk inventory enterprise; TM=Tiumenskaya "oblast"-region; Russia
  • PNW
    Pacific Northwest, United States
  • PSW
    Pacific Southwest, United States
  • STAR
    EPA star project headed by Dr. Beverly Law
  • STPB
    St.-Petersburg; Russia
  • WINE
    Winema National Forest
  • WRE
    Wind River Xxperimental Forest
STAND - char(4) (nominal)

ID: TD02203.STAND

Code for stand

Type system: Microsoft SQL Server 2008

Code definitions (47)
  • ME
    Metolius RNA
  • RSF
    Rancho San Felipe, Puerto Morelos, Quintana Roo
  • THUN
    WIND RIVER R.D. CUT UNIT, THUN
  • BONE
    WIND RIVER R.D. CUT UNIT, BONE
  • TCH1
    WIND RIVER R.D. CUT UNIT, TCH1
  • VIM2
    WIND RIVER R.D. CUT UNIT, VIM2
  • SEC4
    WIND RIVER R.D. CUT UNIT, SEC4
  • COUG
    WIND RIVER R.D. CUT UNIT, COUG
  • PCR2
    WIND RIVER R.D. CUT UNIT, PLCR
  • TCH2
    WIND RIVER R.D. CUT UNIT, TCH2
  • SOSF
    WIND RIVER R.D. CUT UNIT, SOSF
  • CHEF
    Cascade Head Experimental Forest OR (TD027)
  • NCB
    North Carolina Botanical Garden, Chapel Hill, NC
  • PFEF
    Pringle Falls Experimental Forest Oregon
  • TUX
    Los Tuxtlas Experimental Forest, UNAM, Veracruz, Mexico
  • YUC
    Noh Bec, Quintana Roo, Mexico
  • OHJA
    Andrews Forest and vicinity Reference Stands
  • PPGY
    Ponderosa Pine Growth and Yield Study
  • RMRS
    Rocky Mountain Reference Stands
  • SQNP
    Sequoia National Park Reference Stands
  • BABA
    BA=Bayandaiskii lekhoz (forest management enterprise); BA=Bayandaevskoe Lesnichestvo (ranger station
  • NZUD
    Nizhneudinsk, Russia
  • OLKO
    OL=Ol'khonskii leskhoz; KO=Kosostepskoe lesnichestvo
  • STIL
    ST=Shestakovskii leskhoz (forest management entermprise); IL=Ilimskoe Lesnichestvo (ranger station)
  • BTKL
    BT=Bystrinskii leskhoz (fme); KL=Kliuchevskoe lesnichestvo (ranger station)
  • KHKF
    KH=Khorskii leskhoz; KF=Kafenskoe lesnichestvo
  • KHKT
    KH=Khorskii leskhoz; KT=Katenskoe lesnichestvo
  • KHLA
    Kh=khorskii leskhoz; LA=Lazovskoe lesnichestvo
  • KHLZ
    Khabarovskii leskhoz (forest management enterprise), Russia
  • ULBR
    UL=Ul'chskii leskhoz; BR=Bogorodskoe lesnichestvo
  • BGKB
    BG=Boguchanskii leskhoz (fme); karabul'skoe lesnichestvo (ranger station)
  • CHCH
    CH=Chunskii leskhoz (forest management enterprise); CH=Chunoyarskoe Lesnichestvo (ranger station)
  • CHKH
    CH=Chunskii leskhoz (fme); khozhenskoe lesnichestvo (ranger station)
  • CHTA
    CH=Chunskii leskhoz (fme); takuchetskoe lesnichestvo (ranger station)
  • EMKE
    EM=Emel'yanovskii leskhoz (fme); ke=kemchugskoe lesnichestvo
  • POPO
    PO=Podol'skii leskhoz; podol'skoe lesnichestvo
  • PZMA
    Pizhma village, Russia
  • BERD
    Berdskii leskhoz (forest management enterprise)
  • MIMI
    MI=Mirnovskii leskhoz; MI=Mirnovskoe lesnichestvo
  • NSIB
    Novosibirsk, Russia
  • BEKZ
    BE=Beloyarskii leskhoz (forest management enterprise); KZ= Kazymskoe Lesnichestvo (ranger station)
  • KART
    Kartashevka, Russia
  • KOBN
    Korbona, Russia
  • LYSI
    Lysino, Russia
  • NOVG
    Novgorod, Russia
  • VRZA
    Viritza, Russia
  • KRD
    Kalamath r.d., Winema National Forest
PLOT - char(10) (nominal)

ID: TD02203.PLOT

Arbitrary site number associated with cwd piece.

Type system: Microsoft SQL Server 2008

YEAR - numeric(4,0) (ratio)

ID: TD02203.YEAR

Year the sample collection took place

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

NUMBER - char(5) (nominal)

ID: TD02203.NUMBER

Identifying code/number of CWD piece

Type system: Microsoft SQL Server 2008

SECTION - char(1) (ordinal)

ID: TD02203.SECTION

Cross-section number or letter of sample; often more than one is taken to give replication

Type system: Microsoft SQL Server 2008

TISSUE - char(1) (nominal)

ID: TD02203.TISSUE

Tissue type of the sample

Type system: Microsoft SQL Server 2008

Code definitions (6)
  • W
    Wood
  • S
    Sapwood
  • H
    Heartwood
  • B
    Bark; indicates inner and outer bark were measured together
  • I
    Inner bark
  • O
    Outer bark
THICKNESS - numeric(5,1) (ratio)

ID: TD02203.THICKNESS

Thickness of the sample, may not be recorded if water displacement used to measure the volume.

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 0.500000

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

AREA - numeric(6,1) (ratio)

ID: TD02203.AREA

Area of the sample, may not be recorded if water displacement used to measure the volume.

Type system: Microsoft SQL Server 2008

Unit: square centimeters

Precision: 1.000000

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

VOLUME - numeric(7,1) (ratio)

ID: TD02203.VOLUME

Volume of the sample, if based on water displacement then thickness and area will be missing. samples soaked 24-48 hrs before displacement measurement

Type system: Microsoft SQL Server 2008

Unit: cubic centimeters

Precision: 0.500000

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

DRYWT - numeric(7,2) (ratio)

ID: TD02203.DRYWT

Usually dry weight of subsample (a wedge), usually after 4-7 days at 55 C.

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 0.020000

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

WETWT - numeric(7,2) (ratio)

ID: TD02203.WETWT

Usually wet weight of subsample (a wedge), may be missing if water displacement used to measure the volume

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 0.020000

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

DENSITY - numeric(5,3) (ratio)

ID: TD02203.DENSITY

Density of sample; calculated from dry weight divided by fresh volume. usually total dry weight divided by the volume of a cross-section

Type system: Microsoft SQL Server 2008

Unit: grams per cubic centimeter

Precision: 0.010000

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

MOISTURE - numeric(6,1) (ratio)

ID: TD02203.MOISTURE

Moisture content of subsample; calculated as water weight lost during drying divided by the dry weight.

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.500000

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

TOTWETWT - numeric(9,2) (ratio)

ID: TD02203.TOTWETWT

Total wet weight of the sample (entire cross-section) measured in the field

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 0.010000

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

TOTDRYWT - numeric(9,3) (ratio)

ID: TD02203.TOTDRYWT

Total dry weight of the sample (entire cross-section) calc-ted from total wet weight and ratio between subsample dry and wet wghts

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 0.001000

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

SAMPLEDATE - date (dateTime)

ID: TD02203.SAMPLEDATE

Date the sample collection took place

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TD02204 - TD02204

Object name: TD02204.csv

Records: 422

Attributes: 24

Temporal coverage: 1982-09-01 to 1993-05-19

File size: 50306 byte

Checksum (MD5): 174518285adf20fb2f98323f9645d8cd

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

Constraints (2)
  • primaryKey: PRIMARY
    TD02204.STUDYID, TD02204.TISSUE, TD02204.NUMBER, TD02204.PLOT, TD02204.YEAR, TD02204.STAND, TD02204.SAMPLEDATE, TD02204.SAMPLE_NO
  • notNullConstraint: NOTNULL
    TD02204.LAB, TD02204.STUDYID, TD02204.TISSUE, TD02204.DBCODE, TD02204.NUMBER, TD02204.PLOT, TD02204.AL, TD02204.B, TD02204.CA, TD02204.CU, TD02204.FE, TD02204.ENTITY, TD02204.K, TD02204.MG, TD02204.MN, TD02204.N, TD02204.NA, TD02204.P, TD02204.S, TD02204.YEAR, TD02204.ZN, TD02204.STAND, TD02204.SAMPLEDATE, TD02204.SAMPLE_NO
Attributes (24)
DBCODE - char(5) (nominal)

ID: TD02204.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • TD022
    FSDB Database Code TD022 (terrestrial decomposition)
ENTITY - numeric(2,0) (interval)

ID: TD02204.ENTITY

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)

STUDYID - char(4) (nominal)

ID: TD02204.STUDYID

Study Id, matches those in TD12 and TV010 whenever possible

Type system: Microsoft SQL Server 2008

Code definitions (16)
  • EUS
    Eastern United States
  • INTM
    Intermountain United States
  • IRIR
    Russia; 1-st pair of letters describes the forest inventory enterprise, Ir=Irkutsk; 2-nd Pair Of Letters Describes The Region-"oblast'", Ir=Irkutsk
  • KHKH
    KH=Kabarovsk inventory enterprise; kH=Khabarovs region-"oblast"; russia
  • KRKR
    KR=Krasnoyarsk inventory enterprise; KR=Krasnoyarsk region-"oblast"; russia
  • MEX
    Mexico
  • MOSK
    Moscow region, Russia
  • NNOV
    Nizhnii novgorod; Russia
  • NSNS
    NS=NNvosibirsk inventory enterprise; NS=Novosibirsk region-"oblast"; Russia
  • NSTM
    NS=Novosibirsk inventory enterprise; TM=Tiumenskaya "oblast"-region; Russia
  • PNW
    Pacific Northwest, United States
  • PSW
    Pacific Southwest, United States
  • STAR
    EPA star project headed by Dr. Beverly Law
  • STPB
    St.-Petersburg; Russia
  • WINE
    Winema National Forest
  • WRE
    Wind River Xxperimental Forest
STAND - char(4) (nominal)

ID: TD02204.STAND

Code for stand

Type system: Microsoft SQL Server 2008

Code definitions (47)
  • ME
    Metolius RNA
  • RSF
    Rancho San Felipe, Puerto Morelos, Quintana Roo
  • THUN
    WIND RIVER R.D. CUT UNIT, THUN
  • BONE
    WIND RIVER R.D. CUT UNIT, BONE
  • TCH1
    WIND RIVER R.D. CUT UNIT, TCH1
  • VIM2
    WIND RIVER R.D. CUT UNIT, VIM2
  • SEC4
    WIND RIVER R.D. CUT UNIT, SEC4
  • COUG
    WIND RIVER R.D. CUT UNIT, COUG
  • PCR2
    WIND RIVER R.D. CUT UNIT, PLCR
  • TCH2
    WIND RIVER R.D. CUT UNIT, TCH2
  • SOSF
    WIND RIVER R.D. CUT UNIT, SOSF
  • CHEF
    Cascade Head Experimental Forest OR (TD027)
  • NCB
    North Carolina Botanical Garden, Chapel Hill, NC
  • PFEF
    Pringle Falls Experimental Forest Oregon
  • TUX
    Los Tuxtlas Experimental Forest, UNAM, Veracruz, Mexico
  • YUC
    Noh Bec, Quintana Roo, Mexico
  • OHJA
    Andrews Forest and vicinity Reference Stands
  • PPGY
    Ponderosa Pine Growth and Yield Study
  • RMRS
    Rocky Mountain Reference Stands
  • SQNP
    Sequoia National Park Reference Stands
  • BABA
    BA=Bayandaiskii lekhoz (forest management enterprise); BA=Bayandaevskoe Lesnichestvo (ranger station
  • NZUD
    Nizhneudinsk, Russia
  • OLKO
    OL=Ol'khonskii leskhoz; KO=Kosostepskoe lesnichestvo
  • STIL
    ST=Shestakovskii leskhoz (forest management entermprise); IL=Ilimskoe Lesnichestvo (ranger station)
  • BTKL
    BT=Bystrinskii leskhoz (fme); KL=Kliuchevskoe lesnichestvo (ranger station)
  • KHKF
    KH=Khorskii leskhoz; KF=Kafenskoe lesnichestvo
  • KHKT
    KH=Khorskii leskhoz; KT=Katenskoe lesnichestvo
  • KHLA
    Kh=khorskii leskhoz; LA=Lazovskoe lesnichestvo
  • KHLZ
    Khabarovskii leskhoz (forest management enterprise), Russia
  • ULBR
    UL=Ul'chskii leskhoz; BR=Bogorodskoe lesnichestvo
  • BGKB
    BG=Boguchanskii leskhoz (fme); karabul'skoe lesnichestvo (ranger station)
  • CHCH
    CH=Chunskii leskhoz (forest management enterprise); CH=Chunoyarskoe Lesnichestvo (ranger station)
  • CHKH
    CH=Chunskii leskhoz (fme); khozhenskoe lesnichestvo (ranger station)
  • CHTA
    CH=Chunskii leskhoz (fme); takuchetskoe lesnichestvo (ranger station)
  • EMKE
    EM=Emel'yanovskii leskhoz (fme); ke=kemchugskoe lesnichestvo
  • POPO
    PO=Podol'skii leskhoz; podol'skoe lesnichestvo
  • PZMA
    Pizhma village, Russia
  • BERD
    Berdskii leskhoz (forest management enterprise)
  • MIMI
    MI=Mirnovskii leskhoz; MI=Mirnovskoe lesnichestvo
  • NSIB
    Novosibirsk, Russia
  • BEKZ
    BE=Beloyarskii leskhoz (forest management enterprise); KZ= Kazymskoe Lesnichestvo (ranger station)
  • KART
    Kartashevka, Russia
  • KOBN
    Korbona, Russia
  • LYSI
    Lysino, Russia
  • NOVG
    Novgorod, Russia
  • VRZA
    Viritza, Russia
  • KRD
    Kalamath r.d., Winema National Forest
PLOT - char(10) (nominal)

ID: TD02204.PLOT

Arbitrary site number associated with cwd piece.

Type system: Microsoft SQL Server 2008

YEAR - numeric(4,0) (ratio)

ID: TD02204.YEAR

Year the sample collection took place

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

SAMPLE_NO - numeric(1,0) (interval)

ID: TD02204.SAMPLE_NO

Unique sample number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

NUMBER - char(5) (nominal)

ID: TD02204.NUMBER

Identifying code/number of CWD piece

Type system: Microsoft SQL Server 2008

N - numeric(6,2) (ratio)

ID: TD02204.N

Nitrogen concentration (micro kjeldahl n)

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

TISSUE - char(1) (nominal)

ID: TD02204.TISSUE

Tissue type of the sample

Type system: Microsoft SQL Server 2008

Code definitions (6)
  • W
    Wood
  • S
    Sapwood
  • H
    Heartwood
  • B
    Bark; indicates inner and outer bark were measured together
  • I
    Inner bark
  • O
    Outer bark
AL - numeric(7,1) (ratio)

ID: TD02204.AL

Aluminum concentration (icap inductively coupled argon spectrophotometry)

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 0.100000

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

B - numeric(6,1) (ratio)

ID: TD02204.B

Boron concentration (icap inductively coupled argon spectrophotometry)

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 0.100000

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

CA - numeric(8,1) (ratio)

ID: TD02204.CA

Calcium concentration (icap inductively coupled argon spectrophotometry)

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 0.100000

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

CU - numeric(6,1) (ratio)

ID: TD02204.CU

Copper concentration (icap inductively coupled argon spectrophotometry)

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 0.100000

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

FE - numeric(7,1) (ratio)

ID: TD02204.FE

Iron concentration (icap inductively coupled argon spectrophotometry)

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 0.100000

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

K - numeric(8,0) (ratio)

ID: TD02204.K

Potassium concentration (icap inductively coupled argon spectrophotometry)

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 1.000000

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

MG - numeric(7,1) (ratio)

ID: TD02204.MG

Magnesium concentration (icap inductively coupled argon spectrophotometry)

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 0.100000

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

MN - numeric(7,1) (ratio)

ID: TD02204.MN

Manganese concentration (icap inductively coupled argon spectrophotometry)

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 0.100000

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

P - numeric(7,1) (ratio)

ID: TD02204.P

Phosphorus concentration (icap inductively coupled argon spectrophotometry)

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 0.100000

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

S - numeric(6,1) (ratio)

ID: TD02204.S

Sulfur concentration (icap inductively coupled argon spectrophotometry)

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 0.100000

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

ZN - numeric(8,1) (ratio)

ID: TD02204.ZN

Zinc concentration (icap inductively coupled argon spectrophotometry)

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 0.100000

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

NA - numeric(8,1) (ratio)

ID: TD02204.NA

Sodium concentration (icap inductively coupled argon spectrophotometry)

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 0.100000

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

LAB - char(3) (nominal)

ID: TD02204.LAB

Analyzing laboratory

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • CAL
    Lab where analysis was performed (CAL, Michigan, or UPN)
  • MMI
    Lab where analysis was performed (CAL, Michigan, or UPN)
  • UPN
    Lab where analysis was performed (CAL, Michigan, or UPN)
SAMPLEDATE - date (dateTime)

ID: TD02204.SAMPLEDATE

Date the sample collection took place

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TD02206 - TD02206

Object name: TD02206.csv

Records: 6666

Attributes: 13

Temporal coverage: 1982-09-01 to 2001-06-11

File size: 440816 byte

Checksum (MD5): c18b3f55980ddbf2ec720f007c979594

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

Constraints (2)
  • primaryKey: PRIMARY
    TD02206.STUDYID, TD02206.NUMBER, TD02206.PLOT, TD02206.SECTION, TD02206.YEAR, TD02206.STAND
  • notNullConstraint: NOTNULL
    TD02206.STUDYID, TD02206.DBCODE, TD02206.NUMBER, TD02206.PLOT, TD02206.SECTION, TD02206.DKRAD, TD02206.ENTITY, TD02206.PDKRAD, TD02206.PDKVOL, TD02206.TOTRAD, TD02206.YEAR, TD02206.STAND, TD02206.SAMPLEDATE
Attributes (13)
DBCODE - char(5) (nominal)

ID: TD02206.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • TD022
    FSDB Database Code TD022 (terrestrial decomposition)
ENTITY - numeric(2,0) (interval)

ID: TD02206.ENTITY

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)

STUDYID - char(4) (nominal)

ID: TD02206.STUDYID

Study Id, matches those in TD12 and TV010 whenever possible

Type system: Microsoft SQL Server 2008

Code definitions (16)
  • EUS
    Eastern United States
  • INTM
    Intermountain United States
  • IRIR
    Russia; 1-st pair of letters describes the forest inventory enterprise, Ir=Irkutsk; 2-nd Pair Of Letters Describes The Region-"oblast'", Ir=Irkutsk
  • KHKH
    KH=Kabarovsk inventory enterprise; kH=Khabarovs region-"oblast"; russia
  • KRKR
    KR=Krasnoyarsk inventory enterprise; KR=Krasnoyarsk region-"oblast"; russia
  • MEX
    Mexico
  • MOSK
    Moscow region, Russia
  • NNOV
    Nizhnii novgorod; Russia
  • NSNS
    NS=NNvosibirsk inventory enterprise; NS=Novosibirsk region-"oblast"; Russia
  • NSTM
    NS=Novosibirsk inventory enterprise; TM=Tiumenskaya "oblast"-region; Russia
  • PNW
    Pacific Northwest, United States
  • PSW
    Pacific Southwest, United States
  • STAR
    EPA star project headed by Dr. Beverly Law
  • STPB
    St.-Petersburg; Russia
  • WINE
    Winema National Forest
  • WRE
    Wind River Xxperimental Forest
STAND - char(4) (nominal)

ID: TD02206.STAND

Code for stand

Type system: Microsoft SQL Server 2008

Code definitions (47)
  • ME
    Metolius RNA
  • RSF
    Rancho San Felipe, Puerto Morelos, Quintana Roo
  • THUN
    WIND RIVER R.D. CUT UNIT, THUN
  • BONE
    WIND RIVER R.D. CUT UNIT, BONE
  • TCH1
    WIND RIVER R.D. CUT UNIT, TCH1
  • VIM2
    WIND RIVER R.D. CUT UNIT, VIM2
  • SEC4
    WIND RIVER R.D. CUT UNIT, SEC4
  • COUG
    WIND RIVER R.D. CUT UNIT, COUG
  • PCR2
    WIND RIVER R.D. CUT UNIT, PLCR
  • TCH2
    WIND RIVER R.D. CUT UNIT, TCH2
  • SOSF
    WIND RIVER R.D. CUT UNIT, SOSF
  • CHEF
    Cascade Head Experimental Forest OR (TD027)
  • NCB
    North Carolina Botanical Garden, Chapel Hill, NC
  • PFEF
    Pringle Falls Experimental Forest Oregon
  • TUX
    Los Tuxtlas Experimental Forest, UNAM, Veracruz, Mexico
  • YUC
    Noh Bec, Quintana Roo, Mexico
  • OHJA
    Andrews Forest and vicinity Reference Stands
  • PPGY
    Ponderosa Pine Growth and Yield Study
  • RMRS
    Rocky Mountain Reference Stands
  • SQNP
    Sequoia National Park Reference Stands
  • BABA
    BA=Bayandaiskii lekhoz (forest management enterprise); BA=Bayandaevskoe Lesnichestvo (ranger station
  • NZUD
    Nizhneudinsk, Russia
  • OLKO
    OL=Ol'khonskii leskhoz; KO=Kosostepskoe lesnichestvo
  • STIL
    ST=Shestakovskii leskhoz (forest management entermprise); IL=Ilimskoe Lesnichestvo (ranger station)
  • BTKL
    BT=Bystrinskii leskhoz (fme); KL=Kliuchevskoe lesnichestvo (ranger station)
  • KHKF
    KH=Khorskii leskhoz; KF=Kafenskoe lesnichestvo
  • KHKT
    KH=Khorskii leskhoz; KT=Katenskoe lesnichestvo
  • KHLA
    Kh=khorskii leskhoz; LA=Lazovskoe lesnichestvo
  • KHLZ
    Khabarovskii leskhoz (forest management enterprise), Russia
  • ULBR
    UL=Ul'chskii leskhoz; BR=Bogorodskoe lesnichestvo
  • BGKB
    BG=Boguchanskii leskhoz (fme); karabul'skoe lesnichestvo (ranger station)
  • CHCH
    CH=Chunskii leskhoz (forest management enterprise); CH=Chunoyarskoe Lesnichestvo (ranger station)
  • CHKH
    CH=Chunskii leskhoz (fme); khozhenskoe lesnichestvo (ranger station)
  • CHTA
    CH=Chunskii leskhoz (fme); takuchetskoe lesnichestvo (ranger station)
  • EMKE
    EM=Emel'yanovskii leskhoz (fme); ke=kemchugskoe lesnichestvo
  • POPO
    PO=Podol'skii leskhoz; podol'skoe lesnichestvo
  • PZMA
    Pizhma village, Russia
  • BERD
    Berdskii leskhoz (forest management enterprise)
  • MIMI
    MI=Mirnovskii leskhoz; MI=Mirnovskoe lesnichestvo
  • NSIB
    Novosibirsk, Russia
  • BEKZ
    BE=Beloyarskii leskhoz (forest management enterprise); KZ= Kazymskoe Lesnichestvo (ranger station)
  • KART
    Kartashevka, Russia
  • KOBN
    Korbona, Russia
  • LYSI
    Lysino, Russia
  • NOVG
    Novgorod, Russia
  • VRZA
    Viritza, Russia
  • KRD
    Kalamath r.d., Winema National Forest
PLOT - char(10) (nominal)

ID: TD02206.PLOT

Arbitrary site number associated with cwd piece.

Type system: Microsoft SQL Server 2008

YEAR - numeric(4,0) (ratio)

ID: TD02206.YEAR

Year the sample collection took place

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

NUMBER - char(5) (nominal)

ID: TD02206.NUMBER

Identifying code/number of CWD piece

Type system: Microsoft SQL Server 2008

SECTION - char(1) (ordinal)

ID: TD02206.SECTION

Cross-section number or letter of sample; often more than one is taken to give replication

Type system: Microsoft SQL Server 2008

DKRAD - numeric(5,1) (ratio)

ID: TD02206.DKRAD

Radial depth of rot; depth to which the rot progrssed from outside inward

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1.000000

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

TOTRAD - numeric(5,1) (ratio)

ID: TD02206.TOTRAD

Total radius of wooden tissues in a cross-section

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1.000000

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

PDKRAD - numeric(3,0) (ratio)

ID: TD02206.PDKRAD

Percent of radius decayed

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1.000000

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

PDKVOL - numeric(3,0) (ratio)

ID: TD02206.PDKVOL

Percent of volume decayed

Type system: Microsoft SQL Server 2008

Unit: cubic centimeters

Precision: 1.000000

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

SAMPLEDATE - date (dateTime)

ID: TD02206.SAMPLEDATE

Date the sample collection took place

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TD02207 - TD02207

Object name: TD02207.csv

Records: 4297

Attributes: 17

Temporal coverage: 1982-09-01 to 2001-06-11

File size: 367722 byte

Checksum (MD5): 3a09ac58a8b5f890bec127bf66e4bc81

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

Constraints (2)
  • primaryKey: PRIMARY
    TD02207.STUDYID, TD02207.NUMBER, TD02207.PLOT, TD02207.SECTION, TD02207.YEAR, TD02207.STAND
  • notNullConstraint: NOTNULL
    TD02207.STUDYID, TD02207.DBCODE, TD02207.NUMBER, TD02207.PLOT, TD02207.SECTION, TD02207.ENTITY, TD02207.IFHW, TD02207.IFIB, TD02207.IFOB, TD02207.IFSW, TD02207.IHWT, TD02207.IIBT, TD02207.IOBT, TD02207.ISWT, TD02207.YEAR, TD02207.STAND, TD02207.SAMPLEDATE
Attributes (17)
DBCODE - char(5) (nominal)

ID: TD02207.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • TD022
    FSDB Database Code TD022 (terrestrial decomposition)
ENTITY - numeric(2,0) (interval)

ID: TD02207.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

STUDYID - char(4) (nominal)

ID: TD02207.STUDYID

Study Id, matches those in TD12 and TV010 whenever possible

Type system: Microsoft SQL Server 2008

Code definitions (16)
  • EUS
    Eastern United States
  • INTM
    Intermountain United States
  • IRIR
    Russia; 1-st pair of letters describes the forest inventory enterprise, Ir=Irkutsk; 2-nd Pair Of Letters Describes The Region-"oblast'", Ir=Irkutsk
  • KHKH
    KH=Kabarovsk inventory enterprise; kH=Khabarovs region-"oblast"; russia
  • KRKR
    KR=Krasnoyarsk inventory enterprise; KR=Krasnoyarsk region-"oblast"; russia
  • MEX
    Mexico
  • MOSK
    Moscow region, Russia
  • NNOV
    Nizhnii novgorod; Russia
  • NSNS
    NS=NNvosibirsk inventory enterprise; NS=Novosibirsk region-"oblast"; Russia
  • NSTM
    NS=Novosibirsk inventory enterprise; TM=Tiumenskaya "oblast"-region; Russia
  • PNW
    Pacific Northwest, United States
  • PSW
    Pacific Southwest, United States
  • STAR
    EPA star project headed by Dr. Beverly Law
  • STPB
    St.-Petersburg; Russia
  • WINE
    Winema National Forest
  • WRE
    Wind River Xxperimental Forest
STAND - char(4) (nominal)

ID: TD02207.STAND

Code for stand

Type system: Microsoft SQL Server 2008

Code definitions (47)
  • ME
    Metolius RNA
  • RSF
    Rancho San Felipe, Puerto Morelos, Quintana Roo
  • THUN
    WIND RIVER R.D. CUT UNIT, THUN
  • BONE
    WIND RIVER R.D. CUT UNIT, BONE
  • TCH1
    WIND RIVER R.D. CUT UNIT, TCH1
  • VIM2
    WIND RIVER R.D. CUT UNIT, VIM2
  • SEC4
    WIND RIVER R.D. CUT UNIT, SEC4
  • COUG
    WIND RIVER R.D. CUT UNIT, COUG
  • PCR2
    WIND RIVER R.D. CUT UNIT, PLCR
  • TCH2
    WIND RIVER R.D. CUT UNIT, TCH2
  • SOSF
    WIND RIVER R.D. CUT UNIT, SOSF
  • CHEF
    Cascade Head Experimental Forest OR (TD027)
  • NCB
    North Carolina Botanical Garden, Chapel Hill, NC
  • PFEF
    Pringle Falls Experimental Forest Oregon
  • TUX
    Los Tuxtlas Experimental Forest, UNAM, Veracruz, Mexico
  • YUC
    Noh Bec, Quintana Roo, Mexico
  • OHJA
    Andrews Forest and vicinity Reference Stands
  • PPGY
    Ponderosa Pine Growth and Yield Study
  • RMRS
    Rocky Mountain Reference Stands
  • SQNP
    Sequoia National Park Reference Stands
  • BABA
    BA=Bayandaiskii lekhoz (forest management enterprise); BA=Bayandaevskoe Lesnichestvo (ranger station
  • NZUD
    Nizhneudinsk, Russia
  • OLKO
    OL=Ol'khonskii leskhoz; KO=Kosostepskoe lesnichestvo
  • STIL
    ST=Shestakovskii leskhoz (forest management entermprise); IL=Ilimskoe Lesnichestvo (ranger station)
  • BTKL
    BT=Bystrinskii leskhoz (fme); KL=Kliuchevskoe lesnichestvo (ranger station)
  • KHKF
    KH=Khorskii leskhoz; KF=Kafenskoe lesnichestvo
  • KHKT
    KH=Khorskii leskhoz; KT=Katenskoe lesnichestvo
  • KHLA
    Kh=khorskii leskhoz; LA=Lazovskoe lesnichestvo
  • KHLZ
    Khabarovskii leskhoz (forest management enterprise), Russia
  • ULBR
    UL=Ul'chskii leskhoz; BR=Bogorodskoe lesnichestvo
  • BGKB
    BG=Boguchanskii leskhoz (fme); karabul'skoe lesnichestvo (ranger station)
  • CHCH
    CH=Chunskii leskhoz (forest management enterprise); CH=Chunoyarskoe Lesnichestvo (ranger station)
  • CHKH
    CH=Chunskii leskhoz (fme); khozhenskoe lesnichestvo (ranger station)
  • CHTA
    CH=Chunskii leskhoz (fme); takuchetskoe lesnichestvo (ranger station)
  • EMKE
    EM=Emel'yanovskii leskhoz (fme); ke=kemchugskoe lesnichestvo
  • POPO
    PO=Podol'skii leskhoz; podol'skoe lesnichestvo
  • PZMA
    Pizhma village, Russia
  • BERD
    Berdskii leskhoz (forest management enterprise)
  • MIMI
    MI=Mirnovskii leskhoz; MI=Mirnovskoe lesnichestvo
  • NSIB
    Novosibirsk, Russia
  • BEKZ
    BE=Beloyarskii leskhoz (forest management enterprise); KZ= Kazymskoe Lesnichestvo (ranger station)
  • KART
    Kartashevka, Russia
  • KOBN
    Korbona, Russia
  • LYSI
    Lysino, Russia
  • NOVG
    Novgorod, Russia
  • VRZA
    Viritza, Russia
  • KRD
    Kalamath r.d., Winema National Forest
PLOT - char(10) (nominal)

ID: TD02207.PLOT

Arbitrary site number associated with cwd piece.

Type system: Microsoft SQL Server 2008

YEAR - numeric(4,0) (ratio)

ID: TD02207.YEAR

Year the sample collection took place

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

NUMBER - char(5) (nominal)

ID: TD02207.NUMBER

Identifying code/number of CWD piece

Type system: Microsoft SQL Server 2008

SECTION - char(1) (ordinal)

ID: TD02207.SECTION

Cross-section number or letter of sample; often more than one is taken to give replication

Type system: Microsoft SQL Server 2008

IOBT - numeric(5,1) (ratio)

ID: TD02207.IOBT

Initial radial thickness of outerbark

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1.000000

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

IIBT - numeric(5,1) (ratio)

ID: TD02207.IIBT

Initial radial thickness of inner bark

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1.000000

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

ISWT - numeric(5,1) (ratio)

ID: TD02207.ISWT

Initial radial thickness of sapwood

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1.000000

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

IHWT - numeric(5,1) (ratio)

ID: TD02207.IHWT

Initial radial thickness of heartwood

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1.000000

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

IFOB - numeric(5,1) (ratio)

ID: TD02207.IFOB

Initial fraction of cross-section in outer bark

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

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

IFIB - numeric(5,1) (ratio)

ID: TD02207.IFIB

Initial fraction of cross-section in inner bark

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

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

IFSW - numeric(5,1) (ratio)

ID: TD02207.IFSW

Initial fraction of cross-section in sapwood

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)

IFHW - numeric(5,1) (ratio)

ID: TD02207.IFHW

Initial fraction of cross-section in heartwood

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)

SAMPLEDATE - date (dateTime)

ID: TD02207.SAMPLEDATE

Date the sample collection took place

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TD02208 - TD02208

Object name: TD02208.csv

Records: 2256

Attributes: 30

Temporal coverage: 1982-09-01 to 2001-06-11

File size: 207569 byte

Checksum (MD5): 5837e37d29cf1c28789028fc42f1cd48

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

Constraints (2)
  • primaryKey: PRIMARY
    TD02208.STUDYID, TD02208.NUMBER, TD02208.PLOT, TD02208.YEAR, TD02208.STAND
  • notNullConstraint: NOTNULL
    TD02208.STUDYID, TD02208.DBCODE, TD02208.NUMBER, TD02208.PLOT, TD02208.ENTITY, TD02208.YEAR, TD02208.STAND, TD02208.SAMPLEDATE
Attributes (30)
DBCODE - char(5) (nominal)

ID: TD02208.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • TD022
    FSDB Database Code TD022 (terrestrial decomposition)
ENTITY - numeric(2,0) (interval)

ID: TD02208.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

STUDYID - char(4) (nominal)

ID: TD02208.STUDYID

Study Id, matches those in TD12 and TV010 whenever possible

Type system: Microsoft SQL Server 2008

Code definitions (16)
  • EUS
    Eastern United States
  • INTM
    Intermountain United States
  • IRIR
    Russia; 1-st pair of letters describes the forest inventory enterprise, Ir=Irkutsk; 2-nd Pair Of Letters Describes The Region-"oblast'", Ir=Irkutsk
  • KHKH
    KH=Kabarovsk inventory enterprise; kH=Khabarovs region-"oblast"; russia
  • KRKR
    KR=Krasnoyarsk inventory enterprise; KR=Krasnoyarsk region-"oblast"; russia
  • MEX
    Mexico
  • MOSK
    Moscow region, Russia
  • NNOV
    Nizhnii novgorod; Russia
  • NSNS
    NS=NNvosibirsk inventory enterprise; NS=Novosibirsk region-"oblast"; Russia
  • NSTM
    NS=Novosibirsk inventory enterprise; TM=Tiumenskaya "oblast"-region; Russia
  • PNW
    Pacific Northwest, United States
  • PSW
    Pacific Southwest, United States
  • STAR
    EPA star project headed by Dr. Beverly Law
  • STPB
    St.-Petersburg; Russia
  • WINE
    Winema National Forest
  • WRE
    Wind River Xxperimental Forest
STAND - char(4) (nominal)

ID: TD02208.STAND

Code for stand

Type system: Microsoft SQL Server 2008

Code definitions (47)
  • ME
    Metolius RNA
  • RSF
    Rancho San Felipe, Puerto Morelos, Quintana Roo
  • THUN
    WIND RIVER R.D. CUT UNIT, THUN
  • BONE
    WIND RIVER R.D. CUT UNIT, BONE
  • TCH1
    WIND RIVER R.D. CUT UNIT, TCH1
  • VIM2
    WIND RIVER R.D. CUT UNIT, VIM2
  • SEC4
    WIND RIVER R.D. CUT UNIT, SEC4
  • COUG
    WIND RIVER R.D. CUT UNIT, COUG
  • PCR2
    WIND RIVER R.D. CUT UNIT, PLCR
  • TCH2
    WIND RIVER R.D. CUT UNIT, TCH2
  • SOSF
    WIND RIVER R.D. CUT UNIT, SOSF
  • CHEF
    Cascade Head Experimental Forest OR (TD027)
  • NCB
    North Carolina Botanical Garden, Chapel Hill, NC
  • PFEF
    Pringle Falls Experimental Forest Oregon
  • TUX
    Los Tuxtlas Experimental Forest, UNAM, Veracruz, Mexico
  • YUC
    Noh Bec, Quintana Roo, Mexico
  • OHJA
    Andrews Forest and vicinity Reference Stands
  • PPGY
    Ponderosa Pine Growth and Yield Study
  • RMRS
    Rocky Mountain Reference Stands
  • SQNP
    Sequoia National Park Reference Stands
  • BABA
    BA=Bayandaiskii lekhoz (forest management enterprise); BA=Bayandaevskoe Lesnichestvo (ranger station
  • NZUD
    Nizhneudinsk, Russia
  • OLKO
    OL=Ol'khonskii leskhoz; KO=Kosostepskoe lesnichestvo
  • STIL
    ST=Shestakovskii leskhoz (forest management entermprise); IL=Ilimskoe Lesnichestvo (ranger station)
  • BTKL
    BT=Bystrinskii leskhoz (fme); KL=Kliuchevskoe lesnichestvo (ranger station)
  • KHKF
    KH=Khorskii leskhoz; KF=Kafenskoe lesnichestvo
  • KHKT
    KH=Khorskii leskhoz; KT=Katenskoe lesnichestvo
  • KHLA
    Kh=khorskii leskhoz; LA=Lazovskoe lesnichestvo
  • KHLZ
    Khabarovskii leskhoz (forest management enterprise), Russia
  • ULBR
    UL=Ul'chskii leskhoz; BR=Bogorodskoe lesnichestvo
  • BGKB
    BG=Boguchanskii leskhoz (fme); karabul'skoe lesnichestvo (ranger station)
  • CHCH
    CH=Chunskii leskhoz (forest management enterprise); CH=Chunoyarskoe Lesnichestvo (ranger station)
  • CHKH
    CH=Chunskii leskhoz (fme); khozhenskoe lesnichestvo (ranger station)
  • CHTA
    CH=Chunskii leskhoz (fme); takuchetskoe lesnichestvo (ranger station)
  • EMKE
    EM=Emel'yanovskii leskhoz (fme); ke=kemchugskoe lesnichestvo
  • POPO
    PO=Podol'skii leskhoz; podol'skoe lesnichestvo
  • PZMA
    Pizhma village, Russia
  • BERD
    Berdskii leskhoz (forest management enterprise)
  • MIMI
    MI=Mirnovskii leskhoz; MI=Mirnovskoe lesnichestvo
  • NSIB
    Novosibirsk, Russia
  • BEKZ
    BE=Beloyarskii leskhoz (forest management enterprise); KZ= Kazymskoe Lesnichestvo (ranger station)
  • KART
    Kartashevka, Russia
  • KOBN
    Korbona, Russia
  • LYSI
    Lysino, Russia
  • NOVG
    Novgorod, Russia
  • VRZA
    Viritza, Russia
  • KRD
    Kalamath r.d., Winema National Forest
PLOT - char(10) (nominal)

ID: TD02208.PLOT

Arbitrary site number associated with cwd piece.

Type system: Microsoft SQL Server 2008

YEAR - numeric(4,0) (ratio)

ID: TD02208.YEAR

Year the sample collection took place

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

NUMBER - char(5) (nominal)

ID: TD02208.NUMBER

Identifying code/number of CWD piece

Type system: Microsoft SQL Server 2008

NEEDLES - char(1) (nominal)

ID: TD02208.NEEDLES

Is foliage (leaves or needles) present? y=yes n=no

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
TWIGS - char(1) (nominal)

ID: TD02208.TWIGS

Are twigs present?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
BRANCHES - char(1) (nominal)

ID: TD02208.BRANCHES

Are branches present?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
BARKBR - char(1) (nominal)

ID: TD02208.BARKBR

Is bark still on the branches?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
BARKBOLE - char(1) (nominal)

ID: TD02208.BARKBOLE

Is bark still on the bole?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
SAPSLOUGH - char(1) (nominal)

ID: TD02208.SAPSLOUGH

Is sapwood sloughing off the bole?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
COLLAPSE - char(1) (nominal)

ID: TD02208.COLLAPSE

Is the log collasping and unable to support its own weight?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
SCATTER - char(1) (nominal)

ID: TD02208.SCATTER

Is the log scattered over surface and ellpitical in cross-section?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
CONKS - char(1) (nominal)

ID: TD02208.CONKS

Are there fungal conks present?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
MOSS - char(1) (nominal)

ID: TD02208.MOSS

Is there moss cover present?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
LICHENS - char(1) (nominal)

ID: TD02208.LICHENS

Is there lichen cover present?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
ANTS - char(1) (nominal)

ID: TD02208.ANTS

Is there evidence of carpenter ants present? best evidence is from cutting into the log

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
TERMITES - char(1) (nominal)

ID: TD02208.TERMITES

Is there evidence of termites present? best evidence is from cutting into the log

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
BEETLES - char(1) (nominal)

ID: TD02208.BEETLES

Is there evidence of bark beetles present? best evidence is from underside of bark or wood surface of the log

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
BEARS - char(1) (nominal)

ID: TD02208.BEARS

Is there evidence of bears have been ripping open logs?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
BROWNROT - char(1) (nominal)

ID: TD02208.BROWNROT

Is there cubical brown rot present?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
WHITEROT - char(1) (nominal)

ID: TD02208.WHITEROT

Is there white rot present?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
SAPFRIAB - char(1) (nominal)

ID: TD02208.SAPFRIAB

Is the sapwood friable? crushed by hand?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
HWFRIAB - char(1) (nominal)

ID: TD02208.HWFRIAB

Is the heartwood friable? crushed by hand?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
CASEHARD - char(1) (nominal)

ID: TD02208.CASEHARD

Is there casehardening of the outer wood? wood takes on a bleached look and is solid

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
STUBSMOV - char(1) (nominal)

ID: TD02208.STUBSMOV

Can you move the branch subs sticking out of the log by hand? this indicates wood is rotten to the center

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
WOODBORER - char(1) (nominal)

ID: TD02208.WOODBORER

Woodborers present?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes
  • N
    No
SAMPLEDATE - date (dateTime)

ID: TD02208.SAMPLEDATE

Date the sample collection took place

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

Units
number of years years time nominalYear second 31536000 one year excluding leap seconds and leap days, 31536000 seconds (often used for age in years)
meters m length meter meter 1 meter; SI unit of length
square centimeters cm2 area centimeterSquare meterSquared 0.0001 square centimeters
grams per cubic centimeter g/cm3 massDensity gramPerCentimeterCubed kilogramPerMeterCubed 1000 grams per cubic centimeter
grams g mass gram kilogram 0.001 grams; 0.001 kilogram
parts per million ppm massDensity partsPerMillion kilogramPerMeterCubed 0.001 parts per million
day of month day datetime number YYYY-MM-DDThh:mm:ss N/A day of month
month of year month datetime MM YYYY-MM-DDThh:mm:ss N/A month of year (MM)
cubic centimeters cm3 volume centimeterCubed meterCubed 0.000001 cubic centimeters
centimeters cm length centimeter meter 0.01 centimeters; .01 meters
percent % dimensionless number dimensionless 100 percent; a number
millimeters mm length millimeter meter 0.001 millimeters; .001 meters
year (yyyy) YYYY datetime YYYY YYYY-MM-DDThh:mm:ss N/A year (4 character) portion of date
number number dimensionless number dimensionless 1 dimensionless number, i.e., ratio, count
Intellectual Rights

Data Use Agreement:

The re-use of scientific data has the potential to greatly increase communication, collaboration and synthesis within and among disciplines, and thus is fostered, supported and encouraged. This Data Set is released under the Creative Commons license CC BY "Attribution" (see: https://creativecommons.org/licenses/by/4.0/). Creative Commons license CC BY - Attribution is a license that allows others to distribute, remix, tweak, and build upon your work (even commercially), as long as you are credited for the original creation. This license accommodates maximum dissemination and use of licensed materials.

It is considered professional conduct and an ethical obligation to acknowledge the work of other scientists. The Data User is asked to provide attribution of the original work if this data package is shared in whole or by individual parts or used in the derivation of other products. A recommended citation is provided for each Data Set in the Andrews LTER data catalog (see: http://andlter.forestry.oregonstate.edu/data/catalog/datacatalog.aspx). A generic citation is also provided for this Data Set on the website https://portal.edirepository.org in the summary metadata page. Data Users are thus strongly encouraged to consider consultation, collaboration and/or co-authorship with the Data Set Creator.

While substantial efforts are made to ensure the accuracy of data and associated documentation, complete accuracy of data sets cannot be guaranteed and all data are made available "as is." The Data User should be aware, however, that data are updated periodically and it is the responsibility of the Data User to check for new versions of the data. The data authors and the repository where these data were obtained shall not be liable for damages resulting from any use or misinterpretation of the data.

General acknowledgement: Data were provided by the HJ Andrews Experimental Forest research program, funded by the National Science Foundation's Long-Term Ecological Research Program (DEB 2025755), US Forest Service Pacific Northwest Research Station, and Oregon State University.

Licensed

License: N/A

Maintenance

Maintenance update frequency: irregular

Description

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

Change History

  • Version2 (1990-01-01)
    Original metadata creation
  • Version1 (2007-08-14)
    The data were started to be collected in 1982. The current files were started in 1990 as part of an effort to make collection of this type of data systematic. The abstract will need to be updated as new sites are added to the files.
  • Version3 (2007-08-14)
    Moved database to SQL server
  • Version4 (2007-10-09)
    Removed data access restriction per request of metadata contact person.
  • Version7 (2018-09-20)
    Updated all entities in database. Created sampledate out of year, month, day. Created place domain out of enumberated stand. Cannot make plot (freetex) a place domain because it is a mix of places and numbers. There were also null values. Created new plot codes by including stand with an underscore for the numbered plots, using stand where null, and leaving the actual place named plots alone. Created taxonomic domain out of enumerated species. Ran QC, recreated data structures and appended modified data. Removed entity 5 from online because there is no data. Created an entity 9, offline, to store old enumerations.