1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
Output format tests - POLYGON, no SRID
:memory: #use in-memory database
SELECT AsText(geom), AsKML(geom), AsKML('myname', 'mydesc', geom), AsGML(geom), AsGeoJSON(geom), AsWkt(geom), AsEWkt(geom) FROM (SELECT GeomFromText('POLYGON((0 0, 1 1, 0 2, -1 1, 0 0))') as geom) dummy;
1 # rows (not including the header row)
7 # columns
AsText(geom)
AsKML(geom)
AsKML('myname', 'mydesc', geom)
AsGML(geom)
AsGeoJSON(geom)
AsWkt(geom)
AsEWkt(geom)
POLYGON((0 0, 1 1, 0 2, -1 1, 0 0))
(NULL)
(NULL)
<gml:Polygon><gml:outerBoundaryIs><gml:LinearRing><gml:coordinates>0,0 1,1 0,2 -1,1 0,0</gml:coordinates></gml:LinearRing></gml:outerBoundaryIs></gml:Polygon>:0 # trailing ':0' required to avoid truncation !!!
{'type':'Polygon','coordinates':[[[0,0],[1,1],[0,2],[-1,1],[0,0]]]}:0 # trailing ':0' required to avoid truncation !!!
POLYGON((0 0,1 1,0 2,-1 1,0 0))
SRID=0;POLYGON((0 0,1 1,0 2,-1 1,0 0))
|
