Shiny-data-files

#> i Using "','" as decimal and "'.'" as grouping mark. Use `read_delim()` for more control.

Description of data files used by the Shiny applications

This document is using keywords as defined in RFC 2119

Weather files are expected to be in the ASCROM binary VLE package data folder.

Weather files

  • Each file describes a single climate serie.
  • Filenames are later used as an identifier in the Shiny applications.
  • Files are plain text files with Delimiter-Separated Values tabular data.
  • Use a “Long” format style with columns ParamName the parameter name and ParamValue its value (nota: rows order MUST BE chronological with no missing, columns order on the other hand is not important as long as all parameters are defined, see parameter table below).

Weather Parameters definition :

Parameter name Description              
jour the day of the month [1-31]
mois the month of the year [1-12]
annee the year
ETP daily reference evapotranspiration (mm.d-1)
Rain daily rainfall (mm.d-1)
RHmin daily minimmum air relative humidity (%)
u2 daily wind speed at 2m (m.s-1),

Sample weather file content :

jour mois annee ETP Rain RHmin u2
1 5 2022 3.091 0 91.5 0.1084
2 5 2022 1.164 15.39 99.52 0.4494
3 5 2022 1.121 4.421 60.71 0.704
4 5 2022 3.511 23.96 31.14 0.2931
5 5 2022 0.5016 0 63.71 0.641
6 5 2022 2.256 0 56.89 0.5705
7 5 2022 0.07894 0 31.67 0.5943
8 5 2022 2.697 0 48.97 0.8786
9 5 2022 0.1377 17.89 27.26 0.3757
10 5 2022 1.061 18.72 21.33 0.2724

Soil Files

  • Each file describes a single soil.
  • Filenames (without extension) are later used as an identifier in the Shiny applications.
  • Files are plain text files with Delimiter-Separated Values tabular data.
  • Use a “Long” format style with columns ParamName the parameter name and ParamValue its value (nota: rows order is not important as long as all parameters are defined, see parameter table below).

Soil Parameters definition :

Parameter name Description              
TH1 soil surface layer thickness (mm)
ThetaFC1 soil surface layer water content at field capacity (%)
ThetaWP1 soil surface layer water content wilting point (%)
BD1 soil surface layer bulk density (-)
TH2 soil deep layer thickness (mm)
ThetaFC2 soil deep layer water content at field capacity (%)
ThetaWP2 soil deep layer water content wilting point (%)
BD2 soil deep layer bulk density (-)

Sample Soil file content :

ParamName ParamValue
TH1 0.18
ThetaFC1 19.5
ThetaWP1 11.8
BD1 2.2
TH2 0.85
ThetaFC2 27.2
ThetaWP2 18.4
BD2 2.2

Crop Files

4 different kind of files define crop related datas :

Consequently, in order to add a new crop, one needs to :

  • add a new kc pairs file
  • add a new row in the kc_filelist.csv file to give it a unique crop ID
  • add a new row to the crop_parameters.txt file with all crop specific parameter values.

The newly crop ID defined can then be used in new sequences files.

kc pairs

  • Each file describes a single crop (as a set of pairs that will be used for daily interpolation).
  • Files are plain text files with Delimiter-Separated Values tabular data.
  • Use a “Long” format style with columns date in number of days and kc its value (nota: rows order is not important as long as all dates are unique).
  • All files MUST BE located in the rASCROM/inst/extdata/crops/kc folder
  • File encoding SHOULD BE UTF-8
  • Column separator MUST BE ;
  • Decimal separator MUST BE ,
  • SHOULD BE 7 rows of data
  • First and last kc values SHOULD BE 0
  • Dates for 1st and 2nd rows SHOULD BE respectivly 0 and 1
  • Dates for last and 2nd to last rows SHOULD BE 1 apart

Sample kc pairs file content :

date kc
0 0
1 0.15
113 0.15
196 1.05
310 1.05
363 0.9
364 0

kc_filelist.csv

  • This file associate a unique crop ID to a kc pairs file.
  • File is a plain text files with Delimiter-Separated Values tabular data.
  • Use a “Long” format style with columns id the unique crop ID values and filename the filename of kc pairs file.
  • File MUST BE located in the rASCROM/inst/extdata/crops folder
  • File encoding SHOULD BE UTF-8
  • Column separator MUST BE ;
  • All values in the id column MUST BE unique
  • All values in the filename column MUST BE an existing kc pairs file in the rASCROM/inst/extdata/crops/kc folder

kc_filelist.csv file content :

id filename
min kc_min.txt
ex2 kc_sample2.txt
ex1 kc_sample.txt
R_banana_1y kc_banana_1y.txt
F_banana_1y kc_banana_1y.txt
S_banana_1y kc_banana_1y.txt
D_banana_1y kc_banana_1y.txt
R_beetroot kc_beetroot.txt
F_beetroot kc_beetroot.txt
S_beetroot kc_beetroot.txt
D_beetroot kc_beetroot.txt
R_finger_millet kc_finger_millet.txt
F_finger_millet kc_finger_millet.txt
S_finger_millet kc_finger_millet.txt
D_finger_millet kc_finger_millet.txt
R_garlic kc_garlic.txt
F_garlic kc_garlic.txt
S_garlic kc_garlic.txt
D_garlic kc_garlic.txt
R_groundnut kc_groundnut.txt
F_groundnut kc_groundnut.txt
S_groundnut kc_groundnut.txt
D_groundnut kc_groundnut.txt
R_horse_gram kc_horse_gram.txt
F_horse_gram kc_horse_gram.txt
S_horse_gram kc_horse_gram.txt
D_horse_gram kc_horse_gram.txt
R_bangal_gram kc_bangal_gram.txt
F_bangal_gram kc_bangal_gram.txt
S_bangal_gram kc_bangal_gram.txt
D_bangal_gram kc_bangal_gram.txt
R_maize kc_maize.txt
F_maize kc_maize.txt
S_maize kc_maize.txt
D_maize kc_maize.txt
R_marigold_WIP kc_marigold_WIP.txt
F_marigold_WIP kc_marigold_WIP.txt
S_marigold_WIP kc_marigold_WIP.txt
D_marigold_WIP kc_marigold_WIP.txt
R_onion kc_onion.txt
F_onion kc_onion.txt
S_onion kc_onion.txt
D_onion kc_onion.txt
R_sorghum kc_sorghum.txt
F_sorghum kc_sorghum.txt
S_sorghum kc_sorghum.txt
D_sorghum kc_sorghum.txt
R_sugare_cane_1y kc_sugare_cane_1y.txt
F_sugare_cane_1y kc_sugare_cane_1y.txt
S_sugare_cane_1y kc_sugare_cane_1y.txt
D_sugare_cane_1y kc_sugare_cane_1y.txt
R_sunflower kc_sunflower.txt
F_sunflower kc_sunflower.txt
S_sunflower kc_sunflower.txt
D_sunflower kc_sunflower.txt
R_tomato kc_tomato.txt
F_tomato kc_tomato.txt
S_tomato kc_tomato.txt
D_tomato kc_tomato.txt
R_turmeric_WIP kc_turmeric_WIP.txt
F_turmeric_WIP kc_turmeric_WIP.txt
S_turmeric_WIP kc_turmeric_WIP.txt
D_turmeric_WIP kc_turmeric_WIP.txt
R_water_melon kc_water_melon.txt
F_water_melon kc_water_melon.txt
S_water_melon kc_water_melon.txt
D_water_melon kc_water_melon.txt

crop_parameters.txt

  • This file associate for each unique crop ID a set of parameter values.
  • File is a plain text files with Delimiter-Separated Values tabular data.
  • Use a “Long” format style with columns CropID the unique crop ID values, see table below for the definition of the other colums.
  • File MUST BE located in the rASCROM/inst/extdata/crops folder
  • File encoding SHOULD BE UTF-8
  • Column separator MUST BE ;
  • Decimal separator MUST BE ,

Crop Parameters definition :

Parameter name Description              
h The mean plant height during the mid or late season stage. (m) - also see ClimaticWaterDemand model doc
MaxDepthRoots Maximum depth of roots. (m) - also see ClimaticWaterDemand model doc
kcini ?? (-) - also see ClimaticWaterDemand model doc
kcmid ?? (-) - also see ClimaticWaterDemand model doc
IrrigationDose Irrigation amount to be applied. (mm.d-1) - also see IrrigationDemand model doc
Max_Irrigation_Duration Maximal water cycle duration. (d) - also see FarmIrrigationManager model doc
Rain_Threshold Rain amount threshold for Rule_Strat=Rain_Threshold. (mm) - also see IrrigationDemand model doc
SoilWaterContent_Threshold Soil water content threshold for Rule_Strat=SoilWaterContent_Threshold. (mm) - also see IrrigationDemand model doc
CropWaterStress_Threshold Crop water stress threshold for Rule_Strat=CropWaterStress_Threshold. (-) - also see IrrigationDemand model doc
YieldMax ?? (??) - also see Yield model doc
Rain_Threshold_To_Reset_Days_Without_Water Water threshold for water deficit counter. (mm) - also see ClimaticWaterDemand model doc
Lethal_Threshold_Days_Without_Water Number of days of water deficit after which the crop is failed. (d) - also see IrrigationPriority model doc
Lethal_Threshold_CropWaterStress Crop water stress threshold for crop failure. (-) - also see ClimaticWaterDemand model doc
CropPriority Crop priority related to economic factor and crop cycle length. (-) - also see IrrigationPriority model doc
Irrigation_Technic_Factor irrigation technic factor (from least to most demanding in water). (-) - also see IrrigationPriority model doc

crop params file content :

CropID h MaxDepthRoots kcini kcmid Max_Irrigation_Duration Lethal_Threshold_Days_Without_Water YieldMax IrrigationDose Irrigation_Technic_Factor Rain_Threshold SoilWaterContent_Threshold CropWaterStress_Threshold Lethal_Threshold_CropWaterStress Rain_Threshold_To_Reset_Days_Without_Water CropPriority
ex1 1 0.7 0.3 1.1 4 5 10 10 1 10 10 0.5 0.5 10 5
ex2 2 1.2 0.4 1.2 6 5 10 20 1 10 10 0.5 0.5 10 5
R_banana_1y 3 0.5 0.15 1.05 7 17 26 0 1 10 10 0.5 0.5 10 5
R_sugare_cane_1y 3 1.2 0.15 1.2 8 18 123 0 1 10 10 0.5 0.5 10 5
R_turmeric_WIP 0.5 0.4 0.15 0.9 7 17 4.5 0 1 10 10 0.5 0.5 10 1
R_beetroot 0.4 0.5 0.15 0.95 6 14 17 0 1 10 10 0.5 0.5 10 2
R_garlic 0.3 0.4 0.15 0.9 6 14 1.05 0 1 10 10 0.5 0.5 10 2
R_onion 0.3 0.4 0.15 0.95 6 14 5 0 1 10 10 0.5 0.5 10 2
R_tomato 1.05 0.4 0.15 1.12 6 14 44 0 1 10 10 0.5 0.5 10 2
R_water_melon 0.4 0.4 0.15 0.95 6 14 36 0 1 10 10 0.5 0.5 10 2
R_finger_millet 0.7 1 0.15 0.95 15 23 1 0 1 10 10 0.5 0.5 10 4
R_groundnut 0.4 0.5 0.15 1.1 10 20 0.9 0 1 10 10 0.5 0.5 10 4
R_horse_gram 0.4 0.6 0.15 1 15 23 1.2 0 1 10 10 0.5 0.5 10 4
R_maize 2 0.9 0.15 1.15 10 20 2.3 0 1 10 10 0.5 0.5 10 4
R_marigold_WIP 0.4 0.5 0.15 1 8 16 20 0 1 10 10 0.5 0.5 10 4
R_sorghum 2 1 0.15 1 10 20 1 0 1 10 10 0.5 0.5 10 4
R_sunflower 2 0.8 0.15 0.95 10 20 1 0 1 10 10 0.5 0.5 10 4
F_banana_1y 3 0.5 0.15 1.05 7 17 26 40 0.6667 10 10 0.5 0.5 10 5
F_sugare_cane_1y 3 1.2 0.15 1.2 8 18 123 40 0.6667 10 10 0.5 0.5 10 5
F_turmeric_WIP 0.5 0.4 0.15 0.9 7 17 4.5 40 0.6667 10 10 0.5 0.5 10 1
F_beetroot 0.4 0.5 0.15 0.95 6 14 17 40 0.6667 10 10 0.5 0.5 10 2
F_garlic 0.3 0.4 0.15 0.9 6 14 1.05 40 0.6667 10 10 0.5 0.5 10 2
F_onion 0.3 0.4 0.15 0.95 6 14 5 40 0.6667 10 10 0.5 0.5 10 2
F_tomato 1.05 0.4 0.15 1.12 6 14 44 40 0.6667 10 10 0.5 0.5 10 2
F_water_melon 0.4 0.4 0.15 0.95 6 14 36 40 0.6667 10 10 0.5 0.5 10 2
F_finger_millet 0.7 1 0.15 0.95 15 23 1 40 0.6667 10 10 0.5 0.5 10 4
F_groundnut 0.4 0.5 0.15 1.1 10 20 0.9 40 0.6667 10 10 0.5 0.5 10 4
F_horse_gram 0.4 0.6 0.15 1 15 23 1.2 40 0.6667 10 10 0.5 0.5 10 4
F_maize 2 0.9 0.15 1.15 10 20 2.3 40 0.6667 10 10 0.5 0.5 10 4
F_marigold_WIP 0.4 0.5 0.15 1 8 16 20 40 0.6667 10 10 0.5 0.5 10 4
F_sorghum 2 1 0.15 1 10 20 1 40 0.6667 10 10 0.5 0.5 10 4
F_sunflower 2 0.8 0.15 0.95 10 20 1 40 0.6667 10 10 0.5 0.5 10 4
S_banana_1y 3 0.5 0.15 1.05 7 17 26 15 0.25 10 10 0.5 0.5 10 5
S_sugare_cane_1y 3 1.2 0.15 1.2 8 18 123 15 0.25 10 10 0.5 0.5 10 5
S_turmeric_WIP 0.5 0.4 0.15 0.9 7 17 4.5 15 0.25 10 10 0.5 0.5 10 1
S_beetroot 0.4 0.5 0.15 0.95 6 14 17 15 0.25 10 10 0.5 0.5 10 2
S_garlic 0.3 0.4 0.15 0.9 6 14 1.05 15 0.25 10 10 0.5 0.5 10 2
S_onion 0.3 0.4 0.15 0.95 6 14 5 15 0.25 10 10 0.5 0.5 10 2
S_tomato 1.05 0.4 0.15 1.12 6 14 44 15 0.25 10 10 0.5 0.5 10 2
S_water_melon 0.4 0.4 0.15 0.95 6 14 36 15 0.25 10 10 0.5 0.5 10 2
S_finger_millet 0.7 1 0.15 0.95 15 23 1 15 0.25 10 10 0.5 0.5 10 4
S_groundnut 0.4 0.5 0.15 1.1 10 20 0.9 15 0.25 10 10 0.5 0.5 10 4
S_horse_gram 0.4 0.6 0.15 1 15 23 1.2 15 0.25 10 10 0.5 0.5 10 4
S_maize 2 0.9 0.15 1.15 10 20 2.3 15 0.25 10 10 0.5 0.5 10 4
S_marigold_WIP 0.4 0.5 0.15 1 8 16 20 15 0.25 10 10 0.5 0.5 10 4
S_sorghum 2 1 0.15 1 10 20 1 15 0.25 10 10 0.5 0.5 10 4
S_sunflower 2 0.8 0.15 0.95 10 20 1 15 0.25 10 10 0.5 0.5 10 4
D_banana_1y 3 0.5 0.15 1.05 7 17 26 5 0.08333 10 10 0.5 0.5 10 5
D_sugare_cane_1y 3 1.2 0.15 1.2 8 18 123 5 0.08333 10 10 0.5 0.5 10 5
D_turmeric_WIP 0.5 0.4 0.15 0.9 7 17 4.5 5 0.08333 10 10 0.5 0.5 10 1
D_beetroot 0.4 0.5 0.15 0.95 6 14 17 5 0.08333 10 10 0.5 0.5 10 2
D_garlic 0.3 0.4 0.15 0.9 6 14 1.05 5 0.08333 10 10 0.5 0.5 10 2
D_onion 0.3 0.4 0.15 0.95 6 14 5 5 0.08333 10 10 0.5 0.5 10 2
D_tomato 1.05 0.4 0.15 1.12 6 14 44 5 0.08333 10 10 0.5 0.5 10 2
D_water_melon 0.4 0.4 0.15 0.95 6 14 36 5 0.08333 10 10 0.5 0.5 10 2
D_finger_millet 0.7 1 0.15 0.95 15 23 1 5 0.08333 10 10 0.5 0.5 10 4
D_groundnut 0.4 0.5 0.15 1.1 10 20 0.9 5 0.08333 10 10 0.5 0.5 10 4
D_horse_gram 0.4 0.6 0.15 1 15 23 1.2 5 0.08333 10 10 0.5 0.5 10 4
D_maize 2 0.9 0.15 1.15 10 20 2.3 5 0.08333 10 10 0.5 0.5 10 4
D_marigold_WIP 0.4 0.5 0.15 1 8 16 20 5 0.08333 10 10 0.5 0.5 10 4
D_sorghum 2 1 0.15 1 10 20 1 5 0.08333 10 10 0.5 0.5 10 4
D_sunflower 2 0.8 0.15 0.95 10 20 1 5 0.08333 10 10 0.5 0.5 10 4

sequences

  • Each file describes a single crop sequence (as a set of quadruplets).
  • Files are plain text files with Delimiter-Separated Values tabular data.
  • Use a “Long” format style with columns sequence a valid crop ID, padding an optionnal date padding, startdate a relative calendar date for the start of a crop, enddate a relative calendar date for the end of a crop.
  • All files MUST BE located in the rASCROM/inst/extdata/crops/sequences folder
  • Filename extension MUST BE .csv
  • File encoding SHOULD BE UTF-8
  • Column separator MUST BE ;
  • The time span defined between startdate and enddate MUST BE the same as the on defined by the extreme dates in the corresponding kc pairs file

Sample sequence file content :

sequence padding startdate enddate
R_sorghum 0 1/6/+0 10/10/+0
R_sorghum 0 1/6/+1 10/10/+1
R_sorghum 0 1/6/+2 10/10/+2
R_sorghum 0 1/6/+3 10/10/+3
R_sorghum 0 1/6/+4 10/10/+4
R_sorghum 0 1/6/+5 10/10/+5
R_sorghum 0 1/6/+6 10/10/+6
R_sorghum 0 1/6/+7 10/10/+7
R_sorghum 0 1/6/+8 10/10/+8
R_sorghum 0 1/6/+9 10/10/+9
R_sorghum 0 1/6/+10 10/10/+10
R_sorghum 0 1/6/+11 10/10/+11
R_sorghum 0 1/6/+12 10/10/+12
R_sorghum 0 1/6/+13 10/10/+13
R_sorghum 0 1/6/+14 10/10/+14