Margot L.

Processing of Breton land use data (MOS) on PostgreSQL (pgadmin) via QGIS queries and geoprocessing, development of a data visualization and mapping tool, Apache Superset, to provide decision support for future land use planning (ZAN law). Markdown, HTML, CSS, JSON syntax used to create the tool. Automation of web data download and addition to the database via Python script. Involvement in QGIS plugin development projects using QTDesigner and Python. Involvement in updating data in an R Shiny dashboard. User assistance with processing and representing geographic information in their daily use. Training agents on the Apache Superset tool. Procedure creation.

Remote work. Updating cadastral data, geolocating vineyard parcels (CVI) in departments 24 and 47. Data correction and merging. Creation of a QGIS mapping project for mandatory control of flavescence dorée and insect trapping. Proposal for the development of an Input mobile mapping project connected to a Mergin cloud to transition the annual survey from paper to digital format. Surveyors now all work on the application, networked, thus avoiding collecting data on paper, manually entering data into mapping software, and preventing data entry errors. Time savings: 3 months/year for the federation. Automation of cadastral/CVI data processing (Excel workflows) upon output of results and cartographic atlases in QGIS via Model Builder (7 models created) as well as mail merge for letters to winegrowers. Training staff on QGIS and the mobile application. Writing procedures and explanatory videos.

On the theme of food and sex trapping of vine pests (Eudemis - Cochylis - Flavescence dorée) in the Libournais region; Updating the MCD to integrate new data, creating the new structure. Harmonization of trapping data and processing for integration into the database. Database integration and creation of views for data consultation via phpmyadmin. SQL queries. Data consultation: Creation of maps via QGIS: adding this data by exporting from the database view, symbology. Automation of all weekly map production steps during the season via QGIS Model Builder.