Changes between Version 1 and Version 2 of SEA HOPE

Timestamp:

Jun 20, 2012 5:37:55 PM (13 years ago)

Author:

celine

Comment:

--

SEA HOPE

@@ -9 +9 @@
 alter table rht.crosstab1000_carte add column obs_amont numeric default 1;
 update rht.crosstab1000_carte set obs_amont=0 where tx_survie_turb=1;
+
 update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('107530'));
 update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('114058'));
 update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('114425'));
+---Donzère
 update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('114363'));
 update rht.crosstab1000_carte set obs_amont=1 where id_drain in ('114425','114058','114363','114341');
 
+---Problemes avec les centrales nucléaires suivantes en aval de Décize :
+---ROE6581 : centrale nucléaire de Dampierre
+---ROE7783 : centrale nucléaire de Belleville
+---ROE14010 : centrale nucléaire de St Laurent des eaux
 update rht.crosstab1000_carte set obs_amont=0 where id_drain in ('210360');
 update rht.crosstab1000_carte set obs_amont=0 where id_drain in (select * from rht.upstream_segments('210360'));