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-boun...@lists.osgeo.org] 
Puolesta Gert Cuykens
Lähetetty: 6. maaliskuuta 2018 17:32
Vastaanottaja: Seth G <se...@geographika.co.uk>
Kopio: mapserver-users@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 <se...@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@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@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to