1 2 3 4 5 6 7
|
CompressGeometry - GEOMETRYCOLLECTION ZM (2 Linestrings)
:memory: #use in-memory database
SELECT AsText(CompressGeometry(GeomFromText('GEOMETRYCOLLECTIONZM(LINESTRINGZM(1 2 100 10, 3 4 101 11, 5 6 102 12), LINESTRINGZM(7 7 101 11, 8 8 102 12, 9 9 103 13))', 4326)))
1 # rows (not including the header row)
1 # columns
AsText(CompressGeometry(GeomFromText('GEOMETRYCOLLECTIONZM(LINESTRINGZM(1 2 100 10, 3 4 101 11, 5 6 102 12), LINESTRINGZM(7 7 101 11, 8 8 102 12, 9 9 103 13))', 4326)))
GEOMETRYCOLLECTION ZM(LINESTRING ZM(1 2 100 10, 3 4 101 11, 5 6 102 12), LINESTRING ZM(7 7 101 11, 8 8 102 12, 9 9 103 13))
|