I want to delete some data from database "Nominatim".

  • One way is to generate nominatim pre-indexed file from database "Nominatim".
  • Next, remove some data from this file.
  • After all, create new database from this npi file.

The problem is that npi service is being deprecated http://open.mapquestapi.com/npi/

How can I generate npi file from database "Nominatim"?

asked 09 Jan '14, 12:20

amshegar's gravatar image

amshegar
46337
accept rate: 0%


The NPI format is no longer supported. The code that still exists is not maintained and might be changed or removed at some point in the future.

If you want to filter data from the database you should filter your OSM file before importing it into Nominatim.

permanent link

answered 09 Jan '14, 14:37

lonvia's gravatar image

lonvia
5.7k25381
accept rate: 41%

-2

Hi, did you followed III's suggestions ? 'There is currently no DB schema description of Nominatim available: http://wiki.openstreetmap.org/wiki/Category:Nominatim 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?' And the result ? Since your asking it here again ?

permanent link

answered 09 Jan '14, 13:19

Hendrikklaas's gravatar image

Hendrikklaas
9.0k185217363
accept rate: 5%

Hi, did you followed III's suggestions...

Hello. No. This is a task from my work. Before this day I had other tasks and goals, but today all tasks were done. This is the last task: I must significantly improve the speed of geocoding (for example, ** requests per second)

I'm not a very good specialist in the geocoding or database design. But in our company there are no other specialists. So I ask this question on the forum.

So, 1) extract planet-latest.osm from planet-latest.osm.pbf or planet-latest.osm.bz2 2) write scripts for removing some data from planet-latest.osm 3) make planet-latest.osm.bz2 from planet-latest.osm using winRAR

(10 Jan '14, 06:48) amshegar
1

We usually use Osmosis to process .PBF or .OSM files, so it's the most reliable tool. You might also try others.
AFAIK you can use osmosis without needing to extract the full planet (saves disk space and increases speed).
Yes, sounds like a plan :) But I suggest to start playing with filtering with smaller extracts, so you save time and get a better feeling about the results and see possible problems fast enough. Your home area is always a good idea.

(10 Jan '14, 17:51) iii
2

To be honest it sounds as if you are very much out of your depth, and anything you try will be fishing in muddy waters. Are you even sure that removing some data will speed things up? Have you tuned your PostGIS database as recommended? Is your database on an SSD, and does the machine have enough RAM? -- We have programs that can filter OSM data, like osmosis or osmfilter, there's no need to write your own. You could even run the import normally and then remove data from PostGIS by issuing DELETE statements for what you don't need. But as I said, it's not even sure that this will help.

(11 Jan '14, 00:15) Frederik Ramm ♦

I already tuned all software (I read official documentation on each program). The database is on an SSD. The hardware is good.

I think I finish this task successfully if I significantly reduce the size of database "nominatim" (in this case I also save some SSD). For example, I want to delete all data, which level is less than 17. http://wiki.openstreetmap.org/wiki/Nominatim/Development_overview#Indexing_.2F_Address_Calculation

Does such command in osmosis exist?

(13 Jan '14, 11:44) amshegar
Your answer
toggle preview

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:

×635
×2

question asked: 09 Jan '14, 12:20

question was seen: 7,540 times

last updated: 13 Jan '14, 11:44

powered by OSQA