Improve performance when querying with complex geometries

[Ben-Hodgkiss]

Overview:
Due to the complex and huge geometries like in flood risk zones, slow queries and long page load times are being experienced. Whenever such geometries are involved, the query execution takes significantly longer than expected. To enhance the overall performance, a solution needs to be implemented that optimizes the handling of these large and complex geometries.

Link for slow query
entity page load

Tech Approach:
Needs to be decided

Acceptance Criteria:

• Significant reduction in query load time and page load time when dealing with complex geometries.
• Implementation of geometry optimization techniques that don't compromise the accuracy of spatial data.

Related Tickets:
https://trello.com/c/qa8oK45o/3539-slow-queries-solution-excludefields-filtered-out-before-querying?filter=label:Infrastructure

https://trello.com/c/V9WU2IDz/3257-502s-encountered-when-loading-entity