Is it possible to import a list of POI from a spreadsheet?

107 views
Skip to first unread message

Boris Feldblyum

unread,
May 27, 2019, 10:36:26 AM5/27/19
to Osmand

I am planning a trip across several states (US) and would like to make a list, with street addresses of sites to see. Is it possible to import the list into OSMAND? As one layer? As one layer per state?
Thank you!

Helmut Jarausch

unread,
May 27, 2019, 1:18:16 PM5/27/19
to osm...@googlegroups.com
Have a look at the file favourites.xml in OSMAND data folder. 
You have to extend this file with entries like, where you have to modify lat / lon, 
the name tag, the type tag and the color tag. 
Mind to insert your entries before the final
</gpx> tag. 


<wpt lat="50.99739" lon="0.597532">
    <name> "Great Dixter House" </name>
    <type>Name of my Collection</type>
    <extensions>
      <color>#f08c00</color>
    </extensions>
  </wpt>

Boris Feldblyum <boris2.f...@gmail.com> schrieb am Mo., 27. Mai 2019, 15:36:

I am planning a trip across several states (US) and would like to make a list, with street addresses of sites to see. Is it possible to import the list into OSMAND? As one layer? As one layer per state?
Thank you!

--
You received this message because you are subscribed to the Google Groups "Osmand" group.
To unsubscribe from this group and stop receiving emails from it, send an email to osmand+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/osmand/a037941c-6445-40b1-a7bf-6d929e8820b4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Boris Feldblyum

unread,
May 27, 2019, 1:55:22 PM5/27/19
to Osmand
Thank you, Helmut for taking the time to reply.

Unfortunately, I am not a programmer and do not understand your advice and what to do.

Here is what I did and what am trying to do right now.

I tried to add a friend’s address as point of interest (POI) on both OSMAND and MAPS.ME while the apps were open but neither worked.  I think MAPS.ME allowed me to view the entire street but no house number.

I did the same on Google/MYMAPS and there it worked. In total, I put 3 test POI on the map, across several US states and then exported the data into a KML file - on my desktop.

Next, I emailed the file to myself.

Next, I touched-opened it on my Android phone. The MAPS.ME icon appeared. I assumed it meant that MAPS.ME imported the KLM data, but I could net see the POI on the map.

If I uninstall MAPS.ME from my phone, will OSMAND automatically open/import KLM data?

Thank you!



On Monday, May 27, 2019 at 1:18:16 PM UTC-4, Helmut Jarausch wrote:
Have a look at the file favourites.xml in OSMAND data folder. 
You have to extend this file with entries like, where you have to modify lat / lon, 
the name tag, the type tag and the color tag. 
Mind to insert your entries before the final
</gpx> tag. 


<wpt lat="50.99739" lon="0.597532">
    <name> "Great Dixter House" </name>
    <type>Name of my Collection</type>
    <extensions>
      <color>#f08c00</color>
    </extensions>
  </wpt>

Boris Feldblyum <boris2....@gmail.com> schrieb am Mo., 27. Mai 2019, 15:36:

I am planning a trip across several states (US) and would like to make a list, with street addresses of sites to see. Is it possible to import the list into OSMAND? As one layer? As one layer per state?
Thank you!

--
You received this message because you are subscribed to the Google Groups "Osmand" group.
To unsubscribe from this group and stop receiving emails from it, send an email to osm...@googlegroups.com.

J Albrecht

unread,
May 27, 2019, 2:46:22 PM5/27/19
to osm...@googlegroups.com
Hello Boris,

Perhaps the following may help:

POI

“Point of Interest” files can be imported into OsmAnd and saved as “Favourites”. 
Suitable import files include:
  • kml
  • gpx

kml

  • Create or download a kml file containing POI references.
  • Save the file on the Android device
  • Open the file with OsmAnd
  • This should happen automatically. If not, choose “Open with…”
  • Open “My Places”. The kml file will be loaded into  Import > Tracks
  • Select the file.
  • Touch the “3 Vertical Dots” icon to the right off the Search icon
  • Select “Add to Favourites”
  • Activate the “Points” check box
  • Touch the Favourites icon (the Star)
  • IMPORTANT: Define the name for this group of favourites

If the above steps are not followed precisely, the POIs will not be saved to a Favourites group. Rather, every POI within the imported kml file will be saved as an individual file in the general “Favourites” folder

gpx

POIs can be created from gpx files which are either self-created or downloaded from Google Maps




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

To unsubscribe from this group and stop receiving emails from it, send an email to osmand+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/osmand/3674db7c-cbb5-4c88-8520-51bd5b81a49e%40googlegroups.com.
signature.asc

Helmut Jarausch

unread,
May 27, 2019, 4:53:53 PM5/27/19
to osm...@googlegroups.com
Hi, you don't need to programme anything. You can transfer the file favourites.gpx from your mobile (<SDCARD>/Android/data/net.osmand.plus/files/favourites.gpx) to your PC. There you can use a text editor (or spreadsheet software) to generate the entries mentioned in my previous mail. Again, using a text editor you can add (all of) your entries before the last line (containing </gpx>).
Then copy this modified file to your mobile at the very same place where got it from. The term <SDCARD> has to be replaced by either your internal or external SD card depending on where OSMAND has stored this file and maps, etc. 


To unsubscribe from this group and stop receiving emails from it, send an email to osmand+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/osmand/3674db7c-cbb5-4c88-8520-51bd5b81a49e%40googlegroups.com.

HH P

unread,
May 28, 2019, 2:58:46 PM5/28/19
to Osmand
Search csv 2 gpx in Google. You will find several programs or websites that solve your problem.

Harald R.

unread,
Jun 8, 2019, 2:54:24 AM6/8/19
to Osmand
You have to perform 4 steps to achieve this:
1. geocode your address data, meaning to convert the address into geographical coordinate (longitude, latitude)
2. from this data create a gpx file (gpsvisualizer can do this too)
3. transfer the gpx file to the OSMAND folder into the subfolder \tracks\import
4. activate the gpx file in OSMAND configure Map / gpx files

Am Montag, 27. Mai 2019 16:36:26 UTC+2 schrieb Boris Feldblyum:
Reply all
Reply to author
Forward
0 new messages