[postgis-users] line_interpolate_point

mj mjurce at yahoo.it
Mon Sep 18 03:00:19 PDT 2006


Hello,
the result of an line_interpolate_point(line_locate_point(....)), fails 
on intersects() function, between
the result of the interpolation and the line.

How I can obtain a point that is guaranted to intersects the line, with 
interpolation?

Thanks

Example data:

--Interpolation
select AsEWKT(line_interpolate_point(GeomFromText('LINESTRING(692592.1 
135072.3,692574.4 135071.6,
692531.7 135066.2,692503.5 135057.3)',-1),
line_locate_point(GeomFromText('LINESTRING(692592.1 135072.3,692574.4 
135071.6,
692531.7 135066.2,692503.5 135057.3)',-1),
 GeomFromText('POINT(692526.54112091 135065.87825639)',-1)) ) )

--Check for itnersections
select intersects(GeomFromText('LINESTRING(692592.1 135072.3,692574.4 
135071.6,
692531.7 135066.2,692503.5 135057.3)',-1),
GeomFromText('POINT(692526.916080715 135064.690181502)',-1))

result -> false;




More information about the postgis-users mailing list