I have a
queried layer and a
buildings layer and I am currently running the following query to find areas of intersection using the St_Intersection() function inside the QGIS DB Manager plugin:
SELECT ST_Intersection(buildings.geom, queried.geom) as inter from buildings, queried
(I'm hoping the function is correct as it's been running for over an hour now...)
But I want to repeat this and combine it using ST_Area() so that the output layer constains all intersection features with another column in the table showing the area.
How could I combine these two functions into one query?