back to first page..

create table rht.crosstab1000_carte as 
select * from rht.crosstab1000_rhtvs2;

select * from rht.crosstab1000_carte limit 2
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'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('212928'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('214776'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('218072'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('226878'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('225829'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('223193'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('218065'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('218696'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('219474'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('227360'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('230875'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('231722'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('232149'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('232179'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('232301'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('232686'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('231568'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('231627'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('233095'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('231232'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('232179'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('232726'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('233321'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('230578'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('231054'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('232475'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('230578'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('232376'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('228466'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('228697'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('229554'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('229649'));
update rht.crosstab1000_carte set obs_amont=1 where id_drain in (select * from rht.upstream_segments('229253'));