Hot answers tagged

4

Use Spatialite Database! It is a lightweight file based spatial DB supported out of the box by QGIS. First set-up a spatialite DB following theses instructions Push your two tables to this spatialite DB using QGIS DB manager Assuming that your tables are called "polygon" and "line" run the following SQL command in DB manager query interface. SELECT ...


2

In spatialite you should be able to do a cast. Assuming a table "numbers" with one TEXT column, "number_str" (that represents integers) and a second column "number_ints" that was defined as INTEGER, then UPDATE numbers SET number_ints=(CAST(number_str AS INTEGER)); More details on the sqlite concept of "affinity" and the CAST function are here Regarding ...



Only top voted, non community-wiki answers of a minimum length are eligible