How do I convert .osm.pbf or .osm.bz2 to .mbtiles via command line

Question

How do I convert .osm.pbf or .osm.bz2 http://download.geofabrik.de/africa-latest.osm.bz2. to Geo .tiff via commandline? I want is end results to convert files to .mbtiles. If I have Geo .tiff I can convert using Gdal to .mbtiles easily. This is the response I got from the guys at geofabrik.de.

 This is not so easy. You will want to have different zoom levels
 generated, so it is better to go osm->mbtiles directly without GDAL and
 GeoTiff. However, osm->mbtiles requires map rendering and style
 information. If it is for a small area, you can probably use Maperitive
 for this (unsure if it has a command line). Otherwise you will need to
 import OSM data into a PostGIS database, and then you can use e.g.
 Tilemill to batch-process

(Credits Frederik Ramm)

Can someone translate this? How do I import OSM data into PostGIS database. Reference: http://wiki.openstreetmap.org/wiki/Osm2pgsql

osm2pgsql -s -U postgres -d nameofdatabase /file/path/toosm/fileorpbf/name.osm

Will this work for .OSM.PBF?

How do I use a Tilemill to do a batch process? What is the commandline arguments?

Answer 1

As Frederick / woodpeck points out this is not easy and contains multiple steps:

rendering OSM geodata to rasterdata
converting map rasterdata to mbtiles

I'm not familar if Tilemill/Mapbox studio can handle both steps. But this platform runs completely online and without any CLI preprocessing.

Usually you pick an desktop renderer as Maperitive (or the full OSM rendering stack) and convert the resulting tiles structure to MBtiles (no idea which tool to use).
Anyway, you should start with an pretty small area! An whole continent doesn't sound like a good idea for usual hardware!

Answer 2

2

The best guide to setting up osm2pgsql etc. is probably the switch2osm guide. You can point TileMill at the database that you set up using those instructions.

permanent link

answered 30 Jul '15, 10:24

SomeoneElse ♦
36.9k●71●370●866
accept rate: 16%

@Someoneelse can you let me know how to point TileMill to this database?

(31 Jul '15, 02:56) Chathu

Mapbox's "use TileMill with a database" instructions are here:

https://www.mapbox.com/tilemill/docs/guides/postgis-work/

But that's probably only needed if you're setting up a TileMill project from scratch. If you're using an existing stylesheet and your database is called "gis" I'd imagine things will "just work" as far as database access is concerned

(03 Aug '15, 17:23) SomeoneElse ♦

Answer 3

You can create MBTiles from any .osm.pbf file using this tool - https://github.com/systemed/tilemaker

Download .osm.pbf file from Geofabric. To download for a custom area, you can use Protomaps or BBBike Extract
Download tilemaker
Execute the following command

tilemaker --input netherlands.osm.pbf --output netherlands.mbtiles --process resources/process-openmaptiles.lua --config resources/config-openmaptiles.json

You can read more about it in this blog post - https://blog.kleunen.nl/blog/tilemaker-generate-map

How do I convert .osm.pbf or .osm.bz2 to .mbtiles via command line

Follow this question

Related questions