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