Development of road condition database based on geographical information system and pavement condition index method

Abstract

The data about the road conditions must be managed properly to ensure the safety and accessibility of information in the context of road maintenance. The present study aims to create a reliable and accessible database which able to store road conditions data. The method was by combining the Pavement Condition Index (PCI) method with Google Maps, XAMPP, Notepad ++ and Botstrap software. The results of the analysis obtained several parameters of road conditions, including road damages, PCI values, density, deduct value and corrected deduct value. The developed website design is a GIS-based database application with the display of two main menus, namely the “ROAD DATA” menu and the “SURVEY ROAD MAP” menu. The first menu contains data on road conditions from the analysis using the PCI method, while the second menu contains a map of the distribution of points of the road segments for every distance of 1 km. Information related to how to use the database is displayed in the application manual which contains how to activate XAMPP, Apache, and MySQL and also the website on localhost, as well as how to display road condition data.The data about the road conditions must be managed properly to ensure the safety and accessibility of information in the context of road maintenance. The present study aims to create a reliable and accessible database which able to store road conditions data. The method was by combining the Pavement Condition Index (PCI) method with Google Maps, XAMPP, Notepad ++ and Botstrap software. The results of the analysis obtained several parameters of road conditions, including road damages, PCI values, density, deduct value and corrected deduct value. The developed website design is a GIS-based database application with the display of two main menus, namely the “ROAD DATA” menu and the “SURVEY ROAD MAP” menu. The first menu contains data on road conditions from the analysis using the PCI method, while the second menu contains a map of the distribution of points of the road segments for every distance of 1 km. Information related to how to use the database is displayed in the application manual which contains how...