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.

Discussion

Comment from philippec on 30 August 2017 at 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 ?

Comment from apm-wa on 31 August 2017 at 01:24

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

The wiki article on it is here: http://wiki.openstreetmap.org/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

Log in to leave a comment