back to first page..

Integrating the result into tableresultmodel

Results of delta-gamma model for each EMU

drop table if exists ccm21.resultmodel_mdxmpa_Western;
create table ccm21.resultmodel_mdxmpa_Western as (
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) ;

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) ;