Why use a subquery initially ?
I would have done it with a JOIN:
SELECT build.* FROM research_area.buildings build JOIN research_area.landuse land ON ST_Intersects(build.geom, land.geom);
Why use a subquery initially ?
I would have done it with a JOIN:
SELECT build.* FROM research_area.buildings build JOIN research_area.landuse land ON ST_Intersects(build.geom, land.geom);
Written by