[postgis-users] Splitting multistrings

Steffen Macke sdteffen at gmail.com
Tue Nov 21 09:28:55 PST 2006

Hi Nick,

> I'm trying to split multistrings into individual linestrings using SQL
> within PostGIS, but I cant find an appropriate function.  Is it
> possible to do this using SQL?  If not, does anyone know a way this
> can be done?

Did you have a look at the GeometryN() function?
Together with the PostgreSQL generate_series() and NumGeometries() you
should be able to split your lines accordingly.

Or do you have to insert new vertices at the split points? In this
case, a little bit
of additional information would help.



More information about the postgis-users mailing list