Even though there are 1,200 resources, it's not actually that much data to manage in the page since we're using pagination. Additionally, CARTO is used for queries, but most of these queries are relatively simple and might be easier to run by filtering an array of objects.
This will require some testing out, but it looks like it makes more sense to load everything from the Google Sheets API and filter that in JS on the page to minimize the amount of requests and external services that need to be used. We could also switch the map to Leaflet since each item has latitude and longitude coordinates
Even though there are 1,200 resources, it's not actually that much data to manage in the page since we're using pagination. Additionally, CARTO is used for queries, but most of these queries are relatively simple and might be easier to run by filtering an array of objects.
This will require some testing out, but it looks like it makes more sense to load everything from the Google Sheets API and filter that in JS on the page to minimize the amount of requests and external services that need to be used. We could also switch the map to Leaflet since each item has latitude and longitude coordinates