1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
Output format tests - MULTILINESTRINGZ 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;MULTILINESTRING((-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 Z((-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,9 2,3,8.4 4,1,9.4</coordinates></LineString><LineString><coordinates>0,2,1 2,0,1 0,0,2 1,1,3</coordinates></LineString></MultiGeometry>
<gml:MultiLineString srsName='EPSG:4326'><gml:lineStringMember><gml:LineString><gml:coordinates>-1,1,9 2,3,8.4 4,1,9.4</gml:coordinates></gml:LineString></gml:lineStringMember><gml:lineStringMember><gml:LineString><gml:coordinates>0,2,1 2,0,1 0,0,2 1,1,3</gml:coordinates></gml:LineString></gml:lineStringMember></gml:MultiLineString>:0
{'type':'MultiLineString','coordinates':[[[-1,1,9],[2,3,8.4],[4,1,9.4]],[[0,2,1],[2,0,1],[0,0,2],[1,1,3]]]}:0
MULTILINESTRING((-1 1,2 3,4 1),(0 2,2 0,0 0,1 1))
SRID=4326;MULTILINESTRING((-1 1 9,2 3 8.4,4 1 9.4),(0 2 1,2 0 1,0 0 2,1 1 3))
3031303530303030413045363130303030303032303030303030303130323030303038303033303030303030303030303030303030303030463042463030303030303030303030304630334630303030303030303030303032323430303030303030303030303030303034303030303030303030303030303038343043444343434343434343434332303430303030303030303030303030313034303030303030303030303030304630334643444343434343434343434332323430303130323030303038303034303030303030303030303030303030303030303030303030303030303030303030303030343030303030303030303030303046303346303030303030303030303030303034303030303030303030303030303030303030303030303030303030303046303346303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303430303030303030303030303030463033463030303030303030303030304630334630303030303030303030303030383430
|
