Changes between Version 17 and Version 18 of Cookbook CCM21_France

Timestamp:

Jul 1, 2010 11:38:32 AM (15 years ago)

Author:

celine

Comment:

--

Cookbook CCM21_France

@@ -12 +12 @@
 join (SELECT ST_Union(f.the_geom) as singlegeom
     FROM france.departement As f) as sub
-ON ST_Contains(sub.singlegeom,r.the_geom); 
+ON ST_Intersects(sub.singlegeom,r.the_geom); 
 */
  -- we try to get the vector of seaoutlets that are within the geographical area
@@ -32 +32 @@
 join (SELECT ST_Union(f.the_geom) as singlegeom
     FROM france.departement As f) as sub
-ON ST_Contains(sub.singlegeom,r.the_geom); --170703 lines
+ON ST_Intersects(sub.singlegeom,r.the_geom); --170828 lignes   (avec st_contains 170703 lines)
 
 UPDATE france.wso set area='France' where area IS NULL