Restricting search to exclude alien species

[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.

[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.

[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.

[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.)

[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.

[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.