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

David William Bitner david.bitner at gmail.com
Wed Jun 11 11:08:39 PDT 2008

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


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

More information about the postgis-users mailing list