Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 2 of 2

Multi-radius

This is a discussion on Multi-radius within the MapPoint Desktop 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 ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    Multi-radius

    i just posted this msg in wish list i presume it isnt possible - if it is i will be very happy man :-)

    "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

  2. #2
    mark.sechrist is offline Junior Member White Belt
    Join Date
    Oct 2002
    Posts
    8
    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Multi-radius
    By Anonymous in forum Wish List
    Replies: 2
    Last Post: 06-29-2003, 11:54 PM
  2. Area Codes, Multi-Other Granularity
    By Anonymous in forum Wish List
    Replies: 0
    Last Post: 05-21-2003, 07:53 AM
  3. multi polyshape query
    By henemonster in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-25-2003, 06:10 PM
  4. [Multi pushpins selection ?]
    By Vincent BENNER in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 01-30-2003, 04:41 AM
  5. Mappoint newbie here- need to be able to map multi....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 06-13-2002, 10:04 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83