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


For example, I want decrease the database size. I need to geocode only to the level of the village or town. Can I remove some not usefull data from planet.osm.pbf or from geodatabase "Nominatim"? I do not need streets, suburbs, buildings, etc. So I want remove this data from database or .osm.pbf.

The structure of geodatabase "Nominatim" is quite difficult, so I think that the best way is to change osm.pbf file. But I don't know how.

asked 18 Dec '13, 07:25

amshegar's gravatar image

accept rate: 0%


Yes I'd like to see some docs for the DB schema, or just an overview explanation of some of the main database structures of nominatim (AKA the osm2pgsql "gazetteer mode" output?). I thought it would be fairly easy to do geo queries on the nominatim db directly, but the structure is surprisingly "difficult" as you say. I figured out some queries I can do. See my adventures so far here:

(05 May '16, 12:40) Harry Wood

There is currently no DB schema description of Nominatim available:

So you might ask at the OSM-TALK or OSM-DEV mailinglist or in wiki at the Nominatim disc. A documentation at the wiki would be nice for the community :)

Maybe it's easier to export your dump to preprocessed nomiatim NPI files and filter this files before reimporting to get a light DB?

permanent link

answered 18 Dec '13, 15:29

iii's gravatar image

accept rate: 10%

Thanks for the answer. Can you tell me how convert postgresql database "Nominatim" to the nominatim pre-indexed file?

(09 Jan '14, 10:24) amshegar

Also I have read that NPI service is currently being deprecated. So I can not download NPI file from MapQuest...

(09 Jan '14, 12:09) amshegar

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]( "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: 18 Dec '13, 07:25

question was seen: 8,772 times

last updated: 05 May '16, 12:40

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