[gdal-dev] Geopackage ogr2ogr append question

Neumann, Andreas a.neumann at carto.net
Fri Mar 3 06:16:46 PST 2017


Hi, 

I am, for the first time trying to append additional tables with ogr2ogr
to an existing Geopackage file and have questions: 

ogr2ogr -progress -lco SPATIAL_INDEX=YES -f GPKG av_1700_lv03.gpkg
PG:'dbname=publikation host=localhost schemas=av_1700' -sql "SELECT
t_id, t_ili_tid, geom_03, bfs_nr, gemeinde, bodenbedeckungsart,
bodenbedeckungs_flaeche, gebaeudenummer, gwr_egid, objekt_name FROM
av_1700.bb_bodenbedeckung" 

ogr2ogr -progress -append -f GPKG av_1700_lv03.gpkg
PG:'dbname=publikation host=localhost schemas=av_1700' -sql "SELECT
t_id, t_ili_tid, geom_03, bfs_nr, gemeinde, linienart, bobeart_links,
bobeart_rechts FROM av_1700.bb_bodenbedeckung_kanten" 

----------------- 

First question: 

is the -append option enough or do I also need the -update option? 

----------------- 

Second question: 

I get warnings: 

Warning 1: Layer sql_statement relies on the 'gpkg_geom_COMPOUNDCURVE'
(GeoPackage 1.0 Specification Annex J) extension that should be
implemented for safe write-support, but is not currently. Update of that
layer are strongly discouraged to avoid corruption.
Warning 1: Layer sql_statement relies on the 'gpkg_geom_CURVEPOLYGON'
(GeoPackage 1.0 Specification Annex J) extension that should be
implemented for safe write-support, but is not currently. Update of that
layer are strongly discouraged to avoid corruption. 

Can I safely ignore these messages? Or is there a creation option for
the first table that enables this extension? 

Thanks a lot for your help! 

Andreas

  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20170303/42622cd6/attachment.html>


More information about the gdal-dev mailing list