Thanks for the quick reply. Do you mean to suggest that I can just include "proportionoverlap" in a SQL query even though it is not in the MapInfo7 manual nor in the pull-down listing of functions in the SQL dialog?
Just a (slightly) confused (relative) newbie (who likes using parentheses).
David Haschart Hughes Network Systems Germantown, Maryland, USA
At 01:39 PM 7/25/03 -0700, Gerasimtchouk, Renee wrote:
david-
Here is what I used recently for a zoning layer:
Q. Detect overlapping polys: (detects/queries the proportion overlap of Polygons)
A. first ensure your table has a unique row identifier then make a copy of the table then use the following sql (substitute the table and column headers for your own)
Select table1.id, copy1.id, proportionoverlap(table1.obj,copy1.obj) from table1, copy1 where table1.obj intersects copy1.obj And table1.id <> copy1.id into Selection Browse * From Selection
then used a set target>>erase to erase the overlap.
I'm not sure about slivers, anyone out there know how I can detect slivers, kind of like ArcMap's cluster tolerence?
_Renee
Reneé Gerasimtchouk Geographic Systems Specialist II Planning Department, rm. 400 (408)277-2294
-----Original Message----- From: David Haschart [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 1:28 PM To: [EMAIL PROTECTED] Subject: MI-L proportionoverlap?
Hello Folks,
I've seen this function (proportionoverlap) mentioned in previous discussions and it would seem to be the answer to my problem (at least my MapInfo problem). But when I looked for it (in the SQL select window) it was not present. Is this an add-in? or am I looking in the wrong place?
Thanks (in advance),
David Haschart Hughes Network Systems Germantown, Maryland, USA
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7779
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7781
