That is a nice trick, I will remember that. I really just need the coordinates, since each coordinate needs to go back into a database in a register of a location-time that needs more data added later. These are the "generic" addresses, with the apartment numbers stripped, so each address will provide coordinates for multiples DB entries on different dates, and I won't really be using them on the same layer. But I am sure I can figure out a way to get the data back out with PostGIS (the original data is in Postgres anyway).<div>
<br></div><div>Cheers,</div><div>JP<br><br><div class="gmail_quote">On Fri, Feb 4, 2011 at 11:59 PM, Dan Putler <span dir="ltr"><<a href="mailto:dan.putler@sauder.ubc.ca">dan.putler@sauder.ubc.ca</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">JP,<br>
<br>
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.<br>
<br>
Dan<div class="im"><br>
<br>
On 02/04/2011 02:20 PM, JP Glutting wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
Hi Bernie,<br>
<br>
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.<br>
<br>
<a href="http://groups.google.com/group/fusion-tables-users-group/browse_thread/thread/91c43c73107164eb" target="_blank">http://groups.google.com/group/fusion-tables-users-group/browse_thread/thread/91c43c73107164eb</a><br>
<br>
Unless I export it to KML and pull it back out of there?<br>
<br>
That seems like a lot of work. But it sure geocodes like gangbusters.<br>
<br>
Cheers,<br>
JP<br>
<br>
Public Health - GIS - Bioinformatics<br>
</div><a href="http://www.bmeisis.com" target="_blank">http://www.bmeisis.com</a> <<a href="http://www.bmeisis.com/" target="_blank">http://www.bmeisis.com/</a>><br>
<a href="http://www.jpglutting.com" target="_blank">http://www.jpglutting.com</a><div class="im"><br>
<br>
<br>
<br>
<br>
On Fri, Feb 4, 2011 at 7:42 PM, Connors, Bernie (SNB) <<a href="mailto:Bernie.Connors@snb.ca" target="_blank">Bernie.Connors@snb.ca</a> <mailto:<a href="mailto:Bernie.Connors@snb.ca" target="_blank">Bernie.Connors@snb.ca</a>>> wrote:<br>
<br>
Try Google Fusion Tables. All you have to do is put all of the<br>
address components in one field and it should be recognized and<br>
geocoded.<br>
<br>
--<br>
<br>
*Bernie Connors, P.Eng*<br>
<br>
Service New Brunswick<br>
<br>
(506) 444-2077<br>
<br>
45°56'25.21"N, 66°38'53.65"W<br>
<br></div>
<a href="http://www.snb.ca/geonb/" target="_blank">www.snb.ca/geonb/</a> <<a href="http://www.snb.ca/geonb/" target="_blank">http://www.snb.ca/geonb/</a>><div class="im"><br>
<br>
*From:*<a href="mailto:discuss-bounces@lists.osgeo.org" target="_blank">discuss-bounces@lists.osgeo.org</a><br>
<mailto:<a href="mailto:discuss-bounces@lists.osgeo.org" target="_blank">discuss-bounces@lists.osgeo.org</a>><br>
[mailto:<a href="mailto:discuss-bounces@lists.osgeo.org" target="_blank">discuss-bounces@lists.osgeo.org</a><br>
<mailto:<a href="mailto:discuss-bounces@lists.osgeo.org" target="_blank">discuss-bounces@lists.osgeo.org</a>>] *On Behalf Of *JP Glutting<br>
*Sent:* Friday, 2011-02-04 09:34<br></div>
*To:* <a href="mailto:discuss@lists.osgeo.org" target="_blank">discuss@lists.osgeo.org</a> <mailto:<a href="mailto:discuss@lists.osgeo.org" target="_blank">discuss@lists.osgeo.org</a>><div><div></div><div class="h5">
<br>
*Subject:* [OSGeo-Discuss] Batch geocoding<br>
<br>
Hello,<br>
<br>
I have a large set of addresses (around 150k) that I need to<br>
geocode for a study (my Masters thesis on heat-related mortality).<br>
I am looking into different solutions, but I can't find anything<br>
that seems like it would work properly.<br>
<br>
I could script a solution using Google's map API, but there is a<br>
limit of 2,500 addreses per day (I can get around them with a<br>
little patience).<br>
<br>
Right now the best solution I am looking at geopy for geocoding<br>
addresses (<a href="http://code.google.com/p/geopy/" target="_blank">http://code.google.com/p/geopy/</a>). It seems like a good<br>
system, I think I can use it to pull addresses out of my database<br>
and write back coordinates. There is one thing that I am not sure,<br>
about, though, is whether I am actually allowed to use the Google<br>
API without my use being liked to a specific web page. The terms<br>
of service and form for getting a Google API key require a URL<br>
linked to a Google account. In fact, it looks like the API can<br>
only be used through a web site:<br>
<br>
"5.2 _Account Key_. After supplying Google with your account<br>
information and the URL of your Maps API Implementation, and<br>
accepting the Terms, you will be issued an alphanumeric key<br>
assigned to you by Google that is uniquely associated with<br>
your Google Account and the URL of your Maps API<br>
Implementation. Your Maps API Implementation must import the<br>
Google Maps APIs using this key as described in the Maps APIs<br>
Documentation<br></div></div>
<<a href="http://code.google.com/apis/maps/documentation/" target="_blank">http://code.google.com/apis/maps/documentation/</a>>, and Google<div class="im"><br>
will block requests with an invalid key or invalid URL. You<br>
may only obtain and use a key in accordance with these Terms<br>
and the Maps APIs Documentation<br></div>
<<a href="http://code.google.com/apis/maps/documentation/" target="_blank">http://code.google.com/apis/maps/documentation/</a>>."<div class="im"><br>
<br>
So it looks like I can't even get it to work without a URL.<br>
<br>
I can always write a script that loops through results extracted<br>
from the database, creates URLs and parses the XML results one at<br>
a time, but that seems like a fairly inelegant solution.<br>
<br>
Does anyone have any good ideas about how to geocode a few<br>
thousand addresses?<br>
<br>
Many thanks,<br>
<br>
JP<br>
<br>
<br>
_______________________________________________<br>
Discuss mailing list<br></div>
<a href="mailto:Discuss@lists.osgeo.org" target="_blank">Discuss@lists.osgeo.org</a> <mailto:<a href="mailto:Discuss@lists.osgeo.org" target="_blank">Discuss@lists.osgeo.org</a>><div class="im"><br>
<a href="http://lists.osgeo.org/mailman/listinfo/discuss" target="_blank">http://lists.osgeo.org/mailman/listinfo/discuss</a><br>
<br>
<br>
</div></blockquote><div><div></div><div class="h5">
<br>
_______________________________________________<br>
Discuss mailing list<br>
<a href="mailto:Discuss@lists.osgeo.org" target="_blank">Discuss@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/discuss" target="_blank">http://lists.osgeo.org/mailman/listinfo/discuss</a><br>
</div></div></blockquote></div><br></div>