基于SQLite的地图瓦片数据库的设计与实现

Design and Implementation of Tile Database Based on SQLite

提出了一种可行的瓦片数据库生成模式,设计了数据库-层级、数据库-图幅两级瓦片存储规则和编码规则,利用多线程和数据库技术,将地图瓦片批量生成多个SQLite数据库。该方法生成的瓦片数据库方便海量地理数据的管理和调度,既有利于特定分辨率瓦片数据的迁移和备份,也能满足不同地理范围对数据的需求;该流程周期短、投入低,为大范围瓦片数据库的批量生产提供了一定的实践经验。

This paper proposes a feasible generation mode of tile database based on designing the storage rules and encoding rules of tile database. A large number of map tiles were written into muhiple SQLite databases based on muhithread programming and database technology. The generated tile database by this method will advantage the management of geographical data. It benefits the migration and backup of map tiles with special resolution and meets the need of different geographical range. This process provides some practical experience about mass production of tile database with wide area, short period and low cost.