1

Topic: Taxon Local Status Issue

While checking some data where species lists had got shorter for newer data I came across this;

When I compile a list of species in Management Studio and give it designations from the All_designations column [UDF] for County Notable the status is applied and all appears fine. If I look up the Taxon in R6 it says it has no Staus or rather none is shown.

I rebuilt the Taxon Designation Index to be sure and still no change. All the species that have this problem are Lichens so far.

So if it is only Lichens what is different about them and what is it if others are also included. I have check a few other species from other taxon groups but they seem unaffected. So Lichens?

Data Manger
Somerset Environmental Records Centre

2

Re: Taxon Local Status Issue

My guess is that this depends on which list the County Notable status has been attached to Tony. That's what usually happens. You will probably find that when you try it the second way, either you are looking at the taxa in a non-preferred list and the status belongs to the preferred one, or you are looking at the preferred list but have applied the status to a non-preferred one.

The first method finds the status whichever list the status belongs to, because it incorporates the synonymy.

Its a bit of a nuisance I know, but until the latest upgrade there was no single Organism table (equivalent to the old taxon dictionary in R3), so the statuses are all attached to particular lists. Now that we have the Organism table it would make more sense if taxon designations were connected to this, rather than via  a list, but I suspect that would involve reworking a lot of other stuff and might be more complicated than it is worth.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

3

Re: Taxon Local Status Issue

Hmm, thanks. It might be worth doing as I have found that due to name changes some species that are common have been made notable. As there is no easy way to edit a designation it may be just as easy to delete the designation and do it again.

I'm having toruble remebering how I did it and where to go to edit it. I'll get there I guess.

Data Manger
Somerset Environmental Records Centre

4

Re: Taxon Local Status Issue

Taxon Designations can be added and edited under Dictionary/Edit Taxon Details. You need to know the dictionary list used to add any user defined designations. Designation should be under statuses for the taxa.  Just a reminder not to use any of the system supplied designation lists to add local designations. Any of the other list should ok, but the preferred lists probably the most suitable.

Mike Weideli

5

Re: Taxon Local Status Issue

Thanks Mike, the species in question is Geranium robertianum subsp. maritimum which I made anotable through a rucksack. It was converted to the current syn. Geranium robertianum and so this common species became notable.

In the Dictionary/Edit none of the Geranium robertianum subsp. maritimum or Geranium robertianum are notable. So I cannot edit it there. I can only assume it is another perculiarity of R6 and will have to find the entry in the underlying table and remove it by hand.

Data Manger
Somerset Environmental Records Centre

6

Re: Taxon Local Status Issue

The SQL which poulates Index_taxon_designation finds any synonyms and children of anything which is in the Taxon_designation_table and applies the designation to all of these. There has to be a Taxon_List_Item key in the Taxon_designation table which feeds this process, so Taxon_designastion is the place to look.  You should be able to find all the users defiined entries in the Taxon_Designation_table which have the designation type you are interested in.  The entry must be  there somewhere,  but it may not be that obvious.    The SQL finds the Synonyms and children by looking at all the list, which can cause problems, because some of the lists are badly constructed. Now we have the ognanism table we will be able to use this to find the children, which should improve things.

Mike Weideli

7

Re: Taxon Local Status Issue

Thanks, it was not obvious or easy but with access to R6 tables through Excel 2010 and SSMS I tracked down the correct KEY after a couple of hours. I do have the task now of trying to work out what other species are not what they were intended and that I'm not sure about. At least it's not urgent.

The organism thing passed me by and sounds like what we were actually suposed to get in R6 to begin with.

Data Manger
Somerset Environmental Records Centre

8

Re: Taxon Local Status Issue

The organism table was certaintly asked for at one of the first R6 users meetings. What we got was NAMESERVER, which while solvings some problems left a number of holes.  Version 6.18 and Dictionary Upgrades to 0000001N (which need 6.18) installsand populate the Organism table, and make use of some of the features (eg getting the Kingdon/Phlum/Class/Order/Family for a species and a sort order which which is independent of the taxon lists).  The table can also be used for expanding the taxonomic hierarchy avoiding the use of some of the lists which are poorly constructed. It should be possible to apply this to the expansiion of the hierarchy in reporting and also in the generation of Index_Taxon_Designation.  Hopefully, we will complete the implementation of these features in May.

Mike Weideli