What electronic bus boards don’t tell you, filling in the gaps in TfL bus data with Kognitio SQL
We previously talked about reading JSON files into Kognitio from Amazon S3 in this previous blog post and like with most data, it needed to be cleansed and formatted. In this post we will go through one that needed to be applied to the TfL bus data we collected. This is separated into lookups (information…