Usando QGIS para planificación urbana en la municipalidad de Montecchio Maggiore, Vicenza, Italia

Montecchio Maggiore is a small town in the middle west of Vicenza (about 24.000 population). And as many other italian municipality it manages the town planning; in particular the urban planning and what we call “recovery plan” aka PDR — Piani Di Recupero. This urbanistic tool is dedicated to the historical area in the center of the town and it requires a specific study: building state of conservation, intended use, particular historical notice via survey and restitution to produce planimetric and prospectus graphics. For this purpose it has used QGIS in addition to Postgresql/Postgis database, PHP code and Libreoffice suite, QCAD (LibreCAD).

La tarea

Workflow Schema

Esquema de Flujo de Trabajo

Un esquema aclarará el flujo de trabajo:

Every building data was retrieved via survey and written in paper schedule. Once in office the data were inputed into the Postgresql/Postgis database via PHP form using canonical web browser (Firefox, Iceweasel as well). In a second moment the shape of every building was draw with QGIS and linked to the survey table via id key field (PostgreSQL/Postgis view).

Al mismo tiempo, las fachadas de los edificios fueron diseñados utilizando QCAD (CAD Libre).

El PDR (piani di recupero) debe seguir unas reglas estrictas que requieren gráficos específicos:

  • Estado actual
  • Estado del proyecto
  • Uso previsto (actual)
  • Uso previsto (proyecto)
  • Tipo de intervención admitida

For every graphic thematic maps were produced using the attribute and data retrieve during the survey (for the present state) and data modified during the study and design fase.

Thus a photo was linked to every building facilitating the design and analisys in the gis project (using the “action” feature). The SQL tools (pgquery, postgis manager, dbmanager et al.) allowed to obtain very sophisticated query immediately viewable in the map canvas such as: volume calculation split by building intended use, standards area calculation in percentage of the total planning area and other minor queries. All useful items for the design and planning study otherwise not possible without a very strength tool like gis (and QGIS in particular).

QGIS project with building data viewing

Proyecto QGIS con muestra de datos de edificios

Finally a synthesis report for every building were produced using libreoffice suite. The report consists in a schedule summarise with photo, cartography extract which localize the building in the contest and data of the present state.

QGIS print composer for final graphic layout

Compositor de impresión QGIS para capas gráficas finales

Conclusión

La fortaleza de QGIS es su interfaz de usuario muy amistoso acoplado con las diversas herramientas que ofrece. La conexión con varios formatos de datos (archivos shape, bd spatialite, bd postgresql/postgis,…) facilita e incrementa la interoperabilidad entre diferentes mundos. Así, la libertad ofrecida por el software libre (QGIS, PHP, Libreoffice, QCAD) estimula y abre nuevos horizontes.

Y para finalizar: trabajamos en diferentes plataformas (Windows 7 64 bit, Windows XP 32 bit, servidor Debian y cliente Debian) aunque nunca encontramos problemas que no puedan resolverse.

Autor

Flavio Rigolon

Flavio Rigolon

This article was contributed May 2012 by Flavio Rigolon. He lives in Vicenza (Italy) and works in Montecchio Maggiore municipality as SIT manager. He has migrated almost all the gis data from proprietary to free platform (QGIS, Postgresql/Postgis, Spatialite). He is a member of GFOSS.it (Associazione Italiana per l’Informazione Geografica Libera) since 2007 and was a member of the GFOSS.it board from 2010 to 2012.