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

[Noli Sicad]

Hi Juergen and Alex

I solve the problem in New/Add Spatialite Layer.

The spatialite CLI 2.4.0r3a is actually intervening the QGIS
SpatiaLite provider (New
SpatiaLite Layer/Add SpatiaLite Layer.

I thought QGIS uses libspatialite and Spatialite binary does not
interact with QGIS.

I make unistalled Spatialite 2.4.0r3a and QGIS 1.5.0.2 works. This is
what happening to me in Windows as well. In Mac OS X, I don't install
the CLI spatialite, hence it is working properly.

Thanks for your patient on dealing this problem.

Now, we know why QGIS is not working when someone has been working
with spatialite CLI before installing QGIS.

Thanks.

Noli






On 8/29/10, Jürgen E. <jef at norbit.de> wrote:
> 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
>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>