File: geomfromkml11.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-- 2,479 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
 
From KML - Geometrycollection - POLYGON with interior, 2-D
:memory:
SELECT AsText(GeomFromKML('<MultiGeometry><Polygon><outerBoundaryIs> <LinearRing> <coordinates>-122.43193945401,37.801983684521             -122.431564131101,37.8020327731402 -122.431499536494,37.801715236748 -122.43187136387,37.8016634915437 -122.43193945401,37.801983684521 </coordinates></LinearRing> </outerBoundaryIs><innerBoundaryIs>          <LinearRing>            <coordinates>              -122.431885303019,37.8019316061803              -122.431762847554,37.8019476932246              -122.431719843168,37.8017374462006 -122.431841863906,37.8017213314352              -122.431885303019,37.8019316061803  </coordinates></LinearRing></innerBoundaryIs>        <innerBoundaryIs>          <LinearRing> <coordinates> -122.431714248439,37.8019544341044 -122.431592404659,37.8019694509363              -122.431548777661,37.8017591041777   -122.431671453253,37.8017428443014   -122.431714248439,37.8019544341044            </coordinates>          </LinearRing>        </innerBoundaryIs></Polygon></MultiGeometry>'))
1 # rows
1 # column
AsText(GeomFromKML('<MultiGeometry><Polygon><outerBoundaryIs> <LinearRing> <coordinates>-122.43193945401,37.801983684521             -122.431564131101,37.8020327731402 -122.431499536494,37.801715236748 -122.43187136387,37.8016634915437 -122.43193945401,37.801983684521 </coordinates></LinearRing> </outerBoundaryIs><innerBoundaryIs>          <LinearRing>            <coordinates>              -122.431885303019,37.8019316061803              -122.431762847554,37.8019476932246              -122.431719843168,37.8017374462006 -122.431841863906,37.8017213314352              -122.431885303019,37.8019316061803  </coordinates></LinearRing></innerBoundaryIs>        <innerBoundaryIs>          <LinearRing> <coordinates> -122.431714248439,37.8019544341044 -122.431592404659,37.8019694509363              -122.431548777661,37.8017591041777   -122.431671453253,37.8017428443014   -122.431714248439,37.8019544341044            </coordinates>          </LinearRing>        </innerBoundaryIs></Polygon></MultiGeometry>'))
MULTIPOLYGON(((-122.431939 37.801984, -122.431564 37.802033, -122.4315 37.801715, -122.431871 37.801663, -122.431939 37.801984), (-122.431885 37.801932, -122.431763 37.801948, -122.43172 37.801737, -122.431842 37.801721, -122.431885 37.801932), (-122.431714 37.801954, -122.431592 37.801969, -122.431549 37.801759, -122.431671 37.801743, -122.431714 37.801954)))