[postgis-users] points coinciding with lines

[Paul Ramsey]

You probably want to do it within a tolerance, using ST_DWithin...

select points.*,lines.id from points, lines where ST_DWithin 
(points.the_geom, lines.the_geom, 0.01);

P

On 6-Oct-07, at 5:11 PM, temiz wrote:

> hello
>
> I have point geometry table and a line geometry table.
> how can I query these points coinciding with the lines ?
>
> regards
>
>
> -- 
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users