Enhancing Infrastructure Asset Management in Adama City through Spatial Database Management System and Web Based Geographical Information System

Abstract

Infrastructure Asset Management Is Crucial For Ensuring The Long-Term Sustainability And Performance Of Urban Systems. Adama City, Like Many Developing Urban Centers, Faces Challenges In Effectively Managing Its Infrastructure Assets. Despite The Growing Significance Of This Domain, There Is A Research Gap In Understanding And Enhancing Infrastructure Asset Management Practices Tailored To The Local Context Of Adama City. This Study Aims To Evaluate And Improve The Infrastructure Asset Management Practices In Adama City By Implementing A Spatial Database Model And Leveraging Open-Source Tools. The Research Methodology Involves Data Collection, Assessment Indicator Development, Data Analysis, Gap Identification, Requirement Analysis, Geodatabase Design, And Web-GIS Implementation. The Assessment Of The Current Infrastructure Asset Management System In Adama City Reveals Several Areas That Require Improvement, Including The Inventory System, Data Storage And Management, Road Condition Assessment, Decision-Making Processes, Operational Planning, Maintenance Planning, Capital Works Planning, And Information Systems. To Address These Identified Gaps, The Study Developed A Geodatabase Model Using Arcgis And Postgresql With Postgis Extension. This Model Demonstrated Its Effectiveness In Organizing And Managing Infrastructure And Utility Data. Furthermore, A Web-Based GIS Application Was Implemented Using The Qgis2web Plugin Of QGIS, Enabling Users To Interact With The Infrastructure Data Through A User-Friendly Interface. The Research Findings Suggest That There Are Ample Open-Source Opportunities To Improve Infrastructure Asset Management Systems In Developing Countries Like Adama City. The Spatial Database Model And Web-GIS Application Developed In This Study Can Serve As A Template For Other Municipalities To Enhance Their Infrastructure Asset Management Practices And Foster Collaboration And Data-Driven Decision-Making.