TV010: Long-term growth, mortality and regeneration of trees in permanent vegetation plots in the Pacific Northwest, 1910 to present
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.; Bell, D.; Remillard, S.; Pabst, R.; Bluhm, A.; Powers, M. 2025. Long-term growth, mortality and regeneration of trees in permanent vegetation plots in the Pacific Northwest, 1910 to present Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/TV010 Accessed 2026-05-10.
Abstract
A network of more than 130 permanent vegetation plots provides long-term information on patterns and rates of forest succession in most of the major forest zones of the Pacific Northwest. The plot network extends from the coast to the Cascades in western Oregon and Washington and east to ponderosa pine forests in the Oregon Cascades. Most of the permanent plots were established during two intervals: from 1910 to 1948, and from 1970 to 1989. The earlier plots were established by U.S. Forest Service researchers to quantify timber growth in young stands of important commercial species and to help answer other applied forestry questions. The more recent period of plot establishment began under the Coniferous Forest Biome program of the International Biological Program during the 1970s, and continued under the Long-term Ecological Research program. A broader set of objectives motivated plot establishment since 1970, especially quantification of composition, structure, and population and ecosystem dynamics of natural forests. Plots have one of three spatial arrangements: (1) contiguous rectangles subjectively placed within an area of homogeneous forest; (2) circular plots subjectively placed within an area of homogeneous forest; and (3) circular plots systematically located on long transects to sample an entire watershed, ridge, or reserve. Rectangular study areas are mostly 1.0 ha or 0.4 ha (1.0 ac) in size (slope-corrected). Circular plots are 0.1 ha (0.247 ac), not corrected for slope. The tree stratum is the focus of work in closed-forest study areas. All trees larger than a minimum diameter (5 cm for most areas) are permanently tagged. Plots are censused every 5 or 6 years. Attributes measured or assessed at each census include tree diameter, tree vigor, and the condition of the crown and stem. The same attributes are recorded for trees (ingrowth) that have exceeded the minimum diameter since the previous census. In many plots tree locations are surveyed to provide a plot-specific x-y location. A mortality assessment is done for trees that have died since the previous census. The assessment characterizes rooting, stem, and crown condition, obvious signs of distress or disturbance, and the apparent predisposing and proximate causes of tree death.
Coverage
Temporal coverage: 1910-02-01 to 2023-08-01
Geographic coverage: Primarily the Pacific Northwest (OR, WA); additional plots in other western states (CA, WY, CO).
Spatial coverage:
Bounds: W -123.99604700, E -105.85785000, N 47.99100000, S 36.56212100
Purpose
- The study purpose is to examine long-term trends and dynamics of representative forest types in the Pacific Northwest. The study provides baseline information on long-term rates of tree growth and tree regeneration (ingrowth), causes and characteristics of tree mortality, forest productivity and biomass, and spatial patterns (demography) of ingrowth and mortality. Long-term observations are the only direct means to document and understand the slow changes of our forests which are dominated by long-lived trees species (individuals commonly live 400 to 1000 years). Long-term observations can quantify levels and dynamics of natural forest structures to be used as guides in ecosystem management. Long-term observations provide the definitive measure of long-term productivity and, thus, sustainable harvest levels. Long-term observations also provide a basis for monitoring effects of global climatic change as well as other changes.
Project
Title: Long-Term Ecological Research
Personnel
-
Posy Elizabeth Busby - Principal Investigator Assistant Professor OSU Botany & Plant PathologyEmail: busbyp@science.oregonstate.edu, posybusby@gmail.comORCID: 0000-0002-2837-9820
-
Matthew G Betts - Principal Investigator Department of Forest Ecosystems and Society; 201E Richardson Hall; College of Forestry; Oregon State University, Corvallis, OR, 97331Phone: (541) 737-3841Email: matt.betts@oregonstate.eduORCID: 0000-0002-7100-2551
-
Brooke E. Penaluna - Principal Investigator Email: brooke.penaluna@usda.gov, Brooke.Penaluna@oregonstate.eduORCID: 0000-0001-7215-770X
-
Catalina Segura - Principal Investigator Assistant Professor; Department of Forest Engineering, Resources, and Management; Oregon State University, Corvallis, OR, 97331Phone: 541-737-6568Email: catalina.segura@oregonstate.eduORCID: 0000-0002-0924-1172
-
David M. Bell - Principal Investigator Email: david.bell@usda.gov, david.bell@oregonstate.eduORCID: 0000-0002-2673-5836
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: DEB2025755
Awards
-
LTER: Long-Term Ecological Research at the H.J. Andrews Experimental Forest (LTER8) Award Number: DEB2025755Funder: National Science FoundationFunder Identifier: https://ror.org/021nxhr62
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
-
Steven A. Acker
Role: Former InvestigatorUSFS
-
Richard E. Brainerd
Role: Former Investigator
-
C. Ted Dyrness
Role: Former InvestigatorOregon State University;Dept. of Forest Science;321 Richardson Hall, Corvallis, OR, 97331-5752, USAPhone: (541) 750-7325, (541) 928-8897
-
Jerry F. Franklin
Role: CreatorUniversity of Washington;College of Forest Resources;Box 352100, Seattle, WA, 98195-2100, USAPhone: (206) 543-2138Email: jff@u.washington.edu
-
Sarah E. Greene
Role: Former InvestigatorUSDA Forest Service;Pacific Northwest Research Station;3200 SW Jefferson Way, Corvallis, OR, 97331, USAPhone: (541) 750-7360Email: seginor@gmail.com
-
Charles B. Halpern
Role: Other ResearcherSchool of Environmental and Forest Sciences, University of Washington, Box 352100, Seattle, WA, 98195-2100, USAPhone: (206) 543-2789Email: chalpern@u.washington.edu
-
Paul A. Harcombe
Role: Former InvestigatorRice University;Dept. of Ecology and Evolutionary Biology;6100 South Main Street;PO Box 1892, Houston, TX, 77005, USAPhone: (713) 348-4924Email: harcomb@rice.edu
-
Mark E. Harmon
Role: Former InvestigatorOregon State University;Dept. of Forest Science;321 Richardson Hall, Corvallis, OR, 97331-5752, USAPhone: (541) 737-8455, (978) 724-0045 ext 223Email: mark.harmon@oregonstate.edu
-
Julia A. Jones
Role: Other ResearcherOregon State University;Department of Geosciences; Wilkinson Hall 104, Corvallis, OR, 97331-5506, USAPhone: (541) 737-1224Email: Julia.Jones@oregonstate.edu, geojulia@comcast.net
-
Robert J. Pabst
Role: Other Researcher321 Richardson Hall; Oregon State University, Corvallis, OR, 97331, USAPhone: 541-750-7435Email: rob.pabst@oregonstate.edu
-
Robert J. Pabst
Role: Creator321 Richardson Hall; Oregon State University, Corvallis, OR, 97331, USAPhone: 541-750-7435Email: rob.pabst@oregonstate.edu
-
David Carl Shaw
Role: Former InvestigatorForest Science;Oregon State University;321 Richardson Hall, Corvallis, OR, 97331-5752, USAPhone: 541 737 2845Email: dave.shaw@oregonstate.edu
-
Kenneth J. Bible
Role: Former InvestigatorPacific Northwest Research Station (Washington, Oregon); PNW,Corvallis,Ecological Process and FunctionPhone: 509-427-8019Email: kenneth.j.bible@usda.gov
-
Howard Bruner
Role: Former InvestigatorOregon State University;Dept. of Forest Science;321 Richardson Hall, Corvallis, OR, 97331-5752, USAPhone: (541) 737 8520Email: hbrunerh@hotmail.com
-
Suzanne M. Remillard
Role: Other ResearcherOffice: FSL 354;; Forest Science Department;; Oregon State University, Corvallis, OR, 97331, USAPhone: (541) 758-8767Email: suzanne.remillard@oregonstate.edu
-
Suzanne M. Remillard
Role: CreatorOffice: FSL 354;; Forest Science Department;; Oregon State University, Corvallis, OR, 97331, USAPhone: (541) 758-8767Email: suzanne.remillard@oregonstate.edu
-
Thornton T. Munger
Role: Former Investigator
-
Kari B. O'Connell
Role: Former InvestigatorOregon State University Center for Research in Lifelong STEM Learning, Corvallis, OR, 97331, USAPhone: (541) 737-1289Email: kari.oconnell@oregonstate.edu
-
James A. Lutz
Role: Other ResearcherEmail: james.lutz@usu.edu
-
Mark E. Swanson
Role: Former InvestigatorEmail: mark.swanson@oregonstate.edu
-
Janneke HilleRisLambers
Role: Other ResearcherUniversity of Washington, Seattle, WAEmail: jhrl@u.washington.edu
-
Todd M. Wilson
Role: Other ResearcherPNW Research Station;USFS, Corvallis, OR, 97331Email: todd.wilson@usda.gov
-
James A. Freund
Role: Former InvestigatorUniversity of Washington, Seattle, WAEmail: jfreund@u.washington.edu
-
Andrew J. Larson
Role: Other ResearcherDepartment of Forest Management; College of Forestry and Conservation; The University of Montana, Missoula, MT, 59812Email: andrew.larson@cfc.umt.edu
-
David M. Bell
Role: Principal InvestigatorEmail: david.bell@usda.gov, david.bell@oregonstate.edu
-
David M. Bell
Role: CreatorEmail: david.bell@usda.gov, david.bell@oregonstate.edu
-
Matt Powers
Role: Principal InvestigatorEmail: Matthew.Powers@oregonstate.edu
-
Matt Powers
Role: CreatorEmail: Matthew.Powers@oregonstate.edu
-
Andrew Bluhm
Role: Other ResearcherEmail: andrew.bluhm@oregonstate.edu
-
Andrew Bluhm
Role: CreatorEmail: andrew.bluhm@oregonstate.edu
Contact
-
Information Manager
Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331Email: hjaweb@lists.oregonstate.edu
-
Robert J. Pabst
321 Richardson Hall; Oregon State University, Corvallis, OR, 97331, USAPhone: 541-750-7435Email: rob.pabst@oregonstate.edu
-
Suzanne M. Remillard
Office: FSL 354;; Forest Science Department;; Oregon State University, Corvallis, OR, 97331, USAPhone: (541) 758-8767Email: suzanne.remillard@oregonstate.edu
Publisher
-
Andrews Forest LTER Site
Role: PublisherForest Ecosystems and Society Department in Forestry, Oregon State University, 201K Richardson Hall, Corvallis, OR, 97331-5752Phone: (541) 737-8480Email: lterweb@lists.oregonstate.edu
Study Description
A network of more than 130 permanent vegetation plots provides long-term information on patterns and rates of forest succession in most of the major forest zones of the Pacific Northwest. The plot network extends from the coast to the Cascades in western Oregon and Washington and east to ponderosa pine forests in the Oregon Cascades. Most of the permanent plots were established during two intervals: from 1910 to 1948, and from 1970 to 1989. The earlier plots were established by U.S. Forest Service researchers to quantify timber growth in young stands of important commercial species and to help answer other applied forestry questions. The more recent period of plot establishment began under the Coniferous Forest Biome program of the International Biological Program during the 1970s, and continued under the Long-term Ecological Research program. A broader set of objectives motivated plot establishment since 1970, especially quantification of composition, structure, and population and ecosystem dynamics of natural forests. Plots have one of three spatial arrangements: (1) contiguous rectangles subjectively placed within an area of homogeneous forest; (2) circular plots subjectively placed within an area of homogeneous forest; and (3) circular plots systematically located on long transects to sample an entire watershed, ridge, or reserve. Rectangular study areas are mostly 1.0 ha or 0.4 ha (1.0 ac) in size (slope-corrected). Circular plots are 0.1 ha (0.247 ac), not corrected for slope. The tree stratum is the focus of work in closed-forest study areas. All trees larger than a minimum diameter (5 cm for most areas) are permanently tagged. Plots are censused every 5 or 6 years. Attributes measured or assessed at each census include tree diameter, tree vigor, and the condition of the crown and stem. The same attributes are recorded for trees (ingrowth) that have exceeded the minimum diameter since the previous census. In many plots tree locations are surveyed to provide a plot-specific x-y location. A mortality assessment is done for trees that have died since the previous census. The assessment characterizes rooting, stem, and crown condition, obvious signs of distress or disturbance, and the apparent predisposing and proximate causes of tree death. The study purpose is to examine long-term trends and dynamics of representative forest types in the Pacific Northwest. The study provides baseline information on long-term rates of tree growth and tree regeneration (ingrowth), causes and characteristics of tree mortality, forest productivity and biomass, and spatial patterns (demography) of ingrowth and mortality. Long-term observations are the only direct means to document and understand the slow changes of our forests which are dominated by long-lived trees species (individuals commonly live 400 to 1000 years). Long-term observations can quantify levels and dynamics of natural forest structures to be used as guides in ecosystem management. Long-term observations provide the definitive measure of long-term productivity and, thus, sustainable harvest levels. Long-term observations also provide a basis for monitoring effects of global climatic change as well as other changes. Field Methods - TV010
Purpose: The study purpose is to examine long-term trends and dynamics of representative forest types in the Pacific Northwest. The study provides baseline information on long-term rates of tree growth and tree regeneration (ingrowth), causes and characteristics of tree mortality, forest productivity and biomass, and spatial patterns (demography) of ingrowth and mortality. Long-term observations are the only direct means to document and understand the slow changes of our forests which are dominated by long-lived trees species (individuals commonly live 400 to 1000 years). Long-term observations can quantify levels and dynamics of natural forest structures to be used as guides in ecosystem management. Long-term observations provide the definitive measure of long-term productivity and, thus, sustainable harvest levels. Long-term observations also provide a basis for monitoring effects of global climatic change as well as other changes.
Methods
Method Steps
Field Methods - TV010
- The stands are surveyed into 25 X 25 slope corrected subplots marked with permanent stakes. All trees greater than the minimum size (usually 5 cm dbh) are tagged, diametered, vigor coded, and mapped. The mapping is done using a 5 X 5 m grid formed with string as a guide. See attached sheet for details.
Sampling
Study Extent
- Sampling frequency: 1-6 years
Sampling Description
- The sites were selected subjectively to represent modal examples of the major habitat types in the H.J. Andrews area (usually with a mature and old growth example). Some stands (e.g.riparian) were selected for other reasons. The stands are remeasured at 5 to 10 year intervals to provide growth and regeneration information.
Spatial Sampling Units
-
Reference Stand RS01, H.J. Andrews EF, Willamette NF
W -122.25882057, E -122.25694806, N 44.20296850, S 44.20177046Altitude: 559 to 559 meter
-
Reference Stand RS02, H.J. Andrews EF, Willamette NF
W -122.24405016, E -122.24250891, N 44.21869615, S 44.21758772Altitude: 535 to 535 meter
-
Reference Stand RS03, H.J. Andrews EF, Willamette NF
W -122.15980373, E -122.15787403, N 44.25917739, S 44.25819622Altitude: 987 to 987 meter
-
Reference Stand RS04, H.J. Andrews EF, Willamette NF
W -122.13769081, E -122.13682229, N 44.27336726, S 44.27274323Altitude: 1312 to 1312 meter
-
Reference Stand RS05, H.J. Andrews EF, Willamette NF
W -122.20296608, E -122.20296608, N 44.22183496, S 44.22183496Altitude: 908 to 908 meter
-
Reference Stand RS07, H.J. Andrews EF, Willamette NF
W -122.25040993, E -122.24956136, N 44.21428064, S 44.21367034Altitude: 510 to 510 meter
-
Reference Stand RS08, H.J. Andrews EF, Willamette NF
W -122.25695385, E -122.25627083, N 44.20207348, S 44.20158214Altitude: 545 to 545 meter
-
Reference Stand RS12, H.J. Andrews EF, Willamette NF
W -122.12215555, E -122.12127180, N 44.22728027, S 44.22664480Altitude: 991 to 991 meter
-
Reference Stand RS13, Wildcat Mtn RNA, Willamette NF
W -122.12300000, E -122.12300000, N 44.34400000, S 44.34400000
-
Reference Stand RS14, Wildcat Mtn RNA, Willamette NF
W -122.09452900, E -122.09452900, N 44.32745400, S 44.32745400
-
Reference Stand RS15, H.J. Andrews EF, Willamette NF
W -122.23947584, E -122.23947584, N 44.20940908, S 44.20940908Altitude: 735 to 735 meter
-
Reference Stand RS16, H.J. Andrews EF, Willamette NF
W -122.24292582, E -122.24212024, N 44.21264655, S 44.21206714Altitude: 691 to 691 meter
-
Reference Stand RS17, H.J. Andrews EF, Willamette NF
W -122.24119304, E -122.24043055, N 44.22069115, S 44.22014281Altitude: 532 to 532 meter
-
Reference Stand RS18, H.J. Andrews EF, Willamette NF
W -122.15937238, E -122.15864178, N 44.24684301, S 44.24631784Altitude: 1106 to 1106 meter
-
Reference Stand RS20, H.J. Andrews EF, Willamette NF
W -122.25048522, E -122.25048522, N 44.22179408, S 44.22179408Altitude: 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 RS26, H.J. Andrews EF, Willamette NF
W -122.17459934, E -122.17310628, N 44.26819286, S 44.26712000Altitude: 1058 to 1058 meter
-
Reference Stand RS35, Hagan Creek, Willamette NF
W -122.43270000, E -122.43270000, N 44.16920000, S 44.16920000
-
Reference Stand RS38, H.J. Andrews EF, Willamette NF
W -122.22386317, E -122.22126811, N 44.22958414, S 44.22778050Altitude: 559 to 559 meter
-
Reference Stand CH14, Cascade Head EF, Douglas-fir
W -123.91830000, E -123.91830000, N 45.04170000, S 45.04170000Altitude: 139 to 139 meter
-
Reference Stand CH41, Cascade Head EF, Douglas-fir
W -123.92020000, E -123.92020000, N 45.03130000, S 45.03130000Altitude: 120 to 120 meter
-
Reference Stand CH42, Cascade Head EF, Douglas-fir
W -123.92160000, E -123.92160000, N 45.03180000, S 45.03180000Altitude: 119 to 119 meter
-
Reference Stand GP01, Camp Creek, Gifford Pinchot NF
W -121.85991980, E -121.85991980, N 46.45622375, S 46.45622375
-
Reference Stand GP02, Camp Creek, Gifford Pinchot NF
W -121.86219500, E -121.86219500, N 46.45647800, S 46.45647800
-
Reference Stand GP03, Camp Creek, Gifford Pinchot NF
W -121.86141303, E -121.86141303, N 46.45767858, S 46.45767858
-
Reference Stand GP04, Camp Creek, Gifford Pinchot NF
W -121.85734300, E -121.85734300, N 46.45533900, S 46.45533900
-
Reference Stand GP05, Camp Creek, Gifford Pinchot NF
W -121.84305201, E -121.84305201, N 46.44536268, S 46.44536268
-
Reference Stand GP07, Kiona Creek, Gifford Pinchot NF
W -121.97145472, E -121.97145472, N 46.55019331, S 46.55019331
-
Reference Stand GP09, Kiona Creek, Gifford Pinchot NF
W -121.98204233, E -121.98204233, N 46.55183599, S 46.55183599
-
Reference Stand MH01, Still Creek, Mount Hood NF
W -121.90629496, E -121.90629496, N 45.30695949, S 45.30695949Altitude: 592 to 592 meter
-
Reference Stand MH02, Still Creek, Mount Hood NF
W -121.90722288, E -121.90722288, N 45.30713040, S 45.30713040
-
Reference Stand MH03, Still Creek, Mount Hood NF
W -121.90599428, E -121.90599428, N 45.30917196, S 45.30917196
-
Reference Stand MUNA, T. T. Munger RNA, Gifford Pinchot NF
W -121.97039300, E -121.97039300, N 45.82827700, S 45.82827700
-
Reference Stand OL01, Quilcene, WA, Olympic NF
W -122.92226111, E -122.92226111, N 47.79385277, S 47.79385277Altitude: 186 to 186 meter
-
Reference Stand OL02, Quilcene, WA, Olympic NF
W -122.92276388, E -122.92276388, N 47.79351666, S 47.79351666Altitude: 186 to 186 meter
-
Reference Stand OL03, Blyn, WA, Olympic NF
W -123.00581900, E -123.00581900, N 47.99045300, S 47.99045300
-
Reference Stand OL04, Blyn, WA, Olympic NF
W -123.00442123, E -123.00442123, N 47.98912372, S 47.98912372
-
Reference Stand SI04, Deadwood Creek, Siuslaw NF
W -123.71207700, E -123.71207700, N 44.20815400, S 44.20815400
-
Reference Stand SI05, Deadwood Creek, Siuslaw NF
W -123.71207700, E -123.71207700, N 44.20233400, S 44.20233400
-
Reference Stand SI06, Saddle Mtn, Siuslaw NF
W -123.97010100, E -123.97010100, N 44.16262900, S 44.16262900
-
Reference Stand SI07, Saddle Mtn, Siuslaw NF
W -123.96997000, E -123.96997000, N 44.16310200, S 44.16310200
-
Reference Stand SI08, Saddle Mtn, Siuslaw NF
W -123.96984000, E -123.96984000, N 44.16366000, S 44.16366000
-
Reference Stand SI09, Five Rivers, Siuslaw NF
W -123.77800000, E -123.77800000, N 44.25300000, S 44.25300000
-
Reference Stand SI10, Five Rivers, Siuslaw NF
W -123.77300000, E -123.77300000, N 44.25200000, S 44.25200000
-
Reference Stand SN01, Skate Creek, Snoqualmie NF
W -121.80328000, E -121.80328000, N 46.69604700, S 46.69604700
-
Reference Stand SN02, Skate Creek, Snoqualmie NF
W -121.80227100, E -121.80227100, N 46.69669200, S 46.69669200
-
Reference Stand WI01, Lowell RD, Willamette NF, stand 1
W -122.61918283, E -122.61918283, N 43.81934359, S 43.81934359
-
Reference Stand WI02, Lowell RD, Willamette NF, stand 2
W -122.62248185, E -122.62248185, N 43.81679745, S 43.81679745
-
Reference Stand WI03, Lowell RD, Willamette NF, stand 3
W -122.62015660, E -122.62015660, N 43.82070644, S 43.82070644
-
Reference Stand WI05, Salmon Creek, Willamette NF
W -121.87019637, E -121.87019637, N 45.84019625, S 45.84019625
-
Reference Stand WR02, Wind River EF, Gifford Pinchot NF
W -121.90628000, E -121.90628000, N 45.87738000, S 45.87738000
-
Reference Stand WR04, Panther Cr, Wind River EF, GPinchot NF
W -121.86768530, E -121.86768530, N 45.82630903, S 45.82630903Altitude: 338 to 338 meter
-
Reference Stand WR05, Panther Cr, Wind River EF, GPinchot NF
W -121.87017944, E -121.87017944, N 45.84017138, S 45.84017138Altitude: 367 to 367 meter
-
Reference Stand WR09, Wind River EF, Gifford Pinchot NF
W -121.90429900, E -121.90429900, N 45.87738000, S 45.87738000
-
Reference Stand WR90, Panther Cr, Wind River EF, GPinchot NF
W -121.86908101, E -121.86908101, N 45.82630305, S 45.82630305Altitude: 317 to 317 meter
-
Reference Stand CH01, Cascade Head EF, hemlock-spruce
W -123.89730000, E -123.89730000, N 45.04560000, S 45.04560000Altitude: 298 to 298 meter
-
Reference Stand CH03, Cascade Head EF, hemlock-spruce
W -123.90400156, E -123.90400156, N 45.04565431, S 45.04565431Altitude: 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.06531912Altitude: 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.06460149Altitude: 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.06310277Altitude: 279 to 279 meter
-
Reference Stand CH12, Cascade Head EF, hemlock-spruce
W -123.90120006, E -123.90120006, N 45.04999731, S 45.04999731Altitude: 243 to 243 meter
-
Reference Stand CH13, Cascade Head EF, hemlock-spruce
W -123.90175355, E -123.90175355, N 45.05128019, S 45.05128019Altitude: 247 to 247 meter
-
Reference Stand HR01, South Fork Hoh River, Olympic NP
W -123.91819273, E -123.91819273, N 47.78499903, S 47.78499903Altitude: 245 to 245 meter
-
Reference Stand HR02, South Fork Hoh River, Olympic NP
W -123.91819273, E -123.91819273, N 47.78499903, S 47.78499903Altitude: 245 to 245 meter
-
Reference Stand HR03, South Fork Hoh River, Olympic NP
W -123.90572570, E -123.90572570, N 47.78051829, S 47.78051829Altitude: 250 to 250 meter
-
Reference Stand HR04, South Fork Hoh River, Olympic NP
W -123.90572570, E -123.90572570, N 47.78051829, S 47.78051829Altitude: 250 to 250 meter
-
Reference Stand HS01, Neskowin Crest RNA, Siuslaw NF
W -123.99288100, E -123.99288100, N 45.08145600, S 45.08145600
-
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 HS04, Twin Creek RNA, Olympic NP
W -123.98154038, E -123.98154038, N 47.83556885, S 47.83556885
-
Reference Stand NCNA, Neskowin Crest RNA, Siuslaw NF
W -123.97810000, E -123.97810000, N 45.07760000, S 45.07760000Altitude: 278 to 278 meter
-
Reference Watershed HGBK, Hagan RNA, Willamette NF
W -122.41884666, E -122.41884666, N 44.18318777, S 44.18318777Altitude: 653 to 653 meter
-
Reference Watershed WS02, H.J. Andrews EF, Willamette NF
W -122.25594700, E -122.23466500, N 44.21823402, S 44.20645849Altitude: 1003 to 1003 meter
-
Reference Stand SP06, Santiam Pass, Willamette NF
W -121.85207267, E -121.85207267, N 44.42195227, S 44.42195227
-
Reference Stand TCTR, Torrey-Charlton RNA, Willamette NF
W -121.98988694, E -121.98988694, N 43.76596138, S 43.76596138Altitude: 1726 to 1726 meter
-
Reference Stand CFMF, Cedar Flats Research Natural Area
W -122.00632100, E -122.00632100, N 46.10399900, S 46.10399900
-
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.27505533Altitude: 1358 to 1358 meter
-
Reference Stand GMNF, Goat Marsh RNA, Gifford Pinchot NF
W -122.27548379, E -122.27548379, N 46.17465620, S 46.17465620Altitude: 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 SRNA, Steamboat Mtn RNA, Gifford Pinchot NF
W -121.74166400, E -121.74166400, N 46.13538422, S 46.13538422Altitude: 1350 to 1350 meter
-
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 BRNA, Bagby RNA, Mount Hood NF
W -122.17277300, E -122.17277300, N 44.94224300, S 44.94224300
-
Reference Stand RS10, H.J. Andrews EF, Willamette NF
W -122.21915148, E -122.21828692, N 44.23366010, S 44.23303850Altitude: 626 to 626 meter
-
Reference Stand RS21, H.J. Andrews EF, Willamette NF
W -122.13638469, E -122.13472670, N 44.25053878, S 44.24934705Altitude: 1218 to 1218 meter
-
Reference Stand RS22, H.J. Andrews EF, Willamette NF
W -122.14190600, E -122.14016423, N 44.27489050, S 44.27363908Altitude: 1307 to 1307 meter
-
Reference Stand RS23, H.J. Andrews EF, Willamette NF
W -122.12585145, E -122.12401831, N 44.22726463, S 44.22599520Altitude: 1023 to 1023 meter
-
Reference Stand RS25, Middle Santiam RNA, Willamette NF
W -122.25683100, E -122.25683100, N 44.51405500, S 44.51405500
-
Reference Stand RS27, H.J. Andrews EF, Willamette NF
W -122.17802149, E -122.17624662, N 44.25443528, S 44.25316474Altitude: 808 to 808 meter
-
Reference Stand RS28, H.J. Andrews EF, Willamette NF
W -122.16954395, E -122.16819882, N 44.24323888, S 44.24227191Altitude: 1083 to 1083 meter
-
Reference Stand RS29, H.J. Andrews EF, Willamette NF
W -122.15384910, E -122.15215947, N 44.23259697, S 44.23138213Altitude: 860 to 860 meter
-
Reference Stand RS30, H.J. Andrews EF, Willamette NF
W -122.14993666, E -122.14821556, N 44.23124990, S 44.23001240Altitude: 909 to 909 meter
-
Reference Stand RS31, H.J. Andrews EF, Willamette NF
W -122.18451674, E -122.18313160, N 44.26140908, S 44.26041366Altitude: 908 to 908 meter
-
Reference Stand RS32, H.J. Andrews EF, Willamette NF
W -122.19098031, E -122.19098031, N 44.23572829, S 44.23572829Altitude: 660 to 660 meter
-
Reference Stand RS33, H.J. Andrews EF, Willamette NF
W -122.16074778, E -122.16074778, N 44.24835204, S 44.24835204Altitude: 1115 to 1115 meter
-
Reference Stand RS34, H.J. Andrews EF, Willamette NF
W -122.16675812, E -122.16675812, N 44.21786432, S 44.21786432Altitude: 779 to 779 meter
-
Reference Stand RS36, Wildcat Mtn RNA, Willamette NF
W -122.09045600, E -122.09045600, N 44.33132800, S 44.33132800
-
Reference Stand RS37, South Fork Hagan Creek, Willamette NF
W -122.42557977, E -122.42557977, N 44.16533518, S 44.16533518
-
Reference Stand ARNA, Ashland Research Natural Area
W -122.70614500, E -122.70614500, N 42.15192400, S 42.15192400
-
Reference Stand MRNA, Metolius RNA, Deschutes NF
W -121.63325593, E -121.63325593, N 44.49076908, S 44.49076908
-
Reference Stand PF28, Pringle Falls RNA, Deschutes NF
W -121.60590486, E -121.60590486, N 43.70822744, S 43.70822744
-
Reference Stand PF29, Pringle Falls RNA, Deschutes NF
W -121.61548044, E -121.61548044, N 43.70581376, S 43.70581376
-
Reference Stand FRA3, Fraser EF, CO, lodgepole pine
W -105.86428500, E -105.86428500, N 39.90670600, S 39.90670600
-
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 FRD2, Fraser EF, CO, lodgepole pine
W -105.86309300, E -105.86309300, N 39.89788500, S 39.89788500
-
Reference Stand FA3I, Fraser EF, CO, lodgepole pine
W -105.86551330, E -105.86369000, N 39.90812400, S 39.90633400
-
Reference Stand FB2I, Fraser EF, CO, lodgepole pine
W -105.86980800, E -105.86859800, N 39.90831000, S 39.90479600
-
Reference Stand FC3I, Fraser EF, CO, lodgepole pine
W -105.85950100, E -105.85785000, N 39.90510500, S 39.89785600
-
Reference Stand FD1I, Fraser EF, CO, spruce-fir
W -105.86453300, E -105.86289700, N 39.99895000, S 39.89736500
-
Reference Stand FD2I, Fraser EF, CO, lodgepole pine
W -105.86444400, E -105.86220900, N 39.89878600, S 39.89711400
-
Reference Stand FRB2, Fraser EF, CO, lodgepole pine
W -105.86863100, E -105.86863100, N 39.90668800, S 39.90668800
-
Reference Stand PF27, Pringle Falls RNA, Deschutes NF
W -121.61135773, E -121.61135773, N 43.70697926, S 43.70697926
-
Reference Stand MUN2, T. T. Munger RNA, Gifford Pinchot NF
W -121.97035400, E -121.97035400, N 45.82851500, S 45.82851500
-
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.76763350Altitude: 1428 to 1428 meter
-
Reference Stand AG05, Nisqually River, Mt. Rainier NP
W -121.80521225, E -121.80521225, N 46.74764989, S 46.74764989Altitude: 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.77574944Altitude: 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.77602294Altitude: 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.74979152Altitude: 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 RS39, H.J. Andrews EF, Willamette NF
W -122.16961390, E -122.16961390, N 44.29078050, S 44.29078050Altitude: 2740 to 2740 meter
-
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
-
Reference Stand CH17, Cascade Head EF, alder-conifer
W -123.91009245, E -123.91009245, N 45.04114413, S 45.04114413
-
Reference Stand CH22, Cascade Head EF, alder-conifer
W -123.91119331, E -123.91119331, N 45.04147830, S 45.04147830
-
Reference Stand CH23, Cascade Head EF, alder-conifer
W -123.91128765, E -123.91128765, N 45.04112293, S 45.04112293
-
Reference Stand RS06, H.J. Andrews EF, Willamette NF
W -122.25780000, E -122.25780000, N 44.21950000, S 44.21950000Altitude: 644 to 644 meter
-
Reference Stand RS09, H.J. Andrews EF, Willamette NF
W -122.26083000, E -122.26083000, N 44.21690000, S 44.21690000Altitude: 472 to 472 meter
-
Reference Stand RS11, H.J. Andrews EF, Willamette NF
W -122.17770800, E -122.17770800, N 44.26556300, S 44.26556300
-
Alder-conifer study at Cascade Head Experimental Forest
W -123.91075500, E -123.91075500, N 45.04053500, S 45.04053500Altitude: 183 to 183 meter
-
Douglas-fir Growth And Yield Study
W -123.96900000, E -121.80100000, N 47.99100000, S 43.74800000Altitude: 762 to 762 meter
-
Hemlock-spruce Growth And Yield Study
W -123.99500000, E -123.87300000, N 47.83400000, S 45.04400000Altitude: 402 to 402 meter
-
H. J. Andrews WS 2 and Hagan Block: LTER Study transects
W -122.42000000, E -122.24300000, N 44.21200000, S 44.17900000Altitude: 700 to 700 meter
-
Mountain Hemlock Growth and Yield Study
W -121.98200000, E -121.84900000, N 44.42300000, S 43.76400000Altitude: 1659 to 1659 meter
-
Mt. St. Helens Volcanic study area
W -122.00500000, E -122.00500000, N 46.10400000, S 46.10400000Altitude: 363 to 363 meter
-
Mt Rainier Reference Stands
W -121.88700000, E -121.53800000, N 46.99500000, S 46.74100000Altitude: 1610 to 1610 meter
-
Noble Fir Growth and Yield Study
W -123.55700000, E -121.56100000, N 46.92400000, S 44.27800000Altitude: 3100 to 3100 meter
-
Andrews Forest and vicinity Reference Stands
W -122.25882600, E -122.11525700, N 44.27566300, S 44.20057900Altitude: 1305 to 1305 meter
-
Ponderosa Pine Growth and Yield Study
W -122.70500000, E -121.60300000, N 44.48800000, S 42.15200000Altitude: 1400 to 1400 meter
-
Sequoia National Park Reference Stands
W -118.80000000, E -118.73000000, N 36.60000000, S 36.57000000Altitude: 2440 to 2440 meter
-
High Elevation Reference Stand HE04, H.J. Andrews EF
W -122.14113880, E -122.14113880, N 44.24983033, S 44.24983033Altitude: 1183 to 1183 meter
-
High Elevation Reference Stand HE05, H.J. Andrews EF
W -122.14010184, E -122.14010184, N 44.22302714, S 44.22302714Altitude: 1303 to 1303 meter
-
High Elevation Reference Stand HE06, H.J. Andrews EF
W -122.17219547, E -122.17219547, N 44.20819707, S 44.20819707Altitude: 1355 to 1355 meter
-
High Elevation Reference Stand HE07, H.J. Andrews EF
W -122.12884360, E -122.12884360, N 44.24387786, S 44.24387786Altitude: 1467 to 1467 meter
-
High Elevation Reference Stand HE08, H.J. Andrews EF
W -122.13136477, E -122.13136477, N 44.21584125, S 44.21584125Altitude: 1602 to 1602 meter
-
High Elevation Reference Stand HE13, H.J. Andrews EF
W -122.11565234, E -122.11565234, N 44.20954328, S 44.20954328Altitude: 1202 to 1202 meter
-
High Elevation Reference Stand HE17, H.J. Andrews EF
W -122.11048183, E -122.11048183, N 44.20541102, S 44.20541102Altitude: 1306 to 1306 meter
-
High Elevation Reference Stand HE18, H.J. Andrews EF
W -122.11908791, E -122.11908791, N 44.23825038, S 44.23825038Altitude: 1295 to 1295 meter
-
High Elevation Reference Stand, H.J. Andrews EF
W -122.11048183, E -122.17219547, N 44.24983033, S 44.20541102Altitude: 1602 to 1602 meter
Software
No software entries listed in this EML file.
Keywords
- LTER controlled vocabulary: stand structure (theme), forest dynamics (theme), measurements (theme), productivity (theme), biomass (theme), plant properties (theme), wind (theme), community composition (theme), plant species composition (theme), spatial properties (theme), long term (theme), permanent plots (theme), succession (theme), primary production (theme), plant growth (theme), mortality (theme), regeneration (theme), disease (theme), disturbance (theme), woody debris (theme), organic matter (theme), ecosystems (theme), forests (theme), old growth forests (theme), trees (theme)
- Andrews Experimental Forest site thesaurus: Long-Term Ecological Research (LTER) (theme), windthrow (theme)
- LTER core research areas: primary production (theme), disturbance (theme), organic matter (theme)
Taxonomic Hierarchy
- All Organisms: All Organisms
- Highest common category (ca. kingdom): Plantae
- Division or Phylum: Coniferophyta
- Class: Pinopsida
- Order: Pinales
- Family: Taxodiaceae
- Genus: Sequoiadendron
- Species: Sequoiadendron giganteum
- Family: Cupressaceae
- Genus: Thuja
- Species: Thuja plicata
- Genus: Calocedrus
- Species: Calocedrus decurrens
- Genus: Chamaecyparis
- Species: Chamaecyparis nootkatensis
- Family: Pinaceae
- 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: Larix
- Species: Larix occidentalis
- Genus: Pseudotsuga
- Species: Pseudotsuga menziesii
- Genus: Tsuga
- Species: Tsuga mertensiana
- Species: Tsuga heterophylla
- Order: Taxales
- Family: Taxaceae
- Genus: Taxus
- Species: Taxus brevifolia
- Division or Phylum: Magnoliophyta
- Class: Magnoliopsida
- Subclass: Rosidae
- Order: Rhamnales
- Family: Rhamnaceae
- Genus: Rhamnus
- Species: Rhamnus purshiana
- Order: Cornales
- Family: Cornaceae
- Genus: Cornus
- Species: Cornus nuttallii
- Order: Sapindales
- Family: Aceraceae
- Genus: Acer
- Species: Acer macrophyllum
- Species: Acer circinatum
- Order: Rosales
- Family: Rosaceae
- Genus: Prunus
- Species: Prunus emarginata
- Subclass: Hamamelididae
- Order: Fagales
- Family: Fagaceae
- Genus: Quercus
- Species: Quercus garryana
- Species: Quercus kelloggii
- Genus: Chrysolepis
- Species: Castanopsis chrysophylla
- Family: Betulaceae
- Genus: Alnus
- Species: Alnus sinuata
- Species: Alnus rubra
- Subclass: Dilleniidae
- Order: Ericales
- Family: Ericaceae
- Genus: Arbutus
- Species: Arbutus menziesii
- Order: Salicales
- Family: Salicaceae
- Genus: Populus
- Species: Populus trichocarpa
- Species: Populus balsamifera ssp. trichocarpa
Data Entities
| # | Entity | Metadata | Data |
|---|---|---|---|
| 1 |
TV01001
Initial tree conditions with spatial coordinates Data into this table was discontinued in 2010. Master treeid data and spatial coordinates are stored in TP001. |
METADATA | DATA |
| 2 |
TV01002
Individual tree remeasurement Table containing periodic remeasurement data of individual trees within reference stands |
METADATA | DATA |
| 3 |
TV01003
Individual tree mortality Table recording individual tree mortality year and contributing conditions and causes of mortality |
METADATA | DATA |
| 4 |
TV01004
Tree heights Height data of selected trees. Last collected in 2004. |
METADATA | DATA |
Metadata
TV01001 - Initial tree conditions with spatial coordinates
Object name: TV01001_v2.csv
Records: 51491
Attributes: 23
Temporal coverage: 1910-10-01 to 2010-04-01
File size: 4309361 byte
Checksum (MD5): c0dc85384cc261e0b588505c220801cd
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TV01001.TREEID
-
notNullConstraint: NOTNULL TV01001.BOLE1, TV01001.BOLE2, TV01001.BOLE3, TV01001.CROWN1, TV01001.CROWN2, TV01001.CROWN3, TV01001.DBCODE, TV01001.DISTURB1, TV01001.DISTURB2, TV01001.ENTITY, TV01001.PLOTNUMBER, TV01001.QUARTER, TV01001.ROOT, TV01001.SPECIES, TV01001.STANDID, TV01001.PSP_STUDYID, TV01001.TAG, TV01001.YEAR, TV01001.TREEID
Attributes (23)
DBCODE - char(5) (nominal)
ID: TV01001.DBCODE
FSDB Database code
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
TV010
FSDB Data set code TV010
ENTITY - numeric(2,0) (ratio)
ID: TV01001.ENTITY
Entity number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=whole, min=1.0000 (exclusive=false), max=1.0000 (exclusive=false)
TREEID - char(13) (nominal)
ID: TV01001.TREEID
Tree identification code represented as STANDID+PLOTID+00000, where 00000 represents a unique tree number for that stand and plot
Type system: Microsoft SQL Server 2019
PSP_STUDYID - char(4) (nominal)
ID: TV01001.PSP_STUDYID
Permanent Study Plots (PSP) study identification code - a mutually exclusive grouping of study forest stands
Type system: Microsoft SQL Server 2019
Code definitions (13)
-
ALCO
Alder-conifer study at Cascade Head Experimental Forest
-
DFGY
Douglas-fir Growth And Yield Study
-
HSGY
Hemlock-spruce Growth And Yield Study
-
MHGY
Mountain Hemlock Growth and Yield Study
-
MSHV
Mt. St. Helens Volcanic study area
-
MRRS
Mt Rainier Reference Stands
-
NFGY
Noble Fir Growth and Yield Study
-
HJRS
Andrews Forest and vicinity Reference Stands
-
PPGY
Ponderosa Pine Growth and Yield Study
-
RMRS
Rocky Mountain Reference Stands
-
SQNP
Sequoia National Park Reference Stands
-
HJWS
Andrews Forest and vicinity Watershed Reference Stands
-
HJHE
High Elevation Reference Stand, H.J. Andrews EF
STANDID - char(4) (nominal)
ID: TV01001.STANDID
Study forest stand or watershed identification code
Type system: Microsoft SQL Server 2019
Code definitions (170)
-
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
-
RS04
Reference Stand RS04, H.J. Andrews EF, Willamette NF
-
RS05
Reference Stand RS05, H.J. Andrews EF, Willamette NF
-
RS07
Reference Stand RS07, H.J. Andrews EF, Willamette NF
-
RS08
Reference Stand RS08, H.J. Andrews EF, Willamette NF
-
RS12
Reference Stand RS12, H.J. Andrews EF, Willamette NF
-
RS13
Reference Stand RS13, Wildcat Mtn RNA, Willamette NF
-
RS14
Reference Stand RS14, Wildcat Mtn RNA, Willamette NF
-
RS15
Reference Stand RS15, H.J. Andrews EF, Willamette NF
-
RS16
Reference Stand RS16, H.J. Andrews EF, Willamette NF
-
RS17
Reference Stand RS17, H.J. Andrews EF, Willamette NF
-
RS18
Reference Stand RS18, 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
-
RS26
Reference Stand RS26, H.J. Andrews EF, Willamette NF
-
RS35
Reference Stand RS35, Hagan Creek, Willamette NF
-
RS38
Reference Stand RS38, H.J. Andrews EF, Willamette NF
-
CH14
Reference Stand CH14, Cascade Head EF, Douglas-fir
-
CH41
Reference Stand CH41, Cascade Head EF, Douglas-fir
-
CH42
Reference Stand CH42, Cascade Head EF, Douglas-fir
-
GP01
Reference Stand GP01, Camp Creek, Gifford Pinchot NF
-
GP02
Reference Stand GP02, Camp Creek, Gifford Pinchot NF
-
GP03
Reference Stand GP03, Camp Creek, Gifford Pinchot NF
-
GP04
Reference Stand GP04, Camp Creek, Gifford Pinchot NF
-
GP05
Reference Stand GP05, Camp Creek, Gifford Pinchot NF
-
GP07
Reference Stand GP07, Kiona Creek, Gifford Pinchot NF
-
GP09
Reference Stand GP09, Kiona Creek, Gifford Pinchot NF
-
MH01
Reference Stand MH01, Still Creek, Mount Hood NF
-
MH02
Reference Stand MH02, Still Creek, Mount Hood NF
-
MH03
Reference Stand MH03, Still Creek, Mount Hood NF
-
MUNA
Reference Stand MUNA, T. T. Munger RNA, Gifford Pinchot NF
-
OL01
Reference Stand OL01, Quilcene, WA, Olympic NF
-
OL02
Reference Stand OL02, Quilcene, WA, Olympic NF
-
OL03
Reference Stand OL03, Blyn, WA, Olympic NF
-
OL04
Reference Stand OL04, Blyn, WA, Olympic NF
-
SI04
Reference Stand SI04, Deadwood Creek, Siuslaw NF
-
SI05
Reference Stand SI05, Deadwood Creek, Siuslaw NF
-
SI06
Reference Stand SI06, Saddle Mtn, Siuslaw NF
-
SI07
Reference Stand SI07, Saddle Mtn, Siuslaw NF
-
SI08
Reference Stand SI08, Saddle Mtn, Siuslaw NF
-
SI09
Reference Stand SI09, Five Rivers, Siuslaw NF
-
SI10
Reference Stand SI10, Five Rivers, Siuslaw NF
-
SI20
Reference Stand SI20, Cook sale check plot, Siuslaw NF
-
SN01
Reference Stand SN01, Skate Creek, Snoqualmie NF
-
SN02
Reference Stand SN02, Skate Creek, Snoqualmie NF
-
WI01
Reference Stand WI01, Lowell RD, Willamette NF, stand 1
-
WI02
Reference Stand WI02, Lowell RD, Willamette NF, stand 2
-
WI03
Reference Stand WI03, Lowell RD, Willamette NF, stand 3
-
WI05
Reference Stand WI05, Salmon Creek, Willamette NF
-
WR02
Reference Stand WR02, Wind River EF, Gifford Pinchot NF
-
WR04
Reference Stand WR04, Panther Cr, Wind River EF, GPinchot NF
-
WR05
Reference Stand WR05, Panther Cr, Wind River EF, GPinchot NF
-
WR09
Reference Stand WR09, Wind River EF, Gifford Pinchot NF
-
WR90
Reference Stand WR90, Panther Cr, Wind River EF, GPinchot NF
-
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
-
HS01
Reference Stand HS01, Neskowin Crest RNA, Siuslaw NF
-
HS02
Reference Stand HS02, Quinault RNA, Olympic NP
-
HS03
Reference Stand HS03, Quinault RNA, Olympic NP
-
HS04
Reference Stand HS04, Twin Creek RNA, Olympic NP
-
NCNA
Reference Stand NCNA, Neskowin Crest RNA, Siuslaw NF
-
HGBK
Reference Watershed HGBK, Hagan RNA, Willamette NF
-
WS02
Reference Watershed WS02, H.J. Andrews EF, Willamette NF
-
SP06
Reference Stand SP06, Santiam Pass, Willamette NF
-
TCTR
Reference Stand TCTR, Torrey-Charlton RNA, Willamette NF
-
CFMF
Reference Stand CFMF, Cedar Flats Research Natural Area
-
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
-
SRNA
Reference Stand SRNA, Steamboat Mtn RNA, Gifford Pinchot 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
-
BRNA
Reference Stand BRNA, Bagby RNA, Mount Hood NF
-
RS10
Reference Stand RS10, H.J. Andrews EF, Willamette NF
-
RS21
Reference Stand RS21, H.J. Andrews EF, Willamette NF
-
RS22
Reference Stand RS22, H.J. Andrews EF, Willamette NF
-
RS23
Reference Stand RS23, H.J. Andrews EF, Willamette NF
-
RS25
Reference Stand RS25, Middle Santiam RNA, Willamette NF
-
RS27
Reference Stand RS27, H.J. Andrews EF, Willamette NF
-
RS28
Reference Stand RS28, H.J. Andrews EF, Willamette NF
-
RS29
Reference Stand RS29, H.J. Andrews EF, Willamette NF
-
RS30
Reference Stand RS30, H.J. Andrews EF, Willamette NF
-
RS31
Reference Stand RS31, H.J. Andrews EF, Willamette NF
-
RS32
Reference Stand RS32, H.J. Andrews EF, Willamette NF
-
RS33
Reference Stand RS33, H.J. Andrews EF, Willamette NF
-
RS34
Reference Stand RS34, H.J. Andrews EF, Willamette NF
-
RS36
Reference Stand RS36, Wildcat Mtn RNA, Willamette NF
-
RS37
Reference Stand RS37, South Fork Hagan Creek, Willamette NF
-
ARNA
Reference Stand ARNA, Ashland Research Natural Area
-
MRNA
Reference Stand MRNA, Metolius RNA, Deschutes NF
-
PF28
Reference Stand PF28, Pringle Falls RNA, Deschutes NF
-
PF29
Reference Stand PF29, Pringle Falls RNA, Deschutes NF
-
FRA3
Reference Stand FRA3, Fraser EF, CO, lodgepole pine
-
FRC3
Reference Stand FRC3, Fraser EF, CO, lodgepole pine
-
FRD1
Reference Stand FRD1, Fraser EF, CO, spruce-fir
-
FRD2
Reference Stand FRD2, Fraser EF, CO, lodgepole pine
-
FRB2
Reference Stand FRB2, Fraser EF, CO, lodgepole pine
-
PF27
Reference Stand PF27, Pringle Falls RNA, Deschutes NF
-
MUN2
Reference Stand MUN2, T. T. Munger RNA, Gifford Pinchot NF
-
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
-
RS39
Reference Stand RS39, H.J. Andrews EF, Willamette NF
-
CH11
Reference Stand CH11, Cascade Head EF, hemlock-spruce
-
CH15
Reference Stand CH15, Cascade Head EF, alder-conifer
-
CH17
Reference Stand CH17, Cascade Head EF, alder-conifer
-
CH22
Reference Stand CH22, Cascade Head EF, alder-conifer
-
CH23
Reference Stand CH23, Cascade Head EF, alder-conifer
-
RS06
Reference Stand RS06, H.J. Andrews EF, Willamette NF
-
RS09
Reference Stand RS09, H.J. Andrews EF, Willamette NF
-
RS11
Reference Stand RS11, H.J. Andrews EF, Willamette NF
-
CLMA
Reference Stand CLMA, Chambers Lk, GPinchot NF, MSH ashfall
-
EPMA
Reference Stand EPMA, Elk Pass, GPinchot NF, MSH ashfall
-
CRMA
Reference Stand CRMA, N. Fork Cispus R, GP NF, MSH ashfall
-
WS06
Reference Watershed WS06, H.J. Andrews EF, Willamette NF
-
WS07
Reference Watershed WS07, H.J. Andrews EF, Willamette NF
-
WS08
Reference Watershed WS08, H.J. Andrews EF, Willamette NF
-
WS09
Reference Watershed WS09, H.J. Andrews EF, Willamette NF
-
RS40
Reference Stand RS41, H.J. Andrews EF, Willamette NF
-
HE04
High Elevation Reference Stand HE04, H.J. Andrews EF
-
HE05
High Elevation Reference Stand HE05, H.J. Andrews EF
-
HE06
High Elevation Reference Stand HE06, H.J. Andrews EF
-
HE07
High Elevation Reference Stand HE07, H.J. Andrews EF
-
HE08
High Elevation Reference Stand HE08, H.J. Andrews EF
-
HE13
High Elevation Reference Stand HE13, H.J. Andrews EF
-
HE17
High Elevation Reference Stand HE17, H.J. Andrews EF
-
HE18
High Elevation Reference Stand HE18, H.J. Andrews EF
PLOTNUMBER - numeric(4,0) (interval)
ID: TV01001.PLOTNUMBER
Plot number within STANDID
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1
Numeric domain: type=natural, min=0.0000 (exclusive=false), max=9999.0000 (exclusive=false)
QUARTER - char(1) (ordinal)
ID: TV01001.QUARTER
Quarter subplot number for circular plots - zero is assigned when quarter is not used or not applicable
Type system: Microsoft SQL Server 2019
Code definitions (5)
-
code
No quarter subplot number assigned
-
1
Quarter subplot number 1
-
2
Quarter subplot number 2
-
3
Quarter subplot number 3
-
4
Quarter subplot number 4
TAG - numeric(7,0) (interval)
ID: TV01001.TAG
Current tree tag number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=99999.0000 (exclusive=false)
SPECIES - char(6) (nominal)
ID: TV01001.SPECIES
Tree species code
Type system: Microsoft SQL Server 2019
Code definitions (39)
-
ABAM
Abies amabilis
-
ABCO
Abies concolor
-
ABGR
Abies grandis
-
ABLA
Abies lasiocarpa
-
ABMA
Abies magnifica
-
ABPR
Abies procera
-
ACGL
Acer glabrum
-
ACMA3
Acer macrophyllum
-
ALIN2
Alnus incana
-
ALRU2
Alnus rubra
-
ALVIS
Alnus viridis ssp. sinuata
-
ARME
Arbutus menziesii
-
CADE3
Calocedrus decurrens
-
CHCH7
Chrysolepis chrysophylla
-
CONU4
Cornus nuttallii
-
FRPU7
Frangula purshiana
-
LAOC
Larix occidentalis
-
MAFU
Malus fusca
-
PIEN
Picea engelmannii
-
PISI
Picea sitchensis
-
PICO
Pinus contorta
-
PIJE
Pinus jeffreyi
-
PILA
Pinus lambertiana
-
PIMO3
Pinus monticola
-
PIPO
Pinus ponderosa
-
POBAT
Populus balsamifera ssp. trichocarpa
-
POTR5
Populus tremuloides
-
PRUNU
Prunus
-
PREM
Prunus emarginata
-
PSME
Pseudotsuga menziesii
-
QUGA4
Quercus garryana
-
QUKE
Quercus kelloggii
-
SASC
Salix scouleriana
-
TABR2
Taxus brevifolia
-
THPL
Thuja plicata
-
TSHE
Tsuga heterophylla
-
TSME
Tsuga mertensiana
-
CANO9
Callitropsis nootkatensis
-
SEGI
Sequoiadendron giganteum
YEAR - numeric(4,0) (interval)
ID: TV01001.YEAR
Year of establishment, remeasurement, or mortality
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1910.0000 (exclusive=false), max=2010.0000 (exclusive=false)
MONTH - numeric(2,0) (interval)
ID: TV01001.MONTH
Month
Type system: Microsoft SQL Server 2019
Unit: month of year
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=12.0000 (exclusive=false)
XCOORD - numeric(6,2) (ratio)
ID: TV01001.XCOORD
X coordinate
Type system: Microsoft SQL Server 2019
Unit: meters
Precision: 0.010000
Numeric domain: type=real, min=-1.7000 (exclusive=false), max=426.1300 (exclusive=false)
YCOORD - numeric(6,2) (ratio)
ID: TV01001.YCOORD
Y coordinate
Type system: Microsoft SQL Server 2019
Unit: meters
Precision: 0.010000
Numeric domain: type=real, min=-49.1700 (exclusive=false), max=995.7000 (exclusive=false)
CROWN1 - char(1) (nominal)
ID: TV01001.CROWN1
Crown conditions
Type system: Microsoft SQL Server 2019
Code definitions (10)
-
U
No crown condition is recorded
-
1
Crown in good condition
-
2
Broken top
-
3
Multiple tops or leaders
-
4
Dead top
-
5
Top condition is unknown
-
6
Half-crowned
-
7
Crook in crown
-
8
Mistletoe
-
9
Flat top
CROWN2 - char(1) (nominal)
ID: TV01001.CROWN2
Crown conditions
Type system: Microsoft SQL Server 2019
Code definitions (10)
-
U
No crown condition is recorded
-
1
Crown in good condition
-
2
Broken top
-
3
Multiple tops or leaders
-
4
Dead top
-
5
Top condition is unknown
-
6
Half-crowned
-
7
Crook in crown
-
8
Mistletoe
-
9
Flat top
CROWN3 - char(1) (nominal)
ID: TV01001.CROWN3
Crown conditions
Type system: Microsoft SQL Server 2019
Code definitions (10)
-
U
No crown condition is recorded
-
1
Crown in good condition
-
2
Broken top
-
3
Multiple tops or leaders
-
4
Dead top
-
5
Top condition is unknown
-
6
Half-crowned
-
7
Crook in crown
-
8
Mistletoe
-
9
Flat top
BOLE1 - char(1) (nominal)
ID: TV01001.BOLE1
Bole conditions
Type system: Microsoft SQL Server 2019
Code definitions (10)
-
U
No bole condition is recorded
-
1
Good straight bole
-
2
Pistol butt
-
3
Butt swell -- listed if abnormal for species
-
4
Forked or multiple butt
-
5
Leaning
-
6
Grouse ladder
-
7
Sweeping
-
8
Crooks in bole
-
9
Conks present
BOLE2 - char(1) (nominal)
ID: TV01001.BOLE2
Bole conditions
Type system: Microsoft SQL Server 2019
Code definitions (10)
-
U
No bole condition is recorded
-
1
Good straight bole
-
2
Pistol butt
-
3
Butt swell -- listed if abnormal for species
-
4
Forked or multiple butt
-
5
Leaning
-
6
Grouse ladder
-
7
Sweeping
-
8
Crooks in bole
-
9
Conks present
BOLE3 - char(1) (nominal)
ID: TV01001.BOLE3
Bole conditions
Type system: Microsoft SQL Server 2019
Code definitions (10)
-
U
No bole condition is recorded
-
1
Good straight bole
-
2
Pistol butt
-
3
Butt swell -- listed if abnormal for species
-
4
Forked or multiple butt
-
5
Leaning
-
6
Grouse ladder
-
7
Sweeping
-
8
Crooks in bole
-
9
Conks present
ROOT - char(1) (nominal)
ID: TV01001.ROOT
Rooting medium
Type system: Microsoft SQL Server 2019
Code definitions (4)
-
U
Rooting medium not recorded
-
1
Trees rooted in mineral medium
-
2
Trees rooted in an organic medium
-
3
Rooting medium examined but unknown
DISTURB1 - char(1) (nominal)
ID: TV01001.DISTURB1
Disturbance conditions
Type system: Microsoft SQL Server 2019
Code definitions (8)
-
U
No disturbance condition noetd
-
1
No scars or other disturbances observed
-
2
Fire scar
-
3
Log fall scar
-
4
Unknown scar
-
5
Animal scar
-
6
Frost crack
-
7
Lightning
DISTURB2 - char(1) (nominal)
ID: TV01001.DISTURB2
Disturbance conditions
Type system: Microsoft SQL Server 2019
Code definitions (8)
-
U
No disturbance condition noetd
-
1
No scars or other disturbances observed
-
2
Fire scar
-
3
Log fall scar
-
4
Unknown scar
-
5
Animal scar
-
6
Frost crack
-
7
Lightning
AGE - numeric(4,0) (ratio)
ID: TV01001.AGE
Tree age at stand establishment
Type system: Microsoft SQL Server 2019
Unit: number of years
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=560.0000 (exclusive=false)
TV01002 - Individual tree remeasurement
Object name: TV01002_v21.csv
Records: 611570
Attributes: 24
Temporal coverage: 1910-02-01 to 2023-08-01
File size: 60871423 byte
Checksum (MD5): 2bda3a67f0fe607e62a4ad3dc0ff3b6b
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TV01002.PLOTNUMBER, TV01002.STANDID, TV01002.PSP_STUDYID, TV01002.TAG, TV01002.YEAR
-
notNullConstraint: NOTNULL TV01002.CANOPY_CLASS, TV01002.DBCODE, TV01002.DBH_CODE, TV01002.ENTITY, TV01002.PLOTNUMBER, TV01002.QUARTER, TV01002.SPECIES, TV01002.STANDID, TV01002.TREE_STATUS, TV01002.PSP_STUDYID, TV01002.TAG, TV01002.TREE_VIGOR, TV01002.YEAR, TV01002.TREEID, TV01002.MAIN_STEM, TV01002.ROOTING, TV01002.SAMPLEDATE
Attributes (24)
DBCODE - char(5) (nominal)
ID: TV01002.DBCODE
FSDB Database code
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
TV010
FSDB Data set code TV010
ENTITY - numeric(2,0) (ratio)
ID: TV01002.ENTITY
Entity number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=whole, min=2.0000 (exclusive=false), max=2.0000 (exclusive=false)
TREEID - char(13) (nominal)
ID: TV01002.TREEID
Tree identification code represented as STANDID+PLOTID+00000, where 00000 represents a unique tree number for that stand and plot
Type system: Microsoft SQL Server 2019
PSP_STUDYID - char(4) (nominal)
ID: TV01002.PSP_STUDYID
Permanent Study Plots (PSP) study identification code - a mutually exclusive grouping of study forest stands
Type system: Microsoft SQL Server 2019
Code definitions (13)
-
ALCO
Alder-conifer study at Cascade Head Experimental Forest
-
DFGY
Douglas-fir Growth And Yield Study
-
HSGY
Hemlock-spruce Growth And Yield Study
-
MHGY
Mountain Hemlock Growth and Yield Study
-
MSHV
Mt. St. Helens Volcanic study area
-
MRRS
Mt Rainier Reference Stands
-
NFGY
Noble Fir Growth and Yield Study
-
HJRS
Andrews Forest and vicinity Reference Stands
-
PPGY
Ponderosa Pine Growth and Yield Study
-
RMRS
Rocky Mountain Reference Stands
-
SQNP
Sequoia National Park Reference Stands
-
HJWS
Andrews Forest and vicinity Watershed Reference Stands
-
HJHE
High Elevation Reference Stand, H.J. Andrews EF
STANDID - char(4) (nominal)
ID: TV01002.STANDID
Study forest stand or watershed identification code
Type system: Microsoft SQL Server 2019
Code definitions (170)
-
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
-
RS04
Reference Stand RS04, H.J. Andrews EF, Willamette NF
-
RS05
Reference Stand RS05, H.J. Andrews EF, Willamette NF
-
RS07
Reference Stand RS07, H.J. Andrews EF, Willamette NF
-
RS08
Reference Stand RS08, H.J. Andrews EF, Willamette NF
-
RS12
Reference Stand RS12, H.J. Andrews EF, Willamette NF
-
RS13
Reference Stand RS13, Wildcat Mtn RNA, Willamette NF
-
RS14
Reference Stand RS14, Wildcat Mtn RNA, Willamette NF
-
RS15
Reference Stand RS15, H.J. Andrews EF, Willamette NF
-
RS16
Reference Stand RS16, H.J. Andrews EF, Willamette NF
-
RS17
Reference Stand RS17, H.J. Andrews EF, Willamette NF
-
RS18
Reference Stand RS18, 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
-
RS26
Reference Stand RS26, H.J. Andrews EF, Willamette NF
-
RS35
Reference Stand RS35, Hagan Creek, Willamette NF
-
RS38
Reference Stand RS38, H.J. Andrews EF, Willamette NF
-
CH14
Reference Stand CH14, Cascade Head EF, Douglas-fir
-
CH41
Reference Stand CH41, Cascade Head EF, Douglas-fir
-
CH42
Reference Stand CH42, Cascade Head EF, Douglas-fir
-
GP01
Reference Stand GP01, Camp Creek, Gifford Pinchot NF
-
GP02
Reference Stand GP02, Camp Creek, Gifford Pinchot NF
-
GP03
Reference Stand GP03, Camp Creek, Gifford Pinchot NF
-
GP04
Reference Stand GP04, Camp Creek, Gifford Pinchot NF
-
GP05
Reference Stand GP05, Camp Creek, Gifford Pinchot NF
-
GP07
Reference Stand GP07, Kiona Creek, Gifford Pinchot NF
-
GP09
Reference Stand GP09, Kiona Creek, Gifford Pinchot NF
-
MH01
Reference Stand MH01, Still Creek, Mount Hood NF
-
MH02
Reference Stand MH02, Still Creek, Mount Hood NF
-
MH03
Reference Stand MH03, Still Creek, Mount Hood NF
-
MUNA
Reference Stand MUNA, T. T. Munger RNA, Gifford Pinchot NF
-
OL01
Reference Stand OL01, Quilcene, WA, Olympic NF
-
OL02
Reference Stand OL02, Quilcene, WA, Olympic NF
-
OL03
Reference Stand OL03, Blyn, WA, Olympic NF
-
OL04
Reference Stand OL04, Blyn, WA, Olympic NF
-
SI04
Reference Stand SI04, Deadwood Creek, Siuslaw NF
-
SI05
Reference Stand SI05, Deadwood Creek, Siuslaw NF
-
SI06
Reference Stand SI06, Saddle Mtn, Siuslaw NF
-
SI07
Reference Stand SI07, Saddle Mtn, Siuslaw NF
-
SI08
Reference Stand SI08, Saddle Mtn, Siuslaw NF
-
SI09
Reference Stand SI09, Five Rivers, Siuslaw NF
-
SI10
Reference Stand SI10, Five Rivers, Siuslaw NF
-
SI20
Reference Stand SI20, Cook sale check plot, Siuslaw NF
-
SN01
Reference Stand SN01, Skate Creek, Snoqualmie NF
-
SN02
Reference Stand SN02, Skate Creek, Snoqualmie NF
-
WI01
Reference Stand WI01, Lowell RD, Willamette NF, stand 1
-
WI02
Reference Stand WI02, Lowell RD, Willamette NF, stand 2
-
WI03
Reference Stand WI03, Lowell RD, Willamette NF, stand 3
-
WI05
Reference Stand WI05, Salmon Creek, Willamette NF
-
WR02
Reference Stand WR02, Wind River EF, Gifford Pinchot NF
-
WR04
Reference Stand WR04, Panther Cr, Wind River EF, GPinchot NF
-
WR05
Reference Stand WR05, Panther Cr, Wind River EF, GPinchot NF
-
WR09
Reference Stand WR09, Wind River EF, Gifford Pinchot NF
-
WR90
Reference Stand WR90, Panther Cr, Wind River EF, GPinchot NF
-
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
-
HS01
Reference Stand HS01, Neskowin Crest RNA, Siuslaw NF
-
HS02
Reference Stand HS02, Quinault RNA, Olympic NP
-
HS03
Reference Stand HS03, Quinault RNA, Olympic NP
-
HS04
Reference Stand HS04, Twin Creek RNA, Olympic NP
-
NCNA
Reference Stand NCNA, Neskowin Crest RNA, Siuslaw NF
-
HGBK
Reference Watershed HGBK, Hagan RNA, Willamette NF
-
WS02
Reference Watershed WS02, H.J. Andrews EF, Willamette NF
-
SP06
Reference Stand SP06, Santiam Pass, Willamette NF
-
TCTR
Reference Stand TCTR, Torrey-Charlton RNA, Willamette NF
-
CFMF
Reference Stand CFMF, Cedar Flats Research Natural Area
-
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
-
SRNA
Reference Stand SRNA, Steamboat Mtn RNA, Gifford Pinchot 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
-
BRNA
Reference Stand BRNA, Bagby RNA, Mount Hood NF
-
RS10
Reference Stand RS10, H.J. Andrews EF, Willamette NF
-
RS21
Reference Stand RS21, H.J. Andrews EF, Willamette NF
-
RS22
Reference Stand RS22, H.J. Andrews EF, Willamette NF
-
RS23
Reference Stand RS23, H.J. Andrews EF, Willamette NF
-
RS25
Reference Stand RS25, Middle Santiam RNA, Willamette NF
-
RS27
Reference Stand RS27, H.J. Andrews EF, Willamette NF
-
RS28
Reference Stand RS28, H.J. Andrews EF, Willamette NF
-
RS29
Reference Stand RS29, H.J. Andrews EF, Willamette NF
-
RS30
Reference Stand RS30, H.J. Andrews EF, Willamette NF
-
RS31
Reference Stand RS31, H.J. Andrews EF, Willamette NF
-
RS32
Reference Stand RS32, H.J. Andrews EF, Willamette NF
-
RS33
Reference Stand RS33, H.J. Andrews EF, Willamette NF
-
RS34
Reference Stand RS34, H.J. Andrews EF, Willamette NF
-
RS36
Reference Stand RS36, Wildcat Mtn RNA, Willamette NF
-
RS37
Reference Stand RS37, South Fork Hagan Creek, Willamette NF
-
ARNA
Reference Stand ARNA, Ashland Research Natural Area
-
MRNA
Reference Stand MRNA, Metolius RNA, Deschutes NF
-
PF28
Reference Stand PF28, Pringle Falls RNA, Deschutes NF
-
PF29
Reference Stand PF29, Pringle Falls RNA, Deschutes NF
-
FRA3
Reference Stand FRA3, Fraser EF, CO, lodgepole pine
-
FRC3
Reference Stand FRC3, Fraser EF, CO, lodgepole pine
-
FRD1
Reference Stand FRD1, Fraser EF, CO, spruce-fir
-
FRD2
Reference Stand FRD2, Fraser EF, CO, lodgepole pine
-
FRB2
Reference Stand FRB2, Fraser EF, CO, lodgepole pine
-
PF27
Reference Stand PF27, Pringle Falls RNA, Deschutes NF
-
MUN2
Reference Stand MUN2, T. T. Munger RNA, Gifford Pinchot NF
-
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
-
RS39
Reference Stand RS39, H.J. Andrews EF, Willamette NF
-
CH11
Reference Stand CH11, Cascade Head EF, hemlock-spruce
-
CH15
Reference Stand CH15, Cascade Head EF, alder-conifer
-
CH17
Reference Stand CH17, Cascade Head EF, alder-conifer
-
CH22
Reference Stand CH22, Cascade Head EF, alder-conifer
-
CH23
Reference Stand CH23, Cascade Head EF, alder-conifer
-
RS06
Reference Stand RS06, H.J. Andrews EF, Willamette NF
-
RS09
Reference Stand RS09, H.J. Andrews EF, Willamette NF
-
RS11
Reference Stand RS11, H.J. Andrews EF, Willamette NF
-
CLMA
Reference Stand CLMA, Chambers Lk, GPinchot NF, MSH ashfall
-
EPMA
Reference Stand EPMA, Elk Pass, GPinchot NF, MSH ashfall
-
CRMA
Reference Stand CRMA, N. Fork Cispus R, GP NF, MSH ashfall
-
WS06
Reference Watershed WS06, H.J. Andrews EF, Willamette NF
-
WS07
Reference Watershed WS07, H.J. Andrews EF, Willamette NF
-
WS08
Reference Watershed WS08, H.J. Andrews EF, Willamette NF
-
WS09
Reference Watershed WS09, H.J. Andrews EF, Willamette NF
-
RS40
Reference Stand RS41, H.J. Andrews EF, Willamette NF
-
HE04
High Elevation Reference Stand HE04, H.J. Andrews EF
-
HE05
High Elevation Reference Stand HE05, H.J. Andrews EF
-
HE06
High Elevation Reference Stand HE06, H.J. Andrews EF
-
HE07
High Elevation Reference Stand HE07, H.J. Andrews EF
-
HE08
High Elevation Reference Stand HE08, H.J. Andrews EF
-
HE13
High Elevation Reference Stand HE13, H.J. Andrews EF
-
HE17
High Elevation Reference Stand HE17, H.J. Andrews EF
-
HE18
High Elevation Reference Stand HE18, H.J. Andrews EF
PLOTNUMBER - numeric(4,0) (interval)
ID: TV01002.PLOTNUMBER
Plot number within STANDID
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1
Numeric domain: type=natural, min=0.0000 (exclusive=false), max=1005.0000 (exclusive=false)
QUARTER - char(1) (ordinal)
ID: TV01002.QUARTER
Quarter subplot number for circular plots - zero is assigned when quarter is not used or not applicable
Type system: Microsoft SQL Server 2019
Code definitions (5)
-
code
No quarter subplot number assigned
-
1
Quarter subplot number 1
-
2
Quarter subplot number 2
-
3
Quarter subplot number 3
-
4
Quarter subplot number 4
SPECIES - char(6) (nominal)
ID: TV01002.SPECIES
Tree species code
Type system: Microsoft SQL Server 2019
Code definitions (39)
-
ABAM
Abies amabilis
-
ABCO
Abies concolor
-
ABGR
Abies grandis
-
ABLA
Abies lasiocarpa
-
ABMA
Abies magnifica
-
ABPR
Abies procera
-
ACGL
Acer glabrum
-
ACMA3
Acer macrophyllum
-
ALIN2
Alnus incana
-
ALRU2
Alnus rubra
-
ALVIS
Alnus viridis ssp. sinuata
-
ARME
Arbutus menziesii
-
CADE3
Calocedrus decurrens
-
CHCH7
Chrysolepis chrysophylla
-
CONU4
Cornus nuttallii
-
FRPU7
Frangula purshiana
-
LAOC
Larix occidentalis
-
MAFU
Malus fusca
-
PIEN
Picea engelmannii
-
PISI
Picea sitchensis
-
PICO
Pinus contorta
-
PIJE
Pinus jeffreyi
-
PILA
Pinus lambertiana
-
PIMO3
Pinus monticola
-
PIPO
Pinus ponderosa
-
POBAT
Populus balsamifera ssp. trichocarpa
-
POTR5
Populus tremuloides
-
PRUNU
Prunus
-
PREM
Prunus emarginata
-
PSME
Pseudotsuga menziesii
-
QUGA4
Quercus garryana
-
QUKE
Quercus kelloggii
-
SASC
Salix scouleriana
-
TABR2
Taxus brevifolia
-
THPL
Thuja plicata
-
TSHE
Tsuga heterophylla
-
TSME
Tsuga mertensiana
-
CANO9
Callitropsis nootkatensis
-
SEGI
Sequoiadendron giganteum
TAG - numeric(7,0) (interval)
ID: TV01002.TAG
Current tree tag number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=9999999.0000 (exclusive=false)
YEAR - numeric(4,0) (interval)
ID: TV01002.YEAR
Year of establishment, remeasurement, or mortality
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1910.0000 (exclusive=false), max=2023.0000 (exclusive=false)
TREE_STATUS - char(1) (nominal)
ID: TV01002.TREE_STATUS
Tree status code
Type system: Microsoft SQL Server 2019
Code definitions (5)
-
1
Living tree
-
2
Ingrowth - typically young and previously unmeasured trees that now satisfy minimum diameter requirements. Ingrowth codes are not used in the year of plot establishment
-
3
Living stem is fused with one or more tree stems at measurement height and measured together as one
-
6
Dead tree - typically is not noted in the year of plot establishment
-
9
Tree is missing or not found; no measurements are possible
DBH - numeric(6,1) (ratio)
ID: TV01002.DBH
Tree diameter at breast height (1.37 m)
Type system: Microsoft SQL Server 2019
Unit: centimeters
Precision: 0.100000
Numeric domain: type=real, min=0.1000 (exclusive=false), max=625.0000 (exclusive=false)
DBH_CODE - char(1) (nominal)
ID: TV01002.DBH_CODE
Describes cases where dbh was estimated using methods defined in the codes
Type system: Microsoft SQL Server 2019
Code definitions (12)
-
1
DBH estimated by linear interpolation or extrapolation
-
2
DBH estimated from growth rates of nearby trees of similar size
-
3
DBH estimated assuming 'no growth' (usually missing, non-vigorous, or damaged trees)
-
4
DBH estimated for individual boles using basal area of joint dbh of grown together (fused) trees
-
8
DBH is measured using a non-standard field procedure or estimated in the field
-
9
DBH estimated, method unknown or unspecified
-
G
Good: normally measured DBH
-
M
Missing: no measurement taken for missing or dead (mortality) trees
-
U
Unknown: DBH is missing for a tree not listed as missing or dead
-
V
Verified: excessive diameter change is acknowledged and accepted as described by comments
-
A
DBH needs adjustment based on comments
-
5
DBH estimated for individual boles using USFS Forest Inventory and Analysis (FIA) method for Independent trees that grow together
CANOPY_CLASS - char(1) (nominal)
ID: TV01002.CANOPY_CLASS
Canopy class code
Type system: Microsoft SQL Server 2019
Code definitions (7)
-
C
Co-dominant: Crown extends to the top of the general canopy layer and receives light from the top but not much from the sides
-
D
Dominant: Crown emerges from the general canopy layer and receives light from the top and the sides
-
E
Emergent: crown extends completely above the canopy of the stand (only used in Stand RS39 in 1992 and HJHE stands)
-
I
Intermediate: Crown extends into the lower portion of the general canopy layer and receives mostly filtered light from the top and the sides
-
S
Suppressed: Crown completely beneath the general canopy layer
-
U
Unknown or not measured
-
O
Open grown: the tree is not taller than other trees in the stand but still receives light from all directions (e.g., a small tree growing in a canopy gap would be considered open grown). Only used in HJHE stands.
TREE_VIGOR - char(1) (nominal)
ID: TV01002.TREE_VIGOR
Overall vigor code
Type system: Microsoft SQL Server 2019
Code definitions (5)
-
1
Good vigor: no apparent signs of distress
-
2
Fair vigor: some signs of distress apparent (e.g., discolored foliage, paucity of leaves or needles, broken stem with few live branches)
-
3
Poor vigor: extreme distress apparent (i.e., death imminent)
-
M
Vigor is not recorded for dead or missing trees
-
U
Unknown vigor of a living tree - vigor is not recorded
CROWN_RATIO - numeric(3,0) (ratio)
ID: TV01002.CROWN_RATIO
Percent of a tree's height with live branches around one third or more of the bole's circumference
Type system: Microsoft SQL Server 2019
Unit: percent
Precision: 1.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)
MAIN_STEM - char(1) (nominal)
ID: TV01002.MAIN_STEM
Main stem condition code (use of this code begins in 2010)
Type system: Microsoft SQL Server 2019
Code definitions (4)
-
1
Main stem intact (not broken)
-
2
Main stem broken at or above the root collar
-
3
Main stem broken below root collar
-
9
Not recorded / missing
ROOTING - char(1) (nominal)
ID: TV01002.ROOTING
Tree rooting condition code (use of this code begins in 2010)
Type system: Microsoft SQL Server 2019
Code definitions (4)
-
1
Fully rooted; root-soil interface intact, stem is freestanding
-
2
Partially uprooted (roots exposed), but stem is still freestanding and self-supporting
-
3
Uprooted and down, stem is not freestanding
-
9
Condition not recorded / missing
CROWN_PCT - numeric(3,0) (ratio)
ID: TV01002.CROWN_PCT
Percent of a tree's live crown volume that is still intact along the stem (does not apply to uprooted trees); record for living trees begins in 2010 (Entity 2) - only recorded when mortality is noted before 2010 (Entity 3).
Type system: Microsoft SQL Server 2019
Unit: percent
Precision: 5.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)
TREE_PCT - numeric(3,0) (ratio)
ID: TV01002.TREE_PCT
Percent of the entire main stem length that is intact (does not apply to uprooted trees); record for living trees begins in 2010 (Entity 2) - only recorded when mortality is noted before 2010 (Entity 3).
Type system: Microsoft SQL Server 2019
Unit: percent
Precision: 5.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)
LEAN_ANGLE - numeric(3,0) (ratio)
ID: TV01002.LEAN_ANGLE
Angle of tree lean in degrees from vertical, where vertical is 0 degrees (not recorded for uprooted trees); record for living trees begins in 2010 (TV010 Entity 2) - only recorded when mortality is noted before 2010 (TV010 Entity 3).
Type system: Microsoft SQL Server 2019
Unit: degrees angle
Precision: 5.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=130.0000 (exclusive=false)
SAMPLEDATE - datetime (dateTime)
ID: TV01002.SAMPLEDATE
Date of remeasurement (day of month was not always tracked; in these cases the 1st of each month is assigned)
Type system: Microsoft SQL Server 2019
Date format: YYYY-MM-DD
CHECK_NOTES - varchar(250) (nominal)
ID: TV01002.CHECK_NOTES
Pertinent comments about the condition of the tree or to explain oddities about the measurement for a given remeasurement check
Type system: Microsoft SQL Server 2019
DB_NOTES - char(254) (nominal)
ID: TV01002.DB_NOTES
Database notes based on QC after field collection
Type system: Microsoft SQL Server 2019
TV01003 - Individual tree mortality
Object name: TV01003_v21.csv
Records: 40172
Attributes: 27
Temporal coverage: 1910-02-01 to 2023-08-01
File size: 4474995 byte
Checksum (MD5): 370681b1e18b7e017e289efca745c571
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TV01003.PLOTNUMBER, TV01003.STANDID, TV01003.PSP_STUDYID, TV01003.TAG
-
notNullConstraint: NOTNULL TV01003.MORT_CAUSE1, TV01003.MORT_CAUSE2, TV01003.CONDITION1, TV01003.CONDITION2, TV01003.CONDITION3, TV01003.CONDITION4, TV01003.CONDITION5, TV01003.CONDITION6, TV01003.DBCODE, TV01003.ENTITY, TV01003.PLOTNUMBER, TV01003.POSITION, TV01003.SPECIES, TV01003.STANDID, TV01003.PSP_STUDYID, TV01003.TAG, TV01003.YEAR, TV01003.TREEID, TV01003.MAIN_STEM, TV01003.ROOTING, TV01003.DBH_LAST
Attributes (27)
DBCODE - char(5) (nominal)
ID: TV01003.DBCODE
FSDB Database code
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
TV010
FSDB Data set code TV010
ENTITY - numeric(2,0) (ratio)
ID: TV01003.ENTITY
Entity number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=whole, min=3.0000 (exclusive=false), max=3.0000 (exclusive=false)
TREEID - char(13) (nominal)
ID: TV01003.TREEID
Tree identification code represented as STANDID+PLOTID+00000, where 00000 represents a unique tree number for that stand and plot
Type system: Microsoft SQL Server 2019
PSP_STUDYID - char(4) (nominal)
ID: TV01003.PSP_STUDYID
Permanent Study Plots (PSP) study identification code - a mutually exclusive grouping of study forest stands
Type system: Microsoft SQL Server 2019
Code definitions (13)
-
ALCO
Alder-conifer study at Cascade Head Experimental Forest
-
DFGY
Douglas-fir Growth And Yield Study
-
HSGY
Hemlock-spruce Growth And Yield Study
-
MHGY
Mountain Hemlock Growth and Yield Study
-
MSHV
Mt. St. Helens Volcanic study area
-
MRRS
Mt Rainier Reference Stands
-
NFGY
Noble Fir Growth and Yield Study
-
HJRS
Andrews Forest and vicinity Reference Stands
-
PPGY
Ponderosa Pine Growth and Yield Study
-
RMRS
Rocky Mountain Reference Stands
-
SQNP
Sequoia National Park Reference Stands
-
HJWS
Andrews Forest and vicinity Watershed Reference Stands
-
HJHE
High Elevation Reference Stand, H.J. Andrews EF
STANDID - char(4) (nominal)
ID: TV01003.STANDID
Study forest stand or watershed identification code
Type system: Microsoft SQL Server 2019
Code definitions (170)
-
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
-
RS04
Reference Stand RS04, H.J. Andrews EF, Willamette NF
-
RS05
Reference Stand RS05, H.J. Andrews EF, Willamette NF
-
RS07
Reference Stand RS07, H.J. Andrews EF, Willamette NF
-
RS08
Reference Stand RS08, H.J. Andrews EF, Willamette NF
-
RS12
Reference Stand RS12, H.J. Andrews EF, Willamette NF
-
RS13
Reference Stand RS13, Wildcat Mtn RNA, Willamette NF
-
RS14
Reference Stand RS14, Wildcat Mtn RNA, Willamette NF
-
RS15
Reference Stand RS15, H.J. Andrews EF, Willamette NF
-
RS16
Reference Stand RS16, H.J. Andrews EF, Willamette NF
-
RS17
Reference Stand RS17, H.J. Andrews EF, Willamette NF
-
RS18
Reference Stand RS18, 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
-
RS26
Reference Stand RS26, H.J. Andrews EF, Willamette NF
-
RS35
Reference Stand RS35, Hagan Creek, Willamette NF
-
RS38
Reference Stand RS38, H.J. Andrews EF, Willamette NF
-
CH14
Reference Stand CH14, Cascade Head EF, Douglas-fir
-
CH41
Reference Stand CH41, Cascade Head EF, Douglas-fir
-
CH42
Reference Stand CH42, Cascade Head EF, Douglas-fir
-
GP01
Reference Stand GP01, Camp Creek, Gifford Pinchot NF
-
GP02
Reference Stand GP02, Camp Creek, Gifford Pinchot NF
-
GP03
Reference Stand GP03, Camp Creek, Gifford Pinchot NF
-
GP04
Reference Stand GP04, Camp Creek, Gifford Pinchot NF
-
GP05
Reference Stand GP05, Camp Creek, Gifford Pinchot NF
-
GP07
Reference Stand GP07, Kiona Creek, Gifford Pinchot NF
-
GP09
Reference Stand GP09, Kiona Creek, Gifford Pinchot NF
-
MH01
Reference Stand MH01, Still Creek, Mount Hood NF
-
MH02
Reference Stand MH02, Still Creek, Mount Hood NF
-
MH03
Reference Stand MH03, Still Creek, Mount Hood NF
-
MUNA
Reference Stand MUNA, T. T. Munger RNA, Gifford Pinchot NF
-
OL01
Reference Stand OL01, Quilcene, WA, Olympic NF
-
OL02
Reference Stand OL02, Quilcene, WA, Olympic NF
-
OL03
Reference Stand OL03, Blyn, WA, Olympic NF
-
OL04
Reference Stand OL04, Blyn, WA, Olympic NF
-
SI04
Reference Stand SI04, Deadwood Creek, Siuslaw NF
-
SI05
Reference Stand SI05, Deadwood Creek, Siuslaw NF
-
SI06
Reference Stand SI06, Saddle Mtn, Siuslaw NF
-
SI07
Reference Stand SI07, Saddle Mtn, Siuslaw NF
-
SI08
Reference Stand SI08, Saddle Mtn, Siuslaw NF
-
SI09
Reference Stand SI09, Five Rivers, Siuslaw NF
-
SI10
Reference Stand SI10, Five Rivers, Siuslaw NF
-
SI20
Reference Stand SI20, Cook sale check plot, Siuslaw NF
-
SN01
Reference Stand SN01, Skate Creek, Snoqualmie NF
-
SN02
Reference Stand SN02, Skate Creek, Snoqualmie NF
-
WI01
Reference Stand WI01, Lowell RD, Willamette NF, stand 1
-
WI02
Reference Stand WI02, Lowell RD, Willamette NF, stand 2
-
WI03
Reference Stand WI03, Lowell RD, Willamette NF, stand 3
-
WI05
Reference Stand WI05, Salmon Creek, Willamette NF
-
WR02
Reference Stand WR02, Wind River EF, Gifford Pinchot NF
-
WR04
Reference Stand WR04, Panther Cr, Wind River EF, GPinchot NF
-
WR05
Reference Stand WR05, Panther Cr, Wind River EF, GPinchot NF
-
WR09
Reference Stand WR09, Wind River EF, Gifford Pinchot NF
-
WR90
Reference Stand WR90, Panther Cr, Wind River EF, GPinchot NF
-
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
-
HS01
Reference Stand HS01, Neskowin Crest RNA, Siuslaw NF
-
HS02
Reference Stand HS02, Quinault RNA, Olympic NP
-
HS03
Reference Stand HS03, Quinault RNA, Olympic NP
-
HS04
Reference Stand HS04, Twin Creek RNA, Olympic NP
-
NCNA
Reference Stand NCNA, Neskowin Crest RNA, Siuslaw NF
-
HGBK
Reference Watershed HGBK, Hagan RNA, Willamette NF
-
WS02
Reference Watershed WS02, H.J. Andrews EF, Willamette NF
-
SP06
Reference Stand SP06, Santiam Pass, Willamette NF
-
TCTR
Reference Stand TCTR, Torrey-Charlton RNA, Willamette NF
-
CFMF
Reference Stand CFMF, Cedar Flats Research Natural Area
-
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
-
SRNA
Reference Stand SRNA, Steamboat Mtn RNA, Gifford Pinchot 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
-
BRNA
Reference Stand BRNA, Bagby RNA, Mount Hood NF
-
RS10
Reference Stand RS10, H.J. Andrews EF, Willamette NF
-
RS21
Reference Stand RS21, H.J. Andrews EF, Willamette NF
-
RS22
Reference Stand RS22, H.J. Andrews EF, Willamette NF
-
RS23
Reference Stand RS23, H.J. Andrews EF, Willamette NF
-
RS25
Reference Stand RS25, Middle Santiam RNA, Willamette NF
-
RS27
Reference Stand RS27, H.J. Andrews EF, Willamette NF
-
RS28
Reference Stand RS28, H.J. Andrews EF, Willamette NF
-
RS29
Reference Stand RS29, H.J. Andrews EF, Willamette NF
-
RS30
Reference Stand RS30, H.J. Andrews EF, Willamette NF
-
RS31
Reference Stand RS31, H.J. Andrews EF, Willamette NF
-
RS32
Reference Stand RS32, H.J. Andrews EF, Willamette NF
-
RS33
Reference Stand RS33, H.J. Andrews EF, Willamette NF
-
RS34
Reference Stand RS34, H.J. Andrews EF, Willamette NF
-
RS36
Reference Stand RS36, Wildcat Mtn RNA, Willamette NF
-
RS37
Reference Stand RS37, South Fork Hagan Creek, Willamette NF
-
ARNA
Reference Stand ARNA, Ashland Research Natural Area
-
MRNA
Reference Stand MRNA, Metolius RNA, Deschutes NF
-
PF28
Reference Stand PF28, Pringle Falls RNA, Deschutes NF
-
PF29
Reference Stand PF29, Pringle Falls RNA, Deschutes NF
-
FRA3
Reference Stand FRA3, Fraser EF, CO, lodgepole pine
-
FRC3
Reference Stand FRC3, Fraser EF, CO, lodgepole pine
-
FRD1
Reference Stand FRD1, Fraser EF, CO, spruce-fir
-
FRD2
Reference Stand FRD2, Fraser EF, CO, lodgepole pine
-
FRB2
Reference Stand FRB2, Fraser EF, CO, lodgepole pine
-
PF27
Reference Stand PF27, Pringle Falls RNA, Deschutes NF
-
MUN2
Reference Stand MUN2, T. T. Munger RNA, Gifford Pinchot NF
-
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
-
RS39
Reference Stand RS39, H.J. Andrews EF, Willamette NF
-
CH11
Reference Stand CH11, Cascade Head EF, hemlock-spruce
-
CH15
Reference Stand CH15, Cascade Head EF, alder-conifer
-
CH17
Reference Stand CH17, Cascade Head EF, alder-conifer
-
CH22
Reference Stand CH22, Cascade Head EF, alder-conifer
-
CH23
Reference Stand CH23, Cascade Head EF, alder-conifer
-
RS06
Reference Stand RS06, H.J. Andrews EF, Willamette NF
-
RS09
Reference Stand RS09, H.J. Andrews EF, Willamette NF
-
RS11
Reference Stand RS11, H.J. Andrews EF, Willamette NF
-
CLMA
Reference Stand CLMA, Chambers Lk, GPinchot NF, MSH ashfall
-
EPMA
Reference Stand EPMA, Elk Pass, GPinchot NF, MSH ashfall
-
CRMA
Reference Stand CRMA, N. Fork Cispus R, GP NF, MSH ashfall
-
WS06
Reference Watershed WS06, H.J. Andrews EF, Willamette NF
-
WS07
Reference Watershed WS07, H.J. Andrews EF, Willamette NF
-
WS08
Reference Watershed WS08, H.J. Andrews EF, Willamette NF
-
WS09
Reference Watershed WS09, H.J. Andrews EF, Willamette NF
-
RS40
Reference Stand RS41, H.J. Andrews EF, Willamette NF
-
HE04
High Elevation Reference Stand HE04, H.J. Andrews EF
-
HE05
High Elevation Reference Stand HE05, H.J. Andrews EF
-
HE06
High Elevation Reference Stand HE06, H.J. Andrews EF
-
HE07
High Elevation Reference Stand HE07, H.J. Andrews EF
-
HE08
High Elevation Reference Stand HE08, H.J. Andrews EF
-
HE13
High Elevation Reference Stand HE13, H.J. Andrews EF
-
HE17
High Elevation Reference Stand HE17, H.J. Andrews EF
-
HE18
High Elevation Reference Stand HE18, H.J. Andrews EF
PLOTNUMBER - numeric(4,0) (interval)
ID: TV01003.PLOTNUMBER
Plot number within STANDID
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1
Numeric domain: type=natural, min=0.0000 (exclusive=false), max=1005.0000 (exclusive=false)
SPECIES - char(6) (nominal)
ID: TV01003.SPECIES
Tree species code
Type system: Microsoft SQL Server 2019
Code definitions (39)
-
ABAM
Abies amabilis
-
ABCO
Abies concolor
-
ABGR
Abies grandis
-
ABLA
Abies lasiocarpa
-
ABMA
Abies magnifica
-
ABPR
Abies procera
-
ACGL
Acer glabrum
-
ACMA3
Acer macrophyllum
-
ALIN2
Alnus incana
-
ALRU2
Alnus rubra
-
ALVIS
Alnus viridis ssp. sinuata
-
ARME
Arbutus menziesii
-
CADE3
Calocedrus decurrens
-
CHCH7
Chrysolepis chrysophylla
-
CONU4
Cornus nuttallii
-
FRPU7
Frangula purshiana
-
LAOC
Larix occidentalis
-
MAFU
Malus fusca
-
PIEN
Picea engelmannii
-
PISI
Picea sitchensis
-
PICO
Pinus contorta
-
PIJE
Pinus jeffreyi
-
PILA
Pinus lambertiana
-
PIMO3
Pinus monticola
-
PIPO
Pinus ponderosa
-
POBAT
Populus balsamifera ssp. trichocarpa
-
POTR5
Populus tremuloides
-
PRUNU
Prunus
-
PREM
Prunus emarginata
-
PSME
Pseudotsuga menziesii
-
QUGA4
Quercus garryana
-
QUKE
Quercus kelloggii
-
SASC
Salix scouleriana
-
TABR2
Taxus brevifolia
-
THPL
Thuja plicata
-
TSHE
Tsuga heterophylla
-
TSME
Tsuga mertensiana
-
CANO9
Callitropsis nootkatensis
-
SEGI
Sequoiadendron giganteum
TAG - numeric(7,0) (interval)
ID: TV01003.TAG
Current tree tag number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=9999999.0000 (exclusive=false)
YEAR - numeric(4,0) (interval)
ID: TV01003.YEAR
Year of establishment, remeasurement, or mortality
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1915.0000 (exclusive=false), max=2023.0000 (exclusive=false)
DBH_LAST - numeric(6,1) (ratio)
ID: TV01003.DBH_LAST
Last measured tree diameter at breast height (1.37m) - typically from last remeasurement as dbh is usually not measured for dead trees
Type system: Microsoft SQL Server 2019
Unit: centimeters
Precision: 0.100000
Numeric domain: type=real, min=0.3000 (exclusive=false), max=252.3000 (exclusive=false)
MAIN_STEM - char(1) (nominal)
ID: TV01003.MAIN_STEM
Main stem condition code (use of this code begins in 2010)
Type system: Microsoft SQL Server 2019
Code definitions (4)
-
1
Main stem intact (not broken)
-
2
Main stem broken at or above the root collar
-
3
Main stem broken below root collar
-
9
Not recorded / missing
ROOTING - char(1) (nominal)
ID: TV01003.ROOTING
Tree rooting condition code (use of this code begins in 2010)
Type system: Microsoft SQL Server 2019
Code definitions (4)
-
1
Fully rooted; root-soil interface intact, stem is freestanding
-
2
Partially uprooted (roots exposed), but stem is still freestanding and self-supporting
-
3
Uprooted and down, stem is not freestanding
-
9
Condition not recorded / missing
POSITION - char(1) (nominal)
ID: TV01003.POSITION
Tree position (used prior to 2010); describes the physical position of the tree; POSITION is replaced with two separate measurements of MAIN_STEM and ROOTING beginning 2010
Type system: Microsoft SQL Server 2019
Code definitions (5)
-
1
Standing with crown (may be leaning)
-
2
Main stem broken
-
3
Crushed/knocked over/fallen over AND still rooted
-
4
Uprooted
-
9
Unknown: position not recorded or otherwise unknown
CROWN_PCT - numeric(3,0) (ratio)
ID: TV01003.CROWN_PCT
Percent of a tree's live crown volume that is still intact along the stem (does not apply to uprooted trees); record for living trees begins in 2010 (Entity 2) - only recorded when mortality is noted before 2010 (Entity 3).
Type system: Microsoft SQL Server 2019
Unit: percent
Precision: 5.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)
TREE_PCT - numeric(3,0) (ratio)
ID: TV01003.TREE_PCT
Percent of the entire main stem length that is intact (does not apply to uprooted trees); record for living trees begins in 2010 (Entity 2) - only recorded when mortality is noted before 2010 (Entity 3).
Type system: Microsoft SQL Server 2019
Unit: percent
Precision: 5.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)
LEAN_ANGLE - numeric(3,0) (ratio)
ID: TV01003.LEAN_ANGLE
Angle of tree lean in degrees from vertical, where vertical is 0 degrees (not recorded for uprooted trees); record for living trees begins in 2010 (TV010 Entity 2) - only recorded when mortality is noted before 2010 (TV010 Entity 3).
Type system: Microsoft SQL Server 2019
Unit: degrees angle
Precision: 5.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=170.0000 (exclusive=false)
GROUND_PCT - numeric(3,0) (ratio)
ID: TV01003.GROUND_PCT
Percent of the down portion of the tree bole that is in direct contact with the ground (does not include branch contact). Only applies to MAIN_STEM code= 1,2 or POSITION code=2,4
Type system: Microsoft SQL Server 2019
Unit: percent
Precision: 1.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)
SUPPORT_PCT - numeric(3,0) (ratio)
ID: TV01003.SUPPORT_PCT
Percent of the down portion of the tree bole that is suppored above the ground (by its own branches, other trees or downed logs, or other objects such as rocks). Only applies to MAIN_STEM code= 1,2 or POSITION code=2,4
Type system: Microsoft SQL Server 2019
Unit: percent
Precision: 1.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)
MORT_CAUSE1 - char(2) (nominal)
ID: TV01003.MORT_CAUSE1
Proximate mortality cause: the immediate cause that precipitates tree death (defined as primary mortality cause before 2010)
Type system: Microsoft SQL Server 2019
Code definitions (22)
-
01
Suppression
-
10
Disease
-
11
Mistletoe
-
12
Bark insect
-
13
Defoliating insect
-
14
Unknown pathogen
-
20
Windthrow
-
21
Co-opted windthrow
-
22
Windsnap
-
23
Broken top
-
24
Crushed by fallen GREEN tree or limb
-
30
Crushed by fallen DEAD tree, limb, rock, etc.
-
31
Lightning
-
32
Animal kill
-
33
Snow or ice breakage or crushing
-
34
Mudflow
-
40
Fire
-
50
Other disturbance
-
60
Unable to determine primal or primary cause during field inspection
-
70
Tree removed from plot via landslides or other disturbance. This does not apply to trees not found or missing.
-
99
Unknown: no attempt to note proximal or primary cause of mortality
-
02
Previously noted injury/damage
MORT_CAUSE2 - char(2) (nominal)
ID: TV01003.MORT_CAUSE2
Predisposing mortality cause: any condition that produces a susceptibility or disposition to tree death without actually causing it (defined as secondary or contributing mortality cause before 2010)
Type system: Microsoft SQL Server 2019
Code definitions (22)
-
99
Unknown: no attempt to note proximal or primary cause of mortality
-
01
Suppression
-
10
Disease
-
11
Mistletoe
-
12
Bark insect
-
13
Defoliating insect
-
14
Unknown pathogen
-
20
Windthrow
-
21
Co-opted windthrow
-
22
Windsnap
-
23
Broken top
-
24
Crushed by fallen GREEN tree or limb
-
30
Crushed by fallen DEAD tree, limb, rock, etc.
-
31
Lightning
-
32
Animal kill
-
33
Snow or ice breakage or crushing
-
34
Mudflow
-
40
Fire
-
50
Other disturbance
-
60
Unable to determine primal or primary cause during field inspection
-
70
Tree removed from plot via landslides or other disturbance. This does not apply to trees not found or missing.
-
02
Previously noted injury/damage
CONDITION1 - char(2) (nominal)
ID: TV01003.CONDITION1
Condition code 1 - general tree health indicator is one of potentially six noted conditions in arbitrary order
Type system: Microsoft SQL Server 2019
Code definitions (26)
-
01
Green needles or leaves present
-
02
Dead needles or leaves present
-
03
Bark sloughing
-
04
Tree has been dead for several years
-
11
Crown flat-topped
-
12
Evidence for earlier loss of part of crown
-
13
Spike top / Top dieback
-
14
Crown stripped by falling tree or snag
-
21
Rot at break
-
41
Pitch tubes on bole
-
42
Beetle galleries
-
51
Conks
-
52
Rot
-
53
Tree hollow
-
54
Pitch sheets
-
55
Oozing wounds
-
56
Mistletoe plants observed
-
60
Witch's broom
-
71
Scarring of bole
-
72
Girdling
-
73
Woodpecker / Sapsucker activity
-
74
No bark remaining on tree
-
99
Condition code not noted
-
22
Top not found
-
43
Insect frass
-
44
Insect holes
CONDITION2 - char(2) (nominal)
ID: TV01003.CONDITION2
Condition code 2 - general tree health indicator is one of potentially six noted conditions in arbitrary order
Type system: Microsoft SQL Server 2019
Code definitions (26)
-
01
Green needles or leaves present
-
02
Dead needles or leaves present
-
03
Bark sloughing
-
04
Tree has been dead for several years
-
11
Crown flat-topped
-
12
Evidence for earlier loss of part of crown
-
13
Spike top / Top dieback
-
14
Crown stripped by falling tree or snag
-
21
Rot at break
-
41
Pitch tubes on bole
-
42
Beetle galleries
-
51
Conks
-
52
Rot
-
53
Tree hollow
-
54
Pitch sheets
-
55
Oozing wounds
-
56
Mistletoe plants observed
-
60
Witch's broom
-
71
Scarring of bole
-
72
Girdling
-
73
Woodpecker / Sapsucker activity
-
74
No bark remaining on tree
-
99
Condition code not noted
-
22
Top not found
-
43
Insect frass
-
44
Insect holes
CONDITION3 - char(2) (nominal)
ID: TV01003.CONDITION3
Condition code 3 - general tree health indicator is one of potentially six noted conditions in arbitrary order
Type system: Microsoft SQL Server 2019
Code definitions (26)
-
01
Green needles or leaves present
-
02
Dead needles or leaves present
-
03
Bark sloughing
-
04
Tree has been dead for several years
-
11
Crown flat-topped
-
12
Evidence for earlier loss of part of crown
-
13
Spike top / Top dieback
-
14
Crown stripped by falling tree or snag
-
21
Rot at break
-
41
Pitch tubes on bole
-
42
Beetle galleries
-
51
Conks
-
52
Rot
-
53
Tree hollow
-
54
Pitch sheets
-
55
Oozing wounds
-
56
Mistletoe plants observed
-
60
Witch's broom
-
71
Scarring of bole
-
72
Girdling
-
73
Woodpecker / Sapsucker activity
-
74
No bark remaining on tree
-
99
Condition code not noted
-
22
Top not found
-
43
Insect frass
-
44
Insect holes
CONDITION4 - char(2) (nominal)
ID: TV01003.CONDITION4
Condition code 4 - general tree health indicator is one of potentially six noted conditions in arbitrary order
Type system: Microsoft SQL Server 2019
Code definitions (26)
-
01
Green needles or leaves present
-
02
Dead needles or leaves present
-
03
Bark sloughing
-
04
Tree has been dead for several years
-
11
Crown flat-topped
-
12
Evidence for earlier loss of part of crown
-
13
Spike top / Top dieback
-
14
Crown stripped by falling tree or snag
-
21
Rot at break
-
41
Pitch tubes on bole
-
42
Beetle galleries
-
51
Conks
-
52
Rot
-
53
Tree hollow
-
54
Pitch sheets
-
55
Oozing wounds
-
56
Mistletoe plants observed
-
60
Witch's broom
-
71
Scarring of bole
-
72
Girdling
-
73
Woodpecker / Sapsucker activity
-
74
No bark remaining on tree
-
99
Condition code not noted
-
22
Top not found
-
43
Insect frass
-
44
Insect holes
CONDITION5 - char(2) (nominal)
ID: TV01003.CONDITION5
Condition code 5 - general tree health indicator is one of potentially six noted conditions in arbitrary order
Type system: Microsoft SQL Server 2019
Code definitions (26)
-
01
Green needles or leaves present
-
02
Dead needles or leaves present
-
03
Bark sloughing
-
04
Tree has been dead for several years
-
11
Crown flat-topped
-
12
Evidence for earlier loss of part of crown
-
13
Spike top / Top dieback
-
14
Crown stripped by falling tree or snag
-
21
Rot at break
-
41
Pitch tubes on bole
-
42
Beetle galleries
-
51
Conks
-
52
Rot
-
53
Tree hollow
-
54
Pitch sheets
-
55
Oozing wounds
-
56
Mistletoe plants observed
-
60
Witch's broom
-
71
Scarring of bole
-
72
Girdling
-
73
Woodpecker / Sapsucker activity
-
74
No bark remaining on tree
-
99
Condition code not noted
-
22
Top not found
-
43
Insect frass
-
44
Insect holes
CONDITION6 - char(2) (nominal)
ID: TV01003.CONDITION6
Condition code 6 - general tree health indicator is one of potentially six noted conditions in arbitrary order
Type system: Microsoft SQL Server 2019
Code definitions (26)
-
01
Green needles or leaves present
-
02
Dead needles or leaves present
-
03
Bark sloughing
-
04
Tree has been dead for several years
-
11
Crown flat-topped
-
12
Evidence for earlier loss of part of crown
-
13
Spike top / Top dieback
-
14
Crown stripped by falling tree or snag
-
21
Rot at break
-
41
Pitch tubes on bole
-
42
Beetle galleries
-
51
Conks
-
52
Rot
-
53
Tree hollow
-
54
Pitch sheets
-
55
Oozing wounds
-
56
Mistletoe plants observed
-
60
Witch's broom
-
71
Scarring of bole
-
72
Girdling
-
73
Woodpecker / Sapsucker activity
-
74
No bark remaining on tree
-
99
Condition code not noted
-
22
Top not found
-
43
Insect frass
-
44
Insect holes
MORT_NOTES - varchar(110) (nominal)
ID: TV01003.MORT_NOTES
Mortality check comments added to clarify observations and decisions (for example, note the name of the pathogen if known)
Type system: Microsoft SQL Server 2019
TV01004 - Tree heights
Object name: TV01004_v2.csv
Records: 20821
Attributes: 19
Temporal coverage: 1910-02-01 to 2004-08-01
File size: 1390109 byte
Checksum (MD5): 0221cf13aa787dca3bd13bfe5b9bc95f
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TV01004.PLOTNUMBER, TV01004.STANDID, TV01004.PSP_STUDYID, TV01004.YEAR
-
notNullConstraint: NOTNULL TV01004.DBCODE, TV01004.ENTITY, TV01004.PLOTNUMBER, TV01004.SPECIES, TV01004.STANDID, TV01004.PSP_STUDYID, TV01004.YEAR
Attributes (19)
DBCODE - char(5) (nominal)
ID: TV01004.DBCODE
FSDB Database code
Type system: Microsoft SQL Server 2019
Code definitions (1)
-
TV010
FSDB Data set code TV010
ENTITY - numeric(2,0) (ratio)
ID: TV01004.ENTITY
Entity number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=whole, min=4.0000 (exclusive=false), max=4.0000 (exclusive=false)
PSP_STUDYID - char(4) (nominal)
ID: TV01004.PSP_STUDYID
Permanent Study Plots (PSP) study identification code - a mutually exclusive grouping of study forest stands
Type system: Microsoft SQL Server 2019
Code definitions (13)
-
ALCO
Alder-conifer study at Cascade Head Experimental Forest
-
DFGY
Douglas-fir Growth And Yield Study
-
HSGY
Hemlock-spruce Growth And Yield Study
-
MHGY
Mountain Hemlock Growth and Yield Study
-
MSHV
Mt. St. Helens Volcanic study area
-
MRRS
Mt Rainier Reference Stands
-
NFGY
Noble Fir Growth and Yield Study
-
HJRS
Andrews Forest and vicinity Reference Stands
-
PPGY
Ponderosa Pine Growth and Yield Study
-
RMRS
Rocky Mountain Reference Stands
-
SQNP
Sequoia National Park Reference Stands
-
HJWS
Andrews Forest and vicinity Watershed Reference Stands
-
HJHE
High Elevation Reference Stand, H.J. Andrews EF
STANDID - char(4) (nominal)
ID: TV01004.STANDID
Study forest stand or watershed identification code
Type system: Microsoft SQL Server 2019
Code definitions (170)
-
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
-
RS04
Reference Stand RS04, H.J. Andrews EF, Willamette NF
-
RS05
Reference Stand RS05, H.J. Andrews EF, Willamette NF
-
RS07
Reference Stand RS07, H.J. Andrews EF, Willamette NF
-
RS08
Reference Stand RS08, H.J. Andrews EF, Willamette NF
-
RS12
Reference Stand RS12, H.J. Andrews EF, Willamette NF
-
RS13
Reference Stand RS13, Wildcat Mtn RNA, Willamette NF
-
RS14
Reference Stand RS14, Wildcat Mtn RNA, Willamette NF
-
RS15
Reference Stand RS15, H.J. Andrews EF, Willamette NF
-
RS16
Reference Stand RS16, H.J. Andrews EF, Willamette NF
-
RS17
Reference Stand RS17, H.J. Andrews EF, Willamette NF
-
RS18
Reference Stand RS18, 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
-
RS26
Reference Stand RS26, H.J. Andrews EF, Willamette NF
-
RS35
Reference Stand RS35, Hagan Creek, Willamette NF
-
RS38
Reference Stand RS38, H.J. Andrews EF, Willamette NF
-
CH14
Reference Stand CH14, Cascade Head EF, Douglas-fir
-
CH41
Reference Stand CH41, Cascade Head EF, Douglas-fir
-
CH42
Reference Stand CH42, Cascade Head EF, Douglas-fir
-
GP01
Reference Stand GP01, Camp Creek, Gifford Pinchot NF
-
GP02
Reference Stand GP02, Camp Creek, Gifford Pinchot NF
-
GP03
Reference Stand GP03, Camp Creek, Gifford Pinchot NF
-
GP04
Reference Stand GP04, Camp Creek, Gifford Pinchot NF
-
GP05
Reference Stand GP05, Camp Creek, Gifford Pinchot NF
-
GP07
Reference Stand GP07, Kiona Creek, Gifford Pinchot NF
-
GP09
Reference Stand GP09, Kiona Creek, Gifford Pinchot NF
-
MH01
Reference Stand MH01, Still Creek, Mount Hood NF
-
MH02
Reference Stand MH02, Still Creek, Mount Hood NF
-
MH03
Reference Stand MH03, Still Creek, Mount Hood NF
-
MUNA
Reference Stand MUNA, T. T. Munger RNA, Gifford Pinchot NF
-
OL01
Reference Stand OL01, Quilcene, WA, Olympic NF
-
OL02
Reference Stand OL02, Quilcene, WA, Olympic NF
-
OL03
Reference Stand OL03, Blyn, WA, Olympic NF
-
OL04
Reference Stand OL04, Blyn, WA, Olympic NF
-
SI04
Reference Stand SI04, Deadwood Creek, Siuslaw NF
-
SI05
Reference Stand SI05, Deadwood Creek, Siuslaw NF
-
SI06
Reference Stand SI06, Saddle Mtn, Siuslaw NF
-
SI07
Reference Stand SI07, Saddle Mtn, Siuslaw NF
-
SI08
Reference Stand SI08, Saddle Mtn, Siuslaw NF
-
SI09
Reference Stand SI09, Five Rivers, Siuslaw NF
-
SI10
Reference Stand SI10, Five Rivers, Siuslaw NF
-
SI20
Reference Stand SI20, Cook sale check plot, Siuslaw NF
-
SN01
Reference Stand SN01, Skate Creek, Snoqualmie NF
-
SN02
Reference Stand SN02, Skate Creek, Snoqualmie NF
-
WI01
Reference Stand WI01, Lowell RD, Willamette NF, stand 1
-
WI02
Reference Stand WI02, Lowell RD, Willamette NF, stand 2
-
WI03
Reference Stand WI03, Lowell RD, Willamette NF, stand 3
-
WI05
Reference Stand WI05, Salmon Creek, Willamette NF
-
WR02
Reference Stand WR02, Wind River EF, Gifford Pinchot NF
-
WR04
Reference Stand WR04, Panther Cr, Wind River EF, GPinchot NF
-
WR05
Reference Stand WR05, Panther Cr, Wind River EF, GPinchot NF
-
WR09
Reference Stand WR09, Wind River EF, Gifford Pinchot NF
-
WR90
Reference Stand WR90, Panther Cr, Wind River EF, GPinchot NF
-
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
-
HS01
Reference Stand HS01, Neskowin Crest RNA, Siuslaw NF
-
HS02
Reference Stand HS02, Quinault RNA, Olympic NP
-
HS03
Reference Stand HS03, Quinault RNA, Olympic NP
-
HS04
Reference Stand HS04, Twin Creek RNA, Olympic NP
-
NCNA
Reference Stand NCNA, Neskowin Crest RNA, Siuslaw NF
-
HGBK
Reference Watershed HGBK, Hagan RNA, Willamette NF
-
WS02
Reference Watershed WS02, H.J. Andrews EF, Willamette NF
-
SP06
Reference Stand SP06, Santiam Pass, Willamette NF
-
TCTR
Reference Stand TCTR, Torrey-Charlton RNA, Willamette NF
-
CFMF
Reference Stand CFMF, Cedar Flats Research Natural Area
-
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
-
SRNA
Reference Stand SRNA, Steamboat Mtn RNA, Gifford Pinchot 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
-
BRNA
Reference Stand BRNA, Bagby RNA, Mount Hood NF
-
RS10
Reference Stand RS10, H.J. Andrews EF, Willamette NF
-
RS21
Reference Stand RS21, H.J. Andrews EF, Willamette NF
-
RS22
Reference Stand RS22, H.J. Andrews EF, Willamette NF
-
RS23
Reference Stand RS23, H.J. Andrews EF, Willamette NF
-
RS25
Reference Stand RS25, Middle Santiam RNA, Willamette NF
-
RS27
Reference Stand RS27, H.J. Andrews EF, Willamette NF
-
RS28
Reference Stand RS28, H.J. Andrews EF, Willamette NF
-
RS29
Reference Stand RS29, H.J. Andrews EF, Willamette NF
-
RS30
Reference Stand RS30, H.J. Andrews EF, Willamette NF
-
RS31
Reference Stand RS31, H.J. Andrews EF, Willamette NF
-
RS32
Reference Stand RS32, H.J. Andrews EF, Willamette NF
-
RS33
Reference Stand RS33, H.J. Andrews EF, Willamette NF
-
RS34
Reference Stand RS34, H.J. Andrews EF, Willamette NF
-
RS36
Reference Stand RS36, Wildcat Mtn RNA, Willamette NF
-
RS37
Reference Stand RS37, South Fork Hagan Creek, Willamette NF
-
ARNA
Reference Stand ARNA, Ashland Research Natural Area
-
MRNA
Reference Stand MRNA, Metolius RNA, Deschutes NF
-
PF28
Reference Stand PF28, Pringle Falls RNA, Deschutes NF
-
PF29
Reference Stand PF29, Pringle Falls RNA, Deschutes NF
-
FRA3
Reference Stand FRA3, Fraser EF, CO, lodgepole pine
-
FRC3
Reference Stand FRC3, Fraser EF, CO, lodgepole pine
-
FRD1
Reference Stand FRD1, Fraser EF, CO, spruce-fir
-
FRD2
Reference Stand FRD2, Fraser EF, CO, lodgepole pine
-
FRB2
Reference Stand FRB2, Fraser EF, CO, lodgepole pine
-
PF27
Reference Stand PF27, Pringle Falls RNA, Deschutes NF
-
MUN2
Reference Stand MUN2, T. T. Munger RNA, Gifford Pinchot NF
-
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
-
RS39
Reference Stand RS39, H.J. Andrews EF, Willamette NF
-
CH11
Reference Stand CH11, Cascade Head EF, hemlock-spruce
-
CH15
Reference Stand CH15, Cascade Head EF, alder-conifer
-
CH17
Reference Stand CH17, Cascade Head EF, alder-conifer
-
CH22
Reference Stand CH22, Cascade Head EF, alder-conifer
-
CH23
Reference Stand CH23, Cascade Head EF, alder-conifer
-
RS06
Reference Stand RS06, H.J. Andrews EF, Willamette NF
-
RS09
Reference Stand RS09, H.J. Andrews EF, Willamette NF
-
RS11
Reference Stand RS11, H.J. Andrews EF, Willamette NF
-
CLMA
Reference Stand CLMA, Chambers Lk, GPinchot NF, MSH ashfall
-
EPMA
Reference Stand EPMA, Elk Pass, GPinchot NF, MSH ashfall
-
CRMA
Reference Stand CRMA, N. Fork Cispus R, GP NF, MSH ashfall
-
WS06
Reference Watershed WS06, H.J. Andrews EF, Willamette NF
-
WS07
Reference Watershed WS07, H.J. Andrews EF, Willamette NF
-
WS08
Reference Watershed WS08, H.J. Andrews EF, Willamette NF
-
WS09
Reference Watershed WS09, H.J. Andrews EF, Willamette NF
-
RS40
Reference Stand RS41, H.J. Andrews EF, Willamette NF
-
HE04
High Elevation Reference Stand HE04, H.J. Andrews EF
-
HE05
High Elevation Reference Stand HE05, H.J. Andrews EF
-
HE06
High Elevation Reference Stand HE06, H.J. Andrews EF
-
HE07
High Elevation Reference Stand HE07, H.J. Andrews EF
-
HE08
High Elevation Reference Stand HE08, H.J. Andrews EF
-
HE13
High Elevation Reference Stand HE13, H.J. Andrews EF
-
HE17
High Elevation Reference Stand HE17, H.J. Andrews EF
-
HE18
High Elevation Reference Stand HE18, H.J. Andrews EF
PLOTNUMBER - numeric(4,0) (interval)
ID: TV01004.PLOTNUMBER
Plot number within STANDID
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1
Numeric domain: type=natural, min=0.0000 (exclusive=false), max=1005.0000 (exclusive=false)
TAG - numeric(7,0) (interval)
ID: TV01004.TAG
Current tree tag number
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=9991.0000 (exclusive=false)
SPECIES - char(6) (nominal)
ID: TV01004.SPECIES
Tree species code
Type system: Microsoft SQL Server 2019
Code definitions (39)
-
ABAM
Abies amabilis
-
ABCO
Abies concolor
-
ABGR
Abies grandis
-
ABLA
Abies lasiocarpa
-
ABMA
Abies magnifica
-
ABPR
Abies procera
-
ACGL
Acer glabrum
-
ACMA3
Acer macrophyllum
-
ALIN2
Alnus incana
-
ALRU2
Alnus rubra
-
ALVIS
Alnus viridis ssp. sinuata
-
ARME
Arbutus menziesii
-
CADE3
Calocedrus decurrens
-
CHCH7
Chrysolepis chrysophylla
-
CONU4
Cornus nuttallii
-
FRPU7
Frangula purshiana
-
LAOC
Larix occidentalis
-
MAFU
Malus fusca
-
PIEN
Picea engelmannii
-
PISI
Picea sitchensis
-
PICO
Pinus contorta
-
PIJE
Pinus jeffreyi
-
PILA
Pinus lambertiana
-
PIMO3
Pinus monticola
-
PIPO
Pinus ponderosa
-
POBAT
Populus balsamifera ssp. trichocarpa
-
POTR5
Populus tremuloides
-
PRUNU
Prunus
-
PREM
Prunus emarginata
-
PSME
Pseudotsuga menziesii
-
QUGA4
Quercus garryana
-
QUKE
Quercus kelloggii
-
SASC
Salix scouleriana
-
TABR2
Taxus brevifolia
-
THPL
Thuja plicata
-
TSHE
Tsuga heterophylla
-
TSME
Tsuga mertensiana
-
CANO9
Callitropsis nootkatensis
-
SEGI
Sequoiadendron giganteum
YEAR - numeric(4,0) (interval)
ID: TV01004.YEAR
Year of establishment, remeasurement, or mortality
Type system: Microsoft SQL Server 2019
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1910.0000 (exclusive=false), max=2050.0000 (exclusive=false)
DBH - numeric(6,1) (ratio)
ID: TV01004.DBH
Tree diameter at breast height (1.37 m)
Type system: Microsoft SQL Server 2019
Unit: centimeters
Precision: 0.100000
Numeric domain: type=real, min=0.5000 (exclusive=false), max=800.0000 (exclusive=false)
SLOPEDIST - numeric(5,2) (ratio)
ID: TV01004.SLOPEDIST
Horizontal distance from measuring point to tree
Type system: Microsoft SQL Server 2019
Unit: meters
Precision: 0.010000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=63.1000 (exclusive=false)
ANBASE - numeric(4,0) (ratio)
ID: TV01004.ANBASE
Angle to base of tree
Type system: Microsoft SQL Server 2019
Unit: percent
Precision: 1.000000
Numeric domain: type=integer, min=-88.0000 (exclusive=false), max=64.0000 (exclusive=false)
ANCRBASE - numeric(4,0) (ratio)
ID: TV01004.ANCRBASE
Angle to base of tree crown
Type system: Microsoft SQL Server 2019
Unit: percent
Precision: 1.000000
Numeric domain: type=integer, min=-71.0000 (exclusive=false), max=84.0000 (exclusive=false)
ANTOP - numeric(4,0) (ratio)
ID: TV01004.ANTOP
Angle to top of tree
Type system: Microsoft SQL Server 2019
Unit: percent
Precision: 1.000000
Numeric domain: type=integer, min=-37.0000 (exclusive=false), max=134.0000 (exclusive=false)
ADDHT - numeric(5,2) (ratio)
ID: TV01004.ADDHT
Additional height if base of tree not visible
Type system: Microsoft SQL Server 2019
Unit: meters
Precision: 0.010000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=7.3000 (exclusive=false)
HEIGHT - numeric(6,1) (ratio)
ID: TV01004.HEIGHT
Tree height
Type system: Microsoft SQL Server 2019
Unit: meters
Precision: 0.100000
Numeric domain: type=real, min=1.3000 (exclusive=false), max=275.3000 (exclusive=false)
CRBASEHT - numeric(6,1) (ratio)
ID: TV01004.CRBASEHT
Height to base of crown
Type system: Microsoft SQL Server 2019
Unit: meters
Precision: 0.100000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=4041.0000 (exclusive=false)
BROKEN - char(1) (nominal)
ID: TV01004.BROKEN
Was top broken?
Type system: Microsoft SQL Server 2019
Code definitions (2)
-
N
TREE NORMAL (BLANK)
-
B
TREE WITH BROKEN TOP
SAMPLEDATE - datetime (dateTime)
ID: TV01004.SAMPLEDATE
Date of remeasurement (day of month was not always tracked; in these cases the 1st of each month is assigned)
Type system: Microsoft SQL Server 2019
Date format: YYYY-MM-DD
COMMENTS - varchar(110) (nominal)
ID: TV01004.COMMENTS
General comments about the measurement
Type system: Microsoft SQL Server 2019
Units
| degrees angle | deg angle | angle | degree | radian | 0.0174532924 | 360 degrees comprise a unit circle; degrees used for angle and slope |
| square meters | m2 | area | meterSquared | meterSquared | 1 | square meters |
| centimeters | cm | length | centimeter | meter | 0.01 | centimeters; .01 meters |
| number of years | years | time | nominalYear | second | 31536000 | one year excluding leap seconds and leap days, 31536000 seconds (often used for age in years) |
| hectares | ha | area | hectare | meterSquared | 10000 | hectares; 1 hectare is 10^4 square meters |
| decimal degrees latitude or longitude | deg dec lat-lon | latitudeLongitude | decimalDegree | unknown | N/A | decimal degrees; latitude (parallel) or longitude (meridian) |
| degrees latitude or longitude | deg lat-lon | latitudeLongitude | degree | unknown | N/A | degrees; latitude (parallel) or longitude (meridian) |
| minutes of a degree | minutes | latitudeLongitude | degreeMinute | unknown | N/A | the sixtieth part of a degree |
| seconds of a degree | seconds | latitudeLongitude | degreeSecond | unknown | N/A | number of seconds (sixtieth part of a minute of a degree) |
| meters | m | length | meter | meter | 1 | meter; SI unit of length |
| inches | in | length | inch | meter | 0.0254 | inches; an imperial measure of length |
| month of year | month | datetime | MM | YYYY-MM-DDThh:mm:ss | N/A | month of year (MM) |
| number | number | dimensionless | number | dimensionless | 1 | dimensionless number, i.e., ratio, count |
| year (yyyy) | YYYY | datetime | YYYY | YYYY-MM-DDThh:mm:ss | N/A | year (4 character) portion of date |
| square meters per hectare | m2/ha | areaPerArea | meterSquaredPerHectare | meterSquaredPerMeterSquared | .0001 | square meters per hectare |
| cubic meters per hectare | m3/ha | volumetricArea | meterCubedPerHectare | meterCubedPerMeterSquared | 0.0001 | cubic meters per hectare |
| megagrams per hectare per year | megag/ha*year | massFlux | megagramPerHectarePerYear | kilogramPerMeterSquaredPerSecond | 0.00000000316887646 | Megagrams per hectare per year |
| megagrams per hectare | megag/ha | arealMassDensity | megagramPerHectare | kilogramPerMeterSquared | 0.1 | megagrams per hectare |
| number per hectare | number/ha | arealDensity | numberPerHectare | numberPerMeterSquared | 0.0001 | number or count per hectare |
| percent | % | dimensionless | number | dimensionless | 100 | percent; a number |
Intellectual Rights
Data Use Agreement:
The re-use of scientific data has the potential to greatly increase communication, collaboration and synthesis within and among disciplines, and thus is fostered, supported and encouraged. This Data Set is released under the Creative Commons license CC BY "Attribution" (see: https://creativecommons.org/licenses/by/4.0/). Creative Commons license CC BY - Attribution is a license that allows others to distribute, remix, tweak, and build upon your work (even commercially), as long as you are credited for the original creation. This license accommodates maximum dissemination and use of licensed materials.
It is considered professional conduct and an ethical obligation to acknowledge the work of other scientists. The Data User is asked to provide attribution of the original work if this data package is shared in whole or by individual parts or used in the derivation of other products. A recommended citation is provided for each Data Set in the Andrews LTER data catalog (see: http://andlter.forestry.oregonstate.edu/data/catalog/datacatalog.aspx). A generic citation is also provided for this Data Set on the website https://portal.edirepository.org in the summary metadata page. Data Users are thus strongly encouraged to consider consultation, collaboration and/or co-authorship with the Data Set Creator.
While substantial efforts are made to ensure the accuracy of data and associated documentation, complete accuracy of data sets cannot be guaranteed and all data are made available "as is." The Data User should be aware, however, that data are updated periodically and it is the responsibility of the Data User to check for new versions of the data. The data authors and the repository where these data were obtained shall not be liable for damages resulting from any use or misinterpretation of the data.
General acknowledgement: Data were provided by the HJ Andrews Experimental Forest research program, funded by the National Science Foundation's Long-Term Ecological Research Program (DEB 2025755), US Forest Service Pacific Northwest Research Station, and Oregon State University.
Licensed
License: Creative Commons Attribution 4.0 International Public License
Identifier: CC-BY-4.0
Maintenance
Maintenance update frequency: annually
Description
- An update history is logged and maintained with each new version of every dataset.
Change History
-
Version1 (1988-06-30) Original metadata creation.
-
Version2 (2001-08-14) Metadata restructured and moved into SQLServer metadata database LTERMETA. Data moved into SQLServer database FSDBDATA.
-
Version3 (2005-07-25) Non-critical update to force reharvest of EML for this study database. Addition of ACCESS code to EML and syntax updates
-
Version7 (2012-08-07) Major restructuring of TV010 Entities 1, 2, 3. Enity 1 is now initial conditions and Entity 2 is tree measurement data (entity numbers were swapped). Entity 3 is tree mortality. Entity 2 and 3 data are now stored in TP001 and TV010 Entityies 2&3 are now built by queries of TP001. TP001 will house master data for several FSDB studies including TV010, and will include a TREEID attribute that will be unique for each tree over all included FSDB studies. This version does not build the cache data file on-the-fly, but future versions will create cache files dynamically. Entity 2 and 3 data has been broadly checked and many fields corrected. Enumerated domains and attribute definitions have been better defined. Entity 1 (initial conditions) has also been modified but not completely rechecked.
-
Version8 (2015-03-19) New entity 2 and 3 versions includes cleaned data before 2010 and some 2010 data.
-
Version9 (2016-07-27) New entity 4 includes restructured atrributes to match changes to TP001.
-
Version11 (2017-04-17) New entity 2 and 3 version includes 2011, 2012, some 2013 data. Also updated entity 6.
-
Version12 (2018-05-21) New entity version includes 2013 data. Data have been QC'd using newrem and QC procedures and uploaded to SQL in TP001.
-
Version13 (2019-04-30) New entity version includes MRRS from 2017 and RS34 (mort) from 2018 data. Data have been QC'd using newrem and QC procedures and uploaded to SQL in TP001.
-
Version14 (2020-05-18) New entity 2 and 3 version includes 2014 measurement data. Also updated entity 6 for modified remeasurement dates.
-
Version15 (2020-08-11) New entity 2 and 3 version includes upload of data from some stands in 2015 and 2016. Also RS34 adn RS38 mort stands for 2018 and 2019.
-
Version16 (2021-04-19) New entity 2 and 3 versions. For update on 4/30/2019, 2017 MRRS data was not appended to SQL. These data are now appended.
-
Version17 (2021-06-15) New entity 2 and 3 versions include upload of data from some stands in 2015, 2016, and 2018. Also RS34 and RS38 mort stands for 2019 and 2020.
-
Version18 (2021-06-25) New entity 2 and 3 versions include upload of data from 2016 TCTR.
-
Version19 (2022-02-02) New entity 2 and 3 versions includes upload of data from 2019 MUNA and MUN2. Also added 2015 mortality records.
-
Version20 (2022-05-24) New entity 2 and 3 version includes upload of remaining stand data from 2015 collection (except NCNA). Also includes 2021 mortality check data for RS34 and full RS38 collection.
-
Version21 (2022-06-03) New entity 2 and 3 version includes upload of some stand data from 2016 collection. Includes a modification of species attribute from fsdb or garrison codes to usda plant codes.
-
Version23 (2023-04-21) New entity 2 and 3 version includes upload of more stand data from 2016 collection and 2022 annual mortality checks on RS34 and RS38.
-
Version24 (2023-06-22) New entity 2 and 3 version includes upload of remaining stand data from 2016 collection (except RS32). Also includes 2022 mortality check data for RS34 and full RS38 collection.
-
Version25 (2024-05-08) New entity 2 and 3 version includes upload of a selected number of stand data from 2017 collection (for sites within the Lookout fire boundary), RS32 from 2016 (2019 retagged). Also includes 2023 mortality check data for RS38 (RS34 was not measured in 2023 due to the Lookout fire).
-
Version26 (2024-06-05) New entity 2 and 3 version includes upload of final stand data from 2018 collection, which included S. Fork Hoh stands (HR01, HR02, HR03, HR04).
-
Version27 (2025-05-27) New entity 2 and 3 version includes upload of final stand data from 2019 collection.
-
Version28 (2025-06-04) Fixed a few issues with trees in RS03, RS21, RS27, RS34, and HS03 for entities 2 and 3. Reuploaded data to SQL.