1 2 3 4 5 6 7
|
FromGML - MultiPolygon v3
:memory: #use in-memory database
SELECT AsEwkt(GeomFromGml('<gml:MultiSurface srsName="EPSG:4326"><gml:surfaceMembers><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList srsDimension="2">0 0 5 0 5 5 0 5 0 0</gml:posList></gml:LinearRing></gml:exterior><gml:interior><gml:LinearRing><gml:posList srsDimension="2">1 1 2 1 2 2 1 2 1 1</gml:posList></gml:LinearRing></gml:interior></gml:Polygon><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList srsDimension="2">6 6 7 6 7 7 6 7 6 6</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMembers></gml:MultiSurface>'));
1 # rows (not including the header row)
1 # columns
AsEwkt(GeomFromGml('<gml:MultiSurface srsName="EPSG:4326"><gml:surfaceMembers><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList srsDimension="2">0 0 5 0 5 5 0 5 0 0</gml:posList></gml:LinearRing></gml:exterior><gml:interior><gml:LinearRing><gml:posList srsDimension="2">1 1 2 1 2 2 1 2 1 1</gml:posList></gml:LinearRing></gml:interior></gml:Polygon><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList srsDimension="2">6 6 7 6 7 7 6 7 6 6</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMembers></gml:MultiSurface>')):0
SRID=4326;MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0),(1 1,2 1,2 2,1 2,1 1)),((6 6,7 6,7 7,6 7,6 6)))
|