Looks like libspatialite2, which I need for QGIS, is not available in the openSUSE repos, but only through a user HOME obs.<br>It's not officially available anymore, the only time it gets installed is during the initial installation, but once you install QGIS from the GEO repo, it upgrades to the only available spatialite which is libspatialite5 (or v4).<br>
<div class="gmail_extra"><br><br><div class="gmail_quote">On Sun, Dec 9, 2012 at 12:12 PM, Donovan Cameron <span dir="ltr"><<a href="mailto:sault.don@gmail.com" target="_blank">sault.don@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Forgot to mention that tutorial link for reference: <a href="http://www.gaia-gis.it/gaia-sins/spatialite-tutorial-2.3.1.html#t3" target="_blank">http://www.gaia-gis.it/gaia-sins/spatialite-tutorial-2.3.1.html#t3</a><div class="HOEnZb">
<div class="h5"><br><div class="gmail_extra">
<br><br><div class="gmail_quote">On Sun, Dec 9, 2012 at 12:11 PM, Donovan Cameron <span dir="ltr"><<a href="mailto:sault.don@gmail.com" target="_blank">sault.don@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Thanks alex, that's definitely helpful.<br>I tried to install pyspatialite with easy_install and it tries to grab "Best match: pyspatialite 3.0.1" which fails with a lot of errors...<br><br>I can run through the tutorials from the spatialite page and this is the initial output, telling me I am using spatialite 4:<br>
SpatiaLite version ..: 4.0.0 Supported Extensions:<br> - 'VirtualShape' [direct Shapefile access]<br> - 'VirtualDbf' [direct DBF access]<br> - 'VirtualXL' [direct XLS access]<br>
- 'VirtualText' [direct CSV/TXT access]<br> - 'VirtualNetwork' [Dijkstra shortest path]<br> - 'RTree' [Spatial Index - R*Tree]<br> - 'MbrCache' [Spatial Index - MBR cache]<br>
- 'VirtualSpatialIndex' [R*Tree metahandler]<br> - 'VirtualFDO' [FDO-OGR interoperability]<br> - 'SpatiaLite' [Spatial SQL - OGC]<br>PROJ.4 version ......: Rel. 4.8.0, 6 March 2012<br>
GEOS version ........: 3.3.6-CAPI-1.7.6<br>SQLite version ......: 3.7.12.1<br><br>I only installed QGIS from the GEO openSUSE repo.<br>I wonder if this is a dependency issue for the package maintainers?<br><br>I have a freshly installed 12.2 KDE on a laptop and that also shows the same output from above when creating a new sqlite db from spatialite.<div>
<div><br>
<div class="gmail_extra"><br><br><div class="gmail_quote">On Sun, Dec 9, 2012 at 12:00 PM, Alex Mandel <span dir="ltr"><<a href="mailto:tech_dev@wildintellect.com" target="_blank">tech_dev@wildintellect.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>On 12/09/2012 10:40 AM, Donovan Cameron wrote:<br>
> I created a sqlite/spatialite db from the spatialite_gui and started to<br>
> import a bunch of shapefiles.<br>
><br>
> Some of the things I set were the CRS to EPSG:3005 "BC Albers" and the_geom<br>
> as the name for the geometry field (type is set to auto...)<br>
><br>
> Then in spatialite_gui I expanded each new table and built a spatial index.<br>
> I can also right click each the_geom table and see a valid "Map Preview".<br>
><br>
> But I can't open or load this .sqlite files into either spatialite_gis or<br>
> qgis.<br>
> So I think this could be a problem with my actual OS (openSUSE 12.2 x64 w/<br>
> KDE).<br>
><br>
> QGIS loads the layers as tables, not vectors.<br>
> spatialite_gis thrown an error:<br>
><br>
> Missing or invalid Spatial Metadata tables:<br>
> - spatial_ref_sys<br>
> - geometry_columns<br>
><br>
> Sorry, cowardly quitting ...<br>
><br>
> But those tables are in the .sqlite db under the "Metadata" portion.<br>
><br>
> From the layer menu in QGIS, I can't create a layer in a sqlite db. It says<br>
> that my layer is invalid and can't be created. Then I can't even see this<br>
> sqlite database (that got created successfully, it's just the layer that<br>
> failed creation) when navigating from the add vector window. But I can see<br>
> it when trying to load from spatialite_gis but that throws the same error.<br>
><br>
> I noticed in the DB Manager plugin, it says that pyspatialite is missing<br>
> and that package isn't available for openSUSE in the open build service,<br>
> unless it goes by a different name...<br>
><br>
<br>
</div></div>to solve the missing pyspatialite:<br>
easy_install pyspatialite<br>
OR<br>
pip install pyspatialite<br>
<br>
packages for above commands<br>
python-setuptools<br>
python-pip or python-distrubute<br>
<br>
Keep in mind that many python packages do not come in the distros but<br>
are platform independent and easy to install from the pypi python repo<br>
using setup tools or pip.<br>
<br>
This doesn't solve your original issue. What version of spatialite are<br>
you using. QGIS doesn't support the new 4.0 stuff yet...<br>
<br>
Thanks,<br>
Alex<br>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>