Changes between Initial Version and Version 1 of WRBD

Timestamp:

Nov 22, 2010 5:30:18 PM (14 years ago)

Author:

celine

Comment:

--

WRBD

@@ +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);
+
+-- 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;