[mapserver-users] MapServer and Geopackage failing

[Even Rouault]

Seth,

I've pushed a temptative fix per
https://github.com/mapserver/mapserver/commit/4e4885f8598764b7cfb3a8c1c91c6f60eb12671f
but I'm not completely positive this will fix what you've seen.

Even

> Hi all,
> 
> I'm trying out the geopackage format as an alternative to shapefiles but
> running into an issue where MapServer expects the geopackage dataset to
> include spatialite. Drawing layers with shp2img logs the following:
> 
> [Tue Mar 06 10:39:42 2018].512000 msDrawMap(): rendering using outputformat
> named png (AGG/PNG). [Tue Mar 06 10:39:42 2018].512000 msDrawMap(): WMS/WFS
> set-up and query, 0.000s [Tue Mar 06 10:39:42 2018].529000 msOGRFileOpen:
> Spatialite support in GPKG not enabled [Tue Mar 06 10:39:42 2018].549000
> msOGRFileNextShape(): OGR error. OGR GetNextFeature() error'd. Check logs.
> [Tue Mar 06 10:39:42 2018].549000 msOGRFileNextShape(): In ExecuteSQL():
> sqlite3_prepare(SELECT spatialite_version()): no such function:
> spatialite_version
> [Tue Mar 06 10:39:42 2018].550000 msDrawMap(): Image handling error. Failed
> to draw layer named 'ways'.
> 
> The spatialite_version function is missing in the geopackage. The dataset
> was created by exporting from MapServer as an OUTPUTOPTION:
> 
>       OUTPUTFORMAT
>         NAME "GeoPackage"
>         DRIVER "OGR/GPKG"
>         FORMATOPTION "STORAGE=memory"
>         FORMATOPTION "FORM=simple"
>         FORMATOPTION "FILENAME=result.gpkg"
>         FORMATOPTION "DSCO:SPATIALITE=YES"	# not a listed option, but tried
> anyway FORMATOPTION "LCO:SPATIAL_INDEX=YES"
>     END
> 
> Running a GisInternals build,  including GDAL 2.1.3 and MapServer 7.0.4.
> 
> Relevant code is at
> https://github.com/mapserver/mapserver/blob/aae74ff2abed3f2f8fe1f76c9b4bbcc
> f15023dc1/mapogr.cpp#L1313 It looks like the error should be swallowed up?
> 
> The same dataset exported directly to spatilite works fine.
> 
> Anyone experienced the above issue?
> 
> Regards,
> 
> Seth
> 
> 
> --
> web:http://geographika.co.uk
> twitter: @geographika
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users


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