Skip to content
  • Categories
  • Recent
  • Popular
  • Support
  • MyRoute-app
Collapse
Brand Logo

MRA Community Forum

  1. Home
  2. MyRoute-app Routeplanner
  3. [Web] Suggestions and Discussion
  4. Bulk Upload of POI's

Bulk Upload of POI's

Scheduled Pinned Locked Moved [Web] Suggestions and Discussion
25 Posts 8 Posters 1.9k Views 6 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • Mzokkundefined Mzokk

    @Dikke-Wim you can also use Qgis to harvest POI's from OSM mapping.

    This is Castles for UK and Ireland.ksnip_20250113-163911.jpg

    You need two add ins to get the information QuickOSM
    Which gives a dialog like this.

    QuickOSM.jpg
    And POI exporter which allows export as a GPX file that MRA can read.

    POI Exporter.jpg

    Dikke Wimundefined Offline
    Dikke Wimundefined Offline
    Dikke Wim
    Valued contributor
    wrote on last edited by
    #10

    @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.

    BMW R1300 GS, BMW Connect Ride Next navigator; Quad Lock with Samsung Galaxy Ultra, iPad Pro (iPadOS 18.0 bèta version) MacBook Pro (MacOS Sequoia 15.2 bèta version), iMac (MacOS Monterey 12.7.6)

    Martin Wilckeundefined Mzokkundefined 2 Replies Last reply
    0
    • Dikke Wimundefined Dikke Wim

      @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.

      Martin Wilckeundefined Online
      Martin Wilckeundefined Online
      Martin Wilcke
      wrote on last edited by Martin Wilcke
      #11

      @Dikke-Wim @Mzokk

      Here's another attempt in three simple steps:

      1. Launch a query on overpass-turbo.eu

      Overpass-1.jpg

      1. export as gpx

      Overpass-2.jpg

      1. upload into MRA

      Overpass-3.jpg

      BertMundefined Dikke Wimundefined 2 Replies Last reply
      0
      • Martin Wilckeundefined Martin Wilcke

        @Dikke-Wim @Mzokk

        Here's another attempt in three simple steps:

        1. Launch a query on overpass-turbo.eu

        Overpass-1.jpg

        1. export as gpx

        Overpass-2.jpg

        1. upload into MRA

        Overpass-3.jpg

        BertMundefined Offline
        BertMundefined Offline
        BertM
        wrote on last edited by
        #12

        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.

        POIEXcel.JPG

        Greenhamundefined 1 Reply Last reply
        0
        • Martin Wilckeundefined Martin Wilcke

          @Dikke-Wim @Mzokk

          Here's another attempt in three simple steps:

          1. Launch a query on overpass-turbo.eu

          Overpass-1.jpg

          1. export as gpx

          Overpass-2.jpg

          1. upload into MRA

          Overpass-3.jpg

          Dikke Wimundefined Offline
          Dikke Wimundefined Offline
          Dikke Wim
          Valued contributor
          wrote on last edited by
          #13

          @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
          e39f2ddb-5d1a-447d-9a07-6b545ca257d5-image.png

          Cornwall without any castles
          9d561261-31ca-4173-94b3-d2512543137b-image.png

          BMW R1300 GS, BMW Connect Ride Next navigator; Quad Lock with Samsung Galaxy Ultra, iPad Pro (iPadOS 18.0 bèta version) MacBook Pro (MacOS Sequoia 15.2 bèta version), iMac (MacOS Monterey 12.7.6)

          Martin Wilckeundefined 1 Reply Last reply
          0
          • Dikke Wimundefined Dikke Wim

            @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
            e39f2ddb-5d1a-447d-9a07-6b545ca257d5-image.png

            Cornwall without any castles
            9d561261-31ca-4173-94b3-d2512543137b-image.png

            Martin Wilckeundefined Online
            Martin Wilckeundefined Online
            Martin Wilcke
            wrote on last edited by
            #14

            @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:
            UK Castles 1.jpg

            Imported:
            UK Castles 2.jpg

            Dikke Wimundefined 1 Reply Last reply
            0
            • Martin Wilckeundefined Martin Wilcke

              @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:
              UK Castles 1.jpg

              Imported:
              UK Castles 2.jpg

              Dikke Wimundefined Offline
              Dikke Wimundefined Offline
              Dikke Wim
              Valued contributor
              wrote on last edited by Dikke Wim
              #15

              @Martin-Wilcke

              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
              1b0ccb6d-7087-4a15-b18e-b45c0c2d965e-image.png

              No castles in Cornwall after importing the GPX file
              e6571a01-0273-4e94-9854-ccb350ee1905-image.png

              the KML file shows more castles in Google Earth than the GPX file in MRA

              8de64d6b-ea55-4f0d-8789-1b8ac9469b67-image.png

              BMW R1300 GS, BMW Connect Ride Next navigator; Quad Lock with Samsung Galaxy Ultra, iPad Pro (iPadOS 18.0 bèta version) MacBook Pro (MacOS Sequoia 15.2 bèta version), iMac (MacOS Monterey 12.7.6)

              Martin Wilckeundefined 3 Replies Last reply
              0
              • Dikke Wimundefined Dikke Wim

                @Martin-Wilcke

                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
                1b0ccb6d-7087-4a15-b18e-b45c0c2d965e-image.png

                No castles in Cornwall after importing the GPX file
                e6571a01-0273-4e94-9854-ccb350ee1905-image.png

                the KML file shows more castles in Google Earth than the GPX file in MRA

                8de64d6b-ea55-4f0d-8789-1b8ac9469b67-image.png

                Martin Wilckeundefined Online
                Martin Wilckeundefined Online
                Martin Wilcke
                wrote on last edited by
                #16

                @Dikke-Wim

                OK - let's focus on "Crane Castle" as an example; it's this one:

                crane 1.jpg

                Please have a look at the GPX you've uploaded with an editor and search for "Crane", there should be a match like this:

                crane 2.jpg

                In MRA, search for "Portreath" and zoom in to a scale of 1 km / 1 mile or less:

                crane 3.jpg

                Does it show up?

                1 Reply Last reply
                0
                • Dikke Wimundefined Dikke Wim

                  @Martin-Wilcke

                  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
                  1b0ccb6d-7087-4a15-b18e-b45c0c2d965e-image.png

                  No castles in Cornwall after importing the GPX file
                  e6571a01-0273-4e94-9854-ccb350ee1905-image.png

                  the KML file shows more castles in Google Earth than the GPX file in MRA

                  8de64d6b-ea55-4f0d-8789-1b8ac9469b67-image.png

                  Martin Wilckeundefined Online
                  Martin Wilckeundefined Online
                  Martin Wilcke
                  wrote on last edited by
                  #17

                  @Dikke-Wim

                  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.

                  1 Reply Last reply
                  0
                  • Dikke Wimundefined Dikke Wim

                    @Martin-Wilcke

                    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
                    1b0ccb6d-7087-4a15-b18e-b45c0c2d965e-image.png

                    No castles in Cornwall after importing the GPX file
                    e6571a01-0273-4e94-9854-ccb350ee1905-image.png

                    the KML file shows more castles in Google Earth than the GPX file in MRA

                    8de64d6b-ea55-4f0d-8789-1b8ac9469b67-image.png

                    Martin Wilckeundefined Online
                    Martin Wilckeundefined Online
                    Martin Wilcke
                    wrote on last edited by
                    #18

                    @Dikke-Wim

                    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:

                    UK Castles 3.jpg

                    Sorry for the confusion!

                    Dikke Wimundefined JP dundefined 2 Replies Last reply
                    0
                    • Dikke Wimundefined Dikke Wim

                      @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.

                      Mzokkundefined Online
                      Mzokkundefined Online
                      Mzokk
                      wrote on last edited by
                      #19

                      @Dikke-Wim Somewhat less work than the method you describe👍

                      Dikke Wimundefined 1 Reply Last reply
                      0
                      • Martin Wilckeundefined Martin Wilcke

                        @Dikke-Wim

                        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:

                        UK Castles 3.jpg

                        Sorry for the confusion!

                        Dikke Wimundefined Offline
                        Dikke Wimundefined Offline
                        Dikke Wim
                        Valued contributor
                        wrote on last edited by
                        #20

                        @Martin-Wilcke

                        Thanks Martin. It works now much better (see below).
                        f45a36c1-6b9e-41bd-ba3c-03809ef23506-image.png

                        BMW R1300 GS, BMW Connect Ride Next navigator; Quad Lock with Samsung Galaxy Ultra, iPad Pro (iPadOS 18.0 bèta version) MacBook Pro (MacOS Sequoia 15.2 bèta version), iMac (MacOS Monterey 12.7.6)

                        Martin Wilckeundefined 1 Reply Last reply
                        0
                        • Mzokkundefined Mzokk

                          @Dikke-Wim Somewhat less work than the method you describe👍

                          Dikke Wimundefined Offline
                          Dikke Wimundefined Offline
                          Dikke Wim
                          Valued contributor
                          wrote on last edited by
                          #21

                          @Mzokk

                          What method do you mean? I don't get it.
                          For me: the easier the better!

                          BMW R1300 GS, BMW Connect Ride Next navigator; Quad Lock with Samsung Galaxy Ultra, iPad Pro (iPadOS 18.0 bèta version) MacBook Pro (MacOS Sequoia 15.2 bèta version), iMac (MacOS Monterey 12.7.6)

                          1 Reply Last reply
                          0
                          • Dikke Wimundefined Dikke Wim

                            @Martin-Wilcke

                            Thanks Martin. It works now much better (see below).
                            f45a36c1-6b9e-41bd-ba3c-03809ef23506-image.png

                            Martin Wilckeundefined Online
                            Martin Wilckeundefined Online
                            Martin Wilcke
                            wrote on last edited by
                            #22

                            @Dikke-Wim
                            👍

                            1 Reply Last reply
                            0
                            • Martin Wilckeundefined Martin Wilcke

                              @Dikke-Wim

                              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:

                              UK Castles 3.jpg

                              Sorry for the confusion!

                              JP dundefined Offline
                              JP dundefined Offline
                              JP d
                              wrote on last edited by
                              #23

                              @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. 🙏

                              1 Reply Last reply
                              0
                              • BertMundefined BertM

                                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.

                                POIEXcel.JPG

                                Greenhamundefined Offline
                                Greenhamundefined Offline
                                Greenham
                                wrote on last edited by
                                #24

                                @BertM

                                Yes this is what I am trying to do. Add my own POI's

                                BertMundefined 1 Reply Last reply
                                0
                                • Greenhamundefined Greenham

                                  @BertM

                                  Yes this is what I am trying to do. Add my own POI's

                                  BertMundefined Offline
                                  BertMundefined Offline
                                  BertM
                                  wrote on last edited by
                                  #25

                                  @Greenham said in Bulk Upload of POI's:

                                  @BertM

                                  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
                                  *

                                  55fe76c9-4529-4956-aa88-187b6e52461c-image.png

                                  3rd Item in the list selected and button "Show in Google Maps" selected

                                  e23dc9f7-65d3-43b3-9234-a73992e056d5-image.png

                                  Import in MRA from GPX file
                                  108d4b72-58e8-4f93-996c-5a584a2aa1d3-image.png

                                  Import in Basecamp with selected symbol
                                  c26cd62c-f8ee-4dff-9e24-924ad4cc7c21-image.png

                                  Data added in Excel and transferred to Garmin GPX, see also the different symbols in the same GPX

                                  c3212141-58ca-4b2b-b383-37443fec46e0-image.png

                                  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

                                  1 Reply Last reply
                                  1
                                  Reply
                                  • Reply as topic
                                  Log in to reply
                                  • Oldest to Newest
                                  • Newest to Oldest
                                  • Most Votes


                                  • 1
                                  • 2
                                  ACTIVE USERS
                                  Mzokkundefined
                                  Mzokk
                                  BertMundefined
                                  BertM
                                  Adrian Avramundefined
                                  Adrian Avram
                                  Dikke Wimundefined
                                  Dikke Wim
                                  Nomko Nomdenundefined
                                  Nomko Nomden
                                  JP dundefined
                                  JP d
                                  Martin Wilckeundefined
                                  Martin Wilcke
                                  Greenhamundefined
                                  Greenham
                                  POPULAR TOPICS
                                  • Herberekenen route
                                    Con Hennekensundefined
                                    Con Hennekens
                                    0
                                    17
                                    181

                                  • iets gekst bij export
                                    Arjan de Vriesundefined
                                    Arjan de Vries
                                    0
                                    6
                                    75

                                  • MRA use on 2000 mile trip
                                    Corjan Meijerinkundefined
                                    Corjan Meijerink
                                    3
                                    5
                                    76

                                  • Android Auto bugs and improvements
                                    Corjan Meijerinkundefined
                                    Corjan Meijerink
                                    2
                                    7
                                    294

                                  • Reverse your route?
                                    Matthew Perkins 0undefined
                                    Matthew Perkins 0
                                    0
                                    3
                                    4

                                  • Route recalculation
                                    ginoginoundefined
                                    ginogino
                                    -1
                                    3
                                    28

                                  • Silverfox H1+ long-press
                                    Marinus van Deudekomundefined
                                    Marinus van Deudekom
                                    0
                                    12
                                    127

                                  • Newcomer
                                    paul69undefined
                                    paul69
                                    0
                                    11
                                    176
                                  MY GROUPS
                                  • Login

                                  • Login or register to search.
                                  • First post
                                    Last post
                                  0
                                  • Categories
                                  • Recent
                                  • Popular
                                  • Support
                                  • MyRoute-app