2 Replies Latest reply: Dec 24, 2013 7:41 AM by Stefan Jager RSS

    Check for overlaps in polygons

    NathanT

      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.