Changes between Version 11 and Version 12 of FDORfc39


Ignore:
Timestamp:
Jun 25, 2009, 10:09:36 AM (15 years ago)
Author:
danstoica
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • FDORfc39

    v11 v12  
    2323== Overview ==
    2424
    25 This RFC is for adding spatial operator combinations support.
     25This RFC is for adding spatial operator combinations support (the RELATE spatial operator).
    2626
    2727== Motivation ==
    2828
    29 Allows implementation of the RELATE spatial filter.
     29Along with the standard named spatial operators which FDO already suppotrs, OGS specifies the Relate predicate based on the pattern matrix which has the advantage that clients can test for a large number of spatial relationships and fine tune the particular relationship being tested; This pattern matrix is called the Extended Nine-Intersection Model (DE-9IM); see Reference [1].
    3030
     31This model has been adopted by MS SqlServer 2008 and PostGIS databases following the OGS syntax, like:
     32      STRelate('T*F**F***') for 'Within'
     33
     34Oracle supports Relate as well but in more readable form, like:
     35      SDO_RELATE(... 'mask=touch+coveredby') = 'TRUE';
     36
     37Therefore supporting Relate implies providing the ability to generate DE-9IM strings based on a OR mask . Note it is not possible to generate an unambiguous OR mask given a DE-9IM string.
    3138
    3239== Proposed Solution ==
     40
     41Obviously generating valid strings for spatial operation combinations in DE-9IM form is not easy and this task must be accomplished by FDO. In turn, FDO will present the user the list of available named operators which can be combined in a bitmapped mask.
    3342
    3443A number of changes in FDO are proposed:
     
    153162
    154163== Referencies ==
    155 [1] [http://portal.opengeospatial.org/files/?artifact_id=18241] - Extended Nine-Intersection Model (DE-9IM) [[BR]]
     164[1] OpenGIS® Implementation Specification for Geographic information - Simple feature access - Part 1: Common architecture - Extended Nine, 6.1.15.2 The Dimensionally Extended Nine-Intersection Model (DE-9IM) [[BR]]
    156165[2] [http://download-west.oracle.com/docs/cd/B19306_01/appdev.102/b14255/sdo_operat.htm#i78531] - Oracle SDO_RELATE() operator[[BR]]
    157166[3] [http://msdn.microsoft.com/en-us/library/bb933915.aspx] - SqlServer2008 STRelate() operator[[BR]]