- AuthorPosts
- January 21, 2020 at 17:01 #33367JuanjoParticipant
Hi,
in mapsforge POI v 1 there is a record in poi_data table for each combination of data/category columns, meaning that, if a POI belong to several categories, there are several records in the table for the same POI.
Because of this, when doing searches in oruxmaps, the same POI is displayed several times, which is annoying.
If my understanding is correct, mapsforge POI v 2 can deal with this without duplicating records. Not only will this solve the issue with oruxmaps, I think it will considerably decrease the POI database size as well.
So my question is: do you have any plan to move to POI v2 in the (near) future?Regards
January 22, 2020 at 12:00 #33372ChristianKKeymasterHi,
No Problem – which poi databse (country) do you want to have for testing?
Maybe i have to change the poi-mapping.
At a first approach I will prozess the given poi-mapping with the new poi-writer.Best regards
ChristianJanuary 22, 2020 at 12:39 #33377JuanjoParticipantHi Christian,
Spain_Portugal_ML.poi would be perfect.
Many thanks
January 27, 2020 at 16:29 #33517ChristianKKeymasterYou can download the Spain_Portugal.poi from the site:
http://download.openandromaps.org/pois/europe/Spain_Portugal.poi.zip(Green button – the poi file in the map.zip ist still the old one)
January 27, 2020 at 20:56 #33521JuanjoParticipantThank you Christian,
I tested the new POI file in oruxmaps and it is working like a charm. I do not have anymore the same alpine hut info displayed three times when I touch it on the map.
FYI, I also checked what happens if the dots you added to category names, to avoid duplicates, are removed, and the answer is: nothing happens. Everything continues to work flawlessly.
So, it may be that you want to add a few lines at the end of your generation script to do it as well. I ran the following SQL command in the database:
UPDATE poi_categories SET name = TRIM(name, '.')
Thanks again
January 28, 2020 at 15:51 #33535ChristianKKeymasterHi,
Thanks for feedback !
Best regards
Christian - AuthorPosts
- You must be logged in to reply to this topic.