A client with a Windows-based legacy application running onsite and tracking billing and service stops for trucks needed a new real-time management tool. The legacy application included a complex data model for service routes, repeat service stops, one-time service stops, and service scheduling. The client also needed to identify service stops on a map and identify incorrect addresses and stops in their core data that could be adjusted to optimize route planning.
- Legacy application cannot check for incorrect addresses
- Drivers and Planners cannot look at more than one route at a time
- Drivers and Planners have no visual display of routes on a map
- Changes to routes requires manual updating in data tables
Wildland identified two major goals that would directly contribute to the success of the project: Efficiently and correctly replicate legacy data out of the onsite database, and sync legacy data with a new web database that could also render the data on an interactive map. The application was built upon the Mapbox control along with an EmberJS front-end.
Automated data sync between local database and web-app.
In previous iterations of the Route Mapping program, changes in the CORE system were not automatically reflected to customer support or project management. With the new web application CORE changes are updated daily, and new routes, stops, and trucks are automatically included into the interface.
Visually render large amounts of data points on a single map.
At the heart of the project was the desire for the client to be able to visually examine routes. By linking routes to validated address points on a google map render the user is able to now view hundreds of points and make determinations based on visual information. Users can quickly see route stops that are better-attributed to another route, or see efficiencies of switching times or trucks for certain stops, all through the route visualization process.
Sort and filter routes based on several criteria Data set grouping to allow for quicker loading
Like the ability to visualize routes, it was a must-have for our client to be able to quickly see stops for some routes and filter between large data-sets. The filtering mechanisms allow a user to rapidly move between cities, routes, and even route managers. Route stops are also grouped depending on the map size, which allows for hundreds and even thousands of routes to be quickly loaded.
In the end, Wildland built and presented a great application to an overwhelmed client and immediately made an impact in their effort to cut costs by increasing efficiency. The client now has a process for stories and updating legacy data as well as a sleek visual application to manage routes and stops in real time.
I enjoyed working on the Route Mapping Application project for two main reasons. The first is that it was a project that directly helped improve our local community. The second was the map visualization was very fun to make.