Changes between Version 9 and Version 10 of europe.wso1

Timestamp:

Jun 20, 2011 1:35:20 PM (14 years ago)

Author:

celine

Comment:

--

europe.wso1

@@ -68 +68 @@
 {{{
 ---- Cas Espagne à voir !!! beaucoup trop de segments retenus dans Spain_Atl
----Spain-Atl
-insert into europe.wso1(wso_id, wso1_id) 
-(select wso_id, wso1_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.wso1 set area='Spain_Atl' where area IS NULL;  --348 lines
-
-insert into europe.wso1(wso_id,wso1_id)
-(select wso_id, wso1_id from europe.wso where area='Spain'
-except (select  wso_id  from europe.wso where area='France')) 
-intersect (select wso_id from european_wise2008.rbd_f1v3 where name_eng='Basque County internal basins'); 
+---Basque
+ insert into europe.wso1(wso_id, wso1_id) 
+    select distinct on (wso_id, wso1_id)  wso_id, wso1_id from ccm21.riversegments r1 where wso_id in (select  r.wso_id from ccm21.riversegments r
+    join (SELECT the_geom 
+        FROM european_wise2008.rbd_f1v3 As f where gid=41) as sub
+    ON ST_Intersects(sub.the_geom,r.the_geom)) or wso_id in ('291467','297569','297544','420706','319592','297608','319864','319930','319559');
+    UPDATE europe.wso1 set area='Basque' where area IS NULL; --2680 lines
+drop view if exists europe.spain;
+       
+CREATE VIEW europe.spain as select r1.* from ccm21.riversegments r1 where wso_id in (select  r.wso_id from ccm21.riversegments r
+    join (SELECT the_geom 
+        FROM european_wise2008.rbd_f1v3 As f where gid=41) as sub
+    ON ST_Intersects(sub.the_geom,r.the_geom)) or wso_id in ('291467','297569','297544','420706','319592','297608','319864','319930','319559');
 }}}