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 distance(h.the_geom,r.the_geom)<=500; David On Wed, Jun 11, 2008 at 12:54 PM, Abram Gillespie <[EMAIL PROTECTED]> 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@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- ************************************ David William Bitner _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
