[OSM-dev] How to support name:* in MapOSMatic?
Greg Troxel
gdt at ir.bbn.com
Fri Jan 8 13:29:52 GMT 2010
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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 194 bytes
Desc: not available
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20100108/de1a02c1/attachment.pgp>
More information about the dev
mailing list