Monday, July 24, 2017

Airbnb in Berlin


In 2008 the first Berlin apartment was listed on Airbnb. It is estimated that there are now around 10,000 properties in Berlin being rented out on Airbnb. You can view where and when all 10,000 properties were listed on Airbnb on a new interactive animated map.

Airbnb in Berlin is an animated map which shows the growth of the Airbnb market in Berlin from 2008 to the present day. As the animation plays you can watch as properties are added to the map by the date of their listing. Every dot on the map shows when a property was first added to Airbnb and the name of the property's owner.

Unfortunately the map doesn't include a timeline control. It would be useful to be able to adjust the date visualized on the map. For example this would be useful for exploring the effect of Berlin banning whole properties from being listed on Airbnb from May 2016. It would also be useful to view some other visualizations of the data, for example a heat map view showing where in the city the most properties are listed.


Airbnb vs Berlin is a much better data driven investigation into the popularity of Airbnb in Berlin and the possible effect it is having on affordable housing in the city.

Among the interactive maps used to illustrate this investigation is Airbnb Streets. The map highlights the streets in Berlin with more than 20 Airbnb offers and reveals that many of the properties listed on Airbnb are in popular tourist areas. In particular there is a high concentration of properties in areas that are popular with young travelers.


Another interactive map in the article visualizes the number of Airbnb listings by neighborhood. This choropleth map shows in which areas of the city more flats and rooms are offered on Airbnb. The Reuterkiez area in Neuk├Âlln is the most active neighborhood on Airbnb with 476 rooms and flats listed within only a few blocks.

A third map shows the locations of properties by the top 10 'power users' in Berlin. There is one user who lists 44 separate properties in Berlin on Airbnb. This rise in 'super users' suggests that Airbnb is being used as a business tool. It appears that more and more Airbnb listings are being rented on a commercial level by landlords exploiting the service to make higher profits from short term rentals rather than from renting out their properties to long term tenants.

Sunday, July 23, 2017

The Rubbish Map of the Week


Litterati is an iOS and Android app which is used for logging the location of litter found on the streets. Using the app anyone can take a quick photo and report any litter that they find. The photo is then added to the worldwide Litterati interactive map.

The app has already proved hugely successful around the world. The Litterati interactive map already has nearly half a million reports in the United States and over 100,000 reports in Europe. After taking photos users of the app are meant to dispose of the litter in a responsible manner. If they do this then that is a lot of litter which has already been removed from the world's streets.

Users of the app are also encouraged to log the type of litter (plastic, cigarettes, cans, glass etc) and the manufacturers and brands of the litter. Marlboro, MacDonalds and Coke are the three leading brands so far whose discarded cigarette butts, wrapping and cans have been found on the streets around the world. This suggests that these brands have a lot more work to do to encourage their customers to not litter the streets.

Litterati claim that users have also created groups to crowd-source the identification and cleaning of particularly dirty neighborhoods in their towns and cities. City authorities have also used the app to identify the levels of cigarette butts on the streets in order to determine tax levels to charge on cigarettes.

Saturday, July 22, 2017

Where the UK is Getting Old


The UK is getting old. Although some areas of the country are managing to stay relatively young. In 2016 18% of the population were aged 65 and over. 2.4% were aged 85 and over. As lifestyles & healthcare improve and people continue to have children later in life the percentage of the elderly is expected to increase. You can see how and where on a new map from the Office for National Statistics.

The ONS's UK Population Age map shows the percentage of the UK population over 65, over 85 and the old age dependency ratio at local authority level. The map allows you to view the percentage of the aged population by year for 1996, 2006 and 2016. It also allows you to view the projected growth in the percentage of the population over 65 and 85 for the years 2026 and 2036.

The map reveals that there are geographical differences in the proportion of the local population with high percentages of older or younger people. The bigger cities tend to have a higher proportion of younger people than more rural locations. This presumably reflects a tendency for people to live in cities for work and then move to more rural areas when they retire. Many local authorities in the south have the highest proportions of elderly people, indicating that these are popular areas to retire.

If you want to know how your local authority compares to the rest of the country you can select it on the map. You can then view charts showing how your authority compares to the national average for the percentage of the population over 65 and over 85.

Friday, July 21, 2017

Animated Race Maps


Back in 2013 the New York Times created an impressive animated mapped visualization of the America's Cup Finale between the USA and New Zealand. The America’s Cup Finale: Oracle’s Path to Victory showed the progress of the race between the two yachts from start to finish.

The America's Cup 2013 Finale: An Animated Map is a lovingly created and accurate reproduction of the NYT's map using Leaflet.js. The map allows you to replay the whole finale between the two sailing teams. The map even includes the wind speed and wind direction for the whole race.

If you like this animated map visualization and are interested in creating a similar animated race map then you can view the entire America's Cup project on GitHub.


Over 35,000 people competed in last year's Berlin Marathon. You can see how every one of those competitors fared in an animated map of the race, created by the Berliner Morgenpost.

The Berlin Marathon 2016 map animates every single runner in the Berlin Marathon on top of a map of the race's route. As the animation plays out you can watch all 35,827 of the athletes as they complete the course.

The animated map of the Berlin Marathon 2016 was created using the PixiJS HTML5 engine.

If you are interested in mapped visualizations of sports then you might also like The New Age of Sports Visualization.

Detroit's Deadliest Days


50 years ago, in July 1967, a riot broke out in Detroit which lasted five days. By the time the riot ended 43 people were dead, 1,189 were injured, over 7,200 people had been arrested and more than 2,000 buildings had been destroyed.

To mark the 50th anniversary of the 1967 Detroit Riot the Detroit News has released a map exploring every single one of the 43 deaths that occurred during the riot. The map doesn't attempt to explain the causes of the riot or how it progressed. It just attempts to explain who died, where they died and how.

Five Deadly Days in Detroit uses Carto's Odyssey.js story map format to provide a simple chronological account of what happened in Detroit. The basemap used for the story map is a United States Geological Survey map from 1968. As you scroll through Five Deadly Days in Detroit the map pans to the location where one of the 43 people were killed. The text beneath the map provides an account of who died and how they were killed. This text is illustrated with vintage images from the Detroit News coverage of the riot in 1967.

Thursday, July 20, 2017

Street View in Space

This is ground control to major Pegman. Take your protein pills and put your helmet on. Can you hear us major Pegman? Commencing countdown. Engines on .....


You can now see inside the International Space Station on Google Maps. ESA astronaut Thomas Pesquet got a part-time job over the winter capturing panoramic Street View imagery from outer space for Google Maps. That imagery is now live.

If this is your first trip to space aboard the ISS you might find these quick links helpful while you get familiar with weightlessness:

the Cupola Observation Module
the US Laboratory Module
Node 1 (Unity)
Node 2 (Harmony) Crew Quarters
Joint Airlock (Quest)

Google's Street View images from the ISS include links which provide useful information about some of the unfamiliar out-of-this-world equipment that you will find on your journey around the space station. Just click on the links to learn more about life in space.

The Emoji Weather Map


Dark Sky provide hyper-local weather information with its iOS and Android apps. It also provides a desktop weather map which includes a seven day forecast of weather conditions around the world.

The Dark Sky Weather Map has for a while included the option to view global weather conditions on an interactive 3d globe. It now also has an option to view a weather forecast on an emoji map of the world. If you select 'emoji' from the drop-down menu at the top of the Dark Sky Map you can now view your weather predictions represented by thousands of emoji symbols.

The Dark Sky Weather Map includes a number of different weather layers which allow you to view a seven day forecast of temperature, precipitation and wind speed around the world. The 3d weather visualization uses OpenLayers with the Cesium WebGL 3d globe engine.


You can also share your location using the universal language of the emoji. What3Emojis is a revolutionary method of addressing the entire world using the only common language of the entire human race, the emoji.

With What3Emojis the Earth is divided into millions of 4m x 4m squares, each of which is randomly assigned a unique three-emoji combination. If you want to share your location with someone else all you need to do is share the three emojis assigned to that 4m x 4m square. Any similarity to What3Words is entirely intentional.

The Manhattan Skyscraper Explorer


New York is a city of amazing tall buildings. But what do you actually know about Manhattan's tallest buildings? Do you know how tall they are or when they were built? Do you know what each building is used for? To find out the answer to these questions you need the Manhattan Skyscraper Explorer

The Manhattan Skyscraper Explorer is your guide to Manhattan's tallest building. This 3d Esri map allows you to explore the amazing New York skyline and find out everything you would ever need to know about the city's buildings. The 3d map is accompanied by a timeline - height chart, which allows you to explore Manhattan's skyscrapers by year of construction and by building height.

If you select an individual building on the map you can learn more about the chosen skyscraper, such as its height and the year it was built. You can even view an image gallery of the building and (where available) click through to learn more about the building on Wikipedia.

A Game of Thrones Street View


What could be better than exploring A Game of Thrones on the Five Maps of Westeros?

How about a world tour of some of the amazing real-life filming locations where the television series was made?

One reason for the huge success of HBO's series of George R.R. Martin's best-selling 'A Song of Ice and Fire' is the amazing set locations. HBO scoured the planet to find suitable locations to represent King's Landing, Winterfell and Essos. Google has put together a collection of filming locations from A Game of Thrones which appear on Google Maps Street View. The collection takes you on a tour of beautiful locations in Ireland, Croatia, Iceland, Spain and elsewhere around the world.

Game of Thrones: The Old Views and the New allows you to explore the filming locations for King's Landing, Winterfell and the mysterious continent of Essos. Google's collection is split into three main Houses, the Starks, Lannisters and the Mother of Dragons.

The Google Earth Blog has used Google's collection of Street Views to put together a Game Of Thrones kml file which allows you to explore these filming locations in 3d on Google Earth.

Wednesday, July 19, 2017

The 3D Globe of Google Trends


The Global Trend Tracker is a 3D globe which shows you what subjects people are currently searching for in different countries around the world. As you browse and watch the globe the top Google search trends will appear over each country.

You can zoom in on individual countries. Alternatively you can select a country from a drop-down menu. If you select an individual country on the map then you can view the current top ten search trends in that country. You can even click through to view the links to the trend on Google.com.


If you are interested in mapping Google Trends then you might be interested in the Google Trends Datastore, which provides a great source of data for anyone interested in mapping search trends from Google. Key datasets from Google Trends are added to the Datastore all the time and can be downloaded by anyone, in CSV format.

Many of the datasets have a geographically element to them. For example, at the moment you can download a CSV file of the 'Champions League final: Search interest in Real Madrid and Juventus by country'.