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

Collapse
10: Response to zip code distance matrix (response to 1)
Posted by David Ornelas on 02/11/02 02:35 PM
PostgreSQL has a function in /contrib called earthdistance. Using this along with a contributed procedure in the PostgreSQL cookbook http://techdocs.postgresql.org, you can pretty much do an sql query looking for the closest n providers/vendors/whatever to the given zipcode. HTH