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