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