Solved

Google Maps API - translate address to longitude/latitude

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Designer 19 40
SQL Replication question 9 42
SSRS 2013 - Overlapping reports 2 22
SQL Server - Find Unmatched Records Between Two Tables - Has Trouble with Nulls 10 30
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
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

770 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