For the purpose of facility management it is very important to have detailed and up-to-date databases of underground utility lines, but such data are not always available with adequate accuracy. Hence, the need of collecting and organizing suitable information on underground services is a fundamental issue when dealing with urban data. Besides, by analyzing the process of designing and laying new underground infrastructures it is possible to implement an efficient and cost-effective approach to integrate and update existing maps by exploiting the surveying required for the installation of new facilities. It is also important to underline that collecting all the data in a unique integrated database (and GIS) gives the possibility to share (at least at a local level) the cartographic and thematic information for an optimal management of underground networks. In this paper, a database (DB) model for archiving the underground lines data is presented. The structure of the DB has been designed by following the standard methodology for the modelling of a relational DB, going through successive phases and originating the external, conceptual and logical model. Finally, preliminary tests have been carried on for parts of the DB to verify quality parameters.

A shared database of underground utility lines for 3D mapping and GIS applications

CAZZANIGA, NOEMI EMANUELA;CARRION, DANIELA;MIGLIACCIO, FEDERICA;BARZAGHI, RICCARDO
2013-01-01

Abstract

For the purpose of facility management it is very important to have detailed and up-to-date databases of underground utility lines, but such data are not always available with adequate accuracy. Hence, the need of collecting and organizing suitable information on underground services is a fundamental issue when dealing with urban data. Besides, by analyzing the process of designing and laying new underground infrastructures it is possible to implement an efficient and cost-effective approach to integrate and update existing maps by exploiting the surveying required for the installation of new facilities. It is also important to underline that collecting all the data in a unique integrated database (and GIS) gives the possibility to share (at least at a local level) the cartographic and thematic information for an optimal management of underground networks. In this paper, a database (DB) model for archiving the underground lines data is presented. The structure of the DB has been designed by following the standard methodology for the modelling of a relational DB, going through successive phases and originating the external, conceptual and logical model. Finally, preliminary tests have been carried on for parts of the DB to verify quality parameters.
2013
GIS; relational database; underground utility lines
File in questo prodotto:
File Dimensione Formato  
isprsarchives-XL-4-W1-105-2013-UDMS.pdf

Accesso riservato

: Altro materiale allegato
Dimensione 697.98 kB
Formato Adobe PDF
697.98 kB Adobe PDF   Visualizza/Apri

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/11311/727573
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 5
  • ???jsp.display-item.citation.isi??? 1
social impact