|
I want to delete some data from database "Nominatim".
The problem is that npi service is being deprecated http://open.mapquestapi.com/npi/ How can I generate npi file from database "Nominatim"? |
|
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. |
|
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 ?
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.
(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
|
