Changes between Version 33 and Version 34 of INTEGRATING fish

Timestamp:

Dec 7, 2010 10:25:10 AM (14 years ago)

Author:

cedric

Comment:

--

INTEGRATING fish

@@ -292 +292 @@
 copy wrbd.fish_fi from 'D:/CelineJouanin/POSEProject/Ireland/DataIreland/specimen_tw_08_09_3.csv' with CSV header delimiter as ';';
 }}}
+= wfd river depletion =
+some additional information to be added by update (the operations were already there
+{{{
+/* pour mémoire
+drop table if exists wrbd.wfd_operations;
+create table wrbd.wfd_operations (date date,year integer,station character varying(10),
+length numeric,width numeric,area numeric,p1 integer,p2 integer,p3 integer,total integer,totalest numeric);
+
+copy wrbd.wfd_operations from 'C:/base/wfd_operations.csv' with CSV header delimiter as ';';
+copy wrbd.wfd_operations from 'D:/CelineJouanin/POSEProject/Ireland/DataIreland/wfd_operations.csv' with CSV header delimiter as ';';
+-- le seul pivot possible est sur l'année
+select * from wrbd.wfd_operations join wrbd.operation_op on (op_st_id,op_year)=(station,year) ;
+create table wrbd.wfd_operations_1 as(
+        select o.op_id as ope_id, sr.* from wrbd.wfd_operations sr join wrbd.operation_op o on (op_st_id,op_year)=(station,year)
+);
+drop table wrbd.wfd_operations;
+drop table wrbd.wfd_operations_1;
+*/
+-- export excel
+--wrbd.wfd_operations_1 now contains operation
+-- a la main sous excel
+update wrbd.operation_op set (op_p1,op_p2,op_p3,op_nbtotal,op_density,op_totalestim) =(13,8,7,28,0.072,34) where op_id=8;
+update wrbd.operation_op set (op_p1,op_p2,op_p3,op_nbtotal,op_density,op_totalestim) =(1,0,0,1,0.006,2) where op_id=18;
+update wrbd.operation_op set (op_p1,op_p2,op_p3,op_nbtotal,op_density,op_totalestim) =(1,0,0,1,0.004,2) where op_id=13;
+update wrbd.operation_op set (op_p1,op_p2,op_p3,op_nbtotal,op_density,op_totalestim) =(1,1,1,3,0.004,3) where op_id=16;
+update wrbd.operation_op set (op_p1,op_p2,op_p3,op_nbtotal,op_density,op_totalestim) =(9,25,17,51,0.068,43) where op_id=12;
+update wrbd.operation_op set (op_p1,op_p2,op_p3,op_nbtotal,op_density,op_totalestim) =(12,7,9,28,0.014,31) where op_id=15;
+update wrbd.operation_op set (op_p1,op_p2,op_p3,op_nbtotal,op_density,op_totalestim) =(9,2,2,13,0.003,20) where op_id=14;
+update wrbd.operation_op set (op_p1,op_p2,op_p3,op_nbtotal,op_density,op_totalestim) =(0,2,0,2,0.007,2) where op_id=2;
+update wrbd.operation_op set (op_p1,op_p2,op_p3,op_nbtotal,op_density,op_totalestim) =(17,15,3,35,0.097,49) where op_id=5;
+}}}