Mapnik error: column "generator:source" does not exist

Question

Heyho!

When trying to render my map from PostgreSQL/PostGIS database by generate_image.py and osm.xml I receive the following ERROR! Could somebody be so kind and try to solve my problem?

If you need to see some sourcecode etc. .. just tell me and I'll upload it here!

Thanks and Greetings! Matze

Traceback (most recent call last):
  File "C:\0A\9\run_python.py", line 3, in <module>
    execfile(r"C:\0A\9\generate_image.py")
  File "C:\0A\9\generate_image.py", line 42, in <module>
    mapnik.load_map(m,mapfile)
RuntimeError: Postgis Plugin: PSQL error:
ERROR:  column "generator:source" does not exist
LINE 8:          or (power='generator' and ("generator:source"='wind...
                                            ^
Full sql was: 'SELECT * FROM 
      (select *
      from planet_osm_point
      where aeroway in ('airport','aerodrome','helipad')
         or barrier in ('bollard','gate','lift_gate','block')
         or highway in ('mini_roundabout','gate')
         or man_made in ('lighthouse','power_wind','windmill','mast')
         or (power='generator' and ("generator:source"='wind' or power_source='wind'))
         or "natural" in ('peak','volcano','spring','tree','cave_entrance')
         or railway='level_crossing'
      ) as symbols LIMIT 0'
 (encountered during parsing of layer 'amenity-symbols' in map 'osm.xml')

Accepted Answer

This is likely because your osm2pgsql version is older than the osm.xml map style. The map style assumes that osm2pgsql has imported a column named generator:source but in fact osm2pgsql hasn't. You can fix the problem in one of these ways:

get new osm2pgsql (or just new default.style file) and do new import
get an older osm.xml map style that does not rely on generator:source
insert an empty generator:source column into your postgres tables
remove the line about power generators from your osm.xml

Obvoiusly, only the first option will lead to wind turbines being rendered properly.

Answer 2

The software osm2pgsql, usually used to import OSM data into a rendering database, only imports a subset of the data required for rendering. What osm2pgsql deems necessary for rendering (and thus the resulting database schema) is defined in a import style-sheet. This osm2pgsql import style-sheet needs to match your mapnik rendering style-sheet, otherwise you will see errors as yours, complaining about missing columns.

Looking at your output, it appears you are using windows. The windows version of osm2pgsql is unfortunately very old and thus the import style-sheet going with it no longer matches the current osm mapnik style-sheet. You can find the current import style-sheet at https://trac.openstreetmap.org/browser/applications/utils/export/osm2pgsql/default.style which you will need for re-importing the data into your database.

Answer 3

Who, this is probably my solution to! I don't have much experience with linux but I got pretty far. This is my error. But my question is how can I check the versions and find the right style-sheet?

My Error:

`renderd[17965]: An error occurred while loading the map layer 'default': :
ERROR:  column "generator:source" does not exist
LINE 8:          or (power='generator' and ("generator:source"='wind...
                                            ^
Full sql was: 'SELECT * FROM 
      (select *
      from planet_osm_point
      where aeroway in ('airport','aerodrome','helipad')
         or barrier in ('bollard','gate','lift_gate','block')
         or highway in ('mini_roundabout','gate')
         or man_made in ('lighthouse','power_wind','windmill','mast')
         or (power='generator' and ("generator:source"='wind' or power_source='wind'))
         or "natural" in ('peak','volcano','spring','tree','cave_entrance')
         or railway='level_crossing'
      ) as symbols LIMIT 0'
 (encountered during parsing of layer 'amenity-symbols' in map '/home/administrator/src/mapnik-style/osm.xml')
renderd[17965]: An error occurred while loading the map layer 'default': :
ERROR:  column "generator:source" does not exist
LINE 8:          or (power='generator' and ("generator:source"='wind...
                                            ^
Full sql was: 'SELECT * FROM 
      (select *
      from planet_osm_point
      where aeroway in ('airport','aerodrome','helipad')
         or barrier in ('bollard','gate','lift_gate','block')
         or highway in ('mini_roundabout','gate')
         or man_made in ('lighthouse','power_wind','windmill','mast')
         or (power='generator' and ("generator:source"='wind' or power_source='wind'))
         or "natural" in ('peak','volcano','spring','tree','cave_entrance')
         or railway='level_crossing'
      ) as symbols LIMIT 0'
 (encountered during parsing of layer 'amenity-symbols' in map '/home/administrator/src/mapnik-style/osm.xml')
renderd[17965]: An error occurred while loading the map layer 'default': :
ERROR:  column "generator:source" does not exist
LINE 8:          or (power='generator' and ("generator:source"='wind...
                                            ^
Full sql was: 'SELECT * FROM 
      (select *
      from planet_osm_point
      where aeroway in ('airport','aerodrome','helipad')
         or barrier in ('bollard','gate','lift_gate','block')
         or highway in ('mini_roundabout','gate')
         or man_made in ('lighthouse','power_wind','windmill','mast')
         or (power='generator' and ("generator:source"='wind' or power_source='wind'))
         or "natural" in ('peak','volcano','spring','tree','cave_entrance')
         or railway='level_crossing'
      ) as symbols LIMIT 0'
 (encountered during parsing of layer 'amenity-symbols' in map '/home/administrator/src/mapnik-style/osm.xml')
renderd[17965]: An error occurred while loading the map layer 'default': :
ERROR:  column "generator:source" does not exist
LINE 8:          or (power='generator' and ("generator:source"='wind...
                                            ^
Full sql was: 'SELECT * FROM 
      (select *
      from planet_osm_point
      where aeroway in ('airport','aerodrome','helipad')
         or barrier in ('bollard','gate','lift_gate','block')
         or highway in ('mini_roundabout','gate')
         or man_made in ('lighthouse','power_wind','windmill','mast')
         or (power='generator' and ("generator:source"='wind' or power_source='wind'))
         or "natural" in ('peak','volcano','spring','tree','cave_entrance')
         or railway='level_crossing'
      ) as symbols LIMIT 0'
 (encountered during parsing of layer 'amenity-symbols' in map '/home/administrator/src/mapnik-style/osm.xml')`

Mapnik error: column "generator:source" does not exist

Follow this question

Related questions