Applying Postgis for Storage and Processing of Geospatial Data in Logistics System
Liubomyr Kaptosv , Bechalor Degree in Computer Science, Odesa National University of Technology, smartbarrel.io - Senior Software EngineerAbstract
The relevance of the study is due to the growing needs of logistics companies for high-performance solutions for processing geospatial data, in particular in the context of delivery routing in a dynamic urban environment. Traditional relational DBMSs show limitations in performance and scalability when working with large amounts of spatial information, which complicates the implementation of adaptive logistics algorithms. At the same time, open technologies, in particular PostGIS, are becoming more widespread, but are not sufficiently empirically evaluated in the applied logistics context.
The aim of the study is to develop and empirically test an efficient route construction algorithm based on PostGIS and pgRouting tools to ensure optimization of delivery time in a logistics environment.
The methodology is based on an experimental approach, which involves creating a test environment using PostgreSQL 15, PostGIS 3.3, and pgRouting, as well as implementing a routing algorithm with the pgr_dijkstra function. To evaluate the performance, we used real geodata from the OpenStreetMap road network and simulated sets of delivery points of 100, 1000, and 10,000 objects. PostGIS results were compared to MySQL performance under identical conditions. Metrics included average query execution time, peak values, memory usage, and scalability.
The results of the study showed a significant advantage of PostGIS in the performance of route queries. In particular, when processing 10,000 points, the average query execution time was 6.5 seconds in PostGIS, while in MySQL it was 58.9 seconds, which indicates a ninefold advantage over. A linear relationship between the amount of data and processing time was found, indicating good scalability.
The conclusions suggest that PostGIS with the pgRouting extension is a technologically sound tool for solving routing problems in logistics, providing stable performance, accuracy, and integration with other components of information systems.
Prospects for further research include testing the algorithm in real logistics environments, integration with machine learning methods for predicting transport conditions, and expanding the routing functionality by implementing multi-criteria approaches.
Keywords
geoinformation technologies, route optimization, spatial indexing, logistics data, spatial queries, database scalability
References
Abas, M. A. H., Yassin, I. M., Ali, M. S. A. M., Tahir, N. M., & Zabidi, A. (2021). Extending development of web application system with location data. In 2021 IEEE Symposium on Computers & Informatics (ISCI) (pp. 36–39). IEEE. https://doi.org/10.1109/ISCI51925.2021.9633727
Breunig, M., Bradley, P. E., Jahn, M., Kuper, P., Mazroob, N., Rösch, N., ... & Jadidi, M. (2020). Geospatial data management research: Progress and future directions. ISPRS International Journal of Geo-Information, 9(2), 95. https://doi.org/10.3390/ijgi9020095
Chaudhry, N., & Yousaf, M. M. (2019). Spatial querying of mineral resources using PostGIS. In 2019 2nd International Conference on Advancements in Computational Sciences (ICACS) (pp. 1–6). IEEE. https://doi.org/10.23919/ICACS.2019.8688999
Cui, L., Li, W., Wang, X., & Niu, X. (2022). Design and implementation of open-source WebGIS system for orchard land management. Advances in Computer, Signals and Systems, 6(3), 26–34. https://clausiuspress.com/assets/default/article/2022/08/26/article_1661568424.pdf
Das, B. C., Ahmad, M., & Maqsood, M. (2025). Strategies for spatial data management in cloud environments. In Innovations in Optimization and Machine Learning (pp. 181–204). IGI Global. https://www.igi-global.com/chapter/strategies-for-spatial-data-management-in-cloud-environments/368408
Ellul, C., Loo, R., & Floros, G. (2024). Exploring the potential of NoSQL databases for a BIM and 3D GIS enabled location framework for construction digital twins and the golden thread. ISPRS Annals of the Photogrammetry, Remote Sensing and Spatial Information Sciences, 10, 137–145. https://doi.org/10.5194/isprs-annals-X-4-W5-2024-137-2024
Filho, A. G. G., Borba, P., Silva, V. H. S., Cerdeira, A., & Poz, A. P. D. (2020). Quality control relevance on acquisition of large scale geospatial data to urban territorial management. In 2020 IEEE Latin American GRSS & ISPRS Remote Sensing Conference (LAGIRS) (pp. 138–142). IEEE. https://doi.org/10.1109/LAGIRS48042.2020.9165682
Germinian, J. F., & W. S. T., T. E. (2023). Utilizing PostGIS extension to process spatial data stored in Neo4j database. In 2023 IEEE International Conference on Data and Software Engineering (ICoDSE) (pp. 250–255). IEEE. https://doi.org/10.1109/ICoDSE59534.2023.10291400
Graser, A. (2019). Movingpandas: Efficient structures for movement data in Python. GIForum, 1, 54–68. https://doi.org/10.1553/giscience2019_01_s54
Hataitara, R., Piyathamrongchai, K., & Choosumrong, S. (2024). Development of an emergency notification system to analyze the access route for emergency medical services using Geo-IoT and pgRouting. Applied Geomatics, 16, 441–449. https://doi.org/10.1007/s12518-024-00557-8
Isbaex, C., Costa, F. R. F., & Batista, T. (2025). Application of GIS in the maritime-port sector: A systematic review. Sustainability, 17(8), 3386. https://doi.org/10.3390/su17083386
Kalantari, S., Wang, Y., Sun, S., & Wang, X. (2024). FleetWiz: An Intelligent Platform for Spatio-Temporal Multi-Resource Truckload Fleet Dispatching. In SIGSPATIAL '24: The 32nd ACM International Conference on Advances in Geographic Information Systems (pp. 665–668). ACM. https://doi.org/10.1145/3678717.3691272
Karam, A., Illemann, T. M., & Reinau, K. H. (2020). GPS-derived measures of freight trucks for rest areas: A case-study based analysis. In 2020 IEEE International Conference on Industrial Engineering and Engineering Management (IEEM) (pp. 939–943). IEEE. https://doi.org/10.1109/IEEM45057.2020.9309748
Koubarakis, M., & Pantazi, D. A. (2023). Legacy geospatial data technologies. In Geospatial Data Science: A Hands-on Approach for Building Geospatial Applications Using Linked Data Technologies (pp. 31–52). ACM. https://doi.org/10.1145/3581906.3581910
Li, Z., & Li, D. (2022). Data visualization and interaction of urban traffic logistics management system using WebGIS. Computational Intelligence and Neuroscience, 2022, Article ID 9347247. https://doi.org/10.1155/2022/9347247
Malla, S. R. (2025). A landmark-based addressing framework for urban navigation using geospatial clustering and pathfinding algorithm. Kathmandu University Journal of Science, Engineering and Technology, 19(1). https://journals.ku.edu.np/kuset/article/view/593
Mamatov, I., Galety, M. G., Alimov, R., Sriharsha, A. V., Rofoo, F. F. H., & Sunitha, G. (2024). Geospatial data storage and management. In Ethics, Machine Learning, and Python in Geospatial Analysis (pp. 150–167). IGI Global. https://www.igi-global.com/chapter/geospatial-data-storage-and-management/345908
Millard-Ball, A., Hampshire, R. C., & Weinberger, R. R. (2019). Map-matching poor-quality GPS data in urban environments: The pgMapMatch package. Transportation Planning and Technology, 42(6), 539–553. https://doi.org/10.1080/03081060.2019.1622249
Muljana, R., Deffansyah, S. A., Andrew, H., Gunawan, A. A. S., Irwansyah, E., Pramudya, F. S., & Achmad, S. (2024). GeoBeeDashboard: An intelligent geospatial platform for enhancing waste management in Tangerang City. In 2024 IEEE International Conference on Communication, Networks and Satellite (COMNETSAT) (pp. 320–327). IEEE. https://doi.org/10.1109/COMNETSAT63286.2024.10862220
Natsvlishvili, L., Jorjiashvili, N., & Kochoradze, V. (2022). Development of a PostGIS-based method for creating risk maps of natural disasters using the example of Georgia. Geodesy and Cartography, 48(2), 70–77. https://doi.org/10.3846/gac.2022.14791
Obe, R., & Hsu, L. (2021). PostGIS in action (3rd ed.). Simon and Schuster. https://books.google.com.ua/books?id=6PY8EAAAQBAJ
Patroumpas, K., Skoutas, D., Mandilaras, G., Giannopoulos, G., & Athanasiou, S. (2019). Exposing points of interest as linked geospatial data. In Proceedings of the 16th International Symposium on Spatial and Temporal Databases (pp. 21–30). ACM. https://doi.org/10.1145/3340964.3340976
Puttinaovarat, S., & Horkaew, P. (2021). A geospatial database management system for the collection of medicinal plants. Geospatial Health, 16(2). https://doi.org/10.4081/gh.2021.998
Ryan, K., & W. S. T., T. E. (2023). Structured spatial three-dimensional objects data modeling extension in PostgreSQL. In 2023 IEEE International Conference on Data and Software Engineering (ICoDSE) (pp. 226–231). IEEE. https://doi.org/10.1109/ICoDSE59534.2023.10291378
Sandhya, M. C. (2020). Exploring opportunities with open source GIS. International Journal of Engineering Research & Technology, 9(5), 731–736. https://pdfs.semanticscholar.org/2df4/63f19b38893437124979c3310e52f0b40387.pdf
Sosa-Franco, I., Pérez-Guerra, G., Machado-García, N., & Pérez, M. E. R. (2023). Method for query processing in a geographic information system. Revista Ciencias Técnicas Agropecuarias, 32(2), 1–9. https://www.redalyc.org/articulo.oa?id=93275373008
Sveen, A. F. (2019). Efficient storage of heterogeneous geospatial data in spatial databases. Journal of Big Data, 6, Article 102. https://doi.org/10.1186/s40537-019-0262-8
Vijaya Deepika, V. S., Sri, K. B., Katyayani, V., Sahitya, G., & Rachapudi, V. (2024). A comprehensive study of geospatial data storage mechanisms. In 2024 International Conference on Expert Clouds and Applications (ICOECA) (pp. 87–95). IEEE. https://doi.org/10.1109/ICOECA62351.2024.00029
Xiong, S., Ouyang, X., & Xiong, W. (2023). Distributed or centralized: An experimental study on spatial database systems for processing big trajectory data. In 2023 IEEE 8th International Conference on Big Data Analytics (ICBDA) (pp. 8–13). IEEE. https://doi.org/10.1109/ICBDA57405.2023.10105005
Yen Phan Quoc. (2024). Researching open source WebGIS technology in building software to support optimal search and rescue equipment. Vietnam Journal of Science, Technology and Engineering, 66(3), 15–23. https://doi.org/10.31276/VJSTE.2023.0018
Article Statistics
Copyright License
Copyright (c) 2025 Liubomyr Kaptosv

This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors retain the copyright of their manuscripts, and all Open Access articles are disseminated under the terms of the Creative Commons Attribution License 4.0 (CC-BY), which licenses unrestricted use, distribution, and reproduction in any medium, provided that the original work is appropriately cited. The use of general descriptive names, trade names, trademarks, and so forth in this publication, even if not specifically identified, does not imply that these names are not protected by the relevant laws and regulations.