File: geomfromkml21.testcase

package info (click to toggle)
spatialite 5.1.0-3
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 74,240 kB
  • sloc: ansic: 587,051; makefile: 8,583; sh: 4,276; yacc: 1,973; xml: 717
file content (7 lines) | stat: -rw-r--r-- 1,277 bytes parent folder | download | duplicates (3)
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)))