1
2
3
4
5
6
7
8
9
|
SquareGrid - valid - with Origin
:memory: #use in-memory database
SELECT AsText(SquareGrid(GeomFromText('POLYGON((0.2 0.2, 2.2 0.2, 2.2 1.2, 0.2 1.2, 0.2 0.2))', 4326), 1.0, 0, GeomFromText('POINT(0.1 0.1)')));
1 # rows (not including the header row)
1 # columns
AsText(SquareGrid(GeomFromText('POLYGON((0.2 0.2, 2.2 0.2, 2.2 1.2, 0.2 1.2, 0.2 0.2))', 4326), 1.0, 0, GeomFromText('POINT(0.1 0.1)')))
MULTIPOLYGON(((0.1 0.1, 1.1 0.1, 1.1 1.1, 0.1 1.1, 0.1 0.1)), ((1.1 0.1, 2.1 0.1, 2.1 1.1, 1.1 1.1, 1.1 0.1)), ((2.1 0.1, 3.1 0.1, 3.1 1.1, 2.1 1.1, 2.1 0.1)), ((0.1 1.1, 1.1 1.1, 1.1 2.1, 0.1 2.1, 0.1 1.1)), ((1.1 1.1, 2.1 1.1, 2.1 2.1, 1.1 2.1, 1.1 1.1)), ((2.1 1.1, 3.1 1.1, 3.1 2.1, 2.1 2.1, 2.1 1.1)))
|
