MODELLING BELOW- AND ABOVE-GROUND UTILITY NETWORK FEATURES WITH THE CITYGML UTILITY NETWORK ADE: EXPERIENCES FROM ROTTERDAM
Keywords: Utility networks, CityGML, Utility Network ADE, 3D City Database, PgRouting
Abstract. Precise and comprehensive knowledge about 3D urban space is required for simulation and analysis in the fields of urban and environmental planning, city administration and disaster management. In order to facilitate these applications, geo-information about functional, semantic, and topographic aspects of urban features, their mutual dependencies and relations is needed. Substantial work has been done in the modelling and representation of above-ground features in the context of 3D city modelling. However, the belowground part of the real world, of which utility networks form a big part, is often neglected. Existing data models for utility networks are generally very domain-specific and, therefore, not suitable either. This paper describes a 3D data modelling approach for integrated management of below-ground utility networks and related above-ground city objects. This approach consists of manipulating first the structure of existing utility data in the commonly used Feature Manipulation Engine ETL software in order to make the data compliant to the CityGML Utility Network ADE data model. Subsequently, workspaces are created that take care of storing the CityGML data into the free and open-source 3D City Database, which has been extended in order to manage utility network data, too. Moreover, the research shows the suitability of the extended 3DCityDB to perform graph-based topological operations by means of the PostgreSQL pgRouting extension. Lastly, the results are visualized in typical GIS applications, e.g. QGIS and ArcGIS.