Changes between Version 11 and Version 12 of Cookbook CCM21_Europe

Timestamp:

Feb 18, 2011 3:03:06 PM (14 years ago)

Author:

celine

Comment:

--

Cookbook CCM21_Europe

@@ -99 +99 @@
 UPDATE europe.wso set area='Spain_Atl' where area IS NULL;
 
---WRB
+--WRB Western River Basin
     insert into europe.wso(wso_id) 
     select distinct on (wso_id)  wso_id from ccm21.riversegments r
@@ -106 +106 @@
     ON ST_Intersects(sub.the_geom,r.the_geom);
     UPDATE europe.wso set area='Western' where area IS NULL;
+
+--Anglian
+    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=200) as sub
+    ON ST_Intersects(sub.the_geom,r.the_geom);
+    UPDATE europe.wso set area='Anglian' where area IS NULL;
+
+--Sardinia
+    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=85) as sub
+    ON ST_Intersects(sub.the_geom,r.the_geom);
+    UPDATE europe.wso set area='Sardinia' where area IS NULL;
+
+--Swedish ?
+    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=85) as sub
+    ON ST_Intersects(sub.the_geom,r.the_geom);
+    UPDATE europe.wso set area='Swedish' where area IS NULL;
+
+--Elbe ?
+    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=208) as sub
+    ON ST_Intersects(sub.the_geom,r.the_geom);
+    UPDATE europe.wso set area='Elbe' where area IS NULL;
 }}}