1
2
3
4
5
6
7
8
9
|
dissolve - Overlap points ZM
:memory: #use in-memory database
SELECT AsText(DissolveSegments(geom)),AsText(DissolvePoints(geom)) from (SELECT GeomFromText('LINESTRINGZM(0 1 0 2, 0 2 1 3, 1 2 2 4, 1 2 3 5, 1 2 3 6, 1 2 3 6)') as geom) dummy;
1 # rows (not including the header row)
2 # columns
AsText(DissolveSegments(geom))
AsText(DissolvePoints(geom))
MULTILINESTRING ZM((0 1 0 2, 0 2 1 3), (0 2 1 3, 1 2 2 4), (1 2 2 4, 1 2 3 5), (1 2 3 5, 1 2 3 6))
MULTIPOINT ZM(0 1 0 2, 0 2 1 3, 1 2 2 4, 1 2 3 5, 1 2 3 6, 1 2 3 6)
|
