Changes between Version 11 and Version 12 of Meuse bassin

Timestamp:

Jun 24, 2014 1:15:28 PM (11 years ago)

Author:

laura

Comment:

--

Meuse bassin

@@ -19 +19 @@
 #!sql
 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
+create table belge.join_emu_wso as
+select wso1_id,sub2.gid,emu_name_short,emu_coun_abrev,emu_cty_id from 
+ ( select * from ccm21.riversegments where wso1_id in (select wso1_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;
 }}}