BSBI Distribution Database > message board

Blank squares

Any queries about using the BSBI database

Blank squares

by vc66 » Mon Oct 12, 2015 11:54 pm

How can I get a list of monads with no records in a VC ?
vc66
 
Posts: 76
Joined: Tue Feb 11, 2014 9:17 pm
name: john durkin

Re: Blank squares

by admin » Wed Oct 14, 2015 1:59 pm

Hi John,

I've made some changes so that this can be done now. The problem, as you probably discovered is that the conventional search for records only returns matches and not empty squares.

To return a full grid-square list for a county instead use Area as the base search, then join with a query for records. Something like this should work:

empty_squares_query.png
empty_squares_query.png (46.55 KiB) Viewed 11906 times


http://bsbidb.org.uk/search.php#retriev ... 73d29db40a

The important parts are that the 'Area' primary query is grouped by monad and that, for efficiency, the county is specified again in the Records subquery. Narrower searches (e.g. constrained by taxon or date range) will usually be quicker than less focused searches. The 'frequency' clause (requiring 0 results) has been added so as to return squares with no records.

Mapping of results for this type of search doesn't yet work.
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: 438
Joined: Tue Nov 20, 2012 4:16 pm
name: Tom Humphrey

Re: Blank squares

by vc66 » Thu Oct 15, 2015 11:04 pm

Thanks Tom, but it doesn't work.
vc66
 
Posts: 76
Joined: Tue Feb 11, 2014 9:17 pm
name: john durkin

Re: Blank squares

by admin » Thu Oct 15, 2015 11:46 pm

You're right...

Having got the empty square query working I went on to fix some other problems with grouped area queries but inadvertently broke the previous queries.

Re-running the search should work now (yeilding 167 monads).
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: 438
Joined: Tue Nov 20, 2012 4:16 pm
name: Tom Humphrey

Re: Blank squares

by vc66 » Sat Oct 17, 2015 10:46 pm

Thanks Tom. That works, but will not download- "File not found"
vc66
 
Posts: 76
Joined: Tue Feb 11, 2014 9:17 pm
name: john durkin

Re: Blank squares

by admin » Thu Oct 22, 2015 1:10 am

Sorry for the problems - blank square queries were added in a rush. Downloads should work now.

If there are still problems the post 2000 vc68 null monad list can be downloaded here.
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: 438
Joined: Tue Nov 20, 2012 4:16 pm
name: Tom Humphrey

Re: Blank squares

by vc66 » Thu Oct 22, 2015 11:18 pm

Thanks, it still doesn't work.

john
vc66
 
Posts: 76
Joined: Tue Feb 11, 2014 9:17 pm
name: john durkin

Blank squares

by vc66 » Mon Oct 26, 2015 3:23 pm

Hi Tom, that still won't download or produce maps.

john
vc66
 
Posts: 76
Joined: Tue Feb 11, 2014 9:17 pm
name: john durkin

Re: Blank squares

by admin » Mon Oct 26, 2015 3:50 pm

Hi John,

I've found the problem with downloads (part of the changes that I'd made previously hadn't been fully moved to the live version - so things worked when I ran tests, but not as a regular user). Downloads should work for everyone now.

Mapping of this type of result set doesn't work yet. I've added it to the 'to do' list, but there are higher priorities to address first.

regards,

Tom
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: 438
Joined: Tue Nov 20, 2012 4:16 pm
name: Tom Humphrey

Re: Blank squares

by welshofficer » Thu Feb 11, 2016 10:09 am

Should this be working now? I just tried for VC52, but only got one blank square. Running a search for post-2000 records grouped by monads shows a lot more gaps on the map.
welshofficer
 
Posts: 44
Joined: Wed Oct 09, 2013 9:29 am
name: Polly Spencer-Vellacott

Next

Return to Help and support

cron