Solved

Google Maps API - translate address to longitude/latitude

Posted on 2013-01-24
3
2,099 Views
Last Modified: 2013-01-29
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.
0
Comment
Question by:HLRosenberger
  • 2
3 Comments
 
LVL 7

Expert Comment

by:Ross Turner
ID: 38814880
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
 
LVL 7

Accepted Solution

by:
Ross Turner earned 500 total points
ID: 38814925
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
 
LVL 1

Author Closing Comment

by:HLRosenberger
ID: 38831425
Thanks
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now