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