Changes between Version 56 and Version 57 of Noeud - parcours RHT

Timestamp:

Jan 11, 2012 4:41:44 PM (13 years ago)

Author:

celine

Comment:

--

Noeud - parcours RHT

@@ -50 +50 @@
 }}}
 
+== Table attributs
+{{{
+#!sql
+alter table rht.attributs_rht_fev_2011_vs2 add column altitude1 numeric;
+update rht.attributs_rht_fev_2011_vs2 set altitude1=cast(altitude as numeric);
+alter table rht.attributs_rht_fev_2011_vs2 drop column altitude;
+alter table rht.attributs_rht_fev_2011_vs2 rename column altitude1 to altitude;
+
+alter table rht.attributs_rht_fev_2011_vs2 add column pente1 numeric;
+update rht.attributs_rht_fev_2011_vs2 set pente1=cast(pente as numeric);
+alter table rht.attributs_rht_fev_2011_vs2 drop column pente;
+alter table rht.attributs_rht_fev_2011_vs2 rename column pente1 to pente;
+
+alter table rht.rhtvs2 add column relative_distance numeric;
+update rht.rhtvs2 set relative_distance=dmer/(dsource+dmer);
+}}}
 
 == Noeuds mer RHT ==