Re: [GENERAL] Zip Code Proximity

[Jeff Hoffmann]

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