The primary objective was to enable dynamic queries showing work performed by Asplundh’s Spray Trains and Trucks for customers in a straightforward map interface. Doing so eliminated the use of spreadsheets containing three to twenty thousand lines per day of service that required cumbersome navigation.
Our solution was a system that would process and ingest data from multiple flat files, utilizing Sql Server Integration Services with SharePoint Embedded and a user-friendly dashboard. An advanced dashboard was developed showing spray activity with a rendered map display. The dashboard provides date range capabilities and other filters to refine information displayed on the map.
The project included user experience design, database architecture, platform integrations, and web services. Prior to development, Seisan business analysts worked with Asplundh staff to ensure compliance with all business process workflows and data field requirements. Our systems integration powered Asplundh’s customer satisfaction through a dashboard easily accessible to clients.
Users can filter by specific date, date range, and other options in order to customize their display. Each spray indicator delivers quick details pertaining to chemicals used, nozzle(s) activated, as well as length and exact location.