Joining several raster .mbtiles?

Question

I have several .mbtiles with no (or little) overlapping areas and I would like to merge them into one file in order to be able to serve them more easily.

I'm looking for a command line tool that can do this.

tile-join seems to work only on vector tiles. When I run to on my raster tiles it crashes:

tile-join first.mbtiles second .mbtiles -o combined.mbtiles
libc++abi.dylib: libc++abi.dylib: libc++abi.dylib: libc++abi.dylib: libc++abi.dylib: terminating with uncaught exception of type protozero::unknown_pbf_wire_type_exception: unknown pbf field type exceptionterminating with uncaught exception of type protozero::unknown_pbf_wire_type_exception: unknown pbf field type exceptionterminating with uncaught exception of type protozero::unknown_pbf_wire_type_exception: unknown pbf field type exceptionlibc++abi.dylib: terminating with uncaught exception of type protozero::unknown_pbf_wire_type_exception: unknown pbf field type exceptionlibc++abi.dylib: terminating with uncaught exception of type protozero::unknown_pbf_wire_type_exception: unknown pbf field type exception
Abort trap: 6

gdal_merge.py works on .tiff files but I have .mbtiles as input.

Update:

I managed to convert the .mbtiles to .tiff using

gdal_translate input.mbtiles output.tiff
gdal_translate input2.mbtiles output2.tiff

Then merge them using

gdal_merge.py -co COMPRESS=LZW  *.tiff

This gives me one out.tiff but then how to get a .mbtiles back? goal_translate gives me this error:

gdal_translate -of mbtiles out.tif  out.mbtiles
Input file size is 81920, 81920
0ERROR 6: GDALDriver::Create() ... no create method implemented for this format.

any ideas?

Answer 1

You can use SQLITE 3 command line tool or OGRINFO SQLITE Functions you need to connect to first database and then attach second database and insert into tiles * from others.tiles

Make sure you vacuum database and Re index tables

https://sqlite.org/cli.html https://www.sqlite.org/lang_attach.html

Do it from command line or from a SQLITE EDITOR DBBROWSER is free

Answer 2

Extending GeospatialInformationTech's answer, the mbutil patch tool from https://github.com/mapbox/mbutil/blob/d495c0a737f4bce5fde8e707fe267674be39369a/patch can merge raster mbtiles where there are no overlapping tiles.