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

A species list for a vice-county subdivided by BSBI date class

If we follow the the instructions for creating a species list for a vice county, there is one additional step, which is adding a ‘subdivide’ clause via more options > grouping.

‘Subdivide’ adds additional columns to the output of the query, giving the number of records for each taxon in each date class period.

vice county search grouped by taxon name and sub-divided by date class: click to see the query in the DDb (login required)

This query can be modified to give a count of hectads for each species in each date class, by adding a more options > grouping > distinct clause to the query, and selecting hectad.

number of taxon found in distinct hetrad in a vice county grouped by date: click to see the query in the DDb (login required)

Because old historic records are often only available at hectad resolution (at best) running this query at the hectad precision level is sensible as it allows comparison over many decades.