ISPRS Annals of the Photogrammetry, Remote Sensing and Spatial Information Sciences
Download
Publications Copernicus
Download
Citation
Articles | Volume II-2/W1
https://doi.org/10.5194/isprsannals-II-2-W1-291-2013
https://doi.org/10.5194/isprsannals-II-2-W1-291-2013
13 Sep 2013
 | 13 Sep 2013

AN APPROACH TO DEVELOP 3D GEO-DBMS TOPOLOGICAL OPERATORS BY RE-USING EXISTING 2D OPERATORS

D. Xu and S. Zlatanova

Keywords: 3D, Geo-DBMS, 9IM, Oracle Spatial, topological function, city model

Abstract. Database systems are continuously extending their capabilities to store, process and analyse 3D data. Topological relationships which describe the interaction of objects in space is one of the important spatial issues. However, spatial operators for 3D objects are still insufficient. In this paper we present the development of a new 3D topological function to distinguish intersections of 3D planar polygons. The development uses existing 2D functions in the DBMS and two geometric transformations (rotation and projection). This function is tested for a real dataset to detect overlapping 3D city objects. The paper presents the algorithms and analyses the challenges. Suggestions for improvements of the current algorithm as well as possible extensions to handle more 3D topological cases are discussed at the end.