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