It's widely reported that Musk is a majority shareholder of xAI and the controlling shareholder of SpaceX (close to 80% of voting shares). Not surprising that he would be looking to consolidate ownership under one entity especially if he perceives significant synergies (i.e., data centres in space).
I could not disagree more - often times, especially if travelling with multiple people it is far more convenient, comfortable and can even be more affordable than taking public transport. While I agree that London has great public transport, Uber has been a game changer for myself and many people I know.
I took the list of 4 thousand odd cities from the UN statistics report of cities over 100k and then ran it through the batch geocoding site: http://www.findlatitudeandlongitude.com/ ... apart from that just old fashioned excel to calculate
How I built this: I pulled the population data from the UN statistics report on cities over 100k and then batch geocoded all of the cities (there was also a fair bit of data cleansing required). I then used a macro in excel to calculate the distance between every city pair (using Vincenty's formula) and uploaded the results to a database. Happy to share more if anyone is curious.