Oracle Selecting geometries inside polygon

From WickyWiki
Revision as of 07:26, 5 July 2013 by Admin (talk | contribs) (1 revision)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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;