The development of road evaluation and monitoring system using database application

Road infrastructure is one of a nation’s strategic assets. It accommodates the basic human needs to move from one place to another place in order to fulfill their needs. In Furthermore, to keep its optimum service level, this infrastructure requires a routine maintenance. In the present study, road geometric data, road distress type, road distress gps coordinates and cost estimation are integrated into one road maintenance database application. By doing data integration, the user can easily analyze the pavement maintenance strategies, and eventually this system database will give good contribution towards decision making process to achieve reliable road maintenance system and sustainable pavement. The observed road pavements were Joko Tingkir, Monginsidi, Ir. Juanda and Kyai Mojo—all of these are under the authority of Public Works Agency of Surakarta City Government. Relevant data were acquired by conducting field observation. The web database application is developed as a standalone extension from previously android-based application called Road Evaluation And Monitoring System (REMS). GPS coordinates, PCI index value derived from the calculation of distress type, distress area or volume and its deduct value were generated from REMS application. Distress type and severity was used to determine the maintenance method. Bina Marga’s standardized unit price indices and each road distress volume or area were used as base calculation to obtain final work unit price. The estimated maintenance cost for Joko Tingkir road is Rp28,087,654.29, Monginsidi road is Rp46,784,249.87, Ir. Juanda road is Rp266,780,014.78 and Kyai Mojo road is Rp76,584,885.27. All of the calculation results are displayed on the web-based interactive map layer, graph and tables for each of the observed roads. The table of road distress, maintenance and treatment recommendation are also displayed for detailed analysis.