[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