Long/Lat from KML Fusion Tables export - any way? -


is there way long/lat coordinates fusion tables kml export?

this post it, process doesn't work anymore:

http://mickschroeder.com/2011/03/fusion-tables-export/

if data coded lat/longs, you'll lat/longs out in export (in form of <coordinates> element. if data coded address (as suspect in case), there's no way coordinates directly in export. instead, kml file have <address> element. seems google address geocoding on fly, , isn't willing share you.

google has geocoding api can use turn addresses coordinates under condition you'll displaying geocoded data on google map. here's simple example of using geocoding api in python:

import urllib2, json  # create request uri google geocoding api service_fmt = "https://maps.googleapis.com/maps/api/geocode/json?address={0}&sensor=false" request_addr = service_fmt.format(urllib2.quote("600 mountain ave, new providence, nj"))  # make request , deserialize json response response_handle = urllib2.urlopen(request_addr) response = json.loads(response_handle.read())  print(response["results"][0]["geometry"]["location"]) 

Comments

Popular posts from this blog

html5 - What is breaking my page when printing? -

html - Unable to style the color of bullets in a list -

c# - must be a non-abstract type with a public parameterless constructor in redis -