Solved

Google Maps API - translate address to longitude/latitude

Posted on 2013-01-24
3
2,217 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

622 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