Re: [gdal-dev] [Proposed new feature] A '"SQLite" SQL dialect for OGR

2012-08-18 Thread Smith, Michael ERDC-RDE-CRREL-NH
This is "wicked cool". Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center On 8/18/12 1:03 PM, "Even Rouault" wrote: >Hi folks, > >I've attached in >http://trac.osgeo.org/gdal/attachment/ticket/4782/sqlite_dialect.patch a >patch >that adds a SQLite alternate SQL dialect that ca

[gdal-dev] [Proposed new feature] A '"SQLite" SQL dialect for OGR

2012-08-18 Thread Even Rouault
Hi folks, I've attached in http://trac.osgeo.org/gdal/attachment/ticket/4782/sqlite_dialect.patch a patch that adds a SQLite alternate SQL dialect that can be used with any OGR datasource (only available if GDAL/OGR is configured with SQLite support of course) To remind you the concept of SQL

Re: [gdal-dev] Gdalinfo slow with big Rasterlite tables

2012-08-18 Thread Even Rouault
Jukka, > > Is gdalinfo perhaps walking through every single tile in the > rasterlite table for gathering the image layer info? Could > there be any other way to do it in more effective way on the > GDAL side? The Rasterlite driver needs to fetch the extent of the "_metadata" layers to estab

[gdal-dev] Gdalinfo slow with big Rasterlite tables

2012-08-18 Thread Jukka Rahkonen
Hi, I converted 153600 x 249600 pixels of rasterdata into a Rasterlite table. After creating overviews the result behaves well in Quantum GIS once the table is opened. Unfortunatly opening the table with QGis installed on a mini PC takes ages. I do not know what QGis is really doing but I guessed