I have two polygon layrers, each layer a table in PostgreSQL: One layer with polygons areas in a city. Another layer with buildings (polygons) that are within areas.
How can I to do to know what buildings are in each areas? Can I have a list or csv with that information?
Something like: layer1(area) -> layer1, 3, 4 (buildings)