Forum OpenACS Q&A: Response to zip code distance matrix

Posted by David Ornelas on
PostgreSQL has a function in /contrib called earthdistance. Using this along with a contributed procedure in the PostgreSQL cookbook, you can pretty much do an sql query looking for the closest n providers/vendors/whatever to the given zipcode. HTH