This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

column “int_tc_type” does not exist

Hey guys! When rendering from PostgreSQL/PostGIS database by Python/Mapnik I receice the following ERROR: http://dpaste.org/s8zIZ/

Traceback (most recent call last):
File "C:\0A\11\generate_image.py", line 71, in <module>
mapnik.render(m, im)
RuntimeError: Postgis Plugin: PSQL error:
ERROR: column "int_tc_type" does not exist
LINE 1: SELECT ST_AsBinary("way") AS geom,"int_tc_type" from planet_...
^
Full sql was: 'SELECT ST_AsBinary("way") AS geom,"int_tc_type" from planet_osm_roads WHERE "way" && SetSRID('BOX3D(1127187.934825658 7229086.56980958,1134824.118093661 7236722.753077583)'::box3d, 900913)'

I took the steps like in http://switch2osm.org/serving-tiles/manually-building-a-tile-server/

My OS is Windows.

I imported my africa.osm by osm2pgsql to my database.

Is it possible, that the whole thing only works with the whole planet_latest.osm?

column rendering postgis mapnik int_tc_type

asked 28 Mar '12, 15:44

MHein
141●11●11●16
accept rate: 0%

One Answer:

Most likely the version of osm2psql is too old to work with the current mapnik stylesheet you are using. Try an older stylesheet eg: https://trac.openstreetmap.org/browser/applications/rendering/mapnik?rev=20000

answered 28 Mar '12, 21:57

Firefishy ♦♦
1.3k●7●36●52
accept rate: 29%

Thanks, but I don't find any stylesheet "default.style" there (maybe because the server

seems to be kind of down..) or did you think of the osm.xml?

Yesterday I downloaded a newer "default.style" to fix another Error

https://help.openstreetmap.org/questions/11542/error-column-generatorsource-does-not-exist

How can I fix both of them? Is there any possibility to fill in the missing column by hand/manually? .. column "length" is also missing ..

(29 Mar '12, 10:17) MHein