TW003: Sap flow measurements to estimate overstory water use in Watersheds 1 and 2, Andrews Experimental Forest, 1999-2002
Notice
"As Is" Basis: All content, including maps and forecasts, is provided without warranties. Users are advised to independently verify critical information.
Citation
Bond, B.; Moore, G. 2011. Sap flow measurements to estimate overstory water use in Watersheds 1 and 2, Andrews Experimental Forest, 1999-2002 Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/TW003 Accessed 2026-05-10.
Abstract
This study investigates how differences in tree age, stand structure and species composition between an old and young Douglas-fir/western hemlock forest impacts overstory transpiration. We measured sap flow (using constant-heat thermal dissipation sensors in g/m) during the growing season in samples of trees in Watershed 1 (harvested in the 1960's) and Watershed 2 (last major disturbance approximately 450 ybp) at the HJ Andrews Forest in the Western Cascades of Oregon. The trees selected for these measurements differ somewhat each year but all are PSME. Sap flow was scaled to the whole tree level (per unit sapwood area) from measurements in outer and inner portions of the sapwood. We also surveyed vegetation in plots arrayed along transects in a 100 m swath centered on the streambed in each watershed, determining the species composition as well as the basal area (m/ha) and sapwood basal area by species (m/ha) . From the sap flow measurements in the sampled trees and the vegetation surveys, we estimated overstory water use within the 100 m swath. Data collection occurred between 1999-2002 and is now complete.
Coverage
Temporal coverage: 1999-06-01 to 2002-09-30
Geographic coverage: Andrews Experimental Forest; Watershed 1, Watershed 2, Replacement Series Plots (L404, L405)
Spatial coverage:
Bounds: W -122.25683100, E -122.19122322, N 44.25702372, S 44.19901700
Purpose
- The long-term of this project is to better understand how vegetation age, structure, and species composition affects hydrological patterns in small watersheds at the H.J. Andrews Experimental Forest. We found that differences in water use per unit sapwood area, sapwood area density, and species composition between the old and young forests all result in greater water use by the overstory trees in the younger forest. This may explain some observed differences in stream runoff among forested watersheds and provides some insight into the implications for forest management on water resources.
Project
Title: Long-Term Ecological Research
Personnel
-
Sherri L. Johnson - Principal Investigator US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USAPhone: 541-758-7771Email: sherri.johnson2@usda.gov, sherri.johnson@oregonstate.edu
-
Julia A. Jones - Principal Investigator Oregon State University;Department of Geosciences; Wilkinson Hall 104, Corvallis, OR, 97331-5506, USAPhone: (541) 737-1224Email: Julia.Jones@oregonstate.edu, geojulia@comcast.netORCID: http://orcid.org/0000-0001-9429-8925
-
Matthew G Betts - Principal Investigator Department of Forest Ecosystems and Society; 201E Richardson Hall; College of Forestry; Oregon State University, Corvallis, OR, 97331Phone: (541) 737-3841Email: matt.betts@oregonstate.edu
-
Michael P. Nelson - Principal Investigator Department of Forest Ecosystems and Society; 201K Richarson Hall; College of Forestry; Oregon State University, Corvallis, OR, 97331Phone: 541-737-9221Email: mpnelson@oregonstate.eduORCID: http://orcid.org/0000-0001-6917-4752
-
David Bell - Principal Investigator Email: david.bell@usda.gov, david.bell@oregonstate.edu
Abstract
- The H.J. Andrews Experimental Forest is a living laboratory that provides unparalleled opportunities for the study of forest and stream ecosystems in the central Cascade Range of Oregon. Since 1980, as a part of the National Science Foundation Long Term Ecological Research (NSF-LTER) program, the Andrews Experimental Forest has become a leader in the analysis of forest and stream ecosystem dynamics.
- Long-term field experiments and measurement programs have focused on climate dynamics, streamflow, water quality, and vegetation succession. Currently researchers are working to develop concepts and tools needed to predict effects of natural disturbance, land use, and climate change on ecosystem structure, function, and species composition.
- The Andrews Experimental Forest is administered cooperatively by the USDA Forest Service Pacific Northwest Research Station, Oregon State University and the Willamette National Forest. Funding for the research program comes from the National Science Foundation (NSF), US Forest Service Pacific Northwest Research Station, Oregon State University, and other sources.
Funding
Data were provided by the HJ Andrews Experimental Forest research program, funded by the National Science Foundation's Long-Term Ecological Research Program (DEB 2025755), US Forest Service Pacific Northwest Research Station, and Oregon State University. National Science Foundation: DEB1440409
Study Area Description
-
Long-Term Ecological Research The Andrews Forest is situated in the western Cascade Range of Oregon, and covers the entire 15,800-acre (6400-ha) drainage basin of Lookout Creek. Elevation ranges from 1350 to 5340 feet (410 to 1630 m). Broadly representative of the rugged mountainous landscape of the Pacific Northwest, the Andrews Forest contains excellent examples of the region's conifer forests and associated wildlife and stream ecosystems. These forests are among the tallest and most productive in the world, with tree heights of often greater than 250 ft (75 m). Streams are steep, cold and clean, providing habitat for numerous aquatic organisms.
Associated Party
-
Barbara J Bond
Role: Principal InvestigatorOregon State University;Dept. of Forest Science;330 Richardson Hall, Corvallis, OR, 97331, USAPhone: (541) 737-6110, (541) 908-2515Email: barbara.bond@oregonstate.edu
-
Barbara J Bond
Role: CreatorOregon State University;Dept. of Forest Science;330 Richardson Hall, Corvallis, OR, 97331, USAPhone: (541) 737-6110, (541) 908-2515Email: barbara.bond@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
-
David A. Post
Role: Other ResearcherCSIRO Land and Water;Davies Laboratory;PMB PO Aitkenvale, Aitkenvale, QLD, 4814, AustraliaPhone: +61-7-4753-8605Email: posty_67@yahoo.com.au
-
Georgianne W. Moore
Role: AbstractorTexas A&M University; Horticulture Forest Science Building, College Station, TX, 77843, USAPhone: 979/845-3765Email: gwmoore@tamu.edu
-
Georgianne W. Moore
Role: CreatorTexas A&M University; Horticulture Forest Science Building, College Station, TX, 77843, USAPhone: 979/845-3765Email: gwmoore@tamu.edu
-
Nathan Phillips
Role: Other ResearcherEmail: nathan@bu.edu
Contact
-
Information Manager
Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331Email: hjaweb@fsl.orst.edu
-
Barbara J Bond
Oregon State University;Dept. of Forest Science;330 Richardson Hall, Corvallis, OR, 97331, USAPhone: (541) 737-6110, (541) 908-2515Email: barbara.bond@oregonstate.edu
-
Georgianne W. Moore
Texas A&M University; Horticulture Forest Science Building, College Station, TX, 77843, USAPhone: 979/845-3765Email: gwmoore@tamu.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@fsl.orst.edu
Study Description
This study investigates how differences in tree age, stand structure and species composition between an old and young Douglas-fir/western hemlock forest impacts overstory transpiration. We measured sap flow (using constant-heat thermal dissipation sensors in g/m) during the growing season in samples of trees in Watershed 1 (harvested in the 1960's) and Watershed 2 (last major disturbance approximately 450 ybp) at the HJ Andrews Forest in the Western Cascades of Oregon. The trees selected for these measurements differ somewhat each year but all are PSME. Sap flow was scaled to the whole tree level (per unit sapwood area) from measurements in outer and inner portions of the sapwood. We also surveyed vegetation in plots arrayed along transects in a 100 m swath centered on the streambed in each watershed, determining the species composition as well as the basal area (m/ha) and sapwood basal area by species (m/ha) . From the sap flow measurements in the sampled trees and the vegetation surveys, we estimated overstory water use within the 100 m swath. Data collection occurred between 1999-2002 and is now complete. The long-term of this project is to better understand how vegetation age, structure, and species composition affects hydrological patterns in small watersheds at the H.J. Andrews Experimental Forest. We found that differences in water use per unit sapwood area, sapwood area density, and species composition between the old and young forests all result in greater water use by the overstory trees in the younger forest. This may explain some observed differences in stream runoff among forested watersheds and provides some insight into the implications for forest management on water resources. Field Methods - TW003
Purpose: The long-term of this project is to better understand how vegetation age, structure, and species composition affects hydrological patterns in small watersheds at the H.J. Andrews Experimental Forest. We found that differences in water use per unit sapwood area, sapwood area density, and species composition between the old and young forests all result in greater water use by the overstory trees in the younger forest. This may explain some observed differences in stream runoff among forested watersheds and provides some insight into the implications for forest management on water resources.
Methods
Method Steps
Field Methods - TW003
- Sapflow
- Transpiration is measured at 30-second intervals and averaged every 20 minutes with constant heat sapflow sensors (Granier 1996) installed in 5 to 7 trees of each species/age-class, with at least three sensors per tree (more details on sensor positions is provided below). These trees were cored with an increment borer to determine sapwood depth. It is critical to note that the power requirements for sapflow measurements preclude a good random sample of trees throughout the watersheds. Instead, the sample trees lie in a cluster near the base of the watersheds and thus the data to date are unavoidably biased due to the sampling design. In WS1 trees lie along two "transects", one each of alder and Doug-fir, just above the weir. These run normal to the stream through a pocket of each vegetation type up the southern (north facing) slope. The transects are 50m long, and 7 trees were selected along the transect at roughly equal intervals. Due to limitations of power and equipment, we measured red alder only in 1999; in subsequent years we estimated sap flux in red alder based on relationships between red alder and Douglas-fir in 1999. We began measurements in WS2 in 2000. In WS2 we selected 5 Douglas-fir and 3 western hemlock (all overstory trees) in a transect on the N side of the stream about 50m below the weir.
- The maximum potential effect on sap flow estimates due to background temperature fluctuations (insert citation) was evaluated and found to be detectable yet minimal. Based on measurements taken of background temperature fluctuations during six warm, sunny days in July, we found that sap flow may be underestimated by 3.7+/-0.5% and 0.2+/-0.5% per day in young and old Douglas-fir respectively, and overestimated by 6.0+/-1.1% in hemlock during the month of July.
- Sap flux density for each individual sensor over each 20 minute period was determined from temperature differentials using equations in Granier (1987). These measurements were scaled to the whole-tree and species level generally using the procedures described in Phillips et al. 2002. In red alder we installed sensors at three depths (0-20 cm, 20-40 cm and 40-60 cm) in five trees and we determined the average gradient in sapflow from the outer to inner sapwood. Using this gradient we "scaled" outer flux measurements in the other trees to a whole tree basis, and then divided by the total sapwood area of that tree to come up with the average sap flux density. In Douglas-fir and western hemlock we installed most sensors at a depth of 0-20 cm, but we also installed sensors at 20-40 cm in 4 of the old-growth trees. We combined information from these four trees with sap flux measurements from Douglas-fir at Wind River to analyze how radial gradients in sap flow are affected by site, tree age and seasonal variation. From this analysis we developed a predictive relationship to estimate radial variation based on measurements in the outer 2 cm of the sapwood, and we then used these relationships to estimate whole-tree sap flow over 20 min intervals for each measurement tree. For hemlock we took advantage of radial measurements of sapflow by F.R. Meinzer at Wind River. Meinzer's data show that sapflow declines linearly from the outer edge of sapwood to the sapwood/heartwood boundary. We used this relationship to estimate whole tree sapflow from measurements in the outer 2 cm in hemlock. We found no difference in whole-tree sap flux density for any species or size/age class as a function of distance from the stream, so we averaged the data (for each time increment) over the total number of sample trees to develop the mean sapflux density for measurement period for each species/size class. We multiplied this value for red alder by the sapwood basal area of hardwoods in WS1 to estimate hardwood transpiration. We multiplied this value by the sapwood basal area of all conifers (which is >95% Douglas-fir) to estimate conifer transpiration in WS1. We multiplied the valued for old hemlock and Douglas-fir, respectively, by the sapwood basal areas of these species in WS2 (which account for >95% of the sapwood basal area of all trees in this watershed) to estimate transpiration in WS2. The sap fluxes over 20 min intervals were summed to obtain daily sap fluxes.
- 2001-2002: "Select 7 Douglas-fir and 7 red alder in a ~70 m transect perpendicular to the stream at the base of WS1. Select 5 Douglas-fir and 3 western hemlock in a ~70 m transect perpendicular to the stream at the base of WS2.
- For replacement series plots, select 8 trees (4 Douglas-fir and 4 red alder in mixed plots) in each of 8 plots (4 at each site) for a total of 64 trees (and 64 sensors)." Install 2 sensors per tree in WS1 in the outer xylem at approximately 1 m above the ground at a depth of 0-20 mm. Install 1 sensor per tree in WS1 in the inner xylem at approximately 1 m above the ground at a depth of 20-40 mm. Install up to 3 sensors per tree in WS2 in the outer xylem at approximately 5 m above the ground at a depth of 0-20 mm. Install up to 2 sensor per tree in WS2 in the inner xylem at approximately 5 m above the ground at a depth of 20-40 mm. For replacement series plots, install 1 sensor per tree at approximately 0.5 m above the ground (below the first live branch) to a depth of 0-20 mm.
- Follow methods for calculating sap flux from A. Granier (1987). For radial profiles, use the methods of N. Phillips (2002) in Douglas-fir. Use radial profile from 4 red alders in WS1 for alder. Assume all red alders are 100% sapwood (no heartwood).
- Measure basal areas on every tree over 1 cm diameter in transects perpendicular to the stream on both sides of the stream in WS1 and WS2. In WS1, transects composed of five 10x10 meter plots alternating sides of stream every 200 meters for a total of 7 transects. In WS2, transects composed of 3 20x20 meter plots on both sides of the main stream every 200 meters for a total of 3 transects. Measure sapwood depth, bark depth, and heights on 5 of each species in each plot. Basal areas were measured using diameter tapes at breast height. Sapwood depths and bark depths were measured at breast height with and increment borer and by visually inspecting the oore for lenth of "wet" xylem. Heights were measured with a laser altimeter. Additional measurements were taken in each plot of slope aspect and angle, using a compass and laser altimeter, respectively. Species too small to be cored (~less than 5 cm DBH) were assumed to be 100% sapwood at breast height.
- In many cases, individual sensors were not functional over periods of several days. Because of the small sample sizes, dropping these individuals from the overall mean could result in large artifacts in the time-series data. Therefore, we interpolated to fill "missing" data based on relationships among the sensors when all functioned properly.
- Vegetation surveys were conducted in 1999 in WS1 and 2000 in WS2 to quantify the species composition and basal sapwood area of all woody vegetation >1 cm diameter in the riparian zones (arbitrarily defined as 100 m swath centered on the stream bed) of the two watersheds. In each WS, we established transects normal to the stream every 200 m upstream from the weir. The transects alternated from one side of the stream to the other. Along each transect we established contiguous square plots - in WS1 there were five 10m-square plots and in WS2 there were three 20m-square plots on each transect (plot dimensions were determined for the horizontal plane - i.e., they were slope-corrected). Within each plot we measured the diameter and species of every tree greater than 1 cm diameter as well as height and sapwood depth of 5 trees of each species in the plot, systematically selected to represent the size distribution in that plot. From the sample of trees used for measurements of height and sapwood depth, we developed species-specific regression equations to predict sapwood area from DBH outside the bark. Cover (by percent area) estimates of shrubs and herbaceous species were made using the line intercept technique from a diagonal transect running from the SW to the NE corners of the plots, with species identified when possible.
- Integrated volumetric water content of the top 0.30 m of the soil was measured hourly using 4 water content reflectometers (Campbell Scientific, Logan, UT) distributed evenly within the sap flow transect of WS2.
- Time domain reflectometry measurements (Tektronix 1502C, Gray and Spies 1995) integrated over the top 0.45 m were taken approximately once every 2 weeks at 16 locations throughout the sap flow transects of WS1 and WS2.
Processing Procedure - TW003
- Follow methods for calculating sap flux from A. Granier (1987)
- Methodology Instrumentation: constant heat sapflow sensors Methodology Algorithm/Statistics:,,, name, sapflow
- Description, converts millivolt sapflow sensor output to sapflux per unit sapwood area (millimeters per second) by:
- K=(dT(m)-dT)/(dt)
- u=0.119 * K^1.231
- F=u*S
- dT(m) and dT are the temperature differences between the two probes
- S = the cross sectional area of the sapwood at the location of the heated probe (in square meters)
- F = the total sap flow in millimeters per second
Sampling
Study Extent
- Sampling frequency: annual
Sampling Description
- Select 7 Douglas-fir and 7 red alder in a ~70 m transect perpendicular to the stream at the base of WS1. Select 5 Douglas-fir and 3 western hemlock in a ~70 m transect perpendicular to the stream at the base of WS2. Install 2 sensors per tree in WS1 in the outer xylem at approximately 1 m above the ground at a depth of 0-20 mm. Install 1 sensor per tree in WS1 in the inner xylem at approximately 1 m above the ground at a depth of 20-40 mm. Install up to 3 sensors per tree in WS2 in the outer xylem at approximately 5 m above the ground at a depth of 0-20 mm. Install up to 2 sensor per tree in WS2 in the inner xylem at approximately 5 m above the ground at a depth of 20-40 mm
- For replacement series plots, select 8 trees (4 Douglas-fir and 4 red alder in mixed plots) in each of 8 plots (4 at each site) for a total of 64 trees (and 64 sensors).
Spatial Sampling Units
-
Andrews Watershed 1
W -122.25683100, E -122.23581300, N 44.20851700, S 44.19901700Altitude: 1027 to 1027 meter
-
Andrews Watershed 2
W -122.24397600, E -122.22974100, N 44.21338500, S 44.20617800Altitude: 1079 to 1079 meter
-
UNIT L405
W -122.19824144, E -122.19122322, N 44.25702372, S 44.25284439Altitude: 879 to 879 meter
-
UNIT L404
W -122.19891567, E -122.19212205, N 44.25007353, S 44.24364806Altitude: 812 to 812 meter
Software
No software entries listed in this EML file.
Keywords
- LTER controlled vocabulary: droughts (theme), sapwood area (theme), water content (theme), soil moisture (theme), primary production (theme), hydrologic processes (theme), old growth forests (theme), vegetation (theme)
- Andrews Experimental Forest site thesaurus: Long-Term Ecological Research (LTER) (theme), riparian ecosystems (theme), moisture stress (theme)
- LTER core research areas: primary production (theme)
Taxonomic Hierarchy
- All Organisms: All Organisms
- Highest common category (ca. kingdom): Plantae
- Division or Phylum: Magnoliophyta
- Class: Magnoliopsida
- Subclass: Hamamelididae
- Order: Fagales
- Family: Fagaceae
- Genus: Chrysolepis
- Species: Castanopsis chrysophylla
- Family: Betulaceae
- Genus: Alnus
- Species: Alnus rubra
- Genus: Corylus
- Species: Corylus cornuta var. californica
- 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 circinatum
- Species: Acer macrophyllum
- Order: Rosales
- Family: Rosaceae
- Genus: Prunus
- Species: Prunus emarginata
- Genus: Holodiscus
- Species: Holodiscus discolor
- Genus: Amelanchier
- Species: Amelanchier alnifolia
- Subclass: Dilleniidae
- Order: Salicales
- Family: Salicaceae
- Genus: Populus
- Species: Populus trichocarpa
- Order: Ericales
- Family: Ericaceae
- Genus: Rhododendron
- Species: Rhododendron macrophyllum
- Genus: Vaccinium
- Species: Vaccinium parvifolium
- Division or Phylum: Coniferophyta
- Class: Pinopsida
- Order: Taxales
- Family: Taxaceae
- Genus: Taxus
- Species: Taxus brevifolia
- Order: Pinales
- Family: Pinaceae
- Genus: Tsuga
- Species: Tsuga heterophylla
- Genus: Pseudotsuga
- Species: Pseudotsuga menziesii
- Family: Cupressaceae
- Genus: Thuja
- Species: Thuja plicata
Data Entities
| # | Entity | Metadata | Data |
|---|---|---|---|
| 1 |
TW00301
TW00301 Sapflow 1999-2000: |
METADATA | DATA |
| 2 |
TW00302
TW00302 Time domain reflectometry (soil moisture) data: |
METADATA | DATA |
| 3 |
TW00303
TW00303 Water content reflectometer (soil moisture) data: |
METADATA | DATA |
| 4 |
TW00304
TW00304 Riparian vegetation survey: |
METADATA | DATA |
| 5 |
TW00305
TW00305 Sapflow 2001 - 2002: This file consists of sap flow data from the upper and lower replacement series plots for the period from April 2001 through August 2002. Note that all data after day 117 of 2002 are corrected for sensor degradation (see Ch.3 of dissertation Moore 2003). |
METADATA | DATA |
| 6 |
TW00306
TW00306 Time domain reflectometry (soil moisture) data, 2001 - 2002: This file consists of time domain reflectometry (soil moisture) data from the upper and lower replacement series sites for the period from May 2001 through July 2002 |
METADATA | DATA |
| 7 |
TW00307
TW00307 Vegetation Survey 2002: This file consists of vegetation survey data from the upper and lower replacement series sites taken in summer 2002. |
METADATA | DATA |
Metadata
TW00301 - TW00301
Object name: TW00301.csv
Records: 583
Attributes: 7
File size: 23268 byte
Checksum (MD5): f174e8e02fa0c0f90b661916ace7ac9f
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TW00301.DAY, TW00301.SITE, TW00301.SPECIES, TW00301.YEAR
-
notNullConstraint: NOTNULL TW00301.DAY, TW00301.SITE, TW00301.SPECIES, TW00301.YEAR, TW00301.DBCODE, TW00301.ENTITY
Attributes (7)
DBCODE - char(5) (nominal)
ID: TW00301.DBCODE
Database code
Type system: Microsoft SQL Server 2008
Code definitions (1)
-
TW003
FSDB Database Code TW003
ENTITY - numeric(1,0) (interval)
ID: TW00301.ENTITY
Entity number
Type system: Microsoft SQL Server 2008
Unit: number
Precision: 1
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=1.0000 (exclusive=false)
SITE - char(10) (nominal)
ID: TW00301.SITE
Site code (WS1, WS2)
Type system: Microsoft SQL Server 2008
Code definitions (2)
-
WS01
Andrews Watershed 1
-
WS02
Andrews Watershed 2
YEAR - numeric(4,0) (dateTime)
ID: TW00301.YEAR
Year of measurement
Type system: Microsoft SQL Server 2008
Date format: YYYY
DAY - numeric(3,0) (dateTime)
ID: TW00301.DAY
Julian day of measurement
Type system: Microsoft SQL Server 2008
Date format: julian day
SPECIES - char(5) (nominal)
ID: TW00301.SPECIES
Tree species code
Type system: Microsoft SQL Server 2008
Code definitions (17)
-
ACCI
Acer circinatum
-
ACMA
Acer macrophyllum
-
ALRU
Alnus rubra
-
AMAL
Amelanchier alnifolia
-
CONU
Cornus nuttallii
-
COCOC
Corylus cornuta var. californica
-
HODI
Holodiscus discolor
-
POTR2
Populus trichocarpa
-
PREM
Prunus emarginata
-
PSME
Pseudotsuga menziesii
-
RHPU
Rhamnus purshiana
-
RHMA
Rhododendron macrophyllum
-
TABR
Taxus brevifolia
-
THPL
Thuja plicata
-
TSHE
Tsuga heterophylla
-
VAPA
Vaccinium parvifolium
-
CACH
Castanopsis chrysophylla
SAPFLOW - numeric(12,2) (ratio)
ID: TW00301.SAPFLOW
Daily total sapflow data averaged for all sensors (sapwood area basis)
Type system: Microsoft SQL Server 2008
Unit: grams per square meter per day
Precision: 0.010000
Numeric domain: type=real, min=9000.0000 (exclusive=false), max=2000000.0000 (exclusive=false)
TW00302 - TW00302
Object name: TW00302.csv
Records: 309
Attributes: 7
File size: 10632 byte
Checksum (MD5): 9e8e863ac36e578e49cee6f2c8c46a1a
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TW00302.DAY, TW00302.ROD_LOCATN, TW00302.YEAR
-
notNullConstraint: NOTNULL TW00302.DAY, TW00302.ROD_LOCATN, TW00302.VOL_WATER_T, TW00302.YEAR, TW00302.DBCODE, TW00302.ENTITY
Attributes (7)
DBCODE - char(5) (nominal)
ID: TW00302.DBCODE
Database code
Type system: Microsoft SQL Server 2008
Code definitions (1)
-
TW003
FSDB Database Code TW003
ENTITY - numeric(1,0) (interval)
ID: TW00302.ENTITY
Entity number
Type system: Microsoft SQL Server 2008
Unit: number
Precision: 1
Numeric domain: type=natural, min=2.0000 (exclusive=false), max=2.0000 (exclusive=false)
ROD_LOCATN - char(5) (nominal)
ID: TW00302.ROD_LOCATN
Site code (WS1, WS2)
Type system: Microsoft SQL Server 2008
Code definitions (48)
-
a1t1
Ws1 adj. 1999 douglas-fir sapflow tree 1 tdr 1, installed vertically to 45 cm
-
a1t2
Ws1 adj. 1999 douglas-fir sapflow tree 2 tdr 1, installed vertically to 45 cm
-
a1t3
Ws1 adj. 1999 douglas-fir sapflow tree 3 tdr 1, installed vertically to 45 cm
-
a1t4
Ws1 adj. 1999 douglas-fir sapflow tree 4 tdr 1, installed vertically to 45 cm
-
a1t5
Ws1 adj. 1999 douglas-fir sapflow tree 5 tdr 1, installed vertically to 45 cm
-
a1t6
Ws1 adj. 1999 douglas-fir sapflow tree 6 tdr 1, installed vertically to 45 cm
-
a1t7
Ws1 adj. 1999 douglas-fir sapflow tree 7 tdr 1, installed vertically to 45 cm
-
a2t1
Ws1 adj. 1999 douglas-fir sapflow tree 1 tdr 2, installed vertically to 45 cm
-
a2t2
Ws1 adj. 1999 douglas-fir sapflow tree 2 tdr 2, installed vertically to 45 cm
-
a2t3
Ws1 adj. 1999 douglas-fir sapflow tree 3 tdr 2, installed vertically to 45 cm
-
a2t4
Ws1 adj. 1999 douglas-fir sapflow tree 4 tdr 2, installed vertically to 45 cm
-
a2t5
Ws1 adj. 1999 douglas-fir sapflow tree 5 tdr 2, installed vertically to 45 cm
-
a2t6
Ws1 adj. 1999 douglas-fir sapflow tree 6 tdr 2, installed vertically to 45 cm
-
a2t7
Ws1 adj. 1999 douglas-fir sapflow tree 7 tdr 2, installed vertically to 45 cm
-
b1d1
Ws2 adj douglas-fir sapflow tree 1 tdr 1, installed vertically to 45 cm
-
b1d2
Ws2 adj douglas-fir sapflow tree 2 tdr 1, installed vertically to 45 cm
-
b1d3
Ws2 adj douglas-fir sapflow tree 3 tdr 1, installed vertically to 45 cm
-
b1d4
Ws2 adj douglas-fir sapflow tree 4 tdr 1, installed vertically to 45 cm
-
b1d5
Ws2 adj douglas-fir sapflow tree 5 tdr 1, installed vertically to 45 cm
-
b1h1
Ws2 adj hemlock sapflow tree 1 tdr 1, installed vertically to 45 cm
-
b1h2
Ws2 adj hemlock sapflow tree 2 tdr 1, installed vertically to 45 cm
-
b1h3
Ws2 adj hemlock sapflow tree 3 tdr 1, installed vertically to 45 cm
-
b2d1
Ws2 adj douglas-fir sapflow tree 1 tdr 2, installed vertically to 45 cm
-
b2d2
Ws2 adj douglas-fir sapflow tree 2 tdr 2, installed vertically to 45 cm
-
b2d3
Ws2 adj douglas-fir sapflow tree 3 tdr 2, installed vertically to 45 cm
-
b2d4
Ws2 adj douglas-fir sapflow tree 4 tdr 2, installed vertically to 45 cm
-
b2d5
Ws2 adj douglas-fir sapflow tree 5 tdr 2, installed vertically to 45 cm
-
b2h1
Ws2 adj hemlock sapflow tree 1 tdr 2, installed vertically to 45 cm
-
b2h2
Ws2 adj hemlock sapflow tree 2 tdr 2, installed vertically to 45 cm
-
b2h3
Ws2 adj hemlock sapflow tree 3 tdr 2, installed vertically to 45 cm
-
n1
Ws2 on opposite slope from sapflow transect, north side, near stream, installed vertically to 45 cm
-
n10
Ws2 on opposite slope from sapflow transect, north side, 45m from stream, installed vertically to 45 cm
-
n2
Ws2 on opposite slope from sapflow transect, north side, 5m from stream, installed vertically to 45 cm
-
n3
Ws2 on opposite slope from sapflow transect, north side, 10m from stream, installed vertically to 45 cm
-
n4
Ws2 on opposite slope from sapflow transect, north side,15m from stream, installed vertically to 45 cm
-
n5
Ws2 on opposite slope from sapflow transect, north side, 20m from stream, installed vertically to 45 cm
-
n6
Ws2 on opposite slope from sapflow transect, north side, 25m from stream, installed vertically to 45 cm
-
n7
Ws2 on opposite slope from sapflow transect, north side, 30m from stream, installed vertically to 45 cm
-
n8
Ws2 on opposite slope from sapflow transect, north side, 35m from stream, installed vertically to 45 cm
-
n9
Ws2 on opposite slope from sapflow transect, north side, 40m from stream, installed vertically to 45 cm
-
s1
Ws1 on opposite slope from sapflow transect, south side, near stream, installed vertically to 45 cm
-
s2
Ws1 on opposite slope from sapflow transect, south side, 5m from stream, installed vertically to 45 cm
-
s3
Ws1 on opposite slope from sapflow transect, south side, 10m from stream, installed vertically to 45 cm
-
s4
Ws1 on opposite slope from sapflow transect, south side,15m from stream, installed vertically to 45 cm
-
s5
Ws1 on opposite slope from sapflow transect, south side, 20m from stream, installed vertically to 45 cm
-
s6
Ws1 on opposite slope from sapflow transect, south side, 25m from stream, installed vertically to 45 cm
-
s7
Ws1 on opposite slope from sapflow transect, south side, 30m from stream, installed vertically to 45 cm
-
s8
Ws1 on opposite slope from sapflow transect, south side, 35m from stream, installed vertically to 45 cm
YEAR - numeric(4,0) (dateTime)
ID: TW00302.YEAR
Year of measurement
Type system: Microsoft SQL Server 2008
Date format: YYYY
DAY - numeric(3,0) (dateTime)
ID: TW00302.DAY
Julian day of measurement
Type system: Microsoft SQL Server 2008
Date format: julian day
VOL_WATER_T - numeric(5,2) (ratio)
ID: TW00302.VOL_WATER_T
Volumetric soil water content (time domain reflectometry)
Type system: Microsoft SQL Server 2008
Unit: percent
Precision: 0.010000
Numeric domain: type=real, min=5.0000 (exclusive=false), max=50.0000 (exclusive=false)
NOTES - varchar(50) (nominal)
ID: TW00302.NOTES
Notes
Type system: Microsoft SQL Server 2008
TW00303 - TW00303
Object name: TW00303.csv
Records: 10826
Attributes: 7
File size: 465213 byte
Checksum (MD5): 6c8efdcb7b13bbc4e1fcaa581a3bf584
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TW00303.FRACT_DAY, TW00303.POSITION, TW00303.SITE, TW00303.YEAR
-
notNullConstraint: NOTNULL TW00303.FRACT_DAY, TW00303.POSITION, TW00303.SITE, TW00303.YEAR, TW00303.DBCODE, TW00303.ENTITY
Attributes (7)
DBCODE - char(5) (nominal)
ID: TW00303.DBCODE
Database code
Type system: Microsoft SQL Server 2008
Code definitions (1)
-
TW003
FSDB Database Code TW003
ENTITY - numeric(1,0) (interval)
ID: TW00303.ENTITY
Entity number
Type system: Microsoft SQL Server 2008
Unit: number
Precision: 1
Numeric domain: type=natural, min=3.0000 (exclusive=false), max=3.0000 (exclusive=false)
SITE - char(10) (nominal)
ID: TW00303.SITE
Site code (WS1, WS2)
Type system: Microsoft SQL Server 2008
Code definitions (2)
-
WS01
Andrews Watershed 1
-
WS02
Andrews Watershed 2
YEAR - numeric(4,0) (dateTime)
ID: TW00303.YEAR
Year of measurement
Type system: Microsoft SQL Server 2008
Date format: YYYY
FRACT_DAY - numeric(7,3) (dateTime)
ID: TW00303.FRACT_DAY
Julian day of measurement (fractional)
Type system: Microsoft SQL Server 2008
Date format: julian day
POSITION - char(7) (nominal)
ID: TW00303.POSITION
Geomorphic position of water content reflectometer probes (explicit)
Type system: Microsoft SQL Server 2008
Code definitions (4)
-
Bottom
Located between df1 and hem1 sapflow trees in ws2 (stream side)
-
Midslope
Located between df2 and hem2 sapflow trees in ws2
-
Upper1
Located between df3 and hem3 sapflow trees in ws2 (upper slope 1)
-
Upper2
Located between hem3 and df5 sapflow trees in ws2 (upper slope 2)
VOL_WATER - numeric(5,1) (ratio)
ID: TW00303.VOL_WATER
Volumetric soil water content
Type system: Microsoft SQL Server 2008
Unit: percent
Precision: 0.100000
Numeric domain: type=real, min=5.0000 (exclusive=false), max=50.0000 (exclusive=false)
TW00304 - TW00304
Object name: TW00304.csv
Records: 1818
Attributes: 19
File size: 127806 byte
Checksum (MD5): 1c30c6c3dc530913d47245efc28c584b
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TW00304.PLOT, TW00304.SITE, TW00304.TREE_NUM
-
notNullConstraint: NOTNULL TW00304.DISTANCE, TW00304.F_GROUP, TW00304.PLOT, TW00304.SITE, TW00304.SLOPE, TW00304.SPECIES, TW00304.STEMS, TW00304.STREAMSIDE, TW00304.TOTAL_DBH, TW00304.TREE_NUM, TW00304.DBCODE, TW00304.ENTITY
Attributes (19)
DBCODE - char(5) (nominal)
ID: TW00304.DBCODE
Database code
Type system: Microsoft SQL Server 2008
Code definitions (1)
-
TW003
FSDB Database Code TW003
ENTITY - numeric(1,0) (interval)
ID: TW00304.ENTITY
Entity number
Type system: Microsoft SQL Server 2008
Unit: number
Precision: 1
Numeric domain: type=natural, min=4.0000 (exclusive=false), max=4.0000 (exclusive=false)
SITE - char(10) (nominal)
ID: TW00304.SITE
Site code (WS1, WS2)
Type system: Microsoft SQL Server 2008
Code definitions (2)
-
WS01
Andrews Watershed 1
-
WS02
Andrews Watershed 2
PLOT - char(4) (nominal)
ID: TW00304.PLOT
Riparian survey plot
Type system: Microsoft SQL Server 2008
Code definitions (53)
-
1L1
Ws2: transect 1 plot 1 (nearest stream) on left side of stream (as you face upstream)
-
1L2
Ws2: transect 1 plot 2 on left side of stream (as you face upstream)
-
1L3
Ws2: transect 1 plot 3 on left side of stream (as you face upstream)
-
1R1
Ws2: transect 1 plot 1 (nearest stream) on right side of stream (as you face upstream)
-
1R2
Ws2: transect 1 plot 2 on right side of stream (as you face upstream)
-
1R3
Ws2: transect 1 plot 3 on right side of stream (as you face upstream)
-
1v11
Ws1: transect 1 plot 1 (nearest stream)
-
1v12
Ws1: transect 1 plot 2
-
1v13
Ws1: transect 1 plot 3
-
1v14
Ws1: transect 1 plot 4
-
1v15
Ws1: transect 1 plot 5
-
1v21
Ws1: transect 2 plot 1 (nearest stream)
-
1v22
Ws1: transect 2 plot 2
-
1v23
Ws1: transect 2 plot 3
-
1v24
Ws1: transect 2 plot 4
-
1v25
Ws1: transect 2 plot 5
-
1v31
Ws1: transect 3 plot 1 (nearest stream)
-
1v32
Ws1: transect 3 plot 2
-
1v33
Ws1: transect 3 plot 3
-
1v34
Ws1: transect 3 plot 4
-
1v35
Ws1: transect 3 plot 5
-
1v41
Ws1: transect 4 plot 1 (nearest stream)
-
1v42
Ws1: transect 4 plot 2
-
1v43
Ws1: transect 4 plot 3
-
1v44
Ws1: transect 4 plot 4
-
1v45
Ws1: transect 4 plot 5
-
1v51
Ws1: transect 5 plot 1 (nearest stream)
-
1v52
Ws1: transect 5 plot 2
-
1v53
Ws1: transect 5 plot 3
-
1v54
Ws1: transect 5 plot 4
-
1v55
Ws1: transect 5 plot 5
-
1v61
Ws1: transect 6 plot 1 (nearest stream)
-
1v62
Ws1: transect 6 plot 2
-
1v63
Ws1: transect 6 plot 3
-
1v64
Ws1: transect 6 plot 4
-
1v65
Ws1: transect 6 plot 5
-
1v71
Ws1: transect 7 plot 1 (nearest stream)
-
1v72
Ws1: transect 7 plot 2
-
1v73
Ws1: transect 7 plot 3
-
1v74
Ws1: transect 7 plot 4
-
1v75
Ws1: transect 7 plot 5
-
2L1
Ws2: transect 2 plot 1 (nearest stream) on left side of stream (as you face upstream)
-
2L2
Ws2: transect 2 plot 2 on left side of stream (as you face upstream)
-
2L3
Ws2: transect 2 plot 3 on left side of stream (as you face upstream)
-
2R1
Ws2: transect 2 plot 1 (nearest stream) on right side of stream (as you face upstream)
-
2R2
Ws2: transect 2 plot 2 on right side of stream (as you face upstream)
-
2R3
Ws2: transect 2 plot 3 on right side of stream (as you face upstream)
-
3L1
Ws2: transect 3 plot 1 (nearest stream) on left side of stream (as you face upstream)
-
3L2
Ws2: transect 3 plot 2 on left side of stream (as you face upstream)
-
3L3
Ws2: transect 3 plot 3 on left side of stream (as you face upstream)
-
3R1
Ws2: transect 3 plot 1 (nearest stream) on right side of stream (as you face upstream)
-
3R2
Ws2: transect 3 plot 2 on right side of stream (as you face upstream)
-
3R3
Ws2: transect 3 plot 3 on right side of stream (as you face upstream)
DISTANCE - numeric(6,1) (ratio)
ID: TW00304.DISTANCE
Distance from wier along stream to center point of transect (where it crossses the stream)
Type system: Microsoft SQL Server 2008
Unit: meters
Precision: 0.100000
Numeric domain: type=real, min=70.0000 (exclusive=false), max=1300.0000 (exclusive=false)
STREAMSIDE - char(10) (nominal)
ID: TW00304.STREAMSIDE
Side of stream, location of transect to the left or right side of stream as you face upstream (explicit)
Type system: Microsoft SQL Server 2008
ASPECT - char(2) (nominal)
ID: TW00304.ASPECT
Compass direction the plot faces
Type system: Microsoft SQL Server 2008
Code definitions (8)
-
E
East
-
N
North
-
NE
Northeast
-
NW
Northwest
-
S
South
-
SE
Southeast
-
SW
Southwest
-
W
West
SLOPE - numeric(5,2) (ratio)
ID: TW00304.SLOPE
Average slope of plot based on 2 measurements, one on either edge of the plot
Type system: Microsoft SQL Server 2008
Unit: degrees angle
Precision: 0.010000
Numeric domain: type=real, min=-25.0000 (exclusive=false), max=55.0000 (exclusive=false)
TREE_NUM - numeric(3,0) (interval)
ID: TW00304.TREE_NUM
Sequential number assigned to every tree measured in the plot
Type system: Microsoft SQL Server 2008
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=184.0000 (exclusive=false)
SPECIES - char(5) (nominal)
ID: TW00304.SPECIES
Tree species code
Type system: Microsoft SQL Server 2008
Code definitions (17)
-
ACCI
Acer circinatum
-
ACMA
Acer macrophyllum
-
ALRU
Alnus rubra
-
AMAL
Amelanchier alnifolia
-
CONU
Cornus nuttallii
-
COCOC
Corylus cornuta var. californica
-
HODI
Holodiscus discolor
-
POTR2
Populus trichocarpa
-
PREM
Prunus emarginata
-
PSME
Pseudotsuga menziesii
-
RHPU
Rhamnus purshiana
-
RHMA
Rhododendron macrophyllum
-
TABR
Taxus brevifolia
-
THPL
Thuja plicata
-
TSHE
Tsuga heterophylla
-
VAPA
Vaccinium parvifolium
-
CACH
Castanopsis chrysophylla
F_GROUP - char(1) (nominal)
ID: TW00304.F_GROUP
Foliage type
Type system: Microsoft SQL Server 2008
Code definitions (3)
-
1
Deciduous broadleaf
-
2
Conifer
-
3
Evergreen broadleaf
STEMS - numeric(2,0) (ratio)
ID: TW00304.STEMS
Number of stems of multi-stemed woody plants
Type system: Microsoft SQL Server 2008
Unit: number
Precision: 1.000000
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=50.0000 (exclusive=false)
TOTAL_DBH - numeric(5,1) (ratio)
ID: TW00304.TOTAL_DBH
Total diameter at breast height of all stems of an individual plant
Type system: Microsoft SQL Server 2008
Unit: centimeters
Precision: 0.100000
Numeric domain: type=real, min=1.0000 (exclusive=false), max=250.0000 (exclusive=false)
AVG_DBH - numeric(5,1) (ratio)
ID: TW00304.AVG_DBH
Average diameter at breast height of all stems of an individual plant
Type system: Microsoft SQL Server 2008
Unit: centimeters
Precision: 0.100000
Numeric domain: type=real, min=1.0000 (exclusive=false), max=65.0000 (exclusive=false)
HEIGHT - numeric(5,1) (ratio)
ID: TW00304.HEIGHT
Tree height
Type system: Microsoft SQL Server 2008
Unit: meters
Precision: 0.100000
Numeric domain: type=real, min=1.0000 (exclusive=false), max=80.0000 (exclusive=false)
BARKDEPTH - numeric(4,1) (ratio)
ID: TW00304.BARKDEPTH
Bark thickness
Type system: Microsoft SQL Server 2008
Unit: centimeters
Precision: 0.100000
Numeric domain: type=real, min=0.1000 (exclusive=false), max=20.0000 (exclusive=false)
SAPW_DEPTH - numeric(5,2) (ratio)
ID: TW00304.SAPW_DEPTH
Depth of sapwood based on visual inspection of tree core for wetness or change of color
Type system: Microsoft SQL Server 2008
Unit: centimeters
Precision: 0.010000
Numeric domain: type=real, min=0.1000 (exclusive=false), max=18.0000 (exclusive=false)
SAPWOOD_BA - numeric(8,2) (ratio)
ID: TW00304.SAPWOOD_BA
Sapwood basal area, calculated from dbh and sapwood depth change of color
Type system: Microsoft SQL Server 2008
Unit: square centimeters
Precision: 0.010000
Numeric domain: type=real, min=0.7000 (exclusive=false), max=4100.0000 (exclusive=false)
AGE - numeric(2,0) (ratio)
ID: TW00304.AGE
Sapwood basal area, calculated from dbh and sapwood depth change of color
Type system: Microsoft SQL Server 2008
Unit: number of years
Precision: 1.000000
Numeric domain: type=natural, min=8.0000 (exclusive=false), max=40.0000 (exclusive=false)
TW00305 - TW00305
Object name: TW00305.csv
Records: N/A
Attributes: 9
Temporal coverage: 2001-04-01 to 2002-08-01
File size: 746515 byte
Checksum (MD5): 9f5101ea6f7f8ec098ceb2b3328e8cbd
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (1)
-
notNullConstraint: NOTNULL TW00305.DAY, TW00305.SPECIES, TW00305.YEAR, TW00305.RS_SITE, TW00305.RS_PLOT, TW00305.SAPFLOWID, TW00305.DBCODE, TW00305.ENTITY
Attributes (9)
DBCODE - char(5) (nominal)
ID: TW00305.DBCODE
Database code
Type system: Microsoft SQL Server 2008
Code definitions (1)
-
TW003
FSDB Database Code TW003
ENTITY - numeric(1,0) (interval)
ID: TW00305.ENTITY
Entity number
Type system: Microsoft SQL Server 2008
Unit: number
Precision: 1
Numeric domain: type=natural, min=5.0000 (exclusive=false), max=5.0000 (exclusive=false)
RS_SITE - char(10) (nominal)
ID: TW00305.RS_SITE
Replacement series site
Type system: Microsoft SQL Server 2008
Code definitions (2)
-
L404
UNIT L404
-
L405
UNIT L405
RS_PLOT - char(3) (nominal)
ID: TW00305.RS_PLOT
Id for replacement series plots
Type system: Microsoft SQL Server 2008
Code definitions (4)
-
DF
Douglas-fir monoculture
-
RA
Red Alder monoculture
-
DA6
mixed Douglas-fir/red alder (50/50 when planted)
-
DA7
mixed Douglas-fir/red alder (50/50 when planted). Red alder planting delayed by 5 years
YEAR - numeric(4,0) (dateTime)
ID: TW00305.YEAR
Year of measurement
Type system: Microsoft SQL Server 2008
Date format: YYYY
DAY - numeric(3,0) (dateTime)
ID: TW00305.DAY
Julian day of measurement
Type system: Microsoft SQL Server 2008
Date format: julian day
SPECIES - char(5) (nominal)
ID: TW00305.SPECIES
Tree species code
Type system: Microsoft SQL Server 2008
Code definitions (17)
-
ACCI
Acer circinatum
-
ACMA
Acer macrophyllum
-
ALRU
Alnus rubra
-
AMAL
Amelanchier alnifolia
-
CONU
Cornus nuttallii
-
COCOC
Corylus cornuta var. californica
-
HODI
Holodiscus discolor
-
POTR2
Populus trichocarpa
-
PREM
Prunus emarginata
-
PSME
Pseudotsuga menziesii
-
RHPU
Rhamnus purshiana
-
RHMA
Rhododendron macrophyllum
-
TABR
Taxus brevifolia
-
THPL
Thuja plicata
-
TSHE
Tsuga heterophylla
-
VAPA
Vaccinium parvifolium
-
CACH
Castanopsis chrysophylla
SAPFLOWID - numeric(3,0) (interval)
ID: TW00305.SAPFLOWID
Tree Id
Type system: Microsoft SQL Server 2008
Unit: number
Precision: 1
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=8.0000 (exclusive=false)
SAPFLOW - numeric(12,2) (ratio)
ID: TW00305.SAPFLOW
Daily total sapflow data averaged for all sensors (sapwood area basis)
Type system: Microsoft SQL Server 2008
Unit: grams per square meter per day
Precision: 0.010000
Numeric domain: type=real, min=-636034.0000 (exclusive=false), max=5899360.0000 (exclusive=false)
TW00306 - TW00306
Object name: TW00306.csv
Records: N/A
Attributes: 12
Temporal coverage: 2001-05-01 to 2002-07-01
File size: 8654 byte
Checksum (MD5): 4142be9cfd5ae27e1964bfc6a05c9409
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (1)
-
notNullConstraint: NOTNULL TW00306.HEIGHT, TW00306.SAPWOOD_BA, TW00306.SPECIES, TW00306.RS_SITE, TW00306.RS_PLOT, TW00306.TOT_BA, TW00306.XCOORD, TW00306.YCOORD, TW00306.DBCODE, TW00306.ENTITY
Attributes (12)
DBCODE - char(5) (nominal)
ID: TW00306.DBCODE
Database code
Type system: Microsoft SQL Server 2008
Code definitions (1)
-
TW003
FSDB Database Code TW003
ENTITY - numeric(1,0) (interval)
ID: TW00306.ENTITY
Entity number
Type system: Microsoft SQL Server 2008
Unit: number
Precision: 1
Numeric domain: type=natural, min=6.0000 (exclusive=false), max=6.0000 (exclusive=false)
RS_SITE - char(10) (nominal)
ID: TW00306.RS_SITE
Replacement series site
Type system: Microsoft SQL Server 2008
Code definitions (2)
-
L404
UNIT L404
-
L405
UNIT L405
RS_PLOT - char(3) (nominal)
ID: TW00306.RS_PLOT
Id for replacement series plots
Type system: Microsoft SQL Server 2008
Code definitions (4)
-
DF
Douglas-fir monoculture
-
RA
Red Alder monoculture
-
DA6
mixed Douglas-fir/red alder (50/50 when planted)
-
DA7
mixed Douglas-fir/red alder (50/50 when planted). Red alder planting delayed by 5 years
XCOORD - numeric(2,0) (interval)
ID: TW00306.XCOORD
X coordinate of tree
Type system: Microsoft SQL Server 2008
Unit: number
Precision: 1
Numeric domain: type=integer, min=-3.0000 (exclusive=false), max=5.0000 (exclusive=false)
YCOORD - numeric(2,0) (interval)
ID: TW00306.YCOORD
Y coordinate of tree
Type system: Microsoft SQL Server 2008
Unit: number
Precision: 1
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=6.0000 (exclusive=false)
SAPFLOWID - numeric(3,0) (interval)
ID: TW00306.SAPFLOWID
Tree Id
Type system: Microsoft SQL Server 2008
Unit: number
Precision: 1
Numeric domain: type=natural, min=1.0000 (exclusive=false), max=911.0000 (exclusive=false)
SPECIES - char(5) (nominal)
ID: TW00306.SPECIES
Tree species code
Type system: Microsoft SQL Server 2008
Code definitions (17)
-
ACCI
Acer circinatum
-
ACMA
Acer macrophyllum
-
ALRU
Alnus rubra
-
AMAL
Amelanchier alnifolia
-
CONU
Cornus nuttallii
-
COCOC
Corylus cornuta var. californica
-
HODI
Holodiscus discolor
-
POTR2
Populus trichocarpa
-
PREM
Prunus emarginata
-
PSME
Pseudotsuga menziesii
-
RHPU
Rhamnus purshiana
-
RHMA
Rhododendron macrophyllum
-
TABR
Taxus brevifolia
-
THPL
Thuja plicata
-
TSHE
Tsuga heterophylla
-
VAPA
Vaccinium parvifolium
-
CACH
Castanopsis chrysophylla
HEIGHT - numeric(5,1) (ratio)
ID: TW00306.HEIGHT
Tree height
Type system: Microsoft SQL Server 2008
Unit: meters
Precision: 0.100000
Numeric domain: type=real, min=2.9000 (exclusive=false), max=18.7000 (exclusive=false)
SAPW_DEPTH - numeric(5,2) (ratio)
ID: TW00306.SAPW_DEPTH
Depth of sapwood based on visual inspection of tree core for wetness or change of color
Type system: Microsoft SQL Server 2008
Unit: centimeters
Precision: 0.010000
Numeric domain: type=real, min=0.5000 (exclusive=false), max=6.2000 (exclusive=false)
SAPWOOD_BA - numeric(8,2) (ratio)
ID: TW00306.SAPWOOD_BA
Sapwood basal area, calculated from dbh and sapwood depth change of color
Type system: Microsoft SQL Server 2008
Unit: square centimeters
Precision: 0.010000
Numeric domain: type=real, min=2.2900 (exclusive=false), max=379.3000 (exclusive=false)
TOT_BA - numeric(6,2) (ratio)
ID: TW00306.TOT_BA
Total basal area
Type system: Microsoft SQL Server 2008
Unit: square centimeters
Precision: 1
Numeric domain: type=whole, min=3.4600 (exclusive=false), max=608.5300 (exclusive=false)
TW00307 - TW00307
Object name: TW00307.csv
Records: N/A
Attributes: 9
File size: 38178 byte
Checksum (MD5): 6c203048187b992e345870fb41e64cbb
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (1)
-
notNullConstraint: NOTNULL TW00307.DAY, TW00307.YEAR, TW00307.RS_SITE, TW00307.RS_PLOT, TW00307.ROD_LEN, TW00307.TDR_CODE, TW00307.ENTITY
Attributes (9)
DBCODE - char(5) (nominal)
ID: TW00307.DBCODE
Database code
Type system: Microsoft SQL Server 2008
Code definitions (1)
-
TW003
FSDB Database Code TW003
ENTITY - numeric(1,0) (interval)
ID: TW00307.ENTITY
Entity number
Type system: Microsoft SQL Server 2008
Unit: number
Precision: 1
Numeric domain: type=natural, min=7.0000 (exclusive=false), max=7.0000 (exclusive=false)
RS_SITE - char(10) (nominal)
ID: TW00307.RS_SITE
Replacement series site
Type system: Microsoft SQL Server 2008
Code definitions (2)
-
L404
UNIT L404
-
L405
UNIT L405
RS_PLOT - char(3) (nominal)
ID: TW00307.RS_PLOT
Id for replacement series plots
Type system: Microsoft SQL Server 2008
Code definitions (4)
-
DF
Douglas-fir monoculture
-
RA
Red Alder monoculture
-
DA6
mixed Douglas-fir/red alder (50/50 when planted)
-
DA7
mixed Douglas-fir/red alder (50/50 when planted). Red alder planting delayed by 5 years
TDR_CODE - char(10) (nominal)
ID: TW00307.TDR_CODE
TDR PLot IDs
Type system: Microsoft SQL Server 2008
Code definitions (64)
-
LRDA61L
lower repl series plot DA6 rod 1 long (0.9 m)
-
LRDA61S
lower repl series plot DA6 rod 1 short (0.45 m)
-
LRDA62L
lower repl series plot DA6 rod 2 long (0.9 m)
-
LRDA62S
lower repl series plot DA6 rod 2 short (0.45 m)
-
LRDA63L
lower repl series plot DA6 rod 3 long (0.9 m)
-
LRDA63S
lower repl series plot DA6 rod 3 short (0.45 m)
-
LRDA64L
lower repl series plot DA6 rod 4 long (0.9 m)
-
LRDA64S
lower repl series plot DA6 rod 4 short (0.45 m)
-
LRDA71L
lower repl series plot DA7 rod 1 long (0.9 m)
-
LRDA71S
lower repl series plot DA7 rod 1 short (0.45 m)
-
LRDA72L
lower repl series plot DA7 rod 2 long (0.9 m)
-
LRDA72S
lower repl series plot DA7 rod 2 short (0.45 m)
-
LRDA73L
lower repl series plot DA7 rod 3 long (0.9 m)
-
LRDA73S
lower repl series plot DA7 rod 3 short (0.45 m)
-
LRDA74L
lower repl series plot DA7 rod 4 long (0.9 m)
-
LRDA74S
lower repl series plot DA7 rod 4 short (0.45 m)
-
LRDF1L
lower repl series plot DF rod 1 long (0.9 m)
-
LRDF1S
lower repl series plot DF rod 1 short (0.45 m)
-
LRDF2L
lower repl series plot DF rod 2 long (0.9 m)
-
LRDF2S
lower repl series plot DF rod 2 short (0.45 m)
-
LRDF3L
lower repl series plot DF rod 3 long (0.9 m)
-
LRDF3S
lower repl series plot DF rod 3 short (0.45 m)
-
LRDF4L
lower repl series plot DF rod 4 long (0.9 m)
-
LRDF4S
lower repl series plot DF rod 4 short (0.45 m)
-
LRRA1L
lower repl series plot RA rod 1 long (0.9 m)
-
LRRA1S
lower repl series plot RA rod 1 short (0.45 m)
-
LRRA2L
lower repl series plot RA rod 2 long (0.9 m)
-
LRRA2S
lower repl series plot RA rod 2 short (0.45 m)
-
LRRA3L
lower repl series plot RA rod 3 long (0.9 m)
-
LRRA3S
lower repl series plot RA rod 3 short (0.45 m)
-
LRRA4L
lower repl series plot RA rod 4 long (0.9 m)
-
LRRA4S
lower repl series plot RA rod 4 short (0.45 m)
-
URDA61L
upper repl series plot DA6 rod 1 long (0.9 m)
-
URDA61S
upper repl series plot DA6 rod 1 short (0.45 m)
-
URDA62L
upper repl series plot DA6 rod 2 long (0.9 m)
-
URDA62S
upper repl series plot DA6 rod 2 short (0.45 m)
-
URDA63L
upper repl series plot DA6 rod 3 long (0.9 m)
-
URDA63S
upper repl series plot DA6 rod 3 short (0.45 m)
-
URDA64L
upper repl series plot DA6 rod 4 long (0.9 m)
-
URDA64S
upper repl series plot DA6 rod 4 short (0.45 m)
-
URDA71L
upper repl series plot DA7 rod 1 long (0.9 m)
-
URDA71S
upper repl series plot DA7 rod 1 short (0.45 m)
-
URDA72L
upper repl series plot DA7 rod 2 long (0.9 m)
-
URDA72S
upper repl series plot DA7 rod 2 short (0.45 m)
-
URDA73L
upper repl series plot DA7 rod 3 long (0.9 m)
-
URDA73S
upper repl series plot DA7 rod 3 short (0.45 m)
-
URDA74L
upper repl series plot DA7 rod 4 long (0.9 m)
-
URDA74S
upper repl series plot DA7 rod 4 short (0.45 m)
-
URDF1L
upper repl series plot DF rod 1 long (0.9 m)
-
URDF1S
upper repl series plot DF rod 1 short (0.45 m)
-
URDF2L
upper repl series plot DF rod 2 long (0.9 m)
-
URDF2S
upper repl series plot DF rod 2 short (0.45 m)
-
URDF3L
upper repl series plot DF rod 3 long (0.9 m)
-
URDF3S
upper repl series plot DF rod 3 short (0.45 m)
-
URDF4L
upper repl series plot DF rod 4 long (0.9 m)
-
URDF4S
upper repl series plot DF rod 4 short (0.45 m)
-
URRA1L
upper repl series plot RA rod 1 long (0.9 m)
-
URRA1S
upper repl series plot RA rod 1 short (0.45 m)
-
URRA2L
upper repl series plot RA rod 2 long (0.9 m)
-
URRA2S
upper repl series plot RA rod 2 short (0.45 m)
-
URRA3L
upper repl series plot RA rod 3 long (0.9 m)
-
URRA3S
upper repl series plot RA rod 3 short (0.45 m)
-
URRA4L
upper repl series plot RA rod 4 long (0.9 m)
-
URRA4S
upper repl series plot RA rod 4 short (0.45 m)
YEAR - numeric(4,0) (dateTime)
ID: TW00307.YEAR
Year of measurement
Type system: Microsoft SQL Server 2008
Date format: YYYY
DAY - numeric(3,0) (dateTime)
ID: TW00307.DAY
Julian day of measurement
Type system: Microsoft SQL Server 2008
Date format: julian day
ROD_LEN - numeric(4,2) (interval)
ID: TW00307.ROD_LEN
Length of rod (0.45 m or 0.90 m)
Type system: Microsoft SQL Server 2008
Unit: meters
Precision: 1
Numeric domain: type=real, min=0.4500 (exclusive=false), max=0.9000 (exclusive=false)
VOL_WATER_T - numeric(5,2) (ratio)
ID: TW00307.VOL_WATER_T
Volumetric soil water content (time domain reflectometry)
Type system: Microsoft SQL Server 2008
Unit: percent
Precision: 0.010000
Numeric domain: type=real, min=1.6100 (exclusive=false), max=77.7400 (exclusive=false)
Units
| number of years | years | time | nominalYear | second | 31536000 | one year excluding leap seconds and leap days, 31536000 seconds (often used for age in years) |
| degrees angle | deg angle | angle | degree | radian | 0.0174532924 | 360 degrees comprise a unit circle; degrees used for angle and slope |
| grams per square meter per day | g/m2*day | arealMassDensityRate | gramPerMeterSquaredPerDay | kilogramPerMeterSquaredPerSecond | 86.4 | grams per square meter per day |
| centimeters | cm | length | centimeter | meter | 0.01 | centimeters; .01 meters |
| square centimeters | cm2 | area | centimeterSquare | meterSquared | 0.0001 | square centimeters |
| percent | % | dimensionless | number | dimensionless | 100 | percent; a number |
| meters | m | length | meter | meter | 1 | meter; SI unit of length |
| number | number | dimensionless | number | dimensionless | 1 | dimensionless number, i.e., ratio, count |
Intellectual Rights
Data Use Agreement:
The re-use of scientific data has the potential to greatly increase communication, collaboration and synthesis within and among disciplines, and thus is fostered, supported and encouraged. This Data Set is released under the Creative Commons license CC BY "Attribution" (see: https://creativecommons.org/licenses/by/4.0/). Creative Commons license CC BY - Attribution is a license that allows others to distribute, remix, tweak, and build upon your work (even commercially), as long as you are credited for the original creation. This license accommodates maximum dissemination and use of licensed materials.
It is considered professional conduct and an ethical obligation to acknowledge the work of other scientists. The Data User is asked to provide attribution of the original work if this data package is shared in whole or by individual parts or used in the derivation of other products. A recommended citation is provided for each Data Set in the Andrews LTER data catalog (see: http://andlter.forestry.oregonstate.edu/data/catalog/datacatalog.aspx). A generic citation is also provided for this Data Set on the website https://portal.edirepository.org in the summary metadata page. Data Users are thus strongly encouraged to consider consultation, collaboration and/or co-authorship with the Data Set Creator.
While substantial efforts are made to ensure the accuracy of data and associated documentation, complete accuracy of data sets cannot be guaranteed and all data are made available "as is." The Data User should be aware, however, that data are updated periodically and it is the responsibility of the Data User to check for new versions of the data. The data authors and the repository where these data were obtained shall not be liable for damages resulting from any use or misinterpretation of the data.
General acknowledgement: Data were provided by the HJ Andrews Experimental Forest research program, funded by the National Science Foundation's Long-Term Ecological Research Program (DEB 2025755), US Forest Service Pacific Northwest Research Station, and Oregon State University.
Licensed
License: N/A
Maintenance
Maintenance update frequency: notPlanned
Description
- An update history is logged and maintained with each new version of every dataset.
Change History
-
Version1 (2000-06-01) Original metadata creation.
-
Version2 (2002-04-25) Metadata restructured and moved into SQLServer metadata database LTERMETA. Data moved into SQLServer database FSDBDATA.
-
Version5 (2007-09-07) Corrected attributes for early data (entities 1-4). Data for entities 5-7, now online.