Re: [gdal-dev] Corrupted geopackage

2022-02-16 Thread Jonathan Moules
Hi Isabel, If you don't get an answer here, you may want to try the SQLite forum: https://sqlite.org/forum/forum - If anyone knows, it'll be someone there. Maybe also of interest: https://sqlite.org/howtocorrupt.html#cfgerr Cheers, Jonathan On 2022-02-14 08:17, Isabel Kiefer wrote: Hi ever

Re: [gdal-dev] Corrupted geopackage

2022-02-14 Thread Mark Johnson via gdal-dev
On Mon, 14 Feb 2022, 14:11 Mark Johnson, wrote: > You should try rebuild the SpatialIndex. > > Spatialite offers gpkgAddSpatialIndex for a new Index. > > For its own format there are repair functions. > >SQL functions reference list >- spatialite-sql-latest.html > - will always lead to the relea

Re: [gdal-dev] Corrupted geopackage

2022-02-14 Thread Mark Johnson via gdal-dev
You should try rebuild the SpatialIndex. Spatialite offers gpkgAddSpatialIndex for a new Index. For its own format there are repair functions. ___ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] Corrupted geopackage

2022-02-14 Thread Isabel Kiefer
d. > > > > -Jukka- > > > > *Lähettäjä:* Isabel Kiefer > *Lähetetty:* maanantai 14. helmikuuta 2022 13.08 > *Vastaanottaja:* Rahkonen Jukka (MML) > > ; gdal-dev@lists.osgeo.org > *Aihe:* Re: [gdal-dev] Corrupted geopackage > > > > Hi Jukka, > > &

Re: [gdal-dev] Corrupted geopackage

2022-02-14 Thread Even Rouault
a (MML) ; gdal-dev@lists.osgeo.org *Aihe:* Re: [gdal-dev] Corrupted geopackage Hi Jukka, Yes, exactly, there are only 78 entries in a dump to text file. In the original .gpkg-file, the rtree_XX_geom table is completely empty (no columns, no entries) - this must be where the problem comes fro

Re: [gdal-dev] Corrupted geopackage

2022-02-14 Thread Rahkonen Jukka (MML)
. -Jukka- Lähettäjä: Isabel Kiefer Lähetetty: maanantai 14. helmikuuta 2022 13.08 Vastaanottaja: Rahkonen Jukka (MML) ; gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] Corrupted geopackage Hi Jukka, Yes, exactly, there are only 78 entries in a dump to text file. In the original .gpkg-file, the

Re: [gdal-dev] Corrupted geopackage

2022-02-14 Thread Isabel Kiefer
aanantai 14. helmikuuta 2022 12.53 > *Vastaanottaja:* Rahkonen Jukka (MML) > > *Kopio:* gdal-dev@lists.osgeo.org > *Aihe:* Re: [gdal-dev] Corrupted geopackage > > > > Thanks for your suggestion, Jukka! I tried all the advice from > stackoverflow. I can do ".recover&

Re: [gdal-dev] Corrupted geopackage

2022-02-14 Thread Rahkonen Jukka (MML)
@lists.osgeo.org Aihe: Re: [gdal-dev] Corrupted geopackage Thanks for your suggestion, Jukka! I tried all the advice from stackoverflow. I can do ".recover", but get only the features that have been visible all along. In the original .gpkg, I cannot DROP the affected RTree-Index. It gives me the

Re: [gdal-dev] Corrupted geopackage

2022-02-14 Thread Isabel Kiefer
ev *Puolesta *Isabel > Kiefer > *Lähetetty:* maanantai 14. helmikuuta 2022 10.17 > *Vastaanottaja:* gdal-dev@lists.osgeo.org > *Aihe:* [gdal-dev] Corrupted geopackage > > > > Hi everyone, > > > > I've a problem with a corrupted geopackage. > > It s

Re: [gdal-dev] Corrupted geopackage

2022-02-14 Thread Rahkonen Jukka (MML)
dropping it and repeating the suggested tricks. -Jukka Rahkonen- Lähettäjä: gdal-dev Puolesta Isabel Kiefer Lähetetty: maanantai 14. helmikuuta 2022 10.17 Vastaanottaja: gdal-dev@lists.osgeo.org Aihe: [gdal-dev] Corrupted geopackage Hi everyone, I've a problem with a corrupted geopackag

[gdal-dev] Corrupted geopackage

2022-02-14 Thread Isabel Kiefer
Hi everyone, I've a problem with a corrupted geopackage. It should contain a table with 694 entries, but only 78 are visible when opening the file with DB Browser for SQLite or QGIS. The table gpkg_ogr_contents says 694 though. When opening the .gpkg with a Notepad or similar, I can see that there