Oracle Spatial Operator Test Cases
[Geometry]
These tests parallel the ones defined for the MgGeometry methods. With one set of exceptions, each test selects one geometry from the datastore and relates it to the geometry being passed into the sdo_relate function according to the mask argument. Each test should return the row referenced in the select statement. The set of exceptions concern the EnvelopeIntersects predicate. This set uses the sdo_filter function. The mask specifies one or more Oracle spatial operators OR'd together. The meaning of these spatial operators is reproduced for your convenience in the spatial relationships topic.
Before running the sql commands batch file, you must insert the following set of geometries into the Oracle datastore. The assumption is that you have applied a schema which defines an integer field for storing a feature id and a geometry field for storing points, lines, and polygons. It also assumes that you named the feature id field FEATID, the geometry field GEOMETRY, and the class FEATCLASS.
| FeatId | Geometry |
|---|---|
| 0 | POINT(1 1) |
| 1 | LINESTRING(0 1, 3 1) |
| 2 | POLYGON((0 0, 2 0, 2 2, 0 2, 0 0)) |
| 3 | MULTIPOINT(1 1, 2 1) |
| 4 | MULTIPOINT(2 1, 3 1, 5 1) |
| 5 | LINESTRING(2 1, 6 1) |
| 6 | POLYGON((1 0, 6 0, 6 2, 1 2, 1 0)) |
| 7 | POLYGON((2 0, 6 0, 6 2, 2 2, 2 0)) |
| 8 | LINESTRING(4 1, 7 1) |
| 9 | LINESTRING(3 1, 8 1) |
| 10 | LINESTRING(4 1, 8 1) |
| 11 | POLYGON((4 0, 8 0, 8 2, 4 2, 4 0)) |
| 12 | POLYGON((4 0, 8 0, 8 2, 3 2, 3 0)) |
| 13 | POLYGON(1 1, 4 1, 4 4, 1 4, 1 1)) |
| 14 | POLYGON((0 0, 5 0, 5 5, 0 5, 0 0)) |
| 15 | POLYGON((1 0, 5 0, 5 5, 1 5, 1 0)) |
| 16 | MULTIPOINT(2 1, 3 1) |
| 17 | LINESTRING(1 1, 2 1) |
Results
There are 89 tests. All were expected to return true. The following 31 tests returned false:
POINT(1 1):Contains:POINT(1 1) MULTIPOINT(1 1, 2 1):Contains:POINT(1 1) MULTIPOINT(2 1, 3 1, 5 1):Contains:MULTIPOINT(2 1, 3 1, 5 1) LINESTRING(4 1, 7 1):Contains:LINESTRING(4 1, 7 1) POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):Contains:POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)) LINESTRING(4 1, 7 1):CoveredBy:LINESTRING(4 1, 7 1) POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):CoveredBy:POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)) LINESTRING(4 1, 7 1):Crosses:POLYGON((4 0, 6 0, 6 2, 4 2, 4 0)) POINT(1 1):Disjoint:POINT(2 1) POINT(1 1):Disjoint:MULTIPOINT(2 1, 3 1, 5 1) POINT(1 1):Disjoint:LINESTRING(4 1, 7 1) POINT(1 1):Disjoint:POLYGON((2 1, 3 1, 3 2, 2 2, 2 1)) MULTIPOINT(2 1, 3 1, 5 1):Disjoint:MULTIPOINT(4 0, 7 0) MULTIPOINT(2 1, 3 1, 5 1):Disjoint:LINESTRING(4 0, 7 0) MULTIPOINT(2 1, 3 1, 5 1):Disjoint:POLYGON((0 0, 1 0, 1 1, 0 1, 0 0)) LINESTRING(4 1, 7 1):Disjoint:LINESTRING(4 0, 7 0) LINESTRING(4 1, 7 1):Disjoint:POLYGON((0 0, 1 0, 1 1, 0 1, 0 0)) POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):Disjoint:POLYGON((5 1, 6 1, 6 2, 5 2, 5 1)) POINT(1 1):Inside:POINT(1 1) POINT(1 1):Inside:MULTIPOINT(1 1, 2 1) POINT(1 1):Inside:LINESTRING(0 1, 2 1) MULTIPOINT(2 1, 3 1, 5 1):Inside:MULTIPOINT(2 1, 3 1, 5 1) MULTIPOINT(2 1, 3 1, 5 1):Inside:LINESTRING(1 1, 6 1) LINESTRING(4 1, 7 1):Inside:LINESTRING(3 1, 8 1) MULTIPOINT(2 1, 3 1):Overlaps:MULTIPOINT(3 1, 5 1) LINESTRING(4 1, 7 1):Overlaps:LINESTRING(6 1, 8 1) POINT(1 1):Within:POINT(1 1) POINT(1 1):Within:MULTIPOINT(1 1, 2 1) MULTIPOINT(2 1, 3 1, 5 1):Within:MULTIPOINT(2 1, 3 1, 5 1) LINESTRING(4 1, 7 1):Within:LINESTRING(4 1, 7 1) POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):Within:POLYGON((1 1, 4 1, 4 4, 1 4, 1 1))
Contains
REM POINT(1 1):Contains:POINT(1 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 0 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(1,1,NULL), NULL, NULL), 'mask=contains+covers') = 'TRUE'; REM LINSTRING(0 1, 2 1):Contains:POINT(1 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 1 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(1,1,NULL), NULL, NULL), 'mask=contains+covers') = 'TRUE'; REM POLYGON((0 0, 2 0, 2 2, 0 2, 0 0)):Contains:POINT(1 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 2 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(1,1,NULL), NULL, NULL), 'mask=contains+covers') = 'TRUE'; REM MULTIPOINT(1 1, 2 1):Contains:POINT(1 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 3 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(1,1,NULL), NULL, NULL), 'mask=contains+covers') = 'TRUE'; REM MULTIPOINT(2 1, 3 1, 5 1):Contains:MULTIPOINT(2 1, 3 1, 5 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 4 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2005, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1,3), MDSYS.SDO_ORDINATE_ARRAY(2,1, 3,1, 5,1)), 'mask=contains+covers') = 'TRUE'; REM LINESTRING(2 1, 6 1):Contains:MULTIPOINT(2 1, 3 1, 5 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 5 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2005, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1,3), MDSYS.SDO_ORDINATE_ARRAY(2,1, 3,1, 5,1)), 'mask=contains+covers') = 'TRUE'; REM POLYGON((1 0, 6 0, 6 2, 1 2, 1 0)):Contains:MULTIPOINT(2 1, 3 1, 5 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 6 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2005, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1,3), MDSYS.SDO_ORDINATE_ARRAY(2,1, 3,1, 5,1)), 'mask=contains+covers') = 'TRUE'; REM POLYGON((2 0, 6 0, 6 2, 2 2, 2 0)):Contains:MULTIPOINT(2 1, 3 1, 5 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 7 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2005, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1,3), MDSYS.SDO_ORDINATE_ARRAY(2,1, 3,1, 5,1)), 'mask=contains+covers') = 'TRUE'; REM LINESTRING(4 1, 7 1):Contains:LINESTRING(4 1, 7 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(4,1, 7,1)), 'mask=contains+covers') = 'TRUE'; REM LINESTRING(3 1, 8 1):Contains:LINESTRING(4 1, 7 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 9 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(4,1, 7,1)), 'mask=contains+covers') = 'TRUE'; REM LINESTRING(4 1, 8 1):Contains:LINESTRING(4 1, 7 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 10 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(4,1, 7,1)), 'mask=contains+covers') = 'TRUE'; REM POLYGON((4 0, 8 0, 8 2, 4 2, 4 0)):Contains:LINESTRING(4 1, 7 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 11 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(4,1, 7,1)), 'mask=contains+covers') = 'TRUE'; REM POLYGON((3 0, 8 0, 8 2, 3 2, 3 0)):Contains:LINESTRING(4 1, 7 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 12 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(4,1, 7,1)), 'mask=contains+covers') = 'TRUE'; REM POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):Contains:POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 13 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(1,1, 4,1, 4,4, 1,4, 1,1)), 'mask=contains+covers') = 'TRUE'; REM POLYGON((0 0, 5 0, 5 5, 0 5, 0 0)):Contains:POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 14 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(1,1, 4,1, 4,4, 1,4, 1,1)), 'mask=contains+covers') = 'TRUE'; REM POLYGON((1 0, 5 0, 5 5, 1 5, 1 0)):Contains:POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 15 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(1,1, 4,1, 4,4, 1,4, 1,1)), 'mask=contains+covers') = 'TRUE';
CoveredBy
REM LINESTRING(4 1, 7 1):CoveredBy:LINESTRING(4 1, 7 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(4,1, 7,1)), 'mask=coveredby') = 'TRUE'; REM LINESTRING(4 1, 7 1):CoveredBy:LINESTRING(4 1, 8 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(4,1, 8,1)), 'mask=coveredby') = 'TRUE'; REM LINESTRING(4 1, 7 1):CoveredBy:POLYGON((4 0, 8 0, 8 2, 4 2, 4 0)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(4,0, 8,0, 8,2, 4,2, 4,0)), 'mask=coveredby') = 'TRUE'; REM POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):CoveredBy:POLYGON((1 0, 5 0, 5 5, 1 5, 1 0)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 13 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(1,0, 5,0, 5,5, 1,5, 1,0)), 'mask=coveredby') = 'TRUE'; REM POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):CoveredBy:POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 13 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(1,1, 4,1, 4,4, 1,4, 1,1)), 'mask=coveredby') = 'TRUE';
Crosses
REM MULTIPOINT(2 1, 3 1, 5 1):Crosses:LINESTRING(4 1, 7 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 4 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(4,1, 7,1)), 'mask=overlapbdydisjoint') = 'TRUE'; REM MULTIPOINT(2 1, 3 1, 5 1):Crosses:POLYGON((1 0, 4 0, 4 2, 1 2, 1 0)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 4 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(1,0, 4,0, 4,2, 1,2, 1,0)), 'mask=overlapbdydisjoint') = 'TRUE'; REM LINESTRING(4 1, 7 1):Crosses:LINESTRING(5 0, 5 2) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(5,0, 5,2)), 'mask=overlapbdydisjoint') = 'TRUE'; REM LINESTRING(4 1, 7 1):Crosses:POLYGON((4 0, 6 0, 6 2, 4 2, 4 0)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(4,0, 6,0, 6,2, 4,2, 4,0)), 'mask=overlapbdydisjoint') = 'TRUE'; REM LINESTRING(4 1, 7 1):Crosses:POLYGON((5 0, 6 0, 6 2, 5 2, 5 0)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(5,0, 6,0, 6,2, 5,2, 5,0)), 'mask=overlapbdydisjoint') = 'TRUE'; REM LINESTRING(4 1, 7 1):Crosses:POLYGON((5 0, 8 0, 8 2, 5 2, 5 0)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(5,0, 8,0, 8,2, 5,2, 5,0)), 'mask=overlapbdydisjoint') = 'TRUE';
Disjoint
REM POINT(1 1):Disjoint:POINT(2 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 0 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(2,1,NULL), NULL, NULL), 'mask=disjoint') = 'TRUE'; REM POINT(1 1):Disjoint:MULTIPOINT(2 1, 3 1, 5 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 0 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2005, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1,3), MDSYS.SDO_ORDINATE_ARRAY(2,1, 3,1, 5,1)), 'mask=disjoint') = 'TRUE'; REM POINT(1 1):Disjoint:LINESTRING(4 1, 7 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 0 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(4,1, 7,1)), 'mask=disjoint') = 'TRUE'; REM POINT(1 1):Disjoint:POLYGON((2 1, 3 1, 3 2, 2 2, 2 1)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 0 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(2,1, 3,1, 3,2, 2,2, 2,1)), 'mask=disjoint') = 'TRUE'; REM MULTIPOINT(2 1, 3 1, 5 1):Disjoint:MULTIPOINT(4 0, 7 0) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 4 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2005, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1,2), MDSYS.SDO_ORDINATE_ARRAY(4,0, 7,0)), 'mask=disjoint') = 'TRUE'; REM MULTIPOINT(2 1, 3 1, 5 1):Disjoint:LINESTRING(4 0, 7 0) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 4 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(4,0, 7,0)), 'mask=disjoint') = 'TRUE'; REM MULTIPOINT(2 1, 3 1, 5 1):Disjoint:POLYGON((0 0, 1 0, 1 1, 0 1, 0 0)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 4 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(0,0, 1,0, 1,1, 0,1, 0,0)), 'mask=disjoint') = 'TRUE'; REM LINESTRING(4 1, 7 1):Disjoint:LINESTRING(4 0, 7 0) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(4,0, 7,0)), 'mask=disjoint') = 'TRUE'; REM LINESTRING(4 1, 7 1):Disjoint:POLYGON((0 0, 1 0, 1 1, 0 1, 0 0)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(0,0, 1,0, 1,1, 0,1, 0,0)), 'mask=disjoint') = 'TRUE'; REM POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):Disjoint:POLYGON((5 1, 6 1, 6 2, 5 2, 5 1)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 13 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(5,1, 6,1, 6,2, 5,2, 5,1)), 'mask=disjoint') = 'TRUE';
Equals
REM POINT(1 1):Equals:POINT(1 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 0 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(1,1,NULL), NULL, NULL), 'mask=equal') = 'TRUE'; REM MULTIPOINT(2 1, 3 1, 5 1):Equals:MULTIPOINT(2 1, 3 1, 5 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 4 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2005, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1,3), MDSYS.SDO_ORDINATE_ARRAY(2,1, 3,1, 5,1)), 'mask=equal') = 'TRUE'; REM LINESTRING(4 1, 7 1):Equals:LINESTRING(4 1, 7 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(4,1, 7,1)), 'mask=equal') = 'TRUE'; REM POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):Equals:POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 13 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(1,1, 4,1, 4,4, 1,4, 1,1)), 'mask=equal') = 'TRUE';
EnvelopeIntersects
REM POINT(1 1):EnvelopeIntersects:POINT(1 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 0 and sdo_filter(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(1,1,NULL), NULL, NULL), 'querytype = WINDOW') = 'TRUE'; REM MULTIPOINT(2 1, 3 1, 5 1):EnvelopeIntersects:MULTIPOINT(2 1, 3 1, 5 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 4 and sdo_filter(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2005, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1,3), MDSYS.SDO_ORDINATE_ARRAY(2,1, 3,1, 5,1)), 'querytype = WINDOW') = 'TRUE'; REM LINESTRING(4 1, 7 1):EnvelopeIntersects:LINESTRING(4 1, 7 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_filter(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(4,1, 7,1)), 'querytype = WINDOW') = 'TRUE'; REM POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):EnvelopeIntersects:POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 13 and sdo_filter(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(1,1, 4,1, 4,4, 1,4, 1,1)), 'querytype = WINDOW') = 'TRUE';
Inside
REM POINT(1 1):Inside:POINT(1 1) select a.FEATID,a.GEOEMTRY from FEATCLASS a where a.FEATID = 0 and sdo_relate(a.GEOEMTRY, MDSYS.SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(1,1,NULL), NULL, NULL), 'mask=inside') = 'TRUE'; REM POINT(1 1):Inside:MULTIPOINT(1 1, 2 1) select a.FEATID,a.GEOEMTRY from FEATCLASS a where a.FEATID = 0 and sdo_relate(a.GEOEMTRY, MDSYS.SDO_GEOMETRY(2005, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1,2), MDSYS.SDO_ORDINATE_ARRAY(1,1, 2,1)), 'mask=inside') = 'TRUE'; REM POINT(1 1):Inside:LINESTRING(0 1, 2 1) select a.FEATID,a.GEOEMTRY from FEATCLASS a where a.FEATID = 0 and sdo_relate(a.GEOEMTRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(0,1, 2,1)), 'mask=inside') = 'TRUE'; REM POINT(1 1):Inside:POLYGON((0 0, 2 0, 2 2, 0 2, 0 0)) select a.FEATID,a.GEOEMTRY from FEATCLASS a where a.FEATID = 0 and sdo_relate(a.GEOEMTRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(0,0, 2,0, 2,2, 0,2, 0,0)), 'mask=inside') = 'TRUE'; REM MULTIPOINT(2 1, 3 1, 5 1):Inside:MULTIPOINT(2 1, 3 1, 5 1) select a.FEATID,a.GEOEMTRY from FEATCLASS a where a.FEATID = 4 and sdo_relate(a.GEOEMTRY, MDSYS.SDO_GEOMETRY(2005, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1,3), MDSYS.SDO_ORDINATE_ARRAY(2,1, 3,1, 5,1)), 'mask=inside') = 'TRUE'; REM MULTIPOINT(2 1, 3 1, 5 1):Inside:LINESTRING(1 1, 6 1) select a.FEATID,a.GEOEMTRY from FEATCLASS a where a.FEATID = 4 and sdo_relate(a.GEOEMTRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(1,1, 6,1)), 'mask=inside') = 'TRUE'; REM MULTIPOINT(2 1, 3 1, 5 1):Inside:POLYGON((1 0, 6 0, 6 2, 1 2, 1 0)) select a.FEATID,a.GEOEMTRY from FEATCLASS a where a.FEATID = 4 and sdo_relate(a.GEOEMTRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(1,0, 6,0, 6,2, 1,2, 1,0)), 'mask=inside') = 'TRUE'; REM LINESTRING(4 1, 7 1):Inside:LINESTRING(3 1, 8 1) select a.FEATID,a.GEOEMTRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOEMTRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(3,1, 8,1)), 'mask=inside') = 'TRUE'; REM LINESTRING(4 1, 7 1):Inside:POLYGON((3 0, 8 0, 8 2, 3 2, 3 0)) select a.FEATID,a.GEOEMTRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOEMTRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(3,0, 8,0, 8,2, 3,2, 3,0)), 'mask=inside') = 'TRUE'; REM POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):Inside:POLYGON((0 0, 5 0, 5 5, 0 5, 0 0)) select a.FEATID,a.GEOEMTRY from FEATCLASS a where a.FEATID = 13 and sdo_relate(a.GEOEMTRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(0,0, 5,0, 5,5, 0,5, 0,0)), 'mask=inside') = 'TRUE';
Intersects
REM POINT(1 1):Intersects:POINT(1 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 0 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(1,1,NULL), NULL, NULL), 'mask=anyinteract') = 'TRUE'; REM MULTIPOINT(2 1, 3 1, 5 1):Intersects:MULTIPOINT(2 1, 3 1, 5 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 4 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2005, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1,3), MDSYS.SDO_ORDINATE_ARRAY(2,1, 3,1, 5,1)), 'mask=anyinteract') = 'TRUE'; REM LINESTRING(4 1, 7 1):Intersects:LINESTRING(4 1, 7 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(4,1, 7,1)), 'mask=anyinteract') = 'TRUE'; REM POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):Intersects:POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 13 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(1,1, 4,1, 4,4, 1,4, 1,1)), 'mask=anyinteract') = 'TRUE';
Overlaps
REM MULTIPOINT(2 1, 3 1):Overlaps:MULTIPOINT(3 1, 5 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 16 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2005, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1,2), MDSYS.SDO_ORDINATE_ARRAY(3,1, 5,1)), 'mask=overlapbdyintersect') = 'TRUE'; REM LINESTRING(4 1, 7 1):Overlaps:LINESTRING(6 1, 8 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(6,1, 8,1)), 'mask=overlapbdyintersect') = 'TRUE'; REM POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):Overlaps:POLYGON((0 2, 5 2, 5 3, 0 3, 0 2)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 13 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(0,2, 5,2, 5,3, 0,3, 0,2)), 'mask=overlapbdyintersect') = 'TRUE'; REM POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):Overlaps:POLYGON((0 2, 3 2, 3 3, 0 3, 0 2)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 13 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(0,2, 3,2, 3,3, 0,3, 0,2)), 'mask=overlapbdyintersect') = 'TRUE';
Touches
REM POINT(1 1):Touches:LINESTRING(1 1, 2 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 0 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(1,1, 2,1)), 'mask=touch') = 'TRUE'; REM POINT(1 1):Touches:POLYGON((0 0, 1 0, 1 1, 0 1, 0 0)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 0 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(0,0, 1,0, 1,1, 0,1, 0,0)), 'mask=touch') = 'TRUE'; REM MULTIPOINT(2 1, 3 1):Touches:LINESTRING(3 1, 4 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 16 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(3,1, 4,1)), 'mask=touch') = 'TRUE'; REM MULTIPOINT(1 1, 2 1):Touches:POLYGON((0 0, 1 0, 1 1, 0 1, 0 0)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 3 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(0,0, 1,0, 1,1, 0,1, 0,0)), 'mask=touch') = 'TRUE'; REM LINESTRING(4 1, 7 1):Touches:LINESTRING(5 1, 5 2) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(5,1, 5,2)), 'mask=touch') = 'TRUE'; REM LINESTRING(4 1, 7 1):Touches:LINESTRING(4 1, 4 2) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(4,1, 4,2)), 'mask=touch') = 'TRUE'; REM LINESTRING(1 1, 2 1):Touches:POLYGON((0 0, 1 0, 1 1, 0 1, 0 0)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 17 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(0,0, 1,0, 1,1, 0,1, 0,0)), 'mask=touch') = 'TRUE'; REM POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):Touches:POLYGON((4 4, 5 5, 4 6, 3 5, 4 4)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 13 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(4,4, 5,5, 4,6, 3,5, 4,4)), 'mask=touch') = 'TRUE'; REM POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):Touches:POLYGON((4 2, 5 2, 5 3, 4 3, 4 2)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 13 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(4,2, 5,2, 5,3, 4,3, 4,2)), 'mask=touch') = 'TRUE';
Within
REM POINT(1 1):Within:POINT(1 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 0 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(1,1,NULL), NULL, NULL), 'mask=inside+coveredby') = 'TRUE'; REM POINT(1 1):Within:MULTIPOINT(1 1, 2 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 0 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2005, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1,2), MDSYS.SDO_ORDINATE_ARRAY(1,1, 2,1)), 'mask=inside+coveredby') = 'TRUE'; REM POINT(1 1):Within:LINESTRING(0 1, 2 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 0 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(0,1, 2,1)), 'mask=inside+coveredby') = 'TRUE'; REM POINT(1 1):Within:POLYGON((0 0, 2 0, 2 2, 0 2, 0 0)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 0 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(0,0, 2,0, 2,2, 0,2, 0,0)), 'mask=inside+coveredby') = 'TRUE'; REM MULTIPOINT(2 1, 3 1, 5 1):Within:MULTIPOINT(2 1, 3 1, 5 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 4 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2005, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1,3), MDSYS.SDO_ORDINATE_ARRAY(2,1, 3,1, 5,1)), 'mask=inside+coveredby') = 'TRUE'; REM MULTIPOINT(2 1, 3 1, 5 1):Within:LINESTRING(1 1, 6 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 4 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(1,1, 6,1)), 'mask=inside+coveredby') = 'TRUE'; REM MULTIPOINT(2 1, 3 1, 5 1):Within:LINESTRING(2 1, 6 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 4 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(2,1, 6,1)), 'mask=inside+coveredby') = 'TRUE'; REM MULTIPOINT(2 1, 3 1, 5 1):Within:POLYGON((1 0, 6 0, 6 2, 1 2, 1 0)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 4 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(1,0, 6,0, 6,2, 1,2, 1,0)), 'mask=inside+coveredby') = 'TRUE'; REM MULTIPOINT(2 1, 3 1, 5 1):Within:POLYGON((2 0, 6 0, 6 2, 2 2, 2 0)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 4 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(2,0, 6,0, 6,2, 2,2, 2,0)), 'mask=inside+coveredby') = 'TRUE'; REM LINESTRING(4 1, 7 1):Within:LINESTRING(4 1, 7 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(4,1, 7,1)), 'mask=inside+coveredby') = 'TRUE'; REM LINESTRING(4 1, 7 1):Within:LINESTRING(3 1, 8 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(3,1, 8,1)), 'mask=inside+coveredby') = 'TRUE'; REM LINESTRING(4 1, 7 1):Within:LINESTRING(4 1, 8 1) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2002, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(4,1, 8,1)), 'mask=inside+coveredby') = 'TRUE'; REM LINESTRING(4 1, 7 1):Within:POLYGON((4 0, 8 0, 8 2, 4 2, 4 0)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(4,0, 8,0, 8,2, 4,2, 4,0)), 'mask=inside+coveredby') = 'TRUE'; REM LINESTRING(4 1, 7 1):Within:POLYGON((3 0, 8 0, 8 2, 3 2, 3 0)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 8 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(3,0, 8,0, 8,2, 3,2, 3,0)), 'mask=inside+coveredby') = 'TRUE'; REM POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):Within:POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 13 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(1,1, 4,1, 4,4, 1,4, 1,1)), 'mask=inside+coveredby') = 'TRUE'; REM POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):Within:POLYGON((0 0, 5 0, 5 5, 0 5, 0 0)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 13 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(0,0, 5,0, 5,5, 0,5, 0,0)), 'mask=inside+coveredby') = 'TRUE'; REM POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)):Within:POLYGON((1 0, 5 0, 5 5, 1 5, 1 0)) select a.FEATID,a.GEOMETRY from FEATCLASS a where a.FEATID = 13 and sdo_relate(a.GEOMETRY, MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), MDSYS.SDO_ORDINATE_ARRAY(1,0, 5,0, 5,5, 1,5, 1,0)), 'mask=inside+coveredby') = 'TRUE';