[Qgis-user] How to read a sqlite from a gps-app?

[Bo Victor Thomsen]

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
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130913/8e7f2356/attachment.html>