Int. Arch. Photogramm. Remote Sens. Spatial Inf. Sci., XL-4/W1, 105-108, 2013
https://doi.org/10.5194/isprsarchives-XL-4-W1-105-2013
© Author(s) 2013. This work is distributed under
the Creative Commons Attribution 3.0 License.
 
06 May 2013
A SHARED DATABASE OF UNDERGROUND UTILITY LINES FOR 3D MAPPING AND GIS APPLICATIONS
N. E. Cazzaniga, D. Carrion, F. Migliaccio, and R. Barzaghi Politecnico di Milano – DICA – Geodesy and Geomatics, Piazza Leonardo da Vinci 32, Milan, Italy
Keywords: GIS, relational database, underground utility lines 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.
Conference paper (PDF, 697 KB)


Citation: Cazzaniga, N. E., Carrion, D., Migliaccio, F., and Barzaghi, R.: A SHARED DATABASE OF UNDERGROUND UTILITY LINES FOR 3D MAPPING AND GIS APPLICATIONS, Int. Arch. Photogramm. Remote Sens. Spatial Inf. Sci., XL-4/W1, 105-108, https://doi.org/10.5194/isprsarchives-XL-4-W1-105-2013, 2013.

BibTeX EndNote Reference Manager XML