ICE Wifi-user Heatmap
Capturing Passengers' Connectivity Behavior on Inter-City Express Train
Germany's railway company Deutsche Bahn
operates 247 long distance trains Inter-City Express (ICE) serving approximately 148 Million
passengers, only in 2018. This is a huge number, and is expected to grow even more at the following years.
Probably, the availability of Wifi connections within the ICE train is one of the cause.
Out of curiousity, I downloaded their "Wifi on ICE" data here to get a hint on the passenger behavior related to the Wifi facility. The zipped file size is 232Mb, and the real CSV data is around 2Gb with over 21 millions of rows. So it happened. Displaying all of them would be very costly. So, after a series of pre-processing steps (see below), only 25 trains with the longest routes is displayed here, representing 33k rows in the PostGreSQL database.
From those, we can obtain the Wifi-user Heatmap and the tracks, including stops at the train stations and cities as presented below.
- num: [1..25], def = 25
- show: ['station', else], def = 'city'
The colors depict the heatmap of the wifi-users in the train:
- pure green represents zero,
- pure yellow is 150 users,
- pure red means 300 or above.
Displayed data from train id:
                        
Adjust the number of displayed tracks using the parameter num, and pick train stations over cities to display using show. An example for that is given here.
Cities and train stations outside of Germany is not shown since their coordinates are not listed in the obtained database.