This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

Obtain relation ID from city name in a spreadsheet

Hi,

I have a spreadsheet where in column A are listed some italian cities, is there a formula that can retrieve the relation ID of that city automatically? To do it I'm actually going to nominatin, searching the city, select first result and copy the relation ID. Is there a way to automate this work?

example:

COLUMN A COLUMN B

Milano 44915

L'Aquila 41842

Nissoria 39323

Thanks

nominatim spreadsheet relations id

asked 25 Apr '19, 16:32

volo86
36●2●2●4
accept rate: 0%

One Answer:

This could, on the Unix command line, be achieved by a combination of using curl to send a request to Nominatim followed by processing the JSON result with the jq utility, for example:

curl -s "https://nominatim.openstreetmap.org/search?q=Milano&format=json" | 
  jq '.[] | select(.class=="place") | select(.type=="city") | 
    select(.osm_type=="relation").osm_id'

You might have to toy with the jq expression a bit to achive the best result. Of course, you can do the same in a programming language of your choice - "request this URL", "decode JSON", "find objects that are cities", "extract their osm_id" - this should be possible with most common scripting languages.

answered 25 Apr '19, 20:15

Frederik Ramm ♦
82.5k●92●720●1273
accept rate: 23%