Does anyone happen to have a copy of the zips.zip file from the census
bureau? Their FTP server is uncooperative.
Dustin Sallings wrote:
>
> On Thu, 18 May 2000, Jeff Hoffmann wrote:
>
> I tried to get a few permutations of that to work, but with no
> luck. The following will give a l
Actually I was thinking more on the lines of:
select location from test where location @ '((31.6283,93.6347), 1.39)'::circle;
The above lat/lon is for: Zwolle, LA
If Zylks, LA (lat/lon = 32.9696,93.9801) is also in the DB.
The above query should select Zylks since 1.39 * 62.1 = 86 miles approx.
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/gazet
