Changes between Version 9 and Version 10 of Model Results

Timestamp:

Jan 15, 2012 12:14:49 AM (13 years ago)

Author:

celine

Comment:

--

Model Results

@@ -36 +36 @@
         sub5.res_value as surface,
         sub6.res_value as ers,
-        sub7.res_value as abondance,
-        sub8.res_value as exutoire,
+        sub7.res_value as abondance
+          from
+        (select id_drain,dmer,dsource,res_value as md, the_geom from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=1) as sub1
+join
+        (select id_drain, res_value from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=2) as sub2
+        on sub1.id_drain=sub2.id_drain
+join 
+        (select id_drain, res_value from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=3) as sub3
+        on sub1.id_drain=sub3.id_drain
+join 
+        (select id_drain, res_value from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=4) as sub4
+        on sub1.id_drain=sub4.id_drain
+join 
+        (select id_drain, res_value from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=5) as sub5
+        on sub1.id_drain=sub5.id_drain
+join 
+        (select id_drain, res_value from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=6) as sub6
+        on sub1.id_drain=sub6.id_drain
+join 
+        (select id_drain, res_value from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=7) as sub7
+        on sub1.id_drain=sub7.id_drain  
+);
+
+create index indextableresultmod on rht.tableresultmodel using gist(the_geom) ;
+
+drop table if exists rht.tableresultmodelVar;
+create table rht.tableresultmodelVar as (
+select sub8.*,
         sub9.res_value as p_urban,
         sub10.res_value as p_up_urban,
@@ -45 +78 @@
         sub14.res_value as p_up_no_impact
           from
-        (select id_drain,dmer,dsource,res_value as md, the_geom from rht.rht_topology join rht.resultmodel on res_id_drain=id_drain where 
-        res_mod_id=1) as sub1
-join
-        (select id_drain, res_value from rht.rht_topology join rht.resultmodel on res_id_drain=id_drain where 
-        res_mod_id=2) as sub2
-        on sub1.id_drain=sub2.id_drain
+        (select id_drain,dmer,dsource,res_value as exutoire, the_geom from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=8) as sub8
 join 
-        (select id_drain, res_value from rht.rht_topology join rht.resultmodel on res_id_drain=id_drain where 
-        res_mod_id=3) as sub3
-        on sub1.id_drain=sub3.id_drain
+        (select id_drain, res_value from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=9) as sub9
+        on sub8.id_drain=sub9.id_drain
 join 
-        (select id_drain, res_value from rht.rht_topology join rht.resultmodel on res_id_drain=id_drain where 
-        res_mod_id=4) as sub4
-        on sub1.id_drain=sub4.id_drain
+        (select id_drain, res_value from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=10) as sub10
+        on sub8.id_drain=sub10.id_drain
 join 
-        (select id_drain, res_value from rht.rht_topology join rht.resultmodel on res_id_drain=id_drain where 
-        res_mod_id=5) as sub5
-        on sub1.id_drain=sub5.id_drain
+        (select id_drain, res_value from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=11) as sub11
+        on sub8.id_drain=sub11.id_drain
 join 
-        (select id_drain, res_value from rht.rht_topology join rht.resultmodel on res_id_drain=id_drain where 
-        res_mod_id=6) as sub6
-        on sub1.id_drain=sub6.id_drain
+        (select id_drain, res_value from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=12) as sub12
+        on sub8.id_drain=sub12.id_drain
 join 
-        (select id_drain, res_value from rht.rht_topology join rht.resultmodel on res_id_drain=id_drain where 
-        res_mod_id=7) as sub7
-        on sub1.id_drain=sub7.id_drain
+        (select id_drain, res_value from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=13) as sub13
+        on sub8.id_drain=sub13.id_drain        
 join 
-        (select id_drain, res_value from rht.rht_topology join rht.resultmodel on res_id_drain=id_drain where 
-        res_mod_id=8) as sub8
-        on sub1.id_drain=sub8.id_drain
-join 
-        (select id_drain, res_value from rht.rht_topology join rht.resultmodel on res_id_drain=id_drain where 
-        res_mod_id=9) as sub9
-        on sub1.id_drain=sub9.id_drain
-join 
-        (select id_drain, res_value from rht.rht_topology join rht.resultmodel on res_id_drain=id_drain where 
-        res_mod_id=10) as sub10
-        on sub1.id_drain=sub10.id_drain
-join 
-        (select id_drain, res_value from rht.rht_topology join rht.resultmodel on res_id_drain=id_drain where 
-        res_mod_id=11) as sub11
-        on sub1.id_drain=sub11.id_drain
-join 
-        (select id_drain, res_value from rht.rht_topology join rht.resultmodel on res_id_drain=id_drain where 
-        res_mod_id=12) as sub12
-        on sub1.id_drain=sub12.id_drain
-join 
-        (select id_drain, res_value from rht.rht_topology join rht.resultmodel on res_id_drain=id_drain where 
-        res_mod_id=13) as sub13
-        on sub1.id_drain=sub13.id_drain        
-join 
-        (select id_drain, res_value from rht.rht_topology join rht.resultmodel on res_id_drain=id_drain where 
+        (select id_drain, res_value from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
         res_mod_id=14) as sub14
-        on sub1.id_drain=sub14.id_drain       
+        on sub8.id_drain=sub14.id_drain     
 );
 
-create index indextableresultmod on rht.tableresultmodel using gist(the_geom) ;
+create index indextableresultmodVar on rht.tableresultmodelVar using gist(the_geom) ;
 }}}