Real-Time GPS Data Collection and Reporting System for Business Travel

Project Description:

In this project, I will use an ESP32 microcontroller combined with a SIM800L GSM module and a NEO-7M GPS sensor to collect GPS data and send it to a RabbitMQ server. On the server side, I will process the data to determine the start and stop coordinates of each trip and calculate the distance traveled between these points.

The motivation for this project stems from the Dutch tax system, which imposes a tax called "bijtelling" on the private use of company cars. By accurately reporting the coordinates for each business trip, it is possible to demonstrate that the car is used solely for business purposes, thereby avoiding the bijtelling tax. My goal is to create a real-time reporting tool that automatically calculates and logs all travel data, generating monthly reports.

While there are existing products on the market that collect geolocation data for cars, I couldn't find one that offers programmability features. Most of them only provide a map interface. Therefore, I decided to build this project myself to meet my specific needs.

Project Components:

• ESP32 Microcontroller
• SIM800L GSM Module
• NEO-7M GPS Sensor
• RabbitMQ
• FastAPI
• PostgreSQL

This project is ongoing, and I will update this page with progress as it develops.