Did You Find What You Needed?

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

Share Your Feedback

CP002: Precipitation chemistry concentrations and fluxes, HJ Andrews Experimental Forest, 1969 to present

← Back to catalog index

Go to Data Downloads Download Metadata Text (.txt) View Metadata in Browser (HTML) Download Metadata CSV (ZIP)

Status: annually
Period: 1968-10-01 to 2019-05-22
Version: 20
Published: 2019-08-28
EDI Package ID: knb-lter-and.4022.20
Source XML: CP002_20.xml

Notice

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

Citation

Johnson, S.; Fredriksen, R. 2019. Precipitation chemistry concentrations and fluxes, HJ Andrews Experimental Forest, 1969 to present Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/CP002 Accessed 2026-05-10.

Abstract

Collection and analyses of precipitation chemistry were initiated in 1969 at the low-elevation Primary Met site, and in 1973 at a mid-elevation Hi-15 site. Rain collection samples accumulate from one week to three weeks in bulk and NADP type collectors and then are transported to Cooperative Chemical Analytical Laboratory (CCAL) for analysis. Analytes include nitrogen, phosphorus, carbon, and cations and anions as well as pH, conductivity, alkalinity and particulate sediment. Concentration and volume of precipitation are combined for inflow. Dry deposition chemistry concentrations began in 1989 and are analyzed 2-4 times per year at one site. The original objectives were to evaluate precipitation chemistry inputs versus chemistry outputs in streamflow from forested watersheds. The study has evolved into a general monitoring effort for precipitation chemistry that is among the least contaminated of any within the USA. This study is conducted in conjunction with Andrews streamflow chemistry (CF002) and the U.S. National Atmospheric Deposition Program (NADP).

Coverage

Temporal coverage: 1968-10-01 to 2019-05-22

Geographic coverage: Andrews Experimental Forest within the Willamette National Forest. Sample sites are the H. J. Andrews Administrative site (PRIMET) and Watershed 7. The precipitation collector at the administrative site (RCADMN) represents nutrient input for Andrews Watersheds 2, 9, and 10. The original Hi-15 precipitation collector (RCHI15) and the current NADP-like collector (RCHIR7, RCHID7) represent nutrient input for the Andrews Hi-15 Watersheds 6, 7 and 8.

Spatial coverage:

Bounds: W -122.25588900, E -122.17674400, N 44.26663600, S 44.21184400

Purpose
  • The study examines precipitation chemistry and solute budgets in small watersheds. The original objective was to evaluate the magnitude of nutrient inputs and outputs after timber harvest, but is now an established general monitoring effort for precipitation chemistry.
Project

Title: Long-Term Ecological Research

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

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

Study Area Description
  • Long-Term Ecological Research
    The Andrews Forest is situated in the western Cascade Range of Oregon, and covers the entire 15,800-acre (6400-ha) drainage basin of Lookout Creek. Elevation ranges from 1350 to 5340 feet (410 to 1630 m). Broadly representative of the rugged mountainous landscape of the Pacific Northwest, the Andrews Forest contains excellent examples of the region's conifer forests and associated wildlife and stream ecosystems. These forests are among the tallest and most productive in the world, with tree heights of often greater than 250 ft (75 m). Streams are steep, cold and clean, providing habitat for numerous aquatic organisms.
Associated Party
  • Greg Downing
    Role: Method Contact
    Forestry Sciences Lab;3200 SW Jefferson Way, Corvallis, OR, 97333, USA
    Phone: (541) 750-7283, (541) 822-6301
    Email: greg.downing@oregonstate.edu
  • Richard L. Fredriksen
    Role: Creator
  • Stanley V. Gregory
    Role: Other Researcher
    Oregon State University;Dept. of Fisheries and Wildlife;Nash Hall 104, Corvallis, OR, 97331, USA
    Phone: (541) 737-1951
    Email: stanley.gregory@oregonstate.edu
  • Donald L. Henshaw
    Role: Abstractor
    Pacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, Oregon, 97331
    Email: hja_admin@fsl.orst.edu
  • Sherri L. Johnson
    Role: Principal Investigator
    US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: 541-758-7771
    Email: sherri.johnson2@usda.gov, sherri.johnson@oregonstate.edu
  • Sherri L. Johnson
    Role: Creator
    US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: 541-758-7771
    Email: sherri.johnson2@usda.gov, sherri.johnson@oregonstate.edu
  • Julia A. Jones
    Role: Other Researcher
    Oregon State University;Department of Geosciences; Wilkinson Hall 104, Corvallis, OR, 97331-5506, USA
    Phone: (541) 737-1224
    Email: Julia.Jones@oregonstate.edu, geojulia@comcast.net
  • Kate Lajtha
    Role: Other Researcher
    Oregon State University;Dept. of Botany and Plant Pathology;2059 Cordley Hall, Corvallis, OR, 97331, USA
    Phone: (541) 737-5674
    Email: lajthak@science.oregonstate.edu
  • Alfred B. Levno
    Role: Former Investigator
    Corvallis, OR, 97331, USA
    Email: ablevno@comcast.net, allevno@hotmail.com
  • C. Wayne Martin
    Role: Former Investigator
    Email: wmartin_03223@yahoo.com
  • W. Arthur McKee
    Role: Former Investigator
    Flathead Lake Biological Station ;The University of Montana ;300 Bio Station Lane, Polson, MT, 59860-9659, USA
    Phone: 406-982-3301
    Email: Art.McKee@umontana.edu
  • Mark D Schulze
    Role: Other Researcher
    H.J. Andrews Experimental Forest; PO Box 300, Blue River, OR, 97413
    Phone: 541-822-6336
    Email: mark.schulze@oregonstate.edu
Contact
  • Information Manager
    Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331
    Email: hjaweb@fsl.orst.edu
  • Donald L. Henshaw
    Pacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, Oregon, 97331
    Email: hja_admin@fsl.orst.edu
Publisher
  • Andrews Forest LTER Site
    Role: Publisher
    Forest Ecosystems and Society Department in Forestry, Oregon State University, 201K Richardson Hall, Corvallis, OR, 97331-5752
    Phone: (541) 737-8480
    Email: lterweb@fsl.orst.edu
Study Description

Collection and analyses of precipitation chemistry were initiated in 1969 at the low-elevation Primary Met site, and in 1973 at a mid-elevation Hi-15 site. Rain collection samples accumulate from one week to three weeks in bulk and NADP type collectors and then are transported to Cooperative Chemical Analytical Laboratory (CCAL) for analysis. Analytes include nitrogen, phosphorus, carbon, and cations and anions as well as pH, conductivity, alkalinity and particulate sediment. Concentration and volume of precipitation are combined for inflow. Dry deposition chemistry concentrations began in 1989 and are analyzed 2-4 times per year at one site. The original objectives were to evaluate precipitation chemistry inputs versus chemistry outputs in streamflow from forested watersheds. The study has evolved into a general monitoring effort for precipitation chemistry that is among the least contaminated of any within the USA. This study is conducted in conjunction with Andrews streamflow chemistry (CF002) and the U.S. National Atmospheric Deposition Program (NADP). The study examines precipitation chemistry and solute budgets in small watersheds. The original objective was to evaluate the magnitude of nutrient inputs and outputs after timber harvest, but is now an established general monitoring effort for precipitation chemistry. Field Methods - CP002

Purpose: The study examines precipitation chemistry and solute budgets in small watersheds. The original objective was to evaluate the magnitude of nutrient inputs and outputs after timber harvest, but is now an established general monitoring effort for precipitation chemistry.

Methods

Method Steps

Field Methods - CP002
  • Precipitation chemistry is sampled at a low elevation site (RCADMN at Primet, 430m) and a mid-elevation site (RCHIR7 in WS 7, 999m). Samples are stored in polyethylene containers until analysis. Prior to 1988, samples from both sites were collected every 3 weeks and transported to the Corvallis lab (CCAL) for analysis. Beginning October, 1988, samples are collected weekly and refrigerated at the Andrews. Precipitation samples are transported to Corvallis every 3-weeks, and weekly samples are analyzed individually. Beginning April 22, 2008, weekly samples are combined into a single composite sample and analyzed every 3 weeks similarly to the streamflow chemistry samples (CF002). Due to limited resources, winter-time, cold-weather samples (Nov-Mar) are only collected every 3 weeks, however, from April-Oct samples are still collected weekly and refrigerated.
  • Originally, collectors at both sites were open orifice (Polyethylene carboy jug with funnel). At the H. J. Andrews administrative low elevation site (RCADMN), precipitation was collected at the top of a 55 ft tower located in a clearcut. Water was stored in a polyethylene container inside an insulated shelter at the tower base. On January 20, 1982, the collector was moved to a 5 ft platform within 10 meters of the original location, and the polyethylene container is stored in an uninsulated bucket on the platform. At the mid-elevation site (RCHI15) precipitation was collected at the top of a 10 ft pole located in a clearcut near the top of Watershed #6. Water was stored in a polyethylene container inside an insulated shelter at the base of the pole. In October, 1988, a new collection site (RCHIR7) was started in a shelterwood with subsequent overstory removal near the top of Watershed # 7. An NADP-type wet/dry deposition sampler mounted on top of a 5 ft tower was used instead of the open orifice samplers used at the original site. The water is stored in polyethylene containers inside an uninsulated housing on top of the sampler. The "dry" side (RCHID7) container is collected and analyzed 2-4 times per year. The replacement collector (RCHIR7) and the original collector (RCHI15) at these mid-elevation sites were collected and analyzed concurrently for 9 weeks before the old site was discontinued.
  • Total precipitation from the Climatic Station WS#2 (CS2MET) by collection period was used in conjunction with nutrient analyses from the low elevation rain collector (RCADMN) to determine nutrient influx until 10/01/2002. Beginning with WY 2003 (10/01/2002), total precipitation from the Primary Meteorological Station (PRIMET) is used in conjunction with RCADMN. Total precipitation from the Hi-15 Meteorological Station (H15MET) by collection period is used in conjunction with nutrient analyses from the mid elevation rain collectors, originally RCHI15 and currently RCHIR7, to determine nutrient influx. Beginning with WY 2014 (1 Oct 2013), the NADP-style collector was dismantled and removed due to problematic operation. Dry deposition samples at this site were discontinued. Precipitation collection continues with an open orifice style collector (RCHIF7), which is located where the RCHIR7 NADP-style collector had been.
  • Assigning sample type codes (TYPE) is described here. Beginning Oct 1988, samples are collected weekly for analysis, and all samples are assigned sample type codes. A sample that is the result of precipitation collected continuously over the entire weekly period is considered a complete or full sample (TYPE="F"). Operational or other problems causing an incomplete or partial sample over the weekly period are coded as partial (TYPE="P"). Examples might include the malfunction of the sample lid on the NADP collector or possibly a collector overflow. Should zero precipitation result in no sample being collected for any week, sample type is no sample (TYPE='N'). Beginning 2007, there has been infrequent use of a sample type 'Biased' (TYPE='B'), which represents a wet collector sample that has had dry deposition input due to a faulty lid that is stuck open. Beginning April 22, 2008, samples are only analyzed every 3 weeks. If any of the weekly samples are partial or missing, the 3-week composite sample will be labeled sample type partial (TYPE='P').
  • Before Dec 1988, samples were collected on a 3-week basis. Successful operation of the collector over the 3 week period represents a complete or full (TYPE="F") sample. When the collector failed or was out of operation for any part of the 3 week period, the sample is designated as partial (TYPE="P"). When samples contained insufficient water for analysis, they were saved (TYPE='S') and combined (TYPE="C") with the following sample for analysis. Multiple samples might be saved and combined. In these cases the concentration data (Entity 1) and the flux data (entity 2) show precipitation for this entire period, and the "C"ombined sample's analytical measurements represent the entire period over which samples were saved.
  • Date and times listed as data_time in the data files refer to the end date of a collection period. Data is summarized by water year: October 1 to September 30. To allow summarization by water year, an artificial end-of-year sample point (TYPE="YE") is inserted on Sept 30 every year (Entity 2 flux data only) but is not an actual sample . Nutrient concentrations from the next analyzed sample (in October) are used with the precipitation total ending Sep 30 , the end of the wateryear, to calculate flux for this interval, which is designated TYPE="YE". Similarly, the flux value for this first sample of the new wateryear in October is calculated based on concentration values from the first October sample and on precipitation beginning Oct 1.

Instrumentation:

  • Andrews-designed collector (RCADMN, RCHI15, RCHIF7): An open orifice (polyethylene jug with funnel) located on a tower. Aerochem Metrics Model 301 NADP-type wet/dry deposition sampler (RCHIR7/RCHID7): The orifice of this collector is only open during precipitation events. It is controlled by a heated grid sensor which moves a cover from the "wet" side to the "dry"side when precipitation covers the grid of the sensor. The cover moves back to the "wet" side as the water is evaporated off the sensor grid by the heating element. The collector is modified for cold, snowy climates with an electric heater blanket and heat light to prevent freezing of the motor box and the lid arms and a v-shaped structure to prevent snow build-up.
Laboratory Methods - CP002
  • Laboratory procedures: Official compilation of water analyses begins with the WY 1969 (10/1/1968). Originally, samples are analyzed for suspended sediment, alkalinity, pH, ammonia nitrogen, nitrate, nitrite, dissolved kjeldahl nitrogen, ortho (reactive soluble) and total dissolved phosphorus, sodium, potassium, calcium, magnesium, and silica. Sulfate was determined for WY 1972 and sulfate and chloride in WY 1979. Sulphur and Chloride were analyzed at the University of Washington beginning 1988 until 2004, and are now conducted by CCAL at Oregon State. Analysis of specific conductivity was added in Dec 1974 and total P on an unfiltered samples in Oct 1974. Analysis of total kjeldahl N on an unfiltered sample was started in June 1978. Total N is calculated from the total Kjeldahl and NO-N until May 2005. Direct analytical measurement of Total dissolved N and Total N (unfiltered sample) begins in May 2005. Dissolved organic carbon analytical measurement begins in 2003. Aluminum, iron, manganese, and nitrite were below levels of detection and were subsequently dropped from analysis. In general, duplicates were run on all analyses until Oct 1983, and are currently conducted randomly.
  • Other notes on analyses: 1) Since dry deposition analyses were initiated in 1989, 250 ml of dionized water are added to the dry deposition samples before analyses. 2) From 1969 - 1973 samples were analyzed for free ammonia (FNH) prior to being digested for total nitrogen (DON). The FNH was driven off and collected and analyzed separately. Then the sample was digested and analyzed for DON. For these years TKN represents the sum of DON and FNH. Listed Total Kjeldahl N (TKN) values from 6/1/1970-6/21/1971 for RCADMN do not include free ammonia (NH-N) and are shown as estimated. 3) A combination of factors cause the results for silica prior to 17 March 1983 to be labeled as "Q"uestionable. Historic records indicate that many, if not all, of the samples prior to that date were frozen prior to analysis for silica. Freezing samples prior to analysis for silica will reduce the final analyzed concentration of reactive silica (the form we have historically determined). Another complicating factor is that the methodology changed about this same time. Until 1982, a stannous chloride method was used to determine silica, and this method is more prone to variability due to reagent instability.
  • Until May 2005, the CCAL lab analyzed for total dissolved Kjeldahl nitrogen (TKN) and also for total Kjeldahl nitrogen (UTKN), which is performed using an unfiltered sample and includes any particulates (sediment, biota) present. All dissolved results exclude particulates of 0.7 microns or greater. TKN includes NH-N, but does not include NO-N. The following are mathematically calculated in the data set and coded as 'D' when this occurs:
  • Dissolved organic nitrogen (DON) = TKN - NHN
  • Total dissolved nitrogen (TDN) = TKN + NON (directly analyzed after May 2005)
  • Total nitrogen (UTN) = UTKN + NON (directly analyzed after May 2005)
  • Particulate nitrogen (PARTN) = UTKN-TKN, or UTN-TDN (after May 2005)
  • Particulate phosphorous (PARTP) = UTP - TDP
  • Currently, all samples are filtered upon arrival at the Corvallis lab (CCAL) and pH, alkalinity, conductivity, and autoanalyzer runs (NO-N, NH-N, SI) are made immediately. All analyses are completed within 6 weeks. Generally, samples are stored at 0 degrees C if not analyzed immediately. In the first year of sample collection (1968-1969), water was stored at 0 degrees C until operation of the PNW-1653 local lab in spring, 1969.
  • Generally, there is much greater trust and consistency to analytical measurements beginning in 1983.
Processing Procedure - CP002
  • A Visual Foxpro program (pio_true) combines nutrient concentration data with precipitation to produce outputs in kilogram per hectare by water year (Entity 2), and creates annual nutrient concentrations (Entity 3). This program replaces the original PIO99 Fortran program in March 2005.
  • Precipitation values are obtained from both CS2MET (before WY2003) and PRIMET (beginning WY 2003) for the RCADMN rain collector. Precipitation values are obtained from both H15MET (before WY2006) and CENMET (beginning WY 2006) for the Hi-15 rain collectors (RCHI15, RCHIR7, and RCHIF7).
Laboratory Methods - CCAL: Alkalinity
  • APHA 2320, titrate to pH 4.5. Modifications: Use 0.02N Na2CO3 and 0.02N H2SO4

Instrumentation:

  • Radiometer type TTT lc auto-titrator with glass pH electrode, calomel reference electrode and temperature compensator electrode
Laboratory Methods - CCAL: Ammonia
  • APHA 4500-NH3 G; EPA 350.1

Instrumentation:

  • Technicon Auto-Analyzer II
Laboratory Methods - CCAL: Calcium
  • APHA 3111 D; flame atomic absorption spectroscopy. Modifications: nitrous oxide/ acetylene flame. Addition of 1 ml 50,000 mg/1 lanthanum oxide to 10 ml sample to control ionization.

Instrumentation:

  • Varian SpectrAA220; Metals by Flame Atomic Absorption Spectrometry; Nitrous Oxide-Acetylene Flame Method
Laboratory Methods - CCAL: Diss. Organic Carbon
  • APHA 5310 B

Instrumentation:

  • Shimadzu TOC-VCSH Combustion Analyzer
Laboratory Methods - CCAL: Chloride
  • APHA 4110 B; EPA 9056A

Instrumentation:

  • Dionex 1500 Ion Chromatograph
Laboratory Methods - CCAL: Specific conductance
  • APHA 2510; Wheatstone bridge.

Instrumentation:

  • YSI model 3200
Laboratory Methods - CCAL: Magnesium
  • APHA 3111 B; flame atomic absorption spectroscopy.

Instrumentation:

  • Varian SpectrAA220; Metals by Flame Atomic Absorption Spectrometry; Direct Air-Acetylene Flame Method
Laboratory Methods - CCAL: Nitrate
  • APHA 4500-NO3 F; EPA 353.3. Cadmium reduction method.

Instrumentation:

  • Technicon Auto-Analyzer II
Laboratory Methods - CCAL: Total nitrogen
  • Persulfate digestion and analysis by automated colorimetric analysis

Instrumentation:

  • Technicon Auto-Analyzer II
Laboratory Methods - CCAL: pH
  • APHA 4500 H; Calomel reference electrode, glass pH electrode, temperature compensator.

Instrumentation:

  • Radiometer type TTT lc auto-titrator with glass pH electrode, calomel reference electrode and temperature compensator electrode
Laboratory Methods - CCAL: Ortho phosphate
  • APHA 4500-P E; EPA 365.2. Ascorbic acid method.

Instrumentation:

  • Milton-Roy 601 Spectrophotometer with 10 cm pathlength
Laboratory Methods - CCAL: Total phosphorous
  • APHA 4500-P B; APHA 4500-P E; EPA 365.2. Modifications: microwave digestion 60 minutes, 50 ml analysis volume, Ascorbic acid method.
  • The laboratory has automated the method used for analysis of total phosphorus (total phosphorus for unfiltered samples and total dissolved phosphorus for filtered samples) as of 16 June 2010. Samples submitted to the laboratory will now be analyzed using the Technicon Auto-Analyzer II (the same instrument used for analysis of nitrate, ammonia, phosphate, silica and total nitrogen). We have discontinued the routine use of the manual method using the Milton-Roy 601 spectrophotometer at this time.
  • We ran the manual method through the end of calendar year 2010 in an attempt to run comparisons for projects with historic results from the manual method. Results indicate there is expectation for reduced UTP/TDP due to the analytical change.

Instrumentation:

  • Milton-Roy 601 Spectrophotometer with 10 cm pathlength and the Technicon Auto-Analyzer II beginning June 2010
Laboratory Methods - CCAL: Potassium
  • APHA 3111 B; flame atomic absorption spectroscopy.

Instrumentation:

  • Varian SpectrAA220; Metals by Flame Atomic Absorption Spectrometry; Direct Air-Acetylene Flame Method
Laboratory Methods - CCAL: Silica
  • APHA 4500-SiO2 E; Technicon industrial method 105-71W/B.

Instrumentation:

  • Technicon Auto-Analyzer II
Laboratory Methods - CCAL: Sodium
  • APHA 3111 B; flame atomic absorption spectroscopy.

Instrumentation:

  • Varian SpectrAA220; Metals by Flame Atomic Absorption Spectrometry; Direct Air-Acetylene Flame Method
Laboratory Methods - CCAL: Sulfate
  • APHA 4110 B; EPA 9056A

Instrumentation:

  • Dionex1500 Ion Chromatograph
Laboratory Methods - CCAL: Suspended sediment
  • APHA 2540 D

Sampling

Study Extent
  • The Administrative Rain Collector represents nutrients inputs in conjunction with streamflow outputs for WS 1, 2, 3, 9, and 10, and is positioned among these stream gaging stations.
  • Watersheds 1, 2, 3: Though Watersheds 1, 2, and 3 are similar in terms of climate, geology, soils, and topography, they differ in average annual water yield. During the pre-harvest period 1953-1962, Watersheds 1 and 3 produced 86% and 88%, respectively, of the annual average streamflow produced by Watershed 2 (Rothacher et al 1967). From 1964 to 1992, Watershed 2 annual streamflow yield averaged 126 cm and ranged from 37 to 214 cm. Annual runoff: precipitation ratios averaged 0.56 and ranged from 0.28 to 0.71. Monthly runoff volumes follow closely the seasonal pattern of precipitation. Largest runoff volumes occur in December and January, and smallest in August and September. Typically, the largest peak flows occur during rain-on-snow events in which latent heat transfers melt shallow warm snowpacks, increasing water input to the soil by up to 25% (Harr 1981). Maximum rates of runoff during these events may exceed 80 percent of the average rate of precipitation for the preceding 12 to 24 hours (Rothacher et al 1967).
  • Watersheds 9 and 10: Prior to logging, vegetation on both watersheds consisted primarily of 450-year-old Douglas-fir mixed with hemlock and younger Douglas-fir. WS 9 left undisturbed as the control, 21 ac. WS 10 logged by skyline system to single landing, spring, summer 1975. WS 10 unburned, 25 acres. The Hi-15 Rain Collector represents nutrients inputs in conjunction with streamflow outputs for WS 6, 7, and 8 and is positioned on WS 7.
  • Watersheds 6, 7, and 8: The high-elevation watersheds also show differences in annual water yield. During the pre-harvest period 1964-1974, Watersheds 6 and 7 produced 113% and 79%, respectively, of the annual average streamflow produced by Watershed 8 (Harr et al 1982). From 1964 to 1992, Watershed 8 annual streamflow yield averaged 122 cm and ranged from 43 to 218 cm. Annual runoff: ppt ratios averaged 0.56 and ranged from 0.34 to 0.76. Monthly runoff volumes in the high-elevation watersheds follow the same pattern as observed in the lower-elevation watersheds. Snowpack in the high-elevation watersheds tends to be deeper, colder, and more persistant than in the lower watersheds. Contribution of snowmelt to streamflow may continue through June.
  • Sampling frequency: 1-3 weeks
Sampling Description
  • Precipitation samples from two rain collectors and one dry deposition collector are analyzed for nutrient concentrations and fluxes calculated using amount of precipitation inputs during that period. The rain collector at the low elevation administrative site (RCADMN) was established in 1968 in conjunction with stream water chemistry measurements at Andrews WS 9 (control) and WS 10 (clearcut), and also used in conjunction with WS1 (clearcut) and WS2 (control). The rain and dry deposition collectors at the Hi-15 mid-elevation site (positioned mid-slope WS 7) are paired with the HI-15 small watershed study including streamflow nutrient concentration and outflows on WS 8 (control), WS 6 (clearcut), and WS7 (shelterwood cut). Dry deposition samples were discontinued after after WY 2013. The original HI-15 rain collector (RCHI15) was established mid-slope WS 6 in 1969 and replaced with an NADP-style collector in 1988, which separates precipitation collection (RCHIR7) and dry deposition collection (RCHID7). Beginning 1 October 2013 the NADP-style collector was removed and a bulk collection sample initiated (RCHIF7) at the same site in the Hi-15.
Spatial Sampling Units
  • Andrews Watershed 1
    W -122.25683100, E -122.23581300, N 44.20851700, S 44.19901700
    Altitude: 1027 to 1027 meter
  • Andrews Watershed 10
    W -122.25996600, E -122.25443900, N 44.22015200, S 44.21678600
    Altitude: 679 to 679 meter
  • Andrews Watershed 2
    W -122.24397600, E -122.22974100, N 44.21338500, S 44.20617800
    Altitude: 1079 to 1079 meter
  • Andrews Watershed 6
    W -122.18351000, E -122.17755000, N 44.26680800, S 44.26154400
    Altitude: 1029 to 1029 meter
  • Andrews Watershed 7
    W -122.17920900, E -122.17387500, N 44.26974800, S 44.26457900
    Altitude: 1102 to 1102 meter
  • Andrews Watershed 8
    W -122.17079300, E -122.17079300, N 44.26629400, S 44.26588100
    Altitude: 1182 to 1182 meter
  • Andrews Watershed 9
    W -122.25781500, E -122.25151500, N 44.20393300, S 44.20111000
    Altitude: 731 to 731 meter
  • Andrews Administrative Site rain collector (WS 9&10 RC)
    W -122.25588900, E -122.25588900, N 44.21184400, S 44.21184400
    Altitude: 430 to 430 meter
  • Andrews Watershed 7 NADP-style rain collector
    W -122.17674400, E -122.17674400, N 44.26663600, S 44.26663600
    Altitude: 999 to 999 meter
  • Andrews Watershed 7 NADP-style dry deposition collector
    W -122.17674400, E -122.17674400, N 44.26663600, S 44.26663600
    Altitude: 999 to 999 meter
  • Andrews Watershed 7 bulk collector - wet and dry deposition
    W -122.17674400, E -122.17674400, N 44.26663600, S 44.26663600
    Altitude: 999 to 999 meter
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: hydrology (theme), water chemistry (theme), precipitation (theme), chemical properties (theme), concentration (theme), suspended solids (theme), timber harvest (theme), inorganic nutrients (theme), nutrients (theme), water (theme)
  • LTER core research areas: inorganic nutrients (theme)
Taxonomic Hierarchy

No taxonomic hierarchy listed in this EML file.

Data Entities
# Entity Metadata Data
1 CP00201
CP00201
Precipitation water sample nutrient concentrations: Precipitation samples are collected and analyzed on a 3-week basis for nutrient concentrations. Precipitation amounts for each sampling period are provided.
 METADATA DATA
2 CP00202
CP00202
Precipitation water nutrient inflow in kg/ha: Derived nutrient inputs based on precipitation nutrient concentration data (Entity 1) and actual precipitation for the sampling period.
 METADATA DATA
3 CP00203
CP00203
Precipitation water nutrient mean annual concentrations: Mean annual precipitation nutrient concentrations are calculated from the concentration data (Entity 1).
 METADATA DATA
4 CP00206
CP00206
Precipitation water sample log sheet: field and laboratory comments:
 METADATA DATA
Metadata
CP00201 - CP00201

Object name: CP00201.csv

Records: 3123

Attributes: 61

Temporal coverage: 1968-10-01 to 2019-05-22

File size: 639574 byte

Checksum (MD5): bc11d5f7598fdcac3f337af9bee0d12a

Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column

Constraints (2)
  • primaryKey: PRIMARY
    CP00201.SITECODE, CP00201.DATE_TIME
  • notNullConstraint: NOTNULL
    CP00201.STCODE, CP00201.TYPE, CP00201.SITECODE, CP00201.ENTITY, CP00201.DATE_TIME
Attributes (61)
STCODE - char(5) (nominal)

ID: CP00201.STCODE

Study code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • CP002
    Study code CP002
ENTITY - numeric(1,0) (ratio)

ID: CP00201.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

Numeric domain: type=natural, min=1.0000 (exclusive=false), max=1.0000 (exclusive=false)

SITECODE - char(6) (nominal)

ID: CP00201.SITECODE

Precipitation or dry deposition collector site code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • RCADMN
    Andrews Administrative Site rain collector (WS 9&10 RC)
  • RCHI15
    Andrews original HI-15 rain collector
  • RCHIR7
    Andrews Watershed 7 NADP-style rain collector
  • RCHID7
    Andrews Watershed 7 NADP-style dry deposition collector
  • RCHIF7
    Andrews Watershed 7 bulk collector - wet and dry deposition
WATERYEAR - numeric(4,0) (interval)

ID: CP00201.WATERYEAR

Water year of sample or annual summary (October-September)

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

Numeric domain: type=natural, min=1969.0000 (exclusive=false), max=2019.0000 (exclusive=false)

DATE_TIME - datetime (dateTime)

ID: CP00201.DATE_TIME

Collection date and time (PST) of the precipitation sample - sample represents deposition from the previous sample date and time. Assume beginning date of first sample period for each collector is October 1st.

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD hh:mm:ss

LABNO - char(4) (nominal)

ID: CP00201.LABNO

Lab number code for sample

Type system: Microsoft SQL Server 2008

TYPE - char(2) (nominal)

ID: CP00201.TYPE

Sample type indicator - indicates dry deposition samples and other qualifying information

Type system: Microsoft SQL Server 2008

Code definitions (10)
  • S
    Sample saved and combined with the following collection due to insufficient water for analyses - samples were no longer saved and combined after 1981
  • P
    Partial sample - precipitation was not collected successfully over the entire period (includes problems with NADP-style collector motor or samples that may have overflowed)
  • YE
    Year end marker allows summary by water year - this is not a sample. Flux values are calculated from precip ending Sep 30 and use analyte concentrations from the following sample. 'YE' markers are inserted every Sep 30.
  • C
    Sample is combined with preceeding saved sample(s) for analysis. Combined samples of this type are not used after 1981.
  • DW
    Dry deposition sample - dry bucket contains rain water
  • F
    Sample is successfully collected over the entire period - a "Full" sample.
  • N
    No sample is collected - generally indicates periods of little or no rain, but can be a lost sample.
  • DF
    Dry deposition sample - sample is dry and not contaminated with precipitation water
  • B
    Biased sample - Lid on NADP sampler malfunctions and sample includes dry deposition
  • DC
    Dry deposition sample - dry bucket contains rain water and other insects/contaminants
PRECIP_CM - numeric(7,2) (ratio)

ID: CP00201.PRECIP_CM

Precipitation in centimeters for the exact sample period. Based on precipitation stations CS2MET or PRIMET (beginning WY 2003) for collector RCADMN and H15MET or CENMET (beginning WY 2006) for collectors RCHIF7, RCHIR7 and RCHI15.

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=61.8700 (exclusive=false)

PCODE - char(1) (nominal)

ID: CP00201.PCODE

Precipitation value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • N
    No precipitation recorded for period. For saved sample (type='S'), precipitation for this period is included in the following period.
  • E
    Estimated precipitation
  • A
    Accepted value for precipitation
  • Q
    Precipitation value is questionable
  • M
    Missing value
PH - numeric(5,1) (ratio)

ID: CP00201.PH

pH (hydrogen concentration); method: glass electrode

Type system: Microsoft SQL Server 2008

Unit: pH units

Precision: 0.100000

Numeric domain: type=real, min=3.0000 (exclusive=false), max=7.4000 (exclusive=false)

PHCODE - char(1) (nominal)

ID: CP00201.PHCODE

pH value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (4)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • Q
    Value is questionable (used beginning in 1991)
COND - numeric(6,1) (ratio)

ID: CP00201.COND

Specific conductance; method: wheatstone bridge

Type system: Microsoft SQL Server 2008

Unit: micro siemens per centimeter

Precision: 0.400000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=576.4000 (exclusive=false)

CONDCODE - char(1) (nominal)

ID: CP00201.CONDCODE

Conductivity value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
ALK - numeric(6,2) (ratio)

ID: CP00201.ALK

Alkalinity as calcium carbonate (CaCO3); method: electrometric titration to pH 4.5; all data is converted from the formerly used units of bicarbonate carbon (HCO3-C)

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.020000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=15.3700 (exclusive=false)

ALKCODE - char(1) (nominal)

ID: CP00201.ALKCODE

Alkalinity value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
SSED - numeric(7,2) (ratio)

ID: CP00201.SSED

Suspended sediment concentration; method: nonfiltrable residue, gravimetric

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=796.0000 (exclusive=false)

SSEDCODE - char(1) (nominal)

ID: CP00201.SSEDCODE

Suspended sediment value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (4)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • Q
    Value is questionable (used beginning in 1991)
SI - numeric(6,2) (ratio)

ID: CP00201.SI

Silica as silicon concentration; method: automated molybdenum blue

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.050000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=8.9100 (exclusive=false)

SICODE - char(1) (nominal)

ID: CP00201.SICODE

Silica value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
UTP - numeric(8,3) (ratio)

ID: CP00201.UTP

Unfiltered total phosphorus concentration; method: persulfate/H2SO4 digestion, ascorbic acid finish

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.002000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=1483.0000 (exclusive=false)

UTPCODE - char(1) (nominal)

ID: CP00201.UTPCODE

Unfiltered total phosphorus value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
TDP - numeric(6,3) (ratio)

ID: CP00201.TDP

Total dissolved phosphorus concentration; method: persulfate/H2SO4 digestion, ascorbic acid finish

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.002000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=6.0500 (exclusive=false)

TDPCODE - char(1) (nominal)

ID: CP00201.TDPCODE

Total dissolved phosphorus value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
PARTP - numeric(8,3) (ratio)

ID: CP00201.PARTP

Particulate P, also known as total suspended phosphorus - not measured analytically; mathematically determined by subtraction of Total Dissolved P (TDP) from Unfiltered Total P (UTP)

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.002000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=1482.6000 (exclusive=false)

PARTPCODE - char(2) (nominal)

ID: CP00201.PARTPCODE

Particulate P value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • N
    No derived value is calculated due to missing analytical components
  • D
    Derived value - mathematically determined from other analytical measurements
  • D*
    Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit
  • DE
    Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values
  • DQ
    Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values
PO4P - numeric(6,3) (ratio)

ID: CP00201.PO4P

Ortho phosphorus concentration, soluble reactive phosphorus, phosphate (PO4-P); method: ascorbic acid finish

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.001000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=5.9930 (exclusive=false)

PO4PCODE - char(1) (nominal)

ID: CP00201.PO4PCODE

Ortho phosphorus value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
UTN - numeric(6,2) (ratio)

ID: CP00201.UTN

Total nitrogen concentration (unfiltered sample); method: persulfate digestion and analysis by automated colorimetric analysis; instrument: Technicon Auto-Analyzer II

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=15.9900 (exclusive=false)

UTNCODE - char(2) (nominal)

ID: CP00201.UTNCODE

Unfiltered total nitrogen value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • A
    Accepted value
  • E
    Estimated value
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
  • D
    Derived value - mathematically determined from other analytical measurements
  • D*
    Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit
  • DE
    Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values
  • DQ
    Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values
  • N
    No analytical measurement or no derived value calculated due to missing analytical components
TDN - numeric(6,2) (interval)

ID: CP00201.TDN

Total dissolved nitrogen concentration (filtered sample); method: persulfate digestion and analysis by automated colorimetric analysis; instrument: Technicon Auto-Analyzer II

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=14.3700 (exclusive=false)

TDNCODE - char(2) (nominal)

ID: CP00201.TDNCODE

Total dissolved nitrogen value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • A
    Accepted value
  • E
    Estimated value
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
  • D
    Derived value - mathematically determined from other analytical measurements
  • D*
    Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit
  • DE
    Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values
  • DQ
    Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values
  • N
    No analytical measurement or no derived value calculated due to missing analytical components
DON - numeric(6,2) (ratio)

ID: CP00201.DON

Dissolved organic nitrogen - not measured analytically; mathematically determined by subtracting NH3-N and NO3-N from Total dissolved nitrogen. Values before May 2005 are determined by TKN minus NH3-N.

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=10.8700 (exclusive=false)

DONCODE - char(2) (nominal)

ID: CP00201.DONCODE

Dissolved organic nitrogen value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • N
    No derived value is calculated due to missing analytical components
  • D
    Derived value - mathematically determined from other analytical measurements
  • D*
    Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit
  • DE
    Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values
  • DQ
    Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values
PARTN - numeric(6,2) (ratio)

ID: CP00201.PARTN

Particulate N, also known as total suspended nitrogen - not measured analytically; mathematically determined by subtraction of Total dissolved nitrogen (TDN) from Unfiltered Total nitrogen (UTN). Values before May 2005 are determined by UTKN minus TKN.

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=5.1000 (exclusive=false)

PARTNCODE - char(2) (nominal)

ID: CP00201.PARTNCODE

Particulate N value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • N
    No derived value is calculated due to missing analytical components
  • D
    Derived value - mathematically determined from other analytical measurements
  • D*
    Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit
  • DE
    Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values
  • DQ
    Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values
UTKN - numeric(6,2) (ratio)

ID: CP00201.UTKN

Total Kjeldahl nitrogen concentration on unfiltered sample; method: Kjeldahl digestion H2SO4, CuSO4/KCl, nessler finish

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=2.6700 (exclusive=false)

UTKNCODE - char(1) (nominal)

ID: CP00201.UTKNCODE

Unfiltered total Kjeldahl nitrogen value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
TKN - numeric(6,2) (ratio)

ID: CP00201.TKN

Total Kjeldahl nitrogen concentration on filtered sample (dissolved); method: Kjeldahl digestion H2SO4, CuSO4/KCl, nessler finish

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=14.3100 (exclusive=false)

TKNCODE - char(1) (nominal)

ID: CP00201.TKNCODE

Total Kjeldahl nitrogen value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
NH3N - numeric(6,3) (ratio)

ID: CP00201.NH3N

Ammonia-nitrogen (NH3-N) concentration, ammonia as nitrogen; method: automated phenate

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.003000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=3.9160 (exclusive=false)

NH3NCODE - char(1) (nominal)

ID: CP00201.NH3NCODE

NH3-N value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (6)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
  • C
    Value confirmed, contamination suspected (code use begins May 2007)
NO3N - numeric(6,3) (ratio)

ID: CP00201.NO3N

Nitrate-nitrogen (NO3-N), nitrate + nitrite as nitrogen concentration; method: automated cadmium reduction

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.001000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=1.8800 (exclusive=false)

NO3NCODE - char(1) (nominal)

ID: CP00201.NO3NCODE

NO3-N value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (6)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
  • C
    Value confirmed, contamination suspected (code use begins May 2007)
NA - numeric(6,2) (ratio)

ID: CP00201.NA

Na, dissolved sodium (filtrable) concentration; method flame atomic absorption spectroscopy

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=18.2300 (exclusive=false)

NACODE - char(1) (nominal)

ID: CP00201.NACODE

Na value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
K - numeric(6,2) (ratio)

ID: CP00201.K

K, dissolved potassium (filtrable) concentration; method flame atomic absorption spectroscopy

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.030000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=18.2000 (exclusive=false)

KCODE - char(1) (nominal)

ID: CP00201.KCODE

K value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
CA - numeric(6,2) (ratio)

ID: CP00201.CA

Ca, dissolved calcium (filtrable) concentration; method flame atomic absorption spectroscopy

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.060000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=5.5600 (exclusive=false)

CACODE - char(1) (nominal)

ID: CP00201.CACODE

Ca value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
MG - numeric(6,2) (ratio)

ID: CP00201.MG

Mg, dissolved magnesium (filtrable) concentration; method flame atomic absorption spectroscopy

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.020000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=15.9500 (exclusive=false)

MGCODE - char(1) (nominal)

ID: CP00201.MGCODE

Mg value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
SO4S - numeric(6,2) (ratio)

ID: CP00201.SO4S

SO4-S (dissolved) concentration, sulfate as sulfur; method ion chromatography (automated barium sulfate before 1993)

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.020000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=4.8900 (exclusive=false)

SO4SCODE - char(1) (nominal)

ID: CP00201.SO4SCODE

SO4-S value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
CL - numeric(6,2) (ratio)

ID: CP00201.CL

Chloride (dissolved) concentration; method: ion chromatography (automated ferric thiocyanate before 1993)

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=47.2000 (exclusive=false)

CLCODE - char(1) (nominal)

ID: CP00201.CLCODE

Cl value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
DOC - numeric(6,2) (ratio)

ID: CP00201.DOC

DOC, dissolved organic carbon concentration; method: combustion

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.050000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=26.8000 (exclusive=false)

DOCCODE - char(1) (nominal)

ID: CP00201.DOCCODE

DOC value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
PVOL - numeric(7,3) (ratio)

ID: CP00201.PVOL

Sample volume from precipitation collector; for dry deposition sample - includes any precipitation collected and DI water added to sample for analysis

Type system: Microsoft SQL Server 2008

Unit: kilograms

Precision: 0.001000

Numeric domain: type=real, min=0.0080 (exclusive=false), max=19.9800 (exclusive=false)

PVOLCODE - char(1) (nominal)

ID: CP00201.PVOLCODE

Sample volume qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (6)
  • Q
    Sample volume value is questionable - typically implies volume is measured correctly, but volume does not represent the entire collection period
  • N
    No sample volume value available
  • A
    Accepted value
  • K
    Volume is precipitation plus added DIW (usually 250 ml). concentration values are based on this volume.
  • L
    Volume of lab water (DIW) added to dry bucket (usually 250 ml). concentration values are based on this volume.
  • M
    Volume is precipitation in dry bucket (liters). Concentration values are based on this volume. No DIW added to the precipitation water.
ANCA - numeric(5,2) (ratio)

ID: CP00201.ANCA

Anion-cation ratio: micro equivalence ratio of anions to cations by calculation - provided only as an analytical check. Requires anions: ALK, SO4S, CL, NO3N, PO4P, cations: pH, Na, K, Ca, Mg, NH4N

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 0.100000

Numeric domain: type=real, min=0.1200 (exclusive=false), max=6.9500 (exclusive=false)

ANCACODE - char(2) (nominal)

ID: CP00201.ANCACODE

Anion-cation ratio qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • N
    No anion-cation ratio calculation determined due to missing analytical components
  • D
    Derived anion-cation ratio value is based on the full set of anions and cations
  • D*
    Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit
  • DE
    Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values
  • DQ
    Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values
CP00202 - CP00202

Object name: CP00202.csv

Records: 3097

Attributes: 53

Temporal coverage: 1968-10-01 to 2018-10-01

File size: 572493 byte

Checksum (MD5): 7a00af0bd44f8b22a9d97157c970888b

Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column

Constraints (2)
  • primaryKey: PRIMARY
    CP00202.SITECODE, CP00202.DATE_TIME
  • notNullConstraint: NOTNULL
    CP00202.STCODE, CP00202.TYPE, CP00202.SITECODE, CP00202.ENTITY, CP00202.DATE_TIME
Attributes (53)
STCODE - char(5) (nominal)

ID: CP00202.STCODE

Study code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • CP002
    Study code CP002
ENTITY - numeric(1,0) (ratio)

ID: CP00202.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

Numeric domain: type=natural, min=2.0000 (exclusive=false), max=2.0000 (exclusive=false)

SITECODE - char(6) (nominal)

ID: CP00202.SITECODE

Precipitation or dry deposition collector site code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • RCADMN
    Andrews Administrative Site rain collector (WS 9&10 RC)
  • RCHI15
    Andrews original HI-15 rain collector
  • RCHIR7
    Andrews Watershed 7 NADP-style rain collector
  • RCHID7
    Andrews Watershed 7 NADP-style dry deposition collector
  • RCHIF7
    Andrews Watershed 7 bulk collector - wet and dry deposition
WATERYEAR - numeric(4,0) (interval)

ID: CP00202.WATERYEAR

Water year of sample or annual summary (October-September)

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

Numeric domain: type=natural, min=1969.0000 (exclusive=false), max=2018.0000 (exclusive=false)

DATE_TIME - datetime (dateTime)

ID: CP00202.DATE_TIME

Collection date and time (PST) of the precipitation sample - sample represents deposition from the previous sample date and time. Assume beginning date of first sample period for each collector is October 1st.

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD hh:mm:ss

LABNO - char(4) (nominal)

ID: CP00202.LABNO

Lab number code for sample

Type system: Microsoft SQL Server 2008

TYPE - char(2) (nominal)

ID: CP00202.TYPE

Sample type indicator - indicates dry deposition samples and other qualifying information

Type system: Microsoft SQL Server 2008

Code definitions (10)
  • S
    Sample saved and combined with the following collection due to insufficient water for analyses - samples were no longer saved and combined after 1981
  • P
    Partial sample - precipitation was not collected successfully over the entire period (includes problems with NADP-style collector motor or samples that may have overflowed)
  • YE
    Year end marker allows summary by water year - this is not a sample. Flux values are calculated from precip ending Sep 30 and use analyte concentrations from the following sample. 'YE' markers are inserted every Sep 30.
  • C
    Sample is combined with preceeding saved sample(s) for analysis. Combined samples of this type are not used after 1981.
  • DW
    Dry deposition sample - dry bucket contains rain water
  • F
    Sample is successfully collected over the entire period - a "Full" sample.
  • N
    No sample is collected - generally indicates periods of little or no rain, but can be a lost sample.
  • DF
    Dry deposition sample - sample is dry and not contaminated with precipitation water
  • B
    Biased sample - Lid on NADP sampler malfunctions and sample includes dry deposition
  • DC
    Dry deposition sample - dry bucket contains rain water and other insects/contaminants
PRECIP_CM - numeric(6,2) (ratio)

ID: CP00202.PRECIP_CM

Precipitation in centimeters for the exact sample period. Based on CS2MET (RCADMN) or H15MET (RCHIR7, RCHI15) meteorological station precipitation.

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.025000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=140.8900 (exclusive=false)

PCODE - char(1) (nominal)

ID: CP00202.PCODE

Precipitation value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • N
    No precipitation recorded for period. For saved sample (type='S'), precipitation for this period is included in the following period.
  • E
    Estimated precipitation
  • A
    Accepted value for precipitation
  • Q
    Precipitation value is questionable
  • M
    Missing value
ALK_INPUT - numeric(6,2) (ratio)

ID: CP00202.ALK_INPUT

Alkalinity inflow as CaCO3 (units have been converted for all values from bicarbonate (HCO3-C) to calcium carbonate)

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.050000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=19.4600 (exclusive=false)

ALKCODE - char(1) (nominal)

ID: CP00202.ALKCODE

Alkalinity value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
SSED_INPUT - numeric(7,2) (ratio)

ID: CP00202.SSED_INPUT

Suspended sediment inflow

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.050000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=54.8300 (exclusive=false)

SSEDCODE - char(1) (nominal)

ID: CP00202.SSEDCODE

Suspended sediment value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (4)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • Q
    Value is questionable (used beginning in 1991)
SI_INPUT - numeric(6,2) (ratio)

ID: CP00202.SI_INPUT

Silica inflow

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.050000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=9.9800 (exclusive=false)

SICODE - char(1) (nominal)

ID: CP00202.SICODE

Silica value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
UTP_INPUT - numeric(5,3) (ratio)

ID: CP00202.UTP_INPUT

Unfiltered total phosphorus inflow

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.005000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=0.4720 (exclusive=false)

UTPCODE - char(1) (nominal)

ID: CP00202.UTPCODE

Unfiltered total phosphorus value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
TDP_INPUT - numeric(5,3) (ratio)

ID: CP00202.TDP_INPUT

Total dissolved phosphorus inflow

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.005000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=0.4270 (exclusive=false)

TDPCODE - char(1) (nominal)

ID: CP00202.TDPCODE

Total dissolved phosphorus value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
PARTP_INPUT - numeric(5,3) (ratio)

ID: CP00202.PARTP_INPUT

Particulate P inflow - not measured analytically; mathematically determined by subtraction of Total Dissolved P (TDP) from Unfiltered Total P (UTP)

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.005000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=0.2590 (exclusive=false)

PARTPCODE - char(2) (nominal)

ID: CP00202.PARTPCODE

Particulate P value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • N
    No derived value is calculated due to missing analytical components
  • D
    Derived value - mathematically determined from other analytical measurements
  • D*
    Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit
  • DE
    Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values
  • DQ
    Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values
PO4P_INPUT - numeric(5,3) (ratio)

ID: CP00202.PO4P_INPUT

Ortho phosphorus (PO4-P) inflow

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.005000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=0.4760 (exclusive=false)

PO4PCODE - char(1) (nominal)

ID: CP00202.PO4PCODE

Ortho phosphorus value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
UTN_INPUT - numeric(5,2) (ratio)

ID: CP00202.UTN_INPUT

Total nitrogen inflow (unfiltered sample)

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=1.4000 (exclusive=false)

UTNCODE - char(2) (nominal)

ID: CP00202.UTNCODE

Unfiltered total nitrogen value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • A
    Accepted value
  • E
    Estimated value
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
  • D
    Derived value - mathematically determined from other analytical measurements
  • D*
    Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit
  • DE
    Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values
  • DQ
    Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values
  • N
    No analytical measurement or no derived value calculated due to missing analytical components
TDN_INPUT - numeric(5,2) (interval)

ID: CP00202.TDN_INPUT

Total dissolved nitrogen inflow (filtered sample)

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=5.0000 (exclusive=false)

TDNCODE - char(2) (nominal)

ID: CP00202.TDNCODE

Total dissolved nitrogen value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • A
    Accepted value
  • E
    Estimated value
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
  • D
    Derived value - mathematically determined from other analytical measurements
  • D*
    Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit
  • DE
    Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values
  • DQ
    Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values
  • N
    No analytical measurement or no derived value calculated due to missing analytical components
DON_INPUT - numeric(5,2) (ratio)

ID: CP00202.DON_INPUT

Dissolved organic N inflow - not measured analytically; mathematically determined by subtracting NH3-N and NO3-N from Total dissolved nitrogen. Values before May 2005 are determined by TKN minus NH3-N

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=3.7800 (exclusive=false)

DONCODE - char(2) (nominal)

ID: CP00202.DONCODE

Dissolved organic nitrogen value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • N
    No derived value is calculated due to missing analytical components
  • D
    Derived value - mathematically determined from other analytical measurements
  • D*
    Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit
  • DE
    Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values
  • DQ
    Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values
PARTN_INPUT - numeric(5,2) (ratio)

ID: CP00202.PARTN_INPUT

Particulate N inflow - not measured analytically; mathematically determined by subtraction of Total dissolved nitrogen (TDN) from Unfiltered Total nitrogen (UTN). Values before May 2005 are determined by UTKN minus TKN.

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=1.1900 (exclusive=false)

PARTNCODE - char(2) (nominal)

ID: CP00202.PARTNCODE

Particulate N value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • N
    No derived value is calculated due to missing analytical components
  • D
    Derived value - mathematically determined from other analytical measurements
  • D*
    Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit
  • DE
    Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values
  • DQ
    Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values
UTKN_INPUT - numeric(5,2) (ratio)

ID: CP00202.UTKN_INPUT

Unfiltered total Kjeldahl nitrogen inflow

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=1.3500 (exclusive=false)

UTKNCODE - char(1) (nominal)

ID: CP00202.UTKNCODE

Unfiltered total Kjeldahl nitrogen value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
TKN_INPUT - numeric(5,2) (ratio)

ID: CP00202.TKN_INPUT

Total Kjeldahl nitrogen (dissolved) inflow

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=4.9800 (exclusive=false)

TKNCODE - char(1) (nominal)

ID: CP00202.TKNCODE

Total Kjeldahl nitrogen value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
NH3N_INPUT - numeric(5,3) (ratio)

ID: CP00202.NH3N_INPUT

Ammonia-nitrogen (NH3-N) inflow

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.005000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=1.1960 (exclusive=false)

NH3NCODE - char(1) (nominal)

ID: CP00202.NH3NCODE

NH3-N value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (6)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
  • C
    Value confirmed, contamination suspected (code use begins May 2007)
NO3N_INPUT - numeric(5,3) (ratio)

ID: CP00202.NO3N_INPUT

Nitrate-nitrogen (NO3-N) inflow

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.005000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=0.3940 (exclusive=false)

NO3NCODE - char(1) (nominal)

ID: CP00202.NO3NCODE

NO3-N value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (6)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
  • C
    Value confirmed, contamination suspected (code use begins May 2007)
NA_INPUT - numeric(5,2) (ratio)

ID: CP00202.NA_INPUT

Sodium inflow

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.020000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=2.8400 (exclusive=false)

NACODE - char(1) (nominal)

ID: CP00202.NACODE

Na value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
K_INPUT - numeric(5,2) (ratio)

ID: CP00202.K_INPUT

Potassium inflow

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.020000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=1.4100 (exclusive=false)

KCODE - char(1) (nominal)

ID: CP00202.KCODE

K value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
CA_INPUT - numeric(5,2) (ratio)

ID: CP00202.CA_INPUT

Calcium inflow

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.060000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=3.6300 (exclusive=false)

CACODE - char(1) (nominal)

ID: CP00202.CACODE

Ca value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
MG_INPUT - numeric(5,2) (ratio)

ID: CP00202.MG_INPUT

Magnesium inflow

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.020000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=1.1600 (exclusive=false)

MGCODE - char(1) (nominal)

ID: CP00202.MGCODE

Mg value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
SO4S_INPUT - numeric(6,2) (ratio)

ID: CP00202.SO4S_INPUT

SO4-S (sulfate-sulfur) inflow

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.020000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=4.3800 (exclusive=false)

SO4SCODE - char(1) (nominal)

ID: CP00202.SO4SCODE

SO4-S value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
CL_INPUT - numeric(6,2) (ratio)

ID: CP00202.CL_INPUT

Chloride inflow

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.020000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=5.9700 (exclusive=false)

CLCODE - char(1) (nominal)

ID: CP00202.CLCODE

Cl value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
DOC_INPUT - numeric(5,2) (ratio)

ID: CP00202.DOC_INPUT

Dissolved organic carbon inflow

Type system: Microsoft SQL Server 2008

Unit: kilograms per hectare

Precision: 0.020000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=7.4800 (exclusive=false)

DOCCODE - char(1) (nominal)

ID: CP00202.DOCCODE

DOC value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • Q
    Value is questionable (used beginning in 1991)
CP00203 - CP00203

Object name: CP00203.csv

Records: 97

Attributes: 54

Temporal coverage: 1968-10-01 to 2018-10-01

File size: 19751 byte

Checksum (MD5): 5f52519497ca571a139ad46735696466

Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column

Constraints (2)
  • primaryKey: PRIMARY
    CP00203.SITECODE, CP00203.WATERYEAR
  • notNullConstraint: NOTNULL
    CP00203.STCODE, CP00203.SITECODE, CP00203.ENTITY, CP00203.WATERYEAR
Attributes (54)
STCODE - char(5) (nominal)

ID: CP00203.STCODE

Study code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • CP002
    Study code CP002
ENTITY - numeric(1,0) (ratio)

ID: CP00203.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

Numeric domain: type=natural, min=3.0000 (exclusive=false), max=3.0000 (exclusive=false)

SITECODE - char(6) (nominal)

ID: CP00203.SITECODE

Precipitation or dry deposition collector site code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • RCADMN
    Andrews Administrative Site rain collector (WS 9&10 RC)
  • RCHI15
    Andrews original HI-15 rain collector
  • RCHIR7
    Andrews Watershed 7 NADP-style rain collector
  • RCHID7
    Andrews Watershed 7 NADP-style dry deposition collector
  • RCHIF7
    Andrews Watershed 7 bulk collector - wet and dry deposition
WATERYEAR - numeric(4,0) (interval)

ID: CP00203.WATERYEAR

Water year of sample or annual summary (October-September)

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

Numeric domain: type=natural, min=1969.0000 (exclusive=false), max=2018.0000 (exclusive=false)

PRECIP_YR - numeric(6,2) (ratio)

ID: CP00203.PRECIP_YR

Total annual precipitation for the wateryear

Type system: Microsoft SQL Server 2008

Unit: centimeters

Precision: 0.250000

Numeric domain: type=real, min=126.5900 (exclusive=false), max=331.0400 (exclusive=false)

PCODE_YR - char(1) (nominal)

ID: CP00203.PCODE_YR

Annual precipitation value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (4)
  • I
    Incomplete, parts of year missing from annual summary
  • A
    All precipitation is included and not estimated for the wateryear
  • E
    Total includes estimated precipitation values
  • Q
    Precipitation total may be questionable for some periods of the wateryear
PH_YR - numeric(5,1) (ratio)

ID: CP00203.PH_YR

Mean annual pH

Type system: Microsoft SQL Server 2008

Unit: pH units

Precision: 0.100000

Numeric domain: type=real, min=4.6000 (exclusive=false), max=6.0000 (exclusive=false)

PHCODE_YR - char(2) (nominal)

ID: CP00203.PHCODE_YR

Annual pH value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (7)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
COND_YR - numeric(6,1) (ratio)

ID: CP00203.COND_YR

Mean annual specific conductivity concentration

Type system: Microsoft SQL Server 2008

Unit: micro siemens per centimeter

Precision: 0.400000

Numeric domain: type=real, min=2.9000 (exclusive=false), max=15.2000 (exclusive=false)

CONDCODE_YR - char(2) (nominal)

ID: CP00203.CONDCODE_YR

Annual conductivity value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
ALK_YR - numeric(6,2) (ratio)

ID: CP00203.ALK_YR

Mean annual alkalinity concentration as CaCO3 (calcium carbonate) - all values have been converted from HCO3-C (bi-carbonate)

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.020000

Numeric domain: type=real, min=0.2100 (exclusive=false), max=2.5000 (exclusive=false)

ALKCODE_YR - char(2) (nominal)

ID: CP00203.ALKCODE_YR

Annual alkalinity qualifier value code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
SSED_YR - numeric(6,2) (ratio)

ID: CP00203.SSED_YR

Mean annual suspended sediment concentratiom

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.0900 (exclusive=false), max=4.9400 (exclusive=false)

SSEDCODE_YR - char(2) (nominal)

ID: CP00203.SSEDCODE_YR

Annual suspended sediment value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (7)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
SI_YR - numeric(6,2) (ratio)

ID: CP00203.SI_YR

Mean annual silica concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.050000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=0.5200 (exclusive=false)

SICODE_YR - char(2) (nominal)

ID: CP00203.SICODE_YR

Annual silica value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
UTP_YR - numeric(6,3) (ratio)

ID: CP00203.UTP_YR

Mean annual unfiltered total phosphorus concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.002000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=0.0250 (exclusive=false)

UTPCODE_YR - char(2) (nominal)

ID: CP00203.UTPCODE_YR

Annual unfiltered total phosphorus value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
TDP_YR - numeric(6,3) (ratio)

ID: CP00203.TDP_YR

Mean annual total dissolved phosphorus concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.002000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=0.0210 (exclusive=false)

TDPCODE_YR - char(2) (nominal)

ID: CP00203.TDPCODE_YR

Annual total dissolved phosphorus value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
PARTP_YR - numeric(6,3) (ratio)

ID: CP00203.PARTP_YR

Mean annual particulate P - not measured analytically; mathematically determined by subtraction of Total Dissolved P (TDP) from Unfiltered Total P (UTP)

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.002000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=0.0140 (exclusive=false)

PARTPCODE_YR - char(3) (nominal)

ID: CP00203.PARTPCODE_YR

Annual particulate P value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • N
    No derived values are calculated for the entire water year
  • D
    Annual value based on derived values
  • D*
    Annual value based on derived values; one or more values measured below the detection limit
  • DE
    Annual value based on derived values; one or more values estimated
  • DQ
    Annual value based on derived values; one or more values questionable
  • ID
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values
  • ID*
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values measured below the detection limit
  • IDE
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are estimated
  • IDQ
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are questionable
PO4P_YR - numeric(6,3) (ratio)

ID: CP00203.PO4P_YR

Mean annual ortho phosphorus (PO4-P) concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.001000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=0.0170 (exclusive=false)

PO4PCODE_YR - char(2) (nominal)

ID: CP00203.PO4PCODE_YR

Annual ortho phosphorus value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
UTN_YR - numeric(6,2) (ratio)

ID: CP00203.UTN_YR

Mean annual total nitrogen concentration (unfiltered samples)

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.0300 (exclusive=false), max=0.3500 (exclusive=false)

UTNCODE_YR - char(3) (nominal)

ID: CP00203.UTNCODE_YR

Annual unfiltered total nitrogen value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (17)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
  • D
    Annual value based on derived values
  • D*
    Annual value based on derived values; one or more values measured below the detection limit
  • DE
    Annual value based on derived values; one or more values estimated
  • DQ
    Annual value based on derived values; one or more values questionable
  • ID
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values
  • ID*
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values measured below the detection limit
  • IDE
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are estimated
  • IDQ
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are questionable
TDN_YR - numeric(6,2) (ratio)

ID: CP00203.TDN_YR

Mean annual total dissolved nitrogen concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.0200 (exclusive=false), max=0.2200 (exclusive=false)

TDNCODE_YR - char(3) (nominal)

ID: CP00203.TDNCODE_YR

Annual total dissolved nitrogen value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (17)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
  • D
    Annual value based on derived values
  • D*
    Annual value based on derived values; one or more values measured below the detection limit
  • DE
    Annual value based on derived values; one or more values estimated
  • DQ
    Annual value based on derived values; one or more values questionable
  • ID
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values
  • ID*
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values measured below the detection limit
  • IDE
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are estimated
  • IDQ
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are questionable
DON_YR - numeric(6,2) (ratio)

ID: CP00203.DON_YR

Mean annual dissolved organic N concentration - not measured analytically; mathematically determined by subtracting NH3-N and NO3-N from Total dissolved nitrogen. Values before May 2005 are determined by TKN minus NH3-N

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=0.1600 (exclusive=false)

DONCODE_YR - char(3) (nominal)

ID: CP00203.DONCODE_YR

Annual dissolved organic N value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • N
    No derived values are calculated for the entire water year
  • D
    Annual value based on derived values
  • D*
    Annual value based on derived values; one or more values measured below the detection limit
  • DE
    Annual value based on derived values; one or more values estimated
  • DQ
    Annual value based on derived values; one or more values questionable
  • ID
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values
  • ID*
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values measured below the detection limit
  • IDE
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are estimated
  • IDQ
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are questionable
PARTN_YR - numeric(6,2) (ratio)

ID: CP00203.PARTN_YR

Mean annual particulate N concentration - not measured analytically; mathematically determined by subtraction of Total dissolved nitrogen (TDN) from Unfiltered Total nitrogen (UTN). Values before May 2005 are determined by UTKN minus TKN.

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=0.1300 (exclusive=false)

PARTNCODE_YR - char(3) (nominal)

ID: CP00203.PARTNCODE_YR

Annual particulate N value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • N
    No derived values are calculated for the entire water year
  • D
    Annual value based on derived values
  • D*
    Annual value based on derived values; one or more values measured below the detection limit
  • DE
    Annual value based on derived values; one or more values estimated
  • DQ
    Annual value based on derived values; one or more values questionable
  • ID
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values
  • ID*
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values measured below the detection limit
  • IDE
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are estimated
  • IDQ
    Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are questionable
UTKN_YR - numeric(6,2) (ratio)

ID: CP00203.UTKN_YR

Mean annual unfiltered total Kjeldahl nitrogen concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.0200 (exclusive=false), max=0.3300 (exclusive=false)

UTKNCODE_YR - char(2) (nominal)

ID: CP00203.UTKNCODE_YR

Annual unfiltered total Kjeldahl nitrogen value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
TKN_YR - numeric(6,2) (ratio)

ID: CP00203.TKN_YR

Mean annual total Kjeldahl nitrogen concentration (dissolved)

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.0100 (exclusive=false), max=0.2000 (exclusive=false)

TKNCODE_YR - char(2) (nominal)

ID: CP00203.TKNCODE_YR

Annual total Kjeldahl nitrogen value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
NH3N_YR - numeric(6,3) (ratio)

ID: CP00203.NH3N_YR

Mean annual ammonia (NH3-N) concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.003000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=0.0520 (exclusive=false)

NH3NCODE_YR - char(2) (nominal)

ID: CP00203.NH3NCODE_YR

Annual NH3-N value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
NO3N_YR - numeric(6,3) (ratio)

ID: CP00203.NO3N_YR

Mean annual nitrate-nitrogen (NO3-N) concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.001000

Numeric domain: type=real, min=0.0030 (exclusive=false), max=0.0520 (exclusive=false)

NO3NCODE_YR - char(2) (nominal)

ID: CP00203.NO3NCODE_YR

Annual NO3-N value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
NA_YR - numeric(6,2) (ratio)

ID: CP00203.NA_YR

Mean annual sodium concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.0600 (exclusive=false), max=0.6400 (exclusive=false)

NACODE_YR - char(2) (nominal)

ID: CP00203.NACODE_YR

Annual Na value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
K_YR - numeric(6,2) (ratio)

ID: CP00203.K_YR

Mean annual potassium concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.030000

Numeric domain: type=real, min=0.0100 (exclusive=false), max=0.2500 (exclusive=false)

KCODE_YR - char(2) (nominal)

ID: CP00203.KCODE_YR

Annual K value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
CA_YR - numeric(6,2) (ratio)

ID: CP00203.CA_YR

Mean annual calcium concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.060000

Numeric domain: type=real, min=0.0200 (exclusive=false), max=0.3700 (exclusive=false)

CACODE_YR - char(2) (nominal)

ID: CP00203.CACODE_YR

Annual Ca value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
MG_YR - numeric(6,2) (ratio)

ID: CP00203.MG_YR

Mean annual magnesium concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.020000

Numeric domain: type=real, min=0.0200 (exclusive=false), max=0.1000 (exclusive=false)

MGCODE_YR - char(2) (nominal)

ID: CP00203.MGCODE_YR

Annual Mg value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
SO4S_YR - numeric(6,2) (ratio)

ID: CP00203.SO4S_YR

Mean annual SO4-S (sulfate-sulfur) concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.020000

Numeric domain: type=real, min=0.0200 (exclusive=false), max=0.4200 (exclusive=false)

SO4SCODE_YR - char(2) (nominal)

ID: CP00203.SO4SCODE_YR

Annual SO4-S value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
CL_YR - numeric(6,2) (ratio)

ID: CP00203.CL_YR

Mean annual chloride concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.2000 (exclusive=false), max=1.6600 (exclusive=false)

CLCODE_YR - char(2) (nominal)

ID: CP00203.CLCODE_YR

Annual Cl value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
DOC_YR - numeric(6,2) (ratio)

ID: CP00203.DOC_YR

Mean annual dissolved organic carbon concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 0.050000

Numeric domain: type=real, min=0.1000 (exclusive=false), max=1.4400 (exclusive=false)

DOCCODE_YR - char(2) (nominal)

ID: CP00203.DOCCODE_YR

Annual DOC value qualifier code

Type system: Microsoft SQL Server 2008

Code definitions (9)
  • Q
    Annual value includes questionable values
  • N
    No analyses conducted in water year
  • A
    Annual value is accepted
  • E
    Annual value includes estimated values
  • I
    Annual value incomplete; one or more values are missing for part of the year
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • IE
    Annual value incomplete; one or more values are missing for part of the year; one or more values estimated
  • IQ
    Annual value incomplete; one or more values are missing for part of the year; one or more values questionable
  • *
    Annual value includes one or more values measured below the detection limit
CP00206 - CP00206

Object name: CP00206.csv

Records: 3246

Attributes: 14

Temporal coverage: 1968-10-09 to 2019-05-22

File size: 320813 byte

Checksum (MD5): a0862104a8ad2021573c463a6197e08d

Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column

Constraints (2)
  • primaryKey: PRIMARY
    CP00206.SITECODE, CP00206.DATE_TIME
  • notNullConstraint: NOTNULL
    CP00206.STCODE, CP00206.TYPE, CP00206.SITECODE, CP00206.ENTITY, CP00206.WATERYEAR, CP00206.DATE_TIME, CP00206.QCCODE, CP00206.SAMPLER_TYPE, CP00206.LOW_VOLUME, CP00206.SEQ_INDEX
Attributes (14)
STCODE - char(5) (nominal)

ID: CP00206.STCODE

Study code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • CP002
    Study code CP002
ENTITY - numeric(1,0) (ratio)

ID: CP00206.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

Numeric domain: type=natural, min=6.0000 (exclusive=false), max=6.0000 (exclusive=false)

SITECODE - char(6) (nominal)

ID: CP00206.SITECODE

Precipitation or dry deposition collector site code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • RCADMN
    Andrews Administrative Site rain collector (WS 9&10 RC)
  • RCHI15
    Andrews original HI-15 rain collector
  • RCHIR7
    Andrews Watershed 7 NADP-style rain collector
  • RCHID7
    Andrews Watershed 7 NADP-style dry deposition collector
  • RCHIF7
    Andrews Watershed 7 bulk collector - wet and dry deposition
WATERYEAR - numeric(4,0) (interval)

ID: CP00206.WATERYEAR

Water year of sample or annual summary (October-September)

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

Numeric domain: type=natural, min=1969.0000 (exclusive=false), max=2020.0000 (exclusive=false)

DATE_TIME - datetime (dateTime)

ID: CP00206.DATE_TIME

Collection date and time (PST) of the precipitation sample - sample represents deposition from the previous sample date and time. Assume beginning date of first sample period for each collector is October 1st.

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD hh:mm:ss

LABNO - char(4) (nominal)

ID: CP00206.LABNO

Lab number code for sample

Type system: Microsoft SQL Server 2008

TYPE - char(2) (nominal)

ID: CP00206.TYPE

Sample type indicator - indicates dry deposition samples and other qualifying information

Type system: Microsoft SQL Server 2008

Code definitions (10)
  • S
    Sample saved and combined with the following collection due to insufficient water for analyses - samples were no longer saved and combined after 1981
  • P
    Partial sample - precipitation was not collected successfully over the entire period (includes problems with NADP-style collector motor or samples that may have overflowed)
  • YE
    Year end marker allows summary by water year - this is not a sample. Flux values are calculated from precip ending Sep 30 and use analyte concentrations from the following sample. 'YE' markers are inserted every Sep 30.
  • C
    Sample is combined with preceeding saved sample(s) for analysis. Combined samples of this type are not used after 1981.
  • DW
    Dry deposition sample - dry bucket contains rain water
  • F
    Sample is successfully collected over the entire period - a "Full" sample.
  • N
    No sample is collected - generally indicates periods of little or no rain, but can be a lost sample.
  • DF
    Dry deposition sample - sample is dry and not contaminated with precipitation water
  • B
    Biased sample - Lid on NADP sampler malfunctions and sample includes dry deposition
  • DC
    Dry deposition sample - dry bucket contains rain water and other insects/contaminants
QCCODE - char(2) (nominal)

ID: CP00206.QCCODE

Quality control sample codes are assigned to samples collected for examining integrity of proportional sample analysis

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • NA
    Water sample is not a quality control sample
  • QZ
    Miscellaneous quality control water sample
QA_SAMPLE - char(6) (nominal)

ID: CP00206.QA_SAMPLE

Quality assurance sample number assigned if sample water is further analyzed for internal laboratory purposes

Type system: Microsoft SQL Server 2008

SAMPLER_TYPE - char(2) (nominal)

ID: CP00206.SAMPLER_TYPE

Type of water sampler or method used to collect water

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • BC
    Bulk collection includes both wet and dry deposition
  • NP
    NADP-type sampler that separates wet deposition from dry deposition
  • RC
    Bulk samples from original, locally-designed rain collectors that includes both wet and dry deposition
LOW_VOLUME - char(1) (nominal)

ID: CP00206.LOW_VOLUME

Indicator of a low volume sampler that may restrict the breadth of laboratory analyses

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • N
    Sample is of sufficient volume for laboratory analyses
  • Y
    Sample is low volume and laboratory analyses may be limited
FIELD_COMMENTS - char(254) (nominal)

ID: CP00206.FIELD_COMMENTS

Field comments related to the collection of the water sample

Type system: Microsoft SQL Server 2008

LAB_COMMENTS - char(254) (nominal)

ID: CP00206.LAB_COMMENTS

Laboratory comments related to the handling and analyses of the sample

Type system: Microsoft SQL Server 2008

SEQ_INDEX - numeric(5,0) (ratio)

ID: CP00206.SEQ_INDEX

Sequential index generated primarily by the temporal order in which samples are collected

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

Numeric domain: type=natural, min=1.0000 (exclusive=false), max=9233.0000 (exclusive=false)

Units
kilograms kg mass kilogram kilogram 1 kilograms; SI unit of mass
kilograms per hectare kg/ha arealMassDensity kilogramPerHectare kilogramPerMeterSquared 0.0001 kilograms per hectare
micro siemens per centimeter uS/cm specific conductance microSiemenPerCentimeter siemenPerMeter .0001 micro Siemens per centimeter
pH units ph undefined pH unknown N/A Scale used for pH measurements
centimeters cm length centimeter meter 0.01 centimeters; .01 meters
milligrams per liter mg/l massDensity milligramPerLiter kilogramPerMeterCubed 0.001 milligrams per liter
number number dimensionless number dimensionless 1 dimensionless number, i.e., ratio, count
Related Datasets
Related Publications
  • Fredriksen, R. L. 1972. Nutrient budget of a Douglas-fir forest on an experimental watershed in western Oregon. In: Research on coniferous forest ecosystems: Proceedings of a symposium; 1972 March 23-24; Bellingham, WA. [Place of publication unknown]: [Publisher unknown]: 115-131.
  • Grier, C. C.; Cole, D. W.; Dyrness, C. T.; Fredriksen, R. L. 1974. Nutrient cycling in 37- and 450-year-old Douglas-fir ecosystems. In: Waring, R. H.; Edmonds, R. L., eds. Integrated research in the coniferous forest biome. Bulletin 5. Seattle, WA: Coniferous Forest Biome: 21-34.
  • Martin, C. Wayne; Harr, R. Dennis. 1988. Precipitation and streamwater chemistry from undisturbed watersheds in the Cascade Mountains of Oregon. Water, Air, and Soil Pollution. 42: 203-219.
  • Martin, C. Wayne; Harr, R. Dennis. 1989. Logging of mature Douglas-fir in western Oregon has little effect on nutrient output budgets. Canadian Journal of Forest Research. 19: 35-43.
  • Vanderbilt, Kristin L. 2000. Patterns of nitrogen fluxes in watersheds of the H.J. Andrews Experimental Forest, OR. Corvallis, OR: Oregon State University. 110 p. Ph.D. dissertation.
  • Vanderbilt, Kristin L.; Lajtha, Kate; Swanson, Frederick J. 2003. Biogeochemistry of unpolluted forested watersheds in the Oregon Cascades: temporal patterns of precipitation and stream nitrogen fluxes. Biogeochemistry. 62: 87-117.
  • Lajtha, Kate; Jones, Julia. 2013. Trends in cation, nitrogen, sulfate and hydrogen ion concentrations in precipitation in the United States and Europe from 1978 to 2010: a new look at an old problem. Biogeochemistry. 32pp.
Related Files
  • The Cooperative Chemical Analytical Laboratory (CCAL)
    The CCAL web page describes analytical methodology, detection levels and instrumentation. CCAL is a cooperative laboratory operated by Oregon State University and the U.S. Department of Agriculture, Forest Service.
  • National Atmospheric Deposition Program, NTN site OR10
    The NADP monitors precipitation chemistry. It is a cooperative effort between many different groups, including federal, state, tribal and local governmental agencies, educational institutions, private companies, and non-governmental agencies.
  • National Atmospheric Deposition Program, MDN site OR10
    The NADP monitors precipitation chemistry. It is a cooperative effort between many different groups, including federal, state, tribal and local governmental agencies, educational institutions, private companies, and non-governmental agencies.
Intellectual Rights

Data Use Agreement:

The re-use of scientific data has the potential to greatly increase communication, collaboration and synthesis within and among disciplines, and thus is fostered, supported and encouraged. This Data Set is released under the Creative Commons license CC BY "Attribution" (see: https://creativecommons.org/licenses/by/4.0/). Creative Commons license CC BY - Attribution is a license that allows others to distribute, remix, tweak, and build upon your work (even commercially), as long as you are credited for the original creation. This license accommodates maximum dissemination and use of licensed materials.

It is considered professional conduct and an ethical obligation to acknowledge the work of other scientists. The Data User is asked to provide attribution of the original work if this data package is shared in whole or by individual parts or used in the derivation of other products. A recommended citation is provided for each Data Set in the Andrews LTER data catalog (see: http://andlter.forestry.oregonstate.edu/data/catalog/datacatalog.aspx). A generic citation is also provided for this Data Set on the website https://portal.edirepository.org in the summary metadata page. Data Users are thus strongly encouraged to consider consultation, collaboration and/or co-authorship with the Data Set Creator.

While substantial efforts are made to ensure the accuracy of data and associated documentation, complete accuracy of data sets cannot be guaranteed and all data are made available "as is." The Data User should be aware, however, that data are updated periodically and it is the responsibility of the Data User to check for new versions of the data. The data authors and the repository where these data were obtained shall not be liable for damages resulting from any use or misinterpretation of the data.

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

Licensed

License: N/A

Maintenance

Maintenance update frequency: annually

Description

  • An update history is logged and maintained with each new version of every dataset.

Change History

  • Version1 (1984-10-09)
    Original metadata creation.
  • Version2 (1995-09-30)
    All data was automated in the fall of 1979. Regular updates are made annually, but are occasionally delayed based on the availability of precipitation values. Precipitation is combined with nutrient concentration data to produce input in kg per hectares. Originally, precipitation from rain gages at WS09 and WS10 were used to produce input totals, but these gages were discontinued. In 1995, all data was rerun using the Climatic Station @WS2 precipitation record. Analysis codes Q (Questionable lab value) and * (value below detection limit) were initiated in April, 1991.
  • Version3 (2002-02-18)
    Metadata restructured and moved into SQLServer metadata database LTERMETA. Data moved into SQLServer database FSDBDATA.
  • Version4 (2005-03-17)
    This is a major update of this data set. Nutrient concentrations (Entity 1) are updated through mid-2004 (last version was through mid-2001). Entities 2 and 3 were updated through wateryear 2003 (previous version was only through 1997). Precipitation values were updated for RCADMN using CS2MET (note :PRIMET was used after March 2003 but will be replaced later with CS2MET), and precipitation values were updated to RCHIR7 using H15MET. Attributes were renamed in this update process to be unique by attribute definition for the CF002 dataset .
  • Version7 (2007-10-03)
    This is a major structural revision and update of data into winter 2007, lab sets HJAN226-HJAN275, lab numbers 3324-4093. Unfiltered total nitrogen (UTN) and total dissolved nitrogen (TDN) are added with flags. UTN and TDN are calculated and coded as 'D' - derived before May 2005. Particulate P, Particulate N, dissolved organic nitrogen (DON), and anion-cation ratio are calculated from other analyses for all records in Entity 1 and flagged as 'D'erived. Dissolved organic Phosphorus calculation was dropped from Entity 2. UTKN and TKN are changed to 2 decimals for all values. Precipitation is changed to 2 decimals. Enddate and endtime are changed to truetype date_time. Other attributes are renamed, ie., TDP (was TP), PO4P (was OP). Silica samples are flagged as 'Q'uestionable before 10 March 1983 - Samples were frozen and analyses inconsistent.
  • Version8 (2007-10-16)
    Additional corrections and improvements in methods metadata. Correction of analytical codes for 1970-1971 for TKN, DON, and TDN, with correction of an annual 1971 DON concentration.
  • Version9 (2010-06-28)
    Entity 1 is updated into March 2010 although streamflow is only available through Sep 30 2009 (WY 2009), and USGS Lookout Creek streamflow for GSLOOK site through WY2008. 'Y' values are removed from Entity 1 and the streamflow (or precip) and the streamflow (or precip) qualifier codes for the beginning wateryear sample are corrected. A local copy of Entity 1 with the Y values will be maintained to produce annual flux and concentration summaries. Attribute 'wateryear' has been added to Entity 1 and Entity 2. Entity 2 has been updated through WY 2009 for all streamflow and precip sites except GSLOOK (through WY 2008). This is the first Entity 2 update including GSLOOK, WY 2005 (partial year) and complete WY 2006-2008. Resolution of 'S' and 'C' issue: There are 5 instances in which streamflow samples were collected and saved and analyzed in combination with the next sample. To satisfy Sherri's need to see even 3-week calculated values, flux values are present for the sample type = 'S' and represent the concentrations over the 6-week interval, but use the streamflow total for period ending at the Saved sample collection. Flux values for the sample type 'C' use the 6-week concentrations and streamflow beginning from the time of the saved sample collection. In the CP002 precip data, the 'S' samples are removed from Entity 2 and the 'C' type samples include precipitation over the entire collection period of any saved samples. Resolution of 1989-1991 issues of independent weekly partial and grab samples: Again, the issue here is that comparable 3-week sample intervals are desired. In the spreadsheet list sent by Linda Ashkenas several 3-week intervals with additional weekly samples were identified for WS 9 and WS10. New values are calculated at even 3 week intervals. For these cases, Entity 2 values have been modified proportionally based on the weekly collections and the formal rules developed after 1991 used to combine weekly samples in the lab. That is, partial samples were used to represent the total streamflow for the complete intended interval. Grab samples were not used in the calculations. If a 3 week interval included a partial or grab sample type, the 3-week interval was labeled as 'P' partial. In all cases the 3-week flux value represents the streamflow for the entire 3-week interval even if the concentrations are based on 'P' partial samples. This was also applied to 2 similar intervals in Feb 1996 (WS9)and Dec 1997 (WS9 and 10). However, the 1996 flood interval for WS 10, Feb 1996, could not be combined with certainty using this mathematical approach and was left as is. Note that Entity 2 before and including WY 1998 data is no longer reproducible by my automated program. Another issue arose where some concentration values were qualified with a 'C' (beginning WY 2007). 'C' values are defined as 'value confirmed, contamination or experimental tracer suspected'. In these cases the values were rerun (double-checked) by the lab confirming lab results. In all cases, field notes indicated a worm or other large insect had contaminated the sample. In two cases conductivity and chloride values were very high and an experimental tracer is suspected. Currently, these values are left in Entity 1, and also are left in entity 2 with the 'C' qualifier. However, these values were removed for calculation of mean annual concentrations. While the mean annual concentrations generally change very little by inclusion of this point, there is one case in which the annual ammonia value changed dramatically.
  • Version12 (2012-08-30)
    Updated attribute description for attributes with a fine resolution datetime measurement scale to include 'PST' (pacific standard time).
  • Version14 (2014-09-10)
    Entity 1 is updated from 8 March 2010 to 2 July 2014. Precipitation values are added and precipitation is updated beginning WY 2006 for RCHIR7 rain collector. alkalinity is converted to CaCO3 (from HCO3-C)
  • Version15 (2014-09-12)
    Entity 2 is now updated through 2 July 2014 and Entity 3 through WY 2013. Precipitation from CENMET station is now used for all Hi-15 collectors beginning WY 2006. Alkalinity has been converted to units of calcium carbonate (CaCO3) from bi-carbonate (HCO3-C). The NADP-style collector has been discontinued due to problenatic operation after WY 2013 (RCHIR7 and RCHID7). A new bulk type collector begins operation for WY 2014 (RCHIF7).
  • Version16 (2015-08-14)
    Entity 6 is created from precipitation water chemistry sample field log sheets that include sample collection times, sampler type, and field and lab comments associated with the water sample collection and laboratory analyses.
  • Version17 (2015-12-04)
    Entity 6 is updated from June 2015 through October 2015.
  • Version18 (2016-08-25)
    Critical update to fix rendering of custom units and correct for illegal characters in entity 6 field_comments.
  • Version19 (2016-10-31)
    All entities are updated from July 2014 into May 2016. Codes for all analytes are revised so that blank codes (good values) are changed to 'A' (Accepted values).
  • Version20 (2019-08-28)
    All Entities are updated from May 2016 until May 2019. Precipitation values are taken from PRIMET (RCADMN) and CENMET (RCHIF7)