As a DEVELOPER, I want to fill in the Location field of the Transactions table with a (Latitude, Longitude) coordinate pair, so that I will later be able to display this location coordinate on an interactive user-facing map.
A/C:
[ ] Each row of the transactions table should have an associated latitude and longitude based on the company name and branch of the company, which can be generated using the Geocode API.
[ ] If the full address of the company is not known, we may use the OpenAI API to mock the functionality for now.
[ ] Create a function to group transactions by location and count the number of transactions in each location, either per month or for all time.
As a DEVELOPER, I want to fill in the Location field of the Transactions table with a (Latitude, Longitude) coordinate pair, so that I will later be able to display this location coordinate on an interactive user-facing map.
A/C: