this is ticket: #49

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);