This repository takes a csv with information from trials (crop, planting date, latitude, longitude). The csv should always have the same columns as the sample. It downloads soil and weather information, and it runs APSIM for each trial. In the output will add columns to the original csv with soil, weather, and APSIM information.
The characterization variables can be used to characterize the environment of the trials, find clusters of trials with similar conditions, use the variables as regressors to explain the trial results, extrapolate results to areas where trials were not implemented.
The codes are enumerated in the order they need to be executed. Only the first four codes need to be run, and these four codes will call the other ones.
The file input.csv has a row for each trial to be simulated. It requires the following information:
| Variable | Description |
|---|---|
| Site | User site identifier |
| Planting | Planting date |
| Latitude | Latitude of the trial point |
| Longitude | Longitude of the trial point |
| Crop | soybean or maize |
| Genetics | For soybean: maturity group (0 to 6, by 1)For corn: RM (80 to 130, by 5) |
| Variable | Description |
|---|---|
| id_trial | Trial identifier, based on the input.csv |
| Site | User site identifier |
| Planting | Planting date |
| Crop | soybean or maize |
| state | US state |
| region | US region |
| X | latitude |
| Y | longiture |
| yield_sim | Yield obtained from APSIM. If the simulated yield is very different than the trial yield, the simulation should be discarded |
| whc | water-holding capacity of the soil at the location of the exact coordinates (SSURGO) |
| sand | sand % (0-20cm) of the soil at the location of the exact coordinates (SSURGO) |
| clay | clay % (0-20cm) of the soil at the location of the exact coordinates (SSURGO) |
| om | Organic Matter % (0-20cm) of the soil at the location of the exact coordinates (SSURGO) |
| ph | Ph (0-20cm) of the soil at the location of the exact coordinates (SSURGO) |
| rain_# | Rain (mm) in the indicated period |
| radn_# | Mean radiation (MJ/m2/day) in the indicated period |
| MaxT_# | Max temperature (Celsius) in the indicated period |
| MinT_# | Min temperature (Celsius) in the indicated period |
| swdef_expan_# | APSIM water stress index (0 means stress, 1 means no stress) |
| period_start_doy_# | Doy of the year that the period started |
The variables are divided into periods (example: rain_7 means rain during period 7). The periods are the following:
| Period | Description |
|---|---|
| 0 | fallow_initial |
| 1 | veg_early |
| 2 | veg_late |
| 3 | flowering |
| 4 | grainf_early |
| 5 | grainf_late |
| 6 | fallow_end |
Questions about the code and methodology: German Mandrini, Dpt of Crop Sciences, University of Illinois at Urbana-Champaign, germanmandrini@gmail.com
Questions about collaborations: Nicolas F Martin, Dpt of Crop Sciences, University of Illinois at Urbana-Champaign, nfmartin@illinois.edu