7
votes
1answer
2k views

Explode MULTILINESTRING into individual segments in PostGIS 1.5

I have a MULTILINESTRING in PostGIS consisting of several LINESTRING's. Consider each LINESTRING to have a set of POINT's P1, P2, ... PN forming the line segments L1, L2, ... LN-1 where ...