POI Editor and converter

[BertM]

After starting with Excel to convert POI I have changed to Java script in Google Sheets.
The main reason is that I do not have Excel on my home computer, but have a google account.
pre is that I can convert the POI data everywhere when there is a computer available, downside is that you need a Google account.
After some playing around and some help from my new friend Chatgpt I have managed to do the following in Google sheets:

• Import and export KML and GPX files.
  Import is done from a folder Named "Import" in Google Drive.
  Export can be done to Google Drive and downloaded.
  (Import from the computer gave some issues and unstability due to the restrictions of Google to import files
  into the server side, so I removed this function.)

• Geocode the sheet with name, address, city and country with the help of Google.

  • Geocode for the Garmin navi, Google MyMaps etc with different fields
    (Google only fills in the field known to the coordinates, so sometimes not all the field are inserted.)
  • Geocode for MRA in the Name field of the GPX, as MRA only imports this field.:
    Brackets can be inserted after the name and the address in inserted between the brackets.
    The color of the address can be changed for better visibility in the Sheet.

Geocoding can be done on a single field or on multiple fields.

• Check the POI in Google Maps

I am not a programmer, so the programm is not 100% but it does what it needs to do.

If there is interest in the program I can post it on Github and share the Google Sheet, but I then must add some documentation to it.
So if more then 5 people are interested I will do the above effort

some screen shots:

Imported file

file menu

Geocode the first 5 rows by selecting Latitude and Longitude

"Special MRA tools" to fill in address in the Name field.

Screenshot with added address in namefield ( in different colors) and the export dialog.

POI GPX imported in MRA where in the Namefield the address is added between brackets.

[Con Hennekens]

This sounds a lot like my PQ2POI effort, but I made it into a webservice.
https://forum.myrouteapp.com/post/69311

Would people be interested in a web-solution for this? upload POI, enrich with address, combine it in the namefield). I could give it a try.

[BertM]

@Con-Hennekens said in POI Editor and converter:

This sounds a lot like my PQ2POI effort, but I made it into a webservice.
https://forum.myrouteapp.com/post/69311

Would people be interested in a web-solution for this? upload POI, enrich with address, combine it in the namefield). I could give it a try.

I have seen your PQ2POI, looks nice.
I have no webspace, so that is why I use Google sheets for it. Are you using a database for the convertion?

[Con Hennekens]

@BertM, No, it is plain HTML5. But for a solution like yours at least some python code must be used, or a backend to run a script. Nominatim is an API service that could be used freely to geocode, but it is throttled to 1 lookup per second...

[Nick Carthew]

@Con-Hennekens said in POI Editor and converter:

@BertM, No, it is plain HTML5. But for a solution like yours at least some python code must be used, or a backend to run a script. Nominatim is an API service that could be used freely to geocode, but it is throttled to 1 lookup per second...

I understand more when you write in Dutch

[Con Hennekens]

@Nick-Carthew said in POI Editor and converter:

I understand more when you write in Dutch

Somehow I don't think my lack of English is the cause for that...

[Hubert Thoring]

Hey,
ich wäre gerne dabei !!! VG

I would love to participate !!! Best regards

[Con Hennekens]

@BertM, could you show me the source or link of that POI file? Many sources claim to offer biker(friendly) facilities, but a list for all of europe would be very handy.

[BertM]

@Con-Hennekens
It just a small file I use for testing:
https://www.motorhotels.info/poi