Changes between Initial Version and Version 1 of Model Results EDA2.0

Timestamp:

Mar 5, 2012 5:26:13 PM (13 years ago)

Author:

celine

Comment:

--

Model Results EDA2.0

@@ +1 @@
+back to first page[..][[BR]]
+
+= Integrating the result into tableresultmodel =
+== Results of delta-gamma model for each EMU ==
+{{{
+#!sql
+drop table if exists ccm21.resultmodel_mdxmpa_Western;
+create table ccm21.resultmodel_mdxmpa_Western as (
+select sub1.*
+          from
+        (select wso1_id, res_value as mdxmpa, the_geom from ccm21.riversegments_Western join ccm21.resultmodel on res_wso1_id=wso1_id where 
+        res_mod_id=2) as sub1
+
+
+join
+        (select id_drain, res_value from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=2) as sub2
+        on sub1.id_drain=sub2.id_drain
+
+);
+
+create index indexwestern on ccm21.resultmodel_mdxmpa_Western using gist(the_geom) ;