Changes between Version 40 and Version 41 of PATE Anguille

Timestamp:

Feb 15, 2012 10:58:38 AM (13 years ago)

Author:

celine

Comment:

--

PATE Anguille

@@ -137 +137 @@
 }}}
 
+Coordonnées absentes car les obstacles ne sont pas dans la version publique d'avril 2011 --> récupérer les coordonnées dans la table roe_v2.obstacle
 ||id_roe|||| id_drain||
 ||ROE64290              ||pas dans la version ROE publique d'avril 2011||       122703||
@@ -369 +370 @@
 (select id_drain, surf_bv from rht.attributs_rht_fev_2011_vs2) as sub
 where sub.id_drain=pate.id_drain;
-
----Projection id_roe sur RHT à vérifier
+}}}
+
+== Projection id_roe sur RHT à vérifier ==
+{{{
+#!sql
 id_roe in ('ROE46202','ROE42025','ROE45125','ROE6785','ROE20586','ROE43996')
 select surf_bv, surf_bv_rht, id_drain, surf_bv-surf_bv_rht as diff from rht.pate where surf_bv is not null order by diff
 }}}
+A modifier dans rht.rht_roev2  --> calcul cumnbbar à revoir
+{{{
+#!sql
+id_roe in ('ROE42025','ROE20586','ROE46202','ROE45125','ROE6785','ROE43996')
+update rht.rht_roev2 set id_drain=103936 where id_roe='ROE42025';
+update rht.rht_roev2 set id_drain=207306 where id_roe='ROE20586';
+update rht.rht_roev2 set id_drain=122291 where id_roe='ROE46202';
+update rht.rht_roev2 set id_drain=120931 where id_roe='ROE45125';
+update rht.rht_roev2 set id_drain=121592 where id_roe='ROE6785';
+update rht.rht_roev2 set id_drain=121530 where id_roe='ROE43996';
+
+drop table if exists rht.rhvs2_roev2_nbdams;
+create table rht.rhtvs2_roev2_nbdams as
+select id_drain, count(nbdams) as nbdams from rht.rhtvs2_roev2 as r group by id_drain;
+}}}
+A modifier dans rht.pate --> redonner le bon module
+{{{
+#!sql
+id_roe in ('ROE46202','ROE45125','ROE6785','ROE43996')
+update rht.pate set id_drain=122291 where id_roe='ROE46202';
+update rht.pate set id_drain=120931 where id_roe='ROE45125';
+update rht.pate set id_drain=121592 where id_roe='ROE6785';
+update rht.pate set id_drain=121530 where id_roe='ROE43996';
+
+}}}