Powdery Mildew Aragon Dataset

1.- powdery_mildew_dataset.csv File powdery_mildew_dataset.csv contains the dataset that can be used for training ML models. Each of the records represents the data considered for a given parcel (vineyard) in each date. The following table provides a description of the fields contained in the dataset. For clarity, we simplified the table by using an abbreviated notation for the field names; specifically, for some field names we include an asterisk (“*”) with the name followed by a couple of numbers in brackets (“[…]”) that describe the range of integer values that can replace the “*” in the dataset; for example, we did this in fields which provide values of the given variable data for the n days before (dias_atras) and after (dias_adelante). For clarity, we provide here some examples: · tmed_min *_dias_atras [1,13]: this name represents that the dataset contains all the fields tmed_min 1_dias_atras, tmed_min 2_dias_atras, ..., tmed_min 13_dias_atras, which represent, for the given field, the minimum temperature for each of the n days before the date of the record. · wind_NE *_dias_adelante [1,6]: this name represents that the dataset contains all the fields wind_NE 1_dias_adelante, t wind_NE 2_dias_adelante, ..., wind_NE 6_dias_adelante, which represent, for the given field, the wind_NE index for each of the n days after the date of the record. · gdd_4.5_t0_Tbase_sum *_semanas_atras [1,2]: this name represents that the dataset contains all the fields gdd_4.5_t0_Tbase_sum 1_semanas_atras and gdd_4.5_t0_Tbase_sum 2_semanas_atras, which represent, for the given field, the GDD calculated using the base temperature 4.5º C and starting to accumulate at the beginning of the session. Moreover, we use “|” to denote choices (expressed within brackets “[…]”), which can represent several attributes. For example, “rad_[min|max|mean]” actually represents (in a condensed way) 3 different variables: “rad_min”, “rad_max” and “rad_mean”. Other notations can be interpreted similarly. Field Name (abbreviated notation) Description phenologystageid Id of the phenological stage of the parcel on the given date. See file “202407190033_phenological_stages.csv”. variedad Grapevine variety: Cabernet Sauvignon, Chardonnay, Garnacha, Mazuela, Syrach, Tempranillo. codigo Id of the parcel in the Spanish Cadastral Registry. longitude Longitude of the centroid of the parcel. latitude Latitude of the centroid of the parcel. altitud Altitude of the centroid of the parcel. doc_id Id of the Protected Designation of Origin (PDO): Calatayud, Cariñena, Campo de Borja, Somontano and Vinos de la Tierra. fecha The date of the record. estacion The name of the climatic station whose data are considered. season The season to which the record belongs. "do_Borja", "do_Calatayud", "do_Cariñena", "do_Somontano, do_Vinos_de_la_tierra" Boolean values which are true when the record corresponds to the given PDO. "variedad_CABERNET SAUVIGNON", "variedad_CHARDONNAY", "variedad_GARNACHA", "variedad_MAZUELA", "variedad_SYRACH", "variedad_TEMPRANILLO" Boolean values which are true when the record corresponds to a field with the given variety. tmed_[min|max|mean] [Minimum|Maximum|Mean] temperature for the given date (ºC). tmed_[min|max|mean] *_dias_atras [1,13] [Minimum|Maximum|Mean] temperatures for the 13 days before the given date. hr_ mean Average air relative humidity for the given date (%). hr_mean *_dias_atras [1,13] Average air relative humidity radiation for the 13 days before the given date. gdd_[4.5|10.0]_[t0|1|2]_[TBase|TbaseMax]_sum GDD heat accumulation index, calculated with a base temperature of 4.5ºC or 10.0 ºC; accumulated since the beginning of the season (t0), January the 1st of the date’s year (1) or February the 1st (2); considering a maximum temperature threshold over which the heat accumulation stopped (TbaseMAx, 35ºC) or not (TBase); and considering the daily contribution calculated considering the min temperature and max temperature of the given day (sum). gdd_[4.5|10.0]_[t0|1|2]_[TBase|TbaseMax]_sum *_semanas_atras [1|2] GDD heat accumulation index, calculated with a base temperature of 4.5ºC or 10.0 ºC; accumulated since the beginning of the season (t0), January the 1st of the date’s year (1) or February the 1st (2); considering a maximum temperature threshold over which the heat accumulation stopped (TbaseMAx, 35ºC) or not (TBase); and considering the daily contribution calculated considering the min temperature and max temperature of the given day (sum), for the 2 weeks previous to the given day. chillingDD_7.0_[t0|1|2]_[TBase|Tbasemin]_sum Richardson cold accumulation index, calculated with a base temperature of 7.0º C; accumulated since the beginning of the season (t0), January the 1st of the date’s year (1) or February the 1st (2); considering a minimum temperature threshold above which the cold accumulation stopped (Tbasemin, -7ºC) or not (TBase); and considering the daily contribution calculated considering the min temperature and max temperature of the given day (sum). chillingDD_7.0_[t0|1|2]_[TBase|Tbasemin]_sum *_semanas_atras [1|2] Richardson cold accumulation index, calculated with a base temperature of 7.0º C; accumulated since the beginning of the season (t0), January the 1st of the date’s year (1) or February the 1st (2); considering a minimum temperature threshold above which the cold accumulation stopped (Tbasemin, -7ºC) or not (TBase); and considering the daily contribution calculated considering the min temperature and max temperature of the given day (sum), for the 2 weeks previous to the given day. ChillingDD_7.0_[t0|1|2]_ Utah _sum Utah cold accumulation index, calculated with a base temperature of 7.0º C; accumulated since the beginning of the season (t0), January the 1st of the date’s year (1) or February the 1st (2); considering a minimum temperature threshold above which the cold accumulation stopped (Tbasemin, -7ºC) or not (TBase); and considering the daily contribution calculated considering the min temperature and max temperature of the given day (sum). ChillingDD_7.0_[t0|1|2]_ Utah _sum *_semanas_atras [1|2] Utah cold accumulation index, calculated with a base temperature of 7.0º C; accumulated since the beginning of the season (t0), January the 1st of the date’s year (1) or February the 1st (2); considering a minimum temperature threshold above which the cold accumulation stopped (Tbasemin, -7ºC) or not (TBase); and considering the daily contribution calculated considering the min temperature and max temperature of the given day (sum), for the 2 weeks previous to the given day. chillingDD_7.0_[t0|1|2]_[TBase|Tbasemin]_sum_Cumm Accumulated Richardson cold accumulation index, calculated with a base temperature of 7.0º C; accumulated since the beginning of the season (t0), January the 1st of the date’s year (1) or February the 1st (2); considering a minimum temperature threshold above which the cold accumulation stopped (Tbasemin, -7ºC) or not (TBase); and considering the daily contribution calculated considering the min temperature and max temperature of the given day (sum), up until the given date. chillingDD_7.0_[t0|1|2]_[TBase|Tbasemin]_sum_Cumm *_semanas_atras [1|2] Acummulated Richardson cold accumulation index, calculated with a base temperature of 7.0º C; accumulated since the beginning of the season (t0), January the 1st of the date’s year (1) or February the 1st (2); considering a minimum temperature threshold above which the cold accumulation stopped (Tbasemin, -7ºC) or not (TBase); and considering the daily contribution calculated considering the min temperature and max temperature of the given day (sum), for the 2 weeks previous to the given day, until 1 or 2 weeks before the given date. ChillingDD_7.0_[t0|1|2]_ Utah _sum_Cumm Accumulated Utah cold accumulation index, calculated with a base temperature of 7.0º C; accumulated since the beginning of the season (t0), January the 1st of the date’s year (1) or February the 1st (2); considering a minimum temperature threshold above which the cold accumulation stopped (Tbasemin, -7ºC) or not (TBase); and considering the daily contribution calculated considering the min temperature and max temperature of the given day (sum), until the given date. ChillingDD_7.0_[t0|1|2]_ Utah _sum_Cumm *_semanas_atras [1|2] Accumulated Utah cold accumulation index, calculated with a base temperature of 7.0º C; accumulated since the beginning of the season (t0), January the 1st of the date’s year (1) or February the 1st (2); considering a minimum temperature threshold above which the cold accumulation stopped (Tbasemin, -7ºC) or not (TBase); and considering the daily contribution calculated considering the min temperature and max temperature of the given day (sum), for the 2 weeks previous to the given day, until 1 or 2 weeks before the given date. rad_sum Accumulated radiation since the beginning of the season until the given date. rad_sum *_semanas_atras [1|2] Accumulated radiation since the beginning of the season until 1 or 2 weeks before the given date. rad__[t0__Cumm|1__Cumm|2__Cumm] Accumulated radiation since the beginning of the season (t0), January the 1st of the date’s year (1) or February the 1st (2) until the given date rad__[t0__Cumm|1__Cumm|2__Cumm] *_semanas_atras [1|2] Accumulated radiation since the beginning of the season (t0), January the 1st of the date’s year (1) or February the 1st (2) until 1 or 2 weeks before the given date precip_sum Accumulated precipitation since the beginning of the season until the given date. precip_sum *_semanas_atras [1|2] Accumulated precipitation since the beginning of the season until 1 or 2 weeks before the given date. precip__[t0__Cumm|1__Cumm|2__Cumm] Accumulated precipitation since the beginning of the season (t0), January the 1st of the date’s year (1) or February the 1st (2) until the given date precip__[t0__Cumm|1__Cumm|2__Cumm] *_semanas_atras [1|2] Accumulated radiation since the beginning of the season (t0), January the 1st of the date’s year (1) or February the 1st (2) until 1 or 2 weeks before the given date winkler_[4.5|10.0]_[ TBase|TbaseMax] Winkler heat accumulation index, calculated with a base temperature of 4.5ºC or 10.0 ºC; increment for the given date; considering a maximum temperature threshold over which the heat accumulation stopped (TbaseMAx, 35ºC) or not (TBase); and considering the daily contribution calculated considering the min temperature and max temperature of the given day (sum). winkler_[4.5|10.0]_[ TBase|TbaseMax] *_semanas_atras [1|2] Winkler heat accumulation index, calculated with a base temperature of 4.5ºC or 10.0 ºC; daily increment for the date either 1 or 2 weeks before the given date; considering a maximum temperature threshold over which the heat accumulation stopped (TbaseMAx, 35ºC) or not (TBase); and considering the daily contribution calculated considering the min temperature and max temperature of the given day (sum). winkler_[4.5|10.0]_[t0|1|2]_[TBase|TbaseMax]_Cumm Winkler heat accumulation index, calculated with a base temperature of 4.5ºC or 10.0 ºC; accumulated since the beginning of the season (t0), January the 1st of the date’s year (1) or February the 1st (2); considering a maximum temperature threshold over which the heat accumulation stopped (TbaseMAx, 35ºC) or not (TBase); and considering the daily contribution calculated considering the min temperature and max temperature of the given day (sum). winkler_[4.5|10.0]_[t0|1|2]_[TBase|TbaseMax]_Cumm *_semanas_atras [1|2] Winkler heat accumulation index, calculated with a base temperature of 4.5ºC or 10.0 ºC; accumulated since the beginning of the season (t0), January the 1st of the date’s year (1) or February the 1st (2); considering a maximum temperature threshold over which the heat accumulation stopped (TbaseMAx, 35ºC) or not (TBase); and considering the daily contribution calculated considering the min temperature and max temperature of the given day (sum), for the 2 weeks previous to the given day. The GDD, Winkler and Chilling (Richardson and Utah) indexes are also calculated considering the contributions of the time units (periods) to the daily contribution. These fields (or columns of the file) have the same naming schema as their counterparts based on daily calculations but with the “cumm” suffix. 2.- phenologicaletages.csv This file contains a description of the different types of phenological stages considered. The fields are: · itainnovaid: this is an identifier of the phenological stage. · bbch: the number of stage in the BBCH phenological stage. · Descripción BBCH: this is a textual description of the previous BBCH phenological stage. The contents of the file are as follows: itainnovaid bbch Descripción BBCH 0 0 Winter dormancy or resting period 3 63 Early flowering: 30% of flowerhoods fallen 1 11 First leaf unfolded and spread away from shoot 2 15 5 leaves unfolded 4 65 Full flowering: 50% of flowerhoods fallen 6 71 Fruit set: young fruits begin to swell, remains of flowers 5 68 80% of flowerhoods fallen 7 75 50% of fruits have reached final size or fruit has reached 50% of final size 8 77 70% of fruits have reached final size or fruit has reached 70% of final size 9 81 Beginning of ripening or fruit colouration 3.- estaciones_meteorologicas.csv This file contains disaggregated information regarding the georeference of each meteorological station used to obtain the meteorological data for powdery_mildew_dataset.csv. The fields are: · indicativo: the ID of the meteorological station. · año: year when there has been data collection in that meteorological station. · alt: altitude of the meteorological station. · long: longitude of the meteorological station. · lat: latitude of the meteorological station 4.- cadastral_data.csv This file contains disaggregated information regarding the georeference of each vineyard parcel included in powdery_mildew_dataset.csv. The fields are: · codigo: the ID of the vineyard parcel. · longitude: longitude of the vineyard parcel. · latitude: latitude of the vineyard parcel. · altitud: altitude of the vineyard parcel.