MapForums
Community of VE/MapPoint Users and Developers
Multi-radius
This is a discussion on Multi-radius within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; i just posted this msg in wish list i presume it isnt possible - if it is i will be very ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2003
| |||
| |||
| Multi-radius "In my job i have to find out who falls in any of 12 25km radiuses in the UK. To do this i either have to delete all pins outside the radiuses and then export all, or export each radius then add them together and remove any duplications (some radiuses overlapp... so some may be on twice) It would be brill to be able to select, then export multiple radiuses at once... then there would be no overlapp. How about then being able to export all the pins, not under those radiuses... that would be great." Regards Dan         |
|
02-26-2003
| |||
| |||
|
I deal with your exact problem. Here is how I deal with it. 1) I use the drawing tools to draw a circle around the pushpin which I wish to use as the center point. I typically look at a 20 mile radius. 2) I export all the enclosed pushpins with Pushpin Tool (trial version available on this site). 3) I then use a formula I found at the following address to compute distance between the center pushpin and the object pushpin (http://www.cpearson.com/excel/latlong.htm) 4) I then use a nested IF/THEN function in Excel to break the distances into 5 mile radius increments. 5) Finally, I sort and do a subtotal on the IF/THEN function that defines the 5 mile radius increments. Hope this helps. |
 |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Multi-radius | Anonymous | Wish List | 2 | 06-29-2003 11:54 PM |
| Area Codes, Multi-Other Granularity | Anonymous | Wish List | 0 | 05-21-2003 07:53 AM |
| multi polyshape query | henemonster | MapPoint 2006/2009 Discussion | 0 | 03-25-2003 06:10 PM |
| [Multi pushpins selection ?] | Vincent BENNER | MapPoint 2006/2009 Discussion | 4 | 01-30-2003 04:41 AM |
| Mappoint newbie here- need to be able to map multi.... | Anonymous | MapPoint 2006/2009 Discussion | 3 | 06-13-2002 10:04 AM |
All times are GMT -5. The time now is 11:09 PM.
