NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

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?

asked 28 Mar '12, 15:44

MHein's gravatar image

MHein
141111116
accept rate: 0%


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

permanent link

answered 28 Mar '12, 21:57

Firefishy's gravatar image

Firefishy ♦♦
1.3k73652
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

http://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

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×440
×341
×134
×4
×1

question asked: 28 Mar '12, 15:44

question was seen: 4,389 times

last updated: 29 Mar '12, 10:18

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum