hi,
I have a problem with an intersection with 2 lines that don't return what I expect:

sample intersection between a line and a substring of the same line:
first line: LINESTRING(675315.7 158956.9,675280 158912.9)
second: st_makeline(geomfromtext('POINT(675315.7 158956.9)'),
ST_Line_Interpolate_Point(geomfromtext('LINESTRING(675315.7 158956.9,675280 158912.9)'),0.6))

select st_astext(st_intersection(
    geomfromtext('LINESTRING(675315.7 158956.9,675280 158912.9)'),
    st_makeline(geomfromtext('POINT(675315.7 158956.9)'),
ST_Line_Interpolate_Point(geomfromtext('LINESTRING(675315.7 158956.9,675280 158912.9)'),0.6))
));

result: POINT(675315.7 158956.9)

what I expect is that the result of the intersection is not only the point of start of the 2 lines, but a linestring starting with that point but ending with the point returned by the interpolation (expected to be over the line)

I'm doing something wrong with the intersection? there is another way to get the result I expect?
or is a problem in postgis?

ps: I'm using the POSTGIS 1.5.3 version

thx for help
Daniele

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to