DIASPARA - Electrofishing database

The DIASPARA project has created a database for electrofishing data. The database structure was first initiated during the POSE SLIME project and called dbeel. The database was further developped arround various project to gather electrofishing data for eel. These data were used to build the EDA model, a spatial distribution model of eel that allows the prediction of silver eel escapement. The SUDOANG database harmonized electrofishing datasets for eel monitoring across the Iberian Peninsula. The SUDOANG electrofishing database demonstrated the feasibility and value of structuring heterogeneous survey data into a unified framework, enabling its use in large‑scale assessments, modelling. Building on this foundation, our current work aims to adapt the SUDOANG database structure to support multispecific electrofishing surveys rather than eel‑focused datasets alone. This database is also made fully compatible with the DIADROMOUS database developed during the DIASPARA project. Furthermore, the use of a hierarchical structure provides an easy way to update data coming from regional or national authorities. This repository contains the code for building the electrofishing database in PostgreSQL and develop the excel format in support of future data calls for ICES working groups on diadroumous species.