Solved

Google Maps API - translate address to longitude/latitude

Posted on 2013-01-24
3
2,163 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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Introduction This article is designed to assist GIS (Geographic Information System) and GPS (Global Positioning System) developers using ESRI ArcGIS and other spatial information management systems.   For the uninitiated the concept of projectio…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

752 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