[postgis-users] Checking the point location against a line

[Pedro Doria Meunier]

Hi G. LU

 

Use the intersects() function, for instance. don't mix geoms of different
SRIDs. ;-)

 

SELECT myfields WHERE point.geom && line.geom AND intersects(point.geom,
line.geom);

 

HTH,

Pedro Doria Meunier.

 

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Ray G.
Lu
Sent: sexta-feira, 6 de Abril de 2007 13:12
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Checking the point location against a line

 

Hello 
This is my first email (From NZ) to this lovely community. 
My question:
Is there a function provided by PostGIS can check 
a point location against a line?

E.g.
################################################

                                          P(x0,y0)  Above the line 
               
This is line
-------------------------------o------------------------------------- 
                                P(x1,y1) On the line

                                       P(x2,y2) Below the line 
################################################


Thanks in advance,

G. Lu

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070406/6143d300/attachment.html>