Let’s say you have a MapInfo polygon layer called “Regions,” and a point layer called “Points.” You can get find out which Region each Point is inside using a MapInfo SQL query like:
SELECT Points.id,Regions.id from Points,Regions WHERE Points.Obj WITHIN Regions.Obj
But what if you want to do the opposite: get a list of all of the Points that are outside any Polygon (you might call them “orphans”). You can do this:
SELECT Points.id from Points WHERE not Obj within any (SELECT Obj from Regions)
Cool.
About This Blog
I am Peter Rukavina and this is my blog. I am a writer, letterpress printer, and a curious person.
To learn more about me, read my /now, look at my bio, listen to audio I’ve posted, read presentations and speeches I’ve written, or get in touch (peter@rukavina.net is the quickest way).
You can subscribe to an RSS feed of posts, an RSS feed of comments, or a podcast RSS feed that just contains audio posts. You can also receive a daily digests of posts by email.
Comments
Tried this but unfortunately
Tried this but unfortunately it doesn’t work. Can you post screen shots of the entire process?
Sorry — don’t have MapInfo
Sorry — don’t have MapInfo any longer.
I have just used this thread
I have just used this thread and thought i would update it. the SQL worked for me. see the following :
in the from Tables:
select the points file from the Tables drop down list at top right of SQL dialogue box
in the where Conditions:
Not Obj Within Any (Select Obj from HAN_SA_POLY)
obviously, the Han_SA_POLY section being replaced with the name of your Regions/polygon layer you are searching outside of.
hopefully this clarifies it
10/10 would query again
10/10 would query again
Add new comment