1 2 3 4 5 6 7
|
From KML - MultiGeometry POLYGON [hole] x 2 - 3D
:memory:
SELECT AsText(GeomFromKML('<MultiGeometry><Polygon><outerBoundaryIs><LinearRing><coordinates>10,10,100 15,10,101 15,15,102 10,15,103 10,10,100</coordinates></LinearRing></outerBoundaryIs><innerBoundaryIs><LinearRing><coordinates>11,11,100 12,11,101 12,12,102 11,12,103 11,11,100</coordinates></LinearRing></innerBoundaryIs></Polygon><Polygon><outerBoundaryIs><LinearRing><coordinates>16,16,100 17,16,101 17,17,102 16,17,103 16,16,100</coordinates></LinearRing></outerBoundaryIs></Polygon></MultiGeometry>'))
1 # rows
1 # column
AsText(GeomFromKML('<MultiGeometry><Polygon><outerBoundaryIs><LinearRing><coordinates>10,10,100 15,10,101 15,15,102 10,15,103 10,10,100</coordinates></LinearRing></outerBoundaryIs><innerBoundaryIs><LinearRing><coordinates>11,11,100 12,11,101 12,12,102 11,12,103 11,11,100</coordinates></LinearRing></innerBoundaryIs></Polygon><Polygon><outerBoundaryIs><LinearRing><coordinates>16,16,100 17,16,101 17,17,102 16,17,103 16,16,100</coordinates></LinearRing></outerBoundaryIs></Polygon></MultiGeometry>'))
MULTIPOLYGON Z(((10 10 100, 15 10 101, 15 15 102, 10 15 103, 10 10 100), (11 11 100, 12 11 101, 12 12 102, 11 12 103, 11 11 100)), ((16 16 100, 17 16 101, 17 17 102, 16 17 103, 16 16 100)))
|