Discussion:
Driving Directions
(too old to reply)
Jerry8989
2009-02-10 14:53:01 UTC
Permalink
I have a new project that will have over 10,000 address. Now I need to take
these address and get their Latitude and Longitude for each one. Now the
trick part is that I have to take the address and get the distance for
specific ones. Say I have the following table

Address
-------
A
B
C
D

After getting the lat and long I want to find out the distance between
certain ones
A->B what is the driving distance?
A->D what is the driving distance?

My 2nd problem is getting DRIVING distance not areil distance.

Can I do all of this with Mappoint? Is there a dll with mappoint that I can
use?

Thank you
Jerry
DavidCHB
2009-02-10 15:15:01 UTC
Permalink
Yes, based on my experience MapPoint can do all that pretty routinely. You'll
need to write a little bit of code to make it streamlined (eg in excel vba).
--
David
http://www.broomanalysis.plus.com/
Post by Jerry8989
I have a new project that will have over 10,000 address. Now I need to take
these address and get their Latitude and Longitude for each one. Now the
trick part is that I have to take the address and get the distance for
specific ones. Say I have the following table
Address
-------
A
B
C
D
After getting the lat and long I want to find out the distance between
certain ones
A->B what is the driving distance?
A->D what is the driving distance?
My 2nd problem is getting DRIVING distance not areil distance.
Can I do all of this with Mappoint? Is there a dll with mappoint that I can
use?
Thank you
Jerry
Jerry8989
2009-02-10 15:39:01 UTC
Permalink
David,
I will be using C# to feed all the address through. I think it's a tab or
comma delimited file that will have all the latitudes and longitudes. Do you
know with Mappoint 2009 if it comes with a .dll for me to use within .net?

Thank You
Jerry
Post by DavidCHB
Yes, based on my experience MapPoint can do all that pretty routinely. You'll
need to write a little bit of code to make it streamlined (eg in excel vba).
--
David
http://www.broomanalysis.plus.com/
Post by Jerry8989
I have a new project that will have over 10,000 address. Now I need to take
these address and get their Latitude and Longitude for each one. Now the
trick part is that I have to take the address and get the distance for
specific ones. Say I have the following table
Address
-------
A
B
C
D
After getting the lat and long I want to find out the distance between
certain ones
A->B what is the driving distance?
A->D what is the driving distance?
My 2nd problem is getting DRIVING distance not areil distance.
Can I do all of this with Mappoint? Is there a dll with mappoint that I can
use?
Thank you
Jerry
Jerry8989
2009-02-10 15:41:01 UTC
Permalink
David,
Thank you for your reply.
I will be using c# to connect to a tab or comma delimited file and to run
the latitudes and longitudes through. Do you know if Mappoint 2009 comes
with a dll for me to be able to do this?

Thank You
Jerry
Post by DavidCHB
Yes, based on my experience MapPoint can do all that pretty routinely. You'll
need to write a little bit of code to make it streamlined (eg in excel vba).
--
David
http://www.broomanalysis.plus.com/
Post by Jerry8989
I have a new project that will have over 10,000 address. Now I need to take
these address and get their Latitude and Longitude for each one. Now the
trick part is that I have to take the address and get the distance for
specific ones. Say I have the following table
Address
-------
A
B
C
D
After getting the lat and long I want to find out the distance between
certain ones
A->B what is the driving distance?
A->D what is the driving distance?
My 2nd problem is getting DRIVING distance not areil distance.
Can I do all of this with Mappoint? Is there a dll with mappoint that I can
use?
Thank you
Jerry
Jerry8989
2009-02-10 15:41:02 UTC
Permalink
David,
Thank you for your reply.
I will be using c# to connect to a tab or comma delimited file and to run
the latitudes and longitudes through. Do you know if Mappoint 2009 comes
with a dll for me to be able to do this?

Thank You
Jerry
Post by DavidCHB
Yes, based on my experience MapPoint can do all that pretty routinely. You'll
need to write a little bit of code to make it streamlined (eg in excel vba).
--
David
http://www.broomanalysis.plus.com/
Post by Jerry8989
I have a new project that will have over 10,000 address. Now I need to take
these address and get their Latitude and Longitude for each one. Now the
trick part is that I have to take the address and get the distance for
specific ones. Say I have the following table
Address
-------
A
B
C
D
After getting the lat and long I want to find out the distance between
certain ones
A->B what is the driving distance?
A->D what is the driving distance?
My 2nd problem is getting DRIVING distance not areil distance.
Can I do all of this with Mappoint? Is there a dll with mappoint that I can
use?
Thank you
Jerry
DavidCHB
2009-02-10 16:02:25 UTC
Permalink
Sorry don't know the answer to that. You could try downloading the free trial
and see if it works

http://www.microsoft.com/downloads/details.aspx?FamilyID=60905dfe-5aea-44ec-b5fb-0e4130c3e7e5&DisplayLang=en
--
David
http://www.broomanalysis.plus.com/
Post by Jerry8989
David,
Thank you for your reply.
I will be using c# to connect to a tab or comma delimited file and to run
the latitudes and longitudes through. Do you know if Mappoint 2009 comes
with a dll for me to be able to do this?
Thank You
Jerry
Post by DavidCHB
Yes, based on my experience MapPoint can do all that pretty routinely. You'll
need to write a little bit of code to make it streamlined (eg in excel vba).
--
David
http://www.broomanalysis.plus.com/
Post by Jerry8989
I have a new project that will have over 10,000 address. Now I need to take
these address and get their Latitude and Longitude for each one. Now the
trick part is that I have to take the address and get the distance for
specific ones. Say I have the following table
Address
-------
A
B
C
D
After getting the lat and long I want to find out the distance between
certain ones
A->B what is the driving distance?
A->D what is the driving distance?
My 2nd problem is getting DRIVING distance not areil distance.
Can I do all of this with Mappoint? Is there a dll with mappoint that I can
use?
Thank you
Jerry
Jerry8989
2009-02-10 16:08:06 UTC
Permalink
David,
Thanks
Sorry about the extra replies for some reason everytime I post it says there
is an error but it still posts.

Jerry
Post by DavidCHB
Sorry don't know the answer to that. You could try downloading the free trial
and see if it works
http://www.microsoft.com/downloads/details.aspx?FamilyID=60905dfe-5aea-44ec-b5fb-0e4130c3e7e5&DisplayLang=en
--
David
http://www.broomanalysis.plus.com/
Post by Jerry8989
David,
Thank you for your reply.
I will be using c# to connect to a tab or comma delimited file and to run
the latitudes and longitudes through. Do you know if Mappoint 2009 comes
with a dll for me to be able to do this?
Thank You
Jerry
Post by DavidCHB
Yes, based on my experience MapPoint can do all that pretty routinely. You'll
need to write a little bit of code to make it streamlined (eg in excel vba).
--
David
http://www.broomanalysis.plus.com/
Post by Jerry8989
I have a new project that will have over 10,000 address. Now I need to take
these address and get their Latitude and Longitude for each one. Now the
trick part is that I have to take the address and get the distance for
specific ones. Say I have the following table
Address
-------
A
B
C
D
After getting the lat and long I want to find out the distance between
certain ones
A->B what is the driving distance?
A->D what is the driving distance?
My 2nd problem is getting DRIVING distance not areil distance.
Can I do all of this with Mappoint? Is there a dll with mappoint that I can
use?
Thank you
Jerry
Manfred Suendorf
2010-06-23 16:30:08 UTC
Permalink
It´s quite easy: use our tool IC-DistanceCalc.
Send us an email and you will get the Excel-AddIn.
Mail to ***@profit100.de
Also have a look on this site: www.mappoint2010.info

Kind regards
Manfred
Post by Jerry8989
I have a new project that will have over 10,000 address. Now I need to take
these address and get their Latitude and Longitude for each one. Now the
trick part is that I have to take the address and get the distance for
specific ones. Say I have the following table
Address
-------
A
B
C
D
After getting the lat and long I want to find out the distance between
certain ones
A->B what is the driving distance?
A->D what is the driving distance?
My 2nd problem is getting DRIVING distance not areil distance.
Can I do all of this with Mappoint? Is there a dll with mappoint that I can
use?
Thank you
Jerry
Loading...