Five capitals that are not listed in /cities

Question

Hi wirefreethought,

These capitals seem not to be listed in the /cities endpoint if you search by countryID and namePrefix:
* **Madrid**, ES - *(is listed in /cities/Q2807)*
* **Kingston**, JM - *(is listed in /cities/Q34692)*
* **Kyiv**, UA - *(is listed in /cities/Q1899)*
* **Mexico City**, MX - *(is listed in /cities/Q1489)*
* **Victoria**, HK - Q963152

Could you look into these?

Best, Tim

Michael Mogley · Answer

Fixed!

Michael Mogley · Answer

This is taking longer than expected as I'm redoing/simplifying some of the import logic. The import process is unfortunately time-consuming to test. Stay tuned.

Crawfish4170 · Answer

Thanks, I see Kingston.

Michael Mogley · Answer

Kingston is there

Crawfish4170 · Answer

Thanks, I'll use Q14767 for Victoria.

Michael Mogley · Answer

With respect to Victoria (https://www.wikidata.org/wiki/Q963152), it is listed as a historical city with an end date of 30 June 1997. GeoDB only pulls in Wikidata cities that are considered current. (According to this article, Central (Q14767) appears to have replaced it: https://en.wikipedia.org/wiki/Victoria,_Hong_Kong)

Michael Mogley · Answer

These cities have somehow been marked deleted by the import process. Will take a look. Thanks again for your report.

GeoDB Cities

9.9 / 10

67ms

100%

100%

Five capitals that are not listed in /cities