Changes between Version 49 and Version 50 of PATE Anguille

Timestamp:

Feb 15, 2012 5:10:09 PM (13 years ago)

Author:

celine

Comment:

--

PATE Anguille

@@ -441 +441 @@
 update rht.pate set id_drain=306907 where id_roe='ROE7104';
 update rht.pate set id_drain=201665 where id_roe='ROE11608';
-
-
-
-}}}
+---Mise à jour de la distance mer
+ update rht.pate set dmer=sub.dmer from 
+(select id_drain, dmer from rht.rhtvs2) as sub
+where sub.id_drain=pate.id_drain and id_roe in ('ROE46202','ROE45125','ROE6785','ROE43996','ROE42134','ROE7104','ROE11608');
+---Mise à jour de la surface du BV du RHT (pout comparaison avec la "surf_bv")
+update rht.pate set surf_bv_rht=sub.surf_bv from 
+(select id_drain, surf_bv from rht.attributs_rht_fev_2011_vs2) as sub
+where sub.id_drain=pate.id_drain and id_roe in ('ROE46202','ROE45125','ROE6785','ROE43996','ROE42134','ROE7104','ROE11608');
+---Mise à jour du module
+update rht.pate set module=sub.module from 
+(select id_drain, module from rht.attributs_rht_fev_2011_vs2) as sub
+where sub.id_drain=pate.id_drain and id_roe in ('ROE46202','ROE45125','ROE6785','ROE43996','ROE42134','ROE7104','ROE11608');
+---Mise à jour du minqmx
+update rht.pate set minqmx=sub.minqmx from 
+(select id_drain, minqmx from rht.attributs_rht_fev_2011_vs2) as sub
+where sub.id_drain=pate.id_drain and id_roe in ('ROE46202','ROE45125','ROE6785','ROE43996','ROE42134','ROE7104','ROE11608');
+
+
+}}}