Transforming Drainage Research Data (USDA-NIFA Award No. 2015-68007-23193)
This dataset contains research data compiled by the “Managing Water for Increased Resiliency of Drained Agricultural Landscapes” project a.k.a. Transforming Drainage. This project was funded from 2015-2021 by the United States Department of Agriculture, National Institute of Food and Agriculture (USDA-NIFA, Award No. 2015-68007-23193). Data are also available from a separate web-accessible application (drainagedata.org). At drainagedata.org, users can visualize the data with customized tools, query based on specific sites and measurements of interest, and access site photographs, maps, summaries, and publications. Additional data or edits made following the publication of this data here at USDA NAL Ag Data Commons will be posted under the Versions tab on drainagedata.org.
These data began in 1996 and include plot- and field-level measurements for 39 experiments across the Midwest and North Carolina. Practices studied include controlled drainage, drainage water recycling, and saturated buffers. In total, 219 variables are reported and span 207 site-years for tile drainage, 154 for nitrate-N load, 181 for water quality, 92 for water table, and 201 for crop yield.
The Transforming Drainage Project worked to advance the process of designing and implementing agricultural drainage systems for storing water in the landscape to improve the resiliency and productivity of agricultural systems. At each site, a control plot was paired with a plot with one of the following three practices to assess impacts.
Controlled Drainage (CD) is the practice of using a water control structure to raise the depth of the drainage outlet, holding water in the field during periods when drainage is not needed.
Drainage Water Recycling (DWR) diverts subsurface drainage water into on-farm ponds or reservoirs, where it is stored until it can be used by the crop later in the season through supplemental irrigation.
Saturated Buffers (SB) remove nitrate from subsurface drainage water by diverting it into the buffer where it can be taken up by growing vegetation or removed by denitrification.
Resources in this dataset:Resource Title: Field management - tillage. File Name: mngt_tillage_data.csvResource Description: Information about tillage operations performed in the research fields during the study periodResource Title: Field management – notes. File Name: mngt_notes_data.csvResource Description: General information about field conditions during the study periodResource Title: Field management – residue. File Name: mngt_residue_data.csvResource Description: Information about residue management in the research fields during the study periodResource Title: Field management – fertilizing. File Name: mngt_fertilizing_data.csvResource Description: Information about fertilizer application and soil amendments performed in the research fields during the study periodResource Title: Field management – harvesting. File Name: mngt_harvesting_data.csvResource Description: Information about harvesting operations performed in the research fields during the study periodResource Title: Field management – planting. File Name: mngt_planting_data.csvResource Description: Information about planting operations performed in the research fields during the study periodResource Title: Field management – irrigation. File Name: mngt_irrigation_data.csvResource Description: Information about irrigation operations performed in the research fields during the study periodResource Title: Field management – drainage water management. File Name: mngt_dwm_data.csvResource Description: Information about drainage water management in the research fields during the study periodResource Title: Weather data. File Name: weather_data.csvResource Description: On-site weather data collected in the research fields during the study periodResource Title: Soil physicochemical properties data. File Name: soil_properties_data.csvResource Description: Soil physicochemical measurements collected in the research fields during the study periodResource Title: Soil moisture data. File Name: soil_moisture_data.csvResource Description: Soil moisture, temperature and bulk EC measurements collected in the research fields during the study periodResource Title: Irrigation data. File Name: irrigation_data.csvResource Description: Amount of irrigation water applied to the research fields during the study periodResource Title: Stage data. File Name: water_stage_data.csvResource Description: Stage measurements in the wetlands during the study periodResource Title: Water table data. File Name: water_table_data.csvResource Description: Water table measurements collected in the research fields during the study periodResource Title: Water quality data. File Name: water_quality_data.csvResource Description: Water quality measurements collected from the research fields during the study periodResource Title: Methodology. File Name: meta_methods.csvResource Description: Description of the drainage system set up, sampling procedures, and other protocols used at each research site during the study periodResource Title: Plot treatment. File Name: meta_treatment_identifier.csvResource Description: List of treatments used across the research sites during the study periodResource Title: Plot description. File Name: meta_plot_characteristics.csvResource Description: Description of plots and corresponding drainage systems for each research siteResource Title: Agronomic data. File Name: agronomic_data.csvResource Description: Agronomic measurements collected in the research fields during the study periodResource Title: Site description. File Name: meta_site_characteristics.csvResource Description: Description of the research sitesResource Title: Drainage data. File Name: drain_flow_and_N_loads_data.csvResource Description: Drain flow and nitrate load measurements collected from the research fields during the study periodResource Title: Data dictionary. File Name: data_dictionary.csv
Complete Metadata
| @type | dcat:Dataset |
|---|---|
| accessLevel | public |
| bureauCode |
[
"005:18"
]
|
| contactPoint |
{
"fn": "Chighladze, Giorgi",
"hasEmail": "mailto:isudatateam@iastate.edu"
}
|
| description | <p>This dataset contains research data compiled by the “Managing Water for Increased Resiliency of Drained Agricultural Landscapes” project a.k.a. <a href="https://transformingdrainage.org"><strong>Transforming Drainage</strong></a>. This project was funded from 2015-2021 by the United States Department of Agriculture, National Institute of Food and Agriculture (USDA-NIFA, Award No. 2015-68007-23193). Data are also available from a separate web-accessible application (<a href="https://drainagedata.org"><strong>drainagedata.org</strong></a>). At drainagedata.org, users can visualize the data with customized tools, query based on specific sites and measurements of interest, and access site photographs, maps, summaries, and publications. Additional data or edits made following the publication of this data here at USDA NAL Ag Data Commons will be posted under the Versions tab on drainagedata.org.</p> <p>These data began in 1996 and include plot- and field-level measurements for 39 experiments across the Midwest and North Carolina. Practices studied include controlled drainage, drainage water recycling, and saturated buffers. In total, 219 variables are reported and span 207 site-years for tile drainage, 154 for nitrate-N load, 181 for water quality, 92 for water table, and 201 for crop yield.</p> <p>The Transforming Drainage Project worked to advance the process of designing and implementing agricultural drainage systems for storing water in the landscape to improve the resiliency and productivity of agricultural systems. At each site, a control plot was paired with a plot with one of the following three practices to assess impacts.</p> <ol> <li> <p><strong>Controlled Drainage</strong> (CD) is the practice of using a water control structure to raise the depth of the drainage outlet, holding water in the field during periods when drainage is not needed.</p> </li> <li> <p><strong>Drainage Water Recycling</strong> (DWR) diverts subsurface drainage water into on-farm ponds or reservoirs, where it is stored until it can be used by the crop later in the season through supplemental irrigation. </p> </li> <li> <p><strong>Saturated Buffers</strong> (SB) remove nitrate from subsurface drainage water by diverting it into the buffer where it can be taken up by growing vegetation or removed by denitrification.</p> <div><br>Resources in this dataset:</div><br><ul><li><p>Resource Title: Field management - tillage.</p> <p>File Name: mngt_tillage_data.csv</p><p>Resource Description: Information about tillage operations performed in the research fields during the study period</p></li><br><li><p>Resource Title: Field management – notes.</p> <p>File Name: mngt_notes_data.csv</p><p>Resource Description: General information about field conditions during the study period</p></li><br><li><p>Resource Title: Field management – residue.</p> <p>File Name: mngt_residue_data.csv</p><p>Resource Description: Information about residue management in the research fields during the study period</p></li><br><li><p>Resource Title: Field management – fertilizing.</p> <p>File Name: mngt_fertilizing_data.csv</p><p>Resource Description: Information about fertilizer application and soil amendments performed in the research fields during the study period</p></li><br><li><p>Resource Title: Field management – harvesting.</p> <p>File Name: mngt_harvesting_data.csv</p><p>Resource Description: Information about harvesting operations performed in the research fields during the study period</p></li><br><li><p>Resource Title: Field management – planting.</p> <p>File Name: mngt_planting_data.csv</p><p>Resource Description: Information about planting operations performed in the research fields during the study period</p></li><br><li><p>Resource Title: Field management – irrigation.</p> <p>File Name: mngt_irrigation_data.csv</p><p>Resource Description: Information about irrigation operations performed in the research fields during the study period</p></li><br><li><p>Resource Title: Field management – drainage water management.</p> <p>File Name: mngt_dwm_data.csv</p><p>Resource Description: Information about drainage water management in the research fields during the study period</p></li><br><li><p>Resource Title: Weather data.</p> <p>File Name: weather_data.csv</p><p>Resource Description: On-site weather data collected in the research fields during the study period</p></li><br><li><p>Resource Title: Soil physicochemical properties data.</p> <p>File Name: soil_properties_data.csv</p><p>Resource Description: Soil physicochemical measurements collected in the research fields during the study period</p></li><br><li><p>Resource Title: Soil moisture data.</p> <p>File Name: soil_moisture_data.csv</p><p>Resource Description: Soil moisture, temperature and bulk EC measurements collected in the research fields during the study period</p></li><br><li><p>Resource Title: Irrigation data.</p> <p>File Name: irrigation_data.csv</p><p>Resource Description: Amount of irrigation water applied to the research fields during the study period</p></li><br><li><p>Resource Title: Stage data.</p> <p>File Name: water_stage_data.csv</p><p>Resource Description: Stage measurements in the wetlands during the study period</p></li><br><li><p>Resource Title: Water table data.</p> <p>File Name: water_table_data.csv</p><p>Resource Description: Water table measurements collected in the research fields during the study period</p></li><br><li><p>Resource Title: Water quality data.</p> <p>File Name: water_quality_data.csv</p><p>Resource Description: Water quality measurements collected from the research fields during the study period</p></li><br><li><p>Resource Title: Methodology.</p> <p>File Name: meta_methods.csv</p><p>Resource Description: Description of the drainage system set up, sampling procedures, and other protocols used at each research site during the study period</p></li><br><li><p>Resource Title: Plot treatment.</p> <p>File Name: meta_treatment_identifier.csv</p><p>Resource Description: List of treatments used across the research sites during the study period</p></li><br><li><p>Resource Title: Plot description.</p> <p>File Name: meta_plot_characteristics.csv</p><p>Resource Description: Description of plots and corresponding drainage systems for each research site</p></li><br><li><p>Resource Title: Agronomic data.</p> <p>File Name: agronomic_data.csv</p><p>Resource Description: Agronomic measurements collected in the research fields during the study period</p></li><br><li><p>Resource Title: Site description.</p> <p>File Name: meta_site_characteristics.csv</p><p>Resource Description: Description of the research sites</p></li><br><li><p>Resource Title: Drainage data.</p> <p>File Name: drain_flow_and_N_loads_data.csv</p><p>Resource Description: Drain flow and nitrate load measurements collected from the research fields during the study period</p></li><br><li><p>Resource Title: Data dictionary.</p> <p>File Name: data_dictionary.csv</p></li></ul> </li> </ol><p></p> |
| distribution |
[
{
"@type": "dcat:Distribution",
"title": "mngt_tillage_data.csv",
"format": "csv",
"mediaType": "text/plain",
"downloadURL": "https://ndownloader.figshare.com/files/44528996"
},
{
"@type": "dcat:Distribution",
"title": "mngt_notes_data.csv",
"format": "csv",
"mediaType": "application/csv",
"downloadURL": "https://ndownloader.figshare.com/files/44528999"
},
{
"@type": "dcat:Distribution",
"title": "mngt_residue_data.csv",
"format": "csv",
"mediaType": "text/plain",
"downloadURL": "https://ndownloader.figshare.com/files/44529002"
},
{
"@type": "dcat:Distribution",
"title": "mngt_fertilizing_data.csv",
"format": "csv",
"mediaType": "application/csv",
"downloadURL": "https://ndownloader.figshare.com/files/44529005"
},
{
"@type": "dcat:Distribution",
"title": "mngt_harvesting_data.csv",
"format": "csv",
"mediaType": "text/plain",
"downloadURL": "https://ndownloader.figshare.com/files/44529008"
},
{
"@type": "dcat:Distribution",
"title": "mngt_planting_data.csv",
"format": "csv",
"mediaType": "application/csv",
"downloadURL": "https://ndownloader.figshare.com/files/44529011"
},
{
"@type": "dcat:Distribution",
"title": "mngt_irrigation_data.csv",
"format": "csv",
"mediaType": "text/plain",
"downloadURL": "https://ndownloader.figshare.com/files/44529014"
},
{
"@type": "dcat:Distribution",
"title": "mngt_dwm_data.csv",
"format": "csv",
"mediaType": "application/csv",
"downloadURL": "https://ndownloader.figshare.com/files/44529017"
},
{
"@type": "dcat:Distribution",
"title": "weather_data.csv",
"format": "csv",
"mediaType": "text/plain",
"downloadURL": "https://ndownloader.figshare.com/files/44529020"
},
{
"@type": "dcat:Distribution",
"title": "soil_properties_data.csv",
"format": "csv",
"mediaType": "application/csv",
"downloadURL": "https://ndownloader.figshare.com/files/44529023"
},
{
"@type": "dcat:Distribution",
"title": "soil_moisture_data.csv",
"format": "csv",
"mediaType": "text/plain",
"downloadURL": "https://ndownloader.figshare.com/files/44529026"
},
{
"@type": "dcat:Distribution",
"title": "agronomic_data_0.csv",
"format": "csv",
"mediaType": "application/csv",
"downloadURL": "https://ndownloader.figshare.com/files/44529029"
},
{
"@type": "dcat:Distribution",
"title": "irrigation_data.csv",
"format": "csv",
"mediaType": "text/plain",
"downloadURL": "https://ndownloader.figshare.com/files/44529032"
},
{
"@type": "dcat:Distribution",
"title": "water_stage_data.csv",
"format": "csv",
"mediaType": "application/csv",
"downloadURL": "https://ndownloader.figshare.com/files/44529035"
},
{
"@type": "dcat:Distribution",
"title": "water_table_data.csv",
"format": "csv",
"mediaType": "text/plain",
"downloadURL": "https://ndownloader.figshare.com/files/44529038"
},
{
"@type": "dcat:Distribution",
"title": "water_quality_data.csv",
"format": "csv",
"mediaType": "text/plain",
"downloadURL": "https://ndownloader.figshare.com/files/44529044"
},
{
"@type": "dcat:Distribution",
"title": "drain_flow_and_N_loads_data_0.csv",
"format": "csv",
"mediaType": "application/csv",
"downloadURL": "https://ndownloader.figshare.com/files/44529047"
},
{
"@type": "dcat:Distribution",
"title": "meta_methods.csv",
"format": "csv",
"mediaType": "text/plain",
"downloadURL": "https://ndownloader.figshare.com/files/44529053"
},
{
"@type": "dcat:Distribution",
"title": "meta_treatment_identifier.csv",
"format": "csv",
"mediaType": "application/csv",
"downloadURL": "https://ndownloader.figshare.com/files/44529056"
},
{
"@type": "dcat:Distribution",
"title": "meta_plot_characteristics.csv",
"format": "csv",
"mediaType": "text/plain",
"downloadURL": "https://ndownloader.figshare.com/files/44529062"
},
{
"@type": "dcat:Distribution",
"title": "meta_site_characteristics_0.csv",
"format": "csv",
"mediaType": "application/csv",
"downloadURL": "https://ndownloader.figshare.com/files/44529068"
},
{
"@type": "dcat:Distribution",
"title": "data_dictionary_5.csv",
"format": "csv",
"mediaType": "application/csv",
"downloadURL": "https://ndownloader.figshare.com/files/44529074"
}
]
|
| identifier | 10.15482/USDA.ADC/1521092 |
| keyword |
[
"ARS",
"NP211",
"controlled drainage",
"crop yield",
"data.gov",
"drainage",
"drainage water management",
"drainage water recycling",
"saturated buffer",
"subsurface drainage",
"tile drainage"
]
|
| license | https://creativecommons.org/licenses/by/4.0/ |
| modified | 2025-11-22 |
| programCode |
[
"005:040"
]
|
| publisher |
{
"name": "Agricultural Research Service",
"@type": "org:Organization"
}
|
| spatial |
"{"type": "MultiPolygon", "coordinates": [[[[-84.321869, 36.588117], [-84.321869, 33.840324], [-75.533012, 33.840324], [-75.533012, 36.588117], [-84.321869, 36.588117]]], [[[-76.014954, 35.776289], [-76.014954, 35.061855], [-75.458659, 35.061855], [-75.458659, 35.776289], [-76.014954, 35.776289]]], [[[-84.820159, 41.977523], [-84.820159, 38.403202], [-80.518693, 38.403202], [-80.518693, 41.977523], [-84.820159, 41.977523]]], [[[-88.058499, 41.760592], [-88.058499, 37.771742], [-84.784579, 37.771742], [-84.784579, 41.760592], [-88.058499, 41.760592]]], [[[-96.639704, 43.501196], [-96.639704, 40.375501], [-90.140061, 40.375501], [-90.140061, 43.501196], [-96.639704, 43.501196]]], [[[-97.239209, 49.384358], [-97.239209, 43.499356], [-89.489226, 43.499356], [-89.489226, 49.384358], [-97.239209, 49.384358]]], [[[-95.774704, 40.61364], [-95.774704, 35.995683], [-89.098843, 35.995683], [-89.098843, 40.61364], [-95.774704, 40.61364]]], [[[-104.0489, 49.000687], [-104.0489, 45.935054], [-96.554507, 45.935054], [-96.554507, 49.000687], [-104.0489, 49.000687]]], [[[-104.057698, 45.94545], [-104.057698, 42.479635], [-96.436589, 42.479635], [-96.436589, 45.94545], [-104.057698, 45.94545]]]]}"
|
| temporal | 1996-01-01/2018-12-31 |
| title | Transforming Drainage Research Data (USDA-NIFA Award No. 2015-68007-23193) |
