Answers to: Best way to get all cities of a specific area?<p>I'm just starting to play with the databases (Nominatim, Mapnik), but I'm a little bit confused about such an easy task: <em>"How to get a list of all cities in Germany?"</em></p> <p><strong>Nominatim:</strong> It could be so easy, but of course it is not. If I search all states of Germany, I get a only 13 back (of 16!). Why? Because the others do have "Deutschland" instead of "Germany" in their "isin"-column or just nothing.</p> <p><strong>Mapnik:</strong> I suppose the "savest" way would be to find all city-Points inside the "Germany"-polygon? But I can't even find the Germany-polygon. I only found the Germany-point. How do I do this?</p> <p>Or am I doing it totally wrong? What would be your approach?</p>enThu, 03 May 2012 09:41:53 +0100Comment by NicolasDumoulin on Frederik Ramm's answer<p>Mapnik is out of point here. Mapnik is the software used for rendering the data from a postgis database. You need to import the OSM data in a postgis database.</p>NicolasDumoulinThu, 03 May 2012 09:41:53 +0100 by np00 on Frederik Ramm's answer<p>Because I'm planning to get used to the databases, I will focus on the first approach.</p> <p>Is my assumtion for the mapnik-database true? Could you help/lead me with that?</p> <p>Thanks for the quick response!</p>np00Fri, 27 Apr 2012 12:30:01 +0100 by Frederik Ramm<p>Several possible approaches:</p> <ol> <li>Import data into database then make queries, like you tried.</li> <li>Don't import data but instead use someone else's database - see XAPI or Overpass. (The latter can indeed limit a search to a boundary polygon, and an easy way of finding the Germany relation is typing "openstreetmap relation germany" into Google.)</li> <li>Don't use a database at all; download a suitable extract (e.g. from, cut out an area if required using osmosis or similar (not required if you want all of Germany since there's already an extract for that), and then use osmosis or osmfilter to extract the objects you need.</li> </ol>Frederik RammFri, 27 Apr 2012 12:20:02 +0100