1 2 3 4 5 6 7 8 9
|
CompressGeometry - LINESTRINGM
:memory: #use in-memory database
SELECT Hex(geom), AsText(geom) FROM (SELECT CompressGeometry(GeomFromText('LINESTRINGM(1 2 3, 3 4 3, 5 6 4)', 4326)) AS geom)
1 # rows (not including the header row)
2 # columns
Hex(geom)
AsText(geom)
0001E6100000000000000000F03F0000000000000040000000000000144000000000000018407C124A0F0003000000000000000000F03F0000000000000040000000000000084000000040000000400000000000000840000000000000144000000000000018400000000000001040FE
LINESTRING M(1 2 3, 3 4 3, 5 6 4)
|