OpenStreetMap

Importing collected waypoints II or: another CSV2OSM-script

Posted by malenki on 12 September 2013 in English (English)

(This is the continuation of Importing collected waypoints I)

Now you have a complete list with lat;lon;key;value (and maybe some more key;values).
Next step: convert the csv file to osm data. For this writeup I just wrote a small script to avoid my even more ugly oneliners and to have my efforts saved to be reused the next time I need this functionality.
so run
$ csv2osm.sh appended_lower_sort.csv > output.osm

Better save then sorry, so create a backup of the file created: $ cp output.osm output.osm.bckp

Open this file with JOSM - the easiest way is also the bash:
$ josm output.osm

Now tackle the data region by region. Do it like this:

  • copy a handful of POI
  • create a new datalayer
  • paste the POI
  • download the data for that region
  • review the POI: adjust them using aerial imagery or GPS data, check for already existing objects and so on
  • upload
  • delete the active datalayer
  • delete the still marked POI from the original datalayer you copied them from
  • press ctrl-s to save your progress of wading through the data of output.osm

Go on until no data in the output.osm file is left and enjoy yourself. :)

Location: SH81, Sarandë, Vlorë County, 9701, Albania

Comment from escada on 13 September 2013 at 03:50

I use a similar approach, however I wrote a python script that transforms the gpx file with the waypoints immediately into an osm file. During this translation I also expand the short notation into the proper OSM tags (e.g. BK --> amenity=bench, L20+-+28 --> 5 nodes with building=house;addr:housenumber=20 + building=house;addr:housenumber=22 ... up to 28 etc.

I add the extra information that you add in OpenOffice, immediately in JOSM.

You can find my script at http://funky-osm-foto.blogspot.be/2013/03/weekend-projectje.html The explanation is in Dutch, but it's about the script.

Feel free to adapt if you find this useful.

Comment from malenki on 13 September 2013 at 17:49

Thanks for your comment - your script looks very useful for self-diciplined mappers or a dedicated mapping task. But during my holidays I collect a big variety of things so I cannot say I'd replace $A with $B.

Login to leave a comment