[AccessD] Distance Between Two Points

Rocky Smolin rockysmolin at bchacc.com
Mon Jan 7 19:47:49 CST 2013


Thanks Stuart.  Do you know of a site where I can see a snip of VBA code
using it?


Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Monday, January 07, 2013 5:34 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Distance Between Two Points

It's can be as simple as parsing the return from an http request such as 

http://maps.googleapis.com/maps/api/geocode/json?address=1600+Amphitheatre+P
arkway,
+Mountain+View,+CA&sensor=false

See
https://developers.google.com/maps/documentation/geocoding/index

One caveat:

Note: the Geocoding API may only be used in conjunction with a Google map;
geocoding results without displaying them on a map is prohibited. 


Alternatives:

https://webgis.usc.edu/Services/Default.aspx



On 7 Jan 2013 at 17:01, Doug Murphy wrote:

> I think others on the list have discussed ways of doing this. It can be
done
> from the Google Maps api. You need a Google developer ID or something like
> that to use it. It has been a while since I played with it.
> 
> Doug
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> Sent: Monday, January 07, 2013 3:56 PM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Distance Between Two Points
> 
> Dear List:
>  
> I have a client who wants to add to his app the distance from his office
to
> various properties they appraise.  I see some code snips on the web to
> calculate this (as the crow flies) but is there a way to translate a
> complete address into latitude and longitude coordinates?
>  
> MTIA
>  
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com
> <http://www.e-z-mrp.com/>
> Skype: rocky.smolin
>  
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list