Radius of a zip code

From: "Andy Lewis" <jumboc(at)comcast(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Radius of a zip code
Date: 2003-12-26 23:42:08
Message-ID: 000b01c3cc09$e043fd70$0201a8c0@andy2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello all,

I was trying to find all zip codes within a given zip code or radius.

I have map points and Latitude and Longitude in my zip table.

I remember seeing a post or two referencing this but can't see to find
it.

I've tried the following with no luck:

-- 20 Miles
--select 20 * 360.0 / (7900.0 * atan2(1,1) * 4.0);
select * from zip_code where map_loc @
circle(map_point('dallas','tx','75201'), .290105212724467 ) order by
city

Anyone that has this experience, can you validate this for correctness?

Thanks in advance,

Andy

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-12-27 00:09:49 Re: Radius of a zip code
Previous Message Tom Lane 2003-12-26 23:37:40 Re: Anti log in PostgreSQL