Bulk Upload of POI's
-
@Dikke-Wim you can also use Qgis to harvest POI's from OSM mapping.
This is Castles for UK and Ireland.
You need two add ins to get the information QuickOSM
Which gives a dialog like this.
And POI exporter which allows export as a GPX file that MRA can read.@Mzokk Thanks a lot. But.... is a lot of work I guess. Therefore I prefer AI who takes over the difficult stuff. I'm doing some experiments with AI. Curious how things work out.
-
@Mzokk Thanks a lot. But.... is a lot of work I guess. Therefore I prefer AI who takes over the difficult stuff. I'm doing some experiments with AI. Curious how things work out.
Here's another attempt in three simple steps:
- Launch a query on overpass-turbo.eu
- export as gpx
- upload into MRA
-
Here's another attempt in three simple steps:
- Launch a query on overpass-turbo.eu
- export as gpx
- upload into MRA
I do not think @Greenham want to harvest POI's but to put his own POI's into MRA in bulk.
I use Excel to make them and then convert to GPX.
MRA only uses the description but If I load them into my Garmin I get the other fields also. I am now busy to find out how to bulk import a GPX into my little housemade tool. -
Here's another attempt in three simple steps:
- Launch a query on overpass-turbo.eu
- export as gpx
- upload into MRA
@Martin-Wilcke
Thank you very much! It seems to work great....
However, not all dots of castles of South UH that are shown on the map are found in MRA when imported.Do you have any idea how to fix this? See screendumps below.
See e.g. Cornwall with many castles
Cornwall without any castles
-
@Martin-Wilcke
Thank you very much! It seems to work great....
However, not all dots of castles of South UH that are shown on the map are found in MRA when imported.Do you have any idea how to fix this? See screendumps below.
See e.g. Cornwall with many castles
Cornwall without any castles
@Dikke-Wim said in Bulk Upload of POI's:
However, not all dots of castles of South UH that are shown on the map are found in MRA when imported.
Hmmm... Maybe you need to zoom in?
Overpass:
Imported:
-
@Dikke-Wim said in Bulk Upload of POI's:
However, not all dots of castles of South UH that are shown on the map are found in MRA when imported.
Hmmm... Maybe you need to zoom in?
Overpass:
Imported:
Unfortunately even when I zoom in more than in the example above, no additional castles appear. Only "few" of the cirkels with castles in the overpass.eu website, are visible.
Any suggestions what I do wrong?
Example of the map with castles in Cornwall
No castles in Cornwall after importing the GPX file
the KML file shows more castles in Google Earth than the GPX file in MRA
-
Unfortunately even when I zoom in more than in the example above, no additional castles appear. Only "few" of the cirkels with castles in the overpass.eu website, are visible.
Any suggestions what I do wrong?
Example of the map with castles in Cornwall
No castles in Cornwall after importing the GPX file
the KML file shows more castles in Google Earth than the GPX file in MRA
OK - let's focus on "Crane Castle" as an example; it's this one:
Please have a look at the GPX you've uploaded with an editor and search for "Crane", there should be a match like this:
In MRA, search for "Portreath" and zoom in to a scale of 1 km / 1 mile or less:
Does it show up?
-
Unfortunately even when I zoom in more than in the example above, no additional castles appear. Only "few" of the cirkels with castles in the overpass.eu website, are visible.
Any suggestions what I do wrong?
Example of the map with castles in Cornwall
No castles in Cornwall after importing the GPX file
the KML file shows more castles in Google Earth than the GPX file in MRA
And one more note:
I have just noticed that "historic=castle" can be modelled both as a ‘node’ (point) and as a ‘way’ (path, here in the sense of area). They appear as yellow dots for nodes and red dots for ways/areas.
That's why my example query node ["historic"="castle"]; is not ideal, because it only finds castles that are modelled as a point.
Better, as in your example, is nwr ["historic"="castle"]; as it includes nodes, ways and relations.
-
Unfortunately even when I zoom in more than in the example above, no additional castles appear. Only "few" of the cirkels with castles in the overpass.eu website, are visible.
Any suggestions what I do wrong?
Example of the map with castles in Cornwall
No castles in Cornwall after importing the GPX file
the KML file shows more castles in Google Earth than the GPX file in MRA
OK - I got it.
You need an out centre (instead of an out geom) to create a single node for ways/areas. This will generate waypoints for both types (nodes and ways) when exporting as GPX.
Here's the result
https://hidrive.ionos.com/lnk/LhseBgcKc
for the query:
Sorry for the confusion!
-
@Mzokk Thanks a lot. But.... is a lot of work I guess. Therefore I prefer AI who takes over the difficult stuff. I'm doing some experiments with AI. Curious how things work out.
@Dikke-Wim Somewhat less work than the method you describe
-
OK - I got it.
You need an out centre (instead of an out geom) to create a single node for ways/areas. This will generate waypoints for both types (nodes and ways) when exporting as GPX.
Here's the result
https://hidrive.ionos.com/lnk/LhseBgcKc
for the query:
Sorry for the confusion!
Thanks Martin. It works now much better (see below).
-
@Dikke-Wim Somewhat less work than the method you describe
What method do you mean? I don't get it.
For me: the easier the better! -
Thanks Martin. It works now much better (see below).
-
OK - I got it.
You need an out centre (instead of an out geom) to create a single node for ways/areas. This will generate waypoints for both types (nodes and ways) when exporting as GPX.
Here's the result
https://hidrive.ionos.com/lnk/LhseBgcKc
for the query:
Sorry for the confusion!
@Martin-Wilcke this is amazing never knew how to use this feature! It would be of great help if the MRA team @Corjan-Meijerink could make a YouTube tutorial on this.
-
I do not think @Greenham want to harvest POI's but to put his own POI's into MRA in bulk.
I use Excel to make them and then convert to GPX.
MRA only uses the description but If I load them into my Garmin I get the other fields also. I am now busy to find out how to bulk import a GPX into my little housemade tool.Yes this is what I am trying to do. Add my own POI's
-
@Greenham said in Bulk Upload of POI's:
Yes this is what I am trying to do. Add my own POI's
As another member of this forum asked me the same because I replied here, I have been dusting off my 20 year old programming skills in Excel VBA
the today status of the tools is the following
-
Import simple POI GPX files into Excel
-
Edit the imported file and add Symbol, Description, Street, Phone etc for import into Garmin devices
-
Export the POI file to GPX format
-
Double Click on the filled in row and the POI wil open in Google maps.
Excel file with Ribbon (KML does not work yet)
MOHO hotels GPX imported into Excel*3rd Item in the list selected and button "Show in Google Maps" selected
Import in MRA from GPX file
Import in Basecamp with selected symbol
Data added in Excel and transferred to Garmin GPX, see also the different symbols in the same GPX
Send me your email in a PB and I send you the current file with the following status:
-
Made and only tested in Excel/Windows10
-
Error handeling is still poor in the progarmming
-
Program as is, it works on my system, not tested on other equipment.
-
Program is made in MS VBA and not tested in other programs.
regards,
Bert -