Import .poi-file (MapsForge format)

Menion ●

Hello Hans,

may you please share here some sample file (probably pack it to "zip" file) and also is there any documentation for this format? Where it comes from? Some more info is welcome, thanks

URL

1

William Robinson ●

Hello Menion:

I'm not sure if Hans answered you, but I would be interested in this too and here is an example of a zipped *.poi file from Openandromaps.com. The *.poi file format was apparently developed for Magellan.

Thank you!

Bill

Files:

URL

1

Menion ●

Good day William,

are you sure this is data file that Hans talk about? In this case it is SQLite database file and because it's content is based on OpenStreetMaps, I see no reason to support this type of POI file. Mainly because already offer own solution supplied together with LoMaps from Locus Store. Thanks for understanding.

URL

1

Michael Bechtold ●

This is like arguing that you do not need to support MBTiles, OruxMaps and many other formats that Locus does, because most of them are based OSM, too.

URL

1

Menion ●

Agree, it similar (partially), except that MBTiles are probably most widely used mobile map format that also support very nice metadata table, which is huge advantage compare to plain SQLite and OruxMaps on second side support many map projections, not just Mercator as is used in SQLite maps. So both format support something more. It's not case in this format for now. Huge amount of work that this require is another argument against it for now.

URL

1

Michael Bechtold ●

I had a look at both data models, Locus POI and MapsForge. There is no magic in either, but Locus is much more complex, as it supports additional functionality.

One way would be to built a little converter that eats MapsForge POI DBs and delivers the POI part of the Locus POI DB.

I currently do not have the time to do this myself (and I would have to amend my skills while "running", too :-).

URL

1

Menion ●

Yes there is no magic in database, just a little magic in system we have to create it. Anyway I wanted some time ago to publish these our tools we have ... which should be a lot better then creating convertor ;).

URL

2

Michael Bechtold ●

That would be helpful indeed!

URL

1

Michael Vogel ●

Hi would be very useful, when I am searching within an original LoMaps POI database I find only city names and just a couple of locations. Nothing in compare to my Garmin maps or even some other OSM based POI's :(

So it would be brilliant (!) to be able to create (convert, import etc.) locus compatible POI databases.

URL

1

unos ●

Is there something new to import a .poi file in sqlite format ? I´am a new User and would like to import a .poi file

URL

1

Klonutzer ●

Is there any progress on this topic?

URL

1

Petr Voldan ●

Honestly I'm not 100% sure what format users want to supports.

OpenAndroMaps (MapsForge) POIs format - there is already post from menion in this idea http://help.locusmap.eu/topic/import-poi-file#comment-41330 Basically Locus already offers POIs database (also in sqlite format) as part of LoMaps maps
Is it another format? If yes, do you have an example file and information about source?

Thank you

URL

1

Michael Bechtold ●

Well, Petr, a year ago there was talk about providing the tool that writes the LoMaps POI database. Then a volunteer could write a script to export from Mapsforge POI DB and feed into LoMaps POI DB creator.

While both, Mapsforge and LoMaps are fed from the same basic data, there is still a difference, and Mapsforge POIs are more current, too.

URL

1

Petr Voldan ●

I see but it's little bit different story in it isn't subject of this topic :)

URL

1

Skully Fox ●

Hello. Petr, Is there any progress about tool or method that can create own POI file compatible with LOCUS vector (osm) map? I have to create 14,000 point of mountain peaks into osm.db. because that data is not includuded at LoMaps poi DB. I used GDAL tool(ogr2ogr) to create SQLITE3 db for using at LOCUS. but It can't be recognized by LOCUS app. I think LoMaps poi db is much more complicated than mapsforge standard poi file. If You can't provide LoMaps POI DB creator, Would you give me some hint for generating POI file.

Have a good day.

URL

1

Skully Fox ●

In addition, My 14,000 Mt.Peak point is consist of lat, lon and peak name (originally gpx file)

Can it be possible that these data inserted to Lomaps POI db file?

Let me know howto plz

URL

1

Petr Voldan ●

Hi, the generator works only with OSM data and I can't give you any exact info if we release our script publicly. However peaks are included in LoMaps POI DB. Please see section "Nature > Peak". Peaks are obviously from OSM data. Is it OK for you?

URL

1

Skully Fox ●

Thank you for answer, Petr. my country.osm.db(LoMaps) have just 1568 peaks (Yes. It's from OSM data)

But I have about 14,000 peaks data from National Geology Institute(not from osm). So, I need method of making POI (.db) file compatible with LOCUS app. Of course I already have base osm map of my country.

Is there any way of inserting my 14000 peaks data into country.osm.db (LoMaps) ?

URL

1

Petr Voldan ●

Hi,

honestly I'm not familiar with MapsForge POI format but LoMap POI DB is also sqlitedb database (with the spatialite extension). In can briefly describe how to "import" the POIs. Are you familiar with SQL inserts and maybe with some scripting?

BR Petr

URL

1

Michael Bechtold ●

That would be great - there will be some volunteer, I guess ... :-)

URL

3

Petr Voldan ●

I'd like to notice that we decided to publish the tool for generation POIs DB and Addreess DB. Such task has low priority for us but I expect that it would be ready till end of the summer. I guess that it'll be more useful then some SQL queries.

URL

1

Skully Fox ●

Thank you very much for your deciding. Petr. It will be very helpful for users to make their own POI files.

-Skully Fox

URL

1

Michael Vogel ●

Brilliant - first since many years I didn't use Locus during a two week hiking tour (because of two reasons: no offline searching of POIs and OS explorer map tweaking didn't work)...

...would love to get POI databases!

URL

1

Skully Fox ●

Hi, Petr ! How about publishing tool for generating POI db? I think summer is almost over now :)

Our 10000 gps club member wait for your answer

Thanks.

URL

1

Petr Voldan ●

Hi,

thanks for reminder. It's still on my to-do list but there were some important tasks that I had to focus on and also vacation. Please give me couple weeks. Thanks for patience.

URL

1

Skully Fox ●

Hi, Petr. I saw the news (15th OCT.) on locusmap homepage. But there is no comment about "publish the tool for generation POIs DB and Addreess DB" . Should I wait more time or you decided not to provide that tools?

URL

1

Michael Bechtold ●

A promise is a promise ...

... to be held!

URL

1

Petr Voldan ●

I know know and I'm sorry for this. We still want to publish this tool but you know it there is always something more important....

URL

1

Marius Moldovan ●

Please make some time for publishing this tool. We can integrate a lot of geocaches and other POIs into map

URL

1

Skully Fox ●

Hi, Petr. again :)

Can it be possible that we use mapsforge poi tool till the end of 2018 ?

Our 10000 gps member are looking forward to your answer every day. I think you're trustworthy man

have a nice day

URL

1

Skully Fox ●

hi petr. where are you? are u alive?

your promise still valid?

URL

2

Petr Voldan ●

Hi, yes I am :). Well promise is a promise but it has for me the lowest priority. But you're right that I should finally come up to your expectations...after several months. I'll little bit increase the priority for it in the list of my tasks.

URL

1

Klonutzer ●

I'm talking of the format offered at mapsforge. As I can use the map files available there I would like to use the poi files offered along with it.

URL

1

Michael Bechtold ●

From the analysis others did (parallel thread), there are only few challenges left, like the creation of the blob in the poi.db file. So, there might not be the need to disclose the whole tool, but some isolated functions like mentioned above, that would allow others to do their own homework.

URL

1

Simao M ●

I think this would be very important. I don't mind running some kind of converter from mapforge POIs to LoMaps so it can be displayed on Locus, it doesn't need to support the mapforge poi file directly, but would be very good to have these available in Locus

URL

1

Andrea ●

Reminder

URL

1

Petr Krivanek ●

Yep, we need to import *.poi ... :)

URL

2

YPNA Geocaching Team ●

I really like the idea of being able to add all geocaches of a country to a POI database in proper Locus format (even if they are the only POIs in that database as long as there is no import function for OSM POIs).

I am traveling across (or along) Italy at the moment and even with "only" approximately 30K geocaches, this brings Locus to its knees... or gives my navigator a hard time switching between Locus and my geocache repository (which happens to be GDAK, which handles that number of geocaches just fine).

BTW I love Locus and switched to the PRO version after extensive testing.

URL

2

Stephan ●

After cycling more than 10 Years using PDA and Smartphones for navigation, I have the understanding, one app will never offer a perfect world. To get nearer to a perfect world you have to use two or three apps. I solved this POI-problem in this way. I made in the function panel a button to trigger osmand and use the POI-base of Osmand.

Although I have a LoMap of my area and I can use the POIs of Locus, I prefer using in this way Osmand. because it is more comfortable and the presentation of POIs is more userfriendly in Osmand.

URL

1

YPNA Geocaching Team ●

Thank you very much for this suggestion Stephan!

My current limitation are (i) a not very powerful device and (ii) the wish to not having to switch between apps while driving. Displaying geocaches around us while driving (so that we can plan our pit stops accordingly ;-) is what I am looking for. Getting the details of a geocache via a different (and specialized) app is perfectly OK.

URL

1

Skully Fox ●

Petr and menion ignore this idea for many years,,, :)

Petr promissed to publish poi creation tool last year. but no progress yet. HaHaHa

URL

1

Petr Voldan ●

Well I don't ignore it but there is always something more important :( . I should probably correct your expectation. The tool or script for generation of Locus POI database, can process only raw OSM data. So it'll be always needed to convert your custom data into OSM format.

I'm sorry for that and as menion wrote I'll try to find some more time for it.

URL

1

Michael Bechtold ●

Hi Petr, OSM data can come in different formats. Do you think of PBF, o5m, OSM xml ?

URL

2

Petr Voldan ●

The tools is basically plugin for OSMOSIS. So the input data can be in any format supported by OSMOSIS - https://wiki.openstreetmap.org/wiki/Osmosis/Detailed_Usage_0.46

URL

1

Michael Bechtold ●

Very much appreciated - this is the most proper and most powerful way to deliver this promise!

URL

3

Menion ●

This is not exact.

I'm watching this topic carefully, anyway direct support for MapsForge POI system does not have in our plans priority. So the solution was to publish our own POI generator. Here is a problem lack of time on Petr's side, where he is for many months focused on Locus GIS and finishing his work on support for "tracks" in Locus Store and this task may take maybe more than a week of work to correctly separate logic for creating POI database.

I know he promised some public tool a few months ago and I personally really would like to see it published as well, but I understand his priorities as well. Complicated task.

I'll try to push him little more once tracks will be mostly completed.

Anyway sorry, it is not about ignorance, just about lack of time :(.

URL

1

Victor Na ●

Hello Hans & Menion,I heard you accepted a suggestion by many Locus users from Korea and othercountries that you upgrade a function for the Locus app, makingpossible for users to install their own poi files in the Locus app. However, youhave not upgraded the function yet.

Locus App is a good app for outdoor activities. Butthe LoMaps, your poi files selling in the Locus Store, have poor information init because the maps are based on the Open Street Maps. Poor information in the LoMapsdegrades the usefulness of the Locus app. I worry about possibility thatsomeone may have accidents during hiking with LoMaps.

Volunteers in a GPS club in Korea together have builta POI database for Korea streets and mountains. The file is free for allmembers of the club. Users put the file to use by installing in the Oruxmapsapp because Oruxmaps allows users to use their own poi file in the app.

Locus is poplar app in Korea. But, your app is behindin usefulness, comparing with Oruxmaps. I do not want to hear news of accident orinconvenience because of your app. That is the very reason that you have toupgrade the poi function.

Korean guys consider seriously sticking their word if theypromised something. I hope you are much the same as Korean.

We can help you if you need any support. I hope tohear when you will upgrade Locus app.

URL

1

YPNA Geocaching Team ●

We completed our trip through Italyand it is raining cats and dogs at home. A perfect opportunity to tinker withthe Locus POI database.

While on the road, I found an OAM forum entry provided by “cebewee”(https://www.openandromaps.org/oam-forums/topic/poi-nutzbarkeit-der-dateien-mit-locus/page/3).This forum entry points to an analysis of the Locus POI database performed byLars Noschinski (https://gitlab.com/noschinl/locus-poi-db)a while ago.

Last night, I used the SpaciaLite GUI (https://www.gaia-gis.it/fossil/spatialite_gui/index)to open a Locus POI database (Gibraltar) and I was able to add my own points tothat database (see below for the SQL statements used).

This *almost* satisfies my use case to display all geocachesfor a specific region. Of course, it does not give me any geocache details (yet).

What I would like very much, however, is the ability todisplay the proper icons per geocache type. Based on the above Locus POI database analysis,the icons seem to be determined by the combination of FoldersRoot andFoldersSub entries linked to a given point (via table Points_Root_Sub). As thecurrent FoldersRoot (13 rows) and FolderSub (77 rows) tables do not containgeocaching related information, it is probably impossible to display pertinenticons. Also, I have no clue as to where the icons are stored and if it ispossible to add/use custom icons.

I see custom icons as the only solution in the long run, asI am certain that there are endless wishes for specific icons that could neverbe managed centrally. I also understand that “little” wishes like this one can turna simple task into a major project. All the more I appreciate your efforts!

Thank you very much and best regards

Peter from the YPNA Geocaching Team

----------------------------------------------------------------------------------------------------

-- Housekeeping

----------------------------------------------------------------------------------------------------

DELETE FROM "Points" WHERE "id" > 9999999000 AND "id" <9999999010;

-- "Points_id" is the "rowid" of theinserted points! This must be determined ** BEFOREHAND **

-- DELETE FROM "Points_Key_Value" WHERE"Points_id" > 781;

-- DELETE FROM "Points_Root_Sub" WHERE "Points_id" > 781;

----------------------------------------------------------------------------------------------------

-- Insert points into Points table

----------------------------------------------------------------------------------------------------

INSERT INTO "Points"VALUES(9999999001,"P","Test1",GEOMFROMTEXT('POINT(-5.350000136.120001)', 4326));

INSERT INTO "Points"VALUES(9999999002,"P","Test2",GEOMFROMTEXT('POINT(-5.350000236.120002)', 4326));

INSERT INTO "Points" VALUES(9999999003,"P","Test3",GEOMFROMTEXT('POINT(-5.350000336.120003)', 4326));

INSERT INTO "Points"VALUES(9999999004,"P","Test4",GEOMFROMTEXT('POINT(-5.350000436.120004)', 4326));

INSERT INTO "Points"VALUES(9999999005,"P","Test5",GEOMFROMTEXT('POINT(-5.350000536.120005)', 4326));

----------------------------------------------------------------------------------------------------

-- Obtain "rowid" of inserted points for links totags and folders below

----------------------------------------------------------------------------------------------------

SELECT "rowid", * FROM "Points" WHERE"id" > 9999999000 AND"id" < 9999999010;

----------------------------------------------------------------------------------------------------

-- Link inserted points to tags - after example of the 100ton gun (point_id 675275200, rowid 30)

-- SELECT "rowid", * FROM "Points" WHERE"name" LIKE "%gun%";

-- SELECT "rowid", * FROM"Points_Key_Value" WHERE "Points_id" = 30;

-- SELECT "rowid", * FROM "TagKeys";

-- SELECT "rowid", * FROM "TagValues";

----------------------------------------------------------------------------------------------------

INSERT INTO "Points_Key_Value" VALUES(782,1,5);

INSERT INTO "Points_Key_Value" VALUES(783,1,5);

INSERT INTO "Points_Key_Value" VALUES(784,1,5);

INSERT INTO "Points_Key_Value" VALUES(785,1,5);

INSERT INTO "Points_Key_Value" VALUES(786,1,5);

----------------------------------------------------------------------------------------------------

-- Link inserted points to folders - after example of the100 ton gun (point_id 675275200, rowid 30)

-- SELECT "rowid", * FROM "Points" WHERE"name" LIKE "%gun%";

-- SELECT "rowid", * FROM"Points_Root_Sub" WHERE "Points_id" = 30;

-- SELECT "rowid", * FROM "FoldersRoot";

-- SELECT "rowid", * FROM "FoldersSub";

----------------------------------------------------------------------------------------------------

INSERT INTO "Points_Root_Sub" VALUES(782,4,16);

INSERT INTO "Points_Root_Sub" VALUES(783,4,16);

INSERT INTO "Points_Root_Sub" VALUES(784,4,16);

INSERT INTO "Points_Root_Sub" VALUES(785,4,16);

INSERT INTO "Points_Root_Sub" VALUES(786,4,16);

----------------------------------------------------------------------------------------------------

-- Display inserted points and some more for comparisons

----------------------------------------------------------------------------------------------------

SELECT * FROM "Points" WHERE "id" >6000000000 ORDER BY "id";

SELECT * FROM "Points_Key_Value" WHERE"Points_id" > 750;

SELECT * FROM "Points_Root_Sub" WHERE"Points_id" > 750;