[postgis-users] Splitting multistrings
sdteffen at gmail.com
Tue Nov 21 09:28:55 PST 2006
> 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