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

[vamsee movva]

Thank you very much Regina
cheers
satya.

On 2/16/07, Obe, Regina <robe.dnd at cityofboston.gov> wrote:
>
>  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.
> *
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070216/c8782472/attachment.html>