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