Postgis recipe: Extracting MULTILINESTRING into LINESTRING
angch — Wed, 30/09/2009 - 12:35
insert into linestringtable (the_geom, col1, col2, col3)
select st_geometryn(the_geom,n), col1, col2, col3
from
multilinestringtable,
generate_series(1, (select max(NumGeometries(the_geom)) from multilinestringtable)) n
where st_geometryn(the_geom,n) is not null
and GeometryType(st_geometryn(the_geom,n)) ='LINESTRING';Not horribly efficient, but gets the job done.
