NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

Hello!

I'd like to export a list of the 100 biggest towns/cities of each country.

The result should be a csv-file with the columns:countrycode,townname,population,latitude,longitude

How would i do that?

asked 26 Aug '13, 14:59

mawe4585's gravatar image

mawe4585
16111
accept rate: 0%


You're going to have to create this export yourself, though I suspect the data isn't there. Population doesn't seem like data which would be added to OSM (whether political or practical).

If the data does exist, then you'll likely be using the Overpass API. This is a query language for accessing/filtering the OSM data.

Other options may include going all the way down and using Osmium.

I'm not well versed in the types of data requests which can be made, the choices seem slim and Overpass seems to be the most comprehensive and user friendly.

permanent link

answered 27 Aug '13, 02:39

he_the_great's gravatar image

he_the_great
1.2k61423
accept rate: 14%

Please do a search on this FAQ site about "export, data, csv, list, places" or similar keywords.

There are already questions like yours, and answers as well.

permanent link

answered 26 Aug '13, 16:42

stephan75's gravatar image

stephan75
12.6k556210
accept rate: 6%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×315
×58
×42
×18

question asked: 26 Aug '13, 14:59

question was seen: 7,385 times

last updated: 01 Sep '13, 00:08

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum