[postgis-users] Buffer select from one layer to another?

[David William Bitner]

Abe --

For this type of query, running a buffer is actually not necessary.

select h.* from houses h,roads r where r.name like '%MAIN%' and
distance(h.the_geom,r.the_geom)<=500;

David

On Wed, Jun 11, 2008 at 12:54 PM, Abram Gillespie
<abe.gillespie.lists at gmail.com> wrote:
> Hi All,
>
> I'm finally starting to do some real production work ... after years
> of simply using PostGIS in example scenarios as I developed zigGIS.
> Pretty funny, actually.  Anywho, could someone enlighten me on how to
> buffer a road and return the surrounding buildings?  This is what I
> have so far:
>
> select h.* from houses h,roads r where r.name like '%MAIN%' and
> touches(h.the_geom, buffer(r.the_geom,500));
>
> Now I realize the above is a bit complex since " like '%MAIN%' "
> returns multiple road segments, but even working on a single road:
>
> select h.* from houses h,roads r where r.gid=1663 and
> touches(h.the_geom, buffer(r.the_geom,500));
>
> doesn't seem to return anything.  I'm positive the buffer query should
> return some houses.
>
> Thanks for any help!
>
> -Abe
> zigGIS Team
> Obtuse Software, http://www.obtusesoft.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
************************************
David William Bitner