Changes between Version 13 and Version 14 of INTEGRATING stations

Timestamp:

Dec 7, 2010 10:04:00 AM (14 years ago)

Author:

celine

Comment:

--

INTEGRATING stations

@@ -64 +64 @@
 *  INTEGRATING WRBD stations
 *********************************************/
-ALTER TABLE wrbd.station_st add column district character(10);
-ALTER TABLE wrbd.station_st add column GPS_description character(10);
+ALTER TABLE wrbd.station_st add column st_riverbasin_district character(10);
+ALTER TABLE wrbd.station_st add column st_GPS_description character(30);
 
-A FINIR (je le fais Cédric !!!)
-copy 
+copy wrbd.station_st(st_foliono,st_id,st_riverbasin_district,st_district,st_catchment,st_river,st_sitetributary,st_eastings,st_northing,st_x,st_y,st_location,st_gps_description) from 'D:/CelineJouanin/POSEProject/Ireland/DataIreland/Station_4.WRBD_NDP_dbase_Historical_Lakes_and_all_burr_silvers.csv' with csv delimiter as ';' header ; 
+--  lines
+
 }}}