Changes between Version 16 and Version 17 of INTEGRATING operation

Timestamp:

Dec 7, 2010 8:08:22 PM (14 years ago)

Author:

cedric

Comment:

--

INTEGRATING operation

@@ -109 +109 @@
 op_p3,op_p4,op_p5,op_distribution,op_main_survey_target,op_silvereelcatchwt) 
 from 'C:/eda/ireland/POSE_Data_for_Modellers/Operation_4.WRBD_NDP_dbase_Historical_Lakes_and_all_burr_silvers.csv' with csv header delimiter as ';' ;
+
+-- remplacement des 699 par rien
+-- ajout des op_di (je ne prends pas la valeur du serial)
+delete from wrbd.operation_op where op_id>=1961;
+copy wrbd.operation_op(op_id,op_folio_no,op_st_id,op_date,op_year,op_datasource,op_equipment,op_nbnets,op_nbdaysfishing,
+op_nbnightsbeforelifting,op_glass,op_elver,op_yellow,op_silver,op_not_recorded,op_nb_pass,op_p1,op_p2,
+op_p3,op_p4,op_p5,op_distribution,op_main_survey_target,op_silvereelcatchwt) 
+from 'C:/eda/ireland/POSE_Data_for_Modellers/Operation_4.WRBD_NDP_dbase_Historical_Lakes_and_all_burr_silvers.csv' with csv header delimiter as ';'
+
+delete from wrbd.operation_op where op_id>=1335;-- nouvelle numerotation dans le fichier
+alter table wrbd.operation_op drop column op_nbnightsbeforelifting ; --c'est la colonne op_nbnights
+alter table wrbd.operation_op drop column op_nbdaysfishing; -- contains the values of nbnights
+copy wrbd.operation_op(op_id,op_folio_no,op_st_id,op_date,op_year,op_datasource,op_equipment,op_nbnets,op_nbnights,
+op_glass,op_elver,op_yellow,op_silver,op_not_recorded,op_nb_pass,op_p1,op_p2,
+op_p3,op_p4,op_p5,op_distribution,op_main_survey_target,op_silvereelcatchwt) 
+from 'C:/eda/ireland/POSE_Data_for_Modellers/Operation_4.WRBD_NDP_dbase_Historical_Lakes_and_all_burr_silvers.csv' with csv header delimiter as ';'
+
+update wrbd.operation_op set op_equipment='fyke net' where op_equipment='fyke net standard'
 }}}