[Qgis-psc] (QGIS 2020 Grant Report) Use of FileGeodatabase spatial index in OpenFileGDB driver

[Régis Haubourg]

This is great!

Thanks a lot Even (and Nyall IIRC)

Régis

On 28/09/2020 22:29, Even Rouault wrote:
>
> Hi,
>
>  
>
> I want to report about the outcome of
>
> https://github.com/qgis/QGIS-Enhancement-Proposals/issues/172
>
> "Use of FileGeodatabase spatial index in OpenFileGDB driver"
>
>  
>
> This work has been successfully completed into GDAL master (for
> upcoming GDAL 3.2) per https://github.com/OSGeo/gdal/pull/2771 , and
> automatically benefits to QGIS when it uses the OpenFileGDB driver.
>
>  
>
> Some figures on a version from of few years ago of the dataset at
>
> https://data.linz.govt.nz/layer/50772-nz-primary-parcels/, featuring 2
> 484 646 polygons, 773 MB: "ogrinfo -spat 174.949909 -41.143842
> 175.684529 -40.594600 -al -so -noextent" (thus counting the number of
> features intersecting the spatial filter), which returns 81 046
> polygons, nows runs in 400 ms with GDAL 3.2dev and the OpenFileGDB
> driver, versus 6.7 s before (full scan), vs 890 ms with the FileGDB
> driver (with FileGDB SDK 1.5).
>
> All figures given with debug builds, and on a hot run (so with most
> pages cached by the OS).
>
>  
>
> Interactive display of this dataset in QGIS with the OpenFileGDB
> driver is as fluid as with the FileGDB one. Comparing behaviour of
> OpenFileGDB and FileGDB drivers with strace shows that they read a
> similar amount of data in the .spx file, which confirms it is uses
> correctly.
>
>  
>
> The filegdb reverse engineered specification was also updated in
>
> https://github.com/rouault/dump_gdbtable/wiki/FGDB-Spec#specification-of-spx-files
>
>  
>
> Thanks to qgis.org grant program for making this improvement possible.
>
>  
>
> Best regards,
>
>  
>
> Even
>
>  
>
> -- 
>
> Spatialys - Geospatial professional services
>
> http://www.spatialys.com
>
>
> _______________________________________________
> Qgis-psc mailing list
> Qgis-psc at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/qgis-psc

-- 
Open Source GIS Expert / Water management 

mail: regis.haubourg at oslandia.com 
tél: 0033 184 257 870
---------------------------------
http://oslandia.com/

OSLANDIA IS AN INNOVATIVE COMPANY SPECIALIZED IN GIS ARCHITECTURE. WE
PROVIDE SERVICE ON OPEN SOURCE SOFTWARE FOR WHICH WE ARE EDITORS OR
RECOGNIZED EXPERTS.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-psc/attachments/20200929/dcd4d216/attachment.html>