Creating maptiles with german style offline using mapnik and Ubuntu 12.04 LTS

Posted by skaiwalker on 28 December 2012 in English (English)

Please note

This post is obsolete and uses rather dirty methods. I added a quickstart guide to the README file in the mapnik-german repository, which should be used. However, this post might still be valuable for troubleshooting.

First, try to make Mapnik run using this guide:

In case things don’t work, you might find clues there:

In any case, you want to use the latest available sofware, but you do not need to compile from source. There are PPAs.

Install necessary software

#### Mapnik Uninstall any python-mapnik or python-mapnik2 packages from your system (

    sudo add-apt-repository ppa:mapnik/v2.1.0
    sudo apt-get update
    sudo apt-get install libmapnik mapnik-utils python-mapnik #[!sic]


    sudo add-apt-repository ppa:kakrueger/openstreetmap
    sudo apt-get update
    sudo apt-get install osm2pgsql


    sudo apt-get install postgis postgresql postgresql-9.1-postgis

Set-up data base

    sudo -u postgres createdb -E UTF8 -O postgres osm
    sudo -u postgres createlang plpgsql osm
    sudo -u postgres psql osm < /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql
    sudo -u postgres psql osm < /usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql

Create user with YOUR name (somehow only works like this) postgis superuser? yes

    sudo -u postgres createuser -P YOURUSERNAME

Now, get a map file. These are available at e.g.

    unp sachsen.osm.bz2

Finally, import your image into the database

    osm2pgsql -m -d osm -S /usr/share/osm2pgsql/ -W  sachsen.osm

In case of the german scripts, you either need to edit a little or work with the views. The views seem to be necessary when still working with the default OSM style.

    node,way	3dshapes:ggmodelk	text	delete
    node,way	AND_nosr_r	text	delete
    node,way	b5m:*	text	delete
    node,way	bak:*	text	delete
    node,way	canvec:*	text	delete
    node,way	created_by	text	delete
    node,way	dcgis:*	text	delete
    node,way	FIXME	text	delete
    node,way	geobase:*	text	delete
    node,way	gnis:*	text	delete
    node,way	kms:*	text	delete
    node,way	KSJ2:*	text	delete
    node,way	massgis:*	text	delete
    node,way	mvdgis:*	text	delete
    node,way	naptan:*	text	delete
    node,way	ngbe:*	text	delete
    node,way	nhd:*	text	delete
    node,way	NHD:*	text	delete
    node,way	note	text	delete
    node,way	note:*	text	delete
    node,way	notes	text	delete
    node,way	osak:*	text	delete
    node,way	source	text	delete
    node,way	source:*	text	delete
    node,way	sourcedb:*	text	delete
    node,way	tiger:*	text	delete
    node,way	WroclawGIS:*	text	delete
    node,way	yh:*	text	delete
    node,way	rednap:* text	delete
    node,way	ideewfs:* text	delete
    node,way	ign:* text	delete

    node,way   aerialway    text         linear
    node,way   addr:housenumber text     linear
    node,way   aeroway      text         polygon
    node,way   amenity      text         nocache,polygon
    node,way   barrier      text         linear
    node,way   boundary     text         linear
    node,way   building     text         polygon
    node,way   highway      text         linear
    node,way   historic     text         polygon
    node,way   landuse      text         polygon
    node,way   leisure      text         polygon
    node,way   lock         text         linear
    node,way   man_made     text         polygon
    node,way   military     text         polygon
    node,way   place        text         polygon
    node,way   power        text         polygon
    node,way   railway      text         linear
    node,way   route        text         linear
    node,way   shop         text         polygon
    node,way   tourism      text         polygon
    node,way   waterway     text         polygon
    node,way   natural      text         polygon

    node,way   width        real         linear
    node       ele          real         linear

    node,way   z_order      int4         linear # This is calculated during import
    way        way_area     real                # This is calculated during import

    # Needed additions for german style to work
    node,way   wood     text         polygon
    node,way   name:de        text         linear
    node,way   name        text         linear
    node,way   religion        text         linear
    node,way   tunnel        text         linear
    node,way   disused        text         linear
    node,way   bridge        text         linear
    node,way   horse      text         linear
    node,way   foot      text         linear
    node,way   bicycle      text         linear
    node,way   tracktype      text         linear
    node,way   construction      text         linear
    node,way   proposed      text         linear
    node,way   service      text         linear
    node,way   access      text         linear
    node,way   oneway      text         linear
    node,way   layer      text         linear
    node,way   ref     text         linear
    node,way   lcn_ref     text         linear
    node,way   admin_level    text         linear
    node   capital    text         linear
    node,way   generator:source    text         linear
    node,way   power_source    text         linear
    node,way   ruins    text         linear
    node,way   addr:flats   text         polygon
    node,way   addr:interpolation  text  linear
    node,way   addr:housename  text  linear

    node,way   rcn_ref     text     linear
    node,way   ncn_ref     text     linear
    way       lcn          text     linear
    way       rcn          text     linear
    way       ncn          text     linear
    #way       lwn_ref      text     linear
    #way       rwn_ref      text     linear
    #way       nwn_ref      text     linear
    way       lwn              text     linear
    way       rwn              text     linear
    way       nwn              text     linear
    #way       route_pref_color text     linear
    way       route_name       text     linear
    way       network          text     linear
    way       surface          text     linear
    way       voltage          text     linear
    way       line             text     linear
    node      public_transport text     linear
    node      information      text     linear
    node      bus              text     linear
    node      tram             text     linear
    node      hiking           text     linear

Rendering tiles

#### Getting style files Standard OSM:

    svn checkout

German OSM style:

    svn checkout

Follow the README files in there until you get to

     ./ --dbname osm --host 'localhost' --user YOURUSERNAME --port 5432 --password 'YOURPWD'  osm-de.xml > osm-local.xml 

If there are no errors, you may edit the (make sure it uses the right osm-local.xml) and run it



#### hstore in postgis In some cases you want to use the –hstore option (-k) to store additional info (see osm2pgsql -h).

    osm2pgsql -m -k -d osm -S /usr/share/osm2pgsql/ -W  sachsen.osm

In that case, postgis needs to know that.

    sudo -u postgres psql

world boundaries

Get the missing ones from


flooded cities

If you see a lot of water in the rendered images, then you downloaded the wrong (WGS84) projection of the land-polygons.
Use the Mercator projection

Errors with unifont Medium - comment out offending lines from

    <Font face-name="unifont Medium" />

Comment from skaiwalker on 28 December 2012 at 01:15

It’s worth noting that I created a separate folder for the german style files and first copied the original OSM mapnik style files and ontop the mapnik-german style files.

    cp -R mapnik
    cp -R mapnik-german/* mapnik-de/
    # remove subversion files
    find  ./mapnik-de/ -type d -iname ".svn" -exec rm -r -f {} \;

Comment from z-dude on 30 December 2012 at 14:53

Sometimes a flooded city, is an actual flooded city.

Login to leave a comment