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

countries-states-cities-database/master/cities.json is missing location info. #790

Open
luke-song opened this issue Jun 20, 2024 · 0 comments
Labels
France missing-records Missing some records

Comments

@luke-song
Copy link

The cities. Json is missing location information. Here is missing location information. Please add to the database.

[
{
"id": 1,
"name": "Bora Bora",
"state_id": null,
"state_code": null,
"state_name": null,
"country_id": 154,
"country_code": "PF",
"country_name": "French Polynesia",
"latitude": "-16.500412",
"longitude": "-151.741490",
"wikiDataId": "Q34039",
"flag": "🇵🇫",
"destinationId": 1001,
"iataCode": "BOB",
"destinationName": "Bora Bora"
},
{
"id": 3,
"name": "Maui",
"state_id": 13,
"state_code": "HI",
"state_name": "Hawaii",
"country_id": 233,
"country_code": "US",
"country_name": "United States",
"latitude": "20.798362",
"longitude": "-156.331925",
"wikiDataId": "Q160309",
"flag": "🇺🇸",
"destinationId": 1003,
"iataCode": "OGG",
"destinationName": "Maui"
},
{
"id": 5,
"name": "Fiji",
"state_id": null,
"state_code": null,
"state_name": null,
"country_id": 60,
"country_code": "FJ",
"country_name": "Fiji",
"latitude": "-17.713371",
"longitude": "178.065033",
"wikiDataId": "Q712",
"flag": "🇫🇯",
"destinationId": 1005,
"iataCode": "NAN",
"destinationName": "Fiji"
},
{
"id": 8,
"name": "Santorini",
"state_id": 1,
"state_code": "L",
"state_name": "South Aegean",
"country_id": 71,
"country_code": "GR",
"country_name": "Greece",
"latitude": "36.393156",
"longitude": "25.461509",
"wikiDataId": "Q22890",
"flag": "🇬🇷",
"destinationId": 1008,
"iataCode": "JTR",
"destinationName": "Santorini"
},
{
"id": 9,
"name": "Tahiti",
"state_id": null,
"state_code": null,
"state_name": null,
"country_id": 154,
"country_code": "PF",
"country_name": "French Polynesia",
"latitude": "-17.650919",
"longitude": "-149.426042",
"wikiDataId": "Q34115",
"flag": "🇵🇫",
"destinationId": 1009,
"iataCode": "PPT",
"destinationName": "Tahiti"
},
{
"id": 10,
"name": "Palawan",
"state_id": 50,
"state_code": "PH-PLW",
"state_name": "Palawan",
"country_id": 166,
"country_code": "PH",
"country_name": "Philippines",
"latitude": "9.834949",
"longitude": "118.738361",
"wikiDataId": "Q837028",
"flag": "🇵🇭",
"destinationId": 1010,
"iataCode": "PPS",
"destinationName": "Palawan"
},
{
"id": 13,
"name": "Barbados",
"state_id": null,
"state_code": null,
"state_name": null,
"country_id": 23,
"country_code": "BB",
"country_name": "Barbados",
"latitude": "13.193887",
"longitude": "-59.543198",
"wikiDataId": "Q244",
"flag": "🇧🇧",
"destinationId": 1013,
"iataCode": "BGI",
"destinationName": "Barbados"
},
{
"id": 14,
"name": "Turks and Caicos",
"state_id": null,
"state_code": null,
"state_name": null,
"country_id": 215,
"country_code": "TC",
"country_name": "Turks and Caicos Islands",
"latitude": "21.694025",
"longitude": "-71.797928",
"wikiDataId": "Q30971",
"flag": "🇹🇨",
"destinationId": 1017,
"iataCode": "PLS",
"destinationName": "Providenciales"
},
{
"id": 15,
"name": "St. Barths",
"state_id": null,
"state_code": null,
"state_name": null,
"country_id": 54,
"country_code": "BL",
"country_name": "Saint Barthélemy",
"latitude": "17.913922",
"longitude": "-62.833853",
"wikiDataId": "Q25305",
"flag": "🇧🇱",
"destinationId": 1018,
"iataCode": "SBH",
"destinationName": "St. Barths"
},
{
"id": 16,
"name": "Saint Martin",
"state_id": null,
"state_code": null,
"state_name": null,
"country_id": 60,
"country_code": "MF",
"country_name": "Saint Martin",
"latitude": "18.0708",
"longitude": "-63.0501",
"wikiDataId": "Q25151",
"flag": "🇲🇫",
"destinationId": 1019,
"iataCode": "SFG",
"destinationName": "Saint Martin"
},
{
"id": 17,
"name": "Aruba",
"state_id": null,
"state_code": null,
"state_name": null,
"country_id": 8,
"country_code": "AW",
"country_name": "Aruba",
"latitude": "12.521110",
"longitude": "-69.968338",
"wikiDataId": "Q21203",
"flag": "🇦🇼",
"destinationId": 1014,
"iataCode": "AUA",
"destinationName": "Aruba"
},
{
"id": 19,
"name": "Cayman Islands",
"state_id": null,
"state_code": null,
"state_name": null,
"country_id": 50,
"country_code": "KY",
"country_name": "Cayman Islands",
"latitude": "19.3133",
"longitude": "-81.2546",
"wikiDataId": "Q5785",
"flag": "🇰🇾",
"destinationId": 1021,
"iataCode": "GCM",
"destinationName": "Grand Cayman"
},
{
"id": 20,
"name": "Curaçao",
"state_id": null,
"state_code": null,
"state_name": null,
"country_id": 160,
"country_code": "CW",
"country_name": "Curaçao",
"latitude": "12.169570",
"longitude": "-68.990021",
"wikiDataId": "Q25279",
"flag": "🇨🇼",
"destinationId": 1022,
"iataCode": "CUR",
"destinationName": "Curaçao"
},
{
"id": 21,
"name": "St. Lucia",
"state_id": null,
"state_code": null,
"state_name": null,
"country_id": 196,
"country_code": "LC",
"country_name": "Saint Lucia",
"latitude": "13.9094",
"longitude": "-60.9789",
"wikiDataId": "Q760",
"flag": "🇱🇨",
"destinationId": 1023,
"iataCode": "UVF",
"destinationName": "Hewanorra International Airport"
},
{
"id": 22,
"name": "British Virgin Islands",
"state_id": null,
"state_code": null,
"state_name": null,
"country_id": 39,
"country_code": "VG",
"country_name": "British Virgin Islands",
"latitude": "18.4207",
"longitude": "-64.6400",
"wikiDataId": "Q25305",
"flag": "🇻🇬",
"destinationId": 1024,
"iataCode": "EIS",
"destinationName": "Terrance B. Lettsome International Airport"
},
{
"id": 23,
"name": "Lombok",
"state_id": 1,
"state_code": "NB",
"state_name": "West Nusa Tenggara",
"country_id": 103,
"country_code": "ID",
"country_name": "Indonesia",
"latitude": "-8.650000",
"longitude": "116.324943",
"wikiDataId": "Q28560",
"flag": "🇮🇩",
"destinationId": 1025,
"iataCode": "LOP",
"destinationName": "Lombok"
},
{
"id": 24,
"name": "Koh Lipe",
"state_id": 83,
"state_code": "83",
"state_name": "Satun",
"country_id": 216,
"country_code": "TH",
"country_name": "Thailand",
"latitude": "6.490045",
"longitude": "99.300337",
"wikiDataId": "Q122034",
"flag": "🇹🇭",
"destinationId": 1026,
"iataCode": "HDY",
"destinationName": "Koh Lipe"
},
{
"id": 25,
"name": "Saba",
"state_id": null,
"state_code": null,
"state_name": null,
"country_id": 179,
"country_code": "BQ",
"country_name": "Caribbean Netherlands",
"latitude": "17.637546",
"longitude": "-63.236006",
"wikiDataId": "Q207429",
"flag": "🇧🇶",
"destinationId": 1027,
"iataCode": "SAB",
"destinationName": "Saba"
},
{
"id": 26,
"name": "Aitutaki",
"state_id": null,
"state_code": null,
"state_name": null,
"country_id": 61,
"country_code": "CK",
"country_name": "Cook Islands",
"latitude": "-18.830812",
"longitude": "-159.774785",
"wikiDataId": "Q152998",
"flag": "🇨🇰",
"destinationId": 1028,
"iataCode": "AIT",
"destinationName": "Aitutaki"
},
{
"id": 27,
"name": "La Digue",
"state_id": null,
"state_code": null,
"state_name": null,
"country_id": 201,
"country_code": "SC",
"country_name": "Seychelles",
"latitude": "-4.357493",
"longitude": "55.827469",
"wikiDataId": "Q139910",
"flag": "🇸🇨",
"destinationId": 1029,
"iataCode": null,
"destinationName": "La Digue"
},
{
"id": 28,
"name": "Fakarava",
"state_id": null,
"state_code": null,
"state_name": null,
"country_id": 154,
"country_code": "PF",
"country_name": "French Polynesia",
"latitude": "-16.315967",
"longitude": "-145.614191",
"wikiDataId": "Q641092",
"flag": "🇵🇫",
"destinationId": 1030,
"iataCode": "FAV",
"destinationName": "Fakarava"
},
{
"id": 29,
"name": "Roatán",
"state_id": null,
"state_code": null,
"state_name": null,
"country_id": 95,
"country_code": "HN",
"country_name": "Honduras",
"latitude": "16.329205",
"longitude": "-86.537558",
"wikiDataId": "Q148237",
"flag": "🇭🇳",
"destinationId": 1031,
"iataCode": "RTB",
"destinationName": "Roatán"
},
{
"id": 30,
"name": "Isla Holbox",
"state_id": 31,
"state_code": "ROO",
"state_name": "Quintana Roo",
"country_id": 157,
"country_code": "MX",
"country_name": "Mexico",
"latitude": "21.521757",
"longitude": "-87.376138",
"wikiDataId": "Q318960",
"flag": "🇲🇽",
"destinationId": 1032,
"iataCode": "CUN",
"destinationName": "Isla Holbox"
}
]

@dosubot dosubot bot added the missing-records Missing some records label Jun 20, 2024
@dr5hn dr5hn added the France label Sep 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
France missing-records Missing some records
Projects
None yet
Development

No branches or pull requests

2 participants