MapInfo Pro

I make only the boundary layer(known as "bound") needed selectable, then I try a simple SQL Select statement that works for selecting points within a buffer:

"SELECT * FROM Bound, Buffer WHERE bound.obj WITHIN Buffer.obj"

This never works how I would like it to. I end up having to manually draw a radius select to grab the polygons.

If anyone has any way to select polygons within polygons, please help me out!! It would be much appreciated.

Thanks!

Ross

Hi Ross,

If you have more than one Buffer object in the table and you would like to select those objects within a selection of Buffer objects, select the buffer objects first, then execute the following:

SELECT * FROM Bound where obj entirely within any (select obj from selection)

Hopefully this helps?

Here's an article covering the use of Buffer() in a subselect query:

https://li360.pitneybowes.com/LI360/s/article/Query-Ninja-Using-the-Buffer-function-in-a-sub-select

Also notice you have a couple of options when it comes to the spatial operator:

• Within: Selects the object that have their centroid inside
• Entirely Within: Selects the objects that are completely inside
• Partly Within: Selects the objects that have just a node or more inside. This is similar to using Intersects

I would use "Intersects" for this, as this will even pick up polygons that have a shared boundary i.e. touching. Your query will only select the polygons where the buffer has included the centroid of the polygon.?

@Peter Horsbøll Møller? This is exactly what I needed. It worked flawlessly. Thanks for the resource!