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

[Abram Gillespie]

David,

Worked perfectly.  Thanks a bunch!

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

On Wed, Jun 11, 2008 at 2:08 PM, David William Bitner
<david.bitner at gmail.com> wrote:
> 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
> <abe.gillespie.lists at gmail.com> 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 at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
>
> --
> ************************************
> David William Bitner
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>