Changes between Version 8 and Version 9 of Model Results

Timestamp:

Jan 14, 2012 10:09:04 PM (13 years ago)

Author:

celine

Comment:

--

Model Results

@@ -31 +31 @@
 create table rht.tableresultmodel as (
 select sub1.*,
-        sub2.res_value as mpa,
-        sub3.res_value as mdmpa,
-        sub4.res_value as largeur,
-        sub5.res_value as surface,
-        sub6.res_value as ers,
-        sub7.res_value as riverareakm2,
-        sub8.res_value as abondance,
-        sub9.res_value as ers2
-          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
+        sub2.res_value as mpa,
+        sub3.res_value as mdmpa,
+        sub4.res_value as largeur,
+        sub5.res_value as surface,
+        sub6.res_value as ers,
+        sub7.res_value as abondance,
+        sub8.res_value as exutoire,
+        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 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, 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
 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.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
 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.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
 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.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
 join 
         (select id_drain, res_value from rht.rht_topology join rht.resultmodel on res_id_drain=id_drain where 
@@ -74 +79 @@
         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 
+        res_mod_id=14) as sub14
+        on sub1.id_drain=sub14.id_drain       
 );