Changes between Version 9 and Version 10 of Limites administratives Europe

Timestamp:

Jul 20, 2010 4:37:40 PM (15 years ago)

Author:

celine

Comment:

--

Limites administratives Europe

@@ -68 +68 @@
     join (SELECT ST_Union(f.the_geom) as singlegeom
         FROM europe.limiteeurope As f where gid='11'or gid='2'or gid='27' ) as sub
-    ON ST_Intersects(sub.singlegeom,r.the_geom); --170828 lignes   (avec st_contains 170703 lines)
+    ON ST_Intersects(sub.singlegeom,r.the_geom);
 
-    UPDATE europe.wso set area='France' where area IS NULL --693 sea nodes
+    UPDATE europe.wso set area='France' where area IS NULL --680 sea nodes
 
-select * from ccm21.riversegments where wso_id in (select wso_id from europe.wso where area='France')--170703 lines
+select * from ccm21.riversegments where wso_id in (select wso_id from europe.wso where area='France')--170734 lines (with france.departement 170703 lines)
 
 CREATE INDEX europe_wso_id