create table cours_eau(
	geom geometry
);
insert into cours_eau select ST_union(geom) from "SHP_cours_eau_bv";

create table buffer_cours_eau(
	geom geometry
);
insert into buffer_cours_eau select ST_Buffer(geom, 10) from "cours_eau";

create table intersect_parcelles(
	geom geometry
);
insert into intersect_parcelles select p.geom from buffer_cours_eau, "SHP_parcelles_bv" p WHERE st_intersects(buffer_cours_eau.geom, p.geom);