Abstract:The spatial data are processed via editing, query and other complicated analysis with spatial arithmetic operators provided by Oracle Spatial and SQL. In general, abnormal conditions will not occur in the operation with spatial arithmetic operators. In case the number of points of a polygon reaches 60000 or the number of inner rings of a polygon exceeds 200, errors may occur in the intersection overlay operation for spatial geometrical data and the connection between the system and Oracle database will be interrupted. For specific situation of GIS application in China, a polygon of a single parcel, as may occur in land resource investigation, sometimes includes 90000 points, even exceeding 120000 points, and the number of inner rings may far exceed 200. A bug is discovered by the authors in the application of spatial overlay analysis on the national city and county administrative map and national land use map at scale of 1:4000000. After a lot of tests and discuss with Oracle Corporation, the bug is finally confirmed by Oracle Corporation as a new bug (with bug ID of 3146244). To address the limitation of Oracle Spatial in processing vast massive spatial data, an algorithm of "Coordinate reduction intersection overlay" is presented after deeply analyzing the cause of the bug. The appropriate thresholds are decided depending upon the accuracy of analysis for spatial data overlay. Furthermore we have developed an extended module based on this algorithm. The correctness and validity of the solution on the algorithm have been testified by using the same spatial data in which the bug occurred for Oracle Spatial. The study results have been used in the land resource investigation and other fields in Zhejiang province of China.

Fuzzy property and operation algorithms for GIS data model

Fuzzy Morphological Operations in GIS

Fuzzy topological relations between fuzzy spatial objects

Research of the Algorithms of Polygon’s Overlay

Unified Spatial Intersection Algorithms Based on Conformal Geometric Algebra

Fuzzy Geographical Object Modeling Based on Vector Data Model

An Unified CGA-Based Formal Expression of Spatio-Temporal Topological Relations for Computation and Analysis of Geographic Objects

Mechanism and methods of fuzzy geographical object modeling

Building Fuzzy Areal Geographical Objects from Point Sets

Manipulation of Spatial Graphical Data in RDBMS and Its Implementation in Application of GIS

Fuzzy description of topological relations II: computation methods and examples

Network-oriented Massive Spatio-Temporal Data Model and Its Applications

A Review of Fuzzy Sets on Spatial Data Handling

Geographic phenomena data model with fuzzy boundaries

Boolean Operation of Non-Regular Precise Geometric Models

A Study on TGIS Based on Dynamic Multilevel Base State with Amendments

Vector Map Overlay Algorithm Based on Improved Quadtree Indexing

Limitation of Oracle in Management of Vast Massive Points of a Polygon and the Solution

Double-quantitative $γ^{\ast}-$fuzzy coverings approximation operators

Some Einstein interaction geometric aggregation operators based on improved operational laws of complex q-rung orthopair fuzzy set and their applications

A GIS Approach to the Urban Land Suitability Evaluation