Multimodal transport modelling
Transport modelling web app to automate business processes
A bespoke web app to digitise the data collection process, introduce automation, and boost productivity
"What used to take 1-2 days using our previous methodology now takes 2-4 hours with the application and the spreadsheet export [up to 8x faster]."
Developing a bespoke web app to increase productivity by 8x
We built a bespoke web app for a public transport solutions company to digitise and automate their data collation process. The goal was to replace a slow, manual workflow with a streamlined, map-driven interface that could plug seamlessly into their existing systems.
The client’s work involved modelling transport networks and evaluating disruptions such as roadworks and closures. Previously, staff manually cross-referenced ordnance survey maps with public transport archives before organising the results into spreadsheets — a process that could take up to two days.
Our solution automatically gathered and processed bus route data from Transport API based on user-drawn map areas. The system exported results in their existing spreadsheet format, enabling instant adoption. As a result, the client completed work up to eight times faster, accelerating billing cycles and achieving a rapid return on investment.
Want to automate your business processes?
Services delivered
Technologies used
- PHP - Symfony
- TypeScript - Angular
- PostgreSQL database
- AWS cloud infrastructure
Highlights of the bespoke web app
Improving data selection: map-based plotting and pruning
- Bespoke polygonal map-selection tool enables precise area targeting, overcoming postcode limitations and boosting productivity
- Intuitive, minimalist interface allows quick adoption and immediate ROI without steep learning curves
- Custom Google Maps layer supports free-form shape plotting for greater flexibility in data selection
- Two-step data capture process ensures accuracy by pruning out irrelevant results from Transport API’s rectangular selections
Spotlighting valuable data: checkbox pruning
- Checkbox-based pruning system allows users to quickly filter and isolate only the most relevant route information
- One-click export streamlines workflow, reducing time from data selection to actionable output
- Cached API requests prevent quota overuse, enabling efficient collaboration on overlapping project areas
Productivity boost: instant API calls enable the web app to replace tedious tasks
- Automatic mapping of all bus routes in a defined area eliminates the need for manual data gathering
- Instant API-powered schedule reporting accelerates project turnaround times
- Multi-step data fetching ensures accuracy by pruning irrelevant stops before generating route and timetable information
Data export: generating an Excel template and handover pack
- Bespoke Excel exports compatible with pre-existing templates, ensuring smooth adoption
- Option to download consolidated spreadsheets or full raw data packs supports both quick jobs and long-term consultation projects
- Flexible output formats replace legacy processes for all incoming work, delivering consistent value and rapid ROI
Behind-the-scenes and other top features
Not all heroes wear capes. These behind-the-scenes features don't have screenshots, but form an important part of the project.
User permissions and access control support
Granular user roles ensure only the right users have access to sensitive features and data, improving security.
Point-in-time database back-ups for disaster recovery
Automatic backups allow quick recovery in case of data loss, helping to maintain business continuity.
Highly available AWS infrastructure
Scalable cloud infrastructure on AWS providing a low maintenance system with a high service uptime.
Third party API integrations
Taps into third party data sources to save time looking up data manually.
Want to develop a bespoke web app like this?
"We have been working with Codevate on a public transport efficiency tool. From the first inception meeting, we have been impressed with their professionalism and commitment in ensuring that they understand our ever-evolving brief, as well as providing feedback where certain tasks could be modified or enhanced to provide a higher quality output."
- 100% UK-based
- Complimentary scoping call
- At-a-glance feasibility analysis
- No obligation high-level proposal
- Work with an expert to evolve your idea
Project outline: building the bespoke software
We developed this bespoke web app for a public transport solutions company. They wanted to digitise their slow manual data collation process to introduce automation and boost their productivity. The software needed to automate the process as much as possible, outputting an actionable spreadsheet that would seamlessly plug into their existing business workflow.
The company specialises in modelling transport systems and public transport. This includes evaluating disruptions to traffic, including roadworks, closures, and diversions.
Their manual data collation process meant having to manually collect data from ordnance survey maps, cross-referencing with an archive of public transport information. The data then had to be manually organised in an Excel spreadsheet before it could be processed or revenue could be generated.
Throughout initial consultation and discovery workshops, we designed an intuitive map-based interface that downloaded data from third party data sources to automate their manual process.
The software automatically collated bus route information for an area drawn by the user. We tailored our Excel spreadsheet export to their existing spreadsheet template, making internal adoption frictionless.
Before digital transformation, the process took up to two days before our client could deliver — a key aim was to improve the billing cycle to generate a faster return on investment (ROI).
Using our bespoke web app, our client reported being able to complete the work up to eight times faster, without increasing their team size. This increase in productivity resulted in a rapid ROI on their web app development costs.
Want to build your bespoke web app?
Looking to develop software that's greater than the sum of its parts?
Send us a message