If you're an Excel power user with a stack of addresses you'd like to geocode, look no farther than Jon Udell's Excel geocoding adventures to learn how.
Ive been working with a spreadsheet containing addresses that want to be geocoded. Ive had lots of experience running batches of addresses through geocoding services, but in the case of the police department Ive been working with, it would be nice to be able to do the geocoding interactively.
In his signature style, Jon lays out the problem, walks through his thinking, illustrates the solution, and even provides example code.
All in all, it was an educational exercise. The patterns here can serve as a model for any scenario that involves interactively querying a web service based on some cell in Excel, and then incorporating the results into companion cells. Of course since Im a complete novice when it comes to this stuff, Im hoping that by posting my code Ill also find out about other and better approaches.
Good to see ourRead More »from Using the Yahoo Geocoder with Excel