Open dereuromark opened 1 year ago
@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:
Ibiza
geocodes to state Balearic Islands
(IB
)But it is different here both in name and code in the data set.
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
vs
State Sana'a of country Yemen
vs
Probably an oversight, and they indeed have at least some difference in name?