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

Abram Gillespie abe.gillespie.lists at gmail.com
Wed Jun 11 10:54:53 PDT 2008

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!

zigGIS Team
Obtuse Software, http://www.obtusesoft.com

More information about the postgis-users mailing list