Did You Find What You Needed?

We'd love to know how your experience with the Andrews Forest data catalog went - whether you found exactly what you were looking for or hit a dead end. Your feedback helps us improve data discovery and access.

Share Your Feedback

TW003: Sap flow measurements to estimate overstory water use in Watersheds 1 and 2, Andrews Experimental Forest, 1999-2002

← Back to catalog index

Status: notPlanned
Period: 1999-06-01 to 2002-09-30
Version: 7
Published: 2011-09-14
EDI Package ID: knb-lter-and.3187.7
Source XML: TW003_7.xml

Notice

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

Citation

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

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

Study Area Description
  • Long-Term Ecological Research
    The Andrews Forest is situated in the western Cascade Range of Oregon, and covers the entire 15,800-acre (6400-ha) drainage basin of Lookout Creek. Elevation ranges from 1350 to 5340 feet (410 to 1630 m). Broadly representative of the rugged mountainous landscape of the Pacific Northwest, the Andrews Forest contains excellent examples of the region's conifer forests and associated wildlife and stream ecosystems. These forests are among the tallest and most productive in the world, with tree heights of often greater than 250 ft (75 m). Streams are steep, cold and clean, providing habitat for numerous aquatic organisms.
Associated Party
  • Barbara J Bond
    Role: Principal Investigator
    Oregon State University;Dept. of Forest Science;330 Richardson Hall, Corvallis, OR, 97331, USA
    Phone: (541) 737-6110, (541) 908-2515
    Email: barbara.bond@oregonstate.edu
  • Barbara J Bond
    Role: Creator
    Oregon State University;Dept. of Forest Science;330 Richardson Hall, Corvallis, OR, 97331, USA
    Phone: (541) 737-6110, (541) 908-2515
    Email: barbara.bond@oregonstate.edu
  • Julia A. Jones
    Role: Other Researcher
    Oregon State University;Department of Geosciences; Wilkinson Hall 104, Corvallis, OR, 97331-5506, USA
    Phone: (541) 737-1224
    Email: Julia.Jones@oregonstate.edu, geojulia@comcast.net
  • David A. Post
    Role: Other Researcher
    CSIRO Land and Water;Davies Laboratory;PMB PO Aitkenvale, Aitkenvale, QLD, 4814, Australia
    Phone: +61-7-4753-8605
    Email: posty_67@yahoo.com.au
  • Georgianne W. Moore
    Role: Abstractor
    Texas A&M University; Horticulture Forest Science Building, College Station, TX, 77843, USA
    Phone: 979/845-3765
    Email: gwmoore@tamu.edu
  • Georgianne W. Moore
    Role: Creator
    Texas A&M University; Horticulture Forest Science Building, College Station, TX, 77843, USA
    Phone: 979/845-3765
    Email: gwmoore@tamu.edu
  • Nathan Phillips
    Role: Other Researcher
    Email: nathan@bu.edu
Contact
  • Information Manager
    Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331
    Email: hjaweb@fsl.orst.edu
  • Barbara J Bond
    Oregon State University;Dept. of Forest Science;330 Richardson Hall, Corvallis, OR, 97331, USA
    Phone: (541) 737-6110, (541) 908-2515
    Email: barbara.bond@oregonstate.edu
  • Georgianne W. Moore
    Texas A&M University; Horticulture Forest Science Building, College Station, TX, 77843, USA
    Phone: 979/845-3765
    Email: gwmoore@tamu.edu
Publisher
  • Andrews Forest LTER Site
    Role: Publisher
    Forest Ecosystems and Society Department in Forestry, Oregon State University, 201K Richardson Hall, Corvallis, OR, 97331-5752
    Phone: (541) 737-8480
    Email: lterweb@fsl.orst.edu
Study Description

This 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.19901700
    Altitude: 1027 to 1027 meter
  • Andrews Watershed 2
    W -122.24397600, E -122.22974100, N 44.21338500, S 44.20617800
    Altitude: 1079 to 1079 meter
  • UNIT L405
    W -122.19824144, E -122.19122322, N 44.25702372, S 44.25284439
    Altitude: 879 to 879 meter
  • UNIT L404
    W -122.19891567, E -122.19212205, N 44.25007353, S 44.24364806
    Altitude: 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.