Changes between Version 7 and Version 8 of Cookbook CCM21_Europe

Timestamp:

Nov 24, 2010 4:39:22 PM (14 years ago)

Author:

celine

Comment:

--

Cookbook CCM21_Europe

@@ -85 +85 @@
 }}}
 
+
 {{{
 ---Spain-Atl
@@ -93 +94 @@
 UPDATE europe.wso set area='Spain_Atl' where area IS NULL;
 
----Irl_Atl
-insert into europe.wso(wso_id) 
-(select wso_id from europe.wso where area='Ireland'
-intersect (select wso_id from ccm21.seaoutlets where area_cd='A1')); 
-UPDATE europe.wso set area='Irl_Atl' where area IS NULL;
+--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;
 }}}
-
 
 {{{