Changes between Version 42 and Version 43 of WRBD

Timestamp:

Dec 3, 2010 4:28:08 PM (14 years ago)

Author:

cedric

Comment:

--

WRBD

@@ -262 +262 @@
 -- 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_source='WFD_Lake_Surveys' where st_waterbody='Lake';
+ update  wrbd.station_st set st_source='WFD_Lake_Surveys' where st_waterbody='Non-Freshwater';
   update  wrbd.station_st set st_waterbody='river' where st_waterbody='River';
+
+  UPDATE wrbd.station_st SET the_geom=ST_Transform(PointFromText('POINT(' || st_eastings || ' ' || st_northing || ')',29903),3035) where wrbd.station_st.st_source='WFD_Rivers_Surveys';
+   UPDATE wrbd.station_st SET the_geom=ST_Transform(PointFromText('POINT(' || st_eastings || ' ' || st_northing || ')',29903),3035) where wrbd.station_st.st_source='WFD_Lake_Surveys';
 
 }}}