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