Query to find overlapping lines?
444920Feb 21 2007 — edited Feb 23 2007I want to identify lines that overlap. Not necessarily ones that are equal, but that overlap. I have a situation where there could be a 10m line and there is also a 5m line directly in top of a 5m section of that 10m line. I've tried all the sdo_relate masks but "touch" seems to be the only one that returns true but that returns true for every set of lines that just touch at a single point also so this is of no use to me on this occasion. Do the sdo_relate functions just work for polygons? I would have thought that covers/coveredby/on would return the set of geometries that interest me but it's returning nothing.
I'm using Oracle 10.2.0.3..