DOE Data Explorer title logo U.S. Department of Energy
Office of Scientific and Technical Information

Title: Total Dissolved Nitrogen and Ammonia Data for the East River Watershed, Colorado (2015-2022)

Abstract

This data package contains mean values for total dissolved nitrogen (TDN) and ammonia concentrations for water samples taken from the East River Watershed in Colorado. The East River is part of the Watershed Function Scientific Focus Area (WFSFA) located in the Upper Colorado River Basin, United States. TDN was analyzed using a Shimadzu Total Nitrogen Module (TNM-1) combined with the TOC-VCSH analyzer (Shimadzu Corporation, Japan). TNM-1 is a non-specific measurement of total nitrogen (TN). All nitrogen species in samples are combusted to nitrogen monoxide and nitrogen dioxide, then reacted with ozone to form an excited state of nitrogen dioxide. Upon returning to ground state, light energy is emitted. Then, TDN is measured using a chemiluminescence detector. Ammonia was determined using a Lachat's QuikChem 8500 Series 2 Flow Injection Analysis System (LACHAT Instruments, QuckChem 8500 series 2, Automated Ion Analyzer, Loveland, Colorado). When ammonia in water samples is heated (60 degrees C) with salicylate and hypochlorite in an alkaline phosphate buffer, an emerald green color is produced which is proportional to the ammonia concentration. The color is intensified by the addition of nitroprusside. Ethylenediaminetetraacetic acid (EDTA) is added to the buffer to prevent the interference of metal ions (Ca, Mg, andmore » Fe etc.). Ammonia-N is then determined by LACHAT flow injection and a colorimetric assay at an absorbance wavelength 660 nm. (Reference: LACHAT Instruments: QuickChem Method 90-107-06-3-A, Determination of Ammonia by Flow Injection Analysis (High Throughput, Salicylate Method/DCIC) (Multi Matrix method). Written by Lynn Egan (Application group), February 08, 2011.) All files are labeled by location and variable, and data reported are the mean values upon replicate measurements. All samples were analyzed under a rigorous quality assurance and quality control (QA/QC) process as detailed in the methods. This data package contains (1) a zip file (tdn_ammonia_data_2015-2022.zip) containing a total of 224 data files of ammonia and TDN data from across the Lawrence Berkeley National Laboratory (LBNL) Watershed Function Scientific Focus Area (SFA) which is reported in .csv files per location; (2) a file-level metadata (flmd.csv) file that lists each file contained in the dataset with associated metadata; and (3) a data dictionary (dd.csv) file that contains terms/column_headers used throughout the files along with a definition, units, and data type.Update 10/07/2020: Updated the data files to remove times from the timestamps, so that only dates remain. The data values have not changed.Update 4/11/2021: Added Determination of Method Detection Limits (MDLs) for DIC, NPOC and TDN Analyses and Determination of Method Detection Limit for Ammonia and the Interferences by LACHAT Flow Injection Analysis documents, which can be accessed as PDFs or with Microsoft Word.Update on 6/10/2022: versioned updates to this dataset was made along with these changes: (1) updated total dissolved nitrogen and ammonia data for all locations up to 2021-12-31, (2) removal of units from column headers in datafiles, (3) added row underneath headers to contain units of variables, (4) restructure of units to comply with CSV reporting format requirements, (5) added -9999 for empty numerical cells, and (6) the addition of the file-level metadata (flmd.csv) and data dictionary (dd.csv) were added to comply with the File-Level Metadata Reporting Format.Update on 2022-09-09: Updates were made to reporting format specific files (file-level metadata and data dictionary) to correct swapped file names, add additional details on metadata descriptions on both files, add a header_row column to enable parsing, and add version number and date to file names (v2_20220909_flmd.csv and v2_20220909_dd.csv).Update on 2022-12-20: Updates were made to both the data files and reporting format specific files. Units were listed incorrectly, but have been fixed to reflect correct units (ug/L). File level metadata (flmd) and data dictionary (dd) files were updated to reflect the updated versions of these files. Available data was added up until 2022-06-01.« less

Authors:
ORCiD logo ; ; ORCiD logo ; ORCiD logo ; ; ORCiD logo ; ; ORCiD logo ; ; ;
  1. Lawrence Berkeley National Laboratory
  2. Bugs Unlimited, LLC
  3. Subsurface Insights
Contributors:
Related Person: ORCiD logo ; ORCiD logo ;

  1. Lawrence Berkeley National Laboratory
  2. Subsurface Insights
Publication Date:
Other Number(s):
10.15485/1660456; paf_495_924
Research Org.:
Environmental System Science Data Infrastructure for a Virtual Ecosystem (ESS-DIVE) (United States); Watershed Function SFA
Sponsoring Org.:
U.S. DOE > Office of Science > Biological and Environmental Research (BER)
Subject:
54 ENVIRONMENTAL SCIENCES
Keywords:
geochemical; tnd; ammonia; water quality/water chemistry; ground water; surface water; CSV file formatting guidelines; File-level metadata; EARTH SCIENCE > TERRESTRIAL HYDROSPHERE > WATER QUALITY/WATER CHEMISTRY; EARTH SCIENCE > TERRESTRIAL HYDROSPHERE > GROUND WATER; EARTH SCIENCE > TERRESTRIAL HYDROSPHERE > SURFACE WATER; Dissolved Ammonia; Total Dissolved Nitrogen; EARTH SCIENCE > TERRESTRIAL HYDROSPHERE > SURFACE WATER > SURFACE WATER CHEMISTRY; EARTH SCIENCE > TERRESTRIAL HYDROSPHERE > GROUND WATER > GROUNDWATER CHEMISTRY
Geolocation:
39.034,-106.88|38.88,-106.88|38.88,-107.05|39.034,-107.05|39.034,-106.88
OSTI Identifier:
1660456
DOI:
https://doi.org/10.15485/1660456
Project Location:

DOE DataExplorer Dataset Location Google Map

Citation Formats

Dong, Wenming, Beutler, Curtis, Bouskill, Nick, Brown, Wendy, Newman, Alexander, O'Ryan, Dylan, Versteeg, Roelof, Williams, Kenneth, Varadharajan, Charuleka, Crystal-Ornelas, Robert, and Alper, Erek. Total Dissolved Nitrogen and Ammonia Data for the East River Watershed, Colorado (2015-2022). United States: N. p., 2023. Web. doi:10.15485/1660456.
Dong, Wenming, Beutler, Curtis, Bouskill, Nick, Brown, Wendy, Newman, Alexander, O'Ryan, Dylan, Versteeg, Roelof, Williams, Kenneth, Varadharajan, Charuleka, Crystal-Ornelas, Robert, & Alper, Erek. Total Dissolved Nitrogen and Ammonia Data for the East River Watershed, Colorado (2015-2022). United States. doi:https://doi.org/10.15485/1660456
Dong, Wenming, Beutler, Curtis, Bouskill, Nick, Brown, Wendy, Newman, Alexander, O'Ryan, Dylan, Versteeg, Roelof, Williams, Kenneth, Varadharajan, Charuleka, Crystal-Ornelas, Robert, and Alper, Erek. 2023. "Total Dissolved Nitrogen and Ammonia Data for the East River Watershed, Colorado (2015-2022)". United States. doi:https://doi.org/10.15485/1660456. https://www.osti.gov/servlets/purl/1660456. Pub date:Sun Jan 01 00:00:00 EST 2023
@article{osti_1660456,
title = {Total Dissolved Nitrogen and Ammonia Data for the East River Watershed, Colorado (2015-2022)},
author = {Dong, Wenming and Beutler, Curtis and Bouskill, Nick and Brown, Wendy and Newman, Alexander and O'Ryan, Dylan and Versteeg, Roelof and Williams, Kenneth and Varadharajan, Charuleka and Crystal-Ornelas, Robert and Alper, Erek},
abstractNote = {This data package contains mean values for total dissolved nitrogen (TDN) and ammonia concentrations for water samples taken from the East River Watershed in Colorado. The East River is part of the Watershed Function Scientific Focus Area (WFSFA) located in the Upper Colorado River Basin, United States. TDN was analyzed using a Shimadzu Total Nitrogen Module (TNM-1) combined with the TOC-VCSH analyzer (Shimadzu Corporation, Japan). TNM-1 is a non-specific measurement of total nitrogen (TN). All nitrogen species in samples are combusted to nitrogen monoxide and nitrogen dioxide, then reacted with ozone to form an excited state of nitrogen dioxide. Upon returning to ground state, light energy is emitted. Then, TDN is measured using a chemiluminescence detector. Ammonia was determined using a Lachat's QuikChem 8500 Series 2 Flow Injection Analysis System (LACHAT Instruments, QuckChem 8500 series 2, Automated Ion Analyzer, Loveland, Colorado). When ammonia in water samples is heated (60 degrees C) with salicylate and hypochlorite in an alkaline phosphate buffer, an emerald green color is produced which is proportional to the ammonia concentration. The color is intensified by the addition of nitroprusside. Ethylenediaminetetraacetic acid (EDTA) is added to the buffer to prevent the interference of metal ions (Ca, Mg, and Fe etc.). Ammonia-N is then determined by LACHAT flow injection and a colorimetric assay at an absorbance wavelength 660 nm. (Reference: LACHAT Instruments: QuickChem Method 90-107-06-3-A, Determination of Ammonia by Flow Injection Analysis (High Throughput, Salicylate Method/DCIC) (Multi Matrix method). Written by Lynn Egan (Application group), February 08, 2011.) All files are labeled by location and variable, and data reported are the mean values upon replicate measurements. All samples were analyzed under a rigorous quality assurance and quality control (QA/QC) process as detailed in the methods. This data package contains (1) a zip file (tdn_ammonia_data_2015-2022.zip) containing a total of 224 data files of ammonia and TDN data from across the Lawrence Berkeley National Laboratory (LBNL) Watershed Function Scientific Focus Area (SFA) which is reported in .csv files per location; (2) a file-level metadata (flmd.csv) file that lists each file contained in the dataset with associated metadata; and (3) a data dictionary (dd.csv) file that contains terms/column_headers used throughout the files along with a definition, units, and data type.Update 10/07/2020: Updated the data files to remove times from the timestamps, so that only dates remain. The data values have not changed.Update 4/11/2021: Added Determination of Method Detection Limits (MDLs) for DIC, NPOC and TDN Analyses and Determination of Method Detection Limit for Ammonia and the Interferences by LACHAT Flow Injection Analysis documents, which can be accessed as PDFs or with Microsoft Word.Update on 6/10/2022: versioned updates to this dataset was made along with these changes: (1) updated total dissolved nitrogen and ammonia data for all locations up to 2021-12-31, (2) removal of units from column headers in datafiles, (3) added row underneath headers to contain units of variables, (4) restructure of units to comply with CSV reporting format requirements, (5) added -9999 for empty numerical cells, and (6) the addition of the file-level metadata (flmd.csv) and data dictionary (dd.csv) were added to comply with the File-Level Metadata Reporting Format.Update on 2022-09-09: Updates were made to reporting format specific files (file-level metadata and data dictionary) to correct swapped file names, add additional details on metadata descriptions on both files, add a header_row column to enable parsing, and add version number and date to file names (v2_20220909_flmd.csv and v2_20220909_dd.csv).Update on 2022-12-20: Updates were made to both the data files and reporting format specific files. Units were listed incorrectly, but have been fixed to reflect correct units (ug/L). File level metadata (flmd) and data dictionary (dd) files were updated to reflect the updated versions of these files. Available data was added up until 2022-06-01.},
doi = {10.15485/1660456},
journal = {},
number = ,
volume = ,
place = {United States},
year = {2023},
month = {1}
}