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