[OSM-dev] Incomplete Mapnik rendering

Cornelius cornelius.osm at csides.info
Sat Aug 22 18:02:04 BST 2009


Hi,

I've tried to render my own Mapnik tiles. But my tiles are looking
like this:
http://tiles.osmlab.org/14/8531/5447.png
(E. g. there are no streets ...)

I've followed the tutorial on the wiki
(http://wiki.openstreetmap.org/wiki/Mapnik).

I've checked out osm2pgsql and mapnik from svn and called osm2pgsql
like this:
./osm2pgsql -s -m -d gis -U osm -W -H localhost ../data/nordrhein-westfalen.osm.bz2

In /var/log/postgresql/postgresql-8.3-main.log I've found the following:

2009-08-15 11:14:35 CEST ERROR:  function asbinary() does not exist at
character 8
2009-08-15 11:14:35 CEST HINT:  No function matches the given name and
argument types. You might need to add explicit type casts.
2009-08-15 11:14:35 CEST STATEMENT:  select asbinary() as
geom,"highway","name","natural","place","ref" from 
	      (select
way,amenity,highway,leisure,landuse,man_made,"natural",place,tourism,ele,name,ref
	       from planet_osm_point
	       where amenity is not null
	          or leisure is not null
	          or landuse is not null
	          or tourism is not null
	          or "natural" is not null
	          or man_made='lighthouse'
	          or place='island'
	          or highway='motorway_junction'
	      ) as text
	       where  && setSRID('BOX3D(824296.9130273408
6714228.564569879,834080.8526478433
6724012.504190382)'::box3d,-1209139138)


Google founds:
http://www.mail-archive.com/dev@openstreetmap.org/msg08137.html

But I don't understand what I have to do. Why does the function
asbinary() have no parameter?

I hope, someone can helps me ...

Thanks in advance.

Cornelius




More information about the dev mailing list