1
2
3
4
5
6
7
|
EWkb: GeometryCollection XYZ
:memory: #use in-memory database
SELECT AsText(GeomFromEWkb('01070000A0E61000000400000001010000809A9999999999F13F9A999999999901400000000000005940010200008002000000000000000000F03F00000000000000400000000000005940000000000000084000000000000010400000000000405940010300008002000000050000000000000000002440000000000000244000000000000059400000000000002E40000000000000244000000000004059400000000000002E400000000000002E40000000000080594000000000000024400000000000002E400000000000C05940000000000000244000000000000024400000000000005940050000000000000000002840000000000000284000000000004059400000000000002A40000000000000284000000000008059400000000000002A400000000000002A400000000000C0594000000000000028400000000000002A400000000000005A400000000000002840000000000000284000000000004059400101000080000000000000304000000000000030400000000000005940')) AS wkt_geom;
1 # rows (not including the header row)
1 # columns
wkt_geom
GEOMETRYCOLLECTION Z(POINT Z(1.1 2.2 100), POINT Z(16 16 100), LINESTRING Z(1 2 100, 3 4 101), POLYGON Z((10 10 100, 15 10 101, 15 15 102, 10 15 103, 10 10 100), (12 12 101, 13 12 102, 13 13 103, 12 13 104, 12 12 101)))
|
