CUSTOMER SUCCESS STORY
Wellington City Council’s Time-Saving Automation
By establishing an automated FME pipeline between the RAMM API and the corporate GIS platform, Wellington City Council has replaced an ad-hoc, manual data entry process with a hands-off weekly synchronization that completely eliminates duplication of effort.
700km of road synchronized
Managing network-wide data alignment across New Zealand’s capital city
Hands-off weekly automation
Converts a highly manual, time-pressured task into a scheduled background process
Zero data duplication
Eliminates the risk of human entry errors when bridging core operational platforms
Multi-asset coverage
Keeps signs, street lighting, traffic systems, bridges, parking, footpaths, and cycleways aligned
Automating the flow of roading asset data from RAMM to GIS means that WCC staff using the GIS data can be confident that the Transport data is current and correct. This saves the Transport team a lot of time having to either manually supply the data or fixing out-of-date GIS data.”
– Kirsten Brown, Infrastructure Data Analyst, Wellington City Council
The Challenge
Eliminating Manual Synchronization Risks Between Disparate Systems
Wellington City Council (WCC) is a territorial authority governing New Zealand’s capital city, Wellington. The Council is responsible for a range of services to support the environmental, social, cultural and economic wellbeing of the wider community. This includes the administration of transport infrastructure, including roads and bridges and associated assets.
There are approximately 700km of road under WCC’s management control. WCC uses RAMM (Road Asset Maintenance and Management) as the master Asset Management System for assets associated with the roading network. These include signs, street lighting, traffic systems, bridges, parking, footpaths, and cycleways. These roading assets also need to be stored in WCC’s ESRI GIS system. Both systems must remain up-to-date and synchronized. The standard tools in RAMM support the addition, amendment, and deletion of assets. Keeping GIS aligned with RAMM was a manual process that had a duplication of effort, with a risk of data entry errors.
Harmonizing Data Platforms with FME Automation
Determined to find a smarter and more efficient means to keep the systems in-check as well as reduce the possibility of human error, Wellington City Council Infrastructure Data Analyst Kirsten Brown devised a FME powered solution to harmonize the data between systems.
Developing an automation workflow in FME, a connection between the RAMM API and the WCC GIS system was established and what had been an ad-hoc hands-on data processing task (sometimes not done due to time pressure) became a hands-off weekly scheduled automation.
The Results
Complete Confidence in Asset Accuracy
Automating the flow of roading asset data from RAMM to GIS means that WCC staff using the GIS data can be confident that the Transport data is current and correct. This saves the Transport team a lot of time having to either manually supply the data or fixing out-of-date GIS data.
Why it Matters
By automating the flow of road asset data between systems, Wellington City Council removes manual processing while saving time and resources.
By utilizing FME to orchestrate proprietary asset management APIs and central GIS geodatabases, municipal infrastructure operators can completely eliminate manual data updates and administrative bottlenecks. Automating these data synchronization loops ensures that operational field teams and asset managers are continually working with identical, verified information, transforming isolated software silos into a trustworthy, real-time repository for critical city infrastructure.
Success Stories
Powered by Locus Expertise
Road Data Revolution: Wellington City Council’s Time-Saving Automation
Wellington City Council revolutionised road asset data management by automating processes, saving time and resources. Kirsten Brown, Infrastructure Data Analyst, introduced a solution using FME to ensure effortless synchronisation between systems, benefiting the Transport team with current and accurate data.