FLOODGAMA: the new INUNGAMA. Beyond a flood events database for Catalonia

Floods represent a complex natural hazard, influenced not only by meteorological factors but also by geophysical aspects such as terrain topography, social factors such as the value of exposed assets, and cultural factors like risk awareness. For this reason, the study of these phenomena requires a holistic approach. This requires the correct organization of the information. In addition, given that the information comes from different sources, the traceability of the data must also be contrasted and preserved in order to guarantee its quality and robustness. Databases make it possible to conserve and document historical information, to analyze it and to support smart flood risk management.

With this objective in mind, in 2000 the GAMA team developed the INUNGAMA flood database, following the example of other natural hazards databases. This communication will present the new version of this database, FLOODGAMA, and the main results of its analysis. FLOODGAMA contains information on 456 flood events that affected Catalonia (NE of Spain), between 1900 and 2020, which have caused 1,253 casualties. The events are classified according to the impacts. It includes linked tables with information on event dates, descriptions, fatalities, economic damages, affected municipalities, recorded rainfall and recorded flow. Other tables contain historical marks, codifications and the geographical information of municipalities, counties, basins and rivers, as well as meteorological stations. Its structure has been simplified and standardized with Python and migrated to PostgreSQL (PostGIS) from an ACCESS format. The new database allows for more general and straightforward analysis, introduces GIS tool compatibility, and simplifies the addition of new data and new data sources. This last point has been one of the key points in this transformation as it will provide the database with the flexibility to respond to the challenges posed by the digital transformation that is currently taking place and as a tool for the improvement of adaptation.

The contribution shows the structure of this flood database and the results obtained after its analysis that allows the characterization of flood events in Catalonia.

This research has been done in the framework of the C3Riskmed project, Grant PID2020-113638RB-C22 funded by MCIN/AEI/10.13039/501100011033 and Flood2Now project, Grant PLEC2022-009403 funded by MCIN/AEI/10.13039/501100011033 and by the European Union Next Generation EU/PRTR.