I'm not good at all with SQL, so maybe the question is trivial.
I have a polygon loaded in a SpatiaLite DB and I'm using DB Manager in QGIS.
What I'm trying to do is to rotate the polygon by a given number (in degrees) using the
RotateCoords function. The syntax should be:
CREATE TABLE rotated as SELECT RotateCoords(Geometry, 45) AS Geometry from my_table
It seems to work, but I have to major issues:
How can I select all the fields from
my_tablein the same query? I'd like to maintain the same table, just rotate it. Another option could be to update the Geometry column of the existing table
The query of above creates a simple table, when I try to update the Geometry column and make the table as a spatial table it seems that nothing happens:
SELECT RecoverGeometryColumn(‘rotated’, ‘Geometry’, 3003 , ‘MULTIPOLYGON’, ‘XY’)
Am I missing something?