Operation Carro Pipa (OCP) is a federal government action in Brazil with the objective of distributing drinking water to regions severely affected by long periods of drought and low rainfall using trucks. The region served has continental dimensions, covering an area of 688,064 km² and supplying 1703 cities and approximately 5.2 million people. Because it is a large-scale action that involves a lot of public resources, it is essential that all OCP activities are recorded in a safe, complete, and standardized way. This information can be used for potential benefits, audits, and analysis to propose improvements and ensure the provision of this essential service to society. To achieve this, this work analyzes data recorded from the OCP service offered in a Brazilian state and presents computational solutions that can improve the monitoring, registration, storage, and processing of the data generated by this action.