Open jeraldpunx opened 5 years ago
seems a problem 🤨
There are only 283 U.S. cities being seeded. How do I seed the database with a complete list of cities?
same here about Chile cities. only 13 cities and seems those are not even cities and are regions
Here is a full list of all the countries for which 0 cities are provided...
0 => "Aland Islands" 1 => "American Samoa" 2 => "Anguilla" 3 => "Antigua and Barbuda" 4 => "Aruba" 5 => "Bahamas" 6 => "Barbados" 7 => "Bermuda" 8 => "Bhutan" 9 => "Bonaire, Sint Eustatius and Saba" 10 => "Botswana" 11 => "Bouvet Island" 12 => "British Indian Ocean Territory" 13 => "British Virgin Islands" 14 => "Brunei" 15 => "Cayman Islands" 16 => "Chad" 17 => "Christmas Island" 18 => "Cocos (Keeling) Islands" 19 => "Comoros" 20 => "Congo" 21 => "Cook Islands" 22 => "Curaçao" 23 => "DR Congo" 24 => "Dominica" 25 => "Dominican" 26 => "Equatorial Guinea" 27 => "Eswatini" 28 => "Falkland Islands (Malvinas)" 29 => "Faroe Islands" 30 => "Fiji" 31 => "French Guiana" 32 => "French Polynesia" 33 => "French Southern Territories" 34 => "Gambia" 35 => "Georgia" 36 => "Gibraltar" 37 => "Greenland" 38 => "Grenada" 39 => "Guadeloupe" 40 => "Guam" 41 => "Guernsey" 42 => "Guinea-Bissau" 43 => "Haiti" 44 => "Heard Island and McDonald Islands" 45 => "Hong Kong" 46 => "Iceland" 47 => "Iran" 48 => "Iraq" 49 => "Isle of Man" 50 => "Jersey" 51 => "Kuwait" 52 => "Libya" 53 => "Liechtenstein" 54 => "Macau" 55 => "Malta" 56 => "Marshall Islands" 57 => "Martinique" 58 => "Mauritius" 59 => "Mayotte" 60 => "Micronesia" 61 => "Moldova" 62 => "Monaco" 63 => "Montserrat" 64 => "Mozambique" 65 => "Nauru" 66 => "Netherlands Antilles" 67 => "New Caledonia" 68 => "Niue" 69 => "Norfolk Island" 70 => "North Macedonia" 71 => "Northern Mariana Islands" 72 => "Palau" 73 => "Panama" 74 => "Pitcairn" 75 => "Puerto Rico" 76 => "Reunion" 77 => "Saint Barthélemy" 78 => "Saint Helena" 79 => "Saint Kitts and Nevis" 80 => "Saint Lucia" 81 => "Saint Martin" 82 => "Saint Pierre and Miquelon" 83 => "Saint Vincent and the Grenadines" 84 => "Samoa" 85 => "San Marino" 86 => "Sao Tome and Principe" 87 => "Seychelles" 88 => "Singapore" 89 => "Sint Maarten" 90 => "Somalia" 91 => "South Georgia and the South Sandwich Islands" 92 => "South Sudan" 93 => "Svalbard and Jan Mayen Islands" 94 => "Taiwan" 95 => "Tokelau" 96 => "Trinidad and Tobago" 97 => "Turks and Caicos Islands" 98 => "Tuvalu" 99 => "United States Minor Outlying Islands" 100 => "United States Virgin Islands" 101 => "Vatican City State" 102 => "Wallis and Futuna Islands" 103 => "Western Sahara"
I added all cities with over 5000 population in my pull request: https://github.com/khsing/laravel-world/pull/51
When I tried adding every single cities provided by https://download.geonames.org/export/dump/ I saw a considerable slow down in the queries when searching a city by name.
and it only shows 4 cities.