countries-states-cities-database
countries-states-cities-database copied to clipboard
Data inconsistencies
Some states of countries have the same name, but different code That is creating issues on import, since I have a unique column on state + country_id
State Chiayi of country Taiwan
Array
(
[name] => Chiayi
[code] => CYI
[lat] => 23.45184280
[lng] => 120.25546150
)
vs
Array
(
[name] => Chiayi
[code] => CYQ
[lat] => 23.48007510
[lng] => 120.44911130
)
State Sana'a of country Yemen
Array
(
[name] => Sana'a
[code] => SN
[lat] => 15.31689130
[lng] => 44.47480180
)
vs
Array
(
[name] => Sana'a
[code] => SA
[lat] => 15.36944510
[lng] => 44.19100660
Probably an oversight, and they indeed have at least some difference in name?
@dereuromark Thanks for reporting. Btw, are there any other occurrences of similar issues? I will take a look at it, and get back to you soon.
Rest seems fine Some few States dont have geo data however
My report says ~60 of 5000:
Missing lat/lng for Saint George Parish of country Antigua And Barbuda, skipping
Missing lat/lng for Saint John Parish of country Antigua And Barbuda, skipping
Missing lat/lng for Saint Mary Parish of country Antigua And Barbuda, skipping
Missing lat/lng for Saint Paul Parish of country Antigua And Barbuda, skipping
Missing lat/lng for Saint Peter Parish of country Antigua And Barbuda, skipping
Missing lat/lng for Capital of country Bahrain, skipping
Missing lat/lng for Saint Andrew of country Barbados, skipping
Missing lat/lng for Limburg of country Belgium, skipping
Missing lat/lng for La Paz Department of country Bolivia, skipping
Missing lat/lng for Central District of country Botswana, skipping
Missing lat/lng for Southern District of country Botswana, skipping
Missing lat/lng for Centre of country Burkina Faso, skipping
Missing lat/lng for Centre of country Cameroon, skipping
Missing lat/lng for Savanes Region of country Cote D'Ivoire (Ivory Coast), skipping
Missing lat/lng for Saint Andrew Parish of country Dominica, skipping
Missing lat/lng for Saint David Parish of country Dominica, skipping
Missing lat/lng for Saint George Parish of country Dominica, skipping
Missing lat/lng for Saint John Parish of country Dominica, skipping
Missing lat/lng for Saint Mark Parish of country Dominica, skipping
Missing lat/lng for Saint Patrick Parish of country Dominica, skipping
Missing lat/lng for La Paz Department of country El Salvador, skipping
Missing lat/lng for Argolis Regional Unit of country Greece, skipping
Missing lat/lng for Corinthia Regional Unit of country Greece, skipping
Missing lat/lng for Saint Andrew Parish of country Grenada, skipping
Missing lat/lng for Saint David Parish of country Grenada, skipping
Missing lat/lng for Saint George Parish of country Grenada, skipping
Missing lat/lng for Saint Patrick Parish of country Grenada, skipping
Missing lat/lng for Leste Province of country Guinea-Bissau, skipping
Missing lat/lng for Eastern Region of country Iceland, skipping
Missing lat/lng for Southern Region of country Iceland, skipping
Missing lat/lng for Western Region of country Iceland, skipping
Missing lat/lng for Xaisomboun of country Laos, skipping
Missing lat/lng for Central Region of country Malawi, skipping
Missing lat/lng for Northern Region of country Malawi, skipping
Missing lat/lng for Central Province of country Maldives, skipping
Missing lat/lng for North Central Province of country Maldives, skipping
Missing lat/lng for Central Region of country Nepal, skipping
Missing lat/lng for Western Region of country Nepal, skipping
Missing lat/lng for Deir El Balah of country Palestinian Territory Occupied, skipping
Missing lat/lng for Gaza of country Palestinian Territory Occupied, skipping
Missing lat/lng for Jenin of country Palestinian Territory Occupied, skipping
Missing lat/lng for Jericho and Al Aghwar of country Palestinian Territory Occupied, skipping
Missing lat/lng for Jerusalem of country Palestinian Territory Occupied, skipping
Missing lat/lng for Khan Yunis of country Palestinian Territory Occupied, skipping
Missing lat/lng for Nablus of country Palestinian Territory Occupied, skipping
Missing lat/lng for North Gaza of country Palestinian Territory Occupied, skipping
Missing lat/lng for Qalqilya of country Palestinian Territory Occupied, skipping
Missing lat/lng for Rafah of country Palestinian Territory Occupied, skipping
Missing lat/lng for Ramallah of country Palestinian Territory Occupied, skipping
Missing lat/lng for Salfit of country Palestinian Territory Occupied, skipping
Missing lat/lng for Tubas of country Palestinian Territory Occupied, skipping
Missing lat/lng for Tulkarm of country Palestinian Territory Occupied, skipping
Missing lat/lng for Central Province of country Papua new Guinea, skipping
Missing lat/lng for Western Province of country Papua new Guinea, skipping
Missing lat/lng for Amazonas of country Peru, skipping
Missing lat/lng for Eastern Province of country Rwanda, skipping
Missing lat/lng for Northern Province of country Rwanda, skipping
Missing lat/lng for Southern Province of country Rwanda, skipping
Missing lat/lng for Western Province of country Rwanda, skipping
Missing lat/lng for Eastern Province of country Sierra Leone, skipping
Missing lat/lng for Northern Province of country Sierra Leone, skipping
Missing lat/lng for Southern Province of country Sierra Leone, skipping
Missing lat/lng for Central Province of country Solomon Islands, skipping
Missing lat/lng for Western Province of country Solomon Islands, skipping
Missing lat/lng for Central Province of country Sri Lanka, skipping
Missing lat/lng for Eastern Province of country Sri Lanka, skipping
Missing lat/lng for Northern Province of country Sri Lanka, skipping
Missing lat/lng for Southern Province of country Sri Lanka, skipping
Missing lat/lng for Western Province of country Sri Lanka, skipping
Another small inconsistency I found when importing, was:
- City
Ibiza
geocodes to stateBalearic Islands
(IB
)
But it is different here both in name and code in the data set.