Better reporting
Time saved
Data quality improved

The Challenge

Herefordshire Council’s residents report potholes using a form on the Council website, but not all roads or road segments are the responsibility of the Council – some are maintained by third parties. The Council were receiving many reports of potholes which were on roads of which they were not responsible. This was consuming the time and resource of administrative staff, and also negatively impacting the satisfaction of those reporting potholes.

The Council’s Local Street Gazetteer contains the necessary road maintenance data, however this is stored in Aligned Assets Symphony Gazetteer, which is not compatible with the Council’s online report submission system.

FME logo on the screen of a laptop

The Solution

The Council needed a way to identify who was responsible for maintaining a road segment before the reporter submitted the form, so that they would be redirected to the correct and appropriate organisation (if that was not the Council).

  • Extract and Validate: LSG Data is pulled from the Symphony Gazetteer and validated.
  • Transform: The data is transformed into a format that can be used by their online system.
  • Load: Validated data is loaded into the database running the website.

When the reporter inputs the pothole location, the website can now establish whether the road segment is managed by the Council. If not, the customer is redirected to the applicable organisation before they finish reporting. This has improved user satisfaction, and has prevented the Council receiving reports for roads outside of their control, saving time and resource.

Hoople utilise ETL capability of FME to improve customer service

FME® automates data manipulation and transformation

Data rarely arrives in your environment in a state that’s ready to use. The repetitive tasks required to get it into a usable form are laborious and costly. FME® automates these data manipulation and transformation tasks, leaving you to work much more efficiently with your newly optimised data set.

Here’s the problem; you have lots of data from lots of different internal and external sources, but managing it all can be difficult. You’re faced with a unique set of challenges that have a large impact on the way you work:

  • Driving value for your organisation by making the most of your business intelligence.
  • Managing the complex combination of data sources, formats and destinations.
  • Dealing with evolving data, resources and requirements.