1
2
3
4
5
6
7
8
|
makepolygon - XYM hole
:memory: #use in-memory database
SELECT AsText(ST_MakePolygon(GeomFromText('LINESTRINGM(1 1 4, 1 20 3, 20 20 2, 20 1 3, 1 1 4)', 4326), GeomFromText('LINESTRINGM(2 2 10, 3 2 11, 3 3 12, 2 3 13, 2 2 10)')));
1 # rows (not including the header row)
1 # columns
AsText(ST_MakePolygon(GeomFromText('LINESTRINGM(1 1 4, 1 20 3, 20 20 2, 20 1 3, 1 1 4)', 4326), GeomFromText('LINESTRINGM(2 2 10, 3 2 11, 3 3 12, 2 3 13, 2 2 10)')))
POLYGON M((1 1 4, 1 20 3, 20 20 2, 20 1 3, 1 1 4), (2 2 10, 3 2 11, 3 3 12, 2 3 13, 2 2 10))
|
