File: geomfromkml18.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,404 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
 
From KML - MultiGeometry LINESTRING x 2
:memory:
SELECT AsText(GeomFromKML('<MultiGeometry><LineString><coordinates> -112.2550785337791,36.07954952145647 -112.2549277039738,36.08117083492122 -112.2552505069063,36.08260761307279 -112.2564540158376,36.08395660588506 -112.2580238976449,36.08511401044813 -112.2595218489022,36.08584355239394 -112.262073428656,36.08626019085147 -112.2633204928495,36.08621519860091 -112.2644963846444,36.08627897945274 -112.2656969554589,36.08649599090644 </coordinates></LineString><LineString><coordinates>1,2 3,4</coordinates></LineString></MultiGeometry>'))
1 # rows
1 # column
AsText(GeomFromKML('<MultiGeometry><LineString><coordinates> -112.2550785337791,36.07954952145647 -112.2549277039738,36.08117083492122 -112.2552505069063,36.08260761307279 -112.2564540158376,36.08395660588506 -112.2580238976449,36.08511401044813 -112.2595218489022,36.08584355239394 -112.262073428656,36.08626019085147 -112.2633204928495,36.08621519860091 -112.2644963846444,36.08627897945274 -112.2656969554589,36.08649599090644 </coordinates></LineString><LineString><coordinates>1,2 3,4</coordinates></LineString></MultiGeometry>'))
MULTILINESTRING((-112.255079 36.07955, -112.254928 36.081171, -112.255251 36.082608, -112.256454 36.083957, -112.258024 36.085114, -112.259522 36.085844, -112.262073 36.08626, -112.26332 36.086215, -112.264496 36.086279, -112.265697 36.086496), (1 2, 3 4))