# Sap flow measurements to estimate overstory water use in Watersheds 1 and 2, Andrews Experimental Forest, 1999-2002 ## Dataset - **Database Code:** TW003 - **Title:** Sap flow measurements to estimate overstory water use in Watersheds 1 and 2, Andrews Experimental Forest, 1999-2002 - **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. - **Keywords:** droughts; sapwood area; water content; soil moisture; primary production; hydrologic processes; old growth forests; vegetation; Long-Term Ecological Research (LTER); riparian ecosystems; moisture stress; primary production - **Temporal coverage:** 1999-06-01 to 2002-09-30 - **Principal Investigator:** Barbara J Bond ## Data Entities 1. TW00301 2. TW00302 3. TW00303 4. TW00304 5. TW00305 6. TW00306 7. TW00307 ## Entity 1: TW00301 ### Attribute list - **DBCODE** — varchar, enum Database code - **TW003** — FSDB Database Code TW003 - **ENTITY** — numeric(1), range 1.0000 1.0000, number Entity number - **SITE** — varchar, enum Site code (WS1, WS2) - **WS01** — Andrews Watershed 1 - **WS02** — Andrews Watershed 2 - **YEAR** — datetime, freetext Year of measurement - **DAY** — datetime, freetext Julian day of measurement - **SPECIES** — varchar, enum Tree species code - **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(0.010000), range 9000.0000 2000000.0000, grams per square meter per day Daily total sapflow data averaged for all sensors (sapwood area basis) ## Entity 2: TW00302 ### Attribute list - **DBCODE** — varchar, enum Database code - **TW003** — FSDB Database Code TW003 - **ENTITY** — numeric(1), range 2.0000 2.0000, number Entity number - **ROD_LOCATN** — varchar, enum Site code (WS1, WS2) - **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** — datetime, freetext Year of measurement - **DAY** — datetime, freetext Julian day of measurement - **VOL_WATER_T** — numeric(0.010000), range 5.0000 50.0000, percent Volumetric soil water content (time domain reflectometry) - **NOTES** — varchar, freetext Notes ## Entity 3: TW00303 ### Attribute list - **DBCODE** — varchar, enum Database code - **TW003** — FSDB Database Code TW003 - **ENTITY** — numeric(1), range 3.0000 3.0000, number Entity number - **SITE** — varchar, enum Site code (WS1, WS2) - **WS01** — Andrews Watershed 1 - **WS02** — Andrews Watershed 2 - **YEAR** — datetime, freetext Year of measurement - **FRACT_DAY** — datetime, freetext Julian day of measurement (fractional) - **POSITION** — varchar, enum Geomorphic position of water content reflectometer probes (explicit) - **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(0.100000), range 5.0000 50.0000, percent Volumetric soil water content ## Entity 4: TW00304 ### Attribute list - **DBCODE** — varchar, enum Database code - **TW003** — FSDB Database Code TW003 - **ENTITY** — numeric(1), range 4.0000 4.0000, number Entity number - **SITE** — varchar, enum Site code (WS1, WS2) - **WS01** — Andrews Watershed 1 - **WS02** — Andrews Watershed 2 - **PLOT** — varchar, enum Riparian survey plot - **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(0.100000), range 70.0000 1300.0000, meters Distance from wier along stream to center point of transect (where it crossses the stream) - **STREAMSIDE** — varchar, freetext Side of stream, location of transect to the left or right side of stream as you face upstream (explicit) - **ASPECT** — varchar, enum Compass direction the plot faces - **E** — East - **N** — North - **NE** — Northeast - **NW** — Northwest - **S** — South - **SE** — Southeast - **SW** — Southwest - **W** — West - **SLOPE** — numeric(0.010000), range -25.0000 55.0000, degrees angle Average slope of plot based on 2 measurements, one on either edge of the plot - **TREE_NUM** — numeric(1.000000), range 1.0000 184.0000, number Sequential number assigned to every tree measured in the plot - **SPECIES** — varchar, enum Tree species code - **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** — varchar, enum Foliage type - **1** — Deciduous broadleaf - **2** — Conifer - **3** — Evergreen broadleaf - **STEMS** — numeric(1.000000), range 1.0000 50.0000, number Number of stems of multi-stemed woody plants - **TOTAL_DBH** — numeric(0.100000), range 1.0000 250.0000, centimeters Total diameter at breast height of all stems of an individual plant - **AVG_DBH** — numeric(0.100000), range 1.0000 65.0000, centimeters Average diameter at breast height of all stems of an individual plant - **HEIGHT** — numeric(0.100000), range 1.0000 80.0000, meters Tree height - **BARKDEPTH** — numeric(0.100000), range 0.1000 20.0000, centimeters Bark thickness - **SAPW_DEPTH** — numeric(0.010000), range 0.1000 18.0000, centimeters Depth of sapwood based on visual inspection of tree core for wetness or change of color - **SAPWOOD_BA** — numeric(0.010000), range 0.7000 4100.0000, square centimeters Sapwood basal area, calculated from dbh and sapwood depth change of color - **AGE** — numeric(1.000000), range 8.0000 40.0000, number of years Sapwood basal area, calculated from dbh and sapwood depth change of color ## Entity 5: TW00305 ### Attribute list - **DBCODE** — varchar, enum Database code - **TW003** — FSDB Database Code TW003 - **ENTITY** — numeric(1), range 5.0000 5.0000, number Entity number - **RS_SITE** — varchar, enum Replacement series site - **L404** — UNIT L404 - **L405** — UNIT L405 - **RS_PLOT** — varchar, enum Id for replacement series plots - **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** — datetime, freetext Year of measurement - **DAY** — datetime, freetext Julian day of measurement - **SPECIES** — varchar, enum Tree species code - **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(1), range 1.0000 8.0000, number Tree Id - **SAPFLOW** — numeric(0.010000), range -636034.0000 5899360.0000, grams per square meter per day Daily total sapflow data averaged for all sensors (sapwood area basis) ## Entity 6: TW00306 ### Attribute list - **DBCODE** — varchar, enum Database code - **TW003** — FSDB Database Code TW003 - **ENTITY** — numeric(1), range 6.0000 6.0000, number Entity number - **RS_SITE** — varchar, enum Replacement series site - **L404** — UNIT L404 - **L405** — UNIT L405 - **RS_PLOT** — varchar, enum Id for replacement series plots - **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(1), range -3.0000 5.0000, number X coordinate of tree - **YCOORD** — numeric(1), range 0.0000 6.0000, number Y coordinate of tree - **SAPFLOWID** — numeric(1), range 1.0000 911.0000, number Tree Id - **SPECIES** — varchar, enum Tree species code - **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(0.100000), range 2.9000 18.7000, meters Tree height - **SAPW_DEPTH** — numeric(0.010000), range 0.5000 6.2000, centimeters Depth of sapwood based on visual inspection of tree core for wetness or change of color - **SAPWOOD_BA** — numeric(0.010000), range 2.2900 379.3000, square centimeters Sapwood basal area, calculated from dbh and sapwood depth change of color - **TOT_BA** — numeric(1), range 3.4600 608.5300, square centimeters Total basal area ## Entity 7: TW00307 ### Attribute list - **DBCODE** — varchar, enum Database code - **TW003** — FSDB Database Code TW003 - **ENTITY** — numeric(1), range 7.0000 7.0000, number Entity number - **RS_SITE** — varchar, enum Replacement series site - **L404** — UNIT L404 - **L405** — UNIT L405 - **RS_PLOT** — varchar, enum Id for replacement series plots - **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** — varchar, enum TDR PLot IDs - **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** — datetime, freetext Year of measurement - **DAY** — datetime, freetext Julian day of measurement - **ROD_LEN** — numeric(1), range 0.4500 0.9000, meters Length of rod (0.45 m or 0.90 m) - **VOL_WATER_T** — numeric(0.010000), range 1.6100 77.7400, percent Volumetric soil water content (time domain reflectometry) ## Attribute Definitions **AGE** Sapwood basal area, calculated from dbh and sapwood depth change of color **ASPECT** Compass direction the plot faces **AVG_DBH** Average diameter at breast height of all stems of an individual plant **BARKDEPTH** Bark thickness **DAY** Julian day of measurement **DBCODE** Database code **DISTANCE** Distance from wier along stream to center point of transect (where it crossses the stream) **ENTITY** Entity number **FRACT_DAY** Julian day of measurement (fractional) **F_GROUP** Foliage type **HEIGHT** Tree height **NOTES** Notes **PLOT** Riparian survey plot **POSITION** Geomorphic position of water content reflectometer probes (explicit) **ROD_LEN** Length of rod (0.45 m or 0.90 m) **ROD_LOCATN** Site code (WS1, WS2) **RS_PLOT** Id for replacement series plots **RS_SITE** Replacement series site **SAPFLOW** Daily total sapflow data averaged for all sensors (sapwood area basis) **SAPFLOWID** Tree Id **SAPWOOD_BA** Sapwood basal area, calculated from dbh and sapwood depth change of color **SAPW_DEPTH** Depth of sapwood based on visual inspection of tree core for wetness or change of color **SITE** Site code (WS1, WS2) **SLOPE** Average slope of plot based on 2 measurements, one on either edge of the plot **SPECIES** Tree species code **STEMS** Number of stems of multi-stemed woody plants **STREAMSIDE** Side of stream, location of transect to the left or right side of stream as you face upstream (explicit) **TDR_CODE** TDR PLot IDs **TOTAL_DBH** Total diameter at breast height of all stems of an individual plant **TOT_BA** Total basal area **TREE_NUM** Sequential number assigned to every tree measured in the plot **VOL_WATER** Volumetric soil water content **VOL_WATER_T** Volumetric soil water content (time domain reflectometry) **XCOORD** X coordinate of tree **YCOORD** Y coordinate of tree **YEAR** Year of measurement ## Enumerated Domains ### DBCODE - **TW003** — FSDB Database Code TW003 ### SITE - **WS01** — Andrews Watershed 1 - **WS02** — Andrews Watershed 2 ### SPECIES - **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 ### ROD_LOCATN - **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 ### POSITION - **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) ### PLOT - **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) ### ASPECT - **E** — East - **N** — North - **NE** — Northeast - **NW** — Northwest - **S** — South - **SE** — Southeast - **SW** — Southwest - **W** — West ### F_GROUP - **1** — Deciduous broadleaf - **2** — Conifer - **3** — Evergreen broadleaf ### RS_SITE - **L404** — UNIT L404 - **L405** — UNIT L405 ### RS_PLOT - **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 - **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)