16 December 2013

Map of the Netherlands by gemeenten

I have done this map of the Netherlands by municipalities (second level of administrative districts) for http://tableaumapping.bi
Tableau Mapping is a project, where volunteers share their maps produced from shape files, so all Tableau users can use them.
It is a Christmas gift from me :)

11 December 2013

How to create map in Tableau with ShapeToTab

Prepare environment for work in ShapeToTab (created by Richard Leeke)
download release-1600-gdal-1-9-0-mapserver-6-0-1 from http://www.gisinternals.com/sdk/PackageList.aspx?file=release-1600-gdal-1-9-0-mapserver-6-0-1.zip
Unzip both and place them on your computer.

ShapeToTab consists of (my system is not in English, sorry):

20 November 2013

Migration between prefectures of Japan in 2012

You can check flows of the three streams:

  1. In-migration: the Japanese moving into one prefecture from another place within the country.
  2. Out-migration: the Japanese moving out of one prefecture to another place within the country.
  3. Net internal migration: the difference between in-migration and out-migration.

05 November 2013

How to create choropleth maps in Tableau from shape file

Tableau gives the possibility to easily create polygon maps at country and province levels. But what if you want more? Suppose you want to create a map of a city by boroughs or country by counties? There are easy solutions available [that why I am writing this post :) ]

20 October 2013

The most cycle friendly European countries

The Netherlands and Denmark have been named the most cycle friendly countries in Europe by the European Cyclist Federation (ECF).

Countries were judge on five criteria:

  1. market (bicycle sales per 1000 inhabitants)
  2. modal share (cycling as main mode of transport % of population)
  3. activists (ECF individual members per million inhabitants)
  4. safety (number of death per 100,000 cyclists)
  5. tourism (total trips per head)

Points were awarded based on a country's ranking in each category and added to give the overall scores.

11 October 2013

Crime in London

This post was created thanks to London's Metropolitan Police, that published crime data for London's boroughs. Their data base consists even such details like number of stolen bicycles.

Crime rates (Rates per thousand population) were calculated according to: (crime / the resident population)*1000. Many boroughs have very high daytime population, so the resident population is only a fraction of the daytime population and that makes the crime rate so high in some boroughs.

Hope to see such data for other cities.

23 September 2013

Preliminary result of the elections to the 18th German Bundestag

In German's voting system every voter gets two votes. The first allows voters to select candidate in their district. The second is for the party they support.

28 August 2013

Zara comparator

Zara sells its products online in 23 European countries, Japan, China, the United States and Canada. Today online shop has been opened in Russia. I have compared prices of few items.

12 August 2013

Immigration map of Berlin's neighbourhoods

The data were published by Statistical Office for Berlin-Brandenburg. There are many detailed data sets about Berlin's neighbourhoods on the website (in German :))

18 July 2013

New York City Population by Boroughs

New York is the most populous city in the United States, more than twice the size of the second largest city, Los Angeles.

In the period from 2000 to 2010 all five of New York's boroughs saw growth:

  • Staten Island 5.6%
  • The Bronx 3.9%
  • Manhattan 3.2%
  • Brooklyn 1.6%
  • Queens 0.1%

12 July 2013

Differences in price levels for food, beverages and tobacco across Europe

Eurostat published Comparative price levels for food, beverages and tobacco.

Denmark had the highest price level for food in the EU27 in 2012, at 139% of the EU27 average, followed by Sweden (124%). The lowest price levels were observed in Poland (60%) and Romania.

HFCE - total household final consumption expenditure
EA17 - the euro area
EU27 - the European Union

23 June 2013

Mysterious Lake Baikal

The Lake Baikal is not so mysterious anymore, one riddle has been solved, how infrastructure for eco-tourism was created.

The Great Baikal Trail was created to develop system of environmental trails around Lake Baikal. The projects are based on work done by volunteers from all over the world; Russia, Australia, Germany, Spain, Italy, France, the Netherlands, United States, Canada, Mongolia, and many more places.

To show the amount of work done in different areas of the lake I used:

  • number of volunteers involved,
  • man-days (=number of volunteers*number of projects' days).

I encourage you to interact with my visualization and take part in the Baikal's projects.

This data visualization is truly international:
- The data are from The Great Baikal Trail, a Russian interregional community organization.
- I am taking part in Tableau Software contest, which is open to residents of few countries so I am representing Germany :)
- The viz was done with use of American software and Russian Yandex maps :)

07 June 2013

Suicide in Turkey

The latest statistics recorded in 2011 show that 1,876 males and 801 females committed suicide in Turkey.

The suicide rate for every 100,000 citizens is 3.58.

Half of females who commit suicide in the country are under the age of 30, half of males are under 40.

Source of data: TurkStat.

26 April 2013

The LNG Industry 2012

International Group of LNG Importers has published report The LNG Industry 2012.

On the supply side, 5 countries out of a total of 18 made up 67% of global LNG export.

On the demand side, Japan and South Korea's combined share was around 53% of global import. Japan was buying from all exporting countries and recorded an 11% growth year on year.
Asia accounted for 71% of global LNG demand.

The share of spot and short-term trades remains stable, around 25% of total LNG trade.

25 March 2013

Population of Russian cities

The 2010 census recorded depopulation of Russia’s medium and smaller cities.

The population has grown in cities placed in areas with mineral resources; Khanty-Mansiysk - oil deposits (47%), Norilsk -  nickel deposits (30%), Yakutsk - diamonds (28%).

Nothing can stop Moscow and St. Petersburg from constant growth. The Russian government decided to increase the Moscow's territory by 2.4 times. Here you will find Map of Moscow boundary expansion.

17 March 2013

How much people spend on food

USDA has published Expenditures on food and alcoholic beverages that were consumed at home by selected countries in 2011.

As countries develop people spend proportionally less on food. Americans spend 6.7% of their income on food, when Cameroonians have to devote almost 47% of their income.

Norwegians have the highest food budget, an average Norwegian spend 95$ for food weekly.

06 March 2013

The development of the St. Petersburg underground

The St. Petersburg underground has been opened since 1955. The underground system is one of the deepest in the world, the deepest station is Admiralteyskay (86 metres below ground).

19 February 2013

Rubbish map of the world

The world's cities currently generate 1.2kg per city-dweller per day. That is predicted to rise to 1.4kg per person by 2025.

12 February 2013

27 January 2013

Population at-risk-of poverty or exclusion in the EU

Twenty four percent of the EU population (119.6 million people) were at risk of poverty or social exclusion in 2011, according to Eurostat.

The lowest shares were recorded in the Netherlands and Sweden (both 16%), and Luxembourg and Austria (both 17%). The highest were in Bulgaria (49%), Romania and Latvia (both 40%).