Changes between Version 16 and Version 17 of Model Results

Timestamp:

Jan 25, 2012 5:25:38 PM (13 years ago)

Author:

celine

Comment:

--

Model Results

@@ -155 +155 @@
 );
 }}}
+
+
+{{{
+drop table if exists rht.tableresultmodel4;
+create table rht.tableresultmodel4 as (
+select sub1.*,
+        sub2.res_value as mpa,
+        sub3.res_value as mdmpa,
+        sub4.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=23) as sub1
+join
+        (select id_drain, res_value from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=24) 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=25) 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=26) as sub4
+        on sub1.id_drain=sub4.id_drain
+);
+}}}