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 a
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
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
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 sault@gmail.comwrote:
Thanks alex, that's definitely helpful.
I tried to install pyspatialite with easy_install and it
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
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
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
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
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
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
GMT+02:00
Subject: 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
11 matches
Mail list logo