LAND-deFeND - An innovative database structure for landslides and floods and their consequences

Area of Science:

• Geosciences
• Environmental Science
• Data Management

Background:

• Understanding geo-hydrological hazards like landslides and floods is crucial for assessing risks and impacts.
• Existing databases often lack the capacity to comprehensively manage data on both phenomena, their consequences, and remediation actions.
• Current structures may be outdated or not designed for detailed information on single events or damage quantification.

Purpose of the Study:

• To present the LANDslides and Floods National Database (LAND-deFeND), a novel database structure.
• To enable the storage, organization, and management of spatial information on landslides and floods from various sources.
• To provide a unified digital structure for comprehensive geo-hydrological hazard data management.

Main Methods:

• Development of a database structure with four entity groups: nature-related, human-related, geospatial-related, and information-source-related.
• Definition of key nature-related entities: phenomenon, event, and trigger.
• Implementation of a physical model with 32 tables and 10 views, ensuring compliance with EC INSPIRE and Floods Directives.

Main Results:

• The LAND-deFeND database structure can store and organize diverse spatial information on geo-hydrological hazards.
• It effectively manages data on phenomena, events, and their triggers, linking nature-related and human-related entities.
• The database design includes specific views for compliance with European directives.

Conclusions:

• LAND-deFeND offers an open and freely available solution for managing complex geo-hydrological hazard data.
• This database structure enhances the understanding of hazard dynamics, frequency, and impact.
• It supports improved disaster risk assessment and management through integrated data organization.