Changes between Initial Version and Version 1 of SEA HOPE

Timestamp:

Jun 20, 2012 5:34:47 PM (13 years ago)

Author:

celine

Comment:

--

SEA HOPE

@@ +1 @@
+back to first page[..][[BR]]
+
+{{{
+#!sql
+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'));
+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');
+
+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'));
+}}}