CAAB - Codes for Australian Aquatic Biota

O&A Information and Data Centre  »  Applications  »  CAAB - Codes for Australian Aquatic Biota
Please login if you have access to particular applications.
Username: Password:

Codes for Australian Aquatic Biota CAAB database content as at 20-Sep-2018 14:38

This is new version of the existing CAAB application which is also deployed on the RV Investigator - Any issues, improvements etc. please contact dave.watts@csiro.au.

Features include - distribution map from CSIRO catch records, download your search list of taxa as csv, JSON output of any CAAB taxon record.


General search form - search is case in-sensitive

Search for:
Highlite matches
Extract as csv

Sort by

Restrict to: Scientific names (synonymns and authority)
  example: arripis or arripis trutta or ar.tr
Common names (standard/marketing)
Current names only
Species only

or Taxon code
(or synonyms)

example: 37 or 37 441 or 37 441004
Include any category or by default all. [] shows category code

Taxonomic tree - drilldown from kingdom to family and then list all taxa within that family.

CATAMI classification tree - see http://catami.org/ for details


Example taxa reports

O&A Information and Data Centre  »  CAAB - Codes for Australian Aquatic Biota


Debugging Information
Lucee (Velvet) Os 5.2.9.31 (CFML Version 2016,0,03,300357)
Template /data/caab/index.cfm (/srv/www/htdocs/data/caab/index.cfm)
Time Stamp 22/09/2018 5:59 PM
Time Zone Australia/Canberra
Locale English (australian)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 140.79.3.24
Host Name ogc-cdc.it.csiro.au
Architecture 64bit


Execution Time

Total Time Avg Time Count Template
164 ms 164 ms 1 /srv/www/htdocs/data/caab/caab.cfc$getLatestRecordDate
31.4 ms 31.4 ms 1 /srv/www/htdocs/data/caab/caab.cfc$getCategorys
3.27 ms 3.27 ms 1 /srv/www/htdocs/data/common/Application.cfm
0.347 ms 0.347 ms 1 /srv/www/htdocs/data/caab/inc_search_form.cfm
0.137 ms 0.137 ms 1 /srv/www/htdocs/data/common/environment.cfm
0.125 ms 0.125 ms 1 /srv/www/htdocs/data/common/custom_tags/idc_header.cfm
0.095 ms 0.095 ms 1 /srv/www/htdocs/data/caab/environment.cfm
0.045 ms 0.045 ms 1 /srv/www/htdocs/data/common/cfc/data.cfc
0.04 ms 0.04 ms 1 /srv/www/htdocs/data/common/cfc/marlin.cfc
0.037 ms 0.037 ms 1 /srv/www/htdocs/data/common/cfc/warehouse.cfc
0.036 ms 0.036 ms 1 /srv/www/htdocs/data/common/custom_tags/idc_footer.cfm
0.023 ms 0.023 ms 1 /srv/www/htdocs/data/caab/caab.cfc
0.054 ms 0.018 ms 3 /srv/www/htdocs/data/common/cfc/UTMprojection.cfm
0.043 ms 0.014 ms 3 /srv/www/htdocs/data/common/cfc/spatial.cfc
0.029 ms 0.014 ms 2 /srv/www/htdocs/data/common/cfc/sldFactory.cfc
0.029 ms 0.014 ms 2 /srv/www/htdocs/data/common/cfc/SLDGenerator.cfc
0.014 ms 0.014 ms 1 /srv/www/htdocs/data/warehouse/biodiversity/biodiversity.cfc
0.012 ms 0.012 ms 1 /srv/www/htdocs/data/common/cfc/plotting.cfc
0.009 ms 0.009 ms 1 /srv/www/htdocs/data/ship/ship.cfc
0.009 ms 0.009 ms 1 /srv/www/htdocs/data/common/cfc/underway.cfc
0.007 ms 0.007 ms 1 /srv/www/htdocs/data/common/cfc/elog.cfc
0.007 ms 0.007 ms 1 /srv/www/htdocs/data/common/custom_tags/inc_google_analytics.cfm
0.007 ms 0.007 ms 1 /srv/www/htdocs/data/common/cfc/database.cfc
0.007 ms 0.007 ms 1 /srv/www/htdocs/data/common/cfc/geoserver.cfc
0.005 ms 0.002 ms 2 /srv/www/htdocs/data/common/cfc/io.cfc
0.03 ms 0.001 ms 22 /opt/lucee/tomcat/webapps/ROOT/WEB-INF/lucee/context/Component.cfc
0 ms 0 ms 1 /srv/www/htdocs/data/caab/index.cfm
0 ms 0 ms 1 /srv/www/htdocs/data/caab/Application.cfm
0 ms 0 ms 1 /srv/www/htdocs/data/common/cfc/mapFactory.cfc
0 ms 0 ms 1 /srv/www/htdocs/data/waypoints/waypoints.cfc
0.512 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
109 ms  APPLICATION EXECUTION TIME
91.1 ms  QUERY EXECUTION TIME
201 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

test (Datasource=warehouse, Time=2.94 ms, Records=1) in /srv/www/htdocs/data/common/Application.cfm
the following colum(s) are never read within the request:SYSDATE
select sysdate from dual
rQuery (Datasource=caab, Time=56.8 ms, Records=1) in /srv/www/htdocs/data/caab/caab.cfc
select max(date_modified) as ld from taxon_details
rQuery (Datasource=caab, Time=31.3 ms, Records=49) in /srv/www/htdocs/data/caab/caab.cfc
the following colum(s) are never read within the request:MAINTAINER_NAME,CATEGORY_DESCRIPTION,MAINTAINER_EMAIL,CATEGORY_WWW_NOTES
select * from category  where category_name is not null order by category_name


Scope Variables

Application Variables:
applicationname=ABCD
ISRAILO=true
ldap_password=Epic99Failure
ldap_username=sa-cmardatacentre
MNF_OPS_DB=Struct (4)
WOV_VOYAGE=
CGI Variables:
auth_password=
auth_type=
auth_user=
cert_cookie=
cert_flags=
cert_issuer=
cert_keysize=
cert_secretkeysize=
cert_serialnumber=
cert_server_issuer=
cert_server_subject=
cert_subject=
cf_template_path=/srv/www/htdocs/data/caab/index.cfm
content_length=0
content_type=
context_path=
gateway_interface=
http_accept=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
http_accept_encoding=gzip
http_accept_language=
http_connection=Keep-Alive
http_cookie=
http_host=ogc-cdc.it.csiro.au
http_referer=
http_user_agent=CCBot/2.0 (https://commoncrawl.org/faq/)
https=on
https_keysize=
https_secretkeysize=
https_server_issuer=
https_server_subject=
local_addr=127.0.0.2
local_host=ogc-cdc
path_info=
path_translated=/srv/www/htdocs/data/caab/index.cfm
query_string=
remote_addr=140.79.3.24
remote_host=140.79.3.24
remote_user=
request_method=GET
request_url=https://ogc-cdc.it.csiro.au/data/caab/index.cfm
script_name=/data/caab/index.cfm
server_name=ogc-cdc.it.csiro.au
server_port=443
server_port_secure=1
server_protocol=HTTP/1.1
server_software=
web_server_api=
Cookie Variables:
cfid=3d602121-e4fb-4d8a-93d4-86f12941306b
cftoken=0
Form Variables:
category_code=
cn_name=
highlight=N
q=
sci_name=
tn_name=
Request Variables:
admin_caab=false
admin_dap=false
admin_dc=false
admin_equipment=false
admin_gsm=false
admin_mnf=false
admin_tracking=false
admin_wov=false
airchem_processing=false
airchem_user=false
banner=https://research.csiro.au/software/wp-content/uploads/sites/6/2014/12/cropped-AR1380-crop.jpg
caab_db=caab
cmar_db=cmar
datacentre_developers=dave.watts@csiro.au,pamela.brodie@csiro.au,francis.chui@csiro.au,peter.shanks@csiro.au
datasource=warehouse
dbtype=oracle
earth_bright_base_layer=ea-be:World_Bright-Earth-e-Atlas-basemap_No-Labels
equipment_root=/data/files/equipment/
extra_breadcrumbs=&nbsp;<b>&raquo;</b>&nbsp; <a href="/data/caab/">CAAB - Codes for Australian Aquatic Biota</a>
file_root=/srv/www/htdocs/data/caab/
fishmap_layer=caab:CAAB_FISHMAP
fishmap_spcode=SPCODE
global_message=
group_name=Scientific Data Systems
home=data/ops
include_login_form=false
is_ship=false
jquery_root=/data/common/jquery/
marlin_db=marlin
marlin_version=2
media_root=/data/common/web_media/
mest_db=mest
mnf_db=mnf
mnf_only=false
module_root=/data/common/cfc/
obis_db=obis
openlayers_root=/data/common/openlayers/
oracle=true
security_filter= and security_code = 1
server=http://www.cmar.csiro.au
ship_db=warehouse
ship_test=false
team_name=O&A Information and Data Centre
temp_root=/data/temp
title=CAAB - Codes for Australian Aquatic Biota
underway_db=underway
url=Struct (20)
warehouse_db=warehouse
warehouse_dev=warehouse_dev
web_root=/data/caab
worms_endpoint=http://www.marinespecies.org/aphia.php?p=soap&wsdl=1
worms_lsid=urn:lsid:marinespecies.org:taxname:
worms_url=http://www.marinespecies.org/aphia.php?p=taxdetails&id=
wov_db=warehouse
Server Variables:
coldfusion=Struct (9)
java=Struct (8)
lucee=Struct (8)
os=Struct (8)
separator=Struct (3)
servlet=Struct (1)
system=Struct (2)
Session Variables:
cfid=3d602121-e4fb-4d8a-93d4-86f12941306b
cftoken=0
lastvisit={ts '2018-09-22 17:59:13'}
sessionid=ABCD_3d602121-e4fb-4d8a-93d4-86f12941306b_0
timecreated={ts '2018-09-22 17:59:13'}
urltoken=CFID=3d602121-e4fb-4d8a-93d4-86f12941306b&CFTOKEN=0
Debug Rendering Time: 0 ms