[gdal-dev] GeoPackage vector driver fails if layer name contains chars not compatible with SQLite

Stefan Keller sfkeller at gmail.com
Wed May 20 05:41:23 PDT 2015


Salut Even

Thanks and sorry me again.
We tried to compile GDAL 2.0.0beta1 version and still have problems.
Perhaps our config params are wrong?
- --with-pcraster=no
- --with-jasper=no
- --with-grib=no
- --with-vfk=no
- --with-hide-internal-symbols
- --with-xerces

-Stefan


$ ogr2ogr --version
GDAL 2.0.0beta1, released 2015/05/04

$ ogr2ogr -f 'GPKG' out.gpkg WFS:http://maps.zh.ch/wfs/TbaBaustellenZHWF
S
ERROR 1: failed to execute insert : NOT NULL constraint failed:
baustellen-detailansicht.weiteregemeinden
ERROR 1: Unable to write feature 518 from layer baustellen-detailansicht .
ERROR 1: Terminating translation prematurely after failed translation
of layer baustellen-detailansicht (use -skipfailures to skip errors)

2015-05-20 11:21 GMT+02:00 Even Rouault <even.rouault at spatialys.com>:
> Le mercredi 20 mai 2015 11:13:53, Stefan Keller a écrit :
>> Hi Even
>>
>> Just another small issue: GPKG can't handle pre-existing fid column name:
>> >ogr2ogr -f "GPKG" outfile2.gpkg infile.geojson -nln layer_a
>>
>> ERROR 1: sqlite3_exec(ALTER TABLE layer_a ADD COLUMN fid INTEGER) failed:
>> duplic ate column name: fid
>
> Stefan,
>
> you should really try GDAL 2.0.0beta1. Has been fixed there too.
>
> Admitedly burried in  http://svn.osgeo.org/gdal/trunk/gdal/NEWS:
> """
> Cross driver changes:
>  * SQLite, GPKG, PG, PGDump: in a newly created table, allow to create a
> integer field with same name of FID column (#5845)
> """
>
> Even
>
>
>>
>> --S.
>>
>> 2015-05-18 18:50 GMT+02:00 Stefan Keller <sfkeller at gmail.com>:
>> > Salut Even
>> >
>> > 2015-05-18 17:40 GMT+02:00 Even Rouault <even.rouault at spatialys.com> a
> écrit :
>> >> Le lundi 18 mai 2015 17:25:18, Stefan Keller a écrit :
>> >>> Hi,
>> >>>
>> >>> GeoPackage vector driver seems to fail if layer name contains chars
>> >>> not compatible with SQLite (like dashes, '-').
>> >>
>> >> Stefan,
>> >>
>> >> This has been fixed in GDAL 2.0dev.
>> >
>> > Merveilleux! Merci!!
>> >
>> > -S.
>> >
>> > 2015-05-18 17:40 GMT+02:00 Even Rouault <even.rouault at spatialys.com>:
>> >> Le lundi 18 mai 2015 17:25:18, Stefan Keller a écrit :
>> >>> Hi,
>> >>>
>> >>> GeoPackage vector driver seems to fail if layer name contains chars
>> >>> not compatible with SQLite (like dashes, '-').
>> >>
>> >> Stefan,
>> >>
>> >> This has been fixed in GDAL 2.0dev.
>> >>
>> >> Even
>> >>
>> >> --
>> >> Spatialys - Geospatial professional services
>> >> http://www.spatialys.com
>
> --
> Spatialys - Geospatial professional services
> http://www.spatialys.com


More information about the gdal-dev mailing list