[Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)
Donovan Cameron
sault.don at gmail.com
Sun Dec 9 12:16:12 PST 2012
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 spatialite_v3.sqlite -v 3
Which output:
SQLite version: 3.7.12.1
SpatiaLite version: 4.0.0
DB 'aban_wells_v3.sqlite'
converting from Version=4 to Version=3
* converted: spatial_ref_sys
* converted: geometry_columns
* converted: virts_geometry_columns
* converted: views_geometry_columns
* converted: SpatialIndex
* converted: triggers
* converted: Extra-Stuff
* converted: MetaData views
DB-file succesfully converted !!!
And now both QGIS and spatialite_gis can load those layers from the DB.
On Sun, Dec 9, 2012 at 12:37 PM, Donovan Cameron <sault.don at gmail.com> wrote:
> 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 work.
> The spec file for that contains:
> BuildRequires: libspatialite-devel >= 4
>
> I'll post a bug/enhancement request for the spatialite-gui package and
> see where it goes...
>
> On Sun, Dec 9, 2012 at 12:22 PM, Donovan Cameron <sault.don at gmail.com> wrote:
>> PostgreSQL Client Version 9.1.1
More information about the Qgis-user
mailing list