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 3 of 3

Find closest between two sets of addresses?

This is a discussion on Find closest between two sets of addresses? within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have two sets of data, Clients and Offices. Can MapPoint be used to create a list containing the office ...

  1. #1
    mksql is offline Junior Member White Belt
    Join Date
    Jul 2005
    Posts
    2

    Find closest between two sets of addresses?

    I have two sets of data, Clients and Offices. Can MapPoint be used to create a list containing the office closest to each client, and then export to a file usable by another database application?

    Apparently the PushPin Tool Add-in will export a file with lat/long data, but then I still need to compare the two coordinate sets and match based on minimum distance.

  2. #2
    Mohamed is offline Member Green Belt
    Join Date
    Mar 2005
    Posts
    97
    Hi,

    Of course, Mappoint can be used to calculate distances. But you have
    to do it programmatically if you have a lot of addresses.

    If you don't want to do it yourself, John Meyer did a batch that you can download or buy in this web site.
    All is done in Excel or CSV format , so you can easily use your data in other programs.

    John Meyer's Batch Driving Distance Calculator
    Good luck

  3. #3
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    As well as John Meyer's Batch Calculator, I have "MileCharter":

    http://www.mapping-tools.com/milecharter/index.shtml

    This can work between two different groups, outputting a table to Excel.
    Fastest route, shortest route, straight line, etc

    out of the box it won't automatically identify the closest or shortest, but if you want this, send a message off-list.


    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find distance between two addresses
    By WonderMonkey in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 06-26-2006, 03:28 PM
  2. Why doesn't it find these addresses?
    By pileggi in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-13-2005, 03:01 AM
  3. Find 3 closest matches
    By eblubber in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 02-09-2005, 10:45 AM
  4. Find Addresses in Querycircle
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 04-02-2004, 03:45 AM
  5. Find distance between two UK postal addresses by using VB
    By AKPost in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 02-23-2004, 11:18 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