Santander Traffic – Take 1 –

I am currently working in a personal project consisting on a visualization & prediction models of Santander (North of Spain) urban traffic. The city has more than 200 sensors all  around  and you can grab them in “real time” (+2 hours) using their API at

I am using R, simply because  I want to test new amazing packages such as Flexdashboard. The data pipeline is as follows:

1.- Grab sensor data each 60 minutes using a cron job & R script and save them in SQLite Database

2.- Calculate metrics & present data using RMarkdown & Flexdashboard

3.- Add prediction model to the final output & publish as a HTML website. (pending)


Below find some of the current assets (work in progress!!!)

Screenshot from 2016-08-13 09:42:33

Screenshot from 2016-08-07 12:20:55 Screenshot from 2016-08-13 09:42:54

Screenshot from 2016-08-13 09:43:13

Screenshot from 2016-08-13 09:43:33

Screenshot from 2016-08-06 18:06:41

Screenshot from 2016-08-06 18:05:24

Screenshot from 2016-08-07 10:07:01