Batch geocoding from simple text output using Yahoo! maps
Friday, 20. January 2006, 23:45:42
James Fee (www.spatiallyadjusted.com) provided a pointer to this batch geocoder that I just had to check out. The page requests the user simply provide "any kind" of address data from a "simple" format - ie. simply paste address, city, state, ZIP, description, url from an excel spreadsheet. the app validates the source code, then requests the user to specify columns (I was a bit lost on what exactly step 4 does!). Finally, the geocoder runs and displays the output in tabular format with the geocoding output (lat/long) as well as on a map - using Yahoo! maps. Some info provided about the technology behind the scenes... This tool makes primary use of JavaScript ON Demand (JSOD) and JSON to dynamically call and interact with the Yahoo! REST Geocoding API. All you need is somple simple tabular address data and your web client. Ironically, shortly after posting this I heard from the developer, Phillip Holmstrand. He share's this information about the app... You can copy/paste directly from Excel, geocode, and then copy right back into Excel, and/or see addresses on a map instantly. It uses Yahoo's Geocoding API, which is nothing new, but what's nice is it allows batch processing of tabular data. Best news, it's free, and you can geocode up to 50,000 addresses per day.Check it out at http://www.batchgeocode.com/
WIDGETIZE
Anonymous # 24. October 2006, 18:15
great
Anonymous # 4. February 2007, 11:58
this is great it saves so much time!!!!
Anonymous # 27. June 2008, 14:58
The drawback of the above service you have to do the whole thing manually and cannot use the geocoded result on the fly. The alternative is to use Yahoo Geocoding to batch geocode a list of addresses and write it into a xmldocument and directly plug into a google map or something.
This article writes about how to go from a webpage to geocoding to mapping. Check it out.
http://dotnetslackers.com/articles/aspnet/The-wild-wide-web-for-mapping.aspx
Anonymous # 24. January 2009, 18:57
Another option is the USC Geocoder (https://webgis.usc.edu) where you can upload a database of addresses (mdb, csv, txt) for online processing or use the APIs or web forms to process addresses one at a time.