1
2
3
4
5
6
7
8
|
makepolygon - two holes
:memory: #use in-memory database
SELECT AsText(ST_MakePolygon(GeomFromText('LINESTRING(1 1, 1 20, 20 20, 20 1, 1 1)', 4326), GeomFromText('MULTILINESTRING((2 2, 3 2, 3 3, 2 3, 2 2), (10 10, 11 10, 11 11, 10 11, 10 10))')));
1 # rows (not including the header row)
1 # columns
AsText(ST_MakePolygon(GeomFromText('LINESTRING(1 1, 1 20, 20 20, 20 1, 1 1)', 4326), GeomFromText('MULTILINESTRING((2 2, 3 2, 3 3, 2 3, 2 2), (10 10, 11 10, 11 11, 10 11, 10 10))')));
POLYGON((1 1, 1 20, 20 20, 20 1, 1 1), (2 2, 3 2, 3 3, 2 3, 2 2), (10 10, 11 10, 11 11, 10 11, 10 10))
|
