Changes between Version 1 and Version 2 of Station Hydro

Timestamp:

Mar 5, 2012 1:58:58 PM (13 years ago)

Author:

celine

Comment:

--

Station Hydro

@@ -28 +28 @@
 SELECT AddGeometryColumn('pate', 'station_hydro','the_geom', 3035,'POINT',2); 
 UPDATE pate.station_hydro SET the_geom=ST_Transform(PointFromText('POINT(' || x_lambertii || ' ' || y_lambertii || ')',27572),3035) ;
+
+-- Attribution des id_drains 
+alter table pate.station_hydro add column id_drain integer;
+UPDATE pate.station_hydro SET id_drain=sub.id_drain from (select r.id_drain, s.code_station from pate.station_hydro s inner join rht.rhtvs2 r 
+on st_dwithin(s.the_geom,r.the_geom,300)) as sub where station_hydro.code_station=sub.code_station;
+
+UPDATE pate.station_hydro SET id_drain='308381' where code_station='I5221010';
+UPDATE pate.station_hydro SET id_drain='105760' where code_station='P8462510';
+UPDATE pate.station_hydro SET id_drain='20375' where code_station='Y2142010';
+UPDATE pate.station_hydro SET id_drain='121008' where code_station='Q7002910';
+UPDATE pate.station_hydro SET id_drain='119550' where code_station='Q7412910';
+UPDATE pate.station_hydro SET id_drain='209735' where code_station='J8502310';
+UPDATE pate.station_hydro SET id_drain='122242' where code_station='Q6332510';
 }}}