1
2
3
4
5
6
7
|
geomfromtext27
:memory: #use in-memory database
SELECT AsText(GeomFromText('GEOMETRYCOLLECTIONM(POINTM(8 8 9), MULTIPOLYGONM(((0 0 9, 5 0 9, 5 5 9, 0 5 9, 0 0 9), (1 1 9, 2 1 9, 2 2 9, 1 2 9, 1 1 9)), ((10 10 9, 11 10 9, 11 11 9, 10 11 9, 10 10 9))), POINTM(7 7 9), MULTILINESTRINGM((0 1 9, 2 3 9), (4 5 9, 6 7 9)), POINTM(6 6 9), MULTIPOINTM((0 1 9), (2 3 9), (4 5 9)), POINTM(9 9 9))'));
1 # rows (not including the header row)
1 # columns
AsText(GeomFromText('GEOMETRYCOLLECTIONM(POINTM(8 8 9), MULTIPOLYGONM(((0 0 9, 5 0 9, 5 5 9, 0 5 9, 0 0 9), (1 1 9, 2 1 9, 2 2 9, 1 2 9, 1 1 9)), ((10 10 9, 11 10 9, 11 11 9, 10 11 9, 10 10 9))), POINTM(7 7 9), MULTILINESTRINGM((0 1 9, 2 3 9), (4 5 9, 6 7 9)), POINTM(6 6 9), MULTIPOINTM((0 1 9), (2 3 9), (4 5 9)), POINTM(9 9 9))'));
GEOMETRYCOLLECTION M(POINT M(8 8 9), POINT M(7 7 9), POINT M(6 6 9), POINT M(0 1 9), POINT M(2 3 9), POINT M(4 5 9), POINT M(9 9 9), LINESTRING M(0 1 9, 2 3 9), LINESTRING M(4 5 9, 6 7 9), POLYGON M((0 0 9, 5 0 9, 5 5 9, 0 5 9, 0 0 9), (1 1 9, 2 1 9, 2 2 9, 1 2 9, 1 1 9)), POLYGON M((10 10 9, 11 10 9, 11 11 9, 10 11 9, 10 10 9)))
|
