Modeling Infrastructure Maintenance Contracts in a Geospatial Database

Automation in every field has introduced various means to increase productivity and efficiency. Recently, the road maintenance industry has adopted automation. However, automated scheduling, pricing, budgeting, reporting and invoicing of work are restricted by the provided format of data. In addition, the available information to depict real state of environment and capabilities of machines is also one of the obstacles to automate the aforementioned processes. This research work addresses these problems by modeling the data in database that will automate the processes. This thesis focuses on studying existing models of road. The information from existing road models is extracted and compared with each other. Afterwards, the necessary data comprising of work requirements along with related machinery is studied, and the useful information is extracted. The road model is then fused with the machine and contract data model. This fusion results to give information of roads, machines and work requirements which are missing in currently available information. The implemented approach is validated with the help of real world contract area. This results in providing the model which will automate the maintenance processes. The resulted model is aligned with the expert view