[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Maposmatic-dev] Re: [OSM-dev] How to support name:* in MapOSMatic?

From: Greg Troxel
Subject: [Maposmatic-dev] Re: [OSM-dev] How to support name:* in MapOSMatic?
Date: Fri, 08 Jan 2010 08:29:52 -0500
User-agent: Gnus/5.110011 (No Gnus v0.11) Emacs/23.1 (berkeley-unix)

  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

Attachment: pgpx80dq8C9jf.pgp
Description: PGP signature

reply via email to

[Prev in Thread] Current Thread [Next in Thread]