Renee,

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



Reply via email to