MapInfo Pro

I know how to use a "Radius select", but its not efficient as I have 200 locations and I need to export data for radius around each location.

I found the tool to batch export to csv, just need more efficient way of running queries for separate locations and their radius.

See AttachmentI have found quite option for one Location. Using Tool ""Concentric Ring Buffers" u can select statistic to calculate within the rings, but it didn't create separate rings. See Attachment

The above picture shows result for one location.

I have attached result when u do same process for 2 location, problem is that it merges the rings together.

Have you tried the "Concentric Ring Buffer" Tool in the Tool Manager??

Hello John

Yes I did. But I encountered problem that when you select multiply locations it doesn't consider them as separate radius but instead sums up all 3 km Radius then 7.5 Radius and etc. What I want to achieve that it will show me individual output for each location. I could achieve that by only by selecting each location individually, but not as one process. I have attached images above with what I did.

Thank you

In which case, do it the longer method of creating a buffer for each site: >Objects >Buffer.

You can select all sites and create a buffer of given distance for your selection of sites and update a column with the name of the site (and anything else) when the Data Aggregation dialog pops up. I recommend that you create the buffers? in a separate table. With this method you can choose whether to have one buffer for all objects or individual buffers for each object.

The longer process is in creating concentric ring buffers, where you will need to erase smaller buffers from the larger buffers. Can still be done in batch rather than individually though.

Hope that helps

If you already have created your concentric rings using "Concentric Ring Buffer" you can use a SQL Select statement to do the aggregation of data within the individual rings.

Let's assume that you have table with buffers/rings called RingBuffers which has a column with a name (NAME) and a column with a radius (RADIUS)

You also have a table with demographic data called DemogrData with a column with population called TOT_POP.

Now you want to calculate the "sum" of population within the individual buffers.

Such a query would look like this:

See Attachment

Select RingBuffers.NAME, RingBuffers.RADIUS, Sum(DemogrData.TOT_POP)

From RingBuffers, DemogrData

Where RingBuffers Contains DemogrData

Group By RingBuffers.NAME, RingBuffers.RADIUS

Of course you can consier a number of adjustments to this query:

• should the sum depend on the size of the areal overlap?
• would you like to include all population boundaries that intersect the buffer or only those that have the centroid inside the buffer (as we do above)?
• do you want to group the result by the ring buffers and the radius or just by the ring buffer names or are you looking for at total for all ring buffers?

The query result will be one line per buffer name and ring buffer radius.