1

Re: Total species in database

Hi

I am probably missing something simple, but can anyone tell me how I can find the total number of taxa there are records for in the database?

Thanks

Gordon

Gordon Barker
Biological Survey Data Manager
National Trust

2

Re: Total species in database

I don't think there's anything built it, but it should be fairly easy to write a query that pulls out each taxon for each determination, then counts the uniques.

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

3

Re: Total species in database

Sally has kindly pointed out to me that there is an example xml report in the Help files that gets close to the answer. (Under Reporting - Reporting overview, halfway down, XML reports link). As it uses Taxon List Key it gives duplicates if names were entered from different lists or with synonyms but I have tweaked it to remove these (around 1400 duplicates out of 15000). I can upload the queries if people think it would be useful.

Gordon

Gordon Barker
Biological Survey Data Manager
National Trust

4

Re: Total species in database

Yes please!

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

5

Re: Total species in database

Files added here - http://forums.nbn.org.uk/uploads.php

One is a simple copy of Sally's example in the help file, the second (v2) should group together preferred names across lists.

Gordon Barker
Biological Survey Data Manager
National Trust

6

Re: Total species in database

Thanks Gordon.

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital