Changes between Version 21 and Version 22 of Meuse dbeel

Timestamp:

Jul 4, 2014 3:28:33 PM (11 years ago)

Author:

laura

Comment:

--

Meuse dbeel

@@ -1312 +1312 @@
 -- wso1_id: 328521,328497,328314
 }}}
+
+= Création d'une table pour avoir les prédictions par sous-bassins =
+{{{
+#!sql
+
+-- Table des sous-bassins dans postgresql pour la Belgique
+
+DROP TABLE if exists belge.sous_bassin;
+CREATE TABLE belge.sous_bassin as
+select wso4_id, wso1_id from ccm21.catchments 
+where wso4_id in
+(select c.wso4_id from ccm21.catchments c join europe.wso e on e.wso_id=c.wso_id where e.area='Meuse' group by wso4_id); -- 32 wso4 - 123283 rows
+
+ALTER TABLE belge.sous_bassin ADD COLUMN ss_bassin character varying (50);
+UPDATE belge.sous_bassin SET ss_bassin = 'Amblève' where wso4_id = '291590';
+UPDATE belge.sous_bassin SET ss_bassin = 'Sambre'  where wso4_id = '291589';
+UPDATE belge.sous_bassin SET ss_bassin = 'Vesdre'  where wso4_id = '291579';
+UPDATE belge.sous_bassin SET ss_bassin = 'Semois-Cher' where wso4_id in ('291647','291701','291702','291676','291705');
+UPDATE belge.sous_bassin SET ss_bassin = 'Lesse' where wso4_id in ('291605','291618','291613');
+UPDATE belge.sous_bassin SET ss_bassin = 'Meuse amont - Oise' where wso4_id in ('291620','291604','291586');
+UPDATE belge.sous_bassin SET ss_bassin = 'Ourthe' where wso4_id in ('291588','291578');
+UPDATE belge.sous_bassin SET ss_bassin = 'Meuse avale' where wso4_id in ('291577','291586');
+
+select * from belge.sous_bassin
+select ss_bassin from belge.sous_bassin group by 1
+
+}}}
+
+