Best way to store GPS tracking data?

%3CLINGO-SUB%20id%3D%22lingo-sub-2544532%22%20slang%3D%22en-US%22%3EBest%20way%20to%20store%20GPS%20tracking%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2544532%22%20slang%3D%22en-US%22%3E%3CP%3EWe're%20looking%20in%20to%20adding%20GPS%20tracking%20data%20to%20our%20mobile%20app%20in%20order%20to%20track%20the%20location%20of%20independent%20contractor%20drivers.%20There%20may%20be%20as%20many%20as%20500%20drivers%20tracked%20in%20any%20given%20day%2C%20and%20the%20data%20may%20need%20to%20be%20retained%20for%20up%20to%205%20years.%20The%20preview%20feature%20for%20azure%20maps%20data%20service%20looks%20promising%2C%20but%20it%20looks%20more%20geared%20towards%20map%20layers%20and%20geofence%20configurations%20due%20to%20it's%20volume%20limitations.%20Azure%20IoT%20also%20looks%20like%20a%20promising%20platform%20for%20storing%20the%20volume%20of%20data%20involved%2C%20but%20it%20seems%20that%20it%20will%20be%20difficult%20to%20register%20and%20deregister%20devices%20on%20a%20daily%20basis%20as%20the%20independent%20contractors%20come%20and%20go.%26nbsp%3B%20Curious%20if%20anyone%20has%20used%20these%20services%20for%20a%20similar%20use%20case%2C%20or%20if%20there%20may%20be%20other%20storage%20options%20available.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2859600%22%20slang%3D%22en-US%22%3ERe%3A%20Best%20way%20to%20store%20GPS%20tracking%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2859600%22%20slang%3D%22en-US%22%3EAre%20you%20looking%20at%20only%20storing%20data%20or%20being%20able%20to%20analyze%20the%20data%20too%3F%20if%20yes%2C%20what%20type%20of%20analytics%3F%3C%2FLINGO-BODY%3E
New Contributor

We're looking in to adding GPS tracking data to our mobile app in order to track the location of independent contractor drivers. There may be as many as 500 drivers tracked in any given day, and the data may need to be retained for up to 5 years. The preview feature for azure maps data service looks promising, but it looks more geared towards map layers and geofence configurations due to it's volume limitations. Azure IoT also looks like a promising platform for storing the volume of data involved, but it seems that it will be difficult to register and deregister devices on a daily basis as the independent contractors come and go.  Curious if anyone has used these services for a similar use case, or if there may be other storage options available. 

4 Replies
Are you looking at only storing data or being able to analyze the data too? if yes, what type of analytics?

@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.
www.000webhost.com