GPS Tracking

A data collection firm records pings from the full fleet of delivery trucks on a real time basis and provides a file that resides on an external server. A system was designed that polls this server every 10 minutes, downloads the file when available, converts this text data and then stores this information in SQL tables. From this point, algorithms were designed to determine the exact locations and ascertain if a delivery store was reached and tags this as the arrival time. This information is then employed to determine unload time and consequently pay based on union contracts. Also, this information is accessed to map each truck via google maps. Since many city deliveries are made and traffic can skew the results, calculations are performed to eliminate stops, one way streets, pings echoing off buildings, and passing of non-scheduled stores.