Data from: Long-Term Agroecosystem Research in the Central Mississippi River Basin: Goodwater Creek Experimental Watershed and Regional Herbicide Water Quality Data

Project Title:  View help for Project Title Data from: Long-Term Agroecosystem Research in the Central Mississippi River Basin: Goodwater Creek Experimental Watershed and Regional Herbicide Water Quality Data

Summary:  View help for Summary The GCEW herbicide data were collected from 1991-2010, and are documented at plot, field, and watershed scales.

Atrazine concentrations in Goodwater Creek Experimental Watershed (GCEW) were shown to be among the highest of any watershed in the United States based on comparisons using the national Watershed Regressions for Pesticides (WARP) model and by direct comparison with the 112 watersheds used in the development of WARP. This 20-yr-long effort was augmented with a spatially broad effort within the Central Mississippi River Basin encompassing 12 related claypan watersheds in the Salt River Basin, two cave streams on the fringe of the Central Claypan Areas in the Bonne Femme watershed, and 95 streams in northern Missouri and southern Iowa. The research effort on herbicide transport has highlighted the importance of restrictive soil layers with smectitic mineralogy to the risk of transport vulnerability. Near-surface soil features, such as claypans and argillic horizons, result in greater herbicide transport than soils with high saturated hydraulic conductivities and low smectitic clay content.

The data set contains concentration, load, and daily discharge data for Devils Icebox Cave and Hunters Cave from 1999 to 2002. The data are available in Microsoft Excel 2010 format. Sheet 1 (Cave Streams Metadata) contains supporting information regarding the length of record, site locations, parameters measured, parameter units, method detection limits, describes the meaning of zero and blank cells, and briefly describes unit area load computations. Sheet 2 (Devils Icebox Concentration Data) contains concentration data from all samples collected from 1999 to 2002 at the Devils Icebox site for 12 analytes and two computed nutrient parameters. Sheet 3 (Devils Icebox SS Conc Data) contains 15-minute suspended sediment (SS) concentrations estimated from turbidity sensor data for the Devils Icebox site. Sheet 4 (Devils Icebox Load & Discharge Data) contains daily data for discharge, load, and unit area loads for the Devils Icebox site. Sheet 5 (Hunters Cave Concentration Data) contains concentration data from all samples collected from 1999 to 2002 at the Hunters Cave site for 12 analytes and two computed nutrient parameters. Sheet 6 (Hunters Cave SS Conc Data) contains 15-minute SS concentrations estimated from turbidity sensor data for the Hunters Cave site. Sheet 7 (Hunters Cave Load & Discharge Data) contains daily data for discharge, load, and unit area loads for the Hunters Cave site.

[Note: To support automated data access and processing, each worksheet has been extracted as a separate, machine-readable CSV file; see Data Dictionary for descriptions of variables and their concentration units.]


Resources in this dataset:

Resource Title: README - Metadata. File Name: LTAR_GCEW_herbicidewater_qual.xlsxResource Description: Defines Water Quality and Sediment Load/Discharge parameters, abbreviations, time-frames, and units as rendered in the Excel file. For additional information including site information, method detection limits, and methods citations, see Metadata tab. For Definitions used in machine-readable CSV files, see Data Dictionary.

Resource Title: README - Metadata.

File Name: LTAR_GCEW_herbicidewater_qual.xlsx

Resource Description: Defines Water Quality and Sediment Load/Discharge parameters, abbreviations, time-frames, and units as rendered in the Excel file. For additional information including site information, method detection limits, and methods citations, see Metadata tab. For Definitions used in machine-readable CSV files, see Data Dictionary.

Resource Title: Excel data spreadsheet. File Name: c3.jeq2013.12.0516.ds1_.xlsxResource Description: Multi-page data spreadsheet containing data as well as metadata from this study. A direct download of the data spreadsheet can be found here: https://dl.sciencesocieties.org/publications/datasets/jeq/C3.JEQ2013.12.0516.ds1/download

Resource Title: Excel data spreadsheet.

File Name: c3.jeq2013.12.0516.ds1_.xlsx

Resource Description: Multi-page data spreadsheet containing data as well as metadata from this study. A direct download of the data spreadsheet can be found here: https://dl.sciencesocieties.org/publications/datasets/jeq/C3.JEQ2013.12.0516.ds1/download

Resource Title: Devils Icebox Concentration Data. File Name: DevilsIceboxConcData.csvResource Description: Concentrations of herbicides, metabolites, and nutrients (extracted from the Excel tab into machine-readable CSV data).

Resource Title: Devils Icebox Concentration Data.

File Name: DevilsIceboxConcData.csv

Resource Description: Concentrations of herbicides, metabolites, and nutrients (extracted from the Excel tab into machine-readable CSV data).

Resource Title: Devils Icebox Load and Discharge Data. File Name: DevilsIceboxLoad&Discharge.csvResource Description: Discharge and Unit Area Loads for herbicides, metabolites, and suspended sediments (extracted from Excel tab as machine-readable CSV data)

Resource Title: Devils Icebox Load and Discharge Data.

File Name: DevilsIceboxLoad&Discharge.csv

Resource Description: Discharge and Unit Area Loads for herbicides, metabolites, and suspended sediments (extracted from Excel tab as machine-readable CSV data)

Resource Title: Devils Icebox Suspended Sediment Concentration Data. File Name: DevilsIceboxSSConcData.csvResource Description: Suspended Sediment Concentration Data (extracted from Excel tab as machine-readable CSV data)

Resource Title: Devils Icebox Suspended Sediment Concentration Data.

File Name: DevilsIceboxSSConcData.csv

Resource Description: Suspended Sediment Concentration Data (extracted from Excel tab as machine-readable CSV data)

Resource Title: Hunters Cave Load and Discharge Data. File Name: HuntersCaveLoad&Discharge.csvResource Description: Discharge and Unit Area Loads for herbicides, metabolites, and suspended sediments (extracted from Excel tab as machine-readable CSV data)

Resource Title: Hunters Cave Load and Discharge Data.

File Name: HuntersCaveLoad&Discharge.csv

Resource Description: Discharge and Unit Area Loads for herbicides, metabolites, and suspended sediments (extracted from Excel tab as machine-readable CSV data)

Resource Title: Hunters Cave Suspended Sediment Concentration Data. File Name: HuntersCaveSSConc.csvResource Description: Suspended Sediment Concentration Data (extracted from Excel tab as machine-readable CSV data)

Resource Title: Hunters Cave Suspended Sediment Concentration Data.

File Name: HuntersCaveSSConc.csv

Resource Description: Suspended Sediment Concentration Data (extracted from Excel tab as machine-readable CSV data)

Resource Title: Data Dictionary for machine-readable CSV files. File Name: LTAR_GCEW_herbicidewater_qual.csvResource Description: Defines Water Quality and Sediment Load/Discharge parameters, abbreviations, time-frames, and units as implemented in the extracted machine-readable CSV files.

Resource Title: Data Dictionary for machine-readable CSV files.

File Name: LTAR_GCEW_herbicidewater_qual.csv

Resource Description: Defines Water Quality and Sediment Load/Discharge parameters, abbreviations, time-frames, and units as implemented in the extracted machine-readable CSV files.

Resource Title: Hunters Cave Concentration Data. File Name: HuntersCaveConcData.csvResource Description: Concentrations of herbicides, metabolites, and nutrients (extracted from the Excel tab into machine-readable CSV data)

Resource Title: Hunters Cave Concentration Data.

File Name: HuntersCaveConcData.csv

Resource Description: Concentrations of herbicides, metabolites, and nutrients (extracted from the Excel tab into machine-readable CSV data)

Original Distribution URL:  View help for Original Distribution URL https://agdatacommons.nal.usda.gov/articles/dataset/Data_from_Long-Term_Agroecosystem_Research_in_the_Central_Mississippi_River_Basin_Goodwater_Creek_Experimental_Watershed_and_Regional_Herbicide_Water_Quality_Data/24660243

Subject Terms:  View help for Subject Terms EARTH SCIENCE > AGRICULTURE > SOILS; EARTH SCIENCE > HUMAN DIMENSIONS > ENVIRONMENTAL GOVERNANCE/MANAGEMENT > ENVIRONMENTAL ASSESSMENTS; EARTH SCIENCE > TERRESTRIAL HYDROSPHERE > WATER QUALITY/WATER CHEMISTRY > CONTAMINANTS; EARTH SCIENCE > SOLID EARTH > GEOMORPHIC LANDFORMS/PROCESSES > FLUVIAL LANDFORMS > WATERSHED/DRAINAGE BASINS; EARTH SCIENCE > AGRICULTURE > AGRICULTURAL PLANT SCIENCE > CROP/PLANT YIELDS; EARTH SCIENCE > TERRESTRIAL HYDROSPHERE > GROUND WATER > PERCOLATION; CONTINENT > NORTH AMERICA > UNITED STATES OF AMERICA > MISSOURI; CONTINENT > NORTH AMERICA > UNITED STATES OF AMERICA > IOWA; VERTICAL LOCATION > LAND SURFACE; HPLC > High-Performance Liquid Chromatograph; GAS CHROMATOGRAPHS; NP211; data.gov; ARS

Geographic Coverage:  View help for Geographic Coverage United States

Time Period(s):  View help for Time Period(s) 1/1/1999 – 12/31/2002

Data Type(s):  View help for Data Type(s) observational data

Collection Notes:  View help for Collection Notes DOI: 10.15482/USDA.ADC/1178084 Citation: Lerch, Robert; Baffaut, Claire; Sadler, John; Kremer, Robert J. (2015). Data from: Long-Term Agroecosystem Research in the Central Mississippi River Basin: Goodwater Creek Experimental Watershed and Regional Herbicide Water Quality Data. Journal of Environmental Quality. https://doi.org/10.15482/USDA.ADC/1178084 (Downloaded 2026-06-26)