Bogotá D.C. city is duplicate

[mario-alba]

Hi, I found that "Bogotá D.C." city is duplicate on two diferent states, "Cundinamarca" state with id 2875 and "Bogotá D.C." state with id 4921. The correct state is "Bogotá D.C." state with id 4921. This error is on all sql and json files.

[dosubot]

¡Hola @mario-alba! 🌟 Welcome to the repository. I'm here to help you with any bugs, questions, and contributions while we wait for a human maintainer.

To correct the duplication of "Bogotá D.C." city in the SQL and JSON files, you need to update the entries to ensure that "Bogotá D.C." is associated only with the state ID 4921. Here are the steps to make the necessary changes:

SQL File

Update the state ID for "Bogotá D.C." to 4921:

UPDATE cities SET state_id = 4921 WHERE name = 'Bogotá D.C.';

JSON File

Ensure the entry for "Bogotá D.C." has the correct state ID:

{
  "id": 4921,
  "name": "Bogotá D.C.",
  "state_code": "DC",
  "latitude": "4.28204150",
  "longitude": "-74.50270420",
  "type": "capital district"
}

YAML File

Update the YAML file to reflect the correct state ID:

- id: 4921
  name: 'Bogotá D.C.'
  country_id: 48
  country_code: CO
  country_name: Colombia
  state_code: DC
  type: 'capital district'
  latitude: '4.28204150'
  longitude: '-74.50270420'

These updates will ensure that "Bogotá D.C." is correctly associated with state ID 4921 in all relevant files ^[1][2][3].

To continue talking to Dosu, mention @dosu.