Mapnik not rendering streets, route names, city names...

I’m new to rendering with mapnik. I have a August 2008 planet.osm.bz2 file loaded into a postgresql db with postgis installed. I also have the world_boundaries and processed_p files. I set a bbox in generate_tiles.py for the Austin, TX area and ran it. It generates the tiles, but all I see at higher zooms (5-6) is the Texas coastline and at lower zooms (9-11) I see what appear to be county lines. However, that’s all I see. I don’t see highways, smaller streets, names of streets, cities, towns, etc. Just as a sanity check, I opened psql and queried planet_osm_point for known cities, highways, etc. and found rows with those entries.

So, my question is: what am I missing?

Thanks in advance,
Kevin
(aka much confused!)

You might want to ask on the mailing list, I have no idea why that would be and how to debug. You might have the wrong stylesheet?

My stylesheet is the one from the svn repository.

Is there any other info that I can provide that might help diagnose the problem? Or are there any pointers you guys can give on where to look for problems?

As I mentioned, I can login to the postgresql database and query planet_osm_point for any name I want (tried Austin, MoPac [a highway in Austin], some names from the map at http://tile.openstreetmap.nl/~panman/styledit/ …) and get rows back.

I’ve also tried downloading stylesheets from http://tile.openstreetmap.nl/~panman/styledit/ (with layers added) and edited the pathnames & database params for my setup… all with no luck.

– Kevin

Have you created the right osm.xml from osm-template.xml, you could check your osm.xml if the database name is correct.

Yeap, I used set-map-env and customize-mapnik-map to create osm.xml and setup the environment for generate_tiles.py. Here’s a few pics for comparison:

Zoom 5:
What I get:
OSM Tile Server: http://tile.openstreetmap.org/5/7/13.png

Zoom 7:
What I get:
OSM Tile Server: http://tile.openstreetmap.org/7/29/53.png

Zoom 9:
What I get:
OSM Tile Server: http://tile.openstreetmap.org/9/117/210.png

Zoom 11:
What I get:
OSM Tile Server: http://tile.openstreetmap.org/11/470/842.png

– Kevin

Well you are obviously not getting data from the DB aren’t you getting any error messages at all? I still recommend the mailing list, since this problem need good experience with mapnik renderers.

I too guess that it is something related to database. What is good is that you are getting something out, it means that the system is running OK. If you haven’t changed anything in generate_tiles.py then I suggest you to check:

  • What projection option you have used when loading OSM data into PostGIS. If wrong option has been used then the Mapnik queries are hitting to wrong place, no data are found and map remains empty.

  • That the PostGIS connection parameters in osm.xml file suit your database. I guess you must edited those already because you seem to get administrative boundaries out from the database just fine.

    postgis localhost 5432 Test postgis false (select * from uk_line where "power"='line' order by z_order) as power -20037508,-19929239,20037508,19929239

there was a post on the mailinglist where it was stated that incorrect permissions on the Database was the cause of this. (given that it was the same person)