Tech, Oracle, user experience, coffee, design standards, and shameless ranting

FISH Classification

Warning: mysql_get_server_info(): Access denied for user ''@'localhost' (using password: NO) in /home/blucel/public_html/wp-content/plugins/xml-google-maps/xmlgooglemaps_dbfunctions.php on line 10

Warning: mysql_get_server_info(): A link to the server could not be established in /home/blucel/public_html/wp-content/plugins/xml-google-maps/xmlgooglemaps_dbfunctions.php on line 10
FISH Classification

The FISH tool was developed for the Scotland and Northern Ireland Forum for Environmental Research to classify fish populations in Rivers throughout the UK.

The software was developed in Oracle with the new APEX 3.2 release. Custom HTML / CSS APEX templates were created including custom logon screens and admin sections. JQuery is used to provide a more seemless contemporary user experience.

Ecologists record counts of various fish species at locations throughout the country. These data sets are uploaded to the FISH server (Oracle Apex on 11g) and modelled using algorithms designed by the Centre for Ecology and Hydrology (CEH) in Dorset.

Datasets are presented as one of: csv, txt, tsv, xml, xls formats. The FISH software automatically recognises the file content and converts to a common XSD based XML instance for further processing.

Fish tool

Fish tool

The software estimates the expected fish catch at that river stretch and produces classifications based on statistical routines that determine the likelihood of fish being present in that stretch at that time of year.

Centralised login

Centralised login

The software produces outputs in XML, GML, KML, CSV and PDF formats. The reports generated by the software are used to ascertain water quality and ecological viability of predetermined locations across the UK and are fed back to the EU for integration with their european ecology mapping applications.


Data visualisation areas help the user get an instant feel for a location’s characteristics and overall eceological pressures.

Environment Graphs


You can follow any responses to this entry through the RSS 2.0 feed.

Switch to our mobile site