This site and its content are under development. We would welcome your feedback

A list of species that have 5 or fewer hectads

This query returns a list of all species that have 5 or fewer hectads within a region.

species that have five or fewer hectads in Wales: click to see the query in the DDb (login required)

Apart from the usual clauses to exclude invalid records, the important elements are:

  • Grouping by species (because infra-specific taxa would complicate things)
  • Counting distinct hectads (rather than a count of records)
  • Setting a maximum frequency on the grouped total (hectads in this case)

These options are available on the more options > grouping submenu