My mom has been privately sharing a car for the last years. Until now this requires each user to document every trip in a small logbook. It is kept in the glovebox and therefore is not used as intended. Not every trip is documented since the users are lazy, in a hurry or simply forget to make an entry.
In consequence, when trying to split the cost of the car as fair as possible, based on the use of it per user, this is hard, since the logbook usually has a lot of unfilled spaces.
So I decided to throw some technology at the problem and hope to solve it thereby.
- Since none of the users of the car is especially tech-savvy, it has to be very easy to use on a daily basis.
- Cost and complexity shall be kept as low as possible.
- It must conveniently integrate into the car.
- Data analysis doesn't have to be too easy/convenient, since this is only done once a year.
How the device is supposed to work
Every user gets an RFID token. When starting the trip, he puts it on the device. The device automatically counts the travelled distance and saves this data. When doing the billing, this data can be used to split the bills in a straightforward manner.
My current solution (Hardware)
As it can be seen in the picture, this car-sharing system consists of multiple modules:
- GPS - for tracking the travelled distance
- RFID - for identifying the user
- µSD - for saving the data permanently
- UI - a simple LED to show the device status
- Power Supply
A detailed schematic is available on my Github.
My current solution (Software)
The software running on the MCU has to do the following things:
- Handle GPS data and keep track of the travelled distance
- Read the RFID token to identify the user
- Monitor the ignition signal of the car
- Write data to the SD card once the ignition is switched off
- Go to deep sleep when not in use, so it doesn't drain the battery
To achieve this, a lot of very good open source libraries are used - thanks to everybody who contributes to open-source projects - you're awesome!
All code is available on my Github, so feel free to look around, use and improve it to your liking.
Data logging and privacy
At the end of every trip a log entry is generated and saved to the sd card. It looks like this:
- ID - the RFID token id of the user
- Distance - travelled distance of this trip in km
- Date - date of end of trip
- Time - time of end of trip
- lat - latitude of last position
- lng - longitude of last position
ID and distance are obviously required. Date and time are not strictly necessary but since the car's usage is coordinated via a messenger group, this rises little privacy issues. The last know position is of course a very private thing. Unfortunately, the GPS module sometimes takes several minutes to get a new fix. Distances travelled during this time would be lost. That's why the last position is saved and used as a first starting point for the calculation at the beginning of the next trip.
All users know of this issue and are fine with saving this data. However, if changing the GPS module fixes this issue, removing this data from the logs and the calculations is straightforward.
At the moment a very easy python script is available in the project repo. It uses the pandas module and calculates the summarized travel distance of every user. This easy and functional, yet not very sophisticated approach leads me to the next point:
Improvements and TODOs
Regarding the data analysis, removing the SD card and manually running the data log through a python script seems odd if the ESP32 used as the main MCU features wifi and Bluetooth functionality. So in one of the next steps, it would be nice to use the ESP to do the calculations and show the users statistics on request via a slick web interface.
Regarding the hardware, a PCB is currently in the design stage. It allows the ESP32 to control the power supply of all other devices. This has to be one since the ESP can be...Read more »