Re: [Qgis-developer] QGIS build with GDAL 1.7.x - Ubuntu
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 13Fax. +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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] QGIS build with GDAL 1.7.x - Ubuntu
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. j...@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 13Fax. +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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] QGIS build with GDAL 1.7.x - Ubuntu
Hi Noli, On Sat, 28. Aug 2010 at 14:51:29 +1000, Noli Sicad wrote: It seems that QGIS trunk builds is still building using GDAL 1.6 as of 27 August 2010. The builds are simply using the GDAL the distribution has. As far as I can see only ubuntugis currently has GDAL 1.7. That will eventually change and once it does the nightly builds will pick it up. You can always build you own packages - with is particulary easy on debian (and ubuntu). Install GDAL 1.7 from ubuntugis (or experimental - in the debian case) and [1] Jürgen [1] http://www.qgis.org/wiki/Installation_Guide#Building_Debian_packages -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-20 Dipl.-Inf. (FH) Rheinstraße 13Fax. +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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] QGIS build with GDAL 1.7.x - Ubuntu
Il 28/08/2010 09:53, Jürgen E. Fischer ha scritto: You can always build you own packages - with is particulary easy on debian (and In case someone does it, please make the packages available to everybody. All the best. -- Paolo Cavallini: http://www.faunalia.it/pc ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] QGIS build with GDAL 1.7.x - Ubuntu
Hi Juergen, Thanks for your suggestion in compiling from the source. However, I investigated your QGIS 1.5.0.2 built and this one is actually build with libgdal1.7.0. I installed it and it is actually using GDAL 1.7.2 and Spatialite 2.4.0 But I could not open any spatialite that I created and also the spatialite file (subway_test.sqlite) found in this website below. http://gothos.info/2010/02/calculated-fields-in-spatialite-sqlite/ This is very strange bug. nyc_pumas (Geometry is an invalid layer and cannot be loaded). William's Mac OS X QGIS - QGIS-dev does not have this bug. I will try to see what is inside that that built before compiling one. He just did the compiling last weekend. Thanks. Regards, Noli On 8/28/10, Jürgen E. j...@norbit.de wrote: Hi Noli, On Sat, 28. Aug 2010 at 14:51:29 +1000, Noli Sicad wrote: It seems that QGIS trunk builds is still building using GDAL 1.6 as of 27 August 2010. The builds are simply using the GDAL the distribution has. As far as I can see only ubuntugis currently has GDAL 1.7. That will eventually change and once it does the nightly builds will pick it up. You can always build you own packages - with is particulary easy on debian (and ubuntu). Install GDAL 1.7 from ubuntugis (or experimental - in the debian case) and [1] Jürgen [1] http://www.qgis.org/wiki/Installation_Guide#Building_Debian_packages -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-20 Dipl.-Inf. (FH) Rheinstraße 13Fax. +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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] QGIS build with GDAL 1.7.x - Ubuntu
Hi Noli, On Sat, 28. Aug 2010 at 19:40:16 +1000, Noli Sicad wrote: Thanks for your suggestion in compiling from the source. However, I investigated your QGIS 1.5.0.2 built and this one is actually build with libgdal1.7.0. Sure. As said earlier ubuntugis has GDAL 1.7 and the QGIS version in ubuntugis uses it. And for the other builds spatialite support through the spatialite provider will also work just fine (ie. Layer/Add Spatialite Layer or Layer/New Spatialite Layer). But Save As doesn't use the spatialite provider but OGR. So for that SpatiaLite support is up to GDAL/OGR. AFAIK earlier versions of GDAL didn't have a clear distinction between SQLite and SpatiaLite - so you don't know if sqlite means SQLite and SpatiaLite unless you check how GDAL was built. I'm not even sure GDAL 1.7 changes that - but it probably usually always built with spatialite. Jürgen -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-20 Dipl.-Inf. (FH) Rheinstraße 13Fax. +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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] QGIS build with GDAL 1.7.x - Ubuntu
Hi Juergen And for the other builds spatialite support through the spatialite provider will also work just fine (ie. Layer/Add Spatialite Layer or Layer/New Spatialite Layer). QGIS 1.5.0.2 has problem with these processes. Mac OS version can do these operations. But Save As doesn't use the spatialite provider but OGR. So for that SpatiaLite support is up to GDAL/OGR. AFAIK earlier versions of GDAL didn't have a clear distinction between SQLite and SpatiaLite - so you don't know if sqlite means SQLite and SpatiaLite unless you check how GDAL was built. I'm not even sure GDAL 1.7 changes that - but it probably usually always built with spatialite. Mac OS version has the same problem. It saves as sqlite, not spatialite. Right now, Saves As should be avoid if we can dealing with Spatialite. I hope this will be fixed or remove from the listbox as option. Noli ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] QGIS build with GDAL 1.7.x - Ubuntu
Hi Juergen, I still have problem opening spatialite database / files in trunk version - Quantum GIS - 1.6.0-Trunk 'Trunk' (14162M). I am using Ubuntu 10.04. I think there is no problem with ubuntu 9.10, as some of the users are indicated before. Anybody using Ubuntu 10.04 and can open spatialite database and what versions of QGIS, spatialite, ogr2org, etc. The mac os x QGIS-dev has almost same libraries used in QGIS 1.5.0.2 lucid except the Qt 4.6.3 instead of Qt4.6.2. Here's log files of various versions of the libraries used in 1.6.0-Trunk 'Trunk' (14162M). n...@noli-laptop:~$ cat /etc/issue Ubuntu 10.04 LTS \n \l n...@noli-laptop:~$ ogr2org -version No command 'ogr2org' found, did you mean: Command 'ogr2ogr' from package 'gdal-bin' (universe) ogr2org: command not found n...@noli-laptop:~$ ogr2org --version No command 'ogr2org' found, did you mean: Command 'ogr2ogr' from package 'gdal-bin' (universe) ogr2org: command not found n...@noli-laptop:~$ org2org --version org2org: command not found n...@noli-laptop:~$ ogr2ogr --version GDAL 1.7.2, released 2010/04/23 n...@noli-laptop:~$ spatialite --version SpatiaLite version ..: 2.4.0Supported Extensions: - 'VirtualShape'[direct Shapefile access] - 'VirtualDbf' [direct DBF access] - 'VirtualText' [direct CSV/TXT access] - 'VirtualNetwork' [Dijkstra shortest path] - 'RTree' [Spatial Index - R*Tree] - 'MbrCache'[Spatial Index - MBR cache] - 'VirtualFDO' [FDO-OGR interoperability] - 'SpatiaLite' [Spatial SQL - OGC] PROJ.4 version ..: Rel. 4.7.1, 23 September 2009 GEOS version : 3.2.2-CAPI-1.6.2 3.6.22 n...@noli-laptop:~$ qgis --version qgis: unrecognized option '--version' Quantum GIS - 1.6.0-Trunk 'Trunk' (14162M) Quantum GIS (QGIS) is a viewer for spatial data sets, including raster and vector data. Usage: qgis [options] [FILES] options: [--snapshot filename] emit snapshot of loaded datasets to given file [--width width] width of snapshot to emit [--height height] height of snapshot to emit [--lang language] use language for interface text [--project projectfile] load the given QGIS project [--extent xmin,ymin,xmax,ymax] set initial map extent [--nologo] hide splash screen [--noplugins] don't restore plugins on startup [--optionspath path]use the given QSettings path [--configpath path] use the given path for all user configuration [--help]this text FILES: Files specified on the command line can include rasters, vectors, and QGIS project files (.qgs): 1. Rasters - Supported formats include GeoTiff, DEM and others supported by GDAL 2. Vectors - Supported formats include ESRI Shapefiles and others supported by OGR and PostgreSQL layers using the PostGIS extension n...@noli-laptop:~$ qgis --version qgis: unrecognized option '--version' Quantum GIS - 1.6.0-Trunk 'Trunk' (14162M) Quantum GIS (QGIS) is a viewer for spatial data sets, including raster and vector data. Usage: qgis [options] [FILES] options: [--snapshot filename] emit snapshot of loaded datasets to given file [--width width] width of snapshot to emit [--height height] height of snapshot to emit [--lang language] use language for interface text [--project projectfile] load the given QGIS project [--extent xmin,ymin,xmax,ymax] set initial map extent [--nologo] hide splash screen [--noplugins] don't restore plugins on startup [--optionspath path]use the given QSettings path [--configpath path] use the given path for all user configuration [--help]this text FILES: Files specified on the command line can include rasters, vectors, and QGIS project files (.qgs): 1. Rasters - Supported formats include GeoTiff, DEM and others supported by GDAL 2. Vectors - Supported formats include ESRI Shapefiles and others supported by OGR and PostgreSQL layers using the PostGIS extension n...@noli-laptop:~$ clear n...@noli-laptop:~$ cat /etc/issue Ubuntu 10.04 LTS \n \l n...@noli-laptop:~$ ogr2ogr --version GDAL 1.7.2, released 2010/04/23 n...@noli-laptop:~$ spatialite --version SpatiaLite version ..: 2.4.0Supported Extensions: - 'VirtualShape'[direct Shapefile access] - 'VirtualDbf' [direct DBF access] - 'VirtualText' [direct CSV/TXT access] - 'VirtualNetwork' [Dijkstra shortest path] - 'RTree' [Spatial Index - R*Tree] - 'MbrCache'[Spatial Index - MBR cache] - 'VirtualFDO' [FDO-OGR interoperability] - 'SpatiaLite' [Spatial SQL - OGC] PROJ.4 version ..: Rel. 4.7.1,
Re: [Qgis-developer] QGIS build with GDAL 1.7.x - Ubuntu
Hi Alex, Thanks for your reply. I can make a new Spatialite layer using Layer-New-New Spatialite Layer. I believe this is the only correct way to make a Spatialite layer in the current version, Not 'Save As' that is OGR sqlite only. It is editable, saveable and loadable. Note QGIS uses a built in Spatialite in this case, I do not have spatialite installed on the system. Yes, I understand, the New Spatialite layer and QGIS has its own spatialite provider compiled wtih QGIS. My problem is, I am not creating any spatialite layer in QGIS, I like to view and edit spatialite created outside QGIS. The one that I am testing in opening in QGIS ubuntu has been open in Mac OS X QGIS-dev. I could not open the old and new spatialite, or any spatialite files in QGIS ubuntu. I can also verify that I can open Spatialite layers created with older versions of Spatialite directly in QGIS. You might want to start fresh with just what you get from the Ubuntugis repos. Mixing and matching with custom compiled can easily lead to multiple conflicting versions of libraries on your system path. Which version of QGIS are you using that is working spatialite? This version QGIS 1.5.0.2, right. Did you get it from this repository. sudo apt-get install add-apt-repository sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable sudo aptitude install qgis As mentioned in my previous posting, I am using QGIS 1.5.0.2 and QGIS1.6 trunk created by Juergen with no success. When I installed these two versions, one at the time, it actually picked the right library it was compiled as features of linux system. It does not mix and match until you compile your own version of QGIS. I have not done any compiling yet. I really like to get your version that is working. My ubuntu 10.04 is really clean since I just installed it 2 days ago and beside beside I am using the stock sqlite3 and spatialite that comes with ubuntu 10.04, not the new versions of sqlite and spatialite 2.4.0 r3a. Do you know any other repository e.g. Xubuntu 10.04 that has QGIS that is working with Spatialite? Thanks. Noli ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] QGIS build with GDAL 1.7.x - Ubuntu
The qgis package of UbuntuGIS seems to be built against gdal 1.7.x. http://trac.osgeo.org/ubuntugis/ Alan On August 27, 2010 08:16:50 am Noli Sicad wrote: Hi, Where could I get QGIS build with GDAL 1.7.x - Ubuntu? It seems that QGIS 1.5 and QGIS 1.6 trunk are built using GDAL1.6.3 and python-qgis and other are using GDAL 1.7.3. I could not open spatialite database created using the latest 2.4.0 in QGIS built with GDAL 1.6.3. Mac OS X QGIS 1.6 trunk works perfectly. However, I need SciTE - no SciTE in Mac OS X. Noli ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer -- Alan Boudreault Mapgears http://www.mapgears.com ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] QGIS build with GDAL 1.7.x - Ubuntu
Hi Alan, Qgis1.5.0-2~lucid1 is not in repository anymore. I think it has been replaced by QGIS 1.6.0 + svn14153 -lucid1 which I installed. Quantum GIS r14153M In the Help Menu Help- About - This copy of QGIS has been buiilt with GDAL/OCR 1.6.3. I thought that the QGIS trunk is compiling using GDAL 1.7.3 now. Mac OS X Qgis-dev is compiled using GDAL 1.7.3. https://launchpad.net/~ubuntugis/+archive/ubuntugis-unstable I am very sure that I am using this repository since all your packages are showing in Synaptic Package Manager. Thanks. Noli On 8/28/10, Alan Boudreault aboudrea...@mapgears.com wrote: The qgis package of UbuntuGIS seems to be built against gdal 1.7.x. http://trac.osgeo.org/ubuntugis/ Alan On August 27, 2010 08:16:50 am Noli Sicad wrote: Hi, Where could I get QGIS build with GDAL 1.7.x - Ubuntu? It seems that QGIS 1.5 and QGIS 1.6 trunk are built using GDAL1.6.3 and python-qgis and other are using GDAL 1.7.3. I could not open spatialite database created using the latest 2.4.0 in QGIS built with GDAL 1.6.3. Mac OS X QGIS 1.6 trunk works perfectly. However, I need SciTE - no SciTE in Mac OS X. Noli ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer -- Alan Boudreault Mapgears http://www.mapgears.com ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] QGIS build with GDAL 1.7.x - Ubuntu
The funny thing about this built QGIS 1.6.0 is, if can't open the spatialite it created. Here's the steps. 1. Open shapefile 2. Save it as spatialite i.e. Sqlite 3. Remove shapefile 4. Open the newly created Sqlite I can't open the sqlite file that QGIS created. I don't know what is wrong. Where could I find QGIS 1.5.0 ubuntu that can open spatialite that it created it? The windows QGIS, not mentioned Mac OS X can do the above steps. Noli ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] QGIS build with GDAL 1.7.x - Ubuntu
Hi Noli, On Sat, Aug 28, 2010 at 1:33 AM, Noli Sicad nsi...@gmail.com wrote: The funny thing about this built QGIS 1.6.0 is, if can't open the spatialite it created. Here's the steps. 1. Open shapefile 2. Save it as spatialite i.e. Sqlite Maybe did you use Save as...? If you did, the .sqlite you created is not a valid spatialite database (non-spatial table inside it) but only a sqlite vector file. To open it use Add vector layer. Cheers. 3. Remove shapefile 4. Open the newly created Sqlite I can't open the sqlite file that QGIS created. I don't know what is wrong. Where could I find QGIS 1.5.0 ubuntu that can open spatialite that it created it? The windows QGIS, not mentioned Mac OS X can do the above steps. Noli ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer -- Giuseppe Sucameli ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] QGIS build with GDAL 1.7.x - Ubuntu
Here's the steps. 1. Open shapefile 2. Save it as spatialite i.e. Sqlite Maybe did you use Save as...? No. I clicked the vector layer and save sqlite. I have been this testing for 2 weeks now, trying to find the right version of QGIS in Windows, Mac OS X and Linux with Spatialite. My laptop now is triple boot (Window 7, Mac OS X and Ubuntu) to find a solution. If you did, the .sqlite you created is not a valid spatialite database (non-spatial table inside it) but only a sqlite vector file. To open it use Add vector layer. I tried to do this Add vector layer with spatialite a week ago in Windows 7 and Windows XP. The funny thing is QGIS tries to open it as well and display tables to open. It should say not a valid file. Anyway, I have been doing the same steps / processes in QGIS in Windows and Mac OS X. Both built can open spatialite it created. QGIS windows has still problem with the latest spatialite 2.4.0. But at least it open spatialite database it created i.e. saving the vector file into sqlite. One of the main features of QGIS 1.5 release is how easy to save vector files to spatialite and open it. Building QGIS with GDAL1.7.3 would fix this problem as William did in QGIS Mac OS X. It seems that QGIS trunk builds is still building using GDAL 1.6 as of 27 August 2010. Noli ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer