1
2
3
4
5
6
7
8
|
collect - PolygonZM, PolygonM
:memory: #use in-memory database
SELECT AsText(COLLECT(GeomFromText('POLYGONZM((1 2 4 1, 3 4 2 1, 3 2 3 2, 1 2 4 1),(1.5 2.5 4 1, 2.5 3.5 3 2, 2.5 2.3 3 1, 1.5 2.5 4 1))'), GeomFromText('POLYGONM((4 5 3.2, 1 2 4.6, 4 2 3.1, 4 5 3.2),(2 3 4, 3 4 1, 3 3 1, 2 3 4))')));
1 # rows (not including the header row)
1 # columns
AsText(COLLECT(GeomFromText('POLYGONZM((1 2 4 1, 3 4 2 1, 3 2 3 2, 1 2 4 1),(1.5 2.5 4 1, 2.5 3.5 3 2, 2.5 2.3 3 1, 1.5 2.5 4 1))'), GeomFromText('POLYGONM((4 5 3.2, 1 2 4.6, 4 2 3.1, 4 5 3.2),(2 3 4, 3 4 1, 3 3 1, 2 3 4))')))
MULTIPOLYGON ZM(((1 2 4 1, 3 4 2 1, 3 2 3 2, 1 2 4 1), (1.5 2.5 4 1, 2.5 3.5 3 2, 2.5 2.3 3 1, 1.5 2.5 4 1)), ((4 5 0 3.2, 1 2 0 4.6, 4 2 0 3.1, 4 5 0 3.2), (2 3 0 4, 3 4 0 1, 3 3 0 1, 2 3 0 4)))
|
