1
2
3
4
5
6
7
|
CompressGeometry - GEOMETRYCOLLECTION ZM (2 Polygons)
:memory: #use in-memory database
SELECT AsText(CompressGeometry(GeomFromText('GEOMETRYCOLLECTIONZM(POLYGONZM((10 10 77 7, 11 10 88 8, 11 11 99 9, 10 11 88 8, 10 10 77 7)), POLYGONZM((15 15 55 5, 16 15 56 6, 16 16 57 7, 15 16 58 8, 15 15 55 5)))', 4326)))
1 # rows (not including the header row)
1 # columns
AsText(CompressGeometry(GeomFromText('GEOMETRYCOLLECTIONZM(POLYGONZM((10 10 77 7, 11 10 88 8, 11 11 99 9, 10 11 88 8, 10 10 77 7)), POLYGONZM((15 15 55 5, 16 15 56 6, 16 16 57 7, 15 16 58 8, 15 15 55 5)))', 4326)))
GEOMETRYCOLLECTION ZM(POLYGON ZM((10 10 77 7, 11 10 88 8, 11 11 99 9, 10 11 88 8, 10 10 77 7)), POLYGON ZM((15 15 55 5, 16 15 56 6, 16 16 57 7, 15 16 58 8, 15 15 55 5)))
|
