The problem is that the program uses *Sqlite* not *Spatialite* to store spatial information. Spatialite is (off course) an extension to Sqlite with a lot of administration tables and functions. So you have to convert your Sqlite database to a Spatialite database. Use this post http://gis.stackexchange.com/questions/5186/sqlite-to-spatialite as a pointer.

Another approach is to use ogr2ogr - http://www.gdal.org/ogr/drv_csv.html - to convert the table in Sqlite containing spatial data to a csv file and import this csv file into QGis

Regards
Bo VictorThomsen
Aestas-GIS

Den 13-09-2013 01:03, Johan Nilsson skrev:
I have an app Oruxmaps that store tracks and wapoint in a sqlite 3 db. When I try to open or connect it in QgisI get an error that says:

no such table: geometry_columns


How do I create a geometry_columns and/or convert it from sqlite to spatialite?






_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user

_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to