Changes between Version 24 and Version 25 of Export table RHT

Timestamp:

Apr 11, 2012 10:30:49 PM (13 years ago)

Author:

cedric

Comment:

--

Export table RHT

@@ -51 +51 @@
   crosstab.densite, 
   crosstab.abondance,
+  crosstab.nb_ar_mort_turb,
   rhtvs2.the_geom,
   rhtvs2.dmer,
@@ -56 +57 @@
   rhtvs2.cumnbbar from rht.rhtvs2 left join 
         (SELECT * FROM crosstab('select res_id_drain, res_mod_id,res_value from rht.resultmodel
-                                        where res_mod_id in (24,23,25,26,4,5,6,27)
+                                        where res_mod_id in (24,23,25,26,4,5,6,27,28)
                                         order by 1,2',
-                                        'select mod_id from rht.model_mod where mod_id in (24,23,25,26,4,5,6,27) order by mod_id')
+                                        'select mod_id from rht.model_mod where mod_id in (24,23,25,26,4,5,6,27,28) order by mod_id')
                         AS ct(id_drain integer, 
                         largeur numeric,
@@ -67 +68 @@
                         densite numeric,
                         abondance numeric,
-                        exutoire numeric) 
+                        exutoire numeric,
+                        nb_ar_mort_turb numeric) 
         )as crosstab
 on rhtvs2.id_drain=crosstab.id_drain);
 
-comment on table rht.crosstab_rhtvs2 is 'table crée le 6 avril 2012 a partir des résultats définitifs d''EDA';
+comment on table rht.crosstab_rhtvs2 is 'table crée le 6 avril 2012 a partir des résultats définitifs d''EDA, modifiée le 11/04/2012';
+-- creation des clés et des index qui vont bien
+alter table rht.crosstab_rhtvs2 add constraint c_pk_crosstab_rhtvs2 PRIMARY KEY (id_drain);     
+CREATE INDEX crosstab_rhtvs2_index
+  ON rht.crosstab_rhtvs2
+  USING btree
+  (id_drain);
+CREATE INDEX crosstab_rhtvs2_gistindex
+  ON rht.rhtvs2
+  USING gist
+  (the_geom);
 -- creation des clés et des index qui vont bien
 alter table rht.crosstab_rhtvs2 add constraint c_pk_crosstab_rhtvs2 PRIMARY KEY (id_drain);