Rendering GPX trails with mapnik

General talk
21

Looks like it’s perfectly good, but there still is some crap somewhere that prevent it from working. There must be a reference to that unexisting column “the_geom” somewhere.

What’s in your geometry_columns table ?

Mine is :

select * from geometry_columns;
 f_table_catalog | f_table_schema |    f_table_name    | f_geometry_column | coord_dimension |  srid  |      type
-----------------+----------------+--------------------+-------------------+-----------------+--------+-----------------
                 | public         | cfd                | way               |               2 |     -1 | MULTILINESTRING
                 | 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
22

This is mine (some experimental entries left):

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
                 | public         | way                | way               |               2 |     -1 | MULTILINESTRING
                 | public         | cfd                | the_geom          |               2 |     -1 | MULTILINESTRING
                 | public         | cfd                | way               |               2 |     -1 | MULTILINESTRING

(thanks for all your patience and help by the way!)

-peter

23

okay, try to flush all entries related to “cfd” and restart the “prepare table” from shp2pgsql

( there shouldn’t be the “the_geom” geometry_column in that table

24

That worked! Now I get my track! I guess the old stuff left in the DB was the cause of the error.

Thanks!
-peter