Thanks Bernie, That looks very interesting. I might give that a try. Right now I am having decent luck with geopy and the Google and Yahoo APIs. Google is more restrictive, but it doesn't choke on addresses as much. I cleaned up the data and I have about 54k different locations (after removing apartment number, etc.). I will see how far that gets me on Yahoo, and I will try the Fusion tables thing, too (I am storing the Yahoo and Google coordinates in separate fields, so I can do both and compare the two, if need be).
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 > 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/ > > > > *From:* 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 > *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 > http://lists.osgeo.org/mailman/listinfo/discuss > >
_______________________________________________ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
