Changes between Version 6 and Version 7 of Model Results

Timestamp:

Dec 15, 2011 11:53:18 AM (13 years ago)

Author:

celine

Comment:

--

Model Results

@@ -34 +34 @@
         sub3.res_value as mdmpa,
         sub4.res_value as largeur,
-        sub5.res_value as surface
+        sub5.res_value as surface,
+        sub6.res_value as ers,
+        sub7.res_value as riverareakm2,
+        sub8.res_value as abondance
           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 
@@ -58 +61 @@
         res_mod_id=6) as sub6
         on sub1.id_drain=sub6.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
+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
 );