1 2 3 4 5 6 7
|
fromewkt36
:memory: #use in-memory database
SELECT AsText(GeomFromEWKT('SRID=4326;GEOMETRYCOLLECTIONM(POINTM(9 9 9), GEOMETRYCOLLECTIONM(POINTM(0 0 9), LINESTRINGM(1 1 9, 2 2 9)), POINTM(8 8 9), GEOMETRYCOLLECTIONM(POINTM(3 3 9), LINESTRINGM(4 4 9, 5 5 9)), POINTM(7 7 9))'));
1 # rows (not including the header row)
1 # columns
AsText(GeomFromEWKT('SRID=4326;GEOMETRYCOLLECTIONM(POINTM(9 9 9), GEOMETRYCOLLECTIONM(POINTM(0 0 9), LINESTRINGM(1 1 9, 2 2 9)), POINTM(8 8 9), GEOMETRYCOLLECTIONM(POINTM(3 3 9), LINESTRINGM(4 4 9, 5 5 9)), POINTM(7 7 9))'));
GEOMETRYCOLLECTION M(POINT M(9 9 9), POINT M(0 0 9), POINT M(8 8 9), POINT M(3 3 9), POINT M(7 7 9), LINESTRING M(1 1 9, 2 2 9), LINESTRING M(4 4 9, 5 5 9))
|