Creating a Database Model for Road Projects in the City of Bani Walid Using Geographic Information Systems (GIS)

Abstract

The study aims to utilize Geographic Information Systems (GIS) technology and applications to develop a system for documenting and compiling road data for the city of Bani Walid and archiving it electronically. It also seeks to convert all paper-based data into digital data in the form of interactive maps, as well as to benefit from this technology in creating interactive maps that help and facilitate the concerned authorities in accessing information about each road quickly and accurately, without the need to search for each road individually among a large collection of documents.

After conducting research and visiting the relevant authorities, the data obtained was found to be limited and scattered across several sources. A database for the city was created using ArcGIS 10.3, and the data was entered, processed, and analyzed. The roads in the city were then classified functionally according to the Libyan Road Engineering Design Standards issued by the Roads and Bridges Authority. The results were presented in an interactive map showing the type of each road, which facilitates a better understanding and more effective management of the road network.

An interactive map was also created to display the pavement condition index (PCI) for each road, using colors to indicate the condition level of each road: Excellent, Good, Fair, Poor, Very Poor, Serious, and Failed. This interactive map will enable the concerned authorities to quickly understand the condition of the city's road network, eliminating the need for manual searches through documents or checking each road individually. This approach saves time and effort and makes the monitoring process more efficient.

The study presents several recommendations, the most important of which are: expanding this database to include all roads in the city, increasing the availability of data, abandoning paper-based archiving and replacing it with electronic archiving through GIS programs to preserve the data, facilitate access to it among relevant authorities, and benefit from the technology’s ability to store large amounts of data in an organized and well-structured manner without loss or damage.