[Qgis-developer] Spatial index - what about having it automatically created and updated ?

Etienne Tourigny etourigny.dev at gmail.com
Thu Feb 27 05:56:07 PST 2014

That's a python plugin (ftools), so it may not be available to everyone.

Better to do it natively (in the data provider) doing something like
OGR_DS_ExecuteSQL("CREATE SPATIAL INDEX ON tablename [DEPTH N]") - untested

I think it's a great idea to do this automatically with large ogr data

as you said you should probably ask the gdal-dev list about which drivers
support spatial index creation an automatic update.


On Thu, Feb 27, 2014 at 7:51 AM, kimaidou <kimaidou at gmail.com> wrote:

> Hi
> 2014-02-27 11:14 GMT+01:00 Andrea Peri <aperi2007 at gmail.com>:
> I guess more better is to use this extremely simple batch and create all
>> the index in one step only.
>> sing the gdal/ogr from osgeo4w.
>> http://trac.osgeo.org/gdal/wiki/BatchCreationIndexesForShapefilesOnDOS
>> Regards,
>  As I said, I am thinking of non power users. They surely won't create nor
> use such a batch file, even if it is simple. I know there is also the great
> tool Vector / Data management tools / Create Spatial Index, which can
> create one for all layers in one step. But users do not use it : they do no
> know it exists, or they know but forget to use it.
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20140227/fd44886d/attachment.html>

More information about the Qgis-developer mailing list