<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.5730.11" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=146094511-16022007><FONT face=Arial
color=#0000ff size=2>SELECT z.zipcode</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=146094511-16022007><FONT face=Arial
color=#0000ff size=2>FROM zipcode z, zipcode z2</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=146094511-16022007><FONT face=Arial
color=#0000ff size=2>WHERE z2.zipcode = <STRONG>'02109'</STRONG> AND
expand(z2.the_geom, <STRONG><whatever radius you want goes here - but
your spatial ref needs to be in that metric or you need to convert the
radius></STRONG>) && z.the_geom AND distance(z.the_geom,
z2.the_geom) <= <STRONG><radius goes here
again></STRONG></FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>vamsee movva<BR><B>Sent:</B> Thursday, February 15, 2007 11:51
PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users]
how to find zipcodes within the radius ofparticular
zipcode.<BR></FONT><BR></DIV>
<DIV></DIV>Hi <BR>I am very sorry. I would have more clear in the last
post.<BR>I have zip codes defined by polygon and i have to find out zip
codes with in given radius.<BR>Thanking you<BR>cheers<BR>satya<BR><BR>
<DIV><SPAN class=gmail_quote>On 2/15/07, <B class=gmail_sendername>Pedro Doria
Meunier</B> <<A
href="mailto:pdoria@netmadeira.com">pdoria@netmadeira.com</A>> wrote:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV lang=PT vlink="purple" link="blue">
<DIV>
<P><SPAN style="FONT-SIZE: 11pt; COLOR: rgb(31,73,125)">Hello
Satya,</SPAN></P>
<P><SPAN style="FONT-SIZE: 11pt; COLOR: rgb(31,73,125)"></SPAN> </P>
<P><SPAN lang=EN-US style="FONT-SIZE: 11pt; COLOR: rgb(31,73,125)">There's a
lot of functions you can use but you must be more specific as to what type of
data are you using…</SPAN></P>
<P><SPAN lang=EN-US
style="FONT-SIZE: 11pt; COLOR: rgb(31,73,125)">Like:</SPAN></P>
<P><SPAN lang=EN-US style="FONT-SIZE: 11pt; COLOR: rgb(31,73,125)">Are these
zip codes defined by a polygon, point, what?</SPAN></P>
<P><SPAN lang=EN-US style="FONT-SIZE: 11pt; COLOR: rgb(31,73,125)">Please be
more specific so that the list can help you ;-)</SPAN></P>
<P><SPAN lang=EN-US
style="FONT-SIZE: 11pt; COLOR: rgb(31,73,125)">---</SPAN></P>
<P><SPAN lang=EN-US style="FONT-SIZE: 11pt; COLOR: rgb(31,73,125)">Pedro Doria
Meunier</SPAN></P>
<P><SPAN lang=EN-US
style="FONT-SIZE: 11pt; COLOR: rgb(31,73,125)"></SPAN> </P>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: rgb(181,196,223) 1pt solid; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P><B><SPAN lang=EN-US style="FONT-SIZE: 10pt">From:</SPAN></B><SPAN
lang=EN-US style="FONT-SIZE: 10pt"> <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:postgis-users-bounces@postgis.refractions.net"
target=_blank>postgis-users-bounces@postgis.refractions.net</A> [mailto:<A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:postgis-users-bounces@postgis.refractions.net"
target=_blank>postgis-users-bounces@postgis.refractions.net</A>] <B>On Behalf
Of </B>vamsee movva<BR><B>Sent:</B> quinta-feira, 15 de Fevereiro de 2007
22:49<BR><B>To:</B> <A onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.refractions.net</A><BR><B>Subject:</B>
[postgis-users] how to find zipcodes within the radius of particular
zipcode.</SPAN></P></DIV>
<DIV><SPAN class=e id=q_110c7a18a50bc2d0_1>
<P> </P>
<P>Hello,<BR>
How to find zipcodes within the radius of particular zip code.<BR>Thanks in
advance.<BR>cheers<BR>satya</P></SPAN></DIV></DIV></DIV><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</A><BR><A onclick="return top.js.OpenExtLink(window,event,this)"
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR></BLOCKQUOTE></DIV><BR></BODY></HTML>
<HTML><BODY><P><hr size=1></P><br>
<P><STRONG><br>
The substance of this message, including any attachments, may be<br>
confidential, legally privileged and/or exempt from disclosure<br>
pursuant to Massachusetts law. It is intended solely for the<br>
addressee. If you received this in error, please contact the sender<br>
and delete the material from any computer.<br>
</STRONG></P></BODY></HTML>