Changes between Initial Version and Version 1 of INTEGRATING operation

Timestamp:

Dec 6, 2010 1:07:38 PM (14 years ago)

Author:

cedric

Comment:

--

INTEGRATING operation

@@ +1 @@
+
+{{{
+#!sql
+-- operations
+-- changing format of column i
+drop table if exists wrbd.operation_op;
+
+create table wrbd.operation_op (
+op_folio_no character varying(50),
+op_st_id character varying(10),
+ope_date date,
+ope_year integer,
+op_area numeric,
+op_glass numeric, 
+op_elver numeric,
+op_yellow numeric,
+op_silver numeric,
+op_not_recorded numeric,
+op_eels_anaesthetized text, 
+op_num_fishing integer,
+op_p1 integer,
+op_p2 integer,
+op_p3 integer,
+op_p4 integer,
+op_p5 integer,
+op_total integer,
+op_abundance_rating integer,
+op_distribution character varying(15),
+op_main_survey_target character varying(20),
+opedisthwm numeric,
+constraint c_fk_op_code  FOREIGN KEY  (op_st_id) REFERENCES wrbd.station_st(st_id)
+);
+
+
+
+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 ';'  ; 
+-- 966 lines
+
+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;
+alter table wrbd.operation_op add column op_equipment character varying(40);
+update wrbd.operation_op set op_equipment='Handset';
+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;
+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 ';'  ; 
+--984 lines
+
+alter table wrbd.operation_op add column op_id serial;
+alter table wrbd.operation_op add constraint pk_wrbd_operation_op PRIMARY KEY (op_id);
+alter table wrbd.operation_op add column op_nbnights integer;
+alter table wrbd.operation_op add column op_nbnets integer;
+alter table wrbd.operation_op add column op_cpue numeric;
+alter table wrbd.operation_op rename column op_total  to op_nbtotal;
+
+copy wrbd.operation_op(op_st_id,op_year,op_equipment,op_nbnights,op_nbnets,op_nbtotal,op_cpue,op_totalweight,op_nbfem,op_nbmal,op_nbimmat) from 'C:/base/8.lakes_operation.csv' with csv delimiter as ';' header ; 
+copy wrbd.operation_op(op_st_id,op_year,op_equipment,op_nbnights,op_nbnets,op_nbtotal,op_cpue,op_totalweight,op_nbfem,op_nbmal,op_nbimmat) from 'D:/CelineJouanin/POSEProject/Ireland/DataIreland/8.lakes_operation.csv' with csv delimiter as ';' header ; 
+}}}