I created a map of points of interest around my home. This map is shared with a community. Members of this community are not familiar with OpenStreetMap, but can indicate new points of interest via a Google form. So I created a tool that allows, from the list generated by the form, to update the updated list of points of interest in a CSV file containing: name, description, longitude and latitude.
Of course, I can update my map by editing it and loading my new POI file. I thought it would be much more convenient to be able to add this file as a parameter of my map because then with my tool even people without special knowledge of openstreetmap could update the map. I consulted in the support section of the uMap user documentation the part named “advanced”, but I can’t get an automatic update of my map regarding the list of POIs. Either the file is ignored, or I get a message indicating a lack of geographic information. I should probably add a reference to my map in my file, but I don’t know how to do it.
I hope you can explain to me that it is not possible to do what I dreamed of or explain to me how to achieve it.
Thank you for your feedback.
Sorry I forget to set umap in my subject and I don’t how I can add it.
As suggested by Vinzenz_Mai, I tested the remote data, but my csv file which only contains my list of POIs is not compatible. I get the following error message: “Unknown geometry type ignored: features as displayed (in French) in my screenshot.”
Hi, @alan_gr, yes, my CSV file works fine when I upload it manually.
@Vinzenz_Mai, I am not able to open your link because I havent the right access.
I thought about linking it remotely because many community members are not computer literate. Thanks to my development, it is possible to update the CSV file based on the current content of the Google Form. Thus, without any prior knowledge, provided that the file describing the POIs can be dynamically loaded, any community member could update the map. This is why I mentioned a “dream” in the topic of my discussion.
I think umap may need the .csv extension to interpret the file type. I don’t see that in your screenshot but I’m not sure if that is the full link.
Thank you Vinzenz_Mai.
So I don’t know why I get the error on my side.
My csv file is stored on a google drive. Is it the problem ?
I have to check, but that’s the limit of my skills.
Nevertheless, again, thank you fot your help.
Thank Alan.
It is exactly what I want to do but my file doesn’t work while csv file with same data format works on the example of Vinzenz.
Access to the file is ok. So I have to look somewhere else.
Nevertheless, again, thanks Alan for your help.
You need to share in exactly the right way, by publishing to the web. I don’t think it is possible to do this directly from Drive. The only way I found was to do this was to open the file in Sheets and find Publish to the Web in the File menu. The link should end with “output=csv”
Thanks a lot Vinzenz and Alan,
It works also on my side.
Now I have to find a way to open automatically the Google Sheet with a macro in Libre Office. But that is another question.
Again Thanks a lot for your help and your reactivity.
Jacques
