Re: [gdal-dev] OGR Spatialite to geopackage

2018-06-13 Thread lucvanlinden
Hi Even, we had indead a similar question before on the all tables etc with views. This howevere is a straight spatialite to geopackge transform equally as Jukka explained. I must say we are on a 2.2.0 still. The listing with tables works (layernames), the straight as in ogr2ogr -f gpkg outp

Re: [gdal-dev] OGR Spatialite to geopackage

2018-06-13 Thread Even Rouault
On mercredi 13 juin 2018 01:36:18 CEST jratike80 wrote: > Even Rouault-2 wrote > > > There isn't a concept of view in the OGR model, so they are presented as > > tables and converted as such. In that case this is a technical Spatialite > > table that makes no sense in GPKG, so you should exclude i

Re: [gdal-dev] OGR Spatialite to geopackage

2018-06-13 Thread jratike80
Even Rouault-2 wrote > There isn't a concept of view in the OGR model, so they are presented as > tables and converted as such. In that case this is a technical Spatialite > table that makes no sense in GPKG, so you should exclude it from the > conversion by explicitly listing the tables/views y

Re: [gdal-dev] OGR Spatialite to geopackage

2018-06-12 Thread Even Rouault
On mardi 12 juin 2018 02:57:56 CEST lucvanlinden wrote: > Hi Jukka > > Error 1: failed to execute insert : unique constraint failed : > geom_cols_ref_sys._rowid_ > > Error 1 : Unable to write feature 0 from layer geom_cols_ref_sys. > > Terminating > > Seems to me that the metadata tables, i

Re: [gdal-dev] OGR Spatialite to geopackage

2018-06-12 Thread luc.vanlinden
Sorry forgot to mention. This gpkg does not exist. GrLuc Van Linden Original message From: br...@frogmouth.net Date: 12/06/2018 12:01 (GMT+01:00) To: 'lucvanlinden' , gdal-dev@lists.osgeo.org Subject: RE: [gdal-dev] OGR Spatialite to geopackage Can you p

Re: [gdal-dev] OGR Spatialite to geopackage

2018-06-12 Thread luc.vanlinden
ogr2ogr -f gpkg output.gpkg input.sqlite GrLuc Van Linden Original message From: br...@frogmouth.net Date: 12/06/2018 12:01 (GMT+01:00) To: 'lucvanlinden' , gdal-dev@lists.osgeo.org Subject: RE: [gdal-dev] OGR Spatialite to geopackage Can you please show

Re: [gdal-dev] OGR Spatialite to geopackage

2018-06-12 Thread bradh
Can you please show the exact command you are using, and tell us whether the geopackage you are using already exists (i.e. this is an append, not a create)? Brad ___ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listin

Re: [gdal-dev] OGR Spatialite to geopackage

2018-06-12 Thread lucvanlinden
Hi Jukka Error 1: failed to execute insert : unique constraint failed : geom_cols_ref_sys._rowid_ Error 1 : Unable to write feature 0 from layer geom_cols_ref_sys. Terminating Seems to me that the metadata tables, in this case it is even a view is treated as a normal layer. Tx Luc --

Re: [gdal-dev] OGR Spatialite to geopackage

2018-06-11 Thread jratike80
lucvanlinden wrote > Hi > We are using ogr 2.2.0 and were trying to turn a spatialite (non fdo) into > a geopacke file. > The spatialite file has all the metadata tables and view in it. > Should we explicitly pass the layername list (tablenames) for a clean > transform? > We are getting errors on r

[gdal-dev] OGR Spatialite to geopackage

2018-06-11 Thread luc.vanlinden
Hi We are using ogr 2.2.0 and were trying to turn a spatialite (non fdo) into a geopacke file. The spatialite file has all the metadata tables and view in it. Should we explicitly pass the layername list (tablenames) for a clean transform? We are getting errors on records no being able to ge