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

TD014: Long-term log decay experiments at the Andrews Experimental Forest, 1985 to 2185

← Back to catalog index

Go to Data Downloads Download Metadata Text (.txt) View Metadata in Browser (HTML) Download Metadata CSV (ZIP)

Status: irregular
Period: 1985-03-26 to 2016-08-24
Version: 10
Published: 2018-06-13
EDI Package ID: knb-lter-and.4053.10
Source XML: TD014_10.xml

Notice

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

Citation

Franklin, J.; Harmon, M. 2018. Long-term log decay experiments at the Andrews Experimental Forest, 1985 to 2185 Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/TD014 Accessed 2026-05-10.

Abstract

These data are collected from six sites within the H. J. Experimental Forest and are part of a 200-year experiment on the decomposition of logs in a terrestrial environment. The taxa being examined in the experiment are Douglas-fir, western hemlock, western redcedar, and Pacific silver fir. The data start in 1985 and are periodically updated as samples are taken. The last collection of data is planned in 2185. Periodically logs are sampled by measuring their diameters and lengths as well as bark cover and the fraction of their length in contact with the ground. Cross-sections are removed with a chainsaw and dissected with a table saw or other means to determine the density of bark and wood samples. These samples systematically sample each cross-section and can be used to reconstruct the spatial pattern of decomposition. Subsamples are ground and nutrient concentrations are determined to calculate nutrient stores. Twenty one data tables are associated with this study. A general description of the logs (length, diameters, bark cover) is found in td01401 and can be used to estimate how the log has fragmented over time. The areal extent of tissue types (outer bark, inner bark, sapwood, and heartwood) and zones of rotten wood from cross-sections is documented in td01418 and td01419. The position of the pith in each cross-section, a useful indicator of volume loss, is documented in td01420. The density (dry mass/green volume) of samples is documented in td01403 and based on the weights of individual samples (td01404) as well as their dimensions (td01405). The arrangement of samples into transects (top to bottom, left to right) within the cross-sections is documented in td01406. To help explain why some samples may be more dense than others, the area of the sample cross-section covered by knots is documented in td01407 (knots are more decay resistant and of greater density than wood). The radial thickness of inner and outer bark of the undecayed logs is documented in td01409, and can be used to estimate the original thickness of these tissues once extensive decomposition occurs. Given that the outer bark can be quite irregular in shape, water displacement was used to determine the volume of this tissue; these data are documented in td01415. The location of the logs at the six sites is stored in td01413, with distances, slope, and bearing from a series of surveyed posts noted. The cell wall chemistry of samples has been analyzed using the proximate method described by Ryan et al. (td01408) and Van Soest (td01412). The number and type of insect galleries present on logs for the first three years is documented in td01410. The number and species of fungal sporocarps growing on logs in the autumn for the first eight years is documented in td01414. Concentrations of nutrient elements such as nitrogen, phosphorus, calcium, and potassium of dried, ground samples of inner and outer bark, sapwood, and heartwood, as well as fungal sporocarps and insects is stored in td01411. Parameters for regression models derived from these data that describe the temporal pattern of decomposition is stored in td01421.

Coverage

Temporal coverage: 1985-03-26 to 2016-08-24

Geographic coverage: H. J. Andrews Experimental Forest. Pacific Northwest/Oregon Cascades.

Spatial coverage:

Bounds: W -122.26172200, E -122.10084700, N 44.28196400, S 44.19770400

Purpose
  • The experiment that generated these data is designed to test the effect of species of log, tissue type, soil contact, insects, and diameter on the rate of log decomposition and release of nutrients of logs (large, downed and dead wood and bark).
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: Abstractor
    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
  • Jack Booth
    Role: Other Researcher
  • John Moreau
    Role: Other Researcher
    H.J. Andrews Experimental Forest;Box 300, Blue River, OR, 97413, USA
    Email: moreauj@fsl.orst.edu
  • Timothy D. Schowalter
    Role: Other Researcher
    Department of Entomology;404 Life Sciences Bldg.;Louisiana State University, Baton Rouge, LA, 70803, USA
    Phone: (225) 578-1628
    Email: tschowalter@agcenter.lsu.edu
  • John D. Lattin
    Role: Other Researcher
    Corvallis, OR, 97333, USA
  • Rick G. Kelsey
    Role: Other Researcher
    USDA Forest Service;Pacific NW ResearchStation;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Email: Rick.Kelsey@oregonstate.edu
  • Elaine R. Ingham
    Role: Other Researcher
    Oregon State University;Botany & Plant Path;Cordley 2066, Corvallis, OR, 97331, USA
    Phone: 541-752-5066
    Email: elaine@environmentcelebration.com
  • Jerry F. Franklin
    Role: Creator
    University of Washington;College of Forest Resources;Box 352100, Seattle, WA, 98195-2100, USA
    Phone: (206) 543-2138
    Email: jff@u.washington.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 are collected from six sites within the H. J. Experimental Forest and are part of a 200-year experiment on the decomposition of logs in a terrestrial environment. The taxa being examined in the experiment are Douglas-fir, western hemlock, western redcedar, and Pacific silver fir. The data start in 1985 and are periodically updated as samples are taken. The last collection of data is planned in 2185. Periodically logs are sampled by measuring their diameters and lengths as well as bark cover and the fraction of their length in contact with the ground. Cross-sections are removed with a chainsaw and dissected with a table saw or other means to determine the density of bark and wood samples. These samples systematically sample each cross-section and can be used to reconstruct the spatial pattern of decomposition. Subsamples are ground and nutrient concentrations are determined to calculate nutrient stores. Twenty one data tables are associated with this study. A general description of the logs (length, diameters, bark cover) is found in td01401 and can be used to estimate how the log has fragmented over time. The areal extent of tissue types (outer bark, inner bark, sapwood, and heartwood) and zones of rotten wood from cross-sections is documented in td01418 and td01419. The position of the pith in each cross-section, a useful indicator of volume loss, is documented in td01420. The density (dry mass/green volume) of samples is documented in td01403 and based on the weights of individual samples (td01404) as well as their dimensions (td01405). The arrangement of samples into transects (top to bottom, left to right) within the cross-sections is documented in td01406. To help explain why some samples may be more dense than others, the area of the sample cross-section covered by knots is documented in td01407 (knots are more decay resistant and of greater density than wood). The radial thickness of inner and outer bark of the undecayed logs is documented in td01409, and can be used to estimate the original thickness of these tissues once extensive decomposition occurs. Given that the outer bark can be quite irregular in shape, water displacement was used to determine the volume of this tissue; these data are documented in td01415. The location of the logs at the six sites is stored in td01413, with distances, slope, and bearing from a series of surveyed posts noted. The cell wall chemistry of samples has been analyzed using the proximate method described by Ryan et al. (td01408) and Van Soest (td01412). The number and type of insect galleries present on logs for the first three years is documented in td01410. The number and species of fungal sporocarps growing on logs in the autumn for the first eight years is documented in td01414. Concentrations of nutrient elements such as nitrogen, phosphorus, calcium, and potassium of dried, ground samples of inner and outer bark, sapwood, and heartwood, as well as fungal sporocarps and insects is stored in td01411. Parameters for regression models derived from these data that describe the temporal pattern of decomposition is stored in td01421. The experiment that generated these data is designed to test the effect of species of log, tissue type, soil contact, insects, and diameter on the rate of log decomposition and release of nutrients of logs (large, downed and dead wood and bark). Field Methods - TD014

Purpose: The experiment that generated these data is designed to test the effect of species of log, tissue type, soil contact, insects, and diameter on the rate of log decomposition and release of nutrients of logs (large, downed and dead wood and bark).

Methods

Method Steps

Field Methods - TD014
  • Logs of the four species used in the experiments were removed from four locations during September 1985. Low- standard access roads were constructed at each site during July and August 1985 to place the logs and then the roads were closed. Logs were placed on either side of the access roads after the 50 m point to reduce the microclimatic effects of stand edge on the experiment. To reduce the effects of road work on the stand, trees were not felled unless the road could not avoid them. Saving old-growth trees and large snags was given priority over saving small trees. Wherever possible, preexisting skidding roads were used. Logs crossing the road were removed so that a minimum of damage to the logs and soil occurred. The logs used in the experiment met specifications for diameter, length, amount of bark cover, and degree of decay. Logs that ranged in diameter between 45 and 60 cm over their length were deemed suitable. The final log length at the experimental sites was 5.5 m. Damage to the bark during the yarding, transport, and placement was minimized; however, logs with more than 10 percent of their bark missing were considered unsuitable. Logs with large decay columns, conks, or both were rejected. Logs were transported to the experimental sites on short-bed logging trucks and placed along the access road by mobile loader. Enough logs of each species were placed so that destructive samples could be made at least 18 times after placement--a total of 530 logs.
  • Invertebrates were excluded in a subsample of logs by placing them onto polyester mesh and then building an A- frame over the log. The frame was then covered with 0.8-mm polyester mesh. One-half of the exclosure length was also covered with a 0.1-mm mesh to exclude small insects, such as ambrosia beetles.
  • The logs were sampled in 1985 to determine the initial characteristics of each log. After that point subsets of logs were sampled to determine how their characteristics change over time. In some cases logs were resampled so as to preserve intact logs for future study. While methods have been standardized over time to the degree possible, the fact that logs are decomposing and changing also means that some of the methods have to change so that comparable data can be collected.
  • Bark coverage, length, and diameters were measured to characterize the initial condition of each log. The total area of bark missing was measured to the nearest 0.01 m using a gridded 20- by 50-cm metal frame. Diameter was measured at both ends and the middle of the log by using calipers. The maximum and minimum diameters were measured at each point to calculate the mean diameter. Log length was measured to the nearest 1 cm and represented a mean length when the ends were not cut parallel. The total length of the log suspended off the ground was measured to the nearest 0.1 m. The number of freshly cut branches was counted on each log to indicate if the log was from the bole or the crown of a tree. Log volume was calculated using Newton's formula:
  • V=L (A+4A+A)/6
  • where V is the volume, L is the length, and A, A, and A are the area of the base, midpoint, and top of the log. Surface area was calculated assuming the logs were frustrums of cones.
  • After 1985 these measurements were repeated with the exception that diameter measurements were also taken at the point where cross-sections were removed. In some cases diameter was estimated from digitized photographs of the cross-sections. Because the missing bark area increased as the logs decomposed, the length and width of missing bark sections was hand measured because using the original metal frame was not practical.
  • To characterize initial density, moisture content, and volume of tissue in each log, a cross-section 8 to 10-cm thick was removed from each end. All cross-sections were wrapped in black plastic bags and stored at 2°C until they were processed. The cross-sections were photographed and these were digitized to estimate the volume of outer bark, inner bark, sapwood, and heartwood.
  • The logs that were sampled after 1985 were determined randomly by drawing from the list of available logs.
  • To characterize how density, moisture content, and volume of tissue in each log changed after 1985, five 8 to 10-cm thick cross-sections, spaced out at roughly equal intervals were removed from each sampled log. The diameter of each cross-section and its location relative to the large end was measured. For some year logs that had already been sampled were resampled to increase the temporal resolution of changes. In this case two of the cut segments that remained after the initial sampling had cross-sections removed from their center. The time between the initial sampling and the resampling was kept to a minimum to reduce the effects of decomposer colonization from the cut ends. As the logs decomposed some became weak enough that cross-sections could not be removed without additional support. Bark was kept on the cross-section by initially using canvas strips, then duct tape, and finally cardboard wrapped with saran wrap. In addition cross-sections that were too weak to be carried without breaking were placed on octagonal plywood backer boards. To reduce movement the cross-sections were saran wrapped onto the backer boards. All cross-sections were placed in a black plastic trash bag and stored in refrigeration until they were processed.
Permanent Plots - TD014
  • A map indicating the position of logs at each site was prepared to aid relocation (maps on file in RWU- 4356, Forest Science Laboratory, Corvallis, OR). Each log was marked with an aluminum numbered tag nailed at the top of each end. The position of fiberglass t-posts along each access road were surveyed using by a jacobs staff, compass, fiberglass tape, and clinometer. Backsight measurements were made at each position. The distance, compass bearing, and slope of each log was surveyed from the nearest fiberglass t-post.
Laboratory Methods - TD014
  • Processing of the cross-sections included many measurements to characterize density, moisture content, and volume of tissue and extent of decay.
  • The cross-sections were photographed and these images were digitized to estimate the volume of outer bark, inner bark, sapwood, and heartwood. To aid identification of tissues and zones of decay, the different zones on cross-sections were marked with different colored pens. The initial digitizing system used slides that were back projected onto an opaque digitizing pad. The programs used to determine the areas was vector-based and while it could determine the areas of the various tissues and decay zones for the first three years, as the decay patterns became more and more complex, it became impossible to use and accurately determine areas. In 2016-2017 an alternative system based on pixels was used instead. In this case the slides were scanned and analyzed using the Image-J software. The first step in the Image-J process was to calibrate the linear horizontal distance on the image using the scale on the photo to determine how many pixels were in 70 cm. The total area of the cross-section was determined by digitizing the outermost boundary and selecting the area inside the boundary to determine its area using the threshold function. When bark was missing due to cross-section handling, the distance between the outmost bark and the wood was estimated. When bark had fallen off due to natural processes, the outermost boundary used was that of the wood. The next area to be determined was that of total wood by digitizing along the bark-wood boundary. When sapwood was missing due to handling the outer wood area was also estimated using the remaining sapwood. The heartwood area was then determined by digitizing along the sapwood-heartwood boundaries indicated on the images that had been marked with magic markers prior to the photography. In cases in which the sapwood-heartwood boundary was not marked on the image (typically ABAM and TSHE in advanced stages of decomposition) the average thickness of the sapwood on the undecayed initial samples was used to approximate the boundary. The area blue-stained by fungi was determined using the threshold function to identify darker areas of sapwood. This threshold was determined by comparing areas that clearly had blue-stain with the areas meeting the threshold; however soil contamination, bark dust, shadows, and other non-blue-stain processes could make the sapwood appear dark. It is therefore not a very reliable indicator of the area with blue-stain and might be considered more of a qualitative index as to whether blue-stain was present or not. The boundary of all the wood with decay was digitized and the area of each decayed zone was summed when there was more than one zone. This process was repeated for the heartwood to determine the area of heartwood that was decayed. These are all general methods, the exact method of digitizing, order of digitizing, creation of intermediate images (e.g., wood area or heartwood area) for further processing depended on the arrangement of the decay patterns found in a cross-section.
  • In addition, the following areas could be determined from these primary measurements: The bark area was determined by subtracting the wood area from the total area. The sapwood area was the difference between the total wood area and the heartwood area. The area of decayed sapwood was determined as the difference between the total area of decayed wood minus the area of decayed heartwood. The diameter was estimated from the total area assuming that the area was a circle (often it was elliptical).
  • The area of outer versus inner bark was initially calculated using the inner bark thickness measurements and the wood diameter based on the outermost wood surface. As it became more difficult to measure the inner bark thickness due to decay, the area of each bark tissue was estimated using the initial proportions of outer versus inner bark and applying that to the total bark area. This assumes that when outer bark is lost from the circumference, that inner bark is lost as well. Based on observations, this assumption conforms to how bark is typically lost during the decomposition process.
  • For the 1985-2005 period wood density was sampled radially along a series of transects along a cross-section that went from the top to the bottom through the center, and the two sides to the center. Rectangular blocks of wood were rough-cut to create these transects by chainsaw forming an X-pattern. One of the blocks sampled in the vertical direction and two shorter blocks were used to sample in the horizontal direction. Portions of the cross-section with large knots were avoided when possible. A table saw was used to trim the blocks to precise cross-sectional area (75 by 50 mm), and then smaller blocks were cut--either 25 mm or 38 mm wide in the radial dimension. The prepared blocks were categorized by sapwood, mixed, or heartwood types. Samples were identified as to type, log number, end, and piece by bar- code labels. All subsequent measurements (weight and dimensions) were referenced to these labels by microcomputer and a bar code reader. The volume of knots within each block was visually estimated by checking against prepared standards.
  • For the 2015 sampling cross-sections were sampled using two different methods as the log cross-sections had become decayed enough that it was not safe to cut them on a table saw. The first method was similar to the radial sampling in that bark and wood samples were removed from the top, bottom, and sides of the cross-sections. However, only one sample was removed for bark, sapwood, and heartwood per “transect”. The bark samples were combined into one sample and inner and outer bark were separated. The wood samples were kept separate for each transect and represented a physical average. The sapwood sample was generally rectangular in shape; the heartwood sample was a triangle centered on the pith (if it was visible). The dimensions, wet and dry weights of these samples were determined as in earlier years of processing. The second method used anticipated the method that will likely have to be used when the logs become extremely decayed. In this method each layer of tissue (outer bark, inner bark, sapwood, and heartwood ) is sampled as a series of concentric rings that are separated and weighed. For each ring of tissue the diameter, longitudinal thickness, and total wet weight was determined. When fragmentation removed a portion of the ring (typically for bark), the circumferential length of the tissue was measured as well as the radial and longitudinal length, and the total wet weight of the ring of tissue. Dry weights for the entire cross-section were determined by adjusting the wet weight using the moisture content of the samples removed in the first sampling.
  • The radial, longitudinal, and tangential dimensions were measured to the nearest 0.1 mm with calipers for samples removed from each cross- section cut. For samples removed radially along a transect, a polynomial relationship was found that could be used to estimate the cross-sectional area at any point to within 1.8 percent of the actual value by using the cross- sectional area at both ends and the middle. The tangential and longitudinal dimensions at both ends and the middle were used to parameterize this relationship for each cross- section.
  • The weight of each block or sample before and after oven drying was determined to the nearest 0.01 g by using an electronic digital balance linked to a microcomputer. Oven drying was generally at 55°C for seven days or until the dry weight stabilized.
  • After recording the thickness at four points of each cross-section, the outer and inner bark were also sampled for density and moisture content for each cross-section typically by removing subsamples from the top, side, and bottom that were then combined into one sample. Each subsample of bark was 20- to 30-cm length of the circumference. The radial, longitudinal, and tangential dimensions of these pieces were recorded. For radial dimensions, at least six measurements were made to give a reasonable average.
  • As decomposition proceeded it became difficult to measure some tissue thicknesses directly. In the case of inner bark extensive decomposition lead to a collapse of this tissue. Therefore the initial thickness measurements from 1985 were used instead. For sapwood, either fragmentation, complete decomposition, or decay obscured the sapwood-heartwood boundary. The initial thickness of sapwood in 1985 for a log was used to determine the approximate thickness of sapwood samples. The latter method was used extensively in 2015 for both Pacific silver fir, western redcedar, and western hemlock. For the first two species sapwood was often missing. For western hemlock the sapwood-heartwood boundary was not always obvious.
  • Outer and inner bark were separated by chisel for all species, except Pacific silver fir. The weight of each bark sample before and after oven drying was determined to the nearest 0.01 g using an electronic digital balance linked to microcomputer. Oven drying was at 55°C for seven days. Previously oven dried outer bark samples were soaked in water 48 hours, and then volume was measured to the nearest 1 cm3 by water displacement. This method was the preferred one to determine volume for density calculations. It was found that the irregular shape of the outer bark surface made volume estimates from dimensions highly uncertain.
  • Moisture content, calculated from the weight before and after oven drying, was expressed as a percentage of oven dry weight. Density was calculated as oven dry weight over green volume. For outer bark samples, volume was based on water displacement; for other tissues it was based on dimensional analysis for both the individual sample and the ring-based sampling methods.
  • In 1985 each tissue type was sampled from a subset of 10 logs of each species for nutrient content and cell wall carbon chemistry (that is, lignin, cellulose, acid detergent fiber). After 1985 samples were taken from each log that was processed. In 1985 a separate set of bark subsamples was removed and stored frozen until processing. In 1985 sapwood and heartwood samples were removed from the oven dried pieces as were inner bark, sapwood, and heartwood after that period. Outer bark samples after 1985 were taken from samples that were dried, but not used in the water displacement determination of volume.
  • All tissues were first coarse ground, and then fine ground with a Wiley mill to pass a 40-mesh screen. Nitrogen content was measured using microKjeldahl digestion. Concentration of assorted elements--including calcium, copper, iron, potassium, magnesium, manganese, phosphorus, sulfur, and zinc--were measured by inductively coupled argon spectroscopy. Acid detergent fiber, permanganate lignin, and cellulose were measured using the procedures of Goering and Van Soest (1970). Unextracted material was used for these analyses.

Sampling

Study Extent
  • For details see http://andrewsforest.oregonstate.edu/data/studies/td014/td014_sitedescription.pdf
  • Sampling frequency: incrementally
Sampling Description
  • The experiments are being conducted at six sites located within intact old-growth Douglas-fir-western hemlock forests. The experimental design is a split-split plot in time. Each site represents a block, and log species is the main plot effect. Substrate layer (that is, inner bark, outer bark, sapwood, and heartwood) is the subplot effect. Logs were sampled (or in some cases) resampled annually for first 5 years, and then sampled at 2, 4 and 10 year intervals. This allows for a greater temporal resolution initially, but decreases the resolution as time passes and decomposition slows allowing for long-term patterns to be seen.
Spatial Sampling Units
  • Andrews Experimental Forest (HJA)
    W -122.26172200, E -122.10084700, N 44.28196400, S 44.19770400
    Altitude: 1631 to 1631 meter
  • H.J. Andrews Log decomp sites
    W -122.22958280, E -122.12612610, N 44.26604506, S 44.22808159
    Altitude: 965 to 965 meter
  • H.J. Andrews Log decomp site 1
    W -122.17043111, E -122.17043111, N 44.26604506, S 44.26604506
    Altitude: 965 to 965 meter
  • 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 3
    W -122.22958283, E -122.22958283, N 44.23111015, S 44.23111015
    Altitude: 539 to 539 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
  • H.J. Andrews Log decomp site 5
    W -122.14464099, E -122.14464099, N 44.24212614, S 44.24212614
    Altitude: 961 to 961 meter
  • H.J. Andrews Log decomp site 6
    W -122.12612613, E -122.12612613, N 44.22852991, S 44.22852991
    Altitude: 949 to 949 meter
  • All LIDET sites
    W -149.56666660, E -65.81666660, N 68.63333330, S 9.16666660
  • Coweeta Hydrologic Laboratory LIDET site
    W -83.50000000, E -83.50000000, N 35.00000000, S 35.00000000
    Altitude: 700 to 700 meter
  • Cedar Creek Natural History Area, Minnesota LIDET site
    W -93.20000000, E -93.20000000, N 45.40000000, S 45.40000000
    Altitude: 230 to 230 meter
  • Konza Prairie Research Natural Area, Kansas LIDET site
    W -96.58333333, E -96.58333333, N 39.08333333, S 39.08333333
    Altitude: 366 to 366 meter
  • H.J. Andrews Log decomp site 0
    W -122.22958280, E -122.12612610, N 44.26604506, S 44.22808159
    Altitude: 965 to 965 meter
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: decay rates (theme), decomposition (theme), nutrient cycling (theme), inorganic nutrients (theme), nutrients (theme), woody debris (theme), coarse woody debris (theme), organic matter (theme), invertebrates (theme), logs (theme)
  • LTER core research areas: inorganic nutrients (theme), organic matter (theme)
Taxonomic Hierarchy
  • All Organisms: All Organisms
  • Highest common category (ca. kingdom): Fungi
  • Genus: Phlebia
  • Species: Phlebia tremellosus
  • Genus: Nidularia
  • Species: Nidularia candida
  • Genus: Dacrymyces
  • Species: Dacrymyces palmatus
  • Division or Phylum: Basidiomycota
  • Division or Phylum: Basidiomycetes
  • Order: Hymenochaetales
  • Family: Schizoporaceae
  • Genus: Oxyporus
  • Order: Agaricales
  • Family: Strophariaceae
  • Genus: Naematoloma
  • Species: Naematoloma capnoides
  • Order: Polyporales
  • Family: Fomitopsidaceae
  • Genus: Fomitopsis
  • Species: Fomitopsis pinicola
  • Species: Fomitopsis pinicola, dead
  • Family: Polyporaceae
  • Genus: Polyporus
  • Species: Polyporus versicolor
  • Order: Boletales
  • Family: Boletaceae
  • Genus: Boletus
  • Species: Boletus mirabilis
  • Species: Boletus mirabiles
  • Genus: Ganoderma
  • Species: Ganoderma applanatum
  • Genus: Mycena
  • Species: Mycena epiterygia
  • Species: Mycena occidentalis
  • Genus: Agaric
  • Genus: Pholiata
  • Species: Pholiata lenta
  • Genus: Hericium
  • Species: Hericium abietes
  • Highest common category (ca. kingdom): Plantae
  • Division or Phylum: Coniferophyta
  • Class: Pinopsida
  • Order: Pinales
  • Family: Cupressaceae
  • Genus: Thuja
  • Species: Thuja plicata
  • Family: Pinaceae
  • Genus: Pseudotsuga
  • Species: Pseudotsuga menziesii
  • Species: Pseudotsuga menziesii hardwood; wood standard
  • Genus: Abies
  • Species: Abies amabilis
  • Genus: Tsuga
  • Species: Tsuga heterophylla
  • Division or Phylum: Magnoliophyta
  • Class: Magnoliopsida
  • Subclass: Hamamelididae
  • Order: Fagales
  • Family: Fagaceae
  • Genus: Quercus
  • Highest common category (ca. kingdom): Animalia
  • Division or Phylum: Arthropoda
  • Class: Insecta
  • Order: Coleoptera
  • Family: Cerambycidae
  • Genus: Rhagium
  • Family: Elateridae
  • Genus: Ampedus
  • Genus: Alaus
  • Species: Alaus melanops
  • Family: Buprestidae
  • Genus: Buprestis
  • Species: Buprestis rusticorum
  • Species: Buprestis aurulenta
  • Family: Scolytidae
  • Genus: Dendroctonus
  • Family: Cleridae
  • Genus: Thanasimus
  • Family: Non-taxonomic objects (vegetative, organic, or inorganic)
  • Species: Tree knot
  • Species: unknown plant
  • Species: unknown plant 1
  • Species: unknown
Data Entities
# Entity Metadata Data
1 TD01401
TD01401
Whole Log Descriptions: A general description of the logs (length, diameters, bark cover); used to estimate how the log has fragmented over time
 METADATA DATA
2 TD01403
TD01403
Sample volume, moisture, and density:
 METADATA DATA
3 TD01404
TD01404
Sample Wet and Dry Weights:
 METADATA DATA
4 TD01405
TD01405
Wood and Bark Sample Outer Dimensions:
 METADATA DATA
5 TD01406
TD01406
Block and Sample Arrangement in Cross-sections: The arrangement of samples into transects (top to bottom, left to right)
 METADATA DATA
6 TD01407
TD01407
Knot Volume Correction Estimate for Wood Samples:
 METADATA DATA
7 TD01408
TD01408
Ryan et al Cell Wall Chemistry of Bark and Wood Samples:
 METADATA DATA
8 TD01409
TD01409
Radial Bark Thickness: The radial thickness of inner and outer bark of the undecayed logs
 METADATA DATA
9 TD01410
TD01410
Insect Galleries:
 METADATA DATA
10 TD01411
TD01411
Nutrient Content of Bark, Wood, Fungal, and Insect Samples:
 METADATA DATA
11 TD01412
TD01412
Van Soest Cell Wall Chemistry of Wood and Bark Samples:
 METADATA DATA
12 TD01413
TD01413
Log Location Survey Notes: Used to Produce Maps
 METADATA DATA
13 TD01414
TD01414
Sporocarp Counts from Logs:
 METADATA DATA
14 TD01415
TD01415
Bark Sample Volumes from Water Displacement:
 METADATA DATA
15 TD01416
TD01416
Entire cross-section method: data for tissue dimensions, total mass, total volume, and density:
 METADATA DATA
16 TD01417
TD01417
Entire cross-section method: data for subsample dimensions, mass, and density:
 METADATA DATA
17 TD01418
TD01418
Areas of sound and rotten tissues based on digitized photographic slides of cross-sections:
 METADATA DATA
18 TD01419
TD01419
Computed diameter and areas of sound and rotten tissues based on digitized photographic slides of cross-sections: Derived from digitized data (entity 18)
 METADATA DATA
19 TD01420
TD01420
Polar coordinate (distance and angle) location of pith relative to the outer surface of cross-sections: Distance and angle data for pith to external parts of cross-section. See related file: Idealized cross-section diagram
 METADATA DATA
20 TD01421
TD01421
Decomposition equation summary data:
 METADATA DATA
Metadata
TD01401 - TD01401

Object name: TD01401.csv

Records: 879

Attributes: 36

Temporal coverage: 1986-09-08 to 2016-08-24

File size: 111259 byte

Checksum (MD5): 2e492e2c29eeaf250808dbddf30263bc

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01401.LOGNUM, TD01401.TIME, TD01401.SITECODE
  • notNullConstraint: NOTNULL
    TD01401.SITE, TD01401.TREATMNT, TD01401.DBCODE, TD01401.ENTITY, TD01401.LOGNUM, TD01401.TIME, TD01401.YEAR, TD01401.SAMPLEDATE, TD01401.LOG_SPECIES, TD01401.SITECODE
Attributes (36)
DBCODE - char(5) (nominal)

ID: TD01401.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

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

SITECODE - char(10) (nominal)

ID: TD01401.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
SITE - char(1) (nominal)

ID: TD01401.SITE

Bedding site of log added to

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • code
    Sample from log at one of study sites (1-6), site unknown originally for knot samples taken from scraps pile at annual harvest
  • 4
    W of 350 road near junction of 350 and 1506
  • 3
    N of 410 road
  • 5
    SW of 354 road
  • 1
    End of 327 road
  • 6
    1506 road above 350 junction
  • 2
    End of 324 road
  • A
    All sites combined for summaries
LOGNUM - numeric(3,0) (interval)

ID: TD01401.LOGNUM

Number of log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

LOG_SPECIES - char(4) (nominal)

ID: TD01401.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
TREATMNT - char(1) (nominal)

ID: TD01401.TREATMNT

Treatment of log exclosure, inclosure or control

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • N
    Control - time series
  • J
    Jumbo - large diameter logs (>75 cm)
  • E
    Insect exclosure
TIME - numeric(3,0) (ratio)

ID: TD01401.TIME

Time log has been decaying

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TD01401.YEAR

Year of measurement; does not necessarily reflect time decaying in field

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

DIAM_END1 - numeric(5,1) (ratio)

ID: TD01401.DIAM_END1

diameter of large end of log

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

DIAM1 - numeric(4,1) (ratio)

ID: TD01401.DIAM1

diameter of first sample cut

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

DIST1 - numeric(3,1) (ratio)

ID: TD01401.DIST1

distance from large end to first sample cut

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

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

DIAM2 - numeric(4,1) (ratio)

ID: TD01401.DIAM2

diameter of second sample cut

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

DIST2 - numeric(3,1) (ratio)

ID: TD01401.DIST2

distance from large end to second sample cut

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

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

DIAM_MID - numeric(5,1) (ratio)

ID: TD01401.DIAM_MID

diameter of middle of log

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

DIST_MID - numeric(3,1) (ratio)

ID: TD01401.DIST_MID

distance to middle of log from large end

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

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

DIAM3 - numeric(4,1) (ratio)

ID: TD01401.DIAM3

diameter of third sample cut

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

DIST3 - numeric(3,1) (ratio)

ID: TD01401.DIST3

distance from large end to third sample cut

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

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

DIAM4 - numeric(5,1) (ratio)

ID: TD01401.DIAM4

diameter of fourth sample cut

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

DIST4 - numeric(3,1) (ratio)

ID: TD01401.DIST4

distance from large end to fourth sample cut

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

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

DIAM5 - numeric(5,1) (ratio)

ID: TD01401.DIAM5

diameter of fifth sample cut

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

DIST5 - numeric(3,1) (ratio)

ID: TD01401.DIST5

distance from large end to fifth sample cut

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

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

DIAM_END2 - numeric(5,1) (ratio)

ID: TD01401.DIAM_END2

diameter of smaller end of log

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

EST_DIAM - char(1) (nominal)

ID: TD01401.EST_DIAM

log diameter estimated from photo

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Log diameter was estimated from a photo
  • N
    No log diameter estimation made
LENGTH - numeric(6,2) (ratio)

ID: TD01401.LENGTH

Total log length

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

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

LENGTHUP - numeric(6,1) (ratio)

ID: TD01401.LENGTHUP

Length of log suspended off ground

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.100000

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

BARK_MISSING - numeric(6,1) (ratio)

ID: TD01401.BARK_MISSING

Cover of bark missing on log

Type system: Microsoft SQL Server 2008

Unit: square meters

Precision: 0.100000

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

ORIENT - numeric(3,0) (interval)

ID: TD01401.ORIENT

Compass orientation of log from 90 degree to 270 degree

Type system: Microsoft SQL Server 2008

Unit: degrees angle

Precision: 1.000000

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

ASPECT - numeric(3,0) (interval)

ID: TD01401.ASPECT

Aspect of ground at point of placement. used of log with respect to aspect.

Type system: Microsoft SQL Server 2008

Unit: degrees azimuth

Precision: 1.000000

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

SLOPE - numeric(3,0) (interval)

ID: TD01401.SLOPE

Inclination of the log

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1.000000

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

BRANCH - numeric(3,0) (interval)

ID: TD01401.BRANCH

Number of branches with fresh wounds.

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

VOLUME - numeric(7,4) (ratio)

ID: TD01401.VOLUME

Volume of log

Type system: Microsoft SQL Server 2008

Unit: cubic meters

Precision: 0.000100

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

SURFAREA - numeric(7,3) (ratio)

ID: TD01401.SURFAREA

Surface area of log

Type system: Microsoft SQL Server 2008

Unit: square meters

Precision: 0.001000

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

SAMPLEDATE - datetime (dateTime)

ID: TD01401.SAMPLEDATE

Date of sample processing

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

MOSS_COVER - numeric(3,0) (interval)

ID: TD01401.MOSS_COVER

percent of log covered in moss

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1

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

COMMENTS_FIELD - char(254) (nominal)

ID: TD01401.COMMENTS_FIELD

comments from field data sheets

Type system: Microsoft SQL Server 2008

TD01403 - TD01403

Object name: TD01403.csv

Records: 54695

Attributes: 26

Temporal coverage: 1985-03-26 to 2015-12-09

File size: 5746552 byte

Checksum (MD5): 1a810d967ca2353a5637c0040e77e893

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01403.SECTION, TD01403.SUBTYPE, TD01403.LOGNUM, TD01403.TIME, TD01403.SAMPLEDATE
  • notNullConstraint: NOTNULL
    TD01403.SECTION, TD01403.SUBTYPE, TD01403.DBCODE, TD01403.ENTITY, TD01403.LOGNUM, TD01403.TIME, TD01403.YEAR, TD01403.SAMPLEDATE
Attributes (26)
DBCODE - char(5) (nominal)

ID: TD01403.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

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

SITECODE - char(10) (nominal)

ID: TD01403.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
LOGNUM - numeric(3,0) (interval)

ID: TD01403.LOGNUM

Number of log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

LOG_SPECIES - char(4) (nominal)

ID: TD01403.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
SECTION - char(1) (nominal)

ID: TD01403.SECTION

Section of log

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • Y
    2nd cross-section from log remnant 1st cross-section from log remnant in 1992
  • Z
    2nd cross section from log remnant in 1992
  • 3
    Cross section from year 0, extra section
  • X
    1st cross-section from log remnant
  • A
    1st cross-section from large end 1st sample
  • 1
    Cross-section from large end of log - initial sample
  • 2
    Cross section from small end of log - initial sample
  • B
    2nd cross-section from large end 1st sample
  • D
    4th cross-section from large end 1st sample
  • C
    3rd cross-section from large end 1st sample
  • E
    5th cross-section from large end 1st sample
  • F
    6th cross-section from large end 1st sample, usually insect enclosure logs
  • G
    Partial harvest samples from 1993 full harvest logs collected in 1997
  • H
    Partial harvest samples from 1993 full harvest logs collected in 1997
TIME - numeric(3,0) (ratio)

ID: TD01403.TIME

Time log has been decaying

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TD01403.YEAR

Year of measurement; does not necessarily reflect time decaying in field

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

SUBTYPE - char(1) (nominal)

ID: TD01403.SUBTYPE

Substrate type(e.g. innerbark, heartwood)

Type system: Microsoft SQL Server 2008

Code definitions (17)
  • W
    Wood standard
  • K
    Knot wood
  • S
    Sapwood
  • E
    Heartwood near log end (terminal)
  • I
    Inner bark
  • H
    Heartwood
  • 3
    Wood standard decay class 3
  • 5
    Wood standard decay class 5
  • 1
    Pine needle nbs standard reference material # 1575
  • 2
    Wood standard decay class 2
  • M
    Mushroom or sporocarp tissues
  • O
    Outer bark
  • A
    Arthropod
  • T
    Transition between sapwood and heartwood
  • R
    Rotten wood
  • L
    Leaf sample
  • X
    Whole log in which all the bark and wood tissues are combined
SHAPE - char(1) (nominal)

ID: TD01403.SHAPE

Dimensional shape of sample taken from cross-section

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • 1
    Rectangular
  • 4
    Triangle (pie wedge)
RADPOS - numeric(2,0) (ratio)

ID: TD01403.RADPOS

Radial position of sample, for bark the number is zero.

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

D1 - numeric(5,1) (ratio)

ID: TD01403.D1

Dimension in radial direction

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 0.100000

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

D2 - numeric(6,1) (ratio)

ID: TD01403.D2

Dimension in tangential direction. If missing then volume calculated using other radial measurement (D1, D3, D4, or volume known).

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 0.100000

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

D3 - numeric(5,1) (ratio)

ID: TD01403.D3

Dimension in longitudinal direction, if missing then calculated

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 0.100000

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

D4 - numeric(4,1) (ratio)

ID: TD01403.D4

Angle, in degrees, if triangle shape

Type system: Microsoft SQL Server 2008

Unit: degrees angle

Precision: 1

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

VOL1 - numeric(5,1) (ratio)

ID: TD01403.VOL1

Volume including air voids, calculated from d1,d2,d3; if missing, d2 and d3 calculated from measurement of end and center pieces

Type system: Microsoft SQL Server 2008

Unit: milliliters

Precision: 0.100000

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

VOL2 - numeric(5,1) (ratio)

ID: TD01403.VOL2

Volume of bark measured by water displacement

Type system: Microsoft SQL Server 2008

Unit: milliliters

Precision: 0.100000

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

AIRAREA - numeric(5,1) (ratio)

ID: TD01403.AIRAREA

Area of bark in air voids, measured with a wire grid. missing after 1986

Type system: Microsoft SQL Server 2008

Unit: square millimeters

Precision: 10.000000

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

WETWT - numeric(6,2) (ratio)

ID: TD01403.WETWT

Wet weight of sample

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 0.100000

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

DRYWT - numeric(6,2) (ratio)

ID: TD01403.DRYWT

Dry weight of sample. dried 7 days at 55 degree c

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 0.100000

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

MOIST - numeric(5,1) (ratio)

ID: TD01403.MOIST

Moisture content of sample. calculated from wetwet and drywt

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.100000

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

DEN1 - numeric(5,3) (ratio)

ID: TD01403.DEN1

Density based on dry wt. and vol 1. this is apparent density including air voids

Type system: Microsoft SQL Server 2008

Unit: grams per milliliter

Precision: 0.000100

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

DEN2 - numeric(5,3) (ratio)

ID: TD01403.DEN2

Density based on dry wt. and vol2. this is actual density for bark

Type system: Microsoft SQL Server 2008

Unit: grams per milliliter

Precision: 0.000100

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

KNOTVOL - numeric(3,0) (ratio)

ID: TD01403.KNOTVOL

Volume of wood block that is knot

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1.000000

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

SAMPLEDATE - datetime (dateTime)

ID: TD01403.SAMPLEDATE

Date of sample processing

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

COMMENTS_LAB - char(254) (nominal)

ID: TD01403.COMMENTS_LAB

Comments from lab data sheets

Type system: Microsoft SQL Server 2008

TD01404 - TD01404

Object name: TD01404.csv

Records: 109568

Attributes: 13

Temporal coverage: 1985-11-25 to 2016-10-01

File size: 6971994 byte

Checksum (MD5): eb730dae7fead1b74c73e60ca03cf25e

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01404.SECTION, TD01404.SUBTYPE, TD01404.WEIGHT_TYPE, TD01404.LOGNUM, TD01404.RADPOS, TD01404.TIME, TD01404.SAMPLEDATE
  • notNullConstraint: NOTNULL
    TD01404.SECTION, TD01404.SUBTYPE, TD01404.WEIGHT_TYPE, TD01404.DBCODE, TD01404.ENTITY, TD01404.LOGNUM, TD01404.RADPOS, TD01404.TIME, TD01404.WEIGHT, TD01404.YEAR, TD01404.SAMPLEDATE
Attributes (13)
DBCODE - char(5) (nominal)

ID: TD01404.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

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

SITECODE - char(10) (nominal)

ID: TD01404.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
LOGNUM - numeric(3,0) (interval)

ID: TD01404.LOGNUM

Number of log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

LOG_SPECIES - char(4) (nominal)

ID: TD01404.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
SECTION - char(1) (nominal)

ID: TD01404.SECTION

Section of log

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • Y
    2nd cross-section from log remnant 1st cross-section from log remnant in 1992
  • Z
    2nd cross section from log remnant in 1992
  • 3
    Cross section from year 0, extra section
  • X
    1st cross-section from log remnant
  • A
    1st cross-section from large end 1st sample
  • 1
    Cross-section from large end of log - initial sample
  • 2
    Cross section from small end of log - initial sample
  • B
    2nd cross-section from large end 1st sample
  • D
    4th cross-section from large end 1st sample
  • C
    3rd cross-section from large end 1st sample
  • E
    5th cross-section from large end 1st sample
  • F
    6th cross-section from large end 1st sample, usually insect enclosure logs
  • G
    Partial harvest samples from 1993 full harvest logs collected in 1997
  • H
    Partial harvest samples from 1993 full harvest logs collected in 1997
TIME - numeric(3,0) (ratio)

ID: TD01404.TIME

Time log has been decaying

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TD01404.YEAR

Year of measurement; does not necessarily reflect time decaying in field

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

SUBTYPE - char(1) (nominal)

ID: TD01404.SUBTYPE

Substrate type(e.g. innerbark, heartwood)

Type system: Microsoft SQL Server 2008

Code definitions (17)
  • W
    Wood standard
  • K
    Knot wood
  • S
    Sapwood
  • E
    Heartwood near log end (terminal)
  • I
    Inner bark
  • H
    Heartwood
  • 3
    Wood standard decay class 3
  • 5
    Wood standard decay class 5
  • 1
    Pine needle nbs standard reference material # 1575
  • 2
    Wood standard decay class 2
  • M
    Mushroom or sporocarp tissues
  • O
    Outer bark
  • A
    Arthropod
  • T
    Transition between sapwood and heartwood
  • R
    Rotten wood
  • L
    Leaf sample
  • X
    Whole log in which all the bark and wood tissues are combined
RADPOS - numeric(2,0) (ratio)

ID: TD01404.RADPOS

Radial position of sample, for bark the number is zero.

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

WEIGHT_TYPE - char(1) (nominal)

ID: TD01404.WEIGHT_TYPE

Is sample wet weight or oven dried weight? W=wet weight D=dry weight

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • D
    Dry weight
  • W
    Wet weight
WEIGHT - numeric(7,2) (ratio)

ID: TD01404.WEIGHT

Weight of sample (either fresh or over dried. data from electronic digital scale.

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 0.100000

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

SAMPLEDATE - datetime (dateTime)

ID: TD01404.SAMPLEDATE

Date of sample processing

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TD01405 - TD01405

Object name: TD01405.csv

Records: 17625

Attributes: 21

Temporal coverage: 1985-12-11 to 2015-10-01

File size: 1424671 byte

Checksum (MD5): 90e48b9160b2e4d5a80a8f88fedccb4a

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01405.SECTION, TD01405.SUBTYPE, TD01405.LOGNUM, TD01405.RADPOS, TD01405.TIME
  • notNullConstraint: NOTNULL
    TD01405.SECTION, TD01405.SUBTYPE, TD01405.DBCODE, TD01405.ENTITY, TD01405.GD1, TD01405.GD2, TD01405.LOGNUM, TD01405.RADPOS, TD01405.TIME, TD01405.YEAR, TD01405.SAMPLEDATE, TD01405.RECTANGLE_TYPE
Attributes (21)
DBCODE - char(5) (nominal)

ID: TD01405.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

ID: TD01405.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SITECODE - char(10) (nominal)

ID: TD01405.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
LOGNUM - numeric(3,0) (interval)

ID: TD01405.LOGNUM

Number of log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

LOG_SPECIES - char(4) (nominal)

ID: TD01405.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
SECTION - char(1) (nominal)

ID: TD01405.SECTION

Section of log

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • Y
    2nd cross-section from log remnant 1st cross-section from log remnant in 1992
  • Z
    2nd cross section from log remnant in 1992
  • 3
    Cross section from year 0, extra section
  • X
    1st cross-section from log remnant
  • A
    1st cross-section from large end 1st sample
  • 1
    Cross-section from large end of log - initial sample
  • 2
    Cross section from small end of log - initial sample
  • B
    2nd cross-section from large end 1st sample
  • D
    4th cross-section from large end 1st sample
  • C
    3rd cross-section from large end 1st sample
  • E
    5th cross-section from large end 1st sample
  • F
    6th cross-section from large end 1st sample, usually insect enclosure logs
  • G
    Partial harvest samples from 1993 full harvest logs collected in 1997
  • H
    Partial harvest samples from 1993 full harvest logs collected in 1997
TIME - numeric(3,0) (ratio)

ID: TD01405.TIME

Time log has been decaying

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TD01405.YEAR

Year of measurement; does not necessarily reflect time decaying in field

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

RADPOS - numeric(2,0) (ratio)

ID: TD01405.RADPOS

Radial position of sample, for bark the number is zero.

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SAWSET - char(1) (nominal)

ID: TD01405.SAWSET

Indicates if saw was reset during the final cutting. if blank then the saw w as set once, a twice, b three times etc

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • 1
    saw was set once
  • 2
    saw was set twice
  • 3
    saw was set three times
SHAPE - char(1) (nominal)

ID: TD01405.SHAPE

Dimensional shape of sample taken from cross-section

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • 1
    Rectangular
  • 4
    Triangle (pie wedge)
SUBTYPE - char(1) (nominal)

ID: TD01405.SUBTYPE

Substrate type(e.g. innerbark, heartwood)

Type system: Microsoft SQL Server 2008

Code definitions (17)
  • W
    Wood standard
  • K
    Knot wood
  • S
    Sapwood
  • E
    Heartwood near log end (terminal)
  • I
    Inner bark
  • H
    Heartwood
  • 3
    Wood standard decay class 3
  • 5
    Wood standard decay class 5
  • 1
    Pine needle nbs standard reference material # 1575
  • 2
    Wood standard decay class 2
  • M
    Mushroom or sporocarp tissues
  • O
    Outer bark
  • A
    Arthropod
  • T
    Transition between sapwood and heartwood
  • R
    Rotten wood
  • L
    Leaf sample
  • X
    Whole log in which all the bark and wood tissues are combined
RECTANGLE_TYPE - char(1) (nominal)

ID: TD01405.RECTANGLE_TYPE

Shape of the rectangle piece of wood cut from the sample (regular or irregular). May indicate if end piece or not.

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • R
    Regular rectangular shaped piece
  • I
    Irregular rectangular shaped piece
GD1 - numeric(5,1) (ratio)

ID: TD01405.GD1

Radial dimension of green piece, measurements taken before oven drying (which can cause shrinkage), measured with caliper

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 0.100000

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

GD2 - numeric(5,1) (ratio)

ID: TD01405.GD2

Tangential dimension of green piece, measurements taken before oven drying (which can cause shrinkage)

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 0.100000

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

GD3 - numeric(5,1) (ratio)

ID: TD01405.GD3

Longitudinal dimension of green piece, measurements taken before oven drying (which can cause shrinkage)

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 0.100000

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

GD4 - numeric(5,1) (ratio)

ID: TD01405.GD4

Green dimension angle if shape=4

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

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

DD1 - numeric(5,1) (ratio)

ID: TD01405.DD1

Radial dimension of oven dried piece

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 0.100000

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

DD2 - numeric(5,1) (ratio)

ID: TD01405.DD2

Tangential dimension of oven dried piece

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 0.100000

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

OD3 - numeric(5,1) (ratio)

ID: TD01405.OD3

Longitudinal dimension of oven dried piece

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 0.100000

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

SAMPLEDATE - datetime (dateTime)

ID: TD01405.SAMPLEDATE

Date of sample processing

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TD01406 - TD01406

Object name: TD01406.csv

Records: 2458

Attributes: 21

Temporal coverage: 1985-11-25 to 2015-10-01

File size: 155248 byte

Checksum (MD5): 9fde7f86a69f3065199cc666b6c30fed

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01406.SECTION, TD01406.LOGNUM, TD01406.TIME
  • notNullConstraint: NOTNULL
    TD01406.SECTION, TD01406.DBCODE, TD01406.ENTITY, TD01406.EB1, TD01406.LOGNUM, TD01406.SB1, TD01406.TIME, TD01406.YEAR, TD01406.LOG_SPECIES
Attributes (21)
DBCODE - char(5) (nominal)

ID: TD01406.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

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

SITECODE - char(10) (nominal)

ID: TD01406.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
LOGNUM - numeric(3,0) (interval)

ID: TD01406.LOGNUM

Number of log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

LOG_SPECIES - char(4) (nominal)

ID: TD01406.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
SECTION - char(1) (nominal)

ID: TD01406.SECTION

Section of log

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • Y
    2nd cross-section from log remnant 1st cross-section from log remnant in 1992
  • Z
    2nd cross section from log remnant in 1992
  • 3
    Cross section from year 0, extra section
  • X
    1st cross-section from log remnant
  • A
    1st cross-section from large end 1st sample
  • 1
    Cross-section from large end of log - initial sample
  • 2
    Cross section from small end of log - initial sample
  • B
    2nd cross-section from large end 1st sample
  • D
    4th cross-section from large end 1st sample
  • C
    3rd cross-section from large end 1st sample
  • E
    5th cross-section from large end 1st sample
  • F
    6th cross-section from large end 1st sample, usually insect enclosure logs
  • G
    Partial harvest samples from 1993 full harvest logs collected in 1997
  • H
    Partial harvest samples from 1993 full harvest logs collected in 1997
TIME - numeric(3,0) (ratio)

ID: TD01406.TIME

Time log has been decaying

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TD01406.YEAR

Year of measurement; does not necessarily reflect time decaying in field

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

SB1 - numeric(2,0) (interval)

ID: TD01406.SB1

Wood piece diameter #1 starts on. a sequential number of sample position. actual start of #1

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

DS1 - numeric(2,0) (interval)

ID: TD01406.DS1

Dimensional start of diameter #1; start of regular portion of diameter #1, if different from above

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

EB1 - numeric(2,0) (interval)

ID: TD01406.EB1

Wood piece diameter #1 ends on a sequential number of sample position. actual end of #1

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

DE1 - numeric(2,0) (interval)

ID: TD01406.DE1

Dimensional end of diameter #1; end regular portion of diameter #1, if different from above

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SB2 - numeric(2,0) (interval)

ID: TD01406.SB2

Wood piece diameter #2 starts on a sequential number of sample position. actual start of #2

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

DS2 - numeric(2,0) (interval)

ID: TD01406.DS2

Dimensional start of diameter #2; start of regular portion of diameter #2, if different from above

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

EB2 - numeric(2,0) (interval)

ID: TD01406.EB2

Wood piece diameter #2 ends on a sequential number of sample position. actual end of #2

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

DE2 - numeric(2,0) (interval)

ID: TD01406.DE2

Dimensional end of diameter #2; end regular portion of diameter #2, if different from above

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SB3 - numeric(2,0) (interval)

ID: TD01406.SB3

Wood piece diameter #3 starts on a sequential number of sample position. actual start of #3

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

DS3 - numeric(2,0) (interval)

ID: TD01406.DS3

Dimensional start of diameter #3; start of regular portion of diameter #3, if different from above

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

EB3 - numeric(2,0) (interval)

ID: TD01406.EB3

Wood piece diameter #3 ends on a sequential number of sample position. actual end of #3

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

DE3 - numeric(2,0) (interval)

ID: TD01406.DE3

Dimensional end of diameter #3; end regular portion of diameter #3, if different from above

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

PITH - numeric(2,0) (ratio)

ID: TD01406.PITH

Block that contains the pith

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

TD01407 - TD01407

Object name: TD01407.csv

Records: 2426

Attributes: 11

Temporal coverage: 1985-12-12 to 2005-10-21

File size: 135435 byte

Checksum (MD5): 94ca75eb77011020b8154f04082cb0b6

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01407.SECTION, TD01407.LOGNUM, TD01407.TIME
  • notNullConstraint: NOTNULL
    TD01407.SECTION, TD01407.DBCODE, TD01407.ENTITY, TD01407.EXAMDATE, TD01407.KNOTVOL, TD01407.LOGNUM, TD01407.TIME, TD01407.YEAR
Attributes (11)
DBCODE - char(5) (nominal)

ID: TD01407.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

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

SITECODE - char(10) (nominal)

ID: TD01407.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
LOGNUM - numeric(3,0) (interval)

ID: TD01407.LOGNUM

Number of log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

LOG_SPECIES - char(4) (nominal)

ID: TD01407.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
SECTION - char(1) (nominal)

ID: TD01407.SECTION

Section of log

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • Y
    2nd cross-section from log remnant 1st cross-section from log remnant in 1992
  • Z
    2nd cross section from log remnant in 1992
  • 3
    Cross section from year 0, extra section
  • X
    1st cross-section from log remnant
  • A
    1st cross-section from large end 1st sample
  • 1
    Cross-section from large end of log - initial sample
  • 2
    Cross section from small end of log - initial sample
  • B
    2nd cross-section from large end 1st sample
  • D
    4th cross-section from large end 1st sample
  • C
    3rd cross-section from large end 1st sample
  • E
    5th cross-section from large end 1st sample
  • F
    6th cross-section from large end 1st sample, usually insect enclosure logs
  • G
    Partial harvest samples from 1993 full harvest logs collected in 1997
  • H
    Partial harvest samples from 1993 full harvest logs collected in 1997
TIME - numeric(3,0) (ratio)

ID: TD01407.TIME

Time log has been decaying

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TD01407.YEAR

Year of measurement; does not necessarily reflect time decaying in field

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

RADPOS - numeric(2,0) (ratio)

ID: TD01407.RADPOS

Radial position of sample, for bark the number is zero.

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

KNOTVOL - numeric(3,0) (ratio)

ID: TD01407.KNOTVOL

Volume of wood block that is knot

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1.000000

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

EXAMDATE - datetime (dateTime)

ID: TD01407.EXAMDATE

Date the piece was examined. for years 1-4 these are approximate dates.

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TD01408 - TD01408

Object name: TD01408.csv

Records: 257

Attributes: 16

Temporal coverage: 1985-11-25 to 1993-10-25

File size: 18918 byte

Checksum (MD5): 708ee991b4833205b2cf6c2b60011632

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01408.STUDYID, TD01408.SUBTYPE, TD01408.TIME, TD01408.YEAR, TD01408.SUBNUM, TD01408.LOG_SPECIES
  • notNullConstraint: NOTNULL
    TD01408.STUDYID, TD01408.SUBTYPE, TD01408.DBCODE, TD01408.ASH, TD01408.ENTITY, TD01408.NPE, TD01408.TANNIN, TD01408.TIME, TD01408.WSE, TD01408.WSSUG, TD01408.YEAR, TD01408.SUBNUM, TD01408.LOG_SPECIES
Attributes (16)
DBCODE - char(5) (nominal)

ID: TD01408.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

ID: TD01408.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(3) (nominal)

ID: TD01408.STUDYID

Study identification

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • COW
    Coweeta LTER
  • NBS
    National Bureau of Standards, standard reference material
  • CED
    Cedar Creek LTER
  • KON
    Konza lLTER
  • MAC
    MacDonald forest Corvallis
  • HJA
    H.J. Andrews Experimental Forest, Oregon
  • WWN
    Wallowa Valley Ranger district, Wallowa Whitman National Forest 25 miles NE Enterprise, 0regon
  • ALL
    Material from TD23 LIDET study, see for source
LOG_SPECIES - char(4) (nominal)

ID: TD01408.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
TIME - numeric(3,0) (ratio)

ID: TD01408.TIME

Time log has been decaying

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TD01408.YEAR

Year of measurement; does not necessarily reflect time decaying in field

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

SUBTYPE - char(1) (nominal)

ID: TD01408.SUBTYPE

Substrate type(e.g. innerbark, heartwood)

Type system: Microsoft SQL Server 2008

Code definitions (17)
  • W
    Wood standard
  • K
    Knot wood
  • S
    Sapwood
  • E
    Heartwood near log end (terminal)
  • I
    Inner bark
  • H
    Heartwood
  • 3
    Wood standard decay class 3
  • 5
    Wood standard decay class 5
  • 1
    Pine needle nbs standard reference material # 1575
  • 2
    Wood standard decay class 2
  • M
    Mushroom or sporocarp tissues
  • O
    Outer bark
  • A
    Arthropod
  • T
    Transition between sapwood and heartwood
  • R
    Rotten wood
  • L
    Leaf sample
  • X
    Whole log in which all the bark and wood tissues are combined
SUBNUM - numeric(2,0) (interval)

ID: TD01408.SUBNUM

Unique number for each subtype in a given studyid, species, year, time. Used for primary key.

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

ASH - numeric(6,3) (ratio)

ID: TD01408.ASH

Ash content

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.001000

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

LIGNINR - numeric(6,2) (ratio)

ID: TD01408.LIGNINR

Lignin content based on Effland 1977 Tappi 6(10) ligin is defined as the res d digest at 100 c. this for extact free wood

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

ACIDSOL - numeric(6,2) (ratio)

ID: TD01408.ACIDSOL

Acid soluble carbohydrates, based upon Effland 1977 Tappi 6(100) digestion in 72% sulfuric acid, this is for extractive free wood

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

NPE - numeric(6,2) (ratio)

ID: TD01408.NPE

Non polar extractives, dichloromehtane (CH2Cl2) in sonicator 90 min

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

WSE - numeric(6,2) (ratio)

ID: TD01408.WSE

Water soluble extractives, 3 hours in 100 c water, ryan et al method

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

WSSUG - numeric(6,2) (ratio)

ID: TD01408.WSSUG

Percent of water soluble matter that is sugar, phenol-sulfuric acid assay

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

ASSUG - numeric(6,2) (ratio)

ID: TD01408.ASSUG

Percent of acid soluble carbohydrates that is sugar, using phenol-surfuric a

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

TANNIN - numeric(6,2) (ratio)

ID: TD01408.TANNIN

Tannin content based upon folin-denis method using tannic acid as a standard

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

TD01409 - TD01409

Object name: TD01409.csv

Records: 1801

Attributes: 18

Temporal coverage: 1985-11-30 to 1992-09-24

File size: 126871 byte

Checksum (MD5): c4a82bb170b3137bad989bc0215e87d3

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01409.SECTION, TD01409.LOGNUM, TD01409.TIME, TD01409.PIECE
  • notNullConstraint: NOTNULL
    TD01409.SECTION, TD01409.DBCODE, TD01409.ENTITY, TD01409.LOGNUM, TD01409.TIME, TD01409.YEAR, TD01409.SAMPLEDATE, TD01409.PIECE
Attributes (18)
DBCODE - char(5) (nominal)

ID: TD01409.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

ID: TD01409.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SITECODE - char(10) (nominal)

ID: TD01409.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
LOGNUM - numeric(3,0) (interval)

ID: TD01409.LOGNUM

Number of log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

LOG_SPECIES - char(4) (nominal)

ID: TD01409.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
SECTION - char(1) (nominal)

ID: TD01409.SECTION

Section of log

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • Y
    2nd cross-section from log remnant 1st cross-section from log remnant in 1992
  • Z
    2nd cross section from log remnant in 1992
  • 3
    Cross section from year 0, extra section
  • X
    1st cross-section from log remnant
  • A
    1st cross-section from large end 1st sample
  • 1
    Cross-section from large end of log - initial sample
  • 2
    Cross section from small end of log - initial sample
  • B
    2nd cross-section from large end 1st sample
  • D
    4th cross-section from large end 1st sample
  • C
    3rd cross-section from large end 1st sample
  • E
    5th cross-section from large end 1st sample
  • F
    6th cross-section from large end 1st sample, usually insect enclosure logs
  • G
    Partial harvest samples from 1993 full harvest logs collected in 1997
  • H
    Partial harvest samples from 1993 full harvest logs collected in 1997
TIME - numeric(3,0) (ratio)

ID: TD01409.TIME

Time log has been decaying

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TD01409.YEAR

Year of measurement; does not necessarily reflect time decaying in field

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

PIECE - numeric(2,0) (interval)

ID: TD01409.PIECE

Unique piece number for each section of log measured in a particular site and year. Used for primary key.

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

OB1 - numeric(3,0) (ratio)

ID: TD01409.OB1

Outer bark thickness at top of logs

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1.000000

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

OB2 - numeric(3,0) (ratio)

ID: TD01409.OB2

Outer bark thickness at right side of log facing the end

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1.000000

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

OB3 - numeric(3,0) (ratio)

ID: TD01409.OB3

Outer bark thickness at base of log

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1.000000

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

OB4 - numeric(3,0) (ratio)

ID: TD01409.OB4

Outer bark thickness at left side of log facing it

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1.000000

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

IB1 - numeric(3,0) (ratio)

ID: TD01409.IB1

Inner bark thickness at top log

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1.000000

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

IB2 - numeric(3,0) (ratio)

ID: TD01409.IB2

Inner bark thickness at right side of log

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1.000000

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

IB3 - numeric(3,0) (ratio)

ID: TD01409.IB3

Inner bark thickness at bottom of log

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1.000000

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

IB4 - numeric(3,0) (ratio)

ID: TD01409.IB4

Inner bark thickness at left side of log

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1.000000

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

SAMPLEDATE - datetime (dateTime)

ID: TD01409.SAMPLEDATE

Date of sample processing

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TD01410 - TD01410

Object name: TD01410.csv

Records: 993

Attributes: 17

Temporal coverage: 1986-09-09 to 1989-10-05

File size: 80762 byte

Checksum (MD5): d7478c685c6c7b64d8653dcbcb47d803

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01410.POSITION, TD01410.LOGNUM, TD01410.TIME
  • notNullConstraint: NOTNULL
    TD01410.POSITION, TD01410.DBCODE, TD01410.ABA, TD01410.ABG, TD01410.BBA, TD01410.BBG, TD01410.ENTITY, TD01410.LOGNUM, TD01410.TIME, TD01410.WBA, TD01410.WBG, TD01410.YEAR, TD01410.SAMPLEDATE, TD01410.LOG_SPECIES
Attributes (17)
DBCODE - char(5) (nominal)

ID: TD01410.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

ID: TD01410.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SITECODE - char(10) (nominal)

ID: TD01410.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
LOGNUM - numeric(3,0) (interval)

ID: TD01410.LOGNUM

Number of log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

LOG_SPECIES - char(4) (nominal)

ID: TD01410.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
TIME - numeric(3,0) (ratio)

ID: TD01410.TIME

Time log has been decaying

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TD01410.YEAR

Year of measurement; does not necessarily reflect time decaying in field

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

TREATMNT - char(1) (nominal)

ID: TD01410.TREATMNT

Treatment of log exclosure, inclosure or control

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • N
    Control - time series
  • J
    Jumbo - large diameter logs (>75 cm)
  • E
    Insect exclosure
SEGMENT - char(2) (nominal)

ID: TD01410.SEGMENT

Log segment sampled, defined by the two x-sections that form ends example: ( see the original sheet)

Type system: Microsoft SQL Server 2008

POSITION - char(1) (nominal)

ID: TD01410.POSITION

Position on log that sample was taken from

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • B
    Bottom
  • S
    Side
  • T
    Top
ABG - numeric(4,0) (ratio)

ID: TD01410.ABG

Number of ambrosia beetle galleries in area

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

ABA - numeric(7,3) (ratio)

ID: TD01410.ABA

Area of sample for ambrosia beetles

Type system: Microsoft SQL Server 2008

Unit: square meters

Precision: 0.001000

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

BBG - numeric(4,0) (ratio)

ID: TD01410.BBG

Number of bark beetle galleries in area

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

BBA - numeric(7,3) (ratio)

ID: TD01410.BBA

Area of sample for bark bettles

Type system: Microsoft SQL Server 2008

Unit: square meters

Precision: 0.001000

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

WBG - numeric(4,0) (ratio)

ID: TD01410.WBG

Number of wood borer galleries as indicated by larval?

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

WBA - numeric(7,3) (ratio)

ID: TD01410.WBA

Area of sample for wood borers

Type system: Microsoft SQL Server 2008

Unit: square meters

Precision: 0.001000

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

SAMPLEDATE - datetime (dateTime)

ID: TD01410.SAMPLEDATE

Date of sample processing

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TD01411 - TD01411

Object name: TD01411.csv

Records: 1251

Attributes: 25

Temporal coverage: 1987-04-23 to 1994-02-20

File size: 152508 byte

Checksum (MD5): b8bf6fa138ec1784dec28b37798d5e64

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01411.SUBTYPE, TD01411.TIME, TD01411.SAMPLEDATE, TD01411.PIECENUM, TD01411.SAMPLED_SPECIES
  • notNullConstraint: NOTNULL
    TD01411.LAB, TD01411.STUDYID, TD01411.SUBTYPE, TD01411.DBCODE, TD01411.ENTITY, TD01411.TIME, TD01411.YEAR, TD01411.SAMPLEDATE, TD01411.PIECENUM, TD01411.SAMPLED_SPECIES
Attributes (25)
DBCODE - char(5) (nominal)

ID: TD01411.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

ID: TD01411.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SITECODE - char(10) (nominal)

ID: TD01411.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
STUDYID - char(3) (nominal)

ID: TD01411.STUDYID

Study identification

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • COW
    Coweeta LTER
  • NBS
    National Bureau of Standards, standard reference material
  • CED
    Cedar Creek LTER
  • KON
    Konza lLTER
  • MAC
    MacDonald forest Corvallis
  • HJA
    H.J. Andrews Experimental Forest, Oregon
  • WWN
    Wallowa Valley Ranger district, Wallowa Whitman National Forest 25 miles NE Enterprise, 0regon
  • ALL
    Material from TD23 LIDET study, see for source
LOGNUM - numeric(3,0) (interval)

ID: TD01411.LOGNUM

Number of log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SAMPLED_SPECIES - char(5) (nominal)

ID: TD01411.SAMPLED_SPECIES

Species sampled; includes tree species as well as other species (such as fungi and insects)

Type system: Microsoft SQL Server 2008

Code definitions (27)
  • OXSP
    Oxyporus species
  • NACA
    Naematoloma capnoides
  • MYOC
    Mycena occidentalis
  • POVE
    Polyporus versicolor
  • HEAB
    Hericium abietes
  • PHTR
    Phlebia tremellosus
  • AMSP
    Ampedus spp., mixed species small brown elaterid beetles
  • BMIX
    Buprestis rusticorum and dicerca tenebrosa, mixed buprestid beetles
  • ALME
    Alaus melanops, large eye-spotted elaterid beetle
  • THUN
    Thanasimus undatulus, checkered beetle
  • DEPS
    Dendroctonus pseudotsugae , d.f.bark beetle
  • FOPI
    Fomitopsis pinicola
  • CHAN
    Chalcophora angulicollis, sculptured pine borer, buprestid beetle
  • BUAU
    Buprestis aurulenta, golden buprestid beetle
  • WSTD
    Psme hw wood standard
  • WST?
    Wood standard with questionable values
  • RHIN
    Rhagium inquistor, grey cerambycid beetle
  • PSM?
    Suspect unknown sample, possibly psme
  • PSTD
    Pire pine needle standard
  • NEMI
    Neanthophilax mirificus, red and black cerambycid beetle
  • CTSP
    Ctenicera spp., mixed species small striped elaterid beetles
  • THPL
    Thuja plicata
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • TSHE
    Tsuga heterophylla
  • QRC
    Quercus species
  • ACSA
    Acer saccharum
TIME - numeric(3,0) (ratio)

ID: TD01411.TIME

Time log has been decaying

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TD01411.YEAR

Year of measurement; does not necessarily reflect time decaying in field

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

PIECENUM - char(1) (nominal)

ID: TD01411.PIECENUM

Unique identifier for nutrient content analysis. T, M, B was removed from lognum_nc (now lognum) and put into this field. Used for primary key. Some data appear to be duplicates.

Type system: Microsoft SQL Server 2008

Code definitions (12)
  • B
    Bottom
  • M
    Middle
  • T
    Top
  • 1
    Piece #1
  • 2
    Piece #2
  • 3
    Piece #3
  • 4
    Piece #4
  • 5
    Piece #5
  • 6
    Piece #6
  • 7
    Piece #7
  • 8
    Piece #8
  • 9
    Piece #9
SUBTYPE - char(1) (nominal)

ID: TD01411.SUBTYPE

Substrate type(e.g. innerbark, heartwood)

Type system: Microsoft SQL Server 2008

Code definitions (17)
  • W
    Wood standard
  • K
    Knot wood
  • S
    Sapwood
  • E
    Heartwood near log end (terminal)
  • I
    Inner bark
  • H
    Heartwood
  • 3
    Wood standard decay class 3
  • 5
    Wood standard decay class 5
  • 1
    Pine needle nbs standard reference material # 1575
  • 2
    Wood standard decay class 2
  • M
    Mushroom or sporocarp tissues
  • O
    Outer bark
  • A
    Arthropod
  • T
    Transition between sapwood and heartwood
  • R
    Rotten wood
  • L
    Leaf sample
  • X
    Whole log in which all the bark and wood tissues are combined
N - numeric(6,2) (ratio)

ID: TD01411.N

Nitrogen concentration (micro Kjeldahl N)

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

AL - numeric(6,1) (ratio)

ID: TD01411.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=0.0000 (exclusive=false), max=5066.2002 (exclusive=false)

B - numeric(6,1) (ratio)

ID: TD01411.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.0000 (exclusive=false), max=3074.0000 (exclusive=false)

CA - numeric(8,1) (ratio)

ID: TD01411.CA

Calcuim 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=121200.0000 (exclusive=false)

CU - numeric(6,1) (ratio)

ID: TD01411.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=86.2000 (exclusive=false)

FE - numeric(6,1) (ratio)

ID: TD01411.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=0.0000 (exclusive=false), max=9966.4004 (exclusive=false)

K - numeric(8,0) (ratio)

ID: TD01411.K

Potassium concentration (icap inductively coupled argon spectrophotometry)

Type system: Microsoft SQL Server 2008

Unit: parts per million

Precision: 1.000000

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

MG - numeric(6,1) (ratio)

ID: TD01411.MG

Magnesium concentration (cap 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=3498.6001 (exclusive=false)

MN - numeric(6,1) (ratio)

ID: TD01411.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=1025.8000 (exclusive=false)

P - numeric(8,1) (ratio)

ID: TD01411.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=0.0000 (exclusive=false), max=10033.8000 (exclusive=false)

S - numeric(6,1) (ratio)

ID: TD01411.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=1500.0000 (exclusive=false)

ZN - numeric(8,1) (ratio)

ID: TD01411.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=0.0000 (exclusive=false), max=309.4000 (exclusive=false)

NA - numeric(8,1) (ratio)

ID: TD01411.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=841.3000 (exclusive=false)

LAB - char(3) (nominal)

ID: TD01411.LAB

Code for laboratory responsible for analysis

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • MMI
    Micro macro international inc. analytical lab Athens, Georgia
  • CAL
    OSU Central analytical laboratory Corvallis, Oregon
  • HOR
    OSU Central analytical laboratory Corvallis, Oregon
SAMPLEDATE - datetime (dateTime)

ID: TD01411.SAMPLEDATE

Date of sample processing

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TD01412 - TD01412

Object name: TD01412.csv

Records: 501

Attributes: 14

Temporal coverage: 1987-07-30 to 1989-06-20

File size: 39079 byte

Checksum (MD5): e54d8d7cedb600cc4320e6bc2689b41f

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01412.SUBTYPE, TD01412.LOGNUM, TD01412.TIME, TD01412.SAMPLENUM
  • notNullConstraint: NOTNULL
    TD01412.SUBTYPE, TD01412.DBCODE, TD01412.ADF, TD01412.ASH, TD01412.ENTITY, TD01412.CELL, TD01412.LIGNINV, TD01412.LOGNUM, TD01412.TIME, TD01412.YEAR, TD01412.SAMPLEDATE, TD01412.SAMPLENUM, TD01412.LOG_SPECIES
Attributes (14)
DBCODE - char(5) (nominal)

ID: TD01412.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

ID: TD01412.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SITECODE - char(10) (nominal)

ID: TD01412.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
LOGNUM - numeric(3,0) (interval)

ID: TD01412.LOGNUM

Number of log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

LOG_SPECIES - char(4) (nominal)

ID: TD01412.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
TIME - numeric(3,0) (ratio)

ID: TD01412.TIME

Time log has been decaying

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TD01412.YEAR

Year of measurement; does not necessarily reflect time decaying in field

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

SUBTYPE - char(1) (nominal)

ID: TD01412.SUBTYPE

Substrate type(e.g. innerbark, heartwood)

Type system: Microsoft SQL Server 2008

Code definitions (17)
  • W
    Wood standard
  • K
    Knot wood
  • S
    Sapwood
  • E
    Heartwood near log end (terminal)
  • I
    Inner bark
  • H
    Heartwood
  • 3
    Wood standard decay class 3
  • 5
    Wood standard decay class 5
  • 1
    Pine needle nbs standard reference material # 1575
  • 2
    Wood standard decay class 2
  • M
    Mushroom or sporocarp tissues
  • O
    Outer bark
  • A
    Arthropod
  • T
    Transition between sapwood and heartwood
  • R
    Rotten wood
  • L
    Leaf sample
  • X
    Whole log in which all the bark and wood tissues are combined
SAMPLENUM - numeric(1,0) (interval)

ID: TD01412.SAMPLENUM

Unique sample number for primary key. Based on studyid,lognum,year,time,subtype.

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

ADF - numeric(5,2) (ratio)

ID: TD01412.ADF

Acid detergent fiber approximates hemicellulose fraction, non extracted wood

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

LIGNINV - numeric(5,2) (ratio)

ID: TD01412.LIGNINV

Lignin content, non extracted wood

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

CELL - numeric(5,2) (ratio)

ID: TD01412.CELL

Cellulose content, nonextracted wood

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.010000

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

ASH - numeric(6,3) (ratio)

ID: TD01412.ASH

Ash content

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 0.001000

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

SAMPLEDATE - datetime (dateTime)

ID: TD01412.SAMPLEDATE

Date of sample processing

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TD01413 - TD01413

Object name: TD01413.csv

Records: 524

Attributes: 10

Temporal coverage: 1985-11-25 to 1985-11-25

File size: 25900 byte

Checksum (MD5): d2ee48d5ad44b136007ed39ba013a4b1

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01413.POST, TD01413.LOGNUM
  • notNullConstraint: NOTNULL
    TD01413.SITE, TD01413.BEARING, TD01413.DBCODE, TD01413.POST, TD01413.ANGLE, TD01413.ENTITY, TD01413.DIST, TD01413.LOGNUM
Attributes (10)
DBCODE - char(5) (nominal)

ID: TD01413.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

ID: TD01413.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SITECODE - char(10) (nominal)

ID: TD01413.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
SITE - char(1) (nominal)

ID: TD01413.SITE

Bedding site of log added to

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • code
    Sample from log at one of study sites (1-6), site unknown originally for knot samples taken from scraps pile at annual harvest
  • 4
    W of 350 road near junction of 350 and 1506
  • 3
    N of 410 road
  • 5
    SW of 354 road
  • 1
    End of 327 road
  • 6
    1506 road above 350 junction
  • 2
    End of 324 road
  • A
    All sites combined for summaries
LOGNUM - numeric(3,0) (interval)

ID: TD01413.LOGNUM

Number of log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

LOG_SPECIES - char(4) (nominal)

ID: TD01413.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
POST - char(1) (ordinal)

ID: TD01413.POST

Post survey reading was made form

Type system: Microsoft SQL Server 2008

Code definitions (13)
  • A
    Survey Post A
  • B
    Survey Post B
  • C
    Survey Post C
  • D
    Survey Post D
  • E
    Survey Post E
  • F
    Survey Post F
  • G
    Survey Post G
  • H
    Survey Post H
  • I
    Survey Post I
  • J
    Survey Post J
  • K
    Survey Post K
  • L
    Survey Post L
  • M
    Survey Post M
BEARING - char(4) (nominal)

ID: TD01413.BEARING

Bearing from post to end of log nearest road. The leading letter is the initial cardinal direction, the final letter is off of the starting direction, the number is the number of degrees from the starting direction to the actual bearing. (related file)

Type system: Microsoft SQL Server 2008

DIST - numeric(6,2) (ratio)

ID: TD01413.DIST

Slope distance to the log from post

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.050000

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

ANGLE - numeric(6,0) (ratio)

ID: TD01413.ANGLE

Slope from post to log

Type system: Microsoft SQL Server 2008

Unit: degrees angle

Precision: 1.000000

Numeric domain: type=integer, min=-45.0000 (exclusive=false), max=55.0000 (exclusive=false)

TD01414 - TD01414

Object name: TD01414.csv

Records: 826

Attributes: 11

Temporal coverage: 1985-11-01 to 1992-11-30

File size: 52595 byte

Checksum (MD5): dde358524f92070e95a8ee91b31891bc

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01414.LOGNUM, TD01414.TIME
  • notNullConstraint: NOTNULL
    TD01414.DBCODE, TD01414.ENTITY, TD01414.LOGNUM, TD01414.MEANWT, TD01414.SPOROCAR, TD01414.TIME, TD01414.YEAR, TD01414.SAMPLEDATE, TD01414.LOG_SPECIES
Attributes (11)
DBCODE - char(5) (nominal)

ID: TD01414.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

ID: TD01414.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SITECODE - char(10) (nominal)

ID: TD01414.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
LOGNUM - numeric(3,0) (interval)

ID: TD01414.LOGNUM

Number of log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

LOG_SPECIES - char(4) (nominal)

ID: TD01414.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
TIME - numeric(3,0) (ratio)

ID: TD01414.TIME

Time log has been decaying

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TD01414.YEAR

Year of measurement; does not necessarily reflect time decaying in field

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

SPOROCAR - numeric(6,0) (ratio)

ID: TD01414.SPOROCAR

Number of sporocarps on log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

FUNGI_SPECIES - char(4) (nominal)

ID: TD01414.FUNGI_SPECIES

Type of sporocarps analyzed

Type system: Microsoft SQL Server 2008

Code definitions (17)
  • NACA
    Naematoloma capnoides
  • POSP
    Polyporus
  • OXSP
    Oxyporus
  • BOMI
    Boletus mirabilis
  • GAAP
    Ganoderma applanatum
  • DAPA
    Dacrymyces palmatus
  • MYOC
    Mycena occidentalis
  • MYEP
    Mycena epiterygia
  • AGSP
    Agaric
  • NICA
    Nidularia candida
  • PHLE
    Pholiata lenta
  • POVE
    Polyporus versicolor
  • HEAB
    Hericium abietes
  • PHTR
    Phlebia tremellosus
  • FOPI
    Fomitopsis pinicola
  • FOPD
    Fomitopsis pinicola, dead
  • UNKN
    unknown
MEANWT - numeric(7,3) (ratio)

ID: TD01414.MEANWT

Mean weight of fungus

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 0.020000

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

SAMPLEDATE - datetime (dateTime)

ID: TD01414.SAMPLEDATE

Date of sample processing

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TD01415 - TD01415

Object name: TD01415.csv

Records: 1920

Attributes: 12

Temporal coverage: 1985-11-15 to 2016-07-06

File size: 115157 byte

Checksum (MD5): c4a87184b9cdd774b05bc963bbfc2e01

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01415.SECTION, TD01415.SUBTYPE, TD01415.LOGNUM, TD01415.TIME, TD01415.SAMPLENUM
  • notNullConstraint: NOTNULL
    TD01415.SECTION, TD01415.SUBTYPE, TD01415.DBCODE, TD01415.ENTITY, TD01415.LOGNUM, TD01415.TIME, TD01415.YEAR, TD01415.SAMPLEDATE, TD01415.SAMPLENUM
Attributes (12)
DBCODE - char(5) (nominal)

ID: TD01415.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

ID: TD01415.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SITECODE - char(10) (nominal)

ID: TD01415.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
LOGNUM - numeric(3,0) (interval)

ID: TD01415.LOGNUM

Number of log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

LOG_SPECIES - char(4) (nominal)

ID: TD01415.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
SECTION - char(1) (nominal)

ID: TD01415.SECTION

Section of log

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • Y
    2nd cross-section from log remnant 1st cross-section from log remnant in 1992
  • Z
    2nd cross section from log remnant in 1992
  • 3
    Cross section from year 0, extra section
  • X
    1st cross-section from log remnant
  • A
    1st cross-section from large end 1st sample
  • 1
    Cross-section from large end of log - initial sample
  • 2
    Cross section from small end of log - initial sample
  • B
    2nd cross-section from large end 1st sample
  • D
    4th cross-section from large end 1st sample
  • C
    3rd cross-section from large end 1st sample
  • E
    5th cross-section from large end 1st sample
  • F
    6th cross-section from large end 1st sample, usually insect enclosure logs
  • G
    Partial harvest samples from 1993 full harvest logs collected in 1997
  • H
    Partial harvest samples from 1993 full harvest logs collected in 1997
TIME - numeric(3,0) (ratio)

ID: TD01415.TIME

Time log has been decaying

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TD01415.YEAR

Year of measurement; does not necessarily reflect time decaying in field

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

SUBTYPE - char(1) (nominal)

ID: TD01415.SUBTYPE

Substrate type(e.g. innerbark, heartwood)

Type system: Microsoft SQL Server 2008

Code definitions (17)
  • W
    Wood standard
  • K
    Knot wood
  • S
    Sapwood
  • E
    Heartwood near log end (terminal)
  • I
    Inner bark
  • H
    Heartwood
  • 3
    Wood standard decay class 3
  • 5
    Wood standard decay class 5
  • 1
    Pine needle nbs standard reference material # 1575
  • 2
    Wood standard decay class 2
  • M
    Mushroom or sporocarp tissues
  • O
    Outer bark
  • A
    Arthropod
  • T
    Transition between sapwood and heartwood
  • R
    Rotten wood
  • L
    Leaf sample
  • X
    Whole log in which all the bark and wood tissues are combined
SAMPLENUM - numeric(1,0) (interval)

ID: TD01415.SAMPLENUM

Unique sample number for primary key. Based on studyid,lognum,year,time,subtype.

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

WVOL - numeric(5,0) (ratio)

ID: TD01415.WVOL

Water displacement volume of bark. soaked 48-72 hours before measurement

Type system: Microsoft SQL Server 2008

Unit: cubic centimeters

Precision: 1.000000

Numeric domain: type=whole, min=14.0000 (exclusive=false), max=800.0000 (exclusive=false)

SAMPLEDATE - datetime (dateTime)

ID: TD01415.SAMPLEDATE

Date of sample processing

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TD01416 - TD01416

Object name: TD01416.csv

Records: 120

Attributes: 35

Temporal coverage: 2005-09-20 to 2015-10-21

File size: 23172 byte

Checksum (MD5): e15f8e8985d006130e20ae6c75a30147

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01416.SECTION, TD01416.LOGNUM, TD01416.TIME
  • notNullConstraint: NOTNULL
    TD01416.SECTION, TD01416.DBCODE, TD01416.ENTITY, TD01416.LOGNUM, TD01416.TIME, TD01416.YEAR, TD01416.SAMPLEDATE
Attributes (35)
DBCODE - char(5) (nominal)

ID: TD01416.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

ID: TD01416.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SITECODE - char(10) (nominal)

ID: TD01416.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
LOGNUM - numeric(3,0) (interval)

ID: TD01416.LOGNUM

Number of log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

LOG_SPECIES - char(4) (nominal)

ID: TD01416.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
SECTION - char(1) (nominal)

ID: TD01416.SECTION

Section of log

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • Y
    2nd cross-section from log remnant 1st cross-section from log remnant in 1992
  • Z
    2nd cross section from log remnant in 1992
  • 3
    Cross section from year 0, extra section
  • X
    1st cross-section from log remnant
  • A
    1st cross-section from large end 1st sample
  • 1
    Cross-section from large end of log - initial sample
  • 2
    Cross section from small end of log - initial sample
  • B
    2nd cross-section from large end 1st sample
  • D
    4th cross-section from large end 1st sample
  • C
    3rd cross-section from large end 1st sample
  • E
    5th cross-section from large end 1st sample
  • F
    6th cross-section from large end 1st sample, usually insect enclosure logs
  • G
    Partial harvest samples from 1993 full harvest logs collected in 1997
  • H
    Partial harvest samples from 1993 full harvest logs collected in 1997
TIME - numeric(3,0) (ratio)

ID: TD01416.TIME

Time log has been decaying

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TD01416.YEAR

Year of measurement; does not necessarily reflect time decaying in field

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

BFRAG - char(10) (nominal)

ID: TD01416.BFRAG

Is bark fragmented?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    bark is fragmented
  • N
    bark is not fragmented
BCIRC_LEN - numeric(5,1) (ratio)

ID: TD01416.BCIRC_LEN

Circumferential length of bark if present and fragmented

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

BRAD - numeric(5,1) (ratio)

ID: TD01416.BRAD

Radial thickness of bark

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

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

BLONG - numeric(5,1) (ratio)

ID: TD01416.BLONG

Longitudinal length of bark

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

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

BDIAM - numeric(5,1) (ratio)

ID: TD01416.BDIAM

Diameter of x-sec if bark not fragmented

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

BTOT_WET - numeric(7,2) (ratio)

ID: TD01416.BTOT_WET

Total wet weight of bark

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 1

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

BTOT_DRY - numeric(7,2) (ratio)

ID: TD01416.BTOT_DRY

Total dry weight of bark

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 1

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

SFRAG - char(1) (nominal)

ID: TD01416.SFRAG

Is sapwood fragmented?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    sapwood is fragmented
  • N
    sapwood is not fragmented
SCIRC_LEN - numeric(5,1) (ratio)

ID: TD01416.SCIRC_LEN

Circumferential length of sapwood if present and fragmented

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

SRAD - numeric(5,1) (ratio)

ID: TD01416.SRAD

Radial thickness of sapwood

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

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

SLONG - numeric(5,1) (ratio)

ID: TD01416.SLONG

Longitudinal length of sapwood

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

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

SDIAM - numeric(5,1) (ratio)

ID: TD01416.SDIAM

Diameter of x-sec with bark removed

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

STOT_WET - numeric(7,2) (ratio)

ID: TD01416.STOT_WET

Total wet weight of sapwood

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 1

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

STOT_DRY - numeric(7,2) (ratio)

ID: TD01416.STOT_DRY

Total dry weight of sapwood

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 1

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

HFRAG - char(1) (nominal)

ID: TD01416.HFRAG

Is heartwood fragmented?

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    heartwood is fragmented
  • N
    heartwood is not fragmented
HRAD - numeric(4,1) (ratio)

ID: TD01416.HRAD

Radial thickness of heartwood

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

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

HLONG - numeric(5,1) (ratio)

ID: TD01416.HLONG

Longitudinal length of heartwood

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 1

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

HDIAM - numeric(5,1) (ratio)

ID: TD01416.HDIAM

Diameter of heartwood

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

HTOT_WET - numeric(7,2) (ratio)

ID: TD01416.HTOT_WET

Total wet weight of heartwood

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 1

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

HTOT_DRY - numeric(7,2) (ratio)

ID: TD01416.HTOT_DRY

Total dry weight of heartwood

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 1

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

B_VOL - numeric(9,2) (ratio)

ID: TD01416.B_VOL

Total bark volume

Type system: Microsoft SQL Server 2008

Unit: cubic centimeters

Precision: 1

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

S_VOL - numeric(9,2) (ratio)

ID: TD01416.S_VOL

Total sapwood volume

Type system: Microsoft SQL Server 2008

Unit: cubic centimeters

Precision: 1

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

H_VOL - numeric(9,2) (ratio)

ID: TD01416.H_VOL

Total heartwood volume

Type system: Microsoft SQL Server 2008

Unit: cubic centimeters

Precision: 1

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

B_DENSITY - numeric(4,2) (ratio)

ID: TD01416.B_DENSITY

Density of bark based on dry weight and volume

Type system: Microsoft SQL Server 2008

Unit: grams per cubic centimeter

Precision: 1

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

S_DENSITY - numeric(4,2) (ratio)

ID: TD01416.S_DENSITY

Density of sapwood based on dry weight and volume

Type system: Microsoft SQL Server 2008

Unit: grams per cubic centimeter

Precision: 1

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

H_DENSITY - numeric(4,2) (ratio)

ID: TD01416.H_DENSITY

Density of heartwood based on dry weight and volume

Type system: Microsoft SQL Server 2008

Unit: grams per cubic centimeter

Precision: 1

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

SAMPLEDATE - datetime (dateTime)

ID: TD01416.SAMPLEDATE

Date of sample processing

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TD01417 - TD01417

Object name: TD01417.csv

Records: 1200

Attributes: 20

Temporal coverage: 2005-09-20 to 2015-10-21

File size: 118910 byte

Checksum (MD5): 9ca161dae7cfb706fdfa733eaeafbf9b

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01417.SECTION, TD01417.SUBTYPE, TD01417.LOGNUM, TD01417.TIME, TD01417.W_RADPOS
  • notNullConstraint: NOTNULL
    TD01417.SECTION, TD01417.SHAPE, TD01417.SUBTYPE, TD01417.DBCODE, TD01417.ENTITY, TD01417.LOGNUM, TD01417.TIME, TD01417.YEAR, TD01417.SAMPLEDATE, TD01417.W_RADPOS
Attributes (20)
DBCODE - char(5) (nominal)

ID: TD01417.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

ID: TD01417.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SITECODE - char(10) (nominal)

ID: TD01417.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
LOGNUM - numeric(3,0) (interval)

ID: TD01417.LOGNUM

Number of log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

LOG_SPECIES - char(4) (nominal)

ID: TD01417.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
SECTION - char(1) (nominal)

ID: TD01417.SECTION

Section of log

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • Y
    2nd cross-section from log remnant 1st cross-section from log remnant in 1992
  • Z
    2nd cross section from log remnant in 1992
  • 3
    Cross section from year 0, extra section
  • X
    1st cross-section from log remnant
  • A
    1st cross-section from large end 1st sample
  • 1
    Cross-section from large end of log - initial sample
  • 2
    Cross section from small end of log - initial sample
  • B
    2nd cross-section from large end 1st sample
  • D
    4th cross-section from large end 1st sample
  • C
    3rd cross-section from large end 1st sample
  • E
    5th cross-section from large end 1st sample
  • F
    6th cross-section from large end 1st sample, usually insect enclosure logs
  • G
    Partial harvest samples from 1993 full harvest logs collected in 1997
  • H
    Partial harvest samples from 1993 full harvest logs collected in 1997
TIME - numeric(3,0) (ratio)

ID: TD01417.TIME

Time log has been decaying

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TD01417.YEAR

Year of measurement; does not necessarily reflect time decaying in field

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

SUBTYPE - char(1) (nominal)

ID: TD01417.SUBTYPE

Substrate type(e.g. innerbark, heartwood)

Type system: Microsoft SQL Server 2008

Code definitions (17)
  • W
    Wood standard
  • K
    Knot wood
  • S
    Sapwood
  • E
    Heartwood near log end (terminal)
  • I
    Inner bark
  • H
    Heartwood
  • 3
    Wood standard decay class 3
  • 5
    Wood standard decay class 5
  • 1
    Pine needle nbs standard reference material # 1575
  • 2
    Wood standard decay class 2
  • M
    Mushroom or sporocarp tissues
  • O
    Outer bark
  • A
    Arthropod
  • T
    Transition between sapwood and heartwood
  • R
    Rotten wood
  • L
    Leaf sample
  • X
    Whole log in which all the bark and wood tissues are combined
SHAPE - char(1) (nominal)

ID: TD01417.SHAPE

Dimensional shape of sample taken from cross-section

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • 1
    Rectangular
  • 4
    Triangle (pie wedge)
W_RADPOS - char(1) (nominal)

ID: TD01417.W_RADPOS

radial position of wedge sample, for bark the number is zero

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • 1
    top, sapwood
  • 2
    top, heartwood
  • 3
    bottom,heartwood
  • 4
    bottom, sapwood
  • 5
    left, sapwood
  • 6
    left, heartwood
  • 7
    right, heartwood
  • 8
    right, sapwood
  • code
    bark
D1 - numeric(5,1) (ratio)

ID: TD01417.D1

Dimension in radial direction

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 0.100000

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

D3 - numeric(5,1) (ratio)

ID: TD01417.D3

Dimension in longitudinal direction, if missing then calculated

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 0.100000

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

D4 - numeric(4,1) (ratio)

ID: TD01417.D4

Angle, in degrees, if triangle shape

Type system: Microsoft SQL Server 2008

Unit: degrees angle

Precision: 1

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

D2 - numeric(6,1) (ratio)

ID: TD01417.D2

Dimension in tangential direction. If missing then volume calculated using other radial measurement (D1, D3, D4, or volume known).

Type system: Microsoft SQL Server 2008

Unit: millimeters

Precision: 0.100000

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

WETWT - numeric(6,2) (ratio)

ID: TD01417.WETWT

Wet weight of sample

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 0.100000

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

DRYWT - numeric(6,2) (ratio)

ID: TD01417.DRYWT

Dry weight of sample. dried 7 days at 55 degree c

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 0.100000

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

DEN - numeric(5,3) (ratio)

ID: TD01417.DEN

Density based on dry weight

Type system: Microsoft SQL Server 2008

Unit: grams per milliliter

Precision: 1

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

SAMPLEDATE - datetime (dateTime)

ID: TD01417.SAMPLEDATE

Date of sample processing

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

COMMENTS_LAB - char(254) (nominal)

ID: TD01417.COMMENTS_LAB

Comments from lab data sheets

Type system: Microsoft SQL Server 2008

TD01418 - TD01418

Object name: TD01418.csv

Records: 2143

Attributes: 16

Temporal coverage: 1985-11-25 to 2001-10-05

File size: 202080 byte

Checksum (MD5): 6bf5b5461447eac686eddb102c46ad87

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01418.SECTION, TD01418.LOGNUM, TD01418.TIME, TD01418.SAMPLENUM
  • notNullConstraint: NOTNULL
    TD01418.SECTION, TD01418.DBCODE, TD01418.ENTITY, TD01418.LOGNUM, TD01418.TIME, TD01418.YEAR, TD01418.SAMPLENUM, TD01418.LOG_SPECIES
Attributes (16)
DBCODE - char(5) (nominal)

ID: TD01418.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

ID: TD01418.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SITECODE - char(10) (nominal)

ID: TD01418.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
LOGNUM - numeric(3,0) (interval)

ID: TD01418.LOGNUM

Number of log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

LOG_SPECIES - char(4) (nominal)

ID: TD01418.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
SECTION - char(1) (nominal)

ID: TD01418.SECTION

Section of log

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • Y
    2nd cross-section from log remnant 1st cross-section from log remnant in 1992
  • Z
    2nd cross section from log remnant in 1992
  • 3
    Cross section from year 0, extra section
  • X
    1st cross-section from log remnant
  • A
    1st cross-section from large end 1st sample
  • 1
    Cross-section from large end of log - initial sample
  • 2
    Cross section from small end of log - initial sample
  • B
    2nd cross-section from large end 1st sample
  • D
    4th cross-section from large end 1st sample
  • C
    3rd cross-section from large end 1st sample
  • E
    5th cross-section from large end 1st sample
  • F
    6th cross-section from large end 1st sample, usually insect enclosure logs
  • G
    Partial harvest samples from 1993 full harvest logs collected in 1997
  • H
    Partial harvest samples from 1993 full harvest logs collected in 1997
TIME - numeric(3,0) (ratio)

ID: TD01418.TIME

Time log has been decaying

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TD01418.YEAR

Year of measurement; does not necessarily reflect time decaying in field

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

SAMPLENUM - numeric(1,0) (interval)

ID: TD01418.SAMPLENUM

Unique sample number for primary key. Based on studyid,lognum,year,time,subtype.

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

TA - numeric(7,2) (ratio)

ID: TD01418.TA

Total cross-sectional area

Type system: Microsoft SQL Server 2008

Unit: square centimeters

Precision: 2.000000

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

WA - numeric(7,2) (ratio)

ID: TD01418.WA

Cross-sectional area of wood

Type system: Microsoft SQL Server 2008

Unit: square centimeters

Precision: 2.000000

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

BSS - numeric(7,2) (ratio)

ID: TD01418.BSS

Blue-stained sapwood cross-sectional area

Type system: Microsoft SQL Server 2008

Unit: square centimeters

Precision: 2.000000

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

HWA - numeric(7,2) (ratio)

ID: TD01418.HWA

Heartwood cross-sectional area

Type system: Microsoft SQL Server 2008

Unit: square centimeters

Precision: 2.000000

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

SOWA - numeric(7,2) (ratio)

ID: TD01418.SOWA

Total area of sound (not rotten) wood

Type system: Microsoft SQL Server 2008

Unit: square centimeters

Precision: 1

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

SOHWA - numeric(7,2) (ratio)

ID: TD01418.SOHWA

Total area of sound (not rotten) heartwood

Type system: Microsoft SQL Server 2008

Unit: square centimeters

Precision: 1

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

NOTES - char(254) (nominal)

ID: TD01418.NOTES

measurement notes and assumptions

Type system: Microsoft SQL Server 2008

TD01419 - TD01419

Object name: TD01419.csv

Records: 2141

Attributes: 20

Temporal coverage: 1985-11-25 to 2001-10-05

File size: 246099 byte

Checksum (MD5): b4f59378a5064167c326c988f2156ad6

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01419.SECTION, TD01419.LOGNUM, TD01419.TIME, TD01419.SAMPLENUM
  • notNullConstraint: NOTNULL
    TD01419.SECTION, TD01419.DBCODE, TD01419.ENTITY, TD01419.LOGNUM, TD01419.TIME, TD01419.YEAR, TD01419.SAMPLENUM, TD01419.LOG_SPECIES
Attributes (20)
DBCODE - char(5) (nominal)

ID: TD01419.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

ID: TD01419.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SITECODE - char(10) (nominal)

ID: TD01419.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
LOGNUM - numeric(3,0) (interval)

ID: TD01419.LOGNUM

Number of log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

LOG_SPECIES - char(4) (nominal)

ID: TD01419.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
SECTION - char(1) (nominal)

ID: TD01419.SECTION

Section of log

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • Y
    2nd cross-section from log remnant 1st cross-section from log remnant in 1992
  • Z
    2nd cross section from log remnant in 1992
  • 3
    Cross section from year 0, extra section
  • X
    1st cross-section from log remnant
  • A
    1st cross-section from large end 1st sample
  • 1
    Cross-section from large end of log - initial sample
  • 2
    Cross section from small end of log - initial sample
  • B
    2nd cross-section from large end 1st sample
  • D
    4th cross-section from large end 1st sample
  • C
    3rd cross-section from large end 1st sample
  • E
    5th cross-section from large end 1st sample
  • F
    6th cross-section from large end 1st sample, usually insect enclosure logs
  • G
    Partial harvest samples from 1993 full harvest logs collected in 1997
  • H
    Partial harvest samples from 1993 full harvest logs collected in 1997
TIME - numeric(3,0) (ratio)

ID: TD01419.TIME

Time log has been decaying

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TD01419.YEAR

Year of measurement; does not necessarily reflect time decaying in field

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

SAMPLENUM - numeric(1,0) (interval)

ID: TD01419.SAMPLENUM

Unique sample number for primary key. Based on studyid,lognum,year,time,subtype.

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

TA - numeric(7,2) (ratio)

ID: TD01419.TA

Total cross-sectional area

Type system: Microsoft SQL Server 2008

Unit: square centimeters

Precision: 2.000000

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

WA - numeric(7,2) (ratio)

ID: TD01419.WA

Cross-sectional area of wood

Type system: Microsoft SQL Server 2008

Unit: square centimeters

Precision: 2.000000

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

BA - numeric(7,2) (ratio)

ID: TD01419.BA

Bark cross-sectional area including inner and outer

Type system: Microsoft SQL Server 2008

Unit: square centimeters

Precision: 1.000000

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

IBA - numeric(6,2) (ratio)

ID: TD01419.IBA

Inner bark cross-sectional area

Type system: Microsoft SQL Server 2008

Unit: square centimeters

Precision: 1.000000

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

OBA - numeric(8,2) (ratio)

ID: TD01419.OBA

Outer bark cross-sectional area

Type system: Microsoft SQL Server 2008

Unit: square centimeters

Precision: 1.000000

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

SWA - numeric(7,2) (ratio)

ID: TD01419.SWA

Sapwood cross-sectional area

Type system: Microsoft SQL Server 2008

Unit: square centimeters

Precision: 2.000000

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

BSS - numeric(7,2) (ratio)

ID: TD01419.BSS

Blue-stained sapwood cross-sectional area

Type system: Microsoft SQL Server 2008

Unit: square centimeters

Precision: 2.000000

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

RSA - numeric(7,2) (ratio)

ID: TD01419.RSA

Rotten sapwood cross-sectional area

Type system: Microsoft SQL Server 2008

Unit: square centimeters

Precision: 2.000000

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

HWA - numeric(7,2) (ratio)

ID: TD01419.HWA

Heartwood cross-sectional area

Type system: Microsoft SQL Server 2008

Unit: square centimeters

Precision: 2.000000

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

RHA - numeric(7,2) (ratio)

ID: TD01419.RHA

Rotten heartwood cross-sectional area

Type system: Microsoft SQL Server 2008

Unit: square centimeters

Precision: 2.000000

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

DIAM_EST - numeric(4,1) (ratio)

ID: TD01419.DIAM_EST

estimated diameter from total area

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1

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

TD01420 - TD01420

Object name: TD01420.csv

Records: 1774

Attributes: 17

Temporal coverage: 1985-11-25 to 1992-09-24

File size: 137161 byte

Checksum (MD5): bd92477f5cf7fa9e0c756606eaf2fe90

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01420.SECTION, TD01420.LOGNUM, TD01420.TIME, TD01420.SAMPLENUM
  • notNullConstraint: NOTNULL
    TD01420.SECTION, TD01420.DBCODE, TD01420.ENTITY, TD01420.LOGNUM, TD01420.TIME, TD01420.YEAR, TD01420.SAMPLENUM, TD01420.LOG_SPECIES, TD01420.SITECODE
Attributes (17)
DBCODE - char(5) (nominal)

ID: TD01420.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

ID: TD01420.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SITECODE - char(10) (nominal)

ID: TD01420.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
LOGNUM - numeric(3,0) (interval)

ID: TD01420.LOGNUM

Number of log

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

LOG_SPECIES - char(4) (nominal)

ID: TD01420.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
SECTION - char(1) (nominal)

ID: TD01420.SECTION

Section of log

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • Y
    2nd cross-section from log remnant 1st cross-section from log remnant in 1992
  • Z
    2nd cross section from log remnant in 1992
  • 3
    Cross section from year 0, extra section
  • X
    1st cross-section from log remnant
  • A
    1st cross-section from large end 1st sample
  • 1
    Cross-section from large end of log - initial sample
  • 2
    Cross section from small end of log - initial sample
  • B
    2nd cross-section from large end 1st sample
  • D
    4th cross-section from large end 1st sample
  • C
    3rd cross-section from large end 1st sample
  • E
    5th cross-section from large end 1st sample
  • F
    6th cross-section from large end 1st sample, usually insect enclosure logs
  • G
    Partial harvest samples from 1993 full harvest logs collected in 1997
  • H
    Partial harvest samples from 1993 full harvest logs collected in 1997
TIME - numeric(3,0) (ratio)

ID: TD01420.TIME

Time log has been decaying

Type system: Microsoft SQL Server 2008

Unit: number of years

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TD01420.YEAR

Year of measurement; does not necessarily reflect time decaying in field

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

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

SAMPLENUM - numeric(1,0) (interval)

ID: TD01420.SAMPLENUM

Unique sample number for primary key. Based on studyid,lognum,year,time,subtype.

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

PTD - numeric(5,1) (ratio)

ID: TD01420.PTD

Distance from pith to top. note all these reading are used to reference the position of the pith for future reconstructions.

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

PTA - numeric(3,0) (ratio)

ID: TD01420.PTA

Angle between pith and top

Type system: Microsoft SQL Server 2008

Unit: degrees angle

Precision: 1.000000

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

PBD - numeric(5,1) (ratio)

ID: TD01420.PBD

Distance between pith and log bottom

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

PBA - numeric(3,0) (ratio)

ID: TD01420.PBA

Angle between pith and bottom

Type system: Microsoft SQL Server 2008

Unit: degrees angle

Precision: 1.000000

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

PS1D - numeric(5,1) (ratio)

ID: TD01420.PS1D

Distance between the pith and the 1st side

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

PS1A - numeric(3,0) (ratio)

ID: TD01420.PS1A

Angle between the pith and the first side

Type system: Microsoft SQL Server 2008

Unit: degrees angle

Precision: 1.000000

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

PS2D - numeric(5,1) (ratio)

ID: TD01420.PS2D

Angle between the pith and 2nd side

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

PS2A - numeric(3,0) (ratio)

ID: TD01420.PS2A

Angle between the pith and 2nd side

Type system: Microsoft SQL Server 2008

Unit: degrees angle

Precision: 1.000000

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

TD01421 - TD01421

Object name: TD01421.csv

Records: 283

Attributes: 30

Temporal coverage: 1985-11-25 to 2015-09-18

File size: 31818 byte

Checksum (MD5): 0afa68e0f617102f767e8cd25969d93f

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

Constraints (2)
  • primaryKey: PRIMARY
    TD01421.SUBTYPE, TD01421.LOG_SPECIES, TD01421.SITECODE, TD01421.EQN_FORM
  • notNullConstraint: NOTNULL
    TD01421.SITE, TD01421.SUBTYPE, TD01421.DBCODE, TD01421.ENTITY, TD01421.LOG_SPECIES, TD01421.SITECODE, TD01421.EQN_FORM, TD01421.N_OBS, TD01421.INTERCEPT_FORCED, TD01421.R_SQUARED, TD01421.OVERALL_PV
Attributes (30)
DBCODE - char(5) (nominal)

ID: TD01421.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2008

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

ID: TD01421.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SITECODE - char(10) (nominal)

ID: TD01421.SITECODE

Sampling location

Type system: Microsoft SQL Server 2008

Code definitions (14)
  • TD014_NBS
    United States
  • TD014_WWN
    Wallowa-Whitman National Forest
  • TD014_HJA1
    H.J. Andrews Log decomp site 1
  • TD014_HJA4
    H.J. Andrews Log decomp site 4
  • TD014_HJA5
    H.J. Andrews Log decomp site 5
  • TD014_HJA6
    H.J. Andrews Log decomp site 6
  • TD014_MAC
    Near Macdonald-Dunn Research Forest, Corvallis, Oregon
  • TD014_ALL
    All LIDET sites
  • TD014_COW
    Coweeta Hydrologic Laboratory LIDET site
  • TD014_CED
    Cedar Creek Natural History Area, Minnesota LIDET site
  • TD014_KON
    Konza Prairie Research Natural Area, Kansas LIDET site
  • TD014_HJA2
    H.J. Andrews Log decomp site 2
  • TD014_HJA3
    H.J. Andrews Log decomp site 3
  • TD014_HJA0
    H.J. Andrews Log decomp site 0
SITE - char(1) (nominal)

ID: TD01421.SITE

Bedding site of log added to

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • code
    Sample from log at one of study sites (1-6), site unknown originally for knot samples taken from scraps pile at annual harvest
  • 4
    W of 350 road near junction of 350 and 1506
  • 3
    N of 410 road
  • 5
    SW of 354 road
  • 1
    End of 327 road
  • 6
    1506 road above 350 junction
  • 2
    End of 324 road
  • A
    All sites combined for summaries
LOG_SPECIES - char(4) (nominal)

ID: TD01421.LOG_SPECIES

Species of log

Type system: Microsoft SQL Server 2008

Code definitions (8)
  • ABAM
    Abies amabilis
  • PSME
    Pseudotsuga menziesii
  • QRC
    Quercus
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • WDST
    Pseudotsuga menziesii hardwood; wood standard
  • UNKN
    unknown
  • KNOT
    Tree knot
SUBTYPE - char(1) (nominal)

ID: TD01421.SUBTYPE

Substrate type(e.g. innerbark, heartwood)

Type system: Microsoft SQL Server 2008

Code definitions (17)
  • W
    Wood standard
  • K
    Knot wood
  • S
    Sapwood
  • E
    Heartwood near log end (terminal)
  • I
    Inner bark
  • H
    Heartwood
  • 3
    Wood standard decay class 3
  • 5
    Wood standard decay class 5
  • 1
    Pine needle nbs standard reference material # 1575
  • 2
    Wood standard decay class 2
  • M
    Mushroom or sporocarp tissues
  • O
    Outer bark
  • A
    Arthropod
  • T
    Transition between sapwood and heartwood
  • R
    Rotten wood
  • L
    Leaf sample
  • X
    Whole log in which all the bark and wood tissues are combined
EQN_FORM - char(6) (nominal)

ID: TD01421.EQN_FORM

Defines the model equation used to estimate parameters

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • LAG
    Modified Chapman-Richards to include lag term: PMR= 1-(1-exp(-k*t])^Lag where PRM is proportion of mass remaining, t is time in years, and k and Lag are the model parameters
  • SINGLE
    Single negative exponential: PMR=Int*exp(-k*t) where PMR is proportion of mass remaining, t is time in years, and k is the model parameter
  • DUAL
    Dual negative exponential: PMR= P1t0*exp(-k1*t) + (1-P1t0)*exp(-k2*t) where PMR is proportion of mass remaining, P1to is the proportion of part 1 at time zero, t is time in years, and k1 and k2 are the decomposition ra
N_OBS - numeric(3,0) (interval)

ID: TD01421.N_OBS

Number of observations used to estimate model parameters

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

DECAY_RATE - numeric(5,3) (ratio)

ID: TD01421.DECAY_RATE

Decomposition rate-constant (k) estimated parameter

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

DECAY_RATE_SE - numeric(5,3) (ratio)

ID: TD01421.DECAY_RATE_SE

Standard error of decomposition rate-constant estimated parameter

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

INTERCEPT - numeric(4,2) (ratio)

ID: TD01421.INTERCEPT

Intercept estimated parameter

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

INTERCEPT_SE - numeric(4,2) (ratio)

ID: TD01421.INTERCEPT_SE

Standard error of intercept estimated parameter

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

INTERCEPT_FORCED - char(1) (nominal)

ID: TD01421.INTERCEPT_FORCED

Intercept forced to be between 0.95 and 1.05 for linear and equal to 1 for lag and dual-exponential equations at time 0 (Y,N)

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • Y
    Yes, intercept forced
  • N
    No, intercept not forced
DECAY_RATE_PV - numeric(6,4) (ratio)

ID: TD01421.DECAY_RATE_PV

p-value of k parameter

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

INTERCEPT_PV - numeric(6,4) (ratio)

ID: TD01421.INTERCEPT_PV

p-value of intercept parameter

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

LAG - numeric(4,2) (ratio)

ID: TD01421.LAG

Lag estimated parameter

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

LAG_SE - numeric(4,2) (ratio)

ID: TD01421.LAG_SE

Standard error of lag estimated parameter

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

LAG_PV - numeric(6,4) (ratio)

ID: TD01421.LAG_PV

p-value of lag parameter

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

R_SQUARED - numeric(8,4) (ratio)

ID: TD01421.R_SQUARED

r-squared of overall equation

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

OVERALL_PV - char(1) (nominal)

ID: TD01421.OVERALL_PV

Significance of the p-value of overall equation

Type system: Microsoft SQL Server 2008

Code definitions (4)
  • N
    P-value not significant (> 0.1)
  • M
    P-value moderately significant (0.05-0.1)
  • S
    P-value significant (<0.05)
  • H
    P-value highly significant (<0.01)
DECAY_LAG_CORR - numeric(6,4) (ratio)

ID: TD01421.DECAY_LAG_CORR

Correlation between k and lag parameters, used for lag model only

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

DECAY_INTERCEPT_CORR - numeric(7,4) (ratio)

ID: TD01421.DECAY_INTERCEPT_CORR

Correlation between k and intercept parameters used for single exponential model only

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

P1T0 - numeric(4,2) (ratio)

ID: TD01421.P1T0

Initial proportion of mass applied to k1 in dual exponential equation

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

P1T0_SE - numeric(10,2) (ratio)

ID: TD01421.P1T0_SE

Standard error of the P1t0 estimated parameter

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

DECAY_RATE_K1 - numeric(5,3) (ratio)

ID: TD01421.DECAY_RATE_K1

Decomposition rate-constant for part 1 (k1) estimated parameter for dual exponential

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

DECAY_RATE_K1_SE - numeric(8,3) (ratio)

ID: TD01421.DECAY_RATE_K1_SE

Standard error of the k1 estimated parameter

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

DECAY_RATE_K2 - numeric(5,3) (ratio)

ID: TD01421.DECAY_RATE_K2

Decomposition rate-constnat for part 2 (k2) estimated parameter for dual exponential

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

DECAY_RATE_K2_SE - numeric(9,3) (ratio)

ID: TD01421.DECAY_RATE_K2_SE

Standard error of the k2 estimated parameter

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

K1_K2_CORR - numeric(6,4) (ratio)

ID: TD01421.K1_K2_CORR

Correlation between k1 and k2, used for dual exponential model only

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

K1_P1T0_CORR - numeric(7,4) (ratio)

ID: TD01421.K1_P1T0_CORR

Correlation between k1 and proportion of mass for k1 used for dual exponential model only

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

Units
degrees azimuth deg az azimuth azimuthDegree unknown N/A degrees azimuth (0-360)
cubic meters m3 volume meterCubed meterCubed 1 cubic meters
square millimeters mm2 area millimeterSquared meterSquared 0.000001 square millimeters
milliliters ml volume milliliter meterCubed 0.000001 milliliters; 1/1000 of a liter
square meters m2 area meterSquared meterSquared 1 square meters
parts per million ppm massDensity partsPerMillion kilogramPerMeterCubed 0.001 parts per million
percent % dimensionless number dimensionless 100 percent; a number
meters m length meter meter 1 meter; SI unit of length
cubic centimeters cm3 volume centimeterCubed meterCubed 0.000001 cubic centimeters
grams per cubic centimeter g/cm3 massDensity gramPerCentimeterCubed kilogramPerMeterCubed 1000 grams per cubic centimeter
millimeters mm length millimeter meter 0.001 millimeters; .001 meters
grams g mass gram kilogram 0.001 grams; 0.001 kilogram
grams per milliliter g/ml massDensity gramPerMilliliter kilogramPerMeterCubed 1000 grams per milliliter
square centimeters cm2 area centimeterSquare meterSquared 0.0001 square centimeters
degrees angle deg angle angle degree radian 0.0174532924 360 degrees comprise a unit circle; degrees used for angle and slope
centimeters cm length centimeter meter 0.01 centimeters; .01 meters
number of years years time nominalYear second 31536000 one year excluding leap seconds and leap days, 31536000 seconds (often used for age in years)
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
Related Datasets

No related dataset codes found in the EML text fields.

Related Publications
  • Harmon, Mark E. 1992. Long-term experiments on log decomposition at the H.J. Andrews Experimental Forest. Gen. Tech. Rep. PNW-280. Portland, OR: U.S. Department of Agriculture, Forest Service, Pacific Northwest Research Station. 28 p.
Related Files
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

  • Version1 (1985-10-01)
    Original metadata creation
  • Version2 (2005-04-25)
    Moved database to SQL server
  • Version7 (2015-01-28)
    Restructured datasets; Converted CARDTYPE to ENTITY, DATACODE to DBCODE, mm,dd,year to sampledate (kept YEAR), will convert SPECIES to taxa and studyid to place. Added primary key. Ran QC and uploaded new structures to SQL. Data from 2005 and 2015 will need to be added and further modifications to the structures may be required.
  • Version8 (2015-11-25)
    Converted enum species lists to taxa domain (1, 6, 8, 10, 12, 14), added missing species (11), converted survey posts to enum (13). Ran QC, recreated SQL structures and uploaded data.
  • Version10 (2018-06-13)
    Major data update that includes data from 2005, 2015 and 2016. Addition of 6 new entities. Restructure of pervious entities to include sitecode with geographic reference and log_species where appropriate. See specific entity update history for details.