<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">The problem is that the program uses <b>Sqlite</b>
not <b>Spatialite</b> 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
<a class="moz-txt-link-freetext" href="http://gis.stackexchange.com/questions/5186/sqlite-to-spatialite">http://gis.stackexchange.com/questions/5186/sqlite-to-spatialite</a>
as a pointer.<br>
<br>
Another approach is to use ogr2ogr - <a
href="http://www.gdal.org/ogr/drv_csv.html">http://www.gdal.org/ogr/drv_csv.html</a>
- to convert the table in Sqlite containing spatial data to a csv
file and import this csv file into QGis<br>
<br>
Regards<br>
Bo VictorThomsen<br>
Aestas-GIS<br>
<br>
Den 13-09-2013 01:03, Johan Nilsson skrev:<br>
</div>
<blockquote
cite="mid:CALnM-k8TJGKJaFcEM0+zPTB0NvADm0joQy3vuLbGo1KJg+7V6Q@mail.gmail.com"
type="cite">
<div dir="ltr">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:<br>
<br>
<style type="text/css">
p, li { white-space: pre-wrap; }
</style>
<p style="margin:0px;text-indent:0px">no such table:
geometry_columns</p>
<p style="margin:0px;text-indent:0px"><br>
</p>
<p style="margin:0px;text-indent:0px">How do I create a
geometry_columns and/or convert it from sqlite to spatialite?</p>
<p style="margin:0px;text-indent:0px"><br>
</p>
<p style="margin:0px;text-indent:0px"><br>
</p>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
</body>
</html>