Shulou(Shulou.com)06/01 Report--

This article is to share with you about how to develop a MBTiles Server in GIS development. The editor thinks it is very practical, so I share it with you. I hope you can get something after reading this article.

MBTiles is a database that stores map slices based on SQLite data and stores map slices in the order of zoom level, horizontal and vertical rows. A common Geoserver can load plug-ins and publish MBTiles. There is also an open source MBTiles Server on github, and you can also publish MBTiles. How to do a MBTiles Server development when you only need a slice of the map: first, look at the structure of the MBTiles database, which you can use to view the SQLite database.

Generally, it contains metadata and indicates the zoom level and row number of each slice. The table structure varies according to the scene. However, all of them have slice images that can be checked directly according to the zoom level and row number.

The following figure creates a query for a view:

The SQL content of the view:

SELECT map.zoom_level AS zoom_level,map.tile_column AS tile_column,map.tile_row AS tile_row,images.tile_data AS tile_data FROM map JOIN images ON images.tile_id = map.tile_id in short, they all have the following SQL statement to query map slices: SELECT tile_data FROM tiles WHERE zoom_level =% d AND tile_column =% d AND tile_row =% d common map, direct access to map slices: take Mapbox-gl as an example

According to the above ideas, according to the map request url rules, query the corresponding slices in MBTiles, return, you can access the map slices on the map side. Key codes for springboot-based implementation:

Test results of client access:

The above is how to develop a MBTiles Server in GIS development. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.