[OSM-dev] How to get mapnik generate a map with roads and stuff

[Jon Burgess]

On Tue, 2008-01-29 at 23:08 +0100, John Wheeler wrote:
> Hi,
> 
> I am trying to create my own tileserver to learn the tasks involved
> setting up a slippy map. So I managed to get osm2pgsl compiled and
> filled the postgresql gis database. Then I succeeded in getting mapnik
> generate some tiles for me! So far, so good. However, I used
> planet-latest.osm.bz2 and world_boundaries.tar.bz2, but the tiles
> generated and showing up in my browser show no roads and no cities at
> all. To generate the map I used the steps on the wiki.
> 
> $ source ./set-mapnik-env
> $ ./customize-mapnik-map >$MAPNIK_MAP_FILE
> $ ./generate_tiles.py
> 
> Can anyone point me the way how to fix this?
> 
It sounds like you are failing to fetch any data from the database, this
could be for any number of reasons...

- Verify you've got data in the Postgresql tables (if it took a few
hours to import then you probably do), e.g.

gis=> select osm_id,astext(way) from planet_osm_point where amenity='pub' limit 1;
  osm_id  |                  astext
----------+------------------------------------------
 26795285 | POINT(-13809852.0188925 5564541.1872538)


- Bad connection parameters, check the database name, table name,
username and password in the $MAPNIK_MAP_FILE (and the $MAPNIK_MAP_FILE
is the one actually being used by generate_tiles.py)

- See also the Postgresql log files for things like...
FATAL:  no pg_hba.conf entry for host "10.0.0.1", user "tile", database "gis", SSL on

- Check that Mapnik compiled the Postgis plugin, e.g. you should have
something like:
# ls -l /usr/local/lib/mapnik/input/postgis.input
-rwxr-xr-x 1 root root 163240 2008-01-25 21:28 /usr/local/lib/mapnik/input/postgis.input

- the user running the renderer must have permission to perform select()
on geometry_columns table in Postgres:

gis=> select * from geometry_columns;
 f_table_catalog | f_table_schema |    f_table_name    | f_geometry_column | coord_dimension |  srid  |    type
-----------------+----------------+--------------------+-------------------+-----------------+--------+------------
                 | public         | planet_osm_point   | way               |               2 | 900913 | POINT
                 | public         | planet_osm_line    | way               |               2 | 900913 | LINESTRING
                 | public         | planet_osm_polygon | way               |               2 | 900913 | POLYGON
                 | public         | planet_osm_roads   | way               |               2 | 900913 | LINESTRING
(4 rows)


	Jon