[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
Gillespie
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!
-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
More information about the postgis-users
mailing list