Articles about Database

A web site to support the Reforestation of the Atlantic Forest

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.

Relational Division

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:

Technology Articles

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

Species Protection Legislation

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. was created to provide web space for not for profit Biodiversity and conservation projects and provide resources for biodiversity projects.

Wet Woods Restoration Project Website

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.

The Species Dictionary at the Natural History Museum

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.

Encryption of 1:50,000 Ordnance Survey maps for Recorder

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.