search

felt / tippecanoe

Build vector tilesets from large collections of GeoJSON features.
BSD 2-Clause "Simplified" License
906 stars 78 forks source link

Mbtile tables format not according to spec. #163

Closed bsherman101 closed 10 months ago

bsherman101 commented 10 months ago

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...

1) Copied the Tiles view as a new table named "tiles_temp" 2) Deleted the tiles view 3) renamed the new tiles table back to "tiles" 4) Deleted the map and images tables 5) 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.

bsherman101 commented 10 months ago

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.