Volume II-2/W1
ISPRS Ann. Photogramm. Remote Sens. Spatial Inf. Sci., II-2/W1, 291-298, 2013
https://doi.org/10.5194/isprsannals-II-2-W1-291-2013
© Author(s) 2013. This work is distributed under
the Creative Commons Attribution 3.0 License.
ISPRS Ann. Photogramm. Remote Sens. Spatial Inf. Sci., II-2/W1, 291-298, 2013
https://doi.org/10.5194/isprsannals-II-2-W1-291-2013
© Author(s) 2013. This work is distributed under
the Creative Commons Attribution 3.0 License.

  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 D. Xu and S. Zlatanova
  • Jaffalaan 9, 2628 BX, Delft, the Netherlands

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.