[postgis-users] how to find zipcodes within the radius ofparticular zipcode.

[Obe, Regina]

SELECT z.zipcode
FROM zipcode z, zipcode z2
WHERE z2.zipcode = '02109' AND expand(z2.the_geom, <whatever radius you
want goes here - but your spatial ref needs to be in that metric or you
need to convert the radius>) && z.the_geom   AND distance(z.the_geom,
z2.the_geom) <= <radius goes here again>

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
vamsee movva
Sent: Thursday, February 15, 2007 11:51 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] how to find zipcodes within the radius
ofparticular zipcode.


Hi 
I am very sorry. I would have more clear in the last post.
I have  zip codes defined by polygon and i have to find out zip codes
with in given radius.
Thanking you
cheers
satya


On 2/15/07, Pedro Doria Meunier <pdoria at netmadeira.com> wrote: 

	Hello Satya,

	 

	There's a lot of functions you can use but you must be more
specific as to what type of data are you using...

	Like:

	Are these zip codes defined by a polygon, point, what?

	Please be more specific so that the list can help you ;-)

	---

	Pedro Doria Meunier

	 

	From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
vamsee movva
	Sent: quinta-feira, 15 de Fevereiro de 2007 22:49
	To: postgis-users at postgis.refractions.net
	Subject: [postgis-users] how to find zipcodes within the radius
of particular zipcode.

	 

	Hello,
	            How to find zipcodes within the radius of particular
zip code.
	Thanks in advance.
	cheers
	satya


	_______________________________________________
	postgis-users mailing list
	postgis-users at postgis.refractions.net 
	http://postgis.refractions.net/mailman/listinfo/postgis-users
	
	





-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070216/81bc5720/attachment.html>