Changes between Initial Version and Version 1 of Model Results Spain

Timestamp:

Mar 16, 2012 4:32:38 PM (13 years ago)

Author:

celine

Comment:

--

Model Results Spain

@@ +1 @@
+back to the first page[..][[BR]]
+
+CREATE TABLE rht.model_mod
+(
+  mod_id serial NOT NULL,
+  mod_name character varying(30) NOT NULL,
+  mod_date date,
+  mod_description text NOT NULL,
+  mod_location character varying(25), -- Geographical area to which the model is applied, should be consistent with europe.wso
+  mod_formula text,
+  CONSTRAINT model_mod_pkey PRIMARY KEY (mod_id),
+  CONSTRAINT model_mod_mod_name_key UNIQUE (mod_name)
+);
+
+DROP TABLE IF EXISTS rht.resultmodel;
+CREATE TABLE rht.resultmodel
+(
+  res_id serial NOT NULL,
+  res_id_drain integer,
+  res_value double precision,
+  res_mod_id integer,
+  CONSTRAINT resultmodel_pkey PRIMARY KEY (res_id),
+  CONSTRAINT c_fk_res_mod_id FOREIGN KEY (res_mod_id)
+      REFERENCES rht.model_mod (mod_id) MATCH SIMPLE
+      ON UPDATE NO ACTION ON DELETE NO ACTION
+);
+
+drop table if exists rht.resultmodelBasque;
+create table ccm21.resultmodelBasque as (
+select sub1.*,
+        sub2.res_value as mpa
+          from
+        (select wso1_id,dmer,dsource,res_value as mpa, the_geom from ccm21.riversegments join ccm21.resultmodel on res_wso1_id=wso1_id where 
+        res_mod_id=12) as sub1
+join
+        (select wso1_id, res_value from ccm21.riversegments join ccm21.resultmodel on res_wso1_id=wso1_id where 
+        res_mod_id=15) as sub2
+        on sub1.wso1_id=sub2.wso1_id
+);
+
+create index indextableresultmod on ccm21.resultmodelBasque using gist(the_geom);