Changes between Version 10 and Version 11 of Model Results

Timestamp:

Jan 16, 2012 5:44:08 PM (13 years ago)

Author:

celine

Comment:

--

Model Results

@@ -108 +108 @@
 create index indextableresultmodVar on rht.tableresultmodelVar using gist(the_geom) ;
 }}}
+
+drop table if exists rht.tableresultmodel2;
+create table rht.tableresultmodel 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=15) as sub1
+join
+        (select id_drain, res_value from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=16) 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=17) 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=18) as sub4
+        on sub1.id_drain=sub4.id_drain
+);