[postgis-users] Break polylines by points

[Nicolas Ribot]

Hi,

Linear referencing functions are your friend here:

st_line_locate_point to get the index on the line where the point lies,
then st_line_substring to cut the line with the point:

Nicolas


On 1 February 2013 15:49, Aitor Gil Martin <agmartin at getxo.net> wrote:

> **
>
> Hi all,****
>
> I would like to split the polylines (pipes) with the points (valves). If a
> point intersects a polyline, this polyline should be transformed into two
> polylines. Both tables have 7000 records aprox.****
>
> Regards, ****
>
> * *
>
> *Aitor Gil Martin*
>
> *Departamento Informática*****
>
> *Getxoko Udala / Ayto Getxo*****
>
> Tel: **94 466 02 16** Ext.- 3457****
>
> www.getxo.net****
>
> agmartin <agmartin at getxo.net>@getxo.net <agmartin at getxo.net>****
>
> ** **
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130201/b9566c00/attachment.html>