Changes between Version 13 and Version 14 of Model Results

Timestamp:

Jan 20, 2012 3:22:36 PM (13 years ago)

Author:

celine

Comment:

--

Model Results

@@ -70 +70 @@
 drop table if exists rht.tableresultmodelVar;
 create table rht.tableresultmodelVar as (
-select sub8.*,
+select sub14.*,
         sub9.res_value as p_urban,
         sub10.res_value as p_up_urban,
         sub11.res_value as p_agricultural,
         sub12.res_value as p_up_agricultural,
-        sub13.res_value as p_unimpact,
-        sub14.res_value as p_up_no_impact
-          from
-        (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
+        sub13.res_value as p_unimpact
+        from
+        (select id_drain,dmer,dsource,res_value as p_up_no_impact, the_geom from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=14) as sub14
 join 
         (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
+        on sub14.id_drain=sub9.id_drain
 join 
         (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
+        on sub14.id_drain=sub10.id_drain
 join 
         (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
+        on sub14.id_drain=sub11.id_drain
 join 
         (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
+        on sub14.id_drain=sub12.id_drain
 join 
         (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.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
-        res_mod_id=14) as sub14
-        on sub8.id_drain=sub14.id_drain     
+        on sub14.id_drain=sub13.id_drain        
 );