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 <[email protected]> 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 <[email protected]>@getxo.net <[email protected]>**** > > ** ** > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
