Topic: Simple metric?
Hi Sophie - a few of us have been thinking about useful metrics for seeing how well the NBNA is progressing, instead of the oft-quoted (but unhelpful) "number of records". We're interested in map completeness, and are looking at this in various ways.
However, it occurs to us that a very simple metric, and one that could be easy to produce, could be the count of distinct combinations of 10km square and species. This simple figure could then be assessed over time to see how we're doing.
Would it be possible to run a quick query on the back-end database please, along the lines of
select count (distinct Taxon Concept ID, OSGR 10km) from TABLE;
(or whatever the equivalent is). Be interesting to jot this down, then revisit it in a year's time.
Thanks