This readme.txt file was generated on <2024/05/03> by John McDaris Recommended citation for the data: McDaris, J.R., J.M. Feinberg, N. Wiest. 2024. Groundwater chemistry data, real-time temperature, elevation, and specific conductance for MN Wells 668848 and 668849 (May 2021 - May 2024). Retrieved from the Data Repository for the University of Minnesota, https://hdl.handle.net/11299/263124. ------------------- GENERAL INFORMATION ------------------- 1. Title of Dataset: Groundwater Chemistry Data, Real-Time temperature, elevation, and specific conductance for MN Wells 668848 and 668849 (May 2021 - May 2024) 2. Author Information Principal Investigator Contact Information Name: John R. McDaris Institution: University of Minnesota Email: mcda0030@umn.edu ORCID: https://orcid.org/0000-0002-9868-9496 Associate or Co-investigator Contact Information Name: Joshua M. Feinberg Institution: University of Minnesota Email: feinberg@umn.edu ORCID: https://orcid.org/0000-0002-5845-9848 Associate or Co-investigator Contact Information Name: Nicholas Wiest Institution: Univeristy of Minnesota Email: wiest033@umn.edu 3. Date published or finalized for release: 04/22/2024 4. Date of data collection: 2021/05/13-2024/04/05 5. Geographic location of data collection: Minneapolis, MN 6. Information about funding sources that supported the collection of the data: Some chemistry data analysis was paid for by funding from the Momental Foundation and the rest was covered by unrestricted funds awarded to Feinberg. Purchase of the Real-Time temperature, elevation, and specific conductance sensors was enabled by the Gill Gabanski Scholarship awarded to McDaris by the Minnesota Groundwater Association (2021). 7. Overview of the data (abstract): Full water chemistry analysis data from two wells (668848, 668849) adjacent to Williamson Hall on the East Bank Campus of the University of Minnesota, Twin Cities. Water samples were taken ~quarterly in conjunction with a PhD project led by McDaris. Feinberg and Wiest assisted in sample collection and interpretation. The wells were also instrumented with in situ sensors measuring groundwater temperature, elevation, and specific conductance. Measurements from these sensors were taken multiple times per hour for three years. -------------------------- SHARING/ACCESS INFORMATION -------------------------- 1. Licenses/restrictions placed on the data: Creative Commons Attribution-NonCommercial-ShareAlike 3.0 United States (http://creativecommons.org/licenses/by-nc-sa/3.0/us/) 2. Links to publications that cite or use the data: none 3. Terms of Use: Data Repository for the U of Minnesota (DRUM) By using these files, users agree to the Terms of Use. https://conservancy.umn.edu/pages/policies/#drum-terms-of-use --------------------- DATA & FILE OVERVIEW --------------------- 1. File List A. Filename: RAL_QWTA_April2024.xlsx Short description: Collated water chemistry data for QWTA well (668848) located next to Williamson Hall on the UMN campus. B. Filename: RAL_OPVL_April2024.xlsx Short description: Collated water chemistry data for OPVL well (668849) located next to Williamson Hall on the UMN campus. C. Filename: McDaris_Williamson_realtime_main.csv Short description: Cleaned data set from real-time sensors from wells next to Williamson Hall, May 2021-May 2024 2. Relationship between files: The two wells respresented by these data sets are right beside each other and water samples were taken from each at the same times for analysis at the Research Analytical Laboratory at the UMN. These files document the data gathered from each. -------------------------- METHODOLOGICAL INFORMATION -------------------------- 1. Description of methods used for collection/generation of data: Water samples were gathered from the two wells using standard hydrologic practice - purge the wells with a bailer, filter samples through sub-micron filters, and submit to the Research Analytical Lab for analysis. METER Hydros 21 sensors were installed inside the well casings below the water level of the wells. Measurements were taken every 5 minutes for the first year or deployment and then every 30 minutes for the following two years. 2. Methods for processing the data: Data were collated from multiple RAL reports. Temperature, depth, and pressure variables are raw. Specific conductnace values are converted from raw with a calibration relation isolated for each sensor prior to installation. MASL data are calculated from depth and the elevation of the well head. 3. Instrument- or software-specific information needed to interpret the data: none 4. Standards and calibration information, if appropriate: See the Research Analytical Laboratory website for more information. 5. Environmental/experimental conditions: Water sample temperatures were controlled between collection and submission to the Research Analytical Laboratory. 6. Describe any quality-assurance procedures performed on the data: Spurous data points associated with removal of the sensors for water sampling have been removed from the set. 7. People involved with sample collection, processing, analysis and/or submission: John McDaris, Joshua Feinberg, Nicholas Wiest (collection, processing, submission) Research Analytical Laboratory, UMN (analysis) ----------------------------------------- DATA-SPECIFIC INFORMATION FOR: RAL_QWTA_April2024.xlsx ----------------------------------------- 1. Number of variables: 38 2. Number of cases/rows: 10 *Second row for column L through AL represents Limit of Detection 3. Missing data codes: Code/symbol: Blank No data available. 4. Variable List A. Name: Date Description: Date sample was taken B. Name: Bicarbonate Alkalinity Description: Concentration of CaCO3 in the sample. mg CaCO3 /L C. Name: TDS (measured) Description: Total Dissolved Solids measured directly by RAL mg/L D. Name: TDS (estimated) Description: Total Dissolved Solids estimated by summing the concentrations of measured chemical species mg/L E. Name: Flouride Description: Measured concentration of Flouride in the sample. Detection limit of 0.1 mg/L. mg/L F. Name: Chloride Description: Measured concentration of Chloride in the sample. Detection limit of 0.1 mg/L. mg/L G. Name: Nitrite-N Description: Measured concentration of Nitrite in the sample. Detection limit of 0.1 mg/L. mg/L H. Name: Bromide Description: Measured concentration of Bromide in the sample. Detection limit of 0.1 mg/L. mg/L I. Name: Sulfate-S Description: Measured concentration of Sulfate or Sulphur in the sample. Detection limit of 0.1 mg/L. mg/L J. Name: Nitrate-N Description: Measured concentration of Nitrate in the sample. Detection limit of 0.1 mg/L. mg/L K. Name: Phosphate-P Description: Measured concentration of Phosphate in the sample. Detection limit of 0.1 mg/L. mg/L L. Name: Al Description: Measured concentration of Aluminum in the sample. mg/L M. Name: As Description: Measured concentration of Arsenic in the sample. mg/L N. Name: B Description: Measured concentration of Boron in the sample. mg/L O. Name: Ba Description: Measured concentration of Barium in the sample. mg/L P. Name: Be Description: Measured concentration of Berilium in the sample. mg/L Q. Name: Ca Description: Measured concentration of Calcium in the sample. mg/L R. Name: Cd Description: Measured concentration of Cadmium in the sample. mg/L S. Name: Co Description: Measured concentration of Cobalt in the sample. mg/L T. Name: Cr Description: Measured concentration of Chromium in the sample. mg/L U. Name: Cu Description: Measured concentration of Copper in the sample. mg/L V. Name: Fe Description: Measured concentration of Iron in the sample. mg/L W. Name: K Description: Measured concentration of Potasium in the sample. mg/L X. Name: Li Description: Measured concentration of Lithium in the sample. mg/L Y. Name: Mg Description: Measured concentration of Magnesium in the sample. mg/L Z. Name: Mn Description: Measured concentration of Manganese in the sample. mg/L AA. Name: Mo Description: Measured concentration of Molybdenum in the sample. mg/L AB. Name: Na Description: Measured concentration of Sodium in the sample. mg/L AC. Name: Ni Description: Measured concentration of Nickel in the sample. mg/L AD. Name: P Description: Measured concentration of Phosphorous in the sample. mg/L AE. Name: Pb Description: Measured concentration of Lead in the sample. mg/L AF. Name: Rb Description: Measured concentration of Rubidium in the sample. mg/L AG. Name: S Description: Measured concentration of Sulphur in the sample. mg/L AH. Name: Si Description: Measured concentration of Silicon in the sample. mg/L AI. Name: Sr Description: Measured concentration of Strontium in the sample. mg/L AJ. Name: Ti Description: Measured concentration of Titanium in the sample. mg/L AK. Name: V Description: Measured concentration of Vanadium in the sample. mg/L AL. Name: Zi Description: Measured concentration of Cobalt in the sample. mg/L ----------------------------------------- DATA-SPECIFIC INFORMATION FOR: RAL_OPVL_April2024.xlsx ----------------------------------------- 1. Number of variables: 38 2. Number of cases/rows: 11 *Second row for column L through AL represents Limit of Detection 3. Missing data codes: Code/symbol: Blank No data available. 4. Variable List A. Name: Date Description: Date sample was taken B. Name: Bicarbonate Alkalinity Description: Concentration of CaCO3 in the sample. mg CaCO3 /L C. Name: TDS (measured) Description: Total Dissolved Solids measured directly by RAL mg/L D. Name: TDS (estimated) Description: Total Dissolved Solids estimated by summing the concentrations of measured chemical species mg/L E. Name: Flouride Description: Measured concentration of Flouride in the sample. Detection limit of 0.1 mg/L. mg/L F. Name: Chloride Description: Measured concentration of Chloride in the sample. Detection limit of 0.1 mg/L. mg/L G. Name: Nitrite-N Description: Measured concentration of Nitrite in the sample. Detection limit of 0.1 mg/L. mg/L H. Name: Bromide Description: Measured concentration of Bromide in the sample. Detection limit of 0.1 mg/L. mg/L I. Name: Sulfate-S Description: Measured concentration of Sulfate or Sulphur in the sample. Detection limit of 0.1 mg/L. mg/L J. Name: Nitrate-N Description: Measured concentration of Nitrate in the sample. Detection limit of 0.1 mg/L. mg/L K. Name: Phosphate-P Description: Measured concentration of Phosphate in the sample. Detection limit of 0.1 mg/L. mg/L L. Name: Al Description: Measured concentration of Aluminum in the sample. mg/L M. Name: As Description: Measured concentration of Arsenic in the sample. mg/L N. Name: B Description: Measured concentration of Boron in the sample. mg/L O. Name: Ba Description: Measured concentration of Barium in the sample. mg/L P. Name: Be Description: Measured concentration of Berilium in the sample. mg/L Q. Name: Ca Description: Measured concentration of Calcium in the sample. mg/L R. Name: Cd Description: Measured concentration of Cadmium in the sample. mg/L S. Name: Co Description: Measured concentration of Cobalt in the sample. mg/L T. Name: Cr Description: Measured concentration of Chromium in the sample. mg/L U. Name: Cu Description: Measured concentration of Copper in the sample. mg/L V. Name: Fe Description: Measured concentration of Iron in the sample. mg/L W. Name: K Description: Measured concentration of Potasium in the sample. mg/L X. Name: Li Description: Measured concentration of Lithium in the sample. mg/L Y. Name: Mg Description: Measured concentration of Magnesium in the sample. mg/L Z. Name: Mn Description: Measured concentration of Manganese in the sample. mg/L AA. Name: Mo Description: Measured concentration of Molybdenum in the sample. mg/L AB. Name: Na Description: Measured concentration of Sodium in the sample. mg/L AC. Name: Ni Description: Measured concentration of Nickel in the sample. mg/L AD. Name: P Description: Measured concentration of Phosphorous in the sample. mg/L AE. Name: Pb Description: Measured concentration of Lead in the sample. mg/L AF. Name: Rb Description: Measured concentration of Rubidium in the sample. mg/L AG. Name: S Description: Measured concentration of Sulphur in the sample. mg/L AH. Name: Si Description: Measured concentration of Silicon in the sample. mg/L AI. Name: Sr Description: Measured concentration of Strontium in the sample. mg/L AJ. Name: Ti Description: Measured concentration of Titanium in the sample. mg/L AK. Name: V Description: Measured concentration of Vanadium in the sample. mg/L AL. Name: Zi Description: Measured concentration of Cobalt in the sample. mg/L ----------------------------------------- DATA-SPECIFIC INFORMATION FOR: McDaris_Williamson_realtime_main.csv ----------------------------------------- 1. Number of variables: 10 2. Number of cases/rows: 118,297 3. Missing data codes: NA No data 4. Variable List A. Name: DateTimeUTC Description: Measurement date and time in universal time B. Name: QWTA.Cond.Cal Description: Calibrated specific conductance μS/cm C. Name: QWTA.Depth Description: Depth of sensor below water surface meters D. Name: QWTA.Temp Description: Groundwater temperature ºC E. Name: QWTA.MASL Description: Groundwater elevation meters above sea level F. Name: OPVL.Cond.Cal Description: Calibrated specific conductance μS/cm G. Name: OPVL.Depth Description: Depth of sensor below water surface meters H. Name: OPVL.Temp Description: Groundwater temperature ºC I. Name: OPVL.MASL Description: Groundwater elevation meters above sea level J. Name: Bar.Press Description: Barometric pressure at the well head m H2O