“FraneItalia” is a catalog of landslide events occurring in the Italian territory. The catalog includes both fatal landslide events and events that did not produce physical harm to people. It is being populated, since January 2010, searching relevant news from online sources.
Calvello M, Pecoraro G (2018). FraneItalia: a catalog of recent Italian landslides. Geoenvironmental Disasters, 5:13. DOI: 10.1186/s40677-018-0105-5
Landslide events are classified considering two numerosity categories and three consequence categories. The numerosity categories are: single landslide events (SLE), for records only reporting one landslide; and areal landslide events (ALE), for records referring to multiple landslides triggered by the same cause in the same geographic area. Both SLEs and ALEs are divided in three consequence categories according to whether the event produced victims and/or missing people (C1, very severe), injured persons and/or evacuations (C2, severe), or did not cause any physical harm to people (C3, minor). A single set of geographic coordinates is assigned to each record of the database, both for single and areal landslide events. The uncertainty related to the position of SLEs is specified by means of three confidence descriptors, while the coordinates attributed to ALEs are always indicative and are meant to approximately identify the geographical region affected by the mentioned landslides. The temporal uncertainty related to the occurrence of the landslide events is specified by means of two confidence descriptors. The uncertainty associated to the number of landslides in ALEs is specified by means of two descriptors. A set of constraints is adopted to guarantee the correctness and semantic integrity of the inserted records.
A PostgreSQL® server must be running on the computer where the FraneItalia catalog structure is restored. Post-GIS®, the spatial database extender for PostgreSQL®, is also required and can be installed using the StackBuilder, a package manager that can be used to download and install additional PostgreSQL® tools and drivers.
Once all the software is installed, the following procedure for the restoration of the catalog can be executed from the pgAdmin® client (an open source software for the management of PostgreSQL® inventories):
- double click on the ‘Server’ node icon;
- right-click on ‘Databases’ and choose ‘Create…’ item;
- in the ‘New Database’ dialog window the user can conveniently choose the name ‘FraneItalia’ to exploit immediately the QGIS® interface described at the end of this section;
- once the new database has been created, a right-click allows to choose the ‘Restore’ item, and to access the corresponding item to restore the dump file of the catalog structure.
The current version of FraneItalia has been tested using PostgreSQL® 9.6.8, pgAdmin4 and PostgGIS® 2.3.7. To facilitate the use and the spatial analysis of the FraneItalia catalog, a QGIS® project for the visualization of the tables and maps is also provided. The QGIS® project is provided together with the dump file. It assumes that the new PostgreSQL® inventory is named ‘FraneItalia’, and is running on the ‘localhost’ server available through the standard 5432 port. To use directly the QGIS® project, QGIS® must be installed on the same computer running the PostgreSQL® server. The QGIS® project has been tested using the QGIS® releases 2.18 and 3.03.