1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
Output format tests - POLYGONM 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;POLYGONM((-10 -10 1, -10 10 2, 10 10 3, 10 -10 4, -10 -10 1),(-1 1 2.3, 1 -2 4.6, 0 -2 1.6, -1 1 2.3))') 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))
POLYGON M((-10 -10 1, -10 10 2, 10 10 3, 10 -10 4, -10 -10 1), (-1 1 2.3, 1 -2 4.6, 0 -2 1.6, -1 1 2.3))
<Polygon><outerBoundaryIs><LinearRing><coordinates>-10,-10 -10,10 10,10 10,-10 -10,-10</coordinates></LinearRing></outerBoundaryIs><innerBoundaryIs><LinearRing><coordinates>-1,1 1,-2 0,-2 -1,1</coordinates></LinearRing></innerBoundaryIs></Polygon>
<gml:Polygon srsName='EPSG:4326'><gml:outerBoundaryIs><gml:LinearRing><gml:coordinates>-10,-10 -10,10 10,10 10,-10 -10,-10</gml:coordinates></gml:LinearRing></gml:outerBoundaryIs><gml:innerBoundaryIs><gml:LinearRing><gml:coordinates>-1,1 1,-2 0,-2 -1,1</gml:coordinates></gml:LinearRing></gml:innerBoundaryIs></gml:Polygon>:0
{'type':'Polygon','coordinates':[[[-10,-10],[-10,10],[10,10],[10,-10],[-10,-10]],[[-1,1],[1,-2],[0,-2],[-1,1]]]}:0
POLYGON((-10 -10,-10 10,10 10,10 -10,-10 -10),(-1 1,1 -2,0 -2,-1 1)):0
SRID=4326;POLYGONM((-10 -10 1,-10 10 2,10 10 3,10 -10 4,-10 -10 1),(-1 1 2.3,1 -2 4.6,0 -2 1.6,-1 1 2.3))
303130333030303036304536313030303030303230303030303030353030303030303030303030303030303030303234433030303030303030303030303032344330303030303030303030303030463033463030303030303030303030303234433030303030303030303030303032343430303030303030303030303030303034303030303030303030303030303234343030303030303030303030303032343430303030303030303030303030303834303030303030303030303030303234343030303030303030303030303032344330303030303030303030303030313034303030303030303030303030303234433030303030303030303030303032344330303030303030303030303030463033463034303030303030303030303030303030303030463042463030303030303030303030304630334636363636363636363636363630323430303030303030303030303030463033463030303030303030303030303030433036363636363636363636363631323430303030303030303030303030303030303030303030303030303030303030433039413939393939393939393946393346303030303030303030303030463042463030303030303030303030304630334636363636363636363636363630323430
|
