1
2
3
4
5
6
7
8
|
GML Polygon: no SRID
:memory: #use in-memory database
SELECT AsGML(3, GeomFromText('POLYGON((10 10, 20 10, 20 20, 10 20, 10 10), (15 15, 16 15, 16 16, 15 16, 15 15))'));
1 # rows (not including the header row)
1 # columns
AsGML(3, GeomFromText('POLYGON((10 10, 20 10, 20 20, 10 20, 10 10), (15 15, 16 15, 16 16, 15 16, 15 15))'))
<gml:Polygon><gml:exterior><gml:LinearRing><gml:posList srsDimension="2">10 10 20 10 20 20 10 20 10 10</gml:posList></gml:LinearRing></gml:exterior><gml:interior><gml:LinearRing><gml:posList srsDimension="2">15 15 16 15 16 16 15 16 15 15</gml:posList></gml:LinearRing></gml:interior></gml:Polygon>:0 # trailing ":0" required to avoid truncation !!!
|
