search

omniscale / imposm3

Imposm imports OpenStreetMap data into PostGIS
http://imposm.org/docs/imposm3/latest/
Apache License 2.0
726 stars 159 forks source link

Unification of additional tag keys #24

Closed hjanetzek closed 7 years ago

hjanetzek commented 10 years ago

Hi, is it currently to unify multiple keys into one column? 'mappings' is only for alternative entity classes if I understood correctly. For example there is wild use to tag colors for Simple-3D-Buildings at the moment which would be nice to be put into one column (of course it would be better to clean up the data in OSM):

building:colour (94 662) building:color (6 926) colour in combination with building (3000) color in combination with building (2500)

roof:colour (~150000) building:roof:colour (~10000) roof:color (~10000) building:roof:color (~100)

mcm-jyl commented 7 years ago

The other option is to use coalesce in SQL: map both column, use the colour tag if possible, otherwise color. As you said, "of course it would be better to clean up the data in OSM".

olt commented 7 years ago

Closing this as it's unlikely that this feature will be supported directly in the future. This could be solved with scripting support. However, there is no time frame for scripting. Right now HStore would be the best solution.