Changes between Version 18 and Version 19 of Meuse dbeel

Timestamp:

Jun 24, 2014 1:16:55 PM (11 years ago)

Author:

laura

Comment:

--

Meuse dbeel

@@ -1290 +1290 @@
 
 }}}
+
+
+= Meuse par EMU et par pays jointure avec CCM =
+{{{
+#!sql
+DROP TABLE IF EXISTS belge.join_emu_wso;
+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');
+}}}