Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Mexico, Italy duplicate data issue #500

Open
ionecum opened this issue Sep 18, 2022 · 0 comments
Open

Mexico, Italy duplicate data issue #500

ionecum opened this issue Sep 18, 2022 · 0 comments
Assignees
Labels
enhancement New feature or request

Comments

@ionecum
Copy link

ionecum commented Sep 18, 2022

Some Italian "states" are, in reality, "boroughs". This makes that some cities are duplicated.

For example this
{
"id": 137775,
"name": "Città metropolitana di Milano",
"latitude": "45.45186000",
"longitude": "9.14586000"
},

which is also duplicated in English
{
"id": 1698,
"name": "Metropolitan City of Milan",
"state_code": "MI",
"cities": []
},

and this, which is not mentioned as a state, but as a city of Lombardy
{
"id": 140142,
"name": "Milan",
"latitude": "45.46427000",
"longitude": "9.18951000"
},

3 entries of the same city. This is awful.

ANY CITY MUST BE UNIQUELY IDENTIFIED AND MENTIONED IN THE DATA BASE.

Also some boroughs in Mexico City are duplicated. For example
{
"id": 68588,
"name": "Benito Juarez",
"latitude": "19.39840000",
"longitude": "-99.15766000"
},
{
"id": 68597,
"name": "Benito Juárez",
"latitude": "19.37270000",
"longitude": "-99.15640000"
},

Duplicate data is perhaps the most serious issue in any database.

@dr5hn dr5hn mentioned this issue Oct 4, 2022
@dr5hn dr5hn self-assigned this Oct 4, 2022
@dr5hn dr5hn added the enhancement New feature or request label Oct 6, 2022
@dr5hn dr5hn changed the title City names are incorrect in Italy and I found duplicate data in Mexico Mexico, Italy duplicate data issue May 20, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants