Changes between Version 20 and Version 21 of INTEGRATING stations

Timestamp:

Jan 19, 2011 11:00:21 AM (14 years ago)

Author:

cedric

Comment:

--

INTEGRATING stations

@@ -85 +85 @@
 -- some other stations
 copy wrbd.station_st(st_id,st_lake, st_location, st_eastings,st_northing,st_x,st_y,st_source)from 'c:/base/lake_stations_5_bis.csv' with csv delimiter as ';';
+UPDATE wrbd.station_st   SET the_geom=ST_Transform(PointFromText('POINT(' || st_eastings || ' ' || st_northing || ')',29901),3035) where the_geom is null;
+
 }}}