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