Integrating Legacy and OTL Data for Enhanced Asset Management at The Agency for Roads and Traffic (AWV)

The Agency for Roads and Traffic (AWV) manages road infrastructure in Flanders and has developed the Object Type Library (OTL) to enhance asset management. This development is phased, resulting in a mix of legacy data and OTL data, which sometimes overlaps and can be contradictory. The integration project aims to consolidate all legacy data into the OTL database, creating a single, consistent dataset without duplicates or inconsistencies. To achieve this goal, various technologies are used: 1. Data retrieval: Data is extracted from original databases via API calls. 2. Data storage: Data is stored in a PostGIS database, serving as the source for further analysis. 3. Reporting in standardized Excel files: Assets are analyzed to identify corresponding items, and differences between corresponding legacy and OTL assets are presented to the business through user-friendly Excel reports. 4. Geographic visualization: Geographic data is visualized in ArcGIS Online. 5. Processing of business decisions: The business records decisions regarding which assets, values, and geometries to retain in the reports. This input is then processed to update the OTL database through API calls and by uploading JSON files into an AWV-specific tool. During the project, both systems remain active, meaning that changes on both the legacy and OTL sides must be captured. Automated FME processes enable this cycle to be repeated until the OTL is fully synchronized with the legacy system.