BSBI Distribution Database > message board

How many new monads did we visit last year?

Any queries about using the BSBI database

How many new monads did we visit last year?

by PWiggins » Sat Jan 19, 2019 10:29 pm

My VCR asked me to try and find this.
Here is my attempt https://database.bsbi.org/search.php#ap ... 74574a0482
It didn't work and I tweaked and got an Internal database error, 1547933015
Help please!

Peter
PWiggins
 
Posts: 7
Joined: Tue Dec 27, 2016 7:59 pm
name: Peter Wiggins

Re: How many new monads did we visit last year?

by admin » Mon Jan 21, 2019 12:30 pm

Hi Peter,

The query you tried was very nearly correct, except that the joined search shouldn't have been grouped (that was triggering the 'internal error' - the system ought to have provided a more helpful error message - or prevent the grouping being applied in the first place).

With out the grouping clause the query looks like this:
https://database.bsbi.org/search.php#re ... 29fa607183

Screenshot 2019-01-21 11.23.49.png
Screenshot 2019-01-21 11.23.49.png (60.31 KiB) Viewed 214 times


That query was very slow to run, but eventually yielded a list of 129 monads.

(I'll email the list to you, as I'm having problems attaching it to this post).
Tom Humphrey
Database Officer, Botanical Society of Britain and Ireland (BSBI)
c/o Centre for Ecology and Hydrology,Maclean Building, Crowmarsh Gifford, Wallingford, Oxon, OX10 8BB, UK.
tom.humphrey@bsbi.org
User avatar
admin
 
Posts: 385
Joined: Tue Nov 20, 2012 4:16 pm
name: Tom Humphrey

Re: How many new monads did we visit last year?

by PWiggins » Tue Jan 22, 2019 1:17 am

Thanks very much.

Peter
PWiggins
 
Posts: 7
Joined: Tue Dec 27, 2016 7:59 pm
name: Peter Wiggins

Re: How many new monads did we visit last year?

by AndyAmphlett » Fri Jan 25, 2019 9:30 am

Peter,

if you don't need to calculate the number of 'recording days' per new monad, there is another, quicker, way to list all monads first recorded in 2018.

https://database.bsbi.org/search.php#re ... 81edf1a689

This lists all monads with records in your vc, the number of species & hybrids recorded, and the first and most recent year with records. Download the results to a spreadsheet. Sort in descending order on the 'earliest date' column. That puts all the monads first recorded in 2018 at the top (at the time of writing there are no 2019 records). This gives 134 monads first recorded in 2018. Or filter the list, just selecting 2018 in the 'earliest date' column. I am not sure why the number of 'new' monads (134) differs from Tom's query (129).

Andy.
AndyAmphlett
 
Posts: 331
Joined: Fri Nov 23, 2012 9:32 am
name: Andy Amphlett


Return to Help and support

cron