<div>
Hi HLRosenberger, <br />
<br />
You can use the google geoencode api to translate your address.<br />
<br />
<a href="https://developers.google.com/maps/documentation/geocoding/" rel="ugc">https://developers.google.<wbr />com/maps/d<wbr />ocumentati<wbr />on/geocodi<wbr />ng/</a><br />
<br />
i gather the addresses are stored in a ms sql database ?<br />
<br />
would this be a set amount of addresses or would you need to translate added one as well ?<br />
<br />
Are you in the uk ?<br />
<br />
Here is a list of all Postcodes with Long\Lat in a csv <br />
<br />
<a href="http://www.doogal.co.uk/files/postcodes.zip" rel="ugc">UK Postcodes</a><br />
<br />
if you are in the uk you could just import this into your sql table and join on the postcode :)
</div>


Hi HLRosenberger,

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

https://developers.google.com/maps/documentation/geocoding/ [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 [http://www.doogal.co.uk/files/postcodes.zip]

if you are in the uk you could just import this into your sql table and join on the postcode :)

<div>
<div class="content wysiwyg-content">
I want a service that translates and address to longitude/latitude. &nbsp;We own &nbsp;Google Maps API for Business, but I'm not sure this is what I want. <br />
<br />
I want need longitude/latitude values and then will store these into a SQL database as a geography data type. &nbsp;I can then use SQL to determine distances between points.
</div>
</div>


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.

Google Maps API - translate address to longitude/latitude

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

The Global Positioning System (GPS) is a space-based global navigation satellite system (GNSS) that provides reliable location and time information in all weather and at all times and anywhere on or near the Earth when and where there is an unobstructed line of sight to four or more GPS satellites. A geographic information system (GIS) or geospatial information system is any system that captures, stores, analyzes, manages, and presents data that are linked to location(s). In the simplest terms, GIS is the merging of cartography, statistical analysis, and database technology.