Google Maps API - translate address to longitude/latitude

I want a service that translates and address to longitude/latitude.  We own  Google Maps API for Business, but I'm not sure this is what I want.

I want need longitude/latitude values and then will store these into a SQL database as a geography data type.  I can then use SQL to determine distances between points.
LVL 1
HLRosenbergerAsked:
Who is Participating?
 
Ross TurnerManagement Information Support AnalystCommented:
I found these tutorials as well

http://www.tomanthony.co.uk/blog/caching-google-maps-geocoder-results/

and

I've tested the below script/tutorial and it works fantastic and probably is you're best solution.

Geocode Addresses in T-SQL
0
 
Ross TurnerManagement Information Support AnalystCommented:
Hi HLRosenberger,

You can use the google geoencode api to translate your address.

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

i gather the addresses are stored in a ms sql database ?

would this be a set amount of addresses or would you need to translate added one as well ?

Are you in the uk ?

Here is a list of all Postcodes with Long\Lat in a csv

UK Postcodes

if you are in the uk you could just import this into your sql table and join on the postcode :)
0
 
HLRosenbergerAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.