Challenge
A major field of work for Wales & West Utilities (WWU) is connecting gas to customer properties. They have to work out where to lay pipes from gas mains to buildings, taking into account obstacles such as other buildings, infrastructure, and a range of other natural features, all whilst trying to find the shortest path for greatest efficiency.
WWU receives tens of thousands of these requests per month, making an automated solution to calculate these routes essential.
Solution
Over a 6 month period, TPXimpact worked with WWU to design and build a program to calculate the shortest viable path between gas mains and client properties. Using agile ways of working and the open source technologies PostGIS, Flask, GeoServer, we built a complex Geographic Information System (GIS), capable of carrying out millions of calculations per second to plot a route.
Given the complex technical nature of the system, we put an even greater focus than usual on the discovery phase of this project to make sure we understood WWU's needs. By performing rapid proofs of concept with user feedback, we ensured we clearly captured the full scope of WWU's requirements for the program, to avoid costly rework later on in the project.
Above image: A connection between a building and the gas main, threading a path between obstructing buildings, following the shortest path.
Impact
The GIS program automatically calculates and maps out the shortest route between a gas main and a property in 1-5 seconds.
Thanks to this software, WWU can easily work out where to lay gas pipes, rather than relying on staff to plot routes by hand. WWU owns the software and there are no licensing costs, ensuring this is a sustainable solution for the organisation in the long term.
Building a new data management platform for a data storage and migration company
How we helped the business reduce costs, improve agility, and simplify their product support model.
Read moreOur latest work
Transformation is for everyone. We love sharing our thoughts, approaches, learning and research all gained from the work we do.
Implementing a global people analytics system for a leading bank
How we delivered a scalable HR analytics platform for one of the world’s biggest banks to meet its people's needs
Read more
Enhancing healthcare training data management
Building user-first data management systems with Health Education and Improvement Wales
Read more
Making data more accessible to solve road-based challenges through a National Access Point
Making data more accessible to solve road-based challenges through a National Access Point
Read more