Development of a unified geographic database from separated existing data through opensource softwares, Crotone Basin, Southern Italy

The Crotone Province (Calabria - South Italy) extends for a total surface of circa 1.736 km² in which a wide spectrum of geological, geomorphological and tectonic configurations alternate from the mountainous hinterland portions towards the coastal plain settings. Through the integrated collection of data coming from separated databases such as Geoportale della Calabria, Geoportale Nazionale, Videpi Project, ARPACAL Multirisk Functional Center, CARG project, CASMEZ, a complete geodatabase which make available a wealth of different spatial and cartographic data useful for the study and monitoring of Province of Crotone was implemented through open source technologies such as Qgis and PostgreSQL. The processed data consist in: 1) A new unified Geological map obtained through the comparison of the CASMEZ 1: 25000 and CARG the 1: 50000 maps and the reinterpretation of the stratigraphies with the adaptation of the old nomenclature with the new standards defined by the CARG project; 2) Geomorphological map obtained through the integration of the available bibliography with new data coming from geoportale della Calabria; 3) Topographic and land cover maps obtained through the processing of both national and regional data; 4) Aspect, Slope and Curvature maps of the studied territory obtained using the Digital Elevation Models (DEM); 5) Rainfall and drainage density maps obtained through the re-elaboration of the ARPACAL databases; 6) Subsidence and land movements maps obtained though the processing of the ascending and descending orbit of RADARSAT 1 and 2 (Band C) satellites (2013-2018) using PSP-DIFSAR technique, and the ascending orbit of the TerraSarX satellite (X Band) and the descending orbit of the CosmoSkyMED satellite (X Band) (2013-2018) using SBAS technique. Lastly, using the qgis2web plugin an interactive WebMap was created with the final aim to disclose, query and interactively view as much information as possible from a single database which also allows periodic updating without major investments and with very low maintenance costs.