JP,
If you export the KML, and then feed it into QGIS you can then save the
resulting layer as a shapefile, which is probably what you are really
hoping to have since you can then easily feed it to R, PostGIS, or a
number of other tools to pull the coordinates.
Dan
On 02/04/2011 02:20 PM, JP Glutting wrote:
Hi Bernie,
You can't actually get the lat-lng back out of a Fusion table. It will
geocode all the addresses, but you can't get the numbers back, you can
just make a map or layer or something.
http://groups.google.com/group/fusion-tables-users-group/browse_thread/thread/91c43c73107164eb
Unless I export it to KML and pull it back out of there?
That seems like a lot of work. But it sure geocodes like gangbusters.
Cheers,
JP
Public Health - GIS - Bioinformatics
http://www.bmeisis.com <http://www.bmeisis.com/>
http://www.jpglutting.com
On Fri, Feb 4, 2011 at 7:42 PM, Connors, Bernie (SNB)
<bernie.conn...@snb.ca <mailto:bernie.conn...@snb.ca>> wrote:
Try Google Fusion Tables. All you have to do is put all of the
address components in one field and it should be recognized and
geocoded.
--
*Bernie Connors, P.Eng*
Service New Brunswick
(506) 444-2077
45°56'25.21"N, 66°38'53.65"W
www.snb.ca/geonb/ <http://www.snb.ca/geonb/>
*From:*discuss-boun...@lists.osgeo.org
<mailto:discuss-boun...@lists.osgeo.org>
[mailto:discuss-boun...@lists.osgeo.org
<mailto:discuss-boun...@lists.osgeo.org>] *On Behalf Of *JP Glutting
*Sent:* Friday, 2011-02-04 09:34
*To:* discuss@lists.osgeo.org <mailto:discuss@lists.osgeo.org>
*Subject:* [OSGeo-Discuss] Batch geocoding
Hello,
I have a large set of addresses (around 150k) that I need to
geocode for a study (my Masters thesis on heat-related mortality).
I am looking into different solutions, but I can't find anything
that seems like it would work properly.
I could script a solution using Google's map API, but there is a
limit of 2,500 addreses per day (I can get around them with a
little patience).
Right now the best solution I am looking at geopy for geocoding
addresses (http://code.google.com/p/geopy/). It seems like a good
system, I think I can use it to pull addresses out of my database
and write back coordinates. There is one thing that I am not sure,
about, though, is whether I am actually allowed to use the Google
API without my use being liked to a specific web page. The terms
of service and form for getting a Google API key require a URL
linked to a Google account. In fact, it looks like the API can
only be used through a web site:
"5.2 _Account Key_. After supplying Google with your account
information and the URL of your Maps API Implementation, and
accepting the Terms, you will be issued an alphanumeric key
assigned to you by Google that is uniquely associated with
your Google Account and the URL of your Maps API
Implementation. Your Maps API Implementation must import the
Google Maps APIs using this key as described in the Maps APIs
Documentation
<http://code.google.com/apis/maps/documentation/>, and Google
will block requests with an invalid key or invalid URL. You
may only obtain and use a key in accordance with these Terms
and the Maps APIs Documentation
<http://code.google.com/apis/maps/documentation/>."
So it looks like I can't even get it to work without a URL.
I can always write a script that loops through results extracted
from the database, creates URLs and parses the XML results one at
a time, but that seems like a fairly inelegant solution.
Does anyone have any good ideas about how to geocode a few
thousand addresses?
Many thanks,
JP
_______________________________________________
Discuss mailing list
Discuss@lists.osgeo.org <mailto:Discuss@lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/discuss
_______________________________________________
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss