Ag Data Commons
Browse
DATASET
c3.jeq2013.12.0516.ds1_.xlsx (4.61 MB)
DATASET
LTAR_GCEW_herbicidewater_qual_0.xlsx (25.91 kB)
DATASET
DevilsIceboxConcData_0.csv (73.83 kB)
DATASET
DevilsIceboxLoad&Discharge_0.csv (199.58 kB)
DATASET
DevilsIceboxSSConcData.csv (2.5 MB)
DATASET
HuntersCaveConcData_0.csv (82.12 kB)
DATASET
HuntersCaveLoad&Discharge.csv (192.69 kB)
DATASET
HuntersCaveSSConc.csv (2.44 MB)
DATASET
LTAR_GCEW_herbicidewater_qual_3.csv (14.26 kB)
1/0
9 files

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

dataset
posted on 2024-02-08, 19:09 authored by Robert Lerch, Claire Baffaut, John Sadler, Robert J. Kremer

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.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_.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.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.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.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.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.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.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.csv

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

Funding

USDA-ARS

History

Data contact name

Lerch, Robert

Data contact email

Bob.Lerch@ars.usda.gov

Publisher

Journal of Environmental Quality

Temporal Extent Start Date

1999-01-01

Temporal Extent End Date

2002-12-31

Theme

  • Not specified

Geographic Coverage

{"type":"FeatureCollection","features":[{"geometry":{"type":"Polygon","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]]]},"type":"Feature","properties":{}},{"geometry":{"type":"Polygon","coordinates":[[[-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]]]},"type":"Feature","properties":{}}]}

Geographic location - description

Goodwater Creek Experimental Watershed, Central Mississippi River Basin; Iowa; Missouri

ISO Topic Category

  • inlandWaters

Ag Data Commons Group

  • Central Mississippi River Basin
  • Long-Term Agroecosystem Research

National Agricultural Library Thesaurus terms

watersheds; mineralogy; models; clay; computer software; turbidity; risk; Iowa; Missouri; streams; herbicides; Mississippi River; suspended sediment; detection limit; data collection; argillic horizons; rivers

OMB Bureau Code

  • 005:18 - Agricultural Research Service

OMB Program Code

  • 005:040 - National Research

ARS National Program Number

  • 211

Primary article PubAg Handle

Pending citation

  • No

Public Access Level

  • Public

Preferred dataset 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