The integration of 3D city models with Building Information Models (BIM), coined as GeoBIM, facilitates improved data support to several applications, e.g., 3D map updates, building permits issuing, detailed city analysis, infrastructure design, context-based building design, to name a few. To solve the integration, several issues need to be tackled and solved, i.e., harmonization of features, interoperability, format conversions, integration of procedures. The GeoBIM benchmark 2019, funded by ISPRS and EuroSDR, evaluated the state of implementation of tools addressing some of those issues. In particular, in the part of the benchmark described in this paper, the application of georeferencing to Industry Foundation Classes (IFC) models and making consistent conversions between 3D city models and BIM are investigated, considering the OGC CityGML and buildingSMART IFC as reference standards. In the benchmark, sample datasets in the two reference standards were provided. External volunteers were asked to describe and test georeferencing procedures for IFC models and conversion tools between CityGML and IFC. From the analysis of the delivered answers and processed datasets, it was possible to notice that while there are tools and procedures available to support georeferencing and data conversion, comprehensive definition of the requirements, clear rules to perform such two tasks, as well as solid technological solutions implementing them, are still lacking in functionalities. Those specific issues can be a sensible starting point for planning the next GeoBIM integration agendas.

This paper provides the innovative approach of using a spatial extract, transform, load (ETL) solution for 3D building modelling, based on an unmanned aerial vehicle (UAV) photogrammetric point cloud. The main objective of the paper is to present the holistic workflow for 3D building modelling, emphasising the benefits of using spatial ETL solutions for this purpose. Namely, despite the increasing demands for 3D city models and their geospatial applications, the generation of 3D city models is still challenging in the geospatial domain. Advanced geospatial technologies provide various possibilities for the mass acquisition of geospatial data that is further used for 3D city modelling, but there is a huge difference in the cost and quality of input data. While aerial photogrammetry and airborne laser scanning involve high costs, UAV photogrammetry has brought new opportunities, including for small and medium-sized companies, by providing a more flexible and low-cost source of spatial data for 3D modelling. In our data-driven approach, we use a spatial ETL solution to reconstruct a 3D building model from a dense image matching point cloud which was obtained beforehand from UAV imagery. The results are 3D building models in a semantic vector format consistent with the OGC CityGML standard, Level of Detail 2 (LOD2). The approach has been tested on selected buildings in a simple semi-urban area. We conclude that spatial ETL solutions can be efficiently used for 3D building modelling from UAV data, where the data process model developed allows the developer to easily control and manipulate each processing step.

Most cadastral systems today are coordinate-based and contain only a weak or no reference to measurements or the origin of the information. In some contexts, this is largely due to the transition of land data management and maintenance from an analogue to a digital environment. This study focuses on analysing the importance of the measurement-based cadastre and the digitisation process in North Macedonia and Slovenia. The survey-based boundary data and their integration into the digital environment were not considered in either case study. The positional differences between the survey-based boundary coordinates and the graphical coordinates of the boundaries are significant. The RMSE(2D) for Trebosh was 48 cm, and the RMSE(2D) for Ivanjševci was 56 cm. Consequently, the differences in location affected the areas of the cadastral parcels, resulting in an RMSE of 26 m² and 23 m² for Trebosh and Ivanjševci, respectively. These differences can be considered as differences within the cadastral boundary data. Therefore, before harmonising the data between the cadastre and the land register, the inconsistencies within the cadastral data should be eliminated first. The differences in the location of cadastral boundaries and parcel area create new challenges in cadastral procedures (formatting of parcels), conflicts in the relocation of boundaries, and impacts on the land market. The solution lies in the way data is maintained, avoiding duplication of attributes or eliminating inconsistencies (after duplication). Both solutions require further modifications of the legal framework for cadastral procedures related to boundary adjustments and data compliance. This study provides a basis for evaluating inconsistencies in cadastral data and highlights the importance of proper source data selection in the digitization process.

This study is focused on indoor navigation network extraction for navigation applications based on available 3D building data and using SFCGAL library, e.g. simple features computational geometry algorithms library. In this study, special attention is given to 3D cadastre and BIM (building information modelling) datasets, which have been used as data sources for 3D geometric indoor modelling. SFCGAL 3D functions are used for the extraction of an indoor network, which has been modelled in the form of indoor connectivity graphs based on 3D geometries of indoor features. The extraction is performed by the integration of extract transform load (ETL) software and the spatial database to support multiple data sources and provide access to SFCGAL functions. With this integrated approach, the current lack of straightforward software support for complex 3D spatial analyses is addressed. Based on the developed methodology, we perform and discuss the extraction of an indoor navigation network from 3D cadastral and BIM data. The efficiency and performance of the network analyses were evaluated using the processing and query execution times. The results show that the proposed methodology for geometry-based navigation network extraction of buildings is efficient and can be used with various types of 3D geometric indoor data.

This paper presents a 3D cadastral data model for buildings. A review of the relevant research shows that a common concept in the 3D cadastre domain is using the legal building unit, i.e. real property unit, as the core modelling unit. Alternatively, this study proposes using indoor space as a core modelling unit. The main reason is to enable the efficient integration of cadastral data with the data from other domains. On the conceptual level, the model is linked to the Land Administration Domain Model (LADM). The integration options are studied for three international standards: IFC, CityGML and IndoorGML.