IDEAS home Printed from https://ideas.repec.org/a/gam/jsusta/v17y2025i2p408-d1562073.html
   My bibliography  Save this article

The Impact of Integrating Open Data in Smart Last-Mile Logistics: The Example of Pamplona Open Data Catalog

Author

Listed:
  • Anas Al-Rahamneh

    (GILT-OR, Institute of Smart Cities, Public University of Navarre, 31006 Pamplona, Spain)

  • Adrian Serrano-Hernandez

    (GILT-OR, Institute of Smart Cities, Public University of Navarre, 31006 Pamplona, Spain)

  • Javier Faulin

    (GILT-OR, Institute of Smart Cities, Public University of Navarre, 31006 Pamplona, Spain)

Abstract

Last-mile logistics is one of the most complicated operations in the whole logistic process. This concept describes the final leg of a product travel from a warehouse or hub to specific customers. One of the last-mile logistics challenges that courier delivery companies face is route planning. Ineffective route planning can cause operational delays that cascade and affect several last-mile deliveries. Thus, numerous factors need to be considered to plan and optimize effective delivery routes. These involve many extraordinary and unpredictable events, including weather, traffic conditions, and traffic regulations. A lack of accessible data hinders dynamic, efficient, and reliable route planning, leading to these factors being overlooked. In this paper, we propose the use of open data (OD) to overcome these limitations. OD are information available for anyone to access, reuse, and distribute for free with minimal attribution and sharing restrictions. Therefore, the aim of this work is to examine the impact of incorporating specific open data elements on the performance of the Clarke and Wright algorithm, particularly in calculating savings, and identifying optimal routes. The results we obtained showed the effect of considering OD with an increase rate of approximately 2% on the total distance compared to not considering them.

Suggested Citation

  • Anas Al-Rahamneh & Adrian Serrano-Hernandez & Javier Faulin, 2025. "The Impact of Integrating Open Data in Smart Last-Mile Logistics: The Example of Pamplona Open Data Catalog," Sustainability, MDPI, vol. 17(2), pages 1-18, January.
    • Handle: RePEc:gam:jsusta:v:17:y:2025:i:2:p:408-:d:1562073
    as

    Download full text from publisher

    File URL: https://www.mdpi.com/2071-1050/17/2/408/pdf
    Download Restriction: no
    File URL: https://www.mdpi.com/2071-1050/17/2/408/
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Kwon, Jaimyoung & Mauch, Michael & Varaiya, Pravin, 2006. "Components of Congestion: Delay from Incidents, Special Events, Lane Closures, Weather, Potential Ramp Metering Gain, and Excess Demand," University of California Transportation Center, Working Papers qt31c9k717, University of California Transportation Center.
    2. John Olsson & Daniel Hellström & Henrik Pålsson, 2019. "Framework of Last Mile Logistics Research: A Systematic Review of the Literature," Sustainability, MDPI, vol. 11(24), pages 1-25, December.
    3. Mengke Li & Yongkui Shi & Meiyan Li, 2023. "Solving the Vehicle Routing Problem for a Reverse Logistics Hybrid Fleet Considering Real-Time Road Conditions," Mathematics, MDPI, vol. 11(7), pages 1-19, March.
    4. Paulina Golinska-Dawson & Kanchana Sethanan, 2023. "Sustainable Urban Freight for Energy-Efficient Smart Cities—Systematic Literature Review," Energies, MDPI, vol. 16(6), pages 1-28, March.
    5. G. Clarke & J. W. Wright, 1964. "Scheduling of Vehicles from a Central Depot to a Number of Delivery Points," Operations Research, INFORMS, vol. 12(4), pages 568-581, August.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Gong, Manlin & Hu, Yucong & Chen, Zhiwei & Li, Xiaopeng, 2021. "Transfer-based customized modular bus system design with passenger-route assignment optimization," Transportation Research Part E: Logistics and Transportation Review, Elsevier, vol. 153(C).
    2. Smith, John Paul, 1974. "A Lockset analysis of farm to plant milk assembly," ISU General Staff Papers 1974010108000018144, Iowa State University, Department of Economics.
    3. Bahram Alidaee & Haibo Wang & Lutfu S. Sua, 2023. "The Last-Mile Delivery of Heavy, Bulky, Oversized Products: Literature Review and Research Agenda," Logistics, MDPI, vol. 7(4), pages 1-16, December.
    4. Tomislav Letnik & Katja Hanžič & Giuseppe Luppino & Matej Mencinger, 2022. "Impact of Logistics Trends on Freight Transport Development in Urban Areas," Sustainability, MDPI, vol. 14(24), pages 1-18, December.
    5. Jumbo, Olga & Moghaddass, Ramin, 2022. "Resource optimization and image processing for vegetation management programs in power distribution networks," Applied Energy, Elsevier, vol. 319(C).
    6. Leloup, Emeline & Paquay, Célia & Pironet, Thierry & Oliveira, José Fernando, 2025. "A three-phase algorithm for the three-dimensional loading vehicle routing problem with split pickups and time windows," European Journal of Operational Research, Elsevier, vol. 323(1), pages 45-61.
    7. Bartosz Sawik, 2024. "Optimizing Last-Mile Delivery: A Multi-Criteria Approach with Automated Smart Lockers, Capillary Distribution and Crowdshipping," Logistics, MDPI, vol. 8(2), pages 1-29, May.
    8. Martins, Sara & Ostermeier, Manuel & Amorim, Pedro & Hübner, Alexander & Almada-Lobo, Bernardo, 2019. "Product-oriented time window assignment for a multi-compartment vehicle routing problem," European Journal of Operational Research, Elsevier, vol. 276(3), pages 893-909.
    9. Zi-bin Jiang & Qiong Yang, 2016. "A Discrete Fruit Fly Optimization Algorithm for the Traveling Salesman Problem," PLOS ONE, Public Library of Science, vol. 11(11), pages 1-15, November.
    10. A. Scholz & G. Wäscher, 2017. "Order Batching and Picker Routing in manual order picking systems: the benefits of integrated routing," Central European Journal of Operations Research, Springer;Slovak Society for Operations Research;Hungarian Operational Research Society;Czech Society for Operations Research;Österr. Gesellschaft für Operations Research (ÖGOR);Slovenian Society Informatika - Section for Operational Research;Croatian Operational Research Society, vol. 25(2), pages 491-520, June.
    11. Qi, Mingyao & Lin, Wei-Hua & Li, Nan & Miao, Lixin, 2012. "A spatiotemporal partitioning approach for large-scale vehicle routing problems with time windows," Transportation Research Part E: Logistics and Transportation Review, Elsevier, vol. 48(1), pages 248-257.
    12. Bahareh Mansouri & Subhasmita Sahu & M. Ali Ülkü, 2023. "Toward Greening City Logistics: A Systematic Review on Corporate Governance and Social Responsibility in Managing Urban Distribution Centers," Logistics, MDPI, vol. 7(1), pages 1-20, March.
    13. Srinivas, Sharan & Ramachandiran, Surya & Rajendran, Suchithra, 2022. "Autonomous robot-driven deliveries: A review of recent developments and future directions," Transportation Research Part E: Logistics and Transportation Review, Elsevier, vol. 165(C).
    14. Derigs, U. & Kaiser, R., 2007. "Applying the attribute based hill climber heuristic to the vehicle routing problem," European Journal of Operational Research, Elsevier, vol. 177(2), pages 719-732, March.
    15. Almoustafa, Samira & Hanafi, Said & Mladenović, Nenad, 2013. "New exact method for large asymmetric distance-constrained vehicle routing problem," European Journal of Operational Research, Elsevier, vol. 226(3), pages 386-394.
    16. César Rego, 1998. "A Subpath Ejection Method for the Vehicle Routing Problem," Management Science, INFORMS, vol. 44(10), pages 1447-1459, October.
    17. van Gils, Teun & Ramaekers, Katrien & Braekers, Kris & Depaire, Benoît & Caris, An, 2018. "Increasing order picking efficiency by integrating storage, batching, zone picking, and routing policy decisions," International Journal of Production Economics, Elsevier, vol. 197(C), pages 243-261.
    18. Pedro Cesar Lopes Gerum & Andrew Reed Benton & Melike Baykal-Gürsoy, 2019. "Traffic density on corridors subject to incidents: models for long-term congestion management," EURO Journal on Transportation and Logistics, Springer;EURO - The Association of European Operational Research Societies, vol. 8(5), pages 795-831, December.
    19. Fleming, Christopher L. & Griffis, Stanley E. & Bell, John E., 2013. "The effects of triangle inequality on the vehicle routing problem," European Journal of Operational Research, Elsevier, vol. 224(1), pages 1-7.
    20. Snežana Tadić & Mladen Krstić & Ljubica Radovanović, 2024. "Assessing Strategies to Overcome Barriers for Drone Usage in Last-Mile Logistics: A Novel Hybrid Fuzzy MCDM Model," Mathematics, MDPI, vol. 12(3), pages 1-25, January.

    More about this item

    Keywords

    ;
    ;
    ;
    ;
    ;
    ;

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:gam:jsusta:v:17:y:2025:i:2:p:408-:d:1562073. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: MDPI Indexing Manager (email available below). General contact details of provider: https://www.mdpi.com .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.