Just to explain why this is an important question. On a sqlite db is impossible to remove a field. So if a table is with two geometry field, it is never see-able from qgis. Because is not possible a command like:
alter table remove filed geometry-2; Bye, Andrea Peri. 2014-08-18 16:52 GMT+02:00 Andrea Peri <[email protected]>: > Hi, > > I have changed my opinin. > From +1 to +0 > > Infact I discovered just now that gdal driver for spatialite don't > seem to support tables with more than 1 geometrt field. > Almost on QGIS. > > Andrea > > > 2014-05-17 22:19 GMT+02:00 Jeremy Palmer <[email protected]>: >> I'm wondered why QGIS needs a native SpatiaLite provider and connection >> dialogue any more. Unlike other database providers such as PostGIS, Oracle, >> MSSQL the SpatiaLite provider doesn't seem to have anything special that >> requires a QGIS provider. From a users perspective it just adds to the >> confusion and complexity for adding data. Why not just use GDAL/OGR for both >> Geopackage and Spatialite? >> >> Cheers >> Jeremy >> ________________________________________ >> From: Stefan Keller [[email protected]] >> Sent: Sunday, 18 May 2014 12:24 a.m. >> To: Martin Dobias >> Cc: Jeremy Palmer; [email protected] >> Subject: Re: [Qgis-developer] Geospackage Slow in QGIS >> >> Hi Martin >> >> It has a different binary encoding compared to Spatialite. >> And in addition it integrates raster tiles (MBTiles) and metadata. >> >> -S. >> >> >> 2014-05-17 14:10 GMT+02:00 Martin Dobias >> <[email protected]<mailto:[email protected]>>: >> Hi >> >> On Sat, May 17, 2014 at 2:32 PM, Jeremy Palmer >> <[email protected]<mailto:[email protected]>> wrote: >>> I've just been using the new implementation of Geopackage in QGIS :) >>> However each map render or feature info is very slow for large database >>> files - even with the new GDAL/OGR Geopackage spatial index support. Each >>> time QGIS renders a new map view or executes a feature info it re-opens the >>> Geopackage file in QgsOgrFeatureIterator via OGROpen, and the Geopackage >>> driver open method runs PRAGMA integrity_check which is very slow (4 secs >>> with my 2GB test file). This integrity check is actually a Geopackage >>> requirement. >>> >>> How can this be fixed? At the in QGIS or GDAL/OGR level? >> >> Actually I am wondering how different is the format of GeoPackage from >> the format of SpatiaLite... we could use our native SpatiaLite >> provider also for GeoPackage files if they are close enough. Any >> ideas? >> >> Regards >> Martin >> _______________________________________________ >> Qgis-developer mailing list >> [email protected]<mailto:[email protected]> >> http://lists.osgeo.org/mailman/listinfo/qgis-developer >> >> This message contains information, which may be in confidence and may be >> subject to legal privilege. If you are not the intended recipient, you must >> not peruse, use, disseminate, distribute or copy this message. If you have >> received this message in error, please notify us immediately (Phone 0800 665 >> 463 or [email protected]) and destroy the original message. LINZ accepts no >> responsibility for changes to this email, or for any attachments, after its >> transmission from LINZ. Thank You. >> _______________________________________________ >> Qgis-developer mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/qgis-developer > > > > -- > ----------------- > Andrea Peri > . . . . . . . . . > qwerty àèìòù > ----------------- -- ----------------- Andrea Peri . . . . . . . . . qwerty àèìòù ----------------- _______________________________________________ Qgis-developer mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-developer
