Changes between Version 21 and Version 22 of INTEGRATING fish

Timestamp:

Dec 6, 2010 4:45:42 PM (14 years ago)

Author:

cedric

Comment:

--

INTEGRATING fish

@@ -106 +106 @@
 drop table wrbd.specimen_riv_08_09_1;
 --wrbd.specimen_riv_08_09_2 now contains operation and stations
+
+insert into wrbd.fish_fi(
+fi_st_id,
+fi_op_id,
+fi_fishid,
+fi_date,
+fi_year,
+fi_individual_life,
+fi_retained,
+fi_length,
+fi_weight)
+  select 
+fi_st_id, 
+fi_ope_id,
+fish_id,
+date,
+year,
+individual_life_silver_stage,
+retained,
+case when length_cm is null then estimated_length_cm
+else length_cm end as length,
+weight_g from wrbd.specimen_riv_08_09_2;
 }}}