Marcel Dopita moneytoo
moneytoo
/ mbtiles_delete_zoom_level.sql
Created
March 30, 2023 09:45
— forked from zhm/mbtiles_delete_zoom_level.sql
Delete zoom levels from an MBTiles file (set max zoom)
This file contains 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'; |
moneytoo
/ regex-weburl.js
Last active
April 15, 2020 07:52
— forked from dperini/regex-weburl.js
This file contains 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 |