Page 1 of 1

Restricting search to exclude alien species

Posted: Mon May 11, 2020 12:18 pm
by WendyEnglish
I'm trying to generate a query to extract VC species with tetrad frequency and excluding aliens. I can get a list OF aliens, and a list of ALL species. Also how do I include other species qualifiers in the output, such as Red Data List status and National status. Apologies if this is obvious, but I'm an inexperienced user.

Re: Restricting search to exclude alien species

Posted: Tue May 12, 2020 10:41 am
by AndyAmphlett
Wendy,

Try this - https://database.bsbi.org/search.php#re ... 874cf2ef1e, or this - https://database.bsbi.org/search.php#re ... 83dcc50348, or this - https://database.bsbi.org/search.php#re ... a92da1d516. These different queries use options available under more options > attributes > status (external scheme). Hope that helps,

Andy.

Re: Restricting search to exclude alien species

Posted: Tue May 12, 2020 10:42 am
by AndyAmphlett
Wendy,

Try this - https://database.bsbi.org/search.php#re ... 874cf2ef1e, or this - https://database.bsbi.org/search.php#re ... 83dcc50348, or this - https://database.bsbi.org/search.php#re ... a92da1d516. These different queries use options available under more options > attributes > status (external scheme). Hope that helps,

Andy.

Re: Restricting search to exclude alien species

Posted: Tue May 12, 2020 6:35 pm
by WendyEnglish
Thanks Andy. Really helpful. Can I add any extra species fields such as Conservation Status or vernacular name (useful once they're downloaded onto a spreadshet.)

Re: Restricting search to exclude alien species

Posted: Tue May 12, 2020 9:39 pm
by AndyAmphlett
Wendy,

you can narrow the query down to just include, for example NR and NSc native taxa eg. - https://database.bsbi.org/search.php#re ... 2d48e0adc0. But it doesn't look like you can annotate the download when results are grouped (by taxa in this case). That might be something that Tom could add as a refinement at some time.

You can get the DDb to included columns with Conservation status when you download the individual records; option listed under Download > Tabular data. The DDb does have a download limit per query; think it is 150K records.

Andy.

Re: Restricting search to exclude alien species

Posted: Wed May 13, 2020 10:02 am
by WendyEnglish
Thanks for your help. Pity about the extra columns. I'll contrive to get several sets of results, and combine them manually - working towards a VC62 RPR for VC62.