Thank you very much Regina<br>cheers<br>satya.<br><br><div><span class="gmail_quote">On 2/16/07, <b class="gmail_sendername">Obe, Regina</b> <<a href="mailto:robe.dnd@cityofboston.gov">robe.dnd@cityofboston.gov</a>> wrote:
</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">SELECT z.zipcode</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">FROM zipcode z, zipcode z2</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" 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 dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><span class="q"><b>From:</b>
<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of
</b>vamsee movva<br></span><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><span class="e" id="q_110ca65001f9d5ca_3">
<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" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">pdoria@netmadeira.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div vlink="purple" link="blue" lang="PT">
<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 style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">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 style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Like:</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Are these
zip codes defined by a polygon, point, what?</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Please be
more specific so that the list can help you ;-)</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">---</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Pedro Doria
Meunier</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"></span> </p>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0cm 0cm;">
<p><b><span style="font-size: 10pt;" lang="EN-US">From:</span></b><span style="font-size: 10pt;" lang="EN-US"> <a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
postgis-users-bounces@postgis.refractions.net</a> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">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 href="mailto:postgis-users@postgis.refractions.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">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>
<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 href="mailto:postgis-users@postgis.refractions.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">postgis-users@postgis.refractions.net
</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></span></div></div>
<div><p></p><hr size="1"><p></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></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>