BSBI Distribution Database > message board

Restricting search to exclude alien species

Any queries about using the BSBI database

Restricting search to exclude alien species

by WendyEnglish » Mon May 11, 2020 12:18 pm

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.
WendyEnglish
 
Posts: 3
Joined: Sat May 09, 2020 3:58 pm
name: Wendy English

Re: Restricting search to exclude alien species

by AndyAmphlett » Tue May 12, 2020 10:41 am

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.
AndyAmphlett
 
Posts: 404
Joined: Fri Nov 23, 2012 9:32 am
name: Andy Amphlett

Re: Restricting search to exclude alien species

by AndyAmphlett » Tue May 12, 2020 10:42 am

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.
AndyAmphlett
 
Posts: 404
Joined: Fri Nov 23, 2012 9:32 am
name: Andy Amphlett

Re: Restricting search to exclude alien species

by WendyEnglish » Tue May 12, 2020 6:35 pm

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.)
WendyEnglish
 
Posts: 3
Joined: Sat May 09, 2020 3:58 pm
name: Wendy English

Re: Restricting search to exclude alien species

by AndyAmphlett » Tue May 12, 2020 9:39 pm

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.
AndyAmphlett
 
Posts: 404
Joined: Fri Nov 23, 2012 9:32 am
name: Andy Amphlett

Re: Restricting search to exclude alien species

by WendyEnglish » Wed May 13, 2020 10:02 am

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.
WendyEnglish
 
Posts: 3
Joined: Sat May 09, 2020 3:58 pm
name: Wendy English


Return to Help and support

cron