Re: Zip Code Proximity - Mailing list pgsql-general

Jeff Hoffmann wrote:

> select zip, location <@> '(lat, lon)'::box
>   from zipcodes
>  order by location <@> '(lat, lon)'::box
>  limit 10;
>

oops, typo.  those boxes should be points.  plus, it looks like you can
get zipcodes & lat-longs from the census at:

http://ftp.census.gov/geo/www/gazetteer/places.html