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