From consistency to flexibility: A simplified database schema for the management of CityJSON 3D city models

Nys, Gilles-Antoine; Billen, Roland

doi:10.1111/tgis.12807

Download

Article (Scientific journals)

From consistency to flexibility: A simplified database schema for the management of CityJSON 3D city models

Nys, Gilles-Antoine; Billen, Roland

2021 • In Transactions in GIS

Peer Reviewed verified by ORBi

Permalink
https://hdl.handle.net/2268/262196

DOI
10.1111/tgis.12807

Files (1)Send to Details Statistics Bibliography Similar publications

Files

Full Text

MainText_Preprint.pdf

Author preprint (2.16 MB)

Download

All documents in ORBi are protected by a user license.

Send to

RIS BibTex APA Chicago Permalink X Linkedin

Details

Keywords :

CityJSON; NoSQL; 3D City Models; Data schema; Data architecture

Abstract :

[en] The use of 3D city models is now common practice; many large cities have their own digital model. Resilient and sustainable management of these models is necessary in many cases, where an application could evolve over its lifecycle. The complexity of generic modeling standardization is often a limitation for a light and user-friendly usage and further developments. This article aims to propose an alternative, providing a simplified database schema implemented in document-oriented storage. Thanks to the use of the NoSQL store, the focus is on flexibility of the data schemas and thus its clarification. In order to aim attention at the compactness in web development, CityJSON has been chosen for the encoding of the 3D city models. Finally, a full-stack application (persistent storage, consistent edition, and visualization of 3D city models) has been developed to handle the simplified schema and illustrates its capabilities in two practical use cases.

Research center :

Geomatics Unit

Disciplines :

Computer science

Author, co-author :

Nys, Gilles-Antoine ; Université de Liège - ULiège > Département de géographie > Unité de Géomatique - Topographie et géométrologie

Billen, Roland ; Université de Liège - ULiège > Département de géographie > Unité de Géomatique - Topographie et géométrologie

Language :

English

Title :

From consistency to flexibility: A simplified database schema for the management of CityJSON 3D city models

Publication date :

16 July 2021

Journal title :

Transactions in GIS

ISSN :

1361-1682

eISSN :

1467-9671

Publisher :

Wiley, Oxford, United Kingdom

Peer reviewed :

Peer Reviewed verified by ORBi

Funders :

F.R.S.-FNRS - Fonds de la Recherche Scientifique [BE]

Available on ORBi :

since 20 July 2021

Statistics

Number of views

130 (31 by ULiège)

Number of downloads

228 (22 by ULiège)

More statistics

Scopus citations^®

Scopus citations^®
without self-citations

OpenCitations

Bibliography

Agrawal, S., & Gupta, R. D. (2017). Web GIS and its architecture: A review. Arabian Journal of Geosciences, 10(23), 518. https://doi.org/10.1007/s12517-017-3296-2
Aleksandrov, M., Diakité, A., Yan, J., Li, W., & Zlatanova, S. (2019). Systems architecture for management of BIM, 3D GIS and sensors data. ISPRS Annals of Photogrammetry, Remote Sensing and Spatial Information Sciences, 4(4/W9), 3–10. https://doi.org/10.5194/isprs-annals-IV-4-W9-3-2019
Bartoszewski, D., Piorkowski, A., & Lupa, M. (2019). The comparison of processing efficiency of spatial data for PostGIS and MongoDB databases. In S. Kozielski, D. Mrozek, P. Kasprowski, B. Małysiak-Mrozek, & D. Kostrzewa (Eds.), Beyond databases, architectures and structures: Paving the road to smart data processing and analysis (Communications in Computer and Information Science, Vol. 1018, pp. 291–302). Cham, Switzerland: Springer.
Biljecki, F., Kumar, K., & Nagel, C. (2018). CityGML application domain extension (ADE): Overview of developments. Open Geospatial Data, Software and Standards, 3(1), 13. https://doi.org/10.1186/s40965-018-0055-6
Biljecki, F., Stoter, J., Ledoux, H., Zlatanova, S., & Çöltekin, A. (2015). Applications of 3D city models: State-of-the-art review. ISPRS International Journal of Geo-Information, 4(4), 2842–2889. https://doi.org/10.3390/ijgi4042842
Blaschke, T., Hay, G. J., Weng, Q., & Resch, B. (2011). Collective sensing: Integrating geospatial technologies to understand urban systems, an overview. Remote Sensing, 3(8), 1743–1776. https://doi.org/10.3390/rs3081743
Boaventura Filho, W., Olivera, H. V., Holanda, M., & Favacho, A. (2016). Geographic data modelling for NoSQL document-oriented databases. In Proceedings of the Seventh International Conference on Advanced Geographic Information Systems, Applications, and Services, Lisbon, Portugal (pp. 63–68).
Breunig, M., Kuper, P. V., Butwilowski, E., Thomsen, A., Jahn, M., Dittrich, A., … Menninghaus, M. (2016). The story of DB4GeO: A service-based geo-database architecture to support multi-dimensional data analysis and visualization. ISPRS Journal of Photogrammetry and Remote Sensing, 117, 187–205. https://doi.org/10.1016/j.isprsjprs.2015.12.006
Bukhsh, Z. A., van Sinderen, M., & Singh, P. M. (2015). SOA and EDA: A comparative study: Similarities, differences and conceptual guidelines on their usage. In Proceedings of the 12th International Conference on e-Business, Colmar, France (pp. 213–220).
Chasseur, C., Li, Y., & Patel, J. (2013). Enabling JSON document stores in relational systems. In Proceedings of the 16th International Workshop on the Web and Databases, New York, NY (pp. 1–6). New York, NY: ACM.
da Costa Rainho, F., & Bernardino, J. (2018). Web GIS: A new system to store spatial data using GeoJSON in MongoDB. In Proceedings of the 13th Iberian Conference on Information Systems and Technologies, Caceres, Spain (pp. 1–6). Piscataway, NJ: IEEE.
Diogo, M., Cabral, B., & Bernardino, J. (2019). Consistency models of NoSQL databases. Future Internet, 11(2), 43. https://doi.org/10.3390/fi11020043
Doboš, J., & Steed, A. (2012). 3D revision control framework. In Proceedings of the 17th International Conference on 3D Web Technology, Los Angeles, CA (pp. 121–129). New York, NY: ACM.
Đurić, M., & Amović, M. (2018). Geoportal for searching and visualization of cadastral data. CABPEMEHA TEOPИJA И ПPAКCA У ГPAДИTEЉCTBУ, 13(1), 687–698. https://doi.org/10.7251/STP1813687A
ECMA International. (2015). ECMAScript 2015: Language specification. Geneva, Switzerland: Author.
Floros, G., & Dimopoulou, E. (2016). Investigating the enrichment of a 3D city model with various CityGML modules. ISPRS International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences, 42(2/W2), 3–9. https://doi.org/10.5194/isprs-archives-XLII-2-W2-3-2016
Gröger, G., & Plümer, L. (2012). CityGML: Interoperable semantic 3D city models. ISPRS Journal of Photogrammetry and Remote Sensing, 71, 12–33. https://doi.org/10.1016/j.isprsjprs.2012.04.004
Haughian, G., Osman, R., & Knottenbelt, W. J. (2016). Benchmarking replication in Cassandra and MongoDB NoSQL datastores. In S. Hartmann & H. Ma (Eds.), Database and expert systems applications (Lecture Notes in Computer Science, Vol. 9828, pp. 152–166). Cham, Switzerland: Springer.
Holemans, A., Kasprzyk, J.-P., & Donnay, J.-P. (2018). Coupling an unstructured NoSQL database with a geographic information system. In Proceedings of the 10th International Conference on Advanced Geographic Information Systems, Applications, and Services, Rome, Italy (pp. 23–28).
Joshi, M. Y., Selmi, W., Binard, M., Nys, G.-A., & Teller, J. (2020). Potential for urban greening with urban roofs: A way towards smart cities. ISPRS Annals of Photogrammetry, Remote Sensing and Spatial Information Sciences, 6(4/W2), 87–94. https://doi.org/10.5194/isprs-annals753VI-4-W2-2020-87-2020
Kulawiak, M., Dawidowicz, A., & Pacholczyk, M. E. (2019). Analysis of server-side and client-side web-GIS data processing methods on the example of JTS and JSTS using open data from OSM and geoportal. Computers & Geosciences, 129, 26–37. https://doi.org/10.1016/j.cageo.2019.04.011
Kumar, K., Ledoux, H., & Stoter, J. (2018). Dynamic 3D visualization of floods: Case of the Netherlands. ISPRS – International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences, 42(4/W10), 83–87. https://doi.org/10.5194/isprs761archives-XLII-4-W10-83-2018
Laksono, D. (2018). Testing spatial data deliverance in SQL and NoSQL database using NodeJS fullstack web app. In Proceedings of the Fourth International Conference on Science and Technology, Yogyakarta, Indonesia (pp. 1–5). Piscataway, NJ: IEEE.
Ledoux, H., Arroyo Ohori, K., Kumar, K., Dukai, B., Labetski, A., & Vitalis, S. (2019). CityJSON: A compact and easy-to-use encoding of the CityGML data model. Preprint, ArXiv:1902.09155.
Lim, J., Janssen, P., & Biljecki, F. (2020). Visualizing detailed CityGML and ADE at the building scale. ISPRS – International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences, 44(4/W1), 83–90. https://doi.org/10.5194/isprs-archives-XLIV-4-W1-2020-83-2020
Liu, Z. H., Hammerschmidt, B., & McMahon, D. (2014). JSON data management: Supporting schema-less development in RDBMS. In Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data, Snowbird, UT (pp. 1247–1258). New York, NY: ACM.
Lopez, M., Couturier, S., & Lopez, J. (2016). Integration of NoSQL databases for analyzing spatial information in geographic information systems. In Proceedings of the Eighth International Conference on Computational Intelligence and Communication Networks, Tehri, India (pp. 351–355). Piscataway, NJ: IEEE.
Makris, A., Tserpes, K., & Anagnostopoulos, D. (2019). Performance evaluation of MongoDB and PostgreSQL for spatio-temporal data. In Proceedings of 22nd International Conference on Extending Database Technology, Lisbon, Portugal (pp. 1–8).
Mao, B., & Harrie, L. (2016). Methodology for the efficient progressive distribution and visualization of 3D building objects. ISPRS International Journal of Geo-Information, 5(10), 185. https://doi.org/10.3390/ijgi5100185
Mobasheri, A., Mitasova, H., Neteler, M., Singleton, A., Ledoux, H., & Brovelli, M. A. (2020). Highlighting recent trends in open source geospatial science and software. Transactions in GIS, 24(5), 1141–1146. https://doi.org/10.1111/tgis.12703
Nys, G.-A., Billen, R., & Poux, F. (2020). Automatic 3D buildings compact reconstruction from LiDAR point clouds. ISPRS International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences, 43(B2), 473–478. https://doi.org/10.5194/isprs-archives-XLIII-B2-2020-473-2020
Nys, G.-A., Kharroubi, A., Poux, F., & Billen, R. (2021). An extension of CityJSON to support point clouds. In Proceedings of the 24th ISPRS Congress, Nice, France.
Nys, G.-A., Poux, F., & Billen, R. (2020). CityJSON building generation from airborne LiDAR 3D point clouds. ISPRS International Journal of Geo-Information, 9(9), 521. https://doi.org/10.3390/ijgi9090521
Obe, R. O., & Hsu, L. S. (2015). PostGIS in action (2nd ed.). Shelter Island, NY: Manning.
Olivera, H. V., Holanda, M., Guimarâes, V., Hondo, F., & Boaventura, W. (2015). Data modeling for NoSQL document-oriented databases. In Proceedings of the Second Annual International Symposium on Information Management and Big Data, Cusco, Peru (pp. 129–135).
Pispidikis, I., & Dimopoulou, E. (2016). Development of a 3D webGIS system for retrieving and visualizing CityGML data based on their geometric and semantic characteristics by using free and open source technology. ISPRS Annals of the Photogrammetry, Remote Sensing and Spatial Information Sciences, 4(2/W1), 47–53. https://doi.org/10.5194/isprs-annals811IV-2-W1-47-2016
Poux, F., Billen, R., Kasprzyk, J.-P., Lefebvre, P.-H., & Hallot, P. (2020). A built heritage information system based on point cloud data: HIS-PC. ISPRS International Journal of Geo-Information, 9(10), 588. https://doi.org/10.3390/ijgi9100588
Reis, D. G., Gasparoni, F. S., Holanda, M., Victorino, M., Ladeira, M., & Ribeiro, E. O. (2018). An evaluation of data model for NoSQL document based databases. In Á. Rocha, H. Adeli, L. P. Reis, & S. Costanzo (Eds.), Trends and advances in information systems and technologies (pp. 616–625). Cham, Switzerland: Springer.
Schultz, W., Avitabile, T., & Cabral, A. (2019). Tunable consistency in MongoDB. Proceedings of the VLDB Endowment, 12(12), 2071–2081. https://doi.org/10.14778/3352063.3352125
Sveen, A. F. (2019). Efficient storage of heterogeneous geospatial data in spatial databases. Journal of Big Data, 6(1), 102. https://doi.org/10.1186/s40537-019-0262-8
Tomlinson, R. (1968). A geographic information system for regional planning. In G. A. Stewart (Ed.), Land evaluation: Papers of a CSIRO Symposium organized in cooperation with UNESCO (pp. 200–210). Melbourne, VIC, Australia: CSIRO.
Toschi, I., Nocerino, E., Remondino, F., Revolti, A., Soria, G., & Piffer, S. (2017). Geospatial data processing for 3D city model generation, management and visualization. ISPRS International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences, 42(1/W1), 527–534. https://doi.org/10.5194/isprs-archives-XLII-1-W1-527-2017
Trubka, R., Glackin, S., Lade, O., & Pettit, C. (2016). A web-based 3D visualisation and assessment system for urban precinct scenario modelling. ISPRS Journal of Photogrammetry and Remote Sensing, 117, 175–186. https://doi.org/10.1016/j.isprsjprs.2015.12.003
Virtanen, J.-P., Jaalama, K., Puustinen, T., Julin, A., Hyyppä, J., & Hyyppä, H. (2021). Near real-time semantic view analysis of 3D city models in web browser. ISPRS International Journal of Geo-Information, 10(3), 138. https://doi.org/10.3390/ijgi10030138
Višnjevac, N., Mihajlović, R., Šoškić, M., Cvijetinović, Ž., & Bajat, B. (2019). Prototype of the 3D cadastral system based on a NoSQL database and a JavaScript visualization application. ISPRS International Journal of Geo-Information, 8(5), 227. https://doi.org/10.3390/ijgi8050227
Vitalis, S., Arroyo Ohori, K., & Stoter, J. (2020). CityJSON in QGIS: Development of an open-source plugin. Transactions in GIS, 24(5), 1147–1164. https://doi.org/10.1111/tgis.12657
Vitalis, S., Labetski, A., Boersma, F., Dahle, F., Li, X., Arroyo Ohori, K., … Stoter, J. (2020). CITYJSON + WEB = NINJA. ISPRS Annals of Photogrammetry, Remote Sensing and Spatial Information Sciences, 6(4/W1), 167–173. https://doi.org/10.5194/isprs-annals-VI-4-W1-2020-167-2020
Voutos, Y., Mylonas, P., Spyrou, E., & Charou, E. (2017). A social environmental sensor network integrated within a Web GIS platform. Journal of Sensor and Actuator Networks, 6(4), 27. https://doi.org/10.3390/jsan6040027
Weglarz, G. (2004). Two worlds of data: Unstructured and structured. Retrieved from http://www.dmreview.com/article_sub_articleId_1009161.html
Westerholt, R., & Resch, B. (2015). Asynchronous geospatial processing: An event-driven push-based architecture for the OGC web processing service. Transactions in GIS, 19(3), 455–479. https://doi.org/10.1111/tgis.12104
Yao, Z., Nagel, C., Kunde, F., Hudra, G., Willkomm, P., Donaubauer, A., … Kolbe, T. H. (2018). 3DCityDB: A 3D geodatabase solution for the management, analysis, and visualization of semantic 3D city models based on CityGML. Open Geospatial Data, Software and Standards, 3(1), 5. https://doi.org/10.1186/s40965-018-0046-7
Zhang, X., Song, W., & Liu, L. (2014). An implementation approach to store GIS spatial data in a NoSQL database. In Proceedings of the 22nd International Conference on Geoinformatics, Kaohsiung, Taiwan (pp. 1–5). Piscataway, NJ: IEEE.
Zlatanova, S., & Stoter, J. (2006). The role of DBMS in the new generation GIS architecture. In S. Rana & J. Sharma (Eds.), Frontiers of geographic information technology (pp. 155–180). Berlin, Germany: Springer.