DIASPARA - Dam database

Dam database River fragmentation induced by human obstacles is a main threat to diadromous species. By impairing their migrations in rivers, they hinder their access to critical growth or reproduction habitats and potentially impair the achievement of their life cycle. Turbines at hydropower stations, pumps are also a direct source of mortality of fish during their downstream migration, or their move within the rivers. In view of this and in a context of an ecosystem approach of fisheries management, there is a clear need to account for the impact of obstacles on the status of the species and to develop tools to prioritize restoration actions. To do so, a prerequisite is the availability of data on the location of dams as well as a set of characteristics related to their impacts, but those data are scattered, not easily available and not standardised. This database proposes a database structure that could be used to collect and store a minimal set of data across Europe to quantify the impact of dams and weirs on diadromous fish stocks. The work is based on an the DBEEL data database from the the POSE project [@walker_pilot_2011] that was developed to handle all threats for eel, and was latter extended during the (SUDOANG project)[https://sudoang.eu/en]. Here, we develop a simplified elements by removing all elements that were judged not necessary in the database structure to answer the core of the question. This simplification is critical to then simplify the data collection at a large spatial scale. The code of the table in the national database is provided. link to diaspara WP3 files The data correspond to the SQL script necessary to rebuild the database structure (no data). Detailed step table by table are presented in the report with links.