[mapserver-users] Mapserver 7.0.6 from MS4W does not find spatial index from Spatialite
Rahkonen Jukka (MML)
jukka.rahkonen at maanmittauslaitos.fi
Fri Aug 25 05:32:14 PDT 2017
Hi,
I have a Spatialite database which has a valid and consistent spatial index if I ask spatialite-gui to check it. However Mapserver 7.0.6 from MS4W 3.2.2 does not find it.
Layer is defined as
CONNECTIONTYPE OGR
DEBUG 5
CONNECTION "\ms4w_data\apps\wms-wfs.sqlite"
DATA "select * from states"
[Fri Aug 25 15:17:41 2017].225000 OGROPen(\ms4w_data\apps\wms-wfs.sqlite)
[Fri Aug 25 15:17:41 2017].235000 msConnPoolRegister(states,\ms4w_data\apps\wms-wfs.sqlite,00A0F2D0)
[Fri Aug 25 15:17:41 2017].236000 msOGRFileOpen(): Layer select * from states has spatial index disabled
[Fri Aug 25 15:17:41 2017].236000 msOGRFileWhichShapes: SQL = select * from states WHERE MbrIntersects("Geometry", BuildMbr(-110.556532,27.919128,-78.556643,44.907341)).
I wonder what is the check that is performed. Obviously not either of these two:
select spatial_index_enabled from geometry_columns where f_table_name='states';
returns 1
select checkspatialindex('states','geometry');
returns 1
-Jukka Rahkonen-
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20170825/9cddc82b/attachment.htm>
More information about the MapServer-users
mailing list