search

prograhammer / countries-regions-cities

MySQL ready-to-use tables with countries, regions/states and cities of the world.
358 stars 139 forks source link

Redundant Cities #7

Open fezanqadirbhatti opened 6 years ago

fezanqadirbhatti commented 6 years ago

There are multiple occurrences of same cities with different latitude and longitude. It show millions of cities records in the world. There are 27,74,830 records in the cities table while there are 20,77,157 unique city records.

zoltiecodes commented 6 years ago

Hi. I bet this is because multiple cities may exist in the world with the same name. Search for Vernon for example in Google Maps.

hjJunior commented 6 years ago

But there are some empty cities that repeat many times