Re: [Maposmatic-dev] Issue to install ocitysmap2: missing "addr:housename" column

[Vincent de Chateau-Thierry]

Hi,

Le 04/12/2011 17:42, David MENTRE a écrit :
> Hello,
>
> I'm trying to install a fresh maposmatic, following instructions
> maposmatic/INSTALL and ocitysmap/INSTALL.lucid. I have adapted the
> install instruction to use pre-compiled package of my Ubuntu 11.10.
>
> I have followed all steps and everything seemed to go smoothly...
> except ocitysmap2-render fails when I launch it! :-(
>
> """
> ./ocitysmap2-render -t "Ceci n'est pas Paris" -b 48.7268,1.9946 48.6801,2.0742
> [...]
> RuntimeError: PSQL error:
> ERROR:  column "addr:housename" does not exist
> LINE 2:       (select way,"addr:housename" from planet_osm_polygon w...
>                            ^
> Full sql was: 'select * from
>        (select way,"addr:housename" from planet_osm_polygon where
> "addr:housename" is not null and building is not null
>         union
>         select way,"addr:housename" from planet_osm_point where
> "addr:housename" is not null
>        ) as housenames
>         limit 0'
>   (encountered during parsing of layer 'housenames')
> """
>
> Apparently, column "addr:housename" is missing from my maposmatic
> database. Any idea how to create it? Any special config for osm2pgsql?

According to
http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/default.style
addr:housename only applies to points and lines :
node,way   addr:housename      text  linear

Maybe replacing "linear" with "polygon" for this entry in your style 
file could help ?

With regards,
vincent