1
2
3
4
5
6
7
8
9
|
dissolve - MULTILINESTRINGZM
:memory: #use in-memory database
SELECT AsText(DissolveSegments(geom)),AsText(DissolvePoints(geom)) from (SELECT GeomFromText('MULTILINESTRINGZM((30 20 1 2, 10 40 1 2, 45 40 1 2, 30 20 1 2),(15 5 2 3, 40 10 2 3, 10 20 2 3, 5 10 2 3, 15 5 2 3))') as geom) dummy;
1 # rows (not including the header row)
2 # columns
AsText(DissolveSegments(geom))
AsText(DissolvePoints(geom))
MULTILINESTRING ZM((30 20 1 2, 10 40 1 2), (10 40 1 2, 45 40 1 2), (45 40 1 2, 30 20 1 2), (15 5 2 3, 40 10 2 3), (40 10 2 3, 10 20 2 3), (10 20 2 3, 5 10 2 3), (5 10 2 3, 15 5 2 3))
MULTIPOINT ZM(30 20 1 2, 10 40 1 2, 45 40 1 2, 30 20 1 2, 15 5 2 3, 40 10 2 3, 10 20 2 3, 5 10 2 3, 15 5 2 3)
|
