[mapserver-users] Mapserver does not use the spatial index with GeoPackage

[Even Rouault]

On mercredi 14 décembre 2016 13:16:47 CET Even Rouault wrote:
> On mercredi 14 décembre 2016 12:00:01 CET Rahkonen Jukka (MML) wrote:
> > Hi,
> > 
> > I am using Mapserver 7.0 with GDAL 2.1.1, released 2016/07/07
> > I have Geopackage as source data:
> > 
> > CONNECTIONTYPE OGR
> > CONNECTION "/users/wms/data/vektorit/kiinteistot/palsta.gpkg"
> > DATA "select * from palsta"
> 
> Using DATA "palsta" should likely make the RTree to be used. The "SELECT
> ..." case could probably be also improved in that case, but that depends on
> whether the OGR driver supports efficient spatial filtering on a layer
> resulting from a SQL SELECT (which should be the case in the GPKG case)
> 
> The GPKG case could also potentially benefit from similar optimizations as
> the ones I did recently for the Spatialite case (would require checking
> that a recent enough Spatialite  lib is available so that the ST_ operators
> can be used).

FYI, I've just enhanced the OGR backend to have optimizations in the GPKG case similar to the 
ones of the Spatialite case (requires GDAL >= 2 and Spatialite >= 4.3). Note: I only dealt with 
the DATA "layer_name" case, not for SELECT...


-- 
Spatialys - Geospatial professional services
http://www.spatialys.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20170109/b0b050d4/attachment.htm>