countries-regions-cities icon indicating copy to clipboard operation
countries-regions-cities copied to clipboard

Published 20 hours ago • verified publisher icon prograhammer

Redundant Cities

Open fezanqadirbhatti opened this issue 6 years ago • 2 comments

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.

fezanqadirbhatti avatar Aug 24 '18 21:08 fezanqadirbhatti

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.

zoltiecodes avatar Sep 09 '18 14:09 zoltiecodes

But there are some empty cities that repeat many times

hjJunior avatar Sep 09 '18 14:09 hjJunior