Oracle Selecting geometries inside polygon: Difference between revisions
From WickyWiki
Created page with "Select geometries that are fully or partially within a geometry, do not select geometries that touch from the outside. The selection geometry is (select geoColum2 from Table2 whe..." |
m 1 revision |
(No difference)
| |
Latest revision as of 07:26, 5 July 2013
Select geometries that are fully or partially within a geometry, do not select geometries that touch from the outside. The selection geometry is (select geoColum2 from Table2 where id=1).
select geoColumn1 from table1 t1, table2 t2 where SDO_RELATE(t1.geoColumn1 , t2.geoColumn2 , 'mask=inside+coveredby+overlapbdyintersect+overlapbdydisjoint+equal+on') = 'TRUE' and t2.id=1;