1
2
3
4
5
6
7
8
9
10
|
POLYGONIZE - polygonzm with two inner ring
:memory: #use in-memory database
SELECT AsText(Polygonize(GeomFromText('MULTILINESTRINGZM((0 0 5 4, 10 0 6 2, 10 12 7 3, 0 12 6 1, 0 0 5 4),(1 1 0 0, 3 1 0 2, 3 3 4 1, 1 3 1 2, 1 1 0 0),(4 4 0 0, 5 4 0 0, 5 5 0 0, 4 5 1 0, 4 4 0 0))')))
1 # rows (not including the header row)
1 # columns
AsText(Polygonize(GeomFromText('MULTILINESTRINGZM((0 0 5 4, 10 0 6 2, 10 12 7 3, 0 12 6 1, 0 0 5 4),(1 1 0 0, 3 1 0 2, 3 3 4 1, 1 3 1 2, 1 1 0 0),(4 4 0 0, 5 4 0 0, 5 5 0 0, 4 5 1 0, 4 4 0 0))')))
POLYGON ZM((0 0 5 0, 0 12 6 0, 10 12 7 0, 10 0 6 0, 0 0 5 0), (1 1 0 0, 3 1 0 0, 3 3 4 0, 1 3 1 0, 1 1 0 0), (4 4 0 0, 5 4 0 0, 5 5 0 0, 4 5 1 0, 4 4 0 0))
|
