Changes between Version 14 and Version 15 of Model Results

Timestamp:

Jan 23, 2012 10:13:03 AM (13 years ago)

Author:

celine

Comment:

--

Model Results

@@ -129 +129 @@
 );
 }}}
+
+{{{
+#!sql
+drop table if exists rht.tableresultmodel3;
+create table rht.tableresultmodel3 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=19) as sub1
+join
+        (select id_drain, res_value from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=20) 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=21) 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=22) as sub4
+        on sub1.id_drain=sub4.id_drain
+);
+}}}