Changes between Version 12 and Version 13 of Meuse bassin


Ignore:
Timestamp:
Jun 24, 2014 1:15:43 PM (11 years ago)
Author:
laura
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Meuse bassin

    v12 v13  
    1414[[Image(source:data/Docs/trac/Meuse/meuse_coast.jpg)]] [[BR]] 
    1515 
    16  
    17 = Meuse par EMU et par pays = 
    18 {{{ 
    19 #!sql 
    20 DROP TABLE IF EXISTS belge.join_emu_wso; 
    21 create table belge.join_emu_wso as 
    22 select wso1_id,sub2.gid,emu_name_short,emu_coun_abrev,emu_cty_id from  
    23  ( select * from ccm21.riversegments where wso1_id in (select wso1_id from europe.wso where area='Meuse') )sub 
    24 join (select * from uga2010.t_emuagreg_ema where emu_coun_abrev='NL' or emu_coun_abrev='FR' or emu_coun_abrev='BE') sub2 
    25 on st_intersects(geom,the_geom) 
    26 where wso_id in (select wso_id from europe.wso where area='Meuse'); 
    27 }}}