[postgis-users] Buffer select from one layer to another?
ERandall at eriecountygov.org
Wed Jun 11 11:02:25 PDT 2008
Shouldn't you use intersects() rather than touches()?
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?
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
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
doesn't seem to return anything. I'm positive the buffer query should
return some houses.
Thanks for any help!
Obtuse Software, http://www.obtusesoft.com
postgis-users mailing list
postgis-users at postgis.refractions.net
More information about the postgis-users