[postgis-users] Split(line, point), a temporary version until ST_Split gets fixed

[Rémi Cura]

Hey List,
here is a link a
link<https://github.com/Remi-C/PPPP_utilities/blob/master/postgis/rc_Split_Line_By_Points.sql>to
a working implementation of ST_Split((multi)line,(multi)point).
The current ST_Split is not working correctly with points due to precision
issues (and it is not working with multi ofc).

The proposed function hacks the Curvilinear api (
http://postgis.refractions.net/docs/ST_Line_Locate_Point.html, etc), in
order to escape the precision issue that plagues all point related stuff in
postgis.

Tolerance is fully supported (no segment too small can be generated with a
filtering on split point, only split if close enough).

I didn't benchmarked it, but I would expect it to be way slower than the C
(non-working) function. This is totally non-optimal but is  temporary until
the necessary changes are made on ST_Split.

Function is tested for 2.0

Cheers,
Rémi-C
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140304/fe67153e/attachment.html>