1
2
3
4
5
6
7
8
|
FromGML - poslist polygon
:memory: #use in-memory database
SELECT AsText(GeomFromGml('<gml:Polygon><gml:outerBoundaryIs><gml:LinearRing><gml:posList>0 0 -100 0 -100 100 0 100 0 0</gml:posList></gml:LinearRing></gml:outerBoundaryIs></gml:Polygon>'))
1 # rows (not including the header row)
1 # columns
AsText(GeomFromGml('<gml:Polygon><gml:outerBoundaryIs><gml:LinearRing><gml:posList>0 0 -100 0 -100 100 0 100 0 0</gml:posList></gml:LinearRing></gml:outerBoundaryIs></gml:Polygon>')):0
POLYGON((0 0, -100 0, -100 100, 0 100, 0 0))
|
