SQL database about soil bioengineering techniques for
riverbank protection

Delphine Jaymond, André Evette, Frédéric Bray, André Torre, Vincent Breton

► To cite this version:

Delphine Jaymond, André Evette, Frédéric Bray, André Torre, Vincent Breton. SQL database about soil bioengineering techniques for riverbank protection. SER Europe conference 2018: Restoration in the Era of Climate Change, Sep 2018, Reykjavik, Iceland. pp.1, 2018, 10.13140/RG.2.2.14082.49602. hal-02607892

HAL Id: hal-02607892

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

Submitted on 2 Apr 2025

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>
# SQL database about soil bioengineering techniques for riverbank protection

Jaymond D., Evette A., Bray F., Torre A., Breton V.

Contact : Delphine Jaymond; delphine.jaymond@irstea.fr

## Why a database on soil bioengineering techniques ?

Soil bioengineering for riverbank protection is defined as the inclusion of vegetation into engineering design to protect riverbanks from erosion and other shallow slope failure (Clark et Hellin 1996, Schiechtl et Stern 1996)

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

* Lack of knowledge : obstacle to the development of bioengineering techniques

* No specific database about bioengineering structures with very detailed information on techniques used

* 2 aims :

* to enable managers to know what type of bioengineering constructions are located near them.

* to collect data for scientific purposes.

## Free access to inform managers and the public

* Prototype available online on https://genibiodiv.irstea.fr/ (English version available)

* New structures regularly uploaded

* Dynamic map to see the data

* Possibility of downloading PDF files for each structure to have more details

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

## SQL structure of the database

<figure><img src="image_4.png" /><figcaption>Relational diagram of the database</figcaption></figure>

* Data will be sent to RiverWiki

* Management by Irstea's IT team

* Internal server in the lab

* Linked to pre-existing databases

## Our project

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