This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- change 9 to whatever the max zoom level you want in your MBTiles | |
DELETE FROM tiles_data WHERE | |
tile_data_id IN (SELECT tile_data_id FROM tiles_shallow WHERE zoom_level > 9) AND | |
tile_data_id NOT IN (SELECT tile_data_id FROM tiles_shallow WHERE zoom_level <= 9); | |
DELETE FROM tiles_shallow WHERE zoom_level > 9; | |
UPDATE metadata SET value = '9' WHERE name = 'maxzoom'; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// | |
// Regular Expression for URL validation | |
// | |
// Author: Diego Perini | |
// Updated: 2010/12/05 | |
// License: MIT | |
// | |
// Copyright (c) 2010-2013 Diego Perini (http://www.iport.it) | |
// | |
// Permission is hereby granted, free of charge, to any person |