1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
Output format tests - LINESTRINGZM via EWKB, WGS-84
:memory: #use in-memory database
SELECT AsText(GeomFromWkb(AsBinary(geom))), AsKML(geom), AsGML(geom), AsGeoJSON(geom), AsWkt(geom), AsEWkt(geom), Hex(AsEWKB(geom)) FROM (SELECT GeomFromEWkt('SRID=4326;LINESTRING(-1 1 2.3 -1, 1 -2 4.6 -6)') as geom) dummy;
1 # rows (not including the header row)
7 # columns
AsText(GeomFromWkb(AsBinary(geom)))
AsKML(geom)
AsGML(geom)
AsGeoJSON(geom)
AsWkt(geom)
AsEWkt(geom)
Hex(AsEWKB(geom))
LINESTRING ZM(-1 1 2.3 -1, 1 -2 4.6 -6)
<LineString><coordinates>-1,1,2.3 1,-2,4.6</coordinates></LineString>
<gml:LineString srsName='EPSG:4326'><gml:coordinates>-1,1,2.3 1,-2,4.6</gml:coordinates></gml:LineString>:0
{'type':'LineString','coordinates':[[-1,1,2.3],[1,-2,4.6]]}:0
LINESTRING(-1 1,1 -2)
SRID=4326;LINESTRING(-1 1 2.3 -1,1 -2 4.6 -6):0
30313032303030304530453631303030303030323030303030303030303030303030303030304630424630303030303030303030303046303346363636363636363636363636303234303030303030303030303030304630424630303030303030303030303046303346303030303030303030303030303043303636363636363636363636363132343030303030303030303030303031384330
|
