MBTiles

Stella981
• 阅读 663

MBTiles Specification

MBTiles is a specification for storing tiled map data in SQLite databases for immediate usage and for transfer. MBTiles files, known as tilesets, must implement the specification below to ensure compatibility with devices.

UTFGrid

The MBTiles specification previously contained the UTFGrid specification. It was removed in version 1.2 and moved into its own specification with synced version numbers - so MBTiles 1.2 is compatible with UTFGrid 1.2. The specs integrate but do not require each other for compliance.

Versions

  • Development - NOT USABLE: 1.2
  • Stable1.1
  • 1.0

Changelog

Roadmap

  • The format will switch tile ordering to the XYZ schema popularized by OpenStreetMap and away from the Tile Map Service specification.

1.1

  • name='format' row required in metadata table.
  • name='bounds' row suggested in metadata table.
  • optional UTFGrid-based interaction spec.

Concept

MBTiles is a compact, restrictive specification. It supports only tiled data, including image tiles and interactivity grid tiles. Only the Spherical Mercator projection is supported for presentation - tile display - and only latitude-longitude coordinates are supported for metadata such as bounds and centers.

It is a minimum specification - only specifying the ways in which data must be retrievable. Thus MBTiles files can internally compress and optimize data, and construct views that adhere to the MBTiles specification.

Unlike Spatialite, GeoJSON, and Rasterlite, MBTiles is not raw data storage - it is storage for presentational data, like rendered map tiles.

One MBTiles file represents a single tileset, optionally including grids of interactivity data. Multiple tilesets - layers, or maps in other terms, can be represented by multiple MBTiles files.

Implementations.

License

The text of this specification is licensed under a Creative Commons Attribution 3.0 United States License. However, the use of this spec in products and code is entirely free: there are no royalties, restrictions, or requirements.

Authors

  • Tom MacWright (tmcw)
  • Will White (willwhite)
  • Konstantin Kaefer (kkaefer)
  • Justin Miller (incanus)

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

MBTiles 1.2

Sub-sections:

  • Interaction: HTTP endpoints needed for implementing interactivity
  • UTFGrid: This specification relies on UTFGrid 1.2 for interactivity.

Abstract

MBTiles is a specification for storing tiled map data in SQLite databases for immediate usage and for transfer. MBTiles files, known as tilesets, must implement the specification below to ensure compatibility with devices.

Database Specifications

Tilesets are expected to be valid SQLite databases of version 3.0.0 or higher. Only core SQLite features are permitted; tilesetscannot require extensions.

MBTiles databases can optionally use the officially assigned magic number to be easily identified as MBTiles.

Database

Note: the schemas outlined are meant to be followed as interfaces. SQLite views that produce compatible results are equally valid. For convenience, this specification refers to tables and virtual tables (views) as tables.

Metadata

Schema

The database is required to contain a table or view named metadata.

This table must yield exactly two columns named name and value. A typical create statement for the metadata table:

CREATE TABLE metadata (name text, value text);

Content

The metadata table is used as a key/value store for settings. Five keys are required:

  • name: The plain-english name of the tileset.
  • typeoverlay or baselayer
  • version: The version of the tileset, as a plain number.
  • description: A description of the layer as plain text.
  • format: The image file format of the tile data: png or jpg

One row in metadata is suggested and, if provided, may enhance performance.

  • bounds: The maximum extent of the rendered map area. Bounds must define an area covered by all zoom levels. The bounds are represented in WGS:84 - latitude and longitude values, in the OpenLayers Bounds format - left, bottom, right, top. Example of the full earth: -180.0,-85,180,85.
  • attribution: An attribution string, which explains in English (and HTML) the sources of data and/or style for the map.

Several additional keys are supported for tilesets that implement UTFGrid-based interaction.

Tiles

Schema

The database is required to contain a table named tiles.

The table must yield four columns named zoom_leveltile_columntile_row, and tile_data. A typical create statement for the tiles table:

CREATE TABLE tiles (zoom_level integer, tile_column integer, tile_row integer, tile_data blob);

Content

The tiles table contains tiles and the values used to locate them. The zoom_leveltile_column, and tile_row columns follow the Tile Map Service Specification in their construction, but in a restricted form:

The global-mercator (aka Spherical Mercator) profile is assumed

The tile_data blob column contains raw image data in binary.

A subset of image file formats are permitted:

  • png
  • jpg

Grids

See the UTFGrid specification for implementation details of grids and interaction metadata itself: the MBTiles specification is only concerned with storage.

Schema

The database can have optional tables named gridsgrid_data.

The grids table must yield four columns named zoom_leveltile_columntile_row, and grid. A typical create statement for the grids table:

CREATE TABLE grids (zoom_level integer, tile_column integer, tile_row integer, grid blob);

The grid_data table must yield five columns named zoom_leveltile_columntile_rowkey_name, and key_json. A typical create statement for the grid_data table:

CREATE TABLE grid_data (zoom_level integer, tile_column integer, tile_row integer, key_name text, key_json text);

Content

The grids table contains UTFGrid data, gzip compressed.

The grid_data table contains grid key to value mappings, with values encoded as JSON objects.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Implementations

Brendan Ward edited this page on Sep 8 · 65 revisions

Pages 1 * **[Implementations](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fmapbox%2Fmbtiles-spec%2Fwiki%2FImplementations)** Clone this wiki locally [Clone in Desktop](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fwindows.github.com%2F) #### 1.1 Compliant * [Mapbox](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Fmapbox.com%2F) * [TileStream](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Fgithub.com%2Fmapbox%2Ftilestream) * [Mapbox iOS SDK](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fmapbox%2Fmapbox-ios-sdk) ([example](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fmapbox%2Fmapbox-ios-example)) * [GDAL](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Fwww.gdal.org%2Ffrmt_mbtiles.html) * node.js: [mbtiles-generator](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fmapsquare%2Fmbtiles-generator) * python: [rio-mbtiles](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fmapbox%2Frio-mbtiles) (write) * python: [mbutil](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fmapbox%2Fmbutil) (read/write) * python: [landez](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fmakinacorpus%2Flandez) (read/write) (uses mbutil) * python: [TileStache](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Ftilestache.org%2F) ([code](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fmigurski%2FTileStache%2Fblob%2Fmaster%2FTileStache%2FMBTiles.py)) (read/write) - a full, high-quality tile server * python: [python-mbtiles](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fperrygeo%2Fpython-mbtiles) * python: [TileCloud](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Ftwpayne%2Ftilecloud) * python: [servembtiles](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fmonkut%2Fservembtiles) a pure python3 wsgi application for serving MBTiles. * python: [gdal2mbtiles](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fecometrica%2Fgdal2mbtiles) - convert GDAL-readable datasets into an MBTiles file (write) * python: [tpkutils](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fconsbio%2Ftpkutils) (write) - convert ArcGIS tile packages into MBtiles 1.1. * proprietary: [Arc2Earth](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Fwww.arc2earth.com%2F) (write) * python: [mapproxy](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Fmapproxy.org%2F) ([announcement](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Fmapproxy.org%2Fblog%2Fnew-mapproxy-1.2.0-release%2F)) (read/write) * proprietary: [maperitive](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Fmaperitive.net%2F) (write) * PHP: [mbtiles-generator](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2FHTML24%2Fmbtiles-generator) (read/write) * python [mbtiles2s3](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2FMinnPost%2Fmbtiles2s3) * objc: [osm2mbtiles](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Frpcarver%2Fosm2mbtiles) * C++: [tilemaker](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fsystemed%2Ftilemaker) (write vector tiles) #### Others * ruby: [silent\_cartographer](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fjwhitehorn%2Fsilent_cartographer) * python/Django: [django-mbtiles](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fmakinacorpus%2Fdjango-mbtiles%2F) * objc: [MapDBImporter](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fmapbox%2FMapDBImporter) (write) * java/android: [MBTilesDroidSpitter](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fdjcoin%2FMBTilesDroidSpitter) ([example](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fdjcoin%2FMBTilesDroidSpitterExampleSimple)) (read) * objc/iPhone: [Maptual](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Fmaptual.com%2F) (read) * java/Android: [Locus](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Flocus.asamm.cz%2F) (read) * java/Android: [MapIt](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Fmapit-gis.com%2F) (read) * Windows compatible viewer: [MBTilesViewer](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Fviswaug.wordpress.com%2F2011%2F06%2F28%2Fmbtilesviewer%2F) (read) * java/Android: [Nutiteq SDK](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Fwww.nutiteq.com%2Fandroid-mapping-api-sdk) * Python: [MBTiles-Extractor](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fpbarry%2FMBTiles-extractor) * Java/Processing: [Unfolding](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Funfoldingmaps.org%2F) (read) ([example](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Ftillnagel%2Funfolding%2Fblob%2Fmaster%2Fexamples%2Fde%2Ffhpotsdam%2Funfolding%2Fexamples%2FMBTilesMapApp.java)) * PHP: [tileserver-php](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fklokantech%2Ftileserver-php) * PHP: [MBTiles-PHP](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Finfostreams%2Fmbtiles-php) * PHP: [PHP-MBTiles-Server](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fbmcbride%2FPHP-MBTiles-Server) * PHP: [TilePhlox](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2FJohn5%2FTilePhlox) * ASP.NET: [tilecannon](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fsainsb%2Ftilecannon) * Python: [MBTiles-extractor](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fpbarry%2FMBTiles-extractor) * C++: [Example C++ mbtiler](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fmapbox%2Fmbtiler) ### Applications * js: [TileMill](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Fdevelopmentseed.github.com%2FTileMill%2F) (write) * [TileMill OS X](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fmapbox%2Ftilemill%2Fdownloads) QuickLook & Spotlight plugins (read) * [Portable Basemap Server](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgeopbs.codeplex.com%2F) An easy to use WPF application and has implemented map tile part of Esri’s “GeoServices REST Specification” and OGC WMTS specification (read/write) * C++: [osgEarth](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Fosgearth.org%2F) (read) * iOS/Android/Web: [Fulcrum- mobile field data collection](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Fwww.fulcrumapp.com%2F) (read) * C: [Viking](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fsourceforge.net%2Fprojects%2Fviking%2F) GPS Desktop application. Linux + Windows (read) * python: [QTiles](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fgithub.com%2Fnextgis%2FQTiles) QGIS plugin (write) * Windows: [TilingTools](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Fgeomixer.ru%2Findex.php%2Fru%2Fdocs%2Fmanual%2Ftilingtools) - raster to tiles (read/write) ### Websites * [MapTiler](https://www.oschina.net/action/GoToLink?url=http%3A%2F%2Fwww.maptiler.com%2F)
点赞
收藏
评论区
推荐文章
blmius blmius
3年前
MySQL:[Err] 1292 - Incorrect datetime value: ‘0000-00-00 00:00:00‘ for column ‘CREATE_TIME‘ at row 1
文章目录问题用navicat导入数据时,报错:原因这是因为当前的MySQL不支持datetime为0的情况。解决修改sql\mode:sql\mode:SQLMode定义了MySQL应支持的SQL语法、数据校验等,这样可以更容易地在不同的环境中使用MySQL。全局s
Easter79 Easter79
3年前
swap空间的增减方法
(1)增大swap空间去激活swap交换区:swapoff v /dev/vg00/lvswap扩展交换lv:lvextend L 10G /dev/vg00/lvswap重新生成swap交换区:mkswap /dev/vg00/lvswap激活新生成的交换区:swapon v /dev/vg00/lvswap
皕杰报表之UUID
​在我们用皕杰报表工具设计填报报表时,如何在新增行里自动增加id呢?能新增整数排序id吗?目前可以在新增行里自动增加id,但只能用uuid函数增加UUID编码,不能新增整数排序id。uuid函数说明:获取一个UUID,可以在填报表中用来创建数据ID语法:uuid()或uuid(sep)参数说明:sep布尔值,生成的uuid中是否包含分隔符'',缺省为
待兔 待兔
5个月前
手写Java HashMap源码
HashMap的使用教程HashMap的使用教程HashMap的使用教程HashMap的使用教程HashMap的使用教程22
Jacquelyn38 Jacquelyn38
3年前
2020年前端实用代码段,为你的工作保驾护航
有空的时候,自己总结了几个代码段,在开发中也经常使用,谢谢。1、使用解构获取json数据let jsonData  id: 1,status: "OK",data: 'a', 'b';let  id, status, data: number   jsonData;console.log(id, status, number )
Wesley13 Wesley13
3年前
Java获得今日零时零分零秒的时间(Date型)
publicDatezeroTime()throwsParseException{    DatetimenewDate();    SimpleDateFormatsimpnewSimpleDateFormat("yyyyMMdd00:00:00");    SimpleDateFormatsimp2newS
Wesley13 Wesley13
3年前
mysql设置时区
mysql设置时区mysql\_query("SETtime\_zone'8:00'")ordie('时区设置失败,请联系管理员!');中国在东8区所以加8方法二:selectcount(user\_id)asdevice,CONVERT\_TZ(FROM\_UNIXTIME(reg\_time),'08:00','0
Wesley13 Wesley13
3年前
00:Java简单了解
浅谈Java之概述Java是SUN(StanfordUniversityNetwork),斯坦福大学网络公司)1995年推出的一门高级编程语言。Java是一种面向Internet的编程语言。随着Java技术在web方面的不断成熟,已经成为Web应用程序的首选开发语言。Java是简单易学,完全面向对象,安全可靠,与平台无关的编程语言。
Stella981 Stella981
3年前
Django中Admin中的一些参数配置
设置在列表中显示的字段,id为django模型默认的主键list_display('id','name','sex','profession','email','qq','phone','status','create_time')设置在列表可编辑字段list_editable
Wesley13 Wesley13
3年前
MySQL部分从库上面因为大量的临时表tmp_table造成慢查询
背景描述Time:20190124T00:08:14.70572408:00User@Host:@Id:Schema:sentrymetaLast_errno:0Killed:0Query_time:0.315758Lock_
Python进阶者 Python进阶者
11个月前
Excel中这日期老是出来00:00:00,怎么用Pandas把这个去除
大家好,我是皮皮。一、前言前几天在Python白银交流群【上海新年人】问了一个Pandas数据筛选的问题。问题如下:这日期老是出来00:00:00,怎么把这个去除。二、实现过程后来【论草莓如何成为冻干莓】给了一个思路和代码如下:pd.toexcel之前把这