A friend sent me a set of GPX files of a round the world cycle trip and asked me whether I could add the towns travelled through to this GPX as waypoints.
The best I could manage was to use the geonames data set http://www.geonames.org/ and filter the records to feature_type = 'P' for populated places. I then picked every one within 1 kiometer of the GPX track.
This is obviously not ideal as it only shows the places the route goes close to and the geonames set is a point set.
Could I have done this better using town/city boundaries in Openstreetmap?
Also, how would you write such a query, my approach was:-
split the GPX into constituent line stringsfind nearest geoname to line string using operatoroutput geonameThis was necessary as the GPX is a multi-linestring with split lines (ocean crossings)
أكثر...
The best I could manage was to use the geonames data set http://www.geonames.org/ and filter the records to feature_type = 'P' for populated places. I then picked every one within 1 kiometer of the GPX track.
This is obviously not ideal as it only shows the places the route goes close to and the geonames set is a point set.
Could I have done this better using town/city boundaries in Openstreetmap?
Also, how would you write such a query, my approach was:-
split the GPX into constituent line stringsfind nearest geoname to line string using operatoroutput geonameThis was necessary as the GPX is a multi-linestring with split lines (ocean crossings)
أكثر...