Changes between Version 1 and Version 2 of WRBD

Timestamp:

Nov 24, 2010 3:46:42 PM (14 years ago)

Author:

cedric

Comment:

--

WRBD

@@ -1 +1 @@
 back to first page [..][[BR]]
 
--- Chargement des noeuds mer qui sont en espagne mais n'ont pas été calculés pour la France
-select wso_id from europe.wso where area='Spain'
-except (select  wso_id  from europe.wso where area='France') --2339
--- chargement des noeuds de la Façade Atlantque
-select wso_id from ccm21.seaoutlets where area_cd='A1'; --6361
--- intersection
-(select wso_id from europe.wso where area='Spain'
-except (select  wso_id  from europe.wso where area='France')) --2339
-intersect (select wso_id from ccm21.seaoutlets where area_cd='A1'); --348
--- Une table pour les vues dans Qgis
-create table ccm21.riversegments_spain as (
-        select * from ccm21.riversegments where wso_id in ((select wso_id from europe.wso where area='Spain'
-except (select  wso_id  from europe.wso where area='France')) --2339
-intersect (select wso_id from ccm21.seaoutlets where area_cd='A1'))); --348);
+ --WRB
+    insert into europe.wso(wso_id) 
+    select distinct on (wso_id)  wso_id from ccm21.riversegments r
+    join (SELECT the_geom 
+        FROM european_wise2008.rbd_f1v3 As f where gid=39) as sub
+    ON ST_Intersects(sub.the_geom,r.the_geom);
+    UPDATE europe.wso set area='Western' where area IS NULL 
 
--- insertion de nouveaux bassins
-insert into europe.wso(wso_id) 
-(select wso_id from europe.wso where area='Spain'
-except (select  wso_id  from europe.wso where area='France')) 
-intersect (select wso_id from ccm21.seaoutlets where area_cd='A1'); 
-UPDATE europe.wso set area='Spain_Atl' where area IS NULL;