[postgis-users] st_split

franco base frenk.calza at gmail.com
Mon Oct 28 10:07:17 PDT 2013


Hi.
I have a set of linestring and point on linestring.
I want cut the linestring on the point.
I can have n points for one linestring,
so I use ST_Split
(insted of ST_Line_Interpolate_Point and ST_Line_Substring)
but it doesn't work.

line;geom_line;point;geom_point
7646;"0102000020BB0B000006000000A4703D0A471F37412D211F04AF335341FAEDEBE0491F3741325530C2AE335341BD5296014F1F37418FC2F578AE3353414694F606521F3741D2DEE07BAE3353412D211F74541F37418FC2F578AE33534123B9FC675020374112143FF6BC335341";11764;"0101000020BB0B00005713362F611F37410D996234AF335341"
7646;"0102000020BB0B000006000000A4703D0A471F37412D211F04AF335341FAEDEBE0491F3741325530C2AE335341BD5296014F1F37418FC2F578AE3353414694F606521F3741D2DEE07BAE3353412D211F74541F37418FC2F578AE33534123B9FC675020374112143FF6BC335341";11769;"0101000020BB0B00005EF0DD584620374139BF2762BC335341"
7646;"0102000020BB0B000006000000A4703D0A471F37412D211F04AF335341FAEDEBE0491F3741325530C2AE335341BD5296014F1F37418FC2F578AE3353414694F606521F3741D2DEE07BAE3353412D211F74541F37418FC2F578AE33534123B9FC675020374112143FF6BC335341";11762;"0101000020BB0B0000A5CBC785841F374156A2A33CB1335341"

ST_GeometryType(St_Split(geom_line, geom_point))
give "ST_GeometryCollection"

but

(ST_Dump(ST_Split(geom_line, geom_point))).geom

return only 3 linestring (one for record) and the geometry is egual to
geom_line


thanks.

fb
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131028/80f51f5d/attachment.html>


More information about the postgis-users mailing list