Page 1 of 1

Rare Plant Register Queries

Posted: Sun Jun 07, 2020 8:51 am
by Geoffrey Hall
The queries in Andy Amphlett's checklist and candidate RPR document fail to run. I've tried them all manually with the same result. Why do they not run? Are they no longer supported?

Re: Rare Plant Register Queries

Posted: Sun Jun 07, 2020 12:58 pm
by AndyAmphlett
Are you using the links in the Word document available from Google Drive at - https://drive.google.com/drive/folders/ ... rPm9_lWY2Z ? This is linked to in the final post at - viewtopic.php?f=1&t=155&p=1016&hilit=rpr#p1016.

I've just checked them, and they work OK on my PC.

Note that the DDb can return a list of vc Scarce and vc Rare taxa. See post at viewtopic.php?f=1&t=460. This uses the same (fairly simplistic) criteria that may queries used, and you may find it much easier to use.

Andy.

Re: Rare Plant Register Queries

Posted: Sun Jun 07, 2020 1:20 pm
by admin
Hi Geoffrey,

Thanks, there was a bug that had broken some of the species-grouped queries. I fixed that this morning, so it's likely that Andy re-tested the queries after the problem had been fixed.

Since Andy wrote the instructions an additional 'taxon rank' column has been added to the search results output, that column along with the 'aggregate' column need to be removed before pasting the results into the spreadsheet template.

I've updated Andy's instructions to reflect this and have refreshed some links and screenshots to use species-grouping that excludes aggregates. The revised version of the word document can be downloaded from:

https://database.bsbi.org/static/Checkl ... _2020.docx

The more recent 'vc Scarce and vc Rare taxa' query may also be worth looking at, it's based on some of the ideas from Andy's worksheet.

Re: Rare Plant Register Queries

Posted: Sun Jun 07, 2020 1:38 pm
by Geoffrey Hall
Thanks very much. Most appreciated.