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

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)

GCEW除草剂数据集的收集始于1991年，直至2010年，其记录涵盖地块、田地及流域尺度。在Goodwater Creek实验流域（GCEW）中检测到的阿特拉津浓度，经国家流域回归模型（WARP）的对比分析及与WARP开发所用112个流域的直接比较，均显示出其在美国各流域中位居前列。这一为期20年的研究工作得以扩展，纳入了位于Central Mississippi河盆地内、涵盖Salt River盆地12个相关粘土平原流域的广泛空间研究，以及Bonne Femme流域边缘的2条洞穴溪流，以及密苏里州北部和爱荷华州南部的95条溪流。关于除草剂迁移的研究突出了具有滑石质矿物学的限制性土壤层对迁移风险易感性之重要影响。近地表土壤特征，如粘土盘和伊利石层，相较于具有高饱和水力传导率和低滑石质粘土含量的土壤，会导致更大的除草剂迁移。该数据集包含1999年至2002年间Devils Icebox洞穴和Hunters洞穴的浓度、负荷和每日排放数据。数据以Microsoft Excel 2010格式提供。工作表1（洞穴溪流元数据）包含关于记录长度、地点、测量参数、参数单位、方法检测限、零和空白单元格的含义以及单位面积负荷计算的辅助信息。工作表2（Devils Icebox浓度数据）包含从1999年至2002年在Devils Icebox地点收集的所有样品的12种分析物和两种计算出的营养参数的浓度数据。工作表3（Devils Icebox悬浮固体浓度数据）包含从浑浊度传感器数据估计的Devils Icebox地点的15分钟悬浮固体浓度。工作表4（Devils Icebox负荷与排放数据）包含Devils Icebox地点的每日排放、负荷和单位面积负荷数据。工作表5（Hunters Cave浓度数据）包含从1999年至2002年在Hunters Cave地点收集的所有样品的12种分析物和两种计算出的营养参数的浓度数据。工作表6（Hunters Cave悬浮固体浓度数据）包含从浑浊度传感器数据估计的Hunters Cave地点的15分钟悬浮固体浓度。工作表7（Hunters Cave负荷与排放数据）包含Hunters Cave地点的每日排放、负荷和单位面积负荷数据。
[注：为支持自动化数据访问和处理，每个工作表均已提取为单独的、机器可读的CSV文件；有关变量及其浓度单位的描述，请参阅数据字典。]