Changes between Version 2 and Version 3 of Cookbook CCM21_France


Ignore:
Timestamp:
May 4, 2010 4:15:24 PM (15 years ago)
Author:
cedric
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Cookbook CCM21_France

    v2 v3  
    11this is ticket: #49 
    22{{{ 
     3/*boolean ST_Contains(geometry geomA, geometry geomB); 
     4Description 
     5Geometry A contains Geometry B  
     6*/ 
     7 
     8 
    39SELECT count (*) from ccm21.riversegments r 
    410join (SELECT ST_Union(f.the_geom) as singlegeom 
    511    FROM france.departement As f) as sub 
    6 ON ST_DWithin(sub.singlegeom, r.the_geom, 300);  
     12ON ST_Contains(sub.singlegeom,r.the_geom);  
    713}}}