Skip to content
FME in Action Customer Stories Wellington City Council & Locus boost efficiency by automating key processes

Wellington City Council & Locus boost efficiency by automating key processes

By automating the flow of road asset data between systems, Wellington City Council removes manual processing while saving time and resources.
Wellington Harbour in NZ Wellington Harbour in NZ

This work was done in collaboration with Safe Software partner Locus.


A data synchronization challenge

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, 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 previously a manual process with a duplication of effort and risk of data entry errors.

An automated solution

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 an 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.

“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
Safe product icons
Reach out and get started with FME today

Real change is just a platform away.