I'd set up Nominatim for the Uk using http://download.geofabrik.de/europe/great-britain-latest.osm.pbf without any issues. However I then wished to update the database with an additional set of data (in this case: http://download.geofabrik.de/europe/ireland-and-northern-ireland-latest.osm.pbf).

My first effort was to use ./utils/update.php --import-file using the Irish file. However this crashed my machine whilst attempting to reindex the updated tables - the machine ran out of disk space. Having read that there were some issues doing updates like this, I truncated the database tables and tried running the update.php script again having first merged the two osm files using osmosis.

This loaded the basic data in ok but unfortunately the php isn't expecting some of the support tables to be empty as I was left with the placex data missing certain key fields, e.g. postcodes, parent_place_ids, centroids.

Is there any script I could have run before the osm import to ensure these fields would have been populated?
(from looking about the setup.php and update.php files, I found a script to populate location_postcodes, and then ran a cursory update on placex thinking the trigger plsql would update the fields but it didn't work)

As it stands I've just dropped the database entirely and am re-running the full setup --all procedure but don't think this can be the best means of doing this...

asked 03 Dec '18, 12:29

Mr%20Davros's gravatar image

Mr Davros
accept rate: 0%

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

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



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:


question asked: 03 Dec '18, 12:29

question was seen: 913 times

last updated: 03 Dec '18, 12:29

powered by OSQA