Changes between Version 65 and Version 66 of PATE Anguille

Timestamp:

Mar 7, 2012 5:56:58 PM (13 years ago)

Author:

celine

Comment:

--

PATE Anguille

@@ -503 +503 @@
 '''Table "tab complété pour Qe et mort.xls" mail Peggy 1/03/2012'''
 {{{
+#!sql
 DROP TABLE IF EXISTS rht.pate_mortalite;
 create table rht.pate_mortalite
@@ -532 +533 @@
 }}}
 
+
+'''Table "ATT496756.xls"'''
+{{{
+#!sql
+DROP TABLE IF EXISTS rht.pate_debitclasse;
+create table rht.pate_debitclasse
+(
+  nom character varying(80),
+  annee_min character varying(80),
+  annee_max character varying(80),
+  periode_migration character varying(80),
+  XlambertIIe numeric,
+  YlambertIIe numeric,
+  surfbv_P numeric,
+  module_p numeric,
+  q75_p numeric,
+  q90_p numeric,
+  q95_p numeric,
+  q975_p numeric,
+  q99_p numeric,
+  codestation character varying(80),
+  nomstation character varying(80),
+  anneemin_bh numeric,
+  anneemax_bh numeric,
+  module_bh numeric,
+  q90_bh1 numeric,
+  q95_bh1 numeric,
+  q98_bh1 numeric,
+  q99_bh1 numeric,
+  q90_bh numeric,
+  q95_bh numeric,
+  q98_bh numeric,
+  q99_bh numeric,
+  id_drain integer
+);
+
+set client_encoding to 'latin1';
+copy rht.pate_mortalite from 'D:/CelineJouanin/PATE/pate_debit_classe.csv' with csv header delimiter as ';' NULL AS 'NA'; -- lines
+}}}
+
 == Export table ==
 {{{