# DiverCILand : Diversity of Crops In Landscape, a data management tool dedicated to rust disease prevention at landscape level

Yannick de Oliveira, Mélanie Polart-Donat

► To cite this version:

Yannick de Oliveira, Mélanie Polart-Donat. DiverCILand : Diversity of Crops In Landscape, a data management tool dedicated to rust disease prevention at landscape level. RustWatch final project meeting, NIAB; Aarhus University, Aug 2022, Cambridge (GB), United Kingdom. hal-04577658

HAL Id: hal-04577658

https://hal.inrae.fr/hal-04577658

Submitted on 16 May 2024

HAL is a multi-disciplinary open access
archive for the deposit and dissemination of sci-
entific research documents, whether they are pub-
lished or not. The documents may come from
teaching and research institutions in France or
abroad, or from public or private research centers.

L'archive ouverte pluridisciplinaire HAL, est
destinée au dépôt et à la diffusion de documents
scientifiques de niveau recherche, publiés ou non,
émanant des établissements d'enseignement et de
recherche français ou étrangers, des laboratoires
publics ou privés.

<figure><img src="image_1.png" /></figure>

Distributed under a Creative Commons Attribution 4.0 International License
# DiverCILand : Diversity of Crops In Landscape, a data management tool dedicated to rust disease prevention at landscape level

Yannick de Oliveira, Mélanie Polart-Donat

► To cite this version:

Yannick de Oliveira, Mélanie Polart-Donat. DiverCILand : Diversity of Crops In Landscape, a data management tool dedicated to rust disease prevention at landscape level. RustWatch final project meeting, NIAB; Aarhus University, Aug 2022, Cambridge (GB), United Kingdom. hal-04577658

HAL Id: hal-04577658

https://hal.inrae.fr/hal-04577658v1

Submitted on 16 May 2024

HAL is a multi-disciplinary open access
archive for the deposit and dissemination of sci-
entific research documents, whether they are pub-
lished or not. The documents may come from
teaching and research institutions in France or
abroad, or from public or private research centers.

L'archive ouverte pluridisciplinaire HAL, est
destinée au dépôt et à la diffusion de documents
scientifiques de niveau recherche, publiés ou non,
émanant des établissements d'enseignement et de
recherche français ou étrangers, des laboratoires
publics ou privés.

<figure><img src="image_1.png" /></figure>

Distributed under a Creative Commons Attribution 4.0 International License
# DiverCILand : Diversity of Crops In Landscape, a data management tool dedicated to rust disease prevention at landscape level

Mélanie Polart-Donat & Yannick De Oliveira

ABISOFT team, GQE- Le Moulon

<figure><img src="image_2.png" /></figure>

RUSTWATCH
WHEAT RUST EARLY WARNING

<figure><img src="image_3.png" /></figure>

Le Moulon
GÉNÉTIQUE
QUANTITATIVE
ET ÉVOLUTION

INRAO
la science pour la vie, l'humain, la terre
# DiverCILand : Diversity of Crops In Landscape, a data management tool dedicated to rust disease prevention at landscape level

Mélanie Polart-Donat & Yannick De Oliveira

ABISOFT team, GQE- Le Moulon

<figure><img src="image_2.png" /></figure>

RUSTWATCH
WHEAT RUST EARLY WARNING

<figure><img src="image_3.png" /></figure>

Le Moulon
GÉNÉTIQUE
QUANTITATIVE
ET ÉVOLUTION

INRAO
la science pour la vie, l'humain, la terre
# OVERVIEW OF A NEW TOOL - DIVERCILAND

**DiverCILand** - Diversity of Crops In Landscape "A web application with associated database"

Under the terms of the GNU AFFERO General Public License

→ Can be **redistributed** and/or **modified**

<figure><img src="image_4.png" /></figure>

Free as in Freedom

**Data management**

* Varieties description and management of DUS (Distinctness, Uniformity and Stability) and VCUS (Value for Cultivation, Use, and Sustainability) data

* Description of crops landscape

* Genotyping rust resistance genes

**Data visualization and export**

* Variety data card

* Varieties life cycle and deployment

* Mapping varieties deployment at European scale

* Genotyping data tables

Two user status in DiverCILand:

→ Admin: can access data management and data visualization and export

→ Read only: can access data visualization and export
# OVERVIEW OF A NEW TOOL - DIVERCILAND

**DiverCILand** - Diversity of Crops In Landscape "A web application with associated database"

Under the terms of the GNU AFFERO General Public License

→ Can be **redistributed** and/or **modified**

<figure><img src="image_4.png" /></figure>

Free as in Freedom

**Data management**

* Varieties description and management of DUS (Distinctness, Uniformity and Stability) and VCUS (Value for Cultivation, Use, and Sustainability) data

* Description of crops landscape

* Genotyping rust resistance genes

**Data visualization and export**

* Variety data card

* Varieties life cycle and deployment

* Mapping varieties deployment at European scale

* Genotyping data tables

Two user status in DiverCILand:

→ Admin: can access data management and data visualization and export

→ Read only: can access data visualization and export
# DIVERCILAND ADMIN INTERFACES – LOAD DATA

Two ways to submit data in DiverCILand

## Land Unit Management

### Create / Update

Name:

<figure><img src="image_5.png" /></figure>

Country:

<figure><img src="image_6.png" /></figure>

Nuts:

<figure><img src="image_7.png" /></figure>

Code:

<figure><img src="image_8.png" /></figure>

Create

Clear

### Load from file

Select the file to upload :

Parcourir...

Aucun fichier sélectionné.

<figure><img src="image_9.png" /></figure>

Create from file

Update from file

Get a template file

With a form

* Creates one object at a time

* Only available for some data types

With a file (CSV format)

* Creates one or several objects at a time

* Available for all data types
# DIVERCILAND ADMIN INTERFACES – LOAD DATA

Two ways to submit data in DiverCILand

## Land Unit Management

### Create / Update

Name:

<figure><img src="image_5.png" /></figure>

Country:

<figure><img src="image_6.png" /></figure>

Nuts:

<figure><img src="image_7.png" /></figure>

Code:

<figure><img src="image_8.png" /></figure>

Create

Clear

### Load from file

Select the file to upload :

Parcourir...

Aucun fichier sélectionné.

Create from file

Update from file

Get a template file

With a form

* Creates one object at a time

* Only available for some data types

With a file (CSV format)

* Creates one or several objects at a time

* Available for all data types
# VARIETIES RECORDED IN THE DATABASE

Data collected by Florence Dubs, Rémi Perronne and Jérôme Enjalbert

<figure><img src="image_10.png" /></figure>
# VARIETIES RECORDED IN THE DATABASE

Data collected by Florence Dubs, Rémi Perronne and Jérôme Enjalbert

<figure><img src="image_9.png" /></figure>
# DEPLOYMENT DATA OVERVIEW

Data collected by Florence Dubs, Rémi Perronne and Jérôme Enjalbert

<figure><img src="image_11.png" /></figure>

Uncontinuous time scale

<figure><img src="image_12.png" /></figure>

Continuous time scale

<table><thead><tr><th>Country</th><th>How data have been computed</th><th>Local data</th><th>1967</th><th>1981</th><th>1991</th><th>1998</th><th>2000</th><th>2005</th><th>2010</th><th>2015</th><th>2019</th></tr></thead><tbody><tr><td>Austria</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Czech republic</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Denmark</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Finland</td><td>calculated raw data</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>France</td><td>raw data (area)</td><td>yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Germany</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Great Britain</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Ireland</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Italy</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Netherlands</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Poland</td><td>raw data (percentage)</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Romania</td><td>calculated raw data</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Slovakia</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Spain</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Sweden</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Switzerland</td><td>raw data (area)</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>
# DEPLOYMENT DATA OVERVIEW

Data collected by Florence Dubs, Rémi Perronne and Jérôme Enjalbert

<figure><img src="image_10.png" /></figure>

Uncontinuous time scale

<figure><img src="image_11.png" /></figure>

Continuous time scale

<table><thead><tr><th>Country</th><th>How data have been computed</th><th>Local data</th><th>1967</th><th>1981</th><th>1991</th><th>1998</th><th>2000</th><th>2005</th><th>2010</th><th>2015</th><th>2019</th></tr></thead><tbody><tr><td>Austria</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Czech republic</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Denmark</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Finland</td><td>calculated raw data</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>France</td><td>raw data (area)</td><td>yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Germany</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Great Britain</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Ireland</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Italy</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Netherlands</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Poland</td><td>raw data (percentage)</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Romania</td><td>calculated raw data</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Slovakia</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Spain</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Sweden</td><td>computed from multiplication</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Switzerland</td><td>raw data (area)</td><td>no</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>
RUST RESISTANCE VCUS DATA

Data collected by Florence Dubs, Rémi Perronne and Jérôme Enjalbert

<figure><img src="image_13.png" /></figure>

Yellow Rust

<figure><img src="image_14.png" /></figure>

Leaf Rust

<figure><img src="image_15.png" /></figure>

Stem Rust

<table><thead><tr><th rowspan="2">Country</th><th rowspan="2">Nb of Accession</th><th colspan="5"></th><th colspan="5"></th></tr><tr><th>1963</th><th>1970</th><th>1991</th><th>1996</th><th>2000</th><th>2005</th><th>2010</th><th>2015</th><th>2020</th></tr></thead><tbody><tr><td rowspan="3">Austria</td><td>215</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>228</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>226</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="3">Czech republic</td><td>136</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>163</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>33</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="2">Denmark</td><td>73</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>81</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Finland</td><td>92</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="2">France</td><td>1029</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>407</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="2">Germany</td><td>465</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>128</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="2">Great Britain</td><td>128</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>73</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="2">Hungary</td><td>108</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>112</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="3">Italy</td><td>125</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>142</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>56</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="2">Netherlands</td><td>115</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>126</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="2">Poland</td><td>117</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>154</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="3">Spain</td><td>148</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>163</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>83</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="2">Sweden</td><td>98</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>95</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="3">Switzerland</td><td>142</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>138</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>27</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>
RUST RESISTANCE VCUS DATA

Data collected by Florence Dubs, Rémi Perronne and Jérôme Enjalbert

<figure><img src="image_12.png" /></figure>

Yellow Rust

<figure><img src="image_13.png" /></figure>

Leaf Rust

<figure><img src="image_14.png" /></figure>

Stem Rust

<table><thead><tr><th rowspan="2">Country</th><th rowspan="2">Nb of Accession</th><th colspan="5"></th><th colspan="5"></th></tr><tr><th>1963</th><th>1970</th><th>1991</th><th>1996</th><th>2000</th><th>2005</th><th>2010</th><th>2015</th><th>2020</th></tr></thead><tbody><tr><td rowspan="3">Austria</td><td>215</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>228</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>226</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="3">Czech republic</td><td>136</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>163</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>33</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="2">Denmark</td><td>73</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>81</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>Finland</td><td>92</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="2">France</td><td>1029</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>407</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="2">Germany</td><td>465</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>128</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="2">Great Britain</td><td>128</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>73</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="2">Hungary</td><td>108</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>112</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="3">Italy</td><td>125</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>142</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>56</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="2">Netherlands</td><td>115</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>126</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="2">Poland</td><td>117</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>154</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="3">Spain</td><td>148</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>163</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>83</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="2">Sweden</td><td>98</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>95</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td rowspan="3">Switzerland</td><td>142</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>138</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>27</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>
EXAMPLES OF DATA VISUALIZATION IN DIVERCILAND

<figure><img src="image_16.png" /></figure>

## Accession's data card

* Accessible from search bar or accession viewer

* Displays information on the accession for several countries by using the country selector

* Presents catalogue data oldest and latest values, next to each trait

* History of values is viewable on a graph
EXAMPLES OF DATA VISUALIZATION IN DIVERCILAND

<figure><img src="image_15.png" /></figure>

## Accession's data card

* Accessible from search bar or accession viewer

* Displays information on the accession for several countries by using the country selector

* Presents catalogue data oldest and latest values, next to each trait

* History of values is viewable on a graph
# EXAMPLES OF DATA VISUALIZATION IN DIVERCILAND

## Life Cycle Viewer

<figure><img src="image_17.png" /></figure>

Percentages of cultivated acreages vs. years in Denmark

<figure><img src="image_18.png" /></figure>

## Life cycle viewer

<figure><img src="image_19.png" /></figure>

Allows to select desired accessions and range of years to represent on the graph

## Variety repartition viewer

<figure><img src="image_20.png" /></figure>

<figure><img src="image_21.png" /></figure>

Represent variety deployment at land unit scale

<figure><img src="image_22.png" /></figure>

Allows to export the data represented on the pie chart (only if the user has an admin status)

<figure><img src="image_23.png" /></figure>
# EXAMPLES OF DATA VISUALIZATION IN DIVERCILAND

## Life Cycle Viewer

<figure><img src="image_16.png" /></figure>

Percentages of cultivated acreages vs. years in Denmark

<figure><img src="image_17.png" /></figure>

## Life cycle viewer

<figure><img src="image_18.png" /></figure>

Allows to select desired accessions and range of years to represent on the graph

## Variety repartition viewer

<figure><img src="image_19.png" /></figure>

<figure><img src="image_20.png" /></figure>

* Represent variety deployment at land unit scale

<figure><img src="image_21.png" /></figure>

* Allows to export the data represented on the pie chart (only if the user has an admin status)

Repartition of cultivated acreages (%) by varieties: Czech Republic (CZ) in 2010

<figure><img src="image_22.png" /></figure>

Accession

<figure><img src="image_23.png" /></figure>

<figure><img src="image_24.png" /></figure>

<figure><img src="image_25.png" /></figure>

<figure><img src="image_26.png" /></figure>

<figure><img src="image_27.png" /></figure>

<figure><img src="image_28.png" /></figure>

<figure><img src="image_29.png" /></figure>

<figure><img src="image_30.png" /></figure>

<figure><img src="image_31.png" /></figure>
EXAMPLES OF DATA VISUALIZATION IN DIVERCILAND

Variety Repartition Map in 2008

2008

<figure><img src="image_24.png" /></figure>

Repartition on map

➤ Displays the deployment of the varieties on the landscape for European countries

<figure><img src="image_25.png" /></figure>

Repartition of cultivated acreages (%) by varieties (DE, 2008)

<figure><img src="image_26.png" /></figure>

➤ A detailed view is accessible by clicking on the pie charts
EXAMPLES OF DATA VISUALIZATION IN DIVERCILAND

Variety Repartition Map in 2008

2008

<figure><img src="image_32.png" /></figure>

Repartition on map

➤ Displays the deployment of the varieties on the landscape for European countries

<figure><img src="image_33.png" /></figure>

Repartition of cultivated acreages (%) by varieties (DE, 2008)

<figure><img src="image_34.png" /></figure>

➤ A detailed view is accessible by clicking on the pie charts
EXAMPLES OF DATA VISUALIZATION IN DIVERCILAND

<figure><img src="image_27.png" /><figcaption>Trait Deployment Map in 2015</figcaption></figure>

2015

<figure><img src="image_28.png" /></figure>

Trait data repartition on map

* Displays the resistance values to yellow rust according to the deployment of the varieties on the landscape for European countries

<figure><img src="image_29.png" /><figcaption>Resistance to Yellow rust</figcaption></figure>

<figure><img src="image_30.png" /></figure>

* A detailed view is accessible by clicking on the pie charts

* Data has been converted to a common scale: 1 (sensitive) → 5 (resistant)

* This scale is not an established standard
EXAMPLES OF DATA VISUALIZATION IN DIVERCILAND

<figure><img src="image_35.png" /><figcaption>Trait Deployment Map in 2015</figcaption></figure>

2015

<figure><img src="image_36.png" /></figure>

Trait data repartition on map

* Displays the resistance values to yellow rust according to the deployment of the varieties on the landscape for European countries

<figure><img src="image_37.png" /><figcaption>Resistance to Yellow rust</figcaption></figure>

* A detailed view is accessible by clicking on the pie charts

* Data has been converted to a common scale: 1 (sensitive) → 5 (resistant)

* This scale is not an established standard
EXAMPLES OF DATA VISUALIZATION IN DIVERCILAND

Trait data repartition on map

* Displays the resistance values to yellow rust according to the deployment of the varieties on the landscape for European countries

2015

<figure><img src="image_31.png" /></figure>

2016

<figure><img src="image_32.png" /></figure>

AT, 2015

Resistance to Yellow rust

<figure><img src="image_33.png" /></figure>

<figure><img src="image_34.png" /></figure>

<figure><img src="image_35.png" /></figure>

<figure><img src="image_36.png" /></figure>

AT, 2016

Resistance to Yellow rust

* A detailed view is accessible by clicking on the pie charts

* Data has been converted to a common scale: 1 (sensitive) → 5 (resistant)

* This scale is not an established standard
# EXAMPLES OF DATA VISUALIZATION IN DIVERCILAND

## Trait data repartition on map

* Displays the resistance values to yellow rust according to the deployment of the varieties on the landscape for European countries

2015

<figure><img src="image_38.png" /></figure>

2016

<figure><img src="image_39.png" /></figure>

AT, 2015

Resistance to Yellow rust

<figure><img src="image_40.png" /></figure>

<figure><img src="image_41.png" /></figure>

<figure><img src="image_42.png" /></figure>

<figure><img src="image_43.png" /></figure>

AT, 2016

Resistance to Yellow rust

* A detailed view is accessible by clicking on the pie charts

* Data has been converted to a common scale: 1 (sensitive) → 5 (resistant)

* This scale is not an established standard
# COMMON SCALE – EXAMPLE OF YELLOW RUST

Table made by Florence Dubs to convert countries' scales to a common scale for DiverCILand

<table><thead><tr><th></th><th>scale FR</th><th colspan="2">scale AT</th><th colspan="2">scale NL</th><th colspan="2">scale CH</th></tr></thead><tbody><tr><th scope="row">Résistant</th><td>9 résistant</td><td>1</td><td>1 = resistant</td><td>9 ; 9,5</td><td>9</td><td>tres_bonne</td><td>tres bon</td><td>+++</td></tr><tr><th scope="row">Résistant mais attaqué</th><td>8 assez résistant à résistant</td><td>2 ; 2.5</td><td></td><td>8 ; 8.5</td><td>8</td><td>bonne_a_très_bonne</td><td>bon</td><td>++(+)</td></tr><tr><th scope="row">Résistant mais attaqué</th><td>7 assez résistant</td><td>3 ; 3,5</td><td></td><td>7 ; 7.5</td><td>7</td><td>bonne</td><td>bon</td><td>++</td></tr><tr><th scope="row">Moyennement sensible</th><td>6 peu sensible</td><td>4 ; 4.5</td><td></td><td>6 ; 6.5</td><td>6</td><td>moyenne_a_bonne</td><td>suffisant</td><td>+(+)</td></tr><tr><th scope="row">Moyennement sensible</th><td>5 assez sensible a peu sensible</td><td>5 ; 5.5</td><td></td><td>5 ; 5.5</td><td>5</td><td>bonne_a_moyenne</td><td>suffisant</td><td>+</td></tr><tr><th scope="row">Assez sensible</th><td>4 assez sensible</td><td>6 ; 6.5</td><td></td><td>4</td><td>4</td><td>moyenne</td><td>moyenne</td><td>Ø</td></tr><tr><th scope="row">Assez sensible</th><td>3 sensible à très sensible</td><td>7</td><td></td><td>3.5</td><td>3</td><td>moyenne_a_faible</td><td>insuffisant</td><td>- ; -(-)</td></tr><tr><th scope="row">Sensible</th><td>2 sensible</td><td>8</td><td></td><td>2</td><td>2</td><td>faible</td><td>mauvais</td><td>-- , -(-)</td></tr><tr><th scope="row">Sensible</th><td>1 très sensible</td><td>9</td><td>9 = very susceptible</td><td>1</td><td>1</td><td>tres_faible</td><td>très mauvai</td><td>---</td></tr></tbody></table>

<table><thead><tr><th></th><th>scale IT</th><th colspan="2">scale HU</th></tr></thead><tbody><tr><th scope="row">Résistant</th><td></td><td>1 Resistant</td><td></td></tr><tr><th scope="row">Résistant mais attaqué</th><td>Resistante</td><td>2 Moderately resistant</td><td></td></tr><tr><th scope="row">Moyennement sensible</th><td>Moderatamente resistante</td><td>3 Moderately susceptible</td><td></td></tr><tr><th scope="row">Assez sensible</th><td>Moderatamente suscettible</td><td>4 More responsive than medium</td><td></td></tr><tr><th scope="row">Sensible</th><td>Suscettible</td><td>5 Very responsive</td><td></td></tr></tbody></table>
# COMMON SCALE – EXAMPLE OF YELLOW RUST

Table made by Florence Dubs to convert countries' scales to a common scale for DiverCILand

<table><thead><tr><th></th><th>scale FR</th><th colspan="2">scale AT</th><th colspan="2">scale NL</th><th colspan="2">scale CH</th></tr></thead><tbody><tr><th scope="row">Résistant</th><td>9 résistant</td><td>1</td><td>1 = resistant</td><td>9 ; 9,5</td><td>9</td><td>tres_bonne</td><td>tres bon</td><td>+++</td></tr><tr><th scope="row">Résistant mais attaqué</th><td>8 assez résistant à résistant</td><td>2 ; 2.5</td><td></td><td>8 ; 8.5</td><td>8</td><td>bonne_a_très_bonne</td><td></td><td>++(+)</td></tr><tr><th scope="row"></th><td>7 assez résistant</td><td>3 ; 3,5</td><td></td><td>7 ; 7.5</td><td>7</td><td>bonne</td><td>bon</td><td>++</td></tr><tr><th scope="row">Moyennement sensible</th><td>6 peu sensible</td><td>4 ; 4.5</td><td></td><td>6 ; 6.5</td><td>6</td><td>moyenne_a_bonne</td><td></td><td>+(+)</td></tr><tr><th scope="row"></th><td>5 assez sensible a peu sensible</td><td>5 ; 5.5</td><td></td><td>5 ; 5.5</td><td>5</td><td>bonne_a_moyenne</td><td>suffisant</td><td>+</td></tr><tr><th scope="row">Assez sensible</th><td>4 assez sensible</td><td>6 ; 6.5</td><td></td><td>4</td><td>4</td><td>moyenne</td><td>moyenne</td><td>Ø</td></tr><tr><th scope="row"></th><td>3 sensible à très sensible</td><td>7</td><td></td><td>3.5</td><td>3</td><td>moyenne_a_faible</td><td>insuffisant</td><td>- ; -(-)</td></tr><tr><th scope="row">Sensible</th><td>2 sensible</td><td>8</td><td></td><td>2</td><td>2</td><td>faible</td><td>mauvais</td><td>-- , --(-)</td></tr><tr><th scope="row"></th><td>1 très sensible</td><td>9</td><td>9 = very susceptible</td><td>1</td><td>1</td><td>tres_faible</td><td>très mauvai</td><td>---</td></tr></tbody></table>

<table><thead><tr><th></th><th>scale IT</th><th colspan="2">scale HU</th></tr></thead><tbody><tr><th scope="row">Résistant</th><td></td><td>1 Resistant</td><td></td></tr><tr><th scope="row">Résistant mais attaqué</th><td>Resistante</td><td>2 Moderately resistant</td><td></td></tr><tr><th scope="row">Moyennement sensible</th><td>Moderatamente resistante</td><td>3 Moderately susceptible</td><td></td></tr><tr><th scope="row">Assez sensible</th><td>Moderatamente suscettible</td><td>4 More responsive than medium</td><td></td></tr><tr><th scope="row">Sensible</th><td>Suscettible</td><td>5 Very responsive</td><td></td></tr></tbody></table>
# EXAMPLES OF DATA VISUALIZATION IN DIVERCILAND

<figure><img src="image_37.png" /><figcaption>## Candidate Gene Deployment Map in 2011</figcaption></figure>

## Candidate gene repartition on map

* Displays the repartition of candidate genes according to the deployment of the varieties on the landscape for European countries

<figure><img src="image_38.png" /></figure>

<figure><img src="image_39.png" /></figure>

* Data of each country is accessible by clicking on the histogram icon on the map
# EXAMPLES OF DATA VISUALIZATION IN DIVERCILAND

<figure><img src="image_44.png" /><figcaption>## Candidate Gene Deployment Map in 2011</figcaption></figure>

## Candidate gene repartition on map

* Displays the repartition of candidate genes according to the deployment of the varieties on the landscape for European countries

### Gene deployment

<figure><img src="image_45.png" /></figure>

### Weighted by number of varieties (%) (FR, 2011)

<figure><img src="image_46.png" /></figure>

* Data of each country is accessible by clicking on the histogram icon on the map
# EXAMPLES OF DATA VISUALIZATION IN DIVERCILAND

## Marker Deployment Map in 2018

2018 v

## Marker repartition on map

* Displays the Minor Allelic Frequency (MAF) of markers and the MAF according to the deployment of the varieties on the landscape for European countries

<figure><img src="image_40.png" /></figure>

<figure><img src="image_41.png" /></figure>

* Data of each country is accessible by clicking on the histogram icon on the map
# EXAMPLES OF DATA VISUALIZATION IN DIVERCILAND

## Marker Deployment Map in 2018

2018 v

## Marker repartition on map

<figure><img src="image_47.png" /></figure>

* Displays the Minor Allelic Frequency (MAF) of markers and the MAF according to the deployment of the varieties on the landscape for European countries

<figure><img src="image_48.png" /></figure>

<figure><img src="image_49.png" /></figure>

<figure><img src="image_50.png" /></figure>

* Data of each country is accessible by clicking on the histogram icon on the map

NA data (accessions without genotyping data) have been removed and the representation is based on 16 accessions instead of 369.
→ Management of user access to data

→ The results of a survey addressed to data providers showed that they were interested in the administration of their data in DiverCILand

→ Such data curation requires the partition data into datasets, enabling partners to do data management with secured access

→ Development of webservices (Django REST framework) to interact with other IT frameworks and especially with the Wheat Rust Toolbox (prototype done)

→ Funding (modest!): French project Co-Breeding (ANR – PEPR Agroecology and digital data)
→ Management of user access to data

→ The results of a survey addressed to data providers showed that they were interested in the administration of their data in DiverCILand

→ Such data curation requires the partition data into datasets, enabling partners to do data management with secured access

→ Development of webservices (Django REST framework) to interact with other IT frameworks and especially with the Wheat Rust Toolbox (prototype done)

→ Funding (modest!): French project Co-Breeding (ANR – PEPR Agroecology and digital data)
ACKNOWLEDGMENTS

Yannick De Oliveira, Software engineer, ABISOFT team leader

Jérôme Enjalbert, Florence Dubs, Remi Perronne, scientific collaborators and data managers

And all the data providers:

<figure><img src="image_42.png" /></figure>

Anders Sondergaard Larsen

<figure><img src="image_43.png" /></figure>

Biagio Randazzo & Anna Giulini

<figure><img src="image_44.png" /></figure>

Nerea Arias & Amaia Caballero Iturri

<figure><img src="image_45.png" /></figure>

Dario Fossati & Fabio Mascher

<figure><img src="image_46.png" /></figure>

József Czapó & Gyula Vida

<figure><img src="image_47.png" /></figure>

Pavel Kraus & Alena Hanzalova

<figure><img src="image_48.png" /></figure>

Pawel Czembor & Tadeusz Oleksiak

<figure><img src="image_49.png" /></figure>

Gunilla Berg & Jannie Hagman

<figure><img src="image_50.png" /></figure>

Katarina Bučkova

<figure><img src="image_51.png" /></figure>

Marianna Ittu

<figure><img src="image_52.png" /></figure>

Lucy James

<figure><img src="image_53.png" /></figure>

Lubbert van den Brink

<figure><img src="image_54.png" /></figure>

Marja Jalli

<figure><img src="image_55.png" /></figure>

Michael Oberforster

<figure><img src="image_56.png" /></figure>

Philippe du Cheyron & Valérie Cadot

<figure><img src="image_57.png" /></figure>

Steven Kildea

<figure><img src="image_58.png" /></figure>

Uta Schnock & Jan Henrik Schmidt

<figure><img src="image_59.png" /></figure>

RUSTWATCH
WHEAT RUST EARLY WARNING

<figure><img src="image_60.png" /></figure>

Le Moulon
GÉNÉTIQUE
QUANTITATIVE
ET ÉVOLUTION

INRAO
la science pour la vie, l'humain, la terre
# ACKNOWLEDGMENTS

Yannick De Oliveira, Software engineer, ABISOFT team leader

Jérôme Enjalbert, Florence Dubs, Remi Perronne, scientific collaborators and data managers

And all the data providers:

<figure><img src="image_51.png" /></figure>

Anders Sondergaard Larsen

<figure><img src="image_52.png" /></figure>

Biagio Randazzo & Anna Giulini

<figure><img src="image_53.png" /></figure>

Nerea Arias & Amaia Caballero Iturri

<figure><img src="image_54.png" /></figure>

Dario Fossati & Fabio Mascher

<figure><img src="image_55.png" /></figure>

József Czapó & Gyula Vida

<figure><img src="image_56.png" /></figure>

Pavel Kraus & Alena Hanzalova

<figure><img src="image_57.png" /></figure>

Pawel Czembor & Tadeusz Oleksiak

<figure><img src="image_58.png" /></figure>

Gunilla Berg & Jannie Hagman

<figure><img src="image_59.png" /></figure>

Katarina Bučkova

<figure><img src="image_60.png" /></figure>

Marianna Ittu

<figure><img src="image_61.png" /></figure>

Lucy James

<figure><img src="image_62.png" /></figure>

Lubbert van den Brink

<figure><img src="image_63.png" /></figure>

Marja Jalli

<figure><img src="image_64.png" /></figure>

Michael Oberforster

<figure><img src="image_65.png" /></figure>

Philippe du Cheyron & Valérie Cadot

<figure><img src="image_66.png" /></figure>

Steven Kildea

<figure><img src="image_67.png" /></figure>

Uta Schnock & Jan Henrik Schmidt

<figure><img src="image_68.png" /></figure>

RUSTWATCH
WHEAT RUST EARLY WARNING

<figure><img src="image_69.png" /></figure>

Le Moulon
GÉNÉTIQUE
QUANTITATIVE
ET ÉVOLUTION

INRAO
la science pour la vie, l'humain, la terre