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 2.0k 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.
  • 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 Offline
      Martin Wilckeundefined Offline
      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 Offline
          Martin Wilckeundefined Offline
          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 Offline
            Martin Wilckeundefined Offline
            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 Offline
              Martin Wilckeundefined Offline
              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 Offline
                Mzokkundefined Offline
                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 Offline
                      Martin Wilckeundefined Offline
                      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
                            • verschil gpx bestand MRA uit windowscomputer en android app
                              Con Hennekensundefined
                              Con Hennekens
                              0
                              12
                              158

                            • Route recalculation
                              ginoginoundefined
                              ginogino
                              0
                              13
                              287

                            • Merge two tracklogs?
                              Con Hennekensundefined
                              Con Hennekens
                              0
                              5
                              57

                            • Via punt overgeslagen?
                              Corjan Meijerinkundefined
                              Corjan Meijerink
                              0
                              4
                              29

                            • Tracklog anders bij gebruik als laag bij maken route
                              Con Hennekensundefined
                              Con Hennekens
                              0
                              6
                              172

                            • Looks van de maps
                              Rob Verhoeffundefined
                              Rob Verhoeff
                              0
                              6
                              334

                            • MRA op Android Auto gebruikt muziekkanaal i.p.v. spraakkanaal
                              undefined
                              0
                              1
                              15

                            • Carpuride verbetert het software update proces
                              versluisundefined
                              versluis
                              1
                              2
                              81
                            MY GROUPS
                            • Login

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