The company receives data daily from an API containing information on territories available or sold to the company’s franchisees. The task was to design a map that takes a country and a postal code as parameters and indicates to the user whether the territory is available or not, as well as the status of all neighboring territories. The map already existed but could only display a single territory and was unable to show information for territories outside of America. An issue with the GBBIS API, which manages the territories, was preventing data from being delivered to the database.
I first had to address the issue with the API. Next, I made the necessary changes to allow the map to display more than just a single territory. However, the received data, which included the coordinates required to display the territories on the map, was demanding a significant amount of resources on the client’s computer. I found a solution to optimize database queries.