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