# QR-CODE PROJECT: Towards better traceability of field sampling data

Christine Plumejeaud-Perreau, Hector Linyer, Cécile Pignol, Sébastien Cipiere, Eric Quinton, Julien Ancelin, Wilfried Heintz, Sylvie Damy, Francis Raoul, Anne Clemens, et al.

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

## To cite this version:

Christine Plumejeaud-Perreau, Hector Linyer, Cécile Pignol, Sébastien Cipiere, Eric Quinton, et al. QR-CODE PROJECT: Towards better traceability of field sampling data. International Long Term Ecological Research Network (ILTER) & Zones Ateliers & Critical Zone Observatory Networks (LTER-France) Joint conference, Oct 2017, Nantes, France., 1 p., 2017. [hal-02788457](https://hal.inrae.fr/hal-02788457)

HAL Id: hal-02788457

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

Submitted on 5 Jun 2020

HAL is a multi-disciplinary open access archive for the deposit and dissemination of scientific research documents, whether they are published 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_2.png" /></figure>

Distributed under a Creative Commons Attribution - ShareAlike 4.0 International License
<figure><img src="image_3.png" /></figure>

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

### ZA Armique

12: Ecobio, UMR 6553 CNRS

13: Avenue Général Leclerc, 35042 Rennes - France

14: ZAAR "Zone Atelier Armique", LTER ZA Armique

15: UMR 6553-ECobio, Avenue Général Leclerc, 35042 Rennes - France

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

### ZA PVs

1: Littoral Environnement et Sociétés (LIENS) - UMR 7266 CNRS & Université de La Rochelle

Bâtiment IL 2, rue Olympe de Gouges 17 000 La Rochelle - France

2: LTSE" Zone Atelier Plaine & Val de Sèvre", (LTSEZ A PVs) - LTSE

4: CNRS-CEBC, F-79360, Beauvoir sur Niort, F-79360, France - France

5: Domaine Experimental de Saint Laurent de la Prée (INRA DE de Saint Laurent de la Prée) - INRA

6: 545 Rue du Bois Mâche, 17450 Saint-Laurent-de-la-Prée - France

16: Centre d'études biologiques de Chizé (CEB) - UMR 7372 CNRS et Université de La Rochelle
CNRs UMR 7372 - 79360 VILLIERS-EN-BOIS - France

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

INRA
DOUES ET MERC

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

### IRSTEA

5: Unité de recherche "Ecosystèmes aquatiques et changements globaux" (EABX) - IRSTEA

50, avenue de Verdun, Gazinet, F-33612 Cestas Cedex - France

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

### ZA PYGAR

7: UMR INRA DYNAFOR - INRA, INP-T ENSAT, ET PURPAN

Centre INRA Occitanie Toulouse 24 Chemin de Borde Rouge - Auzeville CS 52627 31326 Castanet Tolasan cedex - France

### ZA Moselle

14: Laboratoire Interdisciplinaire des Environnements Continentaux (LIEC), UMR 7360 CNRS & Université de Lorraine,

Avenue du Charmois, 54500 Vandoeuvre-les-Nancy - France

15: LTER Zone Atelier Moselle (LTER Zone Atelier Moselle) LTSE

ITFR Zone Atelier Moselle UMR 7360 CNRS-Université de Lorraine, 15 avenue du Charmois, 54500 Vandoeuvre-les-Nancy, France

### ZA Arc Jurassien

8: Chrono-environnement - UMR 6249 - CNRS & Université de Franche-Comté

La Bouolle - UFR Sciences et Techniques 16 route de Gray 25030 Besançon cedex - France

9: LTSE "Zone Atelier Arc Jurassien", (LTSEZ A ZAU) - LTSE

La Bouolle - UFR Sciences et Techniques 16 route de Gray 25030 Besançon cedex - France

### ZA Alpes

3: Environnements, Dynamiques et Territoires de la Montagne (EDYTEM) - UMR 5204 CNRS & Université de Savoie Mont Blanc,

Campus scientifique, 73376 Le Bourget du Lac cedex - France

4: LTSEZ "Zone Atelier Alpes" Univ. Grenoble Alpes, Univ. Savoie Mont Blanc, CNRS, Irstea,

LTSEZ Zone Atelier Alpes: 38000 Grenoble, France

### ZA Bassin du Rhône

10: ZABR - UMR 5023

Domaine scientifique de la Doua 66 bd Niels Bohr CS 52132 69603 Villeurbanne Cedex - France

11: Ecole des Mines de Saint Etienne (ZABR) Groupe des Écoles des Mines (GEM)

158 cours Fauriel - CS 62 362, 42023 Saint-Étienne Cedex 2 - France

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

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

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

edytem

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

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

MINES
Saint-Étienne

## Summary

Ensuring traceability of field experimental data or laboratory sampling data to conduct reproducible research is a challenge at the present time. Between the time when geolocalized specimens (biotic or abiotic) are taken, and the time the resulting data ends up in analysis published within a study, many manual operations take place and may generate errors. The French LTSEr have joined forces at the national level to propose a solution as generic as possible to this problem of monitoring of the samples and the data associated with them. Compared to existing solutions (such as Laboratory Information Management Systems), we target a robust labeling solution adapted to outdoor working conditions, with the management of stocks and movements of samples. We designed and realized a prototype tested from end to end, using an open source software (https://github.com/Irstea/collec), cheap Zebra printers (mobile or not) and raspberries as devices. This solution provides sufficient flexibility for the wide variety of existing protocols. Its strength is the record of all contextual data associated with the samples, which constitute important parameters of the subsequent analyzes. At last, not only traceability is guaranteed, but also a gain of time and a rationalization of the storage of samples that will induce a return on investment.

### Purpose

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

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

<figure><img src="image_16.png" /><figcaption>Samples stored in containers.</figcaption></figure>

### Labels

* Code machine-readable (QRCode) using a scanner

* Any human can read the label and understand written data

* Resist to hard storage and outdoor conditions

* Data situate the sample in a collection (owner, project, kind of thing)

## COLLEC-SCIENCE software

https://www.collec-science.org/

* A Web site to view how to use it:

https://www.collec-science.org/video-tutorial/

* A manuel describing a use case in details

https://www-iuem.univ-brest.fr/pops/attachments/1378

### COLLEC-SCIENCE in life

https://irsta.univ-lrfr/collec/index.php

* 2 mailing lists for users or developers

https://groupes.renater.fr/sympa/info/collec-dey

https://groupes.renater.fr/sympa/info/collec-users

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

Identification réuse :

Dénom connection : 140992017 10 21 27 depuis l'adresse IP 10 4 103 5 ce n'est pas vous, madame veuillez vous passive ou contactez l'administrateur de l'application

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

Lieu des commerces

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

Lieu des Echantillons

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

Adresse rapide d'un échantillon dans
un stock

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

Adresse / sortie par scaner multiple de
QRCode

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

Adresse rapide d'un échantillon du
stock

Copyright © 2016-2017 - Tous droits réservés. Autor : Frédéric Quantin, pour IRSTEA - Logiciel diffus eais seuls licence AGPL
Post tout problème : https://github.com/collec-deyse

The device can be used anywhere without Internet
connection: the raspberry PI3 is used as a wifi hotspot, and all
the database and Web server is embedded inside a Docker
engine. The operator simply uses a tablet, a smartphone or a
PC to fill the Web form describing its samples.

<figure><img src="image_23.png" /><figcaption>Printing device linked by Bluetooth with the raspberry.</figcaption></figure>

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

docker

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

The researcher can create its own metadata templates
describing the data to be associated with the sample.

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

Then, operators can fill a form
describing the sample using the
chosen metadata template.

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

### Informations générales

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

The labels contains a QR Code,
and informations that are
extracted from the metadata
fields.

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

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

Carre

Porcelle

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

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

<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>

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

Any kind of label formats can be printed, using Apache™ FOP (Formatting Objects Processor) as XML language integrated within COLLEC to design the shape, size and content of labels.

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

The QR code contains all the required data to find the sample inside the database, (UID, name of the database) as well essential data for ensuring the data traceability (where and when the sample was collected), using the JavaScript Object Notation.

This is an open-source project (licence AGPL v3). We have made it as generic as possible, and we can interconnect with different systems of labelling, by importing or exporting metadata schemas and identifiers of external databases.

It can be deployed anywhere (indoors/outdoors, centralized/distributed information system).

The total cost for one good thermal transfert printer (like Zebra GX430T for instance) with a professional scanner of labels is of **1000 €**.