Forum Discussion
Best way to store GPS tracking data?
Seshagiri-AzureMaps we need to both store and perform some informal analytics - mostly UI display. At present, we have architected the solution to transmit data points to an Azure IoT Hub instance. When the message arrives, we use an Azure function to process the incoming JSON, and perform any required alerting or special handling of the data. The function then converts the JSON location point to a csv format where it it written to append blob storage with a file for each device for each day. the idea being that the csv is smaller, thus less costly, to store in the blob. Post processing, the data will be occasionally displayed as a route map for an end user, but may also be analyzed at a later date to determine geofence entry and exit times.
Woody0 thank you for the reply. Can you confirm what is the interval at which the GPS location is collected from your feet (e.g., every 30 seconds etc). The current Spatial services were specifically designed for geofence scenarios and not for storage, we will evaluate if we can build something targeting storage.
- Seshagiri-AzureMaps Thank you for your follow-up. I recall choosing not to store the data within Azure Maps as the capacity of an Azure Maps tenant wasn't capable of containing the volume of data we would need to store long term at a cost effective basis. We are still testing the number of points we would be collecting - the plugin we are using only records when in motion, and starts with every 10 meters of change in distance. As speed increases it uses an elastic concept to collect fewer points at higher speeds. The number of sample points will be highly variable based on distance and speed. The best estimate I have now is approximately 10 points per minute per vehicle for a sample route.