This post originated from an RSS feed registered with Ruby Buzz by Jeremy Voorhis. Original Post: Geocoding with Ruby on Rails Feed Title: JVoorhis Feed URL: http://feeds.feedburner.com/jvoorhis Feed Description: JVoorhis is a Rubyist in northeast Ohio. He rambles about Ruby on Rails, development practices, other frameworks such as Django, and on other days he is just full of snark. Latest Ruby Buzz Posts Latest Ruby Buzz Posts by Jeremy Voorhis Latest Posts From JVoorhis

I have spent a little bit of time these days at PLANET ARGON dealing with geocoding. You know, Google maps, proximity search, the works.

Last Sunday, Bryan Wood just posted his geocoding library for Ruby on Rails, including a MySQL dump with coordinates for every US zipcode and a Location model that knows trigonometry

I wanted to play with this, but as those of you in the audience who have been following along already know, we at PLANET ARGON are just as opinionated as the next guys. More specifically, we are biased towards PostgreSQL for our database needs. To combat cognitive dissonance, I fired up sed and a throw-away Ruby script and created this migration. I haven’t tested it with MySQL yet, but it ought to work with anything that supports migrations.