To define an Oracle spatial filter
For more information about Spatial Relationship Settings, see Data Model: Spatial Relationship Settings.
The Global Spatial Mask settings are different for SQL Server than they are for Oracle. These are the following spatial intersection patterns:
Global Spatial Mask |
Description |
Available in Oracle |
Available in SQL Server |
Available in SQLite (Industry Model Drawings) |
CONTAINS |
The interior and boundary of one object is completely contained in the interior of the other object. |
Yes | Yes | |
COVEREDBY |
One object is covered by the interior and boundary of the given geometry. |
Yes | Yes | |
CROSS |
The interior of one object intersects the boundary and interior of the other object, but the two boundaries do not intersect. |
Yes | Yes | Yes |
DISJOINT |
The boundaries and interiors do not intersect. |
Yes | Yes | Yes |
ENVELOPENTERSECTS |
The boundaries of two objects intersect. |
Yes | Yes | Yes |
EQUALS |
The two objects have the same boundary and interior. |
Yes | ||
INSIDE |
The object is inside the interior of the other object, not touching the boundary. |
Yes | Yes | Yes |
INTERSECTS |
The interior and boundary of the two objects cross (No Disjoint) |
Yes | Yes | Yes |
OVERLAP |
The boundary and interior of two objects intersect. |
Yes | Yes | |
TOUCHES |
The boundaries intersect, but the interiors do not intersect. |
Yes | Yes | |
WITHIN |
The interior and boundary of one object is completely within the interior of the other object. |
Yes | Yes |
For more information, see the Oracle Spatial documentation.