Changes between Version 10 and Version 11 of Meuse bassin

Timestamp:

Jun 23, 2014 4:52:48 PM (11 years ago)

Author:

laura

Comment:

--

Meuse bassin

@@ -13 +13 @@
 
 [[Image(source:data/Docs/trac/Meuse/meuse_coast.jpg)]] [[BR]]
+
+
+= Meuse par EMU et par pays =
+{{{
+#!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
+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;
+}}}