Geospatial Database for Maintaining Produce Quality

A system for managing quality of perishable items traveling in a supply chain, comprising:

• one or more processors including memory;
• a geospatial database system comprising:
• one or more inputs through which information concerning the perishable items and the transporting of same are delivered to the system;
• data storage levels configured to collect and store data concerning the perishable items, the environmental conditions to which the perishable items are exposed, and the transporting of the perishable items to a final destination;
• a calculation region in which, based on the data, an estimated remaining salable lifetime of the perishable items and manners of preserving the estimated remaining salable estimated lifetime of the perishable items are determined;
• and
• outputs in which collected data and determinations are distributed.

A computer program product of managing quality of a perishable items traveling in a supply chain, the computer program product comprising a non-transitory computer readable storage medium having program instructions embodied therewith, the program instructions being executable by a computer to cause the computer to perform a method comprising:

• determining an initial estimated salable lifetime of perishable items;
• in real time, reducing the initial estimated salable lifetime to an estimated remaining salable lifetime in a determination based on information comprising one or more conditions relating to the environment to which the perishable items are exposed and the transporting of the perishable items to a final destination;
• determining a manner of preserving the estimated remaining salable lifetime of the perishable items by at least one of slowing the depletion of the estimated remaining salable lifetime and changing a transportation itinerary of the perishable items;
• and
• performing at least one of slowing the depletion of the estimated remaining salable lifetime and changing the transportation itinerary in accordance with the determination to preserve the estimated remaining salable lifetime of the perishable items.