[mapserver-users] MapServer and Geopackage failing

Tue Mar 6 07:49:06 PST 2018

Hi,

Shapefile may be a little faster than gpkg, but not much. For me the advantages in data administration mean more than a nominal difference in speed (can use the same long attribute names than in the source data, support of longer than 255 character strings, just one file for one or more layers etc.).

-Jukka Rahkonen.

-----Alkuperäinen viesti-----
Lähettäjä: mapserver-users [mailto:mapserver-users-bounces at lists.osgeo.org] Puolesta Gert Cuykens
Lähetetty: 6. maaliskuuta 2018 17:32
Vastaanottaja: Seth G <sethg at geographika.co.uk>
Kopio: mapserver-users at lists.osgeo.org
Aihe: Re: [mapserver-users] MapServer and Geopackage failing

Having the same error message but I thought it was because of gdal not compiled with spatialite or something?

gdal = https://pkgs.alpinelinux.org/package/edge/testing/x86/gdal-dev

2018/03/02 13:18:21 [error] 15#0: *1 FastCGI sent in stderr: "CGI Request 1 on process 10
msOGRFileOpen: Spatialite support in GPKG not enabled
msOGRFileOpen: Spatialite support in GPKG not enabled
msOGRFileOpen: Spatialite support in GPKG not enabled
msOGRFileNextShape(): OGR error. OGR GetNextFeature() error'd. Check logs.
msOGRFileNextShape(): In ExecuteSQL(): sqlite3_prepare_v2(SELECT
spatialite_version()):
  no such function: spatialite_version

PS could it be using the native shapefile/qix implementation is much faster than any ogr driver/gpkg alternative even with spatial index enabled ?

On Tue, Mar 6, 2018 at 12:05 PM, Seth G <sethg at geographika.co.uk> wrote:
> Thanks Even!
> I'll get a build together and test,
>
> Seth
>
> --
> web:http://geographika.co.uk
> twitter: @geographika
>
>
> On Tue, Mar 6, 2018, at 11:41 AM, Even Rouault wrote:
>
> Seth,
>
>
>
> I've pushed a temptative fix per
>
> https://github.com/mapserver/mapserver/commit/4e4885f8598764b7cfb3a8c1
> c91c6f60eb12671f
>
> 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/aae74ff2abed3f2f8fe1f76c9
>> b4bbcc
>
>> 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
>
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users