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