CAAB species names listing - updates

[fjaine]

@xhoenner I have been contacted by a user whose study species has recently undergone taxonomic revision and has been assigned a new scientific name. The issue is that the database currently shows its 'old' name.

I was therefore wondering if (or how often) the CAAB species name listing is updated to reflect the latest taxonomic revisions? If not it looks like we might need to consider this in the future.

In the meantime, can we get an updated species listing put into the database please?

FYI two examples below of species in the database that need their names updated:

• Smooth stingray (Dasyatis brevicaudata) recently re-classified as Bathytoshia brevicaudata.
• Reef manta ray (Manta alfredi) and Oceanic manta ray (Manta birostris) recently re-classified as Mobula alfredi and Mobula birostris, respectively.

These are the only ones I have identified so far but I am sure there are more, hence the need for automatic/regular updating of the CAAB species names listing in the database.

[fjaine]

@xhoenner a quick heads up that following a recent taxonomic revision Manta alfredi is now called Mobula alfredi

[xhoenner]

While working on this issue, it would be also useful to improve the current species table so that additional information is available for each species (or at least all ~140 species that we are, or have been tracking), e.g. IUCN status, taxon name, habitat type, link to ALA species distribution area shapefile.

select distinct sp.*
from animal a
join species sp on a.species_id = sp.id
and class = 'au.org.emii.aatams.CaabSpecies'