In this paper we present a web-based relational database on the main levee breaches of the Po river (Northern Italy), which have occurred since the year 1880 until today in the section of the river between the towns of Zerbo (Pavia province) and Serravalle (Ferrara province). The database contains more than 200 fact sheets that show the information for each levee failure. For each fact sheet are attached documents, recent maps and historical maps. The access at the database is free of charge and the web interface includes 88 pages that users can access through a simple and intuitive graphical user interface. The relational database and web application were developed through free open source solutions (Apache, MySQL and PHP). This database may provide a valid support at the environmental protection agencies and a valuable technical aid during the forecasting and monitoring phases of rainfall events and help in the design of defense interventions directed at the prevention and mitigation of hydraulic and geologic risk.
In questo lavoro viene presentato un database sulle rotte nell'arginatura maestra del Po, strumento realizzato al fine di conservare e rendere maggiormente fruibili le numerose informazioni raccolte nell'ambito di una convenzione tra l'Autorità di Bacino del Fiume Po ed il CNR-IRPI di Torino dal titolo "Censimento delle rotte storiche negli argini maestri del Fiume Po", avvenute a partire dal 1800, lungo il percorso fluviale da Zerbo (Pavia) a Serravalle (Ferrara). Il database contiene oltre 200 schede dettagliate sulle rotte negli argini maestri del Po, unitamente alla cartografia storica e recente relativa ad ogni rotta. La consultazione è libera. Mediante semplici ed intuitive interrogazioni, è possibile estrarre informazioni circa l'ubicazione, i meccanismi di rottura, il territorio inondato e molto altro. Il Database è stato sviluppato utilizzando software free open source ed ispirandosi al concetto di riusabilità del software pubblico.
Un database relazionale web-based sulle rotte nell'arginatura maestra del Fiume Po
Nigrelli G;
2014
Abstract
In this paper we present a web-based relational database on the main levee breaches of the Po river (Northern Italy), which have occurred since the year 1880 until today in the section of the river between the towns of Zerbo (Pavia province) and Serravalle (Ferrara province). The database contains more than 200 fact sheets that show the information for each levee failure. For each fact sheet are attached documents, recent maps and historical maps. The access at the database is free of charge and the web interface includes 88 pages that users can access through a simple and intuitive graphical user interface. The relational database and web application were developed through free open source solutions (Apache, MySQL and PHP). This database may provide a valid support at the environmental protection agencies and a valuable technical aid during the forecasting and monitoring phases of rainfall events and help in the design of defense interventions directed at the prevention and mitigation of hydraulic and geologic risk.I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.
