Changes between Version 41 and Version 42 of WRBD

Timestamp:

Dec 3, 2010 3:56:31 PM (14 years ago)

Author:

cedric

Comment:

--

WRBD

@@ -260 +260 @@
  copy wrbd.station_st (st_id,st_waterbody,st_catchment,st_location, st_eastings,st_northing,st_x,st_y)  from 'D:/CelineJouanin/POSEProject/Ireland/DataIreland/8.Lakes_TWaters_Surveys_Stations.csv' with csv delimiter as ';' header; 
 copy wrbd.station_st (st_id,st_waterbody,st_catchment,st_location, st_eastings,st_northing,st_x,st_y) from 'C:/base/8.Lakes_TWaters_Surveys_Stations.csv' with csv delimiter as ';' header; 
+-- I forgot to include st_source to differentiate
+ update  wrbd.station_st set st_source='WFD_Rivers_Surveys' where st_waterbody='River';
+ update  wrbd.station_st set st_source='WFD_Rivers_Surveys' where st_waterbody='Lake';
+ update  wrbd.station_st set st_source='WFD_Rivers_Surveys' where st_waterbody='Non-Freshwater';
+  update  wrbd.station_st set st_waterbody='river' where st_waterbody='River';
 
 }}}