Changes between Version 10 and Version 11 of Limites administratives Europe

Timestamp:

Jul 20, 2010 4:49:39 PM (15 years ago)

Author:

celine

Comment:

--

Limites administratives Europe

@@ -64 +64 @@
      )
 
+----France
     insert into europe.wso(wso_id) 
     select distinct on (wso_id)  wso_id from ccm21.riversegments r
@@ -74 +75 @@
 select * from ccm21.riversegments where wso_id in (select wso_id from europe.wso where area='France')--170734 lines (with france.departement 170703 lines)
 
+----Germany
+    insert into europe.wso(wso_id) 
+    select distinct on (wso_id)  wso_id from ccm21.riversegments r
+    join (SELECT ST_Union(f.the_geom) as singlegeom
+        FROM europe.limiteeurope As f where gid='12') as sub
+    ON ST_Intersects(sub.singlegeom,r.the_geom);
+
+    UPDATE europe.wso set area='Germany' where area IS NULL
+
+----Spain (+Gibraltar)
+    insert into europe.wso(wso_id) 
+    select distinct on (wso_id)  wso_id from ccm21.riversegments r
+    join (SELECT ST_Union(f.the_geom) as singlegeom
+        FROM europe.limiteeurope As f where gid='37' or gid='13') as sub
+    ON ST_Intersects(sub.singlegeom,r.the_geom);
+
+    UPDATE europe.wso set area='Spain' where area IS NULL
+
+----Italy (+
+
 CREATE INDEX europe_wso_id
   ON france.wso