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

CF002: Stream chemistry concentrations and fluxes using proportional sampling in the Andrews Experimental Forest, 1968 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-02 to 2024-10-01
Version: 24
Published: 2026-02-05
EDI Package ID: knb-lter-and.4021.24
Source XML: CF002_24.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.; Henshaw, D.; Remillard, S.; Fredriksen, R. 2026. Stream chemistry concentrations and fluxes using proportional sampling in the Andrews Experimental Forest, 1968 to present Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/CF002 Accessed 2026-05-10.

Abstract

Stream chemistry sampling and analysis was initiated at the H.J. Andrews Experimental Forest in 1968 in two small watersheds (Watersheds 9,10). Sampling has expanded as additional paired watershed studies (Watersheds 1, 2, 6, 7, 8) and monitoring (Mack, Lookout Cr) were initiated over time. Water samples are collected proportionally to streamflow as a function of stage height and composited at each stream gauging site. Composite sample periods are generally three weeks and 3 one-week samples are commonly composited in the lab before analysis. Water samples are analyzed at the Cooperative Chemical Analytical Lab (CCAL) (http://www.ccal.oregonstate.edu/ ). Concentrations of analytes include dissolved and particulate nitrogen, phosphorus, carbon, as well as pH, conductivity, suspended sediment, and full suite of cations and anions. Annual mean concentrations are calculated by weighting 3-week periods by streamflow. Fluxes are calculated using concentrations and flow. Monthly concentrations and fluxes were interpolated from the 3-week sampling data. The original objective was to examine the nutrient budgets for small watersheds and to evaluate changes in average concentrations and fluxes following timber harvest in comparison with unharvested reference watersheds. This study is conducted in conjunction with Andrew's precipitation chemistry (CP002) and the U.S. National Atmospheric Deposition Program (NADP).

Coverage

Temporal coverage: 1968-10-02 to 2024-10-01

Geographic coverage: H. J. Andrews Experimental Forest, Watersheds 1, 2, 6, 7, 8, 9, 10, Mack Creek, and Lookout Creek in the Willamette National Forest

Spatial coverage:

Bounds: W -122.26105600, E -122.16744700, N 44.26629426, S 44.20119000

Purpose
  • Examine stream nutrient concentrations and outputs in small watersheds, evaluate the significance of nutrient losses from a forest soil-plant system after timber harvest compared to reference watersheds, and examine the nutrient and solute budgets for small watersheds.
Project

Title: Long-Term Ecological Research

Personnel
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: DEB2025755

Awards
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
  • Craig Creel
    Role: Former Investigator
    USDA Forest Service;Pacific NW Research Station;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: (541) 750-7326, (541) 822-6301
    Email: cdcreel@comcast.net
  • Greg Downing
    Role: Former Investigator
    Forestry Sciences Lab;3200 SW Jefferson Way, Corvallis, OR, 97333, USA
    Phone: (541) 750-7283, (541) 822-6301
    Email: gregdowning242@gmail.com, 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@lists.oregonstate.edu
  • Donald L. Henshaw
    Role: Creator
    Pacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, Oregon, 97331
    Email: hja_admin@lists.oregonstate.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.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.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@flbs.umt.edu
  • Frederick J. Swanson
    Role: Former Investigator
    USDA Forest Service;Pacific NW Research Station;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: (541) 750-7355
    Email: fred.swanson@oregonstate.edu, fjswanson541@gmail.com
  • Kristin L. Vanderbilt
    Role: Former Investigator
    USA
    Email: krvander@fiu.edu
  • Suzanne M. Remillard
    Role: Abstractor
    Office: FSL 354;; Forest Science Department;; Oregon State University, Corvallis, OR, 97331, USA
    Phone: (541) 758-8767
    Email: suzanne.remillard@oregonstate.edu
  • Suzanne M. Remillard
    Role: Creator
    Office: FSL 354;; Forest Science Department;; Oregon State University, Corvallis, OR, 97331, USA
    Phone: (541) 758-8767
    Email: suzanne.remillard@oregonstate.edu
  • Alba Argerich
    Role: Other Researcher
    School of Natural Resources; 303K Anheuser-Busch Natural Resources Building; University of Missouri, Columbia, MO, 65211
    Email: argericha@missouri.edu, alba.argerich@gmail.com
  • Benjamin E. Nash
    Role: Method Contact
    Email: benjamin.nash@usda.gov
Contact
  • Information Manager
    Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331
    Email: hjaweb@lists.oregonstate.edu
  • Donald L. Henshaw
    Pacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, Oregon, 97331
    Email: hja_admin@lists.oregonstate.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@lists.oregonstate.edu
Study Description

Stream chemistry sampling and analysis was initiated at the H.J. Andrews Experimental Forest in 1968 in two small watersheds (Watersheds 9,10). Sampling has expanded as additional paired watershed studies (Watersheds 1, 2, 6, 7, 8) and monitoring (Mack, Lookout Cr) were initiated over time. Water samples are collected proportionally to streamflow as a function of stage height and composited at each stream gauging site. Composite sample periods are generally three weeks and 3 one-week samples are commonly composited in the lab before analysis. Water samples are analyzed at the Cooperative Chemical Analytical Lab (CCAL) (http://www.ccal.oregonstate.edu/ ). Concentrations of analytes include dissolved and particulate nitrogen, phosphorus, carbon, as well as pH, conductivity, suspended sediment, and full suite of cations and anions. Annual mean concentrations are calculated by weighting 3-week periods by streamflow. Fluxes are calculated using concentrations and flow. Monthly concentrations and fluxes were interpolated from the 3-week sampling data. The original objective was to examine the nutrient budgets for small watersheds and to evaluate changes in average concentrations and fluxes following timber harvest in comparison with unharvested reference watersheds. This study is conducted in conjunction with Andrew's precipitation chemistry (CP002) and the U.S. National Atmospheric Deposition Program (NADP). Examine stream nutrient concentrations and outputs in small watersheds, evaluate the significance of nutrient losses from a forest soil-plant system after timber harvest compared to reference watersheds, and examine the nutrient and solute budgets for small watersheds. Field Methods - CF002

Purpose: Examine stream nutrient concentrations and outputs in small watersheds, evaluate the significance of nutrient losses from a forest soil-plant system after timber harvest compared to reference watersheds, and examine the nutrient and solute budgets for small watersheds.

Methods

Method Steps

Field Methods - CF002
  • Streamwater is sampled from each stream at a rate proportional to the streamflow rate. Samples are collected in 5 gal. polyethylene carboys and stored in an insulated housing or cabinet at the gaging station. Beginning in 2005, the original site-developed samplers are being replaced with automated samplers (SIGMA type).
  • Composite samples, collected proportionally to streamflow over approximate 3-week periods, contain representative sampling of the sediment and dissolved constituents carried by the stream over the collection period. Beginning 1988, stream proportional samples are collected weekly and refrigerated. Refrigerated samples are stored at the Andrews and transported to Corvallis for analysis every 3 weeks. Beginning in WY 2009 due to resource limitations, cold-weather samples (Nov-Mar) are left in the gage house for the entire 3-week interval, but samples are collected weekly and refrigerated throughout the rest of the year. The weekly samples are combined and analyzed as a composite 3-week sample. Before 1988, samples remained at the gage houses until transported to Corvallis for analysis. During high flow periods the samples were collected at shorter intervals to prevent the carboys from overflowing.
  • Historically, samples were collected using a battery powered, in-house constructed sampler designed by Richard Fredriksen (Fredriksen 1969). The interface between the sampler and the recorders was an array of magnetic reed switches which were activated by magnets attached to the counter weights of the recorders. There were 20 segmented proportions equal to discharge increases of 1/20 of the expected maximum discharge. For each proportional increase in flow, the number of samples taken in the base time period increased by one. Streamflow is measured continuously with Leopold-Stevens A-35 recorders and Stevens PAT with Campbell CR-10 data logger.
  • The original sampling rate based on streamflow used in these original reed switch samplers is now represented in the new SIGMA samplers at our long-term sampling sites. Sampling at WS1 and Lookout Creek started in 2003 and 2005 using the SIGMA samplers. WS2 was converted to the SIGMA type sampler with first composite sample on 28 June 2004 after a brief period of running the original and new sampler concurrently. Mack Creek was converted to a SIGMA sampler with first composite sample on 28 August 2007.
  • Samples from each week within the 3-week period are typically combined at the Andrews, but partial samples (i.e., a week where operational problems with the sampler create a non-proportional or incomplete sample) and other very large samples may be combined proportionally at the lab. All samples are assigned sample type codes (TYPE). Handling of samples and assigning sample type codes have been generally consistent since Dec 1988, although modification was made in August 1991. The rules for combining samples and assigning sample type codes are as follows:
  • All three weekly proportional samples for a given watershed sampler, whether partial (incomplete) or full (complete), are combined for the 3-week period. Successful operation of the sampler over all 3 weeks represents a complete or full (TYPE="F") sample. Any partial collection will cause the sample type designation to be partial (TYPE="P") for that entire three week period. Grab samples should be taken when no sample has been collected through the proportional sampler for any single week, sample type 'Grab (TYPE="G"). Grab samples will not be combined with other composite samples and are submitted separately to the lab. Grab samples are only analyzed if the sampler otherwise fails for the entire 3-week period. A carboy with three combined grab samples should be designated as grab (TYPE="G"). Proportional samples with less than 2 liters of water will be augmented at the lab with any grab sample that has been submitted separately and designated as augmented (TYPE="A") sample type. Note that no sample has been augmented (Type='A') since 1998. Should no sample be collected for any week, sample type is missing and listed as no analyses (TYPE='N'). Biased sample (Type 'B') type has been used infrequently since 2007 and indicates samples that were proportionally combined based on streamflow to create a 3-week sample (when crews could not get out to collect the sample after the 3 week). From Dec 1988- Aug 1991, partial and grab weekly samples were analyzed independently of full weekly samples. Flux values for these 3-week periods are based on the weekly samples and have been calculated mathematically (in flux calculations) using current rules for combining samples in the lab.
  • Before Dec 1988 samples were only collected on a 3-week basis. Successful operation of the sampler over the 3 week period represents a complete or full (TYPE="F") sample. When the sampler failed or was out of operation for the entire 3 week period, a grab (TYPE='G') sample was taken to represent the entire period. When the sampler failed or was out of operation for part of the 3 week period, the sample is designated as partial (TYPE="P"). When the partial samples contained insufficient water for analysis, they were "augmented" (TYPE="A") with a grab sample to a level considered sufficient for conducting all analytical measurements. There are only a few cases when the sample contained insufficient water and were saved (TYPE='S') and combined (TYPE='C') with the following sample for analysis. In these cases, there are no independent analytical values for the saved samples (TYPE='S'). Flux values are created for the saved sample interval using streamflow from this interval and using the analytical values from the combined sample representing the 6-week interval.
  • 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 5 flux data only) but is not an actual sample . Nutrient concentrations from the next analyzed sample (in October) are used with the streamflow 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 October sample and on streamflow beginning Oct 1.
  • Quality control samples were taken biannually (one in the winter and one in the summer) at one site each year between 1989 and 2007. Grab QAQC samples were collected above and below the station, and two samples collected from streamwater flowing through the sampler. One of the through-sampler collections was stored at the gagehouse and transported to the lab with the composite sample the following week. The other through-sampler sample and the grab samples were refrigerated at the Andrews until the composite samples are brought to CCAL in Corvallis for analysis. Quality control samples were analyzed using the same methods as the composite samples. these samples are not made public online but are available on request.

Instrumentation:

  • 1) Fredriksen locally-designed battery powered proportional stream water samplers with reed switch assembly (1968-Present); 2) Sigma Model 900 standard portable sampler and a Campbell Scientific CR-10X datalogger (2003-Present). The Sigma sampler is a commercially available and portable sampler powered by a 12 volt battery that has a peristaltic pump, and a programmable control unit. The controller is programmed for flow-based, composite sampling to produce outputs for events that are captured by a datalogger. The controller is programmed to produce repeatable and accurate sample volumes. A record of the program sample history is stored in the controller, and can be reviewed by the operator. The sample storage container is located in the insulated base housing of the Sigma. The sampling system CR-10X is also used to measure and record stream stage height at the gauging station; 3) Streamflow is measured continuously with Leopold-Stevens A-35 recorders and Stevens PAT with Campbell CR-10 data logger.
Laboratory Methods - CF002
  • Laboratory procedures: Official compilation of water analyses begins with the WY 1969 (10/1/68). 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) 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 FNH3. Listed Total Kjeldahl N (TKN) values from 6/1/1970-6/21/1971 for GSWS09 and GSWS10 do not include free ammonia (NH-N) and are shown as estimated. 2) 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 - CF002
  • Monthly concentrations and fluxes were interpolated from the 3-week sampling data. This was a one-time effort that will only be continued as time allows. The Viscual FoxPro (VFP) programs can be shared with interested researchers. The process for creating monthly summaries are listed in: P:\FSDB\HF04\work_don\monthly_chem\status.txt and the work was performed here in Dec 2010. The key program is pio_month.prg, but other processing is necessary first, and the pio_true_mon.prg is used to produce mean annual concentration. In VFP, Entity 1 CF00201_final is the raw concentration data CF00201_month is the raw concentration/interval data, raw data with 'M' and 'Y' points CF00201_year is the original CF00201_TRUE, raw data with 'Y' points Entity 2 CF00202_final is new mean monthly concentration data Entity 3 CF00203_final is mean annual concentration data Entity 4 CF00204_final is new total monthly flux data Entity 5 CF00205_final is the old Entity 2 data (CF00202_TRUE) - calculated flux for each sample
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
Models/Algorithms Methods - CF002
  • Water samples are collected proportionally to streamflow. To obtain mean monthly concentration of analytes, streamflow totals must be broken into intervals that start with the beginning of each month and end at the end of each month. Streamflow is totaled in centimeters from the beginning of each month to the time of the first proportional sample, and from the time of first proportional sample to either the time of the next proportional sample or the end of the month, whichever comes first. Then for each interval, a streamflow total and set of analyte concentrations are available. For the monthly markers at the beginning and end of each month, analyte concentrations from the proportional sample being collected at the month change are assigned. FOR example, analyte concentration values for a 3-week sample collected on Feb 5 would also be assigned to the end of January marker and would therefore be included in the January mean. Analytes from each interval within the month are weighted by streamflow to determine mean concentrations.
  • If samples represent 25 or less days of the month (because one or more samples are missing), the sample is coded 'P'artial. If samples are only present for 5 or less days of the month, the sample is coded 'N' for no sample. Similarly, any analyte that is not analyzed for at least 25 days in a month will be given an 'I'ncomplete qualifier tag for mean monthly concentration values. Flux values calculated from 'I'ncomplete sample analyte concentrations, but are based on the complete streamflow for the month will be considered 'E'stimated. 'I'ncomplete tags will only be used in the flux data when streamflow itself is incomplete for a month. Analyte concentrations and calculated fluxes based on 5 or less days in any month will be considered missing and qualified with an 'N' code no analysis).
  • Sample type codes for the monthly summary values are assigned as follows: F=Full, G=Grab, P=partial. Partial ('P') will have precedence over 'G'rab sample type code. That is, if any sample in a given month is listed as partial, the code will be partial. If all samples are Grab for the month, the code will be Grab. Only if all samples IN month are 'F'ull will the type be labeled 'F'ull.
  • For other analysis codes, any monthly concentration OR flux based on derived calculations will be qualified with a 'D'erived as part of the code. Additionally, collective analysis code for each analyte concentration is assigned and up to two other qualifier codes will be displayed if present for any analysis within the month in the following order of precedence: Estimated, questionable, below detection (E, Q, *). Also note that F=S=C (Saved and Combined samples are treated as 'Full' samples. Saved samples use the 'C'ombined sample analytical concentrations for flux calculation.
  • Key conversion: Kg/ha= 0.1 * mg/l * cm where cm = centimeters of streamflow over the watershed area, and mg/l = milligrams per liter nutrient concentration.

Sampling

Study Extent
  • Watersheds 1 and 2 comprise a low-elevation (442 m to 1082 m) pair of experimental basins with Watershed 2 serving as the control. Watersheds 6, 7, and 8 comprise a high-elevation (863 m to 1190 m) set of experimental basins with Watershed 8 as the control. Watersheds 9 and 10 are a low-elevation pair of small watersheds with Watershed 9 as the control. Mack Ck is a third order, old-growth watershed.
  • Vegetation on Watershed 9 and Watershed 10 (prior to logging) consisted primarily of 450-year-old Douglas-fir mixed with hemlock and younger Douglas-fir. Mid elevation watersheds (1500 ft and 3600 ft). Watershed 2 and 9 are first to second order old-growth watersheds (headwaters of watershed 9 were burned in the 1890's). Old-growth stands are approximately 450 yr old and are dominated by Psme and Tshe at lower elevations and also by Abam at the higher elevations. Watersheds 2, 8, and 9 are undisturbed controls.
  • Sampling frequency: 1-3 weeks
Sampling Description
  • Long term trends in stream water nutrient concentrations and fluxes from gaged experimental watersheds are monitored. Stream water samples are collected over a three week period in proportion to streamflow. Several of the watersheds have been harvested during the study period. Nutrient concentrations of analytes are conducted at the Chemical Cooperative Analytic Laboratory (CCAL) in Corvallis, Oregon.
  • The H.J. Andrews Experimental Forest is within the Lookout Creek Basin (6250 ha). Lookout Creek as well as nine smaller watersheds within the basin have gaging stations. Dominant overstory vegetation is Douglas-fir. Proportional stream water samples are collected at groups of small watersheds with differing harvest treatments: WS 1 and 2; WS 6, 7, and 8; WS 9 and 10. Watersheds 2, 8, and 9 are unharvested reference basins. Mack Creek is a larger basin (600 ha) with old-growth vegetation and Lookout Creek is a 5th order watershed with a USGS gaging station. Drainage areas for the small watersheds range from 9 to 100 ha and elevations range from 460 to 960 m.
  • Watersheds stream sampling history in the H. J. Andrews Forest:
  • Watershed 1: 100% clearcut 1962-1966, burned 1966, no roads; sampling record WY 2003 to present
  • Watershed 2: Control; sampling record WY 1981 to present
  • Watershed 6: 9% roaded 1963, 100% clearcut 1974; sampling record 1972 to 1987, restarted 2003 to present
  • Watershed 7: 60% shelterwood cut 1974, remaining 40% overstory cut in 1984, thinned 2001; sampling record 1972 to 1987, restarted 2002 to present
  • Watershed 8: Control; sampling record WY 1972 to present
  • Watershed 9: Control; sampling record WY 1969 to present
  • Watershed 10: 100% clearcut 1975, unburned; sampling record WY 1969 to present
  • Mack Creek: Control, third-order watershed; sampling record WY 1981 to present
  • Lookout Creek: Approximately 25% harvested; sampling record WY 2005 to present
  • See http://andrewsforest.oregonstate.edu/research/infrastructure/watersheds for more information.
  • Citation:
  • Fredriksen, R. L. Study Plan--Nutrient cycle of a small watershed in the Douglas-fir region of the western slope of the Cascade range in Oregon. 1967. PNW-FSL-1602-22
Spatial Sampling Units
  • Andrews Experimental Forest (HJA)
    W -122.26172200, E -122.10084700, N 44.28196400, S 44.19770400
    Altitude: 1631 to 1631 meter
  • Andrews Watershed 1 Gaging Station
    W -122.25802700, E -122.25802700, N 44.20733900, S 44.20733900
    Altitude: 439 to 439 meter
  • Andrews Watershed 2 Gaging Station
    W -122.24487600, E -122.24487600, N 44.21201500, S 44.21201500
    Altitude: 545 to 545 meter
  • Andrews Watershed 6 Gaging Station
    W -122.18070700, E -122.18070700, N 44.26150800, S 44.26150800
    Altitude: 878 to 878 meter
  • Andrews Watershed 7 Gaging Station
    W -122.17526500, E -122.17526500, N 44.26463700, S 44.26463700
    Altitude: 918 to 918 meter
  • Andrews Watershed 8 Gaging Station
    W -122.17079300, E -122.17079300, N 44.26629426, S 44.26629426
    Altitude: 962 to 962 meter
  • Andrews Watershed 9 Gaging Station
    W -122.25880100, E -122.25880100, N 44.20119000, S 44.20119000
    Altitude: 426 to 426 meter
  • Andrews Watershed 10 Gaging Station
    W -122.26105600, E -122.26105600, N 44.21705700, S 44.21705700
    Altitude: 461 to 461 meter
  • Andrews Mack Creek Gaging Station
    W -122.16744700, E -122.16744700, N 44.21943621, S 44.21943621
    Altitude: 755 to 755 meter
  • Mack Creek
    W -122.16826200, E -122.14698900, N 44.22714600, S 44.20991900
  • 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 Watershed 1
    W -122.25683100, E -122.23581300, N 44.20851700, S 44.19901700
    Altitude: 1027 to 1027 meter
  • Andrews Lookout Creek Gaging Station
    W -122.25714600, E -122.25714600, N 44.21012600, S 44.21012600
    Altitude: 422 to 422 meter
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: hydrology (theme), water chemistry (theme), suspended solids (theme), discharge (theme), streamflow (theme), timber harvest (theme), inorganic nutrients (theme), nutrients (theme), dissolved nutrients (theme), water (theme)
  • Andrews Experimental Forest site thesaurus: Long-Term Ecological Research (LTER) (theme)
  • LTER core research areas: inorganic nutrients (theme)
Taxonomic Hierarchy

No taxonomic hierarchy listed in this EML file.

Data Entities
# Entity Metadata Data
1 CF00201
Proportional stream water sample nutrient concentrations
This is the raw proportional sample concentration data collected periodically (usually every three weeks). Please see mean monthly concentration data provided in entity 2.
 METADATA DATA
2 CF00202
Stream water nutrient mean monthly concentrations
Mean monthly concentrations are interpolated from the 3-week sampling data
 METADATA DATA
3 CF00203
Stream water nutrient mean annual concentrations
Annual mean concentrations are calculated by weighting 3-week periods by streamflow
 METADATA DATA
4 CF00204
Stream water nutrient monthly outflow (kg/ha)
Data are calculated outflow fluxes for each mean monthly concentration value interpolated from the 3-week sampling data
 METADATA DATA
5 CF00205
Stream water nutrient outflow (kg/ha) for each proportional sampling interval
Data are calculated outflow fluxes for each proportional sample period. Alternatively, please consider use of monthly outflow fluxes provided in entity 4.
 METADATA DATA
6 CF00206
Stream water sample log sheet: field and laboratory comments
Field and lab comments
 METADATA DATA
Metadata
CF00201 - Proportional stream water sample nutrient concentrations

Object name: CF00201_v7.csv

Records: 6560

Attributes: 63

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

File size: 1588863 byte

Checksum (MD5): dc4b370c624a28b7164a92bb766b8587

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

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

ID: CF00201.STCODE

Study code

Type system: Microsoft SQL Server 2019

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

ID: CF00201.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SITECODE - char(6) (nominal)

ID: CF00201.SITECODE

Gaging station site code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • GSWS01
    Andrews Watershed 1 Gaging Station
  • GSWS02
    Andrews Watershed 2 Gaging Station
  • GSWS06
    Andrews Watershed 6 Gaging Station
  • GSWS07
    Andrews Watershed 7 Gaging Station
  • GSWS08
    Andrews Watershed 8 Gaging Station
  • GSWS09
    Andrews Watershed 9 Gaging Station
  • GSWS10
    Andrews Watershed 10 Gaging Station
  • GSMACK
    Andrews Mack Creek Gaging Station
  • GSLOOK
    Andrews Lookout Creek Gaging Station
WATERYEAR - numeric(4,0) (interval)

ID: CF00201.WATERYEAR

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

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

DATE_TIME - datetime (dateTime)

ID: CF00201.DATE_TIME

Collection date and time (PST) of the stream water sample - sample collected proportionally to streamflow 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 2019

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

LABNO - char(4) (nominal)

ID: CF00201.LABNO

Lab number code for sample

Type system: Microsoft SQL Server 2019

TYPE - char(2) (nominal)

ID: CF00201.TYPE

Sample type indicator

Type system: Microsoft SQL Server 2019

Code definitions (13)
  • QB
    Quality control samples taken below turbulence box
  • QS
    Quality control sample taken through sampler
  • QL
    Quality control sample taken through sampler and left in gage house until next collection
  • QA
    Quality control sample taken above flume
  • C
    Sample combined with preceeding saved sample(s) for analysis
  • G
    Grab sample taken in lieu of proportional sample
  • S
    Sample saved to combine with following collection (type 'C') due to insufficient water. Nutrient concentrations of the following stream water sample are used to determine fluxes for this period.
  • N
    No sample is collected for this period
  • F
    Complete, full sample. Sampler operational throughout sampling period.
  • YE
    Year end marker allows summary by water year - this is not a sample. Flux values are calculated from streamflow ending Sep 30 and use analyte concentrations from the following sample. 'Y' markers are inserted every Sep30
  • A
    Augmented sample - grab sample added to insufficient proportional sample (rarely used after 1987)
  • P
    Partial sample - proportional sampler did not operate successfully over entire period
  • B
    Biased sample - consecutive samples are proportionally separated and combined based on streamflow - code use begins WY 2008 to approx. two 3-week sampling intervals (where one sample is for 4 wks and the next for 2 wks)
INTERVAL - numeric(6,2) (ratio)

ID: CF00201.INTERVAL

Proportional sampling interval length in days

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 0.020000

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

MEAN_LPS - numeric(8,2) (ratio)

ID: CF00201.MEAN_LPS

Mean discharge over the sampling interval

Type system: Microsoft SQL Server 2019

Unit: liters per second

Precision: 0.100000

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

Q_AREA_CM - numeric(6,2) (ratio)

ID: CF00201.Q_AREA_CM

Streamflow in cm for the time interval represented by the proportional sample

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 0.025000

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

QCODE - char(1) (nominal)

ID: CF00201.QCODE

Streamflow value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • A
    Accepted value for streamflow
  • N
    No streamflow available for period
  • E
    Estimated streamflow value
  • P
    Fire effects may have impacted the data
  • Q
    Streamflow value for the period is questionable
PH - numeric(5,1) (ratio)

ID: CF00201.PH

pH (hydrogen concentration); method: glass electrode

Type system: Microsoft SQL Server 2019

Unit: pH units

Precision: 0.100000

Numeric domain: type=real, min=4.2000 (exclusive=false), max=8.4000 (exclusive=false)

PHCODE - char(1) (nominal)

ID: CF00201.PHCODE

pH value qualifier code

Type system: Microsoft SQL Server 2019

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: CF00201.COND

Specific conductance; method: wheatstone bridge

Type system: Microsoft SQL Server 2019

Unit: micro siemens per centimeter

Precision: 0.400000

Numeric domain: type=real, min=14.4000 (exclusive=false), max=98.0000 (exclusive=false)

CONDCODE - char(1) (nominal)

ID: CF00201.CONDCODE

Conductivity value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00201.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 2019

Unit: milligrams per liter

Precision: 0.020000

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

ALKCODE - char(1) (nominal)

ID: CF00201.ALKCODE

Alkalinity value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00201.SSED

Suspended sediment concentration; method: nonfiltrable residue, gravimetric

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

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

SSEDCODE - char(1) (nominal)

ID: CF00201.SSEDCODE

Suspended sediment value qualifier code

Type system: Microsoft SQL Server 2019

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: CF00201.SI

Silica as silicon concentration; method: automated molybdenum blue

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.050000

Numeric domain: type=real, min=0.1500 (exclusive=false), max=15.0000 (exclusive=false)

SICODE - char(1) (nominal)

ID: CF00201.SICODE

Silica value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00201.UTP

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

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.002000

Numeric domain: type=real, min=0.0050 (exclusive=false), max=0.4920 (exclusive=false)

UTPCODE - char(1) (nominal)

ID: CF00201.UTPCODE

Unfiltered total phosphorus value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00201.TDP

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

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.002000

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

TDPCODE - char(1) (nominal)

ID: CF00201.TDPCODE

Total dissolved phosphorus value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00201.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 2019

Unit: milligrams per liter

Precision: 0.002000

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

PARTPCODE - char(2) (nominal)

ID: CF00201.PARTPCODE

Particulate P value qualifier code

Type system: Microsoft SQL Server 2019

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: CF00201.PO4P

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

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.001000

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

PO4PCODE - char(1) (nominal)

ID: CF00201.PO4PCODE

Ortho phosphorus value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00201.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 2019

Unit: milligrams per liter

Precision: 0.010000

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

UTNCODE - char(2) (nominal)

ID: CF00201.UTNCODE

Unfiltered total nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (10)
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • A
    Accepted value
  • E
    Estimated value
  • 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
  • C
    Value confirmed, contamination suspected (code use begins May 2011)
TDN - numeric(6,2) (ratio)

ID: CF00201.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 2019

Unit: milligrams per liter

Precision: 0.010000

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

TDNCODE - char(2) (nominal)

ID: CF00201.TDNCODE

Total dissolved nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (10)
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • A
    Accepted value
  • E
    Estimated value
  • 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
  • C
    Value confirmed, contamination suspected (code use begins May 2007)
DON - numeric(6,2) (ratio)

ID: CF00201.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 2019

Unit: milligrams per liter

Precision: 0.010000

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

DONCODE - char(2) (nominal)

ID: CF00201.DONCODE

Dissolved organic nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • 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
  • DC
    Derived value confirmed, contamination suspected (code use begins May 2007)
PARTN - numeric(6,2) (ratio)

ID: CF00201.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 2019

Unit: milligrams per liter

Precision: 0.010000

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

PARTNCODE - char(2) (nominal)

ID: CF00201.PARTNCODE

Particulate N value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • 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
  • DC
    Derived value confirmed, contamination suspected (code use begins May 2007)
UTKN - numeric(6,2) (ratio)

ID: CF00201.UTKN

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

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

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

UTKNCODE - char(1) (nominal)

ID: CF00201.UTKNCODE

Unfiltered total Kjeldahl nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00201.TKN

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

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

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

TKNCODE - char(1) (nominal)

ID: CF00201.TKNCODE

Total Kjeldahl nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00201.NH3N

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

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.003000

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

NH3NCODE - char(1) (nominal)

ID: CF00201.NH3NCODE

NH3-N value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00201.NO3N

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

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.001000

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

NO3NCODE - char(1) (nominal)

ID: CF00201.NO3NCODE

NO3-N value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00201.NA

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

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

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

NACODE - char(1) (nominal)

ID: CF00201.NACODE

Na value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00201.K

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

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.030000

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

KCODE - char(1) (nominal)

ID: CF00201.KCODE

K value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00201.CA

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

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.060000

Numeric domain: type=real, min=0.0800 (exclusive=false), max=19.6200 (exclusive=false)

CACODE - char(1) (nominal)

ID: CF00201.CACODE

Ca value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00201.MG

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

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.020000

Numeric domain: type=real, min=0.3100 (exclusive=false), max=13.1100 (exclusive=false)

MGCODE - char(1) (nominal)

ID: CF00201.MGCODE

Mg value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00201.SO4S

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

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.020000

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

SO4SCODE - char(1) (nominal)

ID: CF00201.SO4SCODE

SO4-S value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00201.CL

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

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

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

CLCODE - char(1) (nominal)

ID: CF00201.CLCODE

Cl value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00201.DOC

DOC, dissolved organic carbon concentration; method: combustion

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.050000

Numeric domain: type=real, min=0.1900 (exclusive=false), max=9.2100 (exclusive=false)

DOCCODE - char(1) (nominal)

ID: CF00201.DOCCODE

DOC value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00201.PVOL

Sample volume from streamflow porportional sampler

Type system: Microsoft SQL Server 2019

Unit: kilograms

Precision: 0.001000

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

PVOLCODE - char(1) (nominal)

ID: CF00201.PVOLCODE

Sample volume code

Type system: Microsoft SQL Server 2019

Code definitions (4)
  • A
    Accepted value for sample volume
  • E
    Sample volume value is estimated
  • Q
    Sample volume value is questionable - typically implies volume is measured correctly, but volume does not proportionally represent the collection period
  • N
    No sample volume value available
ANCA - numeric(5,2) (ratio)

ID: CF00201.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 2019

Unit: number

Precision: 0.100000

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

ANCACODE - char(2) (nominal)

ID: CF00201.ANCACODE

Anion-cation ratio qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • D
    Derived anion-cation ratio value is based on the full set of anions and cations
  • N
    No anion-cation ratio calculation determined due to missing analytical components
  • 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
CF00202 - Stream water nutrient mean monthly concentrations

Object name: CF00202_v6.csv

Records: 4420

Attributes: 58

Temporal coverage: 1968-10-01 to 2024-09-01

File size: 922933 byte

Checksum (MD5): 8313610e8da8c6bf62570022e425fe4b

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

Constraints (2)
  • primaryKey: PRIMARY
    CF00202.SITECODE, CF00202.YEAR, CF00202.MONTH
  • notNullConstraint: NOTNULL
    CF00202.STCODE, CF00202.TYPE, CF00202.SITECODE, CF00202.ENTITY, CF00202.WATERYEAR, CF00202.YEAR, CF00202.MONTH
Attributes (58)
STCODE - char(5) (nominal)

ID: CF00202.STCODE

Study code

Type system: Microsoft SQL Server 2019

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

ID: CF00202.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SITECODE - char(6) (nominal)

ID: CF00202.SITECODE

Gaging station site code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • GSWS01
    Andrews Watershed 1 Gaging Station
  • GSWS02
    Andrews Watershed 2 Gaging Station
  • GSWS06
    Andrews Watershed 6 Gaging Station
  • GSWS07
    Andrews Watershed 7 Gaging Station
  • GSWS08
    Andrews Watershed 8 Gaging Station
  • GSWS09
    Andrews Watershed 9 Gaging Station
  • GSWS10
    Andrews Watershed 10 Gaging Station
  • GSMACK
    Andrews Mack Creek Gaging Station
  • GSLOOK
    Andrews Lookout Creek Gaging Station
WATERYEAR - numeric(4,0) (interval)

ID: CF00202.WATERYEAR

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

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: CF00202.YEAR

Calendar year of annual or monthly summary

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

MONTH - numeric(2,0) (ratio)

ID: CF00202.MONTH

Month of summary

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

TYPE - char(2) (nominal)

ID: CF00202.TYPE

Sample type indicator

Type system: Microsoft SQL Server 2019

Code definitions (13)
  • QB
    Quality control samples taken below turbulence box
  • QS
    Quality control sample taken through sampler
  • QL
    Quality control sample taken through sampler and left in gage house until next collection
  • QA
    Quality control sample taken above flume
  • C
    Sample combined with preceeding saved sample(s) for analysis
  • G
    Grab sample taken in lieu of proportional sample
  • S
    Sample saved to combine with following collection (type 'C') due to insufficient water. Nutrient concentrations of the following stream water sample are used to determine fluxes for this period.
  • N
    No sample is collected for this period
  • F
    Complete, full sample. Sampler operational throughout sampling period.
  • YE
    Year end marker allows summary by water year - this is not a sample. Flux values are calculated from streamflow ending Sep 30 and use analyte concentrations from the following sample. 'Y' markers are inserted every Sep30
  • A
    Augmented sample - grab sample added to insufficient proportional sample (rarely used after 1987)
  • P
    Partial sample - proportional sampler did not operate successfully over entire period
  • B
    Biased sample - consecutive samples are proportionally separated and combined based on streamflow - code use begins WY 2008 to approx. two 3-week sampling intervals (where one sample is for 4 wks and the next for 2 wks)
MEAN_LPS - numeric(8,2) (ratio)

ID: CF00202.MEAN_LPS

Mean discharge over the sampling interval

Type system: Microsoft SQL Server 2019

Unit: liters per second

Precision: 0.100000

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

Q_AREA_MO - numeric(6,2) (ratio)

ID: CF00202.Q_AREA_MO

Total monthly streamflow over watershed area

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 0.250000

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

QCODE_MO - char(1) (nominal)

ID: CF00202.QCODE_MO

Monthly streamflow value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • P
    Fire effects may have impacted the data
PH_MO - numeric(5,2) (ratio)

ID: CF00202.PH_MO

Mean monthly pH

Type system: Microsoft SQL Server 2019

Unit: pH units

Precision: 0.100000

Numeric domain: type=real, min=4.3100 (exclusive=false), max=8.0100 (exclusive=false)

PHCODE_MO - char(2) (nominal)

ID: CF00202.PHCODE_MO

Monthly pH value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • IE
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; one or more values estimated
COND_MO - numeric(6,2) (ratio)

ID: CF00202.COND_MO

Mean monthly specific conductivity concentration

Type system: Microsoft SQL Server 2019

Unit: micro siemens per centimeter

Precision: 0.400000

Numeric domain: type=real, min=16.8600 (exclusive=false), max=92.0500 (exclusive=false)

CONDCODE_MO - char(2) (nominal)

ID: CF00202.CONDCODE_MO

Monthly conductivity value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • IE
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; one or more values estimated
ALK_MO - numeric(6,2) (ratio)

ID: CF00202.ALK_MO

Mean monthly alkalinity concentration as CaCO3 (calcium carbonate)

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.020000

Numeric domain: type=real, min=3.1200 (exclusive=false), max=40.6000 (exclusive=false)

ALKCODE_MO - char(2) (nominal)

ID: CF00202.ALKCODE_MO

Monthly alkalinity qualifier value code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • *
    Monthly value includes one or more values measured below the detection limit
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
SSED_MO - numeric(6,2) (ratio)

ID: CF00202.SSED_MO

Mean monthly suspended sediment concentratiom

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

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

SSEDCODE_MO - char(2) (nominal)

ID: CF00202.SSEDCODE_MO

Monthly suspended sediment value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
SI_MO - numeric(6,2) (ratio)

ID: CF00202.SI_MO

Mean monthly silica concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.050000

Numeric domain: type=real, min=1.0400 (exclusive=false), max=12.6000 (exclusive=false)

SICODE_MO - char(2) (nominal)

ID: CF00202.SICODE_MO

Monthly silica value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (7)
  • A
    Accepted monthly value
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • IQ
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; one or more values questionable
  • E
    Monthly value includes estimated values
  • EQ
    Monthly value includes estimated values; one or more values were questionable
UTP_MO - numeric(6,3) (ratio)

ID: CF00202.UTP_MO

Mean monthly unfiltered total phosphorus concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.002000

Numeric domain: type=real, min=0.0060 (exclusive=false), max=0.4410 (exclusive=false)

UTPCODE_MO - char(2) (nominal)

ID: CF00202.UTPCODE_MO

Monthly unfiltered total phosphorus value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • IE
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; one or more values estimated
TDP_MO - numeric(6,3) (ratio)

ID: CF00202.TDP_MO

Mean monthly total dissolved phosphorus concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.002000

Numeric domain: type=real, min=0.0020 (exclusive=false), max=0.3330 (exclusive=false)

TDPCODE_MO - char(2) (nominal)

ID: CF00202.TDPCODE_MO

Monthly total dissolved phosphorus value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • *
    Monthly value includes one or more values measured below the detection limit
PO4P_MO - numeric(6,3) (ratio)

ID: CF00202.PO4P_MO

Mean monthly ortho phosphorus (PO4-P) concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.001000

Numeric domain: type=real, min=0.0020 (exclusive=false), max=0.0910 (exclusive=false)

PO4PCODE_MO - char(2) (nominal)

ID: CF00202.PO4PCODE_MO

Monthly ortho phosphorus (PO4-P) value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • *
    Monthly value includes one or more values measured below the detection limit
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
PARTP_MO - numeric(6,3) (ratio)

ID: CF00202.PARTP_MO

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

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.002000

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

PARTPCODE_MO - char(3) (nominal)

ID: CF00202.PARTPCODE_MO

Monthly particulate P value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • D
    Monthly value based on derived values
  • DE
    Monthly value based on derived values; one or more values estimated
  • DQ
    Monthly value based on derived values; one or more values questionable
  • ID
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values
  • IDE
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values of which one or more values are estimated
  • N
    No analyses conducted for proportional samples taken during the month
UTN_MO - numeric(6,2) (ratio)

ID: CF00202.UTN_MO

Mean monthly total nitrogen concentration (unfiltered samples)

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

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

UTNCODE_MO - char(3) (nominal)

ID: CF00202.UTNCODE_MO

Monthly unfiltered total nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (18)
  • *
    Monthly value includes one or more values measured below the detection limit
  • D
    Monthly value based on derived values
  • D*
    Monthly value based on derived values; one or more values measured below the detection limit
  • DE
    Monthly value based on derived values; one or more values estimated
  • DQ
    Monthly value based on derived values; one or more values questionable
  • DQ*
    Monthly value based on derived values; one or more values questionable; one or more values measured below the detection limit
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • ID
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values
  • ID*
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values of which one or more values measured below the detection limit
  • IDE
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values of which one or more values are estimated
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • E
    Monthly value includes estimated values
  • DE*
    Monthly value based on derived values; one or more values estimated; one or more values measured below the detection limit
  • Q*
    Monthly value includes questionable sample values; one or more values measured below the detection limit
  • A
    Accepted monthly value
  • I*
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary; one or more values measured below the detection limit
  • E*
    One or more values estimated; one or more values measured below the detection limit
TDN_MO - numeric(6,2) (interval)

ID: CF00202.TDN_MO

Mean monthly total dissolved nitrogen concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

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

TDNCODE_MO - char(3) (nominal)

ID: CF00202.TDNCODE_MO

Monthly total dissolved nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (18)
  • *
    Monthly value includes one or more values measured below the detection limit
  • D
    Monthly value based on derived values
  • D*
    Monthly value based on derived values; one or more values measured below the detection limit
  • DE
    Monthly value based on derived values; one or more values estimated
  • DQ
    Monthly value based on derived values; one or more values questionable
  • DQ*
    Monthly value based on derived values; one or more values questionable; one or more values measured below the detection limit
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • ID
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values
  • ID*
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values of which one or more values measured below the detection limit
  • IDE
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values of which one or more values are estimated
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • E
    Monthly value includes estimated values
  • DE*
    Monthly value based on derived values; one or more values estimated; one or more values measured below the detection limit
  • Q*
    Monthly value includes questionable sample values; one or more values measured below the detection limit
  • A
    Accepted monthly value
  • I*
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary; one or more values measured below the detection limit
  • E*
    One or more values estimated; one or more values measured below the detection limit
DON_MO - numeric(6,2) (ratio)

ID: CF00202.DON_MO

Mean monthly 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 2019

Unit: milligrams per liter

Precision: 0.010000

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

DONCODE_MO - char(3) (nominal)

ID: CF00202.DONCODE_MO

Monthly dissolved organic N value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • D
    Monthly value based on derived values
  • D*
    Monthly value based on derived values; one or more values measured below the detection limit
  • DE
    Monthly value based on derived values; one or more values estimated
  • DQ
    Monthly value based on derived values; one or more values questionable
  • DQ*
    Monthly value based on derived values; one or more values questionable; one or more values measured below the detection limit
  • ID
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values
  • ID*
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values of which one or more values measured below the detection limit
  • N
    No analyses conducted for proportional samples taken during the month
  • DE*
    Monthly value based on derived values; one or more values estimated; one or more values measured below the detection limit
PARTN_MO - numeric(6,2) (ratio)

ID: CF00202.PARTN_MO

Mean monthly 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 2019

Unit: milligrams per liter

Precision: 0.010000

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

PARTNCODE_MO - char(3) (nominal)

ID: CF00202.PARTNCODE_MO

Monthly particulate N value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • D
    Monthly value based on derived values
  • D*
    Monthly value based on derived values; one or more values measured below the detection limit
  • DE
    Monthly value based on derived values; one or more values estimated
  • DQ
    Monthly value based on derived values; one or more values questionable
  • ID
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values
  • N
    No analyses conducted for proportional samples taken during the month
  • DQ*
    Monthly value based on derived values; one or more values questionable; one or more values measured below the detection limit
  • ID*
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values; one or more values measured below the detection limit
  • DE*
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values; one or more values estimated
UTKN_MO - numeric(6,2) (ratio)

ID: CF00202.UTKN_MO

Mean monthly unfiltered total Kjeldahl nitrogen concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

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

UTKNCODE_MO - char(2) (nominal)

ID: CF00202.UTKNCODE_MO

Monthly unfiltered total Kjeldahl nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • *
    Monthly value includes one or more values measured below the detection limit
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
TKN_MO - numeric(6,2) (ratio)

ID: CF00202.TKN_MO

Mean monthly total kjeldahl nitrogen concentration (dissolved)

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

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

TKNCODE_MO - char(2) (nominal)

ID: CF00202.TKNCODE_MO

Monthly total Kjeldahl nitrogen (dissolved) value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • *
    Monthly value includes one or more values measured below the detection limit
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
NH3N_MO - numeric(6,3) (ratio)

ID: CF00202.NH3N_MO

Mean monthly ammonia-nitrogen (NH3-N) concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.003000

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

NH3NCODE_MO - char(2) (nominal)

ID: CF00202.NH3NCODE_MO

Monthly ammonia-nitrogen (NH3-N) value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (8)
  • A
    Accepted monthly value
  • *
    Monthly value includes one or more values measured below the detection limit
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q*
    Monthly value includes questionable sample values; one or more values measured below the detection limit
  • I*
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; one or more values measured below the detection limit
  • E*
    Monthly value includes estimated values; one or more values measured below the detection limit
NO3N_MO - numeric(6,3) (ratio)

ID: CF00202.NO3N_MO

Mean monthly nitrate-nitrogen (NO3-N) concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.001000

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

NO3NCODE_MO - char(2) (nominal)

ID: CF00202.NO3NCODE_MO

Monthly nitrate-nitrogen (NO3-N) value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • A
    Accepted monthly value
  • *
    Monthly value includes one or more values measured below the detection limit
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • Q*
    Monthly value includes questionable sample values; one or more values measured below the detection limit
  • I*
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; one or more values measured below the detection limit
  • E*
    Monthly value includes estimated values; one or more values measured below the detection limit
NA_MO - numeric(6,2) (ratio)

ID: CF00202.NA_MO

Mean monthly sodium concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.5100 (exclusive=false), max=5.5700 (exclusive=false)

NACODE_MO - char(2) (nominal)

ID: CF00202.NACODE_MO

Monthly sodium value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • *
    Monthly value includes one or more values measured below the detection limit
K_MO - numeric(6,2) (ratio)

ID: CF00202.K_MO

Mean monthly potassium concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.030000

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

KCODE_MO - char(2) (nominal)

ID: CF00202.KCODE_MO

Monthly potassium value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • *
    Monthly value includes one or more values measured below the detection limit
CA_MO - numeric(6,2) (ratio)

ID: CF00202.CA_MO

Mean monthly calcium concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.060000

Numeric domain: type=real, min=0.5700 (exclusive=false), max=10.3000 (exclusive=false)

CACODE_MO - char(1) (nominal)

ID: CF00202.CACODE_MO

Monthly calcium value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • IE
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; one or more values estimated
MG_MO - numeric(6,2) (ratio)

ID: CF00202.MG_MO

Mean monthly magnesium concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.020000

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

MGCODE_MO - char(2) (nominal)

ID: CF00202.MGCODE_MO

Monthly magnesium value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
SO4S_MO - numeric(6,2) (ratio)

ID: CF00202.SO4S_MO

Mean monthly sulfate-sulfur (SO4-S) concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.020000

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

SO4SCODE_MO - char(2) (nominal)

ID: CF00202.SO4SCODE_MO

Monthly sulfate-sulfur (SO4-S) value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
CL_MO - numeric(6,2) (ratio)

ID: CF00202.CL_MO

Mean monthly chloride concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

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

CLCODE_MO - char(2) (nominal)

ID: CF00202.CLCODE_MO

Monthly chloride value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (4)
  • A
    Accepted monthly value
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • E
    Monthly value includes estimated values
DOC_MO - numeric(6,2) (ratio)

ID: CF00202.DOC_MO

Mean monthly dissolved organic carbon concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.050000

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

DOCCODE_MO - char(2) (nominal)

ID: CF00202.DOCCODE_MO

Monthly dissolved organic carbon value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • A
    Accepted monthly value
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • E
    Monthly value includes estimated values
CF00203 - Stream water nutrient mean annual concentrations

Object name: CF00203_v6.csv

Records: 372

Attributes: 54

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

File size: 73523 byte

Checksum (MD5): 6cd0658c9f9fc0938c8508ef8b254072

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

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

ID: CF00203.STCODE

Study code

Type system: Microsoft SQL Server 2019

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

ID: CF00203.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SITECODE - char(6) (nominal)

ID: CF00203.SITECODE

Gaging station site code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • GSWS01
    Andrews Watershed 1 Gaging Station
  • GSWS02
    Andrews Watershed 2 Gaging Station
  • GSWS06
    Andrews Watershed 6 Gaging Station
  • GSWS07
    Andrews Watershed 7 Gaging Station
  • GSWS08
    Andrews Watershed 8 Gaging Station
  • GSWS09
    Andrews Watershed 9 Gaging Station
  • GSWS10
    Andrews Watershed 10 Gaging Station
  • GSMACK
    Andrews Mack Creek Gaging Station
  • GSLOOK
    Andrews Lookout Creek Gaging Station
WATERYEAR - numeric(4,0) (interval)

ID: CF00203.WATERYEAR

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

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

Q_AREA_YR - numeric(6,2) (ratio)

ID: CF00203.Q_AREA_YR

Total annual streamflow for the wateryear

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 0.250000

Numeric domain: type=real, min=35.5500 (exclusive=false), max=290.2100 (exclusive=false)

QCODE_YR - char(1) (nominal)

ID: CF00203.QCODE_YR

Annual streamflow value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • N
    No streamflow available for period
  • E
    Total includes estimated streamflow values
  • I
    Incomplete, parts of year missing from annual summary
  • A
    Accepted value - all streamflow is included and not estimated for the wateryear
  • P
    Fire effects may have impacted the data
PH_YR - numeric(5,1) (ratio)

ID: CF00203.PH_YR

Mean annual pH

Type system: Microsoft SQL Server 2019

Unit: pH units

Precision: 0.100000

Numeric domain: type=real, min=5.5000 (exclusive=false), max=7.7000 (exclusive=false)

PHCODE_YR - char(2) (nominal)

ID: CF00203.PHCODE_YR

Annual pH value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (7)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • 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: CF00203.COND_YR

Mean annual specific conductivity concentration

Type system: Microsoft SQL Server 2019

Unit: micro siemens per centimeter

Precision: 0.400000

Numeric domain: type=real, min=21.3700 (exclusive=false), max=72.1000 (exclusive=false)

CONDCODE_YR - char(2) (nominal)

ID: CF00203.CONDCODE_YR

Annual conductivity value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    Annual value includes one or more values measured below the detection limit
  • 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
ALK_YR - numeric(6,2) (ratio)

ID: CF00203.ALK_YR

Mean annual alkalinity concentration as CaCO3 (calcium carbonate). All units are now converted from HCO3-C (bi-carbonate)

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.020000

Numeric domain: type=real, min=10.4800 (exclusive=false), max=26.5000 (exclusive=false)

ALKCODE_YR - char(2) (nominal)

ID: CF00203.ALKCODE_YR

Annual alkalinity qualifier value code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    Annual value includes one or more values measured below the detection limit
  • 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
SSED_YR - numeric(6,2) (ratio)

ID: CF00203.SSED_YR

Mean annual suspended sediment concentratiom

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.4500 (exclusive=false), max=565.3200 (exclusive=false)

SSEDCODE_YR - char(2) (nominal)

ID: CF00203.SSEDCODE_YR

Annual suspended sediment value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (7)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • 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: CF00203.SI_YR

Mean annual silica concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.050000

Numeric domain: type=real, min=3.1000 (exclusive=false), max=10.2000 (exclusive=false)

SICODE_YR - char(2) (nominal)

ID: CF00203.SICODE_YR

Annual silica value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    Annual value includes one or more values measured below the detection limit
  • 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
UTP_YR - numeric(6,3) (ratio)

ID: CF00203.UTP_YR

Mean annual unfiltered total phosphorus concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.002000

Numeric domain: type=real, min=0.0090 (exclusive=false), max=0.1150 (exclusive=false)

UTPCODE_YR - char(2) (nominal)

ID: CF00203.UTPCODE_YR

Annual unfiltered total phosphorus value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    Annual value includes one or more values measured below the detection limit
  • 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
TDP_YR - numeric(6,3) (ratio)

ID: CF00203.TDP_YR

Mean annual total dissolved phosphorus concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.002000

Numeric domain: type=real, min=0.0060 (exclusive=false), max=0.0800 (exclusive=false)

TDPCODE_YR - char(2) (nominal)

ID: CF00203.TDPCODE_YR

Annual total dissolved phosphorus value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    Annual value includes one or more values measured below the detection limit
  • 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
PARTP_YR - numeric(6,3) (ratio)

ID: CF00203.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 2019

Unit: milligrams per liter

Precision: 0.002000

Numeric domain: type=real, min=0.0010 (exclusive=false), max=0.0940 (exclusive=false)

PARTPCODE_YR - char(3) (nominal)

ID: CF00203.PARTPCODE_YR

Annual particulate P value qualifier code

Type system: Microsoft SQL Server 2019

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: CF00203.PO4P_YR

Mean annual ortho phosphorus (PO4-P) concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.001000

Numeric domain: type=real, min=0.0040 (exclusive=false), max=0.0430 (exclusive=false)

PO4PCODE_YR - char(2) (nominal)

ID: CF00203.PO4PCODE_YR

Annual ortho phosphorus value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    Annual value includes one or more values measured below the detection limit
  • 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
UTN_YR - numeric(6,2) (ratio)

ID: CF00203.UTN_YR

Mean annual total nitrogen concentration (unfiltered samples)

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

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

UTNCODE_YR - char(3) (nominal)

ID: CF00203.UTNCODE_YR

Annual unfiltered total nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (17)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    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
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • 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
  • 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
TDN_YR - numeric(6,2) (interval)

ID: CF00203.TDN_YR

Mean annual total dissolved nitrogen concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

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

TDNCODE_YR - char(3) (nominal)

ID: CF00203.TDNCODE_YR

Annual total dissolved nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (17)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    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
  • I*
    Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit
  • 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
  • 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
DON_YR - numeric(6,2) (ratio)

ID: CF00203.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 2019

Unit: milligrams per liter

Precision: 0.010000

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

DONCODE_YR - char(3) (nominal)

ID: CF00203.DONCODE_YR

Annual dissolved organic N value qualifier code

Type system: Microsoft SQL Server 2019

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: CF00203.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 2019

Unit: milligrams per liter

Precision: 0.010000

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

PARTNCODE_YR - char(3) (nominal)

ID: CF00203.PARTNCODE_YR

Annual particulate N value qualifier code

Type system: Microsoft SQL Server 2019

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: CF00203.UTKN_YR

Mean annual unfiltered total Kjeldahl nitrogen concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

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

UTKNCODE_YR - char(2) (nominal)

ID: CF00203.UTKNCODE_YR

Annual unfiltered total Kjeldahl nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    Annual value includes one or more values measured below the detection limit
  • 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
TKN_YR - numeric(6,2) (ratio)

ID: CF00203.TKN_YR

Mean annual total kjeldahl nitrogen concentration (dissolved)

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

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

TKNCODE_YR - char(2) (nominal)

ID: CF00203.TKNCODE_YR

Annual total Kjeldahl nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    Annual value includes one or more values measured below the detection limit
  • 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
NH3N_YR - numeric(6,3) (ratio)

ID: CF00203.NH3N_YR

Mean annual ammonia (NH3-N) concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.003000

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

NH3NCODE_YR - char(2) (nominal)

ID: CF00203.NH3NCODE_YR

Annual NH3-N value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    Annual value includes one or more values measured below the detection limit
  • 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
NO3N_YR - numeric(6,3) (ratio)

ID: CF00203.NO3N_YR

Mean annual nitrate-nitrogen (NO3-N) concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.001000

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

NO3NCODE_YR - char(2) (nominal)

ID: CF00203.NO3NCODE_YR

Annual NO3-N value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    Annual value includes one or more values measured below the detection limit
  • 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
NA_YR - numeric(6,2) (ratio)

ID: CF00203.NA_YR

Mean annual sodium concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=1.2800 (exclusive=false), max=3.2400 (exclusive=false)

NACODE_YR - char(2) (nominal)

ID: CF00203.NACODE_YR

Annual Na value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    Annual value includes one or more values measured below the detection limit
  • 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
K_YR - numeric(6,2) (ratio)

ID: CF00203.K_YR

Mean annual potassium concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.030000

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

KCODE_YR - char(2) (nominal)

ID: CF00203.KCODE_YR

Annual K value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    Annual value includes one or more values measured below the detection limit
  • 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
CA_YR - numeric(6,2) (ratio)

ID: CF00203.CA_YR

Mean annual calcium concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.060000

Numeric domain: type=real, min=1.9900 (exclusive=false), max=6.1700 (exclusive=false)

CACODE_YR - char(2) (nominal)

ID: CF00203.CACODE_YR

Annual Ca value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    Annual value includes one or more values measured below the detection limit
  • 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
MG_YR - numeric(6,2) (ratio)

ID: CF00203.MG_YR

Mean annual magnesium concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.020000

Numeric domain: type=real, min=0.4300 (exclusive=false), max=3.2600 (exclusive=false)

MGCODE_YR - char(2) (nominal)

ID: CF00203.MGCODE_YR

Annual Mg value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    Annual value includes one or more values measured below the detection limit
  • 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
SO4S_YR - numeric(6,2) (ratio)

ID: CF00203.SO4S_YR

Mean annual SO4-S (sulfate-sulfur) concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.020000

Numeric domain: type=real, min=0.0500 (exclusive=false), max=1.1800 (exclusive=false)

SO4SCODE_YR - char(2) (nominal)

ID: CF00203.SO4SCODE_YR

Annual SO4-S value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    Annual value includes one or more values measured below the detection limit
  • 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
CL_YR - numeric(6,2) (ratio)

ID: CF00203.CL_YR

Mean annual chloride concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.010000

Numeric domain: type=real, min=0.5400 (exclusive=false), max=4.2200 (exclusive=false)

CLCODE_YR - char(2) (nominal)

ID: CF00203.CLCODE_YR

Annual Cl value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    Annual value includes one or more values measured below the detection limit
  • 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
DOC_YR - numeric(6,2) (ratio)

ID: CF00203.DOC_YR

Mean annual dissolved organic carbon concentration

Type system: Microsoft SQL Server 2019

Unit: milligrams per liter

Precision: 0.050000

Numeric domain: type=real, min=0.3800 (exclusive=false), max=2.8200 (exclusive=false)

DOCCODE_YR - char(2) (nominal)

ID: CF00203.DOCCODE_YR

Annual DOC value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • N
    No analyses conducted in water year
  • Q
    Annual value includes questionable sample values
  • I
    Annual value incomplete; values are missing for part of the year and not included in annual summary
  • E
    Annual value includes estimated values
  • A
    Accepted annual value
  • *
    Annual value includes one or more values measured below the detection limit
  • 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
CF00204 - Stream water nutrient monthly outflow (kg/ha)

Object name: CF00204_v6.csv

Records: 4420

Attributes: 53

Temporal coverage: 1968-10-01 to 2024-09-01

File size: 838768 byte

Checksum (MD5): 17c0263ac15d3a1fa101476f2141f2ea

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

Constraints (2)
  • primaryKey: PRIMARY
    CF00204.SITECODE, CF00204.YEAR, CF00204.MONTH
  • notNullConstraint: NOTNULL
    CF00204.STCODE, CF00204.TYPE, CF00204.SITECODE, CF00204.ENTITY, CF00204.WATERYEAR, CF00204.YEAR, CF00204.MONTH
Attributes (53)
STCODE - char(5) (nominal)

ID: CF00204.STCODE

Study code

Type system: Microsoft SQL Server 2019

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

ID: CF00204.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SITECODE - char(6) (nominal)

ID: CF00204.SITECODE

Gaging station site code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • GSWS01
    Andrews Watershed 1 Gaging Station
  • GSWS02
    Andrews Watershed 2 Gaging Station
  • GSWS06
    Andrews Watershed 6 Gaging Station
  • GSWS07
    Andrews Watershed 7 Gaging Station
  • GSWS08
    Andrews Watershed 8 Gaging Station
  • GSWS09
    Andrews Watershed 9 Gaging Station
  • GSWS10
    Andrews Watershed 10 Gaging Station
  • GSMACK
    Andrews Mack Creek Gaging Station
  • GSLOOK
    Andrews Lookout Creek Gaging Station
WATERYEAR - numeric(4,0) (interval)

ID: CF00204.WATERYEAR

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

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: CF00204.YEAR

Calendar year of annual or monthly summary

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

MONTH - numeric(2,0) (ratio)

ID: CF00204.MONTH

Month of summary

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

TYPE - char(2) (nominal)

ID: CF00204.TYPE

Sample type indicator

Type system: Microsoft SQL Server 2019

Code definitions (13)
  • QB
    Quality control samples taken below turbulence box
  • QS
    Quality control sample taken through sampler
  • QL
    Quality control sample taken through sampler and left in gage house until next collection
  • QA
    Quality control sample taken above flume
  • C
    Sample combined with preceeding saved sample(s) for analysis
  • G
    Grab sample taken in lieu of proportional sample
  • S
    Sample saved to combine with following collection (type 'C') due to insufficient water. Nutrient concentrations of the following stream water sample are used to determine fluxes for this period.
  • N
    No sample is collected for this period
  • F
    Complete, full sample. Sampler operational throughout sampling period.
  • YE
    Year end marker allows summary by water year - this is not a sample. Flux values are calculated from streamflow ending Sep 30 and use analyte concentrations from the following sample. 'Y' markers are inserted every Sep30
  • A
    Augmented sample - grab sample added to insufficient proportional sample (rarely used after 1987)
  • P
    Partial sample - proportional sampler did not operate successfully over entire period
  • B
    Biased sample - consecutive samples are proportionally separated and combined based on streamflow - code use begins WY 2008 to approx. two 3-week sampling intervals (where one sample is for 4 wks and the next for 2 wks)
Q_AREA_MO - numeric(6,2) (ratio)

ID: CF00204.Q_AREA_MO

Total monthly streamflow over watershed area

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 0.250000

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

QCODE_MO - char(1) (nominal)

ID: CF00204.QCODE_MO

Monthly streamflow value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • P
    Fire effects may have impacted the data
ALK_OUT_MO - numeric(6,2) (ratio)

ID: CF00204.ALK_OUT_MO

Total monthly alkalinity outflow as CaCO3 (calcium carbonate). All units are now converted from HCO3-C (bi-carbonate)

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.050000

Numeric domain: type=real, min=0.0700 (exclusive=false), max=124.3300 (exclusive=false)

ALKCODE_MO - char(2) (nominal)

ID: CF00204.ALKCODE_MO

Monthly alkalinity qualifier value code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • *
    Monthly value includes one or more values measured below the detection limit
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
SSED_OUT_MO - numeric(8,2) (ratio)

ID: CF00204.SSED_OUT_MO

Total monthly suspended sediment outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.050000

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

SSEDCODE_MO - char(2) (nominal)

ID: CF00204.SSEDCODE_MO

Monthly suspended sediment value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
SI_OUT_MO - numeric(6,2) (ratio)

ID: CF00204.SI_OUT_MO

Total monthly silica outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.050000

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

SICODE_MO - char(2) (nominal)

ID: CF00204.SICODE_MO

Monthly silica value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (7)
  • A
    Accepted monthly value
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • IQ
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; one or more values questionable
  • E
    Monthly value includes estimated values
  • EQ
    Monthly value includes estimated values; one or more values were questionable
UTP_OUT_MO - numeric(5,3) (ratio)

ID: CF00204.UTP_OUT_MO

Total monthly unfiltered total phosphorus outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.005000

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

UTPCODE_MO - char(2) (nominal)

ID: CF00204.UTPCODE_MO

Monthly unfiltered total phosphorus value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • IE
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; one or more values estimated
TDP_OUT_MO - numeric(5,3) (ratio)

ID: CF00204.TDP_OUT_MO

Total monthly total dissolved phosphorus outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.005000

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

TDPCODE_MO - char(2) (nominal)

ID: CF00204.TDPCODE_MO

Monthly total dissolved phosphorus value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • *
    Monthly value includes one or more values measured below the detection limit
PO4P_OUT_MO - numeric(5,3) (ratio)

ID: CF00204.PO4P_OUT_MO

Total monthly ortho phosphorus (PO4-P) outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.005000

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

PO4PCODE_MO - char(2) (nominal)

ID: CF00204.PO4PCODE_MO

Monthly ortho phosphorus (PO4-P) value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • *
    Monthly value includes one or more values measured below the detection limit
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
PARTP_OUT_MO - numeric(5,3) (ratio)

ID: CF00204.PARTP_OUT_MO

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

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.005000

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

PARTPCODE_MO - char(3) (nominal)

ID: CF00204.PARTPCODE_MO

Monthly particulate P value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • D
    Monthly value based on derived values
  • DE
    Monthly value based on derived values; one or more values estimated
  • DQ
    Monthly value based on derived values; one or more values questionable
  • ID
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values
  • IDE
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values of which one or more values are estimated
  • N
    No analyses conducted for proportional samples taken during the month
UTN_OUT_MO - numeric(5,2) (ratio)

ID: CF00204.UTN_OUT_MO

Total monthly total nitrogen outflow (unfiltered sample)

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.010000

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

UTNCODE_MO - char(3) (nominal)

ID: CF00204.UTNCODE_MO

Monthly unfiltered total nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (18)
  • *
    Monthly value includes one or more values measured below the detection limit
  • D
    Monthly value based on derived values
  • D*
    Monthly value based on derived values; one or more values measured below the detection limit
  • DE
    Monthly value based on derived values; one or more values estimated
  • DQ
    Monthly value based on derived values; one or more values questionable
  • DQ*
    Monthly value based on derived values; one or more values questionable; one or more values measured below the detection limit
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • ID
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values
  • ID*
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values of which one or more values measured below the detection limit
  • IDE
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values of which one or more values are estimated
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • E
    Monthly value includes estimated values
  • DE*
    Monthly value based on derived values; one or more values estimated; one or more values measured below the detection limit
  • Q*
    Monthly value includes questionable sample values; one or more values measured below the detection limit
  • A
    Accepted monthly value
  • I*
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary; one or more values measured below the detection limit
  • E*
    One or more values estimated; one or more values measured below the detection limit
TDN_OUT_MO - numeric(5,2) (interval)

ID: CF00204.TDN_OUT_MO

Total monthly total dissolved nitrogen outflow (filtered sample)

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.010000

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

TDNCODE_MO - char(3) (nominal)

ID: CF00204.TDNCODE_MO

Monthly total dissolved nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (18)
  • *
    Monthly value includes one or more values measured below the detection limit
  • D
    Monthly value based on derived values
  • D*
    Monthly value based on derived values; one or more values measured below the detection limit
  • DE
    Monthly value based on derived values; one or more values estimated
  • DQ
    Monthly value based on derived values; one or more values questionable
  • DQ*
    Monthly value based on derived values; one or more values questionable; one or more values measured below the detection limit
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • ID
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values
  • ID*
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values of which one or more values measured below the detection limit
  • IDE
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values of which one or more values are estimated
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • E
    Monthly value includes estimated values
  • DE*
    Monthly value based on derived values; one or more values estimated; one or more values measured below the detection limit
  • Q*
    Monthly value includes questionable sample values; one or more values measured below the detection limit
  • A
    Accepted monthly value
  • I*
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary; one or more values measured below the detection limit
  • E*
    One or more values estimated; one or more values measured below the detection limit
DON_OUT_MO - numeric(5,2) (ratio)

ID: CF00204.DON_OUT_MO

Total monthly dissolved organic N outflow - 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 2019

Unit: kilograms per hectare

Precision: 0.010000

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

DONCODE_MO - char(3) (nominal)

ID: CF00204.DONCODE_MO

Monthly dissolved organic N value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • D
    Monthly value based on derived values
  • D*
    Monthly value based on derived values; one or more values measured below the detection limit
  • DE
    Monthly value based on derived values; one or more values estimated
  • DQ
    Monthly value based on derived values; one or more values questionable
  • DQ*
    Monthly value based on derived values; one or more values questionable; one or more values measured below the detection limit
  • ID
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values
  • ID*
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values of which one or more values measured below the detection limit
  • N
    No analyses conducted for proportional samples taken during the month
  • DE*
    Monthly value based on derived values; one or more values estimated; one or more values measured below the detection limit
PARTN_OUT_MO - numeric(5,2) (ratio)

ID: CF00204.PARTN_OUT_MO

Total monthly particulate N outflow - 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 2019

Unit: kilograms per hectare

Precision: 0.010000

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

PARTNCODE_MO - char(3) (nominal)

ID: CF00204.PARTNCODE_MO

Monthly particulate N value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • D
    Monthly value based on derived values
  • D*
    Monthly value based on derived values; one or more values measured below the detection limit
  • DE
    Monthly value based on derived values; one or more values estimated
  • DQ
    Monthly value based on derived values; one or more values questionable
  • ID
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values
  • N
    No analyses conducted for proportional samples taken during the month
  • DQ*
    Monthly value based on derived values; one or more values questionable; one or more values measured below the detection limit
  • ID*
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values; one or more values measured below the detection limit
  • DE*
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; monthly value based on derived values; one or more values estimated
UTKN_OUT_MO - numeric(5,2) (ratio)

ID: CF00204.UTKN_OUT_MO

Total monthly unfiltered total Kjeldahl nitrogen outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.010000

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

UTKNCODE_MO - char(2) (nominal)

ID: CF00204.UTKNCODE_MO

Monthly unfiltered total Kjeldahl nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • *
    Monthly value includes one or more values measured below the detection limit
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
TKN_OUT_MO - numeric(5,2) (ratio)

ID: CF00204.TKN_OUT_MO

Total monthly total Kjeldahl nitrogen (dissolved) outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.010000

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

TKNCODE_MO - char(2) (nominal)

ID: CF00204.TKNCODE_MO

Monthly total Kjeldahl nitrogen (dissolved) value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • *
    Monthly value includes one or more values measured below the detection limit
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
NH3N_OUT_MO - numeric(5,3) (ratio)

ID: CF00204.NH3N_OUT_MO

Total monthly ammonia-nitrogen (NH3-N) outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.005000

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

NH3NCODE_MO - char(2) (nominal)

ID: CF00204.NH3NCODE_MO

Monthly ammonia-nitrogen (NH3-N) value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (8)
  • A
    Accepted monthly value
  • *
    Monthly value includes one or more values measured below the detection limit
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q*
    Monthly value includes questionable sample values; one or more values measured below the detection limit
  • I*
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; one or more values measured below the detection limit
  • E*
    Monthly value includes estimated values; one or more values measured below the detection limit
NO3N_OUT_MO - numeric(5,3) (ratio)

ID: CF00204.NO3N_OUT_MO

Total monthly nitrate-nitrogen (NO3-N) outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.005000

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

NO3NCODE_MO - char(2) (nominal)

ID: CF00204.NO3NCODE_MO

Monthly nitrate-nitrogen (NO3-N) value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • A
    Accepted monthly value
  • *
    Monthly value includes one or more values measured below the detection limit
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • Q*
    Monthly value includes questionable sample values; one or more values measured below the detection limit
  • I*
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; one or more values measured below the detection limit
  • E*
    Monthly value includes estimated values; one or more values measured below the detection limit
NA_OUT_MO - numeric(5,2) (ratio)

ID: CF00204.NA_OUT_MO

Total monthly sodium outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.020000

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

NACODE_MO - char(2) (nominal)

ID: CF00204.NACODE_MO

Monthly sodium value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • *
    Monthly value includes one or more values measured below the detection limit
K_OUT_MO - numeric(5,2) (ratio)

ID: CF00204.K_OUT_MO

Total monthly potassium outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.020000

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

KCODE_MO - char(2) (nominal)

ID: CF00204.KCODE_MO

Monthly potassium value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • *
    Monthly value includes one or more values measured below the detection limit
CA_OUT_MO - numeric(5,2) (ratio)

ID: CF00204.CA_OUT_MO

Total monthly calcium outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.060000

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

CACODE_MO - char(1) (nominal)

ID: CF00204.CACODE_MO

Monthly calcium value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • IE
    Monthly value incomplete - only 6-25 days are proportionally sampled in the month; one or more values estimated
MG_OUT_MO - numeric(5,2) (ratio)

ID: CF00204.MG_OUT_MO

Total monthly magnesium outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.020000

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

MGCODE_MO - char(2) (nominal)

ID: CF00204.MGCODE_MO

Monthly magnesium value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
SO4S_OUT_MO - numeric(6,2) (ratio)

ID: CF00204.SO4S_OUT_MO

Total monthly sulfate-sulfur (SO4-S) outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.020000

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

SO4SCODE_MO - char(2) (nominal)

ID: CF00204.SO4SCODE_MO

Monthly sulfate-sulfur (SO4-S) value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • A
    Accepted monthly value
  • E
    Monthly value includes estimated values
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
CL_OUT_MO - numeric(6,2) (ratio)

ID: CF00204.CL_OUT_MO

Total monthly chloride outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.020000

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

CLCODE_MO - char(2) (nominal)

ID: CF00204.CLCODE_MO

Monthly chloride value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (4)
  • A
    Accepted monthly value
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • E
    Monthly value includes estimated values
DOC_OUT_MO - numeric(5,2) (ratio)

ID: CF00204.DOC_OUT_MO

Total monthly dissolved organic carbon outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.020000

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

DOCCODE_MO - char(2) (nominal)

ID: CF00204.DOCCODE_MO

Monthly dissolved organic carbon value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • A
    Accepted monthly value
  • I
    Monthly value incomplete - at least 5 days available, but 25 or fewer days available for month summary
  • N
    No analyses conducted for proportional samples taken during the month
  • Q
    Monthly value includes questionable sample values
  • E
    Monthly value includes estimated values
CF00205 - Stream water nutrient outflow (kg/ha) for each proportional sampling interval

Object name: CF00205_v5.csv

Records: 6921

Attributes: 53

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

File size: 1423529 byte

Checksum (MD5): 7c0765463f70f1320b5bb0a023937e3b

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

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

ID: CF00205.STCODE

Study code

Type system: Microsoft SQL Server 2019

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

ID: CF00205.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SITECODE - char(6) (nominal)

ID: CF00205.SITECODE

Gaging station site code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • GSWS01
    Andrews Watershed 1 Gaging Station
  • GSWS02
    Andrews Watershed 2 Gaging Station
  • GSWS06
    Andrews Watershed 6 Gaging Station
  • GSWS07
    Andrews Watershed 7 Gaging Station
  • GSWS08
    Andrews Watershed 8 Gaging Station
  • GSWS09
    Andrews Watershed 9 Gaging Station
  • GSWS10
    Andrews Watershed 10 Gaging Station
  • GSMACK
    Andrews Mack Creek Gaging Station
  • GSLOOK
    Andrews Lookout Creek Gaging Station
WATERYEAR - numeric(4,0) (interval)

ID: CF00205.WATERYEAR

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

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

DATE_TIME - datetime (dateTime)

ID: CF00205.DATE_TIME

Collection date and time (PST) of the stream water sample - sample collected proportionally to streamflow 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 2019

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

LABNO - char(4) (nominal)

ID: CF00205.LABNO

Lab number code for sample

Type system: Microsoft SQL Server 2019

TYPE - char(2) (nominal)

ID: CF00205.TYPE

Sample type indicator

Type system: Microsoft SQL Server 2019

Code definitions (13)
  • QB
    Quality control samples taken below turbulence box
  • QS
    Quality control sample taken through sampler
  • QL
    Quality control sample taken through sampler and left in gage house until next collection
  • QA
    Quality control sample taken above flume
  • C
    Sample combined with preceeding saved sample(s) for analysis
  • G
    Grab sample taken in lieu of proportional sample
  • S
    Sample saved to combine with following collection (type 'C') due to insufficient water. Nutrient concentrations of the following stream water sample are used to determine fluxes for this period.
  • N
    No sample is collected for this period
  • F
    Complete, full sample. Sampler operational throughout sampling period.
  • YE
    Year end marker allows summary by water year - this is not a sample. Flux values are calculated from streamflow ending Sep 30 and use analyte concentrations from the following sample. 'Y' markers are inserted every Sep30
  • A
    Augmented sample - grab sample added to insufficient proportional sample (rarely used after 1987)
  • P
    Partial sample - proportional sampler did not operate successfully over entire period
  • B
    Biased sample - consecutive samples are proportionally separated and combined based on streamflow - code use begins WY 2008 to approx. two 3-week sampling intervals (where one sample is for 4 wks and the next for 2 wks)
Q_AREA_CM - numeric(6,2) (ratio)

ID: CF00205.Q_AREA_CM

Streamflow in cm for the time interval represented by the proportional sample

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 0.025000

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

QCODE - char(1) (nominal)

ID: CF00205.QCODE

Streamflow value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • A
    Accepted value for streamflow
  • N
    No streamflow available for period
  • E
    Estimated streamflow value
  • P
    Fire effects may have impacted the data
  • Q
    Streamflow value for the period is questionable
ALK_OUTPUT - numeric(6,2) (ratio)

ID: CF00205.ALK_OUTPUT

Alkalinity outflow as CaCO3 (calcium carbonate)

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.050000

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

ALKCODE - char(1) (nominal)

ID: CF00205.ALKCODE

Alkalinity value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00205.SSED_OUTPUT

Suspended sediment outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.050000

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

SSEDCODE - char(1) (nominal)

ID: CF00205.SSEDCODE

Suspended sediment value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00205.SI_OUTPUT

Silica outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.050000

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

SICODE - char(1) (nominal)

ID: CF00205.SICODE

Silica value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00205.UTP_OUTPUT

Unfiltered total phosphorus outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.005000

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

UTPCODE - char(1) (nominal)

ID: CF00205.UTPCODE

Unfiltered total phosphorus value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00205.TDP_OUTPUT

Total dissolved phosphorus outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.005000

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

TDPCODE - char(1) (nominal)

ID: CF00205.TDPCODE

Total dissolved phosphorus value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00205.PARTP_OUTPUT

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

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.005000

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

PARTPCODE - char(2) (nominal)

ID: CF00205.PARTPCODE

Particulate P value qualifier code

Type system: Microsoft SQL Server 2019

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_OUTPUT - numeric(5,3) (ratio)

ID: CF00205.PO4P_OUTPUT

Ortho phosphorus (PO4-P) outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.005000

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

PO4PCODE - char(1) (nominal)

ID: CF00205.PO4PCODE

Ortho phosphorus value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00205.UTN_OUTPUT

Total nitrogen outflow (unfiltered sample)

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.010000

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

UTNCODE - char(2) (nominal)

ID: CF00205.UTNCODE

Unfiltered total nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (10)
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • A
    Accepted value
  • E
    Estimated value
  • 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
  • C
    Value confirmed, contamination suspected (code use begins May 2011)
TDN_OUTPUT - numeric(5,2) (interval)

ID: CF00205.TDN_OUTPUT

Total dissolved nitrogen outflow (filtered sample)

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.010000

Numeric domain: type=whole, min=0.0000 (exclusive=false), max=1.5500 (exclusive=false)

TDNCODE - char(2) (nominal)

ID: CF00205.TDNCODE

Total dissolved nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (10)
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • A
    Accepted value
  • E
    Estimated value
  • 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
  • C
    Value confirmed, contamination suspected (code use begins May 2007)
DON_OUTPUT - numeric(5,2) (ratio)

ID: CF00205.DON_OUTPUT

Dissolved organic N outflow - 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 2019

Unit: kilograms per hectare

Precision: 0.010000

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

DONCODE - char(2) (nominal)

ID: CF00205.DONCODE

Dissolved organic nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • 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
  • DC
    Derived value confirmed, contamination suspected (code use begins May 2007)
PARTN_OUTPUT - numeric(5,2) (ratio)

ID: CF00205.PARTN_OUTPUT

Particulate N outflow - 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 2019

Unit: kilograms per hectare

Precision: 0.010000

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

PARTNCODE - char(2) (nominal)

ID: CF00205.PARTNCODE

Particulate N value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • 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
  • DC
    Derived value confirmed, contamination suspected (code use begins May 2007)
UTKN_OUTPUT - numeric(5,2) (ratio)

ID: CF00205.UTKN_OUTPUT

Unfiltered total Kjeldahl nitrogen outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.010000

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

UTKNCODE - char(1) (nominal)

ID: CF00205.UTKNCODE

Unfiltered total Kjeldahl nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00205.TKN_OUTPUT

Total Kjeldahl nitrogen (dissolved) outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.010000

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

TKNCODE - char(1) (nominal)

ID: CF00205.TKNCODE

Total Kjeldahl nitrogen value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00205.NH3N_OUTPUT

Ammonia-nitrogen (NH3-N) outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.005000

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

NH3NCODE - char(1) (nominal)

ID: CF00205.NH3NCODE

NH3-N value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00205.NO3N_OUTPUT

Nitrate-nitrogen (NO3-N) outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.005000

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

NO3NCODE - char(1) (nominal)

ID: CF00205.NO3NCODE

NO3-N value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00205.NA_OUTPUT

Sodium outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.020000

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

NACODE - char(1) (nominal)

ID: CF00205.NACODE

Na value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00205.K_OUTPUT

Potassium outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.020000

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

KCODE - char(1) (nominal)

ID: CF00205.KCODE

K value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00205.CA_OUTPUT

Calcium outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.060000

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

CACODE - char(1) (nominal)

ID: CF00205.CACODE

Ca value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00205.MG_OUTPUT

Magnesium outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.020000

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

MGCODE - char(1) (nominal)

ID: CF00205.MGCODE

Mg value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00205.SO4S_OUTPUT

SO4-S (sulfate-sulfur) outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.020000

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

SO4SCODE - char(1) (nominal)

ID: CF00205.SO4SCODE

SO4-S value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00205.CL_OUTPUT

Chloride outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.020000

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

CLCODE - char(1) (nominal)

ID: CF00205.CLCODE

Cl value qualifier code

Type system: Microsoft SQL Server 2019

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

ID: CF00205.DOC_OUTPUT

Dissolved organic carbon outflow

Type system: Microsoft SQL Server 2019

Unit: kilograms per hectare

Precision: 0.020000

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

DOCCODE - char(1) (nominal)

ID: CF00205.DOCCODE

DOC value qualifier code

Type system: Microsoft SQL Server 2019

Code definitions (5)
  • *
    Value is below detection limit for analysis (used beginning in 1991)
  • A
    Accepted value
  • E
    Estimated value
  • N
    No analytical measurement
  • Q
    Value is questionable (used beginning in 1991)
CF00206 - Stream water sample log sheet: field and laboratory comments

Object name: CF00206_v9.csv

Records: 6748

Attributes: 14

Temporal coverage: 1968-10-09 to 2025-01-08

File size: 720517 byte

Checksum (MD5): cda338046b75e758d720768e18ae9435

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

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

ID: CF00206.STCODE

Study code

Type system: Microsoft SQL Server 2019

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

ID: CF00206.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SITECODE - char(6) (nominal)

ID: CF00206.SITECODE

Gaging station site code

Type system: Microsoft SQL Server 2019

Code definitions (9)
  • GSWS01
    Andrews Watershed 1 Gaging Station
  • GSWS02
    Andrews Watershed 2 Gaging Station
  • GSWS06
    Andrews Watershed 6 Gaging Station
  • GSWS07
    Andrews Watershed 7 Gaging Station
  • GSWS08
    Andrews Watershed 8 Gaging Station
  • GSWS09
    Andrews Watershed 9 Gaging Station
  • GSWS10
    Andrews Watershed 10 Gaging Station
  • GSMACK
    Andrews Mack Creek Gaging Station
  • GSLOOK
    Andrews Lookout Creek Gaging Station
WATERYEAR - numeric(4,0) (interval)

ID: CF00206.WATERYEAR

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

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

DATE_TIME - datetime (dateTime)

ID: CF00206.DATE_TIME

Collection date and time (PST) of the stream water sample - sample collected proportionally to streamflow 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 2019

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

LABNO - char(4) (nominal)

ID: CF00206.LABNO

Lab number code for sample

Type system: Microsoft SQL Server 2019

TYPE - char(2) (nominal)

ID: CF00206.TYPE

Sample type indicator

Type system: Microsoft SQL Server 2019

Code definitions (13)
  • QB
    Quality control samples taken below turbulence box
  • QS
    Quality control sample taken through sampler
  • QL
    Quality control sample taken through sampler and left in gage house until next collection
  • QA
    Quality control sample taken above flume
  • C
    Sample combined with preceeding saved sample(s) for analysis
  • G
    Grab sample taken in lieu of proportional sample
  • S
    Sample saved to combine with following collection (type 'C') due to insufficient water. Nutrient concentrations of the following stream water sample are used to determine fluxes for this period.
  • N
    No sample is collected for this period
  • F
    Complete, full sample. Sampler operational throughout sampling period.
  • YE
    Year end marker allows summary by water year - this is not a sample. Flux values are calculated from streamflow ending Sep 30 and use analyte concentrations from the following sample. 'Y' markers are inserted every Sep30
  • A
    Augmented sample - grab sample added to insufficient proportional sample (rarely used after 1987)
  • P
    Partial sample - proportional sampler did not operate successfully over entire period
  • B
    Biased sample - consecutive samples are proportionally separated and combined based on streamflow - code use begins WY 2008 to approx. two 3-week sampling intervals (where one sample is for 4 wks and the next for 2 wks)
QCCODE - char(2) (nominal)

ID: CF00206.QCCODE

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

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • NA
    Water sample is not a quality control sample
  • QA
    Quality control water sample taken above the flume
  • QB
    Quality control water sample taken below the turbulence box
  • QL
    Quality control water sample taken through the sampler and left in the gage house until the next collection
  • QS
    Quality control water sample taken through the sampler
  • QZ
    Additional or miscellaneous quality control water sample
QA_SAMPLE - char(6) (nominal)

ID: CF00206.QA_SAMPLE

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

Type system: Microsoft SQL Server 2019

SAMPLER_TYPE - char(2) (nominal)

ID: CF00206.SAMPLER_TYPE

Type of water sampler or method used to collect water

Type system: Microsoft SQL Server 2019

Code definitions (6)
  • GR
    Grab sample taken manually from the flume
  • RI
    Instantaneous sample collected through the battery-powered proportional water sampler
  • RM
    Proportional water sample taken through the battery-powered proportional water sampler with reed switch assembly and mechanical timer
  • RS
    Proportional water sample taken through the battery-powered proportional water sampler with reed switch assembly and solid state time and circuit board
  • SG
    Proportional water sample taken through Sigma sampler with timing controlled by a Campbell Scientific data logger
  • SI
    Instantaneous water sample taken through Sigma sampler
LOW_VOLUME - char(1) (nominal)

ID: CF00206.LOW_VOLUME

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

Type system: Microsoft SQL Server 2019

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: CF00206.FIELD_COMMENTS

Field comments related to the collection of the water sample

Type system: Microsoft SQL Server 2019

LAB_COMMENTS - char(254) (nominal)

ID: CF00206.LAB_COMMENTS

Laboratory comments related to the handling and analyses of the sample

Type system: Microsoft SQL Server 2019

SEQ_INDEX - numeric(5,0) (ratio)

ID: CF00206.SEQ_INDEX

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

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

Units
kilograms kg mass kilogram kilogram 1 kilograms; SI unit of mass
liters per second l/sec volumetricRate literPerSecond literPerSecond 1 liters per second
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
milligrams per liter mg/l massDensity milligramPerLiter kilogramPerMeterCubed 0.001 milligrams per liter
centimeters cm length centimeter meter 0.01 centimeters; .01 meters
kilograms per hectare kg/ha arealMassDensity kilogramPerHectare kilogramPerMeterSquared 0.0001 kilograms per hectare
number number dimensionless number dimensionless 1 dimensionless number, i.e., ratio, count
Related Datasets
Related Publications
  • Sollins, P.; Grier, C. C.; McCorison, F. M.; Cromack, K. Jr.; Fogel, R.; Fredriksen, R. L. 1980. The internal element cycles of an old-growth Douglas-fir ecosystem in western Oregon. Ecological Monographs. 50(3): 261-285.
  • Fredriksen, R. L. 1969. A battery powered proportional stream water sampler. Water Resources Research. 5(6): 1410-1413.
  • 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.
  • Triska, Frank J.; Sedell, James R.; Cromack, Kermit Jr. 1984. Nitrogen budget for a small coniferous forest stream. Ecological Monographs. 54(1): 119-140.
  • 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.
  • Argerich, A.; Johnson, S.L.; Sebestyen, S.D.; Rhoades, C.C.; Greathouse, E.; Knoepp, J.D.; Adams, M.B.; Likens, G.E.; Campbell, J.L.; McDowell, W.H.; Scatena, F.N.; Ice, G.G. 2013. Trends in stream nitrogen concentrations for forested reference catchments across the USA. Environmental Research Letters. 8: 8pp.
  • Corson-Rikert, Hayley A. 2014. Carbon Dynamics in the Hyporheic Zone of a Headwater Mountain Stream in the Cascade Mountains, Oregon. Corvallis, OR: Oregon State University. 132 p. M.S. thesis.
  • Argerich, Alba; Haggerty, Roy; Johnson, Sherri L.; Wondzell, Steve M.; Dosch, Nicholas; Corson-Rikert, Hayley; Ashkenas, Linda; Robert, Pennington; Thomas, Christoph K. 2016. Comprehensive multiyear carbon budget of a temperate headwater stream. Journal of Geophysical Research: Biogeosciences. 121: 1-10. doi: 10.1002/2015JG003050
  • Lee, Baek Soo P. 2015. Hydrologic and Land Cover Effects on Sources and Fate of In-Stream Fluorescent Dissolved Organic Matter. Corvallis: Oregon State University. 163 p. Ph.D.
  • Lee, Baek Soo; Lajtha, Kate. 2016. Hydrologic and forest management controls on dissolved organic matter characteristics in headwater streams of old-growth forests in the Oregon Cascades. Forest Ecology and Management. 380(15): 11-22. doi: 10.1016/j.foreco.2016.08.029
Related Files
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: Creative Commons Attribution 4.0 International Public License

Identifier: CC-BY-4.0

URL: https://creativecommons.org/licenses/by/4.0/

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 streamflow values. Streamflow is combined with nutrient concentration data to produce output in kg per hectares. Analysis codes Q (Questionable lab value) and * (value below detection limit) were initiated in April, 1991.
  • Version3 (2002-02-12)
    Metadata restructured and moved into SQLServer metadata database LTERMETA. Data moved into SQLServer database FSDBDATA.
  • Version4 (2005-03-15)
    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). Additionally, WS 8,9,10, and Mack were refitted with updated streamflow values starting with the beginning of record. Changes were necessary due to rating curve changes in these watersheds. WS 2 data and early data for WS 6&7 was not refitted with new streamflow as the rating curves are the same. Attributes were renamed in this update process to be unique by attribute definition for the CF002 dataset .
  • Version7 (2007-10-15)
    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. Methods are updated and lab methods added.
  • Version8 (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.
  • Version9 (2011-01-03)
    New derived entities are created for mean monthly concentration data and monthly outflow in kg/ha. Monthly data is created for all existing sites except Lookout Creek (GSLOOK). Many new attributes are added, many with enumerated domains. There are now 5 entities, and all have been through the QC process. In addition to the new entities, Entity 1 was corrected to properly type QA samples that were inadvertently listed as Grab samples (GSWS08 August 2000 and GSWS02 August 2005). Streamflow in Entity 1 is changed to cm units from inches (q_area_in is now q_area_cm). Incorrect flagging of below detection values for NH3-N data is corrected - every NH3-N value at or below 0.01 is now tagged as below detection limit beginning 4/9/1991 to Present. Derived entities have also been corrected for changes in NH3-N tagging and QA sample designations.
  • Version10 (2011-01-03)
    The 5 entities are renumbered from the original configuration. Entity 1 is still the raw (cleaned) proportional sample data. Entity 5 is the former Entity 2 data and is the calculated flux for each proportional sample. At this time, Entities 1 and 5 have been taken off-line by PI request. Entity 2 is mean monthly concentration, Entity 3 is still mean annual concentration, Entity 4 is mean monthly outflow in kg per ha.
  • Version13 (2012-08-30)
    Updated attribute description for attributes with a fine resolution datetime measurement scale to include 'PST' (pacific standard time).
  • Version15 (2014-08-26)
    The stream concentration data (Entity 1) is updated from March 2010 until early July 2014. Streamflow (attribute q_area_cm) is added for WaterYear 2010 through WY 2013 for all watersheds except Lookout where streamflow is added or replaces provisional data from WY 2007 to mid WY 2014. Alkalinity values are converted from units of bicarbonate carbon (HCO3-C) to Calcium carbonate (CaCO3), using a multiplicative factor of 4.1664.
  • Version16 (2014-09-17)
    Stream chemistry monthly and annual analyte concentration data, and monthly and sampling period fluxes, are calculated for wateryears 2010-2013 for WS 1,2,6,7,8,9,10 and Mack. Lookout Creek monthly and annual analyte concentration data, and monthly and sampling period fluxes, are calculated and added from beginning of record (May 2005 to June 2014). Alkalinity values are converted from units of bicarbonate carbon (HCO3-C) to calcium carbonate (CaCO3) for all entities. Minor corrections to the 26 August 2014 version of Entity 1 change extreme values for two contaminated samples to null values.
  • Version17 (2015-08-14)
    Entity 6 is created from stream water 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.
  • Version18 (2015-08-19)
    Entity 6: the field_comments attribute is modified to add field notes from HJ_Notes_Corvallis field log that pertain to stream chemistry.
  • Version19 (2015-12-04)
    Entity 6 is updated from June 2015 through October 2015.
  • Version20 (2016-08-25)
    Update to fix custom unit rendering. Cannot be non-critical because also removed illegal characters from record in entity 6, so CSV file needs to be rebuilt.
  • Version21 (2016-09-14)
    Stream chemistry values are updated from Jun 2014 until early May 2016 for all watersheds with monthly and annual summary data updated through WY 2015 (Sep 2015). Streamflow totals are added for WY 2014 and WY 2015 for all watersheds except Lookout Creek, where streamflow data extends through April 2016. Analyte codes for all analyte measurements are updated for all years with blank codes being replaced by an 'A' code (Accepted). .
  • Version22 (2017-03-08)
    Entity 5, which includes nutrient outflow based on the actual 3 week collections (as compared to being summarized monthly) will once again be placed online. This data had been restricted but user needs indicate it is worth posting.
  • Version23 (2019-09-19)
    Stream chemistry values are updated from May 2016 until May 2019 for all watersheds with summary data updated from WY 2016 through WY 2018. Stream discharge totals are added for WY 2016, 2017 and WY 2018 for all watersheds. Stream discharge totals are revised for GSWS01 (WY 2003-WY 2015), GSWS02 (WY 1999-WY2015), and GSWS08 (WY 1988-WY2015) to account for application of revised stream rating curves for these watersheds. Mean discharge in liters per second is added along with the interval length in number of days to Entity 1, and mean monthly discharge in liters per second added to Entity 2.
  • Version24 (2026-02-05)
    Stream chemistry values are updated from wateryear 2019 to 2024 for all watersheds with summary data also updated.