Fuelino Proto3 datalog and Google Fusion Tables

Today I would like to show you one interesting feature of Fuelino. Using "Fuelino File Converter" (latest version available here), I converted the binary data stored by Fuelino on the Micro SD card, into an easily understandable CSV file, and imported it into Google Fusion Tables. The result is shown below: you can click on the map, zoom in and zoom out.

Each point shows the data sampled at a specific timing. This CSV export was created using a sampling time of 1 second, to maintain compatibility with Google Fusion Tables (it cannot manage much data easily), but can be reduced, for example 100ms or less, in case you need to overlay the data on a video (as I did below) and you need a faster sampling time.

I also created a video using RaceRender3 Free edition. Unfortunately, many GPS data packets went lost due to check-sum errors (I am still trying to avoid this problem by reducing the interrupts execution time, so that GPS transmission bits do not get corrupted), therefore the speed calculation (km/h) is not so good; many packets were lost, so the data in between had to be reconstructed using linear interpolation. I will make a better video in the next days, after fixing this problem.

One of the interesting features of Google Fusion Tables is that, by clicking on a specific point, it shows the signals sampled on that point. This is very useful, for example, to understand which was your exact speed in a specific place.

The next targets will be: first of all, fixing the interrupt execution time issue, which causes SWseriale data corruption (GPS data gets corrupted). And also, I need to integrate the IMU (Inertial Measurement Unit) calculation library which I already partially prepared half year ago. Once I get the IMU library working, I will be able also to visualize the 3 Tait-Bryan angles (roll, pitch, yaw). Still some time is required.

Author: Davide Cavaliere

I am an Italian Electrical Engineer graduated at Politecnico di Milano. My interests are motorcycles and cars, electronics, programming, Internet of Things, and Japanese culture.

Leave a Reply

Your email address will not be published. Required fields are marked *