NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

Hi !

I've tried to setup my own Nominatim reverse geocoding server and I've come into some issues. I've resolved some of them myselves but I'm stuck at the API fetching in reverse geocoding. Apparently, the database is incomplete because it throws me an error at my root access (localhost/) and reverse geocoding isn't working as it's throwing that the place couldn't be found.

I've poked around the databse and places hasn't been found in the tables. Here is the logs :

root@ns39147:/home/nominatim-docker# curl "http://localhost:7070/"

<!DOCTYPE html> <html lang="en"> <head> <style> em { font-weight: bold; font-family: monospace; color: #e00404; background-color: #ffeaea; } </style> </head> <body>

Internal Server Error

    <p>Nominatim has encountered an internal error while accessing the database.
       This may happen because the database is broken or because of a bug in
       the software.</p>



<h3>Details</h3>

Database query failed

<p>
    If you feel this error is incorrect feel file an issue on
    <a href="https://github.com/openstreetmap/Nominatim/issues">Github</a>.

    Please include the error message above and the URL you used.
</p>

</body> </html>

postgres=# \c nominatim
You are now connected to database "nominatim" as user "postgres".
nominatim=# \dt
               List of relations
 Schema |       Name        | Type  |   Owner
--------+-------------------+-------+-----------
 public | country_name      | table | nominatim
 public | country_osm_grid  | table | nominatim
 public | gb_postcode       | table | nominatim
 public | place_boundingbox | table | nominatim
 public | spatial_ref_sys   | table | nominatim
 public | us_postcode       | table | nominatim
(6 rows)

For info I'm using nominatim-docker from mediagis 3.4 which uses postgres 11 and postgis 2.5. The OSM files I've used are from geofabrik : Nord-pas-de-calais (a region of France), Monaco, and Finland. All don't work.

My question is : what am I missing to get the reverse geocoding API to work ?

Thanks for your help :)

asked 06 Apr '20, 13:48

Nominageek's gravatar image

Nominageek
16112
accept rate: 0%

1

I can't help you solve the issue but I can tell you that a \dt on a proper Nominatim database will yield hundreds of tables, most importantly among them a table called placex which contains most OSM data. This means something has not worked during your data import process.

(06 Apr '20, 14:10) Frederik Ramm ♦

Thanks for the info ! I hope I'll be able to solve this issue

(06 Apr '20, 14:19) Nominageek

permanent link

answered 09 Apr '20, 15:17

mtmail's gravatar image

mtmail
4.8k1574
accept rate: 27%

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×710
×689
×290
×133
×85

question asked: 06 Apr '20, 13:48

question was seen: 2,580 times

last updated: 09 Apr '20, 15:17

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum