Three-Tier Disaster Logistics System Integrating GIS and MILP Optimization
DOI:
https://doi.org/10.30871/jaic.v10i3.12727Keywords:
Three-Tier Architecture, Disaster Logistics, GIS, MILP Optimization, Design Science ResearchAbstract
Effective disaster logistics management requires rapid, data-driven decision support that bridges optimization theory and operational practice. Existing systems either rely on theoretical models without implementable software, on proprietary datasets that restrict independent reconstruction, or lack validated prototypes in the Indonesian disaster context — three gaps that persist across the disaster IS literature. This study presents a three-tier web-based disaster logistics management IS integrating GIS and MILP optimization, built exclusively on public data sources (BNPB DIBI and OpenStreetMap). Using Design Science Research (DSR) across five phases, the system employs an open-source stack: Laravel 11.x presentation layer, PostgreSQL 16/PostGIS data layer, and Python FastAPI as a dedicated MILP microservice. The MILP model, a two-phase lexicographic MILP formulation with trips-aware vehicle capacity constraints is solved using the PuLP 3.3.0 + CBC solver. Three integrated modules were developed: shelter management, warehouse inventory, and logistics coordination with GIS visualization. Functional testing achieved 100% pass rate across 85 automated test cases covering all system modules, with 246ms mean response time under 50 concurrent users. The MILP solver resolved a 20-shelter problem in 0.094 seconds (99.9% below the 120-second operational planning threshold); scalability testing confirms tractability from 10 to 50 shelters (0.011–0.111 seconds), with Priority-1 shelters consistently served under both sufficient and scarce fleet conditions. Sensitivity analysis confirms lexicographic priority objectives activate correctly under resource scarcity. Comparative evaluation against heuristic and metaheuristic approaches confirms exact MILP is appropriate for the strategic planning scope of this proof-of-concept (n ≤ 50 shelters). Expert validation via ISO 25010 yielded a weighted score of 4.21/5. Usability testing with 25 participants produced a SUS score of 74.8 (Grade B, above-average per established SUS benchmarks) with 88% task completion rate. The primary contributions are a MILP-IS microservices integration pattern with explicit API specification, a comprehensively documented public-data-only implementation framework, and a proof-of-concept that closes the implementation gap between disaster logistics optimization research and operational IS deployment.
Downloads
References
[1] Badan Nasional Penanggulangan Bencana, “Data Informasi Bencana Indonesia (DIBI),” https://dibi.bnpb.go.id. 2025.
[2] L. Özdamar and O. Demir, “A hierarchical clustering and routing procedure for large scale disaster relief logistics planning,” Transp. Res. Part E Logist. Transp. Rev., vol. 48, no. 3, pp. 591–602, 2012, doi: 10.1016/j.tre.2011.11.003.
[3] M. S. Rohman et al., “Strategic Route Planning for Disaster Relief in Palu, Indonesia: A MILP Model Incorporating GIS Data,” Ing. Syst. Inf., vol. 30, no. 7, pp. 1869–1879, Jul. 2025, doi: 10.18280/isi.300719.
[4] F. Mulyani, A. G. Bintoro, and T. J. Ai, Mixed Integer Linear Programming untuk Pemodelan Distribusi Logistik Bencana, vol. 4. Prosiding Seminar RiTekTra, 2014. [Online]. Available: www.ritektra.web.id
[5] C. Boonmee, M. Arimura, and T. Asada, “Facility location optimization model for emergency humanitarian logistics,” International Journal of Disaster Risk Reduction, vol. 24. Elsevier Ltd, pp. 485–498, Sep. 2017. doi: 10.1016/j.ijdrr.2017.01.017.
[6] L. Yu, C. Zhang, J. Jiang, H. Yang, and H. Shang, “Reinforcement learning approach for resource allocation in humanitarian logistics,” Expert Syst. Appl., vol. 173, p. 114663, 2021, doi: https://doi.org/10.1016/j.eswa.2021.114663.
[7] R. Dubey, A. Gunasekaran, S. J. Childe, S. F. Wamba, D. Roubaud, and C. Foropon, “Empirical investigation of data analytics capability and organizational flexibility as complements to supply chain resilience,” Int. J. Prod. Res., vol. 59, no. 1, pp. 110–128, 2021, doi: 10.1080/00207543.2019.1582820.
[8] H. Sun, J. Li, T. Wang, and Y. Xue, “A novel scenario-based robust bi-objective optimization model for humanitarian logistics network under risk of disruptions,” Transp. Res. Part E Logist. Transp. Rev., vol. 157, Jan. 2022, doi: 10.1016/j.tre.2021.102578.
[9] B. Ehsani, H. Karimi, A. Bakhshi, A. Aghsami, and M. Rabbani, “Designing humanitarian logistics network for managing epidemic outbreaks in disasters using Internet-of-Things. A case study: An earthquake in Salas-e-Babajani city,” Comput. Ind. Eng., vol. 175, Jan. 2023, doi: 10.1016/j.cie.2022.108821.
[10] Sahana Software Foundation, “Sahana Eden: Emergency Development Environment,” https://sahanafoundation.org. 2019.
[11] OpenStreetMap, “OpenStreetMap,” https://www.openstreetmap.org. 2024.
[12] K. Peffers, T. Tuunanen, M. A. Rothenberger, and S. Chatterjee, “A design science research methodology for information systems research,” J. Manag. Inf. Syst., vol. 24, no. 3, pp. 45–77, Dec. 2007, doi: 10.2753/MIS0742-1222240302.
[13] S. Gregor and A. R. Hevner, “Positioning and Presenting Design Science Research for Maximum Impact1,” MIS Q., vol. 37, no. 2, pp. 337–355, Jun. 2013, doi: 10.25300/MISQ/2013/37.2.01.
[14] T. Kravchenko, T. Bogdanova, and T. Shevgunov, “Ranking Requirements Using MoSCoW Methodology in Practice,” in Cybernetics Perspectives in Systems. CSOC 2022. Lecture Notes in Networks and Systems, Cham: Springer, 2022, pp. 188–199. doi: 10.1007/978-3-031-09073-8_18.
[15] N. Fawwazi, M. S. Rohman, N. A. S. Winarsih, Y. P. Astuti, and D. O. Ratmana, “Rancang Bangun Aplikasi Pencatat Kehadiran Asisten Berbasis Android Dengan Metode Agile Untuk Laboratorium Komputer Universitas Dian Nuswantoro,” J. Manaj. Inform. Sist. Inf. MISI, vol. 7, no. 2, Jun. 2024, doi: 10.36595/misi.v5i2.
[16] D. O. Ratmana, M. S. Rohman, F. Firdausillah, and G. W. Saraswati, “Perancangan Aplikasi Perhitungan Beban Kerja Dosen Terintegrasi Dengan Pendekatan Waterfall,” J. Teknoif Tek. Inform. Inst. Teknol. Padang, vol. 12, no. 2, pp. 139–148, Oct. 2024, doi: 10.21063/jtif.2024.V12.2.139-148.
[17] International Organization for Standardization, “ISO/IEC 25010:2023 — Systems and Software Engineering — Systems and Software Quality Requirements and Evaluation (SQuaRE) — Product Quality Model,” International Organization for Standardization, Geneva, Switzerland, Standard ISO/IEC 25010:2023, Nov. 2023. [Online]. Available: https://www.iso.org/standard/78176.html
[18] L. Natsvlishvili, N. Jorjiashvili, and V. Kochoradze, “Development Of A Postgis-Based Method For Creating Risk Maps Of Natural Disasters Using The Example Of Georgia,” Geod. Cartogr., vol. 48, no. 2, pp. 70–77, Jun. 2022, doi: 10.3846/gac.2022.14791.
[19] R. H. Ballou, H. Rahardja, and N. Sakai, “Selected country circuity factors for road travel distance estimation,” Transp. Res. Part Policy Pract., vol. 36, no. 9, pp. 843–848, Nov. 2002, doi: 10.1016/S0965-8564(01)00044-1.
[20] A. Bangor, P. T. Kortum, and J. T. Miller, “An Empirical Evaluation of the System Usability Scale,” Int. J. Human–Computer Interact., vol. 24, no. 6, pp. 574–594, Jul. 2008, doi: 10.1080/10447310802205776.
[21] J. Sauro and J. R. Lewis, Quantifying the User Experience: Practical Statistics for User Research. Waltham, MA: Morgan Kaufmann, 2012.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 Danny Oka Ratmana, Muhammad Syaifur Rohman, Galuh Wilujeng Saraswati, Filmada Ocky Saputra, Aprilyani Nur Safitri, Imanuel Harkespan
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License (Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) ) that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
