1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
rotate coords - Two ring polygonm
:memory: #use in-memory database
SELECT AsText(RotateCoords(geom, 0)), AsText(RotateCoords(geom, 90.0)), AsText(RotateCoords(geom, 180.0)), AsText(RotateCoords(geom, -90)), RotateCoords(zeroblob(20), 10), RotateCoords(geom, 'hello'), RotateCoords('foo', 30) FROM (SELECT GeomFromText('POLYGONM((0 0 1, 2 2 2, 2 4 3, -2 2 4, 0 0 1),(0 0 5, 1 1 6, 1 2 7, -1 1 8, 0 0 5))') as geom) dummy;
1 # rows (not including the header row)
7 # columns
AsText(RotateCoords(geom, 0))
AsText(RotateCoords(geom, 90.0))
AsText(RotateCoords(geom, 180.0))
AsText(RotateCoords(geom, -90))
RotateCoords(zeroblob(20), 10)
RotateCoords(geom, 'hello')
RotateCoords('foo', 30)
POLYGON M((0 0 1, 2 2 2, 2 4 3, -2 2 4, 0 0 1), (0 0 5, 1 1 6, 1 2 7, -1 1 8, 0 0 5))
POLYGON M((0 0 1, 2 -2 2, 4 -2 3, 2 2 4, 0 0 1), (0 0 5, 1 -1 6, 2 -1 7, 1 1 8, 0 0 5))
POLYGON M((0 0 1, -2 -2 2, -2 -4 3, 2 -2 4, 0 0 1), (0 0 5, -1 -1 6, -1 -2 7, 1 -1 8, 0 0 5))
POLYGON M((0 0 1, -2 2 2, -4 2 3, -2 -2 4, 0 0 1), (0 0 5, -1 1 6, -2 1 7, -1 -1 8, 0 0 5))
(NULL)
(NULL)
(NULL)
|
