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

Randall, Eric ERandall at eriecountygov.org
Wed Jun 11 11:02:25 PDT 2008

Shouldn't you use intersects() rather than touches()?

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of Abram
Sent: Wednesday, June 11, 2008 1:55 PM
To: PostGIS Users Discussion
Subject: [postgis-users] Buffer select from one layer to another?

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
postgis-users mailing list
postgis-users at postgis.refractions.net

More information about the postgis-users mailing list