Abstract

Abstract. The presented work is part of the research project, titled "Tecniche murarie tradizionali: conoscenza per la conservazione ed il miglioramento prestazionale" (Traditional building techniques: from knowledge to conservation and performance improvement). This research project has the purpose of studying the building techniques of the 13th–18th centuries in the Sardinia Region (Italy) for their knowledge, conservation, and promotion. The end purpose of the entire study is to improve the performance of the examined structures. In particular, the task of the authors within the research project was to build a WebGIS to manage the data collected during the examination and study phases. This infrastructure was entirely built using Open Source software. The work consisted of designing a database built in PostgreSQL and its spatial extension PostGIS, which allows storing and managing feature geometries and spatial data. The data input is performed via a form built in HTML and PHP. The HTML part is based on Bootstrap, an open tools library for websites and web applications. The implementation of this template used both PHP and Javascript code. The PHP code manages the reading and writing of data to the database, using embedded SQL queries. The database is published on the Internet as a WebGIS built using the Leaflet Javascript open libraries, which allows creating map sites with background maps and navigation, input and query tools. This too uses an interaction of HTML, Javascript, PHP and SQL code. The Database can be accessed in QGIS via a PostgreSQL connection. As of today, we surveyed and archived more than 300 buildings, belonging to three main macro categories: fortification architectures, religious architectures, residential architectures.

Highlights

  • In the recent years, the archiving and diffusion of data about Historical-Architectural Heritage, through the new digital information technologies, has represented a very important moment for a new and better management of this heritage. (D'Urso, 2017) This is due, in particular, to the fact that, at present, the amount of data affecting buildings and structures of cultural heritage has increased massively

  • We present a WebGIS infrastructure for the management and storage of a large amount of data concerning to the structural, morphological, material, dimensional and energy characteristics of the historical buildings present in Sardinia and built between the 13th and the 18th century

  • The project, beyond the design and implementation of the geodatabase and WebGIS presented in the previous pages, is going to involve the design and implementation of a WebGIS following the specifications of the Open Geospatial Consortium (OGC)

Read more

Summary

INTRODUCTION

The archiving and diffusion of data about Historical-Architectural Heritage, through the new digital information technologies, has represented a very important moment for a new and better management of this heritage. (D'Urso, 2017) This is due, in particular, to the fact that, at present, the amount of data affecting buildings and structures of cultural heritage has increased massively. The final goal must be to choose and satisfactorily manage the possible technical means needed to obtain the required understanding of the morphology and the structural behaviour of the construction and to characterize the needs of repair In this context of study, the geomatic can offer an important contribution both from the point of view of the survey and for the management and storage of the data, as well as their sharing on the Internet for greater diffusion among the users involved. The database is published on the Internet as a WebGIS built using the Leaflet Javascript open libraries, which allows to create map sites with background maps and navigation, input and query tools This too uses an interaction of HTML, Javascript, PHP and SQL code. The GIS files were predisposed for their eventual publishing on the official GIS of the Autonomous Region of Sardinia (SITR)

DATABASE STRUCTURE AND DATA TYPES
Data types
Database design and implementation
QGIS implementation
WEBGIS DESIGN AND IMPLEMENTATION
FUTURE DEVELOPMENT
CONCLUSIONS

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call

Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.