1 2 3 4 5 6 7 8 9
|
fromWkb - mixed big-little-endian sub-items (2)
:memory: #use in-memory database
SELECT AsText(GeomFromWkb(CastToBlob('0107000000030000000101000000000000000000F03F00000000000000400102000000020000000000000000000000000000000000000000000000000014400000000000002440000000000300000002000000050000000000000000000000000000000040240000000000000000000000000000402400000000000040240000000000000000000000000000402400000000000000000000000000000000000000000000000000054014000000000000401400000000000040180000000000004014000000000000401800000000000040180000000000004014000000000000401800000000000040140000000000004014000000000000', 1)));
1 # rows (not including the header row)
1 # columns
AsText(GeomFromWkb(CastToBlob('0107000000030000000101000000000000000000F03F00000000000000400102000000020000000000000000000000000000000000000000000000000014400000000000002440000000000300000002000000050000000000000000000000000000000040240000000000000000000000000000402400000000000040240000000000000000000000000000402400000000000000000000000000000000000000000000000000054014000000000000401400000000000040180000000000004014000000000000401800000000000040180000000000004014000000000000401800000000000040140000000000004014000000000000', 1)))
GEOMETRYCOLLECTION(POINT(1 2), LINESTRING(0 0, 5 10), POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (5 5, 6 5, 6 6, 5 6, 5 5)))
|