Changes between Version 31 and Version 32 of CookBook join ROE_RHT

Timestamp:

Nov 3, 2011 3:13:59 PM (13 years ago)

Author:

cedric

Comment:

--

CookBook join ROE_RHT

@@ -221 +221 @@
 update rht.rht_bdcarthage_roev2_nbdams set score=1;
 }}}
+
+-- calcul du nb de barrages cumulé sous R et réimport
+{{{
+#!sql
+create table rht.cumnbbar(
+        id_drain integer primary key,
+        cumnbbar integer);
+copy rht.cumnbbar from 'E:/workspace/EDAdata/dataEDArht/cumnbbar.csv' with csv header delimiter as ';' NULL AS 'NA';--114600
+
+
+-- mise à jour des cumuls barrage
+
+update rht.rht_topology t set cumnbbar=sub.cumnbbar from (
+select id_drain, cumnbbar from rht.cumnbbar) as sub
+where t.id_drain=sub.id_drain
+}}}