We would like to support multiple names for a given street: name:fr, name:ar, etc. As far as I have understood, we could configure osm2pgsql to create columns "name:fr", "name:ar", etc. and change our SQL requests to use those columns. That does not seems very scalable.
The ideal configuration would be to have all names (name:fr, name:ar, ...) into a single "name" column and use it. Or have a kind of couple (name, country_code) that would store all different names for a street. But I don't know how to do this. Not well thought out, but: add a name table id(SERIAL), name(lang), name(text) for each such named object, get a new SERIAL in the name table, and add in all of the language/value pairs put the id in the main database
pgpDWLmvFNWAv.pgp
Description: PGP signature
_______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev