Fails to load GDAL's raster GPKGs about geopackage-mapcache-android HOT 6 CLOSED

Thanks. It will be more cases than just the pragmas. From a quick test queries that use the table names in the statements as well. I'll go through and try to find all cases when I get the chance. Until then if you can avoid .'s, things should work.

from geopackage-mapcache-android.

Quotation fixes for this project were released as part of:

• geopackage-mapcache-android 1.13
• geopackage-android-map 1.3.1
• geopackage-android 1.3.1
• geopackage-core-java 1.2.1

Also fixed in geopackage-java 1.2.1

from geopackage-mapcache-android.

Poking in the dark I dropped all triggers and all new tables from GDAL's version, still got the same error.

from geopackage-mapcache-android.

It looks like using a . in the name might be creating an invalid sqlite table name "ERDC_Whitehorse_GeoPackage.gdal".

Can you try something like:

gdal_translate -of GPKG ERDC_Whitehorse_GeoPackage.gpkg Whitehorse_gdal.gpkg

from geopackage-mapcache-android.

Ah, that will be it! You need to quote those table names. A point in the name might be silly and misleading but valid. :)

I guess this is the offending line:
https://github.com/ngageoint/geopackage-android/search?utf8=%E2%9C%93&q=table_info

In these too I'd say, did not look further:
https://github.com/ngageoint/geopackage-java/search?utf8=%E2%9C%93&q=table_info
https://github.com/ngageoint/geopackage-core-java/search?utf8=%E2%9C%93&q=table_info

from geopackage-mapcache-android.

The changes are on the develop branch of geopackage-android, geopackage-core-java, and geopackage-java. They will go out with the next release.

from geopackage-mapcache-android.