If I have a list of address that is for instance "Keilaranta 17 FI-02150 ESPOO FINLAND" in my sql server database and I want to add a new column to add the data of WGS 84. You retrieve the WGS 84 data from google map or similiar. Is it possible to do it?
Retrieve WGS 84 from Google map
1.3k Views Asked by HelloWorld1 At
2
There are 2 best solutions below
0
On
Generally, you can't permanently store coordinates obtained from Google map API, though you can cache for up to 30 days for performance purposes. Here's a link to a similar stackoverflow question I and others had answered:
Terms and Conditions Google Maps: Can I store lat/lng and address components?
You need to look into the Geocoding API. Effectively you need to provide Google with an address (so in your case Keilaranta 17 FI-02150 ESPOO FINLAND) and the API will return the long and lat in WGS84 (Spherical Mercator).
You will also want to read the TOS associated with this as storing results for any use other than caching is against the rules laid out without a commercial licence.