QGIS » QGIS Application

Extract from thread http://lists.osgeo.org/pipermail/qgis-developer/2012-February/thread.html#18510

The conclusion is in the last email

Paolo Cavallini cavallini at faunalia.it
Tue Feb 28 12:42:13 EST 2012

    Previous message: [Qgis-developer] Problems with Martin's repo
    Next message: [Qgis-developer] SpatiaLite layers invisible when loaded from browser
    Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi all.
If I load a SL layer from the browser (from the files list, not from the SL submenu),
the layer is loaded, and can be exported, but is not displayed: anyone confirms?
All the best.
-- 
Paolo Cavallini - Faunalia
www.faunalia.eu
Full contact details at www.faunalia.eu/pc

Paolo Cavallini cavallini at faunalia.it
Wed Feb 29 02:45:21 EST 2012

    Previous message: [Qgis-developer] Import support for PostGIS in browser
    Next message: [Qgis-developer] SpatiaLite layers invisible when loaded from browser
    Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Il 28/02/2012 20:23, Even Rouault ha scritto:

> I don't confirm. It works for me with both GDAL 1.9.0 and GDAL trunk, at least 
> on the attached simple example.

Confirmed: your sample is ok. The sample file[0] does not load correctly here.
Thanks.

[0]http://www.gaia-gis.it/spatialite-2.3.1/test-2.3.zip
-- 
Paolo Cavallini - Faunalia
www.faunalia.eu
Full contact details at www.faunalia.eu/pc

Even Rouault even.rouault at mines-paris.org
Wed Feb 29 14:09:32 EST 2012

    Previous message: [Qgis-developer] SpatiaLite layers invisible when loaded from browser
    Next message: [Qgis-developer] Offset curve tool
    Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Le mercredi 29 février 2012 08:45:21, Paolo Cavallini a écrit :
> Il 28/02/2012 20:23, Even Rouault ha scritto:
> > I don't confirm. It works for me with both GDAL 1.9.0 and GDAL trunk, at
> > least on the attached simple example.
> 
> Confirmed: your sample is ok. The sample file[0] does not load correctly
> here. Thanks.

I also reproduce the error with the test-2.3 database. The difference with the 
poly.sqlite that I sent before is that test-2.3 contains no spatial index.

The console has interesting error messages :

ERROR 1: In ResetStatement(): sqlite3_prepare(SELECT _rowid_, * FROM 'Towns' 
WHERE MBRIntersects("Geometry", BuildMBR(-213552396.323174118996, 
-167417043.364000141621, 215180205.733174085617, 176566090.844000160694, 
32632))):
  no such function: BuildMBR

I'd note that you get the same behaviour when opening from "Open a Vector 
Layer" (which uses the OGR driver)

What is more interesting is that the same request run from ogrinfo works 
perfectly....

I'm afraid the reason why it does not work in QGIS is that it has the bad idea 
of embedding directly libspatialite in /usr/lib/libqgis_core.so.1.9.90 instead 
of dynamically linking to the one provided by the system. So I highly suspect 
a conflict between the libspatialite linked by libgdal.so and the one linked by 
libqgis_core, especially if they are not the same version ....

Another point is  that the QGIS File Browser only displays the first OGR layer, 
whereas when opening with "Open a Vector Layer", you can choose among all OGR 
layers.