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 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
                        Adrian Avramundefined
                        Adrian Avram
                        Nomko Nomdenundefined
                        Nomko Nomden
                        Mzokkundefined
                        Mzokk
                        BertMundefined
                        BertM
                        Dikke Wimundefined
                        Dikke Wim
                        JP dundefined
                        JP d
                        Martin Wilckeundefined
                        Martin Wilcke
                        Greenhamundefined
                        Greenham
                        POPULAR TOPICS
                        • Scenic routing & RouteXpert library improvements
                          Albert van den Elsenundefined
                          Albert van den Elsen
                          6
                          12
                          461

                        • Scherm indeling MRA routeplanner
                          Corjan Meijerinkundefined
                          Corjan Meijerink
                          0
                          6
                          45

                        • Traag web en Android.
                          Corjan Meijerinkundefined
                          Corjan Meijerink
                          0
                          3
                          37

                        • Route crash on pc
                          Corjan Meijerinkundefined
                          Corjan Meijerink
                          0
                          3
                          40

                        • Myroute-app routeplanner
                          Stanisławundefined
                          Stanisław
                          0
                          5
                          145

                        • Trace en rouge
                          Con Hennekensundefined
                          Con Hennekens
                          0
                          2
                          23

                        • Tracklog lost
                          Stanisławundefined
                          Stanisław
                          0
                          7
                          222

                        • DMD T665 Phone + MyRoute App?
                          Guzzistundefined
                          Guzzist
                          0
                          4
                          135
                        MY GROUPS
                        • Login

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