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)))
|