Albieri A., Bellini R., S. Mascali Zeo, C. Venturelli, M. Carrieri, P. Angelini, F. Baldacchini, S. Fontanari
Eden Meeting 2010,
Montpellier, France, 10-11-12th May 2010.
The Aedes albopictus survey group of Emilia-Romagna Region, Italy, collaborates in multidisciplinary context (entomology, epidemiology, informatics, public health) to develop a Web-Based Geographic Information Systems (Web-GIS) that enable storage, processing, and analysis of spatial monitoring and public health data, managed together with other external data in the open source Relational Database Management System (RDBMS) PostgreSQL.
A PostgreSQL session consists of the following cooperating processes: a server process which manages the database files, accepts connections to database from client application and performs actions on database on behalf of the clients; the user’s client (frontend) application to perform database operations. PostGIS open source software was implemented to add support for geographic objects to PostgreSQL relational database. PostGIS “spatially enables” the PostgreSQL server, allowing it to be used as a backend spatial database for Web-GIS. The Regional Web-GIS, dedicated to professionals and to public health care decision-makers, provides specific web interface that includes maps, legends, controls for executing queries on relational data, for creating thematic maps (choropleth maps), time series and layers (shapefiles), reports, and Excel data extraction for vector control program and for Chikungunya virus (CHIKV) survey and control in Emilia-Romagna Region.
Scarica poster