Network Modelling and Semantic 3d City Models: Testing the Maturity of the Utility Network Ade for Citygml With a Water Network Test Case

Abstract

<p><strong>Abstract.</strong> Recent advances in semantic 3D city modelling and a demand from utility network operators for multi-utility data models integration have contributed to the emergence of an open Application Domain Extension (ADE) of the CityGML data model tailored to multiple types of utility networks. This extension, called the Utility Network ADE, is still in active development. However, work is already well underway to create data samples and to develop methods of modelling thereupon. In this paper, a mapping of the Utility Network ADE data model to a relational database schema is introduced. A sample of a freshwater network using the Utility Network ADE and based on data from the city of Nanaimo, Canada, is also presented. This sample has also been imported into a relational database schema built upon the 3DCityDB (a database implementation of CityGML) extended with a schema of the Utility Network ADE. Further to this, a series of basic network analysis functions have been defined and implemented in SQL to interact with the database so as to carry out sample atomic processes involved in network modelling, such as reading semantic properties of elements, calculating composite physical parameters of the network as a whole, and performing simple topological routing to serve as a guiding example for further and more complex development. A brief outlook is also presented, suggesting areas with high potential for future research and development of this nascent data model.</p>

Linking Semantic 3D City Models with Domain-Specific Simulation Tools for the Planning and Validation of Energy Applications at District Level

“…Finally, the data model allows the modelling of interdependencies between network features and city objects as well as between network features of different types of networks. The Utility Network ADE has been used in a number of case studies, ranging from the integrated modelling of heterogeneous networks [23] to the simulation of cascading effects [24].…”

Kentsel teknik altyapı tesislerine yönelik uluslararası coğrafi veri modellerinin analizi

“…Altyapı tesisleri ile kent nesnelerini ve bunların arasındaki ilişkileri temsil etmek, farklı kullanım durumlarının gerektirdiği coğrafi analizleri yapabilmek için coğrafi veri yönetim sistemlerine gereksinim duyulur. CityGML formatındaki verilerin yönetimi için geliştirilmiş bir veri tabanı şeması sunan 3DCityDB (Yao vd., 2018), UNADE için de kullanılabilir (Boates, Agugiaro, & Nichersu, 2018). Örneğin, den Duijn, Agugiaro, ve Zlatanova (2018); teknik altyapı tesisleri ile kent nesneleri arasındaki ilişkileri temsil etmek üzere Rotterdam şehrindeki alçak gerilimli elektrik hatları ile su şebekesine ait yer altındaki kablo ve borular için ADE sınıflarını, yer üstündeki direkler ve menholler için ise CityGML sınıflarını kullanarak bir veri tabanı oluşturmuş, böyle bir yaklaşımla 3 boyutlu altyapı ağ analizlerinin 3 boyutlu kent modelleri kapsamında gerçekleştirilebileceğini göstermiştir.…”

Data Modeling for Operation and Maintenance of Utility Networks: Implementation and Testing

“…(3) multiplying the nodes corresponding with appurtenances to generate external nodes of pipes; (4) generating interior feature links between the exterior nodes of each pipe; (5) generating inter-feature links between exterior nodes of pipes and nodes corresponding to appurtenances; (6) finally, draping all 2D features onto the DEM to give them an elevation, and adding an offset to the underground by -1 m. We left the geometrical representation of the links and nodes of the topology at 0 m elevation (Figure 5), as suggested by Boates et al (2018).…”