[postgis-users] Re: intersects(), touches(), overlaps() documentation issue
amitkulz at yahoo.com
Tue Mar 7 09:46:37 PST 2006
Hi Michael and Martin,
I have uploaded the .shp here, and have stripped it of any identifying
columns (I had to), but have included the .prj file just in case...
intersects(a,b) returns true
I don't know how to do a relate (a,b) to get the intersection matrix
for now, am rushed for time for now. Would you send me the actual SQL
query if possible? I can do it in next 30 mins or next week. I won't
have reliable access to a computer for about a week, will follow up
when I get back.
We have decided to clean up geometry completely in a desktop GIS before
reinserting it back to PostGIS. I saw some threads on inserting
valid/invalid geometries which strk said he needed help on. Does
anybody know what happened to that effort?
Thanks in advance for your help guys!
--- Amit Kulkarni <amitkulz at yahoo.com> wrote:
> I had a situation where a line overlapped another line for a very
> distance near its endpoints. touches() returned true but I was
> why my stored proc was not executing as it should. After some
> frustrated hours checking inside the loop, I thought to pull up the
> offending segments in a Desktop GIS and lo! I saw the overlap
> I was under the impression that touches() returns true and only true
> endpoints touched. Is that impression invalid? intersects() returns
> true but overlap() doesn't return true?
> I am attaching a jpeg. If needed I can attach a .shp
> Thanks for your input
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
More information about the postgis-users