Changes between Version 19 and Version 20 of Model Results

Timestamp:

Jul 27, 2012 2:20:23 PM (13 years ago)

Author:

celine

Comment:

--

Model Results

@@ -189 +189 @@
 E:\IAV\eda\rht>psql -U postgres -f "resultmodel.sql" eda2.0_RHT
 }}}
+
+== Résultats du modèle sans impacts anthropiques ==
+{{{
+#!sql
+drop table if exists rht.tableresultmodelwitoutImpact;
+create table rht.tableresultmodelwitoutImpact as (
+select sub1.*,
+        sub2.res_value as md,
+        sub3.res_value as mdmpa,
+        sub4.res_value as abondance
+          from
+        (select id_drain,dmer,dsource,res_value as mpa, the_geom from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=32) as sub1
+join
+        (select id_drain, res_value from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=33) 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=34) 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=35) as sub4
+        on sub1.id_drain=sub4.id_drain
+);
+}}}