Changes between Version 37 and Version 38 of WRBD

Timestamp:

Dec 3, 2010 11:14:00 AM (14 years ago)

Author:

cedric

Comment:

--

WRBD

@@ -246 +246 @@
 CREATE INDEX indexstation_st ON wrbd.station_st
   USING GIST ( the_geom GIST_GEOMETRY_OPS );
+
+/********************************************
+*  INTEGRATING WFD stations
+*********************************************/
+ alter table wrbd.station_st add column st_source character(25);
+ update  wrbd.station_st set st_source='MI electrofishing survey';
+ alter table wrbd.station_st add column st_waterbody character(25);
+ update  wrbd.station_st set st_waterbody='river';
+-- COPYING survey stations
+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.WFD_Rivers_Survey_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.WFD_Rivers_Survey_Stations.csv' with csv delimiter as ';' header; 
+ 
 }}}