Oracle Spatial, Geometries

2008 ◽  
pp. 821-826 ◽  
Author(s):  
Ravi Kothuri ◽  
Siva Ravada
Keyword(s):  
2014 ◽  
Vol 571-572 ◽  
pp. 600-605
Author(s):  
Lei Gang Sun ◽  
Jian Feng Liu ◽  
Quan Hong Xu

The application requirement of Geospatial data is increasing and complex as it is getting numerous as a result of furthering study on geosciences. Based on a deeply research on Oracle Spatial storage management mechanism, this paper proposed a method that applies the graph theory to domain of optimizing spatial query of massive geographical data, and established a geospatial data query model in order to settle a problem of lower spatial query efficiency in geospatial database. Combining with the practical applications, this paper did a conventional spatial query test and a spatial query based on geospatial data model respectively. The result is that the spatial query based on geospatial data query model has a better efficiency than that on conventional method. Besides, this model can greatly improve the spatial query performance and this improvement will be increasingly apparent as the data volume increases.


2019 ◽  
pp. 1371-1385
Author(s):  
Tuncer Ozerbıl ◽  
Ergun Gokten ◽  
Mustafa Onder ◽  
Osman Selcuk ◽  
Nilhan Ciftci Sarılar ◽  
...  

Usage of aerial oblique cameras and oblique images in generation of 3D city models has become popular all over the world in recent years and various solutions has been developed involving specialized methods and softwares. The first comprehensive step in this field was taken by Konya Metropolitan Municipality in Turkey in 2012 and the project undertaken by GEOGIS has been successfully completed in February 2014. It is the first time in Turkey that 3D city model of this large scale has been generated. The project involves: Aerial image acquisition of the project area with vertical and oblique cameras respectively and photogrammetric triangulation; Development of OttoPenta software, which can display oblique images in pentaview screen, make spatial queries and also can measure the horizontal, vertical distance and area; Digitization of roof and roof structures from vertical stereo images using photogrammetric interpretation techniques and generation of 3D solid building models using this data; Assigning building ID numbers to solid models to integrate with the GIS data of the Municipality that is available in Oracle Spatial database; Automatic texturing of 3D models with oblique images; Exporting of textured 3D models into Oracle Spatial Database in CityGML format, complying the OGC standards; and development of KNVCity software, to create and publish the 3D city guide on WEB and mobile devices. The goal of this paper is sharing the experience and knowledge that was gained during the 3D City modeling and 3D city guide project which was performed for the first time in Turkey.


Sign in / Sign up

Export Citation Format

Share Document