{{{ SELECT count (*) from ccm21.riversegments r join (SELECT ST_Union(f.the_geom) as singlegeom FROM france.departement As f) as sub ON ST_DWithin(sub.singlegeom, r.the_geom, 300); }}}