|
The technical forum of the NBN Trust for use by the Network. It includes discussions and announcements on the NBN Atlas, Recorder 6 and Indicia |
You are not logged in. Please login or register.
Forum → UK Species Inventory / Dictionary → Order = "Diptera larva"???
Hello again, Chris.
I have just done a report from R6 and noticed something I have never seen before in returns from the same saved report as I have used for some years.
For two taxa, the Taxon Order is given as "Diptera larva", while all the others are the expected "Diptera".
One is Tricyphona immaculata, the other Idioptera pulchella, and both are from list NBNSYS0100000006, the DIPTERA list.
Surely there an error in the hierarchy?
Regards,
Murdo
Looks like the new list has completely corrupted the lineage in the Organism table, which has had a knock on effect in a number of places and could possibly account for the problem you have encountered. Dealing with this properly requires an R6 upgrade, which there is no hope of until Feb/March next year, so I am looking for a temporary solution. On Monday, I will get JNCC to withdraw the Lepidoptera upgrade so no further uers are affected. Just one species has caused the problem, but is has affected the complete table. Finding a solution which can be implemented by those with access the Mangement Studio will not be that difficult, but doing something which can be generally implemented is going to be difficult.
OK, Mike. Thanks. I thought it was likely to be a new phenomenon related to the upgrade to ...3A.
I assume you have seen the posts on the other problem with ...3A - that a lot of Leps (those with sspp) have no longer any binomials, so there are two good reasons not to upgrade.
Murdo
If you run the following SQL then rebuild the Index tables this will fix the problem I know about. It does mean that taxon 'Stigmella betulicola form nanivora' isn't going to come out in the right place in a sort, but hopefully we can live with this. If this doesn't fix the problem you have reported then let me know and I will investigate further.
Update ORGANISM Set PARENT_KEY = 'NBNORG0000060131' WHERE
ORGANISM_KEY = 'NBNORG0000043339'
Also attached is the change in the form of a Dictionary Upgrade.
In the longer term the lineage field in the R6 Organism table needs to be increased in length.
I will try that when I feel a bit stronger, Mike! Is it OK to change the field manually? I would prefer that way.
M.
I doesn't matter how it is changed. The problem is that at the moment is creates an entry in the Lineage field which exceeds to 30 characters allowed. Moving it up one level in the structure solves the problem, but is of course not correct.
That has sorted the 'Diptera larva' problem, Mike, at least for the two species I have tested (Tricyphona immaculata and Idioptera pulchella as above).
M.
Many thanks. I was about to run some tests, but you have saved me the time.
Mike, just to clarify - should everyone who installed the latest dictionary run this SQL?
Yes. I am sorting out with JNCC what to do about an update and there will be an announcement when this is in place. Best bet is probably to copy 0000003B.sql into the Dictionary scripts folder and run a dictionary upgrade followed by an index rebuild.
Forum → UK Species Inventory / Dictionary → Order = "Diptera larva"???
Powered by PunBB 1.4.6, supported by Informer Technologies, Inc.