The Royal Botanical Gardens at Kew engaged us to convert an existing MS Access desktop database into a multilingual CMS based web site. The site is a responsive mobile and tablet friendly CMS based web site that enables the management of a database of tree data for conservation purposes. The data relate to trees native to the Atlantic Forests of Brazil that could be used for reforestation - The South Eastern Bahia Atlantic forest database.

Sometimes you come across a problem in SQL that is far more complex than you first imagine. One classic of these is 'Relational Division' - a poorly understood aspect of SQL that can help answer what must be a common question:

Return the things that have all of the items in a given list

Example questions:

Update: we have now combined this site with our main site! And all the articles are available in the one site.

We wanted to create a home for our knowledgebase and created the website technology.blue-bag.com. Here we provide a range of articles and posts covering issues from using CMS systems such as Drupal through to security articles covering securing access to your website.

Over ten years ago when we started creating web sites and applications to manage biodiversity related information we needed a public website to act as a host for these projects. UKWildlife.com was created to provide web space for not for profit Biodiversity and conservation projects and provide resources for biodiversity projects.

To design, create & host a web site to highlight the work undertaken for the LIFE project for the management and conservation of wet woodlands in Scotland. The resulting web site was also to present a gallery of photographs depicting wet woodlands and their management.

The resulting web site used a mixture of static and dynamic ASP based HTML. The various cases studies of woodland sites and their management and conservation status are linked to the gallery of photographs available. We provide the domain registration and hosting for this site.

To create an online representation of the NBN Species Dictionary. The required version was to be a simple reflection of the structure of the data model to highlight the concepts and the content of the standards promoted by the Species Dictionary.

To enable the secure distribution of the 1:50,000 Ordnance Survey map series for use with the Recorder 2000 application. The maps were to be encrypted and supplied on CD. Users of the CD set should be able to apply for unlock keys for maps, to which they access, by email, fax or post. Once unlocked, the maps should be automatically installed for use with the Recorder 2000 software.