Category: Victoria

Recent Posts
Computing, Victoria

Driving a Point: Victorian Crash Statistics

Trigger Warning: This post discusses road-related trauma

 Introduction

VicRoads has released crash statistics for the calendar years 2010-14 inclusive, so I thought I'd fire up MATLAB and see what I could make of the data. My analysis follows.

Heatmaps: What Happens, When?

Initially, I was interested in the spread of reported incidents throughout the day, and the week. With a nod to Powershop's cool ability to track energy usage in a similar fashion, I thought I'd generate a heatmap to show when its most likely, on average, for a collision to occur on Victorian roads, for a given time of week.

...Read More

Getting PTV GTFS Into Your MySQL Database

PTV has finally released their trip information in GTFS format, but that's only half of the battle; to make use of this data, you'll need it in a format other than 'zip file of text files'. Because I (decided to, this week) love Bash, I though I'd use everyone's favourite shell to get up close with GTFS to MySQL translations.

...Read More