The River Macrophytes Database (RMD) is a Microsoft Access database constructed to house data on the plant communities of rivers in Great Britain and Northern Ireland. It includes data from over 7000 survey sites and is the most comprehensive database of its kind. Data have been collected from all over the UK between 1977 and the present day, following the methods of Holmes et al. (1999). The data held in the RMD are the result of collaborative work across all four statutory nature conservation bodies: Scottish Natural Heritage (SNH), Natural England (NE), Natural Resources Wales (NRW, formerly CCW) and the Northern Ireland Environment Agency (NIEA). The River Macrophytes Database can be downloaded from the JNCC website: https://hub.jncc.gov.uk/assets/0a26368d-400c-44e1-beaf-d4b89b7badcd#extent-detail

The JNCC River Macrophytes Database (RMD) is a Microsoft Access database constructed to house data on the plant communities of rivers in Great Britain and Northern Ireland. An extract in Excel format is also provided. The RMD includes data from over 7,000 survey sites and is the most comprehensive database of its kind. Data have been collected from all over the UK between 1977 and the present day, following the methods of Holmes et al. (1999).

The macrophyte survey method records aquatic and marginal plants in a 500 m-long survey section of river. Species from the river channel and the margins/base of the bank are recorded separately on a three-point scale of relative abundance and percentage cover. A standard check-list of species is used to aid recording. The field data can be used to classify the plant community as described by Holmes et al. (1999), and the database has a facility that allows keying-out of the community to sub-type level. This plant community classification has been used as the basis of river SSSI selection (see chapter 6 of Guidelines for Selection of Biological SSSIs). The database also holds a small amount of invertebrate and fish data.

The RMD is an ‘active’ database (i.e. survey records can still be added). However, with a new standard method of river plant survey now being adopted by the UK conservation agencies (i.e. the LEAFPACS method), it is likely that less surveys will be added in future, and it may develop into more of a 'legacy' database.

In 2011 the RMD was made available through the JNCC website with some restrictions on re-use. In June 2018, JNCC re-published the RMD as open data under the Open Government Licence.

Background information on the classification system:

Holmes, N.T, Boon, P.J., & Rowell, T.A. Vegetation communities of British rivers - a revised classification (1999) http://jncc.defra.gov.uk/page-2619