Traffic accidents in Hong Kong in 2009 (a few charts)

This is a project that I am currently working on with Masato Kajimoto, faculty member at the JMSC. A few months ago, we contacted the Hong Kong Transport Department to get some data on road safety in the city.

I originally wanted to get location data on every single accident in Hong Kong, but what we did manage to obtain was all the data for 2009. It is non-personalised data, so all it has was a location, the date-time and the severity (on a scale of 1 to 3).

While TD had the location data for every single accident (fatal or not), it came directly from police reports. Without a standardized way of naming the place of the accident, it has therefore become a nightmare to try and correlate a name of a place with actual coordinates using conventional methods. You have places like Fung Tak Road at the junction of Ying Fung Lane or the slightly better Texaco Road at the junction of Tsuen Wing Street TW New Territories.

(In fact, the location of an accident was often referenced using only with a “chainage” or lamppost identification… Masato asked Highway Department for geo-coded lamppost information and actually obtained it.)

But the easiest visualisations that I am able to make so far have simply been the result of aggregating the data in regular intervals of time, whether to look at the variation per week (more accidents on weeks with public holidays), or at sums per day of the week and time of the day (more accidents later at night, as we approach or are in the weekend).

(Technical note: I wrote a python script that reads my database, and generates links for the Google Chart API.)

Traffic accidents in Hong Kong in 2009 (breakdown per week)

Traffic accidents in Hong Kong in 2009 (breakdown per day)

Traffic accidents in Hong Kong in 2009 (per time of day and day of week)

The last graphic was inspired by this cool project made for visualising the time/day at which tweets are made for any given Twitter account. I found out later that a horizontal scroller could be used to change the date at which the tweets are being observed (and the graphic is regenerated automatically by changing the link of the Google Charts image. Clever!).

Leave a Reply