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