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