I am quite new at working with QGIS.
My Spatialite Database looks like this (arch_locations.sqlite)
Fields: pkuid short_ID name geometry
I´d also like to have two additional columns in that table in QGIS (in the Spatialite Database) where it displays the X and Y coordinates. In the "geometry" field I only see a very long combination of numbers and letters.
While looking for a way to adding those columns I found this short guide:
Using the Plugin "QSpatialite" and modifying the following code passage I managed to create another Table in QGIS with two columns containg the x and y value. I adapted this code:
CREATE TABLE 'Test' AS SELECT PKUID, X(Geometry) as X, Y(Geometry) as Y FROM Points
I did not even know where to enter the code until I installed the plugin.
Though, what I really want is to add two additional columns in the original table and to display the x/y values in those.
How do I do this?