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

Distance to one point from numerous points on map

This is a discussion on Distance to one point from numerous points on map within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have imported 3000 addresses into Mappoint 2006 and then labeled one destination point on this map. Is there a ...

  1. #1
    cdorsey is offline Junior Member White Belt
    Join Date
    Jul 2007
    Posts
    1

    Distance to one point from numerous points on map

    I have imported 3000 addresses into Mappoint 2006 and then labeled one destination point on this map. Is there a way to determine the distance from that destination point from each of the addresses and then export it?

    In the end, I would love to have a list that says a specific address is 1.3 miles from the destination etc.

    Thanks.

  2. #2
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

    Re: Distance to one point from numerous points on map

    Hi,

    You can use DistanceTo programatically to get the distance in the bird eyes of view to each point.

  3. #3
    kneelie is offline Junior Member White Belt
    Join Date
    Aug 2011
    Posts
    1

    Re: Distance to one point from numerous points on map

    I am also looking for a way to determine distance in road miles from one point to numerous 5118 points on map. I have 20 locations to run this report on. I would love to export this data to excel.

  4. #4
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    Re: Distance to one point from numerous points on map

    So you have 5118 * 20 = 102,360 routes to calculate?
    We have a program written to calculate routes and can provide the output as a service if you need it right away.
    Michael R Mattys
    Business Process Developers
    www.mattysconsulting.com

  5. #5
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Distance to one point from numerous points on map

    kneelie:

    Are you interested in writing your own custom macro or looking for a service (as Michael offered) or product do this this?

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  6. #6
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60

    Re: Distance to one point from numerous points on map

    Our MPMileCharter product ( MileCharter: Home Page ) can also do this.
    It could actually do all 20 runs at once if your 5000-or-so are the same set of locations.

    Import your locations as pushpins. Source locs in one pushpin set, destination locs as a second pushpin set (could be just one pushpin) and set MPMileCharter running.
    If running 1->5000, I would reverse the axes so that they are listed down the left side (by default src locs are on the left, dest locs along the top).

    Also 5000 routes might take over an hour to process - depends on your PC speed, road complexities, route lengths, etc.


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

  7. #7
    PROFIT100 Consulting is offline Member Green Belt
    Join Date
    Sep 2009
    Location
    Darmstadt, Germany
    Posts
    94

    Smile Re: Distance to one point from numerous points on map

    Itīs quite easy!

    Just download our MapPoint IC-GeoAnalysisSuite.
    Itīs a 30 day free trial.

    1. Step: Geocode your points with the tool IC-DatasetExport
    2. Step: Use IC-DistanceAnalysis for Calcultion

    Thatīs all.
    Good Luck.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Driving Distance from a Point
    By BC1968 in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 07-21-2007, 09:04 AM
  2. Replies: 6
    Last Post: 08-19-2004, 07:10 PM
  3. Route Planning (Multiple Point to Points)
    By robertuva in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 06-15-2004, 05:19 PM
  4. Map Point always points to Boise
    By trudye in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-04-2004, 09:34 PM
  5. how can I calculate the distance between two moving point
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 04-30-2003, 10:09 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