2 Replies Latest reply on Dec 24, 2013 1:41 PM by Stefan Jager

    Check for overlaps in polygons


      I want to get a list of all the polygons from table 2 which overlap with one polygon from table 1. Following is the query which I am trying to use which doesnt give any result.

      Select b.bg_id from table1 a,table2 b

      where a.store_id = ' 74073'

      AND SDO_Relate(a.geometry,b.geometry,'mask=anyinteract')='TRUE';

      Any suggestions on what would be wrong here.

      Thank You.