Re: [postgis-users] the nearest point of a line from a point

2008-01-31 Thread sylvain dubouis
It works, thanks for your help 2008/1/30, Kevin Neufeld <[EMAIL PROTECTED]>: > > Hi Sylvain, > > ST_ prefixed functions is the new way to access PostGIS methods, > following the SQL-MM specifications. It sounds like you'll need to > upgrade your PostGIS version. > > See this thread in the archives

Re: [postgis-users] the nearest point of a line from a point

2008-01-30 Thread Kevin Neufeld
Hi Sylvain, ST_ prefixed functions is the new way to access PostGIS methods, following the SQL-MM specifications. It sounds like you'll need to upgrade your PostGIS version. See this thread in the archives for more info. http://postgis.refractions.net/pipermail/postgis-users/2007-September/01

Re: [postgis-users] the nearest point of a line from a point

2008-01-30 Thread sylvain dubouis
Thanks Kevin, It seems to be the good solution, but I can't execute "st_" functions : ERROR: function st_line_locate_point(geometry, geometry) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. Do you know why? and how I can Inst

Re: [postgis-users] the nearest point of a line from a point

2008-01-30 Thread Kevin Neufeld
See the section on linear referencing (sec. 6.2.7). (http://postgis.refractions.net/docs/ch06.html#id2775904) You'll need to use two methods. ST_line_locate_point(LineString, Point) returns the percentage along the the LineString the closest point will occur. ST_line_interpolate_point(linest

[postgis-users] the nearest point of a line from a point

2008-01-30 Thread sylvain dubouis
hello, I have a point and a line. I'd like to know the nearest point on the line from the point. but I don't find any function to do this... is there one? thanks for your help. Sylvain ___ postgis-users mailing list postgis-users@postgis.refractions.net