Need to check and correct or rebuilt function of collection and uploading gps data from the RPI to the server database in order to guarantee to keep all gps track data on the server without any missing.
Budget: $30 – $250 USD
The python code readpin.py is running on the RPI as service and upload to the server recorded video files and gps data via 3g. The process of gps data uploading to the server stopped sometimes randomly. As a result, the web app is not getting gps tracking data to the database for the reports. Need to fix it.
GPS data of the bus are keeping in db table gps_points on the server. Need to provide guaranteed transfer actual all gps data, without any skipping to the server. We need to provide gps data in the db table “gps_points” with time interval of GPS data not more than 5 sec.
The current situation:
php code var/www/bus_tracker/app/Gps.php on the server records gps data to the db table “gps_points”, then this gps data are using in the db table “passed_bus_stops” for “Intercity report” creating. The python code on the Raspberry Pi also records video files with gps data in the file name and sends them to the server too.
When we check the db table “gps_points” we can see that there are not all gps data for all time from the RPI. As the result we are getting not correct db table “passed_bus_stops” and “Intercity Reports”. Also, some times, we can see that the video files uploaded to the server has similar gps coordinate, however we can see on the video that the bus is running.
We exclude hardware reasons of this gps issue because the app FoxtrotGPS which is running on the RPI and show gps tracking monitor is running without problem always.
Also need to check if the column “crated_at” of table “pgs_points” keeps the time of creation gps data on the RPI or it is the time of recorded this data to the server, it should be the time of created_at on the RPI, it should be the time of gps data creation on the RPI, if it is not right it needs to correct.
GPS data of the bus are keeping in db table gps_points on the server. Need to provide guaranteed transfer actual all gps data, without any skipping to the server. We need to provide gps data in the db table “gps_points” with time interval of GPS data not more than 5 sec.
The current situation:
php code var/www/bus_tracker/app/Gps.php on the server records gps data to the db table “gps_points”, then this gps data are using in the db table “passed_bus_stops” for “Intercity report” creating. The python code on the Raspberry Pi also records video files with gps data in the file name and sends them to the server too.
When we check the db table “gps_points” we can see that there are not all gps data for all time from the RPI. As the result we are getting not correct db table “passed_bus_stops” and “Intercity Reports”. Also, some times, we can see that the video files uploaded to the server has similar gps coordinate, however we can see on the video that the bus is running.
We exclude hardware reasons of this gps issue because the app FoxtrotGPS which is running on the RPI and show gps tracking monitor is running without problem always.
Also need to check if the column “crated_at” of table “pgs_points” keeps the time of creation gps data on the RPI or it is the time of recorded this data to the server, it should be the time of created_at on the RPI, it should be the time of gps data creation on the RPI, if it is not right it needs to correct.