dr5hn / countries-states-cities-database

🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, PSQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities
https://dr5hn.github.io/countries-states-cities-database/
Open Data Commons Open Database License v1.0
6.83k stars 2.45k forks source link

info error #796

Open le011 opened 1 week ago

le011 commented 1 week ago

{ "id": 2170, "name": "İstanbul", "country_id": 225, "country_code": "TR", "country_name": "Turkey", "state_code": "34", "type": "province", "latitude": "41.16343020", "longitude": "28.76644080" } Istanbul is the largest city in Turkey (https://en.wikipedia.org/wiki/Turkey) , not province, This problem also exists in other cities in Turkey. and is not present in cities.json.

dosubot[bot] commented 1 week ago

Hello @le011! I'm here to assist you with any bugs, questions, or contributions you may have. Let's work on resolving this issue together.

The classification of Istanbul as a "province" instead of a "city" in the cities.json file is indeed incorrect. Here is the corrected entry for Istanbul and other major cities in Turkey:

[
    {
        "id": 2170,
        "name": "İstanbul",
        "country_id": 225,
        "country_code": "TR",
        "country_name": "Turkey",
        "state_code": "34",
        "type": "city",
        "latitude": "41.16343020",
        "longitude": "28.76644080"
    },
    {
        "id": 2204,
        "name": "Gümüşhane",
        "country_id": 225,
        "country_code": "TR",
        "country_name": "Turkey",
        "state_code": "29",
        "type": "province",
        "latitude": "40.28036730",
        "longitude": "39.31432530"
    },
    {
        "id": 2190,
        "name": "Hakkâri",
        "country_id": 225,
        "country_code": "TR",
        "country_name": "Turkey",
        "state_code": "30",
        "type": "province",
        "latitude": "37.44593190",
        "longitude": "43.74498410"
    },
    {
        "id": 2211,
        "name": "Hatay",
        "country_id": 225,
        "country_code": "TR",
        "country_name": "Turkey",
        "state_code": "31",
        "type": "province",
        "latitude": "36.40184880",
        "longitude": "36.34980970"
    },
    {
        "id": 2166,
        "name": "Iğdır",
        "country_id": 225,
        "country_code": "TR",
        "country_name": "Turkey",
        "state_code": "76",
        "type": "province",
        "latitude": "39.88798410",
        "longitude": "44.00483650"
    },
    {
        "id": 2222,
        "name": "Isparta",
        "country_id": 225,
        "country_code": "TR",
        "country_name": "Turkey",
        "state_code": "32",
        "type": "province",
        "latitude": "38.02114640",
        "longitude": "31.07937050"
    },
    {
        "id": 2205,
        "name": "İzmir",
        "country_id": 225,
        "country_code": "TR",
        "country_name": "Turkey",
        "state_code": "35",
        "type": "province",
        "latitude": "38.41924830",
        "longitude": "27.12872000"
    },
    {
        "id": 2221,
        "name": "Bilecik",
        "country_id": 225,
        "country_code": "TR",
        "country_name": "Turkey",
        "state_code": "11",
        "type": "province",
        "latitude": "40.05665550",
        "longitude": "30.06652360"
    },
    {
        "id": 2153,
        "name": "Bingöl",
        "country_id": 225,
        "country_code": "TR",
        "country_name": "Turkey",
        "state_code": "12",
        "type": "province",
        "latitude": "39.06263540",
        "longitude": "40.76960950"
    },
    {
        "id": 2215,
        "name": "Bitlis",
        "country_id": 225,
        "country_code": "TR",
        "country_name": "Turkey",
        "state_code": "13",
        "type": "province",
        "latitude": "38.65231330",
        "longitude": "42.42020280"
    },
    {
        "id": 2172,
        "name": "Bolu",
        "country_id": 225,
        "country_code": "TR",
        "country_name": "Turkey",
        "state_code": "14",
        "type": "province",
        "latitude": "40.57597660",
        "longitude": "31.57880860"
    },
    {
        "id": 2209,
        "name": "Burdur",
        "country_id": 225,
        "country_code": "TR",
        "country_name": "Turkey",
        "state_code": "15",
        "type": "province",
        "latitude": "37.46126690",
        "longitude": "30.06652360"
    },
    {
        "id": 2163,
        "name": "Bursa",
        "country_id": 225,
        "country_code": "TR",
        "country_name": "Turkey",
        "state_code": "16",
        "type": "province",
        "latitude": "40.06554590",
        "longitude": "29.23207840"
    },
    {
        "id": 2216,
        "name": "Çanakkale",
        "country_id": 225,
        "country_code": "TR",
        "country_name": "Turkey",
        "state_code": "17",
        "type": "province",
        "latitude": "40.05101040",
        "longitude": "26.98524220"
    },
    {
        "id": 2168,
        "name": "Çankırı",
        "country_id": 225,
        "country_code": "TR",
        "country_name": "Turkey",
        "state_code": "18",
        "type": "province",
        "latitude": "40.53690730",
        "longitude": "33.58838930"
    },
    {
        "id": 2203,
        "name": "Gaziantep",
        "country_id": 225,
        "country_code": "TR",
        "country_name": "Turkey",
        "state_code": "27",
        "type": "province",
        "latitude": "37.07638820",
        "longitude": "37.38272340"
    },
    {
        "id": 2186,
        "name": "Giresun",
        "country_id": 225,
        "country_code": "TR",
        "country_name": "Turkey",
        "state_code": "28",
        "type": "province",
        "latitude": "40.64616720",
        "longitude": "38.59355110"
    },
    {
        "id": 2171,
        "name": "Eskişehir",
        "country_id": 225,
        "country_code": "TR",
        "country_name": "Turkey",
        "state_code": "26",
        "type": "province",
        "latitude": "39.63296570",
        "longitude": "31.26263660"
    }
]

This correction ensures that Istanbul is classified as a "city" and not a "province" [1].

To continue talking to Dosu, mention @dosu.

le011 commented 1 week ago

@dr5hn Also problematic are the following cities, e.g. `izmir' is a province as well as a city, (https://en.wikipedia.org/wiki/%C4%B0zmir)

  1. İzmir
  2. Ankara
  3. Adana
  4. Mersin
  5. Kayseri