Hello and Thanks,
Yikes! I didn't notice the oversight with spelling--how embarrassing.
This started from something a friend told me years ago: "There is a Jamaica in Queens and a Queens in Jamaica".
I knew that Jamaica was in the New York City borough of Queens, but I couldn't figure out how to extract that as an Entity.
Even worse, a search for all cities in the country of Jamaica did not turn up a Queens city.
So, I started a search haphazardly and found (mistakenly) the Columbia (Colombia)/California pair. (Aside, there are a remarkable number of European capitals in WIsconsin).
The first thought was to try something like this:
citList = Last/@CityData;
and then look for pairs of candidates {"city", "state", "country"} shared at least two common members where the relative locations in the list are reversed.
But, this (as Bianca anticipates) would be terribly expensive.. I was hoping there might be a better way.
