Is it possible to combine two vector mbtiles files using just SQLite?
I noticed this question Joining several raster .mbtiles? but it does not seem to work with vector files.
I also came across this script Patch mbtiles which seems to support the idea that it should be possible.
In my use case, I want to be able to merge mbtiles on the client side (in a Cordova app with sqlite) without having to involve any operations on the server.
For testing I have two .mbtiles, one covering Maryland and another covering Pennsylvania. Both contain the same layers and zoom levels.
If I merge the map and images tables as shown in the patch file above and view the resulting map in mapbox gl js, there is over a hundred mile gap between the top of Maryland and where the map features start rendering again. If I attempt to merge in Virgina it doesn't display at all.
What am I missing?