Recommended citation for the data: McDaris, John R; Feinberg, Joshua M; Runkel, Anthony; Levine, Jonathan; Alexander Jr., E. Calvin; Kasahara, Sophie. (2021). Twin Cities Metropolitan Area Groundwater Chloride Data, 1965-2021. Retrieved from the Data Repository for the University of Minnesota, https://doi.org/10.13020/jxx7-1k60. ------------------- GENERAL INFORMATION ------------------- 1. Title of Dataset: Twin Cities Metropolitan Area Groundwater Chloride Data, 1965-2021 2. Author Information Principal Investigator Contact Information Name: John R. McDaris Institution: University of Minnesota Email: mcda0030@umn.edu ORCID: 0000-0002-9868-9496 Associate or Co-investigator Contact Information Name: Joshua M. Feinberg Institution: University of Minnesota Email: feinberg@umn.edu ORCID: Associate or Co-investigator Contact Information Name: Anthony Runkel Institution: University of Minnesota Email: runke001@umn.edu ORCID: Associate or Co-investigator Contact Information Name: Jonathan Levine Institution: Colgate University Email: jlevine@colgate.edu ORCID: Associate or Co-investigator Contact Information Name: E. Calvin Alexander Jr Institution: University of Minnesota Email: alexa001@umn.edu ORCID: 0000-0002-7864-7512 Associate or Co-investigator Contact Information Name: Sophie Kasahara Institution: University of Minnesota Email: kasah007@umn.edu ORCID: 3. Date of data collection: 19650701 to 20210824 4. Geographic location of data collection (where was data collected?): Minnesota 5. Information about funding sources that supported the collection of the data: The data were collected by state regulatory agencies as part of their purview under state statute. The funding was provided by state funded appropriated by the MN legislature over the span of 6 decades. -------------------------- SHARING/ACCESS INFORMATION -------------------------- 1. Licenses/restrictions placed on the data: CC0 1.0 Universal 2. Links to publications that cite or use the data: McDaris, J.R., Feinberg, J.M., Runkel, A.C., Levine, J., Kasahara, S., & Alexander Jr., E.C. (2022). Documentation and Prediction of Increasing Groundwater Chloride Concentration in the Twin Cities, Minnesota. Groundwater. https://doi.org/10.1111/gwat.13227 3. Links to other publicly accessible locations of the data: 4. Links/relationships to ancillary data sets: 5. Was data derived from another source? If yes, list source(s): --------------------- DATA & FILE OVERVIEW --------------------- 1. File List A. Filename: CL_database Short description: This dataset is compiled from 55 years of groundwater quality testing work done by the Minnesota Geologic Survey, Minnesota Pollution Control Agency, the Minnesota Department Natural Resources, and the Minnesota Department of Health. B. Filename: Readme Short description: documentation of data -------------------------- METHODOLOGICAL INFORMATION -------------------------- 1. Description of methods used for collection/generation of data: Data were gathered by multiple MN state agencies through their standard water sampling and analysis proceedures. 2. Methods for processing the data: Data sets were combined and standardized for units. 3. Instrument- or software-specific information needed to interpret the data: 4. Standards and calibration information, if appropriate: 5. Environmental/experimental conditions: 6. Describe any quality-assurance procedures performed on the data: 7. People involved with sample collection, processing, analysis and/or submission: ----------------------------------------- DATA-SPECIFIC INFORMATION FOR: CL_database ----------------------------------------- 1. Number of variables: 13 2. Number of cases/rows: 2946 3. Missing data codes: Longitude/Latitude: Location information for public water sources is not for publication due to security concerns and has been redacted from the data set. Conductance: Some water samples were collected and analyzed for chemistry without the measurement of specific conductance. First.Bedrock: or 0 Most wells in Quaternary aquifers were not drilled deep enough to encounter a first bedrock layer. These are blank or 0 depending on the source of the data. ClayThickness: 0 No measureable clay was encountered in the drilling of the well. 4. Variable List A. Name: relateid Description: Unique well identifier from the Minnesota Well Index B. Name: Date Description: Date of sample collection C. Name: Time Description: Time of sample collection (if available). Central Standard Time. D. Name: Longitude Description: Well location longtide. (degrees) E. Name: Latitude Description: Well location latitude. (degrees) F. Name: First.Bedrock Description: The first bedrock unit encountered in drilling the well. Abbreviations from the Minnesota Well Index Coding System. G. Name: Aquifer Description: Aquifer unit from which water was sampled at the well. Abbreviations from the Minnesota Well Index Coding System. H. Name: CHLORIDE Description: Chloride concentration of the water sample (mg/L) I. Name: CONDUCTANCE Description: Specific conductance of the water sample (μS/cm) J. Name: Source Description: Initials of the Agency or person who collected the water sample. MGS - Minnesota Geologic Survey; MPCA - Minnesota Pollution Control Agency; MDH - Minnesota Departmenr of Health; DNR - Minnesota Department of Natural Resources; SA - Scott Alexander, University of Minnesota; JM - John McDaris, University of Minnesota K. Name: DOY Description: Day of the calendar year when the sample was taken. L. Name: Year Description: Calendar year when the sample was taken. M. Name: ClayThickness Description: Cumulative thickness of clay in the quaternary deposits overlying the well location. (meters)