back to first page ..

Bassin de la Meuse

Les données sont dans dbeel/belge (anguilles, stations, mesure_anguilles) et eda2/belge (obstacles).

-- selection of the meuse basin
select * from european_wise2008.rbd_f1v3 where name_engl like 'Meuse'

Meuse par EMU et par pays

DROP TABLE IF EXISTS belge.join_emu_wso;
DROP TABLE IF EXISTS belge.join_emu_riversegments;
create table belge.join_emu_riversegments as
select wso_id,sub2.gid,emu_name_short,emu_coun_abrev,emu_cty_id from 
 ( select * from ccm21.riversegments where wso_id in (select wso_id from europe.wso where area='Meuse') )sub
join (select * from uga2010.t_emuagreg_ema where emu_coun_abrev='NL' or emu_coun_abrev='FR' or emu_coun_abrev='BE') sub2
on st_intersects(geom,the_geom)
where wso_id in (select wso_id from europe.wso where area='Meuse');
alter table belge.join_emu_riversegments rename to join_emu_wso;