Second Home

Second Home

Organisation: Berliner Morgenpost (Germany)

Publication Date: 06/02/2014


More than half a million foreigners from about 175 countries live in Berlin. They come from countries such as Barbados, Thailand, Lesotho. With our interactive application, users can find out how much they know about the social conditions and developments in the birth places of people without the German citizenship who live with them in the same district.

Technologies used for this project:

As data sources we use a static Excel file from the statistics agency in Berlin that we converted to JSON and the API of the world bank. The live query of the global data is mapped to the local data via unique country code. If there is data based on gender or age available, it will be provided based on the user input. Otherwise the overall data will be shown. One issue: The world bank doesn't have data for every country and every year. There are data gaps. For the map visualization we used SVG with the Javascript library D3.js. The localization is implemented with HTML5 Geolocation and a Geocoding library. Each state of the interactive has a unique URL that it can be shared via social media or integrated in the other content of the Berliner Morgenpost.

Featured Documents

Follow this project

Comments (0)

You have to be connected to contribute

You have to be connected to follow

Leave this project and no longer be informed about this project

By joining this project, you will be informed by email when an update or a new contribution is posted on the website.

Thank you for your active participation !

The GEN Community Team