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

TV009: Dendrometer studies for stand volume and height measurements of trees of the western US, 1976 to 1993

← Back to catalog index

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

Status: notPlanned
Period: 1976-06-01 to 1993-04-13
Version: 9
Published: 2015-12-16
EDI Package ID: knb-lter-and.3143.9
Source XML: TV009_9.xml

Notice

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

Citation

Franklin, J.; Harmon, M. 2015. Dendrometer studies for stand volume and height measurements of trees of the western US, 1976 to 1993 Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/TV009 Accessed 2026-05-10.

Abstract

Dendrometry is used to get an accurate estimate of volume and height for individual trees. Volume tables or regressions may be generated. This method accurately accounts for taper by measuring at consecutive points up the bole.

Coverage

Temporal coverage: 1976-06-01 to 1993-04-13

Geographic coverage: Western United States

Spatial coverage:

Bounds: W -123.99604700, E -105.85903000, N 47.78499903, S 36.56212100

Purpose

No purpose entries listed in this EML file.

Project

Title: Long-Term Ecological Research

Personnel
  • Sherri L. Johnson - Principal Investigator
    US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: 541-758-7771
    Email: sherri.johnson2@usda.gov, sherri.johnson@oregonstate.edu
  • Julia A. Jones - Principal Investigator
    Oregon State University;Department of Geosciences; Wilkinson Hall 104, Corvallis, OR, 97331-5506, USA
    Phone: (541) 737-1224
    Email: Julia.Jones@oregonstate.edu, geojulia@comcast.net
    ORCID: http://orcid.org/0000-0001-9429-8925
  • Matthew G Betts - Principal Investigator
    Department of Forest Ecosystems and Society; 201E Richardson Hall; College of Forestry; Oregon State University, Corvallis, OR, 97331
    Phone: (541) 737-3841
    Email: matt.betts@oregonstate.edu
  • Michael P. Nelson - Principal Investigator
    Department of Forest Ecosystems and Society; 201K Richarson Hall; College of Forestry; Oregon State University, Corvallis, OR, 97331
    Phone: 541-737-9221
    Email: mpnelson@oregonstate.edu
    ORCID: http://orcid.org/0000-0001-6917-4752
  • David Bell - Principal Investigator
    Email: david.bell@usda.gov, david.bell@oregonstate.edu
Abstract
  • The H.J. Andrews Experimental Forest is a living laboratory that provides unparalleled opportunities for the study of forest and stream ecosystems in the central Cascade Range of Oregon. Since 1980, as a part of the National Science Foundation Long Term Ecological Research (NSF-LTER) program, the Andrews Experimental Forest has become a leader in the analysis of forest and stream ecosystem dynamics.
  • Long-term field experiments and measurement programs have focused on climate dynamics, streamflow, water quality, and vegetation succession. Currently researchers are working to develop concepts and tools needed to predict effects of natural disturbance, land use, and climate change on ecosystem structure, function, and species composition.
  • The Andrews Experimental Forest is administered cooperatively by the USDA Forest Service Pacific Northwest Research Station, Oregon State University and the Willamette National Forest. Funding for the research program comes from the National Science Foundation (NSF), US Forest Service Pacific Northwest Research Station, Oregon State University, and other sources.
Funding

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

Study Area Description
  • Long-Term Ecological Research
    The Andrews Forest is situated in the western Cascade Range of Oregon, and covers the entire 15,800-acre (6400-ha) drainage basin of Lookout Creek. Elevation ranges from 1350 to 5340 feet (410 to 1630 m). Broadly representative of the rugged mountainous landscape of the Pacific Northwest, the Andrews Forest contains excellent examples of the region's conifer forests and associated wildlife and stream ecosystems. These forests are among the tallest and most productive in the world, with tree heights of often greater than 250 ft (75 m). Streams are steep, cold and clean, providing habitat for numerous aquatic organisms.
Associated Party
  • Mark E. Harmon
    Role: Principal Investigator
    Oregon State University;Dept. of Forest Science;321 Richardson Hall, Corvallis, OR, 97331-5752, USA
    Phone: (541) 737-8455, (978) 724-0045 ext 223
    Email: mark.harmon@oregonstate.edu
  • Sarah E. Greene
    Role: Other Researcher
    USDA Forest Service;Pacific Northwest Research Station;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: (541) 750-7360
    Email: seginor@gmail.com, sgreene@fs.fed.us
  • Joseph E. Means
    Role: Former Investigator
    USDA Forest Service;Pacific Northwest Research Station;3200 SW Jefferson Way;, Corvallis, OR, 97331, USA
    Phone: (541) 750-7351
  • Sarah E. Greene
    Role: Abstractor
    USDA Forest Service;Pacific Northwest Research Station;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: (541) 750-7360
    Email: seginor@gmail.com, sgreene@fs.fed.us
  • 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
  • Information Manager
    Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331
    Email: hjaweb@fsl.orst.edu
  • Steven L. Garman
    USA
    Email: SLGarman@usgs.gov
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

Dendrometry is used to get an accurate estimate of volume and height for individual trees. Volume tables or regressions may be generated. This method accurately accounts for taper by measuring at consecutive points up the bole. Field Methods - TV009

Methods

Method Steps

Field Methods - TV009
  • Generally 30 trees per reference stand are measured, trying to set a representative sample of diameter classes.

Sampling

Study Extent
  • Sampling frequency: once only
Sampling Description
  • Generally 30 trees per reference stand are measured, trying to set a representative sample of diameter classes. These values are then entered into a specific program (STX) which calculates tree volume per tree and for the entire stand.
Spatial Sampling Units
  • Andrews Experimental Forest (HJA)
    W -122.26172200, E -122.10084700, N 44.28196400, S 44.19770400
    Altitude: 1631 to 1631 meter
  • Cascade Head Experimental Forest
    W -123.99172777, E -123.89730000, N 45.06476948, S 45.03130000
  • Mt. Rainier National Park
    W -121.91194510, E -121.53641010, N 46.94590700, S 46.75970700
  • Reference Stand TCTR, Torrey-Charlton RNA, Willamette NF
    W -121.98988694, E -121.98988694, N 43.76596138, S 43.76596138
    Altitude: 1726 to 1726 meter
  • Reference Stand RS01, H.J. Andrews EF, Willamette NF
    W -122.25882057, E -122.25694806, N 44.20296850, S 44.20177046
    Altitude: 559 to 559 meter
  • Reference Stand RS02, H.J. Andrews EF, Willamette NF
    W -122.24405016, E -122.24250891, N 44.21869615, S 44.21758772
    Altitude: 535 to 535 meter
  • Reference Stand RS03, H.J. Andrews EF, Willamette NF
    W -122.15980373, E -122.15787403, N 44.25917739, S 44.25819622
    Altitude: 987 to 987 meter
  • Reference Stand RS07, H.J. Andrews EF, Willamette NF
    W -122.25040993, E -122.24956136, N 44.21428064, S 44.21367034
    Altitude: 510 to 510 meter
  • Reference Stand RS15, H.J. Andrews EF, Willamette NF
    W -122.23947584, E -122.23947584, N 44.20940908, S 44.20940908
    Altitude: 735 to 735 meter
  • Reference Stand RS16, H.J. Andrews EF, Willamette NF
    W -122.24292582, E -122.24212024, N 44.21264655, S 44.21206714
    Altitude: 691 to 691 meter
  • Reference Stand RS20, H.J. Andrews EF, Willamette NF
    W -122.25048522, E -122.25048522, N 44.22179408, S 44.22179408
    Altitude: 706 to 706 meter
  • Reference Stand RS24, Hagan Block RNA, Willamette NF
    W -122.42388664, E -122.42388664, N 44.17229527, S 44.17229527
  • Reference Stand CH14, Cascade Head EF, Douglas-fir
    W -123.91830000, E -123.91830000, N 45.04170000, S 45.04170000
    Altitude: 139 to 139 meter
  • Reference Stand CH01, Cascade Head EF, hemlock-spruce
    W -123.89730000, E -123.89730000, N 45.04560000, S 45.04560000
    Altitude: 298 to 298 meter
  • Reference Stand CH03, Cascade Head EF, hemlock-spruce
    W -123.90400156, E -123.90400156, N 45.04565431, S 45.04565431
    Altitude: 243 to 243 meter
  • Reference Stand CH04, Cascade Head EF, hemlock-spruce
    W -123.94127806, E -123.94127806, N 45.06476948, S 45.06476948
  • Reference Stand CH05, Cascade Head EF, hemlock-spruce
    W -123.94230324, E -123.94230324, N 45.06531912, S 45.06531912
    Altitude: 244 to 244 meter
  • Reference Stand CH06, Cascade Head EF, hemlock-spruce
    W -123.93909079, E -123.93909079, N 45.06151088, S 45.06151088
  • Reference Stand CH07, Cascade Head EF, hemlock-spruce
    W -123.93978362, E -123.93978362, N 45.06271141, S 45.06271141
  • Reference Stand CH08, Cascade Head EF, hemlock-spruce
    W -123.94526370, E -123.94526370, N 45.06460149, S 45.06460149
    Altitude: 244 to 244 meter
  • Reference Stand CH09, Cascade Head EF, hemlock-spruce
    W -123.99604700, E -123.99604700, N 45.05883900, S 45.05883900
  • Reference Stand CH10, Cascade Head EF, hemlock-spruce
    W -123.99172777, E -123.99172777, N 45.06310277, S 45.06310277
    Altitude: 279 to 279 meter
  • Reference Stand CH12, Cascade Head EF, hemlock-spruce
    W -123.90120006, E -123.90120006, N 45.04999731, S 45.04999731
    Altitude: 243 to 243 meter
  • Reference Stand CH13, Cascade Head EF, hemlock-spruce
    W -123.90175355, E -123.90175355, N 45.05128019, S 45.05128019
    Altitude: 247 to 247 meter
  • Reference Stand HR01, South Fork Hoh River, Olympic NP
    W -123.91819273, E -123.91819273, N 47.78499903, S 47.78499903
    Altitude: 245 to 245 meter
  • Reference Stand HR02, South Fork Hoh River, Olympic NP
    W -123.91819273, E -123.91819273, N 47.78499903, S 47.78499903
    Altitude: 245 to 245 meter
  • Reference Stand HR03, South Fork Hoh River, Olympic NP
    W -123.90572570, E -123.90572570, N 47.78051829, S 47.78051829
    Altitude: 250 to 250 meter
  • Reference Stand HR04, South Fork Hoh River, Olympic NP
    W -123.90572570, E -123.90572570, N 47.78051829, S 47.78051829
    Altitude: 250 to 250 meter
  • Reference Stand HS02, Quinault RNA, Olympic NP
    W -123.87450473, E -123.87450473, N 47.42708879, S 47.42708879
  • Reference Stand HS03, Quinault RNA, Olympic NP
    W -123.87581879, E -123.87581879, N 47.42796958, S 47.42796958
  • Reference Stand NCNA, Neskowin Crest RNA, Siuslaw NF
    W -123.97810000, E -123.97810000, N 45.07760000, S 45.07760000
    Altitude: 278 to 278 meter
  • Reference Stand SP06, Santiam Pass, Willamette NF
    W -121.85207267, E -121.85207267, N 44.42195227, S 44.42195227
  • Reference Stand BLNF, Blue Lake, Gifford Pinchot NF
    W -122.25800000, E -122.25800000, N 46.17700000, S 46.17700000
  • Reference Stand BPNF, Benson Plateau, Mount Hood NF
    W -121.85033100, E -121.85033100, N 45.64166800, S 45.64166800
  • Reference Stand CMNF, Carpenter Mtn, Blue R, Willamette NF
    W -122.15757248, E -122.15757248, N 44.27505533, S 44.27505533
    Altitude: 1358 to 1358 meter
  • Reference Stand GMNF, Goat Marsh RNA, Gifford Pinchot NF
    W -122.27548379, E -122.27548379, N 46.17465620, S 46.17465620
    Altitude: 952 to 952 meter
  • Reference Stand HPNF, Huffman Peak, Gifford Pinchot NF
    W -122.17768700, E -122.17768700, N 45.97506300, S 45.97506300
  • Reference Stand MPNF, Mary's Peak, Siuslaw NF
    W -123.55851300, E -123.55851300, N 44.51221700, S 44.51221700
  • Reference Stand NWNF, North Wilson, Mount Hood NF
    W -121.65757300, E -121.65757300, N 45.09246600, S 45.09246600
  • Reference Stand WLNF, Wahtum Lake, Mount Hood NF
    W -121.79667900, E -121.79667900, N 45.58934000, S 45.58934000
  • Reference Stand WMNF, Wildcat Mtn RNA, Willamette NF
    W -122.11820200, E -122.11820200, N 44.34002600, S 44.34002600
  • Reference Stand YBNF, Yacolt Burn, Gifford Pinchot NF
    W -122.17284900, E -122.17284900, N 45.78876500, S 45.78876500
  • Reference Stand YSNF, Yarder sale, Wahtum Lake, Mt. Hood NF
    W -121.77992300, E -121.77992300, N 45.57014000, S 45.57014000
  • Reference Stand RS10, H.J. Andrews EF, Willamette NF
    W -122.21915148, E -122.21828692, N 44.23366010, S 44.23303850
    Altitude: 626 to 626 meter
  • Reference Stand RS27, H.J. Andrews EF, Willamette NF
    W -122.17802149, E -122.17624662, N 44.25443528, S 44.25316474
    Altitude: 808 to 808 meter
  • Reference Stand RS32, H.J. Andrews EF, Willamette NF
    W -122.19098031, E -122.19098031, N 44.23572829, S 44.23572829
    Altitude: 660 to 660 meter
  • Reference Stand RS37, South Fork Hagan Creek, Willamette NF
    W -122.42557977, E -122.42557977, N 44.16533518, S 44.16533518
  • Reference Stand MRNA, Metolius RNA, Deschutes NF
    W -121.63325593, E -121.63325593, N 44.49076908, S 44.49076908
  • Reference Stand FRC3, Fraser EF, CO, lodgepole pine
    W -105.85903000, E -105.85903000, N 39.90398200, S 39.90398200
  • Reference Stand FRD1, Fraser EF, CO, spruce-fir
    W -105.86349500, E -105.86349500, N 39.89871600, S 39.89871600
  • Reference Stand AB08, White River, Mt. Rainier NP
    W -121.53767800, E -121.53767800, N 46.92059540, S 46.92059540
  • Reference Stand AE10, Nisqually River, Mt. Rainier NP
    W -121.74354233, E -121.74354233, N 46.76763350, S 46.76763350
    Altitude: 1428 to 1428 meter
  • Reference Stand AG05, Nisqually River, Mt. Rainier NP
    W -121.80521225, E -121.80521225, N 46.74764989, S 46.74764989
    Altitude: 968 to 968 meter
  • Reference Stand AM16, Nisqually River, Mt. Rainier NP
    W -121.75847340, E -121.75847340, N 46.76848075, S 46.76848075
  • Reference Stand AO03, Ohanapecosh River, Mt. Rainier NP
    W -121.54801780, E -121.54801780, N 46.82607494, S 46.82607494
  • Reference Stand AR07, Nisqually River, Mt. Rainier NP
    W -121.74737580, E -121.74737580, N 46.77574944, S 46.77574944
    Altitude: 1435 to 1435 meter
  • Reference Stand AR19, White River, Mt. Rainier NP
    W -121.59531073, E -121.59531073, N 46.91084487, S 46.91084487
  • Reference Stand AV02, Ohanapecosh River, Mt. Rainier NP
    W -122.55019658, E -122.55019658, N 46.82318258, S 46.82318258
  • Reference Stand AV06, Nisqually River, Mt. Rainier NP
    W -121.78509240, E -121.78509240, N 46.77602294, S 46.77602294
    Altitude: 1071 to 1071 meter
  • Reference Stand AV14, Carbon River, Mt. Rainier NP
    W -121.84712600, E -121.84712600, N 46.96037775, S 46.96037775
  • Reference Stand AX15, Nisqually River, Mt. Rainier NP
    W -121.82422280, E -121.82422280, N 46.74979152, S 46.74979152
    Altitude: 1072 to 1072 meter
  • Reference Stand PP17, White River, Mt. Rainier NP
    W -121.60247527, E -121.60247527, N 46.89456539, S 46.89456539
  • Reference Stand TA01, Ohanapecosh River, Mt. Rainier NP
    W -121.55873458, E -121.55873458, N 46.74178086, S 46.74178086
  • Reference Stand TB13, Nisqually River, Mt. Rainier NP
    W -121.84874419, E -121.84874419, N 46.74005371, S 46.74005371
  • Reference Stand TO04, Nisqually River, Mt. Rainier NP
    W -121.88923161, E -121.88923161, N 46.74264071, S 46.74264071
  • Reference Stand TO11, Carbon River, Mt. Rainier NP
    W -121.88730592, E -121.88730592, N 46.99660843, S 46.99660843
  • Reference Stand CCNF, Cushman Crest, Mt. Rainier NP
    W -121.77117837, E -121.77117837, N 46.78177754, S 46.78177754
  • Reference Stand SRNF, Sunrise Ridge, Mt. Rainier NP
    W -121.56100000, E -121.56100000, N 46.92400000, S 46.92400000
  • Reference Stand ABCO, Suwanee Creek, Sequoia NP, white fir
    W -118.79624600, E -118.79624600, N 36.60124500, S 36.60124500
  • Reference Stand LMCC, Crescent Creek, Sequoia NP
    W -118.73998200, E -118.73998200, N 36.56212100, S 36.56212100
  • Reference Stand PIJE, Sequoia NP, Jeffrey pine
    W -118.74360900, E -118.74360900, N 36.60700000, S 36.60700000
  • Reference Stand PILA, Suwanee Creek, Sequoia NP, sugar pine
    W -118.79813500, E -118.79813500, N 36.60510200, S 36.60510200
  • Reference Stand SUCR, Suwanee Cr, Sequoia NP, mixed conifer
    W -118.79732500, E -118.79732500, N 36.60531100, S 36.60531100
  • Reference Stand UCRS, Upper Crescent Cr, Sequoia NP, SEGI
    W -118.73521700, E -118.73521700, N 36.56544200, S 36.56544200
  • Reference Stand TCNF, Three Corner Rock, Washington DNR
    W -122.03941300, E -122.03941300, N 45.73345300, S 45.73345300
  • Reference Stand CH11, Cascade Head EF, hemlock-spruce
    W -123.90952468, E -123.90952468, N 45.04168140, S 45.04168140
  • Reference Stand CH15, Cascade Head EF, alder-conifer
    W -123.90957998, E -123.90957998, N 45.04111037, S 45.04111037
  • Torrey-Charlton RNA
    W -121.98988694, E -121.98988694, N 43.76596138, S 43.76596138
    Altitude: 1726 to 1726 meter
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: stand structure (theme), silviculture (theme), dendrochronology (theme), measurements (theme), plant properties (theme), plant height (theme), trophic structure (theme), dendrometers (theme), primary production (theme), organic matter (theme)
  • Andrews Experimental Forest site thesaurus: Long-Term Ecological Research (LTER) (theme)
  • LTER core research areas: primary production (theme), organic matter (theme)
Taxonomic Hierarchy
  • All Organisms: All Organisms
  • Highest common category (ca. kingdom): Animalia
  • Class: Aves
  • Order: Passeriformes
  • Family: Fringillidae
  • Genus: Carduelis
  • Species: Carduelis pinus
  • Highest common category (ca. kingdom): Plantae
  • Division or Phylum: Coniferophyta
  • Class: Pinopsida
  • Order: Taxales
  • Family: Taxaceae
  • Genus: Taxus
  • Species: Taxus brevifolia
  • Order: Pinales
  • Family: Cupressaceae
  • Genus: Calocedrus
  • Species: Calocedrus decurrens
  • Genus: Chamaecyparis
  • Species: Chamaecyparis nootkatensis
  • Species: Chamaecyparis lawsoniana
  • Genus: Thuja
  • Species: Thuja plicata
  • Family: Pinaceae
  • Genus: Tsuga
  • Species: Tsuga heterophylla
  • Species: Tsuga mertensiana
  • Genus: Pinus
  • Species: Pinus ponderosa
  • Species: Pinus lambertiana
  • Species: Pinus contorta
  • Species: Pinus jeffreyi
  • Species: Pinus monticola
  • Genus: Picea
  • Species: Picea engelmannii
  • Species: Picea sitchensis
  • Genus: Abies
  • Species: Abies procera
  • Species: Abies lasiocarpa
  • Species: Abies concolor
  • Species: Abies amabilis
  • Species: Abies grandis
  • Species: Abies magnifica
  • Genus: Pseudotsuga
  • Species: Pseudotsuga menziesii
  • Family: Taxodiaceae
  • Genus: Sequoiadendron
  • Species: Sequoiadendron giganteum
  • Division or Phylum: Magnoliophyta
  • Class: Magnoliopsida
  • Subclass: Hamamelididae
  • Order: Fagales
  • Family: Betulaceae
  • Genus: Alnus
  • Species: Alnus rubra
  • Family: Fagaceae
  • Genus: Chrysolepis
  • Species: Castanopsis chrysophylla
  • Genus: Quercus
  • Species: Quercus garryana
  • Species: Quercus kelloggii
  • Genus: Lithocarpus
  • Species: Lithocarpus densiflorus
  • Subclass: Rosidae
  • Order: Sapindales
  • Family: Aceraceae
  • Genus: Acer
  • Species: Acer macrophyllum
  • Subclass: Dilleniidae
  • Order: Ericales
  • Family: Ericaceae
  • Genus: Arbutus
  • Species: Arbutus menziesii
Data Entities
# Entity Metadata Data
1 TV00901
TV00901
Dendrometer Measurements - format 1:
 METADATA DATA
2 TV00902
TV00902
Dendrometer Measurements - format 2:
 METADATA DATA
3 TV00903
TV00903
Dendrometer Measurements - format 3:
 METADATA DATA
4 TV00904
TV00904
Dendrometer Measurements - format 4:
 METADATA DATA
5 TV00905
TV00905
Dendrometer Measurements - format 5:
 METADATA DATA
6 TV00906
TV00906
Dendrometer Log Summaries:
 METADATA DATA
7 TV00907
TV00907
Dendrometer Tree Summaries:
 METADATA DATA
8 TV00908
TV00908
Dendrometer Regression Equations:
 METADATA DATA
9 TV00909
TV00909
Regression of Diameter Increment on Crown Ratio by Canopy Cl:
 METADATA DATA
10 TV00910
TV00910
Asymptotic Height-Diameter Equations for 24 Tree Species:
 METADATA DATA
Metadata
TV00901 - TV00901

Object name: TV00901.csv

Records: 2081

Attributes: 12

Temporal coverage: 1976-06-01 to 1993-04-13

File size: 122867 byte

Checksum (MD5): dd808588db134aa05765b9696e4da2d8

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

Constraints (1)
  • notNullConstraint: NOTNULL
    TV00901.DATACODE, TV00901.FORMAT, TV00901.SPECIES, TV00901.STAND, TV00901.STUDYID
Attributes (12)
DATACODE - char(5) (nominal)

ID: TV00901.DATACODE

Data set code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • TV009
    FSDB database code TV009 (terrestrial vegetation)
FORMAT - numeric(2,0) (interval)

ID: TV00901.FORMAT

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

STUDYID - char(4) (nominal)

ID: TV00901.STUDYID

Study area name

Type system: Microsoft SQL Server 2008

Code definitions (19)
  • AKRS
    Noatak National Park, Alaska
  • CASC
    Pooled data for all cascade range studyid's
  • CHEF
    Cascade head experimental forest (hsgy)
  • COAS
    Cascade Head Experimental Forest (HSGY)
  • DFGY
    Douglas fir growth and yield
  • HSGY
    Hemlock-spruce growth and yield
  • LTER
    Watershed 2 and Hagan block lter transects (tree data)
  • MEND
    Mendel unit snags at the hj andrews experimenatl forest
  • MHGY
    Mountain hemlock growth and yield
  • MHVL
    Mountain hemlock volume study
  • MISC
    Miscellaneous reference stands
  • MRRS
    Mt Rainier reference stands
  • NFGY
    Noble fir growth and yield
  • OHJA
    H.J. Andrews reference stands
  • PPGY
    Ponderosa pine growth and yield
  • RMRS
    Rocky Mtn. reference stands
  • SNAG
    Snag study (at Cascade Head and Sequoia Natl. Park)
  • SQNP
    Sequoia national park reference stands
  • THIN
    Greene and Emmingham thinning plots (see study code FS024)
STAND - char(4) (nominal)

ID: TV00901.STAND

Plot or reference stand or plot in transect

Type system: Microsoft SQL Server 2008

Code definitions (156)
  • RS01
    Reference Stand RS01, H.J. Andrews EF, Willamette NF
  • RS02
    Reference Stand RS02, H.J. Andrews EF, Willamette NF
  • RS03
    Reference Stand RS03, H.J. Andrews EF, Willamette NF
  • RS07
    Reference Stand RS07, H.J. Andrews EF, Willamette NF
  • RS15
    Reference Stand RS15, H.J. Andrews EF, Willamette NF
  • RS16
    Reference Stand RS16, H.J. Andrews EF, Willamette NF
  • RS20
    Reference Stand RS20, H.J. Andrews EF, Willamette NF
  • RS24
    Reference Stand RS24, Hagan Block RNA, Willamette NF
  • CHEF
    Cascade Head Experimental Forest
  • CH14
    Reference Stand CH14, Cascade Head EF, Douglas-fir
  • CH01
    Reference Stand CH01, Cascade Head EF, hemlock-spruce
  • CH03
    Reference Stand CH03, Cascade Head EF, hemlock-spruce
  • CH04
    Reference Stand CH04, Cascade Head EF, hemlock-spruce
  • CH05
    Reference Stand CH05, Cascade Head EF, hemlock-spruce
  • CH06
    Reference Stand CH06, Cascade Head EF, hemlock-spruce
  • CH07
    Reference Stand CH07, Cascade Head EF, hemlock-spruce
  • CH08
    Reference Stand CH08, Cascade Head EF, hemlock-spruce
  • CH09
    Reference Stand CH09, Cascade Head EF, hemlock-spruce
  • CH10
    Reference Stand CH10, Cascade Head EF, hemlock-spruce
  • CH12
    Reference Stand CH12, Cascade Head EF, hemlock-spruce
  • CH13
    Reference Stand CH13, Cascade Head EF, hemlock-spruce
  • HR01
    Reference Stand HR01, South Fork Hoh River, Olympic NP
  • HR02
    Reference Stand HR02, South Fork Hoh River, Olympic NP
  • HR03
    Reference Stand HR03, South Fork Hoh River, Olympic NP
  • HR04
    Reference Stand HR04, South Fork Hoh River, Olympic NP
  • HS02
    Reference Stand HS02, Quinault RNA, Olympic NP
  • HS03
    Reference Stand HS03, Quinault RNA, Olympic NP
  • NCNA
    Reference Stand NCNA, Neskowin Crest RNA, Siuslaw NF
  • SP06
    Reference Stand SP06, Santiam Pass, Willamette NF
  • BLNF
    Reference Stand BLNF, Blue Lake, Gifford Pinchot NF
  • BPNF
    Reference Stand BPNF, Benson Plateau, Mount Hood NF
  • CMNF
    Reference Stand CMNF, Carpenter Mtn, Blue R, Willamette NF
  • GMNF
    Reference Stand GMNF, Goat Marsh RNA, Gifford Pinchot NF
  • HPNF
    Reference Stand HPNF, Huffman Peak, Gifford Pinchot NF
  • MPNF
    Reference Stand MPNF, Mary's Peak, Siuslaw NF
  • NWNF
    Reference Stand NWNF, North Wilson, Mount Hood NF
  • WLNF
    Reference Stand WLNF, Wahtum Lake, Mount Hood NF
  • WMNF
    Reference Stand WMNF, Wildcat Mtn RNA, Willamette NF
  • YBNF
    Reference Stand YBNF, Yacolt Burn, Gifford Pinchot NF
  • YSNF
    Reference Stand YSNF, Yarder sale, Wahtum Lake, Mt. Hood NF
  • RS10
    Reference Stand RS10, H.J. Andrews EF, Willamette NF
  • RS27
    Reference Stand RS27, H.J. Andrews EF, Willamette NF
  • RS32
    Reference Stand RS32, H.J. Andrews EF, Willamette NF
  • RS37
    Reference Stand RS37, South Fork Hagan Creek, Willamette NF
  • MRNA
    Reference Stand MRNA, Metolius RNA, Deschutes NF
  • FRC3
    Reference Stand FRC3, Fraser EF, CO, lodgepole pine
  • FRD1
    Reference Stand FRD1, Fraser EF, CO, spruce-fir
  • AB08
    Reference Stand AB08, White River, Mt. Rainier NP
  • AE10
    Reference Stand AE10, Nisqually River, Mt. Rainier NP
  • AG05
    Reference Stand AG05, Nisqually River, Mt. Rainier NP
  • AM16
    Reference Stand AM16, Nisqually River, Mt. Rainier NP
  • AO03
    Reference Stand AO03, Ohanapecosh River, Mt. Rainier NP
  • AR07
    Reference Stand AR07, Nisqually River, Mt. Rainier NP
  • AR19
    Reference Stand AR19, White River, Mt. Rainier NP
  • AV02
    Reference Stand AV02, Ohanapecosh River, Mt. Rainier NP
  • AV06
    Reference Stand AV06, Nisqually River, Mt. Rainier NP
  • AV14
    Reference Stand AV14, Carbon River, Mt. Rainier NP
  • AX15
    Reference Stand AX15, Nisqually River, Mt. Rainier NP
  • PP17
    Reference Stand PP17, White River, Mt. Rainier NP
  • TA01
    Reference Stand TA01, Ohanapecosh River, Mt. Rainier NP
  • TB13
    Reference Stand TB13, Nisqually River, Mt. Rainier NP
  • TO04
    Reference Stand TO04, Nisqually River, Mt. Rainier NP
  • TO11
    Reference Stand TO11, Carbon River, Mt. Rainier NP
  • CCNF
    Reference Stand CCNF, Cushman Crest, Mt. Rainier NP
  • SRNF
    Reference Stand SRNF, Sunrise Ridge, Mt. Rainier NP
  • ABCO
    Reference Stand ABCO, Suwanee Creek, Sequoia NP, white fir
  • LMCC
    Reference Stand LMCC, Crescent Creek, Sequoia NP
  • PIJE
    Reference Stand PIJE, Sequoia NP, Jeffrey pine
  • PILA
    Reference Stand PILA, Suwanee Creek, Sequoia NP, sugar pine
  • SUCR
    Reference Stand SUCR, Suwanee Cr, Sequoia NP, mixed conifer
  • UCRS
    Reference Stand UCRS, Upper Crescent Cr, Sequoia NP, SEGI
  • TCNF
    Reference Stand TCNF, Three Corner Rock, Washington DNR
  • CH11
    Reference Stand CH11, Cascade Head EF, hemlock-spruce
  • CH15
    Reference Stand CH15, Cascade Head EF, alder-conifer
  • 13
    Deschutes NF, John Bell data, Greg Johnson plot 13
  • 20
    Deschutes NF, John Bell data, Greg Johnson plot 20
  • 2233
    Willamette NF, Detroit Rd, Road 2233 flats
  • 23
    Deschutes NF, John Bell data, Greg Johnson plot 23
  • 25
    Deschutes NF, John Bell data, Greg Johnson plot 25
  • 2618
    Ashland, atzet plot 2618, Rogue River NF
  • 2619
    Ashland, atzet plot 2619, Rogue River NF
  • 2623
    Ashland, atzet plot 2623, Rogue River NF
  • 2631
    Ashland, atzet plot 2631, Rogue River NF
  • 2632
    Ashland, atzet plot 2632, Rogue River NF
  • 29
    Deschutes NF, John Bell data, Greg Johnson plot 29
  • 3
    Deschutes NF, John Bell data, Greg Johnson plot 3
  • 30
    Deschutes NF, John Bell data, Greg Johnson plot 30
  • 31
    Deschutes NF, John Bell data, Greg Johnson plot 31
  • 32
    Deschutes NF, John Bell data, Greg Johnson plot 32
  • 348
    Willamette NF, Detroit rd, Hemstrom plot # 348
  • 35
    Deschutes NF, John Bell data, Greg Johnson plot 35
  • 353
    Willamette NF, Detroit rd, Hemstrom plot # 353
  • 4
    Deschutes NF, John Bell data, Greg Johnson plot 4
  • CH02
    Cascade Head EF, CHO2
  • CH16
    Cascade Head EF, CH16
  • GP-1
    Gifford Pinchot NF, Packwood rd , road 45, GP-1
  • GP-2
    Gifford Pinchot NF, Packwood rd , road 45, GP-2
  • GP-3
    Gifford Pinchot NF, Packwood rd , White Pass
  • GP-4
    Gifford Pinchot NF, Mt.Adams rd
  • HM33
    Willamette NF, Detroit rd, Hemstrom plot # 332
  • MB10
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB10
  • MB11
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB11
  • MB12
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB12
  • MB13
    Mt. Baker- Snoqualmie NF, Darrington RD, MB13
  • MB14
    Mt. Baker- Snoqualmie NF, Darrington RD, MB14
  • MB15
    Mt. Baker- Snoqualmie NF, Darrington RD, MB15
  • MB16
    Mt. Baker- Snoqualmie NF, Darrington RD, MB16
  • MB17
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB17
  • MB18
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB18
  • MB19
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB19
  • MB20
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB20
  • MB21
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB21
  • MB22
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB22
  • MB23
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB23
  • MB24
    Mt. Baker- Snoqualmie NF, North Bend RD, MB24
  • MB25
    Mt. Baker- Snoqualmie NF, North Bend RD, MB25
  • MB26
    Mt. Baker- Snoqualmie NF, North Bend RD, MB26
  • MB27
    Mt. Baker- Snoqualmie NF, North Bend RD, MB27
  • MB28
    Mt. Baker- Snoqualmie NF, North Bend RD, MB28
  • MBS1
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS1
  • MBS2
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS2
  • MBS3
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS3
  • MBS4
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS4
  • MBS5
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS5
  • MBS6
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS6
  • MBS7
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS7
  • MBS8
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS8
  • MBS9
    Mt. Baker- Snoqualmie NF, Darrington RD, MBS9
  • MH-1
    Mt. Hood, Hood River R.D., Recon plot 0003, N. Halvorsen
  • MH-2
    Mt. Hood, Hood River R.D., MH-2
  • MH-3
    Mt. Hood, Hood River R.D., Road 3540
  • MH-4
    Mt. Hood, Hood River R.D., MH-4
  • MH-5
    Mt. Hood, Hood River R.D., MH-5
  • MH-6
    Mt. Hood, Hood River R.D., MH-6
  • MHVL
    Deschutes NF, John Bell data, Greg Johnson plot 2
  • RAIN
    Mt. Rainier, RAIN
  • SUMM
    Deschutes NF, Santiam Pass Summit, John Bell data
  • TCMH
    Torrey-Charlton RNA
  • UMP1
    Umpqua NF, Diamond Lake RD, Cinnamon Butte
  • UMP2
    Umpqua NF, UMP2
  • UMP3
    Willamette NF, Rigdon RD
  • UMP4
    Willamette NF, Fairview Peak
  • WEN1
    Wenatchee NF, Wenatchee RD
  • WEN2
    Wenatchee NF, Wenatchee RD, Miner's Ridge
  • WEN3
    Wenatchee NF, Naches RD, WEN3
  • WEN4
    Wenatchee NF, Naches RD, Pinegrass Ridge
  • WEN5
    Wenatchee NF, Naches RD, WEN5
  • WEN6
    Wenatchee NF, Naches RD, Bethel Ridge, WEN6
  • WEN7
    Wenatchee NF, Naches RD, Bethel Ridge, WEN7
  • WEN8
    Wenatchee NF, Naches RD, Section 3 Lake
  • WIL1
    Willamette NF, Blue River RD, Carpenter Mtn
  • WIL2
    Santiam Pass, Gholz Ref. Stand
  • WIND
    Deschutes NF, Windigo Pass, John Bell data
  • BMTN
    Reference Stand BMTN, Sequoia NP
  • WOLV
    Reference Stand WOLV , Sequoia NP
  • MEND
    Mendel unit, HJ Andrews Experimental Forest
SUBPLOT - numeric(2,0) (interval)

ID: TV00901.SUBPLOT

Subplot of reference stand

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

TREENUM - numeric(4,0) (interval)

ID: TV00901.TREENUM

Tree tag number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TV00901.YEAR

Year

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SPECIES - char(5) (nominal)

ID: TV00901.SPECIES

Tree species code after Garrison et al., 1972

Type system: Microsoft SQL Server 2008

Code definitions (29)
  • ABAM
    Abies amabilis
  • ABCO
    Abies concolor
  • ABGR
    Abies grandis
  • ABLA2
    Abies lasiocarpa
  • ABMA
    Abies magnifica
  • ABPR
    Abies procera
  • ACMA
    Acer macrophyllum
  • ALRU
    Alnus rubra
  • ARME
    Arbutus menziesii
  • CADE3
    Calocedrus decurrens
  • CHLA
    Chamaecyparis lawsoniana
  • CHNO
    Chamaecyparis nootkatensis
  • LIDE
    Lithocarpus densiflorus
  • PIEN
    Picea engelmannii
  • PISI
    Picea sitchensis
  • PICO
    Pinus contorta
  • PIJE
    Pinus jeffreyi
  • PILA
    Pinus lambertiana
  • PIMO
    Pinus monticola
  • PIPO
    Pinus ponderosa
  • PSME
    Pseudotsuga menziesii
  • QUGA
    Quercus garryana
  • QUKE
    Quercus kelloggii
  • TABR
    Taxus brevifolia
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • TSME
    Tsuga mertensiana
  • CACH
    Castanopsis chrysophylla
  • SEGI
    Sequoiadendron giganteum
DBH - numeric(5,1) (ratio)

ID: TV00901.DBH

Diameter at breast height

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

BARK1 - numeric(4,1) (ratio)

ID: TV00901.BARK1

Bark thickness - measured at two locations at dbh to get average thickness

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

BARK2 - numeric(4,1) (ratio)

ID: TV00901.BARK2

Bark thickness - measured at two locations at dbh to get average thickness

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

SAMPLEDATE - datetime (dateTime)

ID: TV00901.SAMPLEDATE

date

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TV00902 - TV00902

Object name: TV00902.csv

Records: 2081

Attributes: 17

File size: 154774 byte

Checksum (MD5): 7c8ae1cee16b8ec10cf95e8de88977da

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

Constraints (1)
  • notNullConstraint: NOTNULL
    TV00902.DATACODE, TV00902.FORMAT, TV00902.STAND, TV00902.STUDYID
Attributes (17)
DATACODE - char(5) (nominal)

ID: TV00902.DATACODE

Data set code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • TV009
    FSDB database code TV009 (terrestrial vegetation)
FORMAT - numeric(2,0) (interval)

ID: TV00902.FORMAT

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

STUDYID - char(4) (nominal)

ID: TV00902.STUDYID

Study area name

Type system: Microsoft SQL Server 2008

Code definitions (19)
  • AKRS
    Noatak National Park, Alaska
  • CASC
    Pooled data for all cascade range studyid's
  • CHEF
    Cascade head experimental forest (hsgy)
  • COAS
    Cascade Head Experimental Forest (HSGY)
  • DFGY
    Douglas fir growth and yield
  • HSGY
    Hemlock-spruce growth and yield
  • LTER
    Watershed 2 and Hagan block lter transects (tree data)
  • MEND
    Mendel unit snags at the hj andrews experimenatl forest
  • MHGY
    Mountain hemlock growth and yield
  • MHVL
    Mountain hemlock volume study
  • MISC
    Miscellaneous reference stands
  • MRRS
    Mt Rainier reference stands
  • NFGY
    Noble fir growth and yield
  • OHJA
    H.J. Andrews reference stands
  • PPGY
    Ponderosa pine growth and yield
  • RMRS
    Rocky Mtn. reference stands
  • SNAG
    Snag study (at Cascade Head and Sequoia Natl. Park)
  • SQNP
    Sequoia national park reference stands
  • THIN
    Greene and Emmingham thinning plots (see study code FS024)
STAND - char(4) (nominal)

ID: TV00902.STAND

Plot or reference stand or plot in transect

Type system: Microsoft SQL Server 2008

Code definitions (156)
  • RS01
    Reference Stand RS01, H.J. Andrews EF, Willamette NF
  • RS02
    Reference Stand RS02, H.J. Andrews EF, Willamette NF
  • RS03
    Reference Stand RS03, H.J. Andrews EF, Willamette NF
  • RS07
    Reference Stand RS07, H.J. Andrews EF, Willamette NF
  • RS15
    Reference Stand RS15, H.J. Andrews EF, Willamette NF
  • RS16
    Reference Stand RS16, H.J. Andrews EF, Willamette NF
  • RS20
    Reference Stand RS20, H.J. Andrews EF, Willamette NF
  • RS24
    Reference Stand RS24, Hagan Block RNA, Willamette NF
  • CHEF
    Cascade Head Experimental Forest
  • CH14
    Reference Stand CH14, Cascade Head EF, Douglas-fir
  • CH01
    Reference Stand CH01, Cascade Head EF, hemlock-spruce
  • CH03
    Reference Stand CH03, Cascade Head EF, hemlock-spruce
  • CH04
    Reference Stand CH04, Cascade Head EF, hemlock-spruce
  • CH05
    Reference Stand CH05, Cascade Head EF, hemlock-spruce
  • CH06
    Reference Stand CH06, Cascade Head EF, hemlock-spruce
  • CH07
    Reference Stand CH07, Cascade Head EF, hemlock-spruce
  • CH08
    Reference Stand CH08, Cascade Head EF, hemlock-spruce
  • CH09
    Reference Stand CH09, Cascade Head EF, hemlock-spruce
  • CH10
    Reference Stand CH10, Cascade Head EF, hemlock-spruce
  • CH12
    Reference Stand CH12, Cascade Head EF, hemlock-spruce
  • CH13
    Reference Stand CH13, Cascade Head EF, hemlock-spruce
  • HR01
    Reference Stand HR01, South Fork Hoh River, Olympic NP
  • HR02
    Reference Stand HR02, South Fork Hoh River, Olympic NP
  • HR03
    Reference Stand HR03, South Fork Hoh River, Olympic NP
  • HR04
    Reference Stand HR04, South Fork Hoh River, Olympic NP
  • HS02
    Reference Stand HS02, Quinault RNA, Olympic NP
  • HS03
    Reference Stand HS03, Quinault RNA, Olympic NP
  • NCNA
    Reference Stand NCNA, Neskowin Crest RNA, Siuslaw NF
  • SP06
    Reference Stand SP06, Santiam Pass, Willamette NF
  • BLNF
    Reference Stand BLNF, Blue Lake, Gifford Pinchot NF
  • BPNF
    Reference Stand BPNF, Benson Plateau, Mount Hood NF
  • CMNF
    Reference Stand CMNF, Carpenter Mtn, Blue R, Willamette NF
  • GMNF
    Reference Stand GMNF, Goat Marsh RNA, Gifford Pinchot NF
  • HPNF
    Reference Stand HPNF, Huffman Peak, Gifford Pinchot NF
  • MPNF
    Reference Stand MPNF, Mary's Peak, Siuslaw NF
  • NWNF
    Reference Stand NWNF, North Wilson, Mount Hood NF
  • WLNF
    Reference Stand WLNF, Wahtum Lake, Mount Hood NF
  • WMNF
    Reference Stand WMNF, Wildcat Mtn RNA, Willamette NF
  • YBNF
    Reference Stand YBNF, Yacolt Burn, Gifford Pinchot NF
  • YSNF
    Reference Stand YSNF, Yarder sale, Wahtum Lake, Mt. Hood NF
  • RS10
    Reference Stand RS10, H.J. Andrews EF, Willamette NF
  • RS27
    Reference Stand RS27, H.J. Andrews EF, Willamette NF
  • RS32
    Reference Stand RS32, H.J. Andrews EF, Willamette NF
  • RS37
    Reference Stand RS37, South Fork Hagan Creek, Willamette NF
  • MRNA
    Reference Stand MRNA, Metolius RNA, Deschutes NF
  • FRC3
    Reference Stand FRC3, Fraser EF, CO, lodgepole pine
  • FRD1
    Reference Stand FRD1, Fraser EF, CO, spruce-fir
  • AB08
    Reference Stand AB08, White River, Mt. Rainier NP
  • AE10
    Reference Stand AE10, Nisqually River, Mt. Rainier NP
  • AG05
    Reference Stand AG05, Nisqually River, Mt. Rainier NP
  • AM16
    Reference Stand AM16, Nisqually River, Mt. Rainier NP
  • AO03
    Reference Stand AO03, Ohanapecosh River, Mt. Rainier NP
  • AR07
    Reference Stand AR07, Nisqually River, Mt. Rainier NP
  • AR19
    Reference Stand AR19, White River, Mt. Rainier NP
  • AV02
    Reference Stand AV02, Ohanapecosh River, Mt. Rainier NP
  • AV06
    Reference Stand AV06, Nisqually River, Mt. Rainier NP
  • AV14
    Reference Stand AV14, Carbon River, Mt. Rainier NP
  • AX15
    Reference Stand AX15, Nisqually River, Mt. Rainier NP
  • PP17
    Reference Stand PP17, White River, Mt. Rainier NP
  • TA01
    Reference Stand TA01, Ohanapecosh River, Mt. Rainier NP
  • TB13
    Reference Stand TB13, Nisqually River, Mt. Rainier NP
  • TO04
    Reference Stand TO04, Nisqually River, Mt. Rainier NP
  • TO11
    Reference Stand TO11, Carbon River, Mt. Rainier NP
  • CCNF
    Reference Stand CCNF, Cushman Crest, Mt. Rainier NP
  • SRNF
    Reference Stand SRNF, Sunrise Ridge, Mt. Rainier NP
  • ABCO
    Reference Stand ABCO, Suwanee Creek, Sequoia NP, white fir
  • LMCC
    Reference Stand LMCC, Crescent Creek, Sequoia NP
  • PIJE
    Reference Stand PIJE, Sequoia NP, Jeffrey pine
  • PILA
    Reference Stand PILA, Suwanee Creek, Sequoia NP, sugar pine
  • SUCR
    Reference Stand SUCR, Suwanee Cr, Sequoia NP, mixed conifer
  • UCRS
    Reference Stand UCRS, Upper Crescent Cr, Sequoia NP, SEGI
  • TCNF
    Reference Stand TCNF, Three Corner Rock, Washington DNR
  • CH11
    Reference Stand CH11, Cascade Head EF, hemlock-spruce
  • CH15
    Reference Stand CH15, Cascade Head EF, alder-conifer
  • 13
    Deschutes NF, John Bell data, Greg Johnson plot 13
  • 20
    Deschutes NF, John Bell data, Greg Johnson plot 20
  • 2233
    Willamette NF, Detroit Rd, Road 2233 flats
  • 23
    Deschutes NF, John Bell data, Greg Johnson plot 23
  • 25
    Deschutes NF, John Bell data, Greg Johnson plot 25
  • 2618
    Ashland, atzet plot 2618, Rogue River NF
  • 2619
    Ashland, atzet plot 2619, Rogue River NF
  • 2623
    Ashland, atzet plot 2623, Rogue River NF
  • 2631
    Ashland, atzet plot 2631, Rogue River NF
  • 2632
    Ashland, atzet plot 2632, Rogue River NF
  • 29
    Deschutes NF, John Bell data, Greg Johnson plot 29
  • 3
    Deschutes NF, John Bell data, Greg Johnson plot 3
  • 30
    Deschutes NF, John Bell data, Greg Johnson plot 30
  • 31
    Deschutes NF, John Bell data, Greg Johnson plot 31
  • 32
    Deschutes NF, John Bell data, Greg Johnson plot 32
  • 348
    Willamette NF, Detroit rd, Hemstrom plot # 348
  • 35
    Deschutes NF, John Bell data, Greg Johnson plot 35
  • 353
    Willamette NF, Detroit rd, Hemstrom plot # 353
  • 4
    Deschutes NF, John Bell data, Greg Johnson plot 4
  • CH02
    Cascade Head EF, CHO2
  • CH16
    Cascade Head EF, CH16
  • GP-1
    Gifford Pinchot NF, Packwood rd , road 45, GP-1
  • GP-2
    Gifford Pinchot NF, Packwood rd , road 45, GP-2
  • GP-3
    Gifford Pinchot NF, Packwood rd , White Pass
  • GP-4
    Gifford Pinchot NF, Mt.Adams rd
  • HM33
    Willamette NF, Detroit rd, Hemstrom plot # 332
  • MB10
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB10
  • MB11
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB11
  • MB12
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB12
  • MB13
    Mt. Baker- Snoqualmie NF, Darrington RD, MB13
  • MB14
    Mt. Baker- Snoqualmie NF, Darrington RD, MB14
  • MB15
    Mt. Baker- Snoqualmie NF, Darrington RD, MB15
  • MB16
    Mt. Baker- Snoqualmie NF, Darrington RD, MB16
  • MB17
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB17
  • MB18
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB18
  • MB19
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB19
  • MB20
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB20
  • MB21
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB21
  • MB22
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB22
  • MB23
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB23
  • MB24
    Mt. Baker- Snoqualmie NF, North Bend RD, MB24
  • MB25
    Mt. Baker- Snoqualmie NF, North Bend RD, MB25
  • MB26
    Mt. Baker- Snoqualmie NF, North Bend RD, MB26
  • MB27
    Mt. Baker- Snoqualmie NF, North Bend RD, MB27
  • MB28
    Mt. Baker- Snoqualmie NF, North Bend RD, MB28
  • MBS1
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS1
  • MBS2
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS2
  • MBS3
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS3
  • MBS4
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS4
  • MBS5
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS5
  • MBS6
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS6
  • MBS7
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS7
  • MBS8
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS8
  • MBS9
    Mt. Baker- Snoqualmie NF, Darrington RD, MBS9
  • MH-1
    Mt. Hood, Hood River R.D., Recon plot 0003, N. Halvorsen
  • MH-2
    Mt. Hood, Hood River R.D., MH-2
  • MH-3
    Mt. Hood, Hood River R.D., Road 3540
  • MH-4
    Mt. Hood, Hood River R.D., MH-4
  • MH-5
    Mt. Hood, Hood River R.D., MH-5
  • MH-6
    Mt. Hood, Hood River R.D., MH-6
  • MHVL
    Deschutes NF, John Bell data, Greg Johnson plot 2
  • RAIN
    Mt. Rainier, RAIN
  • SUMM
    Deschutes NF, Santiam Pass Summit, John Bell data
  • TCMH
    Torrey-Charlton RNA
  • UMP1
    Umpqua NF, Diamond Lake RD, Cinnamon Butte
  • UMP2
    Umpqua NF, UMP2
  • UMP3
    Willamette NF, Rigdon RD
  • UMP4
    Willamette NF, Fairview Peak
  • WEN1
    Wenatchee NF, Wenatchee RD
  • WEN2
    Wenatchee NF, Wenatchee RD, Miner's Ridge
  • WEN3
    Wenatchee NF, Naches RD, WEN3
  • WEN4
    Wenatchee NF, Naches RD, Pinegrass Ridge
  • WEN5
    Wenatchee NF, Naches RD, WEN5
  • WEN6
    Wenatchee NF, Naches RD, Bethel Ridge, WEN6
  • WEN7
    Wenatchee NF, Naches RD, Bethel Ridge, WEN7
  • WEN8
    Wenatchee NF, Naches RD, Section 3 Lake
  • WIL1
    Willamette NF, Blue River RD, Carpenter Mtn
  • WIL2
    Santiam Pass, Gholz Ref. Stand
  • WIND
    Deschutes NF, Windigo Pass, John Bell data
  • BMTN
    Reference Stand BMTN, Sequoia NP
  • WOLV
    Reference Stand WOLV , Sequoia NP
  • MEND
    Mendel unit, HJ Andrews Experimental Forest
SUBPLOT - numeric(2,0) (interval)

ID: TV00902.SUBPLOT

Subplot of reference stand

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

TREENUM - numeric(4,0) (interval)

ID: TV00902.TREENUM

Tree tag number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TV00902.YEAR

Year

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

STUMDIAM - numeric(5,1) (ratio)

ID: TV00902.STUMDIAM

Diameter of stump, closest to ground-where sawyer would cut

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

DISTDBH - numeric(5,0) (ratio)

ID: TV00902.DISTDBH

Vertical distance between stump diam and dbh

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1.000000

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

DISTDIAM - numeric(4,0) (ratio)

ID: TV00902.DISTDIAM

Vertical distance from dbh to 1st dendrometer reading if dbh cannot be seen with dendrometer

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 1.000000

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

TRUE1 - numeric(5,1) (ratio)

ID: TV00902.TRUE1

True-first reading on dendrometer

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

Numeric domain: type=real, min=-999.0000 (exclusive=false), max=652.0000 (exclusive=false)

FALSE1 - numeric(5,1) (ratio)

ID: TV00902.FALSE1

1-6 false-second offset reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

SIN1 - numeric(6,4) (ratio)

ID: TV00902.SIN1

Sine-1st-sine angle reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

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

TRUE2 - numeric(5,1) (ratio)

ID: TV00902.TRUE2

True-second reading on dendrometer

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

FALSE2 - numeric(5,1) (ratio)

ID: TV00902.FALSE2

1-6 false-second offset reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

SIN2 - numeric(6,4) (ratio)

ID: TV00902.SIN2

Sine-2nd-sine angle reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

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

ENDID - char(1) (nominal)

ID: TV00902.ENDID

Identifier for the end of tree measurements

Type system: Microsoft SQL Server 2008

TV00903 - TV00903

Object name: TV00903.csv

Records: 2081

Attributes: 20

File size: 172938 byte

Checksum (MD5): cf0db4831a0634252583017b9d5e9fc4

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

Constraints (1)
  • notNullConstraint: NOTNULL
    TV00903.DATACODE, TV00903.FALSE3, TV00903.FORMAT, TV00903.SIN3, TV00903.STAND, TV00903.STUDYID, TV00903.TRUE3
Attributes (20)
DATACODE - char(5) (nominal)

ID: TV00903.DATACODE

Data set code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • TV009
    FSDB database code TV009 (terrestrial vegetation)
FORMAT - numeric(2,0) (interval)

ID: TV00903.FORMAT

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

STUDYID - char(4) (nominal)

ID: TV00903.STUDYID

Study area name

Type system: Microsoft SQL Server 2008

Code definitions (19)
  • AKRS
    Noatak National Park, Alaska
  • CASC
    Pooled data for all cascade range studyid's
  • CHEF
    Cascade head experimental forest (hsgy)
  • COAS
    Cascade Head Experimental Forest (HSGY)
  • DFGY
    Douglas fir growth and yield
  • HSGY
    Hemlock-spruce growth and yield
  • LTER
    Watershed 2 and Hagan block lter transects (tree data)
  • MEND
    Mendel unit snags at the hj andrews experimenatl forest
  • MHGY
    Mountain hemlock growth and yield
  • MHVL
    Mountain hemlock volume study
  • MISC
    Miscellaneous reference stands
  • MRRS
    Mt Rainier reference stands
  • NFGY
    Noble fir growth and yield
  • OHJA
    H.J. Andrews reference stands
  • PPGY
    Ponderosa pine growth and yield
  • RMRS
    Rocky Mtn. reference stands
  • SNAG
    Snag study (at Cascade Head and Sequoia Natl. Park)
  • SQNP
    Sequoia national park reference stands
  • THIN
    Greene and Emmingham thinning plots (see study code FS024)
STAND - char(4) (nominal)

ID: TV00903.STAND

Plot or reference stand or plot in transect

Type system: Microsoft SQL Server 2008

Code definitions (156)
  • RS01
    Reference Stand RS01, H.J. Andrews EF, Willamette NF
  • RS02
    Reference Stand RS02, H.J. Andrews EF, Willamette NF
  • RS03
    Reference Stand RS03, H.J. Andrews EF, Willamette NF
  • RS07
    Reference Stand RS07, H.J. Andrews EF, Willamette NF
  • RS15
    Reference Stand RS15, H.J. Andrews EF, Willamette NF
  • RS16
    Reference Stand RS16, H.J. Andrews EF, Willamette NF
  • RS20
    Reference Stand RS20, H.J. Andrews EF, Willamette NF
  • RS24
    Reference Stand RS24, Hagan Block RNA, Willamette NF
  • CHEF
    Cascade Head Experimental Forest
  • CH14
    Reference Stand CH14, Cascade Head EF, Douglas-fir
  • CH01
    Reference Stand CH01, Cascade Head EF, hemlock-spruce
  • CH03
    Reference Stand CH03, Cascade Head EF, hemlock-spruce
  • CH04
    Reference Stand CH04, Cascade Head EF, hemlock-spruce
  • CH05
    Reference Stand CH05, Cascade Head EF, hemlock-spruce
  • CH06
    Reference Stand CH06, Cascade Head EF, hemlock-spruce
  • CH07
    Reference Stand CH07, Cascade Head EF, hemlock-spruce
  • CH08
    Reference Stand CH08, Cascade Head EF, hemlock-spruce
  • CH09
    Reference Stand CH09, Cascade Head EF, hemlock-spruce
  • CH10
    Reference Stand CH10, Cascade Head EF, hemlock-spruce
  • CH12
    Reference Stand CH12, Cascade Head EF, hemlock-spruce
  • CH13
    Reference Stand CH13, Cascade Head EF, hemlock-spruce
  • HR01
    Reference Stand HR01, South Fork Hoh River, Olympic NP
  • HR02
    Reference Stand HR02, South Fork Hoh River, Olympic NP
  • HR03
    Reference Stand HR03, South Fork Hoh River, Olympic NP
  • HR04
    Reference Stand HR04, South Fork Hoh River, Olympic NP
  • HS02
    Reference Stand HS02, Quinault RNA, Olympic NP
  • HS03
    Reference Stand HS03, Quinault RNA, Olympic NP
  • NCNA
    Reference Stand NCNA, Neskowin Crest RNA, Siuslaw NF
  • SP06
    Reference Stand SP06, Santiam Pass, Willamette NF
  • BLNF
    Reference Stand BLNF, Blue Lake, Gifford Pinchot NF
  • BPNF
    Reference Stand BPNF, Benson Plateau, Mount Hood NF
  • CMNF
    Reference Stand CMNF, Carpenter Mtn, Blue R, Willamette NF
  • GMNF
    Reference Stand GMNF, Goat Marsh RNA, Gifford Pinchot NF
  • HPNF
    Reference Stand HPNF, Huffman Peak, Gifford Pinchot NF
  • MPNF
    Reference Stand MPNF, Mary's Peak, Siuslaw NF
  • NWNF
    Reference Stand NWNF, North Wilson, Mount Hood NF
  • WLNF
    Reference Stand WLNF, Wahtum Lake, Mount Hood NF
  • WMNF
    Reference Stand WMNF, Wildcat Mtn RNA, Willamette NF
  • YBNF
    Reference Stand YBNF, Yacolt Burn, Gifford Pinchot NF
  • YSNF
    Reference Stand YSNF, Yarder sale, Wahtum Lake, Mt. Hood NF
  • RS10
    Reference Stand RS10, H.J. Andrews EF, Willamette NF
  • RS27
    Reference Stand RS27, H.J. Andrews EF, Willamette NF
  • RS32
    Reference Stand RS32, H.J. Andrews EF, Willamette NF
  • RS37
    Reference Stand RS37, South Fork Hagan Creek, Willamette NF
  • MRNA
    Reference Stand MRNA, Metolius RNA, Deschutes NF
  • FRC3
    Reference Stand FRC3, Fraser EF, CO, lodgepole pine
  • FRD1
    Reference Stand FRD1, Fraser EF, CO, spruce-fir
  • AB08
    Reference Stand AB08, White River, Mt. Rainier NP
  • AE10
    Reference Stand AE10, Nisqually River, Mt. Rainier NP
  • AG05
    Reference Stand AG05, Nisqually River, Mt. Rainier NP
  • AM16
    Reference Stand AM16, Nisqually River, Mt. Rainier NP
  • AO03
    Reference Stand AO03, Ohanapecosh River, Mt. Rainier NP
  • AR07
    Reference Stand AR07, Nisqually River, Mt. Rainier NP
  • AR19
    Reference Stand AR19, White River, Mt. Rainier NP
  • AV02
    Reference Stand AV02, Ohanapecosh River, Mt. Rainier NP
  • AV06
    Reference Stand AV06, Nisqually River, Mt. Rainier NP
  • AV14
    Reference Stand AV14, Carbon River, Mt. Rainier NP
  • AX15
    Reference Stand AX15, Nisqually River, Mt. Rainier NP
  • PP17
    Reference Stand PP17, White River, Mt. Rainier NP
  • TA01
    Reference Stand TA01, Ohanapecosh River, Mt. Rainier NP
  • TB13
    Reference Stand TB13, Nisqually River, Mt. Rainier NP
  • TO04
    Reference Stand TO04, Nisqually River, Mt. Rainier NP
  • TO11
    Reference Stand TO11, Carbon River, Mt. Rainier NP
  • CCNF
    Reference Stand CCNF, Cushman Crest, Mt. Rainier NP
  • SRNF
    Reference Stand SRNF, Sunrise Ridge, Mt. Rainier NP
  • ABCO
    Reference Stand ABCO, Suwanee Creek, Sequoia NP, white fir
  • LMCC
    Reference Stand LMCC, Crescent Creek, Sequoia NP
  • PIJE
    Reference Stand PIJE, Sequoia NP, Jeffrey pine
  • PILA
    Reference Stand PILA, Suwanee Creek, Sequoia NP, sugar pine
  • SUCR
    Reference Stand SUCR, Suwanee Cr, Sequoia NP, mixed conifer
  • UCRS
    Reference Stand UCRS, Upper Crescent Cr, Sequoia NP, SEGI
  • TCNF
    Reference Stand TCNF, Three Corner Rock, Washington DNR
  • CH11
    Reference Stand CH11, Cascade Head EF, hemlock-spruce
  • CH15
    Reference Stand CH15, Cascade Head EF, alder-conifer
  • 13
    Deschutes NF, John Bell data, Greg Johnson plot 13
  • 20
    Deschutes NF, John Bell data, Greg Johnson plot 20
  • 2233
    Willamette NF, Detroit Rd, Road 2233 flats
  • 23
    Deschutes NF, John Bell data, Greg Johnson plot 23
  • 25
    Deschutes NF, John Bell data, Greg Johnson plot 25
  • 2618
    Ashland, atzet plot 2618, Rogue River NF
  • 2619
    Ashland, atzet plot 2619, Rogue River NF
  • 2623
    Ashland, atzet plot 2623, Rogue River NF
  • 2631
    Ashland, atzet plot 2631, Rogue River NF
  • 2632
    Ashland, atzet plot 2632, Rogue River NF
  • 29
    Deschutes NF, John Bell data, Greg Johnson plot 29
  • 3
    Deschutes NF, John Bell data, Greg Johnson plot 3
  • 30
    Deschutes NF, John Bell data, Greg Johnson plot 30
  • 31
    Deschutes NF, John Bell data, Greg Johnson plot 31
  • 32
    Deschutes NF, John Bell data, Greg Johnson plot 32
  • 348
    Willamette NF, Detroit rd, Hemstrom plot # 348
  • 35
    Deschutes NF, John Bell data, Greg Johnson plot 35
  • 353
    Willamette NF, Detroit rd, Hemstrom plot # 353
  • 4
    Deschutes NF, John Bell data, Greg Johnson plot 4
  • CH02
    Cascade Head EF, CHO2
  • CH16
    Cascade Head EF, CH16
  • GP-1
    Gifford Pinchot NF, Packwood rd , road 45, GP-1
  • GP-2
    Gifford Pinchot NF, Packwood rd , road 45, GP-2
  • GP-3
    Gifford Pinchot NF, Packwood rd , White Pass
  • GP-4
    Gifford Pinchot NF, Mt.Adams rd
  • HM33
    Willamette NF, Detroit rd, Hemstrom plot # 332
  • MB10
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB10
  • MB11
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB11
  • MB12
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB12
  • MB13
    Mt. Baker- Snoqualmie NF, Darrington RD, MB13
  • MB14
    Mt. Baker- Snoqualmie NF, Darrington RD, MB14
  • MB15
    Mt. Baker- Snoqualmie NF, Darrington RD, MB15
  • MB16
    Mt. Baker- Snoqualmie NF, Darrington RD, MB16
  • MB17
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB17
  • MB18
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB18
  • MB19
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB19
  • MB20
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB20
  • MB21
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB21
  • MB22
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB22
  • MB23
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB23
  • MB24
    Mt. Baker- Snoqualmie NF, North Bend RD, MB24
  • MB25
    Mt. Baker- Snoqualmie NF, North Bend RD, MB25
  • MB26
    Mt. Baker- Snoqualmie NF, North Bend RD, MB26
  • MB27
    Mt. Baker- Snoqualmie NF, North Bend RD, MB27
  • MB28
    Mt. Baker- Snoqualmie NF, North Bend RD, MB28
  • MBS1
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS1
  • MBS2
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS2
  • MBS3
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS3
  • MBS4
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS4
  • MBS5
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS5
  • MBS6
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS6
  • MBS7
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS7
  • MBS8
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS8
  • MBS9
    Mt. Baker- Snoqualmie NF, Darrington RD, MBS9
  • MH-1
    Mt. Hood, Hood River R.D., Recon plot 0003, N. Halvorsen
  • MH-2
    Mt. Hood, Hood River R.D., MH-2
  • MH-3
    Mt. Hood, Hood River R.D., Road 3540
  • MH-4
    Mt. Hood, Hood River R.D., MH-4
  • MH-5
    Mt. Hood, Hood River R.D., MH-5
  • MH-6
    Mt. Hood, Hood River R.D., MH-6
  • MHVL
    Deschutes NF, John Bell data, Greg Johnson plot 2
  • RAIN
    Mt. Rainier, RAIN
  • SUMM
    Deschutes NF, Santiam Pass Summit, John Bell data
  • TCMH
    Torrey-Charlton RNA
  • UMP1
    Umpqua NF, Diamond Lake RD, Cinnamon Butte
  • UMP2
    Umpqua NF, UMP2
  • UMP3
    Willamette NF, Rigdon RD
  • UMP4
    Willamette NF, Fairview Peak
  • WEN1
    Wenatchee NF, Wenatchee RD
  • WEN2
    Wenatchee NF, Wenatchee RD, Miner's Ridge
  • WEN3
    Wenatchee NF, Naches RD, WEN3
  • WEN4
    Wenatchee NF, Naches RD, Pinegrass Ridge
  • WEN5
    Wenatchee NF, Naches RD, WEN5
  • WEN6
    Wenatchee NF, Naches RD, Bethel Ridge, WEN6
  • WEN7
    Wenatchee NF, Naches RD, Bethel Ridge, WEN7
  • WEN8
    Wenatchee NF, Naches RD, Section 3 Lake
  • WIL1
    Willamette NF, Blue River RD, Carpenter Mtn
  • WIL2
    Santiam Pass, Gholz Ref. Stand
  • WIND
    Deschutes NF, Windigo Pass, John Bell data
  • BMTN
    Reference Stand BMTN, Sequoia NP
  • WOLV
    Reference Stand WOLV , Sequoia NP
  • MEND
    Mendel unit, HJ Andrews Experimental Forest
SUBPLOT - numeric(2,0) (interval)

ID: TV00903.SUBPLOT

Subplot of reference stand

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

TREENUM - numeric(4,0) (interval)

ID: TV00903.TREENUM

Tree tag number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TV00903.YEAR

Year

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

TRUE3 - numeric(5,1) (ratio)

ID: TV00903.TRUE3

True-third reading on dendrometer

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

FALSE3 - numeric(5,1) (ratio)

ID: TV00903.FALSE3

1-6 false-second, offset reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

SIN3 - numeric(6,4) (ratio)

ID: TV00903.SIN3

Sine-3rd-sine angle reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

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

TRUE4 - numeric(5,1) (ratio)

ID: TV00903.TRUE4

True-first reading on dendrometer

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

FALSE4 - numeric(5,1) (ratio)

ID: TV00903.FALSE4

False-second offset reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

SIN4 - numeric(6,4) (ratio)

ID: TV00903.SIN4

Sine-3rd-sine angle reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

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

TRUE5 - numeric(5,1) (ratio)

ID: TV00903.TRUE5

True first reading on dendrometer

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

FALSE5 - numeric(5,1) (ratio)

ID: TV00903.FALSE5

False-second offset reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

SIN5 - numeric(6,4) (ratio)

ID: TV00903.SIN5

Sine-3rd sine angle reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

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

TRUE6 - numeric(5,1) (ratio)

ID: TV00903.TRUE6

True-first reading on dendrometer

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

FALSE6 - numeric(5,1) (ratio)

ID: TV00903.FALSE6

1-6 false-second, offset reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

SIN6 - numeric(6,4) (ratio)

ID: TV00903.SIN6

Sine 3rd-sine angle reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

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

ENDID - char(1) (nominal)

ID: TV00903.ENDID

Identifier for the end of tree measurements

Type system: Microsoft SQL Server 2008

TV00904 - TV00904

Object name: TV00904.csv

Records: 344

Attributes: 20

File size: 23356 byte

Checksum (MD5): aecacad96c758c9f211e182117af7db1

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

Constraints (1)
  • notNullConstraint: NOTNULL
    TV00904.DATACODE, TV00904.FALSE7, TV00904.FORMAT, TV00904.SIN7, TV00904.STAND, TV00904.STUDYID, TV00904.TREENUM, TV00904.TRUE7
Attributes (20)
DATACODE - char(5) (nominal)

ID: TV00904.DATACODE

Data set code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • TV009
    FSDB database code TV009 (terrestrial vegetation)
FORMAT - numeric(2,0) (interval)

ID: TV00904.FORMAT

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

STUDYID - char(4) (nominal)

ID: TV00904.STUDYID

Study area name

Type system: Microsoft SQL Server 2008

Code definitions (19)
  • AKRS
    Noatak National Park, Alaska
  • CASC
    Pooled data for all cascade range studyid's
  • CHEF
    Cascade head experimental forest (hsgy)
  • COAS
    Cascade Head Experimental Forest (HSGY)
  • DFGY
    Douglas fir growth and yield
  • HSGY
    Hemlock-spruce growth and yield
  • LTER
    Watershed 2 and Hagan block lter transects (tree data)
  • MEND
    Mendel unit snags at the hj andrews experimenatl forest
  • MHGY
    Mountain hemlock growth and yield
  • MHVL
    Mountain hemlock volume study
  • MISC
    Miscellaneous reference stands
  • MRRS
    Mt Rainier reference stands
  • NFGY
    Noble fir growth and yield
  • OHJA
    H.J. Andrews reference stands
  • PPGY
    Ponderosa pine growth and yield
  • RMRS
    Rocky Mtn. reference stands
  • SNAG
    Snag study (at Cascade Head and Sequoia Natl. Park)
  • SQNP
    Sequoia national park reference stands
  • THIN
    Greene and Emmingham thinning plots (see study code FS024)
STAND - char(4) (nominal)

ID: TV00904.STAND

Plot or reference stand or plot in transect

Type system: Microsoft SQL Server 2008

Code definitions (156)
  • RS01
    Reference Stand RS01, H.J. Andrews EF, Willamette NF
  • RS02
    Reference Stand RS02, H.J. Andrews EF, Willamette NF
  • RS03
    Reference Stand RS03, H.J. Andrews EF, Willamette NF
  • RS07
    Reference Stand RS07, H.J. Andrews EF, Willamette NF
  • RS15
    Reference Stand RS15, H.J. Andrews EF, Willamette NF
  • RS16
    Reference Stand RS16, H.J. Andrews EF, Willamette NF
  • RS20
    Reference Stand RS20, H.J. Andrews EF, Willamette NF
  • RS24
    Reference Stand RS24, Hagan Block RNA, Willamette NF
  • CHEF
    Cascade Head Experimental Forest
  • CH14
    Reference Stand CH14, Cascade Head EF, Douglas-fir
  • CH01
    Reference Stand CH01, Cascade Head EF, hemlock-spruce
  • CH03
    Reference Stand CH03, Cascade Head EF, hemlock-spruce
  • CH04
    Reference Stand CH04, Cascade Head EF, hemlock-spruce
  • CH05
    Reference Stand CH05, Cascade Head EF, hemlock-spruce
  • CH06
    Reference Stand CH06, Cascade Head EF, hemlock-spruce
  • CH07
    Reference Stand CH07, Cascade Head EF, hemlock-spruce
  • CH08
    Reference Stand CH08, Cascade Head EF, hemlock-spruce
  • CH09
    Reference Stand CH09, Cascade Head EF, hemlock-spruce
  • CH10
    Reference Stand CH10, Cascade Head EF, hemlock-spruce
  • CH12
    Reference Stand CH12, Cascade Head EF, hemlock-spruce
  • CH13
    Reference Stand CH13, Cascade Head EF, hemlock-spruce
  • HR01
    Reference Stand HR01, South Fork Hoh River, Olympic NP
  • HR02
    Reference Stand HR02, South Fork Hoh River, Olympic NP
  • HR03
    Reference Stand HR03, South Fork Hoh River, Olympic NP
  • HR04
    Reference Stand HR04, South Fork Hoh River, Olympic NP
  • HS02
    Reference Stand HS02, Quinault RNA, Olympic NP
  • HS03
    Reference Stand HS03, Quinault RNA, Olympic NP
  • NCNA
    Reference Stand NCNA, Neskowin Crest RNA, Siuslaw NF
  • SP06
    Reference Stand SP06, Santiam Pass, Willamette NF
  • BLNF
    Reference Stand BLNF, Blue Lake, Gifford Pinchot NF
  • BPNF
    Reference Stand BPNF, Benson Plateau, Mount Hood NF
  • CMNF
    Reference Stand CMNF, Carpenter Mtn, Blue R, Willamette NF
  • GMNF
    Reference Stand GMNF, Goat Marsh RNA, Gifford Pinchot NF
  • HPNF
    Reference Stand HPNF, Huffman Peak, Gifford Pinchot NF
  • MPNF
    Reference Stand MPNF, Mary's Peak, Siuslaw NF
  • NWNF
    Reference Stand NWNF, North Wilson, Mount Hood NF
  • WLNF
    Reference Stand WLNF, Wahtum Lake, Mount Hood NF
  • WMNF
    Reference Stand WMNF, Wildcat Mtn RNA, Willamette NF
  • YBNF
    Reference Stand YBNF, Yacolt Burn, Gifford Pinchot NF
  • YSNF
    Reference Stand YSNF, Yarder sale, Wahtum Lake, Mt. Hood NF
  • RS10
    Reference Stand RS10, H.J. Andrews EF, Willamette NF
  • RS27
    Reference Stand RS27, H.J. Andrews EF, Willamette NF
  • RS32
    Reference Stand RS32, H.J. Andrews EF, Willamette NF
  • RS37
    Reference Stand RS37, South Fork Hagan Creek, Willamette NF
  • MRNA
    Reference Stand MRNA, Metolius RNA, Deschutes NF
  • FRC3
    Reference Stand FRC3, Fraser EF, CO, lodgepole pine
  • FRD1
    Reference Stand FRD1, Fraser EF, CO, spruce-fir
  • AB08
    Reference Stand AB08, White River, Mt. Rainier NP
  • AE10
    Reference Stand AE10, Nisqually River, Mt. Rainier NP
  • AG05
    Reference Stand AG05, Nisqually River, Mt. Rainier NP
  • AM16
    Reference Stand AM16, Nisqually River, Mt. Rainier NP
  • AO03
    Reference Stand AO03, Ohanapecosh River, Mt. Rainier NP
  • AR07
    Reference Stand AR07, Nisqually River, Mt. Rainier NP
  • AR19
    Reference Stand AR19, White River, Mt. Rainier NP
  • AV02
    Reference Stand AV02, Ohanapecosh River, Mt. Rainier NP
  • AV06
    Reference Stand AV06, Nisqually River, Mt. Rainier NP
  • AV14
    Reference Stand AV14, Carbon River, Mt. Rainier NP
  • AX15
    Reference Stand AX15, Nisqually River, Mt. Rainier NP
  • PP17
    Reference Stand PP17, White River, Mt. Rainier NP
  • TA01
    Reference Stand TA01, Ohanapecosh River, Mt. Rainier NP
  • TB13
    Reference Stand TB13, Nisqually River, Mt. Rainier NP
  • TO04
    Reference Stand TO04, Nisqually River, Mt. Rainier NP
  • TO11
    Reference Stand TO11, Carbon River, Mt. Rainier NP
  • CCNF
    Reference Stand CCNF, Cushman Crest, Mt. Rainier NP
  • SRNF
    Reference Stand SRNF, Sunrise Ridge, Mt. Rainier NP
  • ABCO
    Reference Stand ABCO, Suwanee Creek, Sequoia NP, white fir
  • LMCC
    Reference Stand LMCC, Crescent Creek, Sequoia NP
  • PIJE
    Reference Stand PIJE, Sequoia NP, Jeffrey pine
  • PILA
    Reference Stand PILA, Suwanee Creek, Sequoia NP, sugar pine
  • SUCR
    Reference Stand SUCR, Suwanee Cr, Sequoia NP, mixed conifer
  • UCRS
    Reference Stand UCRS, Upper Crescent Cr, Sequoia NP, SEGI
  • TCNF
    Reference Stand TCNF, Three Corner Rock, Washington DNR
  • CH11
    Reference Stand CH11, Cascade Head EF, hemlock-spruce
  • CH15
    Reference Stand CH15, Cascade Head EF, alder-conifer
  • 13
    Deschutes NF, John Bell data, Greg Johnson plot 13
  • 20
    Deschutes NF, John Bell data, Greg Johnson plot 20
  • 2233
    Willamette NF, Detroit Rd, Road 2233 flats
  • 23
    Deschutes NF, John Bell data, Greg Johnson plot 23
  • 25
    Deschutes NF, John Bell data, Greg Johnson plot 25
  • 2618
    Ashland, atzet plot 2618, Rogue River NF
  • 2619
    Ashland, atzet plot 2619, Rogue River NF
  • 2623
    Ashland, atzet plot 2623, Rogue River NF
  • 2631
    Ashland, atzet plot 2631, Rogue River NF
  • 2632
    Ashland, atzet plot 2632, Rogue River NF
  • 29
    Deschutes NF, John Bell data, Greg Johnson plot 29
  • 3
    Deschutes NF, John Bell data, Greg Johnson plot 3
  • 30
    Deschutes NF, John Bell data, Greg Johnson plot 30
  • 31
    Deschutes NF, John Bell data, Greg Johnson plot 31
  • 32
    Deschutes NF, John Bell data, Greg Johnson plot 32
  • 348
    Willamette NF, Detroit rd, Hemstrom plot # 348
  • 35
    Deschutes NF, John Bell data, Greg Johnson plot 35
  • 353
    Willamette NF, Detroit rd, Hemstrom plot # 353
  • 4
    Deschutes NF, John Bell data, Greg Johnson plot 4
  • CH02
    Cascade Head EF, CHO2
  • CH16
    Cascade Head EF, CH16
  • GP-1
    Gifford Pinchot NF, Packwood rd , road 45, GP-1
  • GP-2
    Gifford Pinchot NF, Packwood rd , road 45, GP-2
  • GP-3
    Gifford Pinchot NF, Packwood rd , White Pass
  • GP-4
    Gifford Pinchot NF, Mt.Adams rd
  • HM33
    Willamette NF, Detroit rd, Hemstrom plot # 332
  • MB10
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB10
  • MB11
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB11
  • MB12
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB12
  • MB13
    Mt. Baker- Snoqualmie NF, Darrington RD, MB13
  • MB14
    Mt. Baker- Snoqualmie NF, Darrington RD, MB14
  • MB15
    Mt. Baker- Snoqualmie NF, Darrington RD, MB15
  • MB16
    Mt. Baker- Snoqualmie NF, Darrington RD, MB16
  • MB17
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB17
  • MB18
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB18
  • MB19
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB19
  • MB20
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB20
  • MB21
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB21
  • MB22
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB22
  • MB23
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB23
  • MB24
    Mt. Baker- Snoqualmie NF, North Bend RD, MB24
  • MB25
    Mt. Baker- Snoqualmie NF, North Bend RD, MB25
  • MB26
    Mt. Baker- Snoqualmie NF, North Bend RD, MB26
  • MB27
    Mt. Baker- Snoqualmie NF, North Bend RD, MB27
  • MB28
    Mt. Baker- Snoqualmie NF, North Bend RD, MB28
  • MBS1
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS1
  • MBS2
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS2
  • MBS3
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS3
  • MBS4
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS4
  • MBS5
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS5
  • MBS6
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS6
  • MBS7
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS7
  • MBS8
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS8
  • MBS9
    Mt. Baker- Snoqualmie NF, Darrington RD, MBS9
  • MH-1
    Mt. Hood, Hood River R.D., Recon plot 0003, N. Halvorsen
  • MH-2
    Mt. Hood, Hood River R.D., MH-2
  • MH-3
    Mt. Hood, Hood River R.D., Road 3540
  • MH-4
    Mt. Hood, Hood River R.D., MH-4
  • MH-5
    Mt. Hood, Hood River R.D., MH-5
  • MH-6
    Mt. Hood, Hood River R.D., MH-6
  • MHVL
    Deschutes NF, John Bell data, Greg Johnson plot 2
  • RAIN
    Mt. Rainier, RAIN
  • SUMM
    Deschutes NF, Santiam Pass Summit, John Bell data
  • TCMH
    Torrey-Charlton RNA
  • UMP1
    Umpqua NF, Diamond Lake RD, Cinnamon Butte
  • UMP2
    Umpqua NF, UMP2
  • UMP3
    Willamette NF, Rigdon RD
  • UMP4
    Willamette NF, Fairview Peak
  • WEN1
    Wenatchee NF, Wenatchee RD
  • WEN2
    Wenatchee NF, Wenatchee RD, Miner's Ridge
  • WEN3
    Wenatchee NF, Naches RD, WEN3
  • WEN4
    Wenatchee NF, Naches RD, Pinegrass Ridge
  • WEN5
    Wenatchee NF, Naches RD, WEN5
  • WEN6
    Wenatchee NF, Naches RD, Bethel Ridge, WEN6
  • WEN7
    Wenatchee NF, Naches RD, Bethel Ridge, WEN7
  • WEN8
    Wenatchee NF, Naches RD, Section 3 Lake
  • WIL1
    Willamette NF, Blue River RD, Carpenter Mtn
  • WIL2
    Santiam Pass, Gholz Ref. Stand
  • WIND
    Deschutes NF, Windigo Pass, John Bell data
  • BMTN
    Reference Stand BMTN, Sequoia NP
  • WOLV
    Reference Stand WOLV , Sequoia NP
  • MEND
    Mendel unit, HJ Andrews Experimental Forest
SUBPLOT - numeric(2,0) (interval)

ID: TV00904.SUBPLOT

Subplot of reference stand

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

TREENUM - numeric(4,0) (interval)

ID: TV00904.TREENUM

Tree tag number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TV00904.YEAR

Year

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

TRUE7 - numeric(5,1) (ratio)

ID: TV00904.TRUE7

True-third reading on dendrometer

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

FALSE7 - numeric(5,1) (ratio)

ID: TV00904.FALSE7

7-10 false-second, offset reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

SIN7 - numeric(6,4) (ratio)

ID: TV00904.SIN7

Sine-3rd-sine angle reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

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

TRUE8 - numeric(5,1) (ratio)

ID: TV00904.TRUE8

True-first reading on dendrometer

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

FALSE8 - numeric(5,1) (ratio)

ID: TV00904.FALSE8

7-10 false-second offset reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

SIN8 - numeric(6,4) (ratio)

ID: TV00904.SIN8

Sine-3rd-sine angle reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

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

TRUE9 - numeric(5,1) (ratio)

ID: TV00904.TRUE9

True first reading on dendrometer

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

FALSE9 - numeric(5,1) (ratio)

ID: TV00904.FALSE9

7-10 false-second offset reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

SIN9 - numeric(6,4) (ratio)

ID: TV00904.SIN9

Sine-3rd sine angle reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

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

TRUE10 - numeric(5,1) (ratio)

ID: TV00904.TRUE10

True-first reading on dendrometer

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

FALSE10 - numeric(5,1) (ratio)

ID: TV00904.FALSE10

7-10 false-second, offset reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

SIN10 - numeric(6,4) (ratio)

ID: TV00904.SIN10

Sine 3rd-sine angle reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

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

ENDID - char(1) (nominal)

ID: TV00904.ENDID

Identifier for the end of tree measurements

Type system: Microsoft SQL Server 2008

TV00905 - TV00905

Object name: TV00905.csv

Records: 7

Attributes: 20

File size: 682 byte

Checksum (MD5): 092081b247bd5ed0d04d56d55bf443c9

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

Constraints (1)
  • notNullConstraint: NOTNULL
    TV00905.DATACODE, TV00905.FALSE11, TV00905.FALSE12, TV00905.FORMAT, TV00905.SIN11, TV00905.SIN12, TV00905.STAND, TV00905.STUDYID, TV00905.TREENUM, TV00905.TRUE11, TV00905.TRUE12, TV00905.YEAR
Attributes (20)
DATACODE - char(5) (nominal)

ID: TV00905.DATACODE

Data set code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • TV009
    FSDB database code TV009 (terrestrial vegetation)
FORMAT - numeric(2,0) (interval)

ID: TV00905.FORMAT

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

STUDYID - char(4) (nominal)

ID: TV00905.STUDYID

Study area name

Type system: Microsoft SQL Server 2008

Code definitions (19)
  • AKRS
    Noatak National Park, Alaska
  • CASC
    Pooled data for all cascade range studyid's
  • CHEF
    Cascade head experimental forest (hsgy)
  • COAS
    Cascade Head Experimental Forest (HSGY)
  • DFGY
    Douglas fir growth and yield
  • HSGY
    Hemlock-spruce growth and yield
  • LTER
    Watershed 2 and Hagan block lter transects (tree data)
  • MEND
    Mendel unit snags at the hj andrews experimenatl forest
  • MHGY
    Mountain hemlock growth and yield
  • MHVL
    Mountain hemlock volume study
  • MISC
    Miscellaneous reference stands
  • MRRS
    Mt Rainier reference stands
  • NFGY
    Noble fir growth and yield
  • OHJA
    H.J. Andrews reference stands
  • PPGY
    Ponderosa pine growth and yield
  • RMRS
    Rocky Mtn. reference stands
  • SNAG
    Snag study (at Cascade Head and Sequoia Natl. Park)
  • SQNP
    Sequoia national park reference stands
  • THIN
    Greene and Emmingham thinning plots (see study code FS024)
STAND - char(4) (nominal)

ID: TV00905.STAND

Plot or reference stand or plot in transect

Type system: Microsoft SQL Server 2008

Code definitions (156)
  • RS01
    Reference Stand RS01, H.J. Andrews EF, Willamette NF
  • RS02
    Reference Stand RS02, H.J. Andrews EF, Willamette NF
  • RS03
    Reference Stand RS03, H.J. Andrews EF, Willamette NF
  • RS07
    Reference Stand RS07, H.J. Andrews EF, Willamette NF
  • RS15
    Reference Stand RS15, H.J. Andrews EF, Willamette NF
  • RS16
    Reference Stand RS16, H.J. Andrews EF, Willamette NF
  • RS20
    Reference Stand RS20, H.J. Andrews EF, Willamette NF
  • RS24
    Reference Stand RS24, Hagan Block RNA, Willamette NF
  • CHEF
    Cascade Head Experimental Forest
  • CH14
    Reference Stand CH14, Cascade Head EF, Douglas-fir
  • CH01
    Reference Stand CH01, Cascade Head EF, hemlock-spruce
  • CH03
    Reference Stand CH03, Cascade Head EF, hemlock-spruce
  • CH04
    Reference Stand CH04, Cascade Head EF, hemlock-spruce
  • CH05
    Reference Stand CH05, Cascade Head EF, hemlock-spruce
  • CH06
    Reference Stand CH06, Cascade Head EF, hemlock-spruce
  • CH07
    Reference Stand CH07, Cascade Head EF, hemlock-spruce
  • CH08
    Reference Stand CH08, Cascade Head EF, hemlock-spruce
  • CH09
    Reference Stand CH09, Cascade Head EF, hemlock-spruce
  • CH10
    Reference Stand CH10, Cascade Head EF, hemlock-spruce
  • CH12
    Reference Stand CH12, Cascade Head EF, hemlock-spruce
  • CH13
    Reference Stand CH13, Cascade Head EF, hemlock-spruce
  • HR01
    Reference Stand HR01, South Fork Hoh River, Olympic NP
  • HR02
    Reference Stand HR02, South Fork Hoh River, Olympic NP
  • HR03
    Reference Stand HR03, South Fork Hoh River, Olympic NP
  • HR04
    Reference Stand HR04, South Fork Hoh River, Olympic NP
  • HS02
    Reference Stand HS02, Quinault RNA, Olympic NP
  • HS03
    Reference Stand HS03, Quinault RNA, Olympic NP
  • NCNA
    Reference Stand NCNA, Neskowin Crest RNA, Siuslaw NF
  • SP06
    Reference Stand SP06, Santiam Pass, Willamette NF
  • BLNF
    Reference Stand BLNF, Blue Lake, Gifford Pinchot NF
  • BPNF
    Reference Stand BPNF, Benson Plateau, Mount Hood NF
  • CMNF
    Reference Stand CMNF, Carpenter Mtn, Blue R, Willamette NF
  • GMNF
    Reference Stand GMNF, Goat Marsh RNA, Gifford Pinchot NF
  • HPNF
    Reference Stand HPNF, Huffman Peak, Gifford Pinchot NF
  • MPNF
    Reference Stand MPNF, Mary's Peak, Siuslaw NF
  • NWNF
    Reference Stand NWNF, North Wilson, Mount Hood NF
  • WLNF
    Reference Stand WLNF, Wahtum Lake, Mount Hood NF
  • WMNF
    Reference Stand WMNF, Wildcat Mtn RNA, Willamette NF
  • YBNF
    Reference Stand YBNF, Yacolt Burn, Gifford Pinchot NF
  • YSNF
    Reference Stand YSNF, Yarder sale, Wahtum Lake, Mt. Hood NF
  • RS10
    Reference Stand RS10, H.J. Andrews EF, Willamette NF
  • RS27
    Reference Stand RS27, H.J. Andrews EF, Willamette NF
  • RS32
    Reference Stand RS32, H.J. Andrews EF, Willamette NF
  • RS37
    Reference Stand RS37, South Fork Hagan Creek, Willamette NF
  • MRNA
    Reference Stand MRNA, Metolius RNA, Deschutes NF
  • FRC3
    Reference Stand FRC3, Fraser EF, CO, lodgepole pine
  • FRD1
    Reference Stand FRD1, Fraser EF, CO, spruce-fir
  • AB08
    Reference Stand AB08, White River, Mt. Rainier NP
  • AE10
    Reference Stand AE10, Nisqually River, Mt. Rainier NP
  • AG05
    Reference Stand AG05, Nisqually River, Mt. Rainier NP
  • AM16
    Reference Stand AM16, Nisqually River, Mt. Rainier NP
  • AO03
    Reference Stand AO03, Ohanapecosh River, Mt. Rainier NP
  • AR07
    Reference Stand AR07, Nisqually River, Mt. Rainier NP
  • AR19
    Reference Stand AR19, White River, Mt. Rainier NP
  • AV02
    Reference Stand AV02, Ohanapecosh River, Mt. Rainier NP
  • AV06
    Reference Stand AV06, Nisqually River, Mt. Rainier NP
  • AV14
    Reference Stand AV14, Carbon River, Mt. Rainier NP
  • AX15
    Reference Stand AX15, Nisqually River, Mt. Rainier NP
  • PP17
    Reference Stand PP17, White River, Mt. Rainier NP
  • TA01
    Reference Stand TA01, Ohanapecosh River, Mt. Rainier NP
  • TB13
    Reference Stand TB13, Nisqually River, Mt. Rainier NP
  • TO04
    Reference Stand TO04, Nisqually River, Mt. Rainier NP
  • TO11
    Reference Stand TO11, Carbon River, Mt. Rainier NP
  • CCNF
    Reference Stand CCNF, Cushman Crest, Mt. Rainier NP
  • SRNF
    Reference Stand SRNF, Sunrise Ridge, Mt. Rainier NP
  • ABCO
    Reference Stand ABCO, Suwanee Creek, Sequoia NP, white fir
  • LMCC
    Reference Stand LMCC, Crescent Creek, Sequoia NP
  • PIJE
    Reference Stand PIJE, Sequoia NP, Jeffrey pine
  • PILA
    Reference Stand PILA, Suwanee Creek, Sequoia NP, sugar pine
  • SUCR
    Reference Stand SUCR, Suwanee Cr, Sequoia NP, mixed conifer
  • UCRS
    Reference Stand UCRS, Upper Crescent Cr, Sequoia NP, SEGI
  • TCNF
    Reference Stand TCNF, Three Corner Rock, Washington DNR
  • CH11
    Reference Stand CH11, Cascade Head EF, hemlock-spruce
  • CH15
    Reference Stand CH15, Cascade Head EF, alder-conifer
  • 13
    Deschutes NF, John Bell data, Greg Johnson plot 13
  • 20
    Deschutes NF, John Bell data, Greg Johnson plot 20
  • 2233
    Willamette NF, Detroit Rd, Road 2233 flats
  • 23
    Deschutes NF, John Bell data, Greg Johnson plot 23
  • 25
    Deschutes NF, John Bell data, Greg Johnson plot 25
  • 2618
    Ashland, atzet plot 2618, Rogue River NF
  • 2619
    Ashland, atzet plot 2619, Rogue River NF
  • 2623
    Ashland, atzet plot 2623, Rogue River NF
  • 2631
    Ashland, atzet plot 2631, Rogue River NF
  • 2632
    Ashland, atzet plot 2632, Rogue River NF
  • 29
    Deschutes NF, John Bell data, Greg Johnson plot 29
  • 3
    Deschutes NF, John Bell data, Greg Johnson plot 3
  • 30
    Deschutes NF, John Bell data, Greg Johnson plot 30
  • 31
    Deschutes NF, John Bell data, Greg Johnson plot 31
  • 32
    Deschutes NF, John Bell data, Greg Johnson plot 32
  • 348
    Willamette NF, Detroit rd, Hemstrom plot # 348
  • 35
    Deschutes NF, John Bell data, Greg Johnson plot 35
  • 353
    Willamette NF, Detroit rd, Hemstrom plot # 353
  • 4
    Deschutes NF, John Bell data, Greg Johnson plot 4
  • CH02
    Cascade Head EF, CHO2
  • CH16
    Cascade Head EF, CH16
  • GP-1
    Gifford Pinchot NF, Packwood rd , road 45, GP-1
  • GP-2
    Gifford Pinchot NF, Packwood rd , road 45, GP-2
  • GP-3
    Gifford Pinchot NF, Packwood rd , White Pass
  • GP-4
    Gifford Pinchot NF, Mt.Adams rd
  • HM33
    Willamette NF, Detroit rd, Hemstrom plot # 332
  • MB10
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB10
  • MB11
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB11
  • MB12
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB12
  • MB13
    Mt. Baker- Snoqualmie NF, Darrington RD, MB13
  • MB14
    Mt. Baker- Snoqualmie NF, Darrington RD, MB14
  • MB15
    Mt. Baker- Snoqualmie NF, Darrington RD, MB15
  • MB16
    Mt. Baker- Snoqualmie NF, Darrington RD, MB16
  • MB17
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB17
  • MB18
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB18
  • MB19
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB19
  • MB20
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB20
  • MB21
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB21
  • MB22
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB22
  • MB23
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB23
  • MB24
    Mt. Baker- Snoqualmie NF, North Bend RD, MB24
  • MB25
    Mt. Baker- Snoqualmie NF, North Bend RD, MB25
  • MB26
    Mt. Baker- Snoqualmie NF, North Bend RD, MB26
  • MB27
    Mt. Baker- Snoqualmie NF, North Bend RD, MB27
  • MB28
    Mt. Baker- Snoqualmie NF, North Bend RD, MB28
  • MBS1
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS1
  • MBS2
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS2
  • MBS3
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS3
  • MBS4
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS4
  • MBS5
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS5
  • MBS6
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS6
  • MBS7
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS7
  • MBS8
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS8
  • MBS9
    Mt. Baker- Snoqualmie NF, Darrington RD, MBS9
  • MH-1
    Mt. Hood, Hood River R.D., Recon plot 0003, N. Halvorsen
  • MH-2
    Mt. Hood, Hood River R.D., MH-2
  • MH-3
    Mt. Hood, Hood River R.D., Road 3540
  • MH-4
    Mt. Hood, Hood River R.D., MH-4
  • MH-5
    Mt. Hood, Hood River R.D., MH-5
  • MH-6
    Mt. Hood, Hood River R.D., MH-6
  • MHVL
    Deschutes NF, John Bell data, Greg Johnson plot 2
  • RAIN
    Mt. Rainier, RAIN
  • SUMM
    Deschutes NF, Santiam Pass Summit, John Bell data
  • TCMH
    Torrey-Charlton RNA
  • UMP1
    Umpqua NF, Diamond Lake RD, Cinnamon Butte
  • UMP2
    Umpqua NF, UMP2
  • UMP3
    Willamette NF, Rigdon RD
  • UMP4
    Willamette NF, Fairview Peak
  • WEN1
    Wenatchee NF, Wenatchee RD
  • WEN2
    Wenatchee NF, Wenatchee RD, Miner's Ridge
  • WEN3
    Wenatchee NF, Naches RD, WEN3
  • WEN4
    Wenatchee NF, Naches RD, Pinegrass Ridge
  • WEN5
    Wenatchee NF, Naches RD, WEN5
  • WEN6
    Wenatchee NF, Naches RD, Bethel Ridge, WEN6
  • WEN7
    Wenatchee NF, Naches RD, Bethel Ridge, WEN7
  • WEN8
    Wenatchee NF, Naches RD, Section 3 Lake
  • WIL1
    Willamette NF, Blue River RD, Carpenter Mtn
  • WIL2
    Santiam Pass, Gholz Ref. Stand
  • WIND
    Deschutes NF, Windigo Pass, John Bell data
  • BMTN
    Reference Stand BMTN, Sequoia NP
  • WOLV
    Reference Stand WOLV , Sequoia NP
  • MEND
    Mendel unit, HJ Andrews Experimental Forest
SUBPLOT - numeric(2,0) (interval)

ID: TV00905.SUBPLOT

Subplot of reference stand

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

TREENUM - numeric(4,0) (interval)

ID: TV00905.TREENUM

Tree tag number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TV00905.YEAR

Year

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

TRUE11 - numeric(5,1) (ratio)

ID: TV00905.TRUE11

True-third reading on dendrometer

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

FALSE11 - numeric(5,1) (ratio)

ID: TV00905.FALSE11

11-14 false-second, offset reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

SIN11 - numeric(6,4) (ratio)

ID: TV00905.SIN11

Sine-3rd-sine angle reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

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

TRUE12 - numeric(5,1) (ratio)

ID: TV00905.TRUE12

True-first reading on dendrometer

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

Numeric domain: type=real, min=-999.0000 (exclusive=false), max=572.0000 (exclusive=false)

FALSE12 - numeric(5,1) (ratio)

ID: TV00905.FALSE12

11-14 false-second offset reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

Numeric domain: type=real, min=-999.0000 (exclusive=false), max=695.0000 (exclusive=false)

SIN12 - numeric(6,4) (ratio)

ID: TV00905.SIN12

Sine-3rd-sine angle reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

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

TRUE13 - numeric(5,1) (ratio)

ID: TV00905.TRUE13

True first reading on dendrometer

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

FALSE13 - numeric(5,1) (ratio)

ID: TV00905.FALSE13

11-14 false-second offset reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

SIN13 - numeric(6,4) (ratio)

ID: TV00905.SIN13

Sine-3rd sine angle reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

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

TRUE14 - numeric(5,1) (ratio)

ID: TV00905.TRUE14

True-first reading on dendrometer

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

FALSE14 - numeric(5,1) (ratio)

ID: TV00905.FALSE14

11-14 false-second, offset reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

SIN14 - numeric(6,4) (ratio)

ID: TV00905.SIN14

Sine 3rd-sine angle reading

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

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

ENDID - char(1) (nominal)

ID: TV00905.ENDID

Identifier for the end of tree measurements

Type system: Microsoft SQL Server 2008

TV00906 - TV00906

Object name: TV00906.csv

Records: 12528

Attributes: 29

File size: 1916707 byte

Checksum (MD5): e23397c930ef66d9a83f8bfb88455a70

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

Constraints (1)
  • notNullConstraint: NOTNULL
    TV00906.DATACODE, TV00906.DBH, TV00906.DIBUPPER, TV00906.DOBUPPER, TV00906.FALSE, TV00906.FORMAT, TV00906.HEIGHT, TV00906.LL, TV00906.LOGNUM, TV00906.SPECIES, TV00906.STAND, TV00906.STUDYID, TV00906.TREENUM, TV00906.TRUE
Attributes (29)
DATACODE - char(5) (nominal)

ID: TV00906.DATACODE

Data set code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • TV009
    FSDB database code TV009 (terrestrial vegetation)
FORMAT - numeric(2,0) (interval)

ID: TV00906.FORMAT

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

STUDYID - char(4) (nominal)

ID: TV00906.STUDYID

Study area name

Type system: Microsoft SQL Server 2008

Code definitions (19)
  • AKRS
    Noatak National Park, Alaska
  • CASC
    Pooled data for all cascade range studyid's
  • CHEF
    Cascade head experimental forest (hsgy)
  • COAS
    Cascade Head Experimental Forest (HSGY)
  • DFGY
    Douglas fir growth and yield
  • HSGY
    Hemlock-spruce growth and yield
  • LTER
    Watershed 2 and Hagan block lter transects (tree data)
  • MEND
    Mendel unit snags at the hj andrews experimenatl forest
  • MHGY
    Mountain hemlock growth and yield
  • MHVL
    Mountain hemlock volume study
  • MISC
    Miscellaneous reference stands
  • MRRS
    Mt Rainier reference stands
  • NFGY
    Noble fir growth and yield
  • OHJA
    H.J. Andrews reference stands
  • PPGY
    Ponderosa pine growth and yield
  • RMRS
    Rocky Mtn. reference stands
  • SNAG
    Snag study (at Cascade Head and Sequoia Natl. Park)
  • SQNP
    Sequoia national park reference stands
  • THIN
    Greene and Emmingham thinning plots (see study code FS024)
STAND - char(4) (nominal)

ID: TV00906.STAND

Plot or reference stand or plot in transect

Type system: Microsoft SQL Server 2008

Code definitions (156)
  • RS01
    Reference Stand RS01, H.J. Andrews EF, Willamette NF
  • RS02
    Reference Stand RS02, H.J. Andrews EF, Willamette NF
  • RS03
    Reference Stand RS03, H.J. Andrews EF, Willamette NF
  • RS07
    Reference Stand RS07, H.J. Andrews EF, Willamette NF
  • RS15
    Reference Stand RS15, H.J. Andrews EF, Willamette NF
  • RS16
    Reference Stand RS16, H.J. Andrews EF, Willamette NF
  • RS20
    Reference Stand RS20, H.J. Andrews EF, Willamette NF
  • RS24
    Reference Stand RS24, Hagan Block RNA, Willamette NF
  • CHEF
    Cascade Head Experimental Forest
  • CH14
    Reference Stand CH14, Cascade Head EF, Douglas-fir
  • CH01
    Reference Stand CH01, Cascade Head EF, hemlock-spruce
  • CH03
    Reference Stand CH03, Cascade Head EF, hemlock-spruce
  • CH04
    Reference Stand CH04, Cascade Head EF, hemlock-spruce
  • CH05
    Reference Stand CH05, Cascade Head EF, hemlock-spruce
  • CH06
    Reference Stand CH06, Cascade Head EF, hemlock-spruce
  • CH07
    Reference Stand CH07, Cascade Head EF, hemlock-spruce
  • CH08
    Reference Stand CH08, Cascade Head EF, hemlock-spruce
  • CH09
    Reference Stand CH09, Cascade Head EF, hemlock-spruce
  • CH10
    Reference Stand CH10, Cascade Head EF, hemlock-spruce
  • CH12
    Reference Stand CH12, Cascade Head EF, hemlock-spruce
  • CH13
    Reference Stand CH13, Cascade Head EF, hemlock-spruce
  • HR01
    Reference Stand HR01, South Fork Hoh River, Olympic NP
  • HR02
    Reference Stand HR02, South Fork Hoh River, Olympic NP
  • HR03
    Reference Stand HR03, South Fork Hoh River, Olympic NP
  • HR04
    Reference Stand HR04, South Fork Hoh River, Olympic NP
  • HS02
    Reference Stand HS02, Quinault RNA, Olympic NP
  • HS03
    Reference Stand HS03, Quinault RNA, Olympic NP
  • NCNA
    Reference Stand NCNA, Neskowin Crest RNA, Siuslaw NF
  • SP06
    Reference Stand SP06, Santiam Pass, Willamette NF
  • BLNF
    Reference Stand BLNF, Blue Lake, Gifford Pinchot NF
  • BPNF
    Reference Stand BPNF, Benson Plateau, Mount Hood NF
  • CMNF
    Reference Stand CMNF, Carpenter Mtn, Blue R, Willamette NF
  • GMNF
    Reference Stand GMNF, Goat Marsh RNA, Gifford Pinchot NF
  • HPNF
    Reference Stand HPNF, Huffman Peak, Gifford Pinchot NF
  • MPNF
    Reference Stand MPNF, Mary's Peak, Siuslaw NF
  • NWNF
    Reference Stand NWNF, North Wilson, Mount Hood NF
  • WLNF
    Reference Stand WLNF, Wahtum Lake, Mount Hood NF
  • WMNF
    Reference Stand WMNF, Wildcat Mtn RNA, Willamette NF
  • YBNF
    Reference Stand YBNF, Yacolt Burn, Gifford Pinchot NF
  • YSNF
    Reference Stand YSNF, Yarder sale, Wahtum Lake, Mt. Hood NF
  • RS10
    Reference Stand RS10, H.J. Andrews EF, Willamette NF
  • RS27
    Reference Stand RS27, H.J. Andrews EF, Willamette NF
  • RS32
    Reference Stand RS32, H.J. Andrews EF, Willamette NF
  • RS37
    Reference Stand RS37, South Fork Hagan Creek, Willamette NF
  • MRNA
    Reference Stand MRNA, Metolius RNA, Deschutes NF
  • FRC3
    Reference Stand FRC3, Fraser EF, CO, lodgepole pine
  • FRD1
    Reference Stand FRD1, Fraser EF, CO, spruce-fir
  • AB08
    Reference Stand AB08, White River, Mt. Rainier NP
  • AE10
    Reference Stand AE10, Nisqually River, Mt. Rainier NP
  • AG05
    Reference Stand AG05, Nisqually River, Mt. Rainier NP
  • AM16
    Reference Stand AM16, Nisqually River, Mt. Rainier NP
  • AO03
    Reference Stand AO03, Ohanapecosh River, Mt. Rainier NP
  • AR07
    Reference Stand AR07, Nisqually River, Mt. Rainier NP
  • AR19
    Reference Stand AR19, White River, Mt. Rainier NP
  • AV02
    Reference Stand AV02, Ohanapecosh River, Mt. Rainier NP
  • AV06
    Reference Stand AV06, Nisqually River, Mt. Rainier NP
  • AV14
    Reference Stand AV14, Carbon River, Mt. Rainier NP
  • AX15
    Reference Stand AX15, Nisqually River, Mt. Rainier NP
  • PP17
    Reference Stand PP17, White River, Mt. Rainier NP
  • TA01
    Reference Stand TA01, Ohanapecosh River, Mt. Rainier NP
  • TB13
    Reference Stand TB13, Nisqually River, Mt. Rainier NP
  • TO04
    Reference Stand TO04, Nisqually River, Mt. Rainier NP
  • TO11
    Reference Stand TO11, Carbon River, Mt. Rainier NP
  • CCNF
    Reference Stand CCNF, Cushman Crest, Mt. Rainier NP
  • SRNF
    Reference Stand SRNF, Sunrise Ridge, Mt. Rainier NP
  • ABCO
    Reference Stand ABCO, Suwanee Creek, Sequoia NP, white fir
  • LMCC
    Reference Stand LMCC, Crescent Creek, Sequoia NP
  • PIJE
    Reference Stand PIJE, Sequoia NP, Jeffrey pine
  • PILA
    Reference Stand PILA, Suwanee Creek, Sequoia NP, sugar pine
  • SUCR
    Reference Stand SUCR, Suwanee Cr, Sequoia NP, mixed conifer
  • UCRS
    Reference Stand UCRS, Upper Crescent Cr, Sequoia NP, SEGI
  • TCNF
    Reference Stand TCNF, Three Corner Rock, Washington DNR
  • CH11
    Reference Stand CH11, Cascade Head EF, hemlock-spruce
  • CH15
    Reference Stand CH15, Cascade Head EF, alder-conifer
  • 13
    Deschutes NF, John Bell data, Greg Johnson plot 13
  • 20
    Deschutes NF, John Bell data, Greg Johnson plot 20
  • 2233
    Willamette NF, Detroit Rd, Road 2233 flats
  • 23
    Deschutes NF, John Bell data, Greg Johnson plot 23
  • 25
    Deschutes NF, John Bell data, Greg Johnson plot 25
  • 2618
    Ashland, atzet plot 2618, Rogue River NF
  • 2619
    Ashland, atzet plot 2619, Rogue River NF
  • 2623
    Ashland, atzet plot 2623, Rogue River NF
  • 2631
    Ashland, atzet plot 2631, Rogue River NF
  • 2632
    Ashland, atzet plot 2632, Rogue River NF
  • 29
    Deschutes NF, John Bell data, Greg Johnson plot 29
  • 3
    Deschutes NF, John Bell data, Greg Johnson plot 3
  • 30
    Deschutes NF, John Bell data, Greg Johnson plot 30
  • 31
    Deschutes NF, John Bell data, Greg Johnson plot 31
  • 32
    Deschutes NF, John Bell data, Greg Johnson plot 32
  • 348
    Willamette NF, Detroit rd, Hemstrom plot # 348
  • 35
    Deschutes NF, John Bell data, Greg Johnson plot 35
  • 353
    Willamette NF, Detroit rd, Hemstrom plot # 353
  • 4
    Deschutes NF, John Bell data, Greg Johnson plot 4
  • CH02
    Cascade Head EF, CHO2
  • CH16
    Cascade Head EF, CH16
  • GP-1
    Gifford Pinchot NF, Packwood rd , road 45, GP-1
  • GP-2
    Gifford Pinchot NF, Packwood rd , road 45, GP-2
  • GP-3
    Gifford Pinchot NF, Packwood rd , White Pass
  • GP-4
    Gifford Pinchot NF, Mt.Adams rd
  • HM33
    Willamette NF, Detroit rd, Hemstrom plot # 332
  • MB10
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB10
  • MB11
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB11
  • MB12
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB12
  • MB13
    Mt. Baker- Snoqualmie NF, Darrington RD, MB13
  • MB14
    Mt. Baker- Snoqualmie NF, Darrington RD, MB14
  • MB15
    Mt. Baker- Snoqualmie NF, Darrington RD, MB15
  • MB16
    Mt. Baker- Snoqualmie NF, Darrington RD, MB16
  • MB17
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB17
  • MB18
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB18
  • MB19
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB19
  • MB20
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB20
  • MB21
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB21
  • MB22
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB22
  • MB23
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB23
  • MB24
    Mt. Baker- Snoqualmie NF, North Bend RD, MB24
  • MB25
    Mt. Baker- Snoqualmie NF, North Bend RD, MB25
  • MB26
    Mt. Baker- Snoqualmie NF, North Bend RD, MB26
  • MB27
    Mt. Baker- Snoqualmie NF, North Bend RD, MB27
  • MB28
    Mt. Baker- Snoqualmie NF, North Bend RD, MB28
  • MBS1
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS1
  • MBS2
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS2
  • MBS3
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS3
  • MBS4
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS4
  • MBS5
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS5
  • MBS6
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS6
  • MBS7
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS7
  • MBS8
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS8
  • MBS9
    Mt. Baker- Snoqualmie NF, Darrington RD, MBS9
  • MH-1
    Mt. Hood, Hood River R.D., Recon plot 0003, N. Halvorsen
  • MH-2
    Mt. Hood, Hood River R.D., MH-2
  • MH-3
    Mt. Hood, Hood River R.D., Road 3540
  • MH-4
    Mt. Hood, Hood River R.D., MH-4
  • MH-5
    Mt. Hood, Hood River R.D., MH-5
  • MH-6
    Mt. Hood, Hood River R.D., MH-6
  • MHVL
    Deschutes NF, John Bell data, Greg Johnson plot 2
  • RAIN
    Mt. Rainier, RAIN
  • SUMM
    Deschutes NF, Santiam Pass Summit, John Bell data
  • TCMH
    Torrey-Charlton RNA
  • UMP1
    Umpqua NF, Diamond Lake RD, Cinnamon Butte
  • UMP2
    Umpqua NF, UMP2
  • UMP3
    Willamette NF, Rigdon RD
  • UMP4
    Willamette NF, Fairview Peak
  • WEN1
    Wenatchee NF, Wenatchee RD
  • WEN2
    Wenatchee NF, Wenatchee RD, Miner's Ridge
  • WEN3
    Wenatchee NF, Naches RD, WEN3
  • WEN4
    Wenatchee NF, Naches RD, Pinegrass Ridge
  • WEN5
    Wenatchee NF, Naches RD, WEN5
  • WEN6
    Wenatchee NF, Naches RD, Bethel Ridge, WEN6
  • WEN7
    Wenatchee NF, Naches RD, Bethel Ridge, WEN7
  • WEN8
    Wenatchee NF, Naches RD, Section 3 Lake
  • WIL1
    Willamette NF, Blue River RD, Carpenter Mtn
  • WIL2
    Santiam Pass, Gholz Ref. Stand
  • WIND
    Deschutes NF, Windigo Pass, John Bell data
  • BMTN
    Reference Stand BMTN, Sequoia NP
  • WOLV
    Reference Stand WOLV , Sequoia NP
  • MEND
    Mendel unit, HJ Andrews Experimental Forest
SUBPLOT - numeric(2,0) (interval)

ID: TV00906.SUBPLOT

Subplot of reference stand

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TV00906.YEAR

Year

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

TREENUM - numeric(4,0) (interval)

ID: TV00906.TREENUM

Tree tag number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SPECIES - char(5) (nominal)

ID: TV00906.SPECIES

Tree species code after Garrison et al., 1972

Type system: Microsoft SQL Server 2008

Code definitions (29)
  • ABAM
    Abies amabilis
  • ABCO
    Abies concolor
  • ABGR
    Abies grandis
  • ABLA2
    Abies lasiocarpa
  • ABMA
    Abies magnifica
  • ABPR
    Abies procera
  • ACMA
    Acer macrophyllum
  • ALRU
    Alnus rubra
  • ARME
    Arbutus menziesii
  • CADE3
    Calocedrus decurrens
  • CHLA
    Chamaecyparis lawsoniana
  • CHNO
    Chamaecyparis nootkatensis
  • LIDE
    Lithocarpus densiflorus
  • PIEN
    Picea engelmannii
  • PISI
    Picea sitchensis
  • PICO
    Pinus contorta
  • PIJE
    Pinus jeffreyi
  • PILA
    Pinus lambertiana
  • PIMO
    Pinus monticola
  • PIPO
    Pinus ponderosa
  • PSME
    Pseudotsuga menziesii
  • QUGA
    Quercus garryana
  • QUKE
    Quercus kelloggii
  • TABR
    Taxus brevifolia
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • TSME
    Tsuga mertensiana
  • CACH
    Castanopsis chrysophylla
  • SEGI
    Sequoiadendron giganteum
CL - numeric(7,2) (ratio)

ID: TV00906.CL

Cummulative length or height from the base of tree (ground) ees the total length of stem

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

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

LL - numeric(6,2) (ratio)

ID: TV00906.LL

Length of log

Type system: Microsoft SQL Server 2008

Unit: cubic meters

Precision: 0.010000

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

CIBV - numeric(7,3) (ratio)

ID: TV00906.CIBV

Cummulative inside bark volume from the base of tree

Type system: Microsoft SQL Server 2008

Unit: cubic meters

Precision: 0.001000

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

LIBV - numeric(7,3) (ratio)

ID: TV00906.LIBV

Log inside bark volume from the base of tree

Type system: Microsoft SQL Server 2008

Unit: square meters

Precision: 0.001000

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

CBV - numeric(6,3) (ratio)

ID: TV00906.CBV

Cummulative bark volume from the base of tree

Type system: Microsoft SQL Server 2008

Unit: square meters

Precision: 0.001000

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

LBV - numeric(6,3) (ratio)

ID: TV00906.LBV

Log bark volume

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.001000

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

CIBSA - numeric(6,2) (ratio)

ID: TV00906.CIBSA

Cummulative inside bark surface area from the base of tree

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.010000

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

LIBSA - numeric(6,2) (ratio)

ID: TV00906.LIBSA

Log inside bark surface area

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.010000

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

COBSA - numeric(6,2) (ratio)

ID: TV00906.COBSA

Cummulative outside bark surface area from tree base

Type system: Microsoft SQL Server 2008

Unit: square meters

Precision: 0.010000

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

LOBSA - numeric(6,2) (ratio)

ID: TV00906.LOBSA

Log outside bark surface area

Type system: Microsoft SQL Server 2008

Unit: square meters

Precision: 0.010000

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

DIBLOWER - numeric(5,1) (ratio)

ID: TV00906.DIBLOWER

Diameter at bottom of log inside bark

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

DOBLOWER - numeric(5,1) (ratio)

ID: TV00906.DOBLOWER

Diameter at bottom of log outside bark

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

DIBUPPER - numeric(5,1) (ratio)

ID: TV00906.DIBUPPER

Diameter at top of log inside bark

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

DOBUPPER - numeric(5,1) (ratio)

ID: TV00906.DOBUPPER

Diameter at top of log outside bark

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

TRUE - numeric(5,1) (ratio)

ID: TV00906.TRUE

Original dendrometer measurement

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

FALSE - numeric(5,1) (ratio)

ID: TV00906.FALSE

Original dendrometer measurement, or, for the first log, the value is diamet er

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

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

SINE - numeric(8,4) (ratio)

ID: TV00906.SINE

Original dendrometer measurement, or for first log, this is the distance bet ween stump abd dbh

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

Numeric domain: type=real, min=-0.9448 (exclusive=false), max=740.0000 (exclusive=false)

DBH - numeric(5,1) (ratio)

ID: TV00906.DBH

Diameter at breast height

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

HEIGHT - numeric(7,2) (ratio)

ID: TV00906.HEIGHT

Sum of log lengths

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

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

LOGNUM - numeric(2,0) (interval)

ID: TV00906.LOGNUM

Log number from bottom

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SAMPLEDATE - datetime (dateTime)

ID: TV00906.SAMPLEDATE

date

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TV00907 - TV00907

Object name: TV00907.csv

Records: 1697

Attributes: 21

File size: 158521 byte

Checksum (MD5): ea013ba19a035a13f022e0e453d92844

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

Constraints (1)
  • notNullConstraint: NOTNULL
    TV00907.BT1, TV00907.BT2, TV00907.DATACODE, TV00907.DBH, TV00907.FORMAT, TV00907.LENGTH, TV00907.SPECIES, TV00907.STAND, TV00907.STUDYID, TV00907.TBV, TV00907.TIBSA, TV00907.TIBV, TV00907.TOBSA, TV00907.TREENUM
Attributes (21)
DATACODE - char(5) (nominal)

ID: TV00907.DATACODE

Data set code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • TV009
    FSDB database code TV009 (terrestrial vegetation)
FORMAT - numeric(2,0) (interval)

ID: TV00907.FORMAT

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

STUDYID - char(4) (nominal)

ID: TV00907.STUDYID

Study area name

Type system: Microsoft SQL Server 2008

Code definitions (19)
  • AKRS
    Noatak National Park, Alaska
  • CASC
    Pooled data for all cascade range studyid's
  • CHEF
    Cascade head experimental forest (hsgy)
  • COAS
    Cascade Head Experimental Forest (HSGY)
  • DFGY
    Douglas fir growth and yield
  • HSGY
    Hemlock-spruce growth and yield
  • LTER
    Watershed 2 and Hagan block lter transects (tree data)
  • MEND
    Mendel unit snags at the hj andrews experimenatl forest
  • MHGY
    Mountain hemlock growth and yield
  • MHVL
    Mountain hemlock volume study
  • MISC
    Miscellaneous reference stands
  • MRRS
    Mt Rainier reference stands
  • NFGY
    Noble fir growth and yield
  • OHJA
    H.J. Andrews reference stands
  • PPGY
    Ponderosa pine growth and yield
  • RMRS
    Rocky Mtn. reference stands
  • SNAG
    Snag study (at Cascade Head and Sequoia Natl. Park)
  • SQNP
    Sequoia national park reference stands
  • THIN
    Greene and Emmingham thinning plots (see study code FS024)
STAND - char(4) (nominal)

ID: TV00907.STAND

Plot or reference stand or plot in transect

Type system: Microsoft SQL Server 2008

Code definitions (156)
  • RS01
    Reference Stand RS01, H.J. Andrews EF, Willamette NF
  • RS02
    Reference Stand RS02, H.J. Andrews EF, Willamette NF
  • RS03
    Reference Stand RS03, H.J. Andrews EF, Willamette NF
  • RS07
    Reference Stand RS07, H.J. Andrews EF, Willamette NF
  • RS15
    Reference Stand RS15, H.J. Andrews EF, Willamette NF
  • RS16
    Reference Stand RS16, H.J. Andrews EF, Willamette NF
  • RS20
    Reference Stand RS20, H.J. Andrews EF, Willamette NF
  • RS24
    Reference Stand RS24, Hagan Block RNA, Willamette NF
  • CHEF
    Cascade Head Experimental Forest
  • CH14
    Reference Stand CH14, Cascade Head EF, Douglas-fir
  • CH01
    Reference Stand CH01, Cascade Head EF, hemlock-spruce
  • CH03
    Reference Stand CH03, Cascade Head EF, hemlock-spruce
  • CH04
    Reference Stand CH04, Cascade Head EF, hemlock-spruce
  • CH05
    Reference Stand CH05, Cascade Head EF, hemlock-spruce
  • CH06
    Reference Stand CH06, Cascade Head EF, hemlock-spruce
  • CH07
    Reference Stand CH07, Cascade Head EF, hemlock-spruce
  • CH08
    Reference Stand CH08, Cascade Head EF, hemlock-spruce
  • CH09
    Reference Stand CH09, Cascade Head EF, hemlock-spruce
  • CH10
    Reference Stand CH10, Cascade Head EF, hemlock-spruce
  • CH12
    Reference Stand CH12, Cascade Head EF, hemlock-spruce
  • CH13
    Reference Stand CH13, Cascade Head EF, hemlock-spruce
  • HR01
    Reference Stand HR01, South Fork Hoh River, Olympic NP
  • HR02
    Reference Stand HR02, South Fork Hoh River, Olympic NP
  • HR03
    Reference Stand HR03, South Fork Hoh River, Olympic NP
  • HR04
    Reference Stand HR04, South Fork Hoh River, Olympic NP
  • HS02
    Reference Stand HS02, Quinault RNA, Olympic NP
  • HS03
    Reference Stand HS03, Quinault RNA, Olympic NP
  • NCNA
    Reference Stand NCNA, Neskowin Crest RNA, Siuslaw NF
  • SP06
    Reference Stand SP06, Santiam Pass, Willamette NF
  • BLNF
    Reference Stand BLNF, Blue Lake, Gifford Pinchot NF
  • BPNF
    Reference Stand BPNF, Benson Plateau, Mount Hood NF
  • CMNF
    Reference Stand CMNF, Carpenter Mtn, Blue R, Willamette NF
  • GMNF
    Reference Stand GMNF, Goat Marsh RNA, Gifford Pinchot NF
  • HPNF
    Reference Stand HPNF, Huffman Peak, Gifford Pinchot NF
  • MPNF
    Reference Stand MPNF, Mary's Peak, Siuslaw NF
  • NWNF
    Reference Stand NWNF, North Wilson, Mount Hood NF
  • WLNF
    Reference Stand WLNF, Wahtum Lake, Mount Hood NF
  • WMNF
    Reference Stand WMNF, Wildcat Mtn RNA, Willamette NF
  • YBNF
    Reference Stand YBNF, Yacolt Burn, Gifford Pinchot NF
  • YSNF
    Reference Stand YSNF, Yarder sale, Wahtum Lake, Mt. Hood NF
  • RS10
    Reference Stand RS10, H.J. Andrews EF, Willamette NF
  • RS27
    Reference Stand RS27, H.J. Andrews EF, Willamette NF
  • RS32
    Reference Stand RS32, H.J. Andrews EF, Willamette NF
  • RS37
    Reference Stand RS37, South Fork Hagan Creek, Willamette NF
  • MRNA
    Reference Stand MRNA, Metolius RNA, Deschutes NF
  • FRC3
    Reference Stand FRC3, Fraser EF, CO, lodgepole pine
  • FRD1
    Reference Stand FRD1, Fraser EF, CO, spruce-fir
  • AB08
    Reference Stand AB08, White River, Mt. Rainier NP
  • AE10
    Reference Stand AE10, Nisqually River, Mt. Rainier NP
  • AG05
    Reference Stand AG05, Nisqually River, Mt. Rainier NP
  • AM16
    Reference Stand AM16, Nisqually River, Mt. Rainier NP
  • AO03
    Reference Stand AO03, Ohanapecosh River, Mt. Rainier NP
  • AR07
    Reference Stand AR07, Nisqually River, Mt. Rainier NP
  • AR19
    Reference Stand AR19, White River, Mt. Rainier NP
  • AV02
    Reference Stand AV02, Ohanapecosh River, Mt. Rainier NP
  • AV06
    Reference Stand AV06, Nisqually River, Mt. Rainier NP
  • AV14
    Reference Stand AV14, Carbon River, Mt. Rainier NP
  • AX15
    Reference Stand AX15, Nisqually River, Mt. Rainier NP
  • PP17
    Reference Stand PP17, White River, Mt. Rainier NP
  • TA01
    Reference Stand TA01, Ohanapecosh River, Mt. Rainier NP
  • TB13
    Reference Stand TB13, Nisqually River, Mt. Rainier NP
  • TO04
    Reference Stand TO04, Nisqually River, Mt. Rainier NP
  • TO11
    Reference Stand TO11, Carbon River, Mt. Rainier NP
  • CCNF
    Reference Stand CCNF, Cushman Crest, Mt. Rainier NP
  • SRNF
    Reference Stand SRNF, Sunrise Ridge, Mt. Rainier NP
  • ABCO
    Reference Stand ABCO, Suwanee Creek, Sequoia NP, white fir
  • LMCC
    Reference Stand LMCC, Crescent Creek, Sequoia NP
  • PIJE
    Reference Stand PIJE, Sequoia NP, Jeffrey pine
  • PILA
    Reference Stand PILA, Suwanee Creek, Sequoia NP, sugar pine
  • SUCR
    Reference Stand SUCR, Suwanee Cr, Sequoia NP, mixed conifer
  • UCRS
    Reference Stand UCRS, Upper Crescent Cr, Sequoia NP, SEGI
  • TCNF
    Reference Stand TCNF, Three Corner Rock, Washington DNR
  • CH11
    Reference Stand CH11, Cascade Head EF, hemlock-spruce
  • CH15
    Reference Stand CH15, Cascade Head EF, alder-conifer
  • 13
    Deschutes NF, John Bell data, Greg Johnson plot 13
  • 20
    Deschutes NF, John Bell data, Greg Johnson plot 20
  • 2233
    Willamette NF, Detroit Rd, Road 2233 flats
  • 23
    Deschutes NF, John Bell data, Greg Johnson plot 23
  • 25
    Deschutes NF, John Bell data, Greg Johnson plot 25
  • 2618
    Ashland, atzet plot 2618, Rogue River NF
  • 2619
    Ashland, atzet plot 2619, Rogue River NF
  • 2623
    Ashland, atzet plot 2623, Rogue River NF
  • 2631
    Ashland, atzet plot 2631, Rogue River NF
  • 2632
    Ashland, atzet plot 2632, Rogue River NF
  • 29
    Deschutes NF, John Bell data, Greg Johnson plot 29
  • 3
    Deschutes NF, John Bell data, Greg Johnson plot 3
  • 30
    Deschutes NF, John Bell data, Greg Johnson plot 30
  • 31
    Deschutes NF, John Bell data, Greg Johnson plot 31
  • 32
    Deschutes NF, John Bell data, Greg Johnson plot 32
  • 348
    Willamette NF, Detroit rd, Hemstrom plot # 348
  • 35
    Deschutes NF, John Bell data, Greg Johnson plot 35
  • 353
    Willamette NF, Detroit rd, Hemstrom plot # 353
  • 4
    Deschutes NF, John Bell data, Greg Johnson plot 4
  • CH02
    Cascade Head EF, CHO2
  • CH16
    Cascade Head EF, CH16
  • GP-1
    Gifford Pinchot NF, Packwood rd , road 45, GP-1
  • GP-2
    Gifford Pinchot NF, Packwood rd , road 45, GP-2
  • GP-3
    Gifford Pinchot NF, Packwood rd , White Pass
  • GP-4
    Gifford Pinchot NF, Mt.Adams rd
  • HM33
    Willamette NF, Detroit rd, Hemstrom plot # 332
  • MB10
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB10
  • MB11
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB11
  • MB12
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MB12
  • MB13
    Mt. Baker- Snoqualmie NF, Darrington RD, MB13
  • MB14
    Mt. Baker- Snoqualmie NF, Darrington RD, MB14
  • MB15
    Mt. Baker- Snoqualmie NF, Darrington RD, MB15
  • MB16
    Mt. Baker- Snoqualmie NF, Darrington RD, MB16
  • MB17
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB17
  • MB18
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB18
  • MB19
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB19
  • MB20
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB20
  • MB21
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB21
  • MB22
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB22
  • MB23
    Mt. Baker- Snoqualmie NF, Skykomish RD, MB23
  • MB24
    Mt. Baker- Snoqualmie NF, North Bend RD, MB24
  • MB25
    Mt. Baker- Snoqualmie NF, North Bend RD, MB25
  • MB26
    Mt. Baker- Snoqualmie NF, North Bend RD, MB26
  • MB27
    Mt. Baker- Snoqualmie NF, North Bend RD, MB27
  • MB28
    Mt. Baker- Snoqualmie NF, North Bend RD, MB28
  • MBS1
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS1
  • MBS2
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS2
  • MBS3
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS3
  • MBS4
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS4
  • MBS5
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS5
  • MBS6
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS6
  • MBS7
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS7
  • MBS8
    Mt. Baker- Snoqualmie NF, Mt. Baker RD, MBS8
  • MBS9
    Mt. Baker- Snoqualmie NF, Darrington RD, MBS9
  • MH-1
    Mt. Hood, Hood River R.D., Recon plot 0003, N. Halvorsen
  • MH-2
    Mt. Hood, Hood River R.D., MH-2
  • MH-3
    Mt. Hood, Hood River R.D., Road 3540
  • MH-4
    Mt. Hood, Hood River R.D., MH-4
  • MH-5
    Mt. Hood, Hood River R.D., MH-5
  • MH-6
    Mt. Hood, Hood River R.D., MH-6
  • MHVL
    Deschutes NF, John Bell data, Greg Johnson plot 2
  • RAIN
    Mt. Rainier, RAIN
  • SUMM
    Deschutes NF, Santiam Pass Summit, John Bell data
  • TCMH
    Torrey-Charlton RNA
  • UMP1
    Umpqua NF, Diamond Lake RD, Cinnamon Butte
  • UMP2
    Umpqua NF, UMP2
  • UMP3
    Willamette NF, Rigdon RD
  • UMP4
    Willamette NF, Fairview Peak
  • WEN1
    Wenatchee NF, Wenatchee RD
  • WEN2
    Wenatchee NF, Wenatchee RD, Miner's Ridge
  • WEN3
    Wenatchee NF, Naches RD, WEN3
  • WEN4
    Wenatchee NF, Naches RD, Pinegrass Ridge
  • WEN5
    Wenatchee NF, Naches RD, WEN5
  • WEN6
    Wenatchee NF, Naches RD, Bethel Ridge, WEN6
  • WEN7
    Wenatchee NF, Naches RD, Bethel Ridge, WEN7
  • WEN8
    Wenatchee NF, Naches RD, Section 3 Lake
  • WIL1
    Willamette NF, Blue River RD, Carpenter Mtn
  • WIL2
    Santiam Pass, Gholz Ref. Stand
  • WIND
    Deschutes NF, Windigo Pass, John Bell data
  • BMTN
    Reference Stand BMTN, Sequoia NP
  • WOLV
    Reference Stand WOLV , Sequoia NP
  • MEND
    Mendel unit, HJ Andrews Experimental Forest
SUBPLOT - numeric(2,0) (interval)

ID: TV00907.SUBPLOT

Subplot of reference stand

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: TV00907.YEAR

Year

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

TREENUM - numeric(4,0) (interval)

ID: TV00907.TREENUM

Tree tag number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

SPECIES - char(5) (nominal)

ID: TV00907.SPECIES

Tree species code after Garrison et al., 1972

Type system: Microsoft SQL Server 2008

Code definitions (29)
  • ABAM
    Abies amabilis
  • ABCO
    Abies concolor
  • ABGR
    Abies grandis
  • ABLA2
    Abies lasiocarpa
  • ABMA
    Abies magnifica
  • ABPR
    Abies procera
  • ACMA
    Acer macrophyllum
  • ALRU
    Alnus rubra
  • ARME
    Arbutus menziesii
  • CADE3
    Calocedrus decurrens
  • CHLA
    Chamaecyparis lawsoniana
  • CHNO
    Chamaecyparis nootkatensis
  • LIDE
    Lithocarpus densiflorus
  • PIEN
    Picea engelmannii
  • PISI
    Picea sitchensis
  • PICO
    Pinus contorta
  • PIJE
    Pinus jeffreyi
  • PILA
    Pinus lambertiana
  • PIMO
    Pinus monticola
  • PIPO
    Pinus ponderosa
  • PSME
    Pseudotsuga menziesii
  • QUGA
    Quercus garryana
  • QUKE
    Quercus kelloggii
  • TABR
    Taxus brevifolia
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • TSME
    Tsuga mertensiana
  • CACH
    Castanopsis chrysophylla
  • SEGI
    Sequoiadendron giganteum
LENGTH - numeric(7,2) (ratio)

ID: TV00907.LENGTH

The total tree height for non-forked trees. for forked trees, it is the tota l length of stem

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

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

TIBV - numeric(8,3) (ratio)

ID: TV00907.TIBV

Total inside bark volume =total wood volume

Type system: Microsoft SQL Server 2008

Unit: cubic meters

Precision: 0.001000

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

TBV - numeric(7,3) (ratio)

ID: TV00907.TBV

Total bark volume

Type system: Microsoft SQL Server 2008

Unit: cubic meters

Precision: 0.001000

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

TIBSA - numeric(6,2) (ratio)

ID: TV00907.TIBSA

Total inside bark surface area

Type system: Microsoft SQL Server 2008

Unit: square meters

Precision: 0.010000

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

TOBSA - numeric(7,2) (ratio)

ID: TV00907.TOBSA

Total outside bark surface area

Type system: Microsoft SQL Server 2008

Unit: square meters

Precision: 0.010000

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

DBH - numeric(5,1) (ratio)

ID: TV00907.DBH

Diameter at breast height

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

BT1 - numeric(5,1) (ratio)

ID: TV00907.BT1

First bark thickness reading

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

BT2 - numeric(5,1) (ratio)

ID: TV00907.BT2

Second bark thickness reading

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.100000

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

BULGES - char(1) (nominal)

ID: TV00907.BULGES

Bulging tree flag-indicates tree does not taper going up stem

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • *
    Tree bulges more than 0.5 in (1.2 cm) going up stem. indicates original reading may be faulty
FORKED - char(1) (nominal)

ID: TV00907.FORKED

Multiple top flag - indicates tree has forked top

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • M
    Tree had multiple top or is forked
DBHCHECK - char(1) (nominal)

ID: TV00907.DBHCHECK

Indicates that dendrometer measure of dbh is dissimilar to tape measurement

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • D
    The dendrometer dbh is greater than +/- 5% of the tape measurement
NOSTUMP - char(1) (nominal)

ID: TV00907.NOSTUMP

Indicates that stump volume and height cannot be calculated

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • Z
    Stump volume and height cannot be calculated for this tree
SAMPLEDATE - datetime (dateTime)

ID: TV00907.SAMPLEDATE

date

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TV00908 - TV00908

Object name: TV00908.csv

Records: 201

Attributes: 15

File size: 16144 byte

Checksum (MD5): cce70cc0bc5ec52a86fa2ba05cef8aef

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

Constraints (2)
  • primaryKey: PRIMARY
    TV00908.EQN_NO
  • notNullConstraint: NOTNULL
    TV00908.B_1, TV00908.COMP, TV00908.DATACODE, TV00908.DENSITY, TV00908.EQFORM, TV00908.FORMAT, TV00908.RSQ, TV00908.SAMPSIZE, TV00908.SPECIES, TV00908.STUDYID, TV00908.YEAR, TV00908.EQN_NO
Attributes (15)
DATACODE - char(5) (nominal)

ID: TV00908.DATACODE

Data set code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • TV009
    FSDB database code TV009 (terrestrial vegetation)
FORMAT - numeric(2,0) (interval)

ID: TV00908.FORMAT

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)

EQN_NO - numeric(4,0) (interval)

ID: TV00908.EQN_NO

Sequential equation number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

EQFORM - char(4) (nominal)

ID: TV00908.EQFORM

Equation form

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • D2HT
    Y = b1*height*dbh*dbh (y = volume in m3, height in m, dbh in m)
  • LNLN
    Ln-ln transform. y = volume = b0*dbh**b1 (y in m3, dbh in cm)
YEAR - numeric(4,0) (interval)

ID: TV00908.YEAR

Year

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

STUDYID - char(4) (nominal)

ID: TV00908.STUDYID

Study area name

Type system: Microsoft SQL Server 2008

Code definitions (19)
  • AKRS
    Noatak National Park, Alaska
  • CASC
    Pooled data for all cascade range studyid's
  • CHEF
    Cascade head experimental forest (hsgy)
  • COAS
    Cascade Head Experimental Forest (HSGY)
  • DFGY
    Douglas fir growth and yield
  • HSGY
    Hemlock-spruce growth and yield
  • LTER
    Watershed 2 and Hagan block lter transects (tree data)
  • MEND
    Mendel unit snags at the hj andrews experimenatl forest
  • MHGY
    Mountain hemlock growth and yield
  • MHVL
    Mountain hemlock volume study
  • MISC
    Miscellaneous reference stands
  • MRRS
    Mt Rainier reference stands
  • NFGY
    Noble fir growth and yield
  • OHJA
    H.J. Andrews reference stands
  • PPGY
    Ponderosa pine growth and yield
  • RMRS
    Rocky Mtn. reference stands
  • SNAG
    Snag study (at Cascade Head and Sequoia Natl. Park)
  • SQNP
    Sequoia national park reference stands
  • THIN
    Greene and Emmingham thinning plots (see study code FS024)
SPECIES - char(5) (nominal)

ID: TV00908.SPECIES

Tree species code after Garrison et al., 1972

Type system: Microsoft SQL Server 2008

Code definitions (29)
  • ABAM
    Abies amabilis
  • ABCO
    Abies concolor
  • ABGR
    Abies grandis
  • ABLA2
    Abies lasiocarpa
  • ABMA
    Abies magnifica
  • ABPR
    Abies procera
  • ACMA
    Acer macrophyllum
  • ALRU
    Alnus rubra
  • ARME
    Arbutus menziesii
  • CADE3
    Calocedrus decurrens
  • CHLA
    Chamaecyparis lawsoniana
  • CHNO
    Chamaecyparis nootkatensis
  • LIDE
    Lithocarpus densiflorus
  • PIEN
    Picea engelmannii
  • PISI
    Picea sitchensis
  • PICO
    Pinus contorta
  • PIJE
    Pinus jeffreyi
  • PILA
    Pinus lambertiana
  • PIMO
    Pinus monticola
  • PIPO
    Pinus ponderosa
  • PSME
    Pseudotsuga menziesii
  • QUGA
    Quercus garryana
  • QUKE
    Quercus kelloggii
  • TABR
    Taxus brevifolia
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • TSME
    Tsuga mertensiana
  • CACH
    Castanopsis chrysophylla
  • SEGI
    Sequoiadendron giganteum
COMP - char(1) (nominal)

ID: TV00908.COMP

Volume component predicted by equation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • B
    Bark (inner + outer)
  • T
    Total (bark + wood)
  • W
    Wood (sapwood + heartwood)
B_0 - numeric(9,7) (ratio)

ID: TV00908.B_0

Y-intercept

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000000

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

B_1 - numeric(7,4) (ratio)

ID: TV00908.B_1

Slope of regression

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

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

CF - numeric(6,4) (ratio)

ID: TV00908.CF

Baskerville's correction factor [cf=e**(mse/2)]. should be multiplied by b0 to get corrected equation.

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

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

RSQ - numeric(5,3) (ratio)

ID: TV00908.RSQ

R-square

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.001000

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

SAMPSIZE - numeric(4,0) (interval)

ID: TV00908.SAMPSIZE

Sample size

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

DENSITY - numeric(5,3) (ratio)

ID: TV00908.DENSITY

Green density of component in mg/m3 or g/cm3

Type system: Microsoft SQL Server 2008

Unit: grams per cubic centimeter

Precision: 0.001000

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

SAMPLEDATE - datetime (dateTime)

ID: TV00908.SAMPLEDATE

date

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

TV00909 - TV00909

Object name: TV00909.csv

Records: 84

Attributes: 13

File size: 7314 byte

Checksum (MD5): eb86e89cff69a21d58676642e250dc71

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

Constraints (2)
  • primaryKey: PRIMARY
    TV00909.CANCLASS, TV00909.SPECIES, TV00909.STUDYID
  • notNullConstraint: NOTNULL
    TV00909.CANCLASS, TV00909.COVB0B1, TV00909.DATACODE, TV00909.FORMAT, TV00909.INTERCPT, TV00909.MSE_9, TV00909.SAMPSIZE, TV00909.SLOPE, TV00909.SPECIES, TV00909.STUDYID, TV00909.VARB0, TV00909.VARB1
Attributes (13)
DATACODE - char(5) (nominal)

ID: TV00909.DATACODE

Data set code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • TV009
    FSDB database code TV009 (terrestrial vegetation)
FORMAT - numeric(2,0) (interval)

ID: TV00909.FORMAT

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)

STUDYID - char(4) (nominal)

ID: TV00909.STUDYID

Study area name

Type system: Microsoft SQL Server 2008

Code definitions (19)
  • AKRS
    Noatak National Park, Alaska
  • CASC
    Pooled data for all cascade range studyid's
  • CHEF
    Cascade head experimental forest (hsgy)
  • COAS
    Cascade Head Experimental Forest (HSGY)
  • DFGY
    Douglas fir growth and yield
  • HSGY
    Hemlock-spruce growth and yield
  • LTER
    Watershed 2 and Hagan block lter transects (tree data)
  • MEND
    Mendel unit snags at the hj andrews experimenatl forest
  • MHGY
    Mountain hemlock growth and yield
  • MHVL
    Mountain hemlock volume study
  • MISC
    Miscellaneous reference stands
  • MRRS
    Mt Rainier reference stands
  • NFGY
    Noble fir growth and yield
  • OHJA
    H.J. Andrews reference stands
  • PPGY
    Ponderosa pine growth and yield
  • RMRS
    Rocky Mtn. reference stands
  • SNAG
    Snag study (at Cascade Head and Sequoia Natl. Park)
  • SQNP
    Sequoia national park reference stands
  • THIN
    Greene and Emmingham thinning plots (see study code FS024)
SPECIES - char(5) (nominal)

ID: TV00909.SPECIES

Tree species code after Garrison et al., 1972

Type system: Microsoft SQL Server 2008

Code definitions (29)
  • ABAM
    Abies amabilis
  • ABCO
    Abies concolor
  • ABGR
    Abies grandis
  • ABLA2
    Abies lasiocarpa
  • ABMA
    Abies magnifica
  • ABPR
    Abies procera
  • ACMA
    Acer macrophyllum
  • ALRU
    Alnus rubra
  • ARME
    Arbutus menziesii
  • CADE3
    Calocedrus decurrens
  • CHLA
    Chamaecyparis lawsoniana
  • CHNO
    Chamaecyparis nootkatensis
  • LIDE
    Lithocarpus densiflorus
  • PIEN
    Picea engelmannii
  • PISI
    Picea sitchensis
  • PICO
    Pinus contorta
  • PIJE
    Pinus jeffreyi
  • PILA
    Pinus lambertiana
  • PIMO
    Pinus monticola
  • PIPO
    Pinus ponderosa
  • PSME
    Pseudotsuga menziesii
  • QUGA
    Quercus garryana
  • QUKE
    Quercus kelloggii
  • TABR
    Taxus brevifolia
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • TSME
    Tsuga mertensiana
  • CACH
    Castanopsis chrysophylla
  • SEGI
    Sequoiadendron giganteum
CANCLASS - char(2) (nominal)

ID: TV00909.CANCLASS

Canopy class code

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • DC
    Dominant-codominant
  • I
    Intermediate
  • S
    Suppressed
INTERCPT - numeric(9,6) (ratio)

ID: TV00909.INTERCPT

Y-intercept

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000001

Numeric domain: type=real, min=-0.0695 (exclusive=false), max=0.5358 (exclusive=false)

SLOPE - numeric(9,6) (ratio)

ID: TV00909.SLOPE

Slope of diameter increment on crown ratio

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000001

Numeric domain: type=real, min=-0.0011 (exclusive=false), max=0.0087 (exclusive=false)

VARB0 - numeric(10,8) (ratio)

ID: TV00909.VARB0

Variance of intercept to get corrected equation

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000000

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

VARB1 - numeric(10,4) (ratio)

ID: TV00909.VARB1

Variance of slope

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000100

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

COVB0B1 - numeric(10,7) (ratio)

ID: TV00909.COVB0B1

Covariance of intercept and slope

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000000

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

MSE_9 - numeric(7,5) (ratio)

ID: TV00909.MSE_9

Mean square error

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000010

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

RSQ - numeric(5,3) (ratio)

ID: TV00909.RSQ

R-square

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.001000

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

SAMPSIZE - numeric(4,0) (interval)

ID: TV00909.SAMPSIZE

Sample size

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

TV00910 - TV00910

Object name: TV00910.csv

Records: 96

Attributes: 23

File size: 15251 byte

Checksum (MD5): 694a22c09b16f0b7acab558d45c2f9cd

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

Constraints (1)
  • notNullConstraint: NOTNULL
    TV00910.B0, TV00910.B1, TV00910.B2, TV00910.DATACODE, TV00910.ECOREGIO, TV00910.FORMAT, TV00910.MAXDBH, TV00910.MAXELEV, TV00910.MAXHT, TV00910.MEANDBH, TV00910.MEANELEV, TV00910.MEANHT, TV00910.MINDBH, TV00910.MINELEV, TV00910.MINHT, TV00910.MSE_10, TV00910.RSQ, TV00910.SAMPSIZE, TV00910.SEB0, TV00910.SEB1, TV00910.SEB2, TV00910.SITECLAS, TV00910.SPECIES
Attributes (23)
DATACODE - char(5) (nominal)

ID: TV00910.DATACODE

Data set code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • TV009
    FSDB database code TV009 (terrestrial vegetation)
FORMAT - numeric(2,0) (interval)

ID: TV00910.FORMAT

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)

SPECIES - char(5) (nominal)

ID: TV00910.SPECIES

Tree species code after Garrison et al., 1972

Type system: Microsoft SQL Server 2008

Code definitions (29)
  • ABAM
    Abies amabilis
  • ABCO
    Abies concolor
  • ABGR
    Abies grandis
  • ABLA2
    Abies lasiocarpa
  • ABMA
    Abies magnifica
  • ABPR
    Abies procera
  • ACMA
    Acer macrophyllum
  • ALRU
    Alnus rubra
  • ARME
    Arbutus menziesii
  • CADE3
    Calocedrus decurrens
  • CHLA
    Chamaecyparis lawsoniana
  • CHNO
    Chamaecyparis nootkatensis
  • LIDE
    Lithocarpus densiflorus
  • PIEN
    Picea engelmannii
  • PISI
    Picea sitchensis
  • PICO
    Pinus contorta
  • PIJE
    Pinus jeffreyi
  • PILA
    Pinus lambertiana
  • PIMO
    Pinus monticola
  • PIPO
    Pinus ponderosa
  • PSME
    Pseudotsuga menziesii
  • QUGA
    Quercus garryana
  • QUKE
    Quercus kelloggii
  • TABR
    Taxus brevifolia
  • THPL
    Thuja plicata
  • TSHE
    Tsuga heterophylla
  • TSME
    Tsuga mertensiana
  • CACH
    Castanopsis chrysophylla
  • SEGI
    Sequoiadendron giganteum
ECOREGIO - varchar(24) (nominal)

ID: TV00910.ECOREGIO

Explicit geographic region of equation applicability

Type system: Microsoft SQL Server 2008

SITECLAS - char(3) (nominal)

ID: TV00910.SITECLAS

Site class

Type system: Microsoft SQL Server 2008

SAMPSIZE - numeric(4,0) (interval)

ID: TV00910.SAMPSIZE

Sample size

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

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

B0 - numeric(9,6) (ratio)

ID: TV00910.B0

Coeff in: ht = 1.37 + (b0(1-exp(b1*dbh))**b2), ht in m, dbh in cm

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000001

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

SEB0 - numeric(9,6) (ratio)

ID: TV00910.SEB0

Standard error of b0

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000001

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

B1 - numeric(9,6) (ratio)

ID: TV00910.B1

Coeff in: ht = 1.37 + (b0(1-exp(b1*dbh))**b2), ht in m, dbh in cm

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000001

Numeric domain: type=real, min=-0.0451 (exclusive=false), max=-0.0083 (exclusive=false)

SEB1 - numeric(9,6) (ratio)

ID: TV00910.SEB1

Standard error of b1

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000001

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

B2 - numeric(9,6) (ratio)

ID: TV00910.B2

Coeff in: ht = 1.37 + (b0(1-exp(b1*dbh))**b2), ht in m, dbh in cm

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000001

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

SEB2 - numeric(9,6) (ratio)

ID: TV00910.SEB2

Standard error of b2

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.000001

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

MSE_10 - numeric(6,3) (ratio)

ID: TV00910.MSE_10

Mean square error

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.001000

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

RSQ - numeric(5,3) (ratio)

ID: TV00910.RSQ

R-square

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.001000

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

MEANDBH - numeric(6,2) (ratio)

ID: TV00910.MEANDBH

Mean dbh

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.010000

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

MINDBH - numeric(6,2) (ratio)

ID: TV00910.MINDBH

Minimum dbh

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.010000

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

MAXDBH - numeric(6,2) (ratio)

ID: TV00910.MAXDBH

Maximum dbh

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.010000

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

MEANHT - numeric(5,2) (ratio)

ID: TV00910.MEANHT

Mean height

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

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

MINHT - numeric(5,2) (ratio)

ID: TV00910.MINHT

Minimum height

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

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

MAXHT - numeric(5,2) (ratio)

ID: TV00910.MAXHT

Maximum height

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

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

MEANELEV - numeric(4,0) (ratio)

ID: TV00910.MEANELEV

Mean elevation

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1.000000

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

MINELEV - numeric(4,0) (ratio)

ID: TV00910.MINELEV

Minimum elevation

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1.000000

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

MAXELEV - numeric(4,0) (ratio)

ID: TV00910.MAXELEV

Maximum elevation

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1.000000

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

Units
cubic meters m3 volume meterCubed meterCubed 1 cubic meters
square meters m2 area meterSquared meterSquared 1 square meters
grams per cubic centimeter g/cm3 massDensity gramPerCentimeterCubed kilogramPerMeterCubed 1000 grams per cubic centimeter
centimeters cm length centimeter meter 0.01 centimeters; .01 meters
meters m length meter meter 1 meter; SI unit of length
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

No publication citations found in this EML file.

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: notPlanned

Description

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

Change History

  • Version1 (1984-02-01)
    Original metadata creation.
  • Version2 (1990-04-25)
    4/25/90: Separate study-area files were combined into single files for each entity.
  • Version3 (2002-02-28)
    Metadata restructured and moved into SQLServer metadata database LTERMETA. Data moved into SQLServer database FSDBDATA.
  • Version8 (2015-11-10)
    Made changes to entity 8. Main change was to add eqn_no.
  • Version9 (2015-12-16)
    Needed to create new CSV with new delimiter for uploading to PASTA. Corrected some species and locations.