cities50000.zip

Phil

unread,

Nov 7, 2023, 11:38:11 AM11/7/23

to GeoNames

Hi,

how could i create a cities50000.zip with population > 50000

https://download.geonames.org/export/dump/
Is there a download area with more files like that?

Thank you

barryhunter

unread,

Nov 7, 2023, 2:16:10 PM11/7/23

to GeoNames

Well could just download the 'allCountries.zip' file, and filter that.

Definitely should read https://download.geonames.org/export/dump/readme.txt

... that notes now the existing 'cities' files where created, so could do something similar

Including how to choose what cities to include (eg the top 50k by population)

Phil

unread,

Nov 8, 2023, 5:50:14 PM11/8/23

to GeoNames

I downloaded the cities15000.zip file and started to remove 50% of the file and tried to import it do my django-cities project.
But ones I started to make the file smaller I am ending up with errors during the import.

I suppose that there are cross references within the lines.

So how can i filter correctly?

barryhunter

unread,

Nov 8, 2023, 6:09:48 PM11/8/23

to GeoNames

Hmm, the cities files are just a list of gazetteer entries. Individual places. Large population centers. A filtered subset of the full geonames gazetteer table.

Don't think the table as any explicit cross-references. Any real admin hierarchy is not in the cities file alone, that sort of data comes from other files.

I don't know what the error you saw are, but perhaps it expecting a certain number of cities in particular countries. You removed too many?

Or maybe it expecting at least one PPLA per country, and you happened to remove them? (there may be seats with less than 50k pop)

If filtering by population, may want to also make sure NOT filtering PPLA*/PPLC records? (in the featurecode column)

Reply all

Reply to author

Forward