File: fromgml48.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,612 bytes parent folder | download | duplicates (4)
1
2
3
4
5
6
7
FromGML - GeometryCollection v3 3D
:memory: #use in-memory database
SELECT AsEwkt(GeomFromGml('<gml:MultiGeometry srsName="EPSG:4326"><gml:geometryMembers><gml:Point><gml:pos srsDimension="3">8 8 10.5</gml:pos></gml:Point><gml:Curve><gml:segments><gml:LineStringSegment><gml:posList srsDimension="3">9 9 10.5 10.1 10.1 10.6</gml:posList></gml:LineStringSegment></gml:segments></gml:Curve><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList srsDimension="3">0 0 10 5 0 11 5 5 13 0 5 13 0 0 10</gml:posList></gml:LinearRing></gml:exterior><gml:interior><gml:LinearRing><gml:posList srsDimension="3">1 1 5 2 1 5 2 2 5 1 2 5 1 1 5</gml:posList></gml:LinearRing></gml:interior></gml:Polygon></gml:geometryMembers></gml:MultiGeometry>'));
1 # rows (not including the header row)
1 # columns
AsEwkt(GeomFromGml('<gml:MultiGeometry srsName="EPSG:4326"><gml:geometryMembers><gml:Point><gml:pos srsDimension="3">8 8 10.5</gml:pos></gml:Point><gml:Curve><gml:segments><gml:LineStringSegment><gml:posList srsDimension="3">9 9 10.5 10.1 10.1 10.6</gml:posList></gml:LineStringSegment></gml:segments></gml:Curve><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList srsDimension="3">0 0 10 5 0 11 5 5 13 0 5 13 0 0 10</gml:posList></gml:LinearRing></gml:exterior><gml:interior><gml:LinearRing><gml:posList srsDimension="3">1 1 5 2 1 5 2 2 5 1 2 5 1 1 5</gml:posList></gml:LinearRing></gml:interior></gml:Polygon></gml:geometryMembers></gml:MultiGeometry>')):0
SRID=4326;GEOMETRYCOLLECTION(POINT(8 8 10.5),LINESTRING(9 9 10.5,10.1 10.1 10.6),POLYGON((0 0 10,5 0 11,5 5 13,0 5 13,0 0 10),(1 1 5,2 1 5,2 2 5,1 2 5,1 1 5)))