1 2 3 4 5 6 7 8
|
CompressGeometry - GEOMETRYCOLLECTION / LINESTRINGZ
:memory: #use in-memory database
SELECT Hex(CompressGeometry(GeomFromText('GeometryCollectionZ(LINESTRINGZ(1 2 0, 3 4 0))')))
1 # rows (not including the header row)
1 # columns
Hex(CompressGeometry(GeomFromText('GeometryCollectionZ(LINESTRINGZ(1 2 0, 3 4 0))')))
000100000000000000000000F03F0000000000000040000000000000084000000000000010407CEF03000001000000692A460F0002000000000000000000F03F00000000000000400000000000000000000000000000084000000000000010400000000000000000FE
|