1
2
3
4
5
6
7
|
union - GEOMETRYCOLLECTION M (Polygon with hole / Linestring)
:memory: #use in-memory database
SELECT AsText(GUnion(GeomFromText('GEOMETRYCOLLECTIONM(LINESTRINGM(30 30 1, 31 31 2), POLYGONM((10 10 1, 15 10 2, 15 15 3, 10 15 4, 10 10 1), (11 11 1, 12 11 2, 12 12 3, 11 12 4, 11 11 1)))'), GeomFromText('GEOMETRYCOLLECTIONM(LINESTRINGM(31 31 2, 35 0 1), POLYGONM((15 10 2, 16 10 1, 16 15 3, 10 15 4, 15 10 2)))')));
1 # rows (not including the header row)
1 # columns
AsText(GUnion(GeomFromText('GEOMETRYCOLLECTIONM(LINESTRINGM(30 30 1, 31 31 2), POLYGONM((10 10 1, 15 10 2, 15 15 3, 10 15 4, 10 10 1), (11 11 1, 12 11 2, 12 12 3, 11 12 4, 11 11 1)))'), GeomFromText('GEOMETRYCOLLECTIONM(LINESTRINGM(31 31 2, 35 0 1), POLYGONM((15 10 2, 16 10 1, 16 15 3, 10 15 4, 15 10 2)))')))
GEOMETRYCOLLECTION M(LINESTRING M(30 30 0, 31 31 0), LINESTRING M(31 31 0, 35 0 0), POLYGON M((15 10 0, 10 10 0, 10 15 0, 15 15 0, 16 15 0, 16 10 0, 15 10 0), (11 11 0, 12 11 0, 12 12 0, 11 12 0, 11 11 0)))
|
