1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
rotate coords - Two ring polygonzm
: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('POLYGONZM((0 0 1 1, 2 2 2 2, 2 4 3 3, -2 2 4 4, 0 0 1 1),(0 0 5 0, 1 1 6 1, 1 2 7 2, -1 1 8 3, 0 0 5 0))') 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 ZM((0 0 1 1, 2 2 2 2, 2 4 3 3, -2 2 4 4, 0 0 1 1), (0 0 5 0, 1 1 6 1, 1 2 7 2, -1 1 8 3, 0 0 5 0))
POLYGON ZM((0 0 1 1, 2 -2 2 2, 4 -2 3 3, 2 2 4 4, 0 0 1 1), (0 0 5 0, 1 -1 6 1, 2 -1 7 2, 1 1 8 3, 0 0 5 0))
POLYGON ZM((0 0 1 1, -2 -2 2 2, -2 -4 3 3, 2 -2 4 4, 0 0 1 1), (0 0 5 0, -1 -1 6 1, -1 -2 7 2, 1 -1 8 3, 0 0 5 0))
POLYGON ZM((0 0 1 1, -2 2 2 2, -4 2 3 3, -2 -2 4 4, 0 0 1 1), (0 0 5 0, -1 1 6 1, -2 1 7 2, -1 -1 8 3, 0 0 5 0))
(NULL)
(NULL)
(NULL)
|
