Study on the Open Data System for Infrastructure Maintenance and Management

In Japan, periodic inspection of social infrastructure is compulsory every five years. Consequently, after infrastructure inspection, many valuable data sets are accumulated. In Yamaguchi Prefecture, however, data are managed using an Excel file format. This makes it difficult and inefficient to extract information from data. Also, incorrect data input can occurs, because data are input manually by a person. In response to this problem, the authors developed a data extraction and conversion system. Which extracts a specific range of Excel format data and converts it to JSON format, making it easier to utilize information by correlating data based on bridge inspection data. By using such a data modification system with Google Map, incorrect data can be identified and corrected. Furthermore, an open data Web API system structure was developed, for future visualizations and analysis. The paper will conclude the authors assessment of the performance of those systems as well as their thoughts on the future utilization of bridge inspection data.