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