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