Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Alex Mandel
Yes, work in the master is going on to update the provider. I'm not sure if you can backport that. Since there are likely no more releases in the QGIS 1 series you might have to wait for QGIS 2 to get spatialite 4 support. There's info on the qgis-dev list about this. Thanks, Alex On 12/09/2012

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Micha Silver
: Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables) I guess that confirms it then Alex. The QGIS 'about' window even says I have spatialite 4.0.0 installed. QGIS version 1.8.0-Lisboa QGIS code revision exported Compiled against Qt 4.8.1 Running agains

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Angelos Tzotsos
Hi Donovan, Yes, we upgraded spatialite to 4.0 a few days ago. I will talk with other maintainers on how to solve this issue. Having 2 versions of spatialite will probably make things worse, since many libraries compile against it. We would need to make a selection I am afraid. I am wondering i

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Donovan Cameron
Thanks Andre, I found that in the midterm already =) and it works great. I was trying to use the Layer > Create option, but I couldn't actually make a valid layer, I could only use that to create the sqlite database. It wouldn't let me put any layers into it. *"From the layer menu in QGIS, I can'

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Andre Joost
Am 09.12.2012 20:16, schrieb Alex Mandel: The plugin requires pyspatialite but QGIS itself has the provider built in. "SpatiaLite version ..: 4.0.0" Grab an older version of the Spatialite GUI (1.4 or 1.5) or figure out how to convert your db to the 3.x variant (I believe the release notes ment

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Donovan Cameron
As Alex suggested, converting to a v3 spatialite db was easy with the spatialite_convert tool. It's described on this page: https://www.gaia-gis.it/fossil/libspatialite/wiki?name=switching-to-4.0 And the command I issued was: cp spatialite.sqlite spatialite_v3.sqlite spatialite_convert -d spatial

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Donovan Cameron
I've been browsing the spec files for the qgis and spatialite packages from the GEO openSUSE repo. QGIS isn't actually requiring spatialite, like you said, it's built in. It's actually part of the requirements for spatialite-gui which explains why your suggestion of downgrading that package would

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Donovan Cameron
I guess that confirms it then Alex. The QGIS 'about' window even says I have spatialite 4.0.0 installed. QGIS version 1.8.0-Lisboa QGIS code revision exported Compiled against Qt 4.8.1 Running against Qt 4.8.1 Compiled against GDAL/OGR 1.9.2 Running against GDAL/OGR 1.9.2 GEOS Version 3.3.6 Postgr

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Donovan Cameron
Looks like libspatialite2, which I need for QGIS, is not available in the openSUSE repos, but only through a user HOME obs. 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

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Alex Mandel
The plugin requires pyspatialite but QGIS itself has the provider built in. "SpatiaLite version ..: 4.0.0" Grab an older version of the Spatialite GUI (1.4 or 1.5) or figure out how to convert your db to the 3.x variant (I believe the release notes mention this is possible). The metadata table ch

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Donovan Cameron
Forgot to mention that tutorial link for reference: http://www.gaia-gis.it/gaia-sins/spatialite-tutorial-2.3.1.html#t3 On Sun, Dec 9, 2012 at 12:11 PM, Donovan Cameron wrote: > Thanks alex, that's definitely helpful. > I tried to install pyspatialite with easy_install and it tries to grab > "Bes

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Donovan Cameron
Thanks alex, that's definitely helpful. 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... I can run through the tutorials from the spatialite page and this is the initial output, telling me I am using spatial

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Alex Mandel
On 12/09/2012 10:40 AM, Donovan Cameron wrote: > I created a sqlite/spatialite db from the spatialite_gui and started to > import a bunch of shapefiles. > > Some of the things I set were the CRS to EPSG:3005 "BC Albers" and the_geom > as the name for the geometry field (type is set to auto...) >

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Donovan Cameron
Not sure if it's helpful, but here is a list of installed spatialite/sqlite packages. I noticed there is two packages called libspatialite2 and sqlite2, are those causing conflicts or something? It looks like libspatialite2 is a (System Package) meaning it was installed during initial OS installati

[Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Donovan Cameron
I created a sqlite/spatialite db from the spatialite_gui and started to import a bunch of shapefiles. Some of the things I set were the CRS to EPSG:3005 "BC Albers" and the_geom as the name for the geometry field (type is set to auto...) Then in spatialite_gui I expanded each new table and built