OpenQuake Platform

Post processing MBTiles with MBPipe

Bug #1144649 reported by Ben Wyss on 2013-03-04

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	OpenQuake Platform	Fix Committed	Undecided	Ben Wyss

Bug Description

first note, I don't think you need MBPipe, you just need sqlite3

second note, don't use dump:

echo 'dump' | sqlite3 tilesA.mbtiles | sqlite3 tilesB.mbtiles

go into the db that will be the destination db:
sqlite3 <destination.mbtiles>
then:

PRAGMA journal_mode=PERSIST;
PRAGMA page_size=80000;
PRAGMA synchronous=OFF;
ATTACH DATABASE '<source tileset>' AS source;
REPLACE INTO grid_utfgrid SELECT * FROM source.grid_utfgrid;
REPLACE INTO keymap SELECT * FROM source.keymap;
REPLACE INTO grid_key SELECT * FROM source.grid_key;
REPLACE INTO images SELECT * FROM source.images;
REPLACE INTO map SELECT * FROM source.map;