I have 2 layers that I want to compare. I wish to retrieve the features in the layer 1 that have no part in common with the features in the layer 2. I try queries like that but do not returns me the expected result :
select * from c1 join activite.c2 on st_disjoint(c1.geom, c2.geom) WHERE c2 blabla' ; I get here (except error) a table that lists for each feature in the layer 1 those of layer 2 who do not cut it. But how to recover those of layer 1 which are intersected by any of the layer 2 ? Hope it s clear...
أكثر...
select * from c1 join activite.c2 on st_disjoint(c1.geom, c2.geom) WHERE c2 blabla' ; I get here (except error) a table that lists for each feature in the layer 1 those of layer 2 who do not cut it. But how to recover those of layer 1 which are intersected by any of the layer 2 ? Hope it s clear...
أكثر...