[postgis-users] Points within range of line

David Bitner osgis.lists at gmail.com
Thu Aug 11 14:13:09 PDT 2005


select intersection(points,buffer(line,distance))
where points is the points geometry 
line is your line geometry 
and distance is the size of your buffer

On 8/11/05, Adrian Holovaty <postgis at holovaty.com> wrote:
> Given a PostGIS-enabled table of points, what's the best way to retrieve all
> the points that are within a certain distance of a given line? The line can
> have an arbitrary number of points (i.e., it's not straight).
> 
> Surely this is a solved problem. Thanks for any help -- I'm still
> learning! :-)
> 
> Adrian
> _______________________________________________
> 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