I created a table on a SpatiaLite-DB using the DB-Manager:
CREATE TABLE Lines (line_id INTEGER NOT NULL PRIMARY KEY,name VARCHAR(256) NOT NULL);Then I "made it spatial":
SELECT AddGeometryColumn('Lines', 'Geometry', 31468, 'Linestring', '2');So far, so good. I can load it and it's being recognized as geometry layer. However, the "Geometry" is visible as an attribute/column. How do I prevent this?
If, for example, I used DBmanager to SELECT * FROM lines and then added that layer to the QGIS window, the Geometry attribute wouldn't be visible in the fields list at all.
أكثر...
CREATE TABLE Lines (line_id INTEGER NOT NULL PRIMARY KEY,name VARCHAR(256) NOT NULL);Then I "made it spatial":
SELECT AddGeometryColumn('Lines', 'Geometry', 31468, 'Linestring', '2');So far, so good. I can load it and it's being recognized as geometry layer. However, the "Geometry" is visible as an attribute/column. How do I prevent this?
If, for example, I used DBmanager to SELECT * FROM lines and then added that layer to the QGIS window, the Geometry attribute wouldn't be visible in the fields list at all.
أكثر...