[postgis-users] Fwd: cut lines with points

Nicolas Ribot nicolas.ribot at gmail.com
Fri Mar 16 02:53:15 PDT 2012

> I tried with the function of example, removing only the part "AND NOT
> ST_Intersects(ST_Boundary(..."
> because I want the line also be cut ifintersected.
> After I did so:
> create table teste9 as
> SELECT upgis_cutlineatpoints(passeios.the_geom,
> rebaixamentos_peoes.the_geom, 50 )
> FROM passeios CROSS JOIN rebaixamentos_peoes
> But did not result simply created thousands of lines of overlapping lines
> that already existed in table 'passeios'.
> Can anybody help me to resolve this?


Try to add a "distinct" clause in your final select to remove duplicate lines.
What is the query you are using ?


More information about the postgis-users mailing list