• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 457
  • Last Modified:

Difficult spatial query using MapInfo

I have a relation/ table (table1) of sites/ land areas. The relation consist of the attributes/ columns site_id (integer), sub_site_id (integer) and spat_obj (wich is the spatial object representing the site). All the sites sharing the same site_id are supposed to touch each other (at least sharing a point) either directly or indirectly (trough a third site sharing the same site_id).

Unfortunately "supposted to" is not the same as "is". Can somebody help me with a query that picks out the sites that shares site_id but don't touch each other?
0
tunheim
Asked:
tunheim
  • 2
1 Solution
 
nico5038Commented:
Did you check the mapinfo site.

I ran into a query to check for "inside an area":
http://testdrive.mapinfo.com/techsupp/miprod.nsf/5c41496d5951a49c852562b5004f3a44/9531c97c90deaba88525654e00706ab5?OpenDocument

But under >Mapinfo >SQL select of the link:
http://testdrive.mapinfo.com/kbase_by_product
There are a lot of other queries defined.

Nic;o)
0
 
nico5038Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - PAQ'd and pts removed
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now