1
2
3
4
5
6
7
8
9
10
11
|
SquareGrid - valid - no 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));
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))
MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((1 0, 2 0, 2 1, 1 1, 1 0)), ((2 0, 3 0, 3 1, 2 1, 2 0)), ((0 1, 1 1, 1 2, 0 2, 0 1)), ((1 1, 2 1, 2 2, 1 2, 1 1)), ((2 1, 3 1, 3 2, 2 2, 2 1)))
|
