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

Metadata Updated: June 5, 2025

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: 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/downloadResource 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 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 Suspended Sediment Concentration Data. File Name: DevilsIceboxSSConcData.csvResource 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 Suspended Sediment Concentration Data. File Name: HuntersCaveSSConc.csvResource 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: 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)

Access & Use Information

Public: This dataset is intended for public access and use. License: us-pd

Downloads & Resources

Dates

Metadata Created Date	March 30, 2024
Metadata Updated Date	June 5, 2025

Metadata Source

Data.json Data.json Metadata
Download Metadata

Harvested from USDA JSON

Additional Metadata

Resource Type	Dataset
Metadata Created Date	March 30, 2024
Metadata Updated Date	June 5, 2025
Publisher	Agricultural Research Service
Maintainer	Lerch, Robert
Identifier	10.15482/USDA.ADC/1178084
Data Last Modified	2025-05-01
Public Access Level	public
Bureau Code	005:18
Metadata Context	https://project-open-data.cio.gov/v1.1/schema/catalog.jsonld
Schema Version	https://project-open-data.cio.gov/v1.1/schema
Catalog Describedby	https://project-open-data.cio.gov/v1.1/schema/catalog.json
Harvest Object Id	40cdec05-1a77-4249-8500-72a533c53a79
Harvest Source Id	d3fafa34-0cb9-48f1-ab1d-5b5fdc783806
Harvest Source Title	USDA JSON
License	https://www.usa.gov/publicdomain/label/1.0/
Old Spatial	{"type": "MultiPolygon", "coordinates": -91.368417, 43.501391, -91.215062, 43.501391, -91.204109, 43.353514, -91.056231, 43.254929, -91.176724, 43.134436, -91.143862, 42.909881, -91.067185, 42.75105, -90.711184, 42.636034, -90.639984, 42.510065, -90.420906, 42.329326, -90.393521, 42.225264, -90.168967, 42.126679, -90.141582, 42.000709, -90.179921, 41.809016, -90.311367, 41.743293, -90.344229, 41.589939, -90.656414, 41.463969, -91.045277, 41.414677, -91.111001, 41.239415, -90.946692, 41.097014, -90.963123, 40.921752, -91.09457, 40.823167, -91.121954, 40.669813, -91.401278, 40.560274, -91.417709, 40.379535, -91.527248, 40.412397, -91.729895, 40.615043, -91.833957, 40.609566, -93.257961, 40.582182, -94.632673, 40.571228, -95.7664, 40.587659, -95.881416, 40.719105, -95.826646, 40.976521, -95.925231, 41.201076, -95.919754, 41.453015, -96.095016, 41.540646, -96.122401, 41.67757, -96.062155, 41.798063, -96.127878, 41.973325, -96.264801, 42.039048, -96.44554, 42.488157, -96.631756, 42.707235, -96.544125, 42.855112, -96.511264, 43.052282, -96.434587, 43.123482, -96.560556, 43.222067, -96.527695, 43.397329, -96.582464, 43.479483, -96.451017, 43.501391, -91.368417, 43.501391, -91.833957, 40.609566, -91.729895, 40.615043, -91.527248, 40.412397, -91.417709, 40.379535, -91.50534, 40.237135, -91.494386, 40.034488, -91.368417, 39.727779, -91.061708, 39.470363, -90.727615, 39.256762, -90.661891, 38.928146, -90.585214, 38.867899, -90.470199, 38.961007, -90.251121, 38.917192, -90.10872, 38.845992, -90.207305, 38.725499, -90.179921, 38.632391, -90.349706, 38.374975, -90.355183, 38.216144, -90.059428, 38.013497, -89.949889, 37.88205, -89.84035, 37.903958, -89.517211, 37.690357, -89.517211, 37.537003, -89.435057, 37.34531, -89.517211, 37.279587, -89.292656, 36.994786, -89.133825, 36.983832, -89.215979, 36.578538, -89.363857, 36.622354, -89.418626, 36.496384, -89.484349, 36.496384, -89.539119, 36.496384, -89.533642, 36.249922, -89.730812, 35.997983, -90.377091, 35.997983, -90.218259, 36.184199, -90.064905, 36.304691, -90.152536, 36.496384, -94.473842, 36.501861, -94.616242, 36.501861, -94.616242, 37.000263, -94.610765, 39.158177, -94.824366, 39.20747, -94.983197, 39.442978, -95.109167, 39.541563, -94.884612, 39.831841, -95.207752, 39.908518, -95.306337, 40.001626, -95.552799, 40.264519, -95.7664, 40.587659, -94.632673, 40.571228, -93.257961, 40.582182, -91.833957, 40.609566}
Program Code	005:040
Source Datajson Identifier	True
Source Hash	8409e543f98033398f4f8c23094cd1b043103094415ce70974406bd31bff2e4f
Source Schema Version	1.1
Spatial	{"type": "MultiPolygon", "coordinates": -91.368417, 43.501391, -91.215062, 43.501391, -91.204109, 43.353514, -91.056231, 43.254929, -91.176724, 43.134436, -91.143862, 42.909881, -91.067185, 42.75105, -90.711184, 42.636034, -90.639984, 42.510065, -90.420906, 42.329326, -90.393521, 42.225264, -90.168967, 42.126679, -90.141582, 42.000709, -90.179921, 41.809016, -90.311367, 41.743293, -90.344229, 41.589939, -90.656414, 41.463969, -91.045277, 41.414677, -91.111001, 41.239415, -90.946692, 41.097014, -90.963123, 40.921752, -91.09457, 40.823167, -91.121954, 40.669813, -91.401278, 40.560274, -91.417709, 40.379535, -91.527248, 40.412397, -91.729895, 40.615043, -91.833957, 40.609566, -93.257961, 40.582182, -94.632673, 40.571228, -95.7664, 40.587659, -95.881416, 40.719105, -95.826646, 40.976521, -95.925231, 41.201076, -95.919754, 41.453015, -96.095016, 41.540646, -96.122401, 41.67757, -96.062155, 41.798063, -96.127878, 41.973325, -96.264801, 42.039048, -96.44554, 42.488157, -96.631756, 42.707235, -96.544125, 42.855112, -96.511264, 43.052282, -96.434587, 43.123482, -96.560556, 43.222067, -96.527695, 43.397329, -96.582464, 43.479483, -96.451017, 43.501391, -91.368417, 43.501391, -91.833957, 40.609566, -91.729895, 40.615043, -91.527248, 40.412397, -91.417709, 40.379535, -91.50534, 40.237135, -91.494386, 40.034488, -91.368417, 39.727779, -91.061708, 39.470363, -90.727615, 39.256762, -90.661891, 38.928146, -90.585214, 38.867899, -90.470199, 38.961007, -90.251121, 38.917192, -90.10872, 38.845992, -90.207305, 38.725499, -90.179921, 38.632391, -90.349706, 38.374975, -90.355183, 38.216144, -90.059428, 38.013497, -89.949889, 37.88205, -89.84035, 37.903958, -89.517211, 37.690357, -89.517211, 37.537003, -89.435057, 37.34531, -89.517211, 37.279587, -89.292656, 36.994786, -89.133825, 36.983832, -89.215979, 36.578538, -89.363857, 36.622354, -89.418626, 36.496384, -89.484349, 36.496384, -89.539119, 36.496384, -89.533642, 36.249922, -89.730812, 35.997983, -90.377091, 35.997983, -90.218259, 36.184199, -90.064905, 36.304691, -90.152536, 36.496384, -94.473842, 36.501861, -94.616242, 36.501861, -94.616242, 37.000263, -94.610765, 39.158177, -94.824366, 39.20747, -94.983197, 39.442978, -95.109167, 39.541563, -94.884612, 39.831841, -95.207752, 39.908518, -95.306337, 40.001626, -95.552799, 40.264519, -95.7664, 40.587659, -94.632673, 40.571228, -93.257961, 40.582182, -91.833957, 40.609566}
Temporal	1999-01-01/2002-12-31

Didn't find what you're looking for? Suggest a dataset here.

Data Catalog