Water bodies at risk of failure in achieving the good status (RNABE in French) has been reported in 2005 by each EU member state. The report can be found here : http://cdr.eionet.europa.eu/
then click on the member state / European Union (EU), obligations / Water Framework Directive: Art. 5 reporting / Deliveries under WFD Art. 5

direct link seems to be: http://cdr.eionet.europa.eu/fr/eu/wfdart5/ ; just replace fr by the code of the country (ie for Ireland for example)

Only river waterbody (not very small waterbody) are available at the moment, which is less than the coverage of the CCM layer.

[[Color(,brown,CWBody)]] : masses d'eau Côtières
[[Color(,brown,LWBody)]] : masses d'eau Lacs
[[Color(,brown,RWBody)]] : masses d'eau grands cours d'eau
[[Color(,brown,TWBody)]] : masses d'eau de Transition


From the PROTAREA--_FRA_region :[[BR]]
[[Color(,#3849ce,Eu_cd)]]:[[BR]]
[[Color(,#3849ce,MS_CD)]]:[[BR]]
[[Color(,#3849ce,LAT - LON : latitude and longitude)]]:[[BR]]
[[Color(,#3849ce,NAME)]]:[[BR]]
[[Color(,#3849ce,AREA)]]: surface[[BR]]
[[Color(,#3849ce,LENGTH)]]:longueur[[BR]]
[[Color(,#3849ce,BATHING - BIRDS - DRINKING - FISH - SHELLFISH - HABITATS - NITRATES - UWWT - ABSTRACTIO)]]:Y (yes), N (no), I assume but no values[[BR]]
[[Color(,#3849ce,DIST_CD)]]:[[BR]]
[[Color(,#3849ce,OGR_FID)]]:[[BR]]
[[Color(,#3849ce,NAME_2)]]:[[BR]]
[[Color(,#3849ce,MS_CD_2)]]:[[BR]]
[[Color(,#3849ce,EU_CD_2)]]:[[BR]]
[[Color(,#3849ce,AUTH_CD)]]:[[BR]]


 * Site de l'Ifen sur le RNABE
http://www.ifen.fr/donnees-essentielles/eau/mise-en-oeuvre-de-la-dce-et-politique-locale-de-l-eau/dce-etat-des-lieux-2004-et-risque-de-non-atteinte-du-bon-etat-en-2015.html