Changes between Version 21 and Version 22 of WRBD

Timestamp:

Dec 2, 2010 4:19:39 PM (14 years ago)

Author:

cedric

Comment:

--

WRBD

@@ -252 +252 @@
 -- operations
 -- changing format of column i
-
+drop table if exists wrbd.mi_operation_op;
+
+create table wrbd.mi_operation_op (
+op_lat numeric,
+op_long numeric,
+op_folio_no character varying(50),
+op_code character varying(10),
+ope_date date,
+ope_year integer,
+length text,--
+av_width text,--
+op_area numeric,
+habitat_type text,--
+dominant_site_substrate text,--
+macrophyte_cover text,--
+riparian_cover text,--
+datasource text,--
+methodology text,
+op_efishing_units text,
+no_hooks text, --
+no_nets text , --
+no_days_fished text, --
+op_glass numeric, 
+op_elver numeric,
+op_yellow numeric,
+op_silver numeric,
+op_not_recorded numeric,
+population_life_stage text, --
+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),
+cpue text,--
+biomass text,--
+op_main_survey_target character varying(20),
+annual_elver text,
+silver_eel_annual_catch text,
+commercial_catch_brown text,
+commercial_catch_silver text,
+cond text,
+temp text,
+report text,
+authors text,
+journal_ref text,
+point_of_contact text,
+p_of_contact_code text ,
+p_of_contact2 text,
+p_of_c_code2 text,
+opedisthwm numeric,
+gradient text --
+);
+
+
+copy wrbd.station_st  from 'C:/base/Operation_14_Eel_Db_MI_Rivers.csv' with csv delimiter as ';' header; 
 }}}