[gdal-dev] GDAL does not support gpkg files generated by GeoServer

[Even Rouault]

Hi,

http://www.geopackage.org/spec/#_sqlite_container "Table 1. GeoPackage 
Data Types" is pretty clear on which data types are valid in a 
GeoPackage vector table, and INT4, VARCHAR(...) or FLOAT8 are not.

You can also use the 
https://github.com/OSGeo/gdal/blob/master/swig/python/gdal-utils/osgeo_utils/samples/validate_gpkg.py 
script although it is not official, but hopefully should be faithful to 
the spec. Otherwise you can use the official validator at 
https://cite.opengeospatial.org/teamengine/

Even

Le 14/02/2024 à 14:51, Raymond Nijssen via gdal-dev a écrit :
> Some fields in geopackages generated by GeoServer are not supported by 
> GDAL. I have already made a ticket for GeoServer, but I'm unsure where 
> the problem lies.
>
> More info in the GeoServer ticket here:
> https://osgeo-org.atlassian.net/browse/GEOS-11292
>
> ---
> Gpkg output can contain fields of type INT4, VARCHAR(255) and FLOAT8 
> which are not supported by GDAL/OGR. For this reason, QGIS, GRASS and 
> FME ignore those fields on import.
>
> ray at fw13:~/Downloads$ ogrinfo ext_nat_nbp.gpkg
> Warning 1: GPKG: unrecognized user_version=0x00000000 (0) on 
> 'ext_nat_nbp.gpkg'
> INFO: Open of ext_nat_nbp.gpkg'       using driver GPKG' successful.
> Warning 1: Field format 'INT4' not supported. Interpreted as INT
> Warning 1: Field format 'VARCHAR(255)' not supported
> Warning 1: geometry column 'deelgebied' of type 'VARCHAR(255)' ignored
> Warning 1: Field format 'FLOAT8' not supported
> Warning 1: geometry column 'oppervlakte_hectare' of type 'FLOAT8' ignored
> Warning 1: Field format 'VARCHAR(255)' not supported
> Warning 1: geometry column 'plan_naam' of type 'VARCHAR(255)' ignored
> 1: ext_nat_nbp (Multi Polygon)
>
>
> The INT4 fields are visible as INT, but all other other fields are 
> ignored. (There’s also an “unrecognized user version“.)
> ---
>
> This also affects QGIS, GRASS and FME, cause they use GDAL for opening 
> the data source.
>
> Who's right and who's wrong here? :)
>
> Kind regards,
> Raymond
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
http://www.spatialys.com
My software is free, but my time generally not.