Say that you have a list of cities in Excel and need to know the latitude and longitude for each city. Price: 1 dollar per 1000 cities.In 1998-2003 I also wrote lists of natural features, seas, rivers, etc, and astronomy-related stuff…. If you have the new features, read on. The database contains locations by country, city, latitude and longitude. Do you have ideas for a new drawing, database, or article that may be useful to thousands readers?Don’t go away… just tell your requirements, what I don’t HAVE I can MAKE for you and future customers. geodatasourceNow, my plan is to take open data from government websites (or scrap from Wikipedia for countries where there is no data available from government), Hello you have a database with all the world’s countriesDo you mind if I quote a few of your articles as long as I provide credit and sourcesChat started on Monday, October 08, 2018 2:17:07 PM(2:17:07 PM) *** Visitor 91355061 has joined the chat ***There are no cities listed in the US state of Mississippi as having more than 100,000, however Jackson, the states capitol city, has a population of 160,000+/-.Can you take a look again? Along people who contacted me, were some asking for free databases (disrespecting my efforts) or some willing to pay but far more data that I could offer myself. Today I consider them useless because such info exist for FREE on Wikipedia and is not necessary to make my own databases.Does anyone know where I can find a complete list of US counties and cities? Consequently, number of cities in each country is nearly proportional with country urban population, in average for every 800,000 country population living in urban areas, there is 1 city over 100,000 people.Geography fascinated me since kindergarten years, studying the geographic atlases I had at home, at 6 years old I already knew all countries, capitals and other major cities. Column A is a Consolidated Invoices of different Country's Company. I have trailer group numbers: Did you found broken links or errors that need correction? geodatasourceNow, my plan is to take open data from government websites (or scrap from Wikipedia for countries where there is no data available from government), Hello you have a database with all the world’s countriesDo you mind if I quote a few of your articles as long as I provide credit and sourcesChat started on Monday, October 08, 2018 2:17:07 PM(2:17:07 PM) *** Visitor 91355061 has joined the chat ***There are no cities listed in the US state of Mississippi as having more than 100,000, however Jackson, the states capitol city, has a population of 160,000+/-.Can you take a look again? The main difference between the two is that the Pro database generally only includes cities and towns that either have a The database includes data on 248 countries. Cities Databases by Country We're happy to offer free world cities databases (by country). Based on feedback from customers, I realized that most purchased city database for web development, making drop-down boxes for country > state / province / region / county >  city… thus population figures are not required, but classifying cities by population is helpful to shortlist database to major cities if you need.Sales of city database been far lower than other databases made by me, but they rose in 2020 and if more people continue to buy it AND require more cities, I can expand database including also cities with population 20,000 – 100,000 from North and South America, China, India, Pakistan, Bangladesh, etc, which may raise number of rows in database to about 15,000-20,000 cities.Cities are classified according icons used by Encarta Encyclopedia 2009, the icons do not always reflect population indicated in city article. Excel ® is a registered trademark of the Microsoft Corporation. Encarta Encyclopedia 2009 provide 2007 estimates for most cities over 500,000 people, while for smaller cities it usually indicate population from last census.Microsoft discontinued Encarta, both CD / DVD and online version, but there are many third-party websites where you can The database does NOT indicate cities administrative status, which vary from country to country so making a single worldwide database of official “cities” excluding towns, communes, villages and other places pose major troubles, especially since few countries does not have any “city”.Classifying cities according Encarta Encyclopedia helped me to make a harmonized database all over the world. If you’re looking for the an excel versionRead More Please find attached the excel I've described the situation there for your convenience. Also playing games with buildings.I made this website in 2009 to share knowledge and educational material, sell my works and promote my services, and make new (business) friends.By today it grew to over 100 pages based on suggestions and project requests from people like YOU!