1 Reply Latest reply: Jan 8, 2014 2:51 AM by John O'Toole RSS

sdo_relate doesnt determine the overlap of postal codes

Jyothsna-Oracle Newbie
Currently Being Moderated

I am trying to find out if the postal codes overlap, using sdo_relate function. I used mask OVERLAPBDYINTERSECT with combination of INSIDE and OVERLAPBDYDISJOINT. but none of the combinations determine the overlap properly.

 

SRID is 8307.

 

Please suggest which function exactly determines the overlap of postal code geometry

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points