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

[John Wheeler]

Thanks for the info Jon. This was the info I needed. The tiles get generated
correctly now. My install runs on a ubuntu gutsy server. The
postgis.inputwas compiled as
postgis.so.

John


On Jan 29, 2008 11:54 PM, Jon Burgess <jburgess777 at googlemail.com> wrote:

>
> 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
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20080131/7eac49ab/attachment.html>