Hi Peter,
Instead of buffering inwards, you could try a query along the following
lines:
select *
from table1, table2
where table1.obj intersects table2.obj
and proportionoverlap(table1.obj , table2.obj) > 0
This should return exactly what you want, whereas I think the buffering
technique may exclude polygons with a very small degree of overlap. The
drawback is that you cannot use the subselect style, and hence will be
left with a joined table.
The problem of duplicate records being returned will be encountered, but
can be solved using the method described with the subselect technique
(Peter Horsbøll Møller's posting).
Andrew
Peter Hatton wrote:
Hi all,
hoping someone can help me with the following .... I
have two tables, each containing objects, and I want to perform a query
between the two to find the objects from table 1 that intersect with table
2. The problem is that I don't want the objects from table 1 that only
adjoin table 2 ...... in other words I need to internally buffer table 2 (
.01 of a metre ) as part of the query so that I don't get the adjoining
objects in my result. We are currently doing a similiar thing with a query
in Exponare but I just can't seem to get the Mapinfo query to work along
similiar lines.
Many thanks
Peter
Peter HATTON
GIS Officer
Greater Taree City Council
2 Pulteney Street TAREE 2430
phone 02 6592 5227
e-mail [EMAIL PROTECTED] gov.au
This email and any files transmitted with it are intended soley for
the use of the individual or entity to whom they are addressed.
Greater Taree City Council is a government organisation and is subject
to Freedom of Information legislation. You must assume that any
material sent to Greater Taree City Council may be accessible by
persons other than the intended recipient.
The contents of this message may express views and opinions
not necessarily shared by Greater Taree City Council.
This e-mail has been scanned for viruses by MCI's Internet Managed
Scanning Services - powered by MessageLabs. For further information
visit http://www.mci.com
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 17603
--
----------------------
Andrew Harfoot
Geodata Institute
University of Southampton
tel: +44 (0) 23 80592719
fax: +44 (0) 23 80592849
[EMAIL PROTECTED]
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 17707
