[Qgis-developer] QGIS build with GDAL 1.7.x - Ubuntu

[Jürgen E. Fischer]

Hi Noli,

On Sun, 29. Aug 2010 at 12:00:15 +1000, Noli Sicad wrote:
> I still have problem opening spatialite database / files  in trunk
> version - Quantum GIS - 1.6.0-Trunk 'Trunk' (14162M).

Ok, let me repeat our earlier findings (with some additional info).

Creating and using SpatiaLite databases via the SpatiaLite provider (New
SpatiaLite Layer/Add SpatiaLite Layer) should work with any QGIS.

But to create SpatiaLite databases using the QgsVectorFileWriter class (Save As)
or use them via the OGR provider (Add Vector Layer) requires a QGIS linked to
GDAL 1.7 that in turn is linked with SpatiaLite 2.4.

The only public available Linux build I know that has that is the ubuntugis
build of QGIS 1.5 - because ubuntugis' GDAL 1.7 has SpatiaLite support.

The nightly debian builds are built against the GDAL the respective
distribution has.  Which is commonly earlier than GDAL 1.7 and therefore
doesn't include SpatiaLite support.

So unless you install a GDAL 1.7 from ubuntugis (or Debian experimental) and
use a QGIS build against it (QGIS 1.5 from ubuntugis or your own build), you
won't have SpatiaLite support in "Save As" and the OGR provider.  SQLite
support is probably there, but that's different from SpatiaLite.

Which version of SpatiaLite is in use in the SpatiaLite provider is determined
by whether or not the build is using the system's SpatiaLite or the qgis'
internal SpatiaLite.

The nightly trunk builds for Debian Squeeze and unstable and Ubuntu Lucid and
Maverick use the system's SpatiaLite, all others (read Debian Lenny) use
internal SpatiaLite, which currently is 2.4.0.  

When unstable and Maverick contain GDAL 1.7 the nightly builds with pick it up
automatically.  So eventually the "problem" with the nightly builds will solve
itself.

> Anybody using Ubuntu 10.04 and can open spatialite database and what
> versions of QGIS, spatialite, ogr2org, etc.

The tool is called ogr2ogr.   But you could even have multiple libaries and
therefore have a GDAL 1.7 ogr2ogr (from gdal-bin), but a QGIS that still uses
an earlier GDAL.

The version of GDAL your OGR provider is using is shown by

  ldd /usr/lib/qgis/plugins/libogrprovider.so | grep gdal

And the version of system SpatiaLite, if any, the SpatiaLite provider uses is
shown by

  ldd /usr/lib/qgis/plugins/libspatialiteprovider.so | grep spatialite

You can also check the about box to see the versions QGIS was built with (which
still might not necessarily be the currently installed and running versions).


Jürgen

-- 
Jürgen E. Fischer         norBIT GmbH               Tel. +49-4931-918175-20
Dipl.-Inf. (FH)           Rheinstraße 13            Fax. +49-4931-918175-50
Software Engineer         D-26506 Norden               http://www.norbit.de

-- 
norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502