Skip to content

Instantly share code, notes, and snippets.

@jsanz

jsanz/mbtiles_delete_zoom_level.sql

Forked from zhm/mbtiles_delete_zoom_level.sql
Created April 22, 2021 15:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jsanz/65d81e0e2fd27faf79016d1cc89b70e8 to your computer and use it in GitHub Desktop.
Save jsanz/65d81e0e2fd27faf79016d1cc89b70e8 to your computer and use it in GitHub Desktop.
Download ZIP
Delete zoom levels from an MBTiles file (set max zoom)
Raw
mbtiles_delete_zoom_level.sql
-- change 18 to whatever the max zoom level you want in your MBTiles
DELETE FROM images WHERE
tile_id IN (SELECT tile_id FROM map WHERE zoom_level > 18) AND
tile_id NOT IN (SELECT tile_id FROM map WHERE zoom_level <= 18);
DELETE FROM map WHERE zoom_level > 18;
UPDATE metadata SET value = '18' WHERE name = 'maxzoom';
-- now run the VACUUM command
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment