[Geocoding] Information

[Sarah Hoffmann]

Hi Michael,

the communication language for this list is English. I hope you
don't mind me switching the language.

On Thu, Jul 19, 2012 at 03:20:15PM +0100, Michael Saimbertil wrote:
> On m'a installé un muni serveur Postgres, nominatim.
> Mon problème c'est que je comprends pas les table que renvois la base quand   mon tuteur a fait un test avant meme d'aller plus loin. J'aimerais savoir s'il   y a pas un document  soi un draft qui explique de facon détaillé chaque table  et qui pourrait vraiment m'aider à avancer avec mon stage.

There is no documentation of the database schema other than the code
itself, sorry. If you want to learn about the schema, I recommend you
start with those three tables: placex, search_name and place_addressline.
(see sql/tables.sql)

placex contains all OSM objects, search_name contains the search tokens
for each object and place_addressline the relation between the objects
(e.g. Paris is in France). The main function to fill these tables
is placex_insert() in sql/functions.sql, so this is a good place to
start reading the code.

Sarah