On Tue, 28 Oct 2008 01:17:28 -0700 (PDT) Came this utterance fomulated by oi_antz to my mailbox:
> > I've had several projects needing a database of countries and cities, > and all I can find are excessively comprehensive databases such as > geodatasource. The sheer volume of cities (2 million+) in those > databases is far too big and keeps crashing the browser when I try to > populate the city select menu with ajax when the country is selected. > > What I'm looking for is all countries and major cities/towns for each > country, say with a criteria of >20,000 population or 2500km2 land > mass. This should remove all villages from the results and should > return just the major centres. > > Can anyone recommend where to get such a database? I don't mind paying > for it. I just need the Country title and ISO code and city titles > with corresponding country id. > This is a free txt cities database of 33MB, approximately 2,710,000 records, but you could sort on population. http://www.maxmind.com/app/worldcities -- Michael All shall be well, and all shall be well, and all manner of things shall be well - Julian of Norwich 1342 - 1416 --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
