Despite the triumphant ‘Jubliympics’ celebrations this year, London has failed to shine in most of the 10 categories included in a study of 40 key tourist cities by travel website Trip Advisor.

These include friendliness of locals, cleanliness of streets, public transport, value for money, friendliness of taxi drivers and shopping.

The results were compiled based on more than 75,000 responses to a survey sent to those who have recently written Trip Advisor reviews on the featured cities.

Despite the big clean-up in the lead-up to this year’s Diamond Jubilee and Olympics, London is ranked 26th in the cleanliness of streets category. Tokyo comes top.

And while London was praised during the Olympics for the friendliness and enthusiasm of the Games’ volunteers, the city has ranked second to last in the friendliest locals category, with only Moscow worse.

Mexico’s Cancun was voted the city with the friendliest locals.

“While London hasn’t ranked particularly highly by those that have reviewed the city this year, it’s important to remember that many of the respondents may have experienced London before major changes were made or post the events of the summer,” said Trip Advisor spokesperson, Emma Shaw.

When it comes to ease of getting around, London is ranked as decidedly average by those that have experienced the city – coming in 17th place. Closely following is Dublin in 21st place.

Other European destinations, however, were voted far easier to navigate, with Zurich and Vienna taking first and second places respectively.

Many of London’s commuters may not be surprised to hear that the city has not ranked well for its public transport, coming in 15th.

According to respondents, it seems that taking a taxi might be the best bet when visiting Dublin and London – the cities rank fourth and fifth places respectively for best taxi services.

And Dublin comes in fifth place globally for the city with the friendliest taxi drivers, ahead of London cabbies in 12th place.

Of the 40 cities included in the study, Portugal’s Lisbon has been awarded top spot in the value-for-money category, followed by Budapest in Hungary. Despite London’s plethora of free museums, parks and attractions, London only ranked 35th in the best value city category.

New York is crowned the best city for shopping of the featured cities, with Bangkok runner-up and Dubai taking third place. London ranks an impressive fourth, beating off stiff competition from the likes of Tokyo (fifth), Hong Kong (sixth) and Paris (11th).

“The popularity of London as one of the most visited cities in the world remains, and travellers will continue to rave about it as a loved destination. Indeed, this year London was voted the best city in the world in the 2012 Trip Advisor Travellers Choice Awards.

“Even so, this study perhaps proves that even a great city isn’t going to be perfect in every way,” said Ms Shaw.

Friendliest locals
Cancun
Tokyo
Lisbon

Friendliest taxi drivers
Tokyo
Cancun
Singapore

Best taxi services
Tokyo
Singapore
Dubai

Cleanest streets
Tokyo
Singapore
Zurich

Ease of getting around
Zurich
Vienna
Singapore

Best public transport
Tokyo
Zurich
Munich

Best value for money
Lisbon
Budapest
Bangkok

Best for shopping
New York
Bangkok
Dubai

Most underrated city
Budapest
Lisbon
Cape Town

Safest city
Tokyo
Singapore
Dubrovnik