The International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences
Download
Share
Publications Copernicus
Download
Citation
Share
Articles | Volume XLVIII-2/W10-2025
https://doi.org/10.5194/isprs-archives-XLVIII-2-W10-2025-231-2025
https://doi.org/10.5194/isprs-archives-XLVIII-2-W10-2025-231-2025
07 Jul 2025
 | 07 Jul 2025

Database Federation for Spatial Digital Twins with Semantically Enhanced Data Processing: A use case of Mission Mjøsa

Sajith Ranatunga, Rune Strand Ødegård, Erling Onstein, and Knut Jetlund

Keywords: Semantic Web Technologies, OBDA, SPARQL, Database Federation, Spatial Digital Twin

Abstract. Developing spatial digital twins (SDTs) for inland water bodies requires addressing challenges such as temporal variability, dynamic water surface conditions, and heterogeneous water datasets. This study presents a semantic integration framework combining Ontology-Based Data Access (OBDA) with PostgreSQL database federation to support real-time decision-making in SDT applications. The framework integrates hydrological data, sensor networks, bathymetric data, and other static datasets under a unified ontology, enabling federated SPARQL queries without centralizing data. A 3D visualization interface allows interactive analysis of results from the SPARQL queries. Demonstrated through the Mission Mjøsa use case, this approach supports inland water mapping and decision support by aligning spatial data across domains. The framework offers a scalable solution for water data processing, semantic fusion, and scenario-based simulation, contributing to the development of intelligent, semantically enriched SDTs for sustainable environment management.

Share