OpenStreetMap標誌 OpenStreetMap

One of my ambitions is to produce a gazetteer of Ashgabat street names so that staff of my embassy (and other foreigners) know for whom or what the streets are named. That would provide insights into local culture as well as merely be interesting for those of us with well honed sense of curiosity. Overpass Turbo provides the tool for generating a list of Ashgabat street names, with the following script:

[out:csv(“name:tk”;false)]; area[name~”Aşgabat”]; way(area)[highway][name]; out;

I imported the generated list into Excel and applied the filter for removing duplicates (easy to do in a spreadsheet), and discovered that this is an excellent tool for identifying misspellings of street names and other anomalies! I’ve spent a little time cleaning up the street names in Ashgabat, as a result, and am now prepared to start work on a gazetteer.

電郵圖示 Bluesky圖示 Facebook圖示 LinkedIn圖示 Mastodon圖示 Telegram圖示 X圖示

討論

philippec2017年8月30日19:18發表的評論

I could try to understand the overpass statement looking in the documentation. But that would take time and effort. Could you translate it in pseudo language please ?

apm-wa2017年8月31日01:24發表的評論

Take a look at Overpass Turbo here: http://overpass-turbo.eu/

The wiki article on it is here: osm.wiki/Overpass_turbo

I am not fluent in the script language myself, but the instructions appear to direct Overpass Turbo to

  1. generate a .csv file consisting of the Turkmen names of specified ways,
  2. apply a filter (only include ways inside Ashgabat)
  3. apply a second filter (only include highways)
  4. send output to the screen

登入以留言