Optimize the query selecting the tiles of a district and their build area proportion
Currently, the query to select the tiles with built area of a district and their respective proportion of the total district built area contains a CROSS JOIN
. We changed a similar query in the process_gaps_in_exposure
function into 2 separate queries, the first calculating the total built area in the district and the second one delivering the tiles and their built-area proportion.