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