# # # FILE_NAME: Cambrian_Ordovician_archival_file_summary # DATASET_DESCRIPTION: This data set was used in a report to characterize the Cambrian-Ordovician Aquifer # System as part of the US Geological Survey National Water Quality Assessment # Program (NAWQA). # DATA_SET FORMAT: Tab-delimited ascii file # DATA_SET URL: http://water.usgs.gov/nawqa-only/aq/data_archive/SIR2011_5229_Data.zip # #-------------------------------------------------------------------------------------------------------- # REPORT TITLE: Water-quality assessment of the Cambrian-Ordovician aquifer system in the northern # Midwest, United States # REPORT SERIES/NUMBER USGS Scientific Investigation Report (SIR 2011-5229) # REPORT URL: http://pubs.usgs.gov/sir/2011/5229/ # #------------------------------------------------------------------------------------------------------- # NAWQA STUDY: Principal Aquifer: Cambrian-Ordovician # #------------------------------------------------------------------------------------------------------- # # METADATA DATE: August 02, 2011 # METADATA CONTACT: John Wilson # USGS-WRD, Indiana Water Science Center # 5957 Lakeside Boulevard # Indianapolis, IN 46278 # voice: (317) 600-2752 # fax: (317) 290-3313 # email: jtwilson@usgs.gov # # SECONDARY CONTACT: Kelly Warner (PA Lead Scientist) # USGS-WRD, Illinois Water Science Center # 1201 West University Avenue, Suite 100 # Urbana, IL 61801 # voice: (217) 328-9727 # fax: (217) 344-0082 # email: klwarner@usgs.gov # # ------------------------------------------------------------------------------------------------------ # DATA_SET NAMES: # # The following files document and archive the data sets used for producing this report. Brief descriptions of # each of these report archival files follow. The archival files are sorted by major topic in directories/folders. # In general, a filename that includes '_nawqa_rasa' is for a data set that contains sample results from the NAWQA # and RASA Programs. A filename that includes '_nawqa' is for a data set that only contains sample results # from the NAWQA Program. A filename that includes '_all" is for a data set that contains sample results from # multiple sources (like NWIS and state agencies). # # # Directory covers: # camord.shp # regions.shp # # # Directory geochem: # camord_hydrochemical_facies.txt # camord_nawqa_redox.txt # camord_PHREEQC_input.txt # camord_PHREEQC_output.txt # # # Directory majors_nutrients: # camord_majors_nawqa_mdl.txt # camord_majors_nutrients_all.txt # camord_nawqa_rasa_majors.txt # camord_nutrients_nawqa_mdl.txt # camord_umis_nitrate_nawqa_resample.txt # camord_wmic_nitrate_nawqa_resample.txt # majors.code2.txt # # # Directory pesticides_vocs_mixtures: # camord_cycleII_mixtures.txt # camord_cycleII_mixtures_data.txt # camord_cycleII_pesticides.txt # camord_cycleII_vocs.txt # camord_pesticides_resample.txt # camord_umis_pesticides_resample.txt # camord_wmic_pesticides_resample.txt # # # Directory QC_NAWQA: # camord_majors_nutrients_nawqa_blanks.txt # camord_majors_nutrients_nawqa_replicates.txt # camord_pesticides_nawqa_blanks.txt # camord_pesticides_nawqa_replicates.txt # camord_radium_nawqa_blanks.txt # camord_radium_nawqa_replicates.txt # camord_radon_nawqa_replicates.txt # camord_trace_nawqa_blanks.txt # camord_trace_nawqa_replicates.txt # camord_vocs_nawqa_blanks.txt # camord_vocs_nawqa_replicates.txt # # # Directory spearman_rank_corr: # camord_nawqa_spearman.txt # cor.all.code.txt # # # Directory trace_elements_radchem: # camord_hydrochemical_facies.txt # camord_nawqa_rasa_rad226.txt # camord_radium_minn_all.txt # camord_radium_nawqa.txt # camord_radon_nawqa.txt # camord_radon_nawqa_lithology.txt # camord_radon_nawqa_resample.txt # camord_trace_nawqa_mdl.txt # camord_trace_rad_all.txt # trace.summary.code.txt # # # Directory water_use: # camord_water_use_data.txt # # # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord.shp # # This geospatial data layer is a shape file (polygon) that represents the extent of the Cambrian- # Ordovician aquifer system in the states of Wisconsin, Michigan, Minnesota, Iowa, Illinois, Indiana, # and Missouri. It does not include Precambrian Sandstones (Hinckley or Jacobsville Sandstones). # There are several areas of Precambrian Crystalline rocks within the boundary of the aquifer system. # # Purpose: These data delineate the areal extent of the Cambrian-Ordovician aquifer system as defined # in the 'groundwater Atlas of the United States' (U.S. Geological Survey HA 730). The boundary of the # aquifer extent was refined using more detailed State bedrock geology maps (digital versions). # The refinement consisted of providing more detailed line work along the northern boundary between # Cambrian and Precambrian rocks, and moving the southern boundary to coincide with the Missouri River. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: regions.shp # # This geospatial data layer is a shape file (polygon) that represents the extent of the Cambrian- # Ordovician aquifer system in the states of Wisconsin, Michigan, Minnesota, Iowa, Illinois, Indiana, # and Missouri. This data set also represents the different areas of regional confinement--confined # (aquifer system is buried by Maquoketa Shale and younger bedrock) and unconfined (aquifer system # is exposed at the bedrock surface). This data set also represents areas of Precambrian Sandstones # and Precambrian Crystalline rocks. Precambrian Sandstones (Jacobsville Ss, Hinckley Ss) are # hydraulically connected to and often indistinguishable from Cambrian Sandstones in Michigan and Minnesota. # # Purpose: These data delineate the areal extent of the Cambrian-Ordovician aquifer system as defined # in the 'groundwater Atlas of the United States' (U.S. Geological Survey HA 730). The boundary of the # aquifer extent was refined using more detailed State bedrock geology maps (digital versions). # The refinement consisted of providing more detailed linework along the northern boundary between Cambrian # and Precambrian rocks, and moving the southern boundary to coincide with the Missouri River. The boundary # where the aquifer system is exposed at the bedrock surface or buried by the Upper Ordovician Maquoketa Shale # or younger bedrock was refined by editing line work along the boundary of the Maquoketa Shale to more closely # match what is on the State geologic maps. In Minnesota, the detail for this boundary was obtained from # a digital version of the 1974 King and Beikman map (Scruben and others, 1997). # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_hydrochemical_facies.txt # # This data set contains groundwater data from multiple sources (not just NAWQA) for major # ions, radionuclides, some physical properties, TDS, and hardness for wells completed in the # Cambrian-Ordovician Aquifer System. # The major-ion data were converted to milliequivalents per liter (meq/L) in order to determine # hydrochemical facies for cations and anions using the methods of or similar to Back (1966). # # Meq/L were calculated using the conversion factors of Hem (1989, table 9). # # Cation facies and anion facies were mapped in the subject report. # Cation facies were also used as a grouping variable for determining statistically significant # differences in radium-226, radium-228, and radon-222, using those wells that included a # value for radium and/or radon-222. # # Samples needed to have a value for alkalinity (or bicarbonate) in order to be used for # determining the sum of anions. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_nawqa_redox.txt # # This data set contains input data and results for determining redox category for NAWQA samples # with the Excel spreadsheet of Jurgens and others (2009) # Jurgens, B.C., McMahon, P.B., Chapelle, F.H., and Eberts, S.M., 2009, An Excel workbook for # identifying redox processes in groundwater: U.S. Geological Survey Open-File Report 2009-1009, 8 p. # # Source of Redox Categories & Process: # McMahon, P.B., and Chapelle, F.H., 2008, Redox processes and water quality of selected principal # aquifer systems: groundwater, v. 46, p. 259–271. # # Data were retrieved from the NAWQA Internal Data Warehouse on or about February 19, 2008. # The data will be used in a report to characterize the Cambrian-Ordovician Aquifer System # as part of the U.S. Geological Survey, National Water-Quality Assessment Program. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_PHREEQC_input.txt # # This data set contains NAWQA groundwater data that make up the input file for the geochemical model # PHREEQCI (pH Redox Equilibrium Calculations in C)--C refers to the programming language, # "I" refers to the graphical user interface version. # Data were retrieved from the NAWQA Internal Data Warehouse on or about February 19, 2008. # The data will be used in a report to characterize the Cambrian-Ordovician Aquifer System # as part of the U.S. Geological Survey, National Water-Quality Assessment Program. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_PHREEQC_output.txt # # This data set contains output from the geochemical model PHREEQCI that included aqueous # speciation and saturation indices for minerals. # PHREEQCI stands for (pH Redox Equilibrium Calculations in C)--C refers to the programming language, # "I" refers to the graphical user interface version. # # Input data are listed at the beginning of the output file, and were retrieved from the # NAWQA Internal Data Warehouse on or about February 19, 2008. # Refer to camord_PHREEQCI_input.txt for more explanation of input data. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_majors_nawqa_mdl.txt # # This data set contains NAWQA groundwater data for major ions and physical properties # that were used to compute summary statistics for the subject report. These data # were also used to test for statistically significant differences between regional confinement # and tritium-based age, and for plotting as boxplots and a trilinear (piper) diagram. # # Non-detections were recensored from Laboratory Reporting Levels to Long-Term Method Detection # Levels that applied to the sample date. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_majors_nutrients_all.txt # # This data set contains groundwater data from multiple sources (not just NAWQA) for major # ions, nutrients, and physical properties for wells completed in the Cambrian-Ordovician # Aquifer System. These data were used to map selected water-quality constituents throughout # the aquifer system. These data were also used to test for statistically significant # differences in concentrations of selected constituents between regionally confined wells # and regionally unconfined wells. Regionally confined areas are defined in this report as # being covered by the Upper Ordovician Maquoketa Shale or younger bedrock. # # Sample dates range as far back as 1960 to as recent as 2008. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_nawqa_rasa_majors.txt # # This data set contains groundwater data for major ions and TDS at six wells in Iowa. # The wells were sampled by the Regional Aquifer-System Analysis (RASA) Program # in 1980 or 1981. The wells were later sampled by the NAWQA Program in 2005 or 2007. # The data are used in an analysis of the temporal variability of major ions. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_nutrients_nawqa_mdl.txt # # This data set contains NAWQA groundwater data for nutrients and dissolved organic carbon that were # used to compute summary statistics for the subject report. These data # were also used to test for statistically significant differences between regional confinement # and tritium-based age, and for plotting as boxplots. # # Non-detections were recensored from Laboratory Reporting Levels to Long-Term Method Detection # Levels that applied to the sample date. # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_umis_nitrate_nawqa_resample.txt # # This data set contains NAWQA groundwater data for nitrate (nitrate + nitrite) samples # collected from 23 NAWQA wells from the UMIS sampling network in 1996 and again in 2007. These data # were used as part of the analysis of near decadal-scale changes in nitrate concentrations. # # All nitrate non-detections are recensored to < 0.05 for purposes of comparison. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_wmic_nitrate_nawqa_resample.txt # # This data set contains NAWQA groundwater data for nitrate (nitrate + nitrite) samples # collected from 26 NAWQA wells from the WMIC sampling network in 1995 and again in 2002. These data # were used as part of the analysis of near decadal-scale changes in nitrate concentrations. # # All nitrate non-detections are recensored to < 0.05 for purposes of comparison. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: majors.code2.txt # # This S-PLUS script computes left-censored summary statistics for NAWQA Major Ion data # It also computes summary statistics and quantiles for Physical Properties and Major Ions # that do not have censored data # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_cycleII_mixtures.txt # # This data set contains the list of unique mixtures of nitrate (> 1 mg/L), # pesticides, and VOCs detected in NAWQA samples (anthropogenic contaminants). The unique mixtures # were tabulated by Jon Scott (Oklahoma WSC) on 01/08/2010. # The data will be used in a report to characterize # the Cambrian-Ordovician Aquifer System as part of the # U.S. Geological Survey, National Water-Quality Assessment Program. # # #-------------------------------------------------------------------------------------------------------- # # REPORT ARCHIVAL DATA SET: camord_cycleII_mixtures_data.txt # This data set contains groundwater data for tabulating unique mixtures of nitrate (> 1 mg/L), # pesticides, and VOCs detected in NAWQA samples (anthropogenic contaminants). Data were retrieved # from the NAWQA Internal Data Warehouse on or about February 19, 2008. # The data will be used in a report to characterize the Cambrian-Ordovician Aquifer System as part of the # U.S. Geological Survey, National Water-Quality Assessment Program. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_cycleII_pesticides.txt # # This data set contains NAWQA groundwater pesticides data for wells completed in the Cambrian- # Ordovician Aquifer System. These data were used to determine detection frequencies of selected # pesticides in samples collected during the second decade (Cycle II) of NAWQA. Concentrations of # pesticides were also compared to human-health benchmarks. Sample dates range from 2002 to 2007. # # Pesticides analyzed in Cycle II samples are from USGS Lab Schedule 2033, which includes 83 pesticides # and degradates. A subset of 35 pesticides were also analyzed in Cycle I samples, and were included # in USGS Circular 1291 (Gilliom and others, 2006). # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_cycleII_vocs.txt # # This data set contains NAWQA groundwater VOCs data for wells completed in the Cambrian-Ordovician # Aquifer System. These data were used to determine detection frequencies of selected # VOCs in samples collected during the second decade (Cycle II) of NAWQA. Concentrations of # VOCs are also compared to human-health benchmarks. Sample dates range from 2002 to 2007. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_pesticides_resample.txt # # This data set contains groundwater pesticide data retrieved from the NAWQA Internal Data Warehouse on or # about March 05, 2008. # # These data are used for the analysis of near decadal-scale changes in pesticides by looking at changes # in the number of pesticides detected and the total concentration of pesticides detected in two samples # collected at each well of two networks. One network of wells is located in the Minneapolis-St. Paul # (Twin Cities) Metropolitan Area of Minnesota and western Wisconsin in the Upper Mississippi River Basin # (UMIS) NAWQA study unit. One network of wells is located in eastern Wisconsin and the Upper Peninsula of # Michigan in the Western Lake Michigan Drainages (WMIC) NAWQA study unit. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_umis_pesticides_resample.txt # # This data set contains NAWQA groundwater data on the number of pesticides detected and the total # concentration of detected pesticides for two samples collected at each of 23 wells in a well # network (UMIS) in the Minneapolis-St. Paul Metropolitan Area. This information is based on pesticides # data retrieved from the NAWQA Internal Data Warehouse on or about March 05, 2008. # # These data are used for the analysis of near decadal-scale changes in pesticides by looking at changes # in the number of pesticides detected and the total concentration of pesticides detected in two samples # collected at each well of two networks. One network of wells is located in the Minneapolis-St. Paul # (Twin Cities) Metropolitan Area of Minnesota and western Wisconsin in the Upper Mississippi River Basin # (UMIS) NAWQA study unit. One network of wells is located in eastern Wisconsin and the Upper Peninsula of # Michigan in the Western Lake Michigan Drainages (WMIC) NAWQA study unit. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_wmic_pesticides_resample.txt # # This data set contains NAWQA groundwater data on the number of pesticides detected and the total # concentration of detected pesticides for two samples collected at each of 26 wells in a well # network (WMIC) in eastern Wisconsin and the Michigan Upper Peninsula. This information is # based on pesticides data retrieved from the NAWQA Internal Data Warehouse on or about # March 05, 2008. # # These data are used for the analysis of near decadal-scale changes in pesticides by looking at changes # in the number of pesticides detected and the total concentration of pesticides detected in two samples # collected at each well of two networks. One network of wells is located in the Minneapolis-St. Paul # (Twin Cities) Metropolitan Area of Minnesota and western Wisconsin in the Upper Mississippi River Basin # (UMIS) NAWQA study unit. One network of wells is located in eastern Wisconsin and the Upper Peninsula of # Michigan in the Western Lake Michigan Drainages (WMIC) NAWQA study unit. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_majors_nutrients_nawqa_blanks.txt # # This data set contains NAWQA groundwater data for major ions, ammonia, nitrate, and dissolved # organic carbon that were used to evaluate detections in Field Blanks. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_majors_nutrients_nawqa_replicates.txt # # This data set contains NAWQA groundwater data for major ions, ammonia, nitrate, and dissolved # organic carbon that were used to evaluate the variability of concentrations in replicate pairs. # # Replicate pairs are comprised of an environmental sample and a replicate sample. A replicate # pair was included in the analysis if both the environmental sample and the replicate sample # had a quantifiable detection (non-detections were not used). # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_pesticides_nawqa_blanks.txt # # This data set contains NAWQA groundwater data for pesticides that were used to evaluate # detections of pesticides in Field Blanks. # # Data were retrieved from the NAWQA Internal Data Warehouse on or about April 14, 2010. # Blank data for the WMIC study unit were not in Data Warehouse and were provided by # the Wisconsin Water Science Center. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_pesticides_nawqa_replicates.txt # # This data set contains NAWQA groundwater data for pesticides that were used to evaluate the # variability of concentrations in replicate pairs. # # Replicate pairs are comprised of an environmental sample and a replicate sample. A replicate # pair was included in the analysis if both the environmental sample and the replicate sample # had a quantifiable detection (non-detections were not used). # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_radium_nawqa_blanks.txt # # This data set contains NAWQA groundwater data for radium-226 and radium-228 that were # used to evaluate Field Blanks. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_radium_nawqa_replicates.txt # # This data set contains NAWQA groundwater data for radium-226 and radium-228 that were # used to evaluate the variability of concentrations in replicate pairs. # # Replicate pairs are comprised of an environmental sample and a replicate sample. A replicate # pair was included in the analysis if both the environmental sample and the replicate sample # had a quantifiable detection (non-detections were not used). # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_radon_nawqa_replicates.txt # # This data set contains NAWQA groundwater data for radon-222 that were used to evaluate # the variability of concentrations in replicate pairs. # # Replicate pairs are comprised of an environmental sample and a replicate sample. A replicate # pair was included in the analysis if both the environmental sample and the replicate sample # had a quantifiable detection (non-detections were not used). # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_trace_nawqa_blanks.txt # # This data set contains NAWQA groundwater data for trace elements that were used to evaluate # detections of trace elements in Field Blanks. # # Data were retrieved from the NAWQA Internal Data Warehouse on or about April 14, 2010. # Blank data for the WMIC study unit were not in Data Warehouse and were provided by # the Wisconsin Water Science Center. # # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_trace_nawqa_replicates.txt # # This data set contains NAWQA groundwater data for trace elements that were used to evaluate # the variability of concentrations in replicate pairs. # # Replicate pairs are comprised of an environmental sample and a replicate sample. A replicate # pair was included in the analysis if both the environmental sample and the replicate sample # had a quantifiable detection (non-detections were not used). # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_vocs_nawqa_blanks.txt # # This data set contains NAWQA groundwater data for VOCs that were used to evaluate # detections of VOCs in Field Blanks. # # Data were retrieved from the NAWQA Internal Data Warehouse on or about March 13, 2008. # Blank data for the WMIC study unit were not in Data Warehouse and were provided by # the Wisconsin Water Science Center. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_vocs_nawqa_replicates.txt # # Abstract: This data set contains NAWQA groundwater data for VOCs that were used to evaluate the # variability of concentrations in replicate pairs. # # Replicate pairs are comprised of an environmental sample and a replicate sample. A replicate # pair was included in the analysis if both the environmental sample and the replicate sample # had a quantifiable detection (non-detections were not used). # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_nawqa_spearman.txt # # This data set contains NAWQA groundwater data for major ions, physical properties, trace elements, # radionuclides, and well characteristics that were used to compute Spearman Rank Correlation # Coefficients (rho) and p-values. The results are presented as a matrix table of correlation # coefficients (rho) in the report. # # Non-detections were recensored from Laboratory Reporting Levels to Long-Term Method Detection # Levels that applied to the sample date. # # Low tritium values and non-detections were recensored to 0.3. # Low dissolved oxygen values and non-detections were recensored to 0.18. # # Some non-detections for Mn, Ni, U, As, Pb, and Mo from 1995 and 1996 were removed because of the # high detection level of 1 microgram per liter. The detection level of 1 ug/L is much higher # than many detections from more recent samples. # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: cor.all.code.txt # # This S-PLUS script computes correlations (Spearman's Rho) between analytes # # Major ion, nutrient, and trace data non-detections have been recensored from Reporting Levels # to Detection Level. This way the samples are retained but are very small relative to the # true detections. # Radchem non-detections are equal to the sample specific reporting level. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_nawqa_rasa_rad226.txt # # This data set contains groundwater data for radium-226 at six wells in Iowa. # The wells were sampled by the Regional Aquifer-System Analysis (RASA) Program # in 1980 or 1981. The wells were later sampled by the NAWQA Program in 2005 or 2007. # The data are used in an analysis of the temporal variability of radium-226. # # Radium-226 results for the RASA samples are for pcode 09510--alpha emitting radium-226, # filtered water, planchett method. # # Radium-226 results for the NAWQA samples are for pcode 09511--radium-226, filtered water, # radon method. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_radium_minn_all.txt # # This data set contains groundwater data from multiple sources (not just NAWQA) for # radium-226, radium-228, and combined radium for wells completed in the Cambrian-Ordovician # Aquifer System in Minnesota. # These data were used to map radium concentrations in Minnesota. # These data were also used to test for statistically significant differences in concentrations # of radium-226, radium-228, and combined radium between samples from the Mount Simon Sandstone # and samples from aquifers above the Mount Simon Sandstone. # # NAWQA data were retrieved from the NAWQA Internal Data Warehouse on or about February 13, 2008. # # RASA data were obtained from the data table in the RASA report: # Siegel, D.I., 1989, Geochemistry of the Cambrian-Ordovician aquifer system in the Northern # Midwest, United States: U.S. Geological Survey Professional Paper 1405-D. # # NWIS data were retrieved from the NWIS database on various dates during 2008 and 2009. # Data were obtained from the Minnesota Department of Health (MNDOH) during 2008. # USGS samples for radium are filtered, radium samples from the MNDOH are presumed to be unfiltered. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_radium_nawqa.txt # # This data set contains NAWQA groundwater data for radium-226, radium-228, selected major ions and # trace elements, and physical properties. Data were used to compute summary statistics for radium # in the subject report. These data were also used to test for statistically significant differences # in radium concentrations between regional confinement and tritium-based age, # and for plotting as boxplots. # # These data were used to show the geochemical relation of radium with selected constituents # such as sulfate, TDS, iron, sodium, fluoride, barium, and strontium. These data were also # used to show the geochemical relation of radium with the saturation index of selected minerals. # # Radium-226 and radium-228 include left-censored data (non-detections). For these constituents, # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_radon_nawqa.txt # # This data set contains NAWQA groundwater data for radon-222, physical properties, TDS, and hardness. # Data were used to compute summary statistics for radon-222 in the subject report. These data # were also used to test for statistically significant differences in radon-222 concentrations # between regional confinement and tritium-based age, and for plotting as boxplots. # # Radon-222 includes left-censored data (non-detections); therefore, parametric summary statistics # are based on ROS (Regression on Ordered Statistics). # # Non-detections of radon-222 were recensored to Laboratory Reporting Level, which is the sample-specific # minimum detectable concentration (SSMDC). # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_radon_nawqa_lithology.txt # # This data set contains NAWQA groundwater data for radon-222 samples collected at 50 wells # in the Twin Cities area of Minnesota and western Wisconsin. Sample dates range from # 1996 to 2007. These wells are located in the Upper Mississippi River Basin (UMIS) # NAWQA study unit. # # This data set also contains data for radon-222 samples collected at 31 wells in # eastern Wisconsin and the Upper Peninsula of Michigan. These wells are located in the # Western Lake Michigan Drainages (WMIC) NAWQA study unit. # # Data were used to test for statistically significant difference in radon-222 concentrations # in samples from Sandstone and Carbonate aquifers. These tests were done separately for # the UMIS and WMIC study areas to eliminate any variable due to geographic location. # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_radon_nawqa_resample.txt # # This data set contains NAWQA groundwater data for radon-222 samples collected twice at 29 wells. # The first sample date was 1995 or 1996 and the second sample date was 2002. # Data were used to evaluate the temporal variability of radon-222 concentrations in the subject report. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_trace_nawqa_mdl.txt # # This data set contains NAWQA groundwater data for trace elements that were used to # compute summary statistics for the subject report. These data were also used to test # for statistically significant differences between regional confinement and tritium-based # age, and for plotting as boxplots. # # Some constituents include left-censored data (non-detections). For these constituents, # parametric summary statistics are based on ROS (Regression on Ordered Statistics). # # Non-detections were recensored from Laboratory Reporting Levels to Long-Term Method Detection # Levels that applied to the sample date # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_trace_rad_all.txt # # This data set contains groundwater data from multiple sources (not just NAWQA) for # trace elements, a few major ions, radionuclides, and physical properties for wells completed # in the Cambrian-Ordovician Aquifer System. # These data were used to map selected water-quality constituents throughout the aquifer system. # These data were also used to test for statistically significant differences in concentrations # of selected constituents between regionally confined wells and regionally unconfined wells. # Regionally confined areas are defined in this report as being covered by the # Upper Ordovician Maquoketa Shale or younger bedrock. # # Sample dates range as far back as 1960 to as recent as 2008. # # USGS samples for trace elements and radium are filtered, as are samples from the ISWS. # Trace element and radium samples from all other sources are presumed to be unfiltered. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: trace.summary.code.txt # # This S-PLUS script computes left-censored summary statistics for NAWQA Trace Element data # It also computes summary statistics and quantiles for Barium and Strontium which do not have # censored data. # # #-------------------------------------------------------------------------------------------------------- # REPORT ARCHIVAL DATA SET: camord_water_use_data.txt # # This data set contains water-use data for those states where the Cambrian-Ordovician aquifer # system is used. Data are for the three major categories of use (public supply, self-supplied # industrial, irrigation) for which data were compiled by Maupin and Barber (2005). States # with water-use data include: Illinois, Iowa, Michigan, Minnesota, Missouri, and Wisconsin. # # Water-use data were used in the introduction of the subject report to show the significance of the # aquifer system in those states. # # Data were from the year 2000, and were obtained from Maupin and Barber (2005). # The data will be used in a report to characterize the Cambrian-Ordovician Aquifer System # as part of the U.S. Geological Survey, National Water-Quality Assessment Program. # # #-------------------------------------------------------------------------------------------------------- END