« GetSET Hackers @ Yahoo! | Main | Application Gallery 'most requested' Feature Is Live »
August 10, 2007
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.
I’ve been working with a spreadsheet containing addresses that want to be geocoded. I’ve had lots of experience running batches of addresses through geocoding services, but in the case of the police department I’ve 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 I’m a complete novice when it comes to this stuff, I’m hoping that by posting my code I’ll also find out about other and better approaches.
Good to see our geocoder being put to good use.
Have you come up with a cool way of using it? If so, let us know...
Jeremy Zawodny
Yahoo! Developer Network
Posted at August 10, 2007 12:18 PM
Comment Policy: We encourage comments and look forward to hearing from you. Please note that Yahoo! may, in our sole discretion, remove comments if they are off topic, inappropriate, or otherwise violate our Terms of Service.
Copyright © 2008 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Copyright Policy - Job Openings