Changes between Version 2 and Version 3 of INTEGRATING stations

Timestamp:

Dec 3, 2010 5:15:03 PM (14 years ago)

Author:

cedric

Comment:

--

INTEGRATING stations

@@ -120 +120 @@
 );
 
-alter table wrbd.operation_op add column op_nb_sets numeric;
+
+
+copy wrbd.operation_op from 'C:/base/Operation_14_Eel_Db_MI_Rivers.csv' with csv delimiter as ';'  ; 
+copy wrbd.operation_op from 'D:/CelineJouanin/POSEProject/Ireland/DataIreland/Operation_14_Eel_Db_MI_Rivers.csv' with csv delimiter as ';'  ; 
+
+alter table wrbd.operation_op add column op_nbsets numeric;
+update wrbd.operation_op set op_nbsets=1;
 alter table wrbd.operation_op rename column op_num_fishing  to op_nb_pass;
 alter table wrbd.operation_op add column op_density numeric;
@@ -128 +134 @@
 alter table  wrbd.operation_op add column op_nbfem integer;
 alter table  wrbd.operation_op add column op_nbmal integer;
+alter table  wrbd.operation_op add column op_nbimmat integer;
 alter table  wrbd.operation_op add column op_nbind integer;
-copy wrbd.operation_op from 'C:/base/Operation_14_Eel_Db_MI_Rivers.csv' with csv delimiter as ';'  ; 
-copy wrbd.operation_op from 'D:/CelineJouanin/POSEProject/Ireland/DataIreland/Operation_14_Eel_Db_MI_Rivers.csv' with csv delimiter as ';'  ; 
+alter table  wrbd.operation_op add column op_totalestim numeric;
+alter table  wrbd.operation_op add column op_totalweight numeric;
+alter table  wrbd.operation_op rename column ope_year to op_year;
+alter table  wrbd.operation_op rename column ope_date to op_date;
+copy wrbd.operation_op(op_st_id,op_year,op_equipment,op_area,op_nbsets,op_nb_pass,op_density,op_totalestim,op_totalweight,op_total,op_nbfem,op_nbmal,op_nbimmat) from 'C:/base/8WFD_river_survey_operations.csv' with csv delimiter as ';' header ; 
+copy wrbd.operation_op from 'D:/CelineJouanin/POSEProject/Ireland/DataIreland/8WFD_river_survey_operations.csv' with csv delimiter as ';'  ; 
+
 
 }}}