Mbtile tables format not according to spec.
bsherman101 opened this issue · 1 comments
Hello,
I am creating multiple mbtiles files with tippecanoe where each file represents contours at different zoom levels.
I was then planning to merge the mbtiles files together with pure sql syntax in sqlite.
I was surprised to find that there was not the single tiles table. Instead there was an additional map and images table and the tiles table was in fact a view.
Can you explain why these tables are here?
In trying to merge the mbtiles together, I did the following...
- Copied the Tiles view as a new table named "tiles_temp"
- Deleted the tiles view
- renamed the new tiles table back to "tiles"
- Deleted the map and images tables
- copied the tiles from all of my mbtiles files into the new tiles table that now allows me to write to it.
In doing all of this, I am finding my new combined mbtiles file does not display any tiles.
I've merged countless mbtiles files together with this same procedure but they have always had the standard tiles and metadata tables only.
Thanks for your help.
I found a description of these tables in the documentation for the Martin tile server. I was able to merge the tables now that I understand how they're used.