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