Welcome to MapForums!

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

## 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. 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. 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. 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. ## 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.

5. ## 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

6. ## 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

7. Member Green Belt
Join Date
Sep 2009
Location
Posts
94

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

Itīs quite easy!

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.