BSBI Distribution Database > message board

Area query subdivided by elevation

Please report any problems with the website. Suggestions for changes are also very welcome.

Area query subdivided by elevation

by AndyAmphlett » Tue Mar 26, 2019 9:06 am


running this type of query - ... 5db8b5f5db - group by grid square subdivided by elevation, only works when grouping by monad. If I change the grouping to tetrads or hectads it runs, but returns no results. I think I recall correctly that the DDb stores monad altitudes for use in this type of query? I assume it should combine these to calculate values for larger squares?


Posts: 384
Joined: Fri Nov 23, 2012 9:32 am
name: Andy Amphlett

Re: Area query subdivided by elevation

by admin » Tue Mar 26, 2019 10:20 am

Hi Andy,

Thanks for highlighting the omission. The query now also works for hectads and tetrads.
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.
User avatar
Posts: 425
Joined: Tue Nov 20, 2012 4:16 pm
name: Tom Humphrey

Return to Bugs and suggestions