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

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