TW006: Ecohydrology and Ecophysiology intensively measured plots in Watershed 1, Andrews Experimental Forest, 2005-2011
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. 2016. Ecohydrology and Ecophysiology intensively measured plots in Watershed 1, Andrews Experimental Forest, 2005-2011 Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/TW006 Accessed 2026-05-10.
Abstract
This database was developed to store data for ecophysiology and ecohydrology studies in Watershed 01 (WS01) at the H.J. Andrews Experimental Forest. The data include a combination of continuous sensor measurements (e.g. for soil moisture, soil temperature, air temperature, and relative humidity data) and repeated sampling (e.g., litterfall, dissolved organic carbon (DOC), rock content of soils). WS01 was clear cut between 1962 and 1966, burned, and replanted to varying degrees of success with Pseudotsuga menziesii, and a set of long-term plots that lie on transects normal to the main stream system was installed in 1962 to monitor plant succession and biomass development (TP073). The plots for these ecohydrological studies were co-located with a subset of TP073 plots to facilitate cross-referencing and cross-analysis of information. The boundaries of the TW006 plots are all at least 5 meters outside of the boundaries of the plant succession and biomass plots so as not to interfere with the long term integrity of those plots. An initial set of eight plots were installed for TW006 in 2004. All of these plots were located near transect #1 of the TP073 plots; i.e. the transect closest to the mouth of the watershed (see http://oregonstate.edu/feel/mapsVideos/transect_diagram.jpg, http://oregonstate.edu/feel/mapsVideos/airshed_base.pdf, and for a “virtual tour” of the watershed that illustrates the plot locations see http://oregonstate.edu/feel/mapsVideos/WS01_3d_spinningWheel2.AVI.MOV). Each of the eight plots (also known as “telemetry plots”) is associated with a bank of solar collectors and batteries that provide power for a network of sensors, and data is transmitted by telemetry via a relay station to the Andrews Headquarters. An additional set of 16 plots was established in 2009 to extend data collection through a broader area of the watershed and to represent the full range of vegetation cover classes. The locations of these was based on a stratified random sampling of TP073 plots. Data from the 2009 LiDAR reconnaissance were used to do this. A LiDAR “cover*height” index was assigned to each of the TP073 plots, and the plots were then grouped into five “height*cover” categories. Three plots were randomly selected from the lowest two categories, two from the highest category, and four each from the remaining categories. In some cases it was necessary to re-select because the randomly-selected plots were relatively inaccessible, so the final set of plots may be somewhat biased on the basis of access for sampling. The figure below shows the location of the 16 plots relative to the network of TP073 permanent plots with background colors showing the LiDAR “height*cover” classes. All of the 16 plots were used for litterfall collections between 2009-2011. Litter was collected with sets of 5 traps per plot with 43 cm x 43 cm dimensions per plot. The traps were initially installed on August 12. 2009. Collections began in October, 2009 and continued at monthly intervals during the summer and bi-monthly intervals during the winter for two years. In 2010, a soil pit of 30 cm x 30 cm x 30 cm was dug near one of the litter traps for each of the plots and all of the rocks within these pits were excavated, bagged and returned to Dr. Kate Lajtha’s laboratory where they were cleaned, dried and weighed to estimate soil rock content. Initial analysis of these data suggested that the sample size was too small to adequately represent the range of productivity in the watershed, so four additional plots were added. The plots were further excavated in July and August of 2010 to install two lysimeters (3 inch long, 1 inch diameter remote suction) at a depth of 70-90 cm. Starting in November, 2010, lysimeters were evaculated with a hand pump, and between 1 and 7 days later, any water collected in the lysimeters was collected into a vial and returned to the laboratory for analysis of dissolved organic carbon (DOC). Sampling continued at irregular intervals thereafter.
Coverage
Temporal coverage: 2005-09-30 to 2011-05-05
Geographic coverage: WS01 at the Andrews Experimental Forest. Tower location is at 44.28 N, 122.28 W.
Spatial coverage:
Bounds: W -122.25683100, E -122.23581300, N 44.20851700, S 44.19901700
Purpose
- This database was created to address ecophysiological and ecohydrological questions at high spatial and temporal resolution. The eight-plot “telemetry transect” was designed to provide high resolution, remotely-accessible data regarding soil and air moisture and temperature to facilitate the understanding of ecosystem processes in mountainous systems as part of an NSF-funded project. The goal of that project was to develop hypotheses and test questions about the sources of variability in ecosystem respired delta-13 CO and air flow patterns, with the ultimate intention of inverting this monitoring to understand annual patterns on an ecosystem wide scale. The network of extended plots from 2010 was designed specifically for one of the LTER6 integrated research projects, “CARBON AND WATER CYCLE PROCESSES WITHIN IN A SMALL WATERSHED: ROLE OF COMPLEX TERRAIN”. The overall objective of this multidisciplinary project is to better understand the influences of complex terrain on the sensitivity of carbon and water cycle processes to environmental drivers at different scales (LTER6 Goal I, objective 2). The specific objectives are to: 1) measure and model stocks and fluxes of carbon and water on a nested range of spatial and temporal scales, 2) identify environmental controls and sensitivities of processes to the controllers on these scales, and 3) test the hypothesis that the sensitivity of carbon and water cycle processes to environmental drivers is lower at the basin scale than at the average plot scale. Further information about the telemetry portion of the transect can be accessed via the H.J. Andrews Airshed Project website (Forest Ecohydrology and Telemetry Transect or FEEL: http://oregonstate.edu/feel/about, or for OSU FORESTRY researchers, via the network drive. Because of WS01's physical and environmental characteristics, it is a good microcosm for other mountainous watersheds in the region such that the understanding gained on ecosystem processes in WS01 may reflect those of the western Cascades range and complex terrains at large.
Project
Title: Long-Term Ecological Research
Personnel
-
Sherri L. Johnson - Principal Investigator US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USAPhone: 541-758-7771Email: sherri.johnson2@usda.gov, sherri.johnson@oregonstate.edu
-
Julia A. Jones - Principal Investigator Oregon State University;Department of Geosciences; Wilkinson Hall 104, Corvallis, OR, 97331-5506, USAPhone: (541) 737-1224Email: Julia.Jones@oregonstate.edu, geojulia@comcast.netORCID: http://orcid.org/0000-0001-9429-8925
-
Matthew G Betts - Principal Investigator Department of Forest Ecosystems and Society; 201E Richardson Hall; College of Forestry; Oregon State University, Corvallis, OR, 97331Phone: (541) 737-3841Email: matt.betts@oregonstate.edu
-
Michael P. Nelson - Principal Investigator Department of Forest Ecosystems and Society; 201K Richarson Hall; College of Forestry; Oregon State University, Corvallis, OR, 97331Phone: 541-737-9221Email: mpnelson@oregonstate.eduORCID: http://orcid.org/0000-0001-6917-4752
-
David Bell - Principal Investigator Email: david.bell@usda.gov, david.bell@oregonstate.edu
Abstract
- The H.J. Andrews Experimental Forest is a living laboratory that provides unparalleled opportunities for the study of forest and stream ecosystems in the central Cascade Range of Oregon. Since 1980, as a part of the National Science Foundation Long Term Ecological Research (NSF-LTER) program, the Andrews Experimental Forest has become a leader in the analysis of forest and stream ecosystem dynamics.
- Long-term field experiments and measurement programs have focused on climate dynamics, streamflow, water quality, and vegetation succession. Currently researchers are working to develop concepts and tools needed to predict effects of natural disturbance, land use, and climate change on ecosystem structure, function, and species composition.
- The Andrews Experimental Forest is administered cooperatively by the USDA Forest Service Pacific Northwest Research Station, Oregon State University and the Willamette National Forest. Funding for the research program comes from the National Science Foundation (NSF), US Forest Service Pacific Northwest Research Station, Oregon State University, and other sources.
Funding
Data were provided by the HJ Andrews Experimental Forest research program, funded by the National Science Foundation's Long-Term Ecological Research Program (DEB 2025755), US Forest Service Pacific Northwest Research Station, and Oregon State University. National Science Foundation: DEB1440409
Study Area Description
-
Long-Term Ecological Research The Andrews Forest is situated in the western Cascade Range of Oregon, and covers the entire 15,800-acre (6400-ha) drainage basin of Lookout Creek. Elevation ranges from 1350 to 5340 feet (410 to 1630 m). Broadly representative of the rugged mountainous landscape of the Pacific Northwest, the Andrews Forest contains excellent examples of the region's conifer forests and associated wildlife and stream ecosystems. These forests are among the tallest and most productive in the world, with tree heights of often greater than 250 ft (75 m). Streams are steep, cold and clean, providing habitat for numerous aquatic organisms.
Associated Party
-
Barbara J Bond
Role: Principal InvestigatorOregon State University;Dept. of Forest Science;330 Richardson Hall, Corvallis, OR, 97331, USAPhone: (541) 737-6110, (541) 908-2515Email: barbara.bond@oregonstate.edu
-
Barbara J Bond
Role: CreatorOregon State University;Dept. of Forest Science;330 Richardson Hall, Corvallis, OR, 97331, USAPhone: (541) 737-6110, (541) 908-2515Email: barbara.bond@oregonstate.edu
-
Michael H. Unsworth
Role: Other ResearcherOregon State University;Oregon Climatology, Corvallis, OR, 97331, USAEmail: unswortm@coas.oregonstate.edu
-
Elizabeth W. Sulzman
Role: Other ResearcherDept. of Crop and Soil Science;3017 ALS Bldg;Oregon State University, Corvallis, OR, 97331-7306, USAPhone: 541-737-8936
-
Alan C. Mix
Role: Other ResearcherOceanic/Atmospheric Sciences;Oregon State University;104 COAS Administration Bldg, Corvalli, OR, 97331-5503Phone: 541 737 5212Email: amix@coas.oregonstate.edu
-
Thomas G. Pypker
Role: Other ResearcherMichigan Tech;45304 Superior Rd, Houghton, MI, 49931, USAPhone: 906-487-1089Email: tgpypker@mtu.edu
-
Holly R. Barnard
Role: Other ResearcherFellow of INSTAAR; Univ. of Colorado at Boulder, Boulder, CO, USAEmail: Holly.Barnard@colorado.edu
-
Julian Licata
Role: Other Researcher
-
Claire Phillips
Role: Other ResearcherUSAEmail: Claire.Phillips@oregonstate.edu, claire.phillips@teraglobalchange.org
-
David R. Conklin
Role: Other ResearcherEmail: david.conklin@mac.com
-
Adam M Kennedy
Role: Other ResearcherCorvallis, OR, 97331, USEmail: adam.kennedy@oregonstate.edu
-
Fox Sparky Peterson
Role: Other ResearcherPhone: 404-580-5016Email: fox@tinybike.net
Contact
-
Information Manager
Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331Email: hjaweb@fsl.orst.edu
Publisher
-
Andrews Forest LTER Site
Role: PublisherForest Ecosystems and Society Department in Forestry, Oregon State University, 201K Richardson Hall, Corvallis, OR, 97331-5752Phone: (541) 737-8480Email: lterweb@fsl.orst.edu
Study Description
This database was developed to store data for ecophysiology and ecohydrology studies in Watershed 01 (WS01) at the H.J. Andrews Experimental Forest. The data include a combination of continuous sensor measurements (e.g. for soil moisture, soil temperature, air temperature, and relative humidity data) and repeated sampling (e.g., litterfall, dissolved organic carbon (DOC), rock content of soils). WS01 was clear cut between 1962 and 1966, burned, and replanted to varying degrees of success with Pseudotsuga menziesii, and a set of long-term plots that lie on transects normal to the main stream system was installed in 1962 to monitor plant succession and biomass development (TP073). The plots for these ecohydrological studies were co-located with a subset of TP073 plots to facilitate cross-referencing and cross-analysis of information. The boundaries of the TW006 plots are all at least 5 meters outside of the boundaries of the plant succession and biomass plots so as not to interfere with the long term integrity of those plots. An initial set of eight plots were installed for TW006 in 2004. All of these plots were located near transect #1 of the TP073 plots; i.e. the transect closest to the mouth of the watershed (see http://oregonstate.edu/feel/mapsVideos/transect_diagram.jpg, http://oregonstate.edu/feel/mapsVideos/airshed_base.pdf, and for a “virtual tour” of the watershed that illustrates the plot locations see http://oregonstate.edu/feel/mapsVideos/WS01_3d_spinningWheel2.AVI.MOV). Each of the eight plots (also known as “telemetry plots”) is associated with a bank of solar collectors and batteries that provide power for a network of sensors, and data is transmitted by telemetry via a relay station to the Andrews Headquarters. An additional set of 16 plots was established in 2009 to extend data collection through a broader area of the watershed and to represent the full range of vegetation cover classes. The locations of these was based on a stratified random sampling of TP073 plots. Data from the 2009 LiDAR reconnaissance were used to do this. A LiDAR “cover*height” index was assigned to each of the TP073 plots, and the plots were then grouped into five “height*cover” categories. Three plots were randomly selected from the lowest two categories, two from the highest category, and four each from the remaining categories. In some cases it was necessary to re-select because the randomly-selected plots were relatively inaccessible, so the final set of plots may be somewhat biased on the basis of access for sampling. The figure below shows the location of the 16 plots relative to the network of TP073 permanent plots with background colors showing the LiDAR “height*cover” classes. All of the 16 plots were used for litterfall collections between 2009-2011. Litter was collected with sets of 5 traps per plot with 43 cm x 43 cm dimensions per plot. The traps were initially installed on August 12. 2009. Collections began in October, 2009 and continued at monthly intervals during the summer and bi-monthly intervals during the winter for two years. In 2010, a soil pit of 30 cm x 30 cm x 30 cm was dug near one of the litter traps for each of the plots and all of the rocks within these pits were excavated, bagged and returned to Dr. Kate Lajtha’s laboratory where they were cleaned, dried and weighed to estimate soil rock content. Initial analysis of these data suggested that the sample size was too small to adequately represent the range of productivity in the watershed, so four additional plots were added. The plots were further excavated in July and August of 2010 to install two lysimeters (3 inch long, 1 inch diameter remote suction) at a depth of 70-90 cm. Starting in November, 2010, lysimeters were evaculated with a hand pump, and between 1 and 7 days later, any water collected in the lysimeters was collected into a vial and returned to the laboratory for analysis of dissolved organic carbon (DOC). Sampling continued at irregular intervals thereafter. This database was created to address ecophysiological and ecohydrological questions at high spatial and temporal resolution. The eight-plot “telemetry transect” was designed to provide high resolution, remotely-accessible data regarding soil and air moisture and temperature to facilitate the understanding of ecosystem processes in mountainous systems as part of an NSF-funded project. The goal of that project was to develop hypotheses and test questions about the sources of variability in ecosystem respired delta-13 CO and air flow patterns, with the ultimate intention of inverting this monitoring to understand annual patterns on an ecosystem wide scale. The network of extended plots from 2010 was designed specifically for one of the LTER6 integrated research projects, “CARBON AND WATER CYCLE PROCESSES WITHIN IN A SMALL WATERSHED: ROLE OF COMPLEX TERRAIN”. The overall objective of this multidisciplinary project is to better understand the influences of complex terrain on the sensitivity of carbon and water cycle processes to environmental drivers at different scales (LTER6 Goal I, objective 2). The specific objectives are to: 1) measure and model stocks and fluxes of carbon and water on a nested range of spatial and temporal scales, 2) identify environmental controls and sensitivities of processes to the controllers on these scales, and 3) test the hypothesis that the sensitivity of carbon and water cycle processes to environmental drivers is lower at the basin scale than at the average plot scale. Further information about the telemetry portion of the transect can be accessed via the H.J. Andrews Airshed Project website (Forest Ecohydrology and Telemetry Transect or FEEL: http://oregonstate.edu/feel/about, or for OSU FORESTRY researchers, via the network drive. Because of WS01's physical and environmental characteristics, it is a good microcosm for other mountainous watersheds in the region such that the understanding gained on ecosystem processes in WS01 may reflect those of the western Cascades range and complex terrains at large. Field Methods - TW006: Data flow
Purpose: This database was created to address ecophysiological and ecohydrological questions at high spatial and temporal resolution. The eight-plot “telemetry transect” was designed to provide high resolution, remotely-accessible data regarding soil and air moisture and temperature to facilitate the understanding of ecosystem processes in mountainous systems as part of an NSF-funded project. The goal of that project was to develop hypotheses and test questions about the sources of variability in ecosystem respired delta-13 CO and air flow patterns, with the ultimate intention of inverting this monitoring to understand annual patterns on an ecosystem wide scale. The network of extended plots from 2010 was designed specifically for one of the LTER6 integrated research projects, “CARBON AND WATER CYCLE PROCESSES WITHIN IN A SMALL WATERSHED: ROLE OF COMPLEX TERRAIN”. The overall objective of this multidisciplinary project is to better understand the influences of complex terrain on the sensitivity of carbon and water cycle processes to environmental drivers at different scales (LTER6 Goal I, objective 2). The specific objectives are to: 1) measure and model stocks and fluxes of carbon and water on a nested range of spatial and temporal scales, 2) identify environmental controls and sensitivities of processes to the controllers on these scales, and 3) test the hypothesis that the sensitivity of carbon and water cycle processes to environmental drivers is lower at the basin scale than at the average plot scale. Further information about the telemetry portion of the transect can be accessed via the H.J. Andrews Airshed Project website (Forest Ecohydrology and Telemetry Transect or FEEL: http://oregonstate.edu/feel/about, or for OSU FORESTRY researchers, via the network drive. Because of WS01's physical and environmental characteristics, it is a good microcosm for other mountainous watersheds in the region such that the understanding gained on ecosystem processes in WS01 may reflect those of the western Cascades range and complex terrains at large.
Methods
Method Steps
Field Methods - TW006: Data flow
- Data are sent to central computing system via a telemetry system maintained by HJ Andrews Forest and Oregon State University. This project is made possible in part due to generous funding from the National Science Foundation. The NSF is a key sponsor of the basic long-term ecological research needed to progress in ecosystem-scale science. This site is hosted on servers maintained by the system administrators at Central Web Services of Oregon State University. The development of the FEEL-DB web application has been made possible with the expertise, generous consulting, and custom web development services of Orion Imagin.
Instrumentation:
- The FEEL website (see above) serves as an access point to data from the telemetry transect.
Statistical Methods - TW006
- Custom regression equation used to convert soil moisture output from milliVolts to water content. Calibrations were developed for a capacitance instrument (ECHO), a time domain reflectometry cable tester (CT), and a water content reflectometer (WCR) in soils collected from the Wind River and H.J. Andrews Experimental Forests.d the standard equations predicted soil moisture content 0%–11.5% lower (p less than 0.0001) than new calibrations. Each new calibration equation adequately predicted soil moisture from the output for each instrument regardless of location or soil type. Prediction intervals varied, with errors of 4.5%, 3.5%, and 7.1% for the ECHO, CT, and WCR, respectively. Only the ECHO system was significantly influenced by temperature for the range sampled: as temperature increased by 1°C, the soil moisture estimate decreased by 0.1%. Overall, the ECHO performed nearly as well as the CT, and thanks to its lower cost, small differences in performance might be offset by deployment of a greater number of probes in field sampling. Despite its higher cost, the WCR did not perform as well as the other two systems.
- The instruments that use the capacitance technique or TDR to determine ? rely on the high dielectric constant of water (80) relative to mineral soil (3–5) and air (1), because water in the soil will influence the propagation of an electric signal through the soil medium. Both these techniques use empirical relationships between the soil water content and the change Can. J. For. Res. 35: 1867–1876 (2005) doi: 10.1139/X05-121 © 2005 NRC Canada 1867 Received 2 December 2004. Accepted 29 May 2005. Published on the NRC Research Press Web site at http://cjfr.nrc.ca on 3 September 2005.
- N.M. Czarnomski, T.G. Pypker, J.Licata, and B.J. Bond. Department of Forest Science, 321 Richardson Hall, Oregon State University, Corvallis, OR 97331, USA. G.W. Moore. Department of Rangeland Ecology and Management, Rm. 325 Animal Industries Building, 2126 TAMU, Texas A & M University, College Station, TX 77843-2126, USA. Corresponding author (e-mail: Nicole.Czarnomski@oregonstate.edu).in an electrical signal to estimate ?. Three common instruments available for the measurement of ? are the ECHO soil moisture probe (hereafter referred to as “ECHO”; Decagon Devices, Pullman, Washington, USA), the TDR cable tester (hereafter referred to as “CT”; we used model 1502C, Tektronix, Inc., Beaverton, Oregon, USA), and the water content reflectometer (hereafter referred to as “WCR”; we used the CS615 from Campbell Scientific, Logan, Utah, USA; since our measurements Campbell Scientific has introduced a new model).
- The ECHO calculates the apparent soil dielectric constant (Ka) of a soil by measuring the charge time of a capacitor in the soil. If the applied voltage is known, the time required to charge the capacitor is related to the output voltage of the instruments.The CT uses TDR to estimate ?. TDR determines Ka by measuring the time required for an electromagnetic pulse to travel up and down a pair of metal transmission lines of a fixed length (e.g., Topp et al. 1980). The high dielectric constant of water relative to soil and air will delay the propagation of the electromagnetic pulse. The WCR also propagates a signal along two parallel rods, but instead of measuring the propagation time of an electromagnetic pulse, the WCR uses the capacitance of the soil to predict Ka.
Instrumentation:
- <para>ECH2O: A Decagon Devices Inc. model EC-20 probe with a 20-cm plate. Signal output ranges between 250 and 1000 mV at 2500-mV excitation. The manufacturer provides an equation that is reported accurate within 3% ? if the soil does not have “high” sand content, clay content, or electrical conductivity. The manufacturer has determined that the instrument is weakly sensitive to changes in temperature and therefore does not suggest the need for a temperature correction (Campbell 2001).</para> <para>CT: A Tektronix model 1502C cable tester with two parallel 33 cm long × 4 mm diameter stainless steel rods that were set 5 cm apart. A commonly used method for interpreting the nanosecond signal was created by Topp et al. (1980); however, we used a slightly different method created by Gray and Spies (1995) because it was calibrated for soils in the Pacific Northwest. Each has a different calibration equation to relate ? to Ka. </para> <para>WCR: A Campbell Scientific, Inc. model CS615 with 30-cm rods (3.2 mm diameter and 3.2-cm spacing) connected to a circuit board. The circuit board is enclosed in epoxy and acts as a bistable multivibrator. Past research indicates that WCR is sensitive to temperature (Seyfried and Murdock 2001).</para>
Permanent Plots - TW006
- Plots are located near transect 1 of the permanent vegetation plots (TP073) in WS01. Plot enumeration follows a slightly different system (see design above). Prefix of "E" is added to plots to indicate association with the TW006 study. Currently in spatial database, plots are denoted as P111___ where ___ is the code as designated in TP073.
Instrumentation:
- From the descriptions of TP073. A total of 133 permanent vegetation sampling plots were established. The undisturbed vegetation present on these plots was recorded during the summer of 1962. Herbage cover of shrubs and trees was estimated by species on a milacre (6.6 feet square) plot. Cover of herbs and grasses was estimated on nine 1.1-foot-square plots at each location. Percent cover and frequency were computed for each plant species present. Prior to logging, plots were assigned to one of the six plant communities and one of six soil types, reflecting parent material, depth, and profile development (Rothacher et al. 1967, Dyrness 1969). Watershed was logged and broadcast burned: WS1 over a 4-yr period (1962-1966). (Modified from Lutz 2004): Circular plots of 250 m sq were established in 1979 (WS3) and 1980 (WS1), 16 and 14 yr after broadcast burning. Plot centers coincided with the locations of permanent understory quadrats established in 1962, prior to harvest (Dyrness 1973, Halpern 1988, 1989). In WS1, 133 plots were spaced at 30.5-m intervals along six widely spaced transects oriented perpendicular to the main stream channel. In WS3, 61 plots were similarly spaced along two to four transects per harvest unit. Because the objective was to characterize development of upland forests, plots that fell in perennial stream channels were not established, nor were plots that fell on rock outcrops or on roads in WS3. Sample plots comprise ~4% of the harvested areas of the two watersheds. Circular plots include one central subplot (2 by 2 m) consistently measured from 1962 to present, and 4 square subplots on outer edge of circular plot were measured from 1979-1987. Plot locations were determined in 2004 using a differentially corrected Trimble GPS. Direct readings were made on 91 plots and the remaining locations were interpolated. Elevation, aspect, and slope were determined from GPS locations and a 10-m digital elevation model and later a 1-m LIDAR coverage. (Lienkaemper 2005, Valentine 2009). Mean annual insolation, considering both topographic shading and cloud cover, was extracted from earlier modeling work by Jonathan Smith (2002).
Field Methods - TW006: DOC
- Installation: (1) Drive down metal rod to desired depth (for 2010/2011 project it was between 70 and 90 cm) at 53 degrees. This angle allows for easy calculation for a 3;4;5 triangle to obtain desired depth (this angle was estimated for 2010/2011) project. (2) Attach lysimeter to nylon tubing at about 1 meter longer than depth of hole to allow slack when sampling. (3) Drop down lysimeter to end of bored hole. Make sure lysimeter reaches the end of the hole or water will pool up beneath the lysimeter and equipment will likely fail to collect water samples. (4) Mix up silica powder at a ratio of about 1:2 with water. Pour silica slurry into hole making sure that entire hole fills up with slurry. If it does not initially fill, then wait a few minutes for silica to plug soil pores and then repeat until hole fills to top. If it does not fill at all, bore a new hole since this means there is a passageway for large quantities of fluid to go in the hole and therefore lysimeter will not be in contact with saturated soil for sampling. D (5) Pack soil over top of bored hole to plug up passageway to disallow water flowing directly to lysimeter (6) Place PVC housing directly above point where lysimeter tubing exits soil (7) Attach tubing from lysimeter to sample bottles and place inside PVC housing. It often helps to wrap the extra tubing around the sample bottle, spinning it while wrapping, this will take up the extra slack. (8) Place PVC caps on PVC housing to completely enclose sample bottles (9) Pack soil around PVC housing to prevent disturbance of sample bottles (10) Place plywood over all PVC housings to ensure that rain and runoff does not preferentially follow the bored hole to the lysimeter, increasing water volume collected and diluting samples.
- Sampling: (1) Priming lysimeters to withdrawal water sample. Usually done at least 3 days before collection. (2) Remove plywood (3) Remove PVC caps (4) Put end of hand pump tube into nylon tube in the cap of the sample bottle. There are two nylon tubes in the sample bottle. One goes into the ground and into the lysimeter, the other has a clip on it and will extrude only about 3 inches from the bottle cap… this short tube is the one to apply the vacuum on. (5) Hand pump sample bottle to 15psi. Make sure to unclip the clip on the nylon tubing to allow air to move through the tube. (6) Re-clip the tube and remove the hand pump tube from sample bottle tube. Make sure the clip is fully in place so vacuum remains. (7) Place PVC cap back on (8)Place plywood back on.
- Collecting samples (1) Remove plywood; (2) Remove PVC cap (3)Pull out sample bottle from PVC housing (4) Unscrew cap of sample bottle (if a hissing sound is heard, make note that the bottle is still under vacuum pressure. This will be important when determine functionality of equipment and installation) (5) Pour contents of sample bottle into separate bottles to be taken back to the lab for analysis.(6) Rinse out sample bottles with Deionized water: rinse 100 ml of DI water 3 times. Make sure all DI water is out of sample bottles before cap is replaced, otherwise following samples will be diluted (7) Screw sample bottle cap back on tight (8) Place sample bottle back in PVC housing, wrapping the nylon tubing around the sample bottle to take up slack (9) Re-apply vacuum to sample bottle (see Priming Lysimeters above) (10) Place PVC cap back on PVC housing (11) Place plywood back on
Instrumentation:
- Instrumentation for installation: (1) 3 inch long, 1 inch diameter remote suction lysimeters (new lysimeter models vary slightly, but same installation and sampling procedure can be applied); (2) 1cm Nylon tubing, ~2 meters per lysimeter; (3) Lysimeter sample collection bottle capable of holding 20psi vacuum pressure, 1 per lysimeter; (4) Hand pump (can obtain from auto parts store, higher durability than from a lab equipment source); (5) 4 foot long, 1 inch diameter metal rod capable of being driven into soil with blunt force; (6) Large mallet or sledge hammer (needs to be heavier than you think); (7) Silica powder, about 300 ml per lysimeter; (8) 4 inch diameter PVC tubing at 1.5 ft length for housing of water sample bottles, 1 per lysimeter; (9) 4 inch diameter PVC caps, 1 per lysimeter; (10) 2ft x 2ft plywood, 1 per plot. May need larger dimensions if dispersing lysimeters farther apart. Instrumentation for sampling: (1)Hand pump; (2) Collection bottles (no smaller than 250ml); (3) Deionized (DI) water for rinsing
Field Methods - TW006: Litterfall
- We collected litter from sixteen plots on WS1. These particular plots have been intensely subsampled for other analyses (Peterson et al.2012) intensely sampled plots were selected to represent the distribution of cover times height as measured by LiDAR reconnaissance in 2008. This metric was selected because it was believed to be a good proxy for biomass distribution. Litter collections were conducted for the years of 2009-2011, beginning with collection on 12 August 2009 and ending with collection on 11 August 2011. The litter traps were co-located just outside the perimeter of the plots in order to avoid interaction with the current vegetative studies on the plots. Each litter trap was square with edges of 43 cm by 43 cm (1.849 m2). The ground-truthed plot sizes are 250 m2; the aerial plot sizes range down to 125 m2 due to steep slopes. Five collections of the litter traps were made in the 1st year. In the second year, four collections were made.
- Litter was collected wet. Trap status, as well as any anamolies in trap content (bark, logs, etc.) were recorded.
- For most collection periods, fine and coarse litter were brought back to the lab and separated with a 12 inch hardware cloth with 12.5 cm openings. To sieve the materials in this manner, a sample was dumped onto the screen and gently shaken and lightly rubbed to pass the small pieces through the screen. After the separation, twigs which slipped through the screen were returned to the coarse fraction and the needles stuck to the coarse objects were rubbed free and placed in the fine fraction. After the separation wet weight is recorded, the sample was placed in a labeled paper bag and oven-dried. Upon reaching a stable weight in the oven, the dry weight is recorded. A paper bag stapled and labeled like the sample bags is used to tare the bag weight out of the gross weight. Some traps were damaged between collections, namely, traps on plots 419, 518, and 522. Litter mass accumulated for these plots was only recorded for non-damaged traps and a note was taken on the number and extent of damage.
- To calculate dry mass of leaves (in Mg) per hectare per period (interval between collections), three conversion factors were created following the form of:
- Mass per Hectare =1849cm2 x Number of Traps x Dried Mass of Leasves/1000000
- (1) Where Mass represents the dried mass of leaves. The rationale for creating three conversion factors was to account for the set of plots on which only three or four trap samples were valid; on these plots the expansion factor must naturally be greater.
- For the first year, leaf collections were precise to 365 days for almost all plots. Thus, the sum of the collected masses per hectare over the course of that year represented the annual collection. For a few plots, one additional day was included in the final collection period, and the influence of that period on the sum was weighted by a conversion factor of 0.9696.
- For the second year, leaf collections were only calculated through 5 May 2011. Thus, the most recent time period was weighted by a conversion factor (1:4631) to extend its influence on the sum through the summer for a full two-year interval. When the most recent collections have been completed, this factor will be removed or recalculated.
- For one plot (518) this years data was damaged for two collection periods, one in the late summer and one in the fall. Mean values from the other two collection periods (early summer and winter) were weighted to the appropriate amount of days and used as a proxy for the missing measurements. We acknowledge that this greatly decreases the accuracy of this plot. For another plot (419), large chunks of bark and rotted log were found in the sample during one remeasurement.
Instrumentation:
- 5 x 17 cm x 17 cm litter trap per plot for 16 plots. Litter recollected on multiple but spontaneous occassions. Sieved mesh used in laboratory as well as laboratory balance. Extrapolations, when conducted, use ArcMap ordinary kriging tool.
Sampling
Study Extent
- WS01 is located in the southwestern corner of the H.J. Andrews Experimental Forest. The site has wet, mild winters and warm, dry summers with a mean annual precipitation of 2300 mm. It is considered to be a low-elevation watershed relative to the rest of the HJA with a range of 410 - 1030 m. Slopes on the watershed are steep, in many locations greater than 100%. The watershed has a distinct north-south alignment, often facilitating comparisons between aspects in the "down-basin" regions. Multiple soil surveys have been conducted to various ends, but the soil is typically described as gravelly clay loam. Large protrusive cap-rocks and talus slopes are evident, although the cause for their exposure is debatable. South facing slopes have significantly less soil depth and development than north facing slopes, and are prone to failures; north-facing slopes have a deep, rich, slumping organic layer. Harvest occurred between 1962 and 1966, predominantly using skyline logging, although one corner was harvested with the high-lead method. Burning was conducted in 1967 despite the presence of "advanced regeneration" on the north-facing slope. Several shrub species, including Rhododendron macrophyllum and Gaultheria shallon established almost immediately post-burning. Forest regeneration was attempted through 4 replantings, 1 aerial and three manual, with progressively reduced extent, older saplings, and intensive care. Some areas were deemed unplantable due to the presence of rocks. Today, the canopy consists of a relatively young, closed-canopied forest (19 m on SF slope, 24 m on NF slope) that consists primarily of Douglas-fir (Pseudotsuga menziesii [Mirb.] Franco) with a smaller component of maples (Acer macrophyllum Pursh. and Acer circinatum at higher elevations), red alder (Alnus rubra Bong.) particularly in the riparian zone, and western hemlock (Tsuga heterophylla).
- Sampling frequency: 15 minutes or hourly
Sampling Description
- Eight plots located across a cross-sectional transect of WS01. Plots correspond with (co-located) the TP073 (veg studies) data from Halpern and the ecohydrology plots (E101, etc.) from Bond. More information on the plot descriptions is at: http://feel.oregonstate.edu
Spatial Sampling Units
-
Andrews Watershed 1
W -122.25683100, E -122.23581300, N 44.20851700, S 44.19901700Altitude: 1027 to 1027 meter
-
Andrews Experimental Forest (HJA)
W -122.26172200, E -122.10084700, N 44.28196400, S 44.19770400Altitude: 1631 to 1631 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 01
W -122.25530100, E -122.25530100, N 44.20743599, S 44.20743599Altitude: 555 to 555 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 02
W -122.25542900, E -122.25542900, N 44.20719374, S 44.20719374Altitude: 536 to 536 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 03
W -122.25554500, E -122.25554500, N 44.20691539, S 44.20691539Altitude: 521 to 521 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 04
W -122.25566100, E -122.25566100, N 44.20666405, S 44.20666405Altitude: 504 to 504 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 05
W -122.25581400, E -122.25581400, N 44.20643096, S 44.20643096Altitude: 485 to 485 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 07
W -122.25597100, E -122.25597100, N 44.20590979, S 44.20590979Altitude: 497 to 497 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 08
W -122.25604800, E -122.25604800, N 44.20570322, S 44.20570322Altitude: 515 to 515 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 09
W -122.25625200, E -122.25625200, N 44.20546145, S 44.20546145Altitude: 535 to 535 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 10
W -122.25638000, E -122.25638000, N 44.20521019, S 44.20521019Altitude: 555 to 555 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 12
W -122.25662400, E -122.25662400, N 44.20472560, S 44.20472560Altitude: 589 to 589 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 2, Plot 11
W -122.25322400, E -122.25322400, N 44.20534261, S 44.20534261Altitude: 530 to 530 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 16
W -122.25030200, E -122.25030200, N 44.20379283, S 44.20379283Altitude: 638 to 638 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 18
W -122.25057200, E -122.25057200, N 44.20328142, S 44.20328142Altitude: 671 to 671 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 21
W -122.25090700, E -122.25090700, N 44.20247332, S 44.20247332Altitude: 689 to 689 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 19
W -122.24523400, E -122.24523400, N 44.20476767, S 44.20476767Altitude: 765 to 765 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 22
W -122.24489800, E -122.24489800, N 44.20553074, S 44.20553074Altitude: 798 to 798 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 25
W -122.24455100, E -122.24455100, N 44.20629372, S 44.20629372Altitude: 827 to 827 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 18
W -122.24319600, E -122.24319600, N 44.20157592, S 44.20157592Altitude: 845 to 845 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 21
W -122.24353200, E -122.24353200, N 44.20078586, S 44.20078586Altitude: 834 to 834 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 26
W -122.24412400, E -122.24412400, N 44.19950230, S 44.19950230Altitude: 902 to 902 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 03
W -122.23895000, E -122.23895000, N 44.20577018, S 44.20577018Altitude: 946 to 946 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 05
W -122.23902000, E -122.23902000, N 44.20521243, S 44.20521243Altitude: 929 to 929 meter
-
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 07
W -122.23908900, E -122.23908900, N 44.20467269, S 44.20467269Altitude: 914 to 914 meter
Software
No software entries listed in this EML file.
Keywords
- LTER controlled vocabulary: hydrology (theme), meteorology (theme), climate change (theme), ecology (theme), forest dynamics (theme), microclimate (theme), soil moisture (theme), primary production (theme), hydrologic processes (theme), modeling (theme), ecosystems (theme), forest ecosystems (theme), vascular plants (theme), vegetation (theme)
- Andrews Experimental Forest site thesaurus: Long-Term Ecological Research (LTER) (theme), conifers (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: Dilleniidae
- Order: Ericales
- Family: Ericaceae
- Genus: Rhododendron
- Species: Rhododendron macrophyllum
- Subclass: Hamamelididae
- Order: Fagales
- Family: Fagaceae
- Genus: Chrysolepis
- Species: Castanopsis chrysophylla
- Family: Betulaceae
- Genus: Alnus
- Species: Alnus rubra
- Subclass: Rosidae
- Order: Sapindales
- Family: Aceraceae
- Genus: Acer
- Species: Acer circinatum
- Species: Acer macrophyllum
- Order: Rosales
- Family: Rosaceae
- Genus: Prunus
- Species: Prunus emarginata
- Order: Rhamnales
- Family: Rhamnaceae
- Genus: Rhamnus
- Species: Rhamnus purshiana
- Division or Phylum: Coniferophyta
- Class: Pinopsida
- Order: Pinales
- Family: Cupressaceae
- Genus: Thuja
- Species: Thuja plicata
- Family: Pinaceae
- Genus: Pseudotsuga
- Species: Pseudotsuga menziesii var. menziesii
- Genus: Abies
- Species: Abies amabilis
- Genus: Tsuga
- Species: Tsuga heterophylla
- Order: Taxales
- Family: Taxaceae
- Genus: Taxus
- Species: Taxus brevifolia
Data Entities
| # | Entity | Metadata | Data |
|---|---|---|---|
| 1 |
TW00601
TW00601 Soil temperature at sites along a transect in WS1: |
METADATA | DATA |
| 2 |
TW00603
TW00603 Air temperature at sites along a transect in WS1: |
METADATA | DATA |
| 3 |
TW00604
TW00604 Relative humidity at sites along a transect in WS1: |
METADATA | DATA |
| 4 |
TW00605
TW00605 Precipitation at sites along a transect in WS1: |
METADATA | DATA |
| 5 |
TW00606
TW00606 Two Years of Litterfall Collection on WS1: |
METADATA | DATA |
| 6 |
TW00607
TW00607 Dissolved Organic Carbon (DOC) concentrations from WS1: Concentrations from 10 remeasurement periods |
METADATA | DATA |
Metadata
TW00601 - TW00601
Object name: TW00601.txt
Records: 1116585
Attributes: 9
Temporal coverage: 2005-09-30 to 2011-03-22
Checksum (MD5): 5b32eb73abb3a361e7084af09bc4a568
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TW00601.DATETIME, TW00601.PROBE, TW00601.SITECODE
-
notNullConstraint: NOTNULL TW00601.DATETIME, TW00601.DBCODE, TW00601.ENTITY, TW00601.METHOD, TW00601.PROBE, TW00601.PLOTID, TW00601.SITECODE
Attributes (9)
DBCODE - char(5) (nominal)
ID: TW00601.DBCODE
Database Code
Type system: Microsoft SQL Server 2008
Code definitions (1)
-
TW006
FSDB Database Code
ENTITY - numeric(2,0) (ratio)
ID: TW00601.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)
SITECODE - char(4) (nominal)
ID: TW00601.SITECODE
Sitecode Name
Type system: Microsoft SQL Server 2008
Code definitions (1)
-
WS01
Andrews Watershed 1
PLOTID - char(6) (nominal)
ID: TW00601.PLOTID
Plot Id consisting of watershed, unit, transect, and plot number (from TP073)
Type system: Microsoft SQL Server 2008
Code definitions (23)
-
P11101
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 01
-
P11102
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 02
-
P11103
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 03
-
P11104
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 04
-
P11105
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 05
-
P11107
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 07
-
P11108
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 08
-
P11109
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 09
-
P11110
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 10
-
P11112
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 12
-
P11211
Veg Study Plot (TP073) - WS01, Unit 1, Transect 2, Plot 11
-
P11316
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 16
-
P11318
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 18
-
P11321
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 21
-
P11419
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 19
-
P11422
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 22
-
P11425
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 25
-
P11518
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 18
-
P11521
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 21
-
P11526
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 26
-
P11603
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 03
-
P11605
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 05
-
P11607
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 07
METHOD - char(4) (nominal)
ID: TW00601.METHOD
Sampling method and interval
Type system: Microsoft SQL Server 2008
Code definitions (6)
-
DE2015
Decagon soil moisture unit Echo 20; 15 minute sampling interval
-
DE0515
Decagon soil moisture unit Echo 05; 15 minute sampling interval
-
CS15
Campbell Scientific thermistor; 15 minute sampling interval
-
CS60
Campbell Scientific thermistor; 1 hour sampling interval
-
CS24
Campbell Scientific thermistor; daily sampling
-
TB15
Tipping Bucket; 15 minute sampling interval
PROBE - char(8) (nominal)
ID: TW00601.PROBE
Probe number code
Type system: Microsoft SQL Server 2008
Code definitions (152)
-
A501C012
Air temperature in center of plot 501 near P11101 at 12 meter height
-
A502C012
Air temperature in center of plot 502 near P11102 at 12 meter height
-
A504C012
Air temperature in center of plot 504 near P11104 at 12 meter height
-
A505C012
Air temperature in center of plot 505 near P11105 at 12 meter height
-
A507C012
Air temperature in center of plot 507 near P11107 at 12 meter height
-
A508C012
Air temperature in center of plot 508 near P11108 at 12 meter height
-
A510C012
Air temperature in center of plot 510 near P11110 at 12 meter height
-
A512C012
Air temperature in center of plot 512 near P11112 at 12 meter height
-
R501C012
Relative humidity in center of plot 501 near P11101 at 12 meter height
-
R502C012
Relative humidity in center of plot 502 near P11102 at 12 meter height
-
R504C012
Relative humidity in center of plot 504 near P11104 at 12 meter height
-
R505C012
Relative humidity in center of plot 505 near P11105 at 12 meter height
-
R507C012
Relative humidity in center of plot 507 near P11107 at 12 meter height
-
R508C012
Relative humidity in center of plot 508 near P11108 at 12 meter height
-
R510C012
Relative humidity in center of plot 510 near P11110 at 12 meter height
-
R512C012
Relative humidity in center of plot 512 near P11112 at 12 meter height
-
S501C005
Soil temperature in center of plot 501 near P11101 at 5 centimeters depth
-
S501C030
Soil temperature in center of plot 501 near P11101 at 30 centimeters depth
-
S501C100
Soil temperature in center of plot 501 near P11101 at 100 centimeters depth
-
S502C005
Soil temperature in center of plot 502 near P11102 at 5 centimeters depth
-
S502C030
Soil temperature in center of plot 502 near P11102 at 30 centimeters depth
-
S502C100
Soil temperature in center of plot 502 near P11102 at 100 centimeters depth
-
S504C005
Soil temperature in center of plot 504 near P11104 at 5 centimeters depth
-
S504C030
Soil temperature in center of plot 504 near P11104 at 30 centimeters depth
-
S504C100
Soil temperature in center of plot 504 near P11104 at 100 centimeters depth
-
S505C005
Soil temperature in center of plot 505 near P11105 at 5 centimeters depth
-
S505C030
Soil temperature in center of plot 505 near P11105 at 30 centimeters depth
-
S505C100
Soil temperature in center of plot 505 near P11105 at 100 centimeters depth
-
S507C005
Soil temperature in center of plot 507 near P11107 at 5 centimeters depth
-
S507C030
Soil temperature in center of plot 507 near P11107 at 30 centimeters depth
-
S507C100
Soil temperature in center of plot 507 near P11107 at 100 centimeters depth
-
S508C005
Soil temperature in center of plot 508 near P11108 at 5 centimeters depth
-
S508C030
Soil temperature in center of plot 508 near P11108 at 30 centimeters depth
-
S508C100
Soil temperature in center of plot 508 near P11108 at 100 centimeters depth
-
S510C005
Soil temperature in center of plot 510 near P11110 at 5 centimeters depth
-
S510C030
Soil temperature in center of plot 510 near P11110 at 30 centimeters depth
-
S510C100
Soil temperature in center of plot 510 near P11110 at 100 centimeters depth
-
S512C005
Soil temperature in center of plot 512 near P11112 at 5 centimeters depth
-
S512C030
Soil temperature in center of plot 512 near P11112 at 30 centimeters depth
-
S512C100
Soil temperature in center of plot 512 near P11112 at 100 centimeters depth
-
M501N005
Soil moisture in north quad of plot 501 near P11101at 5 centimeters depth
-
M501N030
Soil moisture in north quad of plot 501 near P11101 at 30 centimeters depth
-
M501N100
Soil moisture in north quad of plot 501 near P11101 at 100 centimeters depth
-
M501S005
Soil moisture in south quad of plot 501 near P11101 at 5 centimeters depth
-
M501S030
Soil moisture in south quad of plot 501 near P11101 at 30 centimeters depth
-
M501S100
Soil moisture in south quad of plot 501 near P11101 at 100 centimeters depth
-
M501E005
Soil moisture in east quad of plot 501 near P11101 at 5 centimeters depth
-
M501E030
Soil moisture in east quad of plot 501 near P11101 at 30 centimeters depth
-
M501E100
Soil moisture in east quad of plot 501 near P11101 at 100 centimeters depth
-
M501W005
Soil moisture in west quad of plot 501 near P11101 at 5 centimeters depth
-
M501W030
Soil moisture in west quad of plot 501 near P11101 at 30 centimeters depth
-
M501W100
Soil moisture in west quad of plot 501 near P11101 at 100 centimeters depth
-
M502N005
Soil moisture in north quad of plot 502 near P11102 at 5 centimeters depth
-
M502N030
Soil moisture in north quad of plot 502 near P11102 at 30 centimeters depth
-
M502N100
Soil moisture in north quad of plot 502 near P11102 at 100 centimeters depth
-
M502S005
Soil moisture in south quad of plot 502 near P11102 at 5 centimeters depth
-
M502S030
Soil moisture in south quad of plot 502 near P11102 at 30 centimeters depth
-
M502S100
Soil moisture in south quad of plot 502 near P11102 at 100 centimeters depth
-
M502E005
Soil moisture in east quad of plot 502 near P11102 at 5 centimeters depth
-
M502E030
Soil moisture in east quad of plot 502 near P11102 at 30 centimeters depth
-
M502E100
Soil moisture in east quad of plot 502 near P11102 at 100 centimeters depth
-
M502W005
Soil moisture in west quad of plot 502 near P11102 at 5 centimeters depth
-
M502W030
Soil moisture in west quad of plot 502 near P11102 at 30 centimeters depth
-
M502W100
Soil moisture in west quad of plot 502 near P11102 at 100 centimeters depth
-
M504N005
Soil moisture in north quad of plot 504 near P11104 at 5 centimeters depth
-
M504N030
Soil moisture in north quad of plot 504 near P11104 at 30 centimeters depth
-
M504N100
Soil moisture in north quad of plot 504 near P11104 at 100 centimeters depth
-
M504S005
Soil moisture in south quad of plot 504 near P11104 at 5 centimeters depth
-
M504S030
Soil moisture in south quad of plot 504 near P11104 at 30 centimeters depth
-
M504S100
Soil moisture in south quad of plot 504 near P11104 at 100 centimeters depth
-
M504E005
Soil moisture in east quad of plot 504 near P11104 at 5 centimeters depth
-
M504E030
Soil moisture in east quad of plot 504 near P11104 at 30 centimeters depth
-
M504E100
Soil moisture in east quad of plot 504 near P11104 at 100 centimeters depth
-
M504W005
Soil moisture in west quad of plot 504 near P11104 at 5 centimeters depth
-
M504W030
Soil moisture in west quad of plot 504 near P11104 at 30 centimeters depth
-
M504W100
Soil moisture in west quad of plot 504 near P11104 at 100 centimeters depth
-
M505N005
Soil moisture in north quad of plot 505 near P11105 at 5 centimeters depth
-
M505N030
Soil moisture in north quad of plot 505 near P11105 at 30 centimeters depth
-
M505N100
Soil moisture in north quad of plot 505 near P11105 at 100 centimeters depth
-
M505S005
Soil moisture in south quad of plot 505 near P11105 at 5 centimeters depth
-
M505S030
Soil moisture in south quad of plot 505 near P11105 at 30 centimeters depth
-
M505S100
Soil moisture in south quad of plot 505 near P11105 at 100 centimeters depth
-
M505E005
Soil moisture in east quad of plot 505 near P11105 at 5 centimeters depth
-
M505E030
Soil moisture in east quad of plot 505 near P11105 at 30 centimeters depth
-
M505E100
Soil moisture in east quad of plot 505 near P11105 at 100 centimeters depth
-
M505W005
Soil moisture in west quad of plot 505 near P11105 at 5 centimeters depth
-
M505W030
Soil moisture in west quad of plot 505 near P11105 at 30 centimeters depth
-
M505W100
Soil moisture in west quad of plot 505 near P11105 at 100 centimeters depth
-
M507N005
Soil moisture in north quad of plot 507 near P11107 at 5 centimeters depth
-
M507N030
Soil moisture in north quad of plot 507 near P11107 at 30 centimeters depth
-
M507N100
Soil moisture in north quad of plot 507 near P11107 at 100 centimeters depth
-
M507S005
Soil moisture in south quad of plot 507 near P11107 at 5 centimeters depth
-
M507S030
Soil moisture in south quad of plot 507 near P11107 at 30 centimeters depth
-
M507S100
Soil moisture in south quad of plot 507 near P11107 at 100 centimeters depth
-
M507E005
Soil moisture in east quad of plot 507 near P11107 at 5 centimeters depth
-
M507E030
Soil moisture in east quad of plot 507 near P11107 at 30 centimeters depth
-
M507E100
Soil moisture in east quad of plot 507 near P11107 at 100 centimeters depth
-
M507W005
Soil moisture in west quad of plot 507 near P11107 at 5 centimeters depth
-
M507W030
Soil moisture in west quad of plot 507 near P11107 at 30 centimeters depth
-
M507W100
Soil moisture in west quad of plot 507 near P11107 at 100 centimeters depth
-
M508N005
Soil moisture in north quad of plot 508 near P11108 at 5 centimeters depth
-
M508N030
Soil moisture in north quad of plot 508 near P11108 at 30 centimeters depth
-
M508N100
Soil moisture in north quad of plot 508 near P11108 at 100 centimeters depth
-
M508S005
Soil moisture in south quad of plot 508 near P11108 at 5 centimeters depth
-
M508S030
Soil moisture in south quad of plot 508 near P11108at 30 centimeters depth
-
M508S100
Soil moisture in south quad of plot 508 near P11108 at 100 centimeters depth
-
M508E005
Soil moisture in east quad of plot 508 near P11108 at 5 centimeters depth
-
M508E030
Soil moisture in east quad of plot 508 near P11108 at 30 centimeters depth
-
M508E100
Soil moisture in east quad of plot 508 near P11108 at 100 centimeters depth
-
M508W005
Soil moisture in west quad of plot 508 near P11108 at 5 centimeters depth
-
M508W030
Soil moisture in west quad of plot 508 near P11108 at 30 centimeters depth
-
M508W100
Soil moisture in west quad of plot 508 near P11108 at 100 centimeters depth
-
M510N005
Soil moisture in north quad of plot 510 near P11110 at 5 centimeters depth
-
M510N030
Soil moisture in north quad of plot 510 near P11110 at 30 centimeters depth
-
M510N100
Soil moisture in north quad of plot 510 near P11110 at 100 centimeters depth
-
M510S005
Soil moisture in south quad of plot 510 near P11110 at 5 centimeters depth
-
M510S030
Soil moisture in south quad of plot 510 near P11110 at 30 centimeters depth
-
M510S100
Soil moisture in south quad of plot 510 near P11110 at 100 centimeters depth
-
M510E005
Soil moisture in east quad of plot 510 near P11110 at 5 centimeters depth
-
M510E030
Soil moisture in east quad of plot 510 near P11110 at 30 centimeters depth
-
M510E100
Soil moisture in east quad of plot 510 near P11110 at 100 centimeters depth
-
M510W005
Soil moisture in west quad of plot 510 near P11110 at 5 centimeters depth
-
M510W030
Soil moisture in west quad of plot 510 near P11110 at 30 centimeters depth
-
M510W100
Soil moisture in west quad of plot 510 near P11110 at 100 centimeters depth
-
M512N005
Soil moisture in north quad of plot 512 near P11105 at 5 centimeters depth
-
M512N030
Soil moisture in north quad of plot 512 near P11105 at 30 centimeters depth
-
M512N100
Soil moisture in north quad of plot 512 near P11112 at 100 centimeters depth
-
M512S005
Soil moisture in south quad of plot 512 near P11112 at 5 centimeters depth
-
M512S030
Soil moisture in south quad of plot 512 near P11112 at 30 centimeters depth
-
M512S100
Soil moisture in south quad of plot 512 near P11112 at 100 centimeters depth
-
M512E005
Soil moisture in east quad of plot 512 near P11112 at 5 centimeters depth
-
M512E030
Soil moisture in east quad of plot 512 near P11112 at 30 centimeters depth
-
M512E100
Soil moisture in east quad of plot 512 near P11112 at 100 centimeters depth
-
M512W005
Soil moisture in west quad of plot 512 near P11112 at 5 centimeters depth
-
M512W030
Soil moisture in west quad of plot 512 near P11112 at 30 centimeters depth
-
M512W100
Soil moisture in west quad of plot 512 near P11112 at 100 centimeters depth
-
M508E015
Soil moisture in east quad of plot 508 near P11108 at 15 centimeters depth
-
M508W015
Soil moisture in west quad of plot 508 near P11108 at 15 centimeters depth
-
M507E015
Soil moisture in east quad of plot 507 near P11107 at 15 centimeters depth
-
M507W015
Soil moisture in west quad of plot 507 near P11107 at 15 centimeters depth
-
M510E015
Soil moisture in east quad of plot 510 near P11110 at 15 centimeters depth
-
M510W015
Soil moisture in west quad of plot 510 near P11110 at 15 centimeters depth
-
M512E015
Soil moisture in east quad of plot 12 near P11112 at 15 centimeters depth
-
M512W015
Soil moisture in west quad of plot 512 near P11112 at 15 centimeters depth
-
P501C001
Precipitation in center of plot 501 near P11101 at 1 meter height
-
P502C001
Precipitation in center of plot 502 near P11102 at 1 meter height
-
P504C001
Precipitation in center of plot 504 near P11104 at 1 meter height
-
P505C001
Precipitation in center of plot 505 near P11105 at 1 meter height
-
P507C001
Precipitation in center of plot 507 near P11107 at 1 meter height
-
P508C001
Precipitation in center of plot 508 near P11108 at 1 meter height
-
P510C001
Precipitation in center of plot 510 near P11110 at 1 meter height
-
P512C001
Precipitation in center of plot 512 near P11112 at 1 meter height
DATETIME - datetime (dateTime)
ID: TW00601.DATETIME
Formatted time and date (PST) of measurement
Type system: Microsoft SQL Server 2008
Date format: YYYY-MM-DD hh:mm:ss
SOIL_TEMP - numeric(4,2) (interval)
ID: TW00601.SOIL_TEMP
Temperature of the soil
Type system: Microsoft SQL Server 2008
Unit: degrees Celsius
Precision: 1
Numeric domain: type=real, min=-7.0000 (exclusive=false), max=30.0000 (exclusive=false)
SOIL_FLAG - char(1) (nominal)
ID: TW00601.SOIL_FLAG
Soil temperature quality flag
Type system: Microsoft SQL Server 2008
Code definitions (4)
-
Good value
-
Q
Questionable
-
B
Bad
-
M
Missing
TW00603 - TW00603
Object name: TW00603.txt
Records: 1515807
Attributes: 9
Temporal coverage: 2005-08-01 to 2011-03-22
Checksum (MD5): 396ba968c44d19f2a1391a1534c900a6
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TW00603.DATETIME, TW00603.PROBE, TW00603.SITECODE
-
notNullConstraint: NOTNULL TW00603.DATETIME, TW00603.DBCODE, TW00603.ENTITY, TW00603.METHOD, TW00603.PROBE, TW00603.PLOTID, TW00603.SITECODE
Attributes (9)
DBCODE - char(5) (nominal)
ID: TW00603.DBCODE
Database Code
Type system: Microsoft SQL Server 2008
Code definitions (1)
-
TW006
FSDB Database Code
ENTITY - numeric(2,0) (ratio)
ID: TW00603.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)
SITECODE - char(4) (nominal)
ID: TW00603.SITECODE
Sitecode Name
Type system: Microsoft SQL Server 2008
Code definitions (1)
-
WS01
Andrews Watershed 1
PLOTID - char(6) (nominal)
ID: TW00603.PLOTID
Plot Id consisting of watershed, unit, transect, and plot number (from TP073)
Type system: Microsoft SQL Server 2008
Code definitions (23)
-
P11101
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 01
-
P11102
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 02
-
P11103
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 03
-
P11104
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 04
-
P11105
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 05
-
P11107
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 07
-
P11108
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 08
-
P11109
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 09
-
P11110
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 10
-
P11112
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 12
-
P11211
Veg Study Plot (TP073) - WS01, Unit 1, Transect 2, Plot 11
-
P11316
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 16
-
P11318
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 18
-
P11321
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 21
-
P11419
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 19
-
P11422
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 22
-
P11425
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 25
-
P11518
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 18
-
P11521
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 21
-
P11526
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 26
-
P11603
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 03
-
P11605
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 05
-
P11607
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 07
METHOD - char(4) (nominal)
ID: TW00603.METHOD
Sampling method and interval
Type system: Microsoft SQL Server 2008
Code definitions (6)
-
DE2015
Decagon soil moisture unit Echo 20; 15 minute sampling interval
-
DE0515
Decagon soil moisture unit Echo 05; 15 minute sampling interval
-
CS15
Campbell Scientific thermistor; 15 minute sampling interval
-
CS60
Campbell Scientific thermistor; 1 hour sampling interval
-
CS24
Campbell Scientific thermistor; daily sampling
-
TB15
Tipping Bucket; 15 minute sampling interval
PROBE - char(8) (nominal)
ID: TW00603.PROBE
Probe number code
Type system: Microsoft SQL Server 2008
Code definitions (152)
-
A501C012
Air temperature in center of plot 501 near P11101 at 12 meter height
-
A502C012
Air temperature in center of plot 502 near P11102 at 12 meter height
-
A504C012
Air temperature in center of plot 504 near P11104 at 12 meter height
-
A505C012
Air temperature in center of plot 505 near P11105 at 12 meter height
-
A507C012
Air temperature in center of plot 507 near P11107 at 12 meter height
-
A508C012
Air temperature in center of plot 508 near P11108 at 12 meter height
-
A510C012
Air temperature in center of plot 510 near P11110 at 12 meter height
-
A512C012
Air temperature in center of plot 512 near P11112 at 12 meter height
-
R501C012
Relative humidity in center of plot 501 near P11101 at 12 meter height
-
R502C012
Relative humidity in center of plot 502 near P11102 at 12 meter height
-
R504C012
Relative humidity in center of plot 504 near P11104 at 12 meter height
-
R505C012
Relative humidity in center of plot 505 near P11105 at 12 meter height
-
R507C012
Relative humidity in center of plot 507 near P11107 at 12 meter height
-
R508C012
Relative humidity in center of plot 508 near P11108 at 12 meter height
-
R510C012
Relative humidity in center of plot 510 near P11110 at 12 meter height
-
R512C012
Relative humidity in center of plot 512 near P11112 at 12 meter height
-
S501C005
Soil temperature in center of plot 501 near P11101 at 5 centimeters depth
-
S501C030
Soil temperature in center of plot 501 near P11101 at 30 centimeters depth
-
S501C100
Soil temperature in center of plot 501 near P11101 at 100 centimeters depth
-
S502C005
Soil temperature in center of plot 502 near P11102 at 5 centimeters depth
-
S502C030
Soil temperature in center of plot 502 near P11102 at 30 centimeters depth
-
S502C100
Soil temperature in center of plot 502 near P11102 at 100 centimeters depth
-
S504C005
Soil temperature in center of plot 504 near P11104 at 5 centimeters depth
-
S504C030
Soil temperature in center of plot 504 near P11104 at 30 centimeters depth
-
S504C100
Soil temperature in center of plot 504 near P11104 at 100 centimeters depth
-
S505C005
Soil temperature in center of plot 505 near P11105 at 5 centimeters depth
-
S505C030
Soil temperature in center of plot 505 near P11105 at 30 centimeters depth
-
S505C100
Soil temperature in center of plot 505 near P11105 at 100 centimeters depth
-
S507C005
Soil temperature in center of plot 507 near P11107 at 5 centimeters depth
-
S507C030
Soil temperature in center of plot 507 near P11107 at 30 centimeters depth
-
S507C100
Soil temperature in center of plot 507 near P11107 at 100 centimeters depth
-
S508C005
Soil temperature in center of plot 508 near P11108 at 5 centimeters depth
-
S508C030
Soil temperature in center of plot 508 near P11108 at 30 centimeters depth
-
S508C100
Soil temperature in center of plot 508 near P11108 at 100 centimeters depth
-
S510C005
Soil temperature in center of plot 510 near P11110 at 5 centimeters depth
-
S510C030
Soil temperature in center of plot 510 near P11110 at 30 centimeters depth
-
S510C100
Soil temperature in center of plot 510 near P11110 at 100 centimeters depth
-
S512C005
Soil temperature in center of plot 512 near P11112 at 5 centimeters depth
-
S512C030
Soil temperature in center of plot 512 near P11112 at 30 centimeters depth
-
S512C100
Soil temperature in center of plot 512 near P11112 at 100 centimeters depth
-
M501N005
Soil moisture in north quad of plot 501 near P11101at 5 centimeters depth
-
M501N030
Soil moisture in north quad of plot 501 near P11101 at 30 centimeters depth
-
M501N100
Soil moisture in north quad of plot 501 near P11101 at 100 centimeters depth
-
M501S005
Soil moisture in south quad of plot 501 near P11101 at 5 centimeters depth
-
M501S030
Soil moisture in south quad of plot 501 near P11101 at 30 centimeters depth
-
M501S100
Soil moisture in south quad of plot 501 near P11101 at 100 centimeters depth
-
M501E005
Soil moisture in east quad of plot 501 near P11101 at 5 centimeters depth
-
M501E030
Soil moisture in east quad of plot 501 near P11101 at 30 centimeters depth
-
M501E100
Soil moisture in east quad of plot 501 near P11101 at 100 centimeters depth
-
M501W005
Soil moisture in west quad of plot 501 near P11101 at 5 centimeters depth
-
M501W030
Soil moisture in west quad of plot 501 near P11101 at 30 centimeters depth
-
M501W100
Soil moisture in west quad of plot 501 near P11101 at 100 centimeters depth
-
M502N005
Soil moisture in north quad of plot 502 near P11102 at 5 centimeters depth
-
M502N030
Soil moisture in north quad of plot 502 near P11102 at 30 centimeters depth
-
M502N100
Soil moisture in north quad of plot 502 near P11102 at 100 centimeters depth
-
M502S005
Soil moisture in south quad of plot 502 near P11102 at 5 centimeters depth
-
M502S030
Soil moisture in south quad of plot 502 near P11102 at 30 centimeters depth
-
M502S100
Soil moisture in south quad of plot 502 near P11102 at 100 centimeters depth
-
M502E005
Soil moisture in east quad of plot 502 near P11102 at 5 centimeters depth
-
M502E030
Soil moisture in east quad of plot 502 near P11102 at 30 centimeters depth
-
M502E100
Soil moisture in east quad of plot 502 near P11102 at 100 centimeters depth
-
M502W005
Soil moisture in west quad of plot 502 near P11102 at 5 centimeters depth
-
M502W030
Soil moisture in west quad of plot 502 near P11102 at 30 centimeters depth
-
M502W100
Soil moisture in west quad of plot 502 near P11102 at 100 centimeters depth
-
M504N005
Soil moisture in north quad of plot 504 near P11104 at 5 centimeters depth
-
M504N030
Soil moisture in north quad of plot 504 near P11104 at 30 centimeters depth
-
M504N100
Soil moisture in north quad of plot 504 near P11104 at 100 centimeters depth
-
M504S005
Soil moisture in south quad of plot 504 near P11104 at 5 centimeters depth
-
M504S030
Soil moisture in south quad of plot 504 near P11104 at 30 centimeters depth
-
M504S100
Soil moisture in south quad of plot 504 near P11104 at 100 centimeters depth
-
M504E005
Soil moisture in east quad of plot 504 near P11104 at 5 centimeters depth
-
M504E030
Soil moisture in east quad of plot 504 near P11104 at 30 centimeters depth
-
M504E100
Soil moisture in east quad of plot 504 near P11104 at 100 centimeters depth
-
M504W005
Soil moisture in west quad of plot 504 near P11104 at 5 centimeters depth
-
M504W030
Soil moisture in west quad of plot 504 near P11104 at 30 centimeters depth
-
M504W100
Soil moisture in west quad of plot 504 near P11104 at 100 centimeters depth
-
M505N005
Soil moisture in north quad of plot 505 near P11105 at 5 centimeters depth
-
M505N030
Soil moisture in north quad of plot 505 near P11105 at 30 centimeters depth
-
M505N100
Soil moisture in north quad of plot 505 near P11105 at 100 centimeters depth
-
M505S005
Soil moisture in south quad of plot 505 near P11105 at 5 centimeters depth
-
M505S030
Soil moisture in south quad of plot 505 near P11105 at 30 centimeters depth
-
M505S100
Soil moisture in south quad of plot 505 near P11105 at 100 centimeters depth
-
M505E005
Soil moisture in east quad of plot 505 near P11105 at 5 centimeters depth
-
M505E030
Soil moisture in east quad of plot 505 near P11105 at 30 centimeters depth
-
M505E100
Soil moisture in east quad of plot 505 near P11105 at 100 centimeters depth
-
M505W005
Soil moisture in west quad of plot 505 near P11105 at 5 centimeters depth
-
M505W030
Soil moisture in west quad of plot 505 near P11105 at 30 centimeters depth
-
M505W100
Soil moisture in west quad of plot 505 near P11105 at 100 centimeters depth
-
M507N005
Soil moisture in north quad of plot 507 near P11107 at 5 centimeters depth
-
M507N030
Soil moisture in north quad of plot 507 near P11107 at 30 centimeters depth
-
M507N100
Soil moisture in north quad of plot 507 near P11107 at 100 centimeters depth
-
M507S005
Soil moisture in south quad of plot 507 near P11107 at 5 centimeters depth
-
M507S030
Soil moisture in south quad of plot 507 near P11107 at 30 centimeters depth
-
M507S100
Soil moisture in south quad of plot 507 near P11107 at 100 centimeters depth
-
M507E005
Soil moisture in east quad of plot 507 near P11107 at 5 centimeters depth
-
M507E030
Soil moisture in east quad of plot 507 near P11107 at 30 centimeters depth
-
M507E100
Soil moisture in east quad of plot 507 near P11107 at 100 centimeters depth
-
M507W005
Soil moisture in west quad of plot 507 near P11107 at 5 centimeters depth
-
M507W030
Soil moisture in west quad of plot 507 near P11107 at 30 centimeters depth
-
M507W100
Soil moisture in west quad of plot 507 near P11107 at 100 centimeters depth
-
M508N005
Soil moisture in north quad of plot 508 near P11108 at 5 centimeters depth
-
M508N030
Soil moisture in north quad of plot 508 near P11108 at 30 centimeters depth
-
M508N100
Soil moisture in north quad of plot 508 near P11108 at 100 centimeters depth
-
M508S005
Soil moisture in south quad of plot 508 near P11108 at 5 centimeters depth
-
M508S030
Soil moisture in south quad of plot 508 near P11108at 30 centimeters depth
-
M508S100
Soil moisture in south quad of plot 508 near P11108 at 100 centimeters depth
-
M508E005
Soil moisture in east quad of plot 508 near P11108 at 5 centimeters depth
-
M508E030
Soil moisture in east quad of plot 508 near P11108 at 30 centimeters depth
-
M508E100
Soil moisture in east quad of plot 508 near P11108 at 100 centimeters depth
-
M508W005
Soil moisture in west quad of plot 508 near P11108 at 5 centimeters depth
-
M508W030
Soil moisture in west quad of plot 508 near P11108 at 30 centimeters depth
-
M508W100
Soil moisture in west quad of plot 508 near P11108 at 100 centimeters depth
-
M510N005
Soil moisture in north quad of plot 510 near P11110 at 5 centimeters depth
-
M510N030
Soil moisture in north quad of plot 510 near P11110 at 30 centimeters depth
-
M510N100
Soil moisture in north quad of plot 510 near P11110 at 100 centimeters depth
-
M510S005
Soil moisture in south quad of plot 510 near P11110 at 5 centimeters depth
-
M510S030
Soil moisture in south quad of plot 510 near P11110 at 30 centimeters depth
-
M510S100
Soil moisture in south quad of plot 510 near P11110 at 100 centimeters depth
-
M510E005
Soil moisture in east quad of plot 510 near P11110 at 5 centimeters depth
-
M510E030
Soil moisture in east quad of plot 510 near P11110 at 30 centimeters depth
-
M510E100
Soil moisture in east quad of plot 510 near P11110 at 100 centimeters depth
-
M510W005
Soil moisture in west quad of plot 510 near P11110 at 5 centimeters depth
-
M510W030
Soil moisture in west quad of plot 510 near P11110 at 30 centimeters depth
-
M510W100
Soil moisture in west quad of plot 510 near P11110 at 100 centimeters depth
-
M512N005
Soil moisture in north quad of plot 512 near P11105 at 5 centimeters depth
-
M512N030
Soil moisture in north quad of plot 512 near P11105 at 30 centimeters depth
-
M512N100
Soil moisture in north quad of plot 512 near P11112 at 100 centimeters depth
-
M512S005
Soil moisture in south quad of plot 512 near P11112 at 5 centimeters depth
-
M512S030
Soil moisture in south quad of plot 512 near P11112 at 30 centimeters depth
-
M512S100
Soil moisture in south quad of plot 512 near P11112 at 100 centimeters depth
-
M512E005
Soil moisture in east quad of plot 512 near P11112 at 5 centimeters depth
-
M512E030
Soil moisture in east quad of plot 512 near P11112 at 30 centimeters depth
-
M512E100
Soil moisture in east quad of plot 512 near P11112 at 100 centimeters depth
-
M512W005
Soil moisture in west quad of plot 512 near P11112 at 5 centimeters depth
-
M512W030
Soil moisture in west quad of plot 512 near P11112 at 30 centimeters depth
-
M512W100
Soil moisture in west quad of plot 512 near P11112 at 100 centimeters depth
-
M508E015
Soil moisture in east quad of plot 508 near P11108 at 15 centimeters depth
-
M508W015
Soil moisture in west quad of plot 508 near P11108 at 15 centimeters depth
-
M507E015
Soil moisture in east quad of plot 507 near P11107 at 15 centimeters depth
-
M507W015
Soil moisture in west quad of plot 507 near P11107 at 15 centimeters depth
-
M510E015
Soil moisture in east quad of plot 510 near P11110 at 15 centimeters depth
-
M510W015
Soil moisture in west quad of plot 510 near P11110 at 15 centimeters depth
-
M512E015
Soil moisture in east quad of plot 12 near P11112 at 15 centimeters depth
-
M512W015
Soil moisture in west quad of plot 512 near P11112 at 15 centimeters depth
-
P501C001
Precipitation in center of plot 501 near P11101 at 1 meter height
-
P502C001
Precipitation in center of plot 502 near P11102 at 1 meter height
-
P504C001
Precipitation in center of plot 504 near P11104 at 1 meter height
-
P505C001
Precipitation in center of plot 505 near P11105 at 1 meter height
-
P507C001
Precipitation in center of plot 507 near P11107 at 1 meter height
-
P508C001
Precipitation in center of plot 508 near P11108 at 1 meter height
-
P510C001
Precipitation in center of plot 510 near P11110 at 1 meter height
-
P512C001
Precipitation in center of plot 512 near P11112 at 1 meter height
DATETIME - datetime (dateTime)
ID: TW00603.DATETIME
Formatted time and date (PST) of measurement
Type system: Microsoft SQL Server 2008
Date format: YYYY-MM-DD hh:mm:ss
AIR_TEMP - numeric(4,2) (interval)
ID: TW00603.AIR_TEMP
Air temperature
Type system: Microsoft SQL Server 2008
Unit: degrees Celsius
Precision: 1
Numeric domain: type=real, min=-15.0000 (exclusive=false), max=40.0000 (exclusive=false)
AIR_FLAG - char(1) (nominal)
ID: TW00603.AIR_FLAG
Air temperature quality flag
Type system: Microsoft SQL Server 2008
Code definitions (4)
-
Good value
-
Q
Questionable
-
B
Bad
-
M
Missing
TW00604 - TW00604
Object name: TW00604.txt
Records: 1466114
Attributes: 9
Temporal coverage: 2005-08-01 to 2011-03-22
Checksum (MD5): 9f0c88eb353c5f626723871e01c37d88
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TW00604.DATETIME, TW00604.PROBE, TW00604.SITECODE
-
notNullConstraint: NOTNULL TW00604.DATETIME, TW00604.DBCODE, TW00604.ENTITY, TW00604.METHOD, TW00604.PROBE, TW00604.PLOTID, TW00604.SITECODE
Attributes (9)
DBCODE - char(5) (nominal)
ID: TW00604.DBCODE
Database Code
Type system: Microsoft SQL Server 2008
Code definitions (1)
-
TW006
FSDB Database Code
ENTITY - numeric(2,0) (ratio)
ID: TW00604.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)
SITECODE - char(4) (nominal)
ID: TW00604.SITECODE
Sitecode Name
Type system: Microsoft SQL Server 2008
Code definitions (1)
-
WS01
Andrews Watershed 1
PLOTID - char(6) (nominal)
ID: TW00604.PLOTID
Plot Id consisting of watershed, unit, transect, and plot number (from TP073)
Type system: Microsoft SQL Server 2008
Code definitions (23)
-
P11101
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 01
-
P11102
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 02
-
P11103
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 03
-
P11104
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 04
-
P11105
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 05
-
P11107
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 07
-
P11108
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 08
-
P11109
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 09
-
P11110
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 10
-
P11112
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 12
-
P11211
Veg Study Plot (TP073) - WS01, Unit 1, Transect 2, Plot 11
-
P11316
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 16
-
P11318
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 18
-
P11321
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 21
-
P11419
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 19
-
P11422
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 22
-
P11425
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 25
-
P11518
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 18
-
P11521
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 21
-
P11526
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 26
-
P11603
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 03
-
P11605
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 05
-
P11607
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 07
METHOD - char(4) (nominal)
ID: TW00604.METHOD
Sampling method and interval
Type system: Microsoft SQL Server 2008
Code definitions (6)
-
DE2015
Decagon soil moisture unit Echo 20; 15 minute sampling interval
-
DE0515
Decagon soil moisture unit Echo 05; 15 minute sampling interval
-
CS15
Campbell Scientific thermistor; 15 minute sampling interval
-
CS60
Campbell Scientific thermistor; 1 hour sampling interval
-
CS24
Campbell Scientific thermistor; daily sampling
-
TB15
Tipping Bucket; 15 minute sampling interval
PROBE - char(8) (nominal)
ID: TW00604.PROBE
Probe number code
Type system: Microsoft SQL Server 2008
Code definitions (152)
-
A501C012
Air temperature in center of plot 501 near P11101 at 12 meter height
-
A502C012
Air temperature in center of plot 502 near P11102 at 12 meter height
-
A504C012
Air temperature in center of plot 504 near P11104 at 12 meter height
-
A505C012
Air temperature in center of plot 505 near P11105 at 12 meter height
-
A507C012
Air temperature in center of plot 507 near P11107 at 12 meter height
-
A508C012
Air temperature in center of plot 508 near P11108 at 12 meter height
-
A510C012
Air temperature in center of plot 510 near P11110 at 12 meter height
-
A512C012
Air temperature in center of plot 512 near P11112 at 12 meter height
-
R501C012
Relative humidity in center of plot 501 near P11101 at 12 meter height
-
R502C012
Relative humidity in center of plot 502 near P11102 at 12 meter height
-
R504C012
Relative humidity in center of plot 504 near P11104 at 12 meter height
-
R505C012
Relative humidity in center of plot 505 near P11105 at 12 meter height
-
R507C012
Relative humidity in center of plot 507 near P11107 at 12 meter height
-
R508C012
Relative humidity in center of plot 508 near P11108 at 12 meter height
-
R510C012
Relative humidity in center of plot 510 near P11110 at 12 meter height
-
R512C012
Relative humidity in center of plot 512 near P11112 at 12 meter height
-
S501C005
Soil temperature in center of plot 501 near P11101 at 5 centimeters depth
-
S501C030
Soil temperature in center of plot 501 near P11101 at 30 centimeters depth
-
S501C100
Soil temperature in center of plot 501 near P11101 at 100 centimeters depth
-
S502C005
Soil temperature in center of plot 502 near P11102 at 5 centimeters depth
-
S502C030
Soil temperature in center of plot 502 near P11102 at 30 centimeters depth
-
S502C100
Soil temperature in center of plot 502 near P11102 at 100 centimeters depth
-
S504C005
Soil temperature in center of plot 504 near P11104 at 5 centimeters depth
-
S504C030
Soil temperature in center of plot 504 near P11104 at 30 centimeters depth
-
S504C100
Soil temperature in center of plot 504 near P11104 at 100 centimeters depth
-
S505C005
Soil temperature in center of plot 505 near P11105 at 5 centimeters depth
-
S505C030
Soil temperature in center of plot 505 near P11105 at 30 centimeters depth
-
S505C100
Soil temperature in center of plot 505 near P11105 at 100 centimeters depth
-
S507C005
Soil temperature in center of plot 507 near P11107 at 5 centimeters depth
-
S507C030
Soil temperature in center of plot 507 near P11107 at 30 centimeters depth
-
S507C100
Soil temperature in center of plot 507 near P11107 at 100 centimeters depth
-
S508C005
Soil temperature in center of plot 508 near P11108 at 5 centimeters depth
-
S508C030
Soil temperature in center of plot 508 near P11108 at 30 centimeters depth
-
S508C100
Soil temperature in center of plot 508 near P11108 at 100 centimeters depth
-
S510C005
Soil temperature in center of plot 510 near P11110 at 5 centimeters depth
-
S510C030
Soil temperature in center of plot 510 near P11110 at 30 centimeters depth
-
S510C100
Soil temperature in center of plot 510 near P11110 at 100 centimeters depth
-
S512C005
Soil temperature in center of plot 512 near P11112 at 5 centimeters depth
-
S512C030
Soil temperature in center of plot 512 near P11112 at 30 centimeters depth
-
S512C100
Soil temperature in center of plot 512 near P11112 at 100 centimeters depth
-
M501N005
Soil moisture in north quad of plot 501 near P11101at 5 centimeters depth
-
M501N030
Soil moisture in north quad of plot 501 near P11101 at 30 centimeters depth
-
M501N100
Soil moisture in north quad of plot 501 near P11101 at 100 centimeters depth
-
M501S005
Soil moisture in south quad of plot 501 near P11101 at 5 centimeters depth
-
M501S030
Soil moisture in south quad of plot 501 near P11101 at 30 centimeters depth
-
M501S100
Soil moisture in south quad of plot 501 near P11101 at 100 centimeters depth
-
M501E005
Soil moisture in east quad of plot 501 near P11101 at 5 centimeters depth
-
M501E030
Soil moisture in east quad of plot 501 near P11101 at 30 centimeters depth
-
M501E100
Soil moisture in east quad of plot 501 near P11101 at 100 centimeters depth
-
M501W005
Soil moisture in west quad of plot 501 near P11101 at 5 centimeters depth
-
M501W030
Soil moisture in west quad of plot 501 near P11101 at 30 centimeters depth
-
M501W100
Soil moisture in west quad of plot 501 near P11101 at 100 centimeters depth
-
M502N005
Soil moisture in north quad of plot 502 near P11102 at 5 centimeters depth
-
M502N030
Soil moisture in north quad of plot 502 near P11102 at 30 centimeters depth
-
M502N100
Soil moisture in north quad of plot 502 near P11102 at 100 centimeters depth
-
M502S005
Soil moisture in south quad of plot 502 near P11102 at 5 centimeters depth
-
M502S030
Soil moisture in south quad of plot 502 near P11102 at 30 centimeters depth
-
M502S100
Soil moisture in south quad of plot 502 near P11102 at 100 centimeters depth
-
M502E005
Soil moisture in east quad of plot 502 near P11102 at 5 centimeters depth
-
M502E030
Soil moisture in east quad of plot 502 near P11102 at 30 centimeters depth
-
M502E100
Soil moisture in east quad of plot 502 near P11102 at 100 centimeters depth
-
M502W005
Soil moisture in west quad of plot 502 near P11102 at 5 centimeters depth
-
M502W030
Soil moisture in west quad of plot 502 near P11102 at 30 centimeters depth
-
M502W100
Soil moisture in west quad of plot 502 near P11102 at 100 centimeters depth
-
M504N005
Soil moisture in north quad of plot 504 near P11104 at 5 centimeters depth
-
M504N030
Soil moisture in north quad of plot 504 near P11104 at 30 centimeters depth
-
M504N100
Soil moisture in north quad of plot 504 near P11104 at 100 centimeters depth
-
M504S005
Soil moisture in south quad of plot 504 near P11104 at 5 centimeters depth
-
M504S030
Soil moisture in south quad of plot 504 near P11104 at 30 centimeters depth
-
M504S100
Soil moisture in south quad of plot 504 near P11104 at 100 centimeters depth
-
M504E005
Soil moisture in east quad of plot 504 near P11104 at 5 centimeters depth
-
M504E030
Soil moisture in east quad of plot 504 near P11104 at 30 centimeters depth
-
M504E100
Soil moisture in east quad of plot 504 near P11104 at 100 centimeters depth
-
M504W005
Soil moisture in west quad of plot 504 near P11104 at 5 centimeters depth
-
M504W030
Soil moisture in west quad of plot 504 near P11104 at 30 centimeters depth
-
M504W100
Soil moisture in west quad of plot 504 near P11104 at 100 centimeters depth
-
M505N005
Soil moisture in north quad of plot 505 near P11105 at 5 centimeters depth
-
M505N030
Soil moisture in north quad of plot 505 near P11105 at 30 centimeters depth
-
M505N100
Soil moisture in north quad of plot 505 near P11105 at 100 centimeters depth
-
M505S005
Soil moisture in south quad of plot 505 near P11105 at 5 centimeters depth
-
M505S030
Soil moisture in south quad of plot 505 near P11105 at 30 centimeters depth
-
M505S100
Soil moisture in south quad of plot 505 near P11105 at 100 centimeters depth
-
M505E005
Soil moisture in east quad of plot 505 near P11105 at 5 centimeters depth
-
M505E030
Soil moisture in east quad of plot 505 near P11105 at 30 centimeters depth
-
M505E100
Soil moisture in east quad of plot 505 near P11105 at 100 centimeters depth
-
M505W005
Soil moisture in west quad of plot 505 near P11105 at 5 centimeters depth
-
M505W030
Soil moisture in west quad of plot 505 near P11105 at 30 centimeters depth
-
M505W100
Soil moisture in west quad of plot 505 near P11105 at 100 centimeters depth
-
M507N005
Soil moisture in north quad of plot 507 near P11107 at 5 centimeters depth
-
M507N030
Soil moisture in north quad of plot 507 near P11107 at 30 centimeters depth
-
M507N100
Soil moisture in north quad of plot 507 near P11107 at 100 centimeters depth
-
M507S005
Soil moisture in south quad of plot 507 near P11107 at 5 centimeters depth
-
M507S030
Soil moisture in south quad of plot 507 near P11107 at 30 centimeters depth
-
M507S100
Soil moisture in south quad of plot 507 near P11107 at 100 centimeters depth
-
M507E005
Soil moisture in east quad of plot 507 near P11107 at 5 centimeters depth
-
M507E030
Soil moisture in east quad of plot 507 near P11107 at 30 centimeters depth
-
M507E100
Soil moisture in east quad of plot 507 near P11107 at 100 centimeters depth
-
M507W005
Soil moisture in west quad of plot 507 near P11107 at 5 centimeters depth
-
M507W030
Soil moisture in west quad of plot 507 near P11107 at 30 centimeters depth
-
M507W100
Soil moisture in west quad of plot 507 near P11107 at 100 centimeters depth
-
M508N005
Soil moisture in north quad of plot 508 near P11108 at 5 centimeters depth
-
M508N030
Soil moisture in north quad of plot 508 near P11108 at 30 centimeters depth
-
M508N100
Soil moisture in north quad of plot 508 near P11108 at 100 centimeters depth
-
M508S005
Soil moisture in south quad of plot 508 near P11108 at 5 centimeters depth
-
M508S030
Soil moisture in south quad of plot 508 near P11108at 30 centimeters depth
-
M508S100
Soil moisture in south quad of plot 508 near P11108 at 100 centimeters depth
-
M508E005
Soil moisture in east quad of plot 508 near P11108 at 5 centimeters depth
-
M508E030
Soil moisture in east quad of plot 508 near P11108 at 30 centimeters depth
-
M508E100
Soil moisture in east quad of plot 508 near P11108 at 100 centimeters depth
-
M508W005
Soil moisture in west quad of plot 508 near P11108 at 5 centimeters depth
-
M508W030
Soil moisture in west quad of plot 508 near P11108 at 30 centimeters depth
-
M508W100
Soil moisture in west quad of plot 508 near P11108 at 100 centimeters depth
-
M510N005
Soil moisture in north quad of plot 510 near P11110 at 5 centimeters depth
-
M510N030
Soil moisture in north quad of plot 510 near P11110 at 30 centimeters depth
-
M510N100
Soil moisture in north quad of plot 510 near P11110 at 100 centimeters depth
-
M510S005
Soil moisture in south quad of plot 510 near P11110 at 5 centimeters depth
-
M510S030
Soil moisture in south quad of plot 510 near P11110 at 30 centimeters depth
-
M510S100
Soil moisture in south quad of plot 510 near P11110 at 100 centimeters depth
-
M510E005
Soil moisture in east quad of plot 510 near P11110 at 5 centimeters depth
-
M510E030
Soil moisture in east quad of plot 510 near P11110 at 30 centimeters depth
-
M510E100
Soil moisture in east quad of plot 510 near P11110 at 100 centimeters depth
-
M510W005
Soil moisture in west quad of plot 510 near P11110 at 5 centimeters depth
-
M510W030
Soil moisture in west quad of plot 510 near P11110 at 30 centimeters depth
-
M510W100
Soil moisture in west quad of plot 510 near P11110 at 100 centimeters depth
-
M512N005
Soil moisture in north quad of plot 512 near P11105 at 5 centimeters depth
-
M512N030
Soil moisture in north quad of plot 512 near P11105 at 30 centimeters depth
-
M512N100
Soil moisture in north quad of plot 512 near P11112 at 100 centimeters depth
-
M512S005
Soil moisture in south quad of plot 512 near P11112 at 5 centimeters depth
-
M512S030
Soil moisture in south quad of plot 512 near P11112 at 30 centimeters depth
-
M512S100
Soil moisture in south quad of plot 512 near P11112 at 100 centimeters depth
-
M512E005
Soil moisture in east quad of plot 512 near P11112 at 5 centimeters depth
-
M512E030
Soil moisture in east quad of plot 512 near P11112 at 30 centimeters depth
-
M512E100
Soil moisture in east quad of plot 512 near P11112 at 100 centimeters depth
-
M512W005
Soil moisture in west quad of plot 512 near P11112 at 5 centimeters depth
-
M512W030
Soil moisture in west quad of plot 512 near P11112 at 30 centimeters depth
-
M512W100
Soil moisture in west quad of plot 512 near P11112 at 100 centimeters depth
-
M508E015
Soil moisture in east quad of plot 508 near P11108 at 15 centimeters depth
-
M508W015
Soil moisture in west quad of plot 508 near P11108 at 15 centimeters depth
-
M507E015
Soil moisture in east quad of plot 507 near P11107 at 15 centimeters depth
-
M507W015
Soil moisture in west quad of plot 507 near P11107 at 15 centimeters depth
-
M510E015
Soil moisture in east quad of plot 510 near P11110 at 15 centimeters depth
-
M510W015
Soil moisture in west quad of plot 510 near P11110 at 15 centimeters depth
-
M512E015
Soil moisture in east quad of plot 12 near P11112 at 15 centimeters depth
-
M512W015
Soil moisture in west quad of plot 512 near P11112 at 15 centimeters depth
-
P501C001
Precipitation in center of plot 501 near P11101 at 1 meter height
-
P502C001
Precipitation in center of plot 502 near P11102 at 1 meter height
-
P504C001
Precipitation in center of plot 504 near P11104 at 1 meter height
-
P505C001
Precipitation in center of plot 505 near P11105 at 1 meter height
-
P507C001
Precipitation in center of plot 507 near P11107 at 1 meter height
-
P508C001
Precipitation in center of plot 508 near P11108 at 1 meter height
-
P510C001
Precipitation in center of plot 510 near P11110 at 1 meter height
-
P512C001
Precipitation in center of plot 512 near P11112 at 1 meter height
DATETIME - datetime (dateTime)
ID: TW00604.DATETIME
Formatted time and date (PST) of measurement
Type system: Microsoft SQL Server 2008
Date format: YYYY-MM-DD hh:mm:ss
RH - numeric(5,2) (ratio)
ID: TW00604.RH
Relative Humidity
Type system: Microsoft SQL Server 2008
Unit: percent
Precision: 1
Numeric domain: type=real, min=0.0000 (exclusive=false), max=100.0000 (exclusive=false)
RH_FLAG - char(1) (nominal)
ID: TW00604.RH_FLAG
Relative humidity quality flag
Type system: Microsoft SQL Server 2008
Code definitions (4)
-
Good value
-
Q
Questionable
-
B
Bad
-
M
Missing
TW00605 - TW00605
Object name: TW00605.csv
Records: 156146
Attributes: 9
Temporal coverage: 2008-09-08 to 2011-03-21
File size: 9993520 byte
Checksum (MD5): 936a339341d5d98d82e4a3b8f24e41c0
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Attributes (9)
DBCODE - char(5) (nominal)
ID: TW00605.DBCODE
Database Code
Type system: Microsoft SQL Server 2008
Code definitions (1)
-
TW006
FSDB Database Code
ENTITY - numeric(2,0) (ratio)
ID: TW00605.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)
SITECODE - char(4) (nominal)
ID: TW00605.SITECODE
Sitecode Name
Type system: Microsoft SQL Server 2008
Code definitions (1)
-
WS01
Andrews Watershed 1
PLOTID - char(6) (nominal)
ID: TW00605.PLOTID
Plot Id consisting of watershed, unit, transect, and plot number (from TP073)
Type system: Microsoft SQL Server 2008
Code definitions (23)
-
P11101
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 01
-
P11102
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 02
-
P11103
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 03
-
P11104
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 04
-
P11105
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 05
-
P11107
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 07
-
P11108
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 08
-
P11109
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 09
-
P11110
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 10
-
P11112
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 12
-
P11211
Veg Study Plot (TP073) - WS01, Unit 1, Transect 2, Plot 11
-
P11316
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 16
-
P11318
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 18
-
P11321
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 21
-
P11419
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 19
-
P11422
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 22
-
P11425
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 25
-
P11518
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 18
-
P11521
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 21
-
P11526
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 26
-
P11603
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 03
-
P11605
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 05
-
P11607
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 07
METHOD - char(4) (nominal)
ID: TW00605.METHOD
Sampling method and interval
Type system: Microsoft SQL Server 2008
Code definitions (6)
-
DE2015
Decagon soil moisture unit Echo 20; 15 minute sampling interval
-
DE0515
Decagon soil moisture unit Echo 05; 15 minute sampling interval
-
CS15
Campbell Scientific thermistor; 15 minute sampling interval
-
CS60
Campbell Scientific thermistor; 1 hour sampling interval
-
CS24
Campbell Scientific thermistor; daily sampling
-
TB15
Tipping Bucket; 15 minute sampling interval
PROBE - char(8) (nominal)
ID: TW00605.PROBE
Probe number code
Type system: Microsoft SQL Server 2008
Code definitions (152)
-
A501C012
Air temperature in center of plot 501 near P11101 at 12 meter height
-
A502C012
Air temperature in center of plot 502 near P11102 at 12 meter height
-
A504C012
Air temperature in center of plot 504 near P11104 at 12 meter height
-
A505C012
Air temperature in center of plot 505 near P11105 at 12 meter height
-
A507C012
Air temperature in center of plot 507 near P11107 at 12 meter height
-
A508C012
Air temperature in center of plot 508 near P11108 at 12 meter height
-
A510C012
Air temperature in center of plot 510 near P11110 at 12 meter height
-
A512C012
Air temperature in center of plot 512 near P11112 at 12 meter height
-
R501C012
Relative humidity in center of plot 501 near P11101 at 12 meter height
-
R502C012
Relative humidity in center of plot 502 near P11102 at 12 meter height
-
R504C012
Relative humidity in center of plot 504 near P11104 at 12 meter height
-
R505C012
Relative humidity in center of plot 505 near P11105 at 12 meter height
-
R507C012
Relative humidity in center of plot 507 near P11107 at 12 meter height
-
R508C012
Relative humidity in center of plot 508 near P11108 at 12 meter height
-
R510C012
Relative humidity in center of plot 510 near P11110 at 12 meter height
-
R512C012
Relative humidity in center of plot 512 near P11112 at 12 meter height
-
S501C005
Soil temperature in center of plot 501 near P11101 at 5 centimeters depth
-
S501C030
Soil temperature in center of plot 501 near P11101 at 30 centimeters depth
-
S501C100
Soil temperature in center of plot 501 near P11101 at 100 centimeters depth
-
S502C005
Soil temperature in center of plot 502 near P11102 at 5 centimeters depth
-
S502C030
Soil temperature in center of plot 502 near P11102 at 30 centimeters depth
-
S502C100
Soil temperature in center of plot 502 near P11102 at 100 centimeters depth
-
S504C005
Soil temperature in center of plot 504 near P11104 at 5 centimeters depth
-
S504C030
Soil temperature in center of plot 504 near P11104 at 30 centimeters depth
-
S504C100
Soil temperature in center of plot 504 near P11104 at 100 centimeters depth
-
S505C005
Soil temperature in center of plot 505 near P11105 at 5 centimeters depth
-
S505C030
Soil temperature in center of plot 505 near P11105 at 30 centimeters depth
-
S505C100
Soil temperature in center of plot 505 near P11105 at 100 centimeters depth
-
S507C005
Soil temperature in center of plot 507 near P11107 at 5 centimeters depth
-
S507C030
Soil temperature in center of plot 507 near P11107 at 30 centimeters depth
-
S507C100
Soil temperature in center of plot 507 near P11107 at 100 centimeters depth
-
S508C005
Soil temperature in center of plot 508 near P11108 at 5 centimeters depth
-
S508C030
Soil temperature in center of plot 508 near P11108 at 30 centimeters depth
-
S508C100
Soil temperature in center of plot 508 near P11108 at 100 centimeters depth
-
S510C005
Soil temperature in center of plot 510 near P11110 at 5 centimeters depth
-
S510C030
Soil temperature in center of plot 510 near P11110 at 30 centimeters depth
-
S510C100
Soil temperature in center of plot 510 near P11110 at 100 centimeters depth
-
S512C005
Soil temperature in center of plot 512 near P11112 at 5 centimeters depth
-
S512C030
Soil temperature in center of plot 512 near P11112 at 30 centimeters depth
-
S512C100
Soil temperature in center of plot 512 near P11112 at 100 centimeters depth
-
M501N005
Soil moisture in north quad of plot 501 near P11101at 5 centimeters depth
-
M501N030
Soil moisture in north quad of plot 501 near P11101 at 30 centimeters depth
-
M501N100
Soil moisture in north quad of plot 501 near P11101 at 100 centimeters depth
-
M501S005
Soil moisture in south quad of plot 501 near P11101 at 5 centimeters depth
-
M501S030
Soil moisture in south quad of plot 501 near P11101 at 30 centimeters depth
-
M501S100
Soil moisture in south quad of plot 501 near P11101 at 100 centimeters depth
-
M501E005
Soil moisture in east quad of plot 501 near P11101 at 5 centimeters depth
-
M501E030
Soil moisture in east quad of plot 501 near P11101 at 30 centimeters depth
-
M501E100
Soil moisture in east quad of plot 501 near P11101 at 100 centimeters depth
-
M501W005
Soil moisture in west quad of plot 501 near P11101 at 5 centimeters depth
-
M501W030
Soil moisture in west quad of plot 501 near P11101 at 30 centimeters depth
-
M501W100
Soil moisture in west quad of plot 501 near P11101 at 100 centimeters depth
-
M502N005
Soil moisture in north quad of plot 502 near P11102 at 5 centimeters depth
-
M502N030
Soil moisture in north quad of plot 502 near P11102 at 30 centimeters depth
-
M502N100
Soil moisture in north quad of plot 502 near P11102 at 100 centimeters depth
-
M502S005
Soil moisture in south quad of plot 502 near P11102 at 5 centimeters depth
-
M502S030
Soil moisture in south quad of plot 502 near P11102 at 30 centimeters depth
-
M502S100
Soil moisture in south quad of plot 502 near P11102 at 100 centimeters depth
-
M502E005
Soil moisture in east quad of plot 502 near P11102 at 5 centimeters depth
-
M502E030
Soil moisture in east quad of plot 502 near P11102 at 30 centimeters depth
-
M502E100
Soil moisture in east quad of plot 502 near P11102 at 100 centimeters depth
-
M502W005
Soil moisture in west quad of plot 502 near P11102 at 5 centimeters depth
-
M502W030
Soil moisture in west quad of plot 502 near P11102 at 30 centimeters depth
-
M502W100
Soil moisture in west quad of plot 502 near P11102 at 100 centimeters depth
-
M504N005
Soil moisture in north quad of plot 504 near P11104 at 5 centimeters depth
-
M504N030
Soil moisture in north quad of plot 504 near P11104 at 30 centimeters depth
-
M504N100
Soil moisture in north quad of plot 504 near P11104 at 100 centimeters depth
-
M504S005
Soil moisture in south quad of plot 504 near P11104 at 5 centimeters depth
-
M504S030
Soil moisture in south quad of plot 504 near P11104 at 30 centimeters depth
-
M504S100
Soil moisture in south quad of plot 504 near P11104 at 100 centimeters depth
-
M504E005
Soil moisture in east quad of plot 504 near P11104 at 5 centimeters depth
-
M504E030
Soil moisture in east quad of plot 504 near P11104 at 30 centimeters depth
-
M504E100
Soil moisture in east quad of plot 504 near P11104 at 100 centimeters depth
-
M504W005
Soil moisture in west quad of plot 504 near P11104 at 5 centimeters depth
-
M504W030
Soil moisture in west quad of plot 504 near P11104 at 30 centimeters depth
-
M504W100
Soil moisture in west quad of plot 504 near P11104 at 100 centimeters depth
-
M505N005
Soil moisture in north quad of plot 505 near P11105 at 5 centimeters depth
-
M505N030
Soil moisture in north quad of plot 505 near P11105 at 30 centimeters depth
-
M505N100
Soil moisture in north quad of plot 505 near P11105 at 100 centimeters depth
-
M505S005
Soil moisture in south quad of plot 505 near P11105 at 5 centimeters depth
-
M505S030
Soil moisture in south quad of plot 505 near P11105 at 30 centimeters depth
-
M505S100
Soil moisture in south quad of plot 505 near P11105 at 100 centimeters depth
-
M505E005
Soil moisture in east quad of plot 505 near P11105 at 5 centimeters depth
-
M505E030
Soil moisture in east quad of plot 505 near P11105 at 30 centimeters depth
-
M505E100
Soil moisture in east quad of plot 505 near P11105 at 100 centimeters depth
-
M505W005
Soil moisture in west quad of plot 505 near P11105 at 5 centimeters depth
-
M505W030
Soil moisture in west quad of plot 505 near P11105 at 30 centimeters depth
-
M505W100
Soil moisture in west quad of plot 505 near P11105 at 100 centimeters depth
-
M507N005
Soil moisture in north quad of plot 507 near P11107 at 5 centimeters depth
-
M507N030
Soil moisture in north quad of plot 507 near P11107 at 30 centimeters depth
-
M507N100
Soil moisture in north quad of plot 507 near P11107 at 100 centimeters depth
-
M507S005
Soil moisture in south quad of plot 507 near P11107 at 5 centimeters depth
-
M507S030
Soil moisture in south quad of plot 507 near P11107 at 30 centimeters depth
-
M507S100
Soil moisture in south quad of plot 507 near P11107 at 100 centimeters depth
-
M507E005
Soil moisture in east quad of plot 507 near P11107 at 5 centimeters depth
-
M507E030
Soil moisture in east quad of plot 507 near P11107 at 30 centimeters depth
-
M507E100
Soil moisture in east quad of plot 507 near P11107 at 100 centimeters depth
-
M507W005
Soil moisture in west quad of plot 507 near P11107 at 5 centimeters depth
-
M507W030
Soil moisture in west quad of plot 507 near P11107 at 30 centimeters depth
-
M507W100
Soil moisture in west quad of plot 507 near P11107 at 100 centimeters depth
-
M508N005
Soil moisture in north quad of plot 508 near P11108 at 5 centimeters depth
-
M508N030
Soil moisture in north quad of plot 508 near P11108 at 30 centimeters depth
-
M508N100
Soil moisture in north quad of plot 508 near P11108 at 100 centimeters depth
-
M508S005
Soil moisture in south quad of plot 508 near P11108 at 5 centimeters depth
-
M508S030
Soil moisture in south quad of plot 508 near P11108at 30 centimeters depth
-
M508S100
Soil moisture in south quad of plot 508 near P11108 at 100 centimeters depth
-
M508E005
Soil moisture in east quad of plot 508 near P11108 at 5 centimeters depth
-
M508E030
Soil moisture in east quad of plot 508 near P11108 at 30 centimeters depth
-
M508E100
Soil moisture in east quad of plot 508 near P11108 at 100 centimeters depth
-
M508W005
Soil moisture in west quad of plot 508 near P11108 at 5 centimeters depth
-
M508W030
Soil moisture in west quad of plot 508 near P11108 at 30 centimeters depth
-
M508W100
Soil moisture in west quad of plot 508 near P11108 at 100 centimeters depth
-
M510N005
Soil moisture in north quad of plot 510 near P11110 at 5 centimeters depth
-
M510N030
Soil moisture in north quad of plot 510 near P11110 at 30 centimeters depth
-
M510N100
Soil moisture in north quad of plot 510 near P11110 at 100 centimeters depth
-
M510S005
Soil moisture in south quad of plot 510 near P11110 at 5 centimeters depth
-
M510S030
Soil moisture in south quad of plot 510 near P11110 at 30 centimeters depth
-
M510S100
Soil moisture in south quad of plot 510 near P11110 at 100 centimeters depth
-
M510E005
Soil moisture in east quad of plot 510 near P11110 at 5 centimeters depth
-
M510E030
Soil moisture in east quad of plot 510 near P11110 at 30 centimeters depth
-
M510E100
Soil moisture in east quad of plot 510 near P11110 at 100 centimeters depth
-
M510W005
Soil moisture in west quad of plot 510 near P11110 at 5 centimeters depth
-
M510W030
Soil moisture in west quad of plot 510 near P11110 at 30 centimeters depth
-
M510W100
Soil moisture in west quad of plot 510 near P11110 at 100 centimeters depth
-
M512N005
Soil moisture in north quad of plot 512 near P11105 at 5 centimeters depth
-
M512N030
Soil moisture in north quad of plot 512 near P11105 at 30 centimeters depth
-
M512N100
Soil moisture in north quad of plot 512 near P11112 at 100 centimeters depth
-
M512S005
Soil moisture in south quad of plot 512 near P11112 at 5 centimeters depth
-
M512S030
Soil moisture in south quad of plot 512 near P11112 at 30 centimeters depth
-
M512S100
Soil moisture in south quad of plot 512 near P11112 at 100 centimeters depth
-
M512E005
Soil moisture in east quad of plot 512 near P11112 at 5 centimeters depth
-
M512E030
Soil moisture in east quad of plot 512 near P11112 at 30 centimeters depth
-
M512E100
Soil moisture in east quad of plot 512 near P11112 at 100 centimeters depth
-
M512W005
Soil moisture in west quad of plot 512 near P11112 at 5 centimeters depth
-
M512W030
Soil moisture in west quad of plot 512 near P11112 at 30 centimeters depth
-
M512W100
Soil moisture in west quad of plot 512 near P11112 at 100 centimeters depth
-
M508E015
Soil moisture in east quad of plot 508 near P11108 at 15 centimeters depth
-
M508W015
Soil moisture in west quad of plot 508 near P11108 at 15 centimeters depth
-
M507E015
Soil moisture in east quad of plot 507 near P11107 at 15 centimeters depth
-
M507W015
Soil moisture in west quad of plot 507 near P11107 at 15 centimeters depth
-
M510E015
Soil moisture in east quad of plot 510 near P11110 at 15 centimeters depth
-
M510W015
Soil moisture in west quad of plot 510 near P11110 at 15 centimeters depth
-
M512E015
Soil moisture in east quad of plot 12 near P11112 at 15 centimeters depth
-
M512W015
Soil moisture in west quad of plot 512 near P11112 at 15 centimeters depth
-
P501C001
Precipitation in center of plot 501 near P11101 at 1 meter height
-
P502C001
Precipitation in center of plot 502 near P11102 at 1 meter height
-
P504C001
Precipitation in center of plot 504 near P11104 at 1 meter height
-
P505C001
Precipitation in center of plot 505 near P11105 at 1 meter height
-
P507C001
Precipitation in center of plot 507 near P11107 at 1 meter height
-
P508C001
Precipitation in center of plot 508 near P11108 at 1 meter height
-
P510C001
Precipitation in center of plot 510 near P11110 at 1 meter height
-
P512C001
Precipitation in center of plot 512 near P11112 at 1 meter height
DATETIME - datetime (dateTime)
ID: TW00605.DATETIME
Formatted time and date (PST) of measurement
Type system: Microsoft SQL Server 2008
Date format: YYYY-MM-DD hh:mm:ss
PPT - numeric(5,1) (ratio)
ID: TW00605.PPT
Precipitation
Type system: Microsoft SQL Server 2008
Unit: number
Precision: 1.000000
Numeric domain: type=real, min=0.0000 (exclusive=false), max=37.0000 (exclusive=false)
PPT_FLAG - char(1) (nominal)
ID: TW00605.PPT_FLAG
precipitation quality flag
Type system: Microsoft SQL Server 2008
Code definitions (4)
-
Good Value
-
M
Missing
-
Q
Questionable
-
B
Bad
TW00606 - TW00606
Object name: TW00606.csv
Records: 126
Attributes: 15
Temporal coverage: 2009-10-07 to 2011-05-05
File size: 10952 byte
Checksum (MD5): d725bd99961ed44d143896c8761c3ca7
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TW00606.PLOTID, TW00606.SITECODE, TW00606.YEAR, TW00606.SEASON
-
notNullConstraint: NOTNULL TW00606.DBCODE, TW00606.ENTITY, TW00606.PLOTID, TW00606.SITECODE, TW00606.YEAR, TW00606.SEASON, TW00606.SET_DATE, TW00606.DURATION
Attributes (15)
DBCODE - char(5) (nominal)
ID: TW00606.DBCODE
Database Code
Type system: Microsoft SQL Server 2008
Code definitions (1)
-
TW006
FSDB Database Code
ENTITY - numeric(2,0) (ratio)
ID: TW00606.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)
SITECODE - char(4) (nominal)
ID: TW00606.SITECODE
Sitecode Name
Type system: Microsoft SQL Server 2008
Code definitions (1)
-
WS01
Andrews Watershed 1
PLOTID - char(6) (nominal)
ID: TW00606.PLOTID
Plot Id consisting of watershed, unit, transect, and plot number (from TP073)
Type system: Microsoft SQL Server 2008
Code definitions (23)
-
P11101
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 01
-
P11102
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 02
-
P11103
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 03
-
P11104
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 04
-
P11105
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 05
-
P11107
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 07
-
P11108
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 08
-
P11109
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 09
-
P11110
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 10
-
P11112
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 12
-
P11211
Veg Study Plot (TP073) - WS01, Unit 1, Transect 2, Plot 11
-
P11316
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 16
-
P11318
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 18
-
P11321
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 21
-
P11419
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 19
-
P11422
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 22
-
P11425
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 25
-
P11518
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 18
-
P11521
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 21
-
P11526
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 26
-
P11603
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 03
-
P11605
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 05
-
P11607
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 07
YEAR - numeric(4,0) (dateTime)
ID: TW00606.YEAR
Year of measurements
Type system: Microsoft SQL Server 2008
Date format: number
SEASON - char(13) (nominal)
ID: TW00606.SEASON
Season of Measurement
Type system: Microsoft SQL Server 2008
Code definitions (7)
-
EARLY_FALL
August to October
-
LATE_FALL
October and November
-
WINTER
November to March
-
SPRING
March to May
-
SUMMER
May to August
-
FALL_WINTER
August to January
-
WINTER_SPRING
January to May
SET_DATE - datetime (dateTime)
ID: TW00606.SET_DATE
Date litter trap was set out in plot
Type system: Microsoft SQL Server 2008
Date format: YYYY-MM-DD
DURATION - numeric(3,0) (ratio)
ID: TW00606.DURATION
Number of days trap was out in the plot
Type system: Microsoft SQL Server 2008
Unit: number of days
Precision: 1
Numeric domain: type=natural, min=33.0000 (exclusive=false), max=172.0000 (exclusive=false)
NO_TRAPS - numeric(1,0) (interval)
ID: TW00606.NO_TRAPS
Number of traps collected from a plot
Type system: Microsoft SQL Server 2008
Unit: number
Precision: 1
Numeric domain: type=whole, min=0.0000 (exclusive=false), max=5.0000 (exclusive=false)
WET_MIX - numeric(6,2) (ratio)
ID: TW00606.WET_MIX
mass of wet litter total
Type system: Microsoft SQL Server 2008
Unit: grams
Precision: 1
Numeric domain: type=real, min=49.0000 (exclusive=false), max=818.0000 (exclusive=false)
WET_FINE - numeric(6,2) (ratio)
ID: TW00606.WET_FINE
mass of fine wet litter
Type system: Microsoft SQL Server 2008
Unit: grams
Precision: 1
Numeric domain: type=real, min=2.0000 (exclusive=false), max=285.0000 (exclusive=false)
DRY_FINE - numeric(6,2) (ratio)
ID: TW00606.DRY_FINE
mass of fine dry litter
Type system: Microsoft SQL Server 2008
Unit: grams
Precision: 1
Numeric domain: type=real, min=2.0000 (exclusive=false), max=119.0000 (exclusive=false)
WET_COARSE - numeric(6,2) (ratio)
ID: TW00606.WET_COARSE
mass of wet coarse litter
Type system: Microsoft SQL Server 2008
Unit: grams
Precision: 1
Numeric domain: type=real, min=0.5000 (exclusive=false), max=175.0000 (exclusive=false)
DRY_COARSE - numeric(6,2) (ratio)
ID: TW00606.DRY_COARSE
mass of dry coarse litter
Type system: Microsoft SQL Server 2008
Unit: grams
Precision: 1
Numeric domain: type=real, min=0.4000 (exclusive=false), max=186.0000 (exclusive=false)
COMMENTS - char(75) (nominal)
ID: TW00606.COMMENTS
Comments on collection
Type system: Microsoft SQL Server 2008
TW00607 - TW00607
Object name: TW00607.csv
Records: 444
Attributes: 7
Temporal coverage: 2010-11-13 to 2011-04-22
File size: 15566 byte
Checksum (MD5): cce70a2ecb8ebaadeb637dad3b4ea5a4
Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column
Constraints (2)
-
primaryKey: PRIMARY TW00607.DATE, TW00607.LYSIMETER
-
notNullConstraint: NOTNULL TW00607.DBCODE, TW00607.ENTITY, TW00607.DATE, TW00607.LYSIMETER, TW00607.DOC_CODE
Attributes (7)
DBCODE - char(5) (nominal)
ID: TW00607.DBCODE
Database Code
Type system: Microsoft SQL Server 2008
Code definitions (1)
-
TW006
FSDB Database Code
ENTITY - numeric(2,0) (ratio)
ID: TW00607.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)
DATE - datetime (dateTime)
ID: TW00607.DATE
Date of measurement
Type system: Microsoft SQL Server 2008
Date format: YYYY-MM-DD
PLOTID - char(6) (nominal)
ID: TW00607.PLOTID
Plot Id consisting of watershed, unit, transect, and plot number (from TP073)
Type system: Microsoft SQL Server 2008
Code definitions (23)
-
P11101
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 01
-
P11102
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 02
-
P11103
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 03
-
P11104
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 04
-
P11105
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 05
-
P11107
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 07
-
P11108
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 08
-
P11109
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 09
-
P11110
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 10
-
P11112
Veg Study Plot (TP073) - WS01, Unit 1, Transect 1, Plot 12
-
P11211
Veg Study Plot (TP073) - WS01, Unit 1, Transect 2, Plot 11
-
P11316
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 16
-
P11318
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 18
-
P11321
Veg Study Plot (TP073) - WS01, Unit 1, Transect 3, Plot 21
-
P11419
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 19
-
P11422
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 22
-
P11425
Veg Study Plot (TP073) - WS01, Unit 1, Transect 4, Plot 25
-
P11518
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 18
-
P11521
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 21
-
P11526
Veg Study Plot (TP073) - WS01, Unit 1, Transect 5, Plot 26
-
P11603
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 03
-
P11605
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 05
-
P11607
Veg Study Plot (TP073) - WS01, Unit 1, Transect 6, Plot 07
LYSIMETER - char(1) (nominal)
ID: TW00607.LYSIMETER
Lysimeter recorded (Left or Right)
Type system: Microsoft SQL Server 2008
Code definitions (2)
-
L
left lysimeter
-
R
right lysimeter
DOC - numeric(4,2) (ratio)
ID: TW00607.DOC
Conentration of Dissolved Organic Carbon in soil
Type system: Microsoft SQL Server 2008
Unit: milligrams per liter
Precision: 1
Numeric domain: type=real, min=0.0000 (exclusive=false), max=15.0000 (exclusive=false)
DOC_CODE - char(5) (nominal)
ID: TW00607.DOC_CODE
Conentration of Dissolved Organic Carbon in soil Code
Type system: Microsoft SQL Server 2008
Code definitions (2)
-
G
DOC value is good
-
N
No sample collected
Units
| micorgrams per cubic meter | ug/m3 | massDensity | micorgramPerMeterCubed | kilogramPerMeterCubed | 1000000000 | micorgrams per cubic meter |
| degrees Celsius | deg c | temperature | celsiusDegree | kelvin | 1 | Degrees Celsius; a common unit of temperature; constantToSI=273.18 |
| percent | % | dimensionless | number | dimensionless | 100 | percent; a number |
| number of days | days | time | nominalDay | second | 86400 | one day excluding leap seconds, 86400 seconds |
| grams | g | mass | gram | kilogram | 0.001 | grams; 0.001 kilogram |
| number | number | dimensionless | number | dimensionless | 1 | dimensionless number, i.e., ratio, count |
| milligrams per liter | mg/l | massDensity | milligramPerLiter | kilogramPerMeterCubed | 0.001 | milligrams per liter |
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. None
Licensed
License: N/A
Maintenance
Maintenance update frequency: continually
Description
- An update history is logged and maintained with each new version of every dataset.
Change History
-
Version1 (2007-05-14) Database level metadata entered from text document using ASP interface.
-
Version2 (2007-06-28) Uploaded metadata from Excel spreadsheets to SQL using move_xls programs.
-
Version3 (2007-11-20) Ran Adam's data model to move data from MySQL to SQL2005 to SQL2000 using staging tables.
-
Version4 (2008-04-28) Ran generic QA/QC from editdb on uploaded data.
-
Version5 (2008-09-03) Ran generic QA/QC (entities 1, 3, 4) from editdb on automatically uploaded data (uploads monthly). There are some errors with entity 3 that need to be corrected.
-
Version6 (2011-03-23) Updated F1, F3, F4, F5 (F2 has data issues) from FEEL database to FSDBDATA using feel_to_FSDB_revised SSIS data packages. Date generally updated through 3/22/2011
-
Version7 (2011-06-14) Added entity 6 for litter trap data (2 year collection).
-
Version8 (2012-08-30) Updated attribute description for attributes with a fine resolution datetime measurement scale to include 'PST' (pacific standard time).
-
Version9 (2012-12-14) Added entity 7 for DOC concentations
-
Version10 (2016-06-10) Rerun createcsv for new datafiles to upload to PASTA. Changed static_ascii to 'Q' for the large files to run through the query generator. Fixed HTML and other text errors (copy and paste from pdf) in methods.