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
Hello All,
I know there's been quite a few posts on Zip Code Proximity.
Can anyone point me in the right direction to find the code to calulate
the distance between two zip codes?
I'm basically trying to take a zip code given by a user and return them
all of the zip codes within, say 10 miles o
