1 2 3 4 5 6 7
|
From KML - POLYGON Z
:memory:
SELECT AsText(GeomFromKML('<Polygon><outerBoundaryIs><LinearRing><coordinates>-112.3372510731295,36.14888505105317,1784 -112.3356128688403,36.14781540589019,1784 -112.3368169371048,36.14658677734382,1784 -112.3384408457543,36.14762778914076,1784 -112.3372510731295,36.14888505105317,1784</coordinates></LinearRing></outerBoundaryIs></Polygon>'))
1 # rows
1 # column
AsText(GeomFromKML('<Polygon><outerBoundaryIs><LinearRing><coordinates>-112.3372510731295,36.14888505105317,1784 -112.3356128688403,36.14781540589019,1784 -112.3368169371048,36.14658677734382,1784 -112.3384408457543,36.14762778914076,1784 -112.3372510731295,36.14888505105317,1784</coordinates></LinearRing></outerBoundaryIs></Polygon>'))
POLYGON Z((-112.337251 36.148885 1784, -112.335613 36.147815 1784, -112.336817 36.146587 1784, -112.338441 36.147628 1784, -112.337251 36.148885 1784))
|