[Tile-serving] [openstreetmap/osm2pgsql] From the docs: Array elements can be a sign of database misdesign (#879)

[Frederik Ramm]

You should definitely use the Nominatim software for reverse geocoding. It utilises osm2pgsql under the hood but adds a lot of processing in SQL and PHP that you would otherwise have to re-invent yourself. If you *were* to do reverse geocoding with the database you have now, you would query the `planet_osm_line table` for the nearest road, and the `planet_osm_polygon` table for the administrative hierarchy, but there are more pitfalls than I can list in this ticket, and Nominatim solves (almost) all of them for you.

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/879#issuecomment-434666854
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20181031/38ea7ba5/attachment.html>