Hi Andrea > 2014-08-18 16:52 GMT+02:00 Andrea Peri <[email protected]>: >> ... >> 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.
I'm almost certain that there's code - or at least knowhow - available for GDAL to add support for more than one table also for Spatialite. @Pirmin: What do you think? -S. 2014-08-18 16:56 GMT+02:00 Andrea Peri <[email protected]>: > 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
