1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
Output format tests - MULTILINESTRINGZM 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 1, 2 3 8.4 3, 4 1 9.4 1),(0 2 1 84, 2 0 1 26, 0 0 2 -2.1, 1 1 3 0))') 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 ZM((-1 1 9 1, 2 3 8.4 3, 4 1 9.4 1), (0 2 1 84, 2 0 1 26, 0 0 2 -2.1, 1 1 3 0))
<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 1,2 3 8.4 3,4 1 9.4 1),(0 2 1 84,2 0 1 26,0 0 2 -2.1,1 1 3 0))
303130353030303045304536313030303030303230303030303030313032303030304330303330303030303030303030303030303030303046304246303030303030303030303030463033463030303030303030303030303232343030303030303030303030303046303346303030303030303030303030303034303030303030303030303030303038343043444343434343434343434332303430303030303030303030303030303834303030303030303030303030303130343030303030303030303030303046303346434443434343434343434343323234303030303030303030303030304630334630313032303030304330303430303030303030303030303030303030303030303030303030303030303030303030303034303030303030303030303030304630334630303030303030303030303035353430303030303030303030303030303034303030303030303030303030303030303030303030303030303030303046303346303030303030303030303030334134303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303034304344434343434343434343433030433030303030303030303030303046303346303030303030303030303030463033463030303030303030303030303038343030303030303030303030303030303030
|
