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

Timestamp:

Mar 5, 2012 5:54:03 PM (13 years ago)

Author:

celine

Comment:

--

Model Results EDA2.0

@@ -7 +7 @@
 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
+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=4);
+create index indexwestern on ccm21.resultmodel_mdxmpa_Western using gist(the_geom);
 
+drop table if exists ccm21.resultmodel_mdxmpa_Basque;
+create table ccm21.resultmodel_mdxmpa_Basque as (
+select wso1_id, res_value as mdxmpa, the_geom from ccm21.riversegments_basque join ccm21.resultmodel on res_wso1_id=wso1_id where 
+        res_mod_id=2);
+create index indexbasque on ccm21.resultmodel_mdxmpa_Basque using gist(the_geom) ;
 
+drop table if exists ccm21.resultmodel_mdxmpa_Anglian;
+create table ccm21.resultmodel_mdxmpa_Anglian as (
+select wso1_id, res_value as mdxmpa, the_geom from ccm21.riversegments_anglian join ccm21.resultmodel on res_wso1_id=wso1_id where 
+        res_mod_id=3);
+create index indexAnglian on ccm21.resultmodel_mdxmpa_Anglian using gist(the_geom) ;
+
+drop table if exists ccm21.resultmodel_mdxmpa_Brittany;
+create table ccm21.resultmodel_mdxmpa_Brittany as (
+select wso1_id, res_value as mdxmpa, the_geom from ccm21.riversegments_bretagne join ccm21.resultmodel on res_wso1_id=wso1_id where 
+        res_mod_id=5);
+create index indexBrittany on ccm21.resultmodel_mdxmpa_Brittany using gist(the_geom) ;
+
+       
+drop table if exists ccm21.resultmodel_mdxmpa_Rhone;
+create table ccm21.resultmodel_mdxmpa_rhone as (
+select wso1_id, res_value as mdxmpa, the_geom from ccm21.riversegments_Rhone join ccm21.resultmodel on res_wso1_id=wso1_id where 
+        res_mod_id=6);
+create index indexRhone on ccm21.resultmodel_mdxmpa_Rhone using gist(the_geom) ;
+}}}
+
+{{{
+#!sql
 join
         (select id_drain, res_value from rht.rhtvs2 join rht.resultmodel on res_id_drain=id_drain where