{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,10,31]],"date-time":"2025-10-31T22:10:38Z","timestamp":1761948638844,"version":"build-2065373602"},"reference-count":56,"publisher":"MDPI AG","issue":"12","license":[{"start":{"date-parts":[[2020,6,19]],"date-time":"2020-06-19T00:00:00Z","timestamp":1592524800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"funder":[{"DOI":"10.13039\/501100004329","name":"Javna Agencija za Raziskovalno Dejavnost RS","doi-asserted-by":"publisher","award":["P2-0406 Earth observation and geoinformatics"],"award-info":[{"award-number":["P2-0406 Earth observation and geoinformatics"]}],"id":[{"id":"10.13039\/501100004329","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Remote Sensing"],"abstract":"<jats:p>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.<\/jats:p>","DOI":"10.3390\/rs12121972","type":"journal-article","created":{"date-parts":[[2020,6,19]],"date-time":"2020-06-19T10:43:58Z","timestamp":1592563438000},"page":"1972","update-policy":"https:\/\/doi.org\/10.3390\/mdpi_crossmark_policy","source":"Crossref","is-referenced-by-count":19,"title":["Spatial ETL for 3D Building Modelling Based on Unmanned Aerial Vehicle Data in Semi-Urban Areas"],"prefix":"10.3390","volume":"12","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-6450-9821","authenticated-orcid":false,"given":"Ur\u0161ka","family":"Dre\u0161\u010dek","sequence":"first","affiliation":[{"name":"Faculty of Civil and Geodetic Engineering, University of Ljubljana,  Jamova cesta 2, 1000 Ljubljana, Slovenia"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Mojca","family":"Kosmatin Fras","sequence":"additional","affiliation":[{"name":"Faculty of Civil and Geodetic Engineering, University of Ljubljana,  Jamova cesta 2, 1000 Ljubljana, Slovenia"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jernej","family":"Tekavec","sequence":"additional","affiliation":[{"name":"Faculty of Civil and Geodetic Engineering, University of Ljubljana,  Jamova cesta 2, 1000 Ljubljana, Slovenia"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-6119-3390","authenticated-orcid":false,"given":"Anka","family":"Lisec","sequence":"additional","affiliation":[{"name":"Faculty of Civil and Geodetic Engineering, University of Ljubljana,  Jamova cesta 2, 1000 Ljubljana, Slovenia"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"1968","published-online":{"date-parts":[[2020,6,19]]},"reference":[{"key":"ref_1","doi-asserted-by":"crossref","first-page":"2842","DOI":"10.3390\/ijgi4042842","article-title":"Applications of 3D city models: State of the art review","volume":"4","author":"Biljecki","year":"2015","journal-title":"ISPRS Int. J. Geo-Inf."},{"key":"ref_2","unstructured":"Rahman, A.A. (2017). Advances in 3D Geoinformation, Springer."},{"key":"ref_3","doi-asserted-by":"crossref","unstructured":"Sakr, S., and Zomaya, A. (2018). ETL. Encyclopedia of Big Data Technologies, Springer.","DOI":"10.1007\/978-3-319-77525-8"},{"key":"ref_4","unstructured":"(2020, March 20). SafeSoftware, Inc., FME (Feature Manipulation Engine), Desktop Documentation. Available online: https:\/\/docs.safe.com\/fme\/html\/FME_Desktop_Documentation\/FME_Transformers\/transformer-index.htm."},{"key":"ref_5","unstructured":"Open Geospatial Consortium (2020, April 14). City Geography Markup Language (CityGML) Encoding Standard, Version 2.0 2012. Available online: https:\/\/www.ogc.org\/standards\/citygml."},{"key":"ref_6","first-page":"187","article-title":"Building reconstruction from images and laser scanning","volume":"6","author":"Brenner","year":"2005","journal-title":"Int. J. Appl. Earth Obs. Geoinf."},{"key":"ref_7","unstructured":"Kaartinen, H., Hyypp\u00e4, J., G\u00fclch, E., Hyypp\u00e4, H., Matikainen, L., Vosselman, G., Hofmann, A.D., M\u00e4der, U., Persson, \u00c5., and S\u00f6derman, U. (2005, January 17\u201320). EuroSDR Building Extraction Comparison. Proceedings of the ISPRS Hannover Workshop 2005: High-Resolution Earth Imaging for Geospatial Information, Hannover, Germany."},{"key":"ref_8","doi-asserted-by":"crossref","first-page":"570","DOI":"10.1016\/j.isprsjprs.2010.09.006","article-title":"An update on automatic 3D building reconstruction","volume":"65","author":"Haala","year":"2010","journal-title":"ISPRS J. Photogramm. Remote Sens."},{"key":"ref_9","doi-asserted-by":"crossref","first-page":"256","DOI":"10.1016\/j.isprsjprs.2013.10.004","article-title":"Results of the ISPRS benchmark on urban object detection and 3D building reconstruction","volume":"93","author":"Rottensteiner","year":"2014","journal-title":"ISPRS J. Photogramm. Remote Sens."},{"key":"ref_10","doi-asserted-by":"crossref","first-page":"3826","DOI":"10.3390\/rs70403826","article-title":"Building extraction from Airborne Laser Scanning data: An analysis of the state of the art","volume":"7","author":"Tomljenovic","year":"2015","journal-title":"Remote Sens."},{"key":"ref_11","doi-asserted-by":"crossref","first-page":"7323","DOI":"10.3390\/s8117323","article-title":"A comprehensive automated 3D approach for building extraction, reconstruction, and regularization from airborne laser scanning point clouds","volume":"8","author":"Dorninger","year":"2008","journal-title":"Sensors"},{"key":"ref_12","doi-asserted-by":"crossref","first-page":"6101","DOI":"10.3390\/s90806101","article-title":"Building reconstruction by target based graph matching on incomplete laser data: Analysis and limitations","volume":"9","author":"Vosselman","year":"2009","journal-title":"Sensors"},{"key":"ref_13","unstructured":"Kada, M., and McKinley, L. (2009, January 3\u20134). 3D building reconstruction from LiDAR based on a cell decomposition approach. Proceedings of the CMRT09: Object Extraction for 3D City Models, Road Databases and Traffic Monitoring-Concepts, Algorithms and Evaluation, Paris, France."},{"key":"ref_14","doi-asserted-by":"crossref","first-page":"575","DOI":"10.1016\/j.isprsjprs.2009.04.001","article-title":"Knowledge based reconstruction of building models from terrestrial laser scanning data","volume":"64","author":"Pu","year":"2009","journal-title":"ISPRS J. Photogramm. Remote Sens."},{"key":"ref_15","doi-asserted-by":"crossref","first-page":"221","DOI":"10.1016\/j.measurement.2015.07.015","article-title":"Methods of laser scanning point clouds integration in precise 3D building modelling","volume":"74","author":"Kedzierski","year":"2015","journal-title":"Measurement"},{"key":"ref_16","doi-asserted-by":"crossref","first-page":"13945","DOI":"10.3390\/rs71013945","article-title":"Semantic decomposition and reconstruction of compound buildings with symmetric roofs from LiDAR data and aerial imagery","volume":"7","author":"Wang","year":"2015","journal-title":"Remote Sens."},{"key":"ref_17","first-page":"25","article-title":"A patch-based method for the evaluation of dense image matching quality","volume":"70","author":"Zhang","year":"2018","journal-title":"Int. J. Appl. Earth Obs. Geoinf."},{"key":"ref_18","doi-asserted-by":"crossref","first-page":"56","DOI":"10.1016\/j.isprsjprs.2011.12.006","article-title":"Building extraction from oblique airborne imagery based on robust fa\u00e7ade detection","volume":"68","author":"Xiao","year":"2012","journal-title":"ISPRS J. Photogramm. Remote Sens."},{"key":"ref_19","doi-asserted-by":"crossref","first-page":"157","DOI":"10.1016\/j.isprsjprs.2014.02.016","article-title":"Context-based automatic reconstruction and texturing of 3D urban terrain for quick-response tasks","volume":"93","author":"Bulatov","year":"2014","journal-title":"ISPRS J. Photogramm. Remote Sens."},{"key":"ref_20","doi-asserted-by":"crossref","first-page":"84","DOI":"10.1016\/j.cag.2015.07.004","article-title":"Reconstructing building mass models from UAV images","volume":"54","author":"Li","year":"2016","journal-title":"Comput. Graph."},{"key":"ref_21","doi-asserted-by":"crossref","first-page":"527","DOI":"10.5194\/isprs-archives-XLII-1-W1-527-2017","article-title":"Geospatial data processing for 3D city model generation, management and visualization","volume":"XLII-1\/W1","author":"Toschi","year":"2017","journal-title":"Int. Arch. Photogramm. Remote Sens. Spat. Inf. Sci."},{"key":"ref_22","doi-asserted-by":"crossref","unstructured":"Wen, X., Xie, H., Liu, H., and Yan, L. (2019). Accurate Reconstruction of the LoD3 Building Model by Integrating Multi-Source Point Clouds and Oblique Remote Sensing Imagery. ISPRS Int. J. Geo-Inf., 8.","DOI":"10.3390\/ijgi8030135"},{"key":"ref_23","doi-asserted-by":"crossref","first-page":"52","DOI":"10.1016\/j.isprsjprs.2011.10.003","article-title":"3D building reconstruction based on given ground plan information and surface models extracted from spaceborne imagery","volume":"67","author":"Tack","year":"2012","journal-title":"ISPRS J. Photogramm. Remote Sens."},{"key":"ref_24","doi-asserted-by":"crossref","first-page":"365","DOI":"10.1016\/j.isprsjprs.2007.09.003","article-title":"Automatic building extraction from DEMs using an object approach and application to the 3D-city modeling","volume":"63","author":"Lafarge","year":"2008","journal-title":"ISPRS J. Photogramm. Remote Sens."},{"key":"ref_25","doi-asserted-by":"crossref","first-page":"146","DOI":"10.1111\/cgf.12077","article-title":"A survey of urban reconstruction","volume":"32","author":"Musialski","year":"2013","journal-title":"Comput. Graph. Forum"},{"key":"ref_26","first-page":"48","article-title":"An Evaluation on Fixed Wing and Multi-Rotor UAV Images using Photogrammetric Image Processing","volume":"7","author":"Tahar","year":"2013","journal-title":"Int. J. Comput. Electr. Autom. Control Inf. Eng."},{"key":"ref_27","doi-asserted-by":"crossref","unstructured":"Crommelinck, S., Bennett, R., Gerke, M., Nex, F., Yang, M.Y., and Vosselman, G. (2016). Review of automatic feature extraction from high-resolution optical sensor data for UAV-based cadastral mapping. Remote Sens., 8.","DOI":"10.3390\/rs8080689"},{"key":"ref_28","first-page":"87","article-title":"Model-driven and data-driven approaches using LIDAR data: Analysis and comparison","volume":"XXXVI-3\/W4","author":"Landes","year":"2007","journal-title":"Int. Arch. Photogramm. Remote Sens. Spat. Inf. Sci."},{"key":"ref_29","first-page":"97","article-title":"Extended RANSAC Algorithm for Automatic Detection of Building Roof Planes From Lidar Data","volume":"21","author":"Landes","year":"2008","journal-title":"Photogramm. J. Finl."},{"key":"ref_30","first-page":"84","article-title":"Towards fully automatic generation of city models","volume":"XXXIII-B3\/","author":"Brenner","year":"2000","journal-title":"Int. Arch. Photogramm. Remote Sens."},{"key":"ref_31","first-page":"87","article-title":"Building reconstruction using planar faces in very high density height data","volume":"XXXII-3\/2W","author":"Vosselman","year":"1999","journal-title":"Int. Arch. Photogramm. Remote Sens."},{"key":"ref_32","doi-asserted-by":"crossref","first-page":"330","DOI":"10.1111\/j.1477-9730.2012.00688.x","article-title":"A Multi-Resolution Hybrid Approach for Building Model Reconstruction from Lidar Data","volume":"27","author":"Satari","year":"2012","journal-title":"Photogramm. Rec."},{"key":"ref_33","doi-asserted-by":"crossref","first-page":"42","DOI":"10.1109\/MCG.2003.1242381","article-title":"Automatic generation of high-quality building models from LiDAR data","volume":"23","author":"Rottensteiner","year":"2003","journal-title":"IEEE Comput. Graph. Appl."},{"key":"ref_34","doi-asserted-by":"crossref","first-page":"1425","DOI":"10.14358\/PERS.74.11.1425","article-title":"Using a Binary Space Partitioning Tree for Reconstructing Polyhedral Building Models from Airborne Lidar Data","volume":"74","author":"Sohn","year":"2008","journal-title":"Photogramm. Eng. Remote Sens."},{"key":"ref_35","doi-asserted-by":"crossref","first-page":"275","DOI":"10.1016\/j.isprsjprs.2015.01.002","article-title":"Flexible building primitives for 3D building modeling","volume":"101","author":"Xiong","year":"2015","journal-title":"ISPRS J. Photogramm. Remote Sens."},{"key":"ref_36","doi-asserted-by":"crossref","first-page":"227","DOI":"10.1016\/j.isprsjprs.2014.01.007","article-title":"A graph edit dictionary for correcting errors in roof topology graphs reconstructed from point clouds","volume":"93","author":"Xiong","year":"2014","journal-title":"ISPRS J. Photogramm. Remote Sens."},{"key":"ref_37","doi-asserted-by":"crossref","first-page":"12","DOI":"10.1016\/j.isprsjprs.2012.04.004","article-title":"CityGML- Interoperable semantic 3D city models","volume":"71","year":"2012","journal-title":"ISPRS J. Photogramm. Remote Sens."},{"key":"ref_38","doi-asserted-by":"crossref","unstructured":"Lee, J., and Zlatanova, S. (2009). Representing and exchanging 3D city models with CityGML. 3D Geo-Information Sciences, Springer.","DOI":"10.1007\/978-3-540-87395-2"},{"key":"ref_39","doi-asserted-by":"crossref","first-page":"92","DOI":"10.1080\/13658816.2012.667105","article-title":"Establishing a national standard for 3D topographic data compliant to CityGML","volume":"27","author":"Stoter","year":"2013","journal-title":"Int. J. Geogr. Inf. Sci."},{"key":"ref_40","doi-asserted-by":"crossref","first-page":"1","DOI":"10.4018\/jdwm.2009070101","article-title":"A Survey of Extract-Transform-Load A Survey of Extract\u2013Transform\u2013Load Technology","volume":"5","author":"Vassiliadis","year":"2009","journal-title":"Int. J. Data Warehous. Min."},{"key":"ref_41","doi-asserted-by":"crossref","first-page":"626","DOI":"10.1016\/j.proenv.2016.03.117","article-title":"Extraction, Transformation, and Loading (ETL) Module for Hotspot Spatial Data Warehouse Using Geokettle","volume":"33","author":"Astriani","year":"2016","journal-title":"Procedia Environ. Sci."},{"key":"ref_42","first-page":"719","article-title":"Prostorski ETL za bolj\u0161o medopravilnost v GIS","volume":"57","author":"Podobnikar","year":"2013","journal-title":"Geod. Vestn."},{"key":"ref_43","unstructured":"Safe Software Inc (2019, December 21). FME (Feature Manipulation Engine). Available online: https:\/\/www.safe.com\/."},{"key":"ref_44","unstructured":"(2020, May 24). Agisoft Photoscan. Available online: https:\/\/www.agisoft.com\/."},{"key":"ref_45","unstructured":"(2020, January 02). CloudCompare. Available online: https:\/\/www.cloudcompare.org\/."},{"key":"ref_46","doi-asserted-by":"crossref","unstructured":"Hackel, T., Wegner, J.D., and Schindler, K. (2016, January 27\u201330). Contour detection in unstructured 3D point clouds. Proceedings of the IEEE Computer Society Conference on Computer Vision and Pattern Recognition, Las Vegas, NV, USA.","DOI":"10.1109\/CVPR.2016.178"},{"key":"ref_47","doi-asserted-by":"crossref","first-page":"214","DOI":"10.1111\/j.1467-8659.2007.01016.x","article-title":"Efficient RANSAC for Point-Cloud Shape Detection","volume":"26","author":"Schnabel","year":"2007","journal-title":"Comput. Graph. Forum"},{"key":"ref_48","doi-asserted-by":"crossref","unstructured":"Malihi, S., Zoej, M.J.V., and Hahn, M. (2018). Large-scale accurate reconstruction of buildings employing point clouds generated from UAV imagery. Remote Sens., 10.","DOI":"10.3390\/rs10071148"},{"key":"ref_49","doi-asserted-by":"crossref","first-page":"693","DOI":"10.1111\/mice.12043","article-title":"On the validation of solids represented with the international standards for geographic information","volume":"28","author":"Ledoux","year":"2013","journal-title":"Comput. Civ. Infrastruct. Eng."},{"key":"ref_50","doi-asserted-by":"crossref","first-page":"1","DOI":"10.1186\/s40965-018-0043-x","article-title":"val3dity: Validation of 3D GIS primitives according to the international standards","volume":"3","author":"Ledoux","year":"2018","journal-title":"Open Geospatial Data Softw. Stand."},{"key":"ref_51","doi-asserted-by":"crossref","first-page":"286","DOI":"10.1016\/j.isprsjprs.2015.01.016","article-title":"Semantic point cloud interpretation based on optimal neighborhoods, relevant features and efficient classifiers","volume":"105","author":"Weinmann","year":"2015","journal-title":"ISPRS J. Photogramm. Remote Sens."},{"key":"ref_52","doi-asserted-by":"crossref","first-page":"1554","DOI":"10.1109\/TGRS.2009.2030180","article-title":"Segmentation and reconstruction of polyhedral building roofs from aerial lidar point clouds","volume":"48","author":"Sampath","year":"2010","journal-title":"IEEE Trans. Geosci. Remote Sens."},{"key":"ref_53","doi-asserted-by":"crossref","first-page":"115","DOI":"10.5194\/isprsarchives-XXXIX-B3-115-2012","article-title":"Automated Reconstruction of Walls From Airborne Lidar Data for Complete 3D Building Modelling","volume":"XXXIX-B3","author":"He","year":"2012","journal-title":"Int. Arch. Photogramm. Remote Sens. Spat. Inf. Sci."},{"key":"ref_54","doi-asserted-by":"crossref","unstructured":"Gevaert, C.M., Persello, C., and Vosselman, G. (2016). Optimizing multiple kernel learning for the classification of UAV data. Remote Sens., 8.","DOI":"10.3390\/rs8121025"},{"key":"ref_55","doi-asserted-by":"crossref","first-page":"1077","DOI":"10.1080\/17538947.2016.1269841","article-title":"Building segmentation and outline extraction from UAV image-derived point clouds by a line growing algorithm","volume":"10","author":"Dai","year":"2017","journal-title":"Int. J. Digit. Earth"},{"key":"ref_56","doi-asserted-by":"crossref","first-page":"17","DOI":"10.1016\/j.isprsjprs.2012.11.004","article-title":"Model driven reconstruction of roofs from sparse LIDAR point clouds","volume":"76","author":"Henn","year":"2013","journal-title":"ISPRS J. Photogramm. Remote Sens."}],"container-title":["Remote Sensing"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.mdpi.com\/2072-4292\/12\/12\/1972\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,10,11]],"date-time":"2025-10-11T09:40:50Z","timestamp":1760175650000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.mdpi.com\/2072-4292\/12\/12\/1972"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2020,6,19]]},"references-count":56,"journal-issue":{"issue":"12","published-online":{"date-parts":[[2020,6]]}},"alternative-id":["rs12121972"],"URL":"https:\/\/doi.org\/10.3390\/rs12121972","relation":{},"ISSN":["2072-4292"],"issn-type":[{"type":"electronic","value":"2072-4292"}],"subject":[],"published":{"date-parts":[[2020,6,19]]}}}